Oracle Database Design and Development

Oracle Database Design & Development

Next Live Batch Starts : 16th June 2023 09:00 P.M.

Course Content :

Oracle Database 19c: SQL Fundamentals :

Introduction

Explain the theoretical and physical aspects of a relational database)

Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime
Use SQL row limiting clause

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Displaying Data From Multiple Tables Using Joins

Use SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using OUTER joins

Managing Tables using DML statements

Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Retrieving Data using the SQL SELECT Statement

Execute a basic SELECT statement

Using Single-Row Functions to Customize Output

Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements

Reporting Aggregated Data Using the Group Functions

Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Using Subqueries to Solve Queries

Define subqueries
Describe the types of problems that the subqueries can solve
Describe the types of subqueries
Use single-row and multiple-row subqueries
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Introduction to Data Definition Language

Describe the data types that are available for columns
Create a simple table
Create constraints for tables
Describe how schema objects work

Oracle Database 19c Administration 1

This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course.

To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

Introduction
Oracle Database Architecture
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Accessing an Oracle Database
Managing DBCS Database Deployments
Managing Database Instances
Understanding Oracle Net Services
Administering User Security
Creating PDBs
Creating Master Encryption Keys for PDBs
Creating and Managing Tablespaces
Managing Storage Space
Managing Undo Data
Moving Data
Backup and Recovery Concepts
Backup and Recovery Configuration
Creating Database Backups
Performing Database Recovery
Monitoring and Tuning Database Performance
SQL Tuning
Miscellaneous

Oracle Database 19c Administration 2

Creating CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Configure and create a CDB
Create a new PDB from the CDB seed
Explore the structure of PDBs

Backup and Duplicate – Oracle Database: Managing Multitenant Architecture Ed 1

Perform Backup and Recover CDBs and PDBs
Duplicate an active PDB
Duplicate a Database

Manage Application PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Explain the purpose of application root and application seed
Define and create application PDBs
Install, upgrade and Patch applications
Create and administer Application PDBS
Clone PDBs and Application containers
Plug and unplug operations with PDBs and application containers
Comparing Local Undo Mode and Shared Undo Mode

Recovery and Flashback – Oracle Database: Managing Multitenant Architecture Ed 1

Restore and Recovering Databases with RMAN
Perform CDB and PDB flashback

Backup Strategies and Terminology – Oracle Database: Backup and Recovery Workshop

Perform Full and Incremental Backups and Recoveries
Compress and Encrypt RMAN Backups
Use a media manager
Create multi-section backups of very large files
Create duplexed backup sets
Create archival backups
Backup of recovery files
Backup non database files
Back up ASM meta data

Restore and Recovery Concepts – Oracle Database: Backup and Recovery Workshop

Employ the best Oracle Database recovery technology for your failure situation
Describe and use Recovery technology for Crash, Complete, and Point-in-time recovry

Using Flashback Technologies – Oracle Database: Backup and Recovery Workshop

Configure your Database to support Flashback
Perform flashback operations

Duplicating a Database – Oracle Database: Backup and Recovery Workshop

Duplicate Databases

Diagnosing Failures – Oracle Database: Backup and Recovery Workshop

Detect and repair database and database block corruption
Diagnosing Database Issues

Transporting Data – Oracle Database: Backup and Recovery Workshop

Transport Data

Install Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Install Grid Infrastructure for a Standalone server
Install Oracle Database software

Patching Grid Infrastructure and Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Patch Grid Infrastructure and Oracle Database

Upgrading to Oracle Grid Infrastructure – Oracle Database: Deploy, Patch and Upgrade Workshop

Upgrade Oracle Grid Infrastructure

Oracle Database 18c: New Features – Oracle Database: Deploy, Patch and Upgrade Workshop

Image and RPM based Database Installation

Oracle Restart – Oracle Database: Deploy, Patch and Upgrade Workshop

Configure and use Oracle Restart to manage components

Install Grid Infrastructure for a Standalone server – Oracle Database: Deploy, Patch and Upgrade Workshop

Rapid Home Provisioning

Using Availability Enhancements – Oracle Database 19c: New Features for Administrators

Use an RMAN recovery catalog
Use Flashback Database

Monitoring and Tuning Database Performance – Oracle Database: Administration Workshop

Managing Memory Components
Understanding The Automatic Workload Repository (AWR)
Understanding The Advisory Framework
Monitoring Wait Events, Sessions, and Services
Managing Metric Thresholds and Alerts
Understanding and Using The Performance Tuning Methodology
Performing Performance Planning
Understanding The Automatic Database Diagnostic Monitor (ADDM)

Manage CDBs and PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Manage PDB service names and connections
Manage startup, shutdown and availability of CDBs and PDBs
Change the different modes and settings of PDBs
Evaluate the impact of parameter value changes
Performance management in CDBs and PDBs
Control CDB and PDB resource usage with the Oracle Resource Manager

Upgrading and Transporting CDBs and Regular PDBs – Oracle Database: Managing Multitenant Architecture Ed 1

Upgrade an Oracle Database
Transport Data

Manage Security in Multitenant databases – Oracle Database: Managing Multitenant Architecture Ed 1

Manage Security in Multitenant databases
Manage PDB lockdown profiles
Audit Users in CDBs and PDBs
Manage other types of policies in application containers

Configuring and Using RMAN – Oracle Database: Backup and Recovery Workshop

Configure RMAN and the Database for Recoverability
Configureand Using an RMAN recovery catalog

Performing Recovery – Oracle Database: Backup and Recovery Workshop

Restore and Recovering Databases with RMAN
Perform Non RMAN database recovery

RMAN Troubleshooting and Tuning – Oracle Database: Backup and Recovery Workshop

Interpret the RMAN message output
Diagnose RMAN performance issues

Creating an Oracle Database by using DBCA – Oracle Database: Deploy, Patch and Upgrade Workshop

Create, Delete and Configure Databases using DBCA

Upgrade the Oracle Database – Oracle Database: Deploy, Patch and Upgrade Workshop

Plan for Upgrading an Oracle Database
Upgrade an Oracle Database
Perform Post-Upgrade tasks

Using General Overall Database Enhancements – Oracle Database 19c: New Features for Administrators

Install Oracle Database software
Create, Delete and Configure Databases using DBCA
Creating CDBs and Regular PDBs
Use Miscellaneaous 19c New Features

Using Diagnosibility Enhancements – Oracle Database 19c: New Features for Administrators

Use new Diagnoseability Features

Tuning SQL Statements – Oracle Database: Administration Workshop

Understanding The Oracle Optimizer
Using The SQL Tuning Advisor
Managing Optimizer Statistics
Using The SQL Access Advisor
Understanding The SQL Tuning Process

Oracle Fusion Middleware : Build Application with Oracle Forms.

Running a Forms Application
Working in the Forms Builder Environment
Creating a Basic Form Module
Creating a Master-Detail Form
Working Data Blocks and Frames
Working with Text Items
Creating LOVs and Editors
Creating Additional Input Items
Creating Noninput Items
Creating Windows and Content Canvases
Working with Other Canvas Types
Producing and Debugging Triggers
Adding Functionality to Items
Displaying Run-Time Messages and Alerts
Using Query Triggers
Validating User Input
Controlling Navigation
Overriding or Supplementing Transaction Processing
Writing Flexible Code
Sharing Objects and Code
Using WebUtil to Interact with the Client
Introducing Multiple Form Applications

Oracle Reports Developer : Build Reports

Introduction to Oracle Reports Developer
Designing and Running Reports
Exploring Oracle Reports Developer
Creating a Paper Report
Enhancing a Basic Paper Report
Managing Report Templates
Creating a Web Report
Enhancing Reports Using the Data Model: Queries and Groups
Enhancing Reports Using the Data Model: Data Sources
Enhancing Reports Using the Data Model: Creating Columns
Enhancing Reports Using the Paper Layout
Controlling the Paper Layout: Common Properties
Controlling the Paper Layout: Specific Properties
Web Reporting
Extending Functionality Using XML
Creating and Using Report Parameters
Embedding a Graph in a Report
Enhancing Matrix Reports
Coding PL/SQL Triggers
Extending Functionality Using the SRW Package
Maximizing Performance Using OracleAS Reports Services
Building Reports: Efficiency Guidelines

Software Project: Point of Sell

Oracle Apex :

Course Overview

Introducing Oracle Application Express

Application Express Overview
Using Application Express
Application Express Terms and Concepts
How to Install Oracle Apex Latest Version

1 – Creating a Desktop and Mobile Database Application

1. Application Builder Overview
2. Creating Mobile Application
3. Introducing Database Applications
4. Creating Database Applications

2 – Working with Reports for Desktop Application

1. Using Interactive Reports
2. Using Classic Reports
3. Introducing Reports
4. Creating and Customizing an Interactive Report

3 – Working with Reports for Mobile Application

1. Creating a Reflow Report
2. Creating Reports for a Mobile Application
3. Creating Column Toggle Report

4 – Creating Forms

1. Creating Forms
2. Creating a Form in a Mobile Application
3. Modifying Forms
4. Using Forms

5 – Working with Pages and Regions

1. Working with Page Regions
2. Introducing Page Definition
3. Working with Pages

6 – Adding Items and Buttons

1. Creating List of Value (LOV) Type of Items
2. Using Buttons
3. Introducing Items
4. Using Items

7 – Understanding Session State

1. Using Session State in Oracle Application Express
2. Understanding Session State in Oracle Application Express

8 – Including Page Processing

1. Introducing Page Processing
2. Including Computations
3. Including Branches
4. Including Processes
5. Including Validations

9 – Validating and Debugging Your Application

1. Using the Advisor
2. Managing Your Attribute Dictionary
3. Debugging Your Application

10 – Adding Shared Components That Aid Navigation

1. Introducing Shared Components
2. Creating a Navigational Bar
3. Creating Lists
4. Creating Tabs
5. Creating Breadcrumbs

11 – Working with Themes, Templates and Files

1. Using Templates
2. Using Files
3. Using Themes

12 – Implementing Security

1. Using Authorization Schemes
2. Using Authentication Schemes
3. Using Session State Protection
4. Securing an Application

13 – Managing Application Navigation

1. Enforcing Authorization on Your Site Map
2. Building a Site Map
3. Building a Hierarchical List with Images
4. Linking Interactive Reports using a Declarative Filter

14 – Extending Your Application

1. Sending Email from an Application
2. Creating Data Load Wizard Pages
3. Creating an Upload and Download Page
4. Adding BLOB Data to an Existing Application

15 – Creating and Editing Charts

1. Creating and Using Charts
2. Enhanced Charting Examples

16 – Adding Calendars and Trees

1. Using Calendars
2. Using Trees

17 – Using Dynamic Actions and Plug-Ins

1. Using Dynamic Actions
2. Using Plug-Ins

18 – Utilizing Application Express Printing

1. Printing a Standard Report with Derived Output
2. Creating a PDF Report with Multiple Queries

19 – Managing Application Feedback

1. What is Team Development?
2. Managing Feedback

Software Project : (Oracle Apex)

Human Resource Management Systems.
POS Software.

Reporting :

HTML Report
Jasper Soft Report

Next Live Batch Starts : 19th July 2023 09:00 P.M.

Course Fees 21,000/-

Early Bird Discount. BDT. 2,000/- Last Date – 10th June 2023

Buy Course

Free Demo Class (Pre-Recorded) Click Here!
Free Live Orientation Class : 9th June 2023 09:00 P.M. Join Here !
Course Curriculums (PDF)

Course Benefit :

6 Months Study Plan
36 Assignments
50 Live Classes
100 Hours Live Classes
Job / Internship facilities
Weekly Assessment Tests.
Course Completion Certificates.

Instructor

Muhammad Abdullah Al noor

ওরাকল সার্টিফাইড প্রফেশনাল হউন । ৮০% এর উপর ওরাকল সার্টিফাইড প্রফেশনাল জানিয়েছেন তারা এই সার্টিফিকেশনের মাধ্যমে তাদের –

বেতন বৃদ্ধি করিয়েছেন,
প্রমোশন পেয়েছেন অথবা
নতুন চাকরি পেয়েছেন ।

২ মিলিওনের উপর ওরাকল সার্টিফাইড প্রফেশনাল কমিউনিটিতে যোগ দিন –

ওরাকল সার্টিফাইড প্রফেশনাল হলে আপনি একজন দক্ষ আইটি প্রফেশনাল হতে পারবেন ।
আপনার এই নতুন দক্ষতায় আপনার ক্যারিআরের পরিধি হবে বিশ্বব্যাপি ।
শিখুন কিভাবে ক্রিটিকাল সিস্টেম ইমপ্লিমেন্ট, ডেভলপ ও এডমিনিস্ট্রেট করতে পারবেন ।
আপনার ক্যারিয়ারের সুযোগকে আরও প্রশস্ত করার মাধ্যমে আপনার ম্যানেজার এবং কলিগদের কাছ থেকে সম্মান পাবেন।

Course Content :
Course Content is from Oracle University.

Community

Join Our Community. Click Here.

Help

WhatsApp +8801790721177

Payment Procedure :
Payment Method :
Bank (Dutch Bangla Bank, Name – Muhammad Abdullah Al Noor, A/C No – 101.101.177691)
Bikash (+88 017 9072 1177)
Rocket (+88 017 1212 83419)
Nagad (+88 017 1212 8341)

After payment submit this form : https://trainerbd.com/payment/