SQL For Data Science With Google Big Query | E54EBBC40A7AB061C24E479970B7354214A11339

SQL For Data Science With Google Big Query

Name	SQL For Data Science With Google Big Query	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	4.4 GB
Total Files	156
Last Seen
Hash	E54EBBC40A7AB061C24E479970B7354214A11339

/.../07 Census International Data Dashboard Project/
047 Project Intro.mp4	236.1 MB

TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/01 Introduction/
001 Introduction.en.srt	6.4 KB
001 Introduction.mp4	63.6 MB
002 Creating Google Account.en.srt	5.4 KB
002 Creating Google Account.mp4	73.3 MB
003 Signing up for 12 Month Free Trial of Google Cloud Platform and Google Big Query.en.srt	12.5 KB
003 Signing up for 12 Month Free Trial of Google Cloud Platform and Google Big Query.mp4	140.0 MB
004 Getting Access to Big Query Public Data Sets and Pinning them Quick Access.en.srt	8.9 KB
004 Getting Access to Big Query Public Data Sets and Pinning them Quick Access.mp4	95.9 MB
005 Introduction Big Query UI and Functionality.en.srt	18.5 KB
005 Introduction Big Query UI and Functionality.mp4	121.8 MB
006 How Big Query Charges Per Query and How to Make Your Credit Last A Long Time.en.srt	30.1 KB
006 How Big Query Charges Per Query and How to Make Your Credit Last A Long Time.mp4	182.7 MB
006 how-big-query-charges-based-on-query-answers.html	179.8 KB
006 how-big-query-charges-based-on-query-questions.html	177.6 KB
/.../02 Counting Records, Returning Distinct Records, and Ordering Records/
007 Intro to Count and Count Distinct.en.srt	17.1 KB
007 Intro to Count and Count Distinct.mp4	91.8 MB
007 intro-count-star-and-count-distinct.html	15.6 KB
008 Count and Count Distinct with Null Records.en.srt	12.8 KB
008 Count and Count Distinct with Null Records.mp4	80.9 MB
008 counting-part-2-null-records.html	16.0 KB
009 Quiz 1_ Count and Count Distinct Quiz.html	1.1 KB
009 quiz1.pdf	20.1 KB
010 Quiz 1 Solutions.html	0.9 KB
010 quiz1-solutions.pdf	20.4 KB
011 intro-distinct-of-single-column-and-order-by.html	17.1 KB
011 Returning Distinct Records and Ordering Records.en.srt	12.0 KB
011 Returning Distinct Records and Ordering Records.mp4	83.7 MB
012 Quiz 2_ Returning Distinct Records and Ordering With a Single Column.html	1.1 KB
012 quiz2.pdf	18.4 KB
013 Quiz 2 Solutions.html	0.9 KB
013 quiz2-solutions.pdf	23.3 KB
014 distinct-of-multiple-column-and-order-by-answers.html	172.7 KB
014 distinct-of-multiple-column-and-order-by-questions.html	166.4 KB
014 distinct-of-multiple-column-and-order-by.html	15.6 KB
014 Returning DIstinct Records and Order with Multiple Columns.en.srt	14.4 KB
014 Returning DIstinct Records and Order with Multiple Columns.mp4	103.5 MB
/.../03 Where Clause/
015 10-intro-where-clause.html	12.1 KB
015 Introduction to Where Clause.en.srt	11.1 KB
015 Introduction to Where Clause.mp4	71.1 MB
016 11-where-clause-on-numerical.html	28.5 KB
016 Where Clauses On Numerical Columns.en.srt	18.7 KB
016 Where Clauses On Numerical Columns.mp4	120.6 MB
017 12-where-clause-on-string-text.html	24.3 KB
017 Where Clause On String (Text) Columns.en.srt	14.2 KB
017 Where Clause On String (Text) Columns.mp4	81.6 MB
018 Quiz 3_ Where Clause Quiz With Integer and String Columns.html	1.3 KB
018 quiz3.pdf	20.4 KB
019 Quiz 3 Solutions.html	0.9 KB
019 quiz3-solutions.pdf	31.7 KB
020 13-where-clause-on-timestamp-date.html	26.9 KB
020 Where Clause On TIMESTAMP Columns And Some Useful Extract Functions.en.srt	20.2 KB
020 Where Clause On TIMESTAMP Columns And Some Useful Extract Functions.mp4	133.5 MB
021 Quiz 4_ Where Clause Quiz With Timestamp Column.html	1.8 KB
021 quiz4.pdf	18.9 KB
022 Quiz 4_ Solution.html	0.9 KB
022 quiz4-solutions.pdf	21.9 KB
023 14-where-clause-null-and-not-null.html	17.5 KB
023 Where Clause_ IS NULL & IS NOT NULL.en.srt	5.5 KB
023 Where Clause_ IS NULL & IS NOT NULL.mp4	35.8 MB
/.../04 Group By And Aggregate Functions/
024 15-intro-group-by-and-data-studio.html	16.8 KB
024 Intro to Group By, Aggregation, and Google's Data Studio Visualization Tool.en.srt	16.7 KB
024 Intro to Group By, Aggregation, and Google's Data Studio Visualization Tool.mp4	104.6 MB
025 16-explain-group-by-detail.html	34.1 KB
025 Group By And Aggregation Functions_ MAX MIN SUM COUNT AVG.en.srt	31.0 KB
025 Group By And Aggregation Functions_ MAX MIN SUM COUNT AVG.mp4	201.0 MB
026 17-group-by-example-count-with-where-clause.html	15.9 KB
026 Group By Example_ COUNT with WHERE Clause and Visualization In Data Studio.en.srt	19.5 KB
026 Group By Example_ COUNT with WHERE Clause and Visualization In Data Studio.mp4	121.0 MB
027 18-group-by-example-with-sum.html	15.6 KB
027 Group By Example_ SUM and Visualization In Data Studio.en.srt	10.1 KB
027 Group By Example_ SUM and Visualization In Data Studio.mp4	70.9 MB
028 19-group-by-example-with-max-min-avg.html	16.5 KB
028 Group By Example_ MAX MIN AVG with WHERE and Visualization In Data Studio.en.srt	14.0 KB
028 Group By Example_ MAX MIN AVG with WHERE and Visualization In Data Studio.mp4	110.5 MB
029 Group BY Example_ COUNT with HAVING and Visualization In Data Studio.en.srt	10.1 KB
029 Group BY Example_ COUNT with HAVING and Visualization In Data Studio.mp4	69.9 MB
030 Quiz 5_ Group By And Aggregate Functions Quiz.html	1.2 KB
030 quiz5.pdf	19.2 KB
031 Quiz 5 Solutions.html	0.9 KB
031 quiz5-solutions.pdf	24.4 KB
032 21-group-by-multiple-columns.html	25.2 KB
032 Grouping By Multiple Columns Explanation.en.srt	13.8 KB
032 Grouping By Multiple Columns Explanation.mp4	95.4 MB
033 22-group-by-multiple-columns-example.html	17.0 KB
033 Grouping By Multiple Columns Example.en.srt	12.3 KB
033 Grouping By Multiple Columns Example.mp4	82.2 MB
/.../05 Project 1_ New York Citi Bike Dashboard/
034 23-project-1-outline.html	714.9 KB
034 Project Intro.en.srt	6.3 KB
034 Project Intro.mp4	47.9 MB
035 Quick Intro to Google Data Studio Reporting and Data Sources.en.srt	7.7 KB
035 Quick Intro to Google Data Studio Reporting and Data Sources.mp4	54.3 MB
036 25-prepare-ny-city-bike-by-day-data-question.html	85.5 KB
036 Prepare Data Set Question_ NY Citi Bike By Day.en.srt	2.8 KB
036 Prepare Data Set Question_ NY Citi Bike By Day.mp4	18.6 MB
037 26-prepare-ny-city-bike-by-day-data-answer.html	89.9 KB
037 Prepare Data Set Answer_ NY Citi Bike By Day.en.srt	2.6 KB
037 Prepare Data Set Answer_ NY Citi Bike By Day.mp4	34.3 MB
038 Prepare Data Set Data Studio_ NY Citi Bike By Day.en.srt	11.9 KB
038 Prepare Data Set Data Studio_ NY Citi Bike By Day.mp4	46.8 MB
039 28-prepare-remaning-ny-city-bike-day-data-sets-in-data-studio.html	946.1 KB
039 Prepare Remaining Three Data Sets In Data Studio_ NY Citi Bike Project.en.srt	16.5 KB
039 Prepare Remaining Three Data Sets In Data Studio_ NY Citi Bike Project.mp4	101.1 MB
040 Create Dashboard in Data Studio.en.srt	27.7 KB
040 Create Dashboard in Data Studio.mp4	233.6 MB
/.../06 Joins (Joining Multiple Tables Together)/
041 30-intro-to-joins.html	201.2 KB
041 Intro to Joins.en.srt	26.9 KB
041 Intro to Joins.mp4	146.6 MB
042 31-left-join-big-query-census-data.html	17.8 KB
042 Left Join Example Big Query Census Data.en.srt	15.6 KB
042 Left Join Example Big Query Census Data.mp4	90.1 MB
043 32-inner-join-big-query-duplicate-example-taxi-trips.html	20.4 KB
043 Joining Tables with Duplicate Records Leads to Duplicate Results Example.en.srt	11.3 KB
043 Joining Tables with Duplicate Records Leads to Duplicate Results Example.mp4	87.6 MB
044 33-lower-function-and-joining-on-strings.html	16.8 KB
044 Trimming and Lowering When Joining on Columns of Type String.en.srt	13.4 KB
044 Trimming and Lowering When Joining on Columns of Type String.mp4	90.0 MB
045 34-joins-with-aggregates.html	25.4 KB
045 Joins & Where Clause & Group By and Aggregate_ Putting it all together Examples.en.srt	19.8 KB
045 Joins & Where Clause & Group By and Aggregate_ Putting it all together Examples.mp4	142.2 MB
046 35-join-multiple-tables-and-multiple-columns.html	19.0 KB
046 Joining On Multiple Columns With Multiple Tables (More than 2).en.srt	18.1 KB
046 Joining On Multiple Columns With Multiple Tables (More than 2).mp4	135.6 MB
/.../07 Census International Data Dashboard Project/
047 36-project-international-census.html	19.0 KB
047 Project Intro.en.srt	30.4 KB
/.../08 Big Query Standard SQL Functions/
048 37-intro-more-sql-functions.html	12.1 KB
048 Intro to Big Query Standard SQL Functions.en.srt	3.6 KB
048 Intro to Big Query Standard SQL Functions.mp4	32.7 MB
049 38-cast-functions.html	17.3 KB
049 Examples With Cast Function.en.srt	6.7 KB
049 Examples With Cast Function.mp4	47.9 MB
050 39-math-functions.html	16.8 KB
050 Examples with Mathematical Functions.en.srt	14.2 KB
050 Examples with Mathematical Functions.mp4	82.9 MB
051 40-string-functions.html	18.1 KB
051 Examples with String Functions.en.srt	12.5 KB
051 Examples with String Functions.mp4	88.1 MB
052 41-date-time-functions.html	21.9 KB
052 Examples with Date and Timestamp Functions.en.srt	21.0 KB
052 Examples with Date and Timestamp Functions.mp4	139.8 MB
053 assignment-functions-sql.html	85.0 KB
053 Practice Questions for SQL Functions Section.en.srt	0.6 KB
053 Practice Questions for SQL Functions Section.mp4	889.1 KB
054 assignment-functions-sql-solutions.html	1.1 MB
054 Solutions for SQL Functions Questions.en.srt	0.3 KB
054 Solutions for SQL Functions Questions.mp4	589.2 KB
/.../09 Case Statements/
055 44-intro-case-statements.html	76.3 KB
055 Intro to Case Statement Syntax and Example.en.srt	9.5 KB
055 Intro to Case Statement Syntax and Example.mp4	53.9 MB
056 45-case-statement-example.html	20.3 KB
056 Case Statement Examples.en.srt	9.2 KB
056 Case Statement Examples.mp4	56.1 MB
/.../10 Next Steps_ Start Your Own Projects!/
057 Start Your Own Projects!.en.srt	4.9 KB
057 Start Your Own Projects!.mp4	49.9 MB
Total files 156