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 Overview
- Database architecture fundamentals
- Principles of the relational database model
- Management of users, schemas, and session environments
- Available tools for database interaction
SELECT Statement Fundamentals
- Filtering and selecting data via the WHERE clause
- Ordering query results
- Working with data types, operators, and NULL value handling
- Application of built-in scalar functions
- Date manipulation techniques
- Configuration of national and regional SQL settings
Regular Expressions in SQL
- Implementation of regular expressions for pattern matching
Analysis of Aggregated Data
- Application of grouping functions
- Use of the DISTINCT clause to eliminate duplicates
- Employment of GROUP BY and HAVING clauses
Data Retrieval from Multiple Tables
- Execution of inner and outer joins (INNER JOIN, OUTER JOIN)
- Utilization of ANSI SQL syntax alongside other join methods, including SELF JOIN and NATURAL JOIN
- Application of set operators such as UNION, UNION ALL, INTERSECT, and MINUS
Subqueries
- Development of simple subqueries
- Creation of correlated subqueries
- Use of EXISTS and NOT EXISTS operators
- Exploration of additional subquery types
Hierarchical Queries and Data Sampling
- Construction of hierarchical queries using CONNECT BY PRIOR and START WITH clauses
- Utilization of the SYS_CONNECT_BY_PATH function
- Data sampling techniques via the SAMPLE clause
Data Manipulation (DML)
- Execution of INSERT, UPDATE, and DELETE statements
- Handling large datasets through INSERT FIRST, INSERT ALL, and MERGE operations
Management of Concurrent User Access
- Fundamentals of transaction management
- Implementation of locking mechanisms
- Application of FLASHBACK technology for data recovery
Overview of Schema Objects
- Creation and management of views
- Generation of sequences
- Use of private and public synonyms
- Implementation of indexes for performance optimization
Summary and Next Steps
Requirements
- Fundamental knowledge of database systems and proficiency in core computing principles
Audience
- Database administrators
- Software developers
21 Hours
Testimonials (2)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
