Bel ons nu!
040-2924747
Implementing and Maintaining a Microsoft SQL 2008/2005 Database (blended training 6231 en 6232) Microsoft SQL Implementing and Maintaining a Microsoft SQL 2008/2005 Database (blended training 6231 en 6232) M70-432 Implementing and Maintaining a Microsoft SQL Server 2008 Database Prijs: € 2.250,00 Duur: 5 lesdagen Besparing tot € 2.250,00 Doorlooptijd: 7 weken Tijdwinst: 5 lesdagen Samenvatting M70-432 is een “Blended” cursus van in totaal 5 dagen klassikale training in combinatie met zelfstudie. De cursus bestaat uit vijf trainingsdagen die verdeeld zijn over vijf weken. De cursus begint met 1 trainingsdag, dan twee weken zelfstudie, de week erop 2 trainingsdagen, twee weken zelfstudie en vervolgens weer 2 trainingsdagen. In de zelfstudie tijd kunnen de cursisten aan de hand van de studieprogrammering de theoretische elementen bestuderen. De cursus Miles70-432 is een combinatie van de MOC cursus 6232 Implementing a Microsoft SQL 2008 Database en de de MOC cursus 6231 Maintaining a Microsoft SQL Server 2008 Database. Officieel zijn dit 10 dagen training. Naast de geselecteerde onderwerpen uit het officiele Microsoft MOC cursusmateriaal krijgen de cursisten de beschikking over de MSPress trainingkit MCTS Self-Paced Training Kit [Exam 70-432]: Microsoft SQL Server 2008 - Implementation and Maintenance en het Transcender proefexamen. Een professioneel opgezette studieplanner faciliteert de leidraad voor de studie en de voorbereiding op het Microsoft exam 70-432 TS: Microsoft SQL Server 2008 - Implementation and Maintenance. Verder is aan de cursus een casus toegevoegd. Short Description This five-day instructor-led course provides students with product knowledge and skills needed to implement and maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing and maintaining a database. Extra studiemateriaal MOC workbook MSPress trainingkit MCTS Self-Paced Training Kit [Exam 70-432]: Microsoft SQL Server 2008 - Implementation and Maintenance E-Learning Implementing and Maintaining a SQL Server 2008 Database Transcender Proefexamen Klassikale Casus Studieplanner Download hier de totale omschrijving: After completing this course, students will be able to: Install and configure SQL Server 2008. Manage database files. Backup and restore databases. Manage security. Transfer data into and out of SQL Server. Automate administrative tasks. Replicate data between SQL Server instances. Maintain high availability. Monitor SQL Server. Create databases, database files, types and tables. Use XML-related features in Microsoft SQL Server 2008. Plan, create, and optimize indexes. Implement data integrity in Microsoft SQL Server 2008 databases by using constraints and triggers Implement views, stored procedures, functions, managed code Manage transactions and locks. Use Service Broker to build a messaging-based solution Before attending this course, students must have: Basic knowledge of the Microsoft Windows operating system and its core functionality. Working knowledge of Relational databases. Core Windows Server skills. Database design skills. SQL Server skills - ability to write Transact-SQL queries or completed Course 2778: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Onderwerpen Creating Databases and Database Files Creating Databases. Creating Filegroups. Creating Schemas. Creating Database Snapshots. Installing and Configuring SQL Server Preparing to Install SQL Server Installing SQL Server Configuring a SQL Server Installation Managing Databases and Files Planning Databases Creating Databases Using Policy-Based Management Disaster Recovery Planning a Database Backup Strategy Backing Up a User Database Restoring User Databases Performing Online Restore Operations Recovering Data from Database Snapshots System Databases and Disaster Recovery Managing Security Overview of SQL Server Security Protecting the Server Scope Protecting the Database Scope Managing Keys and Certificates Auditing Security Transferring Data Overview of Data Transfer Introduction to 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 Implementing Replication Overview of Replication Managing Publications and Subscriptions Configuring Replication in Some Common Scenarios Maintaining High Availability Introduction to High Availability Implementing Log Shipping Implementing Database Mirroring Implementing Server Clustering Using Distributed High Availability Solutions Monitoring SQL Server Viewing Current Activity Using SQL Server Profiler Monitoring with DDL Triggers Using Event Notifications Troubleshooting and Performance Tuning Troubleshooting SQL Server Performance Tuning in SQL Server Using Resource Governor Using Data Collector Creating Databases and Database Files Creating Databases Creating Filegroups Creating Schemas Creating Database Snapshots Creating Data Types and Tables Creating Data Types Creating Tables Creating Partitioned Tables Creating and Tuning Indexes Planning Indexes Creating Indexes Optimizing Indexes Implementing Data Integrity by Using Constraints and Triggers Data Integrity Overview Implementing Constraints Implementing Triggers Using XML Using the XML Data Type Retrieving XML by Using FOR XML Shredding XML by Using OPENXML Introducing XQuery Creating XML Indexes Implementing XML Schemas Implementing Views Introduction to Views Creating and Managing Views Optimizing Performance by Using Views Implementing Stored Procedures Using Stored Procedures Creating Parameterized Stored Procedures Working With Execution Plans Handling Exceptions Implementing Functions Introducing Functions Working with Functions Controlling Execution Context Implementing Managed Code in the Database Introduction to the SQL Server Common Language Runtime Importing and Configuring Assemblies Creating Managed Database Objects Managing Transactions and Locks Overview of Transactions and Locks Managing Transactions Understanding SQL Server Locking Architecture Managing Locks Using Service Broker Service Broker Overview Creating Service Broker Objects Sending and Receiving Messages Microsoft exam 70-432: MCTS Microsoft SQL Server 2008—Implementation and Maintenance
Pagina wordt geladen...
