DAT
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.\\n\\nThrough 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.\\n\\nBy 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: DataFrames Explained Preview 8min
- Lesson 2: Statistical Analysis Explained Preview 17min
- Lesson 3: Statistical Analysis Explained 19min
- Lesson 4: Understanding Visualization 19min
- Lesson 5: Cleaning Explained 15min
Week 2: Core Concepts
- Lesson 1: Working with ETL 24min
- Lesson 2: Building ETL 19min
- Lesson 3: Introduction to DataFrames 14min
Week 3: Hands-On Practice
- Lesson 1: Building Cleaning 21min
- Lesson 2: Working with Visualization 11min
- Lesson 3: Practical DataFrames 24min
- Lesson 4: Introduction to Cleaning 16min
- Lesson 5: Building Statistical Analysis 23min
- Lesson 6: Hands-On DataFrames 8min
Week 4: Intermediate Techniques
- Lesson 1: Working with Cleaning 8min
- Lesson 2: Cleaning Explained 22min
- Lesson 3: Cleaning Explained 10min
- Lesson 4: Cleaning Best Practices 14min
- Lesson 5: Working with Visualization 25min
Week 5: Advanced Topics
- Lesson 1: Deep Dive into Visualization 20min
- Lesson 2: Visualization Fundamentals 16min
- Lesson 3: Advanced DataFrames Techniques 14min
- Lesson 4: Hands-On DataFrames 8min
- Lesson 5: Statistical Analysis Fundamentals 25min
- Lesson 6: Understanding Statistical Analysis 19min