Implementing & Maintaining A Microsoft SQL Server 2008 (MS6232A + MS6231A)
Course
Objective:
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 MS6232A: Implementing a Microsoft SQL Server 2008 Database
Course MS6231A: Maintaining a Microsoft SQL Server 2008 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)
Course Outline:
Module 1: Installing and Configuring SQL Server
The students will be introduced to planning for a SQL Server
installation. The students will then be introduced to installing,
configuring, and managing SQL Server.
Preparing to Install SQL Server
Installing SQL Server
Configuring a SQL Server Installation
Module 2: Creating Databases and Database Files
The students will learn one of the most fundamental tasks that a
database developer must perform, the creation of a database and its
major components, such as creating databases, setting database
options, creating filegroups, schemas, and database snapshots.
Creating Databases
Creating Filegroups
Creating Schemas
Creating Database Snapshots
Module 3: Creating Data Types and Tables
The students will learn about the system-supplied data types in SQL
Server 2008. They will learn how to define custom Transact-SQL data
types and how to create tables and how to use partitioned tables to
organize data into multiple partitions.
Creating Data Types
Creating Tables
Creating Partitioned Tables
Module 4: Disaster Recovery
The students will be introduced to disaster recovery techniques for
SQL Server. They will learn how to perform different types of backup
and restore operations, including online restores and backup and
restores of system databases.
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Performing Outline Restore Operations
Recovering Data from Database Snapshots
System Databases and Disaster Recovery
Module 5: Creating and Tuning Indexes
The students will learn how to plan, create, and optimize indexes to
attain optimal performance benefits.
Planning Indexes
Creating Indexes
Optimizing Indexes
Module 6: Implementing Data Integrity by Using Constraints
and Triggers
The students will learn about implementing data integrity in SQL
Server 2008 by using constraints. They will also implement data
integrity by using triggers.
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Module 7: Managing Security
The students will be introduced to protecting SQL Server. Students
will learn about the SQL Server security model and how to use SQL
Server security features to control access to databases and their
contents.
Overview of SQL Server Security
Protecting the Server Scope
Protecting the Database Scope
Protecting the Server Scope
Auditing Security
Module 8: Implementing Views
The students will be introduced to the different types of views
available in Microsoft SQL Server 2008 which provide a convenient
way to access data through a predefined query.
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Module 9: Implementing Stored Procedures
The students will learn the design and implementation of stored
procedures to enforce business rules or data consistency, or to
modify and maintain existing stored procedures written by other
developers.
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Working With Execution Plans
Handling Errors
Module 10: Automating Administrative Tasks
The students will learn how to automate routine administrative tasks
using jobs, operators, and alerts.
Automating Administrative Tasks in SQL Server
Using SQL Server Agent
Creating Maintenance Plans
Implementing Alerts
Managing Multiple Servers
Managing SQL Server Agent security
Module 11: Implementing Replication
The students will be introduced to techniques for configuring SQL
Server replication.
Overview of Replication
Managing Publication and Subscriptions
Configuring Replication in Some Common Scenarios
Module 12: Maintaining High Availability
The students will be introduced to concepts and methods for
maintaining high availability with SQL Server.
Introduction to High Availability
Implementing Log Shipping
Implementing Database Mirroring
Implementing Server Clustering
Using Distributed High Availability Solutions
Module 13: Managing Transactions and Locks
The students will learn to use transactions and SQL Server locking
mechanisms to meet the performance and data integrity
requirements of their applications.
Overview of Transactions and Locks
Managing Transactions
Understanding SQL Server Locking Architecture
Managing Locks
Module 14: Monitoring SQL Server
The students will be introduced to monitoring SQL Server
performance and activity.
Viewing Currents
Using SQL Server Profiler
Monitoring with DDL Triggers
Using Event Notifications
Module 15: Implementing Managed Code in the Database
The students will learn to use managed code to implement database
objects, such as stored procedures, user-defined data types, userdefined
functions, and triggers.
Introduction to the SQL Server Common Language Runtime
Copyright © 2008