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
- Relational model database
- Users diagrams sessions
- Tools
Introduction to the SELECT statement
- Screening and selection (WHERE clause)
- sorting
- Data types, operators, and service NULL
- Built-in scalar functions
- Actions to date
- National and regional settings in SQL
Regular expressions
The analysis of aggregated data
- Grouping functions
- DISTINCT clause
- Clauses GROUP BY and HAVING
Retrieving data from multiple tables
- Inner and outer joins (INNER JOIN, OUTER JOIN)
- ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
- Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Subqueries simple
- Correlated subqueries
- Operators EXISTS and NOT EXISTS
- Other types of subqueries
Inquiries hierarchical and samples
- Construction of the tree (CONNECT BY PRIOR clause and START WITH)
- The SYS_CONNECT_BY_PATH
- Data samples (SAMPLE clause)
Data manipulation (DML)
- INSERT, UPDATE, DELETE
- Operations on a large set of (INSERT FIRST INSERT ALL, MERGE)
Concurrent users work
- Transactions
- Locks
- FLASHBACK
Overview of schema objects
- Vistas
- Sequences
- Synonyms private and public
- Indexes
21 Hours
Testimonials (5)
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
Amna AlAli - Federal Demographic Council
Course - Oracle SQL for beginners
Good atmosphere during the training.