Data Analysis with Oracle 11g - workshop Certificate for Dagmara Bruffaerts

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)

• INSTRUCCIONES INSERT, UPDATE, DELETE
• Operacja na dużych zbiorach (INSERT FIRST, ALL INSERT, MERGE)

Concurrent users work

• Transactions
• Locks
• FLASHBACK

Brief overview of schema objects

• vistas
• sequences
• indexes