Tutorials > Learn Oracle PL/SQL - A Comprehensive Training Course

Learn Oracle PL/SQL - A Comprehensive Training Course


Date: 29 July 2022 | Posted by: voska89
Learn Oracle PL/SQL - A Comprehensive Training Course
Last updated 1/2017
MP4 | Video: h264, 960x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 773.62 MB | Duration: 7h 18m
A Comprehensive Oracle PL/SQL Course Taught By Infinite Skills


What you'll learn
To Master Oracle PL/SQL - Learn From A Leading Expert
Requirements
A Desire To Learn
Description
In this training course by Infinite Skills on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Lewis Cunningham is one of an elite group of Oracle ACE Directors, and a certified PL/SQL developer. With over 15 years experience modelling, developing and architecting Oracle databases, you are learning from one of the best in the industry. Starting with the basic outline of what PL/SQL is, you will set the ground work for your knowledge expansion by learning about data types, flow control, errors, and more. You will explore strings, numbers, booleans, and arrays. From there, Lewis jumps into creating programs, using if statements, loops functions, how to handle exceptions, using packages, and even objects. This computer based training tutorial really is an in-depth look at programming with PL/SQL like no other out there! By the conclusion of this video training tutorial, you will be fully versed in the use of the Oracle PL/SQL for getting the most out of your Oracle databases. Extensive working files are included so you can work alongside the author as he trains you in the use PL/SQL.
Overview
Section 1: Introduction
Lecture 1 Important - Download These First - Working Files
Lecture 2 0101 What Is PL/SQL
Lecture 3 0102 Course Expectations
Section 2: An Overview Of PL/SQL
Lecture 4 0201 The Difference Between SQL And PL/SQL
Lecture 5 0202 Where To Access Oracle - Part 1
Lecture 6 0203 Where To Access Oracle - Part 2
Lecture 7 0204 Block Structure
Lecture 8 0205 Functions Procedures Packages
Lecture 9 0206 Data Types
Lecture 10 0207 Complex Objects
Lecture 11 0208 Variables Constants Parameters - Part 1
Lecture 12 0209 Variables Constants Parameters - Part 2
Lecture 13 0210 Flow Control
Lecture 14 0211 Errors Exceptions
Lecture 15 0212 Commenting Code
Section 3: Data Types In Detail
Lecture 16 0301 Strings
Lecture 17 0302 Numbers
Lecture 18 0303 Date And Time
Lecture 19 0304 Booleans Lobs
Section 4: Complex Data Structures
Lecture 20 0401 Records
Lecture 21 0402 Associative Array
Lecture 22 0403 Nested Tables
Lecture 23 0404 Varrays
Lecture 24 0405 Arrays Of Records
Section 5: Programming PL/SQL
Lecture 25 0501 SQLplus
Lecture 26 0502 SQL Developer - Part 1
Lecture 27 0503 SQL Developer - Part 2
Section 6: A First Program
Lecture 28 0601 Hello World
Lecture 29 0602 Create Assign Use Variables
Lecture 30 0603 Create Procedure
Lecture 31 0604 Autonomous Transactions
Section 7: Flow Control
Lecture 32 0701 If Statements
Lecture 33 0702 Case Statements
Lecture 34 0703 Loops - Part 1
Lecture 35 0704 Loops - Part 2
Section 8: Functions
Lecture 36 0801 Functions - Part 1
Lecture 37 0802 Functions - Part 2
Lecture 38 0803 Built in Functions
Section 9: Exception Handling
Lecture 39 0901 What Are Exceptions - Part 1
Lecture 40 0902 Predefined Exceptions
Lecture 41 0903 Raising Exceptions
Lecture 42 0904 Suggestions For Exception Handling
Lecture 43 0905 User Defined Exceptions
Section 10: SQL In PL/SQL
Lecture 44 1001 Inserting In PL/SQL
Lecture 45 1002 Updates And Deletes In PL/SQL
Lecture 46 1003 Selecting Data In PL/SQL
Lecture 47 1004 Cursors
Lecture 48 1005 Cursor For Loops
Lecture 49 1006 Bulk Operations
Section 11: Packages
Lecture 50 1101 Package Specifications
Lecture 51 1102 Package Bodies
Lecture 52 1103 Public And Private Globals - Part 1
Lecture 53 1104 Public And Private Globals - Part 2
Lecture 54 1105 Package Initialization
Lecture 55 1106 Forward Declarations
Lecture 56 1107 Package Cursors
Lecture 57 1108 Utl File
Lecture 58 1109 Overloading
Section 12: Triggers
Lecture 59 1201 DML Triggers
Lecture 60 1202 Compound Triggers
Lecture 61 1203 Instead Of Triggers
Lecture 62 1204 Database Triggers
Section 13: PL/SQL Objects
Lecture 63 1301 Object Types
Lecture 64 1302 Constructors
Lecture 65 1303 Members
Lecture 66 1304 Equality
Lecture 67 1305 Inheritance
Section 14: Dynamic SQL
Lecture 68 1401 Dynamic SQL
Lecture 69 1402 DBMS SQL - Part 1
Lecture 70 1403 DBMS SQL - Part 2
Lecture 71 1404 DBMS SQL - Part 3
Lecture 72 1405 DBMS SQL - Part 4
Lecture 73 1406 NDS - Part 1
Lecture 74 1407 NDS - Part 2
Users Of All Levels

Homepage
https://www.udemy.com/course/oracle-plsql-tutorial/


DOWNLOAD LINK


Links are Interchangeable - No Password - Single Extraction

See full article