Introduction

Become a master SQL user on this 2-day advanced SQL training course.

This course includes plenty of chances to experiment with what you are being taught and ask questions if you’re not sure of something. We make sure that no-one is left behind.

By the time you finish, you’ll be comfortable using a wide variety of advanced SQL queries.

A complete advanced SQL course that covers all of the advanced concepts and techniques.
Plenty of one to one attention and time to ask questions.
Friendly expert trainers, small groups and a comfortable place to learn.

The Trainer

Our usual trainer for this course is Serena.

Serena began her career as a business analyst before moving into IT training.

She is a Microsoft certified and TPMA qualified trainer and has 20+ years’ experience of leading training courses, managing training projects and writing training materials.

What Will I Learn?

By the end of this advanced course, you will be able to use all of SQL’s advanced queries. 

You will be confident about using its more complex commands when viewing and managing tables, and able to run complex queries.

You’ll learn:

  • How to use IF, CASE and UNION queries.
  • Basic error trapping techniques and using commit and rollback.
  • How to create views and use stored procedures.

Course Details

Download full course details Download full course details

 

Click the sections below to see the full course syllabus for this advanced SQL course.

• Relational database concepts
• The role of SQL and ANSI standards

• Creating a database
• Creating tables
• SQL data types
• Altering tables (adding, dropping and renaming columns)
• Table and column constraints
• The role of indexes
• Inserting data
• Importing data

• Good practice when writing SQL queries
• Exploring the templates and stored procedures available in SSMS
• Saving script files v saving stored procedures
• Using Parameterised queries

• Recap on writing JOIN statements and column and table aliases
• ISNULL() function v IS NULL criterion
• Useful string, date and convert functions
• Aggregate functions
• Group by clause including rollup
• IF and CASE
• UNION queries

• Working with INSERT
• Working with UPDATE
• Working with DELETE
• Creating computed columns
• Using Begin transactions with Commit and Rollback
• Simple error trapping

• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()

• Creating a view
• Selecting data using a view
• Altering and dropping views

  • Introduction to Stored Procedures
  • Advantages of Stored Procedures
  • Creating and Using Stored Procedures
  • Dealing with an INSERT
  • Scalar
  • Tabular

Am I Ready For This Course?

This is an advanced SQL course, it assumes that you have some experience of working with databases. 

Before attending you should have a basic understanding of SQL select statements, have attended our introductory SQL course or have achieved equivalent practical knowledge.

Please note that for live online courses you are responsible for installing a functioning version SQL and MS SQL Server Management Studio on your PC prior to the course. On standard PCs this should take less than 10 minutes.

The Training Day

We provide everything you’ll need for two great days of SQL training. 

Our courses run from 9.30 am to roughly 4.30 pm with refreshments throughout the day and a break for a tasty, freshly prepared lunch.

We offer a relaxed, supportive learning environment, fully air-conditioned training facilities and some of the nicest instructors on the planet.

Also, you’ll receive:

A full-colour manual covering everything in the course so that you can recap.
A USB stick for the course exercises to let you practice more in your own time.
A Certificate of Attendance.