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
- A solid understanding of relational databases
- Practical experience with basic SQL queries
- Familiarity with database management concepts
Audience
- Database developers
- Database administrators
- IT professionals working with Oracle databases
35 Hours
Testimonials (1)
Greg was very patient and helpful
