Danh mục
Duocmmo Tedu Tin học văn phòng Laravel Cyberlearn Khoá học miễn phí Tất cả khoá học
Get link khoá học
Trang chủ
Khoá học
Applied SQL For Data Analytics / Data Science With BigQuery

Applied SQL For Data Analytics / Data Science With BigQuery

Go from SQL Zero to Hero and develop rich mental models for writing sophisticated SQL statements & solving problems.

image
50.000 VND
85 VND
Đầy Đủ Bài Giảng
Học Online Tiện Lợi
Kích Hoạt Nhanh 2-5 Phút
Thanh toán tự động
Được phép tải xuống

Tổng quan

Nội dung khoá học

Đánh giá

Mô tả

Woah, another SQL course? Yes! Here's why this one is different.

  1. We write 100% of the code together and I explain everything precisely and with abundant context. I have over a decade of industry experience over have taught this at the university level.


  2. 100% we do is application based. I rarely use toy data to illustrate points, unless it's more illustrative. Hopefully you'll learn much more than SQL throughout the course.


  3. ZERO SET-UP. As long as you have a Google Account, you can login to BigQuery and get started immediately. No headaches configuring databases locally. You'll be up and running in under 3 minutes.


  4. Spaced repetition to develop mastery. This is NOT a table of contents course. This is NOT a list of disparate exercises. Everything is connected. Concepts are revisited throughout the course so you can see them from different angles and maximize understanding.


  5. Can you solve it? I provide tons of mini-challenges throughout the lecture material. The lecture material is basically us solving the problems. No time wasted on theory without context.


  6. I'm not boring. I am human. I do make mistakes. I dwell on them so you can master the debugging process. Debugging is much more important than writing code.



Bạn sẽ học được gì

SQL 101: The basics (SELECT, WHERE, HAVING, JOIN's, dealing with dates and timestamps)

[NEW] Google Analytics 4 and BigQuery - Master the data model and attribution

SQL 202: Date Handling, CASE statements, Common Table Expressions, Subqueries, Correlated Subqueries

Develop clear models of translating business requirements to SQL

Master Window / Analytic Functions, which are the power tools of modern data-science SQL

100% of videos are code along and provide numerous points to stop and "solve it" before me.

Yêu cầu

  • Be able to write very basic SQL statements or at least understand what rows and columns are
  • Have a google account since we use BigQuery

Nội dung khoá học

13 sections

Should you take this course?

1 lectures
How this course works - please watch!
10:26

BigQuery Set-up - Writing Our First Queries!

11 lectures
[Must Watch] - January 2023 - Pinning the Project and getting set-up
02:50
WATCH FIRST PLEASE: New BigQuery UI - Set-up (January 26, 2021 update)
06:49
[Optional - but very useful]Using ChatGPT to accelerate learning and progress.
14:18
[Optional - but very useful] Asking ChatGPT for Examples
15:59
Overview of Tables/Columns and Writing Queries
17:17
Anatomy of a SELECT statement
11:38
Our First Real Question - How Many Questions Each Tag Has?
12:56
Does a Question Have Multiple Tags? More aggregations, GROUPING and the HAVING
14:39
Everything is a Table: Subqueries, Common Table Expressions
08:03
Solution - All Views for Titles Containing "python" - Tricky!
11:57
Solution - All Questions for Each Tag, plus some more subqueries.
11:17

The CASE Statement - Quick Case study using StackOverflow Questions

4 lectures
Using CASE Statements to Classify Stack Overflow Questions
14:27
Solution - Using Question Titles And Tags in our CASE statement
17:43
Solution - Programming Language Growth Using Stack Overflow Data
13:34
Using Python to Generate Larger SQL Statements (Optional)
08:13

Join me and learn to JOIN data + Window/Analytic Functions

7 lectures
INNER, LEFT, RIGHT, OUTER JOIN's - in a nutshell
14:11
JOIN'ing Order and Customers - How to identify JOIN column candidates
13:38
Solution - Most Popular Cities and Intro to ROW_NUMBER()
11:17
Solution - New Customers Acquired by Year/Month
12:30
Breaking Down ROW_NUMBER() in Using order_items
08:58
Breaking Down LAG() in Using order_items
12:39
Solution - Average Days Between Orders Using ROW_NUMER() and LAG()
07:47

Other JOIN's You Might Need

3 lectures
Final Solution - Customers with >1 Orders, Avg Time Between Orders
12:57
FULL OUTER JOIN - Motivation and Problem Statement
08:32
FULL OUTER JOIN - Solution
08:30

JOIN's Mini Project - Hourly Revenue Trends

3 lectures
Hourly Revenue Trends Intro
12:11
Hourly Revenue Trends CASE Solution
08:48
CASE Statement Trick
04:11

UNNEST, Correlated Subqueries

5 lectures
UNNEST Intro, Running Totals w/Correlated Subqueries
11:07
Moving Averages and Quick Comprehension Check
13:41
LAG using a correlated subquery!
07:10
Customer Order Summary - Part 1
15:11
Customer Order Summary - Using Correlated Subqueries Part 2
14:45

Stock Price Project

2 lectures
Analyzing Stock Prices Using Moving Averages
15:26
Stock Price Analysis Solution
13:22

More Complex JOIN's and PARTITION'ing

3 lectures
Top 2 Customer Rentals by Moving Rating (Top N Problem) - Part 1
11:56
Top 2 Customer Rentals by Moving Rating (Top N Problem) - Part 2 Solution
07:18
Using Multiple Partitions with ROW_NUMBER()
07:58

Stack Overflow MiniProject - Top Phrases used in Title by Tag

3 lectures
Splitting Titles into Tokens and Counting Them
16:30
Analyzing Top Occurring Unigrams From the Question Titles Grouped by Tag
16:26
Using ML.NGRAMS to get Bigrams, Trigrams and Ngrams
13:10

More Text Processing With Regular Expressions

6 lectures
Regular Expressions Intro - Advent of Code 2020 Problem 2 Part A
10:12
Regular Expressions Intro - Advent of Code 2020 Problem 2 Part A Continued
10:26
Pair Programming With a Former Student - Watch if you can!
01:17:31
Advent of Code 2020 Problem - Part 2 - First Video
12:05
Advent of Code 2020 Problem - Part 2 - Second Video
05:42
Advent of Code 2020 Problem - Part 2 - Javascript UDF Solution
12:36

Google Analytics Attribution Analysis

4 lectures
Intro to Google Analytics Multichannel Funnels and Paths
10:28
Starting to write the code to analyze first and last touch channels
11:10
Dealing with some edge cases and bigger questions
12:11
Solution for paths of length > 1
10:02

NEW for 2024 - GA4 w/BigQuery - Data Model, Event Params and Attribution Part 1

11 lectures
Intro to BigQuery for GA4 - Understand the data model
13:21
2 - Learning how to UNNEST and deal with event_params
14:27
3 - Analyze Landing Pages
09:08
4 - Adding Transactions to the Landing Page Report
07:46
5 - Interlude - Speeding up the Solution from Lecture 4
10:29
6 - Last Click Attribution, intro to First Click
08:54
7 - First Click Solved, intro to Uniform or Linear Attribution
12:04
8 - Simple Uniform Solved, intro to Segmented Uniform
11:11
9 - Segmented Uniform Attribution Explained Conceptually - Partially Solved
12:48
10 - Segmented Uniform Attribution Solved - Add one user challenge
09:35
11 - Adding another user and partitions for Uniform Attribution
07:33

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

Khoá học liên quan

Yocto Zero to Hero - Building embedded Linux

Yocto Zero to Hero - Building embedded Linux

50 VND
50.000 VND
Khóa NLP thiết kế ngôn ngữ lập trình tư duy bất bại Forex

Khóa NLP thiết kế ngôn ngữ lập trình tư duy bất bại Forex

25 VND
50.000 VND
Become Certified SOLIDWORKS Professional (CSWP) Course

Become Certified SOLIDWORKS Professional (CSWP) Course

25 VND
50.000 VND
Mastering Python: FastAPI, Docker, Streamlit, PostgreSQL

Mastering Python: FastAPI, Docker, Streamlit, PostgreSQL

25 VND
50.000 VND
Thành thạo công thức và 120 hàm Excel phổ biến

Thành thạo công thức và 120 hàm Excel phổ biến

25 VND
50.000 VND
Git and GitHub - The Complete Guide [2024]

Git and GitHub - The Complete Guide [2024]

25 VND
50.000 VND
Personal fitness trainer

Personal fitness trainer

25 VND
50.000 VND
Product Management A-Z: Hands-On, Real-World Simulation

Product Management A-Z: Hands-On, Real-World Simulation

80 VND
50.000 VND
Kỹ thuật xác định và quản lý Product Roadmap

Kỹ thuật xác định và quản lý Product Roadmap

25 VND
50.000 VND
Unreal Engine 5 Blueprints - The Ultimate Developer Course

Unreal Engine 5 Blueprints - The Ultimate Developer Course

45 VND
50.000 VND
Applied SQL For Data Analytics / Data Science With BigQuery

Applied SQL For Data Analytics / Data Science With BigQuery

85 VND
50.000 VND
Tiếng Trung cơ bản 2

Tiếng Trung cơ bản 2

299.000 VND
99.000 VND
The Ultimate 2D Top Down Unreal Engine Course

The Ultimate 2D Top Down Unreal Engine Course

110 VND
50.000 VND
The Story Course - Storytelling Masterclass

The Story Course - Storytelling Masterclass

110 VND
50.000 VND
The Complete UML Course (2024): Learn to Design UML Diagrams

The Complete UML Course (2024): Learn to Design UML Diagrams

25 VND
50.000 VND
Self Driving and ROS - Learn by Doing! Odometry & Control

Self Driving and ROS - Learn by Doing! Odometry & Control

1.599.000 VND
50.000 VND
image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.

Get khoá học cho tôi