1

Introduction

• The relational model
• Basic concepts: relationship (table), attributes (columns), integrity constraints.
• Integrity constraints.

2

Tools

• Overview of SQL*Plus.
• Overview of SQL Developer.

3

Introduction to SQL.

• Oracle data types.
• - Creating tables.
• Introduction to update instructions.
• Using sequences.
• Introduction to querying (SELECT).

4

Data querying

• Sorting and deleting duplicates. Aliases and prefixes. Using Fetch and Offset.
• Handling the NULL value. Using SQL functions.
• Using pseudo-columns: ROWID and ROWNUM. Using aggregates: COUNT, SUM, AVG, etc.
• Set operations: union, intersection, difference.
• Nested queries: IN, EXISTS operators.
• Use of joins.
• External joins.
• Grouping: GROUP BY and HAVING.

5

Objects of an Oracle database

• Creating and deleting tables.
• Integrity constraint management: primary key, uniqueness, non-nullity, CHECK, referential constraints.
• Use of views.
• Use of synonyms.
• Data dictionary.

6

Complex SQL statements

• Configuring SQL*Plus scripts.
• Division and complex queries.
• Update statements with nested queries.
• Hierarchical queries.
• Using regular expressions.