In order to play this video, you will need to install Adobe Flash player for your browser.
Audience
The primary audience for this course is database administrators who are experienced and proficient with enterprise database products such as Oracle, DB2, or Sybase. It will also help current database administrators who are experienced with Microsoft SQL Server 6.5 and earlier. This course is not for individuals who are experienced only in desktop database management systems such as Microsoft Access or individuals who are experienced in SQL Server 7.0.
At Course Completion
After completing this course, students will be able to:
Describe the architecture of SQL Server and its programming environment.
Describe the key components of SQL Server architecture.
Describe the key components of SQL Server storage subsystem architecture.
Describe the typical job tasks to administer and manage SQL Server in a multiple server environment.
Describe the process of developing a data recovery plan.
Describe the process of controlling data access and securing SQL Server.
Describe the tools and methods to monitor system and server activity.
Describe the tools and methods use to manage locks.
Describe the items that may affect performance in SQL Server.
Describe how to access homogenous and heterogeneous data sources.
Describe the processes and tools for moving data into and out of SQL Server.
Describe the processes and tools for analyzing data in SQL Server, using Analysis Services.
Prerequisites
This course requires that students meet the following prerequisites:
Database administrators who are experienced in Oracle, DB2, or Sybase. These database administrators have a technical depth of understanding of the database management systems (DBMS) that they currently administer, implement, and manage, and want to apply their database skills to SQL Server 2000.
Database administrators who are experienced in Microsoft SQL Server 4.2x, 6.0, or 6.5. (Secondary): These database administrators have a technical depth of understanding of the database systems that they currently administer, implement, and manage, and want to apply their current skills to SQL Server 2000.
To be successful in this class, students should have experience in administration and implementation of departmental or enterprise relational database management systems (RDBMS).
Course Outline
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.
Introduction to SQL Server Architecture
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.
Relational Engine
Analyzing Query Plans
Memory and Processes
Client Connectivity
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.
SQL Server Storage Structures
SQL Server Index Architecture
Managing Indexes
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. Topics include using scripting, SQL Server Enterprise Manager, and maintenance plans. The module also teaches how to use SQL Server Agent and jobs to automate administrative tasks.
Administering SQL Server by Scripting and Using SQL Server Enterprise Manager
Automating Administration by Using SQL Server Agent and Jobs
Creating and Using Alerts
Using Multiserver Jobs
Module 5: Backup and Restore
This module provides students with the knowledge and skills to create a recovery plan, and to perform backup and restore procedures in SQL Server 2000.
SQL Server Recovery Models
SQL Server Backups
Restoring Backups
Module 6: SQL Server Security
This module provides information about the process of controlling data access and securing a Microsoft SQL Server relational database management system. It explains security architecture and methods of control and how SQL Server implements logins, users, and roles. The module concludes with a discussion of how SQL Server applies permissions and uses ownership chains.
SQL Server Security Architecture
Securing SQL Server
Common Security Issues
Module 7: Monitoring SQL Server
This module describes the processes and procedures that are used to monitor SQL Server performance and then to tweak SQL Server to improve performance. It covers the use of query plans and indexing strategies and how they are unique in SQL Server.
Monitoring System and Server Activity
Managing Locks
Additional Performance Considerations
Module 8: Transferring and Analyzing Data
This module explains the processes of accessing homogenous and heterogeneous data sources, moving data into and out of SQL Server, and the architecture and components of SQL Server 2000 Analysis Services. It describes data storage cubes, query language, and various data mining models and discusses various data analysis business needs and relevant SQL Server technology solutions.
Distributed Queries
Data Extraction, Transformation, and Loading Tools
Analysis Services