Microsoft SQL Server 2008 MCITP (Microsoft Certified IT Professional) Certification Microsoft products are among the most popular and widely used in the world today. And Microsoft SQL server database along with .NET framework create vast opportunities for software professionals all over the world and London is no exception. The Microsoft SQL server course not only teaches to the concepts of RDBMS (Relational Database Management System) but also focuses on developing proficiency with Microsoft SQL Server database and to teach “on-the-job” skills for setting up and maintaining a database. Highlights of the course includes installing, configuring, and maintaining of MS SQL Server, manipulate relational data, database objects, stored procedures, etc. On an average, people who are certified on MCITP SQL 2008 Server, earn a lot more than their colleagues in the industry. Enroll yourself today in this interactive, hands-on class, taught by a certified professional. The class runs for 8 weeks. Included with the course fee are the books and material for the class and unlimited practice time. Why wait? Learn it right, the first time! MS SQL 2008(MCITP) £1250 Microsoft SQL Server 2008 (MCTS Certification) £990 Oracle OCP + MS SQL 2008(MCTS) £1850   MCITP SQL 2008 Certification Exam and Course Highlight Exam 70–432: Microsoft SQL Server 2008 Microsoft SQL Server 2008, Implementation and Maintenance Exam 70–450: Microsoft SQL Server 2008 Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008		End 2 End Process Enrolment Phone or In Person Course Fee £1250 Books and Course Material Included         Hands-on instructor led Training for 8 weeks, Unlimited Pratice Hours         Free MS SQL 2008 Mock Exam         Actual SQL Exam towards MCITP Exam done @ BCOC Fee not included         Certified MCITP
Nearest starting Dates for MS SQL 2008

SQL Server 2008 Course Overview
Whether it is web commerce, accounting, finance, record keeping, data entry, and marketing or applications developer occupation, one of the basic tools used in many organisations in London and globally is RDBMS (SQL). SQL Server courses can prepare you for a career in database management on highly diverse level of industries in London and worldwide. Our courses for Microsoft SQL certification can also be useful for job encroachment in London because you can use the skills you gain immediately to increase your efficiency. Our SQL courses will give you clear understanding of the structure and function of a relational database system, use Microsoft SQL Server to create a relational database and use good design principles to optimise data storage and retrieval. Our courses in Microsoft SQL Server are gaining popularity, which, together with Microsoft .NET framework courses, promises to endow you to produce results via sophisticated database capabilities and information management. The SQL server course focuses primarily on developing proficiency with Microsoft SQL Server and on gaining solid skills for setting up and maintaining a database in a Microsoft Windows platform.

Exam 70–432: Microsoft SQL Server 2008, Implementation and Maintenance

Installing and Configuring SQL Server 2008

Managing Databases and Files
Planning and Creating Databases, Using Policy-Based Management
Creating a Database. Managing Databases and Files
Monitoring and Managing Filegroup Usage
Creating a Policy, Create a SQL Server database, manage a SQL Server database.

Disaster Recovery
Planning a Backup Strategy, Backing Up User Databases
Restoring User Databases, Performing Online Restore Operations
Recovering Data from Database Snapshots, System Databases and Disaster Recovery
Disaster Recovery, Designing a Backup Strategy
Implementing a Backup Strategy, Restoring and Recovering a Database
Performing Piecemeal Backup and Restore Operations
Restoring the master Database, Plan a backup strategy for a database.
Back up user databases.
Restore user databases from backups, Restore data in a user database while it is online, Recover data for a user database from a database snapshot.
Restore and recover system databases.

Managing Security
Overview of SQL Server Security, Protecting the Server Scope
Protecting the Database Scope, Protecting the Server Scope
Auditing Security, Managing Security, Creating Logins and Assigning Server-Scope Permissions, Creating and Managing Users, Using a Certificate to Protect Data
Implementing SQL Server Audit, Describe how SQL Server manages security.
Protect SQL Server at the server level. Protect SQL Server databases.
Use keys and certificates to protect SQL Server objects, Audit SQL Server security.

Transferring Data
Overview of Data Transfer, Introduction to SQL Server Integration Services
Transferring Data, Using the Import/Export Wizard
Performing a Bulk Load, Creating an SSIS Solution
Use UI and command-line tools to import and export data.
Describe the features of SQL Server Integration Services.

Automating Administrative Tasks
Automating Administrative Tasks in SQL Server
Using SQL Server Agent, Creating Maintenance Plans
Implementing Alerts, Managing Multiple Servers
Managing SQL Server Agent security, Automating Administrative Tasks
Configuring SQL Server Agent, Creating Operators and Jobs
Creating Alerts
Define SQL Server administrative tasks and schedule those tasks to run automatically.
Configure SQL Server Agent to support automatic task scheduling.
Script tasks by using SQL Server jobs, and define operators for managing those jobs.
Define alerts to warn operators about events raised by SQL Server.
Define and manage administrative tasks that span multiple servers.
Configure SQL Server Agent security.

Implementing Replication
Replication, Managing Publications and Subscriptions
Configuring Replication in Some Common Scenarios
Implementing Replication, Implementing Snapshot Replication
Implementing Peer-to-Peer Transactional Replication
Implementing HTTP Merge Replication, Describe replication and its components.
Configure and implement replication
Use replication to meet the requirements of some common scenarios.

Maintaining High Availability
Introduction to High Availability, Implementing Log Shipping
Implementing Database Mirroring, Implementing Server Clustering
Using Distributed High Availability Solutions
Maintaining High Availability, Configuring Log Shipping
Configuring Database Mirroring, Implementing SQL Server Clustering
Describe the factors affecting database availability.
Describe how to implement log shipping to support fast recovery of a standby SQL Server database
Describe how to use SQL Server mirroring to implement a software solution for fast failover
Explain how to implement clustering to support fast failover of computers running SQL Server instances.
Describe how to implement distributed high availability solutions.

Monitoring SQL Server
Viewing Current Activity, Using SQL Server Profiler
Monitoring with DDL Triggers, Using Event Notifications
Monitoring SQL Server, Monitoring SQL Server Activity
Tracing SQL Server Activity, Using DDL Triggers
Using Event Notifications
Examine the current activity in a SQL Server instance.
Use SQL Server Profiler to trace server and database activity.
Use DDL triggers to monitor changes to the structure of database objects.
Use event notifications to capture and monitor significant events for a SQL Server instance.

Troubleshooting and Performance Tuning
Troubleshooting SQL Server, Performance Tuning in SQL Server
Using Resource Governor, Using Data Collector
Troubleshooting and Performance Tuning, Troubleshooting Connectivity Problems
Troubleshooting Concurrency Problems, Using the Database Engine Tuning Advisor
Implementing Resource Governor, Implementing Data Collector
Troubleshoot common SQL Server problems, such as connectivity, concurrency, and job and disk space problems.
Perform basic performance tuning tasks in SQL Server using the Database Engine Tuning Advisor, index tuning, and query tuning.
Use Resource Governor to manage SQL Server workloads and resources.
Use Data Collector to obtain performance data about your computer and the instances of SQL Server running on your computer.

Overview of SQL Server Databases
Overview and Syntax Elements of T-SQL
Working with T-SQL Scripts, Using T-SQL Querying Tools
Using SQL Server Management Studio and SQLCMD
Exploring the Components and Executing Queries in SQL Server Management Studio
Starting and Using SQLCMD
Generating a Report from a SQL Server Database Using Microsoft Office Excel
Describe the architecture and components of SQL Server 2008.
Describe the structure of a SQL Server database.
Explain the basics of the SQL language.
Describe the syntax elements of T-SQL.
Explain how to manage T-SQL scripts.
Use T-SQL querying tools to query SQL Server 2008 databases.

Querying and Filtering Data
Using the SELECT Statement
Filtering Data, Working with NULL Values
Formatting Result Sets, Performance Considerations for Writing Queries
Querying and Filtering Data, Retrieving Data by Using the SELECT Statement
Filtering Data by Using Different Search Conditions
Using Functions to Work with NULL Values
Formatting Result Sets, Retrieve data by using the SELECT statement.
Filter data by using different search conditions.
Explain how to work with NULL values, Format result sets.
Describe the performance considerations that affect data retrieval.

Grouping and Summarizing Data
Summarizing Data by Using Aggregate Functions
Summarizing Grouped Data, Ranking Grouped Data
Creating Crosstab Queries, Grouping and Summarizing Data
Summarizing Data by Using Aggregate Functions
Summarizing Grouped Data, Ranking Grouped Data
Creating Crosstab Queries, Summarize data by using aggregate functions.
Summarize grouped data by using the GROUP BY and COMPUTE clauses.
Rank grouped data,
Create cross-tabulation queries by using the PIVOT and UNPIVOT clauses.

Joining Data from Multiple Tables
Querying Multiple Tables by Using Joins
Applying Joins for Typical Reporting Needs
Combining and Limiting Result Set, Joining Data from Multiple Tables
Querying Multiple Tables by Using Joins, Applying Joins for Typical Reporting Needs
Combining and Limiting Result Sets, Query multiple tables by using joins.
Apply joins for typical reporting needs, Combine and limit result sets.

Working with Subqueries
Writing Basic Subqueries, Writing Correlated Subqueries
Comparing Subqueries with Joins and Temporary Tables
Using Common Table Expressions, Working with Subqueries
Writing Basic Subqueries, Writing Correlated Subqueries
Comparing Subqueries with Joins and Temporary Tables
Using Common Table Expressions, Write basic subqueries.
Write correlated subqueries, Compare subqueries with joins and temporary tables.
Use common table expressions in queries.

Modifying Data in Tables
Inserting Data into Tables, Deleting Data from Tables
Updating Data in Tables, Overview of Transactions
Modifying Data in Tables, Inserting Data into Tables
Deleting Data from Tables, Updating Data in Tables
Working with Transactions, Insert data into tables.
Delete data from tables, Update data in tables, Describe transactions.

Querying Metadata, XML, and Full-Text Indexes
Querying Metadata, Overview of XML
Querying XML Data, Overview of Full-Text Indexes
Querying Full-Text Indexes, Querying Metadata, XML, and Full-Text Indexes
Querying Metadata, Querying XML Data
Creating and Querying Full-Text Indexes
Query metadata, Describe the functionality of XML.
Query XML data, Describe the functionality of full-text indexes.
Query full-text indexes.

Using Programming Objects for Data Retrieval
Overview of Views, Overview of User-Defined Functions
Overview of Stored Procedures, Overview of Triggers
Writing Distributed Queries, Using Programming Objects for Data Retrieval
Creating Views, Creating User-Defined Functions
Creating Stored Procedures, Writing Distributed Queries
Encapsulate queries by using views.
Encapsulate expressions by using user-defined functions.
Explain how stored procedures encapsulate T-SQL logic.
Define triggers, types of triggers, create a trigger.
Write distributed queries.

Using Advanced Querying Techniques
Considerations for Querying Data, Working with Data Types
Cursors and Set-Based Queries, Dynamic SQL
Maintaining Query Files, Using Advanced Querying Techniques
Using Execution Plans, Converting Data Types
Implementing a Hierarchy, Using Cursors and Set-Based Queries
Explain the recommendations for querying complex data.
Query complex table structures, Write efficient queries.
Use various techniques when working with complex queries.
Maintain query files.

Exam 70–450: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008

Designing a SQL Server Instance and a Database Solution
• Design for CPU, memory, and storage capacity requirements.
• RAID, calculating table size, IO throughput, transaction per second, data compression, non-uniform memory access (NUMA), tempdb capacity
• Design SQL Server instances.
• Instance configuration, surface area configuration, CPU affinity, memory allocation, max degree of parallelism (MAXDOP), collation
• Design physical database and object placement.
• Heap and index placement, filestream, data and log files, filegroups, partition placement, large object placement, full text catalog
• Design a migration, consolidation, and upgrade strategy.
• Multi-instance considerations, SQL Server version upgrade, instance and database collation, server-level and instance-level objects, service pack application

Designing a Database Server Security Solution
• Design instance authentication
• Choosing authentication type, logon triggers, regulatory requirements
• Design instance-level security configurations
• Windowsservice accounts, filestream, proxy, credentials, instance-level permissions, certificate and key management, endpoint security, using SSL certificates, TCP ports
• Design database, schema, and object security paramaters
• Users, roles, certificate and key management, Service broker, Common Language Runtime (CLR), ownership chains
• Design a security policy and an audit plan
• Policy-Based Management Framework, security functions, sp_helprotect, catalog views, extended events, notifications
• Design an encryption strategy
• This objective may include but is not limited to: Transparent Data Encryption, encrypting protected data, certificate and key management, filestream

Designing a Database Solution for High Availability
• Design a failover clustering solution
• Cluster resource group, cluster setup considerations, number of nodes, service accounts
• Design database mirroring
• Design a high-availability solution that is based on replication
• Different replication types, topologies, recover from replication failure, synchronization, health monitoring
• Design a high-availability solution that is based on log shipping
• Manage instance-level objects, changing roles, reporting secondary instance for reporting, monitor server, reinitializing, consistency check on secondary instance
• Select high-availability technologies based on business requirements
• Failover clustering, database mirroring, log shipping, replication

Designing a Backup and Recovery Solution
• Design a backup strategy
• Recovery model, compression, choosing backup types, scheduling, backup media, file and filegroups backup, verifying backups, key management, mirrored backups, cluster considerations
• Design a recovery strategy
• Page, file, filegroup, partial and online restores, orphan users, instance rebuild, encryption considerations, handling media failures, transaction logs, point in time and mark recovery, filestreams
• Design a recovery test plan
• Log shipping, replication, hardware considerations, scheduling a database restore test, handling high availability failures

Designing a Monitoring Strategy
• Design a monitoring solution at the operating system level
• System monitor counters, event logs, dynamic management views and functions, Windows Management Instrumentation (WMI), remote monitoring, analyze results
• Design a monitoring solution at the instance level
• Instance, database and object monitoring, data collection, event notifications, dynamic management objects, analyze results
• Design a solution to monitor performance and concurrency
• Dedicated Administrator Connection (DAC), locking, blocking, deadlocks, dynamic management objects, index utilization, tracing, analyze

Designing a Strategy to Maintain and Manage Databases
• Design a maintenance strategy for database servers
• Design a solution to govern resources
• Resource Governor (CPU, memory, number of requests per second; resource pools, resource groups), query governor
• Design policies by using Policy-Based Management
• designing policies and conditions
• Design a data compression strategy
• This objective may include but is not limited to: row vs. page level, update frequency, compression ratio, compressing partitions, specific indexes
• Design a management automation strategy
• SQL Server PowerShell, Windows Management Instrumentation (WMI), SQL Server Agent, event notifications, DDL triggers

Designing a Strategy for Data Distribution
• Administer SQL Server Integration Services (SSIS) packages
• design security for accessing packages, troubleshoot and restart package, schedule package execution, deploy packages to same or different instances
• Design a strategy to use linked servers
• Design a replication strategy for data distribution
• Selecting replication types, conflict resolution, health monitoring, horizontal and vertical partitioning