GogoTraining - Oracle 11g/12c: Advanced SQL

Category: Tutorial | Comment: 0

Download Now

GogoTraining - Oracle 11g/12c: Advanced SQL

GogoTraining - Oracle 11g/12c: Advanced SQL
English | mp4 | H264 640x480 | AAC 2 ch | 6 hrs 29 min | pdf | 2.25 GB
eLearning

In this course, students learn how to use the advanced features of SQL in order to query and manipulate data within the database. Advanced querying and reporting techniques including using SET operators, writing hierarchical queries and using the Flashback Query feature are explained. Schema objects such as Tables, Indexes and Constraints are discussed in detail.
In order to take this course you need to have taken Oracle 11g/12c: Introduction to SQL and have experience in writing Oracle SQL statements.

Prerequisites
You need to have equivalent experience or have taken the following GogoTraining courses:
- Introduction to Programming for Non-Programmers
- Introduction to Programming and Coding for Everyone with javascript
- Oracle 10g/11g: Introduction to SQL
- Oracle 11g/12c: Introduction to SQL

Objectives
As a result of taking this Oracle course, you will be to:
- Combine SQL result sets into a single result set using SET operators
- Access data from a previous point in time using the flashback query feature
- Combine multiple SQL statements into one statement
- Create various database objects

Course Materials
Want to be able to access these helpful materials? Contact Us!
- Student Guide
- Lab Exercise Guide
- Data File
- Setup Guide - 11g
- Setup Guide - 12c

00: Oracle 11g/12c: Advanced SQL Online Training - Course Introduction
01: Using the Set Operators
02: Using the Set Operators Demo
03: Flashback Query
04: Flashback Query Demo
05: Using Subqueries
06: Using Subqueries Demo
07: Hierarchical Retrieval
08: Hierarchical Retrieval Demo
09: Using the Data Dictionary Views
10: Using the Data Dictionary Views Demo
11: Creating Database Objects I (Views)
12: Creating Database Objects I (Views) Demos
13: Creating Database Objects II (Sequences)
14: Creating Database Objects II (Sequences) Demo
15: Creating Database Objects III (Synonyms)
16: Creating Database Objects III (Synonyms) Demo
17: Creating Database Objects IV (Tables)
18: Creating Database Objects IV (Tables) Demo
19: Creating Database Objects V (Indexes)
20: Creating Database Objects V (Indexes) Demo
21: Creating Database Objects VI (Constraints)
22: Creating Database Objects VI (Constraints) Demo
23: Regular Expression Support
24: Regular Expression Support Demo
25: Advanced Oracle: 12c New Features


Screenshots:


GogoTraining - Oracle 11g/12c: Advanced SQL


GogoTraining - Oracle 11g/12c: Advanced SQL


GogoTraining - Oracle 11g/12c: Advanced SQL


rapidgator_net:
http://rapidgator.net/file/bf34547b3c9746acf511a278d1838639/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part1.rar.html
http://rapidgator.net/file/a7c66248322ecb1497210a026f571762/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part2.rar.html
http://rapidgator.net/file/c75b293c4a930a7e954c7790e4bb5545/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part3.rar.html
http://rapidgator.net/file/e7bed9efad7b47974179615f57f9dc41/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part4.rar.html

secureupload_eu:
https://www.secureupload.eu/zq2jx92v6a4p/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part1.rar
https://www.secureupload.eu/9c5vagicc8zw/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part2.rar
https://www.secureupload.eu/akzs07nyvw2c/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part3.rar
https://www.secureupload.eu/wukfu8pss9d4/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part4.rar

uploaded_net:
http://uploaded.net/file/vz74o2l6/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part1.rar
http://uploaded.net/file/ftfogg7o/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part2.rar
http://uploaded.net/file/90p6870s/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part3.rar
http://uploaded.net/file/vem2z8m5/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part4.rar

uploadable_ch:
http://www.uploadable.ch/file/zSbGefMyBaEs/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part1.rar
http://www.uploadable.ch/file/vyfvHfswV8m3/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part2.rar
http://www.uploadable.ch/file/A8SrWpWasbEU/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part3.rar
http://www.uploadable.ch/file/BTuXPVWnJdfW/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part4.rar

nitroflare_com:
http://nitroflare.com/view/7EAEA42F51FBEDF/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part1.rar
http://nitroflare.com/view/51387CF2D848352/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part2.rar
http://nitroflare.com/view/EF679951FDFC99C/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part3.rar
http://nitroflare.com/view/2574F357D9B7DE0/g1e2r.GogoTraining..Oracle.11g12c.Advanced.SQL.part4.rar

Direct Download


Tags: GogoTraining, Oracle, Advanced

GogoTraining - Oracle 11g/12c: Advanced SQL Fast Download via Rapidshare Hotfile Fileserve Filesonic Megaupload, GogoTraining - Oracle 11g/12c: Advanced SQL Torrents and Emule Download or anything related.
Dear visitor, you went to website as unregistered user.
We encourage you to Register or Login to website under your name.
Information
Members of Guest cannot leave comments.