6292/10228 - Instalação e Configuração do cliente Windows 7
Carga Horária: 3 dias / 5 noites
Objetivos:
Este curso de três dias conduzido por instrutor destina-se a profissionais de TI que estejam interessados em expandir sua base de dados e
suas habilidades técnicas relacionadas ao cliente Windows 7. Neste curso, os alunos aprendem a instalar, atualizar e migrar para o cliente
Windows 7. Em seguida, os alunos configuram o cliente Windows 7 para conectividade de rede, segurança, manutenção e computação
móvel. Este curso ajuda os alunos a se prepararem para o Exame 70-680, TS: Windows 7, Configuring.
Público-Alvo:
Este curso destina-se á profissionais de TI que estejam interessados em:
 Expandir sua base dados e suas habilidades técnicas relacionadas ao cliente Windows 7.
 Adquirir profundo conhecimento técnico do Windows 7.
 Conhecer os detalhes de tecnologias do Windows 7.
 Concentrar-se nos aspectos práticos associados a tecnologias do Windows 7.
A maioria desses profissionais usa alguma versão de cliente Windows no local de trabalho e está analisando novas e melhores formas de
executar algumas das funções atuais.
Depois de concluir este curso, os alunos serão capazes de:
 Executar uma instalação limpa do Windows 7, atualizar para o Windows 7 e migrar dados relacionados ao usuário e configurações de
uma versão anterior do Windows.
 Configurar discos, partições, volumes e drivers de dispositivo para habilitar um computador cliente Windows 7.
 Configurar o acesso a arquivo e impressoras em um computador cliente Windows 7.
 Configurar a conectividade de rede em um computador cliente Windows 7.
 Configurar a conectividade de rede sem fio em um computador cliente Windows 7.
 Proteger computadores desktop cliente Windows 7.
 Otimizar e manter o desempenho e a confiabilidade de um computador cliente Windows 7.
 Configurar a computador móvel e dispositivos para um computador cliente Windows 7.
Pré-requisitos:
Antes de participar deste curso, os alunos devem ter:
 Experiência em instalar hardware e dispositivos de PC.
 Noções básicas sobre conceitos de rede e TCP/IP.
 Conhecimentos básicos de Windows e Active Directory.
 Habilidades para mapear compartilhamentos de arquivos de rede.
 Experiência em trabalhar de um prompt de comando.
 Conhecimento de conceitos básicos de aplicativos. Por exemplo, como os aplicativos do computador cliente se comunicam com o
servidor.
 Conhecimento básico de conceitos de segurança, como a autenticação e a autorização.
 Conhecimento dos princípios básicos do uso de impressoras.
Conteúdo Programático
1 - Instalação, atualização e migração para o Windows 7
Este módulo explica como instalar, atualizar e migrar para o Windows 7. Ele também descreve os principais recursos, edições e requisitos
de hardware do Windows 7.
• Preparação para instalar o Windows 7;
• Execução de uma instalação limpa do Windows 7;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Atualização e migração para o Windows 7;
• Execução de uma instalação baseada em imagem do Windows 7;
• Configuração da compatibilidade de aplicativos.
Depois de concluir este módulo, os alunos serão capazes de:
• Descrever os principais recursos, edições e requisitos de hardware do Windows 7;
• Executar uma instalação limpa do Windows 7;
• Atualizar e migrar para o Windows 7 de uma versão anterior do Windows;
• Executar uma instalação baseada em imagem do Windows 7;
• Resolver problemas comuns de compatibilidade de aplicativos.
2 - Configuração de discos e drivers de dispositivo
Este módulo examina como configurar discos, partições, volumes e drivers de dispositivo para permitir que o Windows 7 funcione
conforme desejado.
• Particionamento de discos no Windows 7;
• Gerenciamento de volumes de disco;
• Manutenção de discos no Windows 7;
• Instalação e configuração de drivers de dispositivo.
Depois de concluir este módulo, os alunos serão capazes de:
• Configurar partições de disco em um computador cliente Windows 7;
• Criar e gerenciar volumes de disco;
• Gerenciar a fragmentação do sistema de arquivos e cotas de disco;
• Instalar e configurar drivers de dispositivo.
3 - Configuração de acesso a arquivos e impressoras em computadores cliente Windows 7
Este módulo explica como gerenciar o acesso a pastas compartilhadas e impressoras em um computador executando o Windows 7.
Especificamente, ele descreve como compartilhar e proteger pastas, configurar a compactação de pastas e como instalar, configurar e
administrar a impressão.
• Visão geral de autenticação e autorização;
• Gerenciamento do acesso a arquivos no Windows 7;
• Gerenciamento de pastas compartilhadas;
• Configuração da compactação de arquivos;
• Gerenciamento da impressão.
Depois de concluir este módulo, os alunos serão capazes de:
• Descrever a autenticação e a autorização;
• Gerenciar o acesso a arquivo em um computador cliente Windows 7;
• Criar e gerenciar pastas compartilhadas;
• Configurar a compactação de arquivos;
• Instalar, configurar e administrar impressoras.
4 - Configuração da conectividade de rede
Este módulo explica a conectividade de rede IPv4 e IPv6. Ele também descreve como implementar a alocação automática de endereço IP
e solucionar problemas de conectividade de rede.
• Configuração da conectividade de rede IPv4;
• Configuração da conectividade de rede IPv6;
• Implementação da alocação automática de endereço IP;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Visão geral da resolução de nomes;
• Solução de problemas de rede.
Depois de concluir este módulo, os alunos serão capazes de:
• Configurar a conectividade de rede IPv4;
• Configurar a conectividade de rede IPv6;
• Implementar a alocação automática de endereço IP;
• Solucionar problemas comuns de rede usando as ferramentas disponíveis no Windows 7.
5 - Configuração de conexões de rede sem fio
Este módulo descreve as principais tecnologias de rede sem fio e como configurar componentes de rede sem fio e os elementos do
Windows 7 necessários para acessar redes sem fio.
• Visão geral de redes sem fio;
• Configuração de uma rede sem fio.
Depois de concluir este módulo, os alunos serão capazes de:
• Descrever os padrões e as tecnologias relacionadas a conexões de rede sem fio;
• Configurar uma conexão de rede sem fio.
6 - Proteção de áreas de trabalho do Windows 7
Este módulo descreve como tornar um computador Windows 7 mais seguro sem sacrificar a usabilidade no processo. Especificamente,
ele descreve o Firewall do Windows, o Controle de Conta de Usuário, o Windows Defender e a segurança no Internet Explorer 8.
• Visão geral do gerenciamento de segurança no Windows 7;
• Proteção de um computador cliente Windows 7 usando configurações de diretiva de segurança locais;
• Proteção de dados usando EFS e BitLocker;
• Configuração de restrições de aplicativo;
• Configuração do Controle de Conta de Usuário;
• Configuração do Firewall do Windows;
• Configurações de segurança no Internet Explorer 8;
• Configuração do Windows Defender.
Depois de concluir este módulo, os alunos serão capazes de:
• Explicar os recursos de gerenciamento de segurança do Windows 7;
• Definir configurações de diretiva de segurança locais em um computador cliente Windows 7;
• Proteger dados usando EFS e BitLocker;
• Configurar restrições de aplicativo usando o AppLocker;
• Definir configurações do Controle de Conta de Usuário;
• Configurar o Firewall do Windows em um computador cliente Windows 7;
• Definir configurações de segurança no Internet Explorer para ajudar a proteger um computador cliente Windows 7 que esteja
conectado à Internet;
• Configurar o Windows Defender para ajudar a proteger um computador cliente Windows 7 contra software mal-intencionado.
7 - Otimização e manutenção de computadores cliente Windows 7
Este módulo descreve como usar as ferramentas de monitoramento e configuração para obter informações sobre o desempenho do
Windows 7 e como solucionar problemas de desempenho e confiabilidade.
• Manutenção do desempenho usando as ferramentas de desempenho do Windows 7;
• Manutenção da confiabilidade usando as ferramentas de diagnóstico do Windows 7;
• Backup e restauração de dados usando o Backup do Windows;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Restauração de um sistema Windows 7 usando pontos de restauração do sistema;
• Configuração do Windows Update.
Depois de concluir este módulo, os alunos serão capazes de:
• Manter o desempenho de um computador cliente Windows 7 usando ferramentas de gerenciamento de desempenho;
• Manter a confiabilidade de um computador cliente Windows 7 usando as ferramentas de diagnóstico;
• Fazer backup de dados e restaurá-los em um computador cliente Windows 7 usando o Backup do Windows;
• Restaurar um sistema Windows 7 usando pontos de restauração do sistema;
• Configurar o Windows Update em um computador cliente Windows 7.
8 - Configuração de computação móvel e acesso remoto no Windows 7
Este módulo explica como configurar dispositivos móveis e o acesso remoto. Ele também aborda o DirectAccess e o BranchCache, que
são novidades no Windows 7.
• Configuração de computadores e dispositivos móveis;
• Configuração de Área de Trabalho Remota e Assistência Remota para acesso remoto;
• Configuração do DirectAccess para acesso remoto;
• Configuração do BranchCache para acesso remoto.
Depois de concluir este módulo, os alunos serão capazes de:
• Configurar a computação móvel e dispositivos em um computador cliente Windows 7;
• Configurar Área de Trabalho Remota e Assistência Remota em um computador cliente Windows 7;
• Configurar o DirectAccess em um computador cliente Windows 7 para acesso remoto;
• Configurar o BranchCache em um computador cliente Windows 7 de filial.
Exame
TS: 70-680: Windows 7, Configuring
(disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6294 - Planning and Managing Windows 7 Desktop Deployments and Environments
Carga Horária: 5 dias / 10 noites
Objectives: This five-day instructor-led course is intended for desktop administrators who want to specialize in desktop
deployment, configuration, and management. In this course, students will learn how to plan and deploy Windows 7
desktops in large organizations. They will also learn how to design, configure, and manage the Windows 7 client
environment.
This course helps students prepare for the Exam 70-686, Pro: Windows 7, Enterprise Desktop Administrator.
Audience: This course is intended for IT Professionals who are interested in specializing in Windows 7 desktop and
application deployments and managing the desktop environments for large organizations. People attending this training
could be support technicians or currently in deployment roles and are looking at taking the next step in their career or
enhancing their skills in the areas of planning and deploying Windows 7 desktops.
At Course Completion
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this course, students will be able to:
• Prepare to deploy Windows 7 business desktops.
• Assess and resolve application compatibility issues with Windows 7.
• Determine the most appropriate method to deploy Windows 7 based upon specific business requirements.
• Design a standard Windows 7 image by assessing and evaluating the business requirements.
• Deploy Windows 7 by using WAIK.
• Deploy Windows 7 by using WDS.
• Deploy Windows 7 by using Lite Touch Installation.
• Deploy Windows 7 by using Zero Touch Installation.
• Migrate user state by using Windows Easy Transfer and User State Migration Tool 4.0.
• Design, configure, and manage the Windows 7 client environment.
• Plan and deploy applications and updates to Windows 7 client computers.
• Plan and deploy Windows 7 by using LTI. (Lab-Only Module)
Prerequisites:
Before attending this course, students must have:
• A solid understanding of TCP/IP and networking concepts.
• A solid Windows and Active Directory background. For example, domain user accounts, domain vs. local user accounts,
user profiles, and group membership.
• A good understanding of scripts and batch files.
• A solid understanding of security concepts such as authentication and authorization.
• Performed a clean installation of Windows 7, Upgrade to Windows 7, and migrate user-related data and settings from
Windows XP.
• Configured disks, partitions, volumes, and device drivers to enable Windows 7 to function as desired.
• Experience configuring and troubleshooting permissions and other settings to allow access to resources and applications
on Windows 7 Systems.
• Experience configuring settings to enable network connectivity.
• Experience configuring and troubleshooting a wireless network connection.
• Experience configuring and troubleshooting Windows 7 security.
• Configure mobile computers and devices.
• Familiarity with the client administration capabilities of Windows Server and familiar with management tools such as the
System Center suite of products.
• Familiarity with deployment, packaging, and imaging tools.
• The ability to work in a team/virtual team
• Trained and mentored others
Course Outline:
1 - Preparing to Deploy Windows 7 Business Desktops
This module helps you plan and perform effective preparation tasks for deploying Windows 7 clients. It begins by discussing
client, hardware, and deployment lifecycles. It also discusses how to assess existing computing environments and licensing.
• Overview of the Desktop Lifecycle;
• Desktop Deployment: Challenges and Considerations;
• Tools and Technologies Used in the Desktop Deployment Lifecycle;
• Assessing the Current Computing Environment for Deploying Windows 7;
• Designing Windows Activation.
- Lab : Assessing the Computing Environment by Using the Microsoft Assessment and Planning Toolkit
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Assessing the Computing Environment by Using Microsoft Assessment and Planning Toolkit.
- Lab : Recommending an Activation Strategy
• Review the Activation Scenario.
After completing this module, students will be able to:
• Describe the client, hardware, and desktop deployment lifecycles;
• Explain the challenges involved and considerations for deploying desktops;
• Describe the tools and technologies that are used in the desktop deployment lifecycle;
• Assess the current computing environment to determine the feasibility of deploying Windows 7;
• Design the licensing and activation strategy for a given business scenario.
2 - Assessing Application Compatibility in Windows 7
This module describes the process for addressing common application compatibility issues experienced during a typical
operating system deployment. It also explains how to use the Microsoft Application Compatibility Toolkit (ACT) to help
inventory, analyze, and mitigate application compatibility issues.
• Overview of Application Compatibility;
• Assessing and Resolving Application Compatibility Issues by Using ACT 5.5.
- Lab : Evaluating Application Compatibility Using the Microsoft Application Compatibility Toolkit
• Installing and Configuring ACT;
• Collecting Application Inventory;
• Organizing the Application Inventory;
• Analyzing Application Inventory Results.
- Lab : Creating Application Compatibility Fixes
• Identifying Application Compatibility Issues;
• Mitigating Application Issues.
After completing this module, students will be able to:
• Describe the process and guidelines for resolving common application compatibility issues during an operating system
deployment;
• Inventory, analyze, and mitigate application compatibility issues by using ACT 5.5.
3 - Evaluating Windows 7 Deployment Methods
This module discusses different deployment scenarios and methods that are available when deploying Windows 7. It also
discusses various tools and technologies to use in the different scenarios, and considerations for selecting a deployment
scenario and method.
• Evaluating In-Place Deployment;
• Evaluating Side-by-Side Deployment;
• Evaluating Lite-Touch Deployment Method;
• Evaluating Zero-Touch Deployment Method.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
- Lab : Determining the Windows 7 Deployment Method
• Determining Windows 7 Deployment Methods.
After completing this module, students will be able to:
• Determine the feasibility of installing Windows 7 by using in-place deployment;
• Determine the feasibility of installing Windows 7 by using side-by-side deployment;
• Determine the feasibility of using the Lite Touch deployment method for deploying Windows 7 in a given business
scenario;
• Determine the feasibility of using the Zero Touch deployment method for deploying Windows 7 in a given business
scenario.
4 - Designing Standard Windows 7 Images
This module, explains the underlying architecture of the computer imaging system that can be used to create and deploy a
custom image of a Windows 7 desktop. It also discusses the different phases of the imaging process, and how to determine
imaging strategy and image servicing opportunities in Windows 7.
• Overview of Windows 7 Installation Architecture;
• Overview of the Imaging Process;
• Determining the Image Strategy;
• Selecting the Image Servicing Methods.
- Lab : Determining the Windows 7 Imaging Strategy
• Determining the Windows 7 Image Strategy.
After completing this module, students will be able to:
• Explain the Windows 7 installation architecture;
• Explain the different phases of the imaging process;
• Determine the appropriate Windows 7 imaging strategy based on specific business requirements;
• Select appropriate image servicing methods to service Windows 7 images based on specific business requirements.
5 - Deploying Windows 7 by Using WAIK
This module explains the underlying computer imaging architecture of Windows AIK 2.0, which can be used to create and
deploy a custom Windows 7 desktop image.
• Overview of WAIK 2.0;
• Building a Reference Windows 7 Image by Using Windows SIM and Sysprep;
• Managing the Windows Preinstallation Environment;
• Capturing, Applying, and Servicing a Windows 7 Image.
- Lab : Installing WAIK
• Install the Windows Automated Installation Kit;
• Identify Resources and Tools included with the Windows Automated Installation Kit.
- Lab : Building a Reference Image Using Windows SIM and Sysprep
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Building a Custom Answer File by Using Windows SIM;
• Installing a Reference Computer using a Custom Answer File;
• Generalizing a Reference Computer by Using Sysprep.
- Lab : Creating Windows PE Boot Media
• Adding Packages and Drivers to Windows PE;
• Creating a Bootable Windows PE ISO Image;
• Starting the Windows PE Operating System Environment.
- Lab : Capturing and Applying a Windows 7 Image Using ImageX
• Capturing an Image Using ImageX;
• Apply an Image Using ImageX.
- Lab : Servicing Images by Using DISM
• Servicing a Reference image using DISM.
After completing this module, students will be able to:
• Explain the key features and functionality provided by WAIK 2.0;
• Build a reference Windows 7 image by using Windows SIM and Sysprep;
• Create a custom Windows PE bootable image;
• Capture, apply, and service a Windows 7 image.
6 - Deploying Windows 7 by Using Windows Deployment Services
This module describes how WDS can be used to deploy custom system images to client computers located within the
network infrastructure.
• Overview of WDS;
• Designing and Configuring WDS for Windows 7 Deployment.
- Lab : Deploying Windows 7 by Using Windows Deployment Services
• Designing the WDS Environment;
• Installing and Configuring the WDS Server Role;
• Adding Boot and Install Images to WDS;
• Provisioning Drivers by Using WDS;
• Deploying a Desktop Operating System Using WDS.
After completing this module, students will be able to:
• Explain how WDS can be used to deploy Windows 7;
• Design and configure WDS for Windows 7 deployment.
7 - Deploying Windows 7 by Using Lite Touch Installation
This module describes how to design the Lite Touch Installation (LTI) environment, and provides you with an overview of
the techniques that you can use to build and deploy Windows 7 using the MDT and the LTI scenario.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Designing the Lite Touch Installation Environment;
• Implementing MDT 2010 for Deploying Windows 7.
- Lab : Planning and Configuring MDT 2010
• Planning the MDT Lite Touch Environment;
• Installing MDT 2010 and Additional Component Files;
• Configuring the Deployment Share;
• Creating a Task Sequence.
- Lab : Deploying Windows 7 by Using Lite Touch Installation
• Updating the Deployment Share to Generate Windows PE Media;
• Installing Windows 7 Using Lite Touch Installation.
After completing this module, students will be able to:
• Design the Lite Touch installation environment for deploying Windows 7;
• Perform Lite Touch installation of Windows 7 by using MDT 2010.
8 - Deploying Windows 7 by Using Zero Touch Installation
This module describes the necessary prerequisites and procedures for deploying the Windows 7 operating system using
Zero Touch Installation methodology.
• Designing the Zero Touch Installation Environment;
• Performing Zero-touch Installation of Windows 7 by using MDT 2010 and Configuration Manager 2007.
- Lab : Deploying Windows 7 by Using Zero Touch Installation
• Planning the Zero Touch Installation Environment;
• Preparing the Zero Touch Installation Environment;
• Configuring Deployment Packages and System Images;
• Configuring and Advertising a Client Task Sequence.
After completing this module, students will be able to:
• Design the Zero Touch installation environment for deploying Windows 7;
• Perform the Zero Touch installation of Windows 7 by using MDT 2010 and Configuration Manager 2007.
9 - Migrating User State by Using WET and USMT 4.0
This module explains user state migration, and how to use tools, such as Windows Easy Transfer and the Microsoft
Windows User State Migration Tool (USMT), in various migration scenarios.
• Overview of User State Migration;
• Overview of USMT 4.0;
• Planning User State Migration (USMT 4.0);
• Migrating User State by Using USMT 4.0.
- Lab : Migrating User State by Using Windows Easy Transfer
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Preparing the Window Easy Transfer Source Files;
• Capturing User State Information from a Source Computer;
• Loading User State Information to a Target Computer.
- Lab : Migrating User State by Using the User State Migration Tool 4.0
• Planning for the User State Migration;
• Creating USMT Migration Scripts;
• Capturing and Restoring User State by Using USMT;
• Performing a Hard-Link Migration.
- Lab : Migrating User State by Using State using Hard Link Migration
• Performing a Hard-Link Migration.
After completing this module, students will be able to:
• Migrate user state by using WET;
• Explain how USMT 4.0 can be used to migrate user state;
• Plan for user state migration;
• Migrate user state by using USMT 4.0.
10 - Designing, Configuring, and Managing the Client Environment
This module examines how to design, configure, and manage Windows 7 client configurations. Specifically, it discusses
Group Policy, Internet Explorer, and system security settings.
• Overview of Planning Client Configuration;
• Designing and Configuring Standard System Settings;
• Designing and Configuring Internet Explorer Settings;
• Designing and Configuring Security Settings;
• Designing and Implementing Group Policy;
• Troubleshooting Group Policy.
- Lab : Designing and Configuring the Client Environment
• Designing a Client Environment;
• Implementing a Client Configuration.
- Lab : Troubleshooting GPO Issues
• Resolving a GPO Application Problem.
After completing this module, students will be able to:
• Determine the method for implementing the client configuration;
• Design and configure standard system settings on Windows 7 client computers;
• Design and configure Internet Explorer settings on Windows 7 client computers;
• Design and configure security settings on Windows 7 client computers;
• Design and implement group policy for configuring Windows 7 client computers;
• Troubleshoot group policy issues.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
11 - Planning and Deploying Applications and Updates to Windows 7 Clients
This module discusses the implications of deploying applications to Windows 7 clients including Microsoft Office 2007. It
also discusses the use of Windows Server Update Services (WSUS).
• Determining the Application Deployment Method;
• Deploying the 2007 Microsoft Office System;
• Planning and Configuring Desktop Updates by Using WSUS.
- Lab : Determining the Application Deployment Method
• Determining the Application Deployment Method.
- Lab : Customizing the Microsoft Office Professional Plus 2007 Installation
• Configuring the Setup Category;
• Configuring the Features Category;
• Installing Microsoft Office Professional Plus By Using the Setup Customization File.
- Lab : Planning and Managing Updates by Using WSUS
• Planning Automatic Updates Settings;
• Configuring Automatic Updates Settings by Using Group Policy;
• Approving and Deploying an Update by Using WSUS.
After completing this module, students will be able to:
• Determine an appropriate application deployment method based upon business requirements;
• Customize and deploy Office 2007 based on business requirements;
• Plan and configure desktop updates by using WSUS.
12 - Planning and Deploying Windows 7 by Using LTI
This module is a comprehensive lab that gives the students an opportunity to perform an end-to-end deployment of
Windows 7 by using the LTI.
• Deploying Windows 7 – Challenge Scenario.
- Lab : Planning an End-to-End Windows 7 LTI Deployment
• Planning the MDT Lite Touch Environment.
- Lab : Deploying Windows 7 using the LTI Deployment Plan
• Performing a Network Assessment;
• Configuring MDT 2010 for an LTI Deployment;
• Configuring WDS for a PXE and Multicast Deployment;
• Configuring an MDT 2010 Deployment Share;
• Creating the Reference Computer;
• Preparing the Deployment Task Sequences;
• Performing an Upgrade on Target Computers.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this module, students will be able to:
• Plan an end-to-end Windows 7 LTI deployment;
• Deploy Windows 7 by using the LTI deployment plan.
Exame
70-686, Pro: Windows 7, Enterprise Desktop Administrator
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6421 - Configuring and Troubleshooting a Windows Server 2008 Network
Infrastructure
Carga Horária: 5 dias / 10 noites
About this Course:
This five-day instructor-led course provides students with the knowledge and skills to configure and troubleshoot Windows Server 2008
and Windows Server 2008 R2 Sp1 Network Infrastructures. It will cover networking technologies most commonly used with Windows
Server 2008 and Windows Server 2008 R2 Sp1 such as DNS, DHCP, IPv4 and IPv6 network addressing, Network Policy server and Network
Access Protection and configuring secure network access. It also covers fault tolerant storage technologies, Network Storage and routing
and remote access, monitoring and compliance updates as well as other relevant technologies.
Audience Profile: This course will be of interest and benefit to attendees with different back grounds and career aspirations. It will be of
interest to Network Administrators who currently are, or will be, working with Windows Server 2008 servers. It will also be of interest
and benefit to Active Directory technology specialists who aspire to be Enterprise Administrators (Tier 4 day-to-day network operations)
or experienced Server Administrators who aspire to be Enterprise Administrators.
Storage Area Network Administrators who need to understand this information to deploy or extend their current storage infrastructure
and Operations Managers who need this information to support troubleshooting efforts and business decisions would also benefit from
this course.
This course also maps directly to the 70-642:TS: Windows Server 2008 Network Infrastructure, Configuring exam objective domain and is
part of the MCTS prerequisites for the MCITP: Server Administrator credential. As such people looking to take the 70-642 exam or obtain
the MCITP: Server Administrator credential would also benefit from attending this course.
At Course Completion:
After completing this course, students will be able to:
• Plan and configure an IPv4 network infrastructure.
• Implement DHCP within their organization.
• Configure and troubleshoot DNS.
• Configure, transition to, and troubleshoot IPv6.
• Configure and troubleshoot Routing and Remote Access.
• Install, configure, and troubleshoot the Network Policy Server Role service.
• Implement Network Access Protection.
• Implement security features within Windows Server 2008 and Windows Server 2008 R2.
• Implement security features within Windows Server 2008 and Windows Server 2008 R2 that help to secure network communications.
• Configure and troubleshot file and print services.
• Enable and configure services to optimize branch office data access.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Control and monitor network storage.
• Recover data on Windows Server 2008 and Windows Server 2008 R2 servers.
• Monitor Windows Server 2008 and Windows Server R2 network infrastructure services
Prerequisites:
Before attending this course, students must have:
• You must have an intermediate understanding of Windows Server operating systems such as Windows Server 2003, Windows Server
2008 or Windows Server 2008 R2 Sp1 and Windows client operating systems such as Windows Vista or Windows 7. Client operating
system knowledge equivalent to the below certifications would be of benefit.
Exam 70-680: TS: Windows 7, Configuration or Exam 70-620: TS: Windows Vista, Configuring
• You should understand how TCP/IP functions and have a basic understanding of addressing, name resolution (Domain Name System
[DNS]/Windows Internet Name Service [WINS]), connection methods (wired, wireless, virtual private network [VPN]).
• You should have an awareness of security best practices such as understanding file system permissions, authentication methods,
workstation, and server hardening methods, and so forth.
The minimum level of knowledge required in the above three bullet points, excluding the client experience, can be covered by having
knowledge equivalent to the MOC course 6420B: Fundamentals of Windows Server 2008
• Basic knowledge of Active Directory would also be of benefit.
Course Outline:
1- Planning and Configuring IPv4
This module explains how to deploy and configure networking services in your organization. This module explains how to implement an
IPv4 addressing scheme, determine which name services to deploy, and troubleshoot network-related problems.
• Implementing an IPv4 Network Infrastructure
• Overview of Name Resolution Services in an IPv4 Network Infrastructure
• Configuring and Troubleshooting IPv4.
2- Configuring and Troubleshooting DHCP
This module introduces you to Dynamic Host Configuration Protocol (DHCP), which plays an important role in the Windows Server 2008
R2 infrastructure. It is the primary means of distributing important network configuration information to network clients, and it provides
configuration information to other network-enabled services, including Windows Deployment Services (WDS) and Network Access
Protection (NAP). To support and troubleshoot a Windows Server-based network infrastructure, it is important that you understand how
to deploy, configure, and troubleshoot the DHCP Server Role.
• Overview of the DHCP Server Role
• Configuring DHCP Scopes
• Configuring DHCP Options
• Managing a DHCP Database
• Monitoring and Troubleshooting DHCP
• Configuring DHCP Security
3- Configuring and Troubleshooting DNS
This module introduces you to Domain Name System (DNS), which is the foundation name service in Windows Server 2008 R2. It is vital
that you understand how to deploy, configure, manage, and troubleshoot this critical service.
• Installing the DNS Server Role
• Configuring the DNS Server Role
• Configuring DNS Zones
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Configuring DNS Zone Transfers
• Managing and Troubleshooting DNS
4- Configuring and Troubleshooting IPv6 TCP/IP
This module introduces you to IPv6, a technology that will help ensure that the Internet can support a growing user base and the
increasingly large number of IP-enabled devices. The current Internet Protocol Version 4 (IPv4) has served as the underlying Internet
protocol for almost thirty years. Its robustness, scalability, and limited feature set is now challenged by the growing need for new IP
addresses, due in large part to the rapid growth of new network-aware devices.
• Overview of IPv6
• IPv6 Addressing
• Coexistence with IPv6
• IPv6 Transition Technologies
• Transitioning from IPv4 to IPv6
5- Configuring and Troubleshooting Routing and Remote Access
To support your organization’s distributed workforce, you must become familiar with technologies that enable remote users to connect
to your organization’s network infrastructure. These technologies include virtual private networks (VPNs) and DirectAccess. It is
important that you understand how to configure and secure your remote access clients by using network policies. This module explores
these remote access technologies.
• Configuring Network Access
• Configuring VPN Access
• Overview of Network Policies
• Overview of the Connection Manager Administration Kit
• Troubleshooting Routing and Remote Access
• Configuring Direct Access
6- Installing, Configuring, and Troubleshooting the Network Policy Server Role Service
NPS provides support for the Remote Authentication Dial-In User Service (RADIUS) protocol, and can be configured as a RADIUS server or
proxy. Additionally, NPS provides functionality that is essential for the implementation of Network Access Protection (NAP). This module
explains how to install, configure, and troubleshoot NPS
• Installing and Configuring a Network Policy Server
• Configuring RADIUS Clients and Servers
• NPS Authentication Methods
• Monitoring and Troubleshooting a Network Policy Server
7- Implementing Network Access Protection
In this module, you will learn about Network Access Protection (NAP). NAP enables you to create customized health-requirement policies
to validate computer health before allowing access or communication. NAP also automatically updates compliant computers to ensure
on-going compliance and can limit the access of noncompliant computers to a restricted network until they become compliant.
• Overview of Network Access Protection
• How NAP Works
• Configuring NAP
• Monitoring and Troubleshooting NAP
8- Increasing Security for Windows Servers
Security is an essential consideration for networking with Windows Server 2008. In this module, you will learn how to implement various
methods to increase security. Windows Firewall with Advanced Security is one of the features in Windows Server 2008 that is used to
increase security. You can also use Windows Server Update Services to ensure that approved security updates are applied to servers in a
timely way.
• Windows Security Overview
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Configuring Windows Firewall with Advanced Security;
• Deploying Updates with Windows Server Update Services
• Monitoramento e solução de problemas da NAP.
9- Increasing Security for Network Communication
Internet Protocol security (IPsec) is a framework of open standards for protecting communications over IP networks through
cryptographic security services. IPsec supports network-level peer authentication, data-origin authentication, data integrity, data
confidentiality (encryption), and replay protection. The Microsoft IPsec implementation is based on standards that the Internet
Engineering Task Force (IETF) IPsec working group developed. In this module, you will learn how to implement, configure, and
troubleshoot IPsec
• Overview of IPsec
• Configuring Connection Security Rules
• Configuring NAP with IPsec Enforcement
• Monitoring and Troubleshooting IPsec
10- Configuring and Troubleshooting Network File and Print Services
File and print services are some of the most commonly implemented network services for end users. Unlike infrastructure services like
DNS, file and print services are highly visible to the end users. In this module, you will learn how to configure and troubleshoot file and
print services to provide high quality service to end users. In addition, you will see how both EFS and BitLocker can be used to increase
the security of files that are located in file shares.
• Configuring and Troubleshooting File Shares
• Encrypting Network Files with EFS
• Encrypting Partitions with BitLocker
• Configuring and Troubleshooting Network Printing
11- Optimizing Data Access for Branch Offices
Many organizations maintain a large number of file resources that need to be organized and made highly available to users. These file
resources are often stored on servers and provided to users who are distributed geographically in widespread locations. In this module,
you will learn how to provide efficient access to network resources with minimal traffic over a WAN link
• Branch Office Data Access
• DFS Overview
• Overview of DFS Namespaces
• Configuring DFS Replication
• Configuring BranchCache
12- Controlling and Monitoring Network Storage
Network storage for users is a finite resource that must be managed appropriately to ensure that it remains available for all users. If
network storage is not monitored and managed, it can become filled with irrelevant data, such as personal music or movies. Irrelevant
data increases network storage costs and in some cases can prevent useful data from placement on the network storage. In this module,
you will learn how to monitor and manage network storage.
• Monitoring Network Storage
• Controlling Network Storage Utilization
• Managing File Types on Network Storage
13- Recovering Network Data and Servers
This module explains how to recover network data and servers. There are a variety of scenarios where a network data or a server that
provides networks services can be lost. Volume shadow copies can be used to restore previous versions of files when a file is accidentally
deleted or modified on a computer that is running Windows Server 2008. Windows Server Backup can be used to back up and restore
data files or an entire server.
• Recovering Network Data with Volume Shadow Copies
• Recovering Network Data and Servers with Windows Server Backup
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
14- Monitoring Windows Server 2008 Network Infrastructure Servers
When a system failure or an event that affects system performance occurs, you need to be able to repair the problem or resolve the
issue quickly and efficiently. With so many variables and possibilities in the modern network environment, the ability to determine the
root cause quickly often depends on having an effective performance monitoring methodology and toolset. In this module, you will learn
to use performance-monitoring tools to identify components that require additional tuning and troubleshooting. By identifying
components that require additional tuning, you can improve the efficiency of your servers.
• Monitoring Tools
• Using Performance Monitor
• Monitoring Event Logs
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6425 - Configuring and Troubleshooting Windows Server 2008 Active Directory
Domain Services
Carga Horária: 5 dias / 10 noites
About this Course:
This five-day instructor-led course provides in-depth training on implementing, configuring, managing and troubleshooting Active
Directory Domain Services (AD DS) in Windows Server 2008 and Windows Server 2008 R2 environments. It covers core AD DS concepts
and functionality as well as implementing Group Policies, performing backup and restore and monitoring and troubleshooting Active
Directory related issues. After completing this course students will be able to configure AD DS in their Windows Server 2008 and
Windows server 2008 R2 environments.
The course also provides a direct mapping to the objective domain of the 70-640: TS: Windows Server 2008 Active Directory, Configuring
exam.
Audience Profile:
This course is intended for Active Directory Technology Specialists, Server and Enterprise Administrators who want to learn how to
implement Active Directory Domain Services in Windows Server 2008 and Windows Server 2008 R2 environments. Those attending
would be interested in learning how to secure domains by using Group Policies, back up, restore, monitor, and troubleshoot
configuration to ensure trouble-free operation of Active Directory Domain Services.
Those intending to take the 70-640: TS: Windows Server 2008 Active Directory, Configuring exam will also benefit from attendance at this
course.
At Course Completion:
After completing this course, students will be able to:
• Describe the features and functionality of Active Directory Domain Services.
• Perform secure and efficient administration of Active Directory.
• Manage users and service accounts.
• Manage groups.
• Manage computer accounts.
• Implement a Group Policy infrastructure.
• Manage User Desktops with Group Policy.
• Manage enterprise security and configuration by using Group Policy settings.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Secure administration.
• Improve the security of authentication in an AD DS Domain.
• Configure Domain Name System.
• Administer AD DS domain controllers.
• Manage sites and Active Directory Replication.
• Monitor, maintain and back up directory Service to ensure Directory Service continuity.
• Manage multiple domains and forests.
Prerequisites:
Before attending this course, students must have:
• Basic understanding of networking
• Intermediate understanding of network operating systems
• An awareness of security best practices
• Basic knowledge of server hardware
• Some experience creating objects in Active Directory
• Basic concepts of backup and recovery in a Windows Server environment
• A good knowledge of Windows Client operating systems such as Windows Vista or Windows 7
Course Outline:
1- Introducing Active Directory Domain Services
This module provides an overview of Active Directory components and concepts and steps through the basics of installing and
configuring an Active Directory domain.
• Overview of Active Directory, Identity, and Access
• Active Directory Components and Concepts
• Install Active Directory Domain Services;
• Extensão de IDA com Serviços do Active Directory.
2- Administering Active Directory Securely and Efficiently
This module explains how to work securely and efficiently in Active Directory using Administration Tools and some best practices as well
as use of Windows PowerShell.
• Work with Active Directory Administration Tools
• Custom Consoles and Least Privilege
• Find Objects in Active Directory
• Use Windows PowerShell to Administer Active Directory
3- Managing Users and Service Accounts
This module explains how to create, manage and support user and Managed Service Accounts in Active Directory.
• Create and Administer User Accounts
• Configure User Object Attributes
• Automate User Account Creation
• Create and Configure Managed Service Accounts
4- Managing Groups
This module explains how to create, modify, delete, and support group objects in Active Directory.
• Overview of Groups
• Administer Groups
• Best Practices for Group Management
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
5- Managing Computer Accounts
This module explains how to create and configure computer accounts.
• Create Computers and Join the Domain
• Administer Computer Objects and Accounts
• Perform an Offline Domain Join
6- Implementing a Group Policy Infrastructure
This module explains what Group Policy is, how it works, and how best to implement Group Policy in your organization.
• Understand Group Policy
• Implement GPOs
• Manage Group Policy Scope
• Group Policy Processing
• Troubleshoot Policy Application
7- Managing User Desktop with Group Policy
This module explains how to manage and configure desktop environments using Administrative templates and Group Policy Preferences
as well as how to deploy software using Group Policy
• Implement Administrative Templates
• Configure Group Policy Preferences
• Manage Software with GPSI
8- Managing Enterprise Security and Configuration with Group Policy Settings
This module explains how to use Group Policy to manage a variety of components and features of Windows. It will also explain how to
audit files and folders and how to restrict access to applications using application control policies.
• Manage Group Membership by Using Group Policy Settings
• Manage Security Settings
• Auditing
• Software Restriction Policy and Applocker
9- Securing Administration
This module explains how to administer Active Directory Domain Services Securely.
• Delegate Administrative Permissions
• Audit Active Directory Administration
• Configuração de controladores de domínio somente leitura.
10- Improving the Security of Authentication in an AD DS Domain
This module explains the domain-side components of authentication, including the policies that specify password requirements and the
auditing of authentication-related activities
• Configure Password and Lockout Policies
• Audit Authentication
• Configure Read-Only Domain Controllers
• Configuração e administração avançadas do DNS.
11- Configuring Domain Name System
This module explains how to implement DNS to support name resolution both within your AD DS domain and outside your domain and
your intranet.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Install and Configure DNS in an AD DS Domain
• Integration of AD DS, DNS, and Windows;
• Advanced DNS Configuration and Administration
• Extensão de IDA com Serviços do Active Directory.
12- Administering AD DS Domain Controllers
This module explains how to add Windows Server 2008 domain controllers to a forest or domain, how to prepare a Microsoft Windows
Server 2003 forest or domain for its first Windows Server 2008 DC, how to manage the roles performed by DCs, and how to migrate the
replication of SYSVOL from the File Replication Service (FRS) used in previous versions of Windows to the Distributed File System
Replication (DFS-R) mechanism that provides more robust and manageable replication.
• Domain Controller Installation Options
• Install a Server Core Domain Controller
• Manage Operations Masters
• Configure Global Catalog
• Configure DFS-R Replication of SYSVOL
13- Managing Sites and Active Directory Replication
This module explains how to create a distributed directory service that supports domain controllers in portions of your network that are
separated by expensive, slow, or unreliable links and how to configure replication amongst those servers.
• Configure Sites and Subnets
• Configure Replication
• Fazer backup e restaurar o AD DS e os controladores de domínio.
14- Directory Service Continuity
This module explains about the technologies and tools that are available to help ensure the health and longevity of the directory service.
You will explore tools that help you monitor performance in real time, and you will learn to log performance over time so that you can
keep an eye on performance trends in order to spot potential problems.
• Monitor Active Directory
• Manage the Active Directory Database
• Active Directory Recycle Bin
• Back Up and Restore AD DS and Domain Controllers
15- Managing Multiple Domains and Forests
This module explains how to raise the domain and forest functionality levels within your environment, how to design the optimal AD DS
infrastructure for your enterprise, how to migrate objects between domains and forests, and how to enable authentication and resources
access across multiple domains and forests.
• Configure Domain and Forest Functional Levels
• Manage Multiple Domains and Trust Relationships
• Move Objects between Domains and Forests
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6426 - Configuring and Troubleshooting Identity and Access Solutions with Windows
Server 2008 Active Directory
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Carga Horária: 3 dias / 5 noites
About this course: This three-day instructor-led course provides in-depth training on configuring and troubleshooting
Active Directory Identity and Access (IDA) solutions with Windows Server 2008 and Windows Server 2008 R2.
Audience Profile: This course is intended for those who want to learn how IDA solutions are implemented in Windows
Server 2008 and Windows Server 2008 R2. It is also intended for those preparing for MCTS: Windows Server 2008 Active
Directory certification. This course provides a technology overview of IDA and PKI solutions, and details the implementation
of each of the roles in Windows Server 2008 and Windows Server 2008 R2 that implement the IDA solution.
At Course Completion:
After completing this course, students will be able to:
• Describe the fundamental IDA components and Windows Server 2008 and Windows Server 2008 R2 IDA technologies.
• Deploy, configure, and troubleshoot Active Directory Certificate Services (AD CS).
• Deploy, configure, and manage certificates.
• Deploy, configure, and troubleshoot Active Directory Lightweight Directory Services (AD LDS).
• Deploy, configure, and troubleshoot Active Directory Federation Services 2.0 (AD FS 2.0).
• Deploy, configure, and troubleshoot Active Directory Rights Management Services (AD RMS).
• Maintain Windows Server 2008 and Windows Server 2008 R2 Active Directory IDA Solutions.
Prerequisites:
Before attending this course, students must have:
• Technical skills in Active Directory Domain Services (AD DS). This includes technical skills equivalent to 6425C: Configuring
Windows Server 2008 Active Directory Domain Services
• Technical skills in Windows Server 2008 equivalent to 6419B: Configuring, Managing and Maintaining Windows Server
2008 Servers
Course Outline:
1- Exploring Identity and Access Solutions
This module introduces Identity and Access Management (IDA Management) solutions. You will learn the fundamental IDA
components and Windows Server 2008 and Windows Server 2008 R2 IDA technologies. This module also provides an
overview of Microsoft Forefront technologies that further enhance IDA solutions.
• Overview of Identity and Access Techniques
• Active Directory Identity and Access Solutions Server Roles
• Additional Identity and Access Management Tools and Solutions
2- Deploying and Configuring Active Directory Certificate Services
This module explains the concepts of public key infrastructure (PKI) and certification authority (CA). You will learn how to
deploy a CA hierarchy and install AD CS. This module also describes how to configure AD CS and how to resolve common AD
CS issues.
• Overview of Public Key Infrastructure
• Overview of Certification Authorities
• Deploying Certification Authorities
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Configuring Certification Authorities
• Troubleshooting Active Directory Certificate Services
3- Deploying and Configuring Certificates
This module describes the deployment of certificates by using AD CS. In addition, the module elaborates on managing
enrollment to deploy certificates, certificate revocation, and configuration of certificate template and certificate recovery
• Managing Certificate Templates
• Deploying Certificates and Managing Enrollment
• Managing Certificate Revocation
• Configuring Certificate Recovery
• Configuração da recuperação de certificado
4- Deploying and Configuring Active Directory Lightweight Directory Services
This module explains the concept of AD LDS. You will learn how to install AD LDS, configure AD LDS instances and partitions,
and configure AD LDS replication. This module also describes how to resolve common AD LDS issues.
• Overview of Active Directory Lightweight Directory Services
• Deploying and Configuring Active Directory Lightweight Directory Services
• Configuring AD LDS Instances and Partitions
• Configuring Active Directory Lightweight Directory Services Replication
• Troubleshooting Active Directory Lightweight Directory Services
5- Deploying and Configuring Active Directory Federation Services
This module presents the concept of AD FS 2.0 and its deployment scenarios. You will learn how to deploy AD FS 2.0 and
implement AD FS claims. This module also describes how to resolve common AD FS issues.
• Overview of Active Directory Federation Services 2.0
• Deploying Active Directory Federation Services
• Configuring Active Directory Federation Services Partner Organizations and Claims
• Troubleshooting Active Directory Federation Services
6- Deploying and Configuring Active Directory Rights Management Services
This module explains the concept of AD RMS. You will learn how to install and configure AD RMS server components,
administer AD RMS rights policy templates, and implement AD RMS trust policies. This module also describes how to
resolve common AD RMS issues.
• Overview of Active Directory Rights Management Services
• Deploying and Configuring Active Directory Rights Management Services
• Configuring AD RMS Rights Policy Templates and Exclusion Policies
• Configuring Active Directory Rights Management Services Trust Policies
• Troubleshooting Active Directory Rights Management Services
7- Maintaining Windows Server 2008 Active Directory Identity and Access Solutions
This module explains the maintenance of AD CS, AD LDS, AD FS 2.0, and AD RMS.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Maintaining Active Directory Certificate Services
• Maintaining Active Directory Lightweight Directory Services
• Maintaining Active Directory Federation Services
• Maintaining Active Directory Rights Management Services
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6433 - Planning and Implementing Windows Server 2008
Carga Horária: 5 dias / 10 noites
About this Course
This five day course is intended for IT Professionals who are interested in the knowledge and skills necessary to plan and
implement a Windows Server 2008 and Windows Server 2008 R2 environment. It incorporates both the planning of the
server infrastructure and key aspects of the implementation, management and maintenance of Active Directory and
Network Infrastructure. It is the primary training resource for Exam 70-646 preparation (MCITP: Server Administrator
certification). It covers the most important job tasks for Server Administrators who are responsible for the planning,
operations, and day-to-day maintenance of Windows Server 2008 and Windows Server 2008 R2 servers in the enterprise.
The course covers Windows server 2008, Windows Server 2008 R2 and Windows Server 2008 R2 sp1..
Audience Profile
This course is intended for experienced IT Professionals looking to gain deeper insight and decision making knowledge for a
variety of planning and implementation tasks typically carried out by Server Administrators. Also, this course is relevant for
you if you have been working as a Server Administrator on a previous version of Windows Server and want to update your
skills to the Windows Server 2008 and Windows Server 2008 R2 Sp1 environment.
The course is intended to build on the student's existing skills in the areas of Active Directory and Network Infrastructure
for Windows Server 2008, therefore it is not suitable for new or inexperienced server administrators.
Before attending this course, students must possess the following skillset and knowledge:
•At least one year experience in implementing or contributing to server and client planning
•At least one year experience carrying out day to day network Infrastructure and Active Directory management and
maintenance tasks
•Technology skills equivalent to moc course 6418C: Deploying Windows Server 2008
Also, the following prerequisite certifications would support your preparation for attending this course and the taking of
the subsequent related exam (70-646):
•MCTS: Windows Server 2008 Active Directory Configuration
◦Equivalent course(s): 6425C and 6426C
•MCTS: Windows Server 2008 Network Infrastructure Configuration
◦Equivalent course(s): 6421B
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
At Course Completion
After completing this course, students will be able to:
• Plan Windows Server 2008 and Windows Server 2008 R2 Sp1 deployments and upgrades
• Plan server management and delegated administration strategies
• Plan for network addressing with IPv4 and IPv6 and also the provisioning of DNS services
• Plan and provision Active Directory Domain Services
• Plan and implement Group Policy strategy
• Plan and implement Active Directory Certificate Services?
• Plan and provision Application servers including Web services, presentation virtualization and application virtualization
• Plan and implement file and print server roles
• Plan and implement secure network access policies such as VPNs, Network Access Protection (NAP) and Direct Access
• Plan and provision data and storage
• Plan and implement an update management strategy using Windows Server Update Services (WSUS)
• Plan and implement high availability
• Plan for server performance and event monitoring
• Plan and implement a backup and recovery strategy
Course Outline:
1- Planning Server Deployment and Upgrade
This module explains how to plan Windows Server 2008 and Windows Server 2008 R2 deployments and upgrades.
• Developing a Deployment Strategy
• Virtualization Considerations
• Selecting an Automation Strategy
• Implementing an Automation Strategy
-Lab : Planning and Implementing Server Deployment
• Planning a Windows Server 2008 R2 Deployment
• Modifying a Windows Server 2008 R2 Image
• Preparing to Deploy the Windows Server 2008 R2 Image
After completing this module, students will be able to:
• Develop a deployment strategy.
• Determine factors that affect the implementation of virtualization within your organization.
• Select a strategy for deployment automation.
• Implement the selected automation strategy.
2- Planning Server Management and Delegated Administration
This module explains how to plan for server management and delegated administration on Windows Server 2008 and
Windows Server 2008 R2 environments
• Server Management Tools
• Decentralizing Systems Administration
-Lab : Implementing Role Based Systems Administration
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Create an administrative-level role group
• Creating an account management group
• Enable and configure auditing for sensitive groups
After completing this module, students will be able to:
• Plan for the implementation and use of Windows Server 2008 and Windows Server 2007 R2 remote management tools.
• Plan and Implement decentralized systems administration.
3- Planning Network Addressing and Name Resolution
This module explains how to plan for IPv4 and IPv6 addressing in your network and to plan and implement DNS and DHCP
in a Windows Server 2008 and Windows Server 2008 R2 environment
• Provisioning IPv4 Addresses on Enterprise Networks
• Provisioning IPv6 Addresses on Enterprise Networks
• Transitioning to IPv6
• Provisioning DNS Services on Enterprise Networks
Lab : Planning and Implementing DHCP and DNS
• Planning the Deployment of DHCP and DNS Servers
• Implementing DNS
• Implementing DHCP
After completing this module, students will be able to:
• Provision an IPv4 addressing scheme within your organization.
• Provision an IPv6 addressing scheme within your organization.
• Plan the transition to IPv6.
• Plan and implement DNS name resolution services within your organization’s network.
4- Planning and Provisioning Active Directory Domain Services
This module explains how to plan and provision Active Directory Domain Services in Windows Server 2008 and Windows
Server 2008 R2 environments.
• Deploying Domain Controllers in Multi-Site Organizations
• Planning Administrative and Management Structures for AD DS
• Planning a Maintenance Strategy for AD DS
• Planning a Backup and Restore Strategy for AD DS
-Lab : Planning and Provisioning AD DS
• Planning an Active Directory Structure
• Planning an AD DS Maintenance Strategy
• AD DS Backup and Recovery
After completing this module, students will be able to:
• Identify considerations for deploying domain controllers in multi-site organizations.
• Plan administrative and management structures for AD DS
• Plan a maintenance strategy for AD DS
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Plan a backup and recovery strategy for AD DS.
5- Planning Group Policy Strategy
This module explains how to plan and implement Group Policy strategy n Windows Server 2008 and Windows Server 2008
R2 environments
• Planning Group Policy Settings
• Planning Group Policy Assignment
• Planning the Management of Group Policy Objects
-Lab : Planning and Implementing Group Policy
• Planning Group Policy
• Implementing the Proposed GPO Plan
After completing this module, students will be able to:
• Plan GPO settings.
• Plan the assignment of group policy objects to AD DS containers.
• Plan how to manage GPOs within your organization.
6- Planning Active Directory Certificate Services
This module explains how to plan Active Directory Certificate Services in Windows Server 2008 and Window Server 2008 R2
environments.
• Enterprise PKI Deployment and Administration
• Managing Certificate Templates
• Planning Certificate Enrollment and Revocation
-Lab : Configuring Certificate Services
• Certificate Services Deployment Planning
• Standalone Root and Subordinate CA
• Configure Key Archiving and Recovery
After completing this module, students will be able to:
• Describe which roles and configurations require the deployment of Active Directory Certificate Services as part of a
network’s infrastructure services.
• Know when to deploy an enterprise or standalone Certification Authority
• Determine when to deploy an offline root Certification Authority
• Understand when to deploy a subordinate or issuing Certification Authority
• Plan the deployment of key archiving and recovery
• Develop an appropriate Certification Authority management strategy
7- Planning and Provisioning Application Servers
This module explains how to plan and provision application servers in Windows Server 2008 and Windows Server 2008 R2
environments.
• Planning and Provisioning Web Services
• Planning and Provisioning Presentation Virtualization
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Planning and Provisioning Application Virtualization
-Lab : Planning and Provisioning Application Servers
• Planning Application Deployment
• Configuring Remote Desktop Policies
• Configuring Recovery for Application Servers
• Configuring WSRM Policies
After completing this module, students will be able to:
• Plan and provision web application servers.
• Plan and provision remote desktop services application servers.
• Plan and provision application virtualization servers.
8- Planning File and Print Services
This module explains how to plan and implement File and Print services in your Windows Server 2008 and Windows Server
2008 R2 environment.
• Provisioning File Services
• Provisioning and Managing Storage
•Provisioning and Managing Network Print Services
• Migrating File and Print Services
-Lab : Planning and Implementing File and Print Services
• Planning File Services
• Implementing File Services in the Branch Office
• Implementing Print Services in the Branch Office
After completing this module, students will be able to:
• Plan and implement the file service role.
• Plan and manage storage.
• Plan and manage shared printers.
• Plan the migration of file and print services to Windows Server 2008 R2
9- Planning Network Access
This module explains how to plan and implement your network infrastructure components in your Windows Server 2008
and Windows server 2008 R2 environment.
• Planning Network Security
• Planning Virtual Private Networks
• Planning Network Access Protection
• Planning DirectAccess
-Lab : Planning and Implementing Network Access
• Planning Network Access
• Implementing Network Access
After completing this module, students will be able to:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Plan network infrastructure components to improve network security
• Plan and implement VPNs
• Plan and implement NAP
• Plan DirectAccess
10- Provisioning Data and Storage
This module explains how to provision data and storage in your Windows Server 2008 and Windows server 2008 R2
environment.
• Planning and Implementing Distributed File System
• Planning and Implementing BranchCache
• Provisioning Storage
-Lab : Planning and Implementing Data Access
• Planning Data Access
• Installing and Configuring DFS
• Enabling and Configuring BranchCache
After completing this module, students will be able to:
• Plan and implement the Distributed File System.
• Plan and implement BranchCache.
• Provision an appropriate storage solution.
11- Planning Update Deployment
This module explains how to plan and implement a Windows Server Update Service topology and how to deploy and
manage updates in your Windows Server 2008 and Windows Server 2008 R2 environment.
• WSUS Topologies
• Update Management
-Lab : Multi-Site WSUS Deployment
• Analyze WSUS Deployment Plan
• Configure a Replica WSUS Server
• Configure WSUS for BranchCache and BITS
After completing this module, students will be able to:
• Plan an appropriate Windows Server Update Services (WSUS) topology
• Deploy and manage updates
12- Planning High Availability
This module explains how to plan and implement High Availability in your Windows Server 2008 and Windows Server 2008
R2 environment.
• Planning Network Load Balancing
• Planning Failover Clustering
• Planning for Service Availability
-Lab : Planning and Implementing High Availability
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Planning High Availability
• Implementing High Availability
After completing this module, students will be able to:
• Plan and deploy network load balancing.
• Plan and deploy failover clustering.
• Plan for high service availability.
13- Planning Performance and Event Monitoring
This module explains how to plan for performance and event monitoring in your Windows Server 2008 and Windows Server
2008 R2 environment.
• Monitoring and Analyzing Server Performance
• Managing Events
-Lab : Event Log Forwarding
• Planning Enterprise Event Log Management
• Configuring Event Subscriptions
• Creating Custom Views
• Creating Event Tasks
After completing this module, students will be able to:
• Monitor and analyze server performance.
• Manage events.
14- Enterprise Backup and Recovery
This module explains how to plan for back ups and disaster recovery in your Windows Server 2008 and Windows Server
2008 R2 environment
• Disaster Recovery Concepts
• Planning Windows Server Backup
• Planning and Administering Recovery
-Lab : Backup and restore from VHD
• Creating a Disaster Recovery Plan
• Configure network backup with Windows Server Backup
• Mount Backup VHD and Extract Data
• Configure a Windows Server 2008 server to boot from backup VHD
After completing this module, students will be able to:
• Understand Disaster Recovery Concepts
• Plan Windows Server Backup
• Plan recovery of data and servers
Exame
70-646, Pro: Windows Server 2008, Server Administrator
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
2778 - Writing Queries Using Microsoft SQL Server 2008 Transact-SQL
Carga Horária: 3 dias / 5 noites
Introduction: This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for
Microsoft SQL Server 2008.
After completing this course, students will be able to:
• Describe the uses of and ways to execute the Transact-SQL language;
• Use querying tool;
• Write SELECT queries to retrieve data;
• Group and summarize data by using Transact-SQL;
• Join data from multiple tables;
• Write queries that retrieve and modify data by using subqueries;
• Modify data in tables;
• Query text fields with full-text search;
• Describe how to create programming objects;
• Use various techniques when working with complex queries.
Audience: This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are
responsible for writing queries.
Prerequisites:
Before attending this course, students must have:
• Knowledge of data integrity concepts.
• Core Windows Server skills.
• Relational database design skills.
• Programming skills.
Course Outline:
1 - Getting Started with Databases and Transact-SQL in SQL Server 2008
The student will be introduced to how client/server architecture works, and examine the various database and business tasks that can be
performed by using the components of SQL Server 2008. The student will also be introduced to SQL Server database concepts such as
relational databases, normalization, and database objects. In addition, the student will learn how to use T-SQL to query databases and
generate reports.
• Overview of SQL Server 2008
• Ov erview of SQL Server Databases
• Overview and Syntax Elements of T-SQL
• Working with T-SQL Scripts
• Using T-SQL Querying Tools
- Lab : 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;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this module, students will be able to:
• 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
The students will be introduced to the basic Transact-SQL (T-SQL) statements that are used for writing queries, filtering data, and
formatting result sets.
• Using the SELECT Statement
• Filtering Data
• Working with NULL Values
• Formatting Result Sets
• Performance Con siderations for Writing Queries
- Lab : 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.
After completing this module, students will be able to:
• 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
The students will learn to group and summarize data when generating reports in Microsoft SQL Server 2008 by using aggregate functions
and the COMPUTE clause.
• Summarizing Data by Using Aggregate Functions
• Summarizing Grouped Data
• Ranking Grouped Data
• Creating Crosstab Queries
- Lab : Grouping and Summarizing Data
• Summarizing Data by Using Aggregate Functions;
• Summarizing Grouped Data;
• Ranking Grouped Data;
• Creating Crosstab Queries.
After completing this module, students will be able to:
• 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.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
4 - Joining Data from Multiple
Tables The students will learn to write joins to query multiple tables, as well as limiting and combining result sets.
• Querying Multiple Tables by Using Joins
• Applying Joins for Typical Reporting Needs
• Combining and Limiting Result Set
- Lab : Joining Data from Multiple Tables
• Querying Multiple Tables by Using Joins;
• Applying Joins for Typical Reporting Needs;
• Combining and Limiting Result Sets.
After completing this module, students will be able to:
• Query multiple tables by using joins;
• Apply joins for typical reporting needs;
• Combine and limit result sets.
5 - Working with Subqueries
The students will be introduced to basic and correlated subqueries and how these compare with joins and temporary tables. The
students will also be introduced to using common table expressions in queries.
• Writing Basic Subqueries
• Writing Correlated Subqueries
• Comparing Subqueries with Joins and Temporary Tables
• Using Common Table Expressions
- Lab : Working with Subqueries
• Writing Basic Subqueries;
• Writing Correlated Subqueries;
• Comparing Subqueries with Joins and Temporary Tables;
• Using Common Table Expressions .
After completing this module, students will be able to:
• Write basic subqueries;
• Write correlated subqueries;
• Compare subqueries with joins and temporary tables;
• Use common table expressions in queries.
6 - Modifying Data in Tables
The students will be able to modify the data in tables by using the INSERT, DELETE, and UPDATE statements. In addition, students will
examine how transactions work in a database, the importance of transaction isolation levels, and how to manage transactions.
• Inserting Data into Tables
• Deleting Data from Tables
• Updating Data in Tables
• Overview of Transactions
-Lab : Modifying Data in Tables
• Inserting Data into Tables;
• Deleting Data from Tables;
• Updating Data in Tables;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Working with Transactions.
After completing this module, students will be able to:
• Insert data into tables;
• Delete data from tables;
• Update data in tables;
• Describe transactions.
7 - Querying Metadata, XML, and Full-Text Indexes
The students will learn to query semi-structured and unstructured data. The students will also learn how SQL Server 2008 handles XML
data and will query XML data. The students will also be introduced to full-text indexing in SQL Server 2008.
• Querying Metadata
• Overview of XML
• Querying XML Data
• Overview of Full-Text Indexes
• Querying Full-Text Indexes
- Lab : Querying Metadata, XML, and Full-Text Indexes
• Querying Metadata;
• Querying XML Data;
• Creating and Querying Full-Text Indexes.
After completing this module, students will be able to:
• 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
The students will be introduced to user-defined functions and executing various kinds of queries by using user-defined functions. The
students will be introduced to SQL Server views that encapsulate data and present users with limited and relevant information. In
addition, the students will be introduced to SQL Server stored procedures and the functionalities of the various programming objects.
The students will learn how to perform distributed queries and how SQL Server works with heterogeneous data such as databases,
spreadsheets, and other servers.
• Overview of Views
• Overview of User-Defined Functions
• Overview of Stored Procedures
• Overview of Triggers
• Writing Distributed Queries
- Lab : Using Programming Objects for Data Retrieval
• Creating Views;
• Creating User-Defined Functions;
• Creating Stored Procedures;
• Writing Distributed Queries.
After completing this module, students will be able to:
• Encapsulate queries by using views;
• Encapsulate expressions by using user-defined functions;
• Explain how stored procedures encapsulate T-SQL logic;
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Define triggers, types of triggers, create a trigger;
• Write distributed queries.
9 - Using Advanced Querying Techniques
The students will be introduced to best practices for querying complex data. The students will also examine how to query complex table
structures such as data stored in hierarchies and self-referencing tables. The students will analyze the recommended guidelines for
executing queries and how to optimize query performance.
• Considerations for Querying Data
• Working with Data Types
• Cursors and Set-Based Queries
• Dynamic SQL
• Maintaining Query Files
- Lab : Using Advanced Querying Techniques
• Using Execution Plans;
• Converting Data Types;
• Implementing a Hierarchy;
• Using Cursors and Set-Based Queries.
After completing this module, students will be able to:
• 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.
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6231/10142 - Manutenção de um banco de dados do Microsoft SQL Server 2008
Carga Horária: 5 dias / 10 noites
Introdução: Este curso de cinco dias, ministrado por um instrutor, fornece aos alunos o conhecimento e a técnica necessários para
manter um banco de dados do Microsoft SQL Server 2008. O objetivo do curso é ensinar os alunos a usarem as ferramentas e os recursos
do SQL Server 2008 relacionados à manutenção de um banco de dados.
Público-Alvo: Este curso é dirigido aos profissionais de TI que administram e mantêm bancos de dados do SQL Server.
Depois de concluir este curso, os alunos serão capazes de:
 Instalar e configurar o SQL Server 2008
 Gerenciar arquivos de banco de dados.
 Fazer backup e restaurar bancos de dados.
 Gerenciar a segurança.
 Transferir dados para/do SQL Server.
 Automatizar tarefas administrativas.
 Replicar dados entre instâncias do SQL Server.
 Manter a alta disponibilidade.
 Monitorar o SQL Server.
Pré-Requisitos:
Antes de participar deste curso, os alunos devem ter:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
 Conhecimento básico do sistema operacional Microsoft Windows e de sua funcionalidade principal.
 Conhecimento prático de Transact-SQL.
 Conhecimento prático de bancos de dados relacionais.
 Alguma experiência com design de banco de dados.
Conteúdo Programático:
1 - Instalação e configuração do SQL Server
Os alunos aprenderão a planejar uma instalação do SQL Server. Em seguida, os alunos verão como instalar, configurar e gerenciar o SQL
Server.
• Preparação para instalar o SQL Server
• Instalação do SQL Server
• Configuração de uma instalação do SQL Server
2 - Gerenciamento de bancos de dados e arquivos
Os alunos aprenderão a planejar e criar um banco de dados, além de usar opções de banco de dados para controlar o comportamento de
um banco de dados.
• Planejamento de bancos de dados
• Criação de bancos de dados
• Uso do Gerenciamento Baseado em Diretiva
3 - Recuperação de desastres
Os alunos serão apresentados às técnicas de recuperação de desastres do SQL Server. Os alunos aprenderão a executar diferentes tipos
de operações de backup e restauração, inclusive restaurações e backups online, além de restaurações de bancos de dados do sistema.
• Planejamento de uma estratégia de backup
• Backup de bancos de dados de usuários
• Restauração de bancos de dados de usuários
• Execução de operações de restauração online
• Recuperação de dados de instantâneos do banco de dados
• Bancos de dados do sistema e recuperação de desastres
4 - Gerenciamento de segurança
Os alunos aprenderão a proteger o SQL Server. Eles conhecerão o modelo de segurança do SQL Server e verão como usar os recursos de
segurança do produto para controlar o acesso a bancos de dados e a seu conteúdo.
• Visão geral da segurança do SQL Server
• Proteção do escopo do servidor
• Proteção do escopo do banco de dados
• Proteção do escopo do servidor
• Auditoria da segurança
5 - Transferência de dados
Os alunos verão como transferir dados para/do SQL Server usando a interface do usuário e ferramentas de linha de comando, bem como
aprenderão a transferir e transformar dados com o SQL Server Integration Services.
• Visão geral da da transferência de dados
• Introdução ao SQL Server Integration Services
6 - Automatização de tarefas administrativas
Os alunos aprenderão a automatizar tarefas administrativas de rotina usando trabalhos, operadores e alertas.
• Automatização de tarefas administrativas no SQL Server
• Uso do SQL Server Agent
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Criação de planos de manutenção
• Implementação de alertas
• Gerenciamento de vários servidores
• Gerenciamento da segurança do SQL Server Agent
7 - Implementação da replicação
Os alunos serão apresentados às técnicas para configurar a replicação do SQL Server.
• Visão geral da replicação
• Gerenciamento de publicações e assinaturas
• Configuração da replicação em alguns cenários comuns
8 - Manutenção da alta disponibilidade
Os alunos serão apresentados a conceitos e métodos para manter a alta disponibilidade com o SQL Server.
• Introdução à alta disponibilidade
• Implementação do envio de logs
• Implementação do espelhamento de banco de dados
• Implementação do clustering de servidores
• Uso de soluções distribuídas de alta disponibilidade
9 - Monitoramento do SQL Server
Os alunos verão como monitorar o desempenho e a atividade do SQL Server.
• Exibição da atividade atual
• Uso do SQL Server Profiler
• Monitoramento com gatilhos DDL
• Uso das notificações de eventos
10 - Solução de problemas e ajuste de desempenho
Os alunos aprenderão a solucionar diversos problemas comuns do SQL Server, também aprenderão a ajustar o SQL Server para obter
melhor desempenho com o uso de diversas ferramentas.
• Solução de problemas do SQL Server
• Ajuste de desempenho no SQL Server
• Uso do Administrador de Recursos
• Uso do Coletor de Dados
Exame
TS: 70-432: TS: Microsoft SQL Server 2008 Implementação e Manutenção
(disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
6232/10169 - Implementação de um banco de dados do Microsoft SQL Server 2008
Carga Horária: 5 dias / 10 noites
Introdução: Este curso de cinco dias, ministrado por um instrutor, fornece aos alunos o conhecimento e a técnica necessários para
implementar um banco de dados do Microsoft SQL Server 2008 R2 . O objetivo do curso é ensinar os alunos a usar as ferramentas e os
recursos do SQL Server 2008 relacionados à implementação de um banco de dados.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Público-Alvo: Este curso destina-se a profissionais de TI que querem se tornar hábeis em SQL Server 2008 R2 e de produtos e tecnologias
para a implementação e administração de um banco de dados.
Depois de concluir este curso, os alunos serão capazes de:
Após a conclusão deste curso, os alunos serão capazes de:
• Entender o produto, seus componentes e configuração básica.
• Trabalhar com os tipos de dados suportados pelo SQL Server.
• Design e tabelas, implementar e trabalhar com esquemas.
• Desenhar e implementar pontos de vista e modos de exibição particionados.
• Descrever o conceito de um índice e determinar o tipo de dados apropriado para os índices e as estruturas de índice composto
• Identificar as estruturas de tabelas adequadas e implementar índices clusterizados e heaps.
• Descrever e captura de planos de execução.
• Desenhar e implementar índices não-agrupados, cobrindo índices e colunas incluídas.
• Desenhar e implementar procedimentos armazenados.
• Implementar os tipos de tabela, os parâmetros com valor de tabela, e da instrução MERGE.
• Descrever as operações, os níveis de isolamento da transação, e padrões de projeto para aplicação altamente concorrente aplicações.
• Desenhar e implementar T-SQL tratamento de erros e manipulação de exceção estruturada.
• Desenhar e implementar escalar e funções com valor de tabela.
• Desenhar e implementar restrições.
• Desenhar e implementar triggers.
• Descrever e implementar os casos de uso de SQL alvo de integração CLR.
• Descrever e implementar dados XML e o esquema no SQL Server.
• Use consultas FOR XML e XPath.
• Descrever e usar tipos de dados espaciais no SQL Server.
• Implementar e consultar índices de texto completo.
Pré-requisitos:
• Conhecimento prático de Transact-SQL (capacidade de escrever consultas Transact-SQL) ou Curso: Escrever consultas Usando o
Microsoft SQL Server 2008 Transact-SQL
• Conhecimento de bancos de dados relacionais (habilidades de design de banco de dados)
• Habilidades Server Core do Windows
• Linguagem de programação Basic.
Conteúdo Programático:
1- Introdução ao SQL Server e suas Toolset
Este módulo apresenta toda a plataforma SQL Server e suas ferramentas principais. Também inclui edições, versões básicas dos ouvintes
de rede, e conceitos de serviços e contas de serviço.
• Introdução ao SQL Server Platform
• Trabalhar com ferramentas do SQL Server
• Configurando o SQL Server Serviços
- Lab: Introdução ao SQL Server e suas Toolset
• Verificação da instalação do SQL Server Component
• A alteração de contas de serviço para nova instância
• Habilitar protocolo de pipes nomeados para as duas instâncias
• Criação de Alias para AdventureWorks e Proseware
• Garantir SQL Browser é condicionada e configurar uma porta TCP / IP fixo
Depois de concluírem este módulo, os alunos serão capazes de:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Descrever a plataforma SQL Server.
• Trabalhar com ferramentas do SQL Server.
• Configurar os serviços do SQL Server.
2- Trabalhando com tipos de dados
Este módulo descreve os tipos de dados suportados pelo SQL Server e como trabalhar com eles.
• Usando tipos de dados
• Trabalhando com dados caracteres
• Convertendo tipos de dados
• Trabalhando com tipos de dados especializados
- Laboratório: Trabalhando com Tipos de Dados
• A escolha de tipos de dados apropriados
• Escrever consultas com as conversões de tipo de dados
• Criar tipos de dados Alias
Depois de concluírem este módulo, os alunos serão capazes de:
• Trabalhar com tipos de dados.
• Trabalhar com dados de caracteres.
• Converter entre tipos de dados.
• Usar tipos de dados especializados.
3- Criando e Implementando tabelas
Este módulo descreve a concepção e implementação de tabelas.
• Criando tabelas
• Trabalhar com esquemas
• Criando e alterando Tabelas
- Lab: Criando e Implementando tabelas
• Melhorar o design de tabelas
• Criação de um Schema
• Criar as tabelas
Depois de concluírem este módulo, os alunos serão capazes de:
• Criar tabelas.
• Trabalhar com esquemas
4- Criando e implementando Views
Este módulo descreve o projeto e a implementação de pontos de vista.
• Introdução às exibições
• Criação e gerenciamento de Visitas
• Considerações sobre Desempenho para Views
- Lab: Criando e implementando Views
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• A concepção, implementação e teste de Visualizações WebStock
• Criando e implementando a Vista Contatos
• Modificando o Ver AvailableModels
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar o papel de pontos de vista no desenvolvimento de banco de dados.
• Implementar pontos de vista.
• Descrever os impactos relacionados com o desempenho de pontos de vista.
5 - Planejamento para SQL Servidor de Indexação
Este módulo descreve o conceito de um índice e discute seletividade, densidade e estatísticas. Abrange escolhas tipo de dados
apropriado e escolhas em torno de estruturas, índice composto.
• Conceitos básicos de indexação
• Tipos de dados e índices
• Coluna Única e índices Composite
-Lab: Planejamento para SQL Servidor de Indexação
• Explorando Estatísticas índice existente
• Projetando Ordens Coluna para índices
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar os conceitos de indexação do núcleo.
• Descrever a eficácia de cada tipo de dados comuns utilizadas em índices.
• Plano de coluna única e índices compostos.
6- Estruturas de Implementação, Tabela no SQL Server
Este módulo abrange índices clusterizados e heaps.
• SQL Server Estruturas Tabela
• Trabalhando com índices Clustered
• Projetando eficaz índices de cluster
- Lab: Implementando Estruturas, tabela no SQL Server
• Criação de Tabelas como Heaps
• Criação de tabelas com índices Clustered
• Comparando o desempenho de índices de cluster vs Heaps
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar como as tabelas podem ser estruturadas em bases de dados SQL Server
• Trabalhar com índices de cluster
• Design eficaz, índices cluster
7- Leitura de execução de servidor SQL Planos
Este módulo introduz o conceito de leitura planos de execução.
• Execução Núcleo Conceitos Plano
• Elementos Plano Comum de Execução
• Trabalhando com planos de execução
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
- Laboratório: Execução do Servidor SQL Planos de Leitura
• Planos real vs estimado
• Identificar Elementos de Plano Comum
• Comparação de custo da consulta
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar os principais conceitos relacionados ao uso de planos de execução.
• Descrever o papel dos elementos mais comuns plano de execução.
• Trabalhar com planos de execução.
8- Melhorar o desempenho através de índices não clusterizados
Este módulo explica índices não clusterizados, índices de cobertura e colunas incluídas.
• Projetando eficaz índices não clusterizados
• Implementando índices não clusterizados
• Usar o Database Engine Tuning Advisor
- Laboratório: Melhorar o desempenho através de índices não clusterizados
• Analisar a utilização do índice não-clusterizado
• Melhorar Designs índice não-clusterizado
• Usando o SQL Server Profiler e Database Engine Tuning Advisor
• Design de índice não clusterizado
Depois de concluírem este módulo, os alunos serão capazes de:
• Design eficaz índices não clusterizados.
• Implementar índices não clusterizados.
• Usar o Database Engine Tuning Advisor para índices design.
9- Criandoe implementando Stored Procedures
Este módulo descreve o desenho e implementação de procedimentos armazenados.
• Introdução à Stored Procedures
• Trabalhando com Stored Procedures
• Implementar procedimentos armazenados com parâmetros
• Controlar o contexto de execução
- Lab: Criando e implementando Stored Procedures
• Criação de Stored Procedures
• Criar um procedimento armazenado parametrizado
• A alteração do contexto de execução de procedimentos armazenados
Depois de concluírem este módulo, os alunos serão capazes de:
• Descrever o papel dos procedimentos armazenados e os potenciais benefícios de usá-los.
• Trabalhar com procedimentos armazenados.
• Implementar procedimentos armazenados parametrizados.
• Controlar o contexto de execução de um procedimento armazenado.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
10 – Tabelas: Mesclando Dados e Passando
Este módulo abrange os tipos de tabela, os parâmetros com valor de tabela e a instrução MERGE, usado em procedimentos
armazenados.
• Usando a Instrução MERGE
• Implementação de Tipos de Tabela
• Usando tipos de tabela como Parâmetros
-Laboratório: Tabelas Mesclando dados e passando
• Criar um tipo de tabela
• Utilizando um parâmetro do tipo Table
• Usar um tipo de tabela com MERGE
Depois de concluírem este módulo, os alunos serão capazes de:
• Use a instrução MERGE.
• Implementar os tipos de tabela.
• Use tipos TABLE como parâmetros.
11- Criar aplicativos de servidor SQL altamente concorrente
Este módulo abrange as transações, os níveis de isolamento, e projetar para a concorrência.
• Introdução ao Transações
• Introdução à Locks
• Gestão de bloqueio
• Níveis de isolamento de transação
- Lab: Criando Aplicativos do servidor SQL altamente concorrente
• Deadlocks Detectando
• Investigação de Níveis de isolamento da transação
Depois de concluírem este módulo, os alunos serão capazes de:
• Descrever o papel de transações.
• Explicar o papel de bloqueios.
• Gerenciar bloqueio.
• Trabalhar com níveis de isolamento da transação.
12- Manipulando erros em T-SQL Código
Este módulo descreve a manipulação de exceção estruturada e dá exemplos concretos de sua utilização dentro do projeto de
procedimentos armazenados.
• Projetando T-SQL Error Handling
• Implementação de T-SQL Error Handling
• Implementação de Manipulação de Exceção Estruturada
-Laboratório: Tratamento de erros em T-SQL Código
• Substituição de @ @ ERROR Tratamento de erros baseado com Manipulação de Exceção Estruturada
• Adicionando Deadlock lógica de repetição para o procedimento armazenado
Depois de concluírem este módulo, os alunos serão capazes de:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Design de tratamento de erro T-SQL.
• Implementar T-SQL tratamento de erros.
• Implementar o tratamento de exceção estruturada.
13- Projetando e implementando o User-Defined Functions
Este módulo descreve o projeto e a implementação de funções, tanto escalar e com valor de tabela.
• Criando e implementando Funções escalares
• Criando e implementando com valor de tabela Funções
• Considerações sobre de implementação de funções
• Alternativas Para Funções
- Lab: Criando e implementando User-Defined Functions
• Telefone, Formatando números
• Modificando uma função existente
• Resolver um problema de desempenho de funções
Depois de concluírem este módulo, os alunos serão capazes de:
• Desenhar e implementar funções escalares.
• Desenhar e implementar funções com valor de tabela.
• Descrever considerações sobre a implementação de funções.
• Descrever alternativas para as funções.
14- Garantir a integridade dos dados através de restrições
Este módulo descreve o projeto e a implementação de restrições.
• Impondo a integridade de dados
• Implementando a integridade de Domínio
• Implementando a integridade de entidade e referencial
-Laboratório: Garantir a integridade dos dados através de restrições
• Projetando Constraint
• Testar restrições
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar as opções disponíveis para fazer cumprir a integridade dos dados e os níveis em que elas deveriam ser aplicadas.
• Descrever como integridade de domínio pode ser mantida.
• Descrever como entidade e integridade referencial pode ser mantida.
15- Respondendo a manipulação de dados através de Triggers
Este módulo descreve o desenho e implementação de triggers.
• Projetando DML Triggers
• Implementar disparadores DML
• Conceitos Avançados Gatilho
-Laboratório: Respondendo a manipulação de dados através de Triggers
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Criar o gatilho de Auditoria
• Melhorar o gatilho de Auditoria
Depois de concluírem este módulo, os alunos serão capazes de:
• Design DML triggers.
• Implementar triggers DML.
• Explicar conceitos avançados de trigger DML
16- Aplicação do Código gerenciado no SQL Server
Este módulo descreve a implementação de alvo e casos de uso para o SQL integração CLR.
• Introdução ao SQL CLR Integração
• Importando e configurando Assembléias
• Implementação de SQL CLR, Integração
-Laboratório: Aplicação do Código gerenciado no SQL Server
• Avaliar Proposta, CLR Código
• Implementação de uma Assembléia CLR
• Implementação de um agregado CLR definidas pelo usuário e tipo definido pelo usuário
Depois de concluírem este módulo, os alunos serão capazes de:
• Explicar a importância da integração CLR SQL Server.
• Importar e configurar montagens.
• Implementar os objetos que foram criados dentro. NET.
17- Armazenamento de dados XML no SQL Server
Este módulo abrange o tipo de dados XML, coleções de esquema, colunas digitadas e sem tipo e casos de uso apropriado para XML no
SQL Server.
• Introdução aos esquemas XML e XML
• Armazenamento de dados XML e esquemas em SQL Server
• Implementar o tipo de dados XML
-Laboratório: Armazenamento de Dados XML no SQL Server
• Uso adequado de armazenamento de dados XML no SQL Server
• Investigando o armazenamento de dados XML em variáveis
• investigar o uso de coleções de esquema XML
• Investigar a Criação de Banco de Dados Baseado em colunas XML
Depois de concluírem este módulo, os alunos serão capazes de:
• Descrever os XML e XML esquemas.
• Loja de dados XML e XML esquemas associados no SQL Server.
• Implementar o tipo de dados XML no SQL Server
18- Consultando dados XML no SQL Server
Este módulo aborda os conceitos básicos de consultas FOR XML e XPath.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Utilizar o T-SQL PARA Declaração XML
• Introdução ao XQuery
• Shredding XML
-Laboratório: Consultando dados XML no SQL Server
• Aprender a consulta de dados SQL Server como XML
• Escrever um procedimento armazenado retornando XML
• Escrevendo um procedimento armazenado que atualiza usando XML
Depois de concluírem este módulo, os alunos serão capazes de:
• Usar a T-SQL instrução FOR XML.
• Trabalhar com consultas básicas XQuery.
• Shred XML para um formato relacional.
19- Trabalhando com dados SQL Server Spatial
Este módulo descreve os dados espaciais e como estes dados podem ser implementados dentro do SQL Server.
• Introdução aos Dados Espaciais
• Trabalhar com o SQL Server Tipos de Dados Espaciais
• Uso de Dados Espaciais em Aplicações
-Laboratório: Trabalhando com dados SQL Server Spatial
• Familiaridade com tipo de dados Geometry
• Adição de Dados Espaciais para uma tabela existente
• Aplicação de Negócios de Dados Espaciais
Depois de concluírem este módulo, os alunos serão capazes de:
• Descrever a importância dos dados espaciais e os padrões da indústria relacionada a ela.
• Explicar como armazenar dados espaciais no SQL Server.
• Realizar cálculos e consulta de dados espaciais do SQL Server.
20- Trabalhando com índices de texto completo e consultas
Este módulo abrange os índices de texto completo e consultas.
• Introdução ao Full-Text Indexing
• Implementar Full-Text índices no SQL Server
• Trabalhar com consultas de texto completo
Laboratório: Trabalhando com índices de texto completo e consultas
• Implementar um índice de texto completo
• Implementação de uma lista de palavras irrelevantes
• Criando um procedimento armazenado para implementar uma pesquisa de texto completo
Depois de concluírem este módulo, os alunos serão capazes de:
• Descrever por que interfaces de usuário em aplicações existentes não são suficientes para as necessidades de pesquisa do usuário final.
• Implementar índices de texto completo no SQL Server.
• SQL Server Query usando consultas de texto completo.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Exame
TS: 70-433: TS: Microsoft SQL Server 2008 Desenvolvimento de Banco de Dados
(somente em inglês)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
10266 - Programming in C# with Microsoft Visual Studio 2010
Carga Horária: 5 dias ou 10 noites
About this Course
The course focuses on C# program structure, language syntax, and implementation detailswith .NET Framework 4.0. This course
describes the new enhancements in the C# 4.0 language by using Visual Studio 2010.
In this course, lower-intermediate level programmers gain the knowledge and skills they need to develop C# applications for the
Microsoft .NET Framework 4.0. The course highlights the structure of C# 4.0 programs, language syntax, and implementation details. This
course is not mapped to any exam.
Audience Profile
This course is intended for experienced developers who already have programming experience in C, C++, Visual Basic, or Java and
understand the concepts of object-oriented programming.
This course is not designed for new programmers; it is targeted at professional developers with at least 12 months experience of
programming in an object-oriented environment.
Prerequisites
Before attending this course, students must have:
• At least 12 months experience working with an Object Oriented language
•Have C++ or Java knowledge:
• Creating Classes
• Inheritance and Abstraction
• Polymorphism
• Interfaces
• Exceptions
•Knowledge of the Visual Studio IDE.
At Course Completion
After completing this course, students will be able to:
• Explain the purpose of the .NET Framework, and understand how to use C# and Visual Studio 2010 to build .NET Framework
applications.
• Understand the syntax of basic C# programming constructs.
• Create and call methods in a C# application.
• Catch, handle and throw exceptions.
• Perform basic file IO operations in a C# application.
• Create and use new types (enumerations, classes, and structures), and understand the differences between reference types and value
types.
• Control the visibility and lifetime of members in a type.
• Use inheritance to create new reference types.
• Manage the lifetime of objects and control the use of resources.
• Define properties and indexers to encapsulate data, and define operators for this data.
• Decouple an operation from the method that implements an operation, and use these decoupled operations to handle asynchronous
events.
• Use collections to aggregate data, and use Generics to implement type-safe collection classes, structures, interfaces, and methods.
• Implement custom collection classes that support enumeration.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Query in-memory data by using LINQ.
• Integrate code written by using a dynamic language such as Ruby and Python, or technologies such as COM, into a C# application
Course Outline
1- Introducing C# and the .NET Framework
This module explains the .NET Framework, and using C# and Visual Studio 2010 for building .NET Framework applications.
•Introduction to the .NET Framework
•Creating Projects Within Visual Studio 2010
•Writing a C# Application
•Building a Graphical Application
•Documenting an Application
•Running and Debugging Applications by Using Visual Studio 2010
-Lab : Introducing C# and the .NET Framework
• Building a Simple Console Application
• Building a WPF Application
• Verifying the Application
• Generating Documentation for an Application
After completing this module, students will be able to:
• Explain the purpose of the .NET Framework.
• Create Microsoft Visual C# projects by using Visual Studio 2010.
• Explain the structure of a C# application.
• Use the WPF Application template to build a simple graphical application.
• Use XML comments to document an application.
• Use the debugger to step through a program.
2- Using C# Programming Constructs
This module explains the syntax of basic C# programming constructs.
• Declaring Variables and Assigning Values
• Using Expressions and Operators
• Creating and Using Arrays
• Using Decision Statements
• Using Iteration Statements
- Lab : Using C# Programming Constructs
• Calculating Square Roots with Improved Accuracy
• Converting Integer Numeric Data to Binary
• Multiplying Matrices
After completing this module, students will be able to:
• Declare variables and assign values.
• Create expressions by using operators.
• Create and use arrays.
• Use decision statements.
• Use iteration statements.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
3- Declaring and Calling Methods
This module explains how to create and call methods.
• Defining and Invoking Methods
• Specifying Optional Parameters and Output Parameters
-Lab : Declaring and Calling Methods
• Calculating the Greatest Common Divisor of Two Integers by Using Euclid's Algorithm
• Calculating the GCD of Three, Four, or Five Integers
• Comparing the Efficiency of Two Algorithms
• Displaying Results Graphically
• Solving Simultaneous Equations (optional)
After completing this module, students will be able to:
• Describe how to declare and call methods
• Define and call methods that take optional parameters and output parameters
4- Handling Exceptions
This module explains how to catch exceptions and handle them. Students will also learn how to throw exceptions.
• Handling Exceptions
• Raising Exceptions
-Lab : Handling Exceptions
• Making a Method Fail-Safe
• Detecting an Exceptional Condition
• Checking for Numeric Overflow
After completing this module, students will be able to:
• Describe how to catch and handle exceptions
• Describe how to create and raise exceptions
5- Reading and Writing Files
This module explains how to perform basic file I/O operations in a C# application.
•Accessing the File System
•Reading and Writing Files by Using Streams
-Lab : Reading and Writing Files
•Building a Simple Editor
•Making the Editor XML Aware
After completing this module, students will be able to:
•Describe how to access the file system by using the classes that the .NET Framework provides.
•Describe how to read and write files by using streams.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
6- Creating New Types
This module explains how to create and use new types (enumerations, classes, and structures)
• Creating and Using Enumeration
• Creating and Using Classes
• Creating and Using Structs
• Comparing References to Values
-Lab : Creating New Types
• Using Enumerations to Specify Domains
• Using a Struct to Model a Simple Type
• Using a Class to Model a More Complex Type
• Using a Nullable Struct
After completing this module, students will be able to:
• Describe how to create and use enumerations.
• Describe how to create and use classes.
• Describe how to create and use structures.
• Explain the differences between reference and value types.
7- Encapsulating Data and Methods
This module explains how to control the visibility and lifetime of members in a type.
• Controlling Visibility of Type Members
• Sharing Methods and Data
-Lab : Encapsulating Data and Methods
• Hiding Data Members
• Using Static Members to Share Data
• Implementing an Extension Method
After completing this module, students will be able to:
• Describe how to control the visibility of type members.
• Describe how to share methods and data.
8- Inheriting From Classes and Implementing Interfaces
This module explains how to use inheritance to create new reference types
• Using Inheritance to Define New Reference Types
• Defining and Implementing Interfaces
• Defining Abstract Classes
-Lab : Inheriting From Classes and Implementing Interfaces
• Defining an Interface
• Implementing an Interface
• Creating an Abstract Class
After completing this module, students will be able to:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Use inheritance to define new reference types.
• Define and implement interfaces.
• Define abstract classes.
9- Managing the Lifetime of Objects and Controlling Resources
This module explains how to manage the lifetime of objects and control the use of resources.
• Introduction to Garbage Collection
• Managing Resources
-Lab : Managing the Lifetime of Objects and Controlling Resources
• Implementing the IDisposable Interface
• Managing Resources Used By an Object
After completing this module, students will be able to:
• Describe how garbage collection works in the .NET Framework.
• Manage resources effectively in an application.
10- Encapsulating Data and Defining Overloaded Operators
This module explains how to create properties and indexers to encapsulate data, and how to define operators for this data.
• Creating and Using Properties
• Creating and Using Indexers
• Overloading Operators
-Lab : Creating and Using Properties
• Defining Properties in an Interface
• Implementing Properties in a Class
• Using Properties Exposed By a Class
-Lab : Creating and Using Indexers
• Implementing an Indexer to Access Bits in a Control Register
• Using an Indexer Exposed by a Class
-Lab : Overloading Operators
• Defining the Matrix and MatrixNotCompatible Types
• Implementing Operators for the Matrix Type
• Testing the Operators for the Matrix Type
After completing this module, students will be able to:
• Explain how properties work and use them to encapsulate data.
• Describe how to use indexers to access data through an array-like syntax.
• Describe how to use operator overloading to define operators for your own types.
11- Decoupling Methods and Handling Events
This module explains how to decouple an operation from the method that implements an operation, and how to use these decoupled
methods to handle asynchronous events.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Declaring and Using Delegates
• Using Lambda Expressions
• Handling Events
-Lab : Decoupling Methods and Handling Events
• Raising and Handling Events
• Using Lambda Expressions to Specify Code
After completing this module, students will be able to:
• Describe the purpose of delegates, and explain how to use a delegate to decouple an operation from the implementing method.
• Explain the purpose of lambda expressions, and describe how to use a lambda expression to define an anonymous method.
• Explain the purpose of events, and describe how to use events to report that something significant has happened in a type that other
parts of the application need to be aware of.
12- Using Collections and Building Generic Types
This module introduces collections, and describes how to use Generics to implement type-safe collection classes, structures, interfaces,
and methods.
• Using Collections
• Creating and Using Generic Types
• Defining Generic Interfaces and Understanding Variance
• Using Generic Methods and Delegates
-Lab : Using Collections
• Optimizing a Method by Caching Data
-Lab : Building Generic Types
• Defining a Generic Interface
• Implementing a Generic Interface
• Implementing a Test Harness for the BinaryTree Project
• Implementing a Generic Method
After completing this module, students will be able to:
• Use collection classes.
• Define and use generic types.
• Define generic interfaces and explain the concepts of covariance and contravariance.
• Define and use generic methods and delegates.
13- Building and Enumerating Custom Collection Classes
This module explains how to implement custom collection classes that support enumeration.
• Implementing a Custom Collection Class
• Adding an Enumerator to a Custom Collection Class
-Lab : Building and Enumerating Custom Collection Classes
• Implementing the IList TItem Interface
• Implementing an Enumerator by Writing Code
• Implementing an Enumerator by Using an Iterator
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this module, students will be able to:
• Implement a custom collection class.
• Define an enumerator for a custom collection class.
14- Using LINQ to Query Data
This module explains how to query in-memory data by using LINQ.
• Using the LINQ Extension Methods and Query Operators
• Building Dynamic LINQ Queries and Expressions
-Lab : Using LINQ to Query Data
• Using the LINQ Query Operators
• Building Dynamic LINQ Queries
After completing this module, students will be able to:
• Describe how to use the LINQ extension methods and query operators.
• Describe how to build dynamic LINQ queries and expressions.
15- Integrating Visual C# Code with Dynamic Languages and COM Components
This module explains how to integrate code written by using a dynamic language such as Ruby and Python, and technologies such as
COM, into a C# application
• Integrating C# Code with Ruby and Python
• Accessing COM Components from C#
-Lab : Integrating C# Code with Dynamic Languages and COM Components
• Integrating Code Written by Using a Dynamic Language into a C# Application
• Using a COM Component from Visual C# Application
After completing this module, students will be able to:
• Integrate Ruby and Python code into a Visual C# application.
• Invoke COM components and services from a C# application.
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
10267 - Introduction to Web Development with Microsoft Visual Studio 2010
Carga Horária: 5 dias ou 10 noites
About this Course
This five-day instructor-led course provides knowledge and skills on developing Web applications by using Microsoft Visual Studio 2010.
Audience Profile
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
This course is intended for Web developers who are beginners and have knowledge of Hypertext Markup Language (HTML) or Dynamic
HTML (DHTML), along with some knowledge of a scripting language such as Visual Basic Scripting Edition or Microsoft Jscript.
Students are required to have the following skills:
• Ability to construct a simple Web page using a Microsoft or 3rd Party tool. For example, create or customize a Web Page on a
SharePoint site.
Prerequisites
Before attending this course, students must have at least one month of experience in .NET technologies. In addition to their professional
experience, students who attend this training should have the following technical knowledge:
• Knowledge of HTML or DHTML, including:
• Tables
• Images
• Forms
• Programming experience using Visual Basic .NET or Visual C# .NET, including:
• Declaring variables
• Using loops
• Using conditional statements
The completion of Course 2667, Introduction to Programming, satisfies the preceding prerequisite programming skills requirement.
At Course Completion
After completing this course, students will be able to:
• Explore ASP.NET Web applications in Microsoft Visual Studio 2010.
• Create Web applications by using Microsoft Visual Studio 2010 and Microsoft .NET–based languages.
• Create a Microsoft ASP.NET Web Form.
• Add functionality to a Microsoft ASP.NET Web Form.
• Implement master pages and user controls.
• Validate user input.
• Debug Microsoft ASP.NET Web applications.
• Manage data in an ASP.NET 3.5 Web application.
• Manage data access tasks by using LINQ.
• Manage data by using ASP.NET Dynamic Data.
• Create a Microsoft ASP.NET AJAX application.
• Consume and Windows Communication Foundation (WCF) services.
• Manage state in Web applications.
• Configure and deploy a Microsoft ASP.NET Web application.
• Secure a Microsoft ASP.NET Web application.
• Implement new technologies supported by Visual Studio 2010 for Web development.
Course Outline
1- Exploring Microsoft ASP.NET Web Applications in Microsoft Visual Studio 2010
This module explains the key features of Microsoft .NET Framework and Microsoft ASP.NET. It helps you view the complete Web
application that you build in the labs throughout this course
• Introduction to the .NET Framework
• Overview of ASP.NET
• Overview of the Lab Application
-Lab : There are no labs for this module
After completing this module, students will be able to:
• Describe the .NET Framework.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Describe ASP.NET.
• Describe the Lab Application.
2- Creating Web Applications by Using Microsoft Visual Studio 2010 and Microsoft .NET–Based Languages
This module describes the different programming languages that are available when you develop Microsoft .NET Framework
applications. It explains the fundamental aspects of writing code and creating components by using two of the .NET Framework–based
languages, Microsoft Visual Basic and Microsoft Visual C#. It provides an overview of Microsoft Visual Studio 2010. It also explains how to
create a simple Web application.
• Choosing a Programming Language
• Overview of Visual Studio 2010
• Creating a Simple Web Application
Lab : Creating Web Applications by Using Microsoft Visual Studio 2010 and Microsoft .NET–Based Languages
• Exercise 1: Creating an ASP.NET Web Site
• Exercise 2: Adding and Configuring Server Controls in Web Forms
• Exercise 3: Building and Deploying an ASP.NET Web Application
After completing this module, students will be able to:
• Choose a programming language.
• Describe Visual Studio 2010.
• Create a simple Web application.
3- Creating a Microsoft ASP.NET Web Form
This module explains how to create Web Forms and populate them with server controls.
• Creating Web Forms
• Adding and Configuring Server Controls in a Web Form
-Lab : Creating a Microsoft ASP.NET Web Form
• Exercise 1: Creating a Web Form
• Exercise 2: Adding and Configuring Server Controls in a Web Form
After completing this module, students will be able to:
• Create Web Forms.
• Add and configure server controls in a Web Form.
4- Adding Functionality to a Microsoft ASP.NET Web Form
This module describes the various methods that you can use to add code to your Microsoft ASP.NET Web application. It explains how to
use Web server controls, event handlers, code-behind files, and components. In addition, it explains how to use page events, especially
the Page_Load event.
• Working with Code-Behind Files
• Handling Server Control Events
• Creating Classes and Components by Using Visual Studio 2010
• Handling Page Events
-Lab : Adding Functionality to a Microsoft ASP.NET Web Form
• Exercise 1: Implementing Code in a Web Application
• Exercise 2: Creating Event Procedures
• Exercise 3: Creating an Entity Component
• Exercise 4: Handling Page and Control Events
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this module, students will be able to:
• Work with code-behind files.
• Handle server control events.
• Create classes and components by using Microsoft Visual Studio 2010.
• Handle page events.
5- Implementing Master Pages and User Controls
This module explains how to create and implement master pages and how to implement user controls in a Web application.
• Creating Master Pages
• Adding User Controls to an ASP.NET Web Form
-Lab : Implementing Master Pages and User Controls
• Exercise 1: Adding and Applying a Master Page
• Exercise 2: Converting Web Forms to Content Pages and User Controls
After completing this module, students will be able to:
• Create master pages.
• Add user controls to a Microsoft ASP.NET Web Form.
6- Validating User Input
This module provides an overview of user input validation. It covers information on adding, positioning, and configuring validation
controls on a Web Form. In addition, it covers information on validating Web Forms.
• Overview of User Input Validation
• ASP.NET Validation Controls
• Validating Web Forms
-Lab : Validating User Input
• Exercise 1: Adding Validation Controls
• Exercise 2: Configuring Validation Controls
• Exercise 3: Adding Server-Side Validation
After completing this module, students will be able to:
• Describe user input validation
• Implement Microsoft ASP.NET validation controls
• Validate Web Forms
7- Troubleshooting Microsoft ASP.NET Web Applications
This module describes the steps required to enable tracing and debugging, including how you can use debugging and tracing in a Web
application.
• Debugging in ASP.NET
• Tracing in ASP.NET
-Lab : Debugging Microsoft ASP.NET Web Applications
• Exercise 1: Debugging a Web Application
• Exercise 2: Tracing a Web Application
After completing this module, students will be able to:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Perform debugging in Microsoft ASP.NET
• Perform tracing in ASP.NET
8- Managing Data in an Microsoft ASP.NET 4.0 Web Application
This module provides an overview of Microsoft ADO.NET. It explains how to programmatically work with data by using ADO.NET and how
to create a connection to access the data stored in a Microsoft SQL Server database. In addition, it explains how to use the DataSet and
DataReader objects to support the local data storage and data manipulation requirements of Web Forms.
• Overview of ADO.NET
• Connecting to a Database
• Managing Data
-Lab : Managing Data in an ASP.NET 4.0 Web Application
• Exercise 1: Connecting to a Data Source
• Exercise 2: Binding a Server Control to a Data Source
• Exercise 3: Modifying a Data Source
After completing this module, students will be able to:
• Describe ADO.NET.
• Connect to a database.
• Manage data.
9- Managing Data Access Tasks by Using LINQ
This module explains what LINQ is and how you can use LINQ to manage both XML data and Microsoft SQL Server data in a Microsoft
ASP.NET Web application by using Web Server controls and code.
• Overview of LINQ
• Managing XML Data by Using LINQ to XML
• Managing SQL Data by Using LINQ to SQL and LINQ to Entities
-Lab : Managing Data Access Tasks by Using LINQ
• Exercise 1: Loading Data by Using the XmlDataSource Control
• Exercise 2: Displaying Data by Using LINQ to XML
• Exercise 3: Saving Data by Using LINQ to Entities
After completing this module, students will be able to:
• Describe language-integrated query (LINQ).
• Manage XML data by using LINQ to XML.
• Manage SQL data by using LINQ.
10- Managing Data by Using Microsoft ASP.NET Dynamic Data
This module provides an overview of Microsoft ASP.NET Dynamic Data. It also covers information on applying ASP.NET Dynamic Data. In
addition, it explains how to customize ASP.NET Dynamic Data applications.
• Overview of ASP.NET Dynamic Data
• Applying ASP.NET Dynamic Data
• Customizing ASP.NET Dynamic Data Applications
-Lab : Managing Data by Using ASP.NET Dynamic Data
• Exercise 1: Adding Dynamic Data to an Existing Web Site
• Exercise 2: Registering LINQ to Entities by Using Dynamic Data
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Exercise 3: Map, Clean and Test Solution
After completing this module, students will be able to:
• Describe ASP.NET Dynamic Data
• Apply ASP.NET Dynamic Data
• Customize ASP.NET Dynamic Data applications
11- Creating a Microsoft ASP.NET Ajax-enabled Web Forms Application
This module provides an overview of Microsoft ASP.NET AJAX and explains how to create an ASP.NET AJAX application. It also introduces
the ASP.NET AJAX Control Toolkit, and explains how to install the toolkit and add controls from the toolkit to a Web application.
• Introduction to Ajax
• Creating an ASP.NET Ajax Application by Using the Ajax Features for ASP.NET
• Extending an ASP.NET Web Forms Application by Using the Ajax Control Toolkit
-Lab : Creating a Microsoft ASP.NET Ajax-Enabled Web Forms Application
• Exercise 1: Creating a Modal About Box
• Exercise 2: Customizing Dynamic Data Field Templates with Ajax Server Controls
• Exercise 3: Adding the Country Import Progress Indicator
After completing this module, students will be able to:
• Describe ASP.NET AJAX.
• Create an ASP.NET AJAX application by using the ASP.NET AJAX extensions.
• Extend an application by using the ASP.NET AJAX Control Toolkit.
12- Consuming Microsoft Windows Communication Foundation Services
This module provides an overview of Windows Communication Foundation services. In addition, this module describes how to call a
Windows Communication Foundation (WCF) service directly by using a browser and a proxy from a Web application.
• Overview of Windows Communication Foundation Services
• Calling Windows Communication Foundation Services
• Working with WCF Data Services
-Lab : Consuming Windows Communication Foundation Services
• Exercise 1: Creating a WCF Service Reference Proxy
• Exercise 2: Calling a WCF Service Method from a Web Form
• Exercise 3: Implementing WCF Data Services
After completing this module, students will be able to:
• Describe WCF services.
• Call WCF services.
• Consume Windows Communication Foundation services.
13- Managing State in Web Applications
This module explains how to manage state in a Microsoft ASP.NET Web application.
• State Management
• ASP.NET Profiles
• ASP.NET Caching
-Lab : Managing State in Web Applications
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Exercise 1: Examining the View State
• Exercise 2: Caching Countries
• Exercise 3: Displaying Visitors Counter on Default Page
After completing this module, students will be able to:
• Describe state management.
• Describe Microsoft ASP.NET Profiles.
• Describe ASP.NET Caching.
14- Configuring and Deploying a Microsoft ASP.NET Web Application
This module explains how to configure and deploy a Microsoft ASP.NET Web application by using the machine.config and web.config
files.
• Configuring an ASP.NET Web Application
• Deploying an ASP.NET Web Application
-Lab : Configuring and Deploying a Microsoft ASP.NET Web Application
• Configuring the List View Page Size and Enabling the Save Countries Button
• Configuring the Visitor Counter
• Deploying the Web Application
After completing this module, students will be able to:
• Configure an ASP.NET Web application.
• Deploy an ASP.NET Web application.
15- Securing a Microsoft ASP.NET Web Application
This module explains the various Web application security functionalities. It also covers information on the infrastructure to build and
deploy various Web application security functionalities.
• Overview of Web Application Security
• Declaratively Configuring Authentication and Authorization
• Working Programmatically with Authentication and Authorization
-Lab : Securing a Microsoft ASP.NET Web Application
• Exercise 1: Enabling Forms Authentication
• Exercise 2: Implementing Authorization
• Exercise 3: Protecting Configuration File
After completing this module, students will be able to:
• Describe Web application security.
• Describe how to declaratively configure authentication and authorization.
• Work programmatically with authentication and authorization.
16- Implementing Advanced Technologies Supported by Microsoft Visual Studio 2010 for Web Development
This module describes the new Visual Studio 2010 and .NET Framework 4 functionalities, changes, and enhancements for improved Web
development. The module also covers how Microsoft ASP.NET MVC 2 and Microsoft Silverlight 4 fit in with .NET Framework 4 and Visual
Studio 2010
• Working with the ASP.NET MVC 2 Framework
• Working with Silverlight 4
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
-Lab : Implementing Advanced Technologies Supported by Microsoft Visual Studio 2010 for Web Development
• Exercise: Implementing a Silverlight Application
After completing this module, students will be able to:
• Work with ASP.NET MVC 2.
• Work with Silverlight 4.
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
10265 - Developing Data Access Solutions with Microsoft Visual Studio 2010
Carga Horária: 5 dias
About this Course
In this course, experienced developers who know the basics of data access (CRUD) in Windows client and Web application
environments will learn to optimize their designs and develop better performing data access code by using the ADO.NET
Entity Framework, LINQ, WCF Data Services, the Sync Framework, and ADO.NET.
Audience Profile
This course is intended for professional .NET software developers who use Microsoft Visual Studio in a team-based,
medium-sized to large development environment. They will have experience implementing data access and data binding
within their Web and/or Windows client applications and are interested in learning to optimize data access code in their
applications by using the Entity Framework, LINQ, and ADO.NET. Members of the audience are experienced users of
Microsoft Visual Studio 2008 SP1 or newer releases of the Visual Studio product. The audience has some experience using
Visual Studio 2010 for either Windows client or Web application development.
Typically, this audience has the following knowledge/experience:
• Experience developing n-tier applications that access various data sources
• Experience implementing data binding within their applications
• Some experience using LINQ and ADO.NET
• A conceptual understanding of the Entity Framework
Prerequisites
Before attending this course, students must have:
• An understanding of the problem-solving techniques that apply to software development, including the following
principles of software development:
• Modern software development models
• Typical phases of a software development lifecycle
• Concepts of event-driven programming
• Concepts of object-oriented programming
• Creating use-case diagrams
• Designing and building a user interface
• Developing a structured application
• A basic understanding of the following scripting techniques and some hands-on experience writing scripts:
• Web scripting techniques
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Macro scripting techniques
• Windows scripting techniques
• A general understanding of the purpose, function, and features of following .NET Framework topics:
• Common Language Runtime
• .NET Framework class library
• Common Type System
• Component interoperation
• Cross-language interoperability
• Assemblies in the Common Language Runtime
• Application domains
• Runtime hosts supported by the .NET Framework
• Experience using Visual Studio 2008 in the following task areas:
• Declaring and initializing typed variables using the Camel case naming convention
• Using arithmetic, relational, and logical operators in code statements
• Using branching statements to control code execution
• Using looping statements to iterate through collections or repeat steps until a specified condition is met
• Creating classes and methods to establish the basic structure of an application
• Using methods and events to implement the programming logic of an application
• Identifying syntax and logic errors
• Accessing and managing data from a data source
• Experience in object oriented design and development as follows:
• Creating and accessing classes and class properties
• Creating and accessing methods and overloaded methods
• Implementing inheritance, base classes, and abstract classes
• Declaring, raising, and handling events
• Responding to and throwing exceptions
• Implementing interfaces and polymorphism
• Implementing shared and static members
• Implementing generics
• Creating components and class libraries
• Experience in N-Tier application design and development as follows:
• Managing a software development process
• Controlling input at the user interface level in Windows client and Web applications
• Debugging, tracing, and profiling .NET applications
• Monitoring and logging .NET applications
• Implementing basic testing best practices
• Performing basic data access tasks with LINQ
• Basics of LINQ to XML
• Basics of LINQ to Entities
• Basics of LINQ to SQL
• Implementing basic security best practices in .NET Applications
• Basics of Code Access Security
• Basics of Role-Based Security
• Basics of Cryptography Services
• Implementing basic service calls
• Basics of creating and consuming XML Web Services
• Basics of creating and consuming WCF Services
• Using .NET Configuration Files
• Deploying .NET Framework Applications using ClickOnce and the MS Installer
• Data access experience in Windows client application development as follows:
• Connect to a data source
• Implement data binding
• Implement data validation at the UI layer
• Data access experience in Web application development as follows:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Connect to a data source
• Implement dynamic data
• Implement data validation at the UI layer
At Course Completion
After completing this course, students will be able to:
• Evaluate a variety of business cases, and then select an appropriate combination of data access technologies and tools
most appropriate to each case. Describe the roles of Entity Framework, WCF Data Services, and ADO.NET for building and
maintaining applications. Use LINQ on top of these technologies to improve productivity and the quality of their
applications.
• Use the tools provided with the Entity Framework to map the conceptual model used by the business logic of an
application to the logical data model provided by a database.
• Query an Entity Data Model (EDM) by using common methods such as LINQ to Entities, Entity SQL, and the classes in the
EntityClient namespace.
• Perform data modification tasks on data in an EDM.
• Explain the function of the Object Services model implemented by the Entity Framework and the support provided by the
Object Services API for addressing the issues faced by enterprise applications that have to handle multiple concurrent users
simultaneously accessing the same data .
• Describe best practices for designing and building a scalable, optimized data access layer by using Object Services.
• Customize and extend entities with their own business logic and use advanced mappings to shape the data model to their
business and application requirements.
• Reuse existing business classes in a data access layer built by using the Entity Framework.
• Address the architectural issues that can arise when building an n-tier enterprise application by using the Entity
Framework.
• Build extensible solutions that can update data in an n-tier enterprise application by using the Entity Framework.
• Access offline data or data that that has limited availability in client applications.
• Design, develop, and consume a simple WCF Data Service.
• Use WCF Data Services to update and delete data and to handle multi-user concerns.
• Develop high performance, scalable ADO.NET applications that can query and update data.
• Explain how LINQ to SQL enables development against a logical model which abstracts the low-level details of querying
ADO.NET tables and result sets.
Course Outline
1- Architecture and Data Access Technologies
This module describes the commonly used data access technologies and scenarios in which you are likely to use them.
• Data Access Technologies
• Data Access Scenarios
-Lab : Analyzing Data Access Scenarios
• Identifying Data Access Technologies
After completing this module, students will be able to:
• Describe the key data access technologies available to .NET Framework developers.
• Assign appropriate data access technologies to common data access scenarios.
2- Building Entity Data Models
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
This module introduces the concepts of data modeling, and in particular, Entity Data Models (EDMs). It explains how you
can use EDMs to decouple the conceptual data structure in your applications from the logical data structure in the data
store.
• Introduction to Entity Data Models
• Modifying the Entity Data Model
• Customizing the Entity Data Model
-Lab : Using Entity Data Models
• Generating an EDM from the AdventureWorks Database
• Adding Entities and Associations
• Using the Generate Database Wizard
• Mapping Entities to Multiple Tables
• Implementing an Inheritance Hierarchy
• Using Stored Procedures
• Creating a Complex Type
After completing this module, students will be able to:
• Describe and create an Entity Data Model.
• Modify an Entity Data Model by using the Entity Designer.
• Customize a model to meet their business requirements.
3- Querying Entity Data
This module explains how to query an entity data model by using common methods such as LINQ to Entities, Entity SQL,
and the classes in the EntityClient namespace.
• Retrieving Data by Using LINQ to Entities
• Retrieving Data by Using Entity SQL
• Retrieving Data by Using EntityClient Provider
• Retrieving Data by Using Stored Procedures
• Unit Testing Your Data Access Code
-Lab : Querying Entity Data
• Retrieving All Contact Entities
• Retrieving Contact Entities by Using a Filter
• Retrieving RewardsClaimed Entities
• Querying the Rewards Family of Entities
• Executing a Stored Procedure
After completing this module, students will be able to:
• Retrieve data by using LINQ to Entities.
• Retrieve data by using the Entity SQL language.
• Retrieve data by using the EntityClient Provider.
• Retrieve data by using stored procedures in the entity model.
• Create unit tests for their data access code.
4- Creating, Updating, and Deleting Entity Data
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
This module introduces you to the ways that the Entity Framework enables you to modify the data in your database. You
apply changes to the entities managed by the ObjectContext class. The ObjectContext class is responsible for tracking all
changes to entities and then persisting these changes to the database on request.
• Understanding Change Tracking in the Entity Framework
• Modifying Data in an Entity Data Model
-Lab : Creating, Updating, and Deleting Entity Data
• Maintaining Contact and Reward Data
• Maintaining RewardsClaim Data
After completing this module, students will be able to:
• Describe how the Entity Framework implements change tracking.
• Describe how to modify data in the entity model, and persist the changes to the database.
5- Handling Multi-User Scenarios by Using Object Services
This module introduces the concurrency model that the Entity Framework uses to address the issues faced by applications
that must support multiple users who access the same data simultaneously. It also describes how the Entity Framework can
make use of transactions to ensure data integrity.
• Handling Concurrency in the Entity Framework
• Transactional Support in the Entity Framework
-Lab : Handling Multi-User Scenarios by Using Object Services
• Handling Concurrency of Rewards Claimed Data
• Updating the RewardsClaimed and ArchivedRewardsClaimed Information by Using a Transaction
After completing this module, students will be able to:
• Describe the optimistic concurrency model that the Entity Framework uses.
• Manage transactions in applications that use the Entity Framework.
6- Building Optimized Solutions by Using Object Services
This module explains best practices for designing and building a scalable, optimized data access layer by using Object
Services. The module introduces several techniques that can be used to optimize the performance of queries that execute
against the conceptual model.
• The Stages of Query Execution
• Change Tracking and Object Materialization
• Using Compiled Queries
• Using Design-Time Generated Entity Framework Views
• Monitoring Performance
• Performing Asynchronous Data Modifications
-Lab : Building Optimized Solutions by Using Object Services
• Improving the Performance of Query Operations
• Improving the Performance of Update Operations
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
After completing this module, students will be able to:
• Explain how the Entity Framework executes queries.
• Understand the impact of tracking and object materialization on query performance.
• Describe how to use compiled queries.
• Describe how to use design-time generated views.
• Describe how to monitor query performance.
• Describe how to perform asynchronous data modifications.
7- Customizing Entities and Building Custom Entity Classes
This module describes how to customize and extend entities with your own business logic.
• Overriding Generated Classes
• Using Templates to Customize Entities
• Creating and Using Custom Entity Classes
-Lab : Customizing Entities and Building Custom Entity Classes
• Using a Template to Add Custom Functionality to Entity Classes
• Creating Custom Entity Classes
After completing this module, students will be able to:
• Use partial classes and methods to add business logic to generated code.
• Create and use templates to customize code generation.
• Modify existing business classes to take advantage of entity functionality.
8- Using POCO Classes with the Entity Framework
This module introduces the ways in which you can define custom entity classes in your Entity Framework application. By
default, Microsoft Visual Studio generates a set of entity classes for you from the Entity Data Model (EDM). Instead of these
generated classes, you may want to use an existing set of "plain old" CLR objects (POCO) business classes in your
application You can also extend the generated entity classes to add custom business functionality to your entity objects.
• Requirements for POCO Classes
• POCO Classes and Lazy Loading
• POCO Classes and Change Tracking
• Extending Entity Types
-Lab : Using POCO Classes with the Entity Framework
• Using POCO Classes
• Extending Your POCO Classes
After completing this module, students will be able to:
• List the requirements that their POCO classes must meet.
• Create POCO entities that support automatic lazy loading.
• Create POCO entities that support automatic change tracking.
• Describe the options for using interfaces and inheritance to create custom entity objects.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
9- Building an N-Tier Solution by Using the Entity Framework
This module explains how to address the architectural issues that can arise when building an N-Tier enterprise application
by using the Entity Framework.
• Designing an N-Tier Solution
• Defining Operations and Implementing Data Transport Structures
• Protecting Data and Operations
-Lab : Building an N-Tier Solution by Using the Entity Framework
• Creating the Contacts and Orders Data Access Tier
• Protecting Data Access Operations
After completing this module, students will be able to:
• Describe the issues and strategies that are relevant to building n-tier applications.
• Understand the key components that they must create in order to implement an n-tier application.
• Describe how to protect operations and data in an n-tier application.
10- Handling Updates in an N-Tier Solution by Using the Entity Framework
This module describes how you can handle data modifications in an n-tier solution. The module describes the different
strategies for handling modifications that you should use for the different alternative formats for transporting data
between tiers: data transfer objects (DTOs), self-tracking entities (STEs), and simple entities (SEs). The module also
describes how to manage the exceptions that can occur during the data modification process.
• Tracking Entities and Persisting Changes
• Managing Exceptions in an N-Tier Solution
-Lab : Handling Updates in an N-Tier Solution by Using the Entity Framework
• Handling Updates in the Data Access Tier
• Detecting and Handling Order Conflicts
After completing this module, students will be able to:
• Describe strategies that they can adopt for tracking changes in the client application, and persisting those changes in the
database.
• Describe how to trap and handle update and concurrency exceptions in the an n-tier solution.
11- Building Occasionally Connected Solutions
This module describes how to access offline or occasionally connected data in client applications.
• Offline Data Caching by Using XML
• Using the Sync Framework
-Lab : Building Occasionally Connected Solutions
• Modifying the Orders Application to Use Offline XML Data
• Modifying the Orders Application to Synchronize Locally Cached Data
After completing this module, students will be able to:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Cache data in local XML files by using LINQ to XML.
• Implement an occasionally connected application by using the Microsoft Sync Framework.
12- Querying Data by Using WCF Data Services
Windows Communication Foundation (WCF) Data Services enable you to create highly flexible data services that can be
used to provide access to data across the Internet or a corporate network. You can access these services by using RESTstyle URIs, and they can be easily consumed by a wide variety of applications. As WCF Data Services are build on top of
standard Internet protocols such as HTTP and the Atom Publishing Protocol, they are an ideal choice for delivering data to
AJAX applications and Rich Interactive Applications built using technologies such as Microsoft Silverlight.
• Introduction to WCF Data Services
• Creating a WCF Data Service
• Consuming a WCF Data Service
• Protecting Data and Operations in a WCF Data Service
-Lab : Creating and Using WCF Data Services
• Exposing Order Data as a WCF Data Service
• Consuming a WCF Data Service
• Restricting Access to Data Exposed by a WCF Data Service
• Implementing a Business Operation in a WCF Data Service
After completing this module, students will be able to:
• Describe the purpose and features of WCF Data Services.
• Expose data by using a WCF Data Service.
• Implement a client application that can consume a WCF Data Service.
• Grant and restrict access to resources exposed by a WCF Data Service.
13- Updating Data by Using WCF Data Services
This module describes how to use WCF Data Services to create, update, and delete data. WCF Data Services use standard
internet protocols such as HTTP and the Atom Publishing Protocol to enable update access to data across the Internet or a
corporate network.
• Creating, Updating, and Deleting Data in a WCF Data Service
• Preventing Unauthorized Updates and Improving Performance
• Using WCF Data Services with Nonrelational Data
-Lab : Updating Data by Using WCF Data Services
• Updating Entities by Using a WCF Data Service
• Creating and Deleting Entities by Using a WCF Data Service
• Restricting Create, Update, and Delete Requests
After completing this module, students will be able to:
• Create, update, and delete entities by using a WCF Data Service.
• Control access to data modification functionality, and improve performance by batching commands together.
• Use WCF Data Services to access and modify nonrelational data.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
14- Using ADO.NET
ADO.NET is a highly flexible framework for building applications that require access to data held in a data source. This
module introduces ADO.NET and explains how you can use it to develop scalable, high-performance, data-driven
applications.
• Retrieving and Modifying Data by Using ADO.NET Commands
• Retrieving and Modifying Data by Using DataSets
• Managing Transactions and Concurrency in Multiuser Scenarios
-Lab : Using ADO.NET
• Using ADO.NET to Retrieve Read-Only Information Quickly and Perform Simple Data Modifications
• Developing the Product List Web Application
• Enabling Data Modifications
After completing this module, students will be able to:
• Retrieve and update data by using ADO.NET commands and stored procedures.
• Retrieve and update data by using DataSet objects.
• Implement transactions and handle concurrency exceptions.
15- Using LINQ to SQL
ADO.NET provides a mechanism that enables you to build applications that can query and maintain data that is held in a
variety of sources in a database-agnostic manner. However, building applications by using ADO.NET requires that you are
familiar with the Structured Query Language (SQL) language and features of the database management system that you are
connecting to. Language-Integrated Query (LINQ) to SQL provides a higher-level abstraction for managing data that is held
in a Microsoft SQL Server database, and is an ideal stepping stone for migrating ADO.NET applications toward the ADO.NET
Entity Framework. This module introduces LINQ to SQL and explains how you can use it to abstract the low-level details of
ADO.NET queries by developing against a logical data model.
• Implementing a Logical Data Model by Using LINQ to SQL
• Managing Performance and Handling Concurrency
-Lab : Using LINQ to SQL
• Using LINQ to SQL to Build a Data Access Layer
• Updating a Database by Using a Stored Procedure
• Building a Custom Entity Class
After completing this module, students will be able to:
• Design a logical data model by using LINQ to SQL.
• Manage performance by using LINQ to SQL, and handle concurrency.
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
10264 - Developing Web Applications with Microsoft Visual Studio 2010
Carga Horária: 5 dias
About this Course
In this course, students will learn to develop advanced ASP.NET MVC and Web Forms applications using .NET Framework 4
tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site
application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each
should/could be used. This will also prepare the student for exam 70-515.
Audience Profile
This course is intended for professional Web developers who use Microsoft Visual Studio in a team-based, medium-sized to
large development environment. Members of the audience have a minimum of two to three years of experience
developing Web-based applications by using Microsoft Visual Studio and Microsoft ASP.NET. Members of the audience are
experienced users of Microsoft Visual Studio 2008 SP1 and newer releases of the Visual Studio product. The audience
understands how to use the new features of Visual Studio 2010.
Prerequisites
Before attending this course, students must have:
In addition to their professional Web development experience, students who attend this training should have the following
technical knowledge:
• An understanding of the problem-solving techniques that apply to software development, including the following
principles of software development:
• modern software development model
• typical phases of a software development lifecycle
• concepts of event-driven programming
• concepts of object-oriented programming
• creating use-case diagrams
• designing and building a user interface
• developing a structured application
• A basic understanding of the following scripting techniques and some hands-on experience writing scripts:
• Web scripting techniques
• Macro scripting techniques
• Windows scripting techniques
• A general understanding of the purpose, function, and features of following .NET Framework topics:
• Common Language Runtime
• .NET Framework class library
• Common Type System
• Component interoperation
• Cross-Language Interoperability
• Assemblies in the Common Language Runtime
• Application Domains
• Runtime hosts supported by the .NET Framework
•Experience using Visual Studio 2008 in the following task areas:
• Declaring and initializing typed variables using the Camel case naming convention
• Using arithmetic, relational, and logical operators in code statements
• Using branching statements to control code execution
• Using looping statements to iterate through collections or repeat steps until a specified condition is met
• Creating classes and methods to establish the basic structure of an application
• Using methods and events to implement the programming logic of an application
• Identifying syntax and logic errors
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Accessing and managing data from a data source
• Experience in object oriented design and development as follows:
• Creating and accessing classes and class properties
• Creating and accessing methods and overloaded methods
• Implementing inheritance, base classes, and abstract classes
• Declaring, raising, and handling events
• Responding to and throwing exceptions
• Implementing interfaces and polymorphism
• Implementing shared and static members
• Implementing generics
• Creating components and class libraries
Experience in N-Tier application design and development as follows:
• Managing a software development process
• Controlling input at the user interface level in Windows Client and Web applications
• Debugging, tracing, and profiling .NET applications
• Monitoring and logging .NET applications
• Implementing basic testing best practices
• Performing basic Data Access tasks with LINQ
• Implementing basic security best practices in .NET Applications
• Implementing basic service calls
• Using .NET Configuration Files
•Deploying .NET Framework Applications using ClickOnce and the MS Installer
At Course Completion
After completing this course, students will be able to:
•Describe the underlying architecture and design of a Web application.
•Apply best practices and make appropriate trade-offs based on business requirements when designing a Web application.
•Develop MVC models.
•Develop MVC controllers.
•Develop MVC views.
•Optimize the design of a Web application for discoverability by search engines.
•Write server-side code for Web Forms.
•Optimize data management for Web Forms.
•Ensure quality by debugging, unit testing, and refactoring.
•Secure a Web application.
•Apply Master Pages and CSS for a consistent application UI.
•Develop client-side scripts and services for a responsive, rich, and interactive UI.
•Implement advanced AJAX in a Web application.
•Deploy a Web application.
•Develop a Web application by using Silverlight.
Course Outline
1- Overview of Web Application Design
This module describes the underlying architecture and design of a Web application
• Overview of IIS 7.0
• Overview of ASP.NET 4.0
• Introduction to the MVC Framework
• Overview of the Request Life Cycle
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
-Lab : Exploring the Adventure Works Web Site
• Exercise 1: Explore the Adventure Works Web Site
• Exercise 2: Comparing Web Forms and MVC
• Exercise 3: Working with the Web Forms Page Life Cycle
After completing this module, students will be able to:
• Describe the underlying architecture of ASP.NET 4.0.
• Identify new features in ASP.NET 4.0.
• Describe the components of the MVC framework.
• Describe the structure of an MVC application.
• Describe the life cycle of a Web Forms page.
• Describe the life cycle of an MVC page.
•Describe the differences between the life cycle of a Web Forms page and an MVC page
2- Designing a Web Application
This module describes the best practices and trade-offs that you need to make when designing a Web application.
• Web Applications: Case Studies
• Web Application Design Essentials
• Guidelines for Determining When to Use Web Forms and MVC
• Visual Studio 2010 Tools and Technologies for Web Application Design
-Lab : Redesigning the Adventure Works Web site
• Exercise 1: Reviewing the Adventure Works Web site
• Exercise 2: Redesigning the Adventure Works Web site
• Exercise 3: Adding MVC Capabilities to the Adventure Works Web site
After completing this module, students will be able to:
• Explain the different types of web applications and their characteristics.
• Choose the correct design based on the on business requirements, utilizing Web Forms and MVC based.
• Explain the different tools and technologies and best practices around each.
3- Developing MVC Models
This module describes the MVC development model (Models, Controllers, and Views) and how to create the Models that
are used to access and modify the data in a data source.
• Exploring Ways to Create MVC Models
• Creating a Data Repository
Lab : Developing MVC Models
• Exercise 1: Exploring Ways to Create MVC Models
• Exercise 2: Creating Data Repository
After completing this module, students will be able to:
• Create MVC models by using classes and data mapping tools.
• Create a data repository
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
4- Developing MVC Controllers
This module describes how to create the Controllers that are used to respond to communications from the user and how to
implement the application flow and logic.
• Implementing MVC Controllers
• Creating Action Methods
-Lab : Developing MVC Controllers
• Exercise 1: Creating an MVC Controller
• Exercise 2: Adding Code to List the Blog Entries
• Exercise 3: Adding Code to Create a New Blog Entry
• Exercise 4: Adding Code to Edit a Blog Entry
• Exercise 5: Adding Code to Delete a Blog Entry
After completing this module, students will be able to:
• Implement MVC controllers.
• Create action methods
5- Developing MVC Views
This module describes how to create the Views that are used to expose the application UI. The module also covers how to
manage pre-action and post-action behavior of Controller action methods using the included action filters are provided as
part of MVC
• Implementing MVC Views
• Implementing Strongly-Typed MVC Views
• Implementing Partial MVC Views
-Lab : Developing MVC Views
• Exercise 1: Develop a List MVC View
• Exercise 2: Develop a Details MVC View
• Exercise 3: Develop a Create MVC View
• Exercise 4: Develop an Edit MVC View
• Exercise 5: Develop a Delete MVC View
After completing this module, students will be able to:
• Describe what an MVC view is and the varied types of views.
• Create an MVC view.
• Implement strongly typed MVC views.
• Implement partial MVC views
6- Designing for Discoverability
This module describes how to implement the navigational design and also how discoverability will be achieved through
content keywords and page URLs.
• Overview of Search Engine Optimization
• Creating the Robots and Sitemap Files
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Using ASP.NET Routing
-Lab : Designing for Discoverability
• Exercise 1: Mapping URLs of Web Forms Pages
• Exercise 2: Creating a Sitemap File
• Exercise 3: Building the Application Infrastructure
After completing this module, students will be able to:
• Describe the need to optimize the design of a Web site for discoverability by search engines and how the IIS SEO Toolkit
helps in optimization.
• Create robots.txt and sitemap.xml files.
• Use ASP.NET with Web Forms and MVC pages.
7- Writing Server-Side Code for Web Forms
This module describes the advanced features of server-side coding and technologies. The module describes how to allow
the website to move into a global and web farm environment through localization, shared sessions, and custom user
controls. The module will also cover how to use the custom validator and regular expressions.
• Overview of the Structure of a Web Application
• Controlling ViewState
• Localizing a Web Application
• Persisting Data on a Web Forms Page
• Validating User Input
-Lab : Writing Server-Side Code for Web Forms
• Exercise 1: Modifying a Web Forms Page to Display Localized Content
• Exercise 2: Persisting data on a Web Forms Page
• Exercise 3: Exploring Viewstate
• Exercise 4: Adding Validation to Web Forms Pages
After completing this module, students will be able to:
• Describe the structure of a Web application.
• Control ViewState based on performance requirements.
• Localize a Web application by using resource files.
• Describe the techniques used to persist user information. Describe the different technologies used in web farms.
• Validate user input in Web Forms and MVC pages.
8- Optimizing Data Management for Web Forms
This module describes how to optimize and display data management tasks for a Web Forms-based application using
Dynamic Data, Data Binding, LinqToEntities, server side controls, and server-side code.
• Managing Data by Using LINQ to Entities
• Using Data Source Controls
• Using ASP.NET Dynamic Data
-Lab : Optimizing Data Management for Web Forms
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Exercise 1: Managing Data by Using LINQ to Entities
• Exercise 2: Customizing the GridView
• Exercise 3: Using ListView, DetailsView | Charts
• Exercise 4: Managing Data by Using ASP.NET Dynamic Data
After completing this module, students will be able to:
• Use the LINQtoEntities framework to manage data
• Use data source and data bound controls in Web Forms.
• Use ASP.NET Dynamic Data in Web Forms.
9- Ensuring Quality by Debugging, Unit Testing, and Refactoring
This module describes how to perform check-in testing for their Web Forms and MVC applications as well as how to use the
built-in debugging capabilities of VS2010.
• Debugging and Refactoring Code
• Unit Testing Code
• Processing Unhandled Exceptions
• Test Driven Development
-Lab : Debugging, Unit Testing and Refactoring
• Exercise 1: Configuring Error Handling
• Exercise 2: Debugging Code
• Exercise 3: Logging
• Exercise 4: Creating Unit Tests
• Exercise 5: Implementing the Test-First Development Methodology
After completing this module, students will be able to:
• Debug and refactor code
• Unit test code.
• Describe how to log information to a file, database, event or other, including best practices.
• Describe the Test-Driven Development methodology.
10- Securing a Web Application
This module describes how to mitigate common security threats and to implement the essentials (must haves) of Web
security in both MVC and Web Forms applications.
• Configuring Authentication
• Configuring ASP.NET Membership
• Managing Authorization by Using ASP.NET Roles
-Lab : Securing a Web Application
• Exercise 1: Configuring ASP.NET Membership and Roles
• Exercise 2: Authentication
• Exercise 3: Authorization
After completing this module, students will be able to:
• Configure authentication
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Configure ASP.NET Membership
• Manage authorization by using ASP.NET Roles
11- Applying Master Pages and CSS
This module describes how to achieve a consistent UI in a reusable manner.
• Applying Master Pages
• Applying CSS, Skins, and Themes
-Lab : Applying Master Pages and CSS
• Exercise 1: Modify a Master Page
• Exercise 2: Create Nested Master Page
• Exercise 3: Integrating a Master Page
• Exercise 4: Control Skins
• Exercise 5: Applying Styles | Themes
After completing this module, students will be able to:
• Identify challenges in developing a Web application that is compatible across a wide range of browsers and ways to
address these challenges.
• Apply master pages for a consistent application UI.
• Apply CSS for a consistent application UI.
12- Developing Client Side Scripts and Services
This module described how to develop client-side scripts and services for a responsive, rich, and interactive application UI.
• Developing Client-Side Scripts
• Implementing AJAX
• Creating Services
-Lab : Developing Client Side Scripts and Services
• Exercise 1: Creating Client-Side Script
• Exercise 2: Advanced JQuery
• Exercise 3: Creating a WCF Service
After completing this module, students will be able to:
• Develop client-side scripts
• Implement advanced JQuery
• Create services
13- Implementing Advanced AJAX in a Web Application
This module describes the programmatic side of AJAX enabled controls (as well as extending server controls to include AJAX
functionality) on a Web Forms page as well as implementing AJAX on a MVC page
• Implementing Ajax in ASP.NET MVC Pages Using Microsoft Ajax
• Implementing Ajax in ASP.NET MVC Pages Using jQuery
• Working With jQuery and Ajax Events
-Lab : Implementing Advanced Ajax for the AdventureWorks web application
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Exercise 1: Using AJAX in an MVC Page Scenario
• Exercise 2: Using jQuery in an MVC Page
• Exercise 3: Handling jQuery Ajax Events
After completing this module, students will be able to:
• Manage browser history
• Implement AJAX in MVC pages
• Implement jQuery
14- Deploying a Web Application
This module describes how to plan, configure, and perform deployment tasks associated with a production Web site. The
module also describes the Web site lifecycle as it pertains to deployment.
• Overview of Web Application Deployments
• Overview of Web Site Deployments
• Deploying AdventureWorks
-Lab : Deploying AdventureWorks
• Exercise 1: Deploying a Web Application Project Using One-Click Publish
• Exercise 2: Deploying a Web Application Using a Web Deployment Package
• Exercise 3: Deploying a Web Site with the Copy Web Site Tool
• Exercise 4: Deploying a Web Site with the Publish Web Site Utility
After completing this module, students will be able to:
• Identify challenges in deploying Web applications and describe varied target environments.
• Describe Web application compilation methods and tools.
• Transform the web.config file when deploying a Web application
15- Developing a Web Application by Using Silverlight
This module introduce students to Silverlight by having them integrate a Silverlight module into an existing ASP.NET
application. Students will learn how to add a Silverlight project to an existing solution, leverage the existing Web
application by calling a WCF service, and display the information in Silverlight.
• Introduction to Rich Internet Applications
• Overview of Silverlight
• Creating a Silverlight Application
-Lab : Developing a Web Application by Using Silverlight
• Exercise 1: Creating a Silverlight Project
• Exercise 2: Creating a Silverlight WCF Service
• Exercise 3: Displaying Data by Using Silverlight Controls
After completing this module, students will be able to:
• Describe the characteristics of RIAs and the technologies for building them.
• Describe the features of Silverlight, its architecture, and the use of XAML for developing Silverlight applications
• Create a Silverlight application.
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
80290/80401 - Automação de Marketing no Microsoft Dynamics CRM 2011
Carga Horária: 1 dias ou 2 noites
Sobre este curso
Esse curso apresenta como o Microsoft Dynamics CRM deve ser usado para aumentar a eficiência de seu departamento de
marketing e oferecer contexto para o uso de campanhas de marketing, listas de marketing e modelos de campanha no
Microsoft Dynamics CRM. Ele também aborda o papel das atividades de campanha e das listas de marketing nas
campanhas e como associar as especificações, os produtos-alvo e as listas de preços nas campanhas de marketing.
Pré-Requisitos:
Antes de participar desse curso, os alunos devem ter:
• Conhecimento prático geral de gestão do relacionamento com o cliente
• Entendimento geral de processos de negócios
• Conhecimento prático geral do Microsoft Windows
Na conclusão do curso
Ao concluir este curso, os alunos estarão aptos a:
• Examinar os benefícios do marketing de loop fechado
• Criar e usar listas de marketing
• Apresentar campanhas de marketing e campanhas rápidas
• Planejar campanhas de marketing, além de criar e usar modelos
• Importar clientes potenciais
• Associar especificações, produtos-alvo e listas de preços a campanhas de marketing
• Capturar e gerenciar respostas de campanha
• Criar e gerenciar metas de vendas para indivíduos e equipes dentro da organização
• Usar Gráficos Pessoais, Gráficos de Sistema e Painéis para analisar informações de marketing
Perfil do Público-Alvo:
Esse curso destina-se a novos parceiros e clientes do Microsoft Dynamics CRM que desejam conhecer os recursos de
marketing disponíveis no produto Microsoft Dynamics CRM.
Na conclusão do curso
Após concluir este curso, os alunos serão capazes de implementar e configurar os serviços de domínio Active Directory em
seu ambiente corporativo.
Conteúdo Programático
1 - Introdução
• Benefícios do marketing de loop fechado
• Criação e uso de listas de marketing
• Campanhas de marketing e campanhas rápidas
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Campanhas rápidas
• Introdução a campanhas de marketing
• Criação de uma campanha de marketing
• Criação e uso de modelos de campanha
• Importação de clientes potenciais
2 - Implementação e gerenciamento de campanhas de marketing
• Campanhas, atividades da campanha e listas de marketing
• Criação e uso de modelos de email
• Especificações, produtos e listas de preços
• Distribuição de atividades da campanha
• Captura e exibição de respostas de campanha
• Como trabalhar com respostas de campanha
3 - Análise, relatórios e metas
• Análise de informações de marketing com listas, exibições e gráficos
• Como trabalhar com relatórios
• Criação e gerenciamento de metas de marketing
• Criação de gráficos
• Como personalizar e trabalhar com painéis
Exame:
MB2-868: - Microsoft Dynamics CRM 2011 Applications (disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
80291/80402 - Gerenciamento de Vendas no Microsoft Dynamics CRM 2011
Carga Horária: 1 dia / 2 noites
Sobre este curso:
Esse curso apresenta os recursos de gerenciamento de vendas no Microsoft Dynamics CRM que permitem controlar e
gerenciar o processo de vendas desde o contato inicial até a finalização. Ele fornece uma visão sobre o uso do catálogo de
produtos e das informações de vendas do processo. Também apresenta algumas ferramentas usadas para analisar e gerar
relatórios sobre informações de vendas.
Na conclusão do curso
Ao concluir este curso, os alunos estarão aptos a:
• Obter uma compreensão conceitual do processo de vendas do Microsoft Dynamics CRM
• Compreender a função dos principais tipos de registro usados no Gerenciamento de Vendas
• Discutir quando usar clientes potenciais para qualificar ou desqualificar oportunidades
• Usar diálogo de processo para automatizar o gerenciamento de clientes potenciais e oportunidades
• Usar o catálogo de produtos
• Criar listas de preços para campanhas e ofertas especiais
• Criar pedidos, cotações e acompanhar o cumprimento de pedidos
• Usar listas, exibições e gráficos para obter informações de vendas importantes
• Criar painéis e trabalhar com eles
Perfil do Público-Alvo:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Esse curso destina-se a novos parceiros e clientes do Microsoft Dynamics CRM que desejam conhecer os recursos de
vendas disponíveis no produto Microsoft Dynamics CRM.
Pré-Requisitos:
Antes de participar desse curso, os alunos devem ter:
•Conhecimento prático geral de gestão do relacionamento com o cliente
•Entendimento geral de processos de negócios
•Conhecimento prático geral do Microsoft Windows.
Conteúdo Programático:
1 - Introdução
• Visão geral do processo de vendas no Microsoft Dynamics CRM
• Registros principais no processo de vendas
• Acompanhamento de concorrentes e gerenciamento de especificações
• Como trabalhar com clientes potenciais
• Como trabalhar com oportunidades
• Processos de vendas, fluxos de trabalhos e caixas de diálogo
2 - Como trabalhar com o catálogo de produtos
• O catálogo de produtos e o processo de vendas
• Grupos de unidades
• Adição e manutenção de produtos
• Criação, manutenção e uso de listas de preços
3 - Processamento de ordens de venda
• O processo de pedido de venda do Microsoft Dynamics CRM
• Oportunidades, cotações e processo de vendas
• Como trabalhar com pedidos
• Como trabalhar com faturas
4 - Análise, relatórios e metas
• Análise de informações de vendas com listas, exibições e gráficos
• Como trabalhar com relatórios
• Exportação de informações de vendas para o Microsoft Office Excel
• Criação e gerenciamento de metas de vendas
• Criação de gráficos
• Painéis
Exame:
MB2-868: - Microsoft Dynamics CRM 2011 Applications (disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
80292/80407 - Gerenciamento de Serviço no Microsoft Dynamics CRM 2011
Carga Horária: 1 dia ou 2 noites
Sobre este curso:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Esse curso apresenta a funcionalidade do serviço de gerenciamento do Microsoft Dynamics CRM e explica como ela ajuda
as organizações a controlarem informações sobre casos, reclamações ou solicitações de cliente e projetos pequenos. Ele
ensina como usar a Base de Dados de Conhecimento e aborda a forma como as organizações podem procurar, localizar e
compartilhar informações neste repositório. Além disso, ele aborda a criação, o gerenciamento e o uso de equipes e filas no
Microsoft Dynamics CRM.
Na conclusão do curso
Ao concluir este curso, os alunos estarão aptos a:
• Usar alguns dos aplicativos de gerenciamento de serviços mais comuns de Filas e Contratos.
• Trabalhar com ocorrências na grade de ocorrências.
• Compreender as etapas necessárias para a criação de uma nova ocorrência.
• Criar e gerenciar modelos de contrato.
• Criar e gerenciar contratos.
• Adicionar linhas de contrato a um contrato.
• Associar contratos a ocorrências.
• Criar, ativar, desativar e excluir modelos de artigo da Base de Dados de Conhecimento.
• Pesquisar artigos com base em um registro de ocorrência e utilizar artigos para solucionar ocorrências.
• Criar equipes, gerenciá-las e trabalhar com elas.
• Definir etapas envolvidas na criação e no gerenciamento de filas.
• Trabalhar com itens de fila.
• Criar gráficos e painéis pessoais e de sistema para proporcionar melhor compreensão sobre informações importantes de
gerenciamento de serviços.
Perfil do Público-Alvo:
Esse curso destina-se a novos parceiros e clientes do Microsoft Dynamics CRM que desejam conhecer os recursos de
gerenciamento de serviços disponíveis no produto Microsoft Dynamics CRM.
Pré-Requisitos:
Antes de participar desse curso, os alunos devem ter:
• Conhecimento prático geral de gestão do relacionamento com o cliente
• Entendimento geral de processos de negócios
• Conhecimento prático geral do Microsoft Windows.
Conteúdo Programático:
1 - Introdução
• Introdução ao gerenciamento de serviços
• Ocorrências e o processo de gerenciamento de serviços
• Filas e contratos no gerenciamento de serviços
• Como trabalhar com ocorrências na grade de ocorrências
2 - Como trabalhar com ocorrências e contratos
• Criação de registros de ocorrências
• Como trabalhar com ocorrências
• Contratos e modelos de contrato
• Como criar e trabalhar com contratos
• Uso de contratos com ocorrências
3 - Uso da Base de Dados de Conhecimento
• Modelos de artigo
• Criação, aprovação e publicação de artigos
• Como usar e pesquisar a Base de Dados de Conhecimento
• Ocorrências e artigos da Base de Dados de Conhecimento
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
4 - Como trabalhar com equipes e filas
• Introdução a equipes
• Introdução a filas
• Criação e gerenciamento de filas
• Como trabalhar com filas e itens da fila
• Uso de fluxos de trabalho com filas
5 - Análise, relatórios e metas
• Relatórios de Gerenciamento de Serviços
• Gráficos e painéis de gerenciamento de serviços
• Gerenciamento de metas para serviço
Exame:
MB2-868: - Microsoft Dynamics CRM 2011 Applications (disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
80293/80410 - Agendamento de Serviço no Microsoft Dynamics CRM 2011
Carga Horária: 1 dia ou 2 noites
Sobre este curso
Esse curso aborda detalhadamente o processo de agendamento, o mecanismo de agendamento e as atividades de serviço
de agendamento, pois esses tópicos são importantes pontos de entrada no processo de agendamento. Ele também trata do
uso do agendamento de serviço em situações que apresentam requisitos de agendamento complexos.
Na conclusão do curso
Ao concluir este curso, os alunos estarão aptos a:
• Identificar os principais conceitos de agendamento de serviço
• Comparar os cenários comerciais de agendamento de serviço
• Entender o fluxo do processo de agendamento de serviço
• Configurar agendas de trabalho para usuários, instalações ou um equipamento
• Fechar, cancelar ou reagendar uma atividade de serviço
• Saber como registros de atividade de serviço são sincronizados com o Microsoft Office Outlook
• Incorporar preferências do cliente ao agendar atividades de serviço
Perfil do Público-Alvo
Esse curso destina-se a novos parceiros e clientes do Microsoft Dynamics CRM que desejam conhecer os recursos de
agendamento de serviços disponíveis no produto Microsoft Dynamics CRM.
Pré-Requisitos:
Antes de participar desse curso, os alunos devem ter:
• Conhecimento prático geral de gestão do relacionamento com o cliente
• Entendimento geral de processos de negócios
• Conhecimento prático geral do Microsoft Windows.
Conteúdo Programático:
1 - Introdução
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Visão geral do agendamento de serviços
• Cenários de agendamento de serviços
• Processo de agendamento de serviços
• Como trabalhar com atividades de serviço e o calendário de serviços
• Fechar, cancelar ou reagendar uma atividade de serviço
• Utilização de gráficos e relatórios para analisar as atividades de serviço
2 - Tópicos avançados
• Noções básicas sobre o mecanismo de agendamento de atividades de serviço
• Recursos, serviços e regras de seleção
• Incorporação de preferências do cliente
• Requisitos de capacidade de serviço e de recursos
• Noções básicas sobre locais e requisitos de mesmo local
Exame:
MB2-868: - Microsoft Dynamics CRM 2011 Applications (disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
80294/80382 - Personalização e Configuração do Microsoft Dynamics CRM 2011
Carga Horária: 3 dias ou 6 noites
Sobre este Curso:
Esse curso descreve as técnicas necessárias à personalização do Microsoft Dynamics CRM para atender às necessidades
especializadas de negócios. Os tópicos abordados incluem: segurança; criação e configuração de entidades; criação de
exibições de formulário e gráficos; execução de auditoria e soluções. O curso descreve cada tópico e como cada um deles
se relaciona com outros tópicos para produzir uma solução eficiente e totalmente configurada.
Na conclusão do curso:
Ao concluir este curso, os alunos estarão aptos a:
• Projetar e implementar estratégias de criação de Unidades de Negócios e Funções de Segurança
• Criar e configurar Usuários e Equipes do Microsoft Dynamics CRM
• Descrever os princípios de personalização do sistema
• Criar e configurar campos para entidades personalizadas e de sistema
• Criar e configurar entidades personalizadas, inclusive entidades padrão e de atividade
• Projetar, criar e configurar relacionamentos entre entidades
• Criar e configurar Exibições, Gráficos e Formulários para entidades personalizadas e de sistema
• Implementar a segurança de campo no Microsoft Dynamics CRM
• Configurar e monitorar a auditoria nos componentes do Microsoft Dynamics CRM
• Projetar, criar e configurar Soluções no Microsoft Dynamics CRM; implementação de Soluções gerenciadas e não
gerenciadas
Perfil do Público-Alvo:
Esse curso destina-se tanto a novos quanto a experientes personalizadores do Microsoft Dynamics CRM que estão
familiarizados com os princípios de software do usuário final. Nenhuma habilidade de programação é necessária, mas um
entendimento básico dos princípios de bancos de dados será benéfico.
Pré-Requisitos:
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
Um conhecimento prático sobre como usar o Microsoft Dynamics CRM 2011. É recomendável, mas não obrigatório, que os
indivíduos tenham concluído o treinamento dos aplicativos do Microsoft Dynamics CRM 2011. Como esse material de
treinamento enfatiza a personalização de entidades de bancos de dados, atributos, relacionamentos e mapeamentos, é
recomendável que os indivíduos tenham uma compreensão básica da funcionalidade do Microsoft SQL Server e do banco
de dados relacional.
Conteúdo Programático:
1 - Unidades de negócios e funções de segurança
• Unidades de Negócios
• Gerenciamento de unidades de negócios
• Recursos de segurança
2 - Configuração de usuários e equipes
• Visão geral do gerenciamento de usuários
• Adição e manutenção de contas de usuário
• Configuração da equipe
3 - Visão geral da personalização do Microsoft Dynamics CRM
• Metodologia de personalização
• Quem pode personalizar o Microsoft Dynamics CRM?
• Tipos de personalizações
• Tipos de personalizações — Soluções
4 - Personalização de campos
• Conceitos de personalização
• Tipos de dados de campo
• Propriedades do campo
• Criação de campos
• Criação de conjuntos de opções
5 - Personalização de entidades
• Conceitos de entidade
• Modificação de entidades personalizadas
6 - Personalização de relacionamentos e mapeamentos
• Tipos de relacionamentos entre entidades
• Criação de relacionamentos entre entidades
• Mapeamento de entidades
7 - Personalização de formulários, exibições e gráficos
• Recursos básicos de personalização da interface do usuário
• Visão geral da personalização de exibições
• Gráficos
• Visão geral da personalização de formulários
• Outros objetos de formulário
• Criação de novos formulários
8 - Configuração da segurança de campo
• Escopo da segurança de campo
• Segurança de campo e outros métodos de segurança
9 - Configuração de auditoria
• Habilitação da auditoria
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br
• Exibição de dados de auditoria
• Gerenciamento de partições de auditoria
10 - Configuração de soluções
• Revisão das soluções
• Exportação e importação de soluções não gerenciadas
• Exportação e importação de soluções gerenciadas
Exame:
MB2-866: - Microsoft Dynamics CRM 2011 Applications (disponível em português)
Horário dos cursos:
Integral - 08:30 às 17:30h
Sábado - 08:30 às 17:30h
Noturno - 18:30 às 22:30h
Green Treinamento - Av. Paulista, 326, 12º andar, Bela Vista, São Paulo-SP
Fone: (11) 3253-5299 / Fax: (11) 3253-3541 | Visite nosso site: www.green.com.br