Practical teaching
In addition to class hours, you will practice the topics covered with your instructor and mentor dur
Create account & apply
DATABASE MANAGEMENT · INTERMEDIATE LEVEL
Oracle SQL
Learn advanced SQL querying techniques and optimization strategies for Oracle databases. Topics include complex joins, subqueries, indexing, and performance tuning. This course is vital for database developers and administrators. Our trainers with real-world experience provide hands-on lab sessions.
Intermediate12 weeks48 hoursOn-site
Your selected course will be carried into Ingress Portal.
COURSE HIGHLIGHTS
Mentors
The knowledge and skills you learn at the academy will be further strengthened with the mentor syste
Academic transcript
Assignments and projects are checked by the instructor, and your knowledge and skills are determined
CONDENSED SYLLABUS
See the structure without reading a textbook.
Modules stay collapsed for quick scanning. Open any module to inspect its topics.
01Introduction and Basic Concepts5 lessons+
Definition of RDBMS
What is SQL?
What we can do with SQL?
Advantages of SQL
Basic Select statements (Introduction to SQL)
02Basic Select Statements5 lessons+
Defining column alias
Arithmetic expressions
Selection all columns, specific columns
Concatenation operator
Duplicate and distinct rows
03Restricting and sorting data5 lessons+
BETWEEN condition
AND, OR, NOT operators
LIKE condition
ORDER BY clause for sorting columns
Using WHERE clause
04Single Row functions6 lessons+
General functions
Number functions
Character functions
Type conversion
Date functions
Nesting functions
05Displaying data from multiple tables3 lessons+
What is equijoin and non-equijoin
OUTER, SELF joins and others
Types of joins - INNER, LEFT and RIGHT
06Aggregating Data using group functions3 lessons+
AVG, SUM, MIN, MAX, COUNT functions and etc.
What are group functions
GROUP BY clause, HAVING clause
07Subquery4 lessons+
Single-row and multiple-row subqueries
Subquery syntax
Using ANY and ALL operator
Types of subqueries
08Manipulating data2 lessons+
INSERT, UPDATE, DELETE, MERGE
COMMIT and ROLLBACK
09SET operators4 lessons+
MINUS
UNION
INTERSECT
UNION ALL
10Creating and managing tables4 lessons+
TRUNCATE table
DROP TABLE statements and others
CREATE TABLE statement
ALTER TABLE statement
11Constraints9 lessons+
FOREIGN KEY
DEFAULT
PRIMARY KEY
NOT NULL
Primary and Foreign Key
Table Constraints
CHECK
UNIQUE
CREATE INDEX
12Views3 lessons+
What is View?
Creating view
Updating and dropping view
13Sequences2 lessons+
What are SQL Sequences
How sequences work
UPCOMING GROUPS
Choose the cohort you can actually attend.
Only current, open groups are shown.
STARTS
To be announced
On-site- Schedule
- To be announced
- Format
- On-site
- Duration
- 12 weeks · 48 hours
- Language
- Confirm with advisor
YOUR INSTRUCTOR TEAM
Specialists matched to the modules they teach.
Course delivery is supported by practitioners across engineering, architecture and production backend development.
Saida Kerimli
PL/SQL DeveloperYelo Bank“The program helped me connect individual skills into the way real teams design, build and deliver software.”
See real graduate stories from the Ingress community.
Explore graduate resultsAPPLICATION THROUGH INGRESS PORTAL
Your course stays selected while you create your account.
We use one Portal account for applications, assessments and future learning progress. You will not need to email your details or select the training again.
Questions first? Talk to an advisor- 01
Create or sign in to your Portal accountYour contact details stay connected to one student profile.
- 02
Confirm your application detailsOracle SQL is preselected.
- 03
Submit your applicationThe admissions team receives it immediately and can follow up from the Portal.
SELECTED TRAININGOracle SQLOn-site
Continue in Ingress Portal Already registered? The Portal will let you sign in instead.