Oracle 19c - SQL
Details
| ID | 2757631 |
| Duration | 3.0 days |
| Methods | Lecture with examples and exercises. |
| Prerequisites | General database knowledge |
| Target group | Programmers, developers, DB developers |
Overview
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.
Dates
Zurzeit stehen keine offenen Termine zur Verfügung. Nutzen Sie alternativ die Inhouse‑Option.
Learn with customized examples and content—precisely tailored to your requirements.
Your benefits at a glance
- Flexible preferred date
- Customized content
- Intensive exchange
- High practical relevance
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Content
SQL and Relationa Databases
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), NormalizationSQL DML: Simple Queries
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 FunctionsSQL DML: Advanced Queries
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 QueriesSQL Functions
Strings - Mathematics - Date and Time - AggregatesSQL DML: Queries and Analyses
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 FormatsSQL DDL: Schema Objects
Creating and Managing Tables - Constraints and Keys - Views - Other Database Objects: Sequences, Indexes, SynonymsSQL DML: Data Manipulation
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, SavepointsInstructor
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.Publications
- Oracle PL/SQL (Comelio Medien)
978-3-939701-40-8 - Oracle SQL (Comelio Medien)
978-3-939701-41-5 - Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien)
978-3-939701-42-2 - Oracle, PL/SQL und XML (Comelio Medien)
978-3-939701-49-1