Course Outline
Getting started with the Oracle database
- Database architecture, sessions
- Relational model of the database
- Users and schemas
- Tools
Introduction to the SELECT statement
- Projection and selection
- Sorting
- Operators and handling of NULL
- Query lexical parameters (& and &&)
- Limiting the number of records (ROWNUM, FETCH, SAMPLE)
Scalar functions
- Built-in functions, nesting of functions
- Type conversions
- Enumeration functions
Handling time and regional settings
- Date operations
- Local national and regional settings in SQL
Grouping and aggregation
- Grouping functions
- DISTINCT clause
- GROUP BY and HAVING clauses
Retrieving data from multiple tables
- Cross, inner and outer joins (cross, inner, outer)
- Unusual forms of joins (SELF, NATURAL, NONEQUAL)
- Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Simple subqueries
- Correlated subqueries
- EXISTS and NOT EXISTS operators
- Other types of subqueries (FROM, WITH, scalar)
Appendix A - Joins using Oracle's native SQL syntax
Appendix B - Tables, integrity constraints, views
- Table management (CREATE, ALTER, DROP, RENAME)
- Integrity ties (CONSTRAINTS)
- Use of views during data analysis
Suggested follow-up training courses
ORA_SA2, ORA_SA3
Requirements
General knowledge of IT issues and concepts related to databases 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