Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Oracle Database 11g: SQL Fundamentals I 
Print Page
Click here for other MS SQL CoursesTransact SQL Server (T-SQL) 2000 Database Design
Description:
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.
- Cost: Price on application
- Duration: 4 Days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
Prerequisites:
Windows 2000 or 2003 Installation and Administration training or or have equivalent knowledge. You should also know the basics of querying a SQL server by using the SELECT, INSERT, and UPDATE SQL statements.
An overview of SQL Server:
Exploring the Components of SQL Server
SQL Server Database Structure
Identifying SQL Server Management Tasks
SQL Server Database Structure
Identifying SQL Server Management Tasks
Exploring Transact-SQL:
Working with Transact-SQL
Transact-SQL Statements
Programming in Transact-SQL
Transact-SQL Statements
Programming in Transact-SQL
Designing and Implementing Databases:
Identifying Database Design Issues
Creating Databases
Managing Databases
Creating Databases
Managing Databases
Creating and Managing Tables:
Design and Create Tables
Maintaining Tables
Maintaining Tables
Designing and Implementing Data Integrity:
Understanding Data Integrity
Implementing Constraints
Implementing Constraints
Implementing Indexes:
Designing Indexing
Implementing Indexes
Maintaining Indexes
Implementing Indexes
Maintaining Indexes
Joining Tables:
Querying Multiple Tables
Implementing Advanced Table Joins
Implementing Advanced Table Joins
Designing Advanced Queries:
Designing Subqueries
Changing Data Through Queries
Changing Data Through Queries
Creating Stored Procedures:
Designing Stored Procedures
Creating Stored Procedures
Using parameters in Stored Procedures
Managing Stored Procedures
Creating Stored Procedures
Using parameters in Stored Procedures
Managing Stored Procedures
Creating Triggers:
Designing and Implementing Triggers
Understanding Transactions and Locks:
Designing and Implementing Transactions
Managing Locks
Managing Locks
Implementing Distributed Queries:
Establishing Linked Servers
Creating and Managing Distributed Queries
Creating and Managing Distributed Queries
Optimising Queries:
Exploring the Query Optimiser
Using Indexes to Optimise Queries
Using Indexes to Optimise Queries
Analysing Queries:
Analysing the Performance of Queries