Structured Query Language – SQL Training Courses
Course schedule - Structured Query Language - SQL Training Courses
SQL Training courses we offer:
SQL Training Courses – Learn SQL Online
Structured Query Language (SQL) is one of the most important skills for anyone working with data. Whether you’re starting a career in data analysis, software development, business intelligence, or database administration, SQL is a powerful tool that helps you access, manage, and manipulate data stored in relational databases.
Learn SQL the Easy Way
Our SQL training courses are designed to make learning clear, practical, and enjoyable. You’ll learn how to write SQL code to:
- Store, retrieve, update, and delete data
- Work confidently with relational databases
- Understand database structures and relationships
All sessions are delivered by patient, friendly trainers who specialise in breaking down technical concepts into simple, easy‑to‑understand steps.
Live Online SQL Training
Our SQL courses are delivered live online, giving you the flexibility to learn from anywhere without the hassle of travel. You’ll receive course materials in advance and joining instructions to ensure you’re fully prepared for a smooth and engaging training experience.
Small Class Sizes — Guaranteed to Run
We keep our public online SQL courses small, with a maximum of 4 delegates.
If only one person books, the course still runs — we never cancel due to low numbers.
In‑Person SQL Training
Prefer face‑to‑face training? Let us know — in‑person SQL courses can be arranged if a trainer is available in your area. We also offer group SQL training at our Reading training centre.
Group SQL Training & Corporate Bookings
We offer competitive group booking rates for teams of up to 10 delegates delivered:
- Live Online
- At your office
- At our Reading training venue
Just tell us how many people you’d like to train, and we’ll send you a tailored quotation along with available dates.
What makes TCS Training different from other IT Training providers?
We offer:
Hands-on IT training - engaging courses delivered by friendly and qualified trainers.
Public courses are small - up to 4 delegates only.
1 year after course support is included with all courses.
Group booking rates are available on request.
100% of participants recommend TCS Training - read live reviews
SQL Introduction Training Course – One day – £325
Our one day SQL Introduction level 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 and we cover how databases are designed covering database concepts and terminology.
Whether you’re searching for a SQL course for beginners or you have a little knowledge, this course is for you.
Delegates do not require any previous knowledge of SQL. However, an understanding of relational database design is a preference, but not essential.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
SQL Introduction training course outline
Understanding the Data
• Understand how a relational database is structured
• Identify primary and foreign keys
Introduction to SQL & comments
• Use the Select statement
• Use the From statement
• Create comments
Ordering and Filtering data
• Putting data into alphabetical and numerical order
• Filter data
• Work with multiple criteria
• Work with wildcards for pattern matching
Using SQL code to group, calculate, concatenate
• Concatenate data
• Working with alias
• Build mathematical queries
• Apply aggregate functions
• Group data
Changing Data Values
• Inserting data
• Updating data
• Deleting data
Working with multiple tables
• Extract data from two tables
• Extract data from multiple tables
SQL Intermediate Training Course – One day – £355
Enrol on our one day Intermediate level SQL course to further develop SQL querying skills. The course builds on our SQL Introduction elements and covers some of the more advanced Clauses & Statements and includes an introduction to functions. The course covers more complex joining of tables.
Course Prerequisite: Delegates must have either attended our SQL Introduction course or be comfortable with the course objectives covered at Introductory level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
SQL Intermediate training course outline
Review of some of the basics
• Identify primary and foreign keys
• Review of SQL coding basics
Grouping and Filtering
• Filter data using various methods
• Group data
• Group data with aggregate functions
Mathematical operators and Functions
• Work with mathematical operators for modulus, power, round and ceiling
• Work with SQL functions with dates
• Work with SQL functions to find top and bottom percentage and items
• SQL functions to change data types
• Filtering and null values
• Use the CASE function
SQL Joins
• Understand different join types
• Merge table data
SQL code to create and delete
• Use code to create and delete a database
• Use code to create and delegate a table
• Create Views
• Create and delete Indexes
SQL Advanced Training Course – One day £395
SQL querying skills building on SQL Intermediate elements and covering more advanced functions and statements including transactions and stored procedures.
Our SQL Advanced course will give you the skills and understanding to apply complex coding in your database environments.
Course Prerequisite: Delegates must have either attended our SQL Intermediate course or be comfortable with the course objectives covered at Intermediate level.
If you can't make an advertised course date, please contact us by calling 0118 321 0124 or email info@tcstraining.co.uk and we'll see what we can do for you. Advertised training courses dates are hands-on and delivered live online by our engaging qualified trainers. We only book up to 4 on our public courses.
Group booking rates available for dedicated Live Online training (up to 10 delegates) or training in person delivered at your offices or at our Reading venue. Please contact us for a quotation.
SQL Advanced training course outline
The CASE Function
• Understand how the CASE function works
• Build CASE using text
• Build CASE for testing numbers
Subqueries
• Why we use subqueries
• Different ways to join queries
Work with Views
• Uses of a View
• Create Views
• Changing a View
SQL Variables
• What is a variable?
• Using the @
• Declaring the type
• Selecting variables
User Defined Functions
• Built-in functions
• Advantages of building your own function
• Build a function
• Scalar functions
• Table valued functions
Stored Procedures
• What are Stored Procedures?
• Reasons for creating Stored Procedures
• Create Stored Procedures
• Pass Information into a Stored Procedure
• Run Stored Procedures
Transactions
• What are Transactions?
• Reasons for creating Transactions
• Create basic Transactions
• Understand Commit and Rollback
You may also be interested in these related courses
Microsoft Power BI Courses
On our Microsoft Power BI courses you will learn about the powerful business analytics tools helping you visualise your data and share insights across your organisation. You will produce and share reports and dashboards and collaborate on data analysis. You can use SQL to bring data together for your Power BI visualisations.
Microsoft Power Apps Courses
Our Microsoft Power Apps courses teaches you about the suite of apps, services and connectors that provide rapid development of custom apps for your business needs. Little to no code makes it accessible to all users. Power Apps interact with SQL data.
Microsoft Access courses
Our Microsoft Access courses teach you how to design and build desktop databases for business solutions. Access can connect to SQL databases and also use SQL code to extract data for reporting and use within the application.
View all our IT Training Courses
Microsoft
Courses
Adobe
Courses
Programming
Courses
What our customers say
Why Choose TCS Training?
Expert Instructors
Our courses are led by experienced and certified trainers who are experts in their fields.
Flexible Learning Options
We offer both live online and on-site training to fit your schedule and learning preferences.
Comprehensive Course Materials
Receive detailed workbooks, reference manuals, and other resources to support your learning.
Post-Course Support
Benefit from up to a year of after-course support to help you apply what you've learned.
Customizable Training
We provide standard, tailored, or bespoke training solutions to meet your specific needs.
Group Booking Discounts
Take advantage of special rates for group bookings, whether for public or private courses.
Work with us
Want to chat to someone from our team about a training course or need something tailored for you - no problem.