Oracle SQL for beginners Training Course

Relational Database Models

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

Data Retrieval

• Best practices for writing SQL queries
• Syntax of the SELECT statement
• Retrieving all columns from a table
• Performing arithmetic operations in queries
• Using column aliases
• Working with literals
• The concatenation operator

Filtering Results

• Utilizing the WHERE clause
• Comparison operators
• The LIKE condition
• Using the BETWEEN ... AND range
• Handling IS NULL conditions
• The IN condition
• Boolean logic: AND, OR, and NOT
• Combining multiple conditions within the WHERE clause
• Precedence of operators
• Using the DISTINCT clause

Ordering Data

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

SQL Functions

• Distinguishing between single-row and multi-row functions
• Character, numeric, and date functions
• Explicit versus implicit data conversion
• Conversion functions
• Nesting functions
• Testing function outputs using the dual table
• Retrieving the current date with SYSDATE
• Managing NULL values

Aggregating Data with Grouping

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

Retrieving Data from Multiple Tables

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

Subqueries

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

Set Operators

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

Inserting, Updating, and Deleting Data

• The INSERT command
• Copying data from other tables
• The UPDATE command
• The DELETE command
• The TRUNCATE command

Transactions

• Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT

DDL Commands

• Primary database objects
• Naming conventions for objects
• Creating tables
• Available data types for columns
• Setting DEFAULT values
• Defining NULL and NOT NULL constraints

Table Management

• Enforcing referential integrity via CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
• Creating tables using SELECT queries
• Removing tables with DROP TABLE
• The DESCRIBE command

Other Schema Objects

• Sequences
• Synonyms
• Views