~Get Your Files Here !

  Ex_Files_Intermediate_SQL_for_Data_Scientists

   Exercise Files

    CH02

     02_03.sql

     02_05.sql

    CH03

     03_02.sql

     03_04.sql

    CH04

     04_02.sql

     04_04.sql

     04_06.sql

     04_09.sql

    CH05

     05_02.sql

     05_04.sql

    CH06

     06_03.sql

     06_05.sql

  [1] Introduction

   [1] The need for SQL in data science.srt

   [2] What you should know.srt

  [2] 1. Foundations of SQL for Data Science

   [1] Overview of data science operations.srt

   [2] Data manipulation commands.srt

   [3] Data definition commands.srt

   [4] SQL standards.srt

   [5] Installing PostgreSQL.srt

  [3] 2. Basic Statistics with SQL

   [1] Loading data.srt

   [2] Basic aggregate functions.srt

   [3] Statistical aggregate functions.srt

   [5] Joining and filtering data.mp4

   [6] Challenge Test an attribute for normal distribution.mp4

   [7] Solution Test an attribute for normal distribution.srt

  [4] 3. Data Munging with SQL

   [1] Reformat character data.srt

   [2] Extract strings from character data.srt

   [3] Filter with regular expressions.srt

   [4] Reformat numeric data.srt

   [5] Use SOUNDEX with misspelled text.srt

   [6] Challenge Prepare a data set for analysis.srt

   [7] Solution Prepare a data set for analysis.srt

  [5] 4. Filtering and Aggregation

   [1] Use the HAVING clause to find subgroups.srt

   [2] Subqueries for column values.srt

   [3] Subqueries in FROM clauses.srt

   [4] Subqueries in WHERE clauses.srt

   [5] Use ROLLUP to create subtotals.srt

   [6] Use CUBE to total across dimensions.srt

   [7] Use Top-N queries to find top results.srt

   [8] Challenge Filter and aggregate a data set.srt

   [9] Solution Filter and aggregate a data set.srt

  [6] 5. Window Functions and Ordered Data

   [1] Introduction to window functions.srt

   [2] NTH_VALUE and NTILE.srt

   [3] RANK, LEAD, and LAG.srt

   [4] WIDTH_BUCKET and CUME_DIST.srt

   [5] Challenge Segment a data set using Window functions.srt

   [6] Solution Segment a data set using Window functions.srt

  [7] 6. Common Table Expressions

   [1] Introduction to common table expressions (CTEs).srt

   [2] Multiple table common table expressions.srt

   [3] Hierarchical tables.srt

   [4] Recursive common table expressions.srt

   [5] Challenge Rewrite a complex query to use CTEs.srt

   [6] Solution Rewrite a complex query to use CTEs.srt

  [8] Conclusion

   [1] Next steps.srt