IT / Programming / Oracle / Oracle 19c / SQL
| ID | 2757631 |
|---|---|
| Classroom | 3 days 9:00-16:30 |
| Webinar | 5 days 9:00-12:30 |
| Method | Lecture with examples and exercises. |
| Prequisite | General database knowledge |
| Audience | Programmers, developers, DB developers |
Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications in turn must use SQL when executing the user's request. The strengths of SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. The purpose of SQL is to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database. This training covers all key concepts of using SQL like a) querying data, b) inserting, updating, and deleting rows in a table, c) creating, replacing, altering, and dropping objects, d) controlling access to the database and its objects, and e) guaranteeing database consistency and integrity.
The Relational Database System: Key Concepts, Requirements for a DBMS, Architecture Patterns, System Components - The Relational Model: Basic Concepts, Semantic Model, Characteristics of Data and Data Types, Relationships, Entity-Relationship Model (ERM), Normalization
Fundamental Structures of Queries - Filters and Operators - Sorting: Single and Multiple Sorting - Grouping: Standard Aggregate Functions, Grouping, Groups with Multiple Columns, Groups with Different Aggregate Functions
Queries with Multiple Tables: Principle of Queries using Multiple Tables, Manual and ANSI SQL Joins - Subqueries: Replacement of Values, Subqueries in the Column List, Correlated Subqueries, Derived Tables, Predicates with Subqueries - Advanced Techniques in SQL: Case Distinctions, Access to Pseudo Columns - Hierarchical Queries
Strings - Mathematics - Date and Time - Aggregates
Advanced Grouping: Purpose of Extensions to GROUP BY, GROUPING SETS, ROLLUP, CUBE, GROUPING Functions - Creating Rankings: Rankings, Charts, Ranking with Distributions, Quantiles, Histograms, Individual Row Numbers for Records - Statistical Analysis in SQL: Window Functions, Centered Moving Average, Cumulation, First and Last Values ??of a Subset, Linear Regression - Advanced Query Techniques: Common Table Expressions (CTE), Pivoting and Unpivotierung - Simple Reports with SQL*Plus: Simple Reports, Grouping and Aggregates, Output Options and Report Formats
Creating and Managing Tables - Constraints and Keys - Views - Other Database Objects: Sequences, Indexes, Synonyms
Inserting Data: The Standard Case, Inserting Data from Query, Inserting into Multiple Tables - Updating Data: The Standard Case, Updating Based on Other Table Data using Subqueries - Deleting Data: The Standard Case, The Use of Subqueries - Transactions in DML Operations: Basics, Instructions for Transaction Control, Savepoints
Marco Skulschus (born in Germany in 1978) studied economics in Wuppertal (Germany) and Paris (France) and wrote his master´s thesis about semantic data modeling. He started working as a lecturer and consultant in 2002.
He works as an IT-consultant and project manager. He developed various Business Intelligence systems for industry clients and the public sector. For several years now, he is responsible for a BI-team in India which is mainly involved in BI and OLAP projects, reporting systems as well as statistical analysis and Data Mining. He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.
