Booking options
£1,497
£1,497
Delivered Online or In-Person
You travel to organiser or they travel to you
Redhill
Two days
All levels
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.
None.
2 days
What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.
RDBMS, Tables.
Hands on Investigating a database.
SQL Overview: SQL DML, SQL DDL, SQL
queries. SELECT, WHERE and ORDER BY
clauses. Combining conditions. IN, LIKE and
BETWEEN.
Hands on Querying a database from existing
tables.
Scalar functions.
Hands on Selecting data from an existing database.
Scalar functions, variations. Aggregate functions,
GROUP BY. HAVING.
Hands on Selecting data from an existing database.
Multiple tables, joins, keys, inner joins, left joins,
right joins.
Hands on Selecting data from an existing database.
INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK.
Hands on Modifying data in tables.
USE, CREATE, DROP, TRUNCATE, ALTER.
Hands on Managing new tables and columns.
GRANT, REVOKE.
Hands on Defining permissions.