Course Dates | Venue | Price | ||
---|---|---|---|---|
London Bridge | £329 + VAT save £70 | |||
Online | £329 + VAT save £70 | |||
London Bridge | £399 + VAT | |||
Online | £399 + VAT | |||
London Bridge | £399 + VAT | |||
Online | £399 + VAT | |||
Online | £399 + VAT | |||
London Bridge | £399 + VAT | |||
Online | £399 + VAT | |||
Online | £399 + VAT | |||
London Bridge | £399 + VAT | |||
Online | £399 + VAT | |||
Online | £399 + VAT | |||
London Bridge | £399 + VAT | |||
Online | £399 + VAT |
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.
"Ian was really knowledgeable, helpful and accomadating. Great at answering questions and giving us extra information. Place is lovely and definitely would recommend for others if they are looking to advance their skills."