SQL Index Tutorial | SQL Optimisation Part 1

SQL index is a distinct structure in the database that is built using the CREATE INDEX statement. Mostly , DBAs love & hate SQL indexes at the same time due to the tricky nature they posses. They can either speed up your databases or slow it down , depending on how correctly you have implemented … Continue reading SQL Index Tutorial | SQL Optimisation Part 1

Table vs View – All You Need To Know

Table vs View is a topic of debate among DBAs and beginners because the similarities they both share . We will discuss various aspects of both tables and views . Such as: Difference between Table vs View. Table vs View Performance. Advantages of Views in SQL In SQL Beginner's Guide we have developed basic understanding about views. … Continue reading Table vs View – All You Need To Know

How Grouping Works in SQL

One of our subscribers reached us and asked How Grouping works in SQL ?  So today , this is what we are going to do . We will discuss in detail about grouping in SQL and how it actually works behind the scenes. Also , this is our first post in Questions category and we will … Continue reading How Grouping Works in SQL