.
Centro de Treinamento e Capacitação Sindpd

Web .Net Framework 3.5 + SQL Server

No final deste treinamento, o aluno estará apto a conhecer profundamente, as mais avançadas técnicas de desenvolvimento para Web com acesso a dados, fazendo uso do Microsoft Visual Studio 2008, juntamente com o Microsoft .Net Framework 3.5, utilizando a linguagem Microsoft Visual C# ou o Microsoft Visual Basic .Net.

Junto a carreira de desenvolvedor, o aluno estará apto a conhecer, desenvolver e implementar bancos de dados baseados em Microsoft SQLServer 2008.

Os profissionais que terminarem esta sequência de treinamento, estarão aptos a buscarem a credencial Microsoft Certified IT PRO: Database Administrator 2008, para desenvolverem carreira como administrador ou desenvolvedor de bancos de dados.

Cursos

Conteúdo do curso

Desenvolvimento Web: Visual Studio .Net 2008 & Framework .Net 3.5 + SQL Server

Código

Período

Descrição

6460

24 horas

Visual Studio 2008 : Windows Presentation Foundation
1 - Creating an Application by Using WPF
- Overview of WPF
- Creating a Simple WPF Application
- Handling Events and Commands
- Navigating Between Pages
- Lab : Creating a WPF Application
- Creating a Standalone WPF Application
- Handling Events and Commands
- Navigating Between Pages
- Creating an XBAP Application
After completing this module, students will be able to:
- Explain WPF concepts and features.
- Create a simple WPF application.
- Handle events and commands.
- Navigate between pages in a WPF application.
2 - Building User Interfaces
- Defining Layout
- Using Content Controls
- Using Item Controls
- Hosting Windows Forms Controls
- Lab : Building User Interfaces
- Defining Layout
- Using Content Controls
- Using Item Controls
- Hosting Windows Forms Controls
After completing this module, students will be able to:
- Define layout.
- Use content controls.
- Use items controls.
- Host Windows Forms controls.
3 - Customizing Appearance
- Sharing Logical Resources in an Application
- Creating Consistent User Interfaces Using Styles
- Changing the Appearance of Controls Using Templates
- Using Triggers and Animations
- Lab : Customizing the Appearance of a WPF Application
- Sharing Logical Resources in an Application
- Creating Consistent User Interfaces Using Styles
- Changing the Appearance of Controls Using Templates
- Using Triggers and Animations
After completing this module, students will be able to:
- Share logical resources throughout and application.
- Create a consistent user interface appearance by using styles.
- Change the appearance of controls using templates.
- Change the appearance of user interface elements by using triggers and animations.
4 - Data Binding
- This module explains how to bind user interface controls to data sources.
- Overview of Data Binding
- Create a Data Binding
- Implementing Property Change Notification
- Converting Data
- Validating Data
- Lab : Data Binding
- Binding Controls to Data
- Implementing Property Change Notifications
- Defining Value Converters
- Validating Data
After completing this module, students will be able to:
- Explain WPF data binding concepts and terminology.
- Create a binding between a data source and a control.
- Implement property change notifications.
- Convert data between the binding source and the binding target.
- Validate data entered by the user.
5 - Data Binding to Collections
- Binding to Collections of Objects
- Using Collection Views
- Create Master-Detail User Interfaces
- Using Data Templates
- Lab : Data Binding to Collections
- Binding to Collections of Objects
- Using Collection Views
- Create Master-Detail User Interfaces
- Using Data Templates
After completing this module, students will be able to:
- Bind to a collection of objects.
- Sort, filter, and group collections by using collection views.
- Create master-detail user interfaces.
- Fine-tune data display by using data templates.
6 - Creating New Controls
- Overview of Control Authoring
- Creating Controls
- Lab : Creating New Controls
- Creating User Controls
- Creating Custom Controls
After completing this module, students will be able to:
- Explain scenarios and options for creating new controls.
- Create user controls.
- Create custom controls.
7 - Managing Documents
- Working with Flow Documents
- Working with Fixed Documents
- Packaging Documents
- Printing Documents
- Lab : Managing Documents
- Creating and Displaying Flow Documents
- Creating and Displaying Fixed Documents
- Packaging Documents
- Printing Documents
8 - Graphics and Multimedia
- Displaying 2D graphics
- Displaying Images
- Displaying 3D Graphics
- Going Further with 3D Graphics
- Adding Multimedia Support
- Lab : Adding Graphics and Multimedia Support to a WPF Application
- Displaying 2D graphics
- Displaying Images
- Displaying 3D Graphics
- Playing Audio and Video Clips
9 - Configure and Deploy WPF Applications
- Deployment Options
- Deploying a Standalone WPF Application
- Deploying an XBAP Application
- Configuring Security Settings
- Lab : Configuring and Deploying WPF Applications
- Deploying a Standalone WPF Application
- Creating Deployment and Application Manifests
- Deploying an XBAP Application
After completing this module, students will be able to:
- Explain deployment options.
- Deploy a standalone WPF application.
- Deploy an XBAP application.
- Configure security settings.

6461

24 horas

Visual Studio 2008 : Windows Communication Foundation Applications
1 - Getting Started with Windows Communication Foundation
- Designing an Application to Be Part of a Service Oriented Architecture
- Overview of WCF Architecture
- Using a Language-Level Interface As a Service Contract
- Implementing a Simple WCF Service in Visual Studio 2008
- Consuming a simple WCF service in Visual Studio 2008
- Lab : Creating a Simple Service
- Creating a Simple WCF Service
- Calling the Simple WCF Service
After completing this module, students will be able to:
- Explain how to design an application as part of a Service Oriented Architecture (SOA).
- Describe the main parts of the WCF architecture.
- Create a simple service contract for a WCF service.
- Implement a simple WCF service in Visual Studio 2008.
- Consume a simple WCF service in Visual Studio 2008.
2 - Configuring and Hosting WCF Services
- Programmatically Configuring a Managed Application to Host a WCF Service
- Programmatically Configuring a Managed Application to Call a WCF Service
- Defining Client and Service Settings by Using File-Based Configuration
- Selecting a Hosting Option for a WCF Service
- Deploying a WCF Service
- Lab : Configure and Host a WCF Service
- Creating a Programmatically Configured Managed Application to Host a Service
- Calling a Service Hosted in a Managed Application by Using Programmatic Configuration
- Defining Service Settings by Using External Configuration
- Employing Different Hosting Options for a Service
After completing this module, students will be able to:
- Create a programmatically-configured managed application that hosts a WCF service.
- Call a WCF service hosted in a managed application by using programmatic configuration.
- Define WCF service settings by using external configuration.
- Select the best hosting option for a WCF service.
- Deploy a WCF service onto a remote host.
3 - Endpoints and Behaviors
- Exposing WCF Services Over Different Endpoints
- Adding Behaviors to Services and Endpoints
- Interoperating with Non-WCF Web services
- Lab : Changing Service Endpoints and Behaviors
- Exposing Services by Using Different Bindings
- Adding Metadata Exchange to a Service
- Creating WCF Clients and Services That Interoperate with Non-WCF Web Services
After completing this module, students will be able to:
- Expose WCF services by using different bindings.
- Add behaviors to services and endpoints.
- Create WCF clients and services that interoperate with different types of Web services.
4 - Debugging and Diagnostics
- Logging Messages
- Activity Tracing
- Lab : Message Logging and Activity
- Generating Logging Information for a Service
- Enabling End-to-End Tracing for a Service
After completing this module, students will be able to:
- Log WCF messages.
- Trace WCF service activity.
5 - Designing and Defining Contracts
- Designing a Coherent and Cohesive WCF Service Interface
- Defining a Service Contract
- Defining Operations on a Service
- Defining a Data Contract
- Lab : Contracts for Services and Data
- Defining and Implementing a One-Way Operation Contract
- Passing Complex Data with a Data Contract
- Defining and Implementing a Callback Contract
After completing this module, students will be able to:
- Design a coherent and cohesive service contract.
- Define a service contract.
- Define operations on a service.
- Define a data contract.
6 - Handling Errors
- Relating .NET Exceptions to Service-Level Faults
- Using Faults in a Service
- Handling Faults and Exceptions on Clients
- Lab : Error Handling
- Handling Unexpected Errors in a WCF Service
- Add Fault Handling to a WCF Service and the Service Contract
After completing this module, students will be able to:
- Explain how .NET exceptions relate to service-level faults.
- Define fault information in a service contract.
- Handle service exceptions on clients.
7 - Improving WCF Service Quality
- Managing WCF Service Instances
- Managing Concurrency Issues
- Improving WCF Service Quality
- Lab : Improving WCF Service Quality
- Managing WCF Service Instances
- Managing Concurrency Issues
- Throttling Access to a WCF Service
- Passing Bulk Data Between a WCF Client and Service
After completing this module, students will be able to:
- Manage WCF service instances.
- Manage concurrency issues.
- Improve WCF service performance.
8 - Implementing WCF Security
- Overview of Security in WCF
- Applying Overall Security Requirements to a Binding
- Specifying Required Client and Service Credentials
- Working With Security Information
- Lab : Protecting a Service
- Applying Security for Internal Network Communication
- Applying Security for Internet Communication
After completing this module, students will be able to:
- Explain the process for implementing security in WCF.
- Apply overall security requirements to a binding.
- Specify required client and service credentials.
- Work with security information.
9 - Implementing Transactions
- Overview of Transactions in a Service-Oriented Application
- Creating Transactional Service Operations
- Enabling the Flow of Transactions from Client to Service
- Lab : Implementing Transactions for a Service
- Controlling the Flow of a Transaction from Client to Service
- Forcing a Transaction to Start When a Service Operation Is Called
After completing this module, students will be able to:
- Explain how transactions work in a service-oriented application.
- Create transactional service operations.
- Control transaction flow from client to service.

6463

16 horas

Visual Studio 2008 : ASP .Net 3.5
1 - Getting Started with ASP.NET 3.5
- Building Dynamic Web Pages with ASP.NET 3.5
- ASP.NET 3.5 Features
- Configuring ASP.NET Applications
- Lab : Creating and Configuring an ASP.NET 3.5 Application
- Creating an ASP.NET Application
- Configuring Session State
- Configuring Caching
2 - Implementing a User Interface with ASP.NET Server Controls
- Consuming Controls to Interact with Users
- Creating Custom Controls
- Lab : Consuming and Creating ASP.NET Server Controls
- Creating a User Interface by Using Web Server Controls in an ASP.NET Form
- Creating User Controls and Custom Server Controls
After completing this module, students will be able to:
- Create a user interface on an ASP.NET page by using standard Web server controls.
- Create a user control and a custom server control and add them to an ASP.NET page.
3 - Displaying and Manipulating Data in ASP.NET 3.5
- Accessing Data by Using ADO.NET 3.5
- Accessing Data from Services
- Rendering Data in Web Controls
- Lab : Displaying and Manipulating Data in ASP.NET 3.5
- Accessing Data from an XML File as a Data Source
- Consuming Data from a Web Service
- Displaying and Updating Data by Using Data-Bound Controls
4 - Creating Responsive Pages by Using Client-Side Technologies
- Creating Partial Page Updates by Using AJAX
- Scripting Actions on the Web Client
- Lab : Creating Responsive Pages by Using Client-Side Technologies
- Implementing Partial Page Updates by Using AJAX Controls
- Accessing a Web Service by Using a Client-Side Script
After completing this module, students will be able to:
- Improve page responsiveness by using the ASP.NET AJAX controls.
- Interact with the user, access services, and access the AJAX client-side library by using client scripts.
5 - Debugging and Deploying ASP.NET Applications
- Troubleshooting and Debugging ASP.NET Applications
- Deploying Completed ASP.NET Applications
- Lab : Debugging and Deploying ASP.NET Applications
- Debugging an ASP.NET Application
- Deploying an ASP.NET Application
6 - Writing ASP.NET Applications for Mobile Devices
- Rendering Pages According to Device Capabilities
- Creating Pages with Mobile Web Controls
- Lab : Adding Support for Mobile Devices
- Adding a Mobile Web Form to Your Application
- Displaying Data by Using Mobile Web Controls
6464

16 horas

Visual Studio 2008 : ADO .Net 3.5
1 - Getting Started with ADO.NET 3.5
- Introduction to ADO.NET 3.5
- Connecting to a Database and Retrieving Data
- Best Practices for Managing Connections and Performing Queries
- Lab : Connecting to a Database and Retrieving Data
- Connecting to a Database
- Executing a Simple Query
- Executing a Query That Returns a Result Set
- Executing a Query That Requires a Parameter
2 - Modifying Data by Using ADO.NET Commands
- Inserting, Updating, and Deleting Data
- Managing Data Integrity and Concurrency
- Lab : Modifying Data by Using ADO.NET Commands
- Inserting, Updating, and Deleting Data in a Database
- Implementing Transactional Updates
- Executing Commands Asynchronously
After completing this module, students will be able to:
- Insert, update, and delete data by using ADO.NET Command objects.
- Implement transactions to control data integrity and concurrency.
3 - Querying and Maintaining Data by Using DataSets
- Creating and Using a DataSet to Retrieve Data
- Updating a Database by Using a DataSet
- Using a DataSet in an Occasionally Connected Environment
- Lab : Using a DataSet to Retrieve and Modify Data
- Creating a Typed DataSet
- Retrieving Data into a DataSet
- Modifying Data in a DataSet
- Saving a DataSet and Resolving Conflicts
After completing this module, students will be able to:
- Define and use a DataSet for retrieving data.
- Use a DataSet to update a database.
- Use a DataSet as a local cache in an occasionally connected environment.
4 - Querying and Maintaining Data by Using LINQ
- Querying In-Memory Data by Using LINQ Query Expressions
- Retrieving Data by Using LINQ to SQL
- Modifying Data by Using LINQ to SQL
- Lab : Querying and Maintaining Data by Using LINQ to SQL
- Defining Entity Classes
- Retrieving Data by Using LINQ to SQL
- Modifying Data by Using LINQ to SQL
5 - Implementing an Entity Model by Using the ADO.NET Entity Framework
- Creating an Entity Data Model by Using the ADO.NET Entity Framework
- Querying and Modifying Data by Using the ADO.NET Entity Framework
- Lab : Implementing an Entity Data Model by Using the ADO.NET Entity Framework
- Creating an Entity Data Model
- Querying Entities in an Entity Data Model
- Modifying Entities in an Entity Data Model
After completing this module, students will be able to:
- Explain how to use the ADO.NET Entity Framework to map a database schema to a logical business model.
- Use the ADO.NET Entity Framework to query and manage data.
6 - Building Occasionally Connected Solutions by Using Synchronization Services
- Understanding Microsoft Synchronization Services
- Downloading Data by Using Synchronization Services
- Uploading Data by Using Synchronization Services
- Lab : Building Occasionally Connected Solutions by Using Synchronization Services
- Modifying a Database Schema to Support Synchronization
- Downloading Data to a Client Computer
- Uploading Data Changes to the Database
After completing this module, students will be able to:
- Explain how Synchronization Services supports occasionally-connected solutions.
- Use Synchronization Services to download data from a SQL Server database.
- Use Synchronization Services to upload data to a SQL Server database.
2778 24 horas
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
1 - Getting Started with Databases and Transact-SQL in SQL Server 2008
- Overview of SQL Server 2008
- Overview of SQL Server Databases
- Overview and Syntax Elements of T-SQL
- Working with T-SQL Scripts
- Using T-SQL Querying Tools
- 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.
2 - Querying and Filtering Data
- Using the SELECT Statement
- Filtering Data
- Working with NULL Values
- Formatting Result Sets
- Performance Considerations for Writing Queries
- 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.
3 - Grouping and Summarizing Data
- Summarizing Data by Using Aggregate Functions
- Summarizing Grouped Data
- Ranking Grouped Data
- Creating Crosstab Queries
- 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.
4 - Joining Data from Multiple Tables
- Querying Multiple Tables by Using Joins
- Applying Joins for Typical Reporting Needs
- Combining and Limiting Result Set
- 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.
5 - Working with Subqueries
- Writing Basic Subqueries
- Writing Correlated Subqueries
- Comparing Subqueries with Joins and Temporary Tables
- Using Common Table Expressions
- 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.
6 - Modifying Data in Tables
- Inserting Data into Tables
- Deleting Data from Tables
- Updating Data in Tables
- Overview of Transactions
- 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.
7 - 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
- 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.
8 - Using Programming Objects for Data Retrieval
- Overview of Views
- Overview of User-Defined Functions
- Overview of Stored Procedures
- Overview of Triggers
- Writing Distributed Queries
- 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.
9 - Using Advanced Querying Techniques
- Considerations for Querying Data
- Working with Data Types
- Cursors and Set-Based Queries
- Dynamic SQL
- Maintaining Query Files
- 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.
10142 40 horas
Manutenção de um Banco de Dados do Microsoft SQL Server 2008
1 - Instalação e configuração do SQL Server 2008
- Lição 1: Preparação para instalar o SQL Server 2008
- Lição 2: Instalação do SQL Server 2008
- Lição 3: Configuração de uma instalação do SQL Server 2008
- Laboratório: Instalação e configuração do SQL Server 2008
2 - Gerenciamento de bancos de dados e arquivos
- Lição 1: Planejamento de bancos de dados
- Lição 2: Criação de bancos de dados
- Lição 3: Uso do gerenciamento baseado em diretiva
- Laboratório: Gerenciamento de bancos de dados e arquivos
3 - Recuperação de desastres
- Lição 1: Planejamento de uma estratégia de backup de banco de dados
- Lição 2: Backup de bancos de dados de usuários
- Laboratório: Recuperação de desastres - parte A
- Lição 3: Restauração de bancos de dados de usuários
- Lição 4: Execução de operações de restauração online
- Lição 5: Recuperação de dados de instantâneos do banco de dados
- Lição 6: Bancos de dados do sistema e recuperação de desastres
- Laboratório: Recuperação de desastres - parte B
4 - Gerenciamento da segurança
- Lição 1: Visão geral da segurança do SQL Server
- Lição 2: Proteção do escopo do servidor
- Lição 3: Proteção do escopo do banco de dados
- Lição 4: Gerenciamento de chaves e certificados
- Lição 5: Auditoria da segurança
- Laboratório: Gerenciamento da segurança
5 - Transferência de dados
- Lição 1: Visão geral da transferência de dados
- Lição 2: Introdução ao SQL Server Integration Services
- Laboratório: Transferência de dados
6 - Automatização de tarefas administrativas
- Lição 1: Automatização de tarefas administrativas no SQL Server 2008
- Lição 2: Uso do SQL Server Agent
- Lição 3: Criação de planos de manutenção
- Lição 4: Implementação de alertas
- Lição 5: Gerenciamento de vários servidores
- Lição 6: Gerenciamento de segurança do SQL Server Agent
- Laboratório: Automatização de tarefas administrativas
7 - Implementação da replicação
- Lição 1: Visão geral da replicação
- Lição 2: Gerenciamento de publicações e assinaturas
- Lição 3: Configuração da replicação em alguns cenários comuns
- Laboratório: Implementação da replicação
8 - Manutenção da alta disponibilidade
- Lição 1: Introdução à alta disponibilidade
- Lição 2: Implementação do envio de logs
- Lição 3: Implementação do espelhamento de banco de dados
- Lição 4: Implementação do clustering de servidores
- Lição 5: Uso de soluções distribuídas de alta disponibilidade
- Laboratório: Manutenção da alta disponibilidade
9 - Monitoramento do SQL Server
- Lição 1: Exibição da atividade atual
- Lição 2: Uso do SQL Server Profiler
- Lição 3: Monitoramento com gatilhos DDL
- Lição 4: Uso das notificações de eventos
- Laboratório: Monitoramento do SQL Server
10 - Solução de problemas e ajuste de desempenho
- Lição 1: Solução de problemas do SQL Server
- Lição 2: Ajuste de desempenho no SQL Server
- Lição 3: Uso do Administrador de Recursos
- Lição 4: Uso do Coletor de Dados
- Laboratório: Solução de problemas e ajuste de desempenho
10169 40 horas
Implementação de um banco de dados do Microsoft® SQL Server® 2008
1 - Criação de bancos de dados e arquivos de banco de dados
- Lição 1: Criação de bancos de dados
- Lição 2: Criação de grupos de arquivos
- Lição 3: Criação de esquemas
- Lição 4: Criação de instantâneos do banco de dados
- Laboratório: Criação de bancos de dados e arquivos de banco de dados
2 - Criação de tipos de dados e tabelas
- Lição 1: Criação de tipos de dados
- Lição 2: Criação de tabelas
- Lição 3: Criação de tabelas particionadas
- Laboratório: Criação de tipos de dados e tabelas
3 - Criação e ajuste de índices
- Lição 1: Planejamento de índices - Lição 2: Criação de índices - Lição 3: Otimização de índices - Laboratório: Criação e otimização de índices
4 - Implementação da integridade dos dados usando restrições e gatilhos
- Lição 1: Visão geral da integridade dos dados
- Lição 2: Implementação de restrições
- Lição 3: Implementação de gatilhos
- Laboratório: Implementação da integridade dos dados usando restrições e gatilhos
5 - Uso de XML
- Lição 1: Uso do tipo de dados XML
- Lição 2: Recuperação de XML usando FOR XML
- Lição 3: Fragmentação de XML com OPENXML
- Laboratório 5A: Uso de XML
- Lição 4: Introdução ao XQuery
- Lição 5: Criação de índices XML
- Lição 6: Implementação de esquemas XML
- Laboratório 5B: Uso de XML
6 - Implementação de exibições
- Lição 1: Introdução a exibições
- Lição 2: Criação e gerenciamento de exibições
- Lição 3: Otimização de desempenho usando exibições
- Laboratório: Implementação de exibições
7 - Implementação de procedimentos armazenados
- Lição 1: Uso de procedimentos armazenados
- Lição 2: Criação de procedimentos armazenados com parâmetros
- Lição 3: Trabalho com planos de execução
- Lição 4: Manipulação de exceções
- Laboratório: Implementação de procedimentos armazenados
8 - Implementação de funções
- Lição 1: Introdução a funções
- Lição 2: Como trabalhar com funções
- Lição 3: Controle do contexto de execução
- Laboratório: Implementação de funções
9 - Implementação de código gerenciado em um banco de dados
- Lição 1: Introdução ao Common Language Runtime do SQL Server®
- Lição 2: Importação e configuração de assemblies
- Lição 3: Criação de objetos de banco de dados gerenciados
- Laboratório: Implementação de código gerenciado em um banco de dados
10 - Gerenciamento de transações e bloqueios
- Lição 1: Visão geral de transações e bloqueios
- Lição 2: Gerenciamento de transações
- Lição 3: Noções básicas sobre a arquitetura de bloqueio do SQL Server
- Lição 4: Gerenciamento de bloqueios
- Laboratório: Gerenciamento de transações e bloqueios
11 - Uso do Service Broker
- Lição 1: Visão geral do Service Broker
- Lição 2: Criação de objetos do Service Broker
- Lição 3: Envio e recebimento de mensagens
- Laboratório: Uso do Service Broker

Pré-requisitos

  • Ter uma larga experiência no desenvolvimento de aplicativos em um ambiente web, através das linguagens Visual Basic .Net ou C#, utilizando o .Net Framework 2.0 com o Microsoft Visual Studio 2005
  • Preferencialmente, já ter concluído os cursos da grade voltadas para o Ambiente Web, utilizando o Framework 2.0 e o Microsoft Visual Studio 2005
  • Já ter concluído com sucesso o exame 70-536 : TS: Microsoft.NET Framework 2.0 - Application Development Foundation
  • Conhecimento de conceitos de integridade de dados
  • Conhecimentos de Windows Server
  • Conhecimento de Modelagem de Base de Dados
  • Familiaridade com lógica de programação

Material didático

O material didático recebido pelo aluno são as apostilas oficiais entregues pela própria Microsoft. Quem poderá entregar o melhor conteúdo de aprendizagem, senão a própria empresa fabricante de seu produto?

Certificados e Exames

Certificado oficial Microsoft

Ao concluir pelo menos 75% (setenta e cinco por cento) de presença em todo o conteúdo o aluno receberá um certificado oficial da Miscrosoft.

Certificação Microsoft

Ao término de todo o treinamento, o aluno também estará apto a prestar as seguintes provas de Certificação Microsoft:

  • Exame 70-561 - TS: Microsoft .Net Framework 3.5, ADO.NET Application Development
  • Exame 70-562 - TS: Microsoft .Net Framework 3.5, ASP.NET Application Development
  • Exame 70-502 - TS: Microsoft .Net Framework 3.5, Windows Presentation Foundation Application Development
  • Exame 70-503 - TS: Microsoft .Net Framework 3.5, Windows Communication Foundation Application Development
  • Exame 70-432 - TS: Microsoft SQLServer 2008, Implementantion and Maintenance
  • Exame 70-433 - TS: Microsoft SQLServer 2008, Database Development
  • Exame 70-450 - PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008

Títulos Microsoft

Com isto, o aluno poderá obter os seguintes títulos Microsoft:

MCTS

.NET Framework 3.5, Windows Presentation Foundation Applications (Provas 70-536 e 70-502)

MCTS

.NET Framework 3.5, Windows Communication Foundation Applications (Provas 70-536 e 70-503)

MCTS .NET Framework 3.5, ADO.NET Applications (Provas 70-536 e 70-561)
MCTS .NET Framework 3.5, ASP.NET Applications (Provas 70-536 e 70-562)
Microsoft Certified Technology Specialist

Microsoft Certified Technology Specialist SQL Server 2008 : Database Development (70-432 e 70-433)

Microsoft Certified Professional

Microsoft Certified IT PRO: Database Administrator 2008 (70-432, 70-433 e 70-450)


Investimento para o cursos de Desenvolvimento Web

_

Associado Sindpd

Investimento total:
R$3.490,00
Forma de pagamento:
10 cheques de R$ 349,00

_

Ainda não é associado Sindpd?

Filie-se ao Sindpd

Horários

Horários disponíveis para este curso:

De segunda à sexta-feira
Período Diurno - das 08h30 às 17h
Período Noturno - das 18h00 às 22h30

Sábados
Período Diurno - das 08h30 às 17h

Inscrições

Inscreva-se já e chegue na frente dos seus concorrentes

Inscreva-se

Home | Notícias | Palavra do Presidente | Artigos | Publicações | Serviços | Jurídico | Faq | Links | Web Rádio

SINDPD - Sindicato dos Trabalhadores em Processamento de Dados e Empregados de Empresas de Processamento de Dados do Estado de São Paulo
Av. Angélica, 35 - Santa Cecília - São Paulo, SP - CEP: 01227-000 | Fone: (11) 3823.5600

Desenvolvimento Estúdio Saci

Central Geral dos Trabalhadores do Brasil Federação Sindical Mundial