RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



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

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D81142GC10

Dla kogo

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

Czas trwania

2 dni

Cena bazowa

PLN 2980

Cel

  • Use various features of SQL*Developer
  • Describe and work with the basic elements of Oracle SQL
  • Combine tables using joins and subqueries
  • Create and manage tables, synonyms, sequences, indexes, and views
  • Implement database security by granting privileges and creating roles
  • Describe the Oracle database environment

Opis

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.Learn To:Describe the Oracle database environment.Use various features of Oracle SQL Developer.Describe and work with the basic elements of Oracle SQL.Become familiar with fundamental database security features.Combine tables using joins and subqueries.Create and manage tables, synonyms, sequences, indexes and views.Implement database security by granting privileges and creating roles.Benefits to YouBy enrolling in this course, you'll deep dive into fundamental database security features. By learning to create and manage tables, synonyms, sequences, indexes and views in the Oracle Database 12c environment, you'll be able to better leverage your technology investment.

Tematy

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

Wymagania

    • Experience with SQL
    • SQL Developer

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.