7 Useful SQL Features You Probably Don’t Know

📝 Get my free SQL Cheat Sheets: https://www.databasestar.com/get-sql-...
🎓 Turn your idea into a real database: https://databasestar.mykajabi.com/edd...

After you learn the basics of SQL, what's next?

There are a lot of features in all vendors of SQL (e.g. Oracle, SQL Server, MySQL, Postgres) that you might not know about, but can really improve how you work with databases and SQL.

In this video, you'll learn 7 different SQL features, what they are, and see SQL examples of how to use them in Oracle, SQL Server, MySQL, and Postgres.

⏱ TIMESTAMPS:
00:00 - Introduction
00:37 - Window Functions
03:45 - CTEs
05:36 - Row Limiting
07:29 - Auto Increment
11:10 - Temp Tables
14:21 - Bind Variables
16:30 - Pivot Tables

🔗 VIDEO LINKS:
Scripts used in this video: https://github.com/bbrumm/databasesta...

Window Functions: https://www.databasestar.com/sql-wind...
CTEs: https://www.databasestar.com/sql-cte-...
Row Limiting: https://www.databasestar.com/sql-limit/
Auto Increment: https://www.databasestar.com/sql-auto...
Temp Tables: https://www.databasestar.com/sql-temp...
Bind Variables: https://www.databasestar.com/sql-bind...
Oracle Pivot: https://www.databasestar.com/oracle-s...
SQL Server Pivot: https://www.databasestar.com/sql-serv...
MySQL Pivot: https://www.databasestar.com/mysql-pi...

• #science_technology
• #advanced_sql
• #sql_features
• #sql