Oracle SQL Intermediate Training Course

Create complex queries to databases

• Use available operators
• Queries with multiple conditions

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

• ALTER clause

• DML commands (insert, update, delete)

• DCL commands (grant, revoke)

• Internal and external joins

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

• multi-column
• correlated
• WITH clause