Loading...

نبذة عن Oracle PL/SQL

PL/SQL هي لغة برمجه خاصه ببرنامج قواعد بيانات اوراكل تُمكن مطورى قواعد البيانات من برمجة تطبيق داخل نظام قواعد بيانات اوراكل يُتيح الفرصة للمستخدمين العاديين بالتعامل مع بيانات الجداول من خلال (واجهة UI) مجموعة من Forms لإدخال بيانات جديدة للجداول أو التعديل والحذف منهم وعرض تقارير بدون الحاجة الى تعلم اوامر SQL. و PL/SQL هي اختصار لـ Procedural Language / Structured Query Language .

تفاصيل الكورس

يمكنك مذاكرة الدروس بعد التسجيل فى الكورس

دروس كورس Oracle PL/SQL

  • 1 1/125 Oracle PLSQL: Before You Start 00:01:42
  • 2 2/125 Oracle PLSQL: Course Agenda 00:08:01
  • 3 3/125 Oracle PLSQL: Overview of PLSQL 1 00:11:25
  • 4 4/125 Oracle PLSQL: Overview of PLSQL 2 00:09:56
  • 5 5/125 Oracle PLSQL: Overview of PLSQL 3 00:06:19
  • 6 6/125 Oracle PLSQL: Declaring PLSQL Variables 1 00:09:37
  • 7 7/125 Oracle PLSQL: Declaring PLSQL Variables 2 00:10:28
  • 8 8/125 Oracle PLSQL: Declaring PLSQL Variables 3 00:07:19
  • 9 9/125 Oracle PLSQL: Declaring PLSQL Variables 4 00:21:47
  • 10 10/125 Oracle PLSQL: Declaring PLSQL Variables 5 00:14:36
  • 11 11/125 Oracle PLSQL: Writing executable statements 1 00:15:49
  • 12 12/125 Oracle PLSQL: Writing executable statements 2 00:20:23
  • 13 13/125 Oracle PLSQL:Interacting with Oracle DB Server 1 00:12:10
  • 14 14/125 Oracle PLSQL:Interacting with Oracle DB Server 2 00:14:48
  • 15 15/125 Oracle PLSQL: IF Statement- ركز هنا 00:14:47
  • 16 16/125 Oracle PLSQL: Case Statement VS Case Expression 00:13:06
  • 17 17/125 Oracle PLSQL: Handling Nulls in IF Statement 00:09:23
  • 18 18/125 Oracle PLSQL: Basic Loop 00:11:41
  • 19 19/125 Oracle PLSQL: While Loop 00:04:49
  • 20 20/125 Oracle PLSQL: FOR Loop 00:13:34
  • 21 21/125 Oracle PLSQL: Nested Loops & Labels 00:09:01
  • 22 22/125 Oracle PLSQL: Continue Statement 00:06:19
  • 23 23/125 Oracle PLSQL: PLSQL Records Part 1 00:17:11
  • 24 24/125 Oracle PLSQL: PLSQL Records Part 2 00:18:00
  • 25 25/125 Oracle PLSQL: Index by Tables-Associative Arrays 1 00:15:23
  • 26 26/125 Oracle PLSQL: Index by Tables-Associative Arrays 2 00:13:34
  • 27 27/125 Oracle PLSQL: Index by Tables-Assosiative Arrays 3 00:13:14
  • 28 28/125 Oracle PLSQL: Nested tables 00:19:06
  • 29 29/125 Oracle PLSQL: Varray 00:09:00
  • 30 30/125 Oracle PLSQL: Using explicit cursors 1 00:23:08
  • 31 31/125 Oracle PLSQL: Using explicit cursors 2 00:14:43
  • 32 32/125 Oracle PLSQL: Using explicit cursors 3 ( FOR) 00:12:04
  • 33 33/125 Oracle PLSQL: Using explicit cursors 4 00:11:39
  • 34 34/125 Oracle PLSQL: Using explicit cursors 5 00:16:38
  • 35 35/125 Oracle PLSQL: Handling Exceptions/Introduction 00:13:27
  • 36 36/125 Oracle PLSQL: Handling Exceptions/Real Examples 00:17:12
  • 37 37/125 Oracle PLSQL: Handling Exceptions/Non- Predefined 00:10:36
  • 38 38/125 Oracle PLSQL: Handling Exceptions/Non- Predefined Practice 00:09:26
  • 39 39/125 Oracle PLSQL: Handling Exceptions/Programmer Exceptions 00:21:24
  • 40 40/125 Oracle PLSQL:Creating Procedure/Introduction 00:26:40
  • 41 41/125 Oracle PLSQL:Creating Procedure/Practice 00:16:52
  • 42 42/125 Oracle PLSQL:Creating Procedure/ OUT Parameters 00:13:00
  • 43 43/125 Oracle PLSQL:Creating Procedure/ IN OUT Parameters 00:11:37
  • 44 44/125 Oracle PLSQL:Creating Procedure/ Passing Parameters 00:13:39
  • 45 45/125 Oracle PLSQL:Creating Procedure/ Handling Exceptions 00:13:38
  • 46 46/125 Oracle PLSQL: Creating Functions 1 00:13:40
  • 47 47/125 Oracle PLSQL: Creating Functions 2 00:14:03
  • 48 48/125 Oracle PLSQL: Creating Functions 3 00:11:58
  • 49 49/125 Oracle PLSQL: Creating Functions 4 00:09:17
  • 50 50/125 Oracle PLSQL: Creating Packages 1 00:08:36
  • 51 51/125 Oracle PLSQL: Creating Packages 2 00:11:31
  • 52 52/125 Oracle PLSQL: Creating Packages 3 00:09:10
  • 53 53/125 Oracle PLSQL: Creating Packages 4 00:24:44
  • 54 54/125 Oracle PLSQL: Working with Packages / Overloading 00:22:44
  • 55 55/125 Oracle PLSQL: Working with Packages / Overloading Standard Program 00:07:17
  • 56 56/125 Oracle PLSQL: Working with Packages / Forward Declaration 00:11:59
  • 57 57/125 Oracle PLSQL: Working with Packages / Persistent State 00:16:41
  • 58 58/125 Oracle PLSQL: Working with Packages / Persistent Cursor 00:10:45
  • 59 59/125 Oracle PLSQL: Working with Packages / Array Example 00:02:32
  • 60 60/125 Oracle PLSQL: Supplied Packages / Introduction 00:07:17
  • 61 61/125 Oracle PLSQL: Supplied Packages / DBMS_OUTPUT 00:16:00
  • 62 62/125 Oracle PLSQL: Supplied Packages / UTL_FILE 1 00:07:19
  • 63 63/125 Oracle PLSQL: Supplied Packages / UTL_FILE 2 00:11:58
  • 64 64/125 Oracle PLSQL: Supplied Packages /UTL_FILE 3 00:07:23
  • 65 65/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 1 00:13:49
  • 66 66/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 2 00:24:55
  • 67 67/125 Oracle PLSQL: Dynamic SQL / Introduction 00:14:23
  • 68 68/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 1 00:16:10
  • 69 69/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 2 00:07:26
  • 70 70/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 3 00:08:13
  • 71 71/125 Oracle PLSQL: Dynamic SQL / REF Cursor 00:09:22
  • 72 72/125 Oracle PLSQL: Dynamic SQL / More Examples 00:07:20
  • 73 73/125 Oracle PLSQL: Dynamic SQL / DBMS_SQL 00:15:42
  • 74 74/125 Oracle PLSQL: Design consideration / Standardizing 00:13:42
  • 75 75/125 Oracle PLSQL: Design consideration / Definer’s & Invoker’s Rights 00:12:25
  • 76 76/125 Oracle PLSQL: Design consideration / AUTONOMOUS_TRANSACTION 00:12:40
  • 77 77/125 Oracle PLSQL: Design consideration / NOCOPY Hint 1 00:13:27
  • 78 78/125 Oracle PLSQL: Design consideration / NOCOPY Hint 2 00:15:40
  • 79 79/125 Oracle PLSQL: Design consideration / parallel_enable/ result_cache 00:13:48
  • 80 80/125 Oracle PLSQL: Design consideration / Bulk Binding 1 00:23:30
  • 81 81/125 Oracle PLSQL: Design consideration / Bulk Binding 2 00:14:03
  • 82 82/125 Oracle PLSQL: Design consideration / Bulk Binding 3 00:05:19
  • 83 83/125 Oracle PLSQL: Design consideration / Bulk Binding 4 00:06:12
  • 84 84/125 Oracle PLSQL: Design consideration / Bulk Binding 5 00:09:35
  • 85 85/125 Oracle PLSQL: Design consideration / Bulk Binding 6 00:05:53
  • 86 86/125 Oracle PLSQL: Creating Triggers / Introduction 00:20:53
  • 87 87/125 Oracle PLSQL: Creating Triggers / Statement Level 00:17:51
  • 88 88/125 Oracle PLSQL: Creating Triggers / Row Level (1) 00:12:43
  • 89 89/125 Oracle PLSQL: Creating Triggers / Row Level (2) 00:12:29
  • 90 90/125 Oracle PLSQL: Creating Triggers / Trigger Firing Sequence 00:15:02
  • 91 91/125 Oracle PLSQL: Creating Triggers / Default Value 00:05:23
  • 92 92/125 Oracle PLSQL: Creating Triggers / Instead of Triggers 00:19:28
  • 93 93/125 Oracle PLSQL: Creating Triggers / follows Statement 00:07:41
  • 94 94/125 Oracle PLSQL: Creating Triggers / Compound triggers 1 00:13:35
  • 95 95/125 Oracle PLSQL: Creating Triggers / Compound triggers 2 00:05:56
  • 96 96/125 Oracle PLSQL: Creating Triggers / Compound triggers 3 00:23:55
  • 97 97/125 Oracle PLSQL: Creating Triggers / Compound triggers 4 00:13:25
  • 98 98/125 Oracle PLSQL: Creating Triggers / Compound triggers 5 00:09:06
  • 99 99/125 Oracle PLSQL: Creating Triggers / DDL Triggers 00:13:27
  • 100 100/125 Oracle PLSQL: Creating Triggers / Database Events 00:09:00
  • 101 101/125 Oracle PLSQL: Creating Triggers /Call Statement 00:08:55
  • 102 102/125 Oracle PLSQL: PLSQL Compiler / plsql_code_type 00:17:11
  • 103 103/125 Oracle PLSQL: PLSQL Compiler / plsql_optimize_level 00:11:41
  • 104 104/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 1 00:15:59
  • 105 105/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 2 00:13:08
  • 106 106/125 Oracle PLSQL: PLSQL Compiler / dbms_warning 00:11:07
  • 107 107/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 1 00:14:39
  • 108 108/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 2 00:12:00
  • 109 109/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 1 00:17:44
  • 110 110/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 2 00:07:56
  • 111 111/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 3 00:10:22
  • 112 112/125 Oracle PLSQL: Managing PLSQL / dbms_ddl.create_wrapped 00:11:59
  • 113 113/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 1 00:08:25
  • 114 114/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 2 00:08:51
  • 115 115/125 Oracle PLSQL: Managing Dependencies / Introduction 00:14:00
  • 116 116/125 Oracle PLSQL: Managing Dependencies / Direct and Indirect 00:17:18
  • 117 117/125 Oracle PLSQL: Managing Dependencies / Nice Practice 00:10:37
  • 118 118/125 Oracle PLSQL: Managing Dependencies / 3 cases 00:16:11
  • 119 119/125 Oracle PLSQL: Managing Dependencies / package case 00:07:20
  • 120 120/125 Oracle PLSQL: Managing Dependencies / Synonym 1 00:07:00
  • 121 121/125 Oracle PLSQL: Managing Dependencies / Synonym 2 00:09:53
  • 122 122/125 Oracle PLSQL: Managing Dependencies / Reduce invalidation 00:03:37
  • 123 123/125 Oracle PLSQL: Managing Dependencies / Remote part 1 00:16:54
  • 124 124/125 Oracle PLSQL: Managing Dependencies / Remote part 2 00:13:25
  • 125 125/125 Oracle PLSQL: Thank You 00:00:11

محاضر كورس Oracle PL/SQL

khaled alkhudari