English | Size:
Genre: eLearning
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.
Who this course is for:
SQL beginners
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.
nitro.download/view/1500E92CF876DC5/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part1.rar
nitro.download/view/6159C1A2C606F4C/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part2.rar
nitro.download/view/F2770D5218C3D05/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part3.rar
nitro.download/view/B7E53615E175BB3/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part4.rar
nitro.download/view/21E2070AB86AE3B/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part5.rar
nitro.download/view/D432F839F51AD67/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part6.rar
rapidgator.net/file/61e56994c88bd458e59caa18d4175307/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part1.rar.html
rapidgator.net/file/8b87b7a284aecce8268f393b474e55b0/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part2.rar.html
rapidgator.net/file/28b5bd7ff9cae0df578153ac52bbdd82/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part3.rar.html
rapidgator.net/file/7040e838a2732ff1850848a586fa10f3/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part4.rar.html
rapidgator.net/file/ed41a79e0038011687644e2d6e9b9f35/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part5.rar.html
rapidgator.net/file/3d25a34ad455b299259e687cafcd11dc/Applied.SQL.For.Data.Analytics..Data.Science.With.BigQuery.7.4.2.part6.rar.html
If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9