Pluralsight - Oracle PL SQL Fundamentals - Part 1 - 2014
================
[COVER:]
================
================
[INFO:]
================
Pluralsight - Oracle PL / SQL Fundamentals - Part 1 - 2014 | 605 MB
Genre: E-Learning
Get coding quickly and effectively with Oracle PL / SQL, Oracle's database development language. This course is the first of a two part series, covering the essentials and fundamentals of Oracle PL / SQL. Learn how to quickly and efficiently program with Oracle PL / SQL, the language development of databases Oracle. This course is the first of a two-part series covering the basics of Oracle PL / SQL.
01. Course Introduction 5:53
What is PL/SQL? 1:04
Why learn PL/SQL? 1:43
Audience 1:06
How is PL/SQL Processed? 0:48
Tools 1:11
02. Anonymous Blocks 19:44
Overview 1:04
What is an Anonymous Block? 1:46
Structure of Anonymous Blocks 2:55
Comments in Anonymous Blocks 1:49
Demo of Anonymous Block Structure and Comment Styles 3:13
Nesting of Anonymous Blocks 0:59
Scope and Visibility of Variables in Nested Blocks 1:34
Labels 0:52
Demo: Scope and Visibility of Variables and Block Labels 4:14
Summary 1:15
03. PL/SQL Commonly Used Datatypes 1:04:32
Introduction 1:43
Number: Fixed and Floating Type 4:54
Assignments, Defaults and Constants 1:55
Demo: Numbers 4:41
Subtypes 3:54
%TYPE 3:52
PLS_INTEGER or BINARY_INTEGER 2:03
BINARY_DOUBLE and BINARY_FLOAT 5:40
Character Datatypes 6:47
Demo: Character 1:46
DateTime Datatypes 6:16
Demo: DateTime Datatypes 2:50
Interval Datatype 6:58
Time Datatype Usage Guidelines 0:43
Boolean Datatype 0:34
Composite Datatype: Records 4:41
Composite Datatype: %ROWTYPE 2:38
Other Datatypes 1:39
Summary 0:50
04. Loops 33:10
Overview 4:42
Simple Loops 4:48
Demo: Simple Loops 2:25
FOR Loops 2:32
Demo: FOR Loop 1:02
FOR Loop Counter 5:40
Continue Statement 1:10
Nesting of Loops 1:46
Exit When & Continue When 5:06
While Loop 2:47
Summary 1:07
05. Conditional Execution 24:32
Overview 1:17
If Elseif Else Statements & Nesting 8:24
Demo: If Elsif Else Statements & Nesting 2:53
Case Statement 3:41
Case Expressions 4:18
Demo: Case Statement & Expressions 2:56
Summary 0:59
06. Cursors 54:12
Introduction 2:47
Implicit Cursors 4:42
Demo: Implicit Cursors 2:49
Explicit Cursors 10:00
Cursor FOR Loop 6:41
Cursor FOR Update 6:44
Ref Cursors or Cursor Variables 10:32
Weak Ref Cursors 3:56
Cursor Expressions 4:01
Summary 1:55
07. Exceptions 29:40
Introduction 2:36
Oracle Internal Exceptions 8:31
Predefined Exceptions 2:18
User Defined Exceptions 5:25
Exception Scope & Propagation 9:52
Summary 0:56
08. Debugging 36:47
Introduction 1:57
DBMS_OUTPUT 7:56
DBMS_UTILITY 2:38
Demo: DBMS_OUTPUT & DBMS_UTILITY 6:30
SQLDeveloper Debugger: Privileges & Setup 2:45
Debugging with SQLDeveloper 9:48
Debugging an Exception with SQLDeveloper 4:07
Summary 1:02
Year : 2014
Manufacturer : pluralsight
Author : Pankaj Jain
Duration : 4h 28m
Language : English
Format : MP4
Video : AVC, 1024x768, 4: 3, 15 fps, 427 Kbps
Audio : AAC, 124 Kbps, 2 channels, 44.1 KHz
Please use 7Zip/WinRAR/Universal Extractor to EXTRACT FILES
If You Like This Torrent Support the Authors by Purchasing It!.. Thanx
