For bookings from established businesses, we do not require payment at the point of booking.
We will send you an invoice which you can submit to your accounts payable system.
Purchase Orders
If your employer uses a purchase order (P.O.) system to manage supplier invoices that is no problem.
If you already have a P.O. number when booking add it to the PO number box on the booking form, and we will include it on your invoice.
If you need an invoice to generate a P.O. number in your accounts system, please book the course as normal and add a note in the PO number box – to be provided
We will send you an invoice (without a P.O.) which you can use to generate a P.O..
We will then re-issue your invoice with your P.O. included when you provide us with it
PAYMENT METHODS:
You are not able to pay directly online at the time of booking, we issue an invoice for all bookings.
We accept payment either via direct bank transfer or card
Our invoices contain our bank details if you would like to pay by bank transfer and there is also information on how to pay by card.
Please note, if you are using a business card there is a surcharge of 2% to cover the payment processing charges.
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.
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.
Download full course details