Oracle SQL for beginners Training Course

Relational Database Models

• Anatomy of a relational database
• Types of table relationships
• Concepts of database normalization and denormalization
• Relational operators

Data Retrieval

• Best practices for crafting SQL queries
• SELECT statement syntax
• Retrieving all columns
• Performing arithmetic operations in queries
• Using column aliases
• Working with literals
• Using the concatenation operator

Filtering Results

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

Sorting Data

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

SQL Functions

• Distinguishing between single-row and multi-row functions
• Text, numeric, and date features
• Explicit and implicit type conversion
• Conversion functions
• Nesting functions
• Testing function performance using the dual table
• Retrieving the current date with the SYSDATE function
• Managing NULL values

Aggregating Data with Grouping

• Aggregate functions
• How aggregate functions handle NULL values
• Forming data groups using the GROUP BY clause
• Grouping by multiple columns
• Restricting group results with the HAVING clause

Querying Multiple Tables

• Types of joins
• Utilizing NATURAL JOIN
• Assigning table aliases
• Defining joins in the WHERE clause
• INNER JOIN
• External joins: LEFT, RIGHT, and FULL OUTER JOIN
• The Cartesian product

Subqueries

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

Set Operators

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

Data Modification: Insert, Update, and Delete

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

Transactions

• COMMIT, ROLLBACK, and SAVEPOINT commands

DDL Commands

• Core database objects
• Naming conventions for objects
• Creating tables
• Data types available for columns
• DEFAULT option
• NULL and NOT NULL constraints

Table Management

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

Additional Schema Objects

• Sequences
• Synonyms
• Views