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
- Reviewing foundational principles of relational databases
- Core concepts and terminology
- Fetching data using the SELECT statement
- Employing simple and complex JOINS to extract data from multiple tables
- SELF, INNER, and OUTER joins
- Filtering and sorting data, utilizing conditional expressions
- Single-row functions: string, date, and time manipulation
- IF-THEN-ELSE logic
- Data type conversion
- Generating aggregated reports
- Utilizing correlated and uncorrelated subqueries within SELECT statements
- Retrieving and altering data via subqueries
- Executing Data Manipulation Statements in Oracle to handle database transactions
- Enhancing query optimization and efficiency
Database Management
- Introduction and application of the Oracle Data Dictionary
- Constructing views, indexes, constraints, and synonyms
- Granting and revoking user access to schema objects (tables, views)
- Handling indexes and constraints
Summary and Future Directions
Requirements
- Knowledge of relational databases
- Hands-on experience with fundamental SQL queries
- Understanding of database management principles
Target Audience
- Database developers
- Database administrators
- IT specialists working with Oracle databases
35 Hours
Testimonials (1)
Greg was very patient and helpful
