Learn CRUD operations in MySQL through a comprehensive 10-step tutorial. Master the SQL query language to create, read, update, and delete data in a database. Begin by downloading and importing an employees database, then progress through SELECT statements, INSERT commands, and advanced queries. Explore how to count employees, update records, insert data into multiple tables, and join tables in SELECT statements. Conclude with DELETE operations and a bonus complex SQL statement. Perfect for beginners looking to grasp essential database manipulation techniques in just 32 minutes.
SQL Crash Course - CRUD Operations - MySQL Tutorial
Overview
Syllabus
Intro
Download the Employees Database
Import the Employees Database into MySQL
Step 1: SQL SELECT statement
Step 2: SQL INSERT statement
Step 3: A more specific SELECT
Step 4: SELECT the Highest Employee Number
Step 5: COUNT how many employees
Step 6: SQL UPDATE statement
Step 7: INSERT data into another table
Step 8: SELECT to confirm data insertion
Step 9: JOIN two tables in a SELECT statement
Step 10: DELETE data from tables
BONUS - Step 11: A More Complex SQL Statement
Taught by
Dave Gray
