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.
Course Outline
Introduction
Database Development
- Recapping the basic principles behind relational databases
- Concepts and terminology
- Retrieving data using the SELECT statement
- Using simple and more complex JOINS to retrieve data from multiple tables
- SELF, INNER and OUTER joins
- Restricting and sorting data, conditional expressions
- Single row functions: string, date and time manipulation
- IF-THEN-ELSE statements
- Conversion of data between types
- Creating aggregated reports
- Using correlated and uncorrelated subqueries in SELECT statements
- Retrieving and manipulating data using subqueries
- Running Data Manipulation Statements in Oracle to manage database transactions
- Query optimisation and efficiency
Database Management
- The Oracle Data Dictionary: introduction and usage
- Creating views, indexes, constraints and synonyms
- Controlling and revoking user access to schema objects (tables, views)
- Managing indexes and constraints
Summary and Next Steps
Requirements
- An understanding of relational databases
- Experience with basic SQL queries
- Familiarity with database management concepts
Audience
- Database developers
- Database administrators
- IT professionals working with Oracle databases
35 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €11400 online delivery, based on a group of 2 delegates, €3600 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
Testimonials (5)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
Amna AlAli - Federal Demographic Council
Course - Oracle SQL for beginners
Trainer provided some topic and support it with plenty of exercises. We had a chance to apply knowledge by doing them on our own.
