| Oracle Database 19c: SQL | Overview of Relational Database Management Concepts and Terminologies |
| SQL Statements list used in SQL Course |
| Human Resources (HR) Schema Description |
| Database objects Concept |
| Concept of Table structure |
| Using Basic SELECT Statements |
| Using Concatenation in SQL Statement |
| Using DISTINCT KEYWORD in SQL Statement |
| Using Calculations in SQL Statement |
| Using Column Alias in SQL Statement |
| Using Where Clause in SQL Statement |
| Using Order by Clause in SQL Statement |
| Using TO_CHAR and TO_DATE function in SQL Statement |
| Using UPPER, LOWER, INITCAP function in SQL Statement |
| Using ROUND, TRUNC function in SQL Statement |
| Using LPAD, RPAD function in SQL Statement |
| Using NVL Function in SQL Statement |
| Using CASE Expression in SQL Statement |
| Using Decode function in SQL Statement |
| Using Group Functions in SQL Statement |
| Using Group by Clause in SQL Statement |
| Using Having Clause in SQL Statement |
| Using JOIN in SQL Statement |
| Using NATURAL JOIN in SQL Statement |
| Using Clouse in SQL Statement |
| Using ON Clause in SQL Statement |
| Using Subquery in SQL Statement |
| Using With clause in SQL Statement |
| Concept of Data types |
| Concept of Constraints |
| Creating Table as Schema object |
| Oracle Database 19c: PL/SQL | Concept of PL/SQL |
| Concept of PL/SQL Run-Time Architecture |
| Benefits of PL/SQL |
| Concept of PL/SQL Block Structure |
| Concept of PL/SQL Block Types |
| Concept of PL/SQL Triggers |
| Concept of vriable in PL/SQL |
| Declaring and using variable in PL/SQL |
| Using Select Statments in PL/SQL |
| Inserting Data Using PL/SQL |
| Updating Data Using PL/SQL |
| Deleting Data Using PL/SQL |
| Using IF Statment in PL/SQL |
| EXCEPTION Handling in PL/SQL |
| Using LOOPS in PL/SQL |
| Fetching data(all rows with loop) from the cursor in PL/SQL |
| Using cursor for loop in PL/SQL |
| Concept of Stored Function |
| Creating Stored Function |
| Concept of Stored Procedure |
| Creating Stored Procedure |
| Concept of Stored Package |
| Creating Package specification |
| Creating Package body |
| Creating Trigger |
| Viewing Triggering actions |
| APEX | Introduction to the art of building desktop and mobile web applications |
| Oracle APEX concepts |
| Installing Apex your local environment |
| Creating a Workspace in Oracle APEX |
| Creating an application in Oracle APEX |
| Running an Application |
| Uploading Images |
| Adding an Image as an Application Logo |
| Understanding Project/Application Design |
| Undershtanding Application security |
| Undershtanding Navigation Menu |
| Overview of Application Express Shared Components |
| Dynamic and Static Lists of Values |
| Create a Dynamic List of Values |
| Create a Static List of Values |
| Creating application components |
| Understand Application Branching |
| Authentication scheme |
| Authorization scheme |
| Concept of APEX_COLLECTION |
| Overview of Application Express Navigation Components |
| Creating Navigation Menu |
| Manage the Navigation Menu |
| Create Navigation Bar Entries |
| Create and Use Lists and List Items |
| Creating schema objects such as tables |
| Uploading data from Excel |
| Introducing and preparing dashboard in web applications |
| Adding multiple regions to a page |
| Using the chart in the dashboard |
| Creating application pages for managing customers |
| Viewing Page, Region, Items Attributes in Page Designer |
| Editing Page, Region, Items Attributes in Page Designer |
| Creating an interactive grid |
| Customizing wizard-generated pages |
| Linking To Other Pages |
| Dynamic Actions |
| Program developed for set up products catalog |
| Creating an interactive report |
| Create Page Items |
| Create Application Items |
| Handling images |
| Customizing interactive report |
| Uploading and viewing files |
| Creating application pages for managing supplier |
| Creating application page for managing stock |
| Using PL/SQL Trigger for managing stock |
| Creating application pages for managing purchase |
| Creating Master-Details Reports |
| Program develop for taking orders |
| Creating Master-Details forms |
| Display Dynamic Content |
| Process data |
| Creating a chart and group by views in an interactive report |
| Program developed for graphical reports & mobile integration |
| Creating chart, calendar, Tree |
| Program developed for producing advance reports |
| Installing and Using BI Publisher |
| Using data grouping and sorting |
| Conditional and standard formatting |
| Using calculations |
| Creating a parameterized report |
| Exploring report printing |
| Defining application segments for security |
| Creating groups with different application privileges |
| Assigning application privileges on individual application segments |
| Creating users and assigning groups |
| Setting and resetting user passwords |
| Adding custom database functions |
| Implementing the custom authenticating scheme |
| Implementing applications security |
| Deploying applications |
| Export application |
| Export/Import data |
| Import application |