 |
|
|
SQL Fundamentals
This 3 day course is an introduction to the SQL database query language. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities. The basis of the SQL language can be applied to all modern relational databases and as such, this course is relevent to those wishing to work with SQL Server, Oracle, MySQL, Informix and most other database management systems. The small differences and subtleties of specific environments will be discussed and explored.
The course begins with a general introduction to databases, including the principles of relational databases. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition Language is covered, including creating, altering and dropping tables, and the use of integrity constraints.
Those attending this course require general familiarity with computers and data processing.
Course Objectives:
For each delegate to gain an in-depth understanding of SQL - concepts, syntax, uses and to use hands-on SQL to access databases.
 Course Summary:
- Relational Database Basics
- Simple SELECTs
- Advanced SELECTs
- Subqueries, Joins and Unions
- Conditional Processing with 'CASE'
- INSERT, UPDATE and DELETE
- Data types in more depth
- Creating Databases and Tables
- Creating Indices
- Applying constraints
|
|
|
|
