Oracle SQL - 3 days online classroom
1.950,00 EUR
- 3 days
Develop practical Oracle SQL skills and learn how to work confidently with relational databases using industry-standard SQL techniques. This hands-on Oracle SQL course teaches you how to retrieve, filter, manipulate, and manage data within Oracle database environments while building a strong foundation in database querying and reporting.
Key Features
Language
Course material in English
Level
Beginner - Intermediate level
3 days of live instructor-led
Virtual training (8 hours / day)
Interactive hands-on live labs
All relevant course materials
40+ recommended study hours
Program completion certification included
Learning Outcomes
At the end of this program, you will be able to:
Oracle SQL Fundamentals
Build a strong foundation in Oracle SQL by learning how to write queries, combine data with joins, and use SQL functions for data analysis and reporting.
Dynamic SQL with Parameters
Learn how to use SQL parameters and substitution variables to create flexible, reusable, and interactive SQL scripts that adapt to different user inputs and scenarios.
Advanced Subqueries & Query Techniques
Develop advanced querying skills using inline views, correlated subqueries, multi-column queries, and filtering techniques with ANY, ALL, and SOME for more precise data retrieval.
Transaction Control & Database Performance
Understand how to manage transactions using commit, rollback, and savepoints while improving database performance with indexes, views, and query optimization techniques.
Course timeline
Day 1
Session 1: Relational Database Concepts
- Oracle database fundamentals
- Tables, rows, columns, and data types
- Primary keys, foreign keys, and indexes
- Understanding the data dictionary
Session 2: Using SQL*Plus
- Introduction to SQL*Plus
- Executing and editing SQL statements
- Working with SQL files and command history
- Using the SQLcl utility
Session 3: Using SQL Developer
- Oracle SQL Developer overview
- Configuring database connections
- SQL Worksheet and Query Builder tools
Session 4: Retrieving Data with SELECT
- SELECT, FROM, and WHERE clauses
- Conditional and logical operators
- ORDER BY, aliases, and expressions
- Operator precedence and CSV output
Session 5: Aggregate Functions
- Built-in aggregate functions
- GROUP BY and HAVING clauses
Session 6: Joining Tables
- Inner, outer, and self joins
- Table aliases and ANSI joins
Session 7: Subqueries & Set Operators
- Basic subqueries
- UNION, INTERSECT, and MINUS operators
Day 2
Session 8: Numeric, Character & Date Functions
- Numeric, character, and date functions
- Using the DUAL table
- String concatenation and date arithmetic
Session 9: Conversion & Miscellaneous Functions
- Conversion functions
- NVL, NVL2, COALESCE, and NULLIF
- DECODE and CASE expressions
Session 10: SQL Parameters
- Command-line substitution parameters
- ACCEPT, DEFINE, and UNDEFINE commands
Session 11: Complex Subqueries
- Advanced subquery techniques
- Inline views and Top-N queries
- Correlated and multi-column subqueries
- ANY, ALL, and SOME operators
Day 3
Session 12: Managing Data
- Inserting, updating, and deleting rows
- Verifying changes and transaction control
- Commit, rollback, and savepoints
- Managing data in SQL Developer
Session 13: Managing Tables
- Creating and modifying tables
- Working with constraints
- Dropping and recovering tables
- Copying tables
Session 14: Managing Indexes & Views
- Creating and managing indexes
- Creating, using, and removing views
- Listing indexes and views
Session 15: Managing Sequences & Synonyms
- Creating and viewing sequences
- Creating and listing synonyms
Who Should Enroll in this Program?
Database administrators and aspiring DBAs
Data analysts and business intelligence professionals
Software and application developers
IT professionals working with Oracle databases
Technical support and reporting specialists
Professionals transitioning into database-related roles
Prerequisites
- Basic computer and IT literacy
- Familiarity with databases and data concepts is beneficial
- No prior Oracle SQL experience required
- Basic understanding of programming or data handling concepts is helpful but not mandatory
Statements
Licensing and accreditation
The course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Question
Need corporate solutions or LMS integration?
Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!