Database Management Systems & Programming

Table of Contents

Database Management Systems & Programming

Class Outline

SQL - Structured Query Language

SQL

General SQL Query Syntax

Projections

Unique Projections

Selections

Combining Selections and Projections

Comparison Search Conditions

Comparison Search Conditions

Examples of Search Conditions

Compound Comparison Search Conditions

Sorting

Expressions using Arithmetic

SQL Built-in Functions

Aggregate Functions and Grouping

More Grouping Functions

Restrict Groups with “Having”

Another ‘Having’ example

Subqueries

Nested Subqueries

Join (Natural Join)

Renaming Attributes and Relations with an Alias

‘Exists’ and ‘not exists’ in Subqueries

Email: iwhyte@lib.uwo.ca

Other information:
Structured Query Language

Download presentation source