Core Concepts

In this section, we will start with the core concepts of MS SQL Server. Specifically, we will look at

• Database Concepts / Database Objects
• SQL Types
• MSSQL Constraints
• T-SQL Statements

We will discuss the various T-SQL Statements, data types, tables, and cover examples around select, update, delete and alter.