MCTS – Microsoft SQL Server 2012 /2014
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 2012 Fees:
Fees include the cost of Microsoft Press Books. |
Microsoft SQL Server 2012—Implementation and Maintenance |
Contents
|
Module 1: SQL Server 2012 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 TextIndexing |
· 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-462) – Administering Microsoft SQL Server 2012 Databases
For Further Details and Enrollment mail to admin@vibrantcomputers.com