Udemy – Applied SQL For Data Analytics / Data Science With BigQuery 2024-3

Udemy – Applied SQL For Data Analytics / Data Science With BigQuery 2024-3 Downloadly IRSpace

Udemy – Applied SQL For Data Analytics / Data Science With BigQuery 2024-3
Udemy – Applied SQL For Data Analytics / Data Science With BigQuery 2024-3

Applied SQL For Data Analytics / Data Science With BigQuery, 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.

What you’ll learn

  • 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.

Who this course is for

  • People with at least some SQL experience (you can write simple SELECT statements)
  • Aspiring data scientists or data scientists who don’t leverage SQL
  • Data analysts
  • Product managers who want to get better with DIY analysis.
  • Developers who are interested in SQL!
  • People interested in BigQuery that already know some SQL.
  • Analysts needing to ramp up on GA4 BigQuery

Specificatoin of Applied SQL For Data Analytics / Data Science With BigQuery

  • Publisher : Udemy
  • Teacher : Jeff James
  • Language : English
  • Level : Beginner
  • Number of Course : 63
  • Duration : 13 hours and 1 minutes

Content of Applied SQL For Data Analytics / Data Science With BigQuery

Applied SQL For Data Analytics _ Data Science With BigQuery

Requirements

  • 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

Pictures

Applied SQL For Data Analytics _ Data Science With BigQuery

Sample Clip

Installation Guide

Extract the files and watch with your favorite player

Subtitle : English

Quality: 720

Download Links

Download Part 1 – 1 GB

Download Part 2 – 1 GB

Download Part 3 – 1 GB

Download Part 4 – 1 GB

Download Part 5 – 1 GB

Download Part 6 – 203 MB

File size

5.19 GB