Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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.
21 Hours
Testimonials (5)
overall a good training that responds to my needs. I received also information about Oracle VM VirtualBox allowing me to continue the practice on my own.
Liviu
Course - Oracle SQL LP - Fundamentals
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
