SQL for Data Analytics

SQL for Data Analytics, available at $64.99, has an average rating of 4.55, with 46 lectures, 2 quizzes, based on 199 reviews, and has 906 subscribers.

You will learn about Become an expert in SQL and PostgreSQL Write complex SQL queries with ease Learn Advanced SQL concepts Answer product or data questions using SQL and Data Analysis Apply Data Analytics to make data-informed decisions Replicate real-world situations and find actionable business insights Create visualizations to present your insights Ace the Advanced SQL job interview questions This course is ideal for individuals who are Beginners who wants to learn about SQL or Beginners who wants to learn about Data Analysis or Beginners who wants to learn about Data Science or Beginner developers curious about Data Science or Intermediate developers wants to learn Advanced SQL concepts or Intermediate SQL developers wants to advance their career or People who wants to prepare for SQL Job Interview questions or Beginners who want to prepare for Data Science interview questions or Beginners who want to prepare for Data Engineer interview questions or Beginners who wants to learn about PostgreSQL It is particularly useful for Beginners who wants to learn about SQL or Beginners who wants to learn about Data Analysis or Beginners who wants to learn about Data Science or Beginner developers curious about Data Science or Intermediate developers wants to learn Advanced SQL concepts or Intermediate SQL developers wants to advance their career or People who wants to prepare for SQL Job Interview questions or Beginners who want to prepare for Data Science interview questions or Beginners who want to prepare for Data Engineer interview questions or Beginners who wants to learn about PostgreSQL.

Enroll now: SQL for Data Analytics

Summary

Title: SQL for Data Analytics

Price: $64.99

Average Rating: 4.55

Number of Lectures: 46

Number of Quizzes: 2

Number of Published Lectures: 46

Number of Published Quizzes: 2

Number of Curriculum Items: 51

Number of Published Curriculum Objects: 51

Original Price: $84.99

Quality Status: approved

Status: Live

What You Will Learn

Become an expert in SQL and PostgreSQL
Write complex SQL queries with ease
Learn Advanced SQL concepts
Answer product or data questions using SQL and Data Analysis
Apply Data Analytics to make data-informed decisions
Replicate real-world situations and find actionable business insights
Create visualizations to present your insights
Ace the Advanced SQL job interview questions

Who Should Attend

Beginners who wants to learn about SQL
Beginners who wants to learn about Data Analysis
Beginners who wants to learn about Data Science
Beginner developers curious about Data Science
Intermediate developers wants to learn Advanced SQL concepts
Intermediate SQL developers wants to advance their career
People who wants to prepare for SQL Job Interview questions
Beginners who want to prepare for Data Science interview questions
Beginners who want to prepare for Data Engineer interview questions
Beginners who wants to learn about PostgreSQL

Target Audiences

Beginners who wants to learn about SQL
Beginners who wants to learn about Data Analysis
Beginners who wants to learn about Data Science
Beginner developers curious about Data Science
Intermediate developers wants to learn Advanced SQL concepts
Intermediate SQL developers wants to advance their career
People who wants to prepare for SQL Job Interview questions
Beginners who want to prepare for Data Science interview questions
Beginners who want to prepare for Data Engineer interview questions
Beginners who wants to learn about PostgreSQL

Welcome to SQL for Data Analytics!

There are literally thousands of SQL courses online, but most of them don’t prepare you for using it in the real world.

In this course, instead of just learning about the basic fundamentals of SQL, I will teach you how to use SQL and data to develop your Data Analytics mindset. Together, we will learn how to apply SQL and Data Analysis to real-life business use cases, to draw insights from data in order to make data-informed decisions. We will also learn about the advanced concept in SQL like Self-join and Window Analytics Functions to solve complex business problems.

We even go further to present and communicate that insight effectively with interactive visualization dashboard.

This course requires absolutely no programming experience.

By the end of this course, you will be well equipped to pass all of the SQL interviews questions in the data world: whether you are looking for a job as a data scientist, data analyst, or data engineer.

Feel free to look through the preview videos of this course to see if it’s a good fit for you!

Remember I offer a 30-day money-back guarantee, so you can join me for an entire month, risk-free, and decide whether to keep going or not.

I’ll see you inside the course!

Best,

Tuan Vu

Course Curriculum

Chapter 1: Introduction

Lecture 1: What is SQL?

Lecture 2: Course FAQs

Lecture 3: Setup with Mode

Lecture 4: Assignment: Introduce Yourself

Chapter 2: Basic SQL Fundamentals

Lecture 1: SQL Introduction

Lecture 2: SELECT – FROM

Lecture 3: LIMIT

Lecture 4: WHERE

Lecture 5: Comparison Operators

Lecture 6: Logical Operators: AND, OR, NOT

Lecture 7: LIKE

Lecture 8: IN, NOT IN

Lecture 9: BETWEEN

Lecture 10: IS NULL

Lecture 11: ORDER BY

Chapter 3: SQL Aggregations

Lecture 1: Introduction to Aggregation

Lecture 2: COUNT, SUM

Lecture 3: MIN, MAX, AVG

Lecture 4: GROUP BY

Lecture 5: HAVING

Lecture 6: DISTINCT

Lecture 7: CASE Statement

Lecture 8: Solution: SQL Aggregation Assignment

Chapter 4: SQL Joins

Lecture 1: Introduction to Joins

Lecture 2: Why do we split data into separate tables?

Lecture 3: Inner Join

Lecture 4: Left and Right Join

Lecture 5: JOINs and Filtering

Lecture 6: JOINs and Aggregation

Lecture 7: Full Outer Join

Lecture 8: UNION, UNION ALL

Lecture 9: Self-Join

Lecture 10: Solution: SQL Join Assignment

Chapter 5: SQL Subqueries & Common Table Expression

Lecture 1: Subqueries

Lecture 2: WITH: Common Table Expression (CTE)

Lecture 3: Solution: SQL Subqueries Assignment

Chapter 6: Advanced: SQL Window Functions

Lecture 1: Introduction to WINDOW Functions

Lecture 2: SUM: Compute a cumulative sum

Lecture 3: ROW_NUMBER, PARTITION BY

Lecture 4: RANK, DENSE_RANK

Lecture 5: Aggregates in Window Functions

Lecture 6: Window Frame

Lecture 7: LAG, LEAD

Lecture 8: Assignment: SQL Window Functions

Lecture 9: Solution: SQL Window Functions assignment

Chapter 7: Conclusion

Lecture 1: Course conclusion. Thank you!

Instructors

Tuan Vu
Software Engineer at Facebook

Rating Distribution

1 stars: 0 votes
2 stars: 3 votes
3 stars: 9 votes
4 stars: 58 votes
5 stars: 129 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu