Course Outline
Regular expressions in SQL
- Searching through data
- Data transformations
Hierarchical queries
- Building a tree (CONNECT BY PRIOR clause and START WITH clause)
- SYS_CONNECT_BY_PATH function
Advanced grouping
- Operations on data strings (WITHIN GROUP)
- Operations on the first/last row of a string (KEEP)
- Aggregations in bulk (ROLLUP, CUBE, GROUPING SET)
- Pivot tables (PIVOT, UNPIVOT)
Analytical functions
- Generation of partial summaries
- Ranking functions
- Dynamic windows
Data manipulation (DML)
- Inserting, modifying, deleting data (INSERT, UPDATE, DELETE)
- Truncating tables (TRUNCATE)
Concurrent user operation
- Transactions
- Consistency of data over time
- Locks
- FLASHBACK
Appendix A - Moving and loading data
- Database links
- Exporting query results to csv file
- Importing data from a csv file, SqlLoader
- External tables
Appendix B - Miscellaneous database objects
- System dictionary
- Views
- Sequences
- Indexes
- Synonyms
- PL/SQL syntax programs
Suggested pre-training
ORA_SA1 or ORA_S1
Suggested follow-up training
ORA_SA3
Requirements
Knowledge of issues related to relational databases, free use of the SELECT statement in terms of projection, selection, joins and subqueries.
Testimonials (7)
wiedza i przekłady
Jan Maksymowski
Course - Oracle 11g - Język SQL dla administratorów - warsztaty
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Szkolenie było przygotowane perfekcyjnie, najbardziej podobał mi się sposób prowadzenia oparty przykładach pisanych w czasie rzeczywistym z dokładnym omówieniem jaki wpływ na bazę danych mają poszczególne instrukcje.
Joanna Dymarczyk
Course - Oracle 11g - Programowanie w PL/SQL I - warsztaty
Method of translating the material and examples shown.
Marek Jakimowicz
Course - Tuning SQL i PL/SQL dla programistów
Machine Translated
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
Trainer expertise on SQL tuning
Bogdan - DB Global Technology
Course - Oracle 11g - Application Tuning - Workshop
it was very well organized