SQLServer 2005

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course is designed to be a comprehensive overview of SQL Server 2005. 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, Full-Text Indexes, User -Defined Functions 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 2005 Overview
    • SQL Server Architecture
    • Components of the SQL Server
    • Install & Configure SQL Server
    • Understand DB Design and how to implement them in SQL Server
  • 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 & 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 2005 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


  • User Defined Functions
    • Overview and Creating
    • Scalar & Table Functions
    • Using UDF’s
  • 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
  • Advanced Topics
    • Tools, Backups and RestUsing .NET Code in SQL Server
    • Understanding & ImplementingSecuring
    • Performance & Tuning
    • Administrative Tasks Using Integration Services
    • Analysis Services
  • SQL Server & XML

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