Intermediate SQL Course
Get dates and book
Book Milton Keynes
Book Manchester, 2-Days
SQL Course summary
In this SQL Course you will learn how to get valuable information, trends, summaries, statistics and insights from your company data using SQL.
This course is ideal for managers and data analysts who need to get business intelligence from data.
SQL Course Desciption
Session 1: Database Concepts
What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,
SQL Getting started and Logging in, Selecting a database, Executing SQL statements
Session 2: Basic SQL SELECT statement
The SQL SELECT statement, WHERE clause, Boolean operators (AND and OR) and SQL conditional operators (=,!=,>,<,IN, and BETWEEN).The ORDER BY clause, Column aliases, LIMIT / TOP, Distinct
Session 3: Arithmetic expressions, Null functions (“IS NULL,” “IS NOT NULL,” , "Isnull",“Coalesce”).
Session 4: SQL AGGERGATE Functions (Sum, Average, Maximum, Minimum, Count), 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, Except, Intersect.
Session 6: SQL Subqueries, Nested Subqueries, “WITH AS”, 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).
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, Exporting from the command line, Importing from the command line.
What is included in this SQL Course:
SQL Course Certificate on completion (assessment based)
SQL Course notes
Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
Bring your own laptop, or make arrangements beforehand to use ours
Tea, coffees, but no lunch
After the course, 1 free, online session forquestions or revision on the SQL Course.
Max group size on this SQL Course is 4.