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
[edit | edit source]This 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
[edit | edit source]This 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
[edit | edit source]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.
- Read Transact-SQL Overview.
- Read Transact-SQL Reference.
- Read Beginner's Guide to SQL Server Compact.
- Read Query Fundamentals.
- Read Fundamental Microsoft Jet SQL for Access 2000.
- Read Graphical Query Designer User Interface.
Activity 4 - Create Stored Procedures and Functions
[edit | edit source]This 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.