Home    
Idioma:   
Español Change Language
  Moneda:   
EUA Change Country
  >> Quiero Registrarme      
    Login
¿Ha olvidado
su contraseña? 		 
   Cursos en línea
  Cursos disponibles
  Certificación Microsoft
  Antivirus y Seguridad
  Banco de Datos
  Cursos de Office 2000
  Cursos de Office 2003
  Cursos de Office 2007
  Cursos de Office XP
  Escritorio
  Internet
  Lotus Notes
  Para Niños
  Para Principiantes
  Programación
  Redes
  Servidores
  Windows
     Sus Comentarios
     Soporte
    Cursos Presenciais
    Vea más
   Certificación
  ¿qué es?
  Programa MCP
  Exámenes
  Simulados
    La nueva generación
    El Empresa
  Quién Somos
    E-learning Corporativo
  IT Consulting
  Outsourcing
  Reconocimiento
  Casos de E-Learning
  Responsabilidad Social
  Contáctenos
Ka Solution Tecnologia
em Software Ltda.
Copyright © 2000
All rights reserved.
  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

Precio:

US$118.10

Tarjeta de Crédito Internacional
Matricular
Contenido en línea disponible durante 3 mes para cada entrenamiento, a partir del 1º acceso
Formas de Pago
  • Tarjeta de Crédito Internacional


    • Obs.: Optando por la forma de pago a través de tarjeta de crédito, deberán ser enviadas las copias de esos documentos: NIF, DNI y el frente de la tarjeta de crédito.
    Idioma
     Course in English
    Carga horaria
    6 horas
    Demostración
    * Exchange Server 2003
    * Sólo ejemplo sin ninguna referencia al contenido elegido.
    Contenido
    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
    Descarga del curso para la visualización offline sin el uso de la impresión.
    Certificado
    O certificado de conclusão do curso, estará liberado para impressão ao termino do curso.
    Requisitos del 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 del 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 ...
    US$35.60
    Programming Microsoft SQL Server 2005
    This course will enable database developers ...
    US$118.10
    Installing and Upgrading to Microsoft Exchange Server 2003
    In this course, you install and upgrade to ...
    US$53.10
    Configuring and Managing Microsoft Exchange Server 2003
    In this course, you configure and manage Exchange ...
    US$53.10
    Introduction to Microsoft Office SharePoint Server 2007
    In this online learning course, you will learn ...
    US$47.50