Timestamps 00:03 - Learn SQL fundamentals and advanced techniques through practical exercises. 01:52 - Installing MySQL with Developer Default Setup. 05:27 - Completing MySQL configuration and starting the local instance. 07:12 - Creating a sample database for SQL practice. 11:14 - Understanding the SELECT statement in MySQL for querying data. 13:11 - Understanding SQL query execution and database selection best practices. 17:24 - Understanding the order of operations in SQL calculations. 19:27 - Understanding unique values and distinct queries in SQL. 23:12 - Understanding salary comparison operators in SQL queries. 25:17 - Filtering data using 'not equal' and logical operators in SQL. 29:23 - The LIKE statement allows for pattern matching in SQL queries. 31:36 - Using wildcards in SQL for flexible string matching. 35:29 - Understanding non-aggregated columns in SQL grouping. 37:25 - Learn to group data by occupation and salary using SQL. 41:26 - Understanding SQL ordering by multiple columns impacts output results. 43:22 - Understand the risks of using column positions in SQL queries. 47:25 - Understanding SQL HAVING clause and LIMIT for data filtering. 49:18 - Understanding SQL aliasing for clearer query outputs. 53:08 - Joining tables with INNER JOIN requires specifying ambiguous column names. 55:07 - Using aliases simplifies SQL queries for better readability. 58:53 - Explains SQL joins: Left, Right, and Self Joins with practical examples. 1:00:46 - Understanding table joins and employee ID assignment in SQL. 1:04:49 - Understanding reference tables and joining in SQL. 1:06:49 - Using joins to tie multiple SQL tables together effectively. 1:10:35 - Using UNION to combine query results from different tables. 1:12:38 - Filtering and labeling employees based on salary and gender criteria. 1:16:40 - Data cleaning techniques include ensuring length and standardizing case. 1:18:31 - Learn string manipulation functions in SQL, including trim, left, right, and substring. 1:22:13 - Utilizing substring and replace functions for effective data extraction. 1:24:09 - Learn to use SQL functions for text manipulation. 1:27:55 - Using CASE statements to categorize age groups in SQL queries. 1:29:53 - Calculate pay increases and bonuses based on employee salaries. 1:34:13 - Learn to use CASE statements and subqueries for SQL logic and calculations. 1:36:15 - Using subqueries to filter employee demographics based on department IDs. 1:40:21 - Calculating the overall average salary from the employee data. 1:42:25 - Understanding SQL table naming and aggregations with examples. 1:46:18 - Comparing group by and window functions in SQL for salary analysis. 1:48:19 - Calculating average salary with and without partitioning by gender. 1:52:45 - Understanding rolling totals and window functions in SQL. 1:54:34 - Row numbering and partitioning in SQL helps organize data uniquely. 1:58:33 - Understanding Row Number, Rank, and Dense Rank in SQL. 2:00:20 - Using Common Table Expressions (CTE) improves SQL query readability and functionality. 2:04:04 - Common Table Expressions (CTEs) allow temporary data representation without storage. 2:06:18 - Combining data from common table expressions using SQL joins. 2:10:12 - Creating and using temporary tables in SQL. 2:12:09 - Creating and using temporary tables in SQL effectively. 2:16:08 - Understanding advanced CTEs and the creation of stored procedures. 2:18:00 - Created and executed a stored procedure successfully. 2:21:45 - Understanding stored procedures and best practices in SQL. 2:23:46 - Creating and managing stored procedures in SQL. 2:27:18 - Parameter naming conventions enhance SQL readability. 2:29:02 - Using triggers to automatically update related tables in SQL. 2:32:48 - Understanding SQL triggers for automated data insertion. 2:34:51 - Using triggers in SQL to automate actions on data changes. 2:38:38 - Creating an event to retire employees over 60 automatically. 2:40:37 - Creating and troubleshooting SQL events for data deletion. 2:44:04 - Learn how to import data into a new SQL table. 2:45:44 - Overview of data cleaning steps using a layoffs dataset. 2:49:31 - Ensure data integrity by removing duplicates in a staging database. 2:51:13 - Using SQL to identify duplicate entries with ROW_NUMBER() function. 2:55:21 - Removing duplicates in MySQL involves different strategies than in SQL Server. 2:57:08 - Creating and populating SQL tables with data and filtering rows. 3:01:17 - Learn how to update SQL tables and manage preferences for safe updates. 3:03:10 - Standardize industry labels for accurate data analysis. 3:07:20 - Fixing data issues in SQL by trimming unwanted characters. 3:09:33 - Updating country data and converting text to date format. 3:13:22 - Updating and formatting date columns in SQL. 3:15:11 - Modifying data types and handling null values in SQL. 3:19:28 - Updating travel industry data using SQL joins. 3:21:24 - Identifying companies with missing and non-null industry data. 3:25:42 - Resolved issues with null values in SQL queries for company layoffs. 3:27:47 - Cleaning data is crucial for accurate analysis of layoffs. 3:31:35 - Data cleaning is essential for effective exploratory data analysis. 3:33:17 - The basics of analyzing layoffs data using SQL. 3:37:13 - Analyzing employee layoffs among major companies from 2020 to 2023. 3:39:10 - Analysis of job layoffs by industry and country during COVID-19. 3:43:09 - Analyzing post-IPO layoffs and their implications. 3:45:04 - Calculating monthly rolling totals for layoffs using SQL. 3:49:12 - Creating a rolling total for layoffs by month in SQL. 3:51:18 - Job layoffs significantly increased from 2020 to 2023 globally. 3:55:07 - Ranking companies by employee layoffs over the years using SQL. 3:57:09 - Analyze company layoffs over the years using SQL ranking functions. 4:01:34 - Recap of complex SQL query using CTEs for analyzing layoffs. 4:03:25 - Explore advanced SQL projects and enhance your portfolio with real data analysis.
@amazingme8943 ай бұрын
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!!
@PythonArms3 ай бұрын
You will find something. Good luck. 😊
@yazz.huskies3 ай бұрын
Same, my degree for whatever reason did not include a SQL course. smh. Now I'm scrabbling to learn SQL
@nizzisnice5478Ай бұрын
@@yazz.huskies yeah it’s almost like a degree is a piece of paper proving you wasted your time and money
@Nathaniel-codecity3 ай бұрын
thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.
@adeolafasina3 ай бұрын
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
@momohtimothy68983 ай бұрын
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?
@Nathaniel-codecity3 ай бұрын
@@momohtimothy6898 yeah
@Nathaniel-codecity3 ай бұрын
@@momohtimothy6898 yeah my page check In
@Oseking_013 ай бұрын
@@momohtimothy6898are u interested in learning as well?
@palaceprincess13 күн бұрын
This video SAVED ME. Yesterday I knew nothing about SQL (mind you, I am a biochemist with limited coding background). Had a technical job interview today that required me to write queries in SQL and I aced it, all thanks to this tutorial!
@zohraserhenova3 ай бұрын
Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)
@MwishaLudack3 ай бұрын
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
@Harold15263 ай бұрын
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!
@MR.JAM_6873 ай бұрын
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 😅
@tdcode2 ай бұрын
this is awesome. Christmas came early 🎄
@RohitGupta-ye3he3 ай бұрын
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 :)
@Sankalp-sd6fm3 ай бұрын
34:10 group by, order by 44:18 having vs where
@randomytnametonotshowrealname3 ай бұрын
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.
@arthurleywin18323 ай бұрын
I just started your course and u dropped this, tnx mate
@lesliebenjamin54873 ай бұрын
HELP: Any idea where in GitHub I can get the stored procedure to run and create the db? Which section is it on please?
@Jennifer_631653 ай бұрын
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!!!!
@alexgraham35298 күн бұрын
Nearing the end of this as a refresher, not a SQL admin by any stretch but been great to remind myself due to being an Solution Arch of all these data aspects to a solution which allows me to have enough of an understanding when speaking with engineers, especially when my background before cloud was really Infra ( I'll build you a datacentre ). Thanks for the effort Alex.
@simonoganga95353 ай бұрын
This is great Alex, keep doing the great things you are doing
@bhavadharini46312 ай бұрын
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? :(
@neelguru65623 ай бұрын
Hay Alex you made day. Love from india. God bless you for helping others.
@aaronmorrison71893 ай бұрын
You dropped this King... 👑 (Thanks for this.)
@youthfulminds9498Ай бұрын
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.
@CristiPryor3 ай бұрын
Honestly the best birthday gift. Thanks so much!
@tremolony4924Ай бұрын
Happy birthday
@harshagiripragada74352 ай бұрын
Felt sorry for Tom and Jerry😂!! But the tutorial was on point and absolutely clear. Thankyou Alex for educating!
@winstonsblues13 күн бұрын
I am getting way more duplicates out of the layoffs table than Alex. He's getting like 6, and I'm getting 1000 results. I'm using all the same partitions he is!
@sandysyam22633 ай бұрын
Thankyou Alex. your course really helpful, especially for me who has no background in coding, your explanation really understandable.
@jpg1092 ай бұрын
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!
@ismailsalawu7003 ай бұрын
I'm a simple man, I see a video from Alex, I click!
@Shanz-pt3fn3 ай бұрын
Yay finally. I need it now more than anything.
@denniskirimi1563 ай бұрын
Thank you so much Alex. You dropped this at the right time! I believe it will start paying off some day
@DebzdaCeleb22 күн бұрын
I would love to do this but I have a MAC M3 and there is no option in the drop with the link you provided. I did find what i think is the MAC download but none of what yours displays shows when i download mine. So confusing
@efrainperez2573 ай бұрын
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
@blessingbukoye92823 ай бұрын
Thank you for this, Alex
@RamkumarAmaldasАй бұрын
Hi Alex, Thank you for provide the best effort about SQL , Awesome !!
@Trickst3rZer03 ай бұрын
I am a bit confused, should we follow along? take notes? both? how should we move with you as you teach us each section?
@hitthe21targetАй бұрын
atomics habits watch 30min follow along watch it again to understand and then do exercises on your own
@Leeta-i1f2 ай бұрын
Hey man you done really great job. God bless u man.
@SA-oq2tv8 күн бұрын
How are you so amazing? I don't think the internet can thank you enough for these videos...
@manishachaurasia2 ай бұрын
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?
@abcdaffaa2 ай бұрын
Is udemy free?
@bexcitement6 сағат бұрын
Question: for the UNION section when you are doing the age and pay union, why were Leslie and Chris returned multiple times even though UNION is distinct be default? Thanks in advance for the guidance and appreciate this course!
@TheArgamanvАй бұрын
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?
@monaparisi8856Ай бұрын
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
@dianacarnsАй бұрын
@@monaparisi8856 This worked for me! Thanks for the solution!
@IsmailHuismailАй бұрын
Thanks for the tutorials
@ThePlaceUncovered2 ай бұрын
Nice,,, following closely. unfortunately my triggers and events didnt work as yours lol... exact code at around 2:40:00
@AvatarKage3 ай бұрын
This is a very well structured. Thanks!
@mervyndeanhilary28319 күн бұрын
Thank you Alex, this has been quite easy and sweet. After I ran the multiple queries to be triggered, I noticed it returned two output in the employee_demographics and employee_salary. One with the new value and rows with the inputs and null rows. How do I correct that?
@myboringdesktop29 күн бұрын
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?
@juliencollins404124 күн бұрын
I also ran into this issue
@myboringdesktop24 күн бұрын
@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.
@mervyndeanhilary28319 күн бұрын
2:52:34 the output on the layoffs_staging has different row_num on my SQL code which I ran.. Instead of 1,1,1,1,1 its 1,2,3,4
@hibernate85173 ай бұрын
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 ?
@khris-h1n2 ай бұрын
Hey Alex! Thank you for the great videos. When downloading MySQL there is no option to switch to iOS. Is it located somewhere else?
@theschoolhackathon32583 ай бұрын
note if you're using a mac like me - you need to install my sql server, workbench, connectors, shell separately
@cant_sleeeep2 ай бұрын
just use postgre
@khris-h1n2 ай бұрын
Where did you find the URL to download the components?
@milanghale719Ай бұрын
this why i got a new pc
@davidsonkojoarhin48403 ай бұрын
It's here finally!
@RealEchos3 ай бұрын
it's always been here he just sandwiched his videos together
@زمالكاوى-ح7م2 ай бұрын
I have an interview tomorrow afternoon and I hope this video will help me to be prepared 🙏🙏🙏
@sneak94072 ай бұрын
How did the interview go?
@زمالكاوى-ح7م2 ай бұрын
@@sneak9407 I passed the SQL part but failed in Python :((
@David-yi1hf11 күн бұрын
Thank you!!
@GiorgosVp3 ай бұрын
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 .
@RituPallavi-t9m16 күн бұрын
Hi - Could you please explain why are we doing salary * 1.05 ?
@dheerajrdd83Ай бұрын
Nice Video Course. Good. 👍👌
@santoshkiran58583 ай бұрын
Brilliant awesome super important ❤❤❤
@prateeksareen243826 күн бұрын
Today im starting this course jan 8 My goal is to finish this course in one week Day 1 32:23 jan 8
@mannpatel94521 күн бұрын
any update ?
@PythonArms3 ай бұрын
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!
@BECLYogeshwariChilukamari3 ай бұрын
Thank you so much Alex!!!
@nindogaming41323 ай бұрын
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?
@TheHaagendazs02 ай бұрын
Wild. Glad 😌 this exists.
@LinhHoang-ml1qo3 ай бұрын
Thank you Alex
@JaphetAllah-ndiguim2 ай бұрын
very nice alex. big up Morroco
@AkinfelaBernard3 ай бұрын
Thanks for this You always deliver
@ghfix2 ай бұрын
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)
@sittieainie987129 күн бұрын
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.
@mervyndeanhilary28312 күн бұрын
@alex do you know where I can join a community to practice SQL tasks.. using the learning from your video
@deeny4473 ай бұрын
Thanks for this great video sir.
@DNS_Official694 күн бұрын
Hello Sir, I'm not getting " developer default" option and it's not working even after selecting full mode. please help with that.
@gaganparangol15992 ай бұрын
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
@Heisenberg_9910126 күн бұрын
uninstall MySQL from your system completely. You can do this by search a "how to " on google. then install the whole thing again
@omotayoonike982518 күн бұрын
I had the same issues i can't remember the youtube channel i watch but basically after uninstall mysql on your system you will need to check all your folder and files then delete mysql file in the folder they are hiding in about 4 or 5 file in the system. It's only they thelat you can create a new password. It took my about an hour to find those mysql file which are hiding in the folder. Just make sure you check all the folders and files in your system.
@coolnarsim3 ай бұрын
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
@pawek35233 ай бұрын
You could proceed with custom and manually selecting server, shell, router and workbench.
@faisalyst70029 күн бұрын
Please, is this course the same as the one uploaded 4 years ago (SQL Server Management Studio) in terms of core SQL concepts?
@consensus93 ай бұрын
Hi Alex, did you also explained the CREATE FUNCTION in this video?
@EchiroOda18 күн бұрын
Hello sir .. I have a small issue with trigger... On creating a trigger there is no problem but after that like when u click to show trigger on table it's either hidden or empty but it shows on show trigger... Also when I try to insert data in the salary table it shows error like employee_id doesn't exist on employee demographics which is false it actually has...
@EchiroOda18 күн бұрын
@AlexTheAnalyst
@Jennifer_631653 ай бұрын
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!!!!
@anupamavaradarajan657Ай бұрын
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Ай бұрын
actually same O_O... Any solutions so far?
@anupamavaradarajan657Ай бұрын
@@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.
@anupamavaradarajan657Ай бұрын
Tried DBeaver, all rows are getting imported
@lucasgonzalezsonnenberg320424 күн бұрын
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?
@jnishag18776 күн бұрын
Right! I am lost too. I can’t locate that file so not able to follow. I already downloaded GitHub but I’m list after that
@akilprakash97152 ай бұрын
Excellent❤
@rajashaw85012 ай бұрын
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
@David-kj7el2 ай бұрын
Great teacher
@samyarkhanzadeh3 ай бұрын
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
@samyarkhanzadeh3 ай бұрын
It is really appreciated if you answer my question
@divyashreemahalingam77493 ай бұрын
I think it's the same
@mulikinatisiddarthasiddu82453 ай бұрын
@@samyarkhanzadeh its the same
@brandondyer-smith48922 ай бұрын
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
@vrajparikh863013 күн бұрын
use modulo
@azwarmzafar3 ай бұрын
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?
@AlexTheAnalyst3 ай бұрын
No this does not go as in-depth as the AB course - that one is like 11 hours long with more advanced projects
@BeyondDeeWord3 ай бұрын
About to ask the same question. Both can be study, Thanks Alex.
@Zanab_Fatima3 ай бұрын
Hello dear sir how are you ? I want to ask, can I use replit for practice to become a good data analyst
@lucidboy9436Ай бұрын
bestt sql video on yt
@busaribilkis78626 күн бұрын
Please where can i download the mysql dataset, can't find it on his github
@tessalao52393 ай бұрын
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
@omotayoonike982518 күн бұрын
I have the same issue with insert
@loroda53752 ай бұрын
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!
@arshin163 ай бұрын
hey Alex, thank you! isn´t the same account that you offer through your paid course?
@devgru45433 ай бұрын
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.
@Sankalp-sd6fm3 ай бұрын
I am not getting developer default option 2:20 help string functions
@NonkocyАй бұрын
How did you resolve the issue?
@NonkocyАй бұрын
How did you resolve the issue
@Sankalp-sd6fmАй бұрын
I didnt actually went to some online runner
@juliencollins404124 күн бұрын
@@Sankalp-sd6fm I also ran into this issue
@SaeedBarrie3 ай бұрын
My guru Alex Freberg
@rnielvhinsieans.elpidama69353 ай бұрын
alex which one should i practice the MySQL or PostgreSQL?
@AA-kq8on3 ай бұрын
Thank you so much
@babygirlb1233 ай бұрын
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
@thiagocosta5272 ай бұрын
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!
@_fayed_64092 ай бұрын
+1
@dianacarnsАй бұрын
Hello, i am facing the same problem. Were you able to figure it out?
@TheArgamanvАй бұрын
Same, did you figure it out already?
@KenF77727 күн бұрын
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.
@qm5993 ай бұрын
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.
@dilim832 ай бұрын
Same here. Have you been able to figure it out?
@TheReczz5 күн бұрын
Hi i am facing issues when importing the layoffs.csv file as it only imports 500 something records and not all of the records that is 2000 ones, can somebody please let me know what is the issue i am facing, cause i really want to practice the data cleaning project.
@Hesralli_YanIde3 ай бұрын
I am not getting Create table and Insert Values in Dataset. Plz let me know how to download it. Thank you Alex in adavnce🤩
@shimasherafati52422 ай бұрын
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
@abhishekfarande9672Ай бұрын
do select that option
@adhithyaraj786521 күн бұрын
is this enough to become zero - intermediate or like a step to advance level of sql?
@Dxgreen3 ай бұрын
Hey just wondering can I follow along using Azure SQL?