Kontakt

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

OPEN
IN-HOUSE

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.

Go to book catalog

Services

  • Lunch / catering
  • Help with hotel / travel
  • Comelio certificate
  • Flexible: free cancellation up to one day before
Service-Kaffeekanne

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), Normalization
SQL 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 Functions
SQL 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 Queries
SQL Functions
Strings - Mathematics - Date and Time - Aggregates
SQL 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 Formats
SQL DDL: Schema Objects
Creating and Managing Tables - Constraints and Keys - Views - Other Database Objects: Sequences, Indexes, Synonyms
SQL 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, Savepoints

Instructor

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

Projects

He led several research projects and was leading scientist and project manager of a publicly funded project about interactive questionnaires and online surveys.

Research

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.

Certificates

Marco Skulschus is "Oracle Certified Associate" and passed the ComptiaCTT+ examination.