Dive Into SQL Data Analysis: Full Portfolio Project

Take your SQL data analysis skills to the next level with this full portfolio project. In just 1 hour, you'll dive into an end-to-end SQL project that will showcase your practical skills in data analysis. Perfect for beginners and experienced data analysts alike! GIT HUB Download Data : https://github.com/datacharmer/test_db Link 2 : https://github.com/shubhamringole/employees Questions and Solution :https://medium.com/@singole/10-questions-for-an-employees-dataset-project-in-mysql-6b529576f819 Playlist Name: Learn SQL Complete Guide https://youtube.com/playlist?list=PLSFRPxOkWfFBKeFXsKGhU17OCLz_yzelm&si=iFJgTgbzlWelkIZA Medium Blog -https://medium.com/@singole/understanding-sql-common-table-expressions-ctes-8178d3f431a5 Description for Playlist: Welcome to the "SQL Mastery: From Basics to Advanced" playlist! This series is designed to take you from a complete beginner to a proficient SQL user. Whether you're looking to learn SQL for data analysis, database management, or enhancing your development skills, this playlist has you covered. 🎓 What You Will Learn: The fundamentals of SQL and relational databases Essential SQL commands for data manipulation and querying Advanced SQL techniques for filtering, sorting, and joining tables Practical applications of SQL in various industries Step-by-step tutorials on using SQL tools and software 🔗 Videos in this Playlist: 1. Introduction to SQL Learn to Query Databases Like a Pro https://www.youtube.com/watch?v=K49-QaA2Eg4 2.How to Install MySQL Workbench - A step-by-step guide on downloading, installing, and setting up MySQL Workbench. https://youtu.be/SzM3zNLUN1Q 3.SQL Fundamentals: Data Types, Keys, and Constraints https://youtu.be/7mVoPTBEEFQ 4.SQL Table Operations : Create, Delete, Drop, Truncate, and Alter | Lesson 4 | Introduction to SQL https://youtu.be/nRvrLPbFBZU 5.SELECT Statement | WHERE Clause with Examples and Operators in SQL |Lesson 5 | Introduction to SQL https://youtu.be/HRgmAt0sOT8 6.How to Import an Excel CSV File into MySQL A Step by Step Guide| Lesson 4 | Introduction to SQL https://youtu.be/LJ4xjNi4ZA4 7.Mastering SQL GROUP BY and HAVING Clauses Explained https://www.youtube.com/watch?v=0mZGT_7UH3A&list=PLSFRPxOkWfFBKeFXsKGhU17OCLz_yzelm&index=7 8.Mastering SQL JOINs: Complete Guide with Examples | INNER & LEFT JOIN Lesson 8 | Introduction to SQL https://www.youtube.com/watch?v=xplv8r9YXuc 9. Right Join, Cross Join, and Outer Join Explained | Lesson 9 | Introduction to SQL https://youtu.be/EdZ2OqyLTuA 10.SQL Subqueries Explained: Unlock Advanced Querying Techniques https://youtu.be/O-HZrJAuro0 Timecodes 00:00 Intro 01:26 Channel Intro 01:35 Importing the Data into MYSQL 08:31 List of Employees by Department 17:16 Current and past Salary of Employees 19:47 Employees with specific Titles 25:39 Departments with their managers 30:16 Employees count by Department 34:58 Employees Birthdates in a given Year 38:19 Employees Hired in last 50 years 43:05 Average salary by Department 47:53 Gender Distribution in Each Department 53:06 Longest Serving Employees 57:26 Creating GitHub Repository 58: 20 Uploading Data Medium: https://medium.com/@singole Instagram: https://www.instagram.com/analystmind?igsh=MTQ0anNoZzFmb2VucA== Thank you for watching and happy querying! 👍 Don’t Forget to Like, Comment, and Subscribe! Hit the bell icon 🔔 to get notified about new tutorials. Leave a comment below each video if you have any questions or suggestions for future content. #sql #cte #recursive #rowsbetween sql window functions, sql deep dive, mysql, sql rows