Informationen über Kurs 73476 - Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases - Online
-
Ziele
- Identify the database option categories. - Identify features of the tools used to view database properties. - View database information by using SQL Server Enterprise Manager. - Match the different types of data integrity with their characteristics. - Identify the different types of constraints. - Identify guidelines for creating constraints.
-
Anforderungen
Candidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax.
-
Titel
Kurs 73476 - Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases
-
Inhalt
Course Overview
This is the second course in a five part series that will teach students how to plan for managing databases with SQL Server 2000. This course also includes both theoretical and practical instruction in the creation and management of objects.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.60 CEUs
Total Learning Time
6 hours
Objectives
Unit 1: Database Management 3 hours
- Identify features of the tools used to view database properties.
- View database information by using SQL Server Enterprise Manager.
- Modify a database by using SQL Server Enterprise Manager.
- Identify ways to modify databases by using the ALTER DATABASE statement.
- Identify the features of the sp_dboption stored procedure.
- Create a database diagram by using the Create Database Diagram Wizard.
- Identify guidelines for deleting a database.
- Delete a database by using the SQL Server Enterprise Manager.
- Identify guidelines for managing data and log file growth.
- Identify the features of shrinking a database or database file automatically.
- Identify the guidelines of shrinking a database or database file manually.
- Identify the features of user-defined filegroups.
- Identify guidelines to create a user-defined filegroup.
- Identify the guidelines for using user-defined filegroups for maintenance.
- Identify the steps for creating filegroups.
- Identify the characteristics of transaction logs.
- Identify guidelines for placing transaction logs.
- Identify guidelines for optimizing a database by using hardware-based RAID.
- Identify features of filegroups that improve performance.
- Identify the benefits of combining filegroups with hardware-based RAID.
- Identify guidelines for optimizing database performance.
- Identify guidelines for managing databases.
- Identify guidelines for estimating the size of a database.
- Identify guidelines for estimating the amount of data in a table.
Unit 2: Object Management 3 hours
- Match the different types of data integrity with their characteristics.
- Identify the different types of constraints.
- Identify guidelines for creating constraints.
- Identify guidelines for disabling constraints.
- Identify guidelines for disabling constraint checking when loading new data.
- Identify the features of clustered indexes.
- Identify the features of nonclustered indexes.
- Identify guidelines for creating indexes.
- Identify guidelines for using the DROP_EXISTING option.
- Identify guidelines for using the Index Tuning Wizard.
- Identify performance considerations for planning and creating indexes.
- Identify the features of stored procedures.
- Identify guidelines for creating stored procedures.
- Identify the syntax used to execute a stored procedure.
- Identify considerations for modifying a stored procedure.
- Identify considerations for optimizing a stored procedure.
- Identify the features and functions of triggers.
- Identify the advantages of using triggers.
- Identify guidelines for creating triggers.
- Identify the syntax used to alter a trigger.
- Identify the features of views.
- Identify the considerations for creating a view.
- Identify the critical steps in creating a view by using the Create View Wizard.
- Identify the syntax used to alter a view.
- Identify the features of broken ownership chains.
- Identify the considerations for modifying data with views.
- Identify the different types of user-defined functions.
- Match syntax arguments used to create user-defined functions with their description.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
