Download the course outline
in PDF format.

This download requires the Adobe Acrobat PDF Reader, available for free at the Adobe Web site.

Nova Networks delivers in-depth, real world training solutions. Nova's training courses are designed to help our clients increase workplace performance and productivity. Nova combines Official Curriculum materials with field experienced certified instructors and a quality guarantee to deliver cost effective, practically applied training solutions.

M2723 - MS SQL Server 2000 for Experienced Database Professionals - 3 days

[ Course Schedule ]

Module 1: SQL Server Product Overview

This module introduces key components of SQL Server architecture and describes the structure of databases in SQL Server, related definitions, and terminology.

Lessons

• Introduction to SQL Server Architecture
• SQL Server Programming Environment

Lab A: Working with SQL Server Tools

• Using SQL Server Enterprise Manager and SQL Query Analyzer
• Creating Columns That Have the Identity Data Type
• Creating Columns That Have the Uniqueidentifier Data Type
• Working with Metadata
• Retrieving XML Result Sets

After completing this module, students will be able to:

• Describe the architecture of SQL Server and its programming environment.
• Describe the architecture of SQL Server in terms of its major components and tools.
• Describe the SQL Server programming environment.

Module 2: SQL Server Components

This module introduces the key components of SQL Server relational database management system (RDBMS) architecture and their use in configuring and optimizing SQL Server. The module also describes the structure of databases in SQL Server, related definitions, and terminology.

Lessons

• Relational Engine
• Analyzing Query Plans
• Memory and Processes
• Client Connectivity

Lab A: Creating Databases

• Writing Scripts for Creating a Database
• Creating a Database with Multiple Files and Filegroups
• Configuring Server/Client Network Libraries
• Using Extended Stored Procedures
• Troubleshooting Queries by Using SHOWPLAN
• Optimizing Queries by Using the Index Tuning Wizard

After completing this module, students will be able to:

• Describe key components of SQL Server RDBMS architecture.
• Describe SQL Server components.
• Describe relational engine architecture.
• Describe tools and methods that are used to maintain efficient queries.
• Describe query execution plans and how SQL Server can optimize them.
• Describe memory architecture and management.
• Describe SQL Server threads and process management.
• Describe the process, tools and techniques for connecting clients to SQL Server.

Module 3: SQL Server Storage Subsystems

This module describes the storage structures of SQL Server, index architecture and indexing strategies and how they are unique in SQL Server, how to manage indexes, and finally how to work with SQL Server statistics.

Lessons

• SQL Server Storage Structures
• SQL Server Index Architecture
• Managing Indexes
• Working With Statistics

Lab A: Examining Disk Storage Structures

• Examining Indexes by Using DBCC Page
• If Time Permits: Examining Heaps by Using DBCC Page

After completing this module, students will be able to:

• Describe key components of SQL Server storage subsystem architecture.
• Describe SQL Server storage architecture.
• Describe SQL Server index architecture.
• Manage SQL Server indexes.
• Describe approaches to working with statistics.

Module 4: SQL Server Administration

This module provides students with the knowledge and skills necessary to administer and manage Microsoft® SQL Server™ in a multiple server environment.

Contact the training coordinator for pricing and details at 613-563-NOVA (6682) Ext:267 0r training@novaknowledge.com
Nova Networks can also customize this course to topics of your choice which will reduce the course cost.

Copyright Statement

This site is Copyright © 2007 Nova Networks Inc. Reproduction of any part of this site for personal or commercial purposes without permission is strictly prohibited. The information at this site may be downloaded onto a disk or printed for your personal use provided that you include this copyright notice on each copy and that you make no alterations to any of the pages and do not use any of the information in any other work or publication whatsoever whether the publication is paper based or electronic. No part of the information may be distributed or copied for any commercial purpose.