English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 10m | 183 MB
Want to test—and develop—your SQL data-engineering skills? Do you fancy yourself pretty skilled at SQL and want to see just how sharp you are? Then check out this installment of the Code Challenges series, as instructor Harshit Tyagi presents a number of challenges requiring you to write SQL queries to solve problems and answer questions. The challenges start at a relatively low level of difficulty—column selection, filtering rows from data, sorting and grouping query results—and get progressively tougher, testing you on topics like handling missing and invalid data, calculating moving window average, and data transformations. The challenges are all a few minutes long, and use a single database, so you can jump around from challenge to challenge or watch the entire course. So, if you want to see if you’re equal to the tasks, try out these SQL challenges.
Table of Contents
Introduction
1 Up for a code challenge
1. SQL Fundamentals
2 Column selection
3 Filtering rows from data
4 Removing duplicate data
5 Sorting and grouping query results
2. SQL Joins
6 Inner joins
7 Outer and cross joins
8 Set theory for SQL joins
3. Writing Complex Queries
9 Using OVER and PARTITION BY statements
10 Filtering and subsetting data
11 Using CASE and WHEN statements
12 Calculating moving window average
4. Data Cleaning with SQL
13 Partitioning dates with the DATE PART function
14 Text formatting and pattern matching
15 Using COALESCE to replace null values
16 Sorting with regular expressions
Resolve the captcha to access the links!