Oracle AllinOne Prepare for OCP certification Unique course

Name: Oracle AllinOne Prepare for OCP certification Unique course
Rating: 3.9 (2 reviews)

Learn oracle forms and reports with advance lab and coding examples using oracle developer 10G or 11G or updated (OCP)

Created byAbdul Rahman

Last updated 3/2023

English

What you'll learn

Learn Oracle Forms and reports development using 10G |11G or later with live examples
this course consists of professional forms and reports to manage your database using oracle developers with live examples
the stock inventory is a challenge in business , banks and financial sectors with live examples
course covers all the professional forms and reports using oracle forms with live examples
Create Oracle Based Applications
Manage Oracle Based Applications
Simple and Complex records
Alerts
PLsql Libraries
SQL CLASSES
OBJECT LIBRARIES
TRIGGERS | FUNCTIONS | AND MANY MORE...

Course content

2 sections • 33 lectures • 4h 27m total length

Course Description4:12
Explore Oracle all-in-one strategies to prepare for the OCP certification through a concise course description that outlines essential topics and study strategies.
db_installation2:27
Install the lemon key database using the resources, configure virtual memory, and complete the default setup to create the ORCL database, then use sqlplus to alter and unlock the user.
10g_installation_steps | after installation6:03
Connect the 11g database to the Oracle developer suite after installation by replacing tnsnames.ora with database DNS names, then start the forms server and unlock the user to log in.
10g_installation steps |developer4:05
Install ten g developer suite by increasing virtual memory, enabling Windows XP Service Pack 3 compatibility, selecting a drive (C or F), and configuring network and DNS for database access.
10g_installation_steps | after installation 25:05
Install jinitiator, replace the JVM dll in the jinitiator folder, and copy server dll. Start the forge server software engine, then run your Oracle forms connected to the 11g database.
weblogic | Previous_lectures2:15
Install and configure Oracle WebLogic Server, select a consistent installation directory, and place Oracle 11g and Oracle Forms 11g in the same ORA forms directory to ensure compatibility.
Main_points_weblogic2:15
Install the Oracle WebLogic Server from the extracted files using the installer in the C drive. If you change the directory, keep Oracle Forms 11g in the same folder.
11g_Main Points | Installation | developer3:03
Configure oracle forms and reports for development or deployment by setting the 11g path, instance name, and WebLogic credentials, then run the form via the WebLogic URL on localhost.
11g_2nd_part |developer3:15
Install Oracle forms 11g by running the executable after setting java_home and visuals space. Install jdk and weblogic first, then use the configuration assistant to finish the 11g developer setup.
forms_11g_part_final6:29
Master installing and configuring Oracle Forms 11g, perform prerequisites and memory checks, run as administrator, resolve warnings, and set up form and report services via WebLogic and app logic URLs.
11G_em_console | Open2:03
Open the WebLogic console using the saved form and reports urls, log in with your WebLogic credentials, and start form and report services while exploring the console options.
FINANCIAL FIRM

forms introductory9:27
Learn to build an Oracle Forms 11g project using the object navigator, data blocks, and canvas, add triggers, items, labels, buttons, images, and custom menus for CRUD applications.
forms run19:13
Learn to run Oracle forms after installation, configure the DNS file, connect to database users, create data blocks and canvases, and start WebLogic, Node Manager, and reports.
forms examples16:40
Create Oracle forms for student and practice schemas using automatic data block wizard and manual techniques, design canvases to display data, and build a master form with navigation buttons.
forms examples | 2 manual18:07
Create student and practice users in Oracle SQL Developer, build core tables (student, class, program, session, faculty, instructor), then practice Udemy master and Udemy master details forms and manual forms.
forms manual16:50
Create and customize manual forms in Oracle forms using data blocks, items, and canvases, linking to object and PL/SQL libraries, triggers, and alerts to build a CRUD app.
more with users4:35
Learn how to create Oracle users, grant DBA, and compare single-command versus multi-command methods. Connect as sysdba, set passwords, create the practice user, and explore future table creation.
alerts 112:47
Create and configure static and dynamic alerts in Oracle Forms to confirm deletions, using show_alert, button styles, and PL/SQL logic to guard against accidental data removal.
alerts 211:10
Convert static alerts to dynamic alerts in Oracle forms by using set alert properties and PL/SQL, enabling reusable delete confirmations across multiple forms.
CRUD 116:31
Create, delete, update, and view student records with a data block form in Oracle forms, using simple PL/SQL and buttons for minimal coding.
CRUD 28:36
Demonstrates updating records in Oracle forms by applying a program unit to enable the update button while disabling other actions, then verifies changes in SQL Developer.
CRUD 312:18
Create a CRUD based app by building a program unit to update records in forms. Explore enabling and disabling buttons and using set item properties to control form behavior.
CRUD 43:19
Build and run a CRUD-based Oracle form by compiling, linking to the main form, and executing create, read, update, and view operations.
LOGIN_PART 114:55
Learn to build a login form in Oracle Forms 11g development, including creating a users table, designing data blocks, and implementing PL/SQL login logic with error handling.
LOGIN_PART 27:56
Develop a functional Oracle Forms login form by configuring username and password fields, handling exceptions, validating credentials against a users table, and masking the password for security.
MENUE_PART 15:06
create and customize menus in oracle forms using the menu editor, attach data blocks and libraries, and configure menu items, properties, and compilation into mw and dot files.
MENUE_PART 214:02
Edit and manage menus, call forms against menus, and link login, journal, and library forms with PL/SQL libraries, object libraries, and paths to fmcs files.
OBJECT LIBRARY9:03
Create and link an object library to reuse alerts, buttons, and program units across multiple forms, save the library, and organize with tabs and drag and drop.
PLSQL LIBRARY5:41
Learn to create and attach a plsql library in Oracle forms 11g, reuse program units across forms, and quickly build a data block with the automatic wizard.
EXTRA SETTING 13:32
Learn to run your form without interruptions by disabling warnings in Internet Explorer and security settings. Enable mixed content and specify the form location to prevent warning prompts.
EXTRA SETTING 24:31
Display a form in full screen by editing the forms web cfg file and backing it up. Adjust height and width to match your screen resolution, then compile and run.
Introduction_Manual_Forms_run_application_using_Null_Values.3:10
Create and manage manual forms using the data block and wizard, set up object library components, and implement login, alerts, and crud features in an Oracle app.
Oracle | Reports_Lab8:39
Open the Oracle report developer, use the report wizard to build a department table report with JDBC/SQL/XML queries and templates, then apply built-in functions.

Requirements

installation of database 10g or 11g and installation and configuration of forms and reports
Knowledge of writing sql/plsql

Description

This course covers oracle 10g and 11g forms and reports section with live examples and coding exercises. the forms that coded during the course. you can find from the resources of lectures. the oracle 10G and 11g developers are challenge to configure and work to handle financial data , stock data in a stock inventory system. Banking sectors using transaction processing systems that can be embedded / attached with oracle forms and reports. there's no data found on internet to learn these technologies for development. Our team took initiative to announce this environment first time at Udemy. I hope the learners would enjoy the course and techniques with coding examples of plsql writing in oracle forms and reports. In web based application developer and user interacts with a web based form and developer needs to write hundreds of lines and keywords to manage a single web form whereas , when a developer starts writing code, he can achieve his target/goal with minimum line of coding and using customize features in oracle forms and reports using oracle developer 10G or higher than 11g. Oracle introduced the latest versions of 11G , currently the 21c but the features are the same although the interface is different. therefore, it's not the difference either you are working in 11G developer or higher than the 11G. This was the challenge to launch this course for new learner : those are willing to work in the forms and reports environment or already working in forms and reports and wants to enhance their skills. After this course , you can go for the certifications exams of Oracle developer :Oracle Certified Professional(OCP)

Main Points in this course that covers

-oracle forms

-oracle reports

-writing your own sql/plsql

-functions

-procedures

-triggers

-alerts

-classes/libraries

-crud based application...etc.

Who this course is for:

software developers
oracle developers
database administrators
information technology
inventory stock management | sales and purchase systems
Developer
Company's Forms and Reports Developers
Banks/Financial sectors IT Management

Oracle AllinOne Prepare for OCP certification Unique course

What you'll learn

Explore related topics

Course content

First Section on Configuration11 lectures • 41min

Professional and advance Section22 lectures • 3hr 46min

Requirements

Description

Who this course is for: