GogoTraining - Oracle 11g/12c: Advanced SQL

[Alexandr 3]

 

GogoTraining - Oracle 11g/12c: Advanced SQL

English | mp4 | H264 640x480 | AAC 2 ch | 6 hrs 29 min | 2.25 Gb

Genre: 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

DOWNLOAD

 

Ukryta Zawartość

Treść widoczna tylko dla użytkowników forum DarkSiders. Zaloguj się lub załóż darmowe konto na forum aby uzyskać dostęp bez limitów.