SQL Server 2000/2005: Introduction for Beginners

Course Overview

• This course provides an introduction to the important features of both relational databases and specifically SQL Server 2000/2005. The course will involve a terminology guide
• installation of the server
• a comprehensive guide to the SQL Server tools, including Enterprise Manager and Query Analyser and database implementation basics, with an introduction to T-SQL and SQL Server security.

Audience

This course is for support personnel who need to understand the basic concepts of SQL Server 2000 and 2005, from an administration or development viewpoint. This includes application developers (Visual Basic, C++, etc.) who need a basic grounding in SQL Server 2000 or 2005.

Prerequisites

No previous knowledge of the program is assumed although a working knowledge of Windows 2000/2003 Server/XP will be useful.

Course Outline

SQL Server 2000/2005 Architecture

• RDBMS Characteristics
• SQL 2000/2005 Database Architecture
• Relational Database Design
• The Relational Database
• Structured Query Language
• Enforcing Data Integrity
• Client-Server Architecture
• Replication Architecture

Installing SQL Server 2000/2005

• Pre-Installation Check-List
• Installed SQL Server Components
• Installing SQL Server 2000/2005

SQL Server Tools

• Using the SQL Server Tools
• Creating a Database
• Creating Tables
• Administration Architecture
• Wizards
• Application Development Architecture

Working with SQL Server 2000/2005 Databases and Tables

• Structure Query Language
• Generating Database Information
• Setting Database Options
• Removing Databases
• Enforcing Data Integrity
• Defining Table Columns
• Using INSERT VALUES

Using Database Queries

• The SELECT Statement
• Manipulating Data
• Selecting Rows
• Sorting Data with ORDER BY
• Aggregate Functions
• Implementing Joins
• Deleting Data with DELETE
• Updating Data with UPDATE
• Accessing Data with Views
• Stored Procedures
• Ensuring Database Integrity with Triggers

Implementing SQL Server Security

• Accessing SQL Server 2000/2005
• Fixed Server Roles
• Fixed Database Roles
• What are User-Defined Roles?
• Application Roles
• Database Permissions

SQL Server 2000/2005: Introduction for Beginners / MSSI