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
- Extracting data via the SELECT statement
- Employing simple and advanced JOINS to fetch data across multiple tables
- SELF, INNER, and OUTER joins
- Filtering and ordering data, utilizing conditional expressions
- Single-row functions: handling string, date, and time data
- IF-THEN-ELSE logic
- Data type conversions
- Generating summarized reports
- Utilizing correlated and uncorrelated subqueries within SELECT statements
- Fetching and modifying data through subqueries
- Executing Data Manipulation Statements in Oracle to handle database transactions
- Query optimization and performance enhancement
Database Management
- The Oracle Data Dictionary: overview and practical application
- Establishing views, indexes, constraints, and synonyms
- Granting and revoking user access to schema objects (tables, views)
- Administering indexes and constraints
Summary and Future Steps
Requirements
- Foundational knowledge of relational databases
- Practical experience with fundamental SQL queries
- Understanding of database management principles
Target Audience
- Database developers
- Database administrators
- IT specialists utilizing Oracle databases
35 Hours
Testimonials (2)
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
many exercises with lots of explanations and time allocated for potential questions.
