CourseOracle Database Application Development
Course Content
MODULE 01: Programming Practices & Database Fundamentals
-
Introduction to Programming
-
Types of Programming Languages
-
Compiler vs Interpreter
-
Problem Solving Techniques
-
Algorithm Fundamentals
-
Flowchart Design
-
Pseudocode Writing
-
Variables and Constants
-
Data Types
-
Operators
-
Expressions
-
Input and Output
-
Conditional Statements
-
Looping Statements
-
Functions
-
Arrays
-
Strings
-
Object-Oriented Programming Concepts
-
Database Fundamentals
-
DBMS and RDBMS
-
Database Architecture
-
Tables and Records
-
Keys and Relationships
-
ER Diagram
-
Data Modeling
-
Normalization
MODULE 02: Oracle Database 19c SQL
-
Oracle Database Introduction
-
Oracle Database Architecture Overview
-
SQL Fundamentals
-
SELECT Statement
-
WHERE Clause
-
ORDER BY Clause
-
DISTINCT Keyword
-
SQL Operators
-
Character Functions
-
Number Functions
-
Date Functions
-
Conversion Functions
-
Aggregate Functions
-
GROUP BY Clause
-
HAVING Clause
-
Joins
-
Inner Join
-
Outer Join
-
Self Join
-
Cross Join
-
Subqueries
-
Correlated Subqueries
-
Views
-
Sequences
-
Synonyms
-
Constraints
-
Primary Key
-
Foreign Key
-
Unique Constraint
-
Check Constraint
-
Indexes
-
Transactions
-
COMMIT
-
ROLLBACK
-
SAVEPOINT
MODULE 03: Oracle Database 19c PL/SQL
-
Introduction to PL/SQL
-
PL/SQL Block Structure
-
Variables and Constants
-
Control Structures
-
IF Statements
-
CASE Statements
-
Loops
-
Cursors
-
Implicit Cursor
-
Explicit Cursor
-
Cursor Attributes
-
Procedures
-
Functions
-
Packages
-
Package Specification
-
Package Body
-
Exception Handling
-
User Defined Exceptions
-
Triggers
-
BEFORE Trigger
-
AFTER Trigger
-
Row Level Trigger
-
Statement Level Trigger
-
Collections
-
Nested Tables
-
VARRAY
-
Associative Arrays
-
Dynamic SQL
-
Bulk Collect
-
FORALL
MODULE 04: Oracle Forms Developer
-
Oracle Forms Introduction
-
Oracle Forms Architecture
-
Forms Builder
-
Form Modules
-
Data Blocks
-
Canvas
-
Windows
-
Record Groups
-
LOV (List of Values)
-
Triggers
-
Form Navigation
-
Validation Techniques
-
Master Detail Forms
-
Menus
-
Alerts
-
Parameters
-
Authentication
-
Error Handling
-
Forms Deployment
-
Runtime Environment
MODULE 05: Oracle Reports Developer
-
Oracle Reports Introduction
-
Reports Architecture
-
Reports Builder
-
Data Model
-
Query Design
-
Tabular Reports
-
Group Reports
-
Matrix Reports
-
Summary Reports
-
Formula Columns
-
Summary Columns
-
Parameters
-
Lexical Parameters
-
Report Triggers
-
Layout Design
-
Charts
-
PDF Reports
-
XML Reports
-
Report Deployment
-
Report Optimization
MODULE 06: HTML5, CSS3 and JavaScript
-
Introduction to Web Development
-
HTML5 Fundamentals
-
HTML Forms
-
Semantic HTML
-
Tables
-
Multimedia
-
SVG
-
Canvas
-
CSS3 Fundamentals
-
Selectors
-
Box Model
-
Flexbox
-
CSS Grid
-
Positioning
-
Responsive Design
-
Media Queries
-
Animations
-
Transitions
-
JavaScript Fundamentals
-
Variables
-
Data Types
-
Functions
-
Arrays
-
Objects
-
DOM Manipulation
-
Event Handling
-
JSON
-
Fetch API
-
Promises
-
Async/Await
-
ES6 Features
MODULE 07: Oracle Application Express (APEX)
-
Oracle APEX Introduction
-
Workspace Management
-
Application Builder
-
Page Designer
-
Creating Applications
-
Forms
-
Reports
-
Interactive Reports
-
Interactive Grid
-
Dashboards
-
Charts
-
Dynamic Actions
-
Validation
-
Processes
-
Computations
-
Branches
-
Session State
-
Authentication
-
Authorization
-
LOV
-
RESTful Services
-
Web Services
-
Themes
-
Templates
-
Responsive Design
-
Debugging
-
Deployment
-
Performance Optimization
MODULE 08: Oracle DBA Fundamentals
-
Introduction to DBA
-
Oracle Architecture
-
Instance Management
-
Memory Structures
-
Background Processes
-
Tablespaces
-
Datafiles
-
Control Files
-
Redo Logs
-
User Management
-
Roles and Privileges
-
Profiles
-
Backup Concepts
-
Recovery Concepts
-
RMAN
-
Data Pump Export
-
Data Pump Import
-
Listener Configuration
-
Network Configuration
-
Monitoring
-
Performance Tuning
-
AWR Reports
-
Security
-
Auditing
-
Startup and Shutdown
-
Patching
-
High Availability Concepts
MODULE 09: Real World Projects
-
Student Management System
-
Library Management System
-
Inventory Management System
-
Hospital Management System
-
HR & Payroll Management System
-
E-Commerce Database System
-
Banking Management System
-
Reporting System Development
-
Role-Based Access Control System
-
Authentication and Authorization System
MODULE 10: Capstone Project
-
Requirement Analysis
-
Database Design
-
ER Diagram Design
-
SQL Development
-
PL/SQL Development
-
Forms Development
-
Reports Development
-
APEX Development
-
Testing
-
Debugging
-
Deployment
-
Documentation
-
Presentation
MODULE 11: Professional Development & Career Preparation
-
Software Development Life Cycle
-
Agile Fundamentals
-
Scrum Fundamentals
-
Git Fundamentals
-
GitHub Workflow
-
Software Testing Basics
-
API Fundamentals
-
Technical Documentation
-
Resume Writing
-
LinkedIn Optimization
-
GitHub Portfolio Development
-
Technical Interview Preparation
-
HR Interview Preparation
-
Freelancing Fundamentals
-
Professional Communication
MODULE 12: Final Assessment & Certification
-
SQL Assessment
-
PL/SQL Assessment
-
Forms Assessment
-
Reports Assessment
-
APEX Assessment
-
DBA Assessment
-
Project Assessment
-
Viva Examination
-
Mock Interview
-
Final Examination
-
Certification Evaluation
Student Ratings & Reviews
No Review Yet