Oracle Data Analyst Online Training
Oracle Data Analyst Online Training
Oracle Data Analyst Online Training
Oracle Data Analyst Online Training Course Content :
Introduction to the Oracle database
- Database Architecture
- Relational model database
- Users diagrams sessions
- Tools
Introduction to the SELECT statement
- Screening and selection (WHERE clause)
- sorting
- Data types, operators, and service NULL
- Built-in scalar functions
- Actions to date
- National and regional settings in SQL
Regular expressions
The analysis of aggregated data
- grouping Functions
- DISTINCT clause
- The GROUP BY clause and HAVING.
- Summary (clauses ROLLUP, CUBE, GROUPING)
Retrieving data from multiple tables
- Inner and outer joins (INNER JOIN, OUTER JOIN)
- ANSI SQL syntax, and other methods connectors (SELF JOIN, NATURAL JOIN)
- Collective operators (UNION, UNION ALL, INTERSECT, MINUS)
Subqueries
- Subqueries simple
- Correlated subqueries
- Operators EXISTS and NOT EXISTS
- Other types of subqueries
Inquiries hierarchical and samples
- Construction of the tree (CONNECT BY PRIOR clause and START WITH)
- The SYS_CONNECT_BY_PATH
- Data samples (SAMPLE clause)
Analytic Functions
- Generating summaries
- Definition window
- Statistical Functions
- New features in Oracle 11g
Inquiries Pivot (PIVOT, UNPIVOT)
Tables and referential integrity
- Managing tables (CREATE, ALTER, DROP, RENAME)
- Referential integrity (constraints)
Data manipulation (DML)
- INSTRUCTIONS INSERT, UPDATE, DELETE
- Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)
Concurrent users work
- Transactions
- Locks
- FLASHBACK
Brief overview of schema objects