PinnedEmilio Eguia·Nov 22, 2022Quick Look Into SQL Order ExecutionHow to understand better the execution of your everyday code.
InLevel Up CodingbyEmilio Eguia·Dec 21, 202315 Essential SQL Best Practices15 Best Practices that will level up your SQL coding.
InLevel Up CodingbyEmilio Eguia·Nov 29, 2022A Basic Introduction To Stored ProceduresLearn to use stored procedures, one of the most powerful database tools.
InLevel Up CodingbyEmilio Eguia·Nov 29, 2022SQL Parameters In Stored ProceduresLearn to use parameters in SQL stored procedures, and make your code more versatile and reliable.
Emilio Eguia·Nov 24, 2022Mastering Aggregate Functions in SQLWhy every developer should learn how to use them.
Emilio Eguia·Nov 22, 2022ROW_NUMBER() vs RANK() vs DENSE_RANK()The RANK, DENSE_RANK and ROW_NUMBER functions are used to return an increasing integer number. All of these three functions require the…