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.
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.
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.
- 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
This objective may include but is not limited to: selecting, inserting, updating, or deleting data.