SQL Weekly Tips
2h 55mBeginner2023-06-28
Authors
Mark Niemann-Ross
Technologist experienced in hardware, software, and science fiction
Course details
Structured Query Language (SQL) is a vital tool in a data professional’s toolkit. You can use it to manage data in relational databases, perform various operations on the data you can manage, and more. In this series, Mark Niemann-Ross introduces you to a variety of useful tips, tricks, styles, and details to help you fine-tune and enhance the ways you use SQL. Mark breaks down SQL topics, ranging from formatting styles to selecting random numbers, into manageable chunks that you can enjoy over a lunch break or any other time that you have a few spare minutes to learn.
Skills covered
Serial (Weekly)SQLDatabase AdministrationDatabase DevelopmentDatabase ManagementData AnalysisProgramming LanguagesData ScienceBusiness Analysis and StrategyBusiness Software and ToolsOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Introduction to SQL weekly
- 02 - What you need to know
1. SQL for Data Professionals - Lunch Break Lessons (Jul Sep 2022)
- 03 - SQL formatting styles
- 04 - Compare SQLite to MySQL
- 05 - SQL select distinct
- 06 - SQL select where
- 07 - SQL select having
- 08 - SQL select group
- 09 - SQL select order
- 10 - SQL select having expressions
- 11 - SQL select as
- 12 - SQL select ORDER
- 13 - SQL select LIMIT
- 14 - SQL create RAND
2. SQL for Data Professionals - Lunch Break Lessons (Oct Dec 2022)
- 15 - More on RAND
- 16 - VS code with SQL
- 17 - SQL variables
- 18 - Conditional IF statement in SQL
- 19 - IFNULL and NULLIF
- 20 - Conditional CASE statement in SQL
- 21 - Conditional BETWEEN statement in SQL
- 22 - GREATEST and LEAST in SQL
- 23 - MAX and MIN in SQL
3. SQL for Data Professionals - Lunch Break Lessons (Jan Mar 2023)
- 24 - Regular expressions with SQL - LIKE
- 25 - Regular expressions with SQL - Index
- 26 - Regular expressions with SQL - REPLACE
- 27 - SQL version
- 28 - Use LIKE for string comparison
- 29 - Use IN for string comparison
- 30 - Use STRCMP for multiple string comparisons
- 31 - Use SOUNDEX and SOUNDS LIKE for strings
- 32 - Remove NULL with COALESCE
- 33 - Use SUBSTRING to select string parts
- 34 - Trim strings with TRIM and friends
- 35 - SQL LENGTH returns string lengths
- 36 - LOCATE a substring in a string
4. SQL for Data Professionals - Lunch Break Lessons (Apr Jun 2023)
- 37 - Concatenation with CONCAT and CONCAT WS
- 38 - Find strings in lists with ELT and FIELD
- 39 - Convert IOT sensor data with EXPORT SET and MAKE SET
- 40 - Use FORMAT to put commas and decimals in numbers
- 41 - Convert decimals to hex, binary, or octal with HEX, BIN, and OCT
- 42 - Use REVERSE to reverse the characters in a string
- 43 - Use RPAD and LPAD to line up numbers
- 44 - Use REPLACE to replace occurrences of a specified string
- 45 - Round up and down with FLOOR, ROUND, TRUNCATE, and CEILING
- 46 - Use SQL to create the average of a group of numbers
- 47 - SQL JOIN
- 48 - SQL LEFT JOIN
- 49 - SQL INNER JOIN