Exam 98-364: Database Fundamentals/Creating Database Objects
This lesson covers Creating Database Objects. It looks at data types, tables, views, stored procedures and functions.
Activity 1 - Choose Data Types
editThis objective may include but is not limited to: understanding what data types are, why they are important, and how they affect storage requirements.
- Read Bits & Bytes: Lesson 3.
- Read Data Types.
- Read Data Types.
Activity 2 - Understand Tables and How to Create Them
editThis objective may include but is not limited to: purpose of tables; creating tables in a database by using proper ANSI SQL syntax.
- Read Creating a Table.
- Read CREATE TABLE.
- Read CREATE TABLE.
Activity 3 - Create Views
editThis objective may include but is not limited to: understanding when to use views and how to create a view by using T-SQL or a graphical designer.
Activity 4 - Create Stored Procedures and Functions
editThis objective may include but is not limited to: selecting, inserting, updating, or deleting data.
- Read Aggregate Functions.
- Read Types of Functions.
- Read SQL User-Defined Functions.