corner corner
banner
home > Corsi in accordo con Pipeline > corso MOC 2781 - Designing Microsoft SQL Server 2005 Server-Side Solutions 2005

Catalogo corsi

  catalogo corsi
     

Segnalaci il tuo interesse per questo corso compilando questo modulo

 

calendario corsicatalogo corsi

Thecla su Facebook
Diventa nostro fan su Facebook

newsletter

 

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
 
 
corner corner
 
Mappa del sito
 
©2017 Thecla Informatica di Silvia Montanari - Strada Malchioda 42, 29121 Piacenza - P. IVA 01173520337