Contact us for dates, pricing and how we can customise courses to your requirements: contact us

SQL Introduction / Intermediate for SQL Server

Duration: 3 days TBC after delegates’ requirements are assessed

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 SQL Server Database, an open source product that is gaining in popularity in the industry. However, the concepts are basic enough that they transfer easily to any standard database product that abides by the ANSI standards.

Introduction: Databases & the Web
  • Overview
  • The File System
  • Databases and the ACID Test


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
  • Tables
  • Primary Keys, Foreign Keys, and
  • Relationships


Retrieving Data with SELECT
  • Comparison Operators for the WHERE
  • Clause
  • Apostrophes in Database Text
  • Calculated Columns: Doing Math in Select
  • Statements
  • Select Distinct
  • Selecting All Columns
  • Selecting Data from the Database
Data Manipulation: INSERT, UPDATE, DELETE
  • 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
  • Data
Querying Data Across Tables
  • Basic Joins
  • Selecting From Multiple Tables
Reusing Queries as Views
  • Creating Views


Query Within a Query
  • Subqueries
  • 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
  • Auto-numbered Columns
Relationships Between Tables
  • Normalization
  • Normalizing the Guestbook Table
  • Online Transaction Processing vs. Decision
Restructuring Tables
  • Renaming Tables or Columns
  • Adding or Deleting Columns
  • Normalizing the Camp Sales Database
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


Many-to-Many Relationships Introduction to Transactions Major SQL Statements