| Course Dates | Venue | Price | ||
|---|---|---|---|---|
| London Bridge | £379 + VAT save £20 | |||
| Online | £349 + VAT save £50 |
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
