SQL Intro

SQL Intro training is offered by Media Training. Our courses are meticulously prepared to ensure that they provide the real world skills you'll need to deliver your projects.
 

Master the fundamentals of SQL to work with databases, tables, and queries.
Use SQL queries to gain insights into large datasets and make informed business decisions.

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()