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
Introduction
- Introduction to SQL weekly
- What you need to know
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
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
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
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