PinnedEmilio EguiaQuick Look Into SQL Order ExecutionHow to understand better the execution of your everyday code.3 min read·Nov 22, 2022----
Emilio EguiainLevel Up Coding15 Essential SQL Best Practices15 Best Practices that will level up your SQL coding.4 min read·Dec 21, 2023----
Emilio EguiainLevel Up CodingA Basic Introduction To Stored ProceduresLearn to use stored procedures, one of the most powerful database tools.3 min read·Nov 29, 2022----
Emilio EguiainLevel Up CodingSQL Parameters In Stored ProceduresLearn to use parameters in SQL stored procedures, and make your code more versatile and reliable.4 min read·Nov 29, 2022----
Emilio EguiaKeyboard Shortcuts for WindowsTo be efficient and fast on the computer.4 min read·Nov 24, 2022----
Emilio EguiaMastering Aggregate Functions in SQLWhy every developer should learn how to use them.5 min read·Nov 24, 2022----
Emilio EguiaROW_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…3 min read·Nov 22, 2022----