Oracle SQL - introduction to working with the database

General knowledge of IT and database concepts and the ability to operate a computer efficiently.

Level
Basic
Form
Lecture, Presentation, Workshop
Purpose of the training
The training is dedicated to people with a user, programmer or administrator profile who are starting to work with Oracle database.
Benefits of completing the training
The training will provide participants with the skills to work with Oracle database using SQL language and enables them to participate in further directional training in this field. 
The training prepares you to pass the Oracle Database 12c: SQL Fundamentals (1Z0-061) certification exam, which is an official, internationally respected validation of your skills and required for most Oracle certifications in database administration and programming.

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