Oracle SQL for beginners Training Course

Relational Database Models

• Understanding the architecture of relational databases
• Types of relationships between tables
• Database normalization and denormalization strategies
• Relational operators

Data Retrieval

• Best practices for structuring SQL queries
• SELECT statement syntax
• Retrieving all columns from a table
• Performing arithmetic operations within queries
• Assigning aliases to columns
• Using literals in SQL
• The concatenation operator

Filtering Query Results

• Applying the WHERE clause
• Utilizing comparison operators
• Working with the LIKE condition
• Using the BETWEEN ... AND criteria
• Handling IS NULL conditions
• Filtering with the IN condition
• Boolean logic using AND, OR, and NOT
• Combining multiple conditions in the WHERE clause
• Operator precedence
• Eliminating duplicates with the DISTINCT clause

Data Sorting

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

SQL Functions

• Distinguishing between single-row and multi-row functions
• Handling text, numeric, and date data
• Explicit versus implicit data type conversion
• Using specific conversion functions
• Nesting functions for complex calculations
• Testing function performance using the dual table
• Retrieving the current date with the SYSDATE function
• Managing NULL values

Data Aggregation and Grouping

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

Querying Multiple Tables

• Understanding different join types
• Using the NATURAL JOIN
• Applying table aliases
• Performing joins within the WHERE clause
• Using the INNER JOIN
• External joins: LEFT, RIGHT, and FULL OUTER JOIN
• Understanding the Cartesian product

Subqueries

• Embedding subqueries in the SELECT statement
• Differences between single-row and multi-row subqueries
• Operators for single-row subqueries
• Grouping within subqueries
• Operators for multi-row subqueries: IN, ALL, and ANY
• Handling NULL values within subqueries

Set Operators

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

Data Manipulation: Insert, Update, and Delete

• Using the INSERT statement
• Copying data from other tables
• Modifying data with the UPDATE statement
• Removing data with the DELETE statement
• The TRUNCATE statement

Transactions

• Managing transactions with COMMIT, ROLLBACK, and SAVEPOINT

DDL Commands

• Overview of core database objects
• Naming conventions for objects
• Creating new tables
• Available data types for columns
• Setting default values
• Defining NULL and NOT NULL constraints

Table Management

• Enforcing referential integrity with CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
• Creating tables from existing queries
• Removing tables with DROP TABLE
• Inspecting table structure with the DESCRIBE command

Additional Schema Objects

• Creating and using sequences
• Working with synonyms
• Defining views