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
Oracle Database Fundamentals
- Database architecture overview
- Relational database model principles
- Users, schemas, and session management
- Utilities for database interaction
Introduction to SELECT Statements
- Filtering and selecting data via the WHERE clause
- Ordering query results
- Data types, operators, and NULL value handling
- Application of built-in scalar functions
- Date manipulation techniques
- SQL national language support and regional configurations
Analyzing Aggregated Data
- Aggregate functions
- DISTINCT clause usage
- GROUP BY and HAVING clauses
Retrieving Data from Multiple Tables
- Inner and outer joins (INNER JOIN, OUTER JOIN)
- ANSI SQL syntax and alternative join methods (SELF JOIN, NATURAL JOIN)
- Set operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Simple subqueries
- Correlated subqueries
- EXISTS and NOT EXISTS operators
- Additional subquery types
Hierarchical Queries and Sampling
- Constructing hierarchical queries using CONNECT BY PRIOR and START WITH clauses
- Using the SYS_CONNECT_BY_PATH function
- Data sampling with the SAMPLE clause
Data Manipulation Language (DML)
- INSERT, UPDATE, DELETE statements
- Operations on large datasets (INSERT FIRST, INSERT ALL, MERGE)
System Dictionary
- Navigating and utilizing the Oracle data dictionary
Concurrent User Work
- Transactions
- Locks
- FLASHBACK technology
Users and Permissions
- Creating and modifying users and schemas
- Permissions and roles management
Managing Data Storage - Logical Layer
- Tables, temporary tables, and index-organized tables
- Constraints
- Indexes
- Views, sequences, synonyms, materialized views
- Stored PL/SQL units
Data Model Representation and Restoration Using Oracle SQL Developer Data Modeler
- Leveraging Oracle SQL Developer Data Modeler for data modeling and restoration
Moving Data
- Logical data copy - Data Pump import and export
- Loading data - SQL*Loader
- External tables
- Database links
Automating Tasks
- Using DBMS_JOB and DBMS_SCHEDULER for task automation
Summary and Next Steps
Requirements
- Fundamental understanding of information technology principles
Audience
- Software developers
- Database administrators
35 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
