GogoTraining Oracle 11g/12c: Advanced SQL
English | Size: 2.25 GB (2,420,107,001 Bytes)
Category: Tutorial
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.
GogoTraining Oracle 11g/12c: Advanced SQL
Uploader Notes:
All videos in MP4 format
Video: MPEG4 Video (H264) 640×480 29.97fps 699kbps [V: h264 main L3.1, yuv420p, 640×480, 699 kb/s]
Audio: AAC 44100Hz stereo 127kbps [A: SoundHandler (aac lc, 44100 Hz, stereo, 127 kb/s)]
All Materials Included:
Student Guide
Excercise Guide
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
Related Training
Course: Introduction to Programming and Coding for Everyone with JavaScript
Course: Oracle 10g/11g: Introduction to SQL
Course: Oracle 11g/12c: Introduction to SQL
Course: Oracle 11g PL/SQL Programming Part 1
Course: Oracle 11g PL/SQL Programming Part 2
Course: Oracle 12c: Database Administration I Part 1
Course: Oracle 12c: Database Administration I Part 2
Course: Oracle 12c: Database Administration II Part 1
Course: Oracle 12c: Database Administration II Part 2
Video Title
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
Total: 7 hours 3 minutes
DOWNLOAD:
http://rapidgator.net/file/ed8b1155aa0223c9d00e87b07b31b12c/Oracle_11g_12c_-_Advanced_SQL.part1.rar.html
http://rapidgator.net/file/d6f581621d0524b8d9fb82d16a2adc15/Oracle_11g_12c_-_Advanced_SQL.part2.rar.html
http://rapidgator.net/file/04482b54d83d33df60ea382f4edb92a6/Oracle_11g_12c_-_Advanced_SQL.part3.rar.html
http://rapidgator.net/file/b2c41e73f991e577b2ac2e12e728203b/Oracle_11g_12c_-_Advanced_SQL.part4.rar.html
http://rapidgator.net/file/d21670d6c08be973522fa62966e56742/Oracle_11g_12c_-_Advanced_SQL.part5.rar.html
http://rapidgator.net/file/3b475b2ec7a4125a0a657581cde4ca90/Oracle_11g_12c_-_Advanced_SQL.part6.rar.html
http://nitroflare.com/view/282E2FD8DB43028/Oracle_11g_12c_-_Advanced_SQL.part1.rar
http://nitroflare.com/view/AB8BF102712968E/Oracle_11g_12c_-_Advanced_SQL.part2.rar
http://nitroflare.com/view/C961049583F1642/Oracle_11g_12c_-_Advanced_SQL.part3.rar
http://nitroflare.com/view/8FB251891D3FF3F/Oracle_11g_12c_-_Advanced_SQL.part4.rar
http://nitroflare.com/view/9263BAE4143F263/Oracle_11g_12c_-_Advanced_SQL.part5.rar
http://nitroflare.com/view/5653832672407B0/Oracle_11g_12c_-_Advanced_SQL.part6.rar
If any links die or problem unrar, send request to http://goo.gl/aUHSZc
Leave a Reply