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
Testimonials (7)
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)
The way trainer demonstrated everything
Manveen - 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
- I really liked that the entire training was tailored to the level of all users and to different environments. It was cool to see how queries differ in different environments. - A huge advantage here is that the presenter's goal was to share his knowledge with us, and not to show the participants how smart he is:) - I also consider learning from my own and other people's mistakes to be very valuable because it significantly broadens your horizons.
Kasia
Course - SQL Advanced
Machine Translated
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
The trainer knowledge and style of explication
Vlad-Mihai Nicolae - DB Global Technology SRL
Course - Oracle SQL Advanced
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).