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.
✔ 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.
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
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
- Data Normalization
- Creating a Database
- Creating Tables
- 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
- Convert function
- Format function
- Casting data types
• Writing sub queries
• Over() and Over(Partition by)
• Row() v Rank()
- Sub selects/CTE
- Tabular Functions
- Temporary Tables
- IIF and CASE
- SET Operator Queries
- @local
- @@global
- 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 which covers everything in the course.
✔ Your course exercises so that you can practice at home.
✔ 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.