Microsoft SQL Server 2000 Database Design and Implementation (2073) training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Microsoft SQL Server 2000 Database Design and Implementation (2073)  

 Email information about this seminar Microsoft SQL Server 2000 Database Design and Implementation (2073) by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft SQL Server 2000 Database Design and Implementation (2073) by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for Database administrators, Database analysts, and Database developers.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This course will provide students with the technical skills required to program a database solution by using Microsoft SQL Server 2000. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

microsoft+sql+database+design training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Microsoft SQL Server 2000 Database Design and Implementation (2073) seminar

 

 

Training Course Syllabus:


Description
This course provides students with the technical skills required to program a database solution by using Microsoft SQL Server 2000.

Audience
Database administrators, Database analysts, Database developers

Objectives
·  At the end of the course student will be able to describe the elements of SQL Sever 2000
·  Design a SQL Server enterprise application architecture
·  Describe the conceptual basis of programming in Trasact-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
·  Manage transactions and locks to ensure data concurrency and recoverability

Required Prerequisites
 ·  Implementing Microsoft Windows 2000 Professional and Server (2152)
 ·  Microsoft SQL Server 2000 System Administration (2072)
 ·  Microsoft Windows 2000 Network and Operating System Essentials (2151)

Exams
 ·  70-229 : Microsoft SQL Server 2000 Database Design and Implementation

Next Steps
 ·  Introduction to Oracle: SQL & PL/SQL
 ·  Develop PL/SQL Program Units
 ·  Build Internet Applications I
 ·  Build Internet Applications II

Outline
    1. SQL Server Overview
      1. What Is SQL Server?
      2. SQL Server Integration
      3. SQL Server Databases
      4. SQL Server Security
      5. Working with SQL Server
    2. Overview of Programming SQL Server
      1. Designing Enterprise Application Architecture
      2. SQL Server Programming Tools
      3. The Transact-SQL Programming Language
      4. Elements of Transact-SQL
      5. Additional Language Elements
      6. Ways to Execute Transact-SQL Statement
    3. Creating and Managing Databases
      1. Creating Databases
      2. Creating Filegroups
      3. Managing Databases
      4. Introduction to Data Structures
    4. Creating Data Types and Tables
      1. Creating Data Types
      2. Creating Tables
      3. Generating Column Values
      4. Generating Scripts
    5. Implementing Data Integrity
      1. Types of Data Integrity
      2. Enforcing Data Integrity
      3. Defining Constraints
      4. Types of Constraints
      5. Disabling Constraints
      6. Using Defaults and Rules
      7. Deciding Which Enforcement Method to Use
    6. Planning Indexes
      1. Introduction to Indexes
      2. Index Architecture
      3. How SQL Server Retrieves Stored Data
      4. How SQL Server Maintains Index and Heap Structures
      5. Deciding Which Columns to Index
    7. Creating and Maintaining Indexes
      1. Creating Indexes
      2. Creating Index Options
      3. Maintaining Indexes
      4. Introduction to Statistics
      5. Querying the sysindexes Table
      6. Setting Up Indexes Using the Index Tuning Wizard
      7. Performance Considerations
    8. Implementing Views
      1. Introduction to Views
      2. Advantages of Views
      3. Defining Views
      4. Modifying Data Through Views
      5. Optimizing Performance by Using Views
      6. Performance Considerations
    9. Implementing Stored Procedures
      1. Introduction to Stored Procedures
      2. Creating, Executing, Modifying, and Dropping Stored Procedures
      3. Using Parameters in Stored Procedures
      4. Executing Extended Stored Procedures
      5. Handling Error Messages
      6. Performance Considerations
    10. Implementing User-defined Functions
      1. What Is a User-defined Function?
      2. Defining User-defined Functions
      3. Examples of User-defined Functions
    11. Examples of User-defined Functions
      1. Introduction to Triggers
      2. Defining Triggers
      3. How Triggers Work
      4. Examples of Triggers
      5. Performance Considerations
    12. Programming Across Multiple Servers
      1. Introduction to Distributed Queries
      2. Executing an Ad Hoc Query on a Remote Data Source
      3. Setting Up a Linked Server Environment
      4. Executing a Query on a Linked Server
      5. Managing Distributed Transactions
      6. Modifying Data on a Linked Server
      7. Using Partitioned Views
    13. Optimizing Query Performance
      1. Introduction to the Query Optimizer
      2. Obtaining Execution Plan Information
      3. Using an Index to Cover a Query
      4. Indexing Strategies
      5. Indexing Strategies
    14. Analyzing Queries
      1. Queries That Use the AND Operator
      2. Queries That Use the OR Operator
      3. Queries That Use the OR Operator
    15. Managing Transactions and Locks
      1. Introduction to Transactions and Locks
      2. Managing Transactions
      3. SQL Server Locking
      4. Managing Locks

    Seminar Summary:

    This course will provide students with the technical skills required to program a database solution by using Microsoft SQL Server 2000. (see full course description)

    print this agenda print agenda for the Microsoft SQL Server 2000 Database Design and Implementation (2073) training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search