7 Useful SQL Features You Probably Don’t Know
Vložit
- čas přidán 21. 07. 2024
- 📝 Get my free SQL Cheat Sheets: www.databasestar.com/get-sql-...
🎓 Learn how to design an effective database and create it using SQL: 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: github.com/bbrumm/databasesta...
Window Functions: www.databasestar.com/sql-wind...
CTEs: www.databasestar.com/sql-cte-...
Row Limiting: www.databasestar.com/sql-limit/
Auto Increment: www.databasestar.com/sql-auto...
Temp Tables: www.databasestar.com/sql-temp...
Bind Variables: www.databasestar.com/sql-bind...
Oracle Pivot: www.databasestar.com/oracle-s...
SQL Server Pivot: www.databasestar.com/sql-serv...
MySQL Pivot: www.databasestar.com/mysql-pi... - Věda a technologie
You have a amazing personality!!! Become an online boss = Promo SM !
Thanks!