SQL Training Course

Introduction

What you will learn

Data Models

Flat file

Hierarchical

Network

Entity-Relationship Concepts

Relational Data Model

Terminology

Entity types and occurrences

Attributes

Keys

Relationships

Entity-Relationship diagrams

Entity-Relationship Modelling

Gathering Information

Entity-Relationship modelling

Integrating views into a single model

Complex Relationships

Data Integrity and Normalization

Keys

Integrity rules

Normalization

First Normal Form

Second Normal Form

Third Normal Form

Denormalizing

Preparing for Implementation

Attributes and Validation

SQL for Implementation

CREATE and DROP

Table

Index

Foreign Key

ALTER

Security

GRANT

REVOKE

Implementing a design

Defining tables

Defining Relationships

Importing data

Summary

Introduction to Relational Databases

Relational Databases

• Tables (permanent and temporary), columns, keys

Relationships

Course database layout

Projections, Selections and Joins

Projections

SELECT (including multi-table)

Selections

WHERE clause

Comparison, range and list operators

String matching

ORDER BY clause

GROUP BY and HAVING clauses

Joins

Equijoins

Inner and Outer joins

Self joins

Views

Subqueries

Operators

IN / NOT IN

EXISTS / NOT EXISTS

Updates

INSERT

UPDATE

DELETE

Reports

Presenting, saving and manipulating your data queries