Course Outline
Relational Database Models
- Understanding the structure of a relational database
- Different types of table connections
- Database normalization and denormalization
- Relational operators
Extracting Data
- Best practices for writing SQL queries
- SELECT statement syntax
- Retrieving all columns
- Performing arithmetic operations within queries
- Using column aliases
- Working with literals
- The concatenation operator
Filtering Results
- The WHERE clause
- Comparison operators
- The LIKE condition
- The BETWEEN ... AND prerequisite
- The IS NULL condition
- The IN condition
- Boolean operators: AND, OR, and NOT
- Combining multiple conditions in the WHERE clause
- Operator precedence and ordering
- The DISTINCT clause
Sorting Data
- The ORDER BY clause
- Sorting by multiple columns or expressions
SQL Functions
- Differences between single-line and multi-line functions
- Text, numeric, and date functions
- Explicit and implicit data conversion
- Conversion functions
- Nesting functions
- Viewing function performance using the dual table
- The SYSDATE function for retrieving the current date
- Handling NULL values
Aggregating Data with Grouping
- Grouping functions
- How grouping functions treat NULL values
- Creating data groups with the GROUP BY clause
- Grouping across multiple columns
- Filtering grouped results with the HAVING clause
Retrieving Data from Multiple Tables
- Types of join connectors
- Using NATURAL JOIN
- Table aliases
- Performing joins within the WHERE clause
- INNER JOIN
- External joins: LEFT, RIGHT, and FULL OUTER JOIN
- The Cartesian product
Subqueries
- Placing subqueries within the SELECT command
- Single-row and multi-row subqueries
- Operators for single-row subqueries
- Grouping features within subqueries
- Operators for multi-row subqueries: IN, ALL, ANY
- How NULL values are treated in subqueries
Set Operators
- The UNION operator
- The UNION ALL operator
- The INTERSECT operator
- The MINUS operator
Inserting, Updating, and Deleting Data
- The INSERT command
- Copying data from another table
- The UPDATE command
- The DELETE command
- The TRUNCATE command
Transactions
- Using COMMIT, ROLLBACK, and SAVEPOINT commands
DDL Commands
- Key database objects
- Object naming conventions
- Creating tables
- Available data types for columns
- The DEFAULT option
- NULL and NOT NULL constraints
Managing Tables
- Referential integrity: CHECK, PRIMARY KEY, FOREIGN KEY, and UNIQUE constraints
- Creating a table from a query
- Dropping a table with DROP TABLE
- The 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.
- Customised 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 £4800 + 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