Oracle SQL for beginners Training Course

Relational database models

• The structure of a relational database
• Types of table connections
• Database normalization and denormalization
• Relational Operators

Data retrieval

• Rules for writing SQL queries
• SELECT syntax
• Selecting all columns
• Queries involving arithmetic operations
• Column aliases
• Literals
• Concatenation operator

Limiting results

• The WHERE clause
• Comparison operators
• LIKE Condition
• The BETWEEN ... AND condition
• IS NULL condition
• IN Condition
• Boolean operators AND, OR and NOT
• Multiple conditions within the WHERE clause
• Operator precedence.
• DISTINCT clause

Sorting Data

• The ORDER BY clause
• Sorting by multiple columns or expressions

SQL functions

• Differences between single-row and multi-row functions
• Text, numeric, and date functions
• Explicit and implicit conversion
• Conversion functions
• Nesting functions
• Viewing function performance - dual table
• Getting the current date using the SYSDATE function
• Handling of NULL values

Aggregating data using grouping

• Grouping functions
• How grouping functions treat NULL values
• Creating data groups - the GROUP BY clause
• Grouping multiple columns
• Limiting grouped function results - the HAVING clause

Retrieving data from multiple tables

• Types of connectors
• Using NATURAL JOIN
• Table aliases
• Joins within the WHERE clause
• INNER JOIN (Inner join)
• External Merge LEFT, RIGHT, and FULL OUTER JOIN
• Cartesian product

Subqueries

• Placing subqueries in the SELECT command
• Single-row and multi-row subqueries
• Operators for single-row subqueries
• Grouping features in subqueries
• Operators for multi-row subqueries: IN, ALL, ANY
• How NULL values are treated in subqueries

Set operators

• UNION operator
• UNION ALL operator
• INTERSECT operator
• MINUS operator

Insert, update, and delete data

• INSERT command
• Copying data from another table
• UPDATE command
• DELETE command
• TRUNCATE command

Transactions

• Commands COMMIT, ROLLBACK, and SAVEPOINT

DDL commands

• Main database objects
• Rules for naming objects
• Creating tables
• Data types available for columns
• DEFAULT option
• NULL and NOT NULL options

Managing tables

• Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
• Creating a table from a query
• Dropping a table: DROP TABLE
• DESCRIBE command

Other schema objects

• Sequences
• Synonyms
• Views