Corso MOC 2781 - Designing Microsoft SQL Server 2005 Server-Side Solutions 2005 |
2005 |
Microsoft |
Categoria |
Corsi MOC in accordo con Pipeline |
Livello |
|
Prerequisiti |
aver partecipato al corso MOC2778 "Writing Queries Using Microsoft SQL Server 2005 Transact-SQL" o possedere conoscenze equivalenti;
aver partecipato al corso MOC2779 "Implementing a Microsoft SQL Server 2005 Database" o possedere conoscenze equivalenti;
aver partecipato al corso MOC2780 "Maintaining a Microsoft SQL Server 2005 Database" o possedere conoscenze equivalenti;
avere esperienza nella lettura e interpretazione di documenti riguardanti requisiti utente e fabbisogni;
comprendere la sintassi Transact-SQL e la logica di programmazione;
comprendere XML;
comprendere i requisiti di sicurezza;
essere in grado di progettare in 3NF (terza forma normale);
avere competenze di base in ambito monitoraggio e troubleshooting;
avere una conoscenza di base della architettura del sistema operativo e della integrazione con il database;
avere esperienza con strumenti di reporting; |
|
Questo corso vuole trasmettere agli allievi le conoscenze e le competenze per progettare soluzioni server-side per Microsoft SQL Server 2005. Il corso si focalizza sulla identificazione e utilizzo delle tecnologie utilizzate durante la progettazione di una soluzione che soddisfi i requisiti. Gli allievi impareranno a considerare una soluzione dal punto di vista dell'intero sistema informativo anzich |
|
Selecting SQL Server Services to Support Business Needs
Evaluating When to Use the New SQL Server Services
Evaluating the Use of Database Engine Enhancements
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing Objects to Manage Application Access
Creating an Auditing Strategy
Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Designing a Data Modeling Strategy
Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behavior Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Designing a Notification Services Solution
Defining Event Data
Designing a Subscription Strategy
Designing a Notification Strategy
Designing a Notification Delivery Strategy
Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
Planning for Source Control, Unit Testing, and Deployment
Designing a Source Control Strategy
Designing a Unit Test Plan
Creating a Performance Baseline and Benchmarking Strategy
Designing a Deployment Strategy
Evaluating Advanced Query Techniques
Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Evaluating Advanced XML Techniques
Evaluating the Use of Xquery
Creating a Strategy for Converting Data between XML and Relational Formats
Selecting SQL Server Services to Support Business Needs
Evaluating When to Use the New SQL Server Services
Evaluating the Use of Database Engine Enhancements
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing a Security Strategy for Components of a SQL Server 2005 Solution
Designing Objects to Manage Application Access
Creating an Auditing Strategy
Managing Multiple Development Teams Using the SQL Server 2005 Security Features
Designing a Data Modeling Strategy
Defining Standards for Storing XML Data in a Solution
Designing a Database Solution Schema
Designing a Scale-Out Strategy
Designing a Transaction Strategy for a SQL Server 2005 Solution
Defining Data Behavior Requirements
Defining Isolation Levels
Designing a Resilient Transaction Strategy
Designing a Notification Services Solution
Defining Event Data
Designing a Subscription Strategy
Designing a Notification Strategy
Designing a Notification Delivery Strategy
Designing a Service Broker Solution
Designing a Service Broker Solution Architecture
Designing Service Broker Data Flow
Designing Service Broker Solution Availability
Planning for Source Control, Unit Testing, and Deployment
Designing a Source Control Strategy
Designing a Unit Test Plan
Creating a Performance Baseline and Benchmarking Strategy
Designing a Deployment Strategy
Evaluating Advanced Query Techniques
Evaluating Common Table Expressions
Evaluating Pivot Queries
Evaluating Ranking Queries
Evaluating Advanced XML Techniques
Evaluating the Use of Xquery
Creating a Strategy for Converting Data between XML and Relational Formats
|
|
Corso di gruppo |
Corso personalizzato (1 o 2 partecipanti) |
21 ore |
non previsto |
min. 5 - max. 10 partecipanti |
2 persone: sconto del 50% |
Corso individuale a distanza su VoIP |
non previsto |
|
VIDEO TUTORIAL |