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 to Oracle
- Database architecture
- The relational database model
- Users, schemas, and sessions
- Tools for database interaction
Introduction to the SELECT Statement
- Filtering and selecting data using the WHERE clause
- Sorting query results
- Data types, operators, and handling NULL values
- Using built-in scalar functions
- Date operations
- Understanding national and regional settings in SQL
Regular Expressions in SQL
- Applying regular expressions for pattern matching
Analyzing Aggregated Data
- Using grouping functions
- Applying the DISTINCT clause
- Using 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
- Other types of subqueries
Hierarchical Queries and Sampling
- Building hierarchical queries using CONNECT BY PRIOR and START WITH clauses
- Utilizing the SYS_CONNECT_BY_PATH function
- Sampling data with the SAMPLE clause
Data Manipulation (DML)
- INSERT, UPDATE, and DELETE statements
- Operations on large datasets (INSERT FIRST, INSERT ALL, MERGE)
Managing Concurrent User Access
- Understanding transactions
- Implementing locks
- Leveraging FLASHBACK technology
Overview of Schema Objects
- Views
- Sequences
- Private and public synonyms
- Indexes
Summary and Next Steps
Requirements
- A foundational grasp of databases and familiarity with general computing principles
Target Audience
- Database administrators
- Developers
21 Hours
Testimonials (1)
Greg was very patient and helpful
