SQL for Data Professionals: Lunch Break Lessons

Introduction

• Introduction to SQL weekly
• What you need to know

1. SQL for Data Professionals: Lunch Break Lessons (Jul–Sep 2022)

• SQL formatting styles
• Compare SQLite to MySQL
• SQL select distinct
• SQL select where
• SQL select having
• SQL select group
• SQL select order
• SQL select having expressions
• SQL select as
• SQL select ORDER
• SQL select LIMIT
• SQL create RAND

2. SQL for Data Professionals: Lunch Break Lessons (Oct–Dec 2022)

• More on RAND
• VS code with SQL
• SQL variables
• Conditional IF statement in SQL
• IFNULL and NULLIF
• Conditional CASE statement in SQL
• Conditional BETWEEN statement in SQL
• GREATEST and LEAST in SQL
• MAX and MIN in SQL

3. SQL for Data Professionals: Lunch Break Lessons (Jan–Mar 2023)

• Regular expressions with SQL: LIKE
• Regular expressions with SQL: Index
• Regular expressions with SQL: REPLACE
• SQL version
• Use LIKE for string comparison
• Use IN for string comparison
• Use STRCMP for multiple string comparisons
• Use SOUNDEX and SOUNDS LIKE for strings
• Remove NULL with COALESCE
• Use SUBSTRING to select string parts
• Trim strings with TRIM and friends
• SQL LENGTH returns string lengths
• LOCATE a substring in a string

4. SQL for Data Professionals: Lunch Break Lessons (Apr–Jun 2023)

• Concatenation with CONCAT and CONCAT_WS
• Find strings in lists with ELT and FIELD
• Convert IOT sensor data with EXPORT_SET and MAKE_SET
• Use FORMAT to put commas and decimals in numbers
• Convert decimals to hex, binary, or octal with HEX, BIN, and OCT
• Use REVERSE to reverse the characters in a string
• Use RPAD and LPAD to line up numbers
• Use REPLACE to replace occurrences of a specified string
• Round up and down with FLOOR, ROUND, TRUNCATE, and CEILING
• Use SQL to create the average of a group of numbers
• SQL JOIN
• SQL LEFT JOIN
• SQL INNER JOIN