Next Live Batch Starts : 16th July 2023 09:00 P.M.
Course Content :
The Course Content is from Oracle University Course Curriculum.
Oracle Database : 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 : Program with PL/SQL
Introduction
- Course Objectives
- Course Agenda
- Describe the Human Resources (HR) Schema
- PL/SQL development environments available in this course
- Introduction to SQL Developer
Introduction to PL/SQL
- Overview of PL/SQL
- Identify the benefits of PL/SQL Subprograms
- Overview of the types of PL/SQL blocks
- Create a Simple Anonymous Block
- How to generate output from a PL/SQL Block?
Declare PL/SQL Identifiers
- List the different Types of Identifiers in a PL/SQL subprogram
- Usage of the Declarative Section to Define Identifiers
- Use variables to store data
- Identify Scalar Data Types
- The %TYPE Attribute
- What are Bind Variables?
- Sequences in PL/SQL Expressions
Write Executable Statements
- Describe Basic PL/SQL Block Syntax Guidelines
- Learn to Comment the Code
- Deployment of SQL Functions in PL/SQL
- How to convert Data Types?
- Describe Nested Blocks
- Identify the Operators in PL/SQL
Interaction with the Oracle Server
- Invoke SELECT Statements in PL/SQL
- Retrieve Data in PL/SQL
- SQL Cursor concept
- Avoid Errors by using Naming Conventions when using Retrieval and DML Statements
- Data Manipulation in the Server using PL/SQL
- Understand the SQL Cursor concept
- Use SQL Cursor Attributes to Obtain Feedback on DML
- Save and Discard Transactions
Control Structures
- Conditional processing using IF Statements
- Conditional processing using CASE Statements
- Describe simple Loop Statement
- Describe While Loop Statement
- Describe For Loop Statement
- Use the Continue Statement
Composite Data Types
- Use PL/SQL Records
- The %ROWTYPE Attribute
- Insert and Update with PL/SQL Records
- INDEX BY Tables
- Examine INDEX BY Table Methods
- Use INDEX BY Table of Records
Explicit Cursors
- What are Explicit Cursors?
- Declare the Cursor
- Open the Cursor
- Fetch data from the Cursor
- Close the Cursor
- Cursor FOR loop
- The %NOTFOUND and %ROWCOUNT Attributes
- Describe the FOR UPDATE Clause and WHERE CURRENT Clause
Exception Handling
- Understand Exceptions
- Handle Exceptions with PL/SQL
- Trap Predefined Oracle Server Errors
- Trap Non-Predefined Oracle Server Errors
- Trap User-Defined Exceptions
- Propagate Exceptions
- RAISE_APPLICATION_ERROR Procedure
Stored Procedures
- Create a Modularized and Layered Subprogram Design
- Modularize Development With PL/SQL Blocks
- Understand the PL/SQL Execution Environment
- List the benefits of using PL/SQL Subprograms
- List the differences between Anonymous Blocks and Subprograms
- Create, Call, and Remove Stored Procedures
- Implement Procedures Parameters and Parameters Modes
- View Procedure Information
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
Next Live Batch Starts : 16th July 2023 09:00 P.M.
Course Fees 10,000/-
Early Bird Discount. BDT. 3,000/- Last Date – 10th July 2023
Free Demo Class (Pre-Recorded) Click Here!
Free Live Orientation Class : 9th July 2023 09:00 P.M. Join Here !
Course Curriculums (PDF)
Course Benefit :
- 3-Months Study Plan
- 12 Assignments
- 24 Live Classes
- Job / Internship facilities
- Weekly Assessment Tests.
- Course Completion Certificates.
ওরাকল সার্টিফাইড প্রফেশনাল হউন । ৮০% এর উপর ওরাকল সার্টিফাইড প্রফেশনাল জানিয়েছেন তারা এই সার্টিফিকেশনের মাধ্যমে তাদের –
- বেতন বৃদ্ধি করিয়েছেন,
- প্রমোশন পেয়েছেন অথবা
- নতুন চাকরি পেয়েছেন ।
২ মিলিওনের উপর ওরাকল সার্টিফাইড প্রফেশনাল কমিউনিটিতে যোগ দিন –
- ওরাকল সার্টিফাইড প্রফেশনাল হলে আপনি একজন দক্ষ আইটি প্রফেশনাল হতে পারবেন ।
- আপনার এই নতুন দক্ষতায় আপনার ক্যারিআরের পরিধি হবে বিশ্বব্যাপি ।
- শিখুন কিভাবে ক্রিটিকাল সিস্টেম ইমপ্লিমেন্ট, ডেভলপ ও এডমিনিস্ট্রেট করতে পারবেন ।
- আপনার ক্যারিয়ারের সুযোগকে আরও প্রশস্ত করার মাধ্যমে আপনার ম্যানেজার এবং কলিগদের কাছ থেকে সম্মান পাবেন।
Oracle 12C Fusion Middleware Forms Developer ট্র্যাকে দক্ষতা অর্জন করতে চাইলে নিচের তিনটি বিষয়ে কোর্স করুন ও সার্টিফিকেট অর্জন করুন –
- Oracle Database : Introduction to SQL.
- Oracle Database : Program With PLSQL.
- Oracle Fusion Middleware : Build Application with Oracle Forms.
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/
