• Our Courses

  • Everyone comes into the world with zero SQL Server knowledge and, with this in mind, our course offerings cater for all levels and abilities.  Whether you are a novice or an expert, or maybe even just dabble as part of another role, we have courses to improve your skillset, working practices, and career progression.

  • Course Delivery

  • We are pleased to offer classes as follows:

    • National, in-person classroom based teaching from several major cities around the country
    • These include: London, Brighton, Cambridge, Nottingham, Manchester, Newcastle, and Edinburgh
    • On-site training for those who prefer to utilise their own office space
    • Please see our Locations page for more information

Beginner Courses

An Introduction to T-SQL

This is an introductory course which starts with the absolute basics but quickly progresses to slightly more complex structures. This provides a firm grounding in t-SQL querying, leaving all attendees with a firm understanding of the structure of a t-SQL query and with the confidence to write good t-SQL code against their servers.

2 Day Course | £795.00 (+ VAT)

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.

2 Day Course | £795.00 (+ VAT)

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

2 Day Course | £795.00 (+ VAT)

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.

3 Day Course | £1195.00 (+ VAT)

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

3 Day Course | £1195.00 (+ VAT)

Microsoft Certification

98-364 Microsoft Database Fundamentals (MTA)

Candidates for this exam are seeking to prove introductory knowledge of and skills with databases, including relational databases, such as Microsoft SQL Server.

This course is preparation for the "Microsoft Technology Associate in Database Fundamentals" certification.

3 Day Course | £1195.00 (+ VAT)

9am-5pm

On demand, please enquire

70-761 Querying Data with Transact-SQL (MCSA)

This exam is intended for SQL Server database administrators, system engineers, and developers with two or more years of experience who are seeking to validate their skills and knowledge in writing queries.

This training provides focusses on the requirements for the 70-761 Querying Data with Transact-SQL.

This is one half of the Microsoft Certified Solutions Associate SQL 2016 Database Development certification.

3 Day Course | £1195.00 (+ VAT)

9am-5pm

On demand, please enquire

70-762 Developing SQL Databases (MCSA)

This exam is intended for database professionals who build and implement databases across organisations and who ensure high levels of data availability.  Their responsibilities include creating database files, data types and tables; planning, creating and optimising indexes; ensuring data integrity; implementing views, stored procedures and functions; and managing transactions and locks.

This training provides focusses on the requirements for the 70-762 Developing SQL Databases.

This is one half of the Microsoft Certified Solutions Associate SQL 2016 Database Development certification.

4 Day Course | £1595.00 (+ VAT)

9am-5pm

On demand, please enquire

  • * In person courses are subject to a minimum attendance.  If this is not achieved, a substitute WebEx session will be offered prior to any payment being taken.

  • Would you like to discuss your training requirements with me?

    I'm always happy to help so, whatever your question, simply give me a call or send me a message and I'll get back to you as quickly as possible.