Want to boost enrolments? Login and promote your courses
Searching for courses? Login or register
courses The smart course guide
Courses    
  Most popular search | Share this page  
open My list: 0 courses
central heating design   database administrator course   instructional design course   game design course   instructional design courses   game design courses   packaging design course   database administrator courses   graphic design course london   plumbing design
Homepage › IT, Computing, Telecommunications Courses › Database Administration Courses › SQL Server Courses

SQL Server 2000: Database Design

in PTR Associates Ltd (England)

Classes Course

Place:

Wokingham

Price:

£1,475 + VAT

Duration:

5 Days

Start:

14/12/2008 calendar
See course programme

Requirements:

To ensure your success, we recommend you first take the following courses or have equivalent knowledge: ... see more

Request free information

Course objectives:

This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.

More courses Subject area
Place
 

Request information

Contact directly and with no obligation with
PTR Associates Ltd
You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.
* Compulsory fields
By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.
I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:
:| :) ;)
Average Fast Very fast
 

Course details

Type Course Duration 5 Days
Method / place Contact course provider Classes in Wokingham where
Course objectives This course teaches you how to use the Transact-SQL language to query and program Microsoft SQL Server 2000 in a Windows 2000 Server environment. This course also assists you in preparing for the Microsoft Certified Systems Engineer and Microsoft Certified Database Administrator Exam #70-229, Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
Requirements
To ensure your success, we recommend you first take the following courses or have equivalent knowledge: Windows 2000 for Windows NT Administrators: or have equivalent knowledge. You should also know the basics of querying a SQL server by using the SELECT, INSERT, and UPDATE SQL statements.
Price £1,475 + VAT
Get direct information on how to enrol, venues and availability...

SQL Server courses (from other course providers)

 
SQL Server 2000 Database Design MCSE 70-229
We Teach You
Distance - £50 + VAT
 
Sql Server 2000 Database Design Mcse 70-229 Series
Sales 101 Ltd
Online - £75 + VAT
 
SQL for the web
ACS Distance Education
Distance - £280 + VAT
 
Server+
focus4training
Multimedia - £298 + VAT
 
Database Administration
Futures Development Limited
Blended - Price: On request
Compare the selected courses
+ sql server Courses + SQL Server Courses in Berkshire + Courses in Berkshire + PTR Associates Ltd Courses

Course programme

SQL Server 2000: Database Design
An Overview of SQL Server
  • Exploring the Components of SQL Server
  • Exploring the Features of Microsoft SQL Server
  • Exploring the SQL Server Services
  • Identifying Administrative Utilities
  • Using SQL Server Enterprise Manager
  • Using SQL Query Analyzer
  • Database Structure
  • Discussing the Components of SQL Server
  • Identifying the Default Databases and System Tables
  • Creating and Working with a Database Diagram
  • Understanding the SQL Server Architecture
  • Exploring the Application Architecture
  • Identifying SQL Server Management Tasks
  • Determining SQL Server Management Tasks
  • Configuring Your Servers Authentication Mode
  • Creating a SQL Login Account
  • Working With Server and Database Roles
    Exploring Transact-SQL
  • Working with Transact-SQL
  • Using SQL Query Analyzer
  • Using Osql
  • Transact-SQL Statements
  • Creating a Simple Table
  • Inserting Data
  • Selecting Data
  • Assigning Permissions to the Public Database Role
  • Programming in Transact-SQL
  • Using Variables
  • Saving a Script File
  • Choosing an XML Format
    Designing and Implementing Databases
  • Identifying Database Design Issues
  • Designing Databases
  • Identifying the Space Requirements for Databases
  • Optimizing Database Performance
  • Creating Databases
  • Setting Database Options
  • Using Stored Procedures to View Database Information
  • Managing Databases
  • Configuring SQL Server to Automatically Shrink a DatabaseFile
  • Deleting a Database
    Creating and Managing Tables
  • Design and Create Tables
  • Normalizing Table Designs
  • Maintaining Tables
  • Using SQL Server Enterprise Manager to Generate a Script
    Designing and Implementing Data Integrity
  • Understanding Data Integrity
  • Implementing Constraints
  • Adding a Primary Key Constraint
  • Adding a Foreign Key Constraint to the Movie Table
  • Adding a Default Constraint to the Movie Table
  • Adding a Check Constraint to the Movie Table
  • Disabling Constraint Checking
    Implementing Indexes
  • Designing Indexing
  • Understanding Index Architecture
  • Implementing Indexes
  • Creating a Clustered Index on the Movie Table
  • Viewing the Information in Sysindexes
  • Maintaining Indexes
  • Rebuilding an Index
  • Using DROP_EXISTING to Re-create an Index Based on a PrimaryKey
  • Generating a Workload File in SQL Profiler
  • Observing Index Statistics
    Joining Tables
  • Querying Multiple Tables
  • Working with Cross Joins
  • Implementing Advanced Table Joins
  • Joining Multiple Tables
  • Working with Self Joins
  • Combining SELECT Statements
  • Creating a New Table Based on a SELECT INTO Statement
    Designing Advanced Queries
  • Designing Subqueries
  • Designing Single Value Subqueries
  • Changing Data Through Queries
  • Inserting Data Based on a Query
  • Deleting Rows Based on a Query
    Designing Views
  • Creating and Managing Views
  • Creating a View
  • Displaying View Information
  • Dropping a View
  • Creating an Indexed View
  • Creating a Partitioned View
    Creating Stored Procedures
  • Designing Stored Procedures
  • Using Books Online to Research System Stored Procedures
  • Running Extended Stored Procedures
  • Understanding How SQL Server Processes Stored Procedures
  • Creating Stored Procedures
  • Creating a Stored Procedure
  • Executing a Stored Procedure
  • Using Parameters in Stored Procedures
  • Creating a Stored Procedure With an Input Parameter
  • Creating and Executing a Stored Procedure With Output Parameters
  • Managing Stored Procedures
  • Recompiling a Stored Procedure
    Using Functions
  • Working with Aggregate Functions
  • Using Aggregate Functions to Summarize Data
  • Designing GROUP BY Queries
  • Using TOP in a Query
  • Designing and Creating User-defined Functions
  • Dropping a User-defined Function
    Creating Triggers
  • Designing and Implementing Triggers
  • Designing Triggers
  • Creating an INSERT Trigger
  • Creating a DELETE Trigger
  • Creating an INSTEAD OF Trigger
    Understanding Transactions and Locks
  • Designing and Implementing Transactions
  • Working with Explicit Transactions
  • Managing Locks
  • Observing the Current Locks on Your Server
  • Implementing Session Locking
  • Implementing a Lock Timeout
  • Implementing Table-level Locking
    Implementing Distributed Queries
  • Establishing Linked Servers
  • Defining a Linked Server
  • Logging in to Linked Servers
  • Creating and Managing Distributed Queries
  • Configuring the MSDTC Service
  • Using Ad Hoc Queries to Retrieve Data From Remote Servers
    Optimizing Queries
  • Exploring the Query Optimizer
  • Configuring the Query Governor
  • Using SHOWPLAN to View the Query Execution Plan
  • Analyzing a Graphical Execution Plan
  • Using Indexes to Optimize Queries
  • Designing Indexing
    Analyzing Queries
  • Analyzing the Performance of Queries
    • see the full course programme

    on request

    get more information on the programme directly from PTR Associates Ltd.

    Request information for free
    Get direct information on how to enrol, venues and availability...
     

    Venues and dates



    Where Wokingham, 21a Peach Street see map
    When Start: 14/12/2008 Finish: 18/12/2008 See calendar
     
    Get direct information on how to enrol, venues and availability...
     

    Ex-students

     
    Opinions
     
    Have you attended this course?

    Voice your opinion and help thousands of other users

    opinions

    from users who have attended
    this course.
    Get direct information on how to enrol, venues and availability...
     

    On PTR Associates Ltd

    Provider description
    PTR specialises in technical training, particularly in the areas of data communications & networking, internet/intranet, operating systems, programming languages and relational databases. Company specific courses are available for organisations that have several employees who all need training at the same time or who have a requirement for a tailored course. Closed courses typically provide cost benefits when there are at least four employees who need training simultaneously. Courses can be run at PTR's Training Centre or on-site if suitable facilities exist. Benefit from substantial discounts on technical training with our SAVE IT Scheme. If you, or your organisation has a training requirement of 10+ days then our Save IT Scheme may provide additional savings on your training.
    Advantages of studying with PTR Associates Ltd
    Vendor-independent & Generic Training - unbiased independent knowledge Small Class Sizes - increased interaction with lecturer Hands-on - increased learning efficiency Training Environment - modern, air-conditioned classrooms Course Notes - up-to-date, plain English, excellent reference material Training Experience - friendly, personal service
    Refreshments - morning and afternoon breaks with lunch arrangements second to none, at one of the many local restuarants ROI - our prices and quality mean an excellent Return on Investment   Lecturer Expertise - vendor certified with real-world product experience
    Course provider history
    PTR Associates Ltd was established in 1989.
    Specialises in
    Applications Programming Databases Operating Systems Data Communications and Networking Internet Scripting

    All courses

    by PTR Associates Ltd on emagister.

    See list of courses

    Get direct information on how to enrol, venues and availability...

    Training related to SQL Server

    More related courses
    Data Modelling Price: On request
    + sql server Courses + SQL Server Courses in Berkshire + PTR Associates Ltd Courses
     

    Most searched for in SQL Server

    Courses IT, Computing, Telecommunications | Courses Database Administration | Courses SQL Server |
    International sites Spain  |  Italy  |  France  |  Mexico  |  Germany  |  UK  |  Japan  |  Argentina
    Words related to the courses viewed: sql sql server
    emagister.com complies with the 15/1999 Organic Law dated 13th December (Spain), the Data Protection Law and holds the inscription code 2002010053 on the General Register of the Data Protection Agency. Copyright 1999/2000 - Grupo Intercom - All rights