2073 Programming a Microsoft SQL Server 2000 Database

Capacitacion Eficaz
En Tijuana

Consultar precio
¿Quieres hablar con un asesor sobre este curso?
Compara este curso con otros similares
Ver más cursos similares

Información importante

  • 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

¿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


Compara este curso con otros similares
Ver más cursos similares