[Udemy Course] Applied SQL For Data Analytics Data Science With BigQuery by Jeff James

What you’ll learn

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

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.

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

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.

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.

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.

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.

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.

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.

💢💢💢💢💢💢💢💢

Product Details: https://tinyurl.com/5aa6wj6e

File size: 5.5GB

Payment and delivery:

1. Please provide your EMAIL address in “message:” during checkout.

2. The files will be sent to you after payment has been confirmed.

🔥 All files will be delivered online.

🔥 Download for Lifetime Access

Kindly PM us if you are looking for other ebooks/ Video Courses.

Enjoy learning!