Installing, Configuring and Administering a MS SQL Server 2000 Enterprise (NIR-2072)This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database
Module 1: SQL Server Overview Module 2: Planning to Install SQL Server Module 3: Managing Database Files Module 4: Managing Security Module 5: Performing Administrative Tasks Module 6: Backing Up Databases Module 7: Restoring Databases Module 8: Monitoring SQL Server for Performance Module 9: Transferring Data Module 10: Maintaining High Availability Module 11: Introducing Replication
Course Description
Programming MS SQL 2000 Database (NIR-2073) This course provides students with the technical skills required to program a database solution by using Microsoft? SQL ServerTM 2000
Module 1: SQL Server Overview Module 2: Overview of Programming SQL Server Module 3: Creating and Managing Databases Module 4: Creating Data Types and Tables Module 5: Implementing Data Integrity Module 6: Planning Indexes Module 7: Creating and Maintaining Indexes Module 8: Implementing Views Module 9: Implementing Stored Procedures Module 10: Implementing User-defined Functions Module 11: Implementing Triggers Module 12: Programming Across Multiple Servers Module 13: Optimizing Query Performance Module 14: Analyzing Queries Module 15: Managing Transactions and Locks
สอนโดยคณาจารย์ผู้มีประสบการณ์จริงในการทำงาน
และได้รับใบรับรองจากผู้ผลิต Software มาตรฐานโลก
อาทิ Microsoft , Sun , Cisco คุณจึงมั่นใจได้ในคุณภาพและมาตรฐานของเรา
