Business Booking Details

Payment Of Invoices

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.

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 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 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.