Udemy - SQL For Data Science With Google Big Query

seeders: 1
leechers: 9
Added 5 years ago by tutsnode in Other

Download Fast Safe Anonymous
movies, software, shows...

Files

Udemy - SQL For Data Science With Google Big Query (Size: 4.06 GB)
  TutsNode.com.txt 63 B
  [TGx]Downloaded from torrentgalaxy.to .txt 585 B
  [TutsNode.com] - SQL For Data Science With Google Big Query
  01 Introduction
  001 Introduction.en.srt 6.24 KB
  001 Introduction.mp4 60.7 MB
  002 Creating Google Account.en.srt 5.28 KB
  002 Creating Google Account.mp4 69.93 MB
  003 Signing up for 12 Month Free Trial of Google Cloud Platform and Google Big Query.en.srt 12.2 KB
  003 Signing up for 12 Month Free Trial of Google Cloud Platform and Google Big Query.mp4 133.5 MB
  004 Getting Access to Big Query Public Data Sets and Pinning them Quick Access.en.srt 8.66 KB
  004 Getting Access to Big Query Public Data Sets and Pinning them Quick Access.mp4 91.41 MB
  005 Introduction Big Query UI and Functionality.en.srt 18.09 KB
  005 Introduction Big Query UI and Functionality.mp4 116.16 MB
  006 How Big Query Charges Per Query and How to Make Your Credit Last A Long Time.en.srt 29.35 KB
  006 How Big Query Charges Per Query and How to Make Your Credit Last A Long Time.mp4 174.25 MB
  006 how-big-query-charges-based-on-query-answers.html 175.58 KB
  006 how-big-query-charges-based-on-query-questions.html 173.41 KB
  02 Counting Records, Returning Distinct Records, and Ordering Records
  007 Intro to Count and Count Distinct.en.srt 16.67 KB
  007 Intro to Count and Count Distinct.mp4 87.55 MB
  007 intro-count-star-and-count-distinct.html 15.26 KB
  008 Count and Count Distinct with Null Records.en.srt 12.53 KB
  008 Count and Count Distinct with Null Records.mp4 77.16 MB
  008 counting-part-2-null-records.html 15.64 KB
  009 Quiz 1_ Count and Count Distinct Quiz.html 1.12 KB
  009 quiz1.pdf 19.64 KB
  010 Quiz 1 Solutions.html 925 B
  010 quiz1-solutions.pdf 19.97 KB
  011 Returning Distinct Records and Ordering Records.en.srt 11.73 KB
  011 Returning Distinct Records and Ordering Records.mp4 79.79 MB
  011 intro-distinct-of-single-column-and-order-by.html 16.68 KB
  012 Quiz 2_ Returning Distinct Records and Ordering With a Single Column.html 1.06 KB
  012 quiz2.pdf 17.94 KB
  013 Quiz 2 Solutions.html 914 B
  013 quiz2-solutions.pdf 22.77 KB
  014 Returning DIstinct Records and Order with Multiple Columns.en.srt 14.08 KB
  014 Returning DIstinct Records and Order with Multiple Columns.mp4 98.68 MB
  014 distinct-of-multiple-column-and-order-by-answers.html 168.67 KB
  014 distinct-of-multiple-column-and-order-by-questions.html 162.54 KB
  014 distinct-of-multiple-column-and-order-by.html 15.22 KB
  03 Where Clause
  015 10-intro-where-clause.html 11.8 KB
  015 Introduction to Where Clause.en.srt 10.8 KB
  015 Introduction to Where Clause.mp4 67.79 MB
  016 11-where-clause-on-numerical.html 27.79 KB
  016 Where Clauses On Numerical Columns.en.srt 18.27 KB
  016 Where Clauses On Numerical Columns.mp4 115.02 MB
  017 12-where-clause-on-string-text.html 23.71 KB
  017 Where Clause On String (Text) Columns.en.srt 13.82 KB
  017 Where Clause On String (Text) Columns.mp4 77.8 MB
  018 Quiz 3_ Where Clause Quiz With Integer and String Columns.html 1.3 KB
  018 quiz3.pdf 19.88 KB
  019 Quiz 3 Solutions.html 918 B
  019 quiz3-solutions.pdf 30.92 KB
  020 13-where-clause-on-timestamp-date.html 26.26 KB
  020 Where Clause On TIMESTAMP Columns And Some Useful Extract Functions.en.srt 19.72 KB
  020 Where Clause On TIMESTAMP Columns And Some Useful Extract Functions.mp4 127.29 MB
  021 Quiz 4_ Where Clause Quiz With Timestamp Column.html 1.74 KB
  021 quiz4.pdf 18.48 KB
  022 Quiz 4_ Solution.html 925 B
  022 quiz4-solutions.pdf 21.38 KB
  023 14-where-clause-null-and-not-null.html 17.09 KB
  023 Where Clause_ IS NULL & IS NOT NULL.en.srt 5.39 KB
  023 Where Clause_ IS NULL & IS NOT NULL.mp4 34.13 MB
  04 Group By And Aggregate Functions
  024 15-intro-group-by-and-data-studio.html 16.42 KB
  024 Intro to Group By, Aggregation, and Google's Data Studio Visualization Tool.en.srt 16.27 KB
  024 Intro to Group By, Aggregation, and Google's Data Studio Visualization Tool.mp4 99.78 MB
  025 16-explain-group-by-detail.html 33.27 KB
  025 Group By And Aggregation Functions_ MAX MIN SUM COUNT AVG.en.srt 30.25 KB
  025 Group By And Aggregation Functions_ MAX MIN SUM COUNT AVG.mp4 191.66 MB
  026 17-group-by-example-count-with-where-clause.html 15.57 KB
  026 Group By Example_ COUNT with WHERE Clause and Visualization In Data Studio.en.srt 19.08 KB
  026 Group By Example_ COUNT with WHERE Clause and Visualization In Data Studio.mp4 115.39 MB
  027 18-group-by-example-with-sum.html 15.19 KB
  027 Group By Example_ SUM and Visualization In Data Studio.en.srt 9.88 KB
  027 Group By Example_ SUM and Visualization In Data Studio.mp4 67.65 MB
  028 19-group-by-example-with-max-min-avg.html 16.08 KB
  028 Group By Example_ MAX MIN AVG with WHERE and Visualization In Data Studio.en.srt 13.65 KB
  028 Group By Example_ MAX MIN AVG with WHERE and Visualization In Data Studio.mp4 105.37 MB
  029 Group BY Example_ COUNT with HAVING and Visualization In Data Studio.en.srt 9.82 KB
  029 Group BY Example_ COUNT with HAVING and Visualization In Data Studio.mp4 66.71 MB
  030 Quiz 5_ Group By And Aggregate Functions Quiz.html 1.22 KB
  030 quiz5.pdf 18.7 KB
  031 Quiz 5 Solutions.html 925 B
  031 quiz5-solutions.pdf 23.78 KB
  032 21-group-by-multiple-columns.html 24.64 KB
  032 Grouping By Multiple Columns Explanation.en.srt 13.46 KB
  032 Grouping By Multiple Columns Explanation.mp4 90.97 MB
  033 22-group-by-multiple-columns-example.html 16.57 KB
  033 Grouping By Multiple Columns Example.en.srt 12 KB
  033 Grouping By Multiple Columns Example.mp4 78.42 MB
  05 Project 1_ New York Citi Bike Dashboard
  034 23-project-1-outline.html 698.17 KB
  034 Project Intro.en.srt 6.13 KB
  034 Project Intro.mp4 45.66 MB
  035 Quick Intro to Google Data Studio Reporting and Data Sources.en.srt 7.54 KB
  035 Quick Intro to Google Data Studio Reporting and Data Sources.mp4 51.77 MB
  036 25-prepare-ny-city-bike-by-day-data-question.html 83.46 KB
  036 Prepare Data Set Question_ NY Citi Bike By Day.en.srt 2.77 KB
  036 Prepare Data Set Question_ NY Citi Bike By Day.mp4 17.78 MB
  037 26-prepare-ny-city-bike-by-day-data-answer.html 87.78 KB
  037 Prepare Data Set Answer_ NY Citi Bike By Day.en.srt 2.58 KB
  037 Prepare Data Set Answer_ NY Citi Bike By Day.mp4 32.76 MB
  038 Prepare Data Set Data Studio_ NY Citi Bike By Day.en.srt 11.64 KB
  038 Prepare Data Set Data Studio_ NY Citi Bike By Day.mp4 44.64 MB
  039 28-prepare-remaning-ny-city-bike-day-data-sets-in-data-studio.html 923.94 KB
  039 Prepare Remaining Three Data Sets In Data Studio_ NY Citi Bike Project.en.srt 16.11 KB
  039 Prepare Remaining Three Data Sets In Data Studio_ NY Citi Bike Project.mp4 96.39 MB
  040 Create Dashboard in Data Studio.en.srt 27.04 KB
  040 Create Dashboard in Data Studio.mp4 222.74 MB
  06 Joins (Joining Multiple Tables Together)
  041 30-intro-to-joins.html 196.47 KB
  041 Intro to Joins.en.srt 26.23 KB
  041 Intro to Joins.mp4 139.8 MB
  042 31-left-join-big-query-census-data.html 17.37 KB
  042 Left Join Example Big Query Census Data.en.srt 15.19 KB
  042 Left Join Example Big Query Census Data.mp4 85.91 MB
  043 32-inner-join-big-query-duplicate-example-taxi-trips.html 19.92 KB
  043 Joining Tables with Duplicate Records Leads to Duplicate Results Example.en.srt 11.05 KB
  043 Joining Tables with Duplicate Records Leads to Duplicate Results Example.mp4 83.56 MB
  044 33-lower-function-and-joining-on-strings.html 16.37 KB
  044 Trimming and Lowering When Joining on Columns of Type String.en.srt 13.1 KB
  044 Trimming and Lowering When Joining on Columns of Type String.mp4 85.86 MB
  045 34-joins-with-aggregates.html 24.83 KB
  045 Joins & Where Clause & Group By and Aggregate_ Putting it all together Examples.en.srt 19.3 KB
  045 Joins & Where Clause & Group By and Aggregate_ Putting it all together Examples.mp4 135.59 MB
  046 35-join-multiple-tables-and-multiple-columns.html 18.56 KB
  046 Joining On Multiple Columns With Multiple Tables (More than 2).en.srt 17.69 KB
  046 Joining On Multiple Columns With Multiple Tables (More than 2).mp4 129.32 MB
  07 Census International Data Dashboard Project
  047 36-project-international-census.html 18.54 KB
  047 Project Intro.en.srt 29.71 KB
  047 Project Intro.mp4 225.16 MB
  08 Big Query Standard SQL Functions
  048 37-intro-more-sql-functions.html 11.79 KB
  048 Intro to Big Query Standard SQL Functions.en.srt 3.51 KB
  048 Intro to Big Query Standard SQL Functions.mp4 31.22 MB
  049 38-cast-functions.html 16.93 KB
  049 Examples With Cast Function.en.srt 6.57 KB
  049 Examples With Cast Function.mp4 45.65 MB
  050 39-math-functions.html 16.41 KB
  050 Examples with Mathematical Functions.en.srt 13.85 KB
  050 Examples with Mathematical Functions.mp4 79.03 MB
  051 40-string-functions.html 17.71 KB
  051 Examples with String Functions.en.srt 12.2 KB
  051 Examples with String Functions.mp4 84.03 MB
  052 41-date-time-functions.html 21.35 KB
  052 Examples with Date and Timestamp Functions.en.srt 20.53 KB
  052 Examples with Date and Timestamp Functions.mp4 133.3 MB
  053 Practice Questions for SQL Functions Section.en.srt 627 B
  053 Practice Questions for SQL Functions Section.mp4 868.24 KB
  053 assignment-functions-sql.html 83.04 KB
  054 Solutions for SQL Functions Questions.en.srt 326 B
  054 Solutions for SQL Functions Questions.mp4 575.35 KB
  054 assignment-functions-sql-solutions.html 1.01 MB
  09 Case Statements
  055 44-intro-case-statements.html 74.54 KB
  055 Intro to Case Statement Syntax and Example.en.srt 9.26 KB
  055 Intro to Case Statement Syntax and Example.mp4 51.42 MB
  056 45-case-statement-example.html 19.79 KB
  056 Case Statement Examples.en.srt 8.99 KB
  056 Case Statement Examples.mp4 53.48 MB
  10 Next Steps_ Start Your Own Projects!
  057 Start Your Own Projects!.en.srt 4.8 KB
  057 Start Your Own Projects!.mp4 47.62 MB

Description



Description

This course assumes you know nothing about SQL and teaches you all the basics as well as more advanced features/methods. You will also get to learn Google Big Query, a very popular cloud based tool for querying large amounts of data at scale in the cloud. Not only will you learn SQL, but you will learn a lot about data visualization and how to gather insights from the data. You will also have access to hundreds of huge real world data sets that come along with the Google Big Query Ecosystem. Even after finishing the course content, you can still continue to improve by doing all sorts of projects on the data made available.

This course requires a Google account (which is Free) and a free 12 month trial for Google Cloud Platform (GCP). This is how you access Google Big Query which is one of the services offered through GCP. When signing up for the 12 month free trial of GCP you get $300 USD to spend on any GCP services. This is more than enough to query the data sets in this course. I used less than 5% of the credits in preparing as well as completing all the materials. As part of the sign up process you will require a credit card or bank account details so GCP can verify your identity. You will not be charged or billed during your free 12 month trial. Instructions for signing up will be available in introductory videos for the course.
Who this course is for:

Anyone interested in data and mining insights from data.
Anyone wanting to learn SQL.
Anyone wanting to learn cloud technology, and in particular Google Big Query.
Anyone wanting to Practice SQL further on awesome real world data sets in the cloud.
Anyone wanting to learn more about building dashboards and data visualizations.

Requirements

Able to follow instructions and passion to learn.
Credit card or bank account to sign up for Google Cloud Platform Free Trial. Your card is not charged. Its just for identifying you and is required during the sign up process.

Last Updated 11/2020

Related Torrents

torrent name size uploader age seed leech
0
0
0
3
1