Oracle SQL for beginners Training Course

Relational database models

• The structural architecture of a relational database
• Various table connection types
• Database normalization and denormalization processes
• Relational operators

Data extraction

• Guidelines for crafting SQL queries
• SELECT statement syntax
• Retrieving all columns
• Queries involving arithmetic operations
• Column aliases
• Literals
• Concatenation operator

Filtering results

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

Data sorting

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

SQL functions

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

Data aggregation through grouping

• Grouping functions
• How grouping functions handle NULL values
• Creating data groups with the GROUP BY clause
• Grouping across multiple columns
• Restricting grouped results with the HAVING clause

Data retrieval from multiple tables

• Different types of connectors
• Utilizing the NATURAL JOIN
• Table aliases
• Joins specified in the WHERE clause
• INNER JOIN
• External merges: LEFT, RIGHT, and FULL OUTER JOIN
• Cartesian product

Subqueries

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

Set operators

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

Data modification: Insert, update, and delete

• The INSERT command
• Copying data from another table
• The UPDATE command
• The DELETE command
• The TRUNCATE command

Transactions

• COMMIT, ROLLBACK, and SAVEPOINT commands

DDL commands

• Key database objects
• Object naming conventions
• Table creation
• Available data types for columns
• The 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

Other schema objects

• Sequences
• Synonyms
• Views