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