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
- Structure of a relational database
- Table join types
- Database normalization and denormalization
- Relational operators
Retrieving Data
- Rules for writing SQL queries
- SELECT syntax
- Selecting all columns
- Queries with arithmetic operations
- Column aliases
- Literals
- Concatenation operator
Filtering Results
- The WHERE clause
- Comparison operators
- LIKE condition
- Condition BETWEEN ... AND
- IS NULL condition
- Condition IN
- Boolean operators: AND, OR, 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
- Viewing function results using the dual table
- Retrieving the current date with SYSDATE
- Handling NULL values
Aggregating Data Using 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
- Join types
- Using NATURAL JOIN
- Table aliases
- Joins within the WHERE clause
- INNER JOIN
- Outer joins: LEFT, RIGHT, FULL OUTER
- Cartesian product
Subqueries
- Placing subqueries in the SELECT statement
- Single-line and multi-line subqueries
- Operators for single-line subqueries
- Aggregate functions in subqueries
- Operators for multi-line subqueries: IN, ALL, ANY
- Handling of 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
- Primary database objects
- Object naming rules
- Creating tables
- Column data types
- DEFAULT option
- NULL and NOT NULL options
Table Management
- Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, UNIQUE
- Creating a table via query
- Dropping a table: DROP TABLE
- DESCRIBE command
Other Schema Objects
- Sequences
- Synonyms
- Views
Requirements
- Basic computer literacy
- Familiarity with any 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
