Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL, PLSQL and D2K Online Training Course Bundle
Rating: 4.0 out of 5(18 ratings)
104 students

SQL, PLSQL and D2K Online Training Course Bundle

Oracle SQL, PLSQL and D2K (Oracle Forms and Reports 10g) Online Training Course Bundle
Created bykoduru sridevi
Last updated 11/2019
English

What you'll learn

  • Will be Learning SQL & PL/SQL
  • Will be Learning D2K Course

Course content

3 sections • 44 lectures • 19h 1m total length

  • Oracle D2K | Oracle Forms and Reports Demo Session20:36
    • Oracle D2K | Oracle Forms and Reports Demo Session
  • Introduction to Forms 10g and Role in Oracle Apps, Fundamentals of D2K22:20
    • Introduction to Forms 10g and Role in Oracle Apps
    • Fundamentals of D2K
  • Creation of Data blocks Through wizard and Manually35:15
    • Creation of Data blocks Through wizard and Manually
    • Creation of Different Types of Canvases and Working with Canvases
    • Types of windows and working with windows and changing windows properties
  • Different types of Triggers38:58
    • Different types of Triggers
    • Working with Triggers and Applying to Different Controls
  • Creation of alerts and Calling of Alerts34:30
    • Creation of alerts and Calling of Alerts 
    • Changing Properties at runtime and Re-using Alerts
  • Creation of Editors, Types of Editors and Calling editors through Code19:09
    • Creation of Editors, Types of Editors and Calling editors through Code
  • Creating and Using Object Groups, Creating and Using Object Libraries16:53
    • Creating and Using Object Groups
    • Creating and Using Object Libraries
  • Creation of Lov through wizard and Manually38:02
    • Creation of Lov through wizard and Manually
    • Working with Lov Properties
    • Creation of Record Groups Based On Query and Using Static Values
  • Creation of Master-Detail Data Blocks36:04
    • Creation of Master-Detail Data Blocks
  • parameters32:02
    • parameters
  • Creation of Menus and attaching menus to Forms36:10
    • Creation of Menus and attaching menus to Forms
  • Working with Procedures, Functions and Packages in Forms34:21
    • Working with Procedures, Functions and Packages in Forms
    • Usage of PL/SQL Libraries in Forms and Attached Libraries
  • Introduction to Reports, Fundamentals of Reports23:52
    • Introduction to Reports
    • Fundamentals of Reports
    • Advantages, Features and role of Reports in D2K
  • Creation of Different types of Reports37:33
    • Creation of Different types of Reports
    • Creation of Reports with different Parameters
    • User Parameters
    • System Parameters
  • Working with Formula Columns, Working with Summary Columns38:30
    • Working with Formula Columns
    • Working with Summary Columns
    • Working with Place Holder Columns
  • Working with Data Links34:09
    • Working with Data Links
  • Developing Reports Manually33:46
    • Developing Reports Manually
  • Reports in Triggers17:43
    • Reports in Triggers
  • Creation of Layout in Reports, Drill Down Reports31:39
    • Creation of Layout in Reports
    • Drill Down Reports
    • Calling Reports from Forms
    • Calling Reports from Reports

Requirements

  • Minimum Knowledge in Programmming

Description

SQL, PL/SQL and D2K Training Course bundle Includes SQL & PL/SQL and D2K (Oracle Forms & Reports 10g) 


SQL & PL/SQL Course Details

This course covers Introduction to RDBMS, Introduction to SQL, Oracle data types, classification of sql, DDL and DML Commands, Integrity Constraints, SQL Functions, Character Functions, Number Functions, Date  Functions, Group Functions, Joins, Sub Queries and Clauses, Database Objects, DCL and TCL Commands, Introduction to PL/SQL, Data Types and PLSQL Blocks, Looping Structures, Conditional Statements, Cursors, Exceptions, Exceptions continued, Procedures, Functions, Packages.


Oracle D2K (Forms and Reports 10g) Course Details

From this course you will get a clear idea of 

Forms 10g and Role in Oracle Apps, Fundamentals of D2K, Creation of Data blocks Through wizard and Manually, Creation of Different Types of Canvases and Working with Canvases, Types of windows and working with windows and changing windows properties, Different types of Triggers, Working with Triggers and Applying to Different Controls, Creation of alerts and Calling of Alerts Changing Properties at runtime and Re-using Alerts, Creation of Editors, Types of Editors and Calling editors through Code, Creating and Using Object Groups . Creating and Using Object Libraries, Creation of Lov through wizard and Manually, Working with Lov Properties, Creation of Record Groups Based On Query and Using Static Values, Creation of Master-Detail Data Blocks, Parameters, Creation of Menus and attaching menus to Forms, Working with Procedures, Functions and Packages in Forms, Usage of PL/SQL Libraries in Forms and Attached Libraries, Reports 10g, Introduction to Reports . Fundamentals of Reports . Advantages, Features and role of Reports in D2K, Creation of Different types of Reports . Creation of Reports with different Parameters . User Parameters . System Parameters, Working with Formula Columns . Working with Summary Columns . Working with Place Holder Columns, Working with Data links, Developing Reports Manually, Reports in Triggers, Creation of Layout in Reports . Drill Down Reports . Calling Reports from Forms . Calling Reports from Reports.

Who should take this oracle D2K Course

PL/SQL Developer Forms Developer Application Developer Report Developer System Analyst Technical Consultant Business Intelligence Developer

Who this course is for:

  • Any Graduate

Report abuse