In this video we will do an end to end data analytics project using python and SQL. We will use Kaggle API to download the dataset and to data processing and cleaning using pandas and load the data into sql server. Lastly we will answer some interesting questions using SQL.
github link:
github.com/ankitbansal6/data_analytics_project/
Data Analytics high quality content: namastesql.com/
Zero to hero(Advance) SQL Aggregation:
youtu.be/5Ighj_2PGV0
Most Asked Join Based Interview Question:
youtu.be/xR87ctOgpAE
Solving 4 Trick SQL problems:
youtu.be/Ck1gQrlS5pQ
Data Analyst Spotify Case Study:
youtu.be/-YdAIMjHZrM
Top 10 SQL interview Questions:
youtu.be/Iv9qBz-cyVA
Interview Question based on FULL OUTER JOIN:
youtu.be/KQfWd6V3IB8
Playlist to master SQL :
youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb
Rank, Dense_Rank and Row_Number:
youtu.be/xMWEVFC4FOk
#sql #dataengineer #datanalysis #dataanalytics
- End to End Data Analytics Project (Python + SQL) ( Download)
- Netflix Data Cleaning and Analysis Project | End to End Data Engineering Project (SQL + Python) ( Download)
- End-to-End Data Analysis Project 2024 | SQL & Power BI | Beginner Friendly ( Download)
- Absolute beginner Data Analytics full portfolio project | Soft-skill, SQL, Python, Tableau, Power BI ( Download)
- BEST END TO END DATA ANALYTICS PORTFOLIO PROJECT | TABLEAU & PYTHON ( Download)
- SQL Data Analytics Project (PART 1) | Data Analyst Portfolio Project ( Download)
- 5 Projects for a Data Analyst Job | All Materials Included ( Download)
- Data Analytics Roadmap: Data Analytics End to End Project Pipeline ( Download)
- How to connect MySQL with Python- | Connector Psycopg2, MySQL Connector |PostgreSQL #Day 25 Python ( Download)
- Data Analyst Full Project for Portfolio using Python & SQL | ( Download)
- Data Analyst Portfolio Project | SQL Data Exploration | Project 1/4 ( Download)
- 5 Unique Python Project Ideas for Your Resume | Python Projects for Beginners to Advanced ( Download)
- End to End Data Analytics Project | Power BI Project | Hospitality Domain ( Download)
- 10 PORTFOLIO PROJECTS TO ADD TO YOUR DATA PORTFOLIO ( Download)
- Data Analyst Portfolio Project - SQL | Step-by-Step Guide From SQL Database to Interactive Dashboard ( Download)
