SQL Tutorial For Beginners | MySQL Tutorial

Beginners SQL tutorial with code and exercises.
🔑 Effortlessly set up MySQL, the open-source relational database, as we guide you through the installation process.
📊 Master SQL basics with essential clauses like SELECT, WHERE, DISTINCT, LIKE, ORDER BY, LIMIT, OFFSET, and BETWEEN.
💡 Elevate your skills with advanced topics like summary analytics functions (MIN, MAX, AVG, GROUP BY) and powerful functions (IF, CASE, YEAR, CURYEAR).
📚 Explore additional topics such as the HAVING clause, calculated columns, and the intriguing world of SQL joins.
You can find all exercises at this link: codebasics.io/courses/sql-beg...
Download the datasets from here: codebasics.io/resources/sql-t...
The above link is also my premium SQL course covering many industry use cases and advanced topics. So if you want to learn it thoroughly please check out the affordable SQL course from the above link.
⭐️ Timestamps ⭐️
00:00 MySQL Installation
13:06 SELECT, WHERE, DISTINCT, LIKE, ORDER BY
34:04 Summary Analytics (MIN, MAX, AVG, Group By)
46:24 HAVING clause, Calculated Columns
1:05:09 SQL Joins
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Need help building software or data analytics/AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
🎥 Codebasics Hindi channel: / @codebasicshindi
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...

[@zsrajveer1121]

Sir, very very thankfull I learned a lot as i am a beginner for a data analyst and not only i just saw but also did it with you , at first i pasued and tried to do by myself and in that way i fell very easy to understand what problems i am getting and how it can be handles and why and which steps have to come in order like where keyword cannot be used after filtering keywords and many other thing , though this video is of only 1.5 hr , it took me half day to complete it and it was fun , plz bring more videos to it and once again very very thankyou

[@funclub1008]

"Thank you so much, Sir. This lecture is really helpful for me to understand SQL as a beginner. It will be really helpful for beginners ,when practiced properly.

[@jacobdang751]

This was larger than expected experience to learn SQL like ABCD…. Please create videos on SQL interview questions too.

[@user-mr3hj4sx5p]

I truly appreciate your work, You explain sql queries with real based scenario is very intuitive and make learning sql ease. I've completed this tutorial in 3 hrs with exercises Thanks and keep upload such content.

[@mtad-health]

Thanks for your easy video, its great to learn

[@kumudr]

thank you sir, good sql tutorial in short video covering all major topics..

[@simranjeetsingh1228]

Need you more SQL videos, please take it advance level.

[@huzaifahshah3841]

Thanks Sir Specially you comparison with Excel very easily understand Classic Sir G love fro m Pak

[@AshokKumar-bw9kr]

Great sir your teaching method is distinct ❤

[@madhurisharma946]

can you also provide installation of MYSQL for mac as well?

[@memesworld470]

Good effort sir, I open the link in description for exercise but, it was saying error not found in your website sir, where can I practice questions

[@HarshShah465]

Thank you dhaval for providing easily understandable content.Please upload more videos on end to end llm applications series.Waiting eagerly.

[@codebasics]

yes those videos are coming up soon. Stay tuned!

[@chandrakantshimpi9050]

Sir please upload more videos as soon as

[@user-wq2sr2wp4x]

Thank u sir very useful

[@subhamitakanungo5430]

I appreciate the valuable content you've provided. I'm eagerly anticipating the release of the Advanced SQL series as well. Thank you, Sir!

[@codebasics]

Hey for advanced SQL please check our SQL course on codebasics.io I don't have any plan for uploading advanced sql content on this channel (atleast in the near future)

[@mansijswarnkar4389]

Great !

[@marystellamungai4405]

Thanks sir,,this video is really helpful and easy for a total beginner to understand.🎉 However am unable to access the practice questions, please assist.thank you

[@Lexi_The_Queen]

Good One Sir...Please Upload More

[@ruhannegi8376]

Can we use SQL code to read text file with other SQL codes in a folder and run them??

[@sindhushacn826]

Hi, is sql paid course cover all advanced topics too to get placed in sql devloper role ?

[@sangamvarshney2706]

After installation I have option for MySQL connector in available products. What to do now

[@riyatiwari4767]

There is no vertical scroll bar while importing data using server.

[@Rr-lh2ru]

Sir plz create a playlist for full ai ml

[@H.K_Vlogs]

joining your bootcamp soon 😁

[@gowthampalvannan]

Good morning sir? I'm Gowtham from tamilnadu . 2021 passed out BE-CSE .two years preparation for govt exams. so I lost my two years sir. Which path should I follow as a data scientist sir? Tell step by step procedure sir? Thank you sir.

[@ashwinnirantar7309]

If u could able to bring something more just like data analyst course it'll be very helpful..

[@PraneethKumarMakam-cq8xt]

Where can we find the exercises for practicing SQL

[@user-sm3rx2uw7r]

Where can I find the complete course? I live in Europe.

[@harivetri1503]

Sir I cant able to access the login page for bootcamp it shows like no longer the page is available plzz do reply

[@best7774]

Hello, After I opened My SQL workbench, I am not getting where to find and download Movie Database

[@gamerntube7475]

Power bi desktop not connecting to my sql database .. i tried my sql connector/net to install .. no change in my problem .. give me solution sir

[@tasnimmumu]

I can not find the exercises.. do i need to enroll for it?

[@mrinocent2436]

Sir please solve this question, I want to find which Bollywood movies release in year 2015 ?

[@jithinkvb]

Where can i find the excersis?

[@cbbcbb6803]

How to make workbench work with MariaDB?

[@qudsiyaafaq]

Hi Can someone please please help me out while installation it is just asking for "current root password" and does not allowing me to go on next. neither giving an option for my SQL root password and repeat password. How can i resolve this please help me out. Although I don't remember I ever had root password before

[@maddilashalini6264]

Hi, why installing I cannot see MySQL connection , could you please help me?

[@UNCUTGAMING240]

is this enough for data analytics

[@ROSEMARY-ls5re]

i am not able to configure the server connection when installing.Can anybody help me

[@sowdhaminik8117]

I can't see the exercise .can you help me with that

[@mayurb360]

Hi Dhaval, I'm watching your videos since long time and I know we cannot add users to roles in power bi desktop for that we need power bi services. Correct? But someone told my manager that it is possible to add users in desktop as well, can you tell me if he is right or not? Your answer will be a proof to my answer to him as well. Help please

[@mayurb360]

Hi sir reply please

[@Ayaan_khan21]

@2:40 while trying to install connector the connector option itself is not visible for me . please assist

[@mahendrakumarpagare2960]

same here and I don't see documentation as well, let me know if you find any solution to it

[@93sai]

I cannot see connectors while installation

[@livinglife0788]

Hi Dhaval, thanks for your insightful video... Im facing some issues while downloading MySQL... I was not able to run queries so I uninstalled and was trying to download again but it's not happening... In "connect to server " section I stucked... It's showing connection failed in status...Please help how to solve it...

[@ROZA99090]

Hey how did you resolve it

[@shanksshaki]

how u got download movies db .sql ?

[@praveenmalik8269]

Mysql connectors is not showing to install😢

[@jameelbaba-vx7ge]

Request please upload windows function, CTE and other advanced topics🙏🙏🙏

[@codebasics]

Those concepts are covered in SQL course on codebasics.io (along with end to end industry project)

[@shobhitjais]

30:04 rather than using select * from movies where imdb_rating is NULL why we cant use IS in this sytax : select * from movies where industry IS "Bollywood" instead we use select * from movies where industry="bollywood" Thanks

[@pilotaussie]

Hi, as you said to download the 2 files, but i am not able to download these. Can you please guide

[@user-xp3sn8yl1w]

There is a link in the description.please check

[@Positive_me121]

Hi sir please suggest how to login to the forgotten sql+ account/ pwd

[@t.sathwik5708]

I am also facing same issue i forgot mypassword for my workbench

[@t.sathwik5708]

Can you know what to do resolve the error

[@sojitravaibhavi3162]

Can we import excel file (CSV) in my SQL?

[@karthikreddydappili4040]

YES ,WE CAN

[@Rr-lh2ru]

Anyone suggest me for full ai ml

[@kumudr]

i am in pool now learning to swim :)

[@fazlurrahman8035]

sir when i imported from self contained file it display a message "import completed with 1 error"

[@NITINKUMAR-et7yv]

same

[@dhwanidobhal7721]

27:51 if we are typing AND instead if or while searching for releasea_year why it is not showing the results. @codebasics please explain

[@vloggingmishra5604]

my sql install for Mac user

[@rajeshkannan8608]

sir, i don't get connector option to download!!!!!!in mysql 8.0.34..What to do?

[@imane-hx1kp]

did you find solution?

[@rajeshkannan8608]

@@imane-hx1kp no

[@mithunmahato309]

MySQL connector is not showing !

[@noorulhudabutt4484]

same with me, if u hv downloaded it please help.

[@user-nw7ls4sn4v]

for data scientest how sql we need to learn ?

[@codebasics]

yes. SQL is very much needed for a data scientist

[@readerisleader12]

Sir I take your all courses now i wait data science courses when you gonna upload?

[@swL1941]

How was the experience man? I am thinking of taking the powerbi and sql course. It would be great if you could share your views.

[@codebasics]

I have started work on building data science courses. I do not have exact dates yet but as soon as I have it I will announce it

[@captainchannel8210]

@swL1941 no one can beat Codebasics content for any course either SQL, POWERBI, EXCEL OR PYTHON. Just go for it.

[@tannuchandra1728]

Sir please bring bootcamp for data science

[@codebasics]

yes I have started work on it already. will take few months though

[@tannuchandra1728]

Thank you sir I am eagerly waiting for it

[@user-rp8ny7kt7l]

How can we import excel file into my SQL

[@best7774]

Have you able to find solution?

[@harishsharma8174]

Also make this video in Hindi

[@user-kq5qu3lv7r]

What is the difference between IS NOT NULL and !=" " ?

[@codebasics]

I will answer this in such a way that you will thank me later. Please copy and paste this same question in ChatGPT "What is the difference between IS NOT NULL and !=" " in SQL" and tell me if you get a satisfactory answer. Using ChatGPT for your questions is going to be an important habit that will help you rise in your career.

[@user-kq5qu3lv7r]

@@codebasics Thank you so much.You are a perfect teacher😍.

[@Arwah04]

😊

[@sanyamsah3176]

27:51

[@fenilparmar2586]

Sir Hindi me video banayena plz

[@flickhunter8900]

I think you are a big cinephile like me

[@abidhussain6788]

Sir hum sab middle class family se hain..but aap jaise logon k waja se hum sab kuch ker patein..hain..pls basic to advanced tak kerwa s jiyega ta k esiko ker k Direct job ker skke high package par..pls..adha adhura par mat chord ker jaiyega dusre jaisa..pls...

[@avyanshsingh7453]

boring session

[@cybersecurity_devops]

If you love what you are doing then it's never boring. So try to love what you do.

[@mrinocent2436]

​@@cybersecurity_devopsright brother I'm watching this on 4:35 AM and enjoying in learning 😆

[@saikumargatla4706]

Haters are not allowed

[@Support-Phalestine]

dumb video boring why you cannot use react angular or some server computation api based

[@larimar_1111]

Hi sir, thanks for your content. I have sent you LinkedIn request.please accept request. Also I have question that is this video same as your sql course excluding more exercises.

[@codebasics]

I've combined all the previous videos and published this as a single video. This way viewers don't have to switch between 6 different videos and they get all the value in a single video

[@larimar_1111]

@@codebasics no sir i am asking about your sql paid course on your codebasics website. is this video part of that.

[@vanshsamaiya6545]

why is this happening with me AccessDenied Access denied

[@spring9860]

Did u get it ?