Understand how data is stored in tables
Understand what a table is and how it relates to the data that will be stored in the database; columns/fields, rows/records
Understand relational database concepts
Understand what a relational database is, the need for relational database management systems (RDBMS), and how relations are established
Understand data manipulation language (DML)
Understand what DML is and its role in databases
Understand data definition language (DDL)
Understand how T-SQL can be used to create database objects, such as tables and views