Cheap Microsoft SQL Server 2000 Database Administration Curriculum CBT Training CDs (Software) Price

Related Products

Customer Reviews of Microsoft SQL Server 2000 Database Administration Curriculum CBT Training CDs

Microsoft SQL Server 2000 Database Administration Curriculum
Course Overview <
>This curriculum presents learners with instruction of how to install, manage, monitor, and troubleshoot SQL Server 2000. <
> <
>This curriculum consists of five courses: <
>Course 73475 Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000 <
>Course 73476 Microsoft SQL Server 2000 Database Administration Part 2: Managing Databases <
>Course 73477 Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery <
>Course 73478 Microsoft SQL Server 2000 Database Administration Part 4: Managing Data <
>Course 73479 Microsoft SQL Server 2000 Database Administration Part 5: Maintaining SQL Server 2000 <
> <
>Learn To <
>See individual course descriptions for specific course objectives and scope. <
> <
>Audience <
>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. Learners are expected to have an understanding of basic relational database concepts, and should be familiar with basic transact-SQL syntax. This curriculum prepares learners for Microsoft Exam 70-228. <
> <
>Deployment Options <
>e-Learning <
> <
>Accreditation <
>NASBA credits: 4 CPE Credits Per Course <
>CEU credits: 3.50 CEUs <
> <
>Language Options <
>US English <
> <
>Total Learning Time <
>30 to 40 hours <
> <
> <
> <
> <
>Microsoft SQL Server 2000 Database Administration Part 1: Installing SQL Server 2000 <
>Course Overview <
>This is the first course in a five part series that presents the students with both theoretical and practical instruction in the subject of installing SQL Server 2000. <
> <
>Learn To <
> <
>Identify the features and functions of SQL Server. <
>Identify the components involved in the client-server communication process. <
>Identify the steps in the client-server communication process. <
>Identify the minimum hardware requirements for SQL Server 2000. <
>Identify the typical hardware optimization issues for Microsoft SQL Server 2000. <
>Select an appropriate edition of SQL Server 2000. <
>Identify the different types of SQL Server 2000 installations. <
>Install a default instance of SQL Server 2000. <
>Sequence the stages of an unattended installation. <
>Identify the types of SQL Server databases. <
>Identify the database objects related to SQL Server. <
>Identify the features of the SQL Server 2000 object-naming standard. <
> <
>Audience <
>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. <
> <
>Deployment Options <
>e-Learning <
> <
>Accreditation <
>NASBA credits: 4 CPE Credits <
>CEU credits: 0.70 CEUs <
> <
>Language Options <
>US English <
> <
>Total Learning Time <
>6 to 8 hours <
> <
>Objectives <
>Unit 1: SQL Server 2000 Overview 1 - 2 hours <
> <
>Identify the features and functions of SQL Server. <
>Identify the components involved in the client-server communication process. <
>Identify the steps in the client-server communication process. <
>Identify the features and functions of SQL Server services. <
>Identify the activities associated with administering a SQL Server database. <
>Identify the steps associated with implementing a SQL Server database. <
>Identify the types of application architecture. <
> <
>Unit 2: Planning the Installation 1 - 2 hours <
> <
>Identify the minimum hardware requirements for SQL Server 2000. <
>Identify the typical hardware optimization issues for Microsoft SQL Server 2000. <
>Select an appropriate edition of SQL Server 2000. <
>Identify guidelines for selecting SQL Server 2000 service logon accounts. <
>Identify the features of instances of a SQL Server. <
>Identify guidelines for selecting an authentication mode. <
>Select appropriate server collations and sort rules. <
>Identify the characteristics of network libraries. <
>Configure an appropriate network library. <
> <
>Unit 3: Installation Process 2 hours <
> <
>Identify the different types of SQL Server 2000 installations. <
>Install a default instance of SQL Server 2000. <
>Sequence the stages of an unattended installation. <
>Identify the characteristics of a remote installation. <
>Identify the features of SQL Server 2000 components after installation. <
>Identify different methods of managing SQL Server 2000 services. <
>Connect to a SQL Server 2000. <
>Verify the installed version of SQL Server. <
>Identify the features of registering SQL Server. <
>Configure registration information in SQL Server Enterprise Manager. <
>Create shared registration information. <
>Identify how SQL Server 2000 communicates installation problems. <
>Identify guidelines for troubleshooting SQL Server 2000 installation problems. <
>Review the SQL Server error logs. <
>Identify considerations for upgrading from SQL Server 7.0 to SQL Server 2000. <
>Perform an upgrade from SQL Server 6.5 by using the Upgrade Wizard. <
> <
>Unit 4: Database Creation 2 hours <
> <
>Identify the types of SQL Server databases. <
>Identify the database objects related to SQL Server. <
>Identify the features of the SQL Server 2000 object-naming standard. <
>Identify the effects of the database creation process. <
>Identify the available options during database creation. <
>Create a database by using the Create Database Wizard. <
>Create a database by using SQL Server Enterprise Manager. <
>Create a database by using Transact-SQL statements. <
> <
> <
>