Home    
Idioma:   
Português Change Language
  Moeda:   
Brasil Change Country
  >> Quero me cadastrar      
    Login
Esqueceu sua senha?  
   Cursos online
  Cursos disponíveis
  Certificação Microsoft
  AntiVírus e Segurança
  Banco de Dados
  Cursos de Office 2000
  Cursos de Office 2003
  Cursos de Office 2007
  Cursos de Office XP
  Desktop
  Internet
  Lotus Notes
  Para Crianças
  Para Iniciantes
  Programação
  Redes
  Servidores
  Windows
     Seus Comentários
     Suporte
    Cursos Presenciais
    Veja mais
   Certificação
  O que é
  Programa MCP
  Exames
  Simulados
    A nova geração
    A Empresa
  Quem Somos
    E-learning Corporativo
  IT Consulting
  Outsourcing
  Reconhecimento
  Cases de e-learning
  Responsabilidade Social
  Oportunidades
    Localização
  Contato
Copyright © 2000 Ka Solution Todos os direitos reservados.
  Home >  Microsoft E-Learning
Course 2939: Programming Microsoft SQL Server 2005

This course will enable database developers experienced in SQL Server 2000/7.0 and Analysis Services to upgrade their skills to SQL Server 2005. The course is broken into three modules:

  • Working with SQL Server 2005
  • Exploring Transact-SQL Enhancements in SQL Server 2005
  • Exploring the Use of XML in SQL Server 2005

Preço:
6x de
R$ 31,50

no cartão de crédito
Clique aqui para matricular-se
Conteúdo online disponível durante 3 Meses para cada treinamento, a partir do 1º acesso.
Formas de Pagamento
  • Cheques Pré-Datados - 3x sem juros
  • Boleto Bancário Bradesco - a vista
  • Boleto Bancário Itaú - a vista
  • Cartão Visa - a vista
  • Cartão Mastercard - a vista
  • Cartão Amex - a vista
  • Transferência Eletrônica de Fundos Itaú - a vista
  • Cartão Visa - 6x sem juros
  • Cartão Mastercard - 6x sem juros
  • Pagamento Fácil Bradesco - Cartão de Débito - a vista
    Observação: Optando pela forma de pagamento Cartão de Débito deverá ser enviado o comprovante de pagamento. O curso será liberado após a confirmação do pagamento (48 horas).


    • Obs.: Optando pela forma de pagamento através de cartão de crédito, deverão ser enviadas as cópias desses documentos: CPF, RG e a frente do cartão de crédito.
    Idioma
     Course in English
    Carga horária
    6 horas
    Demonstração
    * Exchange Server 2003
    * Apenas exemplo sem qualquer referência ao conteúdo escolhido
    Conteúdo
    Course Overview
    Module Introduction
    How to Use This Course
    Course Information
    Working with SQL Server 2005
    Module Introduction
    Exploring Components and Features
    Lesson Introduction
    SQL Server 2005 Components
    New Features for Database Administrators
    New Features for Database Developers
    Self Test
    Using the SQL Server 2005 Developer Tools
    Lesson Introduction
    SQL Server 2005 Developer Tools
    What Is SQL Server Management Studio?
    How to Execute a Query
    How to Use Object Explorer
    How to Create a SQL Server Solution
    Self Test
    Implementing the Security Features in SQL Server 2005
    Lesson Introduction
    SQL Server 2005 Security Architecture
    Using Schemas to Manage Security
    Self Test
    Lab: Exploring SQL Server 2005
    Lesson Introduction
    Scenario
    Exercises
    Lab Review
    Module Summary
    Exploring Transact-SQL Enhancements in SQL Server 2005
    Module Introduction
    Using Data Definition Language Enhancements
    Lesson Introduction
    Enhanced Data Definition Language Statements
    New and Enhanced Data Types
    What Is a Partitioned Table?
    Steps for Partitioning a Table
    How to Create a Partitioned Table
    Enhanced Indexing Features
    Self Test
    Using Data Manipulation Language Enhancements
    Lesson Introduction
    How to Use the OUTPUT Keyword
    How to Use Common Table Expressions
    How to Create Recursive Common Table Expressions
    Using the PIVOT and UNPIVOT Operators
    How to Use the APPLY Operator
    How to Use Ranking Functions
    Self Test
    Using Structured Exception Handling
    Lesson Introduction
    What Is Structured Exception Handling?
    Using TRY...CATCH Constructs
    How to Use Structured Exception Handling
    Self Test
    Lab: Programming with Transact-SQL
    Lesson Introduction
    Scenario
    Exercises
    Lab Review
    Module Summary
    Exploring the Use of XML in SQL Server 2005
    Module Introduction
    Using XML Enhancements in SQL Server 2005
    Lesson Introduction
    Enhancements to the FOR XML Clause
    How to Use the FOR XML Clause
    Enhancements to the OPENXML Function
    How to Use the OPENXML Function
    Self Test
    Using the xml Data Type
    Lesson Introduction
    Storing XML in the Database
    How to Use Untyped XML
    Managing XML Schemas
    How to Use Typed XML
    Managing XML Indexes
    Self Test
    Using XQuery
    Lesson Introduction
    What Is XQuery?
    How to Use XQuery Expressions
    Querying XML with xml Data Type Methods
    Modifying XML with the modify Method
    Shredding XML with the nodes Method
    How to Use xml Data Type Methods
    Self Test
    Lab: Working with XML
    Lesson Introduction
    Scenario
    Exercises
    Lab Review
    Module Summary
    Material
    Download do curso para visualização em offline sem o uso de impressão.
    Certificado
    O certificado de conclusão do curso, estará liberado para impressão ao termino do curso.
    Requisitos de Sistema
    A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
    Microsoft® Windows® 2000 or higher
    Microsoft Internet Explorer 6.0 with SP1
    Macromedia Flash 7.0 or higher (1MB disk space needed to install)
    Microsoft Virtual Server ActiveX control (required for virtual labs; 1MB disk space needed to install)
    Microsoft Windows Media Player 7.0 or higher
    Microsoft XML Core Services 3.0 or higher
    A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
    A sound card, speakers, or headphones are recommended.
    Internet bandwidth of 56K or faster. Broadband is recommended.
    Requisitos de Acessibilidade
  • Microsoft Internet Explorer 5.0 or higher
  • Window-Eyes from GS Micro
  • JAWS from Freedom Scientific
  • MSAA enabled
    • Voltar Indique este curso
    Core Training for Microsoft Office Project 2003
    This course introduces the basic features and ...
    R$57,00
    Programming Microsoft SQL Server 2005
    This course will enable database developers ...
    R$189,00
    Installing and Upgrading to Microsoft Exchange Server 2003
    In this course, you install and upgrade to ...
    R$85,00
    Configuring and Managing Microsoft Exchange Server 2003
    In this course, you configure and manage Exchange ...
    R$85,00
    Introduction to Microsoft Office SharePoint Server 2007
    In this online learning course, you will learn ...
    R$76,00