SQL Crash Course: CRUD Operations | 10 Step MySQL Tutorial

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.

(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:

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

#sql #crash #course

[vishnunair]

You deserve more views brother. As always, great tutorial!

[Karmagasm]

I was just thinking about MySQL the other night and now here you are with a crash course, thank you.

[eric_ng]

I must confess that you're the best tutor i have ever come across on this platform
your tutorials have guild me through my journey of becoming a dev engineer....Thank you

[ma-ezzh]

For what you did around the 19:04 mark in the video, I used this command with a couple of subqueries and it worked (in case you couldn't remember Dave Grohl's emp_no or hire_date from the other table):
INSERT INTO titles (emp_no, title, from_date)
VALUES(
(SELECT emp_no FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl'), 'Rock Star',
(SELECT hire_date FROM employees WHERE first_name = 'Dave' AND last_name = 'Grohl')
)

[alfredoalejandromaidana]

Mr Gray you are an awesome instructor, Greetings from Buenos Aires, Argentina!

[vladimiraleksic]

It is pure shame that we gave so little likes for such a great video ❤

[ahmad-murery]

Well done Dave,
just a few notes from a beginner point of view (I'm not but pretending):

If I am new to SQL/Databases I might not be able to follow your instruction as I wouldn't know how tables are structured (rows, columns, primary key, …), so a short intro on tables would be helpful (I think),


Also, I found it not so easy for new comers to understand the JOIN clause without an illustration of the two joined tables where one can visually locate the two joined columns (with the relationship in between), the tables aliases and how we can use this relation to extract needed data from both sides of the relationship/tables.



Waiting for the PHP integration video

[basilistigris]

best video on mysql crud operations i wacth, each step details explained perfect as always by Dave Gray.

[artisticcreature]

Hey brother thank you, I just had one problem with it, when I tried to run the code its throwing me an error saying "no database selected " what could be the reason ?

[ivailopetrov]

What are your thoughts about the LAMP VS Node stack?

[forthaysstudent]

You nearly guessed Grohl's birthdate. Its 1/14/1969!

[haroldpascua]

Thanks a Lot, this is very Helpful! i gave you Like and Subcribe