Udemy – SQL: A Step-by-step Introduction for Data Science 2023-10

SQL: A Step-by-step Introduction to Data Science. This course teaches you the essential skills to work with data using SQL. Focusing on querying, manipulating, and combining datasets, this course is designed to go from beginner to advanced. Using hands-on exercises on the Udemy platform, you’ll start coding right away, without having to install any software. Throughout the course, you’ll work as a data scientist at a fictional education company and learn how to use SQL to analyze data about instructors, students, and courses. The course includes short instructional videos, 40 coding exercises with answers, and assessment tests. Some of the topics covered include SELECT statements, filtering with WHERE, sorting with ORDER BY, joining tables with INNER JOIN and LEFT JOIN, aggregate functions like COUNT and SUM, and advanced Window functions with OVER and PARTITION BY. This course is suitable for people who want to learn SQL for practical data science applications.

What you will learn:

• Mastery of basic SQL commands such as SELECT and WHERE
• Learn how to use aggregate functions to transform data and calculate new values.
• Understand how to use JOIN to combine information from multiple tables.
• Learn how to use advanced window functions to calculate more complex values.

Who is this course suitable for?

• Current or aspiring data scientists and data analysts.
• Anyone who wants to learn SQL with interactive exercises and complete video solutions with detailed explanations.
• SQL beginners who want to go from ignorance to mastery of advanced SQL commands.
• People who want to write SQL code immediately using the Udemy Coding Exercise feature – no software required!

Course Details: SQL: A Step-by-step Introduction for Data Science

• Publisher:  Udemy
• Instructor:  Brian Greco
• Training level: Beginner to advanced
• Training duration: 1 hour and 59 minutes
• Number of lessons: 74

Course syllabus on 2023/11

Prerequisites for the SQL: A Step-by-step Introduction for Data Science course

Course images

Sample course video

Download link

Download file – 736 MB

File(s) password: www.downloadly.ir

File size

736 MB