About Course
This course provides a practical and structured approach to learning data science using modern industry tools and workflows. Learners will build skills in Python, SQL, statistics, data analysis, data visualization, and machine learning while working with real datasets throughout the program.
The course focuses on both technical implementation and analytical thinking, helping students understand how to clean data, explore patterns, build models, and evaluate results effectively. As the program progresses, learners are introduced to machine learning, introductory deep learning concepts, and real-world project workflows. Additional modules cover version control, project organization, and deployment fundamentals commonly used in professional data science environments.
By the end of the course, students will have completed practical projects that demonstrate end-to-end data science skills.
Course Content
SQL FOR DATA SCIENCE AND ANALYTICS.
-
Understanding Databases and Their Role in Data Science and Analytics.
00:00 -
MYSQL SETUP AND PRACTICE DATABASE INSTALLATION
00:00 -
Database Creation and Management Fundamentals.
-
SELECT, FROM, WHERE Fundamentals (Part 1: Filtering and Comparison Operators)
00:00 -
SELECT, FROM, WHERE Fundamentals (Part 2: Filtering with Logic and Patterns)
00:00 -
Data Aggregation and Grouping in SQL
00:00 -
Inner Join in SQL: Combining Related Tables
00:00 -
Advanced Joins in SQL: LEFT, RIGHT, FULL AND SELF JOIN.
00:00 -
Subqueries in SQL: Querying within queries.
00:00 -
SQL Functions and Conditional Logics (Core Functions)
00:00 -
SQL Functions and Conditional Logic (CASE Statement)
00:00 -
Common Table Expression in SQL (CTEs)
00:00 -
Window Functions in SQL: Advanced Row Level Analytics
00:00