
GogoTraining Oracle 11g/12c: Introduction to SQL
English | Size: 2.16 GB (2,322,671,624 Bytes)
Category: CBTs
In this course students learn the basics of writing Oracle SQL statements. This course provides the SQL skills that allow developers, database administrators and end-users to write queries against single and multiple tables, manipulate data in tables and take advantage of Oracle supplied row functions.
GogoTraining Oracle 11g/12c: Introduction to 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
Oracle 10g/11g Setup Guide
Oracle 12c Setup Guide
Prerequisites
You need to have equivalent experience or have taken the following GogoTraining course:
Introduction to Programming for Non-Programmers
Introduction to Programming and Coding for Everyone with JavaScript
Objectives
As a result of taking this Oracle training, you will be to:
Access database data with a basic SELECT statement
Access data from more than one table
Manipulate database data
Decide where best to use Oracle-supplied functions in place of user-written code
Related Training
Course: Introduction to Programming and Coding for Everyone with JavaScript
Course: Oracle 11g/12c: Advanced SQL
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
Course: Oracle 11g PL/SQL Programming Part 1
Course: Oracle 11g PL/SQL Programming Part 2
Video Title
00: Oracle 11g/12c: Introduction to SQL Online Training – Course Introduction
01: Writing SQL SELECT Statements
02: Writing SQL SELECT Statements Demo
03: Restricting Data
04: Restricting Data Demo
05: Sorting Data
06: Sorting Data Demo
07: Displaying Data from Multiple Tables
08: Displaying Data from Multiple Tables Demo
09: Character Row Functions
10: Character Row Functions Demo
11: Numeric Row Functions
12: Numeric Row Functions Demos
13: Date/Time Row Functions
14: Date/Time Row Functions Demo
15: Miscellaneous Row Functions
16: Miscellaneous Row Functions Demo
17: Aggregating Data Using Group Functions
18: Aggregating Data Using Group Functions Demo
19: Extensions to the GROUP BY Clause
20: Extensions to the GROUP BY Clause Demo
21: Manipulating Data I
22: Manipulating Data I Demo
23: Manipulating Data II
24: Manipulating Data II Demo
25: 12c New Features
Total: 6 hours 19 minutes
DOWNLOAD:
http://rapidgator.net/file/f1f7c1d292ea725b59bce547fd3c0255/Oracle_11g_12c_-_Introduction_to_SQL.part1.rar.html
http://rapidgator.net/file/84cfd05996eb4b712b99d65f7ad77010/Oracle_11g_12c_-_Introduction_to_SQL.part2.rar.html
http://rapidgator.net/file/e11a531f54dbd5c1f6487a9f99e8ce55/Oracle_11g_12c_-_Introduction_to_SQL.part3.rar.html
http://rapidgator.net/file/f742fc1e104186efe3a24a2b49090719/Oracle_11g_12c_-_Introduction_to_SQL.part4.rar.html
http://rapidgator.net/file/e5a50b27b6952abc8d0fb20b5ae00e73/Oracle_11g_12c_-_Introduction_to_SQL.part5.rar.html
http://nitroflare.com/view/447291C6117EB15/Oracle_11g_12c_-_Introduction_to_SQL.part1.rar
http://nitroflare.com/view/D8E596BEE353923/Oracle_11g_12c_-_Introduction_to_SQL.part2.rar
http://nitroflare.com/view/8A07B5CA5BDEA9F/Oracle_11g_12c_-_Introduction_to_SQL.part3.rar
http://nitroflare.com/view/8FA892123CB14D2/Oracle_11g_12c_-_Introduction_to_SQL.part4.rar
http://nitroflare.com/view/A844AACF579479F/Oracle_11g_12c_-_Introduction_to_SQL.part5.rar
If any links die or problem unrar, send request to http://goo.gl/aUHSZc
Botan Kurdistani says
12/09/2015 at 22:43Great tutorial.
Do you have also Oracle Database 10g/11g Administration II tutorial? If so can you please upload it?