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)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
During the training, all modules were discussed in great detail - for two days of training - and that was what I cared about the most.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had exercises. It helps to remember discussed topic.