Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Other IT & Software>Applied SQL For Data Analytics / Data Science With BigQuery
IT & SoftwareApplied SQL For Data Analytics / Data Science With BigQuery
Price:Paid
Length:10.5 hours
Content type:video
level:beginner
Updated:19 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Other IT & Software>Applied SQL For Data Analytics / Data Science With BigQuery
Applied SQL For Data Analytics / Data Science With BigQuery
4.4 (2.8k)
10.5 hours
2769 students
What you will learn
1SQL 101: The basics (SELECT, WHERE, HAVING, JOIN's, dealing with dates and timestamps)
2SQL 202: Date Handling, CASE statements, Common Table Expressions, Subqueries, Correlated Subqueries
3Develop clear models of translating business requirements to SQL
4Master Window / Analytic Functions, which are the power tools of modern data-science SQL
5100% of videos are code along and provide numerous points to stop and "solve it" before me.
Target audiences
1People with at least some SQL experience (you can write simple SELECT statements)
2Aspiring data scientists or data scientists who don't leverage SQL
3Data analysts
4Product managers who want to get better with DIY analysis.
5Developers who are interested in SQL!
6People interested in BigQuery that already know some SQL.
Requirements
1Be able to write very basic SQL statements or at least understand what rows and columns are
2Have a google account since we use BigQuery
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
Description

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.



Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Other IT & Software>Applied SQL For Data Analytics / Data Science With BigQuery
IT & SoftwareApplied SQL For Data Analytics / Data Science With BigQuery
Price:Paid
Length:10.5 hours
Content type:video
level:beginner
Updated:19 February 2024
Published:21 August 2022
Similar courses
Opportunities
Courses>Other IT & Software>Applied SQL For Data Analytics / Data Science With BigQuery
Applied SQL For Data Analytics / Data Science With BigQuery
4.4 (2.8k)
10.5 hours
2769 students
What you will learn
1SQL 101: The basics (SELECT, WHERE, HAVING, JOIN's, dealing with dates and timestamps)
2SQL 202: Date Handling, CASE statements, Common Table Expressions, Subqueries, Correlated Subqueries
3Develop clear models of translating business requirements to SQL
4Master Window / Analytic Functions, which are the power tools of modern data-science SQL
5100% of videos are code along and provide numerous points to stop and "solve it" before me.
Target audiences
1People with at least some SQL experience (you can write simple SELECT statements)
2Aspiring data scientists or data scientists who don't leverage SQL
3Data analysts
4Product managers who want to get better with DIY analysis.
5Developers who are interested in SQL!
6People interested in BigQuery that already know some SQL.
Requirements
1Be able to write very basic SQL statements or at least understand what rows and columns are
2Have a google account since we use BigQuery
FAQ
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
Description

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.



Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot