Oracle SQL for beginners Training Course

Relational Database Models

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

Data Retrieval

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

Filtering Results

• Using 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 and ordering
• Using the DISTINCT clause

Data Sorting

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

SQL Functions

• Differences between single-row and multi-row functions
• Character, numeric, and date functions
• Explicit and implicit data conversion
• Conversion functions
• Nesting functions
• Testing function performance using the dual table
• Retrieving the current date using the SYSDATE function
• Handling NULL values

Data Aggregation and Grouping

• Aggregate functions
• How aggregate 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 join connectors
• Using NATURAL JOIN
• Applying table aliases
• Defining 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
• Grouping features within 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

Data Manipulation: Insert, Update, and Delete

• 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

DDL Commands

• Overview of main database objects
• Naming conventions for objects
• Creating tables
• Available data types for columns
• Using the DEFAULT option
• Applying NULL and NOT NULL constraints

Table Management

• Enforcing referential integrity with CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
• Creating tables using queries
• Dropping tables with DROP TABLE
• Using the DESCRIBE command

Other Schema Objects

• Sequences
• Synonyms
• Views