Jump to course:

Intro to Relational Databases and SQL

Overview

This course introduces relational Databases and SQL Structured Query Language. SQL is the native interface to all commercial relational databases and is a vital language to learn and understand in order to build and manipulate databases.

The course uses the Microsoft Access relational database to introduce the terms and concepts needed to design and query a relational database. During the course attendees will learn about the structure and form of standard relational databases and how to maniupulate and access the data held within a database using the SQL language. The course teaches the generic SQL language that is compatible with nearly all relational databases. Attendees will also learn how to use the query building tool to simplify the structure of their SQL queries. The course is designed as a pre-requisite to our Systems Administration for Microsoft SQL Server and similar courses.

Learn To

Create tables
Understand table relationships
Query databases
Build SQL statements
Understand normalisation
Understand the client-server database model

… and much more

Course Content

Introduction

What are Databases?
Why Learn Databases?
Databases and the WWW
Why Use MS Access?
What about SQL?

Database Tables

Overview
Datasheet View
Design View
Data Types
Create your Table
Exercise
Primary Keys
Indexes
Formats and Defaults

Database Relationships

Overview
Creating Relationships
Relationship Types
Integrity

Queries

Overview
Creating a Query
Defining Query Fields
Query Conditions
Multiple Criteria
Other Conditions

Meet SQL
SQL Select Queries

Overview
Order Clause
Group Clause
Where Clause
Combining Clauses
Aggregate Functions

Advanced SQL

Overview
Update
Update Where
Insert
Make Table
Delete

Multi Table Queries

Overview
Building Complex Queries
Joins
Inner Joins
Outer Joins
Queries on Queries

Data Modelling

Overview
Data Anomalies
Normalisation: Step 1
Normalisation: Step 2
Normalisation: Step 3
Data Modelling Tips

Different flavours of SQL

T-SQL: SQL Server
P/L SQL :Oracle
MySQL
DB2

Resources

Access Resources
SQL Resources
Other Database Sites
Definitions

Objectives

To understand the basic relational database concepts and design rules (normal forms). Knowledge of basic SQL syntax (SELECT, UPDATE, and INSERT statements). Familiarity with the Access database engine.

Audience

Anyone new to databases who needs to learn the fundamentals of database theory and the SQL language. Programmers unfamiliar with databases and SQL and anyone developing reports needing to learn SQL will benefit from this course.

Duration

2 Days

Ciara Nally – Dept. of Transport