Oracle Datenbank 11g: Professioneller Einstieg in Oracle SQL

Global Network Communication
In Wien (Österreich)

3.150 
zzgl. MwSt.
Möchten Sie den Bildungsanbieter lieber direkt anrufen?
00 43... Mehr ansehen
Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen

Wichtige informationen

  • Kurs
  • Anfänger
  • Wien (Österreich)
  • Dauer:
    5 Tage
Beschreibung

In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema ..
Gerichtet an: Business Analysts Developer Application Developers PL/SQL Developer Forms Developer System Analysts Data Warehouse Administrator

Wichtige informationen
Veranstaltungsort(e)

Wo und wann

Beginn Lage
auf Anfrage
Wien
Nußdorfer Lände, 23, 1190, Wien, Österreich
Plan ansehen

Was lernen Sie in diesem Kurs?

SQL

Themenkreis

In this course students learn the concepts of relational databases. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects. Students learn to control privileges at the object and system level. This course covers creating indexes and constraints, and altering existing schema objects. Students also learn how to create and query external tables. Students learn to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also learn some of the date-time functions available in the Oracle Database. This course discusses how to use the regular expression support in SQL. In this course, students use Oracle SQL Developer as the main development tool. SQL*Plus is introduced as an optional development tool.

Kursbeschreibung

Sachgebiete

  • Introducing Oracle Database 11g
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single-Row Functions to Customize Output
  • Using Conversion Functions and Conditional Expressions
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data From Multiple Tables
  • Using Sub-queries to Solve Queries
  • Using the SET Operators
  • Manipulating Data
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Controlling User Access
  • Managing Schema Objects
  • Managing Objects with Data Dictionary Views
  • Manipulating Large Data Sets
  • Managing Data in Different Time Zones
  • Retrieving Data Using Sub-queries
  • Regular Expression Support



Teilnehmerkreis

  • Business Analysts
  • Developer
  • Application Developers
  • PL/SQL Developer
  • Forms Developer
  • System Analysts
  • Data Warehouse Administrator



Kategorie

Oracle Grundlagen und Sprachen

Sprache Unterlagen

English


Vergleichen Sie diesen Kurs mit ähnlichen Kursen
Mehr ansehen