Seminar Details

Oracle Database 12c: Introduction for Experienced SQL Users (D81142)

ETC
D81142
Hersteller-ID:
Prüfungs ID:
Dauer: 2 Tage
Preis: € 1.422.- exkl.MwST
Wissensgarantie: hier nicht automatisch anwendbar – bitte kontaktieren Sie Ihren Betreuer für Details
In this Oracle Database 12c: Introduction for Experienced SQL Users training, you learn about Oracle Database 12c, the database environment and the Oracle SQL Developer tool. Expert Oracle University instructors will teach you how to create and manage tables, synonyms, sequences, indexes and views.
Alle Details einblenden

Zielgruppe

  • Data Warehouse Developer
  • Data Warehouse Developer
  • Application Developers
  • Database Administrators
  • Database Administrators
  • Developer

Vorkenntnisse

Required Prerequisite
  • Oracle Database: SQL Workshop I
  • Oracle Database: SQL Workshop II

Suggested Prerequisite
  • SQL Developer
  • Experience with SQL

Schwerpunkte

Course Overview
  • Identify the Appendices Used in this Course
  • Course Objectives, Course Agenda and Class Account Information
  • Describe the Human Resources (HR) Schema
Understanding the Oracle Database Environment
  • Understanding Data Flow During SQL Statement Processing
  • Understanding Read Consistency
  • Understanding the Oracle Database Environment
  • Processing a SQL Statement
  • Understanding the Oracle Instance
Using SQL Developer
  • SQL Developer
Getting Started with Oracle SQL
  • How Oracle SQL treats NULLs
  • Using Pseudocolumns
  • Using Operators, Expressions and Functions
  • Basic SQL statements
  • Understanding Data Types and Date Format
Combining Tables by Using Advanced Queries
  • Perform joins in Oracle SQL
  • Update and delete rows by using correlated subqueries
  • Subqueries
  • Exclude branches from the tree structure
  • Create a tree-structured report
Creating and Managing Tables
  • Use the data dictionary to view and maintain information about tables
  • Using CREATE, ALTER, DROP, RENAME, COMMENT, and TRUNCATE statement
  • Create and maintain integrity constraints
Creating and Managing Other Oracle Database Objects
  • Create and maintain indexes
  • Create and maintain a view
  • Create private and public synonyms
  • Create, maintain, and use sequences
Oracle Database Extensions to DML and DDL Statements
  • Describe transaction processing
  • Create and use external tables
  • Describe the features of multitable INSERT statements
  • Merge rows by using the MERGE statement
Controlling User Access
  • Create and access database links
  • Discuss the concepts of users, roles, and privileges
  • Create users
  • Grant and revoke object privileges
  • Create roles
Alle Details ausblenden

Termin Anfragen

    Durch Angabe Ihrer E-Mail-Adresse und Anklicken des Buttons „Newsletter abonnieren“ erklären Sie sich damit einverstanden, dass ETC Ihnen regelmäßig Informationen zu IT Seminaren und weiteren Trainings- und Weiterbildungsthemen zusendet. Die Einwilligung kann jederzeit bei ETC widerrufen werden.

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

Bisher keine Bewertungen