Course Outline
Introduction to Oracle for Government
- Database Architecture
- Relational Database Model
- Users, Schemas, and Sessions
- Tools for Database Interaction
Introduction to the SELECT Statement for Government
- Filtering and Selection Using the WHERE Clause
- Sorting Query Results
- Data Types, Operators, and Handling NULL Values
- Utilizing Built-in Scalar Functions
- Date Operations
- Understanding National and Regional Settings in SQL for Government
Regular Expressions in SQL for Government
- Implementing Regular Expressions for Pattern Matching
Analyzing Aggregated Data for Government
- Using Grouping Functions
- Applying the DISTINCT Clause
- GROUP BY and HAVING Clauses
Retrieving Data from Multiple Tables for Government
- Inner and Outer Joins (INNER JOIN, OUTER JOIN)
- ANSI SQL Syntax and Other Join Methods (SELF JOIN, NATURAL JOIN)
- Set Operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries for Government
- Simple Subqueries
- Correlated Subqueries
- EXISTS and NOT EXISTS Operators
- Other Types of Subqueries
Hierarchical Queries and Sampling for Government
- Constructing 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) for Government
- INSERT, UPDATE, DELETE Statements
- Operations on Large Datasets (INSERT FIRST, INSERT ALL, MERGE)
Managing Concurrent User Access for Government
- Understanding Transactions
- Implementing Locks
- Utilizing FLASHBACK Technology
Overview of Schema Objects for Government
- Views
- Sequences
- Private and Public Synonyms
- Indexes
Summary and Next Steps for Government
Requirements
- Basic knowledge of database systems and general computing principles
Audience for Government
- Database Administrators
- Software Developers
Testimonials (5)
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
Liviu
Course - Oracle SQL LP - Fundamentals
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
