J. S., Framestore CFC
B. M., London Internet Exchange
Intro to SQL training course contents
What is SQL?
What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends.
Hands on: Investigating a database.
Basic SQL commands
Data retrieval, SQL DML, SQL DDL, SQL queries, SELECT, WHERE clause.
Hands on: Querying a database.
SQL data retrieval
Aggregate functions, Scalar functions, variations. GROUP BY. HAVING, ORDER BY. Combining conditions. IN and BETWEEN.
Hands on: Selecting data from an existing database.
SQL basic data manipulation
INSERT, UPDATE, MERGE, DELETE. Transaction controls: START TRANSACTION, COMMIT, ROLLBACK.
Hands on: Modifying data in tables.
SQL Data Definition
USE, CREATE, DROP, TRUNCATE, ALTER.
Hands on: Defining new tables and elements.
Multiple tables, joins, keys, inner joins, left joins, right joins.
Why Choose Us
SNT trainers score an average of over 90% on the three main areas of:
- Ability to teach
- Technical knowledge
- Answering questions
We limit our maximum class size to 8 delegates; often we have less than this. This ensures optimal interactivity between delegates and instructor.
"Excellent course. The small class size was a great benefit…" M.B. IBM
We write our own courses; courseware does not just consist of slides and our slides are diagrams not bullet point text. A typical chapter provides clearly defined objectives with a chapter overview, slides with text underneath, a quiz at the end to check the learning of the students. Hands on exercises are at the end and are used to reinforce the theory.