SQL Server 2000 Introduction Course

Course Code: RT 125
Course Abstract: This course is for developers coming from Microsoft Access, Visual Basic, Active Server Pages or other development backgrounds who want to learn to build successful databases solutions with SQL Server. Even developers who've already used Oracle, Sybase, DB2 or other relational database management systems will find this course useful for getting up to speed on SQL Server 2000. Participants learn about the features that are available in SQL Server; how to design and create a database; and how to build basic queries using Transact-SQL, the language of SQL Server.
Audience: This course is designed for developers.
Duration: 2 days
Learning Outcomes:

Upon completion of this course, the participant will be able to:
> Get acquainted with the editions of SQL Server and which features are available in each edition
> Learn to install and configure Microsoft SQL Server 2000
> Understand basic database design principles and how to implement them in SQL Server
> Learn the fundamentals of writing Transact-SQL queries that retrieve or modify data

Course Topics:

SQL Server Tour
SQL Server Editions
Graphical Tools
Exploring the Enterprise Manager
Working with SQL Server Books Online

Installation and Configuration of SQL Server
Multiple Instances
Installing an Instance of SQL Server
Configuring the Server

Designing and Creating a Database
Relational Database Design Principles
Implementing the Design

 Basic Querying
Introduction to the Query Analyzer
Retrieving Data
Joining Tables

Action Queries
Modifying Data
Inserting Data
Updating Data
Deleting Data

Prerequisites: Microsoft Access, Visual Basic, Active Server Pages or another development background
Note: All fields are required
At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.


We Value Your Privacy!

Ready to get started or in need of more information? Contact us today.

Go To Blog Virtual Learning

Testimonials

“56% of IT leaders plan to train their staff this year to better manage third-party relationships, negotiate contracts, assess vendor risk, and monitor service-level agreements” (“Trends 2007: Hot IT Skill Areas”, Forrester Research, Inc., March 2007).