Course code: MOC 2073« Back

Programming a Microsoft SQL Server 2000 Database

At the end of the course, students will be able to describe the elements of SQL Server 2000; design a SQL Server enterprise application architecture; describe the conceptual basis of programming in Transact-SQL; create and manage databases and their related components; implement data integrity by using the IDENTITY column property, constraints, defaults, rules, and unique identifiers; plan for the use of indexes; create and maintain indexes; create, use, and maintain data views; implement user-defined functions; design, create, and use stored procedures; create and implement triggers; program across multiple servers by using distributed queries, distributed transactions, and partitioned views; optimize query performance; analyze queries; and manage transactions and locks to ensure data concurrency and recoverability.

This course has been removed from our portfolio
This section contains overview of retired courses which don’t belong to GOPAS course offer any more or were replaced by new course versions.
For more information about possibility to buy retired courses contact our customer services department (__Klientskyservis@gopas.cz) or business department (__Obchod@gopas.cz).

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 24 950 CZK included in course price 50
Brno5 24 950 CZK included in course price 50
Bratislava5 625,00 EUR 268,00 EUR 50

Who is the course for

This course is for IT professionals responsible for implementing or administering solutions based on Microsoft SQL Server™ 2000.

What we teach you

  • Describe the elements of SQL Server 2000
  • Design a SQL Server enterprise application architecture
  • Describe the conceptual basis of programming in Transact-SQL
  • Create and manage databases and their related components
  • Implement data integrity
  • Plan for the use of indexes, create and maintain indexes
  • Create, use, and maintain data views, stored procedures, triggers and user-defined functions
  • Program across multiple servers by using distributed queries
  • Analyze and optimize query performance
  • Manage transactions and locks to ensure data concurrency and recoverability

Required skills

  • Configure the Windows 2000 environment.
  • Understanding of basic relational database concepts
  • Logical and physical database design
  • Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).

Teaching methods

Expert instruction with practical examples, computer practice

Teaching materials

The student materials include comprehensive courseware and other necessary materials for this class. All reading materials are in English and are not included in the course price.

Course Outline

SQL Server Overview

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

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

Creating and Managing Database

  • Creating Databases
  • Creating Filegroups
  • Managing Databases
  • Introduction to Data Structures

Creating Data Types and Tables

  • Creating Data Types
  • Creating Tables
  • Generating Column Values
  • Generating Scripts

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

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

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

Implementing Views

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

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

Implementing User-defined Functions

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

Implementing Triggers

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

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

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

Analyzing Queries

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

Managing Transactions and Locks

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

Previous courses

no preceding courses

Next courses

no following course
Tištěná příručka MOC 2073

Price:
6950 CZK
Tištěná příručka MOC 2073

Price:
268 EUR
The prices are without VAT.