SQL, PL/SQL and D2K Training Course Bundle
3.8 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled

SQL, PL/SQL and D2K Training Course Bundle

Oracle SQL, PL/SQL and D2K (Oracle Forms & Reports 10g) Training Course Bundle
3.8 (6 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
16 students enrolled
Created by koduru sridevi
Last updated 7/2018
English
Current price: $22.99 Original price: $29.99 Discount: 23% off
30-Day Money-Back Guarantee
This course includes
  • 19 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to Udemy's top 3,000+ courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Will be Learning SQL & PL/SQL
  • Will be Learning D2K Course

Requirements
  • Minimum Knowledge in Programmming
Description


SQL, PL/SQL and D2K Training Course bundle Includes SQL & PL/SQLand 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
Course content
Expand all 43 lectures 19:01:31
+ D2K (Forms & Reports 10g) Course
19 lectures 09:41:32
  • Oracle D2K | Oracle Forms and Reports Demo Session
Preview 20:36
  • Introduction to Forms 10g and Role in Oracle Apps
  • Fundamentals of D2K
Introduction to Forms 10g and Role in Oracle Apps, Fundamentals of D2K
22:20
  • 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
Creation of Data blocks Through wizard and Manually
35:15
  • Different types of Triggers
  • Working with Triggers and Applying to Different Controls
Different types of Triggers
38:58
  • Creation of alerts and Calling of Alerts 
  • Changing Properties at runtime and Re-using Alerts
Creation of alerts and Calling of Alerts
34:30
  • Creation of Editors, Types of Editors and Calling editors through Code
Creation of Editors, Types of Editors and Calling editors through Code
19:09
  • Creating and Using Object Groups
  • Creating and Using Object Libraries
Creating and Using Object Groups, Creating and Using Object Libraries
16:53
  • Creation of Lov through wizard and Manually
  • Working with Lov Properties
  • Creation of Record Groups Based On Query and Using Static Values
Creation of Lov through wizard and Manually
38:02
  • Creation of Master-Detail Data Blocks
Creation of Master-Detail Data Blocks
36:04
  • parameters
parameters
32:02
  • Creation of Menus and attaching menus to Forms
Creation of Menus and attaching menus to Forms
36:10
  • Working with Procedures, Functions and Packages in Forms
  • Usage of PL/SQL Libraries in Forms and Attached Libraries
Working with Procedures, Functions and Packages in Forms
34:21
  • Introduction to Reports
  • Fundamentals of Reports
  • Advantages, Features and role of Reports in D2K
Preview 23:52
  • Creation of Different types of Reports
  • Creation of Reports with different Parameters
  • User Parameters
  • System Parameters
Creation of Different types of Reports
37:33
  • Working with Formula Columns
  • Working with Summary Columns
  • Working with Place Holder Columns
Working with Formula Columns, Working with Summary Columns
38:30
  • Working with Data Links
Working with Data Links
34:09
  • Developing Reports Manually
Developing Reports Manually
33:46
  • Reports in Triggers
Reports in Triggers
17:43
  • Creation of Layout in Reports
  • Drill Down Reports
  • Calling Reports from Forms
  • Calling Reports from Reports
Creation of Layout in Reports, Drill Down Reports
31:39
+ Oracle SQL & PL/SQL Course
24 lectures 09:19:59
  • Introduction to RDBMS
  • Introduction to SQL
Preview 23:18
  • Oracle data types
  • classification of sql
Oracle data types
23:11
  • DDL and DML Commands
DDL and DML Commands
22:46
  • DDL and DML Commands Continued
DDL and DML Commands Continued
22:36
  • Integrity Constraints
Integrity Constraints
23:43
  • SQL Functions
  • Character Functions
  • Number Functions
SQL Functions, Character Functions, Number Functions
23:56
  • SQL Functions Continued
  • Date Functions 
  • Group Functions
SQL Functions Continued, Date Functions, Group Functions
19:45
  • Joins
Joins
27:33
  • Sub Queries and Clauses
Sub Queries and Clauses
26:41
  • Database Objects
Database Objects
23:00
  • Database Objects Continued
Database Objects Continued
20:14
  • DCL and TCL Commands
DCL and TCL Commands
22:44
  • Introduction to PL/SQL
Preview 21:40
  • Data Types and PL/SQL Blocks
Data Types and PLSQL Blocks
23:51
  • Looping Structures
Looping Structures
22:54
  • Looping Structure While and Nested Loops
Looping Structure While and Nested Loops
22:45
  • Looping Structure While and Nested Loops Continued
Looping Structure While and Nested Loops Continued
25:43
  • Conditional Statements 
Conditional Statements
25:18
  • Cursors
Cursors
27:57
  • Exceptions
Exceptions
25:20
  • Exceptions Continued
Exceptions Continued
19:07
  • Procedures
Procedures
24:21
  • Functions
Functions
19:39
  • Packages
Packages
21:57