Category: Exam Preparation

NOTES | Getting Started with the SELECT Statement

Using the FROM and SELECT Clauses The FROM and SELECT clauses are two principal clauses that appear in almost every query that retrieves data. When you execute a SELECT statement, it usually retrieves one or more rows of information – the exact number depends on how you construct the statement. These rows are collectively known as a result set. Brief summary of the clauses in a SELECT statement: The FROM Clause FROM – This is the second most important clause in the SELECT statement and is also required. You use the FROM clause to specify the tables or views from… Read More

NOTES | Foundations of Querying

Foundations of Querying T-SQL is the main language used to manage and manipulate data in Microsoft’s main relational database management system (RDBMS), SQL Server—whether on premises or in the cloud (Microsoft Windows Azure SQL Database). It all stems from the mathematical principals of set theory and predicate logic. T-SQL is a dialect of standard SQL and therefore the core elements look the same. However, all leading database vendors decides which features to implement and which to not. Also, each vendor usually implements extensions to the standard in cases where the vendor feels an important feature is not covered by the… Read More