Understanding and using Oracle PL/SQL programming language

سرفصل های دوره

Writing programs to interact and manipulate Oracle databases using PL/SQL programming language

1 - Course Introduction Course goals and objectives of what will be taught

1 - Course Introduction Understanding of how this course will run and goals

2 - Tools that will be used in the course to program in PLSQL

2 - Sql Developer Overview of program that will be used to runtest the PLSQL code

3 - SQL Review Refresher for understanding how SQL works and what it does

3 - SQL Basics Refesher Overview of the SQL language so it can be built upon

4 - SQL Demo Look at how SQL works and what its limitations are programmatically

4 - PLSQL overview declarations and syntax

5 - PLSQL What is PLSQL who uses it and what are the benefits to the language

6 - Declarations variables and constants what they are are and how to use them

7 - Operators

8 - Anonymous block example Writing code in PLSQL

9 - Cursors Bringing multiple rows of data in to the program for manipulation

10 - Cursor Example

11 - PLSQL languge symantics and good practices

5 - Execution section and data manipulating

12 - Executable section where the code runs and interacts with the database

13 - Data manipulation language in PLSQL Transactional control and Cursor attribute

14 - Executable section example

15 - Interacting with the database SELECT INTO Assignments and TYPE attribute

16 - DML example

17 - Conditional statements ifthen and loops in PLSQL

18 - IF THEN example

19 - Exceptions Error trapping and error handling

20 - Exceptions examples

6 - Bringing the code together

21 - Functions What they are and how they work in PLSQL

22 - Function examples

23 - Procedures What they are and why you will use them frequently

24 - Procedure Examples

25 - Packages Putting together like functions and procedures to save time and memory

26 - Database Triggers Automating tables to do things when you make changes to data

7 - Wrap up

27 - Conclusion and Wrap up Where we have been and where you can go from here

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training