Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Relational Database Models
- Understanding the structure of a relational database.
- Types of table relationships.
- Database normalization and denormalization concepts.
- Relational operators.
Retrieving Data
- Guidelines for writing SQL queries.
- Syntax for the SELECT statement.
- Selecting all columns.
- Queries involving arithmetic operations.
- Using column aliases.
- Understanding literals.
- Using the concatenation operator.
Filtering Results
- Utilizing the WHERE clause.
- Comparison operators.
- The LIKE condition.
- Using the BETWEEN ... AND condition.
- The IS NULL condition.
- Using the IN condition.
- Boolean operators: AND, OR, and NOT.
- Combining multiple conditions in the WHERE clause.
- Operator precedence.
- Using the DISTINCT clause.
Sorting Data
- 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 SYSDATE.
- Handling NULL values.
Aggregating Data with Grouping
- Aggregate functions.
- How aggregate functions handle NULL values.
- Creating data groups using the GROUP BY clause.
- Grouping by multiple columns.
- Filtering grouped results using the HAVING clause.
Retrieving Data from Multiple Tables
- Types of joins.
- Using NATURAL JOIN.
- Table aliases.
- Joining tables in the WHERE clause.
- INNER JOIN.
- Outer joins: LEFT, RIGHT, and FULL OUTER JOIN.
- Cartesian products.
Subqueries
- Using subqueries within the SELECT command.
- Single-row and multi-row subqueries.
- Operators for single-row subqueries.
- Using aggregate functions within subqueries.
- Operators for multi-row subqueries: IN, ALL, and 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
- Commands: COMMIT, ROLLBACK, and SAVEPOINT.
DDL Commands
- Key database objects.
- Object naming conventions.
- Creating tables.
- Available data types for columns.
- Using the DEFAULT option.
- Using NULL and NOT NULL options.
Managing Tables
- Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE constraints.
- Creating tables via query (CTAS).
- Dropping tables: DROP TABLE.
- Using the DESCRIBE command.
Other Schema Objects
- Sequences.
- Synonyms.
- Views.
Requirements
- Basic computer literacy.
- Familiarity with at least one operating system.
21 Hours
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
