SQL Server for Developers (3 days)

30 JULY 2008

3 SEP 2008

T.B.A.

$1,395

Special Value: This course is based on an abbreviated version of the Microsoft MOC-2073 course, which is normally a 5 day class. Students receive the complete set of courseware materials for the price of a 3 day class.

SQL Server for Developers
Microsoft Official Curriculum
(Microsoft Course MOC-2073)

This three-day, hands-on course provides students with the technical skills required to program a database solution using Microsoft SQL Server 2000.

At Course Completion

At the end of the course, students will be able to:

• Describe the elements of SQL Server 2000
• Design a SQL Server Enterprise Application architecture
• Describe the conceptual basis of programming in Transact-SQL
• Create and manage databases and their related components
• Implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers
• Create, use, and maintain data views
• Implement user-defined functions
• Design, create, and use stored procedures
• Create and implement triggers
• Optimize query performance
• Manage transactions and locks to ensure data concurrency and recoverability

Course Outline

Module 1: Microsoft SQL Server Overview

• SQL Server Integration
• SQL Server Databases
• SQL Server Security
• Working with SQL Server

Module 2: Overview of Programming SQL Server

• Designing Enterprise Application Architecture
• SQL Server Programming Tools
• The Transact-SQL Programming Language
• Elements of Transact-SQL
• Additional Language Elements
• Ways to Execute Transact-SQL Statement

Module 3: Creating and Managing Databases

• Creating Databases
• Creating Filegroups
• Managing Databases
• Start and stop SQL Server services
• Introduction to Data Structures

Module 4: Creating Data Types and Tables

• Creating Data Types
• Creating Tables
• Generating Column Values
• Generating Scripts

Module 5: Implementing Data Integrity

• Types of Data Integrity
• Enforcing Data Integrity
• Defining Constraints
• Types of Constraints
• Disabling Constraints
• Using Defaults and Rules
• Deciding Which Enforcement Method to Use

Module 6: Implementing Views

• Advantages of Views
• Defining Views
• Modifying Data Through Views
• Optimizing Performance by Using Views
• Performance Considerations

Module 7: Implementing Stored Procedures

• Creating and Executing Stored Procedures
• Using Parameters in Stored Procedures
• Executing Extended Stored Procedures
• Handling Error Messages
• Performance Considerations

Module 8: Implementing User-Defined Functions

• Creating Scalar-type User-defined Functions
• Creating Table-type User-defined Functions
• Examples of User-defined Functions

Module 9: Implementing Triggers

• Defining Triggers
• How Triggers Work
• Examples of Triggers
• Performance Considerations

Module 10: Optimizing Query Performance

• Obtaining Execution Plan Information
• Using an Index to Cover a Query
• Indexing Strategies
• Overriding the Query Optimizer

Module 11: Managing Transactions and Locks

• Managing Transactions
• SQL Server Locking
• Managing Locks

Register for classes online by clicking here or
give us a call at 1-888-600-ALTO (2586).