Web Dev Roadmap for Beginners (Free!): [ Ссылка ]

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 ➜ [ Ссылка ]

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: [ Ссылка ]

Install XAMPP ➜ [ Ссылка ]

📺 This tutorial is part of my PHP and MySQL for Beginners Playlist: [ Ссылка ]

(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:
[ Ссылка ]
[ Ссылка ]

✅ Follow Me:
Twitter: [ Ссылка ]
LinkedIn: [ Ссылка ]
Hashnode: [ Ссылка ]
Reddit: [ Ссылка ]

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

#sql #crash #course

свернуть