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
Getting Started with the Oracle Database
- Database architecture and sessions
- Relational database model
- Users and schemas
- Tools
Introduction to the SELECT Statement
- Projection and selection
- Sorting
- Operators and handling NULL values
- Query lexical parameters (& and &&)
- Limiting record count (ROWNUM, FETCH, SAMPLE)
Scalar Functions
- Built-in functions and function nesting
- Type conversions
- Enumeration functions
Managing 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
- Advanced join types (SELF, NATURAL, NONEQUAL)
- Set operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Simple subqueries
- Correlated subqueries
- EXISTS and NOT EXISTS operators
- Other subquery types (FROM, WITH, scalar)
Appendix A - Joins Using Oracle's Native SQL Syntax
Appendix B - Tables, Integrity Constraints, and Views
- Table management (CREATE, ALTER, DROP, RENAME)
- Integrity constraints
- Using views in data analysis
Recommended follow-up courses:
ORA_SA2, ORA_SA3
Requirements
General IT knowledge and understanding of database concepts, along with the ability to use a computer efficiently.
21 Hours
Testimonials (3)
Greg was very patient and helpful
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
presentation skills, prompt answers to all questions
Oana - OPEN COURSE
Course - Oracle SQL LP - Fundamentals
I found his methods very informative
