SQL Intermediate Course, 3 Days

Online: Instructor-led.

Classroom: Request per email.

SQL Coding Examples

SQL Course Manuals and Notes: In-depth reference materials

Exercises: Practical exercises

SQL Course Certificate on completion.

SQL Course Manual.

Practical SQL Course exercises, SQL Code Samples/ SQL Course Revision work.

After the course, 1 free session for questions.

Max group size, online and in classroom, on this SQL Course is 4.

DAY 1:

Session 1: Database Concepts
What is a database?
Tables, rows and columns, Indexes, primary keys, unique constraints and foreign keys, Client-Server architecture, Supported data types, table types,. The Information_Schema

Session 2: Using the SQL client SQL Getting started and Logging in, Selecting a database, Client commands, Entering and executing SQL statements, Retrieving previous commands, Creating, editing and executing SQL files, Redirecting output into a file, Command line execution of SQL Scripts

Session 3: Basic SQL SELECT statement
The SQL SELECT statement, Case sensitivity, Quotes, Statement terminator, Syntax conventions.
Conditions and the WHERE clause, Boolean operators (AND and OR) and SQL conditional operators.
Column aliases.
Arithmetic expressions.
Null functions ('IS NULL,' 'IS NOT NULL,' , "Isnull",'Coalesce').
The ORDER BY clause.

Session 4:
LIMIT / TOP and Distinct Queries
SQL AGGREGATE Functions (Sum, Average, Maximum, Minimum, Count),
Group By,
Rollup with Group By,
Having.

Session 5: Joins
SQL Cartesian products.
SQL Joins (Inner join, Left join, Right join, Full join).
Table aliases.
Natural joins, Multi-table joins.
Union, Union All queries.
Except/Minus, Simulating join with Intersect.

DAY 2:

Session 6:
SQL Subqueries, Nested Subqueries,
Correlated and uncorrelated subqueries.
Global and Local Temp Tables.

Session 7: SQL Built-in Functions:
Numeric Functions (ABS, SIGN, MOD, etc.)
and String Functions (Locate, Left, Right, Concat, etc),
DATE and TIME functions.

Session 8: SQL Views (Create, alter and drop),
Stored Procedures (Create, alter and drop, Input and Output parameters);
Custom Functions (Create, alter and drop).

DAY 3:

Session 9: Managing Data
Inserting rows, Replacing rows, Updating rows, Deleting rows,

The truncate statement,
The COMMIT and ROLLBACK commands, Savepoints, Implicit commits.

Session 10: SQL Indexes (Create, alter and drop).

Session 11:
Creating Databases and Tables (Create, alter and drop);
Constraints (Add, alter and drop).

Session 12:
Import data into SQL and Export from SQL.
Exporting using SQL, Importing using SQL.

Our SQL Intermediate trainers are experienced award winners.

13 years in business

We keep it practical and customised