| Sign in | Sitemap | Feedback
Go To AppexTech

Microsoft SQL Server 2000

1 Hour Daily

Duration:- ... Months

Appextech Introduction to SQL Server 2000 training teaches attendees the skills they need to successfully build, administer, and query Microsoft SQL Server 2000 databases.

Microsoft SQL Server 2000 Training Objectives

All attendees will learn to:

  1. Use the programming environment in the Query Analyzer and learn the Transact-SQL language.
  2. Understand the differences between view, stored procedures, triggers, and user-defined functions, and know the advantages and drawbacks of each.
  3. Design and implement reliable backup and maintenance plans.
  4. Understand the SQL Server security model; and create logins, users and permissions to protect your data.
  5. Configure and tune SQL Server, and monitor database activity

Microsoft SQL Server 2000 Training Outline

  1. SQL Server Tour
    1. SQL Server Editions
    2. Graphical Tools
    3. Exploring the Enterprise Manager
    4. Working with SQL Server Books Online
  2. Installing SQL Server
    1. Multiple Instances
    2. Installing an Instance of SQL Server
    3. Configuring the Server
  3. Designing and Creating a Database
    1. Relational Database Design Principles
    2. Implementing the Design
  4. Basic Querying
    1. Introduction to the Query Analyzer
    2. Retrieving Data
    3. Joining Tables
  5. Action Queries
    1. Modifying Data
    2. Inserting Data
    3. Updating Data
    4. Deleting Data
  6. Using the Query Analyzer
    1. Query Analyzer Features
    2. The File Menu Items
    3. The Edit Menu
    4. Query Menu Items
    5. Tools Menu Items
    6. Window Menu Items
    7. Help Menu Items
    8. Programming With Transact-SQL
    9. Overview of Transact-SQL
    10. Using Built-In Functions
  7. Programming With Transact-SQL
    1. Control of Flow
    2. Error Handling
  8. Transaction Processing
    1. Transactions
    2. Working with Locks
    3. Monitoring Processes and Locks
    4. Transaction Isolation
    5. Blocking and Deadlocks
  9. Creating Views
    1. What is a View?
    2. Creating Views
    3. Updating Views
  10. Backups and Maintenance
    1. Creating a Backup Strategy
    2. Implementing Backups
    3. Restoring from a Backup
    4. The Database Maintenance Plan Wizard
  11. Stored Procedures and Triggers
    1. Building Stored Procedures
    2. Building Triggers
    3. Using INSTEAD OF Triggers
    4. User-Defined Functions
    5. User-Defined Functions in SQL Server 2000
    6. Scalar Functions
    7. Inline Table-Valued Functions
    8. Multi-Statement Table-Valued Functions
    9. Functions, Views, and Stored Procedures
  12. Advanced Queries and Linked Servers
    1. Dynamic SQL
    2. Transact-SQL Cursors
    3. Handling Large Data Sets
    4. Distributed Queries
  13. Security
    1. Security Overview
    2. Authentication
    3. Understanding Roles
    4. Assigning Permissions
    5. Application Roles
  14. Monitoring, Tuning, and Configuration
    1. Evaluating Performance
    2. Monitoring with SQL Server Profiler
    3. Tuning Queries
    4. Working with Indexes
    5. Indexed Views
    6. Using the Index Tuning Wizard
    7. Data Caching
    8. The System Monitor
  15. Using System Objects
    1. Exploring System Objects
    2. DBCC
  16. Automating Administration with SQL Agent
    1. Configuring SQL Server Agent
    2. Operators
    3. Jobs
    4. Alerts
    5. Create an Alert

Database Training