2073 Programming a Microsoft SQL Server 2000 Database

Curso

En Tijuana

Precio a consultar

Descripción

  • Tipología

    Curso

  • Lugar

    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.

Instalaciones y fechas

Ubicación

Inicio

Tijuana (Baja California)
Ver mapa
Blvd Agua Caliente, 10470-3b, 22420

Inicio

Consultar

Preguntas & Respuestas

Plantea tus dudas y otros usuarios podrán responderte

¿Quién quieres que te responda?

Sólo publicaremos tu nombre y pregunta

Materias

  • 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

Llama al centro

¿Necesitas un coach de formación?

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

2073 Programming a Microsoft SQL Server 2000 Database

Precio a consultar