SQL Training Courses - Remote training

Due to COVID-19 we are now offering our courses remotely helping you structure your day and focus on learning a new skill.
Courses are small - up to 4 delegates only.

SQL Code Introduction Course

This one day course will equip you with the knowledge to extract meaningful data from a database. Our Introduction level course covers retrieval of data including filters, sums, calculations and updating and deleting data. Delegates will also learn to extract data from multiple tables. Delegates do not require any previous knowledge of SQL. However, an understanding of relational database design is a preference, but not essential.

Read More

SQL Code Introduction training course outline

Understanding Relational Databases
Understand how a relational database is structured
Identify Primary and Foreign keys
Write statements to extract data from multiple tables

The Basics and Writing Comments
Write the SELECT Clause
Use the FROM Clause
Create different types of comments

Sorting and Filtering
Use Order By
Work with AND
Work with OR
Apply AND and OR together
Use IN
Work with wildcards to extract data

Work with Alias and Mathmatical Fields
Concatenate columns
Create an alias using AS
Use Mathmatical Operators
Apply Aggregate funcions - SUM, AVG, MIN, MAX, COUNT
Apply the Group By Clause

Apply Changes to Data
Use the INSERT Clause
Apply an Update
Change specific values
Use the DELETE Clause

Training Dates - Live Online

Fri 2nd July 2021

Fri 6th August 2021

Tue 7th September 2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£325

Download Course Details

Book this course

SQL Code Intermediate Course

The aim of this one day course is to further develop SQL querying skills. The course builds on our SQL Introduction elements and covers some of the more advanced Clauses and Statements.

Course Pre-requesite: Delegates must have either attended our SQL Introduction course or be comfortable with the course objectives covered at Introductory level.

Read More

SQL Code Intermediate training course outline

Standard Clauses
Use the DISTINCT Clause
Work with AND and OR
Understand IN and NOT
Review of wildcards
Group Information
Understand the HAVING Clause

Advanced Clauses and Functions
Apply Advanced mathematical operators
Work with various DATE functions
Understand uses of TOP
Work with IS NULL
Apply the CONVERT Clause
An introduction to Working with CASE

Creating and Deleting
Create Databases
Create Tables
Add Columns
Create Views
Create Indexes
Delete databases
Clear data from a table
Delete Tables
Delete Columns
Delete Indexes

Table Joins
Apply an INNER Join
Use a LEFT Join
Use a RIGHT Join
Use a FULL OUTER Join
Work with UNION

Training Dates - Live Online

Mon 5th July 2021

Wed 11th August 2021

Tue 14th September 2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£345

Download Course Details

Book this course

SQL Code Advanced Course

SQL querying skills building on SQL Intermediate elements and covering more advanced functions and statements including transactions and stored procedures.

Course Pre-requesite: Delegates must have either attended our SQL Intermediate course or be comfortable with the course objectives covered at Intermediate level.

Read More

SQL Code Advanced training course outline

Working with CASE

Build Subqueries
Creating and using Views

Introduction to Variables

Create and apply User Defined Functions

Create and use Stored Procedures

Introduction to Transactions

Introduction to Cursors

Using Loops and Cursors in a Stored Procedure

Training Dates - Live Online

Wed 21st July 2021

Wed 18th August 2021

Wed 15th September 2021

Delivered live online, or at your offices. Please contact us to arrange a date to suit you. Group booking rates are available on request.

Price

£395

Download Course Details

Book this course

SQL Training

Structured Query Language (SQL) is a special-purpose programming language designed for managing data in a relational database. Our courses take you from the basics of extracting data to writing complex code.

What our customers say

Book or Enquiry: SQL Training Course

Coronavirus - Remote / Online IT Training

In the current climate, we are offering training remotely.

Our experts will hook up with you via a remote connection and the course will be delivered this way.

Many companies are adopting this delivery method and it's working well to keep structure whilst working from home and providing something positive to focus on.

You can have a group session, or one to one. You still have our after course support service for 1 year after delivery.

We will post out to you the course materials to work with during the training session.
Please contact us for further details:
E: info@tcstraining.co.uk
T: 02380 527816