Curso: Oracle SQL Intermediate

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