MySQL tutorial for beginners – Learn MySQL, the world’s most popular open source database.
🔥 Want to master MySQL? Get the full MySQL course: http://bit.ly/2uAoPM3
👍 Subscribe for more SQL tutorials like this: https://goo.gl/6PYaGF
⭐️Want to learn more from me? Check out these links:
Courses: https://codewithmosh.com
Twitter: https://twitter.com/moshhamedani
Facebook: https://www.facebook.com/programmingwithmosh/
Blog: https://programmingwithmosh.com
📕Get my FREE SQL cheat sheet:
http://bit.ly/2JCO73l
📔Scripts to create the databases in this course:
https://bit.ly/3rvtqdO
TABLE OF CONTENT
0:00:00 Introduction
0:01:02 What is SQL?
0:04:24 Cheat Sheet
0:04:50 Installing MySQL on Mac
0:09:48 Installing MySQL on Windows
0:15:08 Creating the Databases for this Course
0:23:40 The SELECT Statement
0:29:30 The SELECT Clause
0:38:18 The WHERE Clause
0:43:35 The AND, OR, and NOT Operators
0:51:38 The IN Operator
0:54:41 The BETWEEN Operator
0:56:53 The LIKE Operator
1:02:31 The REGEXP Operator
1:11:51 The IS NULL Operator
1:14:18 The ORDER BY Operator
1:21:23 The LIMIT Operator
1:24:50 Inner Joins
1:33:16 Joining Across Databases
1:36:03 Self Joins
1:40:17 Joining Multiple Tables
1:47:03 Compound Join Conditions
1:50:44 Implicit Join Syntax
1:53:04 Outer Joins
1:59:31 Outer Join Between Multiple Tables
2:05:50 Self Outer Joins
2:08:02 The USING Clause
2:13:25 Natural Joins
2:14:46 Cross Joins
2:18:01 Unions
2:26:29 Column Attributes
2:29:54 Inserting a Single Row
2:35:40 Inserting Multiple Rows
2:38:58 Inserting Hierarchical Rows
2:44:51 Creating a Copy of a Table
2:53:38 Updating a Single Row
2:57:33 Updating Multiple Rows
3:00:47 Using Subqueries in Updates
3:06:24 Deleting Rows
3:07:48 Restoring Course Databases
If you’re looking for a complete SQL tutorial for beginners with examples, this tutorial is a great way to learn SQL basics. Just follow through and you’ll be able to write SQL queries in no time.
SQL, short for Structured Query Language, is a language used by software developers, data scientists and anyone who works with data. With SQL, you can store data in relational databases and write queries to extract valuable information.
There are various database management systems (DBMS) that support SQL but each product has its own implementation of SQL. In this course, we’ll be using MySQL to learn SQL. MySQL is the most popular free and open-source database management system in the world. If you use a different DBMS (eg SQL Server), you can still benefit from this course as 90% of the skills you’ll learn in this course can be transferred to other database management systems.
source
34 replies on “MySQL Tutorial for Beginners [Full Course]”
can anyone share the cheat seet?
I used this video as a quick reference before my SQL lecture in my class
I an unable to get the cheat sheet please help …the link is not working
27:45
It's your Johnny sins teaching you MySQL😎😆
khoda kheyret bede.
Cant find the sql zipfile
Hi MOSH, like always, is perfect. Thanks. BUT JUST A WARNING: in SECTION 03:06:36 , ✓ Deleting Rows✓ , In subquery part, in SELECT section, Should replace * signe by column name(by client_id), you wrote: >> SELECT client_id <<, but it don't works
Thanks, Mosh for this great lesson-While downloading MySQL, at the phase of installing the samples and examples product, it brings up a dialog box with " No compatible servers were found. You will need to cancel this wizard and install one". I'm stuck. How do I fix this, please?
Hi Mosh,
AT 02:46:50 copy table:
If you want to have the same defenitions for the new tablle as from the origianal table use:
CREATE TABLE new_table LIKE original_table; — only copies the table defenitions without records,
and after that:
INSERT INTO new_table SELECT * FROM original_table; — filling the tabel with record from the origional table.
So in this case:
CREATE TABLE orders_archieved LIKE orders;
INSERT INTO orders_archieved SELECT * FROM orders;
Thanks for this video.
Thank you for sharing, really appreciate it.
The sheet link is not working. Can you please update the link for sheet.
Thank You for teaching me and everyone SQL.
Thank you for the video. Can you create another video for "SUPERVISORY IT SPECIALIST (DATAMGT)"?
where is the attached zip file
I cannot find the zip file you mention
Thank you..!!!
Many thanks for you mosh
Well well well. Imagine I have been trying to understand SQL for months now. Thanks to you Mosh, I understand more about it in 1 hour compared to months on coursera!
Thank you Sir for this course. Sir, I have a doubt in inner join clause at 1:30:00. When you have used select clause to return order_id, orders.customer_id then the table returned is sorted according to customer_id but the primary key in orders table is order_id. I didn't able to understand it. Please help!!!
In the exercise provided at 1 hr 9mins in the video, isn't it wrong to use REGEX for first question where we specifically want first names to be elka or ambur? Won't the regex also return values if they were 'helka' or 'hambur' or something with these two strings in them?
The best tutorial for MYSQL.
Thanks, MR. mosh just now completed this course.. , its really awesome.
respect for the patience of the teacher, the best lesson i ever heard
Son unos de los mejores LIkeEx.UnO
los mortales abian apreciado tan hermosa mujer
Megan: ''Hotter''
Hopi: ''Sweeter''
Joonie: ''Cooler''
Yoongi: ''Butter''
Senada: ''Hermoso.''
Amor. ''Momentos.''
Jamas.: ''Corazon.''
Habara.: ''Sostengo. .''
Son unos de los mejores conciertos, no puede ir pero de tan solo verlos desde pantalla, se que estuvo sorprendente.
hay nomas pa ra reirse un rato y no estar triste y estresado por la vida dura que se vive hoy..
Tu..belleza.viaja.al.universo.se.reune.con.estrellas.
y.luceros…tu.mirada.enamora.al.sol…..tu.hermosura.quedara.por..una..en.los.corazonede.
tus.admiradores……feliz
Navidad.y.noche.buena….mis.respeto.para.todas.las.mujes.del.mundo…saludos..al.fin.del.mundo. ..
Where he describes how to create table and insert data and about keys.
i dont see the zip file with the databases , where can i find that
Asi con toy y sus mañas no se la XxLike.Uno
I LOVE YOU
hay nomas pa ra reirse un rato y no estar triste y estresado por la vida dura que se vive hoy.
Son unos de los mejores conciertos
, no puede ir pero de tan solo verlos desde pantalla, se que estuvo sorprendente.
Жизнь, как красивая мелодия, только песни перепутались.
#Чо #эт #делает #на #2 #месте #в #тренде
#однако #я #люблю #таких #рыбаков #垃圾
hello , where is the zip file ?
Thank you so much for this video.
Do you recommand any book for me ?
This tutorial is awesome! I could easily understand MySQL and compare the difference with MS SQL server <3
Cheers to you Mosh! You are helping many developer worlwide
I'm using Win10 and I get the message No packages found and MYSQL installer did not find packages in the current bundle suitable for installation. How do I install please? Thank you Mosh
Damn I taught that setting up mySQL for windows would take an hour or more 😅
I can't download the Scripts to create the databases, Mosh can you help me providing another link to download the scripts, it would be very much helpful for me
. You're the best mentor, I have learned python from your channel
Learner Lot, thank you so much