Course Details

DBMS & RDBMS Training in KOlkata (Aptech Computer Education Hazra)   DATABASE Create projects for Oracle Database applications. Database project is a modern and dynamically developing technology. You have a chance to contribute to concept development. Introduction to SQL & Programming with PL/SQL Session Coverage: Chapter 1: Database Design     Database Models     Beginnings     Some Introductory Terminology     Codd's 12 Rules     Normalization     First Normal Form     Higher Order Normal Forms Chapter 2: Oracle Standard Interfaces     SQL     SQL*Plus     Oracle Architecture     Interfaces to Oracle     Command Line Interface     Viewing a Sample Table     The Graphical User Interface     The SQL Buffer     The Web-Based Interface     Describe Chapter 3: The Sample Database     The Entity Relationship Model     Entity Relationship Diagrams     The Sample Database     ER Diagram for Sample Database     Creating the Sample Data     Viewing Sample Data     Data Types of the Sample Data Chapter 4: Data Definition Language     Categories of SQL Statements     Oracle Datatypes     The CREATE Statement     The DROP Command     The ALTER Command     Integrity Constraints     Entity Integrity Constraints     Referential Integrity Constraints     Modifying Table to Use Constraints     Checking Constraints     The Data Dictionary Chapter 5: Data Manipulation Language     DML Statements     The SELECT Statement     The INSERT Statement     The DELETE Statement     The UPDATE Statement     More SQL*Plus Commands Chapter 6: Transaction Control     Transactions     Command Classification     Savepoints     The SET TRANSACTION Command     The SET TRANSACTION Command     The SET TRANSACTION Command Chapter 7: SQL Operators         Simple Selects         Comparison Operators         IN and NOT IN Operators         BETWEEN Operator         The LIKE Operator         Logical Operators         IS NULL and IS NOT NULL         ANY         ALL Chapter 8: SQL FUNCTIONS     Introduction     The DISTINCT Keyword     Aliases     Miscellaneous Functions     Mathematical Functions     String Functions     Date Functions     Conversion Functions     Pseudo Columns Chapter 9: Joining Tables     Joins     Cartesian Product     Inner Joins     Equi-Join     Table Aliases     Non-Equi Join     Non-Key Join     Reflexive Join     Natural Join     Outer Joins     Right Outer Join     Left Outer Join     Full Outer Join     Oracle-Specific Syntax for Outer Joins Chapter 10: Set Operators     Introduction     Selection Criteria     Union     Union All     Intersect     Minus Chapter 11: SQL Subqueries     Introduction     Using a Subquery with a DML Statement     Typical Subqueries     Subquery Operators     Standard vs. Correlated Subqueries     Correlated Subquery Example     Predicate Operators Chapter 12: Groups     SQL Statements     GROUP BY Clause     HAVING Clause     Order of a SELECT Statement Chapter 13: More Database Objects     More Database Objects     Relational Views     Updating a View     Create or Replace     Forcing a View     The Data Dictionary Revisited     Indexes     Synonyms Chapter 14: Reports     Report Features     Session Control     The SET Command     The COLUMN Command     The BREAK Command     The COMPUTE Command Chapter 15: Introduction     SQL vs. PL/SQL     A Few Simple Examples     Saving Procedures     A More Complete Picture     Comments     Variable Substitution     Simple Exception Handling     Advantages of PL/SQL     Assignments Chapter 16: Declarations and Data Types     Declarations     Standard Data Types     Initialization     Variable Names     Specialized Data Types - %TYPE     Specialized Data Types - %ROWTYPE     Building Your Own Data Types - Records     A Quick look at Loops     Arrays     Tables     Nested Blocks Chapter 17: Language Components     Introduction     Assignments     Decision Making Statements     Simple Loops     Loops - for     Loops - indefinite     Loops - while     Simple Loops     Nested Loops     Boolean Variables     PL/SQL Relational Operators     PL/SQL Logical Operators     The CASE Construct Chapter 18: Cursors     Introduction     Cursor Manipulation     Using the Cursor     For Loops Cursors     Cursor Attributes     Cursor Parameters     Nested Cursors     Cursor Exceptions Chapter 19: Exceptions     Errors in Programs     Run Time Exceptions     Oracle Built In Exceptions     Unnamed Exceptions     Built in Exception Functions     Creating Your Own Exceptions     Building Non Terminating Exceptions Chapter 20: Functions and Procedures     Introduction     Creating a Procedure     Example Procedure     Using Parameters     Functions     Procedures and Exceptions PROJECT WORK ORACLE: FORMS & REPORTS The curriculum contents are specially designed for those who are keen on getting themselves a career in the field of web application development.The course focuses on designing full-fledge web applications using J2EE technologies. Course Highlights:     The collaborative cloud-based learning platform that adds to your classroom learning experience     Mapped to Global Certification- Oracle forms developer certified Professional     Latest Infrastructure     Certified trainers     Structured learning Oracle Forms Training     Introducing Oracle Forms Developer and Forms Services     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     Writing Flexible Code     Sharing Objects and Code     Using WebUtil to Interact with the Client Oracle Reports Training     Basic Concepts     Advanced Concepts     Visual Index How To …?     Access Oracle Reports Documentation     Set Properties and Preferences     Perform Common Tasks     Work with the Object Navigator     Work with Reports     Work with Web Reports     Run and Dispatch a Report     Work with the Data Model     Work with the Report Layout     Work with Report Sections     Work with Parameters and the Parameter Form     Define a Template     Use PL/SQL in a Report or Template     Debug a Report     Integrate with Other Products     Administer Oracle Reports Builder PROJECT WORK