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!!
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
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!
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.
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!!!!
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? :(
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)
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!
I had MySQL installed previously, now after uninstalling and making sure that I got rid of every file on my system(as i have lost my password😁),So I am now stuck at 5:00, where I don't remember the password and it does not take in any password that I pick, AM I DOOMED, NOW ??? Can anyone help the needed here
Looks like the MySQL Table Data Import Wizard is having problems for this dataset, probably with the amount of data it is allocating. Someone else suggested converting the .csv file to a .json file: "I too, faced the same problem while importing the layoff CSV i only got 500 rows, I converted the CSV file into JSON and then imported the JSON file into MySQL. The only problem with importing JSON is the date it'll be in five digit series you need to convert that using the Date_add() function, and then you're good to go." This worked for me. Reply
At 2:05 the "Developer Default" option no longer is in the installer. It doesn't matter if you get the latest version or the 8.0.32 version from the archives like shown in this video. Neither have the "Developer Default" option any longer. If you opt for the "Full" install, you also have to install Visual Studio, but it doesn't tell you what parts of Visual Studio to install. All of Visual Studio's options will be 45GB+. How do we replicate the "Developer Default" option in the installer?
@juliencollins4041 Go to 3:35 and the list of modules that are installed with the developer option. I just went with the full instll and selected the same modules.
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?
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
Hi Alex, after finalizing this tutorial, what should I do next? Usually the datasets on kaggle have just one table. I'm kinda lost. Could you give me some advice?
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
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 .
Hi Alex, Thanks for the video. I'm using mac and I tried to import the file, but for some reason only 564 rows are getting updated. What could be the reasons?
@@TheArgamanv Not yet. tried chatgpt, cleansed before uploading, there was a difference in the number of rows, however not all the rows are getting inserted.
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
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!
Convert the .csv to a .json, then import data. All 2,300+ records should import. You’ll have to convert all the NULL text to actually being NULL, change the data types of the columns with numerical data to INT, change the date column to the date data type and change the date format.
Hi, does a work from home setup work for being a data analyst, I'm looking for a remote work with high yield and decent work-life balance. Thanks in advance and hope this gets noticed.
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
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!
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
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!!!!
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!
so i am practicing these in pgadmin and when i try like statement for first_name like 'a__' it is case sensitive, it gives no hits where as i put is as like 'A__' then it returns ann is there any way to go about this ?
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?
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.?
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 TH-cam 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
Is there a way to reset "root" password? I forgot mine and now every time I try to re-install it asks for the old password which I can't remember. Would appreciate instructions!
Okay, So it happened to me as well Because mysql doesn't recognise apostophes ( ' ). For this you need to clear all traces of sql from your computer. Ask gpt on how to do it. I did it and it worked. You have to clear registry, appdata and uninstall all sql products. Then when u re-install it'll ask u a new password. My suggestion is try to include only numbers and alphabets this time.
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?
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.
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
Hi all, thank you so much Alex for this course. I am facing an issue here, when I try to install SQL there is no “Developer default” option. Can someone help me out please?? Much appreciated
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!!
You will find something. Good luck. 😊
Same, my degree for whatever reason did not include a SQL course. smh. Now I'm scrabbling to learn SQL
@@yazz.huskies yeah it’s almost like a degree is a piece of paper proving you wasted your time and money
thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.
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
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?
@@momohtimothy6898 yeah
@@momohtimothy6898 yeah my page check In
@@momohtimothy6898are u interested in learning as well?
Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)
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
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 😅
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!
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.
this is awesome. Christmas came early 🎄
34:10 group by, order by
44:18 having vs where
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 :)
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!!!!
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? :(
This is great Alex, keep doing the great things you are doing
I just started your course and u dropped this, tnx mate
HELP: Any idea where in GitHub I can get the stored procedure to run and create the db? Which section is it on please?
note if you're using a mac like me - you need to install my sql server, workbench, connectors, shell separately
just use postgre
Where did you find the URL to download the components?
this why i got a new pc
Hay Alex you made day.
Love from india.
God bless you for helping others.
Honestly the best birthday gift. Thanks so much!
Happy birthday
Thankyou Alex. your course really helpful, especially for me who has no background in coding, your explanation really understandable.
OMG! This is what I've been looking for like forever. Thank you very much sir. You've taught me a career skill within 4-5hrs time.
You dropped this King... 👑 (Thanks for this.)
Felt sorry for Tom and Jerry😂!! But the tutorial was on point and absolutely clear. Thankyou Alex for educating!
Thank you so much Alex. You dropped this at the right time! I believe it will start paying off some day
I'm a simple man, I see a video from Alex, I click!
Yay finally. I need it now more than anything.
Hi Alex, Thank you for provide the best effort about SQL , Awesome !!
This is a very well structured. Thanks!
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
Hey man you done really great job. God bless u man.
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)
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!
I am a bit confused, should we follow along? take notes? both? how should we move with you as you teach us each section?
atomics habits watch 30min follow along watch it again to understand and then do exercises on your own
Thank you for this, Alex
I had MySQL installed previously, now after uninstalling and making sure that I got rid of every file on my system(as i have lost my password😁),So I am now stuck at 5:00, where I don't remember the password and it does not take in any password that I pick, AM I DOOMED, NOW ??? Can anyone help the needed here
uninstall MySQL from your system completely. You can do this by search a "how to " on google. then install the whole thing again
Thanks for the tutorials
Hi guys I am using Mac and for some reason 2:45:17 I only get 564 rows and not 2361 - have anyone met this issue and if so, What did I do wrong?
Looks like the MySQL Table Data Import Wizard is having problems for this dataset, probably with the amount of data it is allocating. Someone else suggested converting the .csv file to a .json file:
"I too, faced the same problem while importing the layoff CSV i only got 500 rows, I converted the CSV file into JSON and then imported the JSON file into MySQL. The only problem with importing JSON is the date it'll be in five digit series you need to convert that using the Date_add() function, and then you're good to go."
This worked for me.
Reply
@@monaparisi8856 This worked for me! Thanks for the solution!
At 2:05 the "Developer Default" option no longer is in the installer. It doesn't matter if you get the latest version or the 8.0.32 version from the archives like shown in this video. Neither have the "Developer Default" option any longer. If you opt for the "Full" install, you also have to install Visual Studio, but it doesn't tell you what parts of Visual Studio to install. All of Visual Studio's options will be 45GB+. How do we replicate the "Developer Default" option in the installer?
I also ran into this issue
@juliencollins4041 Go to 3:35 and the list of modules that are installed with the developer option. I just went with the full instll and selected the same modules.
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?
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
You could proceed with custom and manually selecting server, shell, router and workbench.
Hi Alex, after finalizing this tutorial, what should I do next?
Usually the datasets on kaggle have just one table. I'm kinda lost. Could you give me some advice?
Today im starting this course jan 8
My goal is to finish this course in one week
Day 1 32:23 jan 8
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
very nice alex. big up Morroco
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 .
Thank you so much Alex!!!
Hi Alex,
Thanks for the video. I'm using mac and I tried to import the file, but for some reason only 564 rows are getting updated. What could be the reasons?
actually same O_O... Any solutions so far?
@@TheArgamanv Not yet. tried chatgpt, cleansed before uploading, there was a difference in the number of rows, however not all the rows are getting inserted.
Tried DBeaver, all rows are getting imported
Nice,,, following closely. unfortunately my triggers and events didnt work as yours lol... exact code at around 2:40:00
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
Brilliant awesome super important ❤❤❤
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!
+1
Hello, i am facing the same problem. Were you able to figure it out?
Same, did you figure it out already?
Convert the .csv to a .json, then import data. All 2,300+ records should import. You’ll have to convert all the NULL text to actually being NULL, change the data types of the columns with numerical data to INT, change the date column to the date data type and change the date format.
Nice Video Course. Good. 👍👌
Thanks for this great video sir.
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 ?
Hi, does a work from home setup work for being a data analyst, I'm looking for a remote work with high yield and decent work-life balance. Thanks in advance and hope this gets noticed.
Wild. Glad 😌 this exists.
Thanks for this
You always deliver
Please where can i download the mysql dataset, can't find it on his github
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
hey Alex, thank you! isn´t the same account that you offer through your paid course?
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!
bestt sql video on yt
It's here finally!
it's always been here he just sandwiched his videos together
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
I am not getting developer default option 2:20 help
string functions
How did you resolve the issue?
How did you resolve the issue
I didnt actually went to some online runner
@@Sankalp-sd6fm I also ran into this issue
Hi Alex, did you also explained the CREATE FUNCTION in this video?
Hello dear sir how are you ? I want to ask, can I use replit for practice to become a good data analyst
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!!!!
Hey Alex! Thank you for the great videos. When downloading MySQL there is no option to switch to iOS. Is it located somewhere else?
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!
so i am practicing these in pgadmin and when i try like statement for first_name like 'a__' it is case sensitive, it gives no hits where as i put is as like 'A__' then it returns ann
is there any way to go about this ?
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?
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?
Is udemy free?
I need help i am failing to download the first file from GITHUB , what must i do
Same with me.
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.?
alex which one should i practice the MySQL or PostgreSQL?
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 TH-cam 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
It is really appreciated if you answer my question
I think it's the same
@@samyarkhanzadeh its the same
Hi Alex,
Unable to copy the DB file to my local system. Please advise me.
We’re to download parks and recreation data set help me guys
Is there a way to reset "root" password? I forgot mine and now every time I try to re-install it asks for the old password which I can't remember. Would appreciate instructions!
Okay, So it happened to me as well
Because mysql doesn't recognise apostophes ( ' ).
For this you need to clear all traces of sql from your computer.
Ask gpt on how to do it.
I did it and it worked.
You have to clear registry, appdata and uninstall all sql products.
Then when u re-install it'll ask u a new password.
My suggestion is try to include only numbers and alphabets this time.
I am not getting Create table and Insert Values in Dataset. Plz let me know how to download it. Thank you Alex in adavnce🤩
heyy how can i get that parks ans recreations folder ........ @Alex The Analyst
I am having problem using trim with trailing in it is giving error what should i do to remove this error can you help?
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?
No this does not go as in-depth as the AB course - that one is like 11 hours long with more advanced projects
About to ask the same question. Both can be study, Thanks Alex.
I can’t load this on my Mac. Does anyone know how to?
What can't you load on your mac?
Great teacher
24:00 I was today years old when I realised Parks and Rec have Tom & Jerry in it.
I have an interview tomorrow afternoon and I hope this video will help me to be prepared 🙏🙏🙏
How did the interview go?
@@sneak9407 I passed the SQL part but failed in Python :((
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.
Is there a difference in MySQL and Microsoft SQL Server? I have Microsoft SQL Server.
I’m not getting that first data set were to download that
Thank you Alex
Excellent❤
How do i get these datasets to practice with
Developer default is not showing on the installation setup anymore. Can anyone help what should be the setup type that I should choose? TIA!
What did you later choose? Because I choose My server and I am confused now.
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.
Same here.
Have you been able to figure it out?
Hello All, When I downloaded MySQL . I was unable to see default settings. Should I choose my server? Please help I am a beginner. Thank you
Im not getting the developer option to download the dev version of mysql, any ideas?
When I try to download, there’s no Mac option. Any suggestions on alternatives?
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
Hi all, thank you so much Alex for this course. I am facing an issue here, when I try to install SQL there is no “Developer default” option. Can someone help me out please?? Much appreciated
do select that option
Hi, I am not seeing the "Developer Default" option. Can anyone help explain why that it?