Oracle SQL Language

Relational database models

• The structure of a relational database
• Connection types of tables
• The normalization and denormalization database
• Database Management System (RDBMS)

Characteristics of declarative SQL language SQL Syntax Division language DQL, DML, DDL, DCL Language DQL (Data Query Language)

• SELECT queries
• Aliases columns, tables
• Service date (DATE types, display functions, formatting)
• Group Features
• Combining internal and external tables
• UNION operator
• Nested Subqueries (the WHERE clause, the table name, column name)
• Correlated subqueries

• Inserting rows (INSERT clause)
• Inserting via query
• Updating rows (UPDATE)
• Removing rows (DELETE)

• Create, change of ownership, remove tables (CREATE, ALTER, DROP) Creating tables by asking (CREATE TABLE .... AS SELECT ...)

• Options NULL and NOT NULL
• CONSTRAINT clause
• Condition PRIMARY KEY
• Condition UNIQUE
• Condition FOREIGN KEY
• DEFAULT clause

• The command COMMIT, ROLLBACK, SAVEPOINT

• Granting and revoking permissions (GRANT, REVOKE)
• Roles
• Creating Users
• sequences
• Synonyms
• The views (perspective)