Oracle SQL for beginners Training Course

Relational database models

• Structure of a relational database
• Types of table relationships
• Database normalization and denormalization
• Relational operators

Retrieving data

• Best practices for writing SQL queries
• SELECT statement syntax
• Selecting all columns
• Performing arithmetic operations in queries
• Using column aliases
• Working with literals
• The concatenation operator

Filtering results

• The WHERE clause
• Comparison operators
• The LIKE condition
• The BETWEEN ... AND condition
• The IS NULL condition
• The IN condition
• Boolean operators: AND, OR, and NOT
• Combining multiple conditions in the WHERE clause
• Operator precedence
• The 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 data conversion
• Conversion functions
• Nesting functions
• Testing functions using the dual table
• Retrieving the current date with the SYSDATE function
• Handling NULL values

Aggregating data using grouping

• Grouping functions
• How grouping functions handle NULL values
• Creating data groups with the GROUP BY clause
• Grouping by multiple columns
• Filtering grouped results with the HAVING clause

Retrieving data from multiple tables

• Types of joins
• Using NATURAL JOIN
• Table aliases
• Performing joins in the WHERE clause
• INNER JOIN
• Outer joins: LEFT, RIGHT, and FULL OUTER JOIN
• The Cartesian product

Subqueries

• Placing subqueries in the SELECT statement
• Single-row and multi-row subqueries
• Operators for single-row subqueries
• Using grouping within subqueries
• Operators for multi-row subqueries: IN, ALL, ANY
• Handling NULL values in subqueries

Set operators

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

Inserting, updating, and deleting data

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

Transactions

• The COMMIT, ROLLBACK, and SAVEPOINT commands

DDL commands

• Primary database objects
• Naming conventions for objects
• Creating tables
• Available data types for columns
• The DEFAULT option
• The NULL and NOT NULL options

Managing tables

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

Other schema objects

• Sequences
• Synonyms
• Views