Mass Layoffs Analysis 2023 | SQL Project | SQL Tutorial | Google BigQuery | IvyProSchool
In this Bootcamp session you will learn how to run SQL commands on Google BigQuery. Analyse the Layoffs Data for 2022-23 and learn how SQL can help you to analyse and extract insights from a dataset. Learn basic SQL Queries, SQL alias, Group by, order by function, and how to use them to solve the questions around the current layoffs happening around the globe.
Data set - https://docs.google.com/spreadsheets/...
Introduction - 00:00
Understanding the Layoffs Data Set - 2:22
What is SQL? - 3:36
SQL Vs Excel - 4:55
Some famous DBMS used in the industry - 5:47
How do we go to Google cloud? - 7:48
How to load data in Google BigQuery platform? - 9:22
Basic SQL commands - 27:38
Total number of people laid off in USA - 37:32
Data Aggregation at Country level using Group by function - 40:50
Top 3 Countries in terms of layoffs - 42:01
Analysing the layoffs in Finance and Education industries - 43:51
Analysing the industries with at least 10,000 layoffs - 45:30
Month(s) with most number of layoffs - 47:49
Questions to be practised - 51:07
Curriculum at Ivy Pro School - 52:49
Conclusion - 53:10
#googlebigquery #layoffdataanalysisusingsql #sqlqueries
❓Interested in a Data Science or Data Engineering career? Check out the Ivy Pro School’s top ranked Nascomm, Govt. of India and IBM accredited Data Science and Data Engineering courses: https://ivyproschool.com/
❓Why should you learn Data Science today? • Future Of Analytics & Data Science | ...
❓Are you a Fresher? Watch this video to know the Data Science Journey for Freshers: • Data Science Journey for Freshers | D...
✅Don’t forget to Subscribe to Ivy Pro School’s YouTube Channel: / @ivyproschool
✅Learn from Ivy Pro School’s Data Science and Data Engineering Students’ Success Stories : • Student Success Story
Liked the video? Check out below more playlists on Data Science and Data Engineering learning tutorial, alumni interview experiences, live data science case studies,etc:
⏩Students Share Interview Experiences- • Data Science Interview Experience and...
⏩Data Cleaning using excel- • Data Cleaning using Excel
⏩SQL Interview questions solved in Hindi - • Sql Interview Questions solved in Hindi
⏩PowerBI Tutorials - • Power BI Tutorial
⏩Industry case studies and projects by students - • Industry Case Studies & Projects by S...
⏩Data Science for Beginners - • Data Science for Beginners
⏩Excel VBA tutorial - • Excel VBA Tutorial
⏩Excel Tutorials by Eeshani Agrawal - • Excel for Beginners
⏩Tableau Tutorials by Eeshani Agrawal - • Tableau Tutorial by Eeshani Agrawal
For more updates on courses and tips don’t forget to follow us on:
Instagram: / ivyproschool
LinkedIn: / ivy-professional-school
Facebook: / ivyproschool
Twitter: / ivyproschool
Telegram: https://t.me/learndswithexperts
Want to take a Data Science Course with Ivy Professional School - visit us at https://ivyproschool.com You can call us at +91-7676882222 or mail to [email protected].
#datawithivy #livebootcamp