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
- Architecture of relational database systems
- Establishing relationships between tables
- Database normalization and denormalization processes
- Application of relational operators
Data retrieval
- Standards for constructing SQL queries
- Syntax for the SELECT statement
- Retrieving all columns from a table
- Executing arithmetic operations within queries
- Assigning aliases to columns
- Utilizing literals in queries
- Using the concatenation operator
Filtering results
- Application of the WHERE clause
- Using comparison operators
- Employing the LIKE condition
- Using the BETWEEN ... AND syntax
- Checking for NULL values with IS NULL
- Using the IN condition
- Applying Boolean operators AND, OR, and NOT
- Combining multiple conditions in the WHERE clause
- Operator precedence rules
- Eliminating duplicates with the DISTINCT clause
Sorting Data
- Application of the ORDER BY clause
- Sorting by multiple columns or complex expressions
SQL functions
- Distinguishing between single-row and multi-row functions
- Characteristics of text, numeric, and date functions
- Explicit and implicit data type conversion
- Using conversion functions
- Nesting functions within queries
- Testing function performance using the dual table
- Retrieving the current date with the SYSDATE function
- Managing NULL values within functions
Aggregating data via grouping
- Application of aggregation functions
- Treatment of NULL values by aggregation functions
- Creating data groups using the GROUP BY clause
- Grouping by multiple columns
- Filtering aggregated results with the HAVING clause
Retrieving data from multiple tables
- Types of table joins
- Using the NATURAL JOIN statement
- Assigning aliases to tables
- Performing joins within the WHERE clause
- Using the INNER JOIN statement
- Using LEFT, RIGHT, and FULL OUTER JOIN statements
- Understanding the Cartesian product
Subqueries
- Positioning subqueries within the SELECT command
- Distinguishing between single-row and multi-row subqueries
- Operators for single-row subqueries
- Applying grouping within subqueries
- Operators for multi-row subqueries (IN, ALL, ANY)
- Treatment of NULL values within subqueries
Set operations
- Using the UNION operator
- Using the UNION ALL operator
- Using the INTERSECT operator
- Using the MINUS operator
Inserting, updating, and deleting data
- Using the INSERT statement
- Copying data from another table
- Using the UPDATE statement
- Using the DELETE statement
- Using the TRUNCATE statement
Transactions
- Managing data changes with COMMIT, ROLLBACK, and SAVEPOINT
Data Definition Language (DDL) commands
- Primary database objects
- Standards for naming database objects
- Creating tables
- Available data types for columns
- Using the DEFAULT option
- Defining NULL and NOT NULL constraints
Managing tables
- Enforcing referential integrity via CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
- Creating tables based on query results
- Dropping tables using DROP TABLE
- Inspecting table structure with the DESCRIBE command
Additional schema objects
- Managing sequences
- Creating synonyms
- Defining views
Requirements
- Basic computer literacy
- Familiarity with standard operating systems
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