SQL Server 2000/2005: Introduction for Beginners

Show more Microsoft SQL Server Training Courses

About this class

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.

Who will the lesson benefit?

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.

What prerequisites are required

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.

Contents of this class

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

(C) AquinasTraining.co.uk - Contact Us