Toll Free: 800-735-7418
Local: 303-377-9333
info@hartmannsoftware.com
 
 

 
INTRODUCTION TO MICROSOFT SQL SERVER 2000 - LEVEL 1

Course Description  
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. This introductory course teaches you the fundamentals and gives you a taste of the potential of Microsoft SQL Server 2000. 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.

Course Length: 2 Day
Course Tuition: $790 (US)
Prerequisites
Microsoft Access, Visual Basic, Active Server Pages or related development experience.
Course Outline  


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

• Installing 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

Contact us for course schedules or more information.
 

Registration and Pricing
The Virtual Classroom
Mentoring Services


Fresh Off The Press MySQL Admin/Dev
Sharepoint for Developers
Advanced XML
Securing Java Web Services
Exploring Design Patterns
Fast Track to Java EE
Ajax using C# (VS 2008) Oracle 11G New Features Complete LINQ