Oracle 11g Development Training

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