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 foundational principles of relational databases
- Concepts and terminology
- Retrieving data using the SELECT statement
- Utilizing simple and advanced JOINS to extract data from multiple tables
- SELF, INNER, and OUTER joins
- Filtering and sorting data, including conditional expressions
- Single-row functions: string, date, and time manipulation
- IF-THEN-ELSE statements
- Data type conversion
- Generating aggregated reports
- Employing correlated and uncorrelated subqueries within SELECT statements
- Extracting and manipulating data via subqueries
- Executing Data Manipulation Statements in Oracle to manage database transactions
- Query optimization 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
- Knowledge of relational databases
- Experience with basic SQL queries
- Familiarity with database management concepts
Audience
- Database developers
- Database administrators
- IT professionals working with Oracle databases
35 Hours
Testimonials (1)
Greg was very patient and helpful
