25,000+ Courses Nationwide
0345 4506120

SQL Server Advanced

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

Select specific date to see price, venue and full details.

Pre-Requisites

Delegates are already familiar with basics of SQL.

Course Content

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

Views:

Create, alter and drop Views, Indexes

SQL Stored Procedure Basics:

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

Variables:

·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

Looping:

·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

Cursors:

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

Triggers:

Create or replace triggers

Creating Tables in SQL:


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

Auto-Indexing:

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

Error-Handling:

·SQL TRY/CATCH
·SQL System error functions
·Customizing SQL error messages
·@@ error function

Debugging:

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

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best