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.
Duration 21 hours
Course Outline
Relational database models
- The architecture of a relational database
- Types of table relationships
- Database normalization and denormalization
- Relational Operators
Data retrieval
- Best practices for writing SQL queries
- Syntax of the SELECT statement
- Selecting all columns
- Executing arithmetic operations
- Column aliases
- Literals
- Concatenation operators
Filtering results
- The WHERE clause
- Comparison operators
- The LIKE condition
- The BETWEEN ... AND condition
- The IS NULL condition
- The IN condition
- Boolean operators AND, OR, and NOT
- Combining multiple conditions in the WHERE clause
- Operator precedence
- The 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 conversions
- Conversion functions
- Nesting functions
- Testing function performance using the dual table
- Retrieving the current date with the SYSDATE function
- Managing NULL values
Data aggregation via grouping
- Aggregation functions
- How aggregation functions handle NULL values
- Creating data groups with the GROUP BY clause
- Grouping on multiple columns
- Filtering aggregated results with the HAVING clause
Retrieving data from multiple tables
- Types of joins
- Using NATURAL JOIN
- Table aliases
- Joins in the WHERE clause
- INNER JOIN
- Outer joins: LEFT, RIGHT, and FULL OUTER JOIN
- Cartesian products
Subqueries
- Placing subqueries within the SELECT command
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Aggregation 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
- Primary database objects
- Naming conventions for objects
- Creating tables
- Available data types for columns
- The DEFAULT option
- NULL and NOT NULL constraints
Table management
- Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
- Creating tables from a query
- Dropping tables with DROP TABLE
- The DESCRIBE command
Additional schema objects
- Sequences
- Synonyms
- Views
Requirements
- General computer proficiency
- Familiarity with any operating system
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
