Pluralsight - Oracle PL / SQL Fundamentals - Part 1 - 2014

seeders: 30
leechers: 62
Download torrent
Added on January 18, 2015 by RocknBassin Other > Tutorials
Torrent verified.


Pluralsight - Oracle PL / SQL Fundamentals - Part 1 - 2014 (Size: 604.75 MB)
 01 What is PL-SQL.mp41.47 MB
 02 Why learn PL-SQL.mp42.37 MB
 03 Audience.mp41.41 MB
 04 How is PL-SQL Processed.mp41.04 MB
 05 Tools.mp41.79 MB
 01 overview.mp41.71 MB
 02 What is an Anonymous Block.mp42.13 MB
 03 Structure of Anonymous Blocks.mp44.12 MB
 04 Comments in Anonymous Blocks.mp42.69 MB
 05 Demo of Anonymous Block Structure and Comment Styles.mp49.12 MB
 06 Nesting of Anonymous Blocks.mp41.7 MB
 07 Scope and Visibility of Variables in Nested Blocks.mp42.79 MB
 08 Labels.mp41.62 MB
 09 Demo Scope and Visibility of Variables and Block Labels.mp413.79 MB
 10 Summary.mp41.42 MB
 01 introduction.mp42.33 MB
 02 Number Fixed and Floating Type.mp45.89 MB
 03 Assignments, Defaults and Constants.mp42.61 MB
 04 Demo Numbers.mp414.31 MB
 05 Subtypes.mp47.78 MB
 06 %TYPE.mp410.44 MB
 07 PLS_INTEGER or BINARY_INTEGER.mp43.27 MB
 08 BINARY_DOUBLE and BINARY_FLOAT.mp416.25 MB
 09 Character Datatypes.mp49.77 MB
 10 Demo Character.mp45.85 MB
 01 overview.mp45.71 MB
 02 Simple Loops.mp46.71 MB
 03 Demo Simple Loops.mp47.14 MB
 04 FOR Loops.mp43.69 MB
 05 Demo FOR Loop.mp42.96 MB
 06 FOR Loop Counter.mp413 MB
 07 Continue Statement.mp41.84 MB
 08 Nesting of Loops.mp42.42 MB
 09 Exit When & Continue When.mp415.77 MB
 10 While Loop.mp46.42 MB
 11 Summary.mp41.46 MB
 01 overview.mp41.98 MB
 02 If Elseif Else Statements & Nesting.mp413.81 MB
 03 Demo If Elsif Else Statements & Nesting.mp48.6 MB
 04 Case Statement.mp46.27 MB
 05 Case Expressions.mp47.7 MB
 06 Demo Case Statement & Expressions.mp49.21 MB
 07 Summary.mp41.4 MB
 01 introduction.mp44 MB
 02 Implicit Cursors.mp48.24 MB
 03 Demo Implicit Cursors.mp49.54 MB
 04 Explicit Cursors.mp421.22 MB
 05 Cursor FOR Loop.mp414.19 MB
 06 Cursor FOR Update.mp414.14 MB
 07 Ref Cursors or Cursor Variables.mp425.23 MB
 08 Weak Ref Cursors.mp49.59 MB
 09 Cursor Expressions.mp411.77 MB
 10 Summary.mp42.32 MB
 01 introduction.mp43.78 MB
 02 Oracle Internal Exceptions.mp416.86 MB
 03 Predefined Exceptions.mp45.44 MB
 04 User Defined Exceptions.mp412.14 MB
 05 Exception Scope & Propagation.mp424.17 MB
 06 Summary.mp41.16 MB
 01 introduction.mp42.73 MB
 02 DBMS_OUTPUT.mp49.99 MB
 03 DBMS_UTILITY.mp43.63 MB
 04 Demo DBMS_OUTPUT & DBMS_UTILITY.mp424.22 MB
 05 SQLDeveloper Debugger Privileges & Setup.mp49.64 MB
 06 Debugging with SQLDeveloper.mp438.83 MB
 07 Debugging an Exception with SQLDeveloper.mp416.69 MB
 08 Summary.mp41.19 MB
 image1-223.png21.39 KB
 image1-94.png104.88 KB
 image1-small-226.png18.06 KB
 image1-small-95.png12.88 KB
 image2-2427.png72.13 KB
 image2-small-2433.png9.46 KB
 mt0@2x-153.jpg18.75 KB
 mt1@2x-154.jpg15.8 KB
 mt2@2x-155.jpg5.84 KB
 mypic-2428.jpg11.98 KB
 BuildVersionHistory.plist294 bytes
 DocumentIdentifier36 bytes
 properties.plist270 bytes
 index.zip90.52 KB
 preview-micro.jpg1.54 KB
 preview-web.jpg6.79 KB
 preview.jpg81.88 KB
 image1-small.png18.06 KB
 Image1.png21.39 KB
 image2-small.png9.46 KB
 Image2.png72.13 KB
 image3-small.png12.89 KB
 Image3.png103.85 KB
 mt0@2x.jpg17.88 KB
 mt1@2x-1.jpg14.6 KB
 mt1@2x.jpg17.2 KB
 mt3@2x.jpg15.99 KB
 BuildVersionHistory.plist245 bytes
 DocumentIdentifier36 bytes
 properties.plist217 bytes
 index.zip70.21 KB
 preview-micro.jpg1.47 KB
 preview-web.jpg5.96 KB
 preview.jpg67.38 KB
 image1-small.png18.06 KB
 Image1.png21.39 KB
 image2-small.png9.46 KB
 Image2.png72.13 KB
 image3-small.png12.89 KB
 Image3.png103.85 KB
 mt0@2x.jpg17.88 KB
 mt1@2x-1.jpg14.6 KB
 mt1@2x.jpg17.2 KB
 mt3@2x.jpg15.99 KB
 BuildVersionHistory.plist245 bytes
 DocumentIdentifier36 bytes
 properties.plist217 bytes
 index.zip140.62 KB
 preview-micro.jpg1.53 KB
 preview-web.jpg6.45 KB
 preview.jpg76.63 KB
 image1-223.png21.39 KB
 image1-94.png104.88 KB
 image1-small-226.png18.06 KB
 image1-small-95.png12.88 KB
 image2-2427.png72.13 KB
 image2-small-2433.png9.46 KB
 mt0@2x-153.jpg18.75 KB
 mt1@2x-154.jpg15.8 KB
 mt2@2x-155.jpg5.84 KB
 mypic-2428.jpg11.98 KB
 BuildVersionHistory.plist294 bytes
 DocumentIdentifier36 bytes
 properties.plist270 bytes
 index.zip130.88 KB
 preview-micro.jpg1.44 KB
 preview-web.jpg5.62 KB
 preview.jpg59.95 KB
 image1-small.png18.06 KB
 Image1.png21.39 KB
 image2-small.png9.46 KB
 Image2.png72.13 KB
 image3-small.png12.89 KB
 Image3.png103.85 KB
 mt0@2x.jpg17.88 KB
 mt1@2x-1.jpg17.2 KB
 mt1@2x.jpg14.6 KB
 mt3@2x.jpg15.99 KB
 BuildVersionHistory.plist245 bytes
 DocumentIdentifier36 bytes
 properties.plist217 bytes
 index.zip85.54 KB
 preview-micro.jpg1.49 KB
 preview-web.jpg5.98 KB
 preview.jpg69.36 KB
 oracle-plsql-fundamentals-m5-cursors-drop.txt47 bytes
 oracle-plsql-fundamentals-m5-cursors-Create.txt927 bytes
 oracle-plsql-fundamentals-m5-cursors-Cursor_For_Update_Demo.txt420 bytes
 oracle-plsql-fundamentals-m5-cursors-CursorExpression.txt871 bytes
 oracle-plsql-fundamentals-m5-cursors-Explicit_Cursors_Attributes_Demo.txt649 bytes
 oracle-plsql-fundamentals-m5-cursors-Implicit_Cursors.txt317 bytes
 oracle-plsql-fundamentals-m5-cursors-NestedCursors.txt604 bytes
 oracle-plsql-fundamentals-m5-cursors-StronglyTypedRefCursorsDemo.txt850 bytes
 oracle-plsql-fundamentals-m5-cursors-WeaklyTypedRefCursorsDemo.txt692 bytes
 setup.txt351 bytes
 image1-223.png21.39 KB
 image1-94.png104.88 KB
 image1-small-226.png18.06 KB
 image1-small-95.png12.88 KB
 image2-2427.png72.13 KB
 image2-small-2433.png9.46 KB
 mt0@2x-153.jpg18.75 KB
 mt1@2x-154.jpg15.8 KB
 mt2@2x-155.jpg5.84 KB
 mypic-2428.jpg11.98 KB
 BuildVersionHistory.plist294 bytes
 DocumentIdentifier36 bytes
 properties.plist270 bytes
 index.zip130.41 KB
 preview-micro.jpg1.46 KB
 preview-web.jpg5.73 KB
 preview.jpg63.08 KB
 image1-94.png104.88 KB
 image1-small-95.png12.88 KB
 image2-2427.png72.13 KB
 image2-small-2433.png9.46 KB
 mt0@2x-153.jpg18.75 KB
 mt1@2x-154.jpg15.8 KB
 mt2@2x-155.jpg5.84 KB
 mypic-2428.jpg11.98 KB
 st0-5004.jpg12.55 KB
 st1-5039.jpg10.43 KB
 BuildVersionHistory.plist294 bytes
 DocumentIdentifier36 bytes
 properties.plist270 bytes
 index.zip99.21 KB
 preview-micro.jpg1.48 KB
 preview-web.jpg5.86 KB
 preview.jpg63.54 KB
 1-oracle-plsql-fundamentals-slides.pdf183.24 KB
 2-oracle-plsql-fundamentals-slides.pdf190.83 KB
 3-oracle-plsql-fundamentals-slides.pdf313.3 KB
 4-oracle-plsql-fundamentals-slides.pdf299.18 KB
 5-oracle-plsql-fundamentals-slides.pdf191.54 KB
 6-oracle-plsql-fundamentals-slides.pdf226.81 KB
 7-oracle-plsql-fundamentals-slides.pdf299.66 KB
 8-oracle-plsql-fundamentals-slides.pdf241.24 KB


Description

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


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







Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
604.75 MB
seeders:30
leechers:62
Pluralsight - Oracle PL / SQL Fundamentals - Part 1 - 2014

All Comments

Angel-Legend
Thanks you very much.
viru338
Thanks a lot mate