SQL Server 2000 Training Course, Learn SQL

Microsoft Certified Partner

Microsoft SQL Server 2000 Administration

Duration: 5 days | Price: Contact a Career Consultant for pricing

Students Will Learn:

Designing and Implementing Databases
SQL Statements
Stored Procedures and Triggers
Backing Up and Restoring Data

Importing and Exporting Data
Automating SQL Server Administration
Monitoring and Optimizing Performance

Description: Five days of intensive hands on training, this class will allow the student to understand relational database concepts and the Structured Query Language (Transact-SQL) in the Microsoft SQL Server environment as well as identify and configure all major aspects of a Microsoft SQL Server RDBMS. You will learn about tables and constraints; DTS packages and transformations; transact SQL queries; creating views; creating and tuning indexes; building transactions & triggers and creating stored procedures; relational database concepts; SQL vocabulary; a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyzer; and database implementation basics. The course also shows how to install and configure SQL Server, create and manage databases and database devices, backup and restore SQL Server databases, import and export data, implement automated tasks and optimize SQL server.

This course is intended for administrators new to database management and development, and includes all of the material in the SQL Programming and Relational Database Design courses. You should not register for either of those courses if you will be attending this course.

Prerequisites: Familiarity with Windows desktop navigation and software installation procedures.

Microsoft SQL Server 2000 Administration Course Overview:

SQL Server Overview Client/Server Architecture A Brief History Review of New features Transact-SQL Users and Security Servers and Databases Networked Architecture SQL Server Installation Upgrading and Backwards Compatibility	What Is A Relational Database? What is a Database? Logical and Physical Design The Relational Database Primary Keys and Foreign Keys Relationships Design Normalization
RDBMS Architecture The RDBMS Structured Query Language - SQL Stored Queries Indexes Transactions and Log Files Client-Server and Middleware Architectures Replication	Data Storage & Management How is Data organized in SQL Server and NT/2000 ? Creating a Database Standard Data Types Tables and Columns in Enterprise Manager Tables and Columns in T-SQL Modifying Tables and Columns Computed Columns Database Diagrams Architecture Planning Fault Tolerance Using File Groups Shrinking Databases
Designing And Implementing Databases Organizing Data Post-Installation Databases Database Files Planning a Database Creating Databases The Primary Filegroup Database Options Managing Databases	Security SQL Server Security Login Accounts Statement and Object Permissions Application Security Auditing Security Checklists Fixed Server Roles User-Defined Roles Database Permissions Application Roles
Tables and Constraints Designing Tables with the Database Diagram Calculated Columns Constraints User-Defined Data Types Legacy Rules and Defaults	Transact SQL Queries Querying SQL Server 2000 Tables SQL and Transact SQL Using the SELECT Statement Transact SQL Built-In Functions Summary Queries Sub-Queries
Views Uses of Views Limitations of Views Calculated Columns Creating Views	Indexes Overview of Indexes Clustered versus Non-Clustered Indexes Creating Indexes Using SHOWPLAN to See if the Index is Being Used Using Composite Indexes to Cover Queries Duplicate Keys and Rows and How to Solve Problems The Distribution Page and UPDATE STATISTICS The Index Tuning Wizard Index Maintenance Plans
Transactions How Data is Changed in SQL Server 2000 Inserting and Copying Records Changing Records Removing Records Transaction Processing Commands Locking Issues	Programming Basics Transact SQL Batch and Script Rules Variables Flow Control Statements The EXEC( ) function Error Handling Cursors
Stored Procedures SQL Server 2000 Query Caching & Related Features Uses for Stored Procedures Creating Stored Procedures Passing Parameters Returning Values and Updating Parameters Compilation Problems And Methods Temporary Procedures and AutoStart Procedures	Triggers Basic Trigger Assumptions and Syntax Improving Trigger Performance Checking the Number of Rows Affected Nested Triggers
Using Queries To Change Data Action Queries The INSERT Statement The DELETE Statement The UPDATE Statement	Enforcing Data Integrity Types of Data Integrity Constraints Ensuring Integrity with Triggers
Improving Data Access Using Views Web Publishing from SQL Server Application Development Environment	Using Queries To View Data The SELECT Statement Manipulating Data Selecting Rows Sorting Data Aggregate Functions Joins - Querying Multiple Tables
Backing Up Data Planning Backups Backup Mechanisms Performing a Backup Backup Types Recovery Models Automating Backups Backup Strategies Standby Servers	Restoring Data Auto Recovery Restoring User Databases Recovering System Databases
Installation Of Microsoft SQL Server Pre-Installation Check-List Installing SQL Server Installed Components Compatibility Issues Upgrading to SQL Server 2000 Failover Clustering SQL Server Enterprise Manager	SQL Server Tools Administration Environment Books Online System Environment Tools SQL Server Enterprise Manager Query Analyser Which Query Tool?
Importing And Exporting Data DTS - Data Transformation Services XML Support with Microsoft IIS Linking Servers Summary of Data Transfer Methods	Data Transformation Services The dtsrun Utility Connecting to External Data with Linked Servers BCP Using Backup & Restore to Move Data
DTS Packages and Transformations Modifying Packages with DTS Designer DTS Transformations	Automating SQL Server Administration Automation Overview Setting Up SQLMail Setting Up Operators in SQL Server Jobs, Events & Alerts Types of Job Creating User-Defined Error Messages Setting Up Alerts Multi-Server Jobs Monitoring Log Space Usage
Data Replication In SQL Server Replication Overview Replication Topologies Microsoft SQL Server Replication Replication and Publishing Replication Mechanisms Monitoring and Troubleshooting Configuring Replication	Troubleshooting, Monitoring And Optimizing Troubleshooting SQL Server Monitoring SQL Server Optimizing SQL Server Optimizing Hardware Optimizing Windows 2000 SQL Server Configuration Optimal Database Design Client-Side Optimization

Student Testimonials

"This is the 6th HOTT training course I have had. The instructors have been very knowledgeable and the material has been invaluable. "
– L.C., Sara Lee

"Last week I attended a 5 day training class on Microsoft SQL Server Administration in Cincinnati. It was a great experience. The student guides were well written and easy to understand. The exercises ranged from simple to complex and challenging. The instructor was always there to help if you had questions or got stuck on a difficult problem. He did not just give you the answers. He guided you with hints and recommended avenues to explore. The instructor was very personable and his teaching skills were exceptional! He helped make learning this difficult subject matter almost fun."
– J.L., VA Healthcare System of Ohio

Hands On Technology Transfer, Inc.
The Old Post House
91 Heath Road
Weybridge Surrey
KT13 8TS
Phone: 0870 063 2964