This course provides students with the technical skills required to program a database solution by using Microsoft SQL ServerT 2000.
This course is intended for system administrators who wish to learn the skills required to program a database solution with SQL Server 2000

Before attending this SQL Server training course, students should have completed:

• Experience using the Microsoft Windows® 2000 operating system to:
  • Connect clients running Windows 2000 to networks and the Internet.
  • Configure the Windows 2000 environment.
  • Create and manage user accounts.
  • Manage access to resources by using groups.
  • Configure and manage disks and partitions, including disk striping and mirroring.
  • Manage data by using the NTFS file system.
  • Implement Windows 2000 security.
  • Optimise performance in Windows 2000.
    

For students who do not meet this prerequisite, the following courses provide students with the necessary knowledge and skills:

• Course 2151, Microsoft Windows 2000 Network and Operating System Essentials
• Course 2152, Implementing Microsoft Windows 2000 Professional and Server
• An understanding of basic relational database concepts, including:
  • Logical and physical database design.
  • Data integrity concepts.
  • Relationships between tables and columns (primary key and foreign key, one-to-one, one-to-many, many-to-many).
  • How data is stored in tables (rows and columns).

For students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:

• Course 1609, Designing Data Services and Data Models
• Knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements).

For students who do not meet this prerequisite, the following course provides students with the necessary knowledge and skills:

• Course 2071, Querying Microsoft SQL Server 2000 with Transact-SQL
• Familiarity with the role of the database administrator.

On completion of this SQL Server training course, students should be able to:

• Describe the elements of SQL Server 2000
• Design a SQL Server enterprise application architecture
• Describe the conceptual basis of programming in Transact-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
• Optimise query performance
• analyse queries
• Manage transactions and locks to ensure data concurrency and recoverability

• What Is SQL Server SQL Server Integration
• SQL Server Databases
• SQL Server Security
• Working with SQL Server

• Designing Enterprise Application Architecture
• SQL Server Programming Tools
• The Transact-SQL Programming Language
• Elements of Transact-SQL
• Additional Language Elements
• Ways to Execute Transact-SQL Statement

• Creating Databases
• Creating Filegroups
• Managing Databases
• Introduction to Data Structures

• Creating Data Types
• Creating Tables
• Generating Column Values
• Generating Script

• Types of Data Integrity
• Enforcing Data Integrity
• Defining Constraints
• Types of Constraints
• Disabling Constraints
• Using Defaults and Rules
• Deciding Which Enforcement Method to Use

• Introduction to Indexes Index Architecture
• How SQL Server Retrieves Stored Data
• How SQL Server Maintains Index and Heap Structures
• Deciding Which Columns to Index

• Creating Indexes
• Creating Index Options
• Maintaining Indexes
• Introduction to Statistics
• Querying the sysindexes Table
• Setting Up Indexes Using the Index Tuning Wisard
• Performance Considerations

• Introduction to Views
• Advantages of Views
• Defining Views
• Modifying Data Through Views
• Optimising Performance by Using Views
• Performance Considerations

• Introduction to Stored Procedures
• Creating, Executing, Modifying, and Dropping Stored Procedures
• Using Parameters in Stored Procedures
• Executing Extended Stored Procedures
• Handling Error Messages
• Performance Considerations

• What Is a User-defined Function?
• Defining User-defined Functions
• Examples of User-defined Functions

• Introduction to Triggers
• Defining Triggers
• How Triggers Work
• Examples of Triggers
• Performance Considerations

• Introduction to Distributed Queries
• Executing an Ad Hoc Query on a Remote Data Source
• Setting Up a Linked Server Environment
• Executing a Query on a Linked Server
• Managing Distributed Transactions
• Modifying Data on a Linked Server
• Using Partitioned Views

• Introduction to the Query Optimiser
• Obtaining Execution Plan Information
• Using an Index to Cover a Query
• Indexing Strategies
• Overriding the Query Optimiser

• Queries That Use the AND Operator
• Queries That Use the OR Operator
• Queries That Use Join Operations

• Introduction to Transactions and Locks
• Managing Transactions
• SQL Server Locking
• Managing Locks

Unfortunately we do no have any courses scheduled at this time. Please email us your requirements and we will endeavour to provide this course for you.