Oracle SQL Intermediate

Basic knowledge in Oracle SQL

Audience

All who want to improve their basic skills in Oracle SQL and also systematize already gained knowledge.

Format of the course

25% lectures, 75% labs

Create complex queries to databases

• Use available operators
• Queries with multiple conditions

Creating tables and references

• DDL commands (create, alter, and drop)
• Create referential integrity
• Normalization of tables (up to 3 normal form)
• anomalies and ways to avoid them

Changes in the structure of existing tables

• ALTER clause

Manipulation of data

• DML commands (insert, update, delete)

Creating new users and granting permissions

• DCL commands (grant, revoke)

Linking Tables

• Internal and external joins

Data Aggregation

• Features of grouping functions
• Use the GROUP BY clause and HAVING
• Grouping multiple column

Subqueries

• multi-column
• correlated
• WITH clause