Posts under this category will deal with beginner to advanced SQL Concepts. Most of the articles here will have a easier version explained in SQL Beginner articles.
This is to make sure we cover topics according to the levels of understanding.
How does SQL Index Work is a question that requires an answer which is creative , imaginative & precise in it’s nature. SQL Index is one of the most important and famous tool in the world of SQL developers. Developing it’s working mechanism and behaviour will help you in deciding whether it’s going to complete your requirements or not.
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 …
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. …
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 …