Telephone: 0208 942 5724
Open: 09:00a.m. to 17:30p.m. Monday to Friday

SQL Introduction / Intermediate

Duration: 3 Days


Databases drive nearly every Internet and Intranet Web site. Aspect’s Introduction to SQL and Database Design class teaches you how to master their power through a thorough grounding in SQL and sound database design fundamentals. This course is designed for people with no relational database experience. The database that we use for the class is Microsoft SQL Server. However, the concepts can be transfered easily to any standard database product that abides by the ANSI standards.


This course can be adapted to any level of prior SQL Server and relational database experience.

Course Topics:

An Overview of SQL

The Role of SQL
SQL History and Major DBMS Vendors

Relational Databases

Queries and Recordsets
Building a Simple SQL Query

More Parts of Relational Databases

Primary Keys, Foreign Keys, and

Retrieving Data with SELECT

Comparison Operators for the WHERE
Apostrophes in Database Text
Calculated Columns: Doing Math in Select
Select Distinct
Selecting All Columns
Selecting Data from the Database

Data Manipulation: INSERT, UPDATE,

INSERT Statements
UPDATE Statements
DELETE Statements

Data Retrieval: More about SELECT

Practicing with ORDER BY
Practicing with Aggregate Functions
Extended WHERE Conditions
Practicing with Extended WHERE Clauses

Fine-Tuning Aggregate Functions

The HAVING Clause
Using GROUP BY and HAVING to Analyze

Querying Data Across Tables

Basic Joins
Selecting From Multiple Tables

Reusing Queries as Views

Creating Views

Query Within a Query

Subqueries vs. Joins

Database Definition SQL

Creating a Table for a Guest Book

Database Design

Data Modeling
Handling More than One Phone Number
Adding Columns with ALTER TABLE

Establishing a Primary Key

Autonumbered Columns

Relationships Between Tables

Normalizing the Guestbook Table
Online Transaction Processing vs. Decision

Restructuring Tables

Renaming Tables or Columns
Adding or Deleting Columns

Data Integrity: Controlling What Goes

Into a Database
Default Values
Setting Default Values
Check Constraints
Checking Input
Creating Foreign Keys
Defining Primary and Foreign Keys

Click Here for printer friendly version of outline

Ring 0208 942 5724 if you require further details or would like to book a training course

Aspect Training, 20 Coombe Road, New Malden, Surrey, KT3 4QE

© 2013 Aspect Training