SQL Advanced Course, 2 Days

SQL Advanced Course summary

At this SQL Advanced Course, we cover SQL advanced queries, sub queries, SQL DDL and SQL DML statements and SQL development techniques.
It also covers course automation of queries using T-SQL.
The SQL Intensive Course covers many SQL developer techniques over 2 days.
Delegates are already familiar with basics of SQL.

SQL Advanced Course Description

Database Concepts Revision:

What is a database, Tables, rows and columns, Indexes, primary keys, foreign keys,

SQL Sub-queries:

·Sub-queries in the WHERE, SELECT, From or Having clauses
·Using SOME, ALL, ANY and IN clauses in the Where Clause ·Self-contained sub-queries
·Correlated sub-queries
·Sub-queries with the EXISTS predicate

Derived Tables and CTEs:

·Using SQL derived tables
·SQL Common Table Expressions (CTEs)
·Recursive CTEs


Create, alter and drop Views, Indexes

SQL Stored Procedure Basics:

·Stored Procedure Principles
·Creating stored procedures
·Executing stored procedures
·System stored procedures


·Declaring variables
·SET versus SELECT
Parameters and Return Values
·Passing parameters
·Default values and WHERE clauses
·Output parameters
Testing Conditions
The IF/ELSE statement


·Syntax of SQL WHILE
·Breaking out of a loop
·Basic transactions
·Beginning a transaction
·Committing/rolling back
·Deleting and updating
·Dropping objects

User defined Functions:

Table Valued Functions
·In-line table-valued functions
·Multi- Statement table-valued functions
·Limitations of user-defined functions
Scalar Functions
·What are scalar functions?
·Some examples
·Disadvantages of scalar functions
·Three advantages


·Syntax of fetching rows
·When to use (and when not to)


Create or replace triggers

Creating Tables in SQL:

·Create, alter and drop Tables
·Inserting values, single rows and multiple rows using queries
Not Null, Unique,Default,Check,Primary Key,Foreign Key,Identity / Auto-increments


Sequencing, Indexes

SQL Temporary Tables and Table Variables:

·Create and use SQL temporary tables
·Create and use SQL table variables
·SQL Tables vs. Table Variables


·SQL System error functions
·Customizing SQL error messages
·@@ error function


·The SQL Server debugger, Debugging (breakpoints, etc.)

What is included in the SQL Advanced Course:
  • SQL Advanced Course Certificate on completion (assessment based)
  • SQL Advanced Course notes
  • Practical SQL Course exercises, SQL Course Homework / SQL Course Revision work
  • Tea, coffees, but no lunch
  • To assist after the course, 1 free session for questions online SQL Course via Skype or Teamviewer.
  • Max group size on this SQL Course is 4.
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops Manchester
MANCHESTER: 53 Fountain Street, Manchester, M2 2AN
Read More
PCWorkshops Birmingham
BIRMINGHAM: One Victoria Square, Birmingham, B1 1BD
Read More
PCWorkshops Southend-on-Sea
SOUTHEND-ON-SEA: The Forum, Elmer Square, Southend-on-Sea SS1 1NS
Read More
PCWorkshops Milton Keynes
MILTON KEYNES: Exchange House, 494 Midsummer Boulevard, Milton Keynes, MK9 2EA
Read More
PORTSMOUTH: Building 1000, Lakeside North Harbour, Western Road, Portsmouth, PO6 3EZ
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More
PCWorkshops London
LONDON: 8 Duncannon Street, London WC2N 4JF
Read More

Subscribe our Newsletter

Sign up to receive lessons, tips, examples, quizzes and other training materials.