Oracle APEX 19 : SQL, PL/SQL to Web Application Development
Oracle APEX 19 : SQL, PL/SQL to Web Application Development, available at $54.99, has an average rating of 3.5, with 50 lectures, 6 quizzes, based on 93 reviews, and has 327 subscribers.
You will learn about An overview about Oracle SQL statement and PL/SQL Details about using Oracle APEX tool to create web application How Oracle APEX, LiveSQL can be used to learn SQL and PLSQL without any installation. How SQL, PL/SQL, Email alert and other features can be used in Page designer towards developing Oracle Apex based application RESTful webservices communication between APEX and external world – like IOT device. This course is ideal for individuals who are Anyone interested to learn building web application using Oracle APEX or Programmer and Developers It is particularly useful for Anyone interested to learn building web application using Oracle APEX or Programmer and Developers.
Enroll now: Oracle APEX 19 : SQL, PL/SQL to Web Application Development
Summary
Title: Oracle APEX 19 : SQL, PL/SQL to Web Application Development
Price: $54.99
Average Rating: 3.5
Number of Lectures: 50
Number of Quizzes: 6
Number of Published Lectures: 50
Number of Published Quizzes: 6
Number of Curriculum Items: 56
Number of Published Curriculum Objects: 56
Original Price: ₹1,199
Quality Status: approved
Status: Live
What You Will Learn
- An overview about Oracle SQL statement and PL/SQL
- Details about using Oracle APEX tool to create web application
- How Oracle APEX, LiveSQL can be used to learn SQL and PLSQL without any installation.
- How SQL, PL/SQL, Email alert and other features can be used in Page designer towards developing Oracle Apex based application
- RESTful webservices communication between APEX and external world – like IOT device.
Who Should Attend
- Anyone interested to learn building web application using Oracle APEX
- Programmer and Developers
Target Audiences
- Anyone interested to learn building web application using Oracle APEX
- Programmer and Developers
This course provides you will necessary details to develop web application using Oracle APEX ver 19. This course uses cloud version of Oracle APEX version 19, hence no install required.
Oracle APEX is ‘plug and play’ application development tool to create impressive application of forms and report based tool without use of any web programming. However, for a complex application, it would require to use SQL statement or PLSQL programming through Page designer. To make learning easier, this course also provides a brief overview about SQL and PLSQL too so that learner need not look at t other source towards learning SQL, PLSQL.
This course provide in depth details about some of the critical features available with Oracle APEX to build desired web application
There are also demonstration as how sql, plsql can be used in application development in Oracle APEX in Page processing, dynamic action and even email feature of event.
•Overview about RDBMS & SQL
•What’s RDBMS
•Entity relationship diagrams
•Environment for practice
•An overview of SQLs
•DDL, DMLs.
•Overview about PL/SQL
•Code block
•Different forms of code blocks
•Demonstration.
•Oracle Application Express
•Why Oracle Apex?
•Getting access to environment
•Navigation.
•Building application using Spreadsheet and from Database.
•Page Designer
• RESTful webservices communication between APEX and external world – like IOT device.
•Learning through Sample Application & demonstrations
Additionally there are built in Quiz section to test your understanding of Oracle APEX.
Good luck and happy learning
Course Curriculum
Chapter 1: Introduction
Lecture 1: Course Overview – Topics of coverage
Chapter 2: Overview about RDBMS and SQL
Lecture 1: What is RDBMS?
Lecture 2: Business flows, ER diagrams and RDBMS
Lecture 3: Structured Query Language – Introduction
Lecture 4: Environments to Practice SQL
Lecture 5: Data Definition Language Overview
Lecture 6: DDL Demonstration : Part 1
Lecture 7: DDL Demonstration: Part 2
Lecture 8: DML Demonstration: Part 1
Lecture 9: DML Demonstration: Part 2
Chapter 3: Overview about PL/SQL
Lecture 1: What is PL/SQL?
Lecture 2: PL/SQL code block
Lecture 3: PL/SQL program contruct
Lecture 4: PL/SQL compute demonstration
Lecture 5: Subprogram – Procedure, Functions
Lecture 6: Database Stored Procedure : Demonstration
Lecture 7: Caution : Having the objects valid
Lecture 8: Importance of exception handling – An overview
Chapter 4: Oracle APEX 19 : Introduction and access
Lecture 1: Why Oracle APEX?
Lecture 2: Accessing the Online environment
Lecture 3: Navigation in Oracle APEX
Chapter 5: Oracle APEX 19: Building a simple spreadsheet application
Lecture 1: Building a simple application from spreadsheet data
Chapter 6: Oracle APEX 19: Building Application Dashboard using database objects
Lecture 1: Creating Database objects using sample dataset
Lecture 2: Review of Database Objects
Lecture 3: Building a report using Oracle Apex
Lecture 4: Validating the report
Chapter 7: Oracle APEX 19: Building Report and Form Based Application – 1
Lecture 1: Building Report and Form based application
Lecture 2: Executing the Report and Form based Application
Chapter 8: Oracle APEX 19: Building Report and Form Based Application – 2
Lecture 1: Creation of Data objects from Data set
Lecture 2: Creating a Card Report based on DEPT
Lecture 3: Creating Form and linking it to card report
Chapter 9: Oracle APEX 19: Page Designer
Lecture 1: What is a Page Designer in Oracle Apex?
Lecture 2: Navigation in Page Designer in Oracle Apex.
Lecture 3: Passing Parameter between two Interactive Reports.
Lecture 4: Modification of report using Page Designer
Lecture 5: Custom designing sample requirement using Page Rendering and Page Processing
Lecture 6: Triggering Email from Oracle APEX based on event
Chapter 10: Oracle Apex 19 : Page Designer – Dynamic action
Lecture 1: What is Dynamic Action?
Lecture 2: Sample Application for Dynamic Action
Chapter 11: Oracle Apex 19: Page Designer – Shared Components
Lecture 1: Shared Components – Menus
Lecture 2: Shared Components – Breadcrumbs
Lecture 3: Shared Components – Authentication and Authorization Overview
Lecture 4: User Authentication – Demonstration
Lecture 5: User Authorization – Demonstration
Chapter 12: Oracle APEX 19: RESTful Webservices – communicating with external devices
Lecture 1: What is RESTful webservices
Lecture 2: Setting up RESTful webservices in Oracle APEX
Lecture 3: RESTful services set up review & Demonstration 1
Lecture 4: RESTful services – Communication between APEX & Raspberry pi (IOT Device)
Chapter 13: Oracle Apex 19: Additional learning through Sample application install
Lecture 1: Additional Learning through Sample application
Chapter 14: Next Step
Lecture 1: Next step towards further learning
Instructors
-
Guha Rajan M., B.Engg, MBA
Founder and CEO – Capstone Solutions, Trainer
Rating Distribution
- 1 stars: 5 votes
- 2 stars: 7 votes
- 3 stars: 31 votes
- 4 stars: 30 votes
- 5 stars: 20 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Digital Marketing Foundation Course
- Google Shopping Ads Digital Marketing Course
- Multi Cloud Infrastructure for beginners
- Master Lead Generation: Grow Subscribers & Sales with Popups
- Complete Copywriting System : write to sell with ease
- Product Positioning Masterclass: Unlock Market Traction
- How to Promote Your Webinar and Get More Attendees?
- Digital Marketing Courses
- Create music with Artificial Intelligence in this new market
- Create CONVERTING UGC Content So Brands Will Pay You More
- Podcast: The top 8 ways to monetize by Podcasting
- TikTok Marketing Mastery: Learn to Grow & Go Viral
- Free Digital Marketing Basics Course in Hindi
- MailChimp Free Mailing Lists: MailChimp Email Marketing
- Automate Digital Marketing & Social Media with Generative AI
- Google Ads MasterClass – All Advanced Features
- Online Course Creator: Create & Sell Online Courses Today!
- Introduction to SEO – Basic Principles of SEO
- Affiliate Marketing For Beginners: Go From Novice To Pro
- Effective Website Planning Made Simple