Users Online
· Guests Online: 3
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
· Members Online: 0
· Total Members: 185
· Newest Member: meenachowdary055
Forum Threads
Newest Threads
No Threads created
Hottest Threads
No Threads created
Latest Articles
DEMO - Oracle PL/SQL Course
DEMO - Oracle PL/SQL CourseDatabase Courses |
| Categories | Most Recent | Top Rated | Popular Courses |
 | Uploader | Date Added | Views | Rating |
| Superadmin | 14.03.16 | 644 | No Rating | |
| Description | ||||
| PL/SQL Course Description In this training course on Oracle PL/SQL Programming, you will learn how to utilize the procedural language extension for SQL in the Oracle relational database. Author 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, Author 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 Lesson Description Section 1 Introduction Lesson 01 What Is PL/SQL Lesson 02 Course Expectations Section 2 An Overview of PL/SQL Lesson 03 The Difference Between SQL And PL/SQL Lesson 04 Where To Access Oracle - Part 1 Lesson 05 Where To Access Oracle - Part 2 Lesson 06 Block Structure Lesson 07 Functions Procedures Packages Lesson 08 Data Types Lesson 09 Complex Objects Lesson 10 Variables Constants Parameters - Part 1 Lesson 11 Variables Constants Parameters - Part 2 Lesson 12 Flow Control Lesson 13 Errors Exceptions Lesson 14 Commenting Code Section 3 Data Types In Detail Lesson 15 Strings Lesson 16 Numbers Lesson 17 Date And Time Lesson 18 Booleans Lobs Section 4 Complex Data Structures Lesson 19 Records Lesson 20 Associative Array Lesson 21 Nested Tables Lesson 22 Varrays Lesson 23 Arrays Of Records Section 5 Programming PL/SQL Lesson 24 SQLplus Lesson 25 SQL Developer - Part 1 Lesson 26 SQL Developer - Part 2 Section 6 A First Program Lesson 27 Hello World Lesson 28 Create Assign Use Variables Lesson 29 Create Procedure Lesson 30 Autonomous Transactions Section 7 Flow Control Lesson 31 If Statements Lesson 32 Case Statements Lesson 33 Loops - Part 1 Lesson 34 Loops - Part 2 Section 8 Functions Lesson 35 Functions - Part 1 Lesson 36 Functions - Part 2 Lesson 37 Built in Functions Section 9 Exception Handling Lesson 38 What Are Exceptions Lesson 39 Predefined Exceptions Lesson 40 Raising Exceptions Lesson 41 Suggestions For Exception Handling Lesson 42 User Defined Exceptions Section 10 SQL In PL/SQL Lesson 43 Inserting In PL/SQL Lesson 44 Updates And Deletes In PL/SQL Lesson 45 Selecting Data In PL/SQL Lesson 46 Cursors Lesson 47 Cursor For Loops Lesson 48 Bulk Operations Section 11 Packages Lesson 49 Package Specifications Lesson 50 Package Bodies Lesson 51 Public And Private Globals - Part 1 Lesson 52 Public And Private Globals - Part 2 Lesson 53 Package Initialization Lesson 54 Forward Declarations Lesson 55 Package Cursors Lesson 56 Utl File Lesson 57 Overloading Section 12 Triggers Lesson 58 DML Triggers Lesson 59 Compound Triggers Lesson 60 Instead Of Triggers Lesson 61 Database Triggers Section 13 PL/SQL Objects Lesson 62 Object Types Lesson 63 Constructors Lesson 64 Members Lesson 65 Equality Lesson 66 Inheritance Section 14 Dynamic SQL Lesson 67 Dynamic SQL Lesson 68 DBMS SQL - Part 1 Lesson 69 DBMS SQL - Part 2 Lesson 70 DBMS SQL - Part 3 Lesson 71 DBMS SQL - Part 4 Lesson 72 NDS - Part 1 Lesson 73 NDS - Part 2 | ||||
Ratings
Comments
No Comments have been Posted.
Post Comment
Please Login to Post a Comment.