مميزات الدورة
- عدد الدروس 177
- الإختبارات 0
- مدة الدورة 50 ساعة
- مستوى المهارات All levels
- اللغة الإنجليزية
- عدد الطلاب 18
- تقييم نعم
-
Oracle PLSQL Program Unit 11g/12c /تعلم اوراكل
- 2/125 Oracle PLSQL: Course Agenda
- 3/125 Oracle PLSQL: Overview of PLSQL 1
- 4/125 Oracle PLSQL: Overview of PLSQL 2
- 5/125 Oracle PLSQL: Overview of PLSQL 3
- 6/125 Oracle PLSQL: Declaring PLSQL Variables 1
- 7/125 Oracle PLSQL: Declaring PLSQL Variables 2
- 8/125 Oracle PLSQL: Declaring PLSQL Variables 3
- 9/125 Oracle PLSQL: Declaring PLSQL Variables 4
- 10/125 Oracle PLSQL: Declaring PLSQL Variables 5
- 11/125 Oracle PLSQL: Writing executable statements 1
- 12/125 Oracle PLSQL: Writing executable statements 2
- 13/125 Oracle PLSQL:Interacting with Oracle DB Server 1
- 14/125 Oracle PLSQL:Interacting with Oracle DB Server 2
- 15/125 Oracle PLSQL: IF Statement- ركز هنا
- 16/125 Oracle PLSQL: Case Statement VS Case Expression
- 17/125 Oracle PLSQL: Handling Nulls in IF Statement
- 18/125 Oracle PLSQL: Basic Loop
- 19/125 Oracle PLSQL: While Loop
- 20/125 Oracle PLSQL: FOR Loop
- 21/125 Oracle PLSQL: Nested Loops & Labels
- 22/125 Oracle PLSQL: Continue Statement
- 23/125 Oracle PLSQL: PLSQL Records Part 1
- 24/125 Oracle PLSQL: PLSQL Records Part 2
- 25/125 Oracle PLSQL: Index by Tables-Associative Arrays 1
- 26/125 Oracle PLSQL: Index by Tables-Associative Arrays 2
- 27/125 Oracle PLSQL: Index by Tables-Assosiative Arrays 3
- 28/125 Oracle PLSQL: Nested tables
- 29/125 Oracle PLSQL: Varray
- 30/125 Oracle PLSQL: Using explicit cursors 1
- 31/125 Oracle PLSQL: Using explicit cursors 2
- 32/125 Oracle PLSQL: Using explicit cursors 3 ( FOR)
- 33/125 Oracle PLSQL: Using explicit cursors 4
- 34/125 Oracle PLSQL: Using explicit cursors 5
- 35/125 Oracle PLSQL: Handling Exceptions/Introduction
- 36/125 Oracle PLSQL: Handling Exceptions/Real Examples
- 37/125 Oracle PLSQL: Handling Exceptions/Non- Predefined
- 38/125 Oracle PLSQL: Handling Exceptions/Non- Predefined Practice
- 39/125 Oracle PLSQL: Handling Exceptions/Programmer Exceptions
- 40/125 Oracle PLSQL:Creating Procedure/Introduction
- 41/125 Oracle PLSQL:Creating Procedure/Practice
- 42/125 Oracle PLSQL:Creating Procedure/ OUT Parameters
- 43/125 Oracle PLSQL:Creating Procedure/ IN OUT Parameters
- 44/125 Oracle PLSQL:Creating Procedure/ Passing Parameters
- 45/125 Oracle PLSQL:Creating Procedure/ Handling Exceptions
- 46/125 Oracle PLSQL: Creating Functions 1
- 47/125 Oracle PLSQL: Creating Functions 2
- 48/125 Oracle PLSQL: Creating Functions 3
- 49/125 Oracle PLSQL: Creating Functions 4
- 50/125 Oracle PLSQL: Creating Packages 1
- 51/125 Oracle PLSQL: Creating Packages 2
- 52/125 Oracle PLSQL: Creating Packages 3
- 53/125 Oracle PLSQL: Creating Packages 4
- 54/125 Oracle PLSQL: Working with Packages / Overloading
- 55/125 Oracle PLSQL: Working with Packages / Overloading Standard Program
- 56/125 Oracle PLSQL: Working with Packages / Forward Declaration
- 57/125 Oracle PLSQL: Working with Packages / Persistent State
- 58/125 Oracle PLSQL: Working with Packages / Persistent Cursor
- 59/125 Oracle PLSQL: Working with Packages / Array Example
- 60/125 Oracle PLSQL: Supplied Packages / Introduction
- 61/125 Oracle PLSQL: Supplied Packages / DBMS_OUTPUT
- 62/125 Oracle PLSQL: Supplied Packages / UTL_FILE 1
- 63/125 Oracle PLSQL: Supplied Packages / UTL_FILE 2
- 64/125 Oracle PLSQL: Supplied Packages /UTL_FILE 3
- 65/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 1
- 66/125 Oracle PLSQL: Supplied Packages / UTL_MAIL 2
- 67/125 Oracle PLSQL: Dynamic SQL / Introduction
- 68/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 1
- 69/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 2
- 70/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 3
- 71/125 Oracle PLSQL: Dynamic SQL / REF Cursor
- 72/125 Oracle PLSQL: Dynamic SQL / More Examples
- 73/125 Oracle PLSQL: Dynamic SQL / DBMS_SQL
- 74/125 Oracle PLSQL: Design consideration / Standardizing
- 75/125 Oracle PLSQL: Design consideration / Definer’s & Invoker’s Rights
- 76/125 Oracle PLSQL: Design consideration / AUTONOMOUS_TRANSACTION
- 77/125 Oracle PLSQL: Design consideration / NOCOPY Hint 1
- 78/125 Oracle PLSQL: Design consideration / NOCOPY Hint 2
- 79/125 Oracle PLSQL: Design consideration / parallel_enable/ result_cache
- 80/125 Oracle PLSQL: Design consideration / Bulk Binding 1
- 81/125 Oracle PLSQL: Design consideration / Bulk Binding 2
- 82/125 Oracle PLSQL: Design consideration / Bulk Binding 3
- 83/125 Oracle PLSQL: Design consideration / Bulk Binding 4
- 84/125 Oracle PLSQL: Design consideration / Bulk Binding 5
- 85/125 Oracle PLSQL: Design consideration / Bulk Binding 6
- 86/125 Oracle PLSQL: Creating Triggers / Introduction
- 87/125 Oracle PLSQL: Creating Triggers / Statement Level
- 88/125 Oracle PLSQL: Creating Triggers / Row Level (1)
- 89/125 Oracle PLSQL: Creating Triggers / Row Level (2)
- 90/125 Oracle PLSQL: Creating Triggers / Trigger Firing Sequence
- 91/125 Oracle PLSQL: Creating Triggers / Default Value
- 92/125 Oracle PLSQL: Creating Triggers / Instead of Triggers
- 93/125 Oracle PLSQL: Creating Triggers / follows Statement
- 94/125 Oracle PLSQL: Creating Triggers / Compound triggers 1
- 95/125 Oracle PLSQL: Creating Triggers / Compound triggers 2
- 96/125 Oracle PLSQL: Creating Triggers / Compound triggers 3
- 97/125 Oracle PLSQL: Creating Triggers / Compound triggers 4
- 98/125 Oracle PLSQL: Creating Triggers / Compound triggers 5
- 99/125 Oracle PLSQL: Creating Triggers / DDL Triggers
- 100/125 Oracle PLSQL: Creating Triggers / Database Events
- 101/125 Oracle PLSQL: Creating Triggers /Call Statement
- 102/125 Oracle PLSQL: PLSQL Compiler / plsql_code_type
- 103/125 Oracle PLSQL: PLSQL Compiler / plsql_optimize_level
- 104/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 1
- 105/125 Oracle PLSQL: PLSQL Compiler / plsql_warnings 2
- 106/125 Oracle PLSQL: PLSQL Compiler / dbms_warning
- 107/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 1
- 108/125 Oracle PLSQL: Managing PLSQL / Conditional Complication 2
- 109/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 1
- 110/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 2
- 111/125 Oracle PLSQL: Managing PLSQL / plsql_ccflags 3
- 112/125 Oracle PLSQL: Managing PLSQL / dbms_ddl.create_wrapped
- 113/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 1
- 114/125 Oracle PLSQL: Managing PLSQL / Wrapper Utility 2
- 115/125 Oracle PLSQL: Managing Dependencies / Introduction
- 116/125 Oracle PLSQL: Managing Dependencies / Direct and Indirect
- 117/125 Oracle PLSQL: Managing Dependencies / Nice Practice
- 118/125 Oracle PLSQL: Managing Dependencies / 3 cases
- 119/125 Oracle PLSQL: Managing Dependencies / package case
- 120/125 Oracle PLSQL: Managing Dependencies / Synonym 1
- 121/125 Oracle PLSQL: Managing Dependencies / Synonym 2
- 122/125 Oracle PLSQL: Managing Dependencies / Reduce invalidation
- 123/125 Oracle PLSQL: Managing Dependencies / Remote part 1
- 124/125 Oracle PLSQL: Managing Dependencies / Remote part 2
- 125/125 Oracle PLSQL: Thank You
-
معلومات متفرقة في الاوراكل
- Create Cluster in Oracle/ عربي
- ROWID & ROWNUM in Oracle/ عربي
- Random number & Random String in Oracle/ عربي
- تعلم قواعد البيانات اوراكل دون تنصيب اي شيء على جهازك
- Solving ORA-01033 oracle initialization or shutdown in progress 12c
- Using ROLLUP & CUBE in ORACLE/عربي/ Arabic
- How to become Oracle PLSQL Developer Certified Associate?
- Database user and application user/arabic
- Database audit techniques/arabic
- Data Concurrency and Consistency/arabic
- Top N Queries in Oracle /arabic
- Oracle Database Constraints ON DELETE CASCADE & more
- Using DEFERRED Constraints in Oracle/ arabic
- Using Oracle Database Constraints/arabic
- The concept of data Migration / Oracle
- Fine Grained Access Control in oracle (FGAC) -عربي
- LISTAGG function in oracle-عربي
- Using SELECT statement to create dynamic scripts-عربي
- Oracle SELECT FOR UPDATE /عربي
- Oracle views and Materialized views عربي
- Overview of Oracle PLSQL-عربي
- Overview of Oracle SQL-عربي
- Oracle SQL Loader/ maxvlearn.com/شرح عربي
- Oracle old joins vs new joins 1999 syntax/عربي
- Oracle 12c Architecture/ شرح عربي
- Using Oracle UTL_FILE
- مقدمه قي قواعد البيانات اوراكل oracle
- Oracle explicit cursors/ شرح عربي
- oracle Instead of triggers
- NOCOPY parameter in oracle/ شرح عربي
- Oracle AUTHID current user/ شرح عربي
- Hierarchical Queries in Oracle/ عربي
- Regular Expressions in oracle part 1/ arabic
- Regular Expressions in oracle part 2/ Arabic
- Regular Expressions in oracle part 3/ Arabic
- AutoNumber & Identity Columns in oracle / arabic
- ORACLE Analytic Functions for Data Warehousing 1/ Arabic
- ORACLE Analytic Functions for Data Warehousing 2/ Arabic
- Oracle LAG & LEAD Functions / Arabic
- ORACLE Analytic Functions for Data Warehousing 3/ Arabic
- Oracle SQL:الطريقة الحديثة في بناء الجداول في احتراف
- Create Database JOB / Oracle Scheduler /عربي
- ORACLE DML ERROR LOGS/ DBMS_ERRLOG / شرح عربي
-
Oracle Database architecture
- Oracle Database architecture part 1 مقدمة بسيطة
- Oracle Database architecture part 2: databases instance vs database
- Oracle Database architecture part 3 :Server process and PGA
- Oracle Database architecture part 4:SGA- Shared pool
- Oracle Database architecture part 5 SGA- Buffer cache and others
- Oracle Database architecture part 6: PMON+ SMON+ Logical storage structure
- Oracle Database architecture part 7: Database Writer DBWn
-
Oracle Exam 1z0-061 & 1z0-071 / نصائح و حل اسئلة