SQL Savvy Function List

SQL Savvy Function List is a comprehensive spreadsheet designed for SQL newbies who want to learn and stay organized with SQL basics and functions. It consists of seven different sheets for Basic SQL Functions, Table Functions, Null Functions, Operators, Aggregate Functions, String Functions, Date Functions, and Analytical Functions.

Each sheet contains a list of specific functions for you to know, along with columns such as Function Name, Function Definition, Syntax, Code Examples, Usage Examples, Tips, and Notes. This allows you to easily understand each function and its usage in SQL.

There's also a list of resources for you to develop your SQL skills.

Some of the functions include:

BASIC FUNCTIONS:

SELECT, FROM, WHERE, ORDER BY, HAVING, LEFT JOIN, RIGHT JOIN, INNER JOIN, FULL OUTER JOIN, DISTINCT, CASE, TOP

AGGREGATE FUNCTIONS:

AVG, COUNT, MAX, MIN, SUM, GROUP BY

STRING FUNCTIONS:

CHARINDEX, LEN, LOWER, LTRIM, RTRIM, SUBSTRING, UPPER

& more!

The spreadsheet isn't an all-encompassing SQL list. As you learn more about SQL and the different functions that are used in different relational databases, you can add more comments or notes to the spreadsheet. Be aware that different relational databases are going to have a similar function but different syntax.

*P.S. All sales are final

The file is .xlsx (a Microsoft Excel file type). You can open this in Microsoft Excel and if you don't have a Microsoft subscription you can still open this file in Google Sheets which is free (preferred to keep the formatting of the spreadsheet). I added a protection feature to the spreadsheet so that when you download the file, the rows and column sizes are maintained so that you can view all of the text without having to manually resize it. When you try to edit the spreadsheet you'll get a pop-up message about the sheet being protected but you can undo the protection feature. See the screenshot below to undo the protection feature in Google Sheets:

1. Click the Data tab
2. Select 'Protect sheets and ranges'
3. Click the trash can icon
4. Click done

Shoot me an email at river@data-queen.co if you face any issues with your download.