![]() |
Profile |
Contact |
Search |
Cart |
| Microsoft SQL Server 2000 Database Administration II: SQL Server 2000 Databases |
| Course Status: | Released | Courseware Features |
| Course Language: | English | |
| Course Duration: | 5 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
Audience |
| Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition |
Prerequisites |
| Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year?s experience administering SQL Server; at least one year?s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000 |
Course Aim |
| This learning path describes in detail the basic configuration and administration of Microsoft SQL Server 2000. |
Learning Objectives |
| To describe how to create and modify SQL Server 2000 databases |
Topics Covered |
| Database planning and datatypes Database planning in SQL Server 2000 System-supplied datatypes in SQL Server 2000 User-defined datatypes in SQL Server 2000 Creating a user-defined datatype in SQL Server 2000 Working with databases Database creation Creating a SQL Server 2000 table Creating and modifying a SQL Server 2000 database |