SQL for Data Science Bootcamp

This course offers a deep dive into SQL's capabilities, giving you the skills to query, manipulate, and combine data sets.

Using Udemy's built-in coding exercises, we will go from zero knowledge to advanced mastery of SQL, seeing how SQL is used in real-life data science situations.  We will work together as data scientists for a fictional educational technology company and learn how to use SQL to answer questions regarding our instructors, students, and courses.

Unlike other courses, we will start coding in SQL immediately, with no software installation required.

Course Features:

• Short video lectures that introduce each topic

• 40 hands-on coding exercises complete with solutions, ensuring you get the practical experience to master SQL

• Quizzes to assess and reinforce your understanding.

  
  

What You'll Learn:

• What is SQL, and why are there dialects like SQLite, PostgreSQL, MySQL and others?

• Basic SELECT statements

• ORDER BY

• WHERE

• Joining tables with INNER JOIN and LEFT JOIN

• Aggregation functions like COUNT, SUM, and AVG to derive meaningful statistics.

• Advanced window functions with OVER and PARTITION BY

• and more!

Who Should Enroll:

• Current or aspiring data scientists and data analysts

• Anybody who wants to learn SQL with interactive exercises and full video solutions with detailed explanations.