He says, "You're the one putting in the hard work," completely ignoring the fact that he compiled hours of material and made it possible and easier for us. Thank you very much Alex.
9:05 Not sure if this has been pointed out, but the reason the SaleDate column didn't "update" here is because UPDATE does not change data types. The table is actually updating, but the data type for the column SaleDate is still datetime. To change data type, one has to use ``` ALTER TABLE NashvilleHousing ALTER COLUMN SaleDate DATE ```
I used to work for Microsoft as a data analyst. All the projects you did here were given to me at different times. Well done. everybody starting from scratch needs to follow you. I didn't have any idea when I started ETL/SQL jobs. This is very good one and you keep this up.👍👍
What you've shown here is what I do everyday for a fortune 500 fintech. Great information and you definitely earned my sub. Looking forward to watching your other videos.
Currently taking the google certificate, and I was literally thinking, “wow, I wish they had a video showing how to do this portfolio project...” thanks so much for taking the time to make these videos! I have completed my portfolio project, but I’m holding off on section 7(R)while I get a better grasp of SQL, and this channel has been great for that so far! Google should link you in their course! Ha!
Yes! I said the same thing! That course is great for the first few but after that they segment it out so much that it's hard to put everything together and actually be able to succeed in the capstone project. Alex, you are a lifesaver/life changer! I'm so excited to be doing these videos and actually seeing everything put together! I'm thinking that after this I will try and do a project on my own and see if I can do one by myself using Alex's methods.
How is it going? I just started studying in parallel with my studies at the university. It would be great to hear some feedback from an old disciple like you
Thank you so much, Alex. This video is incredible. I recently finished my data analyst studies and now I am trying to create a solid portfolio for myself. This is a great start. May God Bless you for all that you have done for people like me.
Thanks so much Alex! I know everyone says it, but you are helping so many people and making these skills so much more accessible! You're an incredible teacher!
I honestly don’t mind things being more advanced. Sometimes it’s really necessary to do things the advanced way and it’s really helpful to be able to learn them while doing a project, and in the end they can even be showcased in portfolio. Which is soo goodd. Thank you very much!
Awesome video Alex. I've been wanting to break into data analytics for YEARS, but back about 5 or 6 years ago, there wasn't really a clear path. Thanks so much for allowing us career changers to learn these skills, showcase them, and land that next job! I'm looking forward to my first gig. Thanks again.
Great and painless Portfolio Project series. Suuuper underated I must say. I finished 3 of these guided in a total of a week and a half. I did learn a lot about SQL and its usefulness. It's great to have someone like you on RUclips. Thank you so much Alex!! Keep up the great work!!
This is amazing! I’m a SAHM looking for a new career path that allows me to be more flexible with my family and doing contract work for analytics has inspired me to learn all I can. Just had my 2nd baby and I’m in the portfolio building phase and seeing you make mistakes and figure it out helps encourage me that I am going to do this but not to give up. I’m hoping to find a job this summer if it’s part time that’d be ideal since I have two under 3. I’m going through this boot camp and it’s amazing and much more fun than the Google cert program.
I feel like a lot of people have told you already Alex, but this is really helpful. I know basic SQL, but learning about all of these new techniques for data cleaning will certainly help me advnace my data analytics toolkit. You make this extremely fun to watch and exciting for your new stuff to come. Thank you!!!
WOW! This was so awesome! While the nuts and bolts of the function syntaxes are at the root of this course, almost more valuable is to understand the thought processes he goes through, and get a real world take on how this plays out when you're actually doing it. I learned so many nuances just watching how he typed things, great detail you can best learn by watching him in- action and doing it alongside him on your PC. So very thankful, Alex!
I am still working on the data analyst bootcamp and it has been fun and productive learning from you. On a sidenote, in the section standardize date format, I have research that instead of using update-set, we could use alter table tablename alter column saledate date and it works as what we have intended without using the update-set. Again Thank you very much Alex.
Thank you so much, Alex. I watched all your SQL videos. When I started I didn't know anything about SQL. I was able to complete this project without much hassle Thank you!!!
Best Project Yet - Really found this one helpful, since most tutorials don't really cover a complete data cleaning process, just parts of it. Thanks Alex!
Excellent Video Alex. As a newly certified Data engineer, I didn't know where to start my venture from as I lack practical experience and stumbling across your video gave me a direction to make portfolio and take it from there. I highly appreciate your work and effort. cheers
I don’t know if you still read these types of comments but I just wanted to thank you Alex for this guide. You’re a really good teacher and I’m glad I found this playlist and this channel
I have never even bother to like any video in my lifetime, you really did helped me a ton and the least that I can do for you is by clicking a button on my computer. I'm gonna find some other data and do the data cleaning on my own and then move on to the part 4 of the project. Thank you so much for your HARD WORK, hopefully what I did will lead me somewhere in the career path. YOU DESERVE all the HAPPINESS.
I think Alex's channel is one of the best channels out there. I'm currently a data analyst working for a telecom company in a country that's been witnessing some really tough time; however, I've always aspired to advance in my career and probably one day be able to immigrate to USA or Canada and get the dream job I want. I think Alex is a great mentor in that aspect because he had a tough start into this field and eventually did it! Thank you for all the tips, really helpful.
Just watched multiple videos from this playlist to strengthen my understanding for a project I'm leading in my new position as an analyst. It makes me SO HAPPY to hear your excitement about SQL because I feel the exact same way!! I can't wait until my project gets to a point where I can start writing SQL again. I look forward to turning to your channel whenever I need help or guidance (and honestly just watching your videos for fun)! Thank you for doing what you do!!!!! AND CONGRATS on the new path you're taking! (now I'm watching your newest video lol) Best of luck with everything!
Thx Alex , I forgot how much I love Sql . I am an IT project manager and interested in advancing my skills in Data Analytics . My goal is land a job in analytics in six months . Thanks again for guiding me through this process
This series is actually making me more motivated to work on projects for my portfolio, especially using SQL since it's by far my favourite. I am starting to apply for data analysis positions again and having projects to show but also discuss in interviews is going to be very valuable (at least for me who has no real formal experience in the area). Thank you for the videos!!!
Hey Alex, great video! During the changing Y and N to Yes and No i found that using a CTE to verify whether the CASE statement affected the table worked much faster than finding individual values prior to updating the table. Thought this might help other people showcase CTE creation and use to further expand their skills. Keep up the great work man; I'm loving your teaching style!
Thank you so much. You probably have an idea... but your portfolios and videos are very generous. You’ve really provided tangible context here that gets right into the meat and potatoes....my analyst buddies made it clear that they would have wished you were there at the start of their careers. And they usually always dismiss the videos I pass by them to check if they’ll help. You, and you alone, check out. Cheers! Happy memorial weekend!
Haha I’m really glad to hear that! That’s why I saturated this channel - when I was first starting out I wish I had stuff like this, but couldn’t find it anywhere. Thanks for watching!
I so appreciate you. I went through this video a few times at certain points to lock things in. And yes CHAT GPT explained what I wasn't quite getting. I'm doing your bootcamp but before I move on to ExcelI want to study more SQL through projects. Thank you for all the time you dedicate to this work.
Hello, Alex! Just wanted to let you know that the 3rd project is done. All queries are working perfectly! After this lesson, I categorized all your cases into "How to approach" -> "How to standardize data format", "How to>>>>" and put them into notes. My personal feedback is that although we haven't been studying the theory extensively, through this day-to-day practice, the understanding of how and why things work is gradually coming to mind. Once again, Alex, thank you so much for the time you've dedicated to sharing your expertise with the world. :) I truly appreciate all your efforts to provide contemporary knowledge to someone who is genuinely interested. Take care! I will provide additional feedback once the next steps are completed!
Thank you so much Alex.. been watching all your videos for almost a year now.. started where I thought I'd never understand SQL, now I'm here.. trying out new codes myself😅.. love you man ! Thank you so much!
THANK YOU ALEX!!! I so appreciate you. You are SO patient, methodical, and detail-oriented. It's been SUPER helpful/valuable for me to see your "mistakes" and follow along as you walk us through how to correct/address these issues in real-time. Thank you for not editing these parts out! I've learned a tremendous amount following your bootcamp already. Can't wait for Project #4!
So thankful Alex for showing me the basics. Your videos showing the nuts and bolts of doing this is EXTREMELY helpful to me. Thanks for demystifying SQL and all your videos and being so friendly!
I completed this project following your video. I used PostgreSQL and I was able to put to use some of the concepts that I learned earlier all due to this project. Also I learnt equivalent commands that can be used in posgresql . And every part of this project helped me learn more. Thank You for guiding during the entire project. It really helps boost my confidence whenever I can complete a project or run a query successfully. Thank You.
WOW.... JUST.... WOW!! ... This is very insightful. I'm so glad i stumbled upon your channel three weeks ago. These projects you're making are great learning tools. I never knew you could combine substring with Charindex like that. 👍👍👍
Thank you very much Alex for your videos! I have been watching all your SQL series from beginner till here. Apart from what you have been showing, I have also tried to do things on my own with the databases you have been using in the videos. When I got stuck I have started looking up on internet for possible solutions. All this to say that during my attempts I bumped into Alter Table Alter Column. So instead of this: ALTER TABLE NashvilleHousing Add SaleDateConverted Date; Update NashvilleHousing SET SaleDateConverted = CONVERT(Date,SaleDate) and then drop SaleDate I used: Alter Table Nashville Alter Column SaleDate date and I works :) Anyway thanks a lor and keep up with the good work
Hey Alex thanks a lot for theses free videos, i am an advanced data analyst now with knowledge on SQL , Talend DI (E.T.L) and Power BI for the visualisation part , i wished i had this kind of ressources back in the days when i was starting my career. I am here for the python and tableau part but can't hold my self to watch all your videos. The fact that you can't have values in this form "YYYY-MM-DD HH:mm:ss.mmm" (datetime) to this form "YYYY-MM-DD" (date) by just updating it is because the column datatype was already defined to datetime at the beginning using DDL. Once again thanks for your time !
thank you so much for all the hard work you put in. I did the google coursera certification course and found i hadnt absorbed any of the information in a useful way. I followed along for just TWO of your sql basic videos and theyve helped me retain so much more information and practical uses. You really give so much to this channel and your subscribers and we really appreciate it.
Another solid project, Alex! Thx! I used a SELECT INTO to copy the source table into a "cleansed" table and then used the SQL code to normalize, etc. That also allowed me to be able to rerun the whole script, along with a few Go commands sprinkled in. Much appreciated!
I couldn't explain all the questions you answered with this video. I've been studying SQL on my own for over a year now and my focus and motivation have definitely improved after this. Thanks!
Hi Alex, you could definitely be a college professor! This is exactly what we were taught in MIS class, but you have it more related to real work. Like it!
Thanks Alex for that amazing video. Concerning the datetime column the convert is mainly for a display and when it comes to the change of the column data type.. then we shifted into the table structure i believe. and that means we need to use ALTER not UPDATE. so the query should be ALTER TABLE 'table_name' ALTER COLUMN 'column_name' 'data type u want' so apply in the example in the video ALTER TABLE NashvilleHousing ALTER COLUMN SaleDate Date and it worked for me. i hope it helps!
Yes works wonderful, because if you also go to the list of columns on the pane available on left the input format for the column is datetime, so either you change that manually in that pane or you can use this alter table command
Since the format is datatime, regardless of any time of sale or without input the result shows dd-mm-yy-00-00-00 so just changing it to date sorts the problem
Alex i love man! Personally I really love SQL too!! These Projects and videos are so useful and really helpful in improving one's skillset. You are literally changing lives and helping so many people. Thank you so much for your time and immense knowledge that you share with us.
Thank you once again Alex for your information and knowledge.. These last three porjects have been very useful for me to embark in my first steps into data Analysis. I think for me and for anyone out there doing this project, is to not solely copy the code line by line, but to try to understand it, by writing comments in your scripts. It will be both useful for yourself and for those reading it.
Yes, I cannot say how much I really appreciate the mistakes made and pointing them out, then correcting them. I am notorious for forgetting parentheses, commas, and all the other "little" details that are easy to miss. Luckily, I have learned this about myself so it's easy for me to understand what I did wrong. As far as syntax goes, I love the material. Alex explains everything so well and I really understand what's going on rather than a copy and paste tutorial. Thanks Alex!
Hello Sir, This seems to be great video and is quite helpful. I never knew data cleaning requires decent amount of efforts. Also, I would like, for MySQL users, we can use UPDATE housing t1, housing t2 SET t2.propertyaddress = t1.propertyaddress WHERE t2.propertyaddress IS NULL AND t2.parcelid = t1.parcelid AND t1.propertyaddress is not null; for filling in null propertyaddress
Thanks for this! I spend a whole day trying to figure out how to do it in MySQL (mac user here) and finally I managed to do it thanks to your comment! 🙌
When Alex says at the end of his videos "You guy are doing great putting in the hard work" it reminds me of the old cartoon Blues Clues (the original Steve ) lol. Thank you
Hi Alex! I'm a 29 year old digital marketing professional that's working to pivot slightly into data analytics. I have Adult ADD so this stuff is really tough for me to get through but I have! I just finished the 3rd portfolio project and I'm looking forward to the next video which will be my first exposure to Python. Thank you for everything you're doing!! I really feel like I'm building a future thanks to you and educators like you.
Thank You So Much Sir, I was able to complete the first Phase of the Bootcamp, I'm still Amazed i did it, you were the first RUclipsr who made understand every video with any problem, I'll reference this video for My future Projects too.
Hi Alex, Thanks for creating this helpful video. Presently I am building my portfolio with these projects. Just a Quick suggestion, change the data type of the SaleDate to date to show the date after updating the column. query- UPDATE real_estate SET SaleDate = CONVERT(date,SaleDate) ALTER TABLE real_estate Alter column SaleDate date;
This worked for me! Thank you very much. You can test the data type of tables change by selecting this sytax, Select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'real_estate'
I have learnt so much from this Video... This for someone who worked in MSSQL alot during the early days of my software Dev career.... I need to do the ETL for sure
I have always found SQL less interactive compared to Excel and it has always bothered me. This beautiful content just reshaped my thought. Thank you so much Alex!
The recording might be 54 minutes long, but this doesn't account for all the rabbit holes you set me off into every time you introduce something new...Which is awesome! That's how precious these videos are, Alex. It's not just about the information you provide, but the lines of inquiry that emerge along the way. I just came back from a 30 minute quest for how to do window functions in R, now I can watch the rest of the video in peace (untill the next rabbit hole anyway lol) Thank you, Alex, for all that you do. You're a saint
🤣🤣 you want to talk about rabbit holes and speed bumps! It took me 7 HOURS to get through the FIRST video of this project! LMBO I have learned more from Alex the Analyst than I have through the Google certificate course! (I'm on the last part of that course) the first 3-4 courses in it are full of really good beginner information but after that they just seemed to fall apart for me. Anyways, I just wanted to stop in and say that I agree with you! Alex really is a saint!
I knew SQL before, but at last i understand what is all about; what is the comprehesive meaning of these data analitics; you put everything in context. Thank you Alex, you are a compass in this sometime complex informatic world.
This is super helpful for people like me who are trying to build a portfolio and don't know where to start and what to show. I'd like to see more projects in this series. However, these videos gave me a good idea on how to start. Thank you so much!
Alex, thank you so much for making these videos! Your videos have really helped me with my role. I just recently switched career and became a data analyst and I am so glad I found your videos. You explained everything in great details in a way that is easy to follow. Please keep making these portfolio videos :)
For the City, I did +2 in the CHARINDEX because of the space it put before the city. Saves me the trouble of having to trim it lately. Because if you start with the comma, you get a comma and a space.
Hi Alex, thank you so much for this Boot Camp I am on my journey to become a data analyst, and it is really an amazing playlist for those who wants to dive deep into the world of data. again thanks a lot for sharing your lifetime learning.
Thanks a million, dear Alex! This Portfolio Projects series is absolutely fantastic and so helpful for "newbies" like me. I know knowledge is a never-ending path but having someone like you on my side definitely makes the process faster, deeper and more pleasant. God bless you, bro!
Hi Victor, Can you please help me out with the data? I'm not able to download the data using the Github link provided by Alex. Can you please share the xlsx via your Github or something?
Hey Alex, loving your data analyst bootcamp... learning tons. In the 1st step in the cleaning here, where we tidy up the saleDate an easier way to clean that up would be: ALTER TABLE NashvilleHousing ALTER COLUMN SaleDate Date I am an absolute noob but I think the reason why it was not taking when using CONVERT or CAST is that the column is a Datetime data type. Keep up the great content!
AWESOME, AWESOME, AWESOME! Thank you for taking the time to do this for all of us. Super inciteful and helpful. This has me doing things that I never would have otherwise done, and opening up possibilities for me to do more extensive things at work that will help me stand out. Kudos to you!
Done! Finally Done!! It's taken two separate attempts, but I finished this project. Thanks Alex, AWESOME video. FWIW, I initially had issues with the data file I downloaded. Not sure exactly what happened, but I ended up with a bunch of rogue data that was preventing a proper flat-file import to Edge-SQL using Azure Data Studio. I re-downloaded the file tonight and everything just worked. How sweet it is! On a side note, I hope you are having an excellent week. Cheers!😎 (ps. "LIKE" button smashed)
Thank you so much for this lesson, Prof. Alex! I have searched for other ways to convert Date type in a column, using ALTER COLUMN function. ALTER TABLE NashvilleHousing ALTER COLUMN SaleDate Date SELECT SaleDate FROM NashvilleHousing I’ve learned so much from your tutorials.
I'm just bummed that I didn't come across your channel sooner! Great content! Awesome SQL video. I have a couple years of experience using MS SQL server and I still found it very informative. Thanks so much!
I use DBeaver with SQL server. Here are my tips for importing Excel data: - Using Google sheet for exporting CSV instead of Excel. All CSV files exported using Excel (Office 365) can't pass DBeaver importer! - Open CSV file using text editor, find and delete '$' (around 7 results). - Now the CSV can be imported smoothly in DBeaver :)
I just spent 2 hours struggling to upload the data to bigquery and I even manually wrote the schema and it still wasn't working and then I read your comment and it was incredibly helpful. Thank you!
30:40 Thanks for making us Understand even hard things in more detailed manner. Update Completed it within 4 and half Hours straight although i wrote more comments in my query for better understanding and ease which took lil more than half hour lol. Thanks Alex.
Thanks Alex for these kinda Projects. I am learning alot from these Projects which you are creating and I hope these will help me get into Data Analytics Field soon.
I'm hearing the first few min of this thinking it's a wash bc I've already cleaned the data in xl to make it import, bahaha. Data Cleaning is easier & better in xl, so why do it in SQL? I know, I'll get there when the xl series starts! Thanks for showing us in case there's ever a time when it's better in SQL tho-- all good info!
Woo Hoo, I am really excited to watch your video and I just finished part 3/4, and I can't wait for part 4/4, may Alex always be given health, abundant sustenance, until video 4/4 can be posted.
It took me 2 weeks to marathon your SQL and Excel videos alternately. It was something unplanned but I end making a rough schedule to finish all of you Data Analyst Bootcamp playlist. Hopes tp see more amazing videossss from you in the future!!
BRUH, keep em coming big guy. I'm loving it. i started part 1 three days ago and i am now here on part 3. that is on top of my corporate finance course as well police legitimacy tier 3 elective. I am loving this series and loving SQL.
It is worth to do this project. For uploading excel file into SQL , I have made a copy of the excel file to 97-2003 format and selected 97-2003 in wizard. It worked. Just check if it is working or not!
Alex, thank you for including the brilliant technique of combining the SUBSTRING() and CHARINDEX() functions to split a column on a specified delimiting character. I was trying to do this on a personal project, and I could not figure it out!! PostgreSQL has the extremely handy SPLIT_PART function, but SSMS unfortunately does not make it that easy. But the use of CHARINDEX() inside of SUBSTRING() has solved my problem! Thank you again!!
Another superb project, thank u Mr Alex, You av bn of tremendous help to me.. Data Analysis is a new for me, it's something I just started considering, u have made my journey easy so far..Thank very much, always motivated each time I listen to you..
Hi Alex, Today Only I have Seen Your portfolio Project Series, it is Amazing 👌👌 But As a request, I am asking You please try to explain at least one project store procedure, ex: "like an extracting data and moving data staging server to data warehouse" Please don't skip, it is helpful to lots of people 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏 As early as possible, please explain
He says, "You're the one putting in the hard work," completely ignoring the fact that he compiled hours of material and made it possible and easier for us. Thank you very much Alex.
He's just too kind
Thank you so much Alex
9:05 Not sure if this has been pointed out, but the reason the SaleDate column didn't "update" here is because UPDATE does not change data types. The table is actually updating, but the data type for the column SaleDate is still datetime.
To change data type, one has to use ``` ALTER TABLE NashvilleHousing ALTER COLUMN SaleDate DATE ```
No every hero wears cape.
Thanks bro
@@Orangeberg-m9x Do this:
ALTER TABLE PortfolioProject..NashvilleHousing
ALTER COLUMN SaleDate Date
This 1 hour video has most of the important SQL concepts needed
I used to work for Microsoft as a data analyst. All the projects you did here were given to me at different times. Well done. everybody starting from scratch needs to follow you. I didn't have any idea when I started ETL/SQL jobs. This is very good one and you keep this up.👍👍
Okay I know it's goddamn weird but can you refer me for some entry level data analyst profile pleaassee
What you've shown here is what I do everyday for a fortune 500 fintech. Great information and you definitely earned my sub. Looking forward to watching your other videos.
Very cool! And thanks for watching! :D
can you mention a few other things that you do every day,might be helpful to know how everyday work is of cleaning data.
@@antarabhattacharjee9194 2 years later. And he never answered. Sigh)
This channel is so underrated. We need more likes for him
Currently taking the google certificate, and I was literally thinking, “wow, I wish they had a video showing how to do this portfolio project...” thanks so much for taking the time to make these videos! I have completed my portfolio project, but I’m holding off on section 7(R)while I get a better grasp of SQL, and this channel has been great for that so far! Google should link you in their course! Ha!
That's really cool! I'm so glad to hear that :D
I back your opinion
Yes! I said the same thing! That course is great for the first few but after that they segment it out so much that it's hard to put everything together and actually be able to succeed in the capstone project. Alex, you are a lifesaver/life changer! I'm so excited to be doing these videos and actually seeing everything put together! I'm thinking that after this I will try and do a project on my own and see if I can do one by myself using Alex's methods.
just in case you see this. how did it go? did you succeed in getting work? i completed it and am working on these as portfolio projects.
How is it going?
I just started studying in parallel with my studies at the university. It would be great to hear some feedback from an old disciple like you
Thank you so much, Alex. This video is incredible. I recently finished my data analyst studies and now I am trying to create a solid portfolio for myself. This is a great start. May God Bless you for all that you have done for people like me.
Thanks so much Alex! I know everyone says it, but you are helping so many people and making these skills so much more accessible! You're an incredible teacher!
I honestly don’t mind things being more advanced. Sometimes it’s really necessary to do things the advanced way and it’s really helpful to be able to learn them while doing a project, and in the end they can even be showcased in portfolio. Which is soo goodd. Thank you very much!
So glad to hear your feedback!
Awesome video Alex. I've been wanting to break into data analytics for YEARS, but back about 5 or 6 years ago, there wasn't really a clear path. Thanks so much for allowing us career changers to learn these skills, showcase them, and land that next job! I'm looking forward to my first gig. Thanks again.
Great and painless Portfolio Project series. Suuuper underated I must say. I finished 3 of these guided in a total of a week and a half. I did learn a lot about SQL and its usefulness. It's great to have someone like you on RUclips. Thank you so much Alex!! Keep up the great work!!
So great to hear that! Learning something new every day is a great thing!
This is amazing! I’m a SAHM looking for a new career path that allows me to be more flexible with my family and doing contract work for analytics has inspired me to learn all I can. Just had my 2nd baby and I’m in the portfolio building phase and seeing you make mistakes and figure it out helps encourage me that I am going to do this but not to give up.
I’m hoping to find a job this summer if it’s part time that’d be ideal since I have two under 3. I’m going through this boot camp and it’s amazing and much more fun than the Google cert program.
I am also a SAHM of 2 hoping to start a career in data analytics, you go mama!! 🥰 we got thiss! 🙏🏼
@@miagobeli-starr me too 🙌
I feel like a lot of people have told you already Alex, but this is really helpful. I know basic SQL, but learning about all of these new techniques for data cleaning will certainly help me advnace my data analytics toolkit. You make this extremely fun to watch and exciting for your new stuff to come. Thank you!!!
Hey, can you send me the dataset. I am unable to download it from the website. Please?
WOW! This was so awesome! While the nuts and bolts of the function syntaxes are at the root of this course, almost more valuable is to understand the thought processes he goes through, and get a real world take on how this plays out when you're actually doing it. I learned so many nuances just watching how he typed things, great detail you can best learn by watching him in- action and doing it alongside him on your PC. So very thankful, Alex!
Thank you again, Alex. I am going through this again in 2023, and I really understood it the second time over. I am so grateful fo you.
I am still working on the data analyst bootcamp and it has been fun and productive learning from you.
On a sidenote, in the section standardize date format, I have research that instead of using update-set, we could use
alter table tablename
alter column saledate date
and it works as what we have intended without using the update-set.
Again Thank you very much Alex.
Thank you so much, Alex. I watched all your SQL videos. When I started I didn't know anything about SQL. I was able to complete this project without much hassle Thank you!!!
Best Project Yet - Really found this one helpful, since most tutorials don't really cover a complete data cleaning process, just parts of it. Thanks Alex!
Your teaching style and pragmatic methodolgy is what makes you great. I enjoy every lesson from this channel.
Excellent Video Alex. As a newly certified Data engineer, I didn't know where to start my venture from as I lack practical experience and stumbling across your video gave me a direction to make portfolio and take it from there.
I highly appreciate your work and effort. cheers
I don’t know if you still read these types of comments but I just wanted to thank you Alex for this guide. You’re a really good teacher and I’m glad I found this playlist and this channel
I have never even bother to like any video in my lifetime, you really did helped me a ton and the least that I can do for you is by clicking a button on my computer. I'm gonna find some other data and do the data cleaning on my own and then move on to the part 4 of the project. Thank you so much for your HARD WORK, hopefully what I did will lead me somewhere in the career path. YOU DESERVE all the HAPPINESS.
Thank you - I appreciate it! Glad it was helpful!
I think Alex's channel is one of the best channels out there. I'm currently a data analyst working for a telecom company in a country that's been witnessing some really tough time; however, I've always aspired to advance in my career and probably one day be able to immigrate to USA or Canada and get the dream job I want.
I think Alex is a great mentor in that aspect because he had a tough start into this field and eventually did it! Thank you for all the tips, really helpful.
So glad to hear the channel has been helpful! Thanks for watching and the support :)
Just watched multiple videos from this playlist to strengthen my understanding for a project I'm leading in my new position as an analyst. It makes me SO HAPPY to hear your excitement about SQL because I feel the exact same way!! I can't wait until my project gets to a point where I can start writing SQL again. I look forward to turning to your channel whenever I need help or guidance (and honestly just watching your videos for fun)! Thank you for doing what you do!!!!! AND CONGRATS on the new path you're taking! (now I'm watching your newest video lol) Best of luck with everything!
Thx Alex , I forgot how much I love Sql . I am an IT project manager and interested in advancing my skills in Data Analytics . My goal is land a job in analytics in six months . Thanks again for guiding me through this process
This series is actually making me more motivated to work on projects for my portfolio, especially using SQL since it's by far my favourite. I am starting to apply for data analysis positions again and having projects to show but also discuss in interviews is going to be very valuable (at least for me who has no real formal experience in the area). Thank you for the videos!!!
Super glad to hear that! :D
@@AlexTheAnalyst sir can you please share another link to the dataset? Your website is not working . I've tried so many times!
@@devanshugupta7246 He is famous now, he wont care for your request , seen many people complaining about data set, he has nt responded to any
@@devanshugupta7246 i just download it. its working at my end
@@manggnorora5159 done man, the project is done. I've downloaded the dataset from another website. Thank you btw!
Hey Alex, great video! During the changing Y and N to Yes and No i found that using a CTE to verify whether the CASE statement affected the table worked much faster than finding individual values prior to updating the table. Thought this might help other people showcase CTE creation and use to further expand their skills. Keep up the great work man; I'm loving your teaching style!
Thank you so much. You probably have an idea... but your portfolios and videos are very generous. You’ve really provided tangible context here that gets right into the meat and potatoes....my analyst buddies made it clear that they would have wished you were there at the start of their careers. And they usually always dismiss the videos I pass by them to check if they’ll help. You, and you alone, check out. Cheers! Happy memorial weekend!
Haha I’m really glad to hear that! That’s why I saturated this channel - when I was first starting out I wish I had stuff like this, but couldn’t find it anywhere. Thanks for watching!
I am about halfway through, excellent quality teaching. Practically applied SQL makes a great change from the same old explanatory tutorials.
So glad to hear that! Thanks for watching! 😁
I so appreciate you. I went through this video a few times at certain points to lock things in. And yes CHAT GPT explained what I wasn't quite getting. I'm doing your bootcamp but before I move on to ExcelI want to study more SQL through projects. Thank you for all the time you dedicate to this work.
Hello, Alex!
Just wanted to let you know that the 3rd project is done. All queries are working perfectly!
After this lesson, I categorized all your cases into "How to approach" -> "How to standardize data format", "How to>>>>" and put them into notes.
My personal feedback is that although we haven't been studying the theory extensively, through this day-to-day practice, the understanding of how and why things work is gradually coming to mind.
Once again, Alex, thank you so much for the time you've dedicated to sharing your expertise with the world. :)
I truly appreciate all your efforts to provide contemporary knowledge to someone who is genuinely interested.
Take care! I will provide additional feedback once the next steps are completed!
Thank you so much Alex.. been watching all your videos for almost a year now.. started where I thought I'd never understand SQL, now I'm here.. trying out new codes myself😅.. love you man ! Thank you so much!
THANK YOU ALEX!!! I so appreciate you. You are SO patient, methodical, and detail-oriented. It's been SUPER helpful/valuable for me to see your "mistakes" and follow along as you walk us through how to correct/address these issues in real-time. Thank you for not editing these parts out! I've learned a tremendous amount following your bootcamp already. Can't wait for Project #4!
Hello please where you able to download the dataset?
So thankful Alex for showing me the basics. Your videos showing the nuts and bolts of doing this is EXTREMELY helpful to me. Thanks for demystifying SQL and all your videos and being so friendly!
So glad to hear it Patrick! :D
I took me a few days to complete this project but totally worth it! Thanks again Alex!
I completed this project following your video. I used PostgreSQL and I was able to put to use some of the concepts that I learned earlier all due to this project. Also I learnt equivalent commands that can be used in posgresql . And every part of this project helped me learn more. Thank You for guiding during the entire project. It really helps boost my confidence whenever I can complete a project or run a query successfully. Thank You.
WOW.... JUST.... WOW!! ... This is very insightful. I'm so glad i stumbled upon your channel three weeks ago. These projects you're making are great learning tools.
I never knew you could combine substring with Charindex like that. 👍👍👍
Glad to hear it was helpful and you learned some new things! :D
Thank you very much Alex for your videos! I have been watching all your SQL series from beginner till here. Apart from what you have been showing, I have also tried to do things on my own with the databases you have been using in the videos. When I got stuck I have started looking up on internet for possible solutions. All this to say that during my attempts I bumped into Alter Table Alter Column. So instead of this:
ALTER TABLE NashvilleHousing
Add SaleDateConverted Date;
Update NashvilleHousing
SET SaleDateConverted = CONVERT(Date,SaleDate)
and then drop SaleDate
I used:
Alter Table Nashville
Alter Column SaleDate date
and I works :)
Anyway thanks a lor and keep up with the good work
Hey Alex thanks a lot for theses free videos, i am an advanced data analyst now with knowledge on SQL , Talend DI (E.T.L) and Power BI for the visualisation part , i wished i had this kind of ressources back in the days when i was starting my career. I am here for the python and tableau part but can't hold my self to watch all your videos. The fact that you can't have values in this form "YYYY-MM-DD HH:mm:ss.mmm" (datetime) to this form "YYYY-MM-DD" (date) by just updating it is because the column datatype was already defined to datetime at the beginning using DDL. Once again thanks for your time !
thank you so much for all the hard work you put in. I did the google coursera certification course and found i hadnt absorbed any of the information in a useful way. I followed along for just TWO of your sql basic videos and theyve helped me retain so much more information and practical uses. You really give so much to this channel and your subscribers and we really appreciate it.
Thank you for providing this resource. I have a data analyst interview on Monday and I just got done working through the whole thing.
Good luck!!
Another solid project, Alex! Thx! I used a SELECT INTO to copy the source table into a "cleansed" table and then used the SQL code to normalize, etc. That also allowed me to be able to rerun the whole script, along with a few Go commands sprinkled in. Much appreciated!
I couldn't explain all the questions you answered with this video. I've been studying SQL on my own for over a year now and my focus and motivation have definitely improved after this.
Thanks!
This was the most well thought out and actually FUN project I have had the pleasure of witnessing. Thank You ALEX!!!
Hi Alex, you could definitely be a college professor! This is exactly what we were taught in MIS class, but you have it more related to real work. Like it!
Thanks Alex for that amazing video. Concerning the datetime column
the convert is mainly for a display and when it comes to the change of the column data type.. then we shifted into the table structure i believe.
and that means we need to use ALTER not UPDATE.
so the query should be
ALTER TABLE 'table_name'
ALTER COLUMN 'column_name' 'data type u want'
so apply in the example in the video
ALTER TABLE NashvilleHousing
ALTER COLUMN SaleDate Date
and it worked for me. i hope it helps!
Yes works wonderful, because if you also go to the list of columns on the pane available on left the input format for the column is datetime, so either you change that manually in that pane or you can use this alter table command
Since the format is datatime, regardless of any time of sale or without input the result shows dd-mm-yy-00-00-00 so just changing it to date sorts the problem
Alex i love man! Personally I really love SQL too!! These Projects and videos are so useful and really helpful in improving one's skillset. You are literally changing lives and helping so many people. Thank you so much for your time and immense knowledge that you share with us.
Thank you once again Alex for your information and knowledge.. These last three porjects have been very useful for me to embark in my first steps into data Analysis. I think for me and for anyone out there doing this project, is to not solely copy the code line by line, but to try to understand it, by writing comments in your scripts. It will be both useful for yourself and for those reading it.
Definitely agree! Walking through it and making mistakes is how you really learn from something like this.
Yes, I cannot say how much I really appreciate the mistakes made and pointing them out, then correcting them. I am notorious for forgetting parentheses, commas, and all the other "little" details that are easy to miss. Luckily, I have learned this about myself so it's easy for me to understand what I did wrong. As far as syntax goes, I love the material. Alex explains everything so well and I really understand what's going on rather than a copy and paste tutorial. Thanks Alex!
Hello Sir,
This seems to be great video and is quite helpful. I never knew data cleaning requires decent amount of efforts. Also, I would like, for MySQL users, we can use
UPDATE housing t1,
housing t2
SET
t2.propertyaddress = t1.propertyaddress
WHERE
t2.propertyaddress IS NULL
AND t2.parcelid = t1.parcelid
AND t1.propertyaddress is not null; for filling in null propertyaddress
Thanks for this! I spend a whole day trying to figure out how to do it in MySQL (mac user here) and finally I managed to do it thanks to your comment! 🙌
@@MaximilianoCarrizo17071983 I tried this code, but mysql timed out for me. Did that happen to you?
Oh wow! Thank you so much. I was stuck, but this helped.
When Alex says at the end of his videos "You guy are doing great putting in the hard work" it reminds me of the old cartoon Blues Clues (the original Steve ) lol. Thank you
I recently came across this tutorial. Thank you so much for the hours, work, and the way you simplified each and every step. You're the real hero.
Hi Alex! I'm a 29 year old digital marketing professional that's working to pivot slightly into data analytics. I have Adult ADD so this stuff is really tough for me to get through but I have! I just finished the 3rd portfolio project and I'm looking forward to the next video which will be my first exposure to Python. Thank you for everything you're doing!! I really feel like I'm building a future thanks to you and educators like you.
Keep up the good work Walker!
Thank You So Much Sir, I was able to complete the first Phase of the Bootcamp, I'm still Amazed i did it, you were the first RUclipsr who made understand every video with any problem, I'll reference this video for My future Projects too.
Hi Alex, Thanks for creating this helpful video. Presently I am building my portfolio with these projects.
Just a Quick suggestion, change the data type of the SaleDate to date to show the date after updating the column.
query-
UPDATE real_estate SET SaleDate = CONVERT(date,SaleDate)
ALTER TABLE real_estate Alter column SaleDate date;
This worked for me! Thank you very much. You can test the data type of tables change by selecting this sytax,
Select * from INFORMATION_SCHEMA.COLUMNS where table_name = 'real_estate'
Again Thank you very much. I have gotten so much from this series. My confidence grows day by day. Lots of Love from Kenya Alex.
I have learnt so much from this Video... This for someone who worked in MSSQL alot during the early days of my software Dev career.... I need to do the ETL for sure
I have always found SQL less interactive compared to Excel and it has always bothered me. This beautiful content just reshaped my thought. Thank you so much Alex!
The recording might be 54 minutes long, but this doesn't account for all the rabbit holes you set me off into every time you introduce something new...Which is awesome! That's how precious these videos are, Alex. It's not just about the information you provide, but the lines of inquiry that emerge along the way. I just came back from a 30 minute quest for how to do window functions in R, now I can watch the rest of the video in peace (untill the next rabbit hole anyway lol)
Thank you, Alex, for all that you do. You're a saint
So glad to hear it was helpful!
🤣🤣 you want to talk about rabbit holes and speed bumps! It took me 7 HOURS to get through the FIRST video of this project! LMBO I have learned more from Alex the Analyst than I have through the Google certificate course! (I'm on the last part of that course) the first 3-4 courses in it are full of really good beginner information but after that they just seemed to fall apart for me. Anyways, I just wanted to stop in and say that I agree with you! Alex really is a saint!
Am so happy to be part of this.may God bless and reward you Mr Alex
I knew SQL before, but at last i understand what is all about; what is the comprehesive meaning of these data analitics; you put everything in context. Thank you Alex, you are a compass in this sometime complex informatic world.
This is super helpful for people like me who are trying to build a portfolio and don't know where to start and what to show. I'd like to see more projects in this series. However, these videos gave me a good idea on how to start. Thank you so much!
So glad to hear that! There will be more :)
this is by far one of the best data exploration videos I have ever watched, thank you Alex.
Alex, thank you so much for making these videos! Your videos have really helped me with my role. I just recently switched career and became a data analyst and I am so glad I found your videos. You explained everything in great details in a way that is easy to follow. Please keep making these portfolio videos :)
For the City, I did +2 in the CHARINDEX because of the space it put before the city. Saves me the trouble of having to trim it lately. Because if you start with the comma, you get a comma and a space.
Hi Alex, thank you so much for this Boot Camp I am on my journey to become a data analyst, and it is really an amazing playlist for those who wants to dive deep into the world of data. again thanks a lot for sharing your lifetime learning.
Thanks a million, dear Alex! This Portfolio Projects series is absolutely fantastic and so helpful for "newbies" like me. I know knowledge is a never-ending path but having someone like you on my side definitely makes the process faster, deeper and more pleasant. God bless you, bro!
Hi Victor,
Can you please help me out with the data?
I'm not able to download the data using the Github link provided by Alex.
Can you please share the xlsx via your Github or something?
Hey Alex, loving your data analyst bootcamp... learning tons. In the 1st step in the cleaning here, where we tidy up the saleDate an easier way to clean that up would be:
ALTER TABLE NashvilleHousing
ALTER COLUMN SaleDate Date
I am an absolute noob but I think the reason why it was not taking when using CONVERT or CAST is that the column is a Datetime data type.
Keep up the great content!
This is helpful. Thank you.
took me 5 days to complete sql part of tutorial and portofolio project. Thank you very very much alex
AWESOME, AWESOME, AWESOME! Thank you for taking the time to do this for all of us. Super inciteful and helpful. This has me doing things that I never would have otherwise done, and opening up possibilities for me to do more extensive things at work that will help me stand out. Kudos to you!
the self join move is actually so so smart
thank for your teachings, Alex. the table could also be altered using ;
alter table table_name
alter column column_name date
Done! Finally Done!! It's taken two separate attempts, but I finished this project. Thanks Alex, AWESOME video. FWIW, I initially had issues with the data file I downloaded. Not sure exactly what happened, but I ended up with a bunch of rogue data that was preventing a proper flat-file import to Edge-SQL using Azure Data Studio. I re-downloaded the file tonight and everything just worked. How sweet it is! On a side note, I hope you are having an excellent week. Cheers!😎 (ps. "LIKE" button smashed)
Thank you so much for this lesson, Prof. Alex! I have searched for other ways to convert Date type in a column, using ALTER COLUMN function.
ALTER TABLE NashvilleHousing
ALTER COLUMN SaleDate Date
SELECT SaleDate FROM NashvilleHousing
I’ve learned so much from your tutorials.
Alex, once Again, Thanks for your video, it has been very useful for me.
Stay tuned and keep Analysing. 😉😉
I'm just bummed that I didn't come across your channel sooner! Great content! Awesome SQL video. I have a couple years of experience using MS SQL server and I still found it very informative. Thanks so much!
A wonderful SQL Tutorial Alex! So glad you exist
Alex man you are doing a great job and using youtube to provide information and share your knowledge with us. I am so thankful
Thank you and thanks for watching!
I absolutely LOVE Alex's background commentary haha
Haha glad to hear it!
@@AlexTheAnalyst I wish you had someone to fulfill your request to play jeopardy music at 43:28 :D
Alex, I honestly appreciate your efforts.
I use DBeaver with SQL server. Here are my tips for importing Excel data:
- Using Google sheet for exporting CSV instead of Excel. All CSV files exported using Excel (Office 365) can't pass DBeaver importer!
- Open CSV file using text editor, find and delete '$' (around 7 results).
- Now the CSV can be imported smoothly in DBeaver :)
I just spent 2 hours struggling to upload the data to bigquery and I even manually wrote the schema and it still wasn't working and then I read your comment and it was incredibly helpful. Thank you!
Must say you're Doing a Great Job, Alex. Sending loads of Love all the way from India.
Sending love back from the Stated :D
30:40 Thanks for making us Understand even hard things in more detailed manner.
Update Completed it within 4 and half Hours straight although i wrote more comments in my query for better understanding and ease which took lil more than half hour lol.
Thanks Alex.
Thanks Alex for these kinda Projects. I am learning alot from these Projects which you are creating and I hope these will help me get into Data Analytics Field soon.
You're more than welcome! Super glad you find them helpful :D
I'm hearing the first few min of this thinking it's a wash bc I've already cleaned the data in xl to make it import, bahaha. Data Cleaning is easier & better in xl, so why do it in SQL? I know, I'll get there when the xl series starts! Thanks for showing us in case there's ever a time when it's better in SQL tho-- all good info!
Woo Hoo, I am really excited to watch your video and I just finished part 3/4, and I can't wait for part 4/4, may Alex always be given health, abundant sustenance, until video 4/4 can be posted.
Big fan of your work Alex... You're really doing an outstanding job!! Can't wait for the final part!!🙌
Thank you and thanks for watching! :D
What an excellent explanation!!
It is bcoj of u that I hv started believing I will become a Data Analyst soon..
You can do it!
Thnx for the motivation Alex 😇
It took me 2 weeks to marathon your SQL and Excel videos alternately. It was something unplanned but I end making a rough schedule to finish all of you Data Analyst Bootcamp playlist. Hopes tp see more amazing videossss from you in the future!!
were you able to download the dataset?
@@ugochukwudivine8151 yes, you can get the link from the description
I really enjoyed this episode. A lot did not work and so I had to learn different ways to get the job done. Very Educative
I have completed all the steps in portfolio project serie so far and learned a lot from practising it. Thank you very much!
Super glad to hear it!
BRUH, keep em coming big guy. I'm loving it. i started part 1 three days ago and i am now here on part 3. that is on top of my corporate finance course as well police legitimacy tier 3 elective. I am loving this series and loving SQL.
I will! So glad you're enjoying it! :D
I'm following this series for my Portfolio. Thank you so much! Your thought process helps me understand SQL better!
It is worth to do this project. For uploading excel file into SQL , I have made a copy of the excel file to 97-2003 format and selected 97-2003 in wizard. It worked. Just check if it is working or not!
Alex, thank you for including the brilliant technique of combining the SUBSTRING() and CHARINDEX() functions to split a column on a specified delimiting character. I was trying to do this on a personal project, and I could not figure it out!! PostgreSQL has the extremely handy SPLIT_PART function, but SSMS unfortunately does not make it that easy. But the use of CHARINDEX() inside of SUBSTRING() has solved my problem! Thank you again!!
That's awesome! So glad to hear it was applicable :)
Another superb project, thank u Mr Alex, You av bn of tremendous help to me.. Data Analysis is a new for me, it's something I just started considering, u have made my journey easy so far..Thank very much, always motivated each time I listen to you..
Great to hear!
This has really helped me advance my skills in sql , Thanks a million Alex 🙏
Hi Alex,
Today Only I have Seen Your portfolio Project Series, it is Amazing 👌👌
But
As a request, I am asking You please try to explain at least one project store procedure, ex: "like an extracting data and moving data staging server to data warehouse" Please don't skip, it is helpful to lots of people 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
As early as possible, please explain
You are the guy! Always insightful and inspiring! Thank you, Alex!
Another great tutorial! I'm really starting to get a better understanding of when to apply CTE's and Windows Functions.