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 the fundamental principles of relational databases
- Key concepts and terminology
- Retrieving data using the SELECT statement
- Employing simple and advanced JOINs to fetch data from multiple tables
- SELF, INNER, and OUTER joins
- Filtering and sorting data, along with conditional expressions
- Single-row functions: manipulating strings, dates, and times
- IF-THEN-ELSE statements
- Converting data between different types
- Generating aggregated reports
- Utilizing correlated and uncorrelated subqueries within SELECT statements
- Retrieving and manipulating data through subqueries
- Executing Data Manipulation Statements in Oracle to handle database transactions
- Optimizing query performance 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 foundational understanding of relational databases.
- Experience in writing basic SQL queries.
- Familiarity with core database management concepts.
Target Audience
- Database developers.
- Database administrators.
- IT professionals working with Oracle databases.
35 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
I found his methods very informative
