Learn SQL Beginner to Advanced in Under 4 Hours

[@amazingme894]

Hey alex, please never die or delete your channel, I'm lost with what career to get after getting a useless degree and have no technical skills for a job, currently unemployed and living with aging mom, so I'm considering following your channel in the near future after i get over my mental slump. APPRECIATE YOU!!

[@PythonArms]

You will find something. Good luck. 😊

[@yazz.huskies]

Same, my degree for whatever reason did not include a SQL course. smh. Now I'm scrabbling to learn SQL

[@quick-learn-africa]

thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.

[@adeolafasina]

Good Evening Please, I want to start a career in data analytics and I will be glad if you can put me through what needs to be done in the right order thank you

[@momohtimothy6898]

wow, that's amazing to hear. I reside in Lagos as well. Can you drop any of ur social media handle so I can follow you?

[@quick-learn-africa]

@@momohtimothy6898 yeah

[@quick-learn-africa]

@@momohtimothy6898 yeah my page check In

[@Oseking_01]

@@momohtimothy6898are u interested in learning as well?

[@zohraserhenova]

Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)

[@Harold1526]

Thank you Alex, You are by far one of my favorite youtube channels about data and technical skills. I am still in the learning process and I am thankful for your free resources. Thanks a lot!

[@MwishaLudack]

Your tutorials are the best. Let me just say that I watched the others, but you are by far the most clear instructor I've watched so far. Thank you

[@MR.JAM_687]

By the way i have completed your EXCEL TUTORIAL FOR DATA ANALYST and i was about to go for SQL and finally you posted this video today 😅

[@theschoolhackathon3258]

note if you're using a mac like me - you need to install my sql server, workbench, connectors, shell separately

[@Sankalp-sd6fm]

34:10 group by, order by 44:18 having vs where

[@tdcode]

this is awesome. Christmas came early 🎄

[@arthurleywin1832]

I just started your course and u dropped this, tnx mate

[@lesliebenjamin5487]

HELP: Any idea where in GitHub I can get the stored procedure to run and create the db? Which section is it on please?

[@bhavadharini4631]

It's wonderful how precise your videos are. You explain concepts and application with such immense clarity! But am I the only one getting overwhelmed starting from subqueries and window functions? :(

[@RohitGupta-ye3he]

Thank You So much Alex, I was just in search of a quick revision of SQL for my upcoming interview, this video just came on time :)

[@CristiPryor]

Honestly the best birthday gift. Thanks so much!

[@Jennifer_63165]

How'd you know i wanted to learn SQL??? Thank you Alex for this video!!! I cant wait to watch it, take notes, and actually be able to do stuff in SQL!!!! I'm so excited!!!! ☺️ Thank you, thank you and big thank you!!!!

[@sandysyam2263]

Thankyou Alex. your course really helpful, especially for me who has no background in coding, your explanation really understandable.

[@neelguru6562]

Hay Alex you made day. Love from india. God bless you for helping others.

[@aaronmorrison7189]

You dropped this King... 👑 (Thanks for this.)

[@harshagiripragada7435]

Felt sorry for Tom and Jerry😂!! But the tutorial was on point and absolutely clear. Thankyou Alex for educating!

[@randomytnametonotshowrealname]

Hey @Alex The Analyst, thank you very much for this video. It was really easy to follow and I actually had fun learning SQL. SQL just seems so easy to understand and all the commands make so much sense. I noticed at 3:07:11 that there were two locations that appeared twice in the data set, Malmo/Malmö and Dusseldorf/Düsseldorf. It seems like the person who inserted these data rows used the umlaut from the native spelling which causes problems if it is not imported through the right encoding method. It's a very detailed and minor thing but if you want to calculate with this data, e.g. which cities in Germany or Sweden had the highest layoffs, and be 100% accurate then the locations need to be combined. Anyway, thank you for this condensed SQL tutorial.

[@simonoganga9535]

This is great Alex, keep doing the great things you are doing

[@Trickst3rZer0]

I am a bit confused, should we follow along? take notes? both? how should we move with you as you teach us each section?

[@newenglandnomad9405]

Love how through the lesson is. My single question, what do you do with the results of your queries? For the EDA project, would you email the results to a stakeholder or manager, or create a dashboard?

[@AlexTheAnalyst]

If it's for someone usually you're exporting to Excel and sending the report. Or if they want it visualized for some kind of KPI tracker you're making a dashboard.

[@jpg109]

I'm very grateful to you for posting this video. The content here is really helpful for someone who is just learning. Thank you so much for your hard work!

[@GiorgosVp]

Purchased MySQL for Data Analytics after watching this video , I hold an MSc in Digital Marketing, where 2 out of the 8 courses were focused on Market Research and Data Science I & II. I am proficient in SPSS, R, and Python however, the curriculum had zero training in SQL for some reason. Given my background, I am considering whether pursuing a second MSc in Data Science would be beneficial, or if targeted courses and self-study would suffice .

[@rajashaw8501]

Is this enough or do we need something more 2 learn ??? I m very much looking forward to transit my carrier into data analysit . Any help would be appreciated

[@Leeta-i1f]

Hey man you done really great job. God bless u man.

[@denniskirimi156]

Thank you so much Alex. You dropped this at the right time! I believe it will start paying off some day

[@brandondyer-smith4892]

For the inner join, how do you deal with the situation where you need to restart the loop, for example based on your secret santa, Craig should be buying a gift for Leslie but that was not shown in the table

[@ismailsalawu700]

I'm a simple man, I see a video from Alex, I click!

[@AvatarKage]

This is a very well structured. Thanks!

[@arshin16]

hey Alex, thank you! isn´t the same account that you offer through your paid course?

[@Shanz-pt3fn]

Yay finally. I need it now more than anything.

[@nindogaming4132]

Thanks for this. However I was scrolling the lessons and I didnt see a video that covered statements like the update or delete statement. Is this video comprehensive or what concepts should I reinforce myself after watching?

[@blessingbukoye9282]

Thank you for this, Alex

[@efrainperez257]

Thanks Alex you are the best thank you and thank you, you are helping a lot of people I want to start my journey in data analytics

[@consensus9]

Hi Alex, did you also explained the CREATE FUNCTION in this video?

[@Zanab_Fatima]

Hello dear sir how are you ? I want to ask, can I use replit for practice to become a good data analyst

[@manishachaurasia]

Awesome! video Alex, I did take some sql courses from udemy to learn SQL but after watching your video and following with that giving me lot of confidence. Do you have more videos for sql projects on youtube?

[@PythonArms]

Hey Alex. Love your channel and everything you share. Question for ya if you dont mind. I have worked FT time as a tableau dev for the past couple years and I feel like tableau prep builder and TabPy are soooo underated, especially when it comes to ease of use, maintenance, etc. Why is it that hard coding ETL processes in SQL seems like the modern way to go? I see apps like tableau prep and power query that seems like they will work circles around hard coding in SQL. Am I off base here? Appreciate your thoughts sir!

[@TheHaagendazs0]

Wild. Glad 😌 this exists.

[@Jennifer_63165]

Hi Alex! I love your content!!! Is there a SQL curriculum you follow? Are there any easy to read books for absolute beginners? Is there a cheat sheet to this class so we can remember concepts? Thank you!!!!

[@edwinlloydniiodarteyevans6382]

If you tried following along with Microsoft SQL and got errors creating the database, try using this instead: -- Set the database to single-user mode to close all connections, then drop it IF DB_ID('Parks_and_Recreation') IS NOT NULL BEGIN ALTER DATABASE Parks_and_Recreation SET SINGLE_USER WITH ROLLBACK IMMEDIATE; DROP DATABASE Parks_and_Recreation; END GO -- Create the database if it doesn’t exist, then switch to it IF DB_ID('Parks_and_Recreation') IS NULL CREATE DATABASE Parks_and_Recreation; GO USE Parks_and_Recreation And then replace the AUTO INCREMENT on line 63 to IDENTITY(1,1)

[@hibernate8517]

Hello, do we need to learn the other string functions, or is okay to learn the ones in this video and learn the others later ?

[@loroda5375]

I have been enjoying your tutorials, however for this one I had to skip the installation part while waiting for my new laptop... Today finally arrived and made the installation, unfortunately the Server is not running and every time I tried to start it manually the app freezes and I have to force close, in other words I can not follow along (sad face)! I tried to troubleshoot with the dev website help but it is too technical (more sad face)... I hope I can get it fix soon!

[@rnielvhinsieans.elpidama6935]

alex which one should i practice the MySQL or PostgreSQL?

[@mozateiwilliams8554]

I can’t download the latest version of mysql because my MacBook doesn’t have the latest version of macOS and can’t be updated is there a work around?

[@BECLYogeshwariChilukamari]

Thank you so much Alex!!!

[@sebastianparrish1673]

I can’t load this on my Mac. Does anyone know how to?

[@ThePlaceUncovered]

Nice,,, following closely. unfortunately my triggers and events didnt work as yours lol... exact code at around 2:40:00

[@samyarkhanzadeh]

Hi Alex. Thanks a lot for your great channel. I just want to ask you something. I am now watching your Alex Data analytics boot camp in your KZbin channel. Should I also watch this SQL tutorial later or what I saw in your boot camp was enough? Again thanks a lot for your great channel

[@samyarkhanzadeh]

It is really appreciated if you answer my question

[@divyashreemahalingam7749]

I think it's the same

[@mulikinatisiddarthasiddu8245]

@@samyarkhanzadeh its the same

[@josemariannaemeka5409]

Do you recommend this for someone learning MS SQL?

[@Hesralli_YanIde]

I am not getting Create table and Insert Values in Dataset. Plz let me know how to download it. Thank you Alex in adavnce🤩

[@davidsonkojoarhin4840]

It's here finally!

[@RealEchos]

it's always been here he just sandwiched his videos together

[@qm599]

Thank you for this video, when I downloaded MYSQL, i don't have the developer set up. Can you point me to the right direction? or if i missed something. thank you.

[@dilim83]

Same here. Have you been able to figure it out?

[@coolnarsim]

At 2.14 you have the option Developer default and you are selecting that option and proceeding. However, i don't see that option and am seeing the next four options . How should i proceed? Please advice

[@pawek3523]

You could proceed with custom and manually selecting server, shell, router and workbench.

[@devgru4543]

Hey Alex, is there any discount for people from India or developing nation, I would like to take the bundle but it kind of a hefty price for me.

[@David-kj7el]

Great teacher

[@AkinfelaBernard]

Thanks for this You always deliver

[@tessalao5239]

Hello Alex. started the data cleaning project, having downloaded the layoffs file, trying to INSERT layoffs-staging, SELECT*, FROM layoffs, i am not getting any table as a result even though my action is correct, don't know what i am doing wrong

[@LinhHoang-ml1qo]

Thank you Alex

[@johnjayluna6049]

Developer default is not showing on the installation setup anymore. Can anyone help what should be the setup type that I should choose? TIA!

[@azwarmzafar]

Hi Alex, I am currently taking Analyst builder SQL courses and in the middle of them. is this content same as them or its new shall i go through this too?

[@AlexTheAnalyst]

No this does not go as in-depth as the AB course - that one is like 11 hours long with more advanced projects

[@popoolaolakunle4257]

About to ask the same question. Both can be study, Thanks Alex.

[@akilprakash9715]

Excellent❤

[@Experience_44]

This is enough for data analytics?

[@santoshkiran5858]

Brilliant awesome super important ❤❤❤

[@deeny447]

Thanks for this great video sir.

[@1212LeoSnake]

Is there a difference in MySQL and Microsoft SQL Server? I have Microsoft SQL Server.

[@SaeedBarrie]

My guru Alex Freberg

[@alexanderpamuri2049]

I need help i am failing to download the first file from GITHUB , what must i do

[@elhassaine]

Who's better to learn from better than Alex? 😅 Btw Alex i need to know if Dp-300 Azure certification covers how to use SQL.

[@graceaadi8720]

heyy how can i get that parks ans recreations folder ........ @Alex The Analyst

[@nik54610]

I haven't watched the video yet, is there any explanation on primary and foreign key in this video?

[@sherlynblessy]

No.

[@tango8011]

Is this the same course that is on Data Analyst?

[@umarfaruk2593]

We’re to download parks and recreation data set help me guys

[@AA-kq8on]

Thank you so much

[@jenellelucas5305]

Hi, I am not seeing the "Developer Default" option. Can anyone help explain why that it?

[@mohsinamukhtar7120]

Can we download this on Mac ?

[@alexrosen8762]

Yes!

[@mohamedmostafa-106]

Why, when I create two mysql users, I notice that there are the same databases in both of them, and I don't want that I want every user to have their own database.?

[@babygirlb123]

i guess I’m not the only one experiencing several frustrations with the cleaning data session. it’s like Alex doesn’t have the same complete dataset as there are values that come up for me when I filter with Rownum but not the same for Alex. I’m also somehow not able to create statement for staging 2. I gave up

[@umarfaruk2593]

I’m not getting that first data set were to download that

[@Ayan.sshhkk]

1:14:45 bro woke up and chose job over old people 😂😂😂😂😂😂😂😂`

[@Dxgreen]

Hey just wondering can I follow along using Azure SQL?

[@AlexTheAnalyst]

It's in a Playlist on my channel :)

[@mildredngondefondeson2395]

Hi Alex I have problems install MySQL. I get stuck at the password level. I don't know what the problem is

[@venkateh734]

Hi Alex I'm getting the same error I'm not able to create a root password asking me to enter the current root password and after entering the password it's showing an error is there a way to reset the root password please help me with this many thanks in advance

[@aN0923]

pls provide notes to revise for interview

[@lal538]

Please make another such video for MS-SQL server

[@AlexTheAnalyst]

Already did - it's somewhere in my videos :)

[@Chiebonam2]

I'm having little challenge putting in my password for this mysql. Is not even checking the password or telling me it is incorrect or to change

[@rekhadolse]

Thank you Alex I am too early!! can I get referral??

[@rishabhrao6618]

TYSM

[@AlchemistTasmi]

The first task on sql you showed that's data entry, isn't it?? Do analysts really need to do it?? Entrying data like this? This seems really lengthy

[@nightmare2821]

No, you take existing data and add it inside the table using code (python and all).

[@AlchemistTasmi]

@nightmare2821 thanks 🌷

[@thiagocosta527]

I've got a problem when I get to Data Cleaning classes. I import the .csv doc but my MySQL only imports about 560 records, not the 2.000 there actually is in the file. I've tried everything I can, but I have no idea what is going on!

[@SagarChowdhury-p1r]

launch some full excel, power bi, and tableau video like this with projects

[@chidinmaumendubisi4027]

It is already on this channel just go through his playlist

[@Sankalp-sd6fm]

I am not getting developer default option 2:20 help string functions

[@Fun-bro-cj]

Can you please upload new Python web scrapping sir

[@yudhitamabimasakti4890]

What different in the last video sql beginner course?

[@AlexTheAnalyst]

It's the same playlist, but put into one video :)

[@yudhitamabimasakti4890]

@@AlexTheAnalyst okay i wanna rewatch again, thanks alex :)

[@danielocean2931]

Please add Auto track options i learn in Hindi please

[@aidanmckenna2366]

I dont see a download option for a mac version of sql on that website?

[@winterfanatic]

Same!!

[@jbbassey1786]

Nice

[@maswinkels]

Ah yes, SQL, the most counter-intuitive way ever invented to query a database. On a positive note: it may be unnecessarily hard for humans to grasp, but it was designed to be super easy for computers to understand. Yay!