SQL Crash Course: CRUD Operations | 10 Step MySQL Tutorial

Web Dev Roadmap for Beginners (Free!): https://bit.ly/DaveGrayWebDevRoadmap

In this SQL Crash Course you will learn CRUD Operations. This 10 Step MySQL Tutorial shows you how to use the SQL query language to create, read, update and delete (CRUD) data in a database.

Subscribe ➜ https://bit.ly/3nGHmNn

PHP is a backend development language that runs on a server. I suggest installing the XAMPP development server. Here is my guide to getting XAMPP set up:    • How to Install the XAMPP Server for P...  

Install XAMPP ➜ https://www.apachefriends.org/

📺 This tutorial is part of my PHP and MySQL for Beginners Playlist:    • PHP and MySQL  

(0:00) Intro
(1:04) Download the Employees Database
(2:36) Import the Employees Database into MySQL
(7:37) Step 1: SQL SELECT statement
(9:09) Step 2: SQL INSERT statement
(11:43) Step 3: A more specific SELECT
(12:37) Step 4: SELECT the Highest Employee Number
(13:41) Step 5: COUNT how many employees
(15:26) Step 6: SQL UPDATE statement
(17:47) Step 7: INSERT data into another table
(20:26) Step 8: SELECT to confirm data insertion
(21:20) Step 9: JOIN two tables in a SELECT statement
(23:27) Step 10: DELETE data from tables
(26:20) BONUS - Step 11: A More Complex SQL Statement

📺 Learn Web Dev at these sites:
https://www.freecodecamp.org
https://www.theodinproject.com

✅ Follow Me:
Twitter:   / yesdavidgray  
LinkedIn:   / davidagray  
Hashnode: https://yesdavidgray.hashnode.dev/
Reddit:   / daveoneleven  

Was this SQL Crash Course tutorial helpful? If so, please share. Let me know your thoughts in the comments.

#sql #crash #course