https://www.udemy.com/course/full-track-be-oracle-apex-developer/?couponCode=APEX_2_150
 

كوبون شهر فبراير للكورس
بسعر 150 $ بدلا من 200 $
---------
المحتوى متجدد للكورس ان شاء الله
--------
بالتوفيق للجميع

الطريق الى أوراكل أبكس

 

المحتوى الموجود الى الآن

37hr 23min 
of video content published
https://www.udemy.com/course/full-track-be-oracle-apex-developer/?couponCode=ALI_3_180
 

https://www.udemy.com/course/full-track-be-oracle-apex-developer/?couponCode=APEX_3_100

 

تم تعديل 20 مارس 20205 سنة بواسطة alisaleh84

المحتوى الموجود الى الان 
45 ساعه 
357 محاضره 
 

 Section 1:
Intro
Lecture 1:
Intro
(Preview enabled)
 Section 2:
overview
Lecture 2:
Create Worsapce
(Preview enabled)
Lecture 3:
Asian Schema to Workspace
Lecture 4:
Create User for our worksapce
Lecture 5:
Overview in Oracle apex environment
 Section 3:
SQL Workshop
Lecture 6:
Browse Table
Lecture 7:
Create Lookup Table
(Preview enabled)
Lecture 8:
Data Section
Lecture 9:
Table Detials
Lecture 10:
User Interface Default On Table
Lecture 11:
Create Table using Wizard
Lecture 12:
Views
Lecture 13:
Index & sequence
Lecture 14:
Overview in Object browser
Lecture 15:
SQL Command
Lecture 16:
SQL Script
 Section 4:
Page Designer
Lecture 17:
Create an Application
Lecture 18:
Add and Edit Page Content
Lecture 19:
Page Designer [Rendering]
(Preview enabled)
Lecture 20:
Page Designer [Dynamic Action]
Lecture 21:
Page Designer [Processing and Page component]
Lecture 22:
Page Designer [Layout] - 1
Lecture 23:
Page Designer [Layout] - 2
Lecture 24:
Page Designer [component view/search/message/help]
Lecture 25:
Page Designer [Property Editor]
Lecture 26:
Page Designer [Toolbar]
 Section 5:
Regions
Lecture 27:
Create Blank Page
Lecture 28:
Create region and Create page with a region
Lecture 29:
Static Content [Region]
Lecture 30:
[Static Region] sub region and start new raw Property
Lecture 31:
[Static Region] Region position Property
Lecture 32:
[Static Region] column and Column spam Property
Lecture 33:
[Template] for page , region,item and button
Lecture 34:
Classic Report [Region]
Lecture 35:
Classic Report [ Column Property ] Part 1
Lecture 36:
Classic Report [ Column Property ] Part 2
Lecture 37:
Classic Report [Attributes]
Lecture 38:
Classic Report Template
(Preview enabled)
Lecture 39:
how to Create [Interactive Report]
Lecture 40:
Default Search in [Interactive Report]
Lecture 41:
Interactive report Action Menu [ select column]
Lecture 42:
Interactive report Action Menu [filter ] by column
Lecture 43:
Interactive report Action Menu [filter ] by Raw
Lecture 44:
Interactive report Action Menu [Data]
Lecture 45:
Interactive report Action Menu [Format]
Lecture 46:
Interactive report Action Menu [Chart]
Lecture 47:
Interactive report Action Menu [Group By]
Lecture 48:
Interactive report Action Menu [Pivot]
Lecture 49:
Interactive report Action Menu [Report,Download,Help And column Menu]
Lecture 50:
Interactive report [column Attributes ]
Lecture 51:
Interactive report [ Attributes ]
Lecture 52:
Interactive report [download and Printing ]
Lecture 53:
Interactive Grid Properties as End User and different between Interactive Report
Lecture 54:
Interactive Grid column Property
Lecture 55:
Interactive Grid region property
Lecture 56:
List View [Report]
Lecture 57:
List View [ Advanced Property ]
(Preview enabled)
Lecture 58:
Column Toggle Report
Lecture 59:
Reflow Report
Lecture 60:
List Region
Lecture 61:
Help Text [ Region ]
Lecture 62:
URL [Region]
Lecture 63:
Breadcrumb [Region]
Lecture 64:
Calendar Region
Lecture 65:
Chart [ Region ]
Lecture 66:
Tree [ Region ]
Lecture 67:
PL/SQL Dynamic [Region]
Lecture 68:
Region Selector [Region] and legacy Regions
Lecture 69:
Create Report With Form [Page]
Lecture 70:
Link to Form
Lecture 71:
Understand form Region strategy
(Preview enabled)
Lecture 72:
Create Separate Form Page and link it to Report Page
Lecture 73:
Editable Interactive Grid [ for User ]
Lecture 74:
Editable Interactive Grid Attributes [ for Developer]
Lecture 75:
Interactive Grid - [ Automatic Row Processing (DML) ] Attributes
Lecture 76:
Editable Interactive Work With Grid Column as Items
Lecture 77:
List View with Form
Lecture 78:
form on Procedure
Lecture 79:
Create Dashboard Page
Lecture 80:
Wizard Page
Lecture 81:
Global Page [ Page 0 ]
Lecture 82:
Legacy Pages ,Region and items
Lecture 83:
Create [Data Load ] Wizard Pages
Lecture 84:
How to use [Data Load ] Wizard to load CSV Data
Lecture 85:
Understand Data Load Wizard Process and Regions
Lecture 86:
Stacked [ master-detail ]
Lecture 87:
master-detail [ Side by Side ]
Lecture 88:
master-detail [ Drill Down ]
 Section 6:
Items
Lecture 89:
Hidden Item
Lecture 90:
[ Text Field ] Item Part 1
Lecture 91:
Text Field Item Part 2 [Layout ]
Lecture 92:
Text Field Item Part 3 [Appearance]
Lecture 93:
Text Field Item Part 4 [ Validation ]
Lecture 94:
Text Field Item Part 5 [ Advanced ]
Lecture 95:
Text Field Item Part 6 [ Default]
Lecture 96:
Text Field Item Part 7 [ Quick Picks -Server-side Condition-Read Only]
Lecture 97:
Text Field Item Part 8 [ Inline Help Text -Help Text - Comments ]
Lecture 98:
Number Field Item
Lecture 99:
Checkbox Field Item
Lecture 100:
[ Color Picker ] Field Item
Lecture 101:
[ Date Picker ] Field Item
Lecture 102:
[ Display Image ]item Field
Lecture 103:
[ File Browse ] item Field
Lecture 104:
[ Display Only ] item Field
Lecture 105:
[ List Manager ] item Field
Lecture 106:
[ Password ] item Field
Lecture 107:
[ Percent Graph ] item Field
(Preview enabled)
Lecture 108:
[ Popup LOV ] item Field
Lecture 109:
[ Rich Text Editor ] item Field
Lecture 110:
[ Radio Group ] item Field
Lecture 111:
[ Select List ] item Field and Cascading LOV
Lecture 112:
[ Select List ] item Field Part 2
Lecture 113:
[ Shuttle ] item Field
Lecture 114:
[ Switch ] item Field
Lecture 115:
[ Textarea ] item Field
Lecture 116:
[ Text Field with autocomplete ] item Field
Lecture 117:
Legacy and unsupported Items
Lecture 118:
Items in Interactive Grid
 Section 7:
Buttons
Lecture 119:
Button Appearance
Lecture 120:
Button Behavior
 Section 8:
Pages
Lecture 121:
Page Property Part 1 [Identification & Appearance ]
Lecture 122:
Page Property Part 2 [Navigation Menu & Navigation]
Lecture 123:
Page Property Part 3 [ JavaScript ]
Lecture 124:
Page Property Part 4 [ CSS ]
 Section 9:
Page Processing
Lecture 125:
Overview on Page Processing
Lecture 126:
Different between client side Condition and Server Side Condition
 Section 10:
Dynamic Action
Lecture 127:
Dynamic Action Introduction
Lecture 128:
[Browser Events] change on item
Lecture 129:
[Browser Events] false action
Lecture 130:
[Browser Events] opposite action & fire on initialization
Lecture 131:
[Browser Events] click & double click on button
Lecture 132:
[Browser Events] get focus
Lecture 133:
[Browser Events] Key-down, Key-press , Key-Release
Lecture 134:
[Browser Events] mouse event [button press,button Release,enter,leave,move]
(Preview enabled)
Lecture 135:
[Browser Events] page Load / page unload
Lecture 136:
[Browser Events] resize /resource load / select
Lecture 137:
[ Framework Events ] Before Refresh , After Refresh
Lecture 138:
[ Framework Events ] Before Page Submit , Page load
Lecture 139:
[ Framework Events ] Dialog Close
Lecture 140:
[Component Events] ( calendar event )
Lecture 141:
[Component Events] (Tree )
Lecture 142:
[Component Events] Interactive [Grid Mode change]
Lecture 143:
[Component Events] [Interactive Grid Page change]
Lecture 144:
[Component Events] Interactive Grid [Report change]
Lecture 145:
[Component Events] [Interactive Grid Raw Initialization ]
Lecture 146:
[Component Events] [Interactive Grid save]
Lecture 147:
[Component Events] [Interactive Grid View change]
Lecture 148:
[Component Events] [Interactive Grid ٍselection change]
Lecture 149:
[Custom event ]
(Preview enabled)
Lecture 150:
[Actions] Open Region / Close Region
Lecture 151:
[Actions] Clear,disable,enable,show,hide,Refresh,Set Focus
Lecture 152:
[Actions] set value
Lecture 153:
[Actions] set value with Set Type: Dialog Return Item
Lecture 154:
[Actions] Execute JavaScript Code
Lecture 155:
[Actions] Execute Pl/SQL Code, Submit
Lecture 156:
[Actions] [Cancel Event]
Lecture 157:
[Actions] [ Close Dialog ,Cancel Dialog ]
Lecture 158:
[Actions] [Add Class]
Lecture 159:
[Actions] [remove class , set style]
Lecture 160:
[Advanced] [Selection Type]
Lecture 161:
[Advanced] [Delete a Row From Classic Report with a Dynamic Action]
Lecture 162:
[Advanced] [Plugin]
(Preview enabled)
Lecture 163:
[Advanced] [Sample Dynamic Actions Application]
Lecture 164:
Dynamic Action on interactive grid column
(Preview enabled)
 Section 11:
Client Side Condition
Lecture 165:
Client-side Condition [ Item = Value ]
Lecture 166:
Client-side Condition [ Item != Value ]
Lecture 167:
Client Side Condition [ Item > & Item >= & Item < & Item <= ] Value
Lecture 168:
Client-side Condition [ Item is null & Item is not null ]
Lecture 169:
Client-side Condition [ Item is in list & Item is not in list ]
Lecture 170:
Client-side Condition [ JavaScript Expression ]
 Section 12:
Server Side Condition
Lecture 171:
Server Side Condition Intro
Lecture 172:
Server Side Condition [where can Apply ]
Lecture 173:
Rows returned & No Rows returned
Lecture 174:
SQL Expression & PL_SQL Expression & PL-SQL Function Body
Lecture 175:
Using Request in Server Side Condition
Lecture 176:
Using Items in Server Side Condition
Lecture 177:
Using User Preference in Server Side Condition
(Preview enabled)
Lecture 178:
[ Using Page ] in Server Side Condition
Lecture 179:
[ Using Read Only for page and Region ] in Server Side Condition
Lecture 180:
[ Using Authenticate ] in Server Side Condition
Lecture 181:
[ Using Language ] in Server Side Condition
(Preview enabled)
Lecture 182:
Server Side Condition [ Never ] &read Only [ Always ] & NAV Different Condition
 Section 13:
Validation
Lecture 183:
Validation intro
(Preview enabled)
Lecture 184:
Validation Using [ Rows returned & No Rows returned ]
Lecture 185:
Validation Using [ SQL - PL_SQL Expression -PL-SQL Error -PL-SQL Function Body ]
Lecture 186:
Validation Using [ using Items ]
 Section 14:
Process
Lecture 187:
Manual Form and [ PL-SQL Code Process Type ] & [ Before Header Point ]
Lecture 188:
PL-SQL Code Process Type on [ Processing Point ]
Lecture 189:
PL-SQL Code Process Type on [ Processing Point ] update & Delete and branches
(Preview enabled)
Lecture 190:
Automatic Row Fetch [Legacy] Process
Lecture 191:
Automatic Row Processing (DML) [Legacy] Process
Lecture 192:
Form Region & [ Form - Initialization ] Process
Lecture 193:
Form - Automatic Row Processing (DML) Process
Lecture 194:
Clear Session State [Process ]
Lecture 195:
Close Dialog [Process]
Lecture 196:
Interactive Grid - Automatic Row Processing (DML) [Process]
Lecture 197:
Uploaded Data Process [Parse - Prepare -Load ]
Lecture 198:
Reset Pagination [ Process ]
Lecture 199:
Send E-Mail [ Process ]
Lecture 200:
User Preferences [Process]
Lecture 201:
Form Pagination [Legacy] Process
Lecture 202:
Process Point [ New Session ]
(Preview enabled)
Lecture 203:
Process Point [ Before Header & After Header ]
Lecture 204:
Process Point [ Before Region & After Region ]
Lecture 205:
Process Point [ Before Footer & After Footer ]
Lecture 206:
Process Point [ Processing & After Submit ]
(Preview enabled)
Lecture 207:
Process Point [ Ajax Callback ]
 Section 15:
Computation
Lecture 208:
all [ Computation ] Types
 Section 16:
branches
Lecture 209:
[ branches ] Page or URL (Redirect)
Lecture 210:
[ branches ] URL Identified by Item - Function Returning a URL (Redirect)
Lecture 211:
Show Only branches
Lecture 212:
[Branches ] PL/SQL Procedure
Lecture 213:
[Branches ] Page Processing {not common}
 Section 17:
mobile shop Project
Lecture 214:
Create Category Table
Lecture 215:
Create Unit Table
Lecture 216:
Create Product Table
(Preview enabled)
Lecture 217:
Create Vendor Table
Lecture 218:
Create Client Table
Lecture 219:
Create Application
Lecture 220:
Create Page For Units
Lecture 221:
Create Page For Category
Lecture 222:
Create Report and Form For Product Part 1
(Preview enabled)
Lecture 223:
Create Report and Form For Product Part 2
Lecture 224:
Create Report and Form For Vendor 1
Lecture 225:
Create Report and Form For Vendor 2
(Preview enabled)
Lecture 226:
Create Report and Form For Clients
Lecture 227:
Create Tables for [ Sell Order & sell Order item ]
Lecture 228:
Create Master & Detail for Sell Order Part 1
Lecture 229:
Create Master & Detail for Sell Order Part 2
(Preview enabled)
Lecture 230:
Create Master & Detail for Sell Order Part 3
Lecture 231:
Update Total in Sell Order
Lecture 232:
Create Validation on Quantity
Lecture 233:
Update sell Order Report and Branching for Form Page
Lecture 234:
Use Manual Pl-SQL code for Interactive Grid in Details
(Preview enabled)
Lecture 235:
Create Master and Detail in one Step
(Preview enabled)
Lecture 236:
Using Trigger to Update Product Quantity
Lecture 237:
Dynamic Column Total for sell Order
Lecture 238:
Update Client Balance after creating sell Order
Lecture 239:
Prevent same product in same order
Lecture 240:
Use Error Handling Function to change Error Message
(Preview enabled)
Lecture 241:
How to Print Invoice Using PL-SQL Dynamic Region Part 1
Lecture 242:
How to Print Invoice Using PL-SQL Dynamic Region Part 2
Lecture 243:
How to Print Invoice Using PL-SQL Dynamic Region Part 3
Lecture 244:
How to Print Invoice Using PL-SQL Dynamic Region Part 4
(Preview enabled)
Lecture 245:
Create Master & Detail for Buy Order Overview
 Section 18:
Shared Components > Application Logic
Lecture 246:
Application Definition [ Name ]
(Preview enabled)
Lecture 247:
Application Definition [ Properties ]
Lecture 248:
Application Definition [ Application Icon ]
Lecture 249:
Application Definition [ Availability ]
Lecture 250:
Application Definition [ Error Handling ]
Lecture 251:
Application Definition [ Global Notification ]
Lecture 252:
Application Definition [ Substitutions ]
(Preview enabled)
Lecture 253:
Application Items
Lecture 254:
Application Items Global & Session Sharing
(Preview enabled)
Lecture 255:
Application Processes
Lecture 256:
Application Computations
Lecture 257:
Application Settings
Lecture 258:
Build Options
(Preview enabled)
 Section 19:
Shared Components > File
Lecture 259:
Files Static Application & Workspac Files
 Section 20:
Shared Components > Navigation
Lecture 260:
Create Static List
Lecture 261:
Create Dynamic List
Lecture 262:
List Entry - Entry
Lecture 263:
List Entry - Target [ Part 1 ]
Lecture 264:
List Entry - Target [ Part 2 ]
Lecture 265:
List Entry - Current List Entry
Lecture 266:
List Entry - [Conditions -Authorization-Configuration ]
Lecture 267:
List Entry - [ Click Counting ]
(Preview enabled)
Lecture 268:
List Entry - [ User Defined Attributes ]
(Preview enabled)
Lecture 269:
Navigation Menu & Navigation Bar
Lecture 270:
Navigation - Breadcrumbs
(Preview enabled)
 Section 21:
Shared Components > Other Components
Lecture 271:
Lists of Values - [ Static ]
Lecture 272:
Lists of Values - [ Dynamic ]
Lecture 273:
Plugin as a component
Lecture 274:
Component Settings
(Preview enabled)
 Section 22:
Shared Components > Shortcut
Lecture 275:
What is Shortcut and How to Use
(Preview enabled)
Lecture 276:
where we can Use Shortcut
Lecture 277:
How to Use Shortcut [ PL-SQL Function Body ]
Lecture 278:
Shortcut [ HTML Text with Escaped Special Chars ]
Lecture 279:
Shortcut [ image ]
Lecture 280:
Shortcut [ Text with JavaScript Escaped Single Quotes ]
Lecture 281:
Shortcut [ Message ]
Lecture 282:
Email Templates
 Section 23:
Advanced
Lecture 283:
Store Blob File Outside Oracle Database In Oracle APEX
(Preview enabled)
Lecture 284:
preview image from directory in oracle apex
(Preview enabled)
Lecture 285:
Send mail from Oracle APEX [ Mail Server ]
(Preview enabled)
Lecture 286:
Send mail from Oracle APEX [ ACL ]
(Preview enabled)
Lecture 287:
Send mail from Oracle APEX [ With Attachment ]
Lecture 288:
Send mail from Oracle APEX [ multiple Attachment ]
Lecture 289:
Send mail from Oracle APEX [ Using APEX Send MAIL Process ]
 Section 24:
Printing In Oracle APEX
Lecture 290:
Print custom PDF Report Using Report Query and Generic Report Layout
(Preview enabled)
Lecture 291:
Print custom PDF Report Using Report Query and Custom Report Layout [XSL]
(Preview enabled)
Lecture 292:
Print custom PDF Report Using Layout [XSL] Designed By Altova StyleVision 2019 i
(Preview enabled)
Lecture 293:
Print custom PDF Report Using [ PL/SQL ] Dynamic Region in Oracle Apex 19.1
(Preview enabled)
Lecture 294:
Create Custom PDF Report in Oracle Apex using [ BIRT ]
(Preview enabled)
 Section 25:
Jasper Report In Oracle APEX
Lecture 295:
Deploy Jasper Reports Integration on Tomcat
Lecture 296:
Create Jasper Report Using [ Jasper soft Studio ]
Lecture 297:
Call Jasper Report From Tomcat Using Jasper Integration
Lecture 298:
Configure Jasper API With Schema
Lecture 299:
Call Jasper Report From APEX Using Jasper API
(Preview enabled)
Lecture 300:
Call Jasper Report From APEX as Link
Lecture 301:
Call Jasper Report From APEX Using java script [1]
Lecture 302:
Call Jasper Report From APEX Using java script [2] More Details
Lecture 303:
Create Jasper Report with parameter Using [ Jasper soft Studio ]
Lecture 304:
Call Jasper Report with Parameter From APEX Using Jasper API
Lecture 305:
Call Jasper Report with Parameter From APEX Using JavaScript
 Section 26:
Security
Lecture 306:
Security intro : Authentication & Authorization
Lecture 307:
Application Express [ Authentication Schema ]
Lecture 308:
Database Accounts [ Authentication Schema ]
Lecture 309:
No [ Authentication Schema ]
Lecture 310:
Custom [ Authentication Schema ]
Lecture 311:
Open Door [ Authentication Schema ]
Lecture 312:
Other Type [ Authentication Schema ]
Lecture 313:
Login Function [ apex_authentication.login ]
Lecture 314:
[ Subscription ] Authentication Schema Property
Lecture 315:
[ Sentry Function ] Authentication Schema Property
Lecture 316:
[ Invalid Session Procedure ] Authentication Schema Property
Lecture 317:
[ Post Logout Procedure ] Authentication Schema Property
Lecture 318:
[ Legacy Attributes & Source ] Authentication Schema Property
Lecture 319:
[ Session Not Valid ] Authentication Schema Property
Lecture 320:
[ Pre-Authentication Procedure ] Authentication Schema Property
Lecture 321:
[ Post-Authentication Procedure ] Authentication Schema Property
Lecture 322:
[ Switch in Session ] Authentication Schema Property
Lecture 323:
[ Help Text ] Authentication Schema Property
Lecture 324:
[ Post-Logout URL ] Authentication Schema Property
Lecture 325:
[ Session Sharing ] Authentication Schema Property
Lecture 326:
Authorization Scheme [ Intro ]
Lecture 327:
Authorization Evaluation Point [ Once per session ]
Lecture 328:
Authorization Evaluation Point [ Once per page view ]
Lecture 329:
Authorization Evaluation Point [ Once per component ]
Lecture 330:
Authorization Evaluation Point [ Always (No Caching) ]
Lecture 331:
where we can apply Authorization
Lecture 332:
[ Exists SQL Query ] Authorization Scheme Type
Lecture 333:
[ Not Exists SQL Query ] Authorization Scheme Type
Lecture 334:
[ Item in Expression 1 is null ] Authorization Scheme Type
Lecture 335:
[ Item in Expression 1 is Not null ] Authorization Scheme Type
Lecture 336:
[ PL-SQL Function Returning Boolean ] Authorization Scheme Type
Lecture 337:
[ Value of Item in Expression 1 Equals Expression 2 ] Authorization Scheme Type
Lecture 338:
[ Value of Item in Expression 1 Does NOT Equal Expression 2 ]
Lecture 339:
[ Value of Preference in Expression 1 Equals Expression 2 ]
Lecture 340:
[ Value of Preference in Expression 1 Does NOT Equal Expression 2 ]
Lecture 341:
[ Is In Role or Group ] Authorization Scheme Type
Lecture 342:
[ Is Not In Role or Group ] Authorization Scheme Type
Lecture 343:
Use Custom User with [ Is In Role or Group ]
Lecture 344:
[ Application Access Control ] as shared component and Used Tables
Lecture 345:
Create Custom Page for [ Application Access Control ]
Lecture 346:
Create [ Application Access Control ] feature
Lecture 347:
understand Build Option for [ Access Control ] Feature
Lecture 348:
understand Application Settings for [ Access Control ] Feature
Lecture 349:
Using [ APEX_ACL API ] Part 1
Lecture 350:
Using [ APEX_ACL API ] Part 2
Lecture 351:
Understand [ Session state ] and item to [ submit ] concept
(Preview enabled)
Lecture 352:
Accessing values in session state
(Preview enabled)
Lecture 353:
[ Session State Protection ] intro
Lecture 354:
Page Access Protection [ Unrestricted ]
Lecture 355:
Page Access Protection [ Arguments Must Have Checksum ]
Lecture 356:
Page Access Protection[ No Arguments Supported ]
Lecture 357:
Page Access Protection [ No URL Access ]

 

 

تم تعديل 22 مايو 20205 سنة بواسطة alisaleh84