Use SQL queries to delve into large datasets.
Gain insights and make informed business decisions.
SQL EXPERTS | PROFESSIONAL TRAINING | SMALL COURSE SIZES | LONDON & ONLINE COURSES
|Online||£229 + VAT save £150|
|London Bridge||£279 + VAT save £100|
SQL Intro | Training 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
• Inner joins
• Outer joins
• Self joins
Questions & Answers
You Might Like These Too
"Excellent, relaxing learning environment. Trainer was very friendly and nice."