Play all

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

Description:

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

Dave Gray

Add to list

#Programming #Domain-Specific Languages (DSL) #SQL #Web Development #Databases #Relational Databases #MySQL #Computer Science #Database Management #CRUD Operations