| MCTS -
Microsoft SQL Server 2008 MCTS (Microsoft
Certified Technology Specialist) Series.
- Courses are for Information Technology(IT) professional
and Developers who are new to product and for experienced
individuals who prefer to learn in a traditional classroom
Setup.
- Courses provide a relevant and guided learning
experience that combines lecture and practice to deliver
through coverage of Microsoft Technology. MCTS credentials
enables professionals to get in-depth knowledge of
and expertise in the technologies they work in.
Course: SQL 2008
Duration: 40 hrs
Fees: Rs.
8,000/-
Fees include
the cost of
Microsoft
Press Books.
|
|
Microsoft SQL Server 2008—Implementation and
Maintenance |
Contents
|
|
Module 1: SQL Server 2008
Installing and Configuring SQL Server Instances. |
·
Preparing to install SQL Server.
·
Determining Hardware and Software Requirements.
·
Supported Operating Systems.
·
Selecting SQL Server Editions.
·
Service Accounts Collation
·
Sequences Authentication Modes |
|
Module 2: Database Configuration and Maintenance
|
·
Configuring Files and File groups.
·
Understanding Files and File group.
·
Understanding Transaction log.
·
Retrieving MetaData Information.
·
Configuring Database Options.
·
Database Integrity Checks |
|
Module 3: Creating Data Types and Tables
|
·
Understanding Different Data Types.
·
Creating Tables
·
Understanding Column Properties
|
|
Module 4: Implementing Constraints |
·
Working with data Integrity using
Different Constraints.
·
Primary Keys
·
Foreign Keys
·
Unique Constraints
·
Default Constraints
·
Check Constraints
·
Rule
·
Implementing Triggers
|
|
Module 5:
Designing SQL Server Indexes |
·
Understanding Index Architecture.
·
Designing Indexes
o
Clustered Index
o
Non-Clustered Index
·
Different Index Options
·
Maintaining Indexes
|
|
Module 6: Implementing Views
|
·
Introduction to Views.
·
Creating and Managing Views.
·
Optimizing Performance by Using Views
|
|
Module 7: Implementing Stored Procedures and
Functions
|
·
Implementing Stored Procedures
·
Creating Parameterized Stored Procedures
·
Creating User Defined Functions.
·
Handling Errors.
|
|
Module 8:Distributing and Partitioning Data |
·
Creating a Partition Function
·
Creating a Partition Scheme
·
Creating Partitioned Tables and Indexes.
·
Managing Partitions. |
|
Module 9: Backing up and Restoring a Database |
·
Planning a Backup Strategy.
·
Backing Up User Databases.
·
Restoring User Databases.
·
Database SnapShot
·
Recovering Data from Database Snapshots
·
Row and Page Compression
·
Backup Compression |
|
Module10: Full Text
Indexing
|
·
Creating and Populating Full Text Indexes
·
Querying Full Text Data
·
Managing Full Text Indexes using Stoplists and
Stopwords |
|
Module 11: Managing Security
|
Overview of SQL Server Security.
·
Creating Principals
o
Logins Fixed Server Roles
o
Database Users
o
Loginless Users
o
Fixed Database Roles
o
User Database Roles
·
Managing Permissions
o
Securables
o
Permissions Metadata Security
·
Encrypting Data
o
Hash Algorithms
o
Symmetric Keys
o
Certificates and Asymmetric Keys
o
Transparent Data Encryption
o
Encryption Key Management
·
DDL Triggers and Auditing
o
Working with DDL triggers
o
Working with Server and Database Audit
specification |
|
Module 12:
Monitoring Microsoft SQL Server |
·
Working with the SQL Server Profiler
·
Working with System Monitor
·
Diagnosing Database Failures
·
Diagnosing Service Failures
·
Diagnosing Hardware Failures
·
Resolving Blocking and Deadlocking Issues
·
Using Activity Monitor
·
Designing Policy Based Management
o
Facets
o
Conditions
o
Policies
o
Import and Export Policies |
|
Module 13:
Optimizing Performance
|
·
Using the Database Engine Tuning Advisor
·
Using Dynamic Management Views and Functions
·
Working with Resource Governor |
|
Module 14:
Automating SQL Server
|
·
Creating Jobs
·
Creating Alerts
·
Creating Operators |
|
Module 15:
Log
Shipping |
·
Overview of Log Shipping
·
Initializing Log Shipping
·
Designing Failover and Failback Strategies. |
|
Module 16:
Database
Mirroring |
·
Overview of Database Mirroring
·
Initializing Database Mirroring. .
·
Designing Failover and Failback Strategies |
|
Module 17:
Overview of Failover Clustering |
·
Overview of Designing Windows Clustering
·
Overview of Designing SQL Server 2008 Failover
Cluster Instances |
|
Module 18:
Replication |
·
Overview of Replication
o
Replication Components
o
Replication Roles
o
Replication Topologies Replication Agents
o
Agent Profiles
o
Replication Methods
o
Data Conflicts
·
Implementing Different types Replication
·
Monitoring Replication |
Microsoft SQL Server 2008
To pass this certification required exam papers
are:
- Microsoft SQL Server 2008 (Exam #70-432) -
Implementation and Maintenance of Database
For Further Details and Enrollment mail to admin@vibrantcomputers.com |
