~Get Your Files Here !

  Ex_Files_SQL_Data_Sci_Code_Challenges

   Exercise Files

    SQL_Challenge_Backup_psql

  [1] Introduction

   [1] Up for a code challenge.srt

  [2] 1. SQL Fundamentals

   [1] Column selection.srt

   [2] Filtering rows from data.srt

   [3] Removing duplicate data.srt

   [4] Sorting and grouping query results.srt

  [3] 2. SQL Joins

   [1] Inner joins.srt

   [2] Outer and cross joins.srt

   [3] Set theory for SQL joins.srt

  [4] 3. Writing Complex Queries

   [1] Using OVER and PARTITION BY statements.srt

   [2] Filtering and subsetting data.srt

   [3] Using CASE and WHEN statements.srt

   [4] Calculating moving window average.srt

  [5] 4. Data Cleaning with SQL

   [1] Partitioning dates with the DATE_PART function.srt

   [2] Text formatting and pattern matching.srt

   [3] Using COALESCE to replace null values.srt

   [4] Sorting with regular expressions.srt