Oracle Database: Introduction to SQL Ed 2

Sun/Oracle
Oracle Database: Introduction to SQL Ed 2
Oracle Database: Introduction to SQL Ed 2
This Oracle Database 12c: Introduction to SQL training helps you write subqueries, combine multiple queries into a
single query using SET operators and report aggregated data using group functions. Learn this and more through
hands-on exercises. Learn To: Understand the basic concepts of relational databases ensure refined code by
developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database
access to specific objects. Manage schema objects. Manage objects with data dictionary views. Retrieve row and
column data from tables. Control privileges at the object and system level. Create indexes and constraints; alter
existing schema objects. Create and query external tables. Benefits to You Ensure fast, reliable, secure and easy to
manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by
enabling consolidation onto database clouds. Learn Advanced Features of SQL This course will help you understand
the advanced features of SQL. Learning these features will help you query and manipulate data within the
database, use the dictionary views to retrieve metadata and create reports about their schema objects. Some of the
date-time functions available in the Oracle Database are also covered. This course also discusses how to use the
regular expression support in SQL through expert instruction. Use Development Tools The main development tool
used in this training is Oracle SQL Developer. SQL*Plus is available as an optional development tool. This is
appropriate for a 10g, 11g and 12c audience. Course Bundle Note: This course is a combination of Oracle Database
12c: SQL Workshop I and Oracle Database12c: SQL Workshop II courses.
Kursinhalt
• Introduction
• Working with Oracle Cloud Exadata Express Cloud Service
• 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 Joins
• Using Subqueries to Solve Queries
• Using the SET Operators
• Managing Tables using DML statements
• Introduction to Data Definition Language
• Introduction to Data Dictionary Views
• Creating Sequences, Synonyms, Indexes
• Creating Views
• Managing Schema Objects
• Retrieving Data by Using Subqueries
• Manipulating Data by Using Subqueries
• Controlling User Access
• Manipulating Data
• Managing Data in Different Time Zones
Vormerkung und Buchung
Reservieren Sie den gewünschten Kurstermin
unverbindlich und kostenlos! Für die Dauer von
7 Tagen halten wir Ihnen einen Platz frei. Diese
Vormerkung sowie eine feste Kursbuchung können
Sie direkt auf unserer Website tätigen. Oder rufen
Sie einfach an: 06074 4868-0
Garantierte Kurstermine
Zur tagesaktuellen Übersicht der Termine führt Sie
der direkte Link: www.experteach.de/go/91UK
Alternativ scannen Sie einfach
den nebenstehenden QR-Code.
Beachten Sie dort bitte auch die
garantierten Kurstermine. Diese
erkennen Sie am Symbol
Ihr Kurs maßgeschneidert
Sie benötigen diesen Kurs mit speziell für Ihr Team
zugeschnittenen Inhalten? Für Ihr Projekt erstellen
wir Weiterbildungsprogramme, die exakt an Ihre
Anforderungen angepasst sind.
E-Book Jeder Teilnehmer erhält die englischsprachigen Original-Unterlagen in Form eines Oracle University eKits.
Zielgruppe
• Application Developers
• Business Analysts
• Data Warehouse Administrator
• Developer
• Forms Developer
• PL/SQL Developer
• System Analysts
Voraussetzungen
• Data processing
• Familiarity with data processing concepts and techniques
Kursziel
• Identify the major structural components of the Oracle Database 12c
• Manage objects with data dictionary views
• Manage schema objects
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Use scalar and correlated sub-queries
• Utilize views to display data
• Write SELECT statements that include queries
• Write multiple-column sub-queries
• Control database access to specific objects
• Create reports of aggregated data
• Create reports of sorted and restricted data
• Create tables to store data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Employ SQL functions to retrieve customized data
5 Tage
€ 3.350,00 zzgl. MwSt.
Termin/Kursort
15.05.-19.05.17
15.05.-19.05.17
19.06.-23.06.17
19.06.-23.06.17
19.06.-23.06.17
03.07.-07.07.17
03.07.-07.07.17
03.07.-07.07.17
Stand 05.04.2017
Berlin
Köln
Köln
Wien
Wien
Basel
Bern
Zürich
04.09.-08.09.17
09.10.-13.10.17
09.10.-13.10.17
09.10.-13.10.17
09.10.-13.10.17
09.10.-13.10.17
20.11.-24.11.17
Wien
Basel
Bern
Dortmund
Gummersb.
Zürich
Wien
91UK
ExperTeach Networking
Technologie-Training
in deutscher Sprache
Über 30 Hersteller
Die wesentlichen
ITK-Anbieter
IT Management
Weiterbildung über
die Technik hinaus
Consulting Services
ITK-Experten für
Ihr Projekt
Garantierte Kurstermine
Planungssicherheit für
Ihre Fortbildung
Virtual Training
Hybrid Training
E-Books • E-Learning
Digitalisierung
Industrie 4.0 & IoT
Know-how für Experten
ExperTeach GmbH
Hamburg
Waldstraße 94 • D-63128 Dietzenbach • Telefon +49 6074 4868-0 • Fax +49 6074 4868-109
[email protected] • www.experteach.de
Berlin
Utrecht
Breda
Partner
Training
Center
Düsseldorf
Bonn
Frankfurt/
Dietzenbach
Nürnberg
Karlsruhe
Stuttgart
ExperTeach
Training
Center
Ulm
Zürich
München
Wien
© ExperTeach GmbH, alle Angaben ohne Gewähr, 05.04.2017