2073 Programming a Microsoft SQL Server 2000 Database
Curso
En Tijuana
¿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
Objetivo del curso: This course provides students with the technical skills required to program a database solution by using Microsoft® SQL Server? 2000.
Sedes y fechas disponibles
Ubicación
Inicio
Inicio
Opiniones
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
¿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.
2073 Programming a Microsoft SQL Server 2000 Database