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!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple