SQL Intro Course

Name: SQL Introduction
Rating: 4.7 (18 reviews)

Learn to query and manage databases confidently using SQL on this practical one-day course.

Covering relational databases, SELECT queries, filtering, joins and aggregate functions using MySQL.

Reviews

9.4

Satisfaction

94.4%

Recommend

See Reviews

SQL Intro Course

Query and manage databases confidently using SQL on this practical one-day introduction course. You'll learn what SQL is and how relational databases are structured, how to create and manage databases and tables, how to insert, update and delete records, how to retrieve data using SELECT statements with WHERE, ORDER BY, GROUP BY and HAVING clauses, how to join multiple tables to combine data from different sources, and how to use aggregate functions to summarise and analyse large datasets.

Hands-on throughout using MySQL.

One Day

10:00 - 16:30 UK Time

Private Options

Key Learning Points
Create and manage databases and tables in MySQL
Insert, update and delete records using SQL
Retrieve data with SELECT, WHERE and ORDER BY
Join tables to combine data from multiple sources
Summarise data using aggregate functions

If attending an online course you must have a licensed copy of any software required and access to a suitable computer.

You need no previous experience to attend this course.

Who is this course for?

For developers, data analysts, marketers and business professionals who need to query and manage databases. No prior SQL experience required.

Expert Trainers

Course leader is an experienced industry expert

Class Size

1 - 10 in person or 1 - 6 online

Support

28 days free helpdesk support with all courses

Cancellation

Cancel before 7 days for 100% refund

Certificate

Earn a certificate of attendance on completion

Volume Discounts

Save money by using our Learning Pots scheme

Private & team training. This course is not on our public schedule at the moment. You can still request a bespoke quote below — we’ll contact you with dates and pricing.

Request a quote for SQL : Introduction

This course is offered as private, bespoke or team training at our centre, live online or at your venue.

You can customise the outline, have a group where it's just your team or enjoy a one-to-one session with an expert.

Fill in the form below and our team will get in touch with pricing and helpful advice.

Course Dates

Course Outline

Introduction to SQL and relational databases

What is SQL?
Overview of relational databases
Using MySQL to create a database

Creating and Managing Databases and Tables

Creating a database
Creating a table
Adding columns to a table
Deleting a column
Dropping a table

Inserting, Updating, and Deleting Data

Inserting data into a table
Updating data in a table
Deleting data from a table

Retrieving Data from Tables

Selecting data from a table
Using wildcards in SELECT statements
Using ORDER BY and LIMIT in SELECT statements
Using GROUP BY and HAVING in SELECT statements

Joining Tables

Inner joins
Outer joins
Self joins

Aggregation

COUNT()
SUM()
AVG()
MAX()
MIN()

Questions and answers

This course is also available as a private course. This allows you to choose the dates of your training and the location (in our training centre, onsite or at your offices). And, if you wish, we can tailor the content for you or your team. Please contact us for more details.

Very good personality and was very good at answering questions, well prepared and very interactive with us.

Great facilities knowledgible teacher a well structured day, with adequate breaks and time to learn.

The facility and trainer were both exactly as needed and to standard.

Great and friendly service from the front desk and extremely knowledgeable trainer who shaped the class to our needs. Great work

Very knowledgeable instructor, great examples.

Trainer (Dele) was very patient and tailored the learning to myself specifically as I was the only one on the course today. He was excellent. Overall a great experience and I plan to come back

Great industry knowledge and adapting course to my needs and industry. Found it extremely beneficial

The relaxed training and comfort to be able to ask questions whenever. And being able to do it online.