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
- Extracting data using the SELECT statement
- Employing simple and advanced JOINS to retrieve data across multiple tables
- SELF, INNER, and OUTER joins
- Filtering and sorting data, along with conditional expressions
- Single row functions: manipulation of strings, dates, and times
- IF-THEN-ELSE logic
- Data type conversion
- Generating aggregated reports
- Leveraging correlated and uncorrelated subqueries within SELECT statements
- Retrieving and manipulating data through subqueries
- Executing Data Manipulation Statements in Oracle to oversee database transactions
- Query optimization and performance efficiency
Database Management
- The Oracle Data Dictionary: introduction and practical usage
- Establishing 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
- Practical experience with basic SQL queries
- Familiarity with core database management concepts
Audience
- Database developers
- Database administrators
- IT professionals engaged 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
