A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms.
Anyone working with databases.
What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.
Hands on Investigating a database.
Data retrieval, SQL DML, SQL DDL, SQL queries, SELECT, WHERE clause.
Hands on Querying a database.
Aggregate functions, Scalar functions, variations. GROUP BY. HAVING, ORDER BY. Combining conditions. IN and BETWEEN.
Hands on Selecting data from an existing database.
INSERT, UPDATE, MERGE, DELETE. Transaction controls: START TRANSACTION, COMMIT, ROLLBACK.
Hands on Modifying data in tables.
USE, CREATE, DROP, TRUNCATE, ALTER.
Hands on Defining new tables and elements.
Multiple tables, joins, keys, inner joins, left joins, right joins.
"I had no knowledge at the start of the course and the instructions were excellent."
This structured course uses Instructor Led Training to provide the best possible learning experience. Small class sizes ensure students benefit from our engaging and interactive style of teaching with delegates encouraged to ask questions throughout the course. Quizzes follow each major section allowing checking of learning. Hands on sessions are used throughout to allow delegates to consolidate their new skills.