SQL Server 2000/2005: Introduction for Beginners

Course Overview

An introduction to the important features of both relational databases and specifically SQL Server. The course will involve a terminology guide; key features of SQL Server; a comprehensive guide to the SQL Server tools, including the Management Studio; and database implementation basics, with an introduction to T-SQL and data integrity.

Audience

Personnel who need to understand the basic concepts of SQL Server, from an administration or development viewpoint. Application developers (Visual Basic, C++, etc.) who need a solid grounding in SQL Server.

Prerequisites

Delegates should have a working knowledge of Windows. It is not necessary to attend this course if you have attended our SQL Server Introduction course.

Course Outline

RELATIONAL DATABASE CONCEPTS

• What is a Database?
• Logical and Physical Design
• The Relational Database
• Primary Keys/Foreign Keys
• Entity Relationship Diagrams
• Design Normalisation

RELATIONAL DATABASE ARCHITECTURE

• The RDBMS
• Structured Query Language - SQL
• Stored Queries
• Indexes
• Transactions and Log Files
• Client-Server and Middleware Architectures

SQL SERVER FEATURES AND ARCHITECTURE

• Overview of SQL Server
• Users and Security
• Networked Architecture
• SQL Server Installation

SQL SERVER TOOLS

• Administrative Tools
• SQL Management Studio
• SQL Server Configuration Tool
• SQL Server Books Online
• SQL Server Surface Area Configuration
• Profiler
• Performance Monitor
• Books Online
• System Environmental Tools
• SQL Server Enterprise Manager
• Query Analyser

VIEWING DATA

• Controlling Data within Database Tables
• The SELECT Statement
• Manipulating Data
• Selecting Rows
• Sorting Data using ORDER BY
• Aggregate Functions
• Joins - Querying Multiple Tables

DATABASES AND TABLE STRUCTURES

• Creating a Database using SQL Server 2005
• Creating a Database using SQL Server 2000
• Adding Tables and Columns - Overview
• Tables and Columns in Management Studio
• Modifying Tables and Columns
• Computed Columns
• Database Diagrams

MANIPULATING DATA

• Action Queries
• The INSERT Statement
• The DELETE Statement
• The UPDATE Statement

ENFORCING DATA INTEGRITY

• Types of Data Integrity
• Constraints
• Ensuring Integrity with Triggers

IMPROVING DATA ACCESS

• Using Views
• Speeding up Data Access with Indexes
• Application Development Environment

SQL Server 2000/2005: Introduction for Beginners / MSQ-IN