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
This objective may include but is not limited to: understanding what data types are, why they are important, and how they affect storage requirements.
 * 1) Read Bits & Bytes: Lesson 3.
 * 2) Read Data Types.
 * 3) Read Data Types.

Activity 2 - Understand Tables and How to Create Them
This objective may include but is not limited to: purpose of tables; creating tables in a database by using proper ANSI SQL syntax.
 * 1) Read Creating a Table.
 * 2) Read CREATE TABLE.
 * 3) Read CREATE TABLE.

Activity 3 - Create Views
This 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.
 * 1) Read Transact-SQL Overview.
 * 2) Read Transact-SQL Reference.
 * 3) Read Beginner's Guide to SQL Server Compact.
 * 4) Read Query Fundamentals.
 * 5) Read Fundamental Microsoft Jet SQL for Access 2000.
 * 6) Read Graphical Query Designer User Interface.

Activity 4 - Create Stored Procedures and Functions
This objective may include but is not limited to: selecting, inserting, updating, or deleting data.
 * 1) Read Aggregate Functions.
 * 2) Read Types of Functions.
 * 3) Read SQL User-Defined Functions.