Course details
'
DUCAT imparts training in a way that is more practical and efficient. Anyone who wants to learn Oracle 11g development needs to look no further than DUCAT. It gives training so that after the training ORACLE 11G DEVELOPMENT becomes a part of you. Oracle 11g development starts where Oracle Parallel Server ends. It allows someone to approach the same database simultaneously. It ensures full tolerance, load balancing and of course performance. The heart of this technology is a… + Read More
Course details
'
DUCAT imparts training in a way that is more practical and efficient. Anyone who wants to learn Oracle 11g development needs to look no further than DUCAT. It gives training so that after the training ORACLE 11G DEVELOPMENT becomes a part of you. Oracle 11g development starts where Oracle Parallel Server ends. It allows someone to approach the same database simultaneously. It ensures full tolerance, load balancing and of course performance. The heart of this technology is a concept of shared disk subsystem. In case of system failure it allows recovery of that node from other nodes. DUCAT imparts training not only by lectures or lessons but by giving real access to Oracle 11g development. One can understand the advantage and disadvantage of this technology only when they feel it which happens during the training at DUCAT. Students learn how to install the process and to run it efficiently. The training teaches all the features of Oracle 11g development in depth. DUCAT faculties are the best in this field of technology. They themselves are experts and they make their students also experts. They teach so that their students shine in their field and make themselves proud.
- INTRODUCTION TO ORACLE DATABASE
- RETRIEVE DATA USING THE SQL SELECT STATEMENT
- LEARN TO RESTRICT AND SORT DATA
- USAGE OF SINGLE-ROW FUNCTIONS TO CUSTOMIZE OUTPUT
- INVOKE CONVERSION FUNCTIONS AND CONDITIONAL EXPRESSIONS
- AGGREGATE DATA USING THE GROUP FUNCTIONS
- DISPLAY DATA FROM MULTIPLE TABLES USING JOINS
- USE SUB-QUERIES TO SOLVE QUERIES
- THE SET OPERATORS
- DATA MANIPULATION STATEMENTS
- USE OF DDL STATEMENTS TO CREATE AND MANAGE TABLES
- OTHER SCHEMA OBJECTS
- CONTROL USER ACCESS
- MANAGEMENT OF SCHEMA OBJECTS
- MANAGE OBJECTS WITH DATA DICTIONARY VIEWS
- MANIPULATE LARGE DATA SETS
- DATA MANAGEMENT IN DIFFERENT TIME ZONES
- RETRIEVE DATA USING SUB-QUERIES
- REGULAR EXPRESSION SUPPORT
- ORACLE DATABASE PROGRAM WITH PL/SQL
- DECLARE PL/SQL IDENTIFIERS
- WRITE EXECUTABLE STATEMENTS
- INTERACTION WITH THE ORACLE SERVER
- CONTROL STRUCTURES
- COMPOSITE DATA TYPES
- EXPLICIT CURSORS
- EXCEPTION HANDLING
- STORED PROCEDURES
- STORED FUNCTIONS AND DEBUGGING SUBPROGRAMS
- PACKAGES
- DEPLOYING PACKAGES
- IMPLEMENT ORACLE-SUPPLIED PACKAGES IN APPLICATION DEVELOPMENT
- DYNAMIC SQL
- DESIGN CONSIDERATIONS FOR PL/SQL CODE
- TRIGGERS
- CREATING COMPOUND, DDL, AND EVENT DATABASE TRIGGERS
- PL/SQL COMPILER
- MANAGE DEPENDENCIES
- ORACLE FUSION MIDDLEWARE 11G: BUILD APPLICATIONS WITH ORACLE FORMS
- 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 11G: BUILD REPORTS
- 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
'
Updated on 12 June, 2016 - Read LessAbout Ducat
Fifteen years ago, we had a thought- to create a benchmark IT institute for the country and the world. Today as Asia, and in particular India Information Technology supremacy, we at the DUCAT are proud to contribute our part as the architects of creating IT Professionals for the world.
What began as an idea is now an acknowledged institution for quality learning. This is an outcome of the various facets that give DUCAT its characteristic value, the faculty, enterprising students, academic affiliations, facilities and industry partnerships.
While the world accepts DUCAT`s status, we silently reinforce our commitment of being the cornerstone for research-oriented learning. Combining that with a strong focus on becoming one of the world`s top ranked IT Institute, and we`ve defined our role and our challenge for the years ahead.
See all Ducat courses