Oracle 19c - SQL
Course Overview
| ID | 2102001 |
| 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
Description
Learn SQL in Oracle to perform simple and complex queries and analyses in an Oracle database and to make data and structural changes.
Services
- Lunch / catering
- Help with hotel / travel
- Comelio certificate
- Flexible: free cancellation up to one day before
Comelio Media
Still looking for additional reading? Discover suitable specialist books in our catalog.
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
Our Oracle trainer, Marco Skulschus, studied economics with a focus on business informatics in Wuppertal and Paris and has been working as an Oracle trainer and Oracle DB developer for data warehousing and reporting solutions for over 10 years. He has published several books on Oracle SQL and Oracle PL/SQL.
Publications
- Oracle SQL (Comelio Medien )
978-3-939701-41-5 - Oracle PL/SQL (Comelio Medien )
978-3-939701-40-8 - Oracle PL/SQL - Objektrelationale Techniken (Comelio Medien )
978-3-939701-42-2 - Oracle, PL/SQL und XML (Comelio Medien )
978-3-939701-49-1 - Oracle 10g: Programmierung mit PL/SQL, Java, PHP und C++ (Galileo Computing )
978-3898423144