Choose data types
Understand what data types are, why they are important, and how they affect storage requirements
Understand tables and how to create them
Purpose of tables; create tables in a database by using proper ANSI SQL syntax
Create views
Understand when to use views and how to create a view by using T-SQL or a graphical designer
Create stored procedures and functions
Select, insert, update, or delete data
Understand how T-SQL can be used to create database objects, such as tables and views