16-Week Data Science & Database Roadmap
Week 1: Python Basics
Install Python & Jupyter Notebook. Learn variables, loops, conditionals, functions. Build a simple calculator.
Week 2: SQL & Relational Databases
Understand databases. Learn basic SQL: SELECT, INSERT, UPDATE, DELETE, WHERE.
Week 3: Intermediate SQL + Joins
Learn joins (INNER, LEFT, RIGHT), GROUP BY, ORDER BY, and aggregation functions.
Week 4: Python + Pandas
Use Pandas to read CSV files, filter, and sort data. Start a basic data analysis project.
Week 5: Database Design
Learn about data normalization, primary and foreign keys, and relationships between tables.
Week 6: Data Visualization
Create graphs using Matplotlib and Seaborn. Visualize real datasets (Netflix, sales, etc).
Week 7: Advanced SQL
Practice subqueries, views, indexing, and transaction concepts (ACID).
Week 8: Python + Pandas Project
Clean and analyze a dataset. Perform EDA and create visualizations.
16-Week Data Science & Database Roadmap
Week 9: Basic Statistics
Study mean, median, mode, standard deviation, and basic probability.
Week 10: Intro to Machine Learning
Learn about supervised/unsupervised learning, linear regression, and model evaluation.
Week 11: Classification Models
Study decision trees, k-NN, and evaluate models using accuracy and confusion matrix.
Week 12: Mini ML Project
Predict housing prices or classify data. Build and evaluate a simple ML model.
Week 13: Learn NoSQL
Install MongoDB. Learn to store and query document-based data. Compare with SQL.
Week 14: Web + DB Integration
Build a simple Flask app with database support. Query and display data on a web page.
Week 15: Model Deployment
Use Streamlit to create a simple ML web app and deploy it on a platform.
Week 16: Capstone Project
Do a complete project: data cleaning, visualization, modeling, and deployment.
