Microsoft Office Courses
Web/Graphic Design Courses
Microsoft Certification
Cisco Certification
CompTIA
Linux Certification
Testing Tool courses
Database Courses
Programming courses
MYOB
Engineering / AutoCAD
Networking / VoIP Courses
Security Courses
VMWare Course
Project Management Courses
SQL Admin/Design
Duration: 48 Hours
Price:  $1,799 AUD

Installing, Configuring, and Administering Microsoft SQL Server 2000 (Exam: 70-228)

Microsoft SQL Server 2000 Database Design and Implementation ( Exam: 70-229)

This class covers the two SQL modules required for MCDBA certification . This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000


Outcomes
  • Describe SQL Server architecture.
  • Plan for a SQL Server installation, and then install an instance of SQL Server.
  • Manage files and databases, including determining resource requirements.
  • Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
  • Perform and automate administrative tasks and create custom administrative tools.
  • Back up databases and implement a backup strategy.
  • Restore databases.
  • Monitor and optimize SQL Server performance.
  • Transfer and migrate data into databases.
  • Maintain the high availability of SQL Server.
  • Describe how to replicate data from one SQL Server to another
Course Outline
  • Overview of SQL Server 2000
  • Installing SQL Server 2000
  • Preparing to Use SQL Server 2000
  • Upgrading to SQL Server 2000
  • Understanding System and User Databases
  • Creating and Configuring User Database
  • Populating a Database
  • Developing a Data Restoration Strategy
  • Backing Up and Restoring SQL Server
  • Managing Access to SQL Server 2000
  • Managing SQL Server Permissions
  • Performing Administrative Tasks
  • Automating Administrative Tasks
  • Monitoring SQL Server Performance and Activity
  • Using SQL Server Replication
  • Maintaining High Availability
  • Introduction to Microsoft SQL Server 2000
  • Using Transact-SQL on a SQL Server Database
  • Designing a SQL Server Database
  • Implementing SQL Server Databases and Tables
  • Implementing Data Integrity
  • Accessing and Modifying Data
  • Managing and Manipulating Data
  • Implementing Stored Procedures
  • Implementing Triggers
  • Implementing Views
  • Implementing Indexes
  • Managing SQL Server Transactions and Locks
  • Designing and Administering SQL Server 2000 Security
  • SQL Server Monitoring and Tuning
ENROLL