Oracle SQL for analysts - fundamentals

General knowledge of IT issues and concepts related to databases and the ability to operate a computer efficiently.

Level
Basic
Form
Lecture, Presentation, Intensive workshop
Purpose of the training
The training is addressed to data analysts and users who need to efficiently and flexibly extract data from the database using SQL language commands directly.
Benefits of completing the training
Learn the basic techniques of data analysis using SQL language.

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