Oracle SQL for beginners Training Course

Relational Database Models

• Understanding the structure of a relational database.
• Types of table relationships.
• Database normalization and denormalization concepts.
• Relational operators.

Data Retrieval Basics

• Rules for writing effective SQL queries.
• Syntax of the SELECT statement.
• Selecting all columns.
• Performing queries with arithmetic operations.
• Using column aliases.
• Working with literals.
• Utilizing the concatenation operator.

Limiting Results

• Using the WHERE clause.
• Understanding comparison operators.
• Applying the LIKE condition.
• Using the BETWEEN ... AND condition.
• Checking for NULL values with the IS NULL condition.
• Using the IN condition.
• Applying boolean operators: AND, OR, and NOT.
• Combining multiple conditions within the WHERE clause.
• Understanding the precedence of operators.
• Using the DISTINCT clause to eliminate duplicates.

Sorting Data

• Using the ORDER BY clause.
• Sorting data by multiple columns or expressions.

SQL Functions

• Differences between single-row and multi-row functions.
• Overview of text, numeric, and date functions.
• Explicit and implicit data conversion.
• Using conversion functions.
• Nesting functions within other functions.
• Evaluating function performance using the DUAL table.
• Retrieving the current date using the SYSDATE function.
• Handling NULL values effectively.

Aggregating Data with Grouping

• Understanding grouping functions.
• How grouping functions handle NULL values.
• Creating data groups using the GROUP BY clause.
• Grouping by multiple columns.
• Limiting group function results using the HAVING clause.

Retrieving Data from Multiple Tables

• Types of joins available.
• Using NATURAL JOIN.
• Applying table aliases.
• Performing joins within the WHERE clause.
• Understanding INNER JOIN.
• Working with outer joins: LEFT, RIGHT, and FULL OUTER JOIN.
• Understanding Cartesian products.

Subqueries

• Placing subqueries within the SELECT command.
• Differences between single-line and multi-line subqueries.
• Operators for single-line subqueries.
• Using grouping functions within subqueries.
• Operators for multi-line subqueries: IN, ALL, and ANY.
• Handling NULL values in subqueries.

Set Operators

• Using the UNION operator.
• Using the UNION ALL operator.
• Using the INTERSECT operator.
• Using the MINUS operator.

Inserting, Updating, and Deleting Data

• Using the INSERT command.
• Copying data from another table.
• Using the UPDATE command.
• Using the DELETE command.
• Using the TRUNCATE command.

Transactions

• Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT commands.

DDL (Data Definition Language) Commands

• Identifying main database objects.
• Rules for naming database objects.
• Creating tables.
• Available data types for columns.
• Using the DEFAULT option.
• Using NULL and NOT NULL constraints.

Managing Tables

• Enforcing referential integrity with CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints.
• Creating a table from a query.
• Dropping a table using the DROP TABLE command.
• Describing table structures with the DESCRIBE command.

Other Schema Objects

• Working with sequences.
• Creating and using synonyms.
• Creating and managing views.