SQL Intro Course

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.