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
- Utilizing simple and complex JOINS to retrieve data from multiple tables
- SELF, INNER, and OUTER joins
- Restricting and sorting data, including conditional expressions
- Single-row functions: string, date, and time manipulation
- IF-THEN-ELSE statements
- Converting data between types
- Creating aggregated reports
- Employing correlated and uncorrelated subqueries in SELECT statements
- Retrieving and manipulating data via subqueries
- Executing Data Manipulation Statements in Oracle to manage database transactions
- Query optimization 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
- A solid understanding of relational databases
- Experience with fundamental SQL queries
- Familiarity with database management principles
Target Audience
- Database developers
- Database administrators
- IT professionals working with Oracle databases
35 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized 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 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
I found his methods very informative
