PinnedQuick Look Into SQL Order ExecutionHow to understand better the execution of your everyday code.Nov 22, 2022Nov 22, 2022
Published inLevel Up Coding15 Essential SQL Best Practices15 Best Practices that will level up your SQL coding.Dec 21, 2023Dec 21, 2023
Published inLevel Up CodingA Basic Introduction To Stored ProceduresLearn to use stored procedures, one of the most powerful database tools.Nov 29, 2022Nov 29, 2022
Published inLevel 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
Mastering Aggregate Functions in SQLWhy every developer should learn how to use them.Nov 24, 2022Nov 24, 2022
ROW_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