Exam 98-364: Database Fundamentals/Creating Database Objects

From Wikiversity
Jump to navigation Jump to search

This lesson covers Creating Database Objects. It looks at data types, tables, views, stored procedures and functions.

Activity 1 - Choose Data Types[edit]

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[edit]

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[edit]

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[edit]

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[edit]