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.
✔ An advanced SQL course that covers all advanced concepts & techniques. ✔ Plenty of one to one attention and time to ask questions. ✔ Friendly expert trainers, small groups and a comfortable place to learn.
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.
How to use IF, CASE and UNION queries.
Basic error trapping techniques and using commit and rollback.
Click the sections below to see the full course syllabus for this advanced SQL course.
• Overview of the database used in the workshop
Flat File and Relational concepts
Creating a Database
SQL Relationship Types
SQL Join Types
Altering tables (adding, dropping and renaming columns)
Table and column constraints
The role of indexes
Scripting Table creates and inserts
Roles of Primary and Foreign Keys
OTLP vs OLAP
Creating a view
Altering and dropping views
Selecting data using a view
• Good practice when writing SQL queries
Writing JOIN statements and column and table aliases
Useful math, string, and date functions
Casting data types
• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()
IIF and CASE
SET Operator Queries
Using Parameterised queries
Scalar vs Tabular
Using Begin transactions with Commit and Rollback
Working with UPDATE
Working with DELETE
Simply Try and Catch error handling
Exploring the templates and stored procedures available in SSMS
Saving script files v saving stored procedures
Introduction to Stored Procedures
Advantages of Stored Procedures
Creating and Using Stored Procedures
Dealing with an UPDATE
Am I Ready For This Course?
This is an advanced SQL course, which 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 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. ✔ A USB stick for the course exercises to let you practise in your own time. ✔ A Certificate of Attendance.
Online Training Requirements
To attend this SQL Training course online, you will need:
✔ MS SQL Server Management Studio connected to a SQL database on your Windows PC/laptop with a camera, speakers & microphone ✔ A stable internet connection capable of running Zoom ✔ To be a confident computer user and able to use Zoom
If you have access to a second screen, we would encourage you to use it as it improves the experience.