GogoTraining - Oracle 11g/12c: Introduction to SQL
GogoTraining - Oracle 11g/12c: Introduction to SQL
English | mp4 | H264 640x480 | AAC 2 ch | 6 hrs 29 min | pdf | 2.16 GB
eLearning
English | mp4 | H264 640x480 | AAC 2 ch | 6 hrs 29 min | pdf | 2.16 GB
eLearning
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.
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
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: 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
Screenshots:
GogoTraining - Oracle 11g/12c: Introduction to SQL
GogoTraining - Oracle 11g/12c: Introduction to SQL
GogoTraining - Oracle 11g/12c: Introduction to SQL
GogoTraining - Oracle 11g/12c: Introduction to SQL
