Seminar Details

Oracle Database: SQL Workshop I (D80190)

ETC
D80190
Hersteller-ID: D80190GC10
Prüfungs ID:
Dauer: 3 Tage
Preis: € 2.133.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details
This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.

Nach Besuch dieses Seminars haben die Teilnehmer Kenntnisse zu folgenden Themen:
  • Understand SQL statements, as well as the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL statements.
  • Manipulate data in relational tables and save the data.
  • Understand the concepts of relational databases and the powerful SQL programming language.
  • Write reports using SQL Statements

Demonstrations and hands-on practice reinforce the fundamental concepts you’ll delve into in this course. You will discover and use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is also introduced as an optional tool.
Alle Details einblenden

Zielgruppe

Dieses Seminar richtet sich an:
  • Application Developers
  • Forms Developer
  • Functional Implementer
  • PL/SQL Developer
  • System Analysts

Vorkenntnisse

Für diese Seminar werden folgende Kenntnisse empfohlen:
  • Familiarity with data processing concepts and techniques

Schwerpunkte

  1. Introduction
    1. Course Objectives, Course Agenda and Appendixes Used in this Course
    2. Overview of Oracle Database 12c and Related Products
    3. Overview of relational database management concepts and terminologies
    4. Introduction to SQL and its development environments
    5. What is Oracle SQL Developer?
    6. Starting SQL*Plus from Oracle SQL Developer
    7. The Human Resource(HR) Schema
    8. Tables used in the Course
  2. Retrieving Data using the SQL SELECT Statement
    1. Capabilities of the SELECT statement
    2. Arithmetic expressions and NULL values in the SELECT statement
    3. Column aliases
    4. Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword
    5. Use of the DESCRIBE command
  3. Restricting and Sorting Data
    1. Limiting the Rows
    2. Rules of precedence for operators in an expression
    3. Substitution Variables
    4. Using the DEFINE and VERIFY command
  4. Using Single-Row Functions to Customize Output
    1. Describe the differences between single row and multiple row functions
    2. Manipulate strings with character function in the SELECT and WHERE clauses
    3. Manipulate numbers with the ROUND, TRUNC and MOD functions
    4. Perform arithmetic with date data
    5. Manipulate dates with the date functions
  5. Using Conversion Functions and Conditional Expressions
    1. Describe implicit and explicit data type conversion
    2. Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
    3. Nest multiple functions
    4. Apply the NVL, NULLIF, and COALESCE functions to data
    5. Use conditional IF THEN ELSE logic in a SELECT statement
  6. Reporting Aggregated Data Using the Group Functions
    1. Group Functions
    2. Creating Groups of Data
    3. Restricting Group Results
  7. Displaying Data From Multiple Tables Using Joins
    1. Introduction to JOINS
    2. Types of Joins
    3. Natural join
    4. Self-join
    5. Non equijoins
    6. OUTER join
  8. Using Subqueries to Solve Queries
    1. Introduction to Subqueries
    2. Single Row Subqueries
    3. Multiple Row Subqueries
  9. Using the SET Operators
    1. Set Operators
    2. UNION and UNION ALL operator
    3. INTERSECT operator
    4. MINUS operator
    5. Matching the SELECT statements
    6. Using ORDER BY clause in set operations
  10. Managing Tables using DML statements
    1. Data Manipulation Language
    2. Database Transactions
  11. Introduction to Data Definition Language
    1. Data Definition Language
Alle Details ausblenden

1 Termin wählen

Was ist:
ILT

Ihr Klassenraumtraining - mehr Infos zu Instructor Led Trainings bei ETC erhalten Sie HIER

vILT

Mehr Infos zu vILT erhalten Sie hier

Live

Ihr virtuelles Training - mehr Infos zu ETC>Live erhalten Sie HIER

Hybrid VBT

Mehr Infos zu VBTs erhalten Sie HIER

Hybrid MOOC

Mehr Infos zu MOOCs erhalten Sie HIER

Coached Learning

Mehr Infos zu Coached Learning erhalten Sie HIER

Hotseat

Mehr Infos zum ETC Hotseat erhalten Sie HIER

Info

zusätzliche Infos zum Seminartermin

Alle Preise exkl. Mwst.

2 Paket wählen

Oracle Database: SQL Workshop I

Coached Learning

  • Ihre Lernbegleitung mit einem zertifizierten Oracle Trainer
  • Seminarunterlagen, Teamwork, Labs als On Demand Training
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.133.-
(€ 2.133.- p.P.)

Preis

  • Ihr ILT Seminar (Instructor Led Training)
  • Seminarunterlagen, Teamwork, Labs
  • Verpflegung vorort in einem der ETC Seminarzentren
  • Seminar-Services
€ 2.133.-
(€ 2.133.- p.P.)

Könnte sie auch interessieren

Ihre Fragen zum Seminar

CHAT mit Experten ODER Rückruf anfordern

Kein passender Termin dabei? Mehr als 5 Personen? Firmentermin gewünscht?

Rufen sie uns an +43/1/533 17 77 - 99

Bewertungen

1 Bewertungen
super trainer, sehr praxisnahe
von