Price per person
€ 2.600,- (excluding VAT)
Duration of this course
4 days
Course dates
4 - 7 november 2024
3 - 6 december 2024
Oracle SQL
This course is only available in Dutch. Would you prefer to take the course in English? Please contact us.
A solid understanding of the SQL language is essential if you are going to develop in an Oracle environment or if you need to manage such an environment. Additionally, proficiency with SQL*Plus and SQL Developer products is necessary. In this four-day training, we provide you with the essential building blocks to work with Oracle. You will have ample time for hands-on practice: 60% of the course time is dedicated to completing exercises, while the remaining 40% is devoted to explanations and demonstrations.
You will learn:
- What the essential features of a relational database are
- How to query, insert, delete, and update data in Oracle tables
- How to create, remove, and potentially modify objects such as tables, constraints, views, and sequences
- The key skills in using SQL*Plus and SQL Developer
- How to systematically structure SQL queries based on a data model
- How to utilize the main syntactic capabilities (operators and functions) of the SQL language
- How to handle the transaction and locking mechanism
- How to avoid the most common pitfalls
Topics:
- Concepts of relational databases
- Connecting to the database
- Operators and the case expression
- Text, numeric, date, general, and conversion functions
- Aggregate functions and grouping
- Analytical functions
- Joins
- Set operators
- Subqueries and inline views
- Referential integrity and constraints
- Hierarchical querying (connect by)
- Data manipulation: insert, update, and delete
- Transactions and locking
- Data definition: creating and modifying tables, views, and sequences
- SQL*Plus commands
- Data dictionary
- The SQL Developer interface
- Avoiding pitfalls
Who should attend?
The course is intended for application designers and developers who are working with or will be working with an Oracle database and/or Oracle tools.
Prior knowledge
No special knowledge is assumed.
Share this training
This training is also part of
- Oracle APEX Developer
- Oracle Developer
- Oracle Database Administrator
- Oracle Data Warehouse Developer
Related training courses
- Oracle: PL/SQL programming
- Optimize Oracle SQL and PL/SQL
- Oracle Designer 10g: Analysis
- Oracle Designer 10g: Database design and generation
- Oracle Designer 10g: Application design and generation
- Oracle Reports 11g: Fundamentals
- Oracle Forms 11g: Fundamentals
- New in Oracle Database 19c
- Linux for Oracle environments
- Workshop: Performance Tuning
- Oracle: Backup & Recovery
- Oracle: Database management
- Workshop: Oracle Data Guard
- Oracle Data Integrator
- Oracle APEX Advanced
- Oracle APEX Case
- JavaScript: Client side
- Introduction HTML & CSS
- Java Programming
- Oracle APEX Fundamentals
- Oracle WebLogic Server 12c for Fusion Middleware administrators
- Oracle: Database concepts for developers
- Oracle: SQL en PL/SQL advanced
- Oracle: XML fundamentals