Main: 01633 256482 info@nilc.co.uk

Advanced SQL

✓  World’s most widely used database language

✓  Hands on classroom sessions

✓  Expert instructors with 5 Star customer ratings

✓  Onsite training courses available

✓  ReAct Government Funded Accepted

Course Type

Classroom

Duration

1 day

Accredited

No

Exam

Not Available

Course Information

The advanced SQL training course will further develop your use of SQL to manage a relational database. By the end of this course you will be a very capable SQL user confident to use its more complex commands when viewing and managing tables in a relational database. You will also be able to run complex queries.

Stored Procedure Basics

  • Pros and cons of stored procedures
  • Creating stored procedures
  • Three ways to execute
  • System stored procedures

Variables

  • Declaring variables
  • SET versus SELECT
  • Tricks with variables and rowsets
  • So-called global variables

Parameters and Return Values

  • Passing parameters
  • Default values and WHERE clauses
  • Output parameters
  • Using RETURN

Avoiding Scalar Functions

  • What are scalar functions?
  • Some examples
  • Disadvantages of scalar functions
  • Three alternatives

Testing Conditions

  • IF / ELSE statement
  • Using CASE where possible

Looping

  • Syntax of WHILE
  • Breaking out of a loop
  • Basic transactions
  • Beginning a transaction
  • Committing / rolling back
  • Deleting and updating
  • Using DELETE and UPDATE
  • Objects
  • Dropping objects

Creating Tables

  • Creating tables in SQL
  • Inserting data
  • Inserting single rows
  • Inserting multiple rows

Temporary Tables and Table Variables

  • Using temporary tables
  • Creating table variables
  • Pros and cons of each approach

Table Valued Functions

  • In-line table-valued functions
  • Mult-statement table-valued functions
  • Limitations of user-defined functions

Derived Tables and CTEs

  • Using dervied tables
  • Common Table Expressions (CTEs)
  • Recursive CTEs

Subqueries

  • The concept of a subquery
  • Using ALL, ANY and IN
  • Correlated subqueries
  • Using EXISTS

Cursors

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

Error-Handling

  • Using TRY / CATCH
  • System error functions
  • Custom error messages
  • The obsolete @error function

Debugging

  • Version differences
  • The Visual Studio debugger
  • The SQL Server debugger
  • Debugging (breakpoints, etc.)

 

There is no formal assessment for this course. For accredited SQL courses please visit Microsoft SQL Server training courses

  • Day 1 –  09:15am – 16:30pm 
  • Day 2  – 09:15am – 16:30pm

This course includes:

  • Training from an experienced SQL trainer
  • Computer / Laptop to use for the duration of the course
  • Detailed course notes and sample exercises
  • Refreshments

Dates and Prices for SQL Advanced

Choose your location

Cardiff
December 19, 2019 £350.00
Available
Enquire
Cardiff
February 4, 2020 £350.00
Available
Enquire
Cardiff
March 3, 2020 £350.00
Available
Enquire
Cardiff
April 3, 2020 £350.00
Available
Enquire

Can’t find the course dates or location you’re looking for?

Please note all published prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT. All public classroom course bookings are subject to availability and minimum course numbers.

Why Choose NILC For Your SQL Training?

 

Industry Expert Trainers

Highly skilled trainers with real world SQL experience

Highly Rated

We are highly rated with 5 stars from Trustpilot

Hand's On Sessions

Practical classroom sessions that let you get hands on with SQL

Multiple Locations

Courses available at our venues or your offices

Other Related Courses

Our registered office and postal address is 50 Commercial Road, Newport, Gwent, NP20 2PE

All quoted prices are exclusive of VAT for consumers who pay no VAT or can recover VAT. The current rate of VAT is 20% for consumers that are required to pay VAT.
All course bookings are subject to availability.