Programming a Ms SQL Server 2000 Db (3-10 Pm)

Name: Programming a Ms SQL Server 2000 Db (3-10 Pm)
Brand: Capacitacion Eficaz - Tijuana, BC,
Price: 7950 MXN

Capacitacion Eficaz - Tijuana, BC,

Curso

En Tijuana, Baja California

$ 7,950 IVA inc.

Llama al centro

(664) 634-3168

¿Necesitas un coach de formación?

Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.

Descripción

Tipología

Curso
Lugar

Tijuana, baja california

Horas lectivas

40h

Objetivo del curso: El Curso provee al estudiante la habilidad y técnicas requeridas para programar soluciones en la Base de Datos usando Microsoft SQL Server? 2000. Destinatarios del curso: A responsables y administradores de Bases de Datos

Sedes y fechas disponibles

Tijuana, Baja California (Baja California)

Blvd. Sanchez Taboada # 10116-105 Plaza Ejecutiva Del Rio, 22320

Inicio

Consultar

Acerca de este curso

Requisitos

Cursos 2151 y 2152 ó Curso 2072

Preguntas & Respuestas

Añade tu pregunta

Nuestros asesores y otros usuarios podrán responderte

¿Quién quieres que te responda?

Todos
Alumnos
Centro

Déjanos tus datos para recibir respuesta

Sólo publicaremos tu nombre y pregunta

Opiniones

Materias

Programa académico

Overview: This course provides students with the technical skills required to program a database solution by using Microsoft® SQL Server™ 2000. Lesson 1: SQL Server Overview

What Is SQL Server?
SQL Server Integration
SQL Server Databases
SQL Server Security
Working with SQL Server

Lesson 2: Overview of Programming SQL Server

Designing Enterprise Application Architecture
SQL Server Programming Tools
The Transact-SQL Programming Language
Elements of Transact-SQL
Additional Language Elements
Ways to Execute Transact-SQL Statement

Lesson 3: Creating and Managing Databases

Creating Databases
Creating Filegroups
Managing Databases
Introduction to Data Structures

Lesson 4: Creating Data Types and Tables

Creating Data Types
Creating Tables
Generating Column Values
Generating Scripts

Lesson 5: Implementing Data Integrity

Types of Data Integrity
Enforcing Data Integrity
Defining Constraints
Types of Constraints
Disabling Constraints
Using Defaults and Rules
Deciding Which Enforcement Method to Use

Lesson 6: Planning Indexes

Introduction to Indexes
Index Architecture
How SQL Server Retrieves Stored Data
How SQL Server Maintains Index and Heap Structures
Deciding Which Columns to Index

Lesson 7: Creating and Maintaining Indexes

Creating Indexes
Creating Index Options
Maintaining Indexes
Introduction to Statistics
Querying the sysindexes Table
Setting Up Indexes Using the Index Tuning Wizard
Performance Considerations

Lesson 8: Implementing Views

Introduction to Views
Advantages of Views
Defining Views
Modifying Data Through Views
Optimizing Performance by Using Views
Performance Considerations

Lesson 9: Implementing Stored Procedures

Introduction to Stored Procedures
Creating, Executing, Modifying, and Dropping Stored Procedures
Using Parameters in Stored Procedures
Executing Extended Stored Procedures
Handling Error Messages
Performance Considerations

Lesson 10: Implementing User-defined Functions

What Is a User-defined Function?
Defining User-defined Functions
Examples of User-defined Functions

Lesson 11: Implementing Triggers

Introduction to Triggers
Defining Triggers
How Triggers Work
Examples of Triggers
Performance Considerations

Lesson 12: Programming Across Multiple Servers

Introduction to Distributed Queries
Executing an Ad Hoc Query on a Remote Data Source
Setting Up a Linked Server Environment
Executing a Query on a Linked Server
Managing Distributed Transactions
Modifying Data on a Linked Server
Using Partitioned Views

Lesson 13: Optimizing Query Performance

Introduction to the Query Optimizer
Obtaining Execution Plan Information
Using an Index to Cover a Query
Indexing Strategies
Overriding the Query Optimizer

Lesson 14: Analyzing Queries

Queries That Use the AND Operator
Queries That Use the OR Operator
Queries That Use Join Operations

Lesson 15: Managing Transactions and Locks

Introduction to Transactions and Locks
Managing Transactions
SQL Server Locking
Managing Locks

Llama al centro

(664) 634-3168

¿Necesitas un coach de formación?

Te ayudará a comparar y elegir el mejor curso para ti y a financiarlo en cómodas cuotas mensuales.

Programming a Ms SQL Server 2000 Db (3-10 Pm)

$ 7,950 IVA inc.

Contáctanos

Programming a Ms SQL Server 2000 Db (3-10 Pm)

Preguntas & Respuestas

Opiniones

Materias

Programa académico

Añade cursos similares
y compáralos para elegir mejor.

Programming a Ms SQL Server 2000 Db (3-10 Pm)

Preguntas & Respuestas

Opiniones

Materias

Programa académico

Añade cursos similaresy compáralos para elegir mejor.

Añade cursos similares
y compáralos para elegir mejor.