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 core principles of relational databases
- Key concepts and terminology
- Retrieving data using the SELECT statement
- Utilizing simple and complex JOINS to extract data from multiple tables
- SELF, INNER, and OUTER joins
- Filtering and sorting data, including conditional expressions
- Single-row functions for string, date, and time manipulation
- IF-THEN-ELSE logic
- Converting data types
- Generating aggregated reports
- Employing correlated and uncorrelated subqueries in SELECT statements
- Extracting and manipulating data via subqueries
- Executing Data Manipulation Statements in Oracle to manage database transactions
- Query optimization and efficiency techniques
Database Management
- Introduction and usage of the Oracle Data Dictionary
- Creating views, indexes, constraints, and synonyms
- Granting 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 with basic SQL queries
- Familiarity with database management principles
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
