Microsoft SQL Server 2000 Development


Microsoft SQL Server 2000, Level 1

Level 1 is for developers coming from other database or development backgrounds who have applications that they’re going to use SQL Server. Learn some of the issues with installation and configuration,

All 3 levels
Cost: $1,399 + GST
 
database design issues, and querying. Level 1 teaches you the fundamentals
and gives you a taste of the potential of Microsoft SQL Server 2000.

SQL Server Tour
  • SQL Server Components
  • Management Tools
  • Overview of SQL Server Security
  • Using Books Online

Installation and Configuration

  • Versions
  • Pre-Requirements
  • Multiple Instances
  • Install SQL Server
  • Upgrade
  • Configure the Server

Designing and Implementing a Database

  • Database Design
  • Setting Up a Database
  • Creating Databases
  • Creating, Dropping, and Altering Tables
  • Modifying Tables
  • Creating Indexes
  • Tools for Enforcing Data Integrity
  • DRI
 Basic Querying
  • Understanding SQL
  • The SELECT Statement
  • The WHERE Clause
  • The ORDER BY Clause
  • The GROUP BY Clause
  • TOP
  • Search Conditions
  • Aggregate Functions

Joining

  • Principals of Joining
  • Inner Joins
  • Outer Joins
  • Self Joins
  • Subqueries
  • Unions
 Action Queries
  • Inserting Data
  • Updating Data
  • Deleting Data