Microsoft SQL Server 2000 Development


Developing Databases with Microsoft SQL Server 2000, Level 2

The first part of Level 2 focuses on programming. You’ll learn how to create Transact SQL queries and such more advanced features such as transaction processing. 

All 3 levels
Cost: $1,399 + GST
 
Then you will learn techniques for writing stored procedures and triggers. You’ll learn how to optimally configure Microsoft SQL Server and use techniques for backing up your data. This level also focuses on topics that are relevant to security, optimization and tuning.

What's new in the Query Analyzer
  • Object Browser
  • Debugging tools
  • Query Analyzer Features

Programming with T-SQL

  • Overview of Transact-SQL
  • Built-in Functions
  • System Functions
    @@IDENTITY
    @@ERROR, etc.
  • Error Handling
  • Flow of Control

Transaction Processing

  • Implicit Transactions
  • Explicit Transactions
  • Working with Locks
  • Monitoring Processes and Locks
  • Isolation Levels
  • Blocking and Deadlocks

Building Views

  • Complex Joins
  • Pre-Aggregate Data
  • Indexed Views
  • Partitioned Views

 

Maintaining and Backing up SQL Server
  • Backup and Restore
  • Creating a Backup Strategy
  • Implementing Backups
  • Database Maintenance Plan Wizard
  • Restoring from a Backup

Building Stored Procedures and Triggers

  • Building Stored Procedures
    Parameters
    Temp tables
    Cursors
  • Building Triggers
    Enforce Business Rules
    Send Alerts
    AFTER Triggers
    INSTEAD OF Triggers
 Building User-Defined Functions
  • Scalar functions
  • Inline table-valued functions
  • Multi-statement table-valued functions
  • The TABLE Data Type
  • Putting it All Together
    When to use a view, function, stored procedure

Advanced Queries/Linked Servers

  • Advanced Queries
    Handling Text & Image Datatypes
    Handling Large Data Sets
  • Distributed Queries-Linked Servers
    OPENROWSET
    OPENQUERY

Security

  • Authentication
  • Roles
  • Permissions
  • Application Roles
  • Windows 2000/Kerberos

Monitoring, Tuning and Configuration

  • Showplan
  • Index Tuning Wizard
  • Using the Profiler
  • Using System Monitor
  • Factors for a Well-Tuned Application
  • Understanding Caching