Reading Time: 9 minutes The SQL Server LEFT JOIN is one of the most useful tools we have when querying SQL Server database. If you plan on working with Microsoft SQL Server databases for more than 10 minutes, you should expect to encounter a LEFT JOIN early in your career. It’s very important to know Continue Reading
INNER JOIN in SQL Server: The Ultimate Guide for Beginners
Reading Time: 14 minutes The INNER JOIN operator is probably one of the most widely used tools we have when querying databases. If you plan on working with databases for more than 5 minutes, you should plan on encountering an INNER JOIN very early on in your career. Knowing what an INNER JOIN is Continue Reading
Common Table Expression (CTE) in SQL: Everything you need to know
Reading Time: 8 minutes Common Table Expressions (CTE’s) are a very useful tool available to us when querying databases in Microsoft SQL Server. CTE’s can help you gather the information you want quickly without needing to write much code, or persist an object in the database. Common Table Expressions are just one type of Continue Reading
Derived Table in SQL Server: Everything you need to know
Reading Time: 9 minutes When learning about table expressions, the first and most simple table expressions you can learn is the Derived Table. They can help you gather the information you want quickly without needing to write much code. Derived Tables are just one type of table expression we have available to us in Continue Reading
SQL Server Table Expressions: The Ultimate Guide for Beginners
Reading Time: 10 minutes There are several different kinds of table expressions you need to be aware of when learning to query and develop SQL Server databases. Each kind of table expression has it’s own strengths and weaknesses, and it is important for you to understand those strengths and weaknesses so you know which Continue Reading