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 & Answers