Back to Search Results

Training Course Summary:

Profile

This course is for programmers and others who are expected to use SQL with a relational database.

Completion of this course will give delegates a sound understanding of SQL as it is implemented by the commercial databases.

Delegates will be able to interpret SQL statements and develop their own SQL processing functions. They will be able to devise sophisticated queries and manipulate the data in relational databases.

Delegates will also gain useful insights into the mechanics of relational databases.


Prerequisites


Delegates will benefit from an understanding of programming principles.
We recommend that attendees have some experience with Unix or Windows NT before commencing this event.


Skills


Introduction: Defining Structured Query Language. Introduction to relational databases. Tables, Rows and Columns. Interactive SQL environments. General SQL guidelines.
Developing queries: The SELECT statement. The WHERE clause. Specifying conditions Relational and logical operators. Pattern matching with LIKE. Other operators. The ORDER BY clause. The GROUP BY and HAVING clauses. Computed values.
Data manipulation: Inserting new data. Modifying existing rows. Deleting data that is no longer required.
Database Definition: Table creation. Specifying data types for columns. Examples of data types.Changing, removing tables. Creating indexes. Indexing strategies.
Controlling access to the database: Privileges and Permissions. Privilege management. The GRANT and REVOKE statements.
Advanced SQL features: Aggregate functions, Nested queries. Outer Joins, Views.