InfiniteSkills – Learning Oracle PL-SQL Programming (2011) [74 mp4 + Working files]
English | Size: 1.04 GB
Category: Tutorial
In this training course by Lewis Cunningham 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.
http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html
01. Introduction
0101 What Is PL/SQL
0102 Course Expectations
02. An Overview Of PL/SQL
0201 The Difference Between SQL And PL/SQL
0202 Where To Access Oracle – Part 1
0203 Where To Access Oracle – Part 2
0204 Block Structure
0205 Functions Procedures Packages
0206 Data Types
0207 Complex Objects
0208 Variables Constants Parameters – Part 1
0209 Variables Constants Parameters – Part 2
0210 Flow Control
0211 Errors Exceptions
0212 Commenting Code
03. Data Types In Detail
0301 Strings
0302 Numbers
0303 Date And Time
0304 Booleans Lobs
04. Complex Data Structures
0401 Records
0402 Associative Array
0403 Nested Tables
0404 Varrays
0405 Arrays Of Records
05. Programming PL/SQL
0501 SQLplus
0502 SQL Developer – Part 1
0503 SQL Developer – Part 2
06. A First Program
0601 Hello World
0602 Create Assign Use Variables
0603 Create Procedure
0604 Autonomous Transactions
07. Flow Control
0701 If Statements
0702 Case Statements
0703 Loops – Part 1
0704 Loops – Part 2
08. Functions
0801 Functions – Part 1
0802 Functions – Part 2
0803 Built in Functions
09. Exception Handling
0901 What Are Exceptions – Part 1
0902 Predefined Exceptions
0903 Raising Exceptions
0904 Suggestions For Exception Handling
0905 User Defined Exceptions
10. SQL In PL/SQL
1001 Inserting In PL/SQL
1002 Updates And Deletes In PL/SQL
1003 Selecting Data In PL/SQL
1004 Cursors
1005 Cursor For Loops
1006 Bulk Operations
11. Packages
1101 Package Specifications
1102 Package Bodies
1103 Public And Private Globals – Part 1
1104 Public And Private Globals – Part 2
1105 Package Initialization
1106 Forward Declarations
1107 Package Cursors
1108 Utl File
1109 Overloading
12. Triggers
1201 DML Triggers
1202 Compound Triggers
1203 Instead Of Triggers
1204 Database Triggers
13. PL/SQL Objects
1301 Object Types
1302 Constructors
1303 Members
1304 Equality
1305 Inheritance
14. Dynamic SQL
1401 Dynamic SQL
1402 DBMS SQL – Part 1
1403 DBMS SQL – Part 2
1404 DBMS SQL – Part 3
1405 DBMS SQL – Part 4
1406 NDS – Part 1
1407 NDS – Part 2
15. About The Author
1501 About Me
Download:
http://uploaded.net/file/74h3qloq/InfiniteSkills%20-%20Learning%20Oracle%20PL-SQL%20Programming.part2.rar
http://uploaded.net/file/1eb63lix/InfiniteSkills%20-%20Learning%20Oracle%20PL-SQL%20Programming.part3.rar
http://rapidgator.net/file/a090705021881f087a91fce256b1f98e/InfiniteSkills_-_Learning_Oracle_PL-SQL_Programming.part1.rar.html
http://rapidgator.net/file/f79d81ff21231c577b757b4d06e48751/InfiniteSkills_-_Learning_Oracle_PL-SQL_Programming.part2.rar.html
http://rapidgator.net/file/290ceee2563a50b80473d3e473415f7a/InfiniteSkills_-_Learning_Oracle_PL-SQL_Programming.part3.rar.html
If get link die or problem unrar, send request to http://goo.gl/aUHSZc
Leave a Reply