Face to face / Online closed & onsite training. Restaurant lunch included at STL venues.
Introduction to SQL
Explanation of SQL
Importance and common application of SQL
Types of Databases that use SQL
Relational Databases
What is a database?
Relational databases
Components of a relational database
SQL Basics
Understanding SQL syntax
Using SQL to manipulate data
Common SQL commands
Creating Databases and Tables
Creating databases
Creating tables
Defining table relationships
Data Manipulation with SQL
Retrieving data using SELECT statement
Filtering data with WHERE clause
Sorting data with ORDER BY clause
Advanced SQL Commands
JOIN clauses
Subqueries
Aggregate functions
SQL Functions
String Functions
Date and Time Functions
Numeric Functions
Managing Data with SQL
Inserting data into tables
Updating data in tables
Deleting data from tables
Data Integrity
Primary keys and foreign keys
Indexes
Constraints
Arguably, the most experienced and highest motivated trainers.
Training is held in our modern, comfortable, air-conditioned suites.
Modern-spec IT, fully networked with internet access
A hot lunch is provided at local restaurants near our venues:
Courses start at 9:30am.
Please aim to be with us for 9:15am.
Browse the sample menus and view joining information (how to get to our venues).
Available throughout the day:
Regular breaks throughout the day.
Contains unit objectives, exercises and space to write notes
Available online. 100+ pages with step-by-step instructions
Your questions answered on our support forum.
The Royal Society
Patryk Kepinski,
Dynamics CRM Administrator
I really appreciated the trainer’s expertise and teaching style! Andrew created a comfortable learning environment, encouraged questions, and explained everything in a way that was easy to understand, even for beginners. Something I never thought I'd say, but it was a pleasure to learn about SQL and it's all thanks to Andrew!
Introduction to SQL
Loading content...
Excellent
Citigroup
Vice President
D.P.
Top-quality training by friendly instructors in good venues
"I've done several courses with these guys, including Advanced Excel and PowerPoint. The days are well organised and they lay on a great lunch, too. Their tutors are always lively and engaged with attendees. I thoroughly recommend their services."
Tutorials and discussions on MS Office
MS Office tips to save you time
MS Office shortcut keys for all versions
Handy info on industry trends
Latest news & offers
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
