Introduction Oracle, SQL and DB2
 
1.      Course Introduction
This course provides the knowledge and skills needed to analysis, design, develop and implement a Financial Project using SEI-CMM SDLC (Software Development Life Cycle) standard. A series of extensive hands-on exercises guides you through the process of building & developing an integrated Financial Application using Oracle database. The most important point is you will gain real financial system implementation experience as well as practical hands-on experience working with Oracle, Erwin, TOAD, Unix Korn Shell and Crystal Reports by completing this project.
 
You Will Learn:
Ø      North America Leading SDLC Standard SEI ? CMM
Ø      Designing and building comprehensive Financial Oracle Application solutions
Ø      Developing a Logical / Physical data model and building the database schema
Ø      Generating and maintaining database objects such as Tables, Primary Key, Foreign Key, Unique Key, Indexes, Views, and Triggers using Erwin
Ø      Loading data into Oracle Database through ETL (Extract, transform and load) process
Ø      Managing data loading, validation, population, interface control and recall process
Ø      Developing Stored Procedures, Views, Functions and Packages, resolving critical PL/SQL problems
Ø      Delivering information with Crystal Reports
Ø      Financial business and real financial project implementation experience
 
Who Should Attend:
This course is valuable for Oracle Developer / Database Designer / ETL Developers / DBA, System Analyst, System Engineers, Consultants and others involved in building Oracle applications. A working knowledge of SQL is assumed, general database and programming experience is recommended.
2.   Course Content
 
Module 1: Project Introduction                                               1
The System function and process
?         System background
?         System objective
?         System functions
?         System processes
?         System Deliverables
System environment overview
Hardware Components
Software Components and tools
System infrastructure
System implementation technical
 
Module 2: SDLC ? Software Development Life Cycle                      1
?         SEI ? CMM introduction
?         SDLC introduction
?         Analysis ? Functional Specifications
?         Design ? System Design Specifications
?         Construction ? Coding / Testing
?         Deployment ? Implementation
?         Post Review & Enhancement
?         Implementation documentation checklist
 
Module 3: System Analysis and Process Design                                   1
Batch Process
?         ETL process ?UNIX/Database
?         Data population process - Database
?         Batch reporting process ? NT/Database
?         Housekeeping process - UNIX/Database
Online Process
?         Static Table Maintenance
?         Audit Process
?         Governance process
?         System Administration
?         Audit Trail process
 
 
Module 4: Data Modeling, Database Design and Creation                   7
Erwin tool introduction
Logical Data Modeling ? based on Business Requirement
?         Entities / Attributes
?         Relationships ?business logic
?         Key Groups
Physical Database Design
?         Database naming standard
?         Tables / Columns
?         Views / Temporary Tables
?         Tablespaces / Indexspace
?         Default values and Validation rule
?         PK/FK/UK & Indexes
?         Script Generate procedures
 
Database Creation
?         Database Parameters
?         Shell scripts
?         SQL scripts
?         Database Package
?         Schema / Roles / Users
?         Create the Application Database in Oracle
 
Module 5: Oracle PL/SQL programming                                       10
?         Introduction to PL/SQL
?         PL/SQL basics
?         Accessing the database
?         Built-in SQL Functions
?         Cursors and cursor management
?         Procedures and Functions
?         Packages
?         Creating triggers
?         Error handling
?         Testing and debugging
?         Advanced techniques using PL/SQL
 
Module 6: EOD batch process programming                          10
 
 
  • ETL concepts 
o        FTP scripts
o        SQL Loader programming
o        ETL process control
  • Data pre-population process
o        Validation check
o        Mapping
o        Converting
  • Data population
o        Governance control
o        Batch reports
  • Error handling
  • Interface recall process
 
 
 
Module 7: Table Management and Audit trail programming                   4
  • System code tables
  • Governance reference tables
  • Audit reference tables
  • System administration tables
  • Audit trail related tables
 
 
 
Module 8: Audit Management Process programming                     8
  • Audit initiation
  • Audit finding update
  • Audit cancellation
  • Audit submit
  • Audit reject
  • Audit approval
 
 
 
Module 9: Prepare Database package                                     2
 
 
?         Database Parameters
?         Shell scripts for batch
?         Schema / Roles / Users
?         Create synonym
?         Grant privileges
?         Create Stored Procedures, package, Views
?         Import initiate data
?         Script to recompile invalid objects
 
Module10: Crystal Reports - Information Delivery                                   6
Crystal Report Design
?         Introduction
?         Basic Report
?         Formatting & Styling
?         Formula Basics
?         Data Sources
?         Explore Complex Data Sources
?         Filtering, Sorting, Grouping and Summarizing.
?         Section
?         Charting
?         Advanced Formula
?         Parameters
?         Cross Tab Report
 
Application report development with Crystal Report
?         Batch reports
?         Ad-hoc reports
?         Build report from views
?         Build report from Stored Procedures and Temporary tables
 
 More info button
(Let someone contact you) 

 

Share
Last update:. Visits -- | Web site design and hosting by WECAN.ca CMS