SQLServer 7.0

LENGTH OF COURSE:
3 Days

DESCRIPTION: This course is designed to be a comprehensive overview of SQL Server 7.0. The course begins with the basics of SQL Server and walks the student through the design and implementation of systems using SQL Server. In addition, students will have an opportunity to work with more advanced features such as Stored Procedures, Triggers, Replication, and much more. This course is a must for any person that will be using, programming, administering, and managing an environment that is using SQL Server.

PREREQUISITES: Students are expected to have a basic knowledge of Relational Database Concepts. Knowledge of SQL is helpful, but not required. The instructor will evaluate the students knowledge base and pace the course materials according to existing knowledge or skills.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

Application Users, Developers, Managers, and Technicians that need to access and format relational data using SQL Server. The course will concentrate on how to use SQL Server in a development and production environment.
KEY HIGHLIGHTS:

  • SQL Server Overview
    • SQL Server Architecture
    • Components of the SQL Server:
      • Databases
      • Tables
      • Database Diagrams
      • Indexes and Views
      • Stored Procedures
      • Triggers
      • Full-Text Indexes
  • Creating a Database
    • Creating a Database Manually and with the Wizard
    • Defining a Maintenance Plan
    • Creating a Database with Transact-SQL
    • Changing Database Characteristics
    • Deleting a Database
    • Viewing Database Components
  • Tables
    • Characteristics
    • Filegroups, Datatypes, Synonyms, Constraints
    • Column Characteristics
      • Identifier
      • Nulls
      • Primary Key
      • Foreign Key
      • UNIQUE & CHECK


  • Query Analyzer
    • Connecting to the Server
    • The Working Screen
    • Executing Commands
    • Executing a Query
    • Analyzing a Query
    • Saving and Recovering a Query
    • Saving the Results Panel
  • SQL Basics and Advanced
    • SQL Server 7 and SQL
    • SQL Essentials
      • Data Definition Language
      • Data Manipulation Language
      • Data Types
      • Expressions and Operators
      • SELECT, INSERT, DELETE, UPDATE, DROP, EXISTS
  • Indexes
    • Types of Indexes
    • Fill Factor
    • Creating Indexes
    • Reconstructing an Index
    • Viewing an Index
    • Deleting an Index


  • Views
    • Creating, Saving, Expanding, Editing, Renaming, and Deleting
  • Stored Procedures
    • Structure
    • Types
    • Parameter and Return Codes
    • Creating and Running
    • Recompiling
    • Deleting
  • Triggers
    • Components
    • Limitations
    • Creating and Changing
    • Deleting a Trigger
  • Replicating
    • Replication Model
    • Types of Replication
    • Subscribing a Pub
    • Defining a Pub
    • Dispatching the Pub
    • Checking and Testing
    • Merge Replication
  • Data Warehousing & OLA
  • OLA Manager
  • Data Transformation Services
  • Tools, Backups and Restore

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.