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 via the SELECT statement
- Employing simple and advanced JOINs to gather data from multiple tables
- SELF, INNER, and OUTER joins
- Filtering and ordering data, alongside conditional expressions
- Single-row functions: handling strings, dates, and time
- IF-THEN-ELSE logic
- Converting data types
- Generating aggregated reports
- Utilizing correlated and uncorrelated subqueries within SELECT statements
- Fetching and altering data through subqueries
- Executing Data Manipulation Statements in Oracle to handle database transactions
- Ensuring query optimization and efficiency
Database Management
- Introduction to and usage of the Oracle Data Dictionary
- Establishing views, indexes, constraints, and synonyms
- Governing and revoking user permissions for schema objects (tables, views)
- Oversight of indexes and constraints
Summary and Next Steps
Requirements
- A solid grasp of relational database principles
- Hands-on experience with fundamental SQL queries
- Knowledge of database management concepts
Target 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
