SQL Advanced Course
From £750 - FAQ's - Included - Course outline - Bespoke SQL Course

MS SQL Server Advanced Course

Course summary

Sub-queries, Views, CTE-Tables, Stored Procedures, Scalar Functions, Table Functions, Variables, Using Variables, Triggers, Looping, Temp Tables, Creating tables, Squencing Indecex

Course Outline

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

Views: 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 ·Using RETURN
Testing Conditions
·The IF/ELSE statement ·CASE ·CHOOSE

·Syntax of SQL WHILE ·Breaking out of a loop ·Basic transactions ·Beginning a transaction ·Committing/rolling back ·Deleting and updating ·Using DELETE and UPDATE ·Sys.Objects ·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
Primary Key
Foreign Key
Identity / Auto-increments


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 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.

Is this course for you? Book today and start preparing

PCWorkshops specialises in Coding Courses, Database Courses and MS Project Courses.

Free Examples and Tips

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