Worth Corner, Crawley, RH10 7SL

Our Courses

Course Levels

We have courses to cater for every skillset.


Beginner

Are you just starting out, a little curious, or want to dip your toe into a new technology? These are for you.

Intermediate

If you already know the basics of SQL Server and wish to advance to the next level, we have you covered.

Expert

These are courses for the more hardcore SQL users. These are complete deep dives into the internals of the product.

Beginner Courses


An Introduction to T-SQL

This course is for beginners, starting with a complete introduction to the basics before quickly progressing through to more complex structures. This provides a firm grounding in T-SQL querying, the confidence to perform basic data analysis and manipulation with T-SQL, alongside the creation of basic objects leading to the writing of good quality reusable and centralised code.

On Demand

Purchase now for access to our online, on demand, pre-recorded training. This includes 1 year of access to the course.


Course TitleInformationDurationPriceBook Now
An Introduction to T-SQLOnline recorded training with 1 year access11 Hrs£395 (+VAT) Book Now
Live Delivery

This is our Live course, delivered via Zoom where Covid restrictions mandate.


Intermediate Courses


T-SQL For Developers

Application developers regularly have to interact with a SQL Server, both writing and generating T-SQL queries and procedures. Sadly, many find that this code lacks performance, however, this can nearly always be rectified with some basic SQL Server internals knowledge and T-SQL tricks and tips in order to troubleshoot queries and to write highly performant and re-usable code. This course provides all the information required to write T-SQL that will drastically improve an application's performance.

Live Delivery

This is our Live course, delivered via Zoom where Covid restrictions mandate.


Accidental and Junior DBA

By the end of this course you will be able to confidently maintain and monitor SQL Server, alongside having a thorough understanding of disaster recovery, index maintenance, and baselining so that you can deal with any issues raised and remain calm and in control should a crisis ever arise. This information will be the underlying knowledge, not just to keep the lights on, but to build on when looking to improve and upgrade your career.

Live Delivery

This is our Live course, delivered via Zoom where Covid restrictions mandate.


Advanced Courses


Deep Dive T-SQL Performance Tuning

This course is designed to provide all the information and skills needed to become a highly skilled SQL Server Developer. It covers everything from indexing and statistical estimation to complex query constructs, optimizer tricks, execution plan analysis, architectural guidance, and much more.

Live Delivery

This is our Live course, delivered via Zoom where Covid restrictions mandate.


SQL Server Database Administration

This course aims to provide you with all the knowledge you need to be a specialist SQL Server DBA. It covers all the basics and essentials from disaster recovery and baselining through to server configuration, index maintenance, and high availability, but then pushes on to database design analysis and architecture (CDC, Temporal Tables, partitioning, and In-Memory optimisations).

Live Delivery

This is our Live course, delivered via Zoom where Covid restrictions mandate.


Sign up for email alerts

Stay current with our latest insights

© Copyright 2020 SQLTraining Ltd.