MOC-2073: Programming a Microsoft SQL Server 2000 Database

Module 1: SQL Server Overview.

- What is SQL Server?.

- 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.

- 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.

- Using Defaults and Rules.

- Deciding Which Enforcement Method to use.

Module 6: Planning Indexes.

- Introduction to Indexes.

- Index Architecture.

- How SQL Server Retrieves Stored Data.

- How SQL Server Maintains Index and Heap Structures.

- Deciding Which Columns to index.

Module 7: Creating and Maintaining Indexes.

- Creating indexes.

- Creating Index Options.

- Maintaining Indexes.

- Introduction to Statistics.

- Querying the sysindexes Table.

- Setting Up Indexes Using the Index Tuning Wizard.

- Performance Considerations.

Module 8: Implementing Views.

- Introduction to Views.

- Advantages of Views.

- Defining Views.

- Modifying Data Through Views.

- Optimizing Performance by Using Views.

- Performance Considerations.

Module 9: Implementing Stored Procedures.

- Introduction to Stored Procedures.

- Creating, Executing, Modifying, and Dropping Stored Procedures.

- Using Parameters in Stored Procedures.

- Executing Extended Stored Procedures.

- Handling Error Messages.

- Performance Considerations.

Module 10: Implementing Userdefined Functions.

- What Is a User-defined Function?.

- Defining User-defined Functions.

- Examples of User-defined Functions.

Module 11: Implementing Triggers.

- Introduction to Triggers.

- Defining Triggers.

- How Triggers Work.

- Examples of Triggers.

- Performance Considerations.

Module 12: Programming Across Multiple Servers.

- Introduction to Distributed Queries.

- Executing an Ad Hoc Query on a Remote Data Source.

- Setting Up a Linked Server Environment.

- Executing a Query on a Linked Server.

- Managing Distributed Transactions.

- Modifying Data on a Linked Server.

- Using Partitioned Views.

Module 13: Optimizing Query Performance.

- Introduction to the Query Optimizer.

- Obtaining Execution Plan Information.

- Using an Index to Cover a Query.

- Indexing Strategies.

- Overriding the Query Optimizer

Module 14: Analyzing Queries.

- Queries That Use the AND Operator.

- Queries That Use the OR Operator.

- Queries That Use Join Operations.

Module 15: Managing Transactions and Locks.

- Introduction to Transactions and Locks.

- managing Transactions.

- SQL Server Locking.

- Managing Locks

Requisitos:

Antes de asistir a este curso, el estudiante debería tener: Experiencia usando sistemas operativos Windows 2000; MOC-2151 Redes y fundamentos del sistema operativo Microsoft Windows 2000; MOC-2152 Implementar Microsoft Windows 2000 Professional y Server; Comprensión del concepto de base de datos relacional; Conocimiento básico de la sintaxis de sentencias SQL; Familiarizarse con los roles del Administrador de bases de datos.