What You’ll Learn
This Training course is designed to provide candidates a strong foundation on Oracle SQL and Pl/SQL.
Purpose of this Course is to help Fresher,Any Graduate and Post Graduate This course begins by assuming you have no experience with Oracle SQL and PL/SQL. ,After completion of this course,Candidate will able to perform L1 and L2 Task easily in Company Plus, you will have a great foundation when preparing for the Oracle Certification exam
Oracle SQL and PL/SQL Course Details
SQL
- Introduction to SQL
- SQL DataType
- Writing Basic SQL SELECT Statements
- Restricting and Sorting Data
- Single-Row Functions
- Displaying Data from Multiple Tables
- Aggregating Data Using Group Functions
- Subqueries
- Manipulating Data
- Creating and Managing Tables
- Including Constraints
- Creating Views
- Other Database Objects like SEQUENCE,INDEX,SYNONYMS,Database Link
- Controlling User Access,Privilage
- Enhancements to the GROUP BY Clause
- Advanced Subqueries
- Hierarchical Queries
- Extensions to DML and DDL Statements
Oracle PL/SQL
- Introduction to PL/SQL
- What Is PL/SQL?
- The Origins of PL/SQL
- Creating and Running PL/SQL Code
- PL/SQL Program Structure
- Loop Basics
- Exception Handlers
- PL/SQL Program Data
- Strings
- Numbers
- Records
- Collections
- Miscellaneous Datatypes
- SQL in PL/SQL
- Data Retrieval
- Procedures, Functions, and Parameters
- Packages
- Triggers
- Managing PL/SQL Code
- I/O and PL/SQL
Oracle Forms
Oracle Forms Developer 10g: Build Internet Applications
- Introducing Oracle Forms Developer and Forms Services
- Grid Computing
- Oracle 10g Products
- Oracle Application Server 10g Architecture
- Benefits and Components of Oracle Developer Suite 10g
- Running a Forms Developer Application
- Working in the Forms Developer Environment
- Creating Forms Modules
- Working with Data Blocks and Frames
- Working with Input Items
- Working with Non Input Items
- Working with Windows and Canvases
- Producing Triggers
- Debugging Triggers
- Adding Functionality to Items
- Run-Time Messages and Alerts
- Query Triggers
- Validation
- Navigation
- Transaction Processing
- Sharing Objects and Code
- Using WebUtil to Interact with the Client
- Introducing Multiple Form Applications
Oracle Reports
Oracle Reports Developer 10g: Build Reports
- Introduction to Oracle Reports Developer
- Business Intelligence
- Enterprise Reporting
- Oracle Reports Developer
- Oracle Database 10g
- Oracle Developer Suite 10g
- Oracle Application Server 10g
- OracleAS Reports Services
- OracleAS Reports Services Architecture for the Web
- 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
- Working with SQL Worksheet
- Using SQL Developer
Basic Unix Command
- Introduction of UNIX/Linux
- Basic Unix Commands
- File and folder Permissions
- Redirect ,Append and Pipe
- Unix text Editors and Cron Job
- User Management