Learn SQL Beginner to Advanced in Under 4 Hours

  Рет қаралды 247,516

Alex The Analyst

Alex The Analyst

Күн бұрын

Пікірлер: 293
@joeychandel7808
@joeychandel7808 19 күн бұрын
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.
@amazingme894
@amazingme894 3 ай бұрын
Hey alex, please never die or delete your channel, I'm lost with what career to get after getting a useless degree and have no technical skills for a job, currently unemployed and living with aging mom, so I'm considering following your channel in the near future after i get over my mental slump. APPRECIATE YOU!!
@PythonArms
@PythonArms 3 ай бұрын
You will find something. Good luck. 😊
@yazz.huskies
@yazz.huskies 3 ай бұрын
Same, my degree for whatever reason did not include a SQL course. smh. Now I'm scrabbling to learn SQL
@nizzisnice5478
@nizzisnice5478 Ай бұрын
@@yazz.huskies yeah it’s almost like a degree is a piece of paper proving you wasted your time and money
@Nathaniel-codecity
@Nathaniel-codecity 3 ай бұрын
thank you so much for your free youtube course with your bootcamp, I'm now a data analytics instructor in Lagos, Nigeria.
@adeolafasina
@adeolafasina 3 ай бұрын
Good Evening Please, I want to start a career in data analytics and I will be glad if you can put me through what needs to be done in the right order thank you
@momohtimothy6898
@momohtimothy6898 3 ай бұрын
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-codecity
@Nathaniel-codecity 3 ай бұрын
@@momohtimothy6898 yeah
@Nathaniel-codecity
@Nathaniel-codecity 3 ай бұрын
@@momohtimothy6898 yeah my page check In
@Oseking_01
@Oseking_01 3 ай бұрын
@@momohtimothy6898are u interested in learning as well?
@palaceprincess
@palaceprincess 13 күн бұрын
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!
@zohraserhenova
@zohraserhenova 3 ай бұрын
Wow! I was just looking for a comprehensive SQL tutorial which was not 10 years old lol. Thank you! Right on time :)
@MwishaLudack
@MwishaLudack 3 ай бұрын
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
@Harold1526
@Harold1526 3 ай бұрын
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_687
@MR.JAM_687 3 ай бұрын
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 😅
@tdcode
@tdcode 2 ай бұрын
this is awesome. Christmas came early 🎄
@RohitGupta-ye3he
@RohitGupta-ye3he 3 ай бұрын
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-sd6fm
@Sankalp-sd6fm 3 ай бұрын
34:10 group by, order by 44:18 having vs where
@randomytnametonotshowrealname
@randomytnametonotshowrealname 3 ай бұрын
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.
@arthurleywin1832
@arthurleywin1832 3 ай бұрын
I just started your course and u dropped this, tnx mate
@lesliebenjamin5487
@lesliebenjamin5487 3 ай бұрын
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_63165
@Jennifer_63165 3 ай бұрын
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!!!!
@alexgraham3529
@alexgraham3529 8 күн бұрын
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.
@simonoganga9535
@simonoganga9535 3 ай бұрын
This is great Alex, keep doing the great things you are doing
@bhavadharini4631
@bhavadharini4631 2 ай бұрын
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? :(
@neelguru6562
@neelguru6562 3 ай бұрын
Hay Alex you made day. Love from india. God bless you for helping others.
@aaronmorrison7189
@aaronmorrison7189 3 ай бұрын
You dropped this King... 👑 (Thanks for this.)
@youthfulminds9498
@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.
@CristiPryor
@CristiPryor 3 ай бұрын
Honestly the best birthday gift. Thanks so much!
@tremolony4924
@tremolony4924 Ай бұрын
Happy birthday
@harshagiripragada7435
@harshagiripragada7435 2 ай бұрын
Felt sorry for Tom and Jerry😂!! But the tutorial was on point and absolutely clear. Thankyou Alex for educating!
@winstonsblues
@winstonsblues 13 күн бұрын
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!
@sandysyam2263
@sandysyam2263 3 ай бұрын
Thankyou Alex. your course really helpful, especially for me who has no background in coding, your explanation really understandable.
@jpg109
@jpg109 2 ай бұрын
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!
@ismailsalawu700
@ismailsalawu700 3 ай бұрын
I'm a simple man, I see a video from Alex, I click!
@Shanz-pt3fn
@Shanz-pt3fn 3 ай бұрын
Yay finally. I need it now more than anything.
@denniskirimi156
@denniskirimi156 3 ай бұрын
Thank you so much Alex. You dropped this at the right time! I believe it will start paying off some day
@DebzdaCeleb
@DebzdaCeleb 22 күн бұрын
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
@efrainperez257
@efrainperez257 3 ай бұрын
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
@blessingbukoye9282
@blessingbukoye9282 3 ай бұрын
Thank you for this, Alex
@RamkumarAmaldas
@RamkumarAmaldas Ай бұрын
Hi Alex, Thank you for provide the best effort about SQL , Awesome !!
@Trickst3rZer0
@Trickst3rZer0 3 ай бұрын
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
@hitthe21target Ай бұрын
atomics habits watch 30min follow along watch it again to understand and then do exercises on your own
@Leeta-i1f
@Leeta-i1f 2 ай бұрын
Hey man you done really great job. God bless u man.
@SA-oq2tv
@SA-oq2tv 8 күн бұрын
How are you so amazing? I don't think the internet can thank you enough for these videos...
@manishachaurasia
@manishachaurasia 2 ай бұрын
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?
@abcdaffaa
@abcdaffaa 2 ай бұрын
Is udemy free?
@bexcitement
@bexcitement 6 сағат бұрын
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
@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
@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
@dianacarns Ай бұрын
@@monaparisi8856 This worked for me! Thanks for the solution!
@IsmailHuismail
@IsmailHuismail Ай бұрын
Thanks for the tutorials
@ThePlaceUncovered
@ThePlaceUncovered 2 ай бұрын
Nice,,, following closely. unfortunately my triggers and events didnt work as yours lol... exact code at around 2:40:00
@AvatarKage
@AvatarKage 3 ай бұрын
This is a very well structured. Thanks!
@mervyndeanhilary2831
@mervyndeanhilary2831 9 күн бұрын
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?
@myboringdesktop
@myboringdesktop 29 күн бұрын
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
@juliencollins4041 24 күн бұрын
I also ran into this issue
@myboringdesktop
@myboringdesktop 24 күн бұрын
@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.
@mervyndeanhilary2831
@mervyndeanhilary2831 9 күн бұрын
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
@hibernate8517
@hibernate8517 3 ай бұрын
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-h1n
@khris-h1n 2 ай бұрын
Hey Alex! Thank you for the great videos. When downloading MySQL there is no option to switch to iOS. Is it located somewhere else?
@theschoolhackathon3258
@theschoolhackathon3258 3 ай бұрын
note if you're using a mac like me - you need to install my sql server, workbench, connectors, shell separately
@cant_sleeeep
@cant_sleeeep 2 ай бұрын
just use postgre
@khris-h1n
@khris-h1n 2 ай бұрын
Where did you find the URL to download the components?
@milanghale719
@milanghale719 Ай бұрын
this why i got a new pc
@davidsonkojoarhin4840
@davidsonkojoarhin4840 3 ай бұрын
It's here finally!
@RealEchos
@RealEchos 3 ай бұрын
it's always been here he just sandwiched his videos together
@زمالكاوى-ح7م
@زمالكاوى-ح7م 2 ай бұрын
I have an interview tomorrow afternoon and I hope this video will help me to be prepared 🙏🙏🙏
@sneak9407
@sneak9407 2 ай бұрын
How did the interview go?
@زمالكاوى-ح7م
@زمالكاوى-ح7م 2 ай бұрын
@@sneak9407 I passed the SQL part but failed in Python :((
@David-yi1hf
@David-yi1hf 11 күн бұрын
Thank you!!
@GiorgosVp
@GiorgosVp 3 ай бұрын
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-t9m
@RituPallavi-t9m 16 күн бұрын
Hi - Could you please explain why are we doing salary * 1.05 ?
@dheerajrdd83
@dheerajrdd83 Ай бұрын
Nice Video Course. Good. 👍👌
@santoshkiran5858
@santoshkiran5858 3 ай бұрын
Brilliant awesome super important ❤❤❤
@prateeksareen2438
@prateeksareen2438 26 күн бұрын
Today im starting this course jan 8 My goal is to finish this course in one week Day 1 32:23 jan 8
@mannpatel945
@mannpatel945 21 күн бұрын
any update ?
@PythonArms
@PythonArms 3 ай бұрын
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!
@BECLYogeshwariChilukamari
@BECLYogeshwariChilukamari 3 ай бұрын
Thank you so much Alex!!!
@nindogaming4132
@nindogaming4132 3 ай бұрын
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?
@TheHaagendazs0
@TheHaagendazs0 2 ай бұрын
Wild. Glad 😌 this exists.
@LinhHoang-ml1qo
@LinhHoang-ml1qo 3 ай бұрын
Thank you Alex
@JaphetAllah-ndiguim
@JaphetAllah-ndiguim 2 ай бұрын
very nice alex. big up Morroco
@AkinfelaBernard
@AkinfelaBernard 3 ай бұрын
Thanks for this You always deliver
@ghfix
@ghfix 2 ай бұрын
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)
@sittieainie9871
@sittieainie9871 29 күн бұрын
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.
@mervyndeanhilary2831
@mervyndeanhilary2831 2 күн бұрын
@alex do you know where I can join a community to practice SQL tasks.. using the learning from your video
@deeny447
@deeny447 3 ай бұрын
Thanks for this great video sir.
@DNS_Official69
@DNS_Official69 4 күн бұрын
Hello Sir, I'm not getting " developer default" option and it's not working even after selecting full mode. please help with that.
@gaganparangol1599
@gaganparangol1599 2 ай бұрын
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_99101
@Heisenberg_99101 26 күн бұрын
uninstall MySQL from your system completely. You can do this by search a "how to " on google. then install the whole thing again
@omotayoonike9825
@omotayoonike9825 18 күн бұрын
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.
@coolnarsim
@coolnarsim 3 ай бұрын
At 2.14 you have the option Developer default and you are selecting that option and proceeding. However, i don't see that option and am seeing the next four options . How should i proceed? Please advice
@pawek3523
@pawek3523 3 ай бұрын
You could proceed with custom and manually selecting server, shell, router and workbench.
@faisalyst7002
@faisalyst7002 9 күн бұрын
Please, is this course the same as the one uploaded 4 years ago (SQL Server Management Studio) in terms of core SQL concepts?
@consensus9
@consensus9 3 ай бұрын
Hi Alex, did you also explained the CREATE FUNCTION in this video?
@EchiroOda
@EchiroOda 18 күн бұрын
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...
@EchiroOda
@EchiroOda 18 күн бұрын
@AlexTheAnalyst
@Jennifer_63165
@Jennifer_63165 3 ай бұрын
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
@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
@TheArgamanv Ай бұрын
actually same O_O... Any solutions so far?
@anupamavaradarajan657
@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
@anupamavaradarajan657 Ай бұрын
Tried DBeaver, all rows are getting imported
@lucasgonzalezsonnenberg3204
@lucasgonzalezsonnenberg3204 24 күн бұрын
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?
@jnishag1877
@jnishag1877 6 күн бұрын
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
@akilprakash9715
@akilprakash9715 2 ай бұрын
Excellent❤
@rajashaw8501
@rajashaw8501 2 ай бұрын
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-kj7el
@David-kj7el 2 ай бұрын
Great teacher
@samyarkhanzadeh
@samyarkhanzadeh 3 ай бұрын
Hi Alex. Thanks a lot for your great channel. I just want to ask you something. I am now watching your Alex Data analytics boot camp in your KZbin channel. Should I also watch this SQL tutorial later or what I saw in your boot camp was enough? Again thanks a lot for your great channel
@samyarkhanzadeh
@samyarkhanzadeh 3 ай бұрын
It is really appreciated if you answer my question
@divyashreemahalingam7749
@divyashreemahalingam7749 3 ай бұрын
I think it's the same
@mulikinatisiddarthasiddu8245
@mulikinatisiddarthasiddu8245 3 ай бұрын
@@samyarkhanzadeh its the same
@brandondyer-smith4892
@brandondyer-smith4892 2 ай бұрын
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
@vrajparikh8630
@vrajparikh8630 13 күн бұрын
use modulo
@azwarmzafar
@azwarmzafar 3 ай бұрын
Hi Alex, I am currently taking Analyst builder SQL courses and in the middle of them. is this content same as them or its new shall i go through this too?
@AlexTheAnalyst
@AlexTheAnalyst 3 ай бұрын
No this does not go as in-depth as the AB course - that one is like 11 hours long with more advanced projects
@BeyondDeeWord
@BeyondDeeWord 3 ай бұрын
About to ask the same question. Both can be study, Thanks Alex.
@Zanab_Fatima
@Zanab_Fatima 3 ай бұрын
Hello dear sir how are you ? I want to ask, can I use replit for practice to become a good data analyst
@lucidboy9436
@lucidboy9436 Ай бұрын
bestt sql video on yt
@busaribilkis786
@busaribilkis786 26 күн бұрын
Please where can i download the mysql dataset, can't find it on his github
@tessalao5239
@tessalao5239 3 ай бұрын
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
@omotayoonike9825
@omotayoonike9825 18 күн бұрын
I have the same issue with insert
@loroda5375
@loroda5375 2 ай бұрын
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!
@arshin16
@arshin16 3 ай бұрын
hey Alex, thank you! isn´t the same account that you offer through your paid course?
@devgru4543
@devgru4543 3 ай бұрын
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-sd6fm
@Sankalp-sd6fm 3 ай бұрын
I am not getting developer default option 2:20 help string functions
@Nonkocy
@Nonkocy Ай бұрын
How did you resolve the issue?
@Nonkocy
@Nonkocy Ай бұрын
How did you resolve the issue
@Sankalp-sd6fm
@Sankalp-sd6fm Ай бұрын
I didnt actually went to some online runner
@juliencollins4041
@juliencollins4041 24 күн бұрын
@@Sankalp-sd6fm I also ran into this issue
@SaeedBarrie
@SaeedBarrie 3 ай бұрын
My guru Alex Freberg
@rnielvhinsieans.elpidama6935
@rnielvhinsieans.elpidama6935 3 ай бұрын
alex which one should i practice the MySQL or PostgreSQL?
@AA-kq8on
@AA-kq8on 3 ай бұрын
Thank you so much
@babygirlb123
@babygirlb123 3 ай бұрын
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
@thiagocosta527
@thiagocosta527 2 ай бұрын
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_6409
@_fayed_6409 2 ай бұрын
+1
@dianacarns
@dianacarns Ай бұрын
Hello, i am facing the same problem. Were you able to figure it out?
@TheArgamanv
@TheArgamanv Ай бұрын
Same, did you figure it out already?
@KenF777
@KenF777 27 күн бұрын
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.
@qm599
@qm599 3 ай бұрын
Thank you for this video, when I downloaded MYSQL, i don't have the developer set up. Can you point me to the right direction? or if i missed something. thank you.
@dilim83
@dilim83 2 ай бұрын
Same here. Have you been able to figure it out?
@TheReczz
@TheReczz 5 күн бұрын
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_YanIde
@Hesralli_YanIde 3 ай бұрын
I am not getting Create table and Insert Values in Dataset. Plz let me know how to download it. Thank you Alex in adavnce🤩
@shimasherafati5242
@shimasherafati5242 2 ай бұрын
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
@abhishekfarande9672 Ай бұрын
do select that option
@adhithyaraj7865
@adhithyaraj7865 21 күн бұрын
is this enough to become zero - intermediate or like a step to advance level of sql?
@Dxgreen
@Dxgreen 3 ай бұрын
Hey just wondering can I follow along using Azure SQL?
@AlexTheAnalyst
@AlexTheAnalyst 3 ай бұрын
It's in a Playlist on my channel :)
How I use SQL as a Data Analyst
15:30
Luke Barousse
Рет қаралды 863 М.
«Жат бауыр» телехикаясы І 26-бөлім
52:18
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 434 М.
ССЫЛКА НА ИГРУ В КОММЕНТАХ #shorts
0:36
Паша Осадчий
Рет қаралды 8 МЛН
Learn SQL In 60 Minutes
56:24
Web Dev Simplified
Рет қаралды 2,2 МЛН
8 Rules For Learning to Code in 2025...and should you?
12:59
Travis Media
Рет қаралды 295 М.
Data Manipulation in SQL   Full Course
48:07
Code Path
Рет қаралды 471
Learn 12 Basic SQL Concepts in 15 Minutes (project files included!)
16:48
SQL Tutorial - Full Database Course for Beginners
4:20:39
freeCodeCamp.org
Рет қаралды 19 МЛН
SQL Course for Beginners [Full Course]
3:10:19
Programming with Mosh
Рет қаралды 12 МЛН
How I Would Become a Data Analyst In 2025 (if I had to start over again)
15:40
Avery Smith | Data Analyst
Рет қаралды 152 М.
SQL Beginner to Advanced in One Hour | CareerFoundry Webinar
1:08:28
Alex The Analyst
Рет қаралды 231 М.
«Жат бауыр» телехикаясы І 26-бөлім
52:18
Qazaqstan TV / Қазақстан Ұлттық Арнасы
Рет қаралды 434 М.