2073 Programming a Microsoft SQL Server 2000 Database

Capacitacion Eficaz
En Tijuana

Consultar precio
¿Quieres hablar con un Asesor sobre este curso?

Información importante

Tipología Curso
Inicio Tijuana
  • Curso
  • Tijuana
Descripción

Objetivo del curso: This course provides students with the technical skills required to program a database solution by using Microsoft® SQL Server? 2000.

Información importante
Instalaciones

Dónde se imparte y en qué fechas

Inicio Ubicación
Consultar
Tijuana
Blvd Agua Caliente, 10470-3b, 22420, Baja California, México
Ver mapa
Inicio Consultar
Ubicación
Tijuana
Blvd Agua Caliente, 10470-3b, 22420, Baja California, México
Ver mapa

¿Qué aprendes en este curso?

SQL

Programa académico

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

Logros de este Centro


Los usuarios que se interesaron por este curso también han mostrado interés por...
Ver más cursos similares