Course Outline
Introduction to working with the Oracle database
- Database architecture
- Relational model of the database
- Users, schemas, sessions
- Tools and configuration files
Query basics
- Projection, selection, sorting
- Operators, expressions, three-state logic
Scalar functions
- Operations on numbers and texts
- Enumeration functions
- Type conversions
- Operations on dates
- Support for national and regional settings
Data aggregations
- Grouping functions
- DISTINCT clause
- GROUP BY and HAVING clauses
Joins
- Cross, inner, outer
- Oracle and ANSI SQL syntax
- Non-standard join methods (SELF, NATURAL, ANTY, NONEQUAL)
- Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Simple subqueries
- Single-line, multi-line, vector subqueries
- Multiple nested
- Subqueries as data sources (FROM, WITH)
Correlated subqueries
- Parameterization of subqueries
- EXISTS and NOT EXISTS operators
- Scalar subqueries
Building a repository
- Creating and managing tables (CREATE, ALTER, DROP, RENAME)
- Integrity ties (CONSTRAINTS)
Data manipulation (DML)
- INSERT, UPDATE, DELETE instructions
- Basics of transactivity
Appendix A - Operations on large data sets (merge, insert all, insert first)
Appendix B - Concurrent user operation
- Autonomous transactions, behavior points
- Locks
- FLASHBACK
Suggested follow-up training courses
ORA_S2, ORA_P1, ORA_P2
Requirements
General knowledge of IT and database concepts and the ability to operate a computer efficiently.
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