About this Course

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™ This course is intended for Microsoft SQL Server Administrators, system engineers, and developers who are responsible for implementing,configuring and administering SQL Server 2008. 

Microsoft Certified Technology Specialists in Microsoft SQL Server 2008 (MCTS: SQL Server 2008) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface. Technology Specialists typically pursue careers as database administrators, database developers, or business intelligence developers. They may also be developers and systems administrators who do not work with SQL Server daily but who want to show their breadth of technology experience. 

Microsoft Skills Assessments for SQL Server 2008 help database administrators, database developers, and business intelligence developers focus their exam preparation training and find learning resources. 

This program consists of two module;

• Course MS6232B: Implementing a Microsoft SQL Server 2008 Database
  
• Course MS6231A: Maintaining a Microsoft SQL Server 2008 Database
  

Course Outline:

Module 1: Installing and Configuring SQL Server 

Module 2: Creating Databases and Database Files 

Module 3: Creating Data Types and Tables 

Module 4: Disaster Recovery 

Module 5: Creating and Tuning Indexes 

Module 6: Implementing Data Integrity by Using Constraints and Triggers 

Module 7: Managing Security 

Module 8: Implementing Views 

Module 9: Implementing Stored Procedures 

Module 10: Automating Administrative Tasks 

Module 11: Implementing Replication 

Module 12: Maintaining High Availability 

Module 13: Managing Transactions and Locks 

Module 14: Monitoring SQL Server 

Module 15: Implementing Managed Code in the Database 

Prerequisite:

An understanding of basic relational database concepts, including:

• Logical and physical database design.
  
• Data integrity concepts.
  
• Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, and many-to-many).
  
• How data is stored in tables (rows and columns).
  
• Working knowledge of Transact-SQL and relational database, some experience in database design and MS Windows operating system and its core functionality
  

Certificate Of Attendance:

Certificate Of Attendance will be awarded to students completing the course achieving minimum 75% attendance..

Training Methodology & Materials:

• Practical hands-on sessions to enhance database concepts
  
• Well-designed lab sessions to enhance further understanding of the courseware
  
• Courseware will be provided.
  

Training Duration:

Full-Time : 5 weekdays or 5 Sats

Time : 9.00am - 6.00pm

Part-Time : 10 sessions

Time : 6.30pm - 10.00pm (twice a week)

Rate this course:

Log in to submit

Comments