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.

References

• Exam 98-364 Database Administration Fundamentals Student Study Guide
• Microsoft: Database Fundamentals Exam Details