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

This article is issued from Wikiversity. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.