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