Course Outline
Relational Database Models
- The structure of a relational database.
- Types of table connections.
- Database normalization and denormalization.
- Relational operators.
Data Retrieval
- Rules for writing SQL queries.
- Syntax for the SELECT statement.
- Selecting all columns.
- Queries involving arithmetic operations.
- Column aliases.
- Literals.
- Concatenation operator.
Limiting 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 in the WHERE clause.
- Operator precedence.
- DISTINCT clause.
Sorting Data
- The ORDER BY clause.
- Sorting by multiple columns or expressions.
SQL Functions
- Differences between single-row and multi-row functions.
- Text, numeric, and date functions.
- Explicit and implicit data conversion.
- Conversion functions.
- Nesting functions.
- Examining function performance using the DUAL table.
- Obtaining the current date using the SYSDATE function.
- Handling NULL values.
Aggregating Data Using Grouping
- Grouping functions.
- How grouping functions handle NULL values.
- Creating data groups using the GROUP BY clause.
- Grouping by multiple columns.
- Limiting grouped function results using the HAVING clause.
Retrieving Data from Multiple Tables
- Types of joins.
- Using NATURAL JOIN.
- Table aliases.
- Joins specified in the WHERE clause.
- INNER JOIN.
- Outer joins: LEFT, RIGHT, and FULL OUTER JOIN.
- Cartesian product.
Subqueries
- Placing subqueries within the SELECT statement.
- Single-row and multi-row subqueries.
- Operators for single-row subqueries.
- Using grouping functions within subqueries.
- Operators for multi-row subqueries: IN, ALL, ANY.
- Handling NULL values in subqueries.
Set Operators
- UNION operator.
- UNION ALL operator.
- INTERSECT operator.
- MINUS operator.
Inserting, Updating, and Deleting Data
- INSERT command.
- Copying data from another table.
- UPDATE command.
- DELETE command.
- TRUNCATE command.
Transactions
- COMMIT, ROLLBACK, and SAVEPOINT commands.
DDL Commands
- Main database objects.
- Rules for naming objects.
- Creating tables.
- Data types available for columns.
- DEFAULT option.
- NULL and NOT NULL options.
Managing Tables
- Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE.
- Creating a table via a query.
- Dropping a table: DROP TABLE.
- DESCRIBE command.
Other Schema Objects
- Sequences.
- Synonyms.
- Views.
Requirements
- Basic computer literacy.
- Familiarity with any operating system.
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 3900 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (6)
it was structured very well both by days and by modules, easy to follow
Melania - DB Global Technology SRL
Course - Oracle SQL for beginners
I liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
the trainer give more examples for each chapter
Corina
Course - Oracle SQL for beginners
the interactive exercises
BOANGIU GIORGIANA
Course - Oracle SQL for beginners
the explanations
Daniela
Course - Oracle SQL for beginners
the exercises
