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: https://youtu.be/btauAEqaifw

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

This tutorial is part of my PHP and MySQL for Beginners Playlist: https://www.youtube.com/playlist?list=PL0Zuz27SZ-6MeRUt-z60DRxNqcrFAUYIb

(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: https://twitter.com/yesdavidgray
LinkedIn: https://www.linkedin.com/in/davidagray/
Hashnode: https://yesdavidgray.hashnode.dev/
Reddit: https://www.reddit.com/user/DaveOnEleven

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

#sql #crash #course