Course Outline
SQL analytical extension
- Summary during groupings
- Operations on strings of records
- Analytical form of aggregation functions
- Rankings and windows
Hierarchical queries and samples
- Tree construction (CONNECT BY PRIOR clause and START WITH clause).
- SYS_CONNECT_BY_PATH function
- Samples of data (SAMPLE clause)
Regular expressions in SQL
- Searching through data
- Data transformations
Repository operations
- System dictionary
- Constraint management
- Temporary tables
- Views
- Sequences
- Indexes
- Synonyms
- Database links
- External tables
Appendix A - Managing users and permissions
- Users and schemas
- System and object permissions
- Roles
- Profiles
Suggested pre-training
ORA_S1 or ORA_SA1
Suggested supplementary training courses
ORA_SP3, ORA_P1,ORA_P2
Requirements
Knowledge of 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