Beginner
Data Science
SQL for Data Analysts
This comprehensive course will take you from beginner to confident practitioner in SQL for Data Analysts. You'll learn industry-standard techniques and best practices used by professionals worldwide.
Through hands-on projects and real-world examples, you'll gain the skills needed to succeed in today's competitive tech landscape. Our curriculum is designed by industry experts with years of experience.
By the end of this course, you'll have a portfolio of projects to showcase your abilities and the confidence to apply your knowledge in professional settings.
Course Syllabus
Week 1: Introduction & Setup
- Lesson 1: Set up Python for data work Preview 8min
- Lesson 2: Jupyter notebooks and workflows Preview 17min
- Lesson 3: NumPy arrays and vectorization 19min
- Lesson 4: Load datasets with Pandas 19min
- Lesson 5: Explore data with summary statistics 15min
Week 2: Core Concepts
- Lesson 1: Data science project workflow 24min
- Lesson 2: Visualize insights with charts 19min
- Lesson 3: Feature engineering basics 14min
Week 3: Hands-On Practice
- Lesson 1: Data science project workflow 21min
- Lesson 2: Visualize insights with charts 11min
- Lesson 3: Feature engineering basics 24min
- Lesson 4: Train a simple predictive model 16min
- Lesson 5: Evaluate model quality 23min
- Lesson 6: Communicate findings clearly 8min
Week 4: Intermediate Techniques
- Lesson 1: Data science project workflow 8min
- Lesson 2: Visualize insights with charts 22min
- Lesson 3: Feature engineering basics 10min
- Lesson 4: Train a simple predictive model 14min
- Lesson 5: Evaluate model quality 25min
Week 5: Advanced Topics
- Lesson 1: Data science project workflow 20min
- Lesson 2: Visualize insights with charts 16min
- Lesson 3: Feature engineering basics 14min
- Lesson 4: Train a simple predictive model 8min
- Lesson 5: Evaluate model quality 25min
- Lesson 6: Communicate findings clearly 19min