Oracle training

Recknors Oracle Training Associate for Oracle Education Partner in Karachi | Lahore | Islamabad & Aboard, offering a wide range of training's in different modules. Recknors now offers Oracle Training & Certification, the first internationally recognized measurable certification standard for people willing to take their career to newer heights.We are providing Exclusive Oracle Training - Faculty from Top Management with highly skilled and certified domain expertise, will train and guide you with Real Time Applications. We give exclusive training materials and Support. Alhamdulillah, we are the pioneer Oracle Certification Training Institute in Karachi - Lahore - Islamabad since 2000, Each year we train hundreds of professionals as well as newcomers. We are continually developing and improving our training programs and facilities to provide a service that matches industry requirements. Oracle Courses Recknors Training Institute offering Oracle Certification courses :-Oracle R12 eBusiness Essentials for Implementers FD01- ERP Application Fundamentals FD02- Access and navigate Oracle Applications FD03- Understand key architectural components FD04- ERP System Administration Concepts FD05- Define key and descriptive Flex fields Oracle R12 Financials Management Consultant FIN01- Financials Management Setups FIN02- General Ledger FIN03- Receivables FIN04- Payables Oracle R12 Supply Chain Management Consultant SCM01- Supply chain Management Setups SCM02- Purchasing Management SCM03- Order Management SCM04- Inventory Management Oracle R12 Human Capital Management Consultant HCM01- HCM Application Setups HCM02- Fundamentals - Employee Profile Management HCM03- Manage - New Hire, Promotion, Transfers HCM04- Manage - Contracts, Qualifications HCM05- Manage Salary (Salary basis) HCM06- Hiring and Terminating Employee

Recknors now offers Oracle Training & Certification, the first internationally recognized measurable certification standard for people willing to take their career to newer heights.We are providing Exclusive Oracle Training - Faculty from Top Management with highly skilled and certified domain expertise, will train and guide you with Real Time Applications. We give exclusive training materials and Support. Alhamdulillah, we are the pioneer Oracle Certification FD01- ERP Application Fundamentals FD02- Access and navigate Oracle Applications FD03- Understand key architectural components FD04- ERP System Administration Concepts FD05- Define key and descriptive Flex fields Oracle R12 Financials Management Consultant FIN01- Financials Management Setups FIN02- General Ledger FIN03- Receivables FIN04- Payables Oracle R12 Supply Chain Management Consultant SCM01- Supply chain Management Setups SCM02- Purchasing Management SCM03- Order Management SCM04- Inventory Management Oracle R12 Human Capital Management Consultant HCM01- HCM Application Setups HCM02- Fundamentals - Employee Profile Management HCM03- Manage - New Hire, Promotion, Transfers HCM04- Manage - Contracts, Qualifications HCM05- Manage Salary (Salary basis) HCM06- Hiring and Terminating Employee Note : Weekend Batch also Available Package includes:100% Hands-On Practical Training Instructor Based Training Study Material SAP Software IDES Access 24/7 Online classes are also Available in Pakistan & Aboard Recknors (Authorized Oracle & SAP Certified Trainer)

Oracle University – Authorized Training Center would like to inform you that the Comprehensive Training and Certification Program on Oracle 11g Database is scheduled to commence from Monday, May 04, 2015. The professionals and students are invited to join the six months training program on first come first register basis. Oracle Database 11g: Training & Certification (Six Months Comprehensive Program): • Oracle Database 11g: SQL Fundamentals I (1Z0-051) • Oracle Database 11g: Program with PL/SQL (1Z0-144) • Oracle Forms: Build Internet Applications (1Z0-141) • Oracle Database 11g: Administration I (1Z0-052) • Oracle Database 11g: Administration II (1Z0-053) Fee For Both Tracks Oracle 11g Developer’s & DBA Duration: Six months (3 alternate days a week) Days: Mon., Wed., Fri. Evening Hours: 6:30.p.m. To 8:30p.m. Class Commencement : Monday, May 04, 2015 Lead Trainer : Senior Oracle Certified Trainer for SAGE region. Benefits of the Program : The participants will get Original Courseware, Exam Dumps for Online Exams, Exam Prep. Material for Certifications, and Hands On Course Who Can Attend This Training: 1. Graduates and Students of BS (Computer Science/Software Engineering), BCS, B-Com/M-Com. 2. Database Professionals 3. Fresh-graduates seeking career in Oracle Database Technologies 4. Executives of Finance Department Private and/or Public Sector Please feel free to contact OU for timely registration and details. Best regards Technology Education Academy Suite D-4, Fourth Floor, Osif Centre, Block 13-A, Gulshan-e-Iqbal, University Road, Karachi-75300 Email: info@aazam.edu.pk 0321-8202003 Technology Education Academy is the official Training, HR Development, and Testing Partner to the leading I.T. vendors of the world: 1. Authorized Prometric Test Center (APTC) 2. Microsoft I.T. Academy - Program Member (Advanced Level) 3. Cisco Networking Academy 4. Sun Microsystem (MySQL, Sun Solaris, JAVA) 5. Oracle University 6. Linux Professional Institute (LPI) - Exclusive and Comprehensive Training and Testing Partner in Pakistan 7. Red Hat Linux: Academic, Training and Testing Partner 8. Novell Suse Linux: Academic Training and Testing Partner

Oracle ADF Guru Pakistan offers you Oracle ADF training for building enterprise application using Oracle Application development framework. We provide professional training in Oracle Application Development Framework (ADF) onsite and offsite(through electronic sources) all over Pakistan. We are the only group in Pakistan which provides professional training in this technology which is trending generally in Pakistan but rapidly in Faisalabad. The reason for the rapid growth is that this technology is to replace Oracle Forms and Reports in the future and as per the internal new Oracle E business suite 2016 is to be launched in Oracle ADF. Oracle has invested $200 Billion for this platform and this is the future technology and can be used as integrating tool with all Oracle Products. For more on Oracle ADF please visit: http://www.oracle.com/technetwork/developer-tools/adf/overview/index.html We have trained many organizations in Faisalabad including IT managers from Kamal Textiles, Interloop and Sitara Textile. For more about us please visit: http://adfguru.com/ Email: support@adfguru.com Ph: 03005007360 Skype: adfguru

Oracle databse course in Rawalpindi, Islamabad, Pakistan. Oracle and Java course in Rawalpindi, Islamabad, Pakistan. Oracle and Java Certificate training course in Rawalpindi, Islamabad, Pakistan. Oracle Data Base 11g,10g,12c course in Rawalpindi, Islamabad, Pakistan. Java training course in Rawalpindi, Islamabad, Pakistan. Oracle and Java Practical Training course in rawalpindi, islamabad, Pakistan. Oracle experiance based diploma for Overseas Pakistani in Middle East, Bahrain, Iraq, Kuwait, Oman, Qatar, United Arab Emirates, UAE, Saudi Arabia, Yemen. Oracle & Java Diploma Course Content: Oracle Build Application Forms1 Build Application Forms2 Reports Java Fundamental Programming Structures in Java Classes and Objects in Java Object Design and Programming with Java Java Interfaces Java Exception Handling Java Collections API Java Input/Output API Differences between Java, C++ and/or C#

Oracle databse course in Rawalpindi, Islamabad, Pakistan. Oracle and Java course in Rawalpindi, Islamabad, Pakistan. Oracle and Java Certificate training course in Rawalpindi, Islamabad, Pakistan. Oracle Data Base 11g,10g,12c course in Rawalpindi, Islamabad, Pakistan. Java training course in Rawalpindi, Islamabad, Pakistan. Oracle and Java Practical Training course in rawalpindi, islamabad, Pakistan. Oracle experiance based diploma for Overseas Pakistani in Middle East, Bahrain, Iraq, Kuwait, Oman, Qatar, United Arab Emirates, UAE, Saudi Arabia, Yemen.Oracle & Java Diploma Course Content: Oracle Build Application Forms1 Build Application Forms2 Reports Java Fundamental Programming Structures in Java Classes and Objects in Java Object Design and Programming with Java Java Interfaces Java Exception Handling Java Collections API Java Input/Output API Differences between Java, C++ and/or C#

Oracle 11g is designed to handle the ever-increasing data needs of modern organizations. Effective management of Oracle 11g capabilities can help organizations ensure the integrity and security of data. In this hands-on course, you maximize the features of Oracle 11g to build and maintain databases, configure memory and storage for optimal performance, and manage large amounts of data and its handling. Learn DBA • Install the database. • Monitor and tune the database. • Navigate in the EM. • Manage the Oracle Instance. • Working with Database objects (DBF, Control Files, Tables, Schema, Users) • Perform backup and recovery. • Administer users and security. Regards, Syed Bilal Ali Operation officer MHSG Consulting - ERP Training Unit MHSG Consulting : www.mhsgconsulting.com Omni Academy | Oracle Partner : www.omni-academy.com M: 0312-2169325 | 0337-7222190 T: 021-366 76393 E: bilal.mhsg@gmail.com , mhsgconsulting@gmail.com MHSG Consulting | B-309, Block-L, Allama Rasheed Turrabi Road, Karachi, Pakistan facebook.com/erptrainings "When you know better you do better"

Oracle Forms Developer 10g is used to build high performance applications for the Internet. Forms Developer is a web based application development tool that helps in quickly constructing database forms and business logic with minimal of effort. Learn Forms Developer • Creating Forms Modules • Working with Data Blocks and Frames • Working with Input Items • Working with Windows and Canvases • Producing Triggers • Run-Time Messages and Alerts • Validation • Transaction Processing • Introducing Multiple Form Applications Learn Reports Developer • Introduction to Oracle Reports Developer • Designing and Running Reports • Exploring Oracle Reports Developer • Create & Enhancing Report • Managing Report Templates • Creating a Web Report • Controlling the Paper Layout: Common Properties • Creating and Using Report Parameters • Embedding a Graph in a Report • Matrix Reports Regards, Syed Bilal Ali Operation officer MHSG Consulting - ERP Training Unit MHSG Consulting : www.mhsgconsulting.com Omni Academy | Oracle Partner : www.omni-academy.com M: 0312-2169325 | 0337-7222190 T: 021-366 76393 E: bilal.mhsg@gmail.com , mhsgconsulting@gmail.com MHSG Consulting | B-309, Block-L, Allama Rasheed Turrabi Road, Karachi, Pakistan facebook.com/erptrainings "When you know better you do better"

Oracle 11g is designed to handle the ever-increasing data needs of modern organizations. Effective management of Oracle 11g capabilities can help organizations ensure the integrity and security of data. In this hands-on course, you maximize the features of Oracle 11g to build and maintain databases, configure memory and storage for optimal performance, and manage large amounts of data and its handling. Learn DBA • Install the database. • Monitor and tune the database. • Navigate in the EM. • Manage the Oracle Instance. • Working with Database objects (DBF, Control Files, Tables, Schema, Users) • Perform backup and recovery. • Administer users and security. Regards, Syed Bilal Ali Operation officer MHSG Consulting - ERP Training Unit MHSG Consulting | B-309, Block-L, Allama Rasheed Turrabi Road, Karachi, Pakistan facebook.com/erptrainings "When you know better you do better"

Oracle Forms Developer 10g is used to build high performance applications for the Internet. Forms Developer is a web based application development tool that helps in quickly constructing database forms and business logic with minimal of effort. Learn Forms Developer • Creating Forms Modules • Working with Data Blocks and Frames • Working with Input Items • Working with Windows and Canvases • Producing Triggers • Run-Time Messages and Alerts • Validation • Transaction Processing • Introducing Multiple Form Applications Learn Reports Developer • Introduction to Oracle Reports Developer • Designing and Running Reports • Exploring Oracle Reports Developer • Create & Enhancing Report • Managing Report Templates • Creating a Web Report • Controlling the Paper Layout: Common Properties • Creating and Using Report Parameters • Embedding a Graph in a Report • Matrix Reports Regards, Syed Bilal Ali Operation officer MHSG Consulting - ERP Training Unit MHSG Consulting | B-309, Block-L, Allama Rasheed Turrabi Road, Karachi, Pakistan facebook.com/erptrainings "When you know better you do better"

Training Instructor and Consultant: Mudassar Malik Contact +923014816616 We are offering Training and Consultancy Services FOR ENGINEERS 1. Oracle Primavera P6 R 16.1 2. MS Project 2016 USED FOR PROJECT PLANNING AND CONTROL BEST FOR JOB HUNTING AND SKILL DEVELOPMENT Online class schedule is available Special Points for Project planning and Control I. Project Planning II. Project Scheduling III. Project Cost Estimation IV. Project Approval – Baseline Setup V. Project Execution Kick off Meeting VI. Collection Of Project Progress VII. Recording of Project Progress VIII. Monitoring for Deviation IX. Control Application on Deviation X. Control Application on Deviation Major Reports 1. Logic Report, Critical Path, By Project 2. Classic Schedule Report - Sort by ES, TF 3. Activity Relationships / Dependencies 4. Project Float, Free Float, Total Float 5. Schedule Report Comparison to Target 6. Activity Status Report 7. Budgeted Cost By Cost Account 8. Resource Units Control Report 9. Resource Cost Control Report 10. Resource Units Loading, Monthly, Organized by WBS 11. Resource Cost Loading, Monthly, Organized by WBS 12. Resource Rates and Availability 13. Resource Curve 14. Resource Histogram 15. Man-hour’s Reports 16. Labor Units Reports 17. Non Labor Units Reports 18. Material Units (Individual) Reports 19. Labor Cost Reports 20. Non Labor Cost Reports 21. Material Cost Reports (Individual Resource) 22. Expenses (Miscellaneous, Sub Contract, Overhead Cost) Reports 23. Cash flow Reports 24. Planned & Actual Comparison (Schedule & Cost 25. Resource Leveling 26. Man-hours Loading Tabular Reports 27. Man-hours (Histogram & S-Curve) Reports 28. Materials Quantity Loading Tabular Reports 29. Materials Quantity (Histogram & S-Curve) Reports 30. Material Cost (Histogram and S-Curve) Reports 31. Cost Loading Reports by Cost Accounts 32. Formatting (Page setup, Import & Export, Setting of Bar’s Table Font & Color’s) Training Instructor and Consultant: Mudassar Malik Contact +923014816616

Oracle Primavera P6 Professional Training In Pakistan and Abroad I provide Pour Practical Work basic level and Advance Level contact on Khurram Shahzad +92-301-7055512 +92-335-7055512 icmt_primavera@outlook.com from Sep 2nd

Oracle Primavera P6 Course Contents 1-Project Planning Step A- Defining of WBS Codes (Work Breakdown Structure) Step B-Defining of Project Activities Step C- Entering of Required Estimated Duration for Completion of each Activity Step D-Assignment of milestones Step E-Assignment of Constraint 2-Project Scheduling Step A- Linking of Project Activities according to their relationship (through different procedure) Relationship Types i) Start to Start ii) Start to Finish iii) Finish to Start IV) Finish to Finish Step B- Schedule Execution (F9 Function Key) Step C-Modification and Deletion of Relationships Step D- Analysis of Gantt Chart & Activity Network (PERT) Step E- Understanding of Forward Pass and Backward Pass Step F- Analysis of Critical & Non Critical Path Step G- Analysis of Total Float, Free Float and Project Float 3-Cost Estimation (Budgeting) Step A –Defining of Roles Step B- Introduction to Enterprise Resource window Step C- Defining of Resources with Rates i) Manpower ii) Material iii) Machinery Step C- Assign Resources to Project Activities Step D- Assign Expenses to Project Activities Step E- Cost Accounts i) Defining of Cost Accounts ii) Assignment of Cost Accounts 4-Activity Codes Step A-Introduction to Activity Codes Step B- Defining of activity codes Step C- Assignment of Activity codes Step D- Activation of Activity Codes 5- Filters Step A- Introduction to Filters Step B-Defining of Filters by i) Date wise ii) WBS wise iii) Activity Codes wise 6- Global Change Step A- Introduction to Global Change Step B- How to Define Global Change i) Defining of Global Change by Increase Cost ii) Defining of Global Change by Decrease Cost iii) Defining of Global Change by Increase Duration iv) Defining of Global Change by Decrease Duration v) Defining of Global Change by Resource Replacement 7-Formatting Step A- Defining of new layout for baseline Project Step B- Defining of new columns for activities and resources Step C- Defining of new bar Step D-Table Font and Row Step E- How to show bar chart legend Step F- Timescale 8-Project Schedule & Budget Approval Step A- Project statistical Data Presentation for Project Schedule & Budget Approval Step B- Modification in Project Schedule and Budget according to Management Instructions 9-Baseline Setting Step A- Introduction to Baseline Step B-Maintain Baseline after Project Schedule and Budget Approval Step C- Assign Baseline to Project (Primary Baseline & Secondary Baseline) Step D- Restore Baseline 10- Project Execution and Recording of Progress Step A- Project Progress Reports Routing Step Step B- Update Activity without any delay Step C- Update Activity with delay Step D- Update Activity Physical Step E- Update Resources without any variance Step F- Update Resources with variance Step G- Update Expense without variance Step H- Update Expense with variance Step I- Rescheduling Project Schedule

Synergy Education Services (SES), a part of Synergy Computers (Pvt) Ltd., offers Oracle Financials training. Course Module Details (Modules covered during the training) 1. R12.x Oracle E-Business Suite Essentials for Implementers 2. R12 Oracle General Ledger Management Fundamentals 3. R12 Oracle Payables Management Fundamentals 4. R12 Oracle Receivables Management Fundamentals 5. R12 Oracle Cash Management Fundamentals Hands-on Course Fee: PKR 36,400 We also offer Oracle SCM, HCM and AppsDBA trainings. Synergy Computers (Pvt) Ltd. is today one of the leading technology company in the country providing best off the shelf solutions for Technology Infrastructures and Education Services.

Free Seminar on Feb 10, 2020 at 06:00 PM It is one of the best Oracle Database Development / Oracle Database Administration courses in Lahore, Rawalpindi & Islamabad. It covers database development and administration using Oracle 12c. It includes understanding database concept; creating databases using Oracle 12c ; querying and manipulating data using PL / SQL and taking advantage of Oracle’s Multitenant-Architecture for cloud computing. The course not only teaches the skills required to Oracle DBA for performing his routine operations but also teaches him the skills required to become a top-performing Oracle DBA. It includes deployment of backup and recovery and its cloud computing strategies. Brief Contents What is Database, Type of Databases, Data Types Difference between Liner & Non Liner Databases What is No SQL Database, What is ATL32-U Database, Object Oriented Database How to Setup Virtual Machine, How to Install Database on Windows Environment How to Install Database on Linux Environment, How to Test Database after installation Trouble Shooting of Database During Installation Introduction of Data Structure, Introduction of Table Structure Select Statement, Database Keys, Distinct Statement, Joining of Tables Null Values, NVL Values, Table Alias Identification of Data, Identification of Primary & Foreign Key Arithmetic Expressions, Add Running Total, Add Union Intersections Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas Introduction of Sub Query, Return Single Row from Sub Query, Return Multiple Row from Sub Query, Where Claus in Sub Query , Inner Joins, Outer Joins, Conversion of Data, Conversion of Data Num To Char, Conversion of Dates What is Aggregation Rule, What is Group by & Having Functions Applying Aggregation Rules, Applying Group by Functions, Apply Having Function Use Multiple Tables in Group By Function, Conversion of Data, Conversion of Data Num To Char, Sorting of Data, Order By of Data Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns How to Define Primary Key, How to Define Foreign Key What is Star Schema, How to Build Star Schema, How to Drop Table, Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences How to Build Auto Incremental Columns, How to Build Sequence in Table Columns What is Loop Functionality, How to Insert Data in Tables through Loop Functionality How to Update Data in Tables Through Loop, How to Delete Data from Tables How to Clone Tables, How to Fetch Query from Multiple Databases Tables How to Display all Tables in User, How to Check Table Space, How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions Type of Functions, How to Build Function in Database, How to Run Function in Database How to use Data Types in Functions, Method to Create Function, Method to Alter Functions Purpose of Functions, Method to Call Function in Database Query How to Optimize Query Through Functions Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views Method to Create Data Views, Method to Alter Data Views, What is Procedure, Why we use Procedures, How to Build Procedure Insert, Update & Delete Data Through Procedure Alteration of Procedure, Drop Procedures What is Package, How to Build Package, Purpose to Build Package How to Send E-Mail Through Database Package List of Major Architecture Components of Database, Explain the Memory Structures Describe the Background Process, Correlate the Logical and Physical Storage Structures What are Database Management Tools, How to Use Database Management Tools How to Install Database Management Tools, Start & Shut Down Database Services Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services View Database Logs, What is Network Environment, How to Configure Network Environment What is TNS Listener, How to Configure TNS Listener, Trouble Shooting of TNS Listener Services How to Configure Network Side Configurations What is Table Space, What is Table Partition, How to Manage Table Spaces What is Undo Data, How to Apply Patches on Database, Difference Between Undo & Redo Data, Space Management of Databases Managing Database Roles, Changing Database Privilege Database Compressions, Describing the Locking Mode, Unlocking of Data Release of Expired Users, Database Backup Description, How to Backup Database How to Restore Database Through Dumps, Backup Database without shutting it down Generate Database Alerts, Small Briefing of Database Auditing What is Database Patch, How to Download & Apply Database Patches What is Database Scheduler, Create Schedule of Database Jobs, Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database Move Database From One Server to Another Server Introduction of RMAN, How to Use RMAN from SQL Plus, How to Connect Database with RMAN, Use SQL in RMAN What is Recovery Catalog, How to Configure Recovery Catalog in RMAN How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog What is Data backup Through RMAN, Create Backup Plan Strategy using RMAN Database Backup Configuring Fast Recovery Data, How to Use Incremental Backup Manage Backups, Backup Database on No Archive & Archive Mode How to Backup Non-Database Files, Secure Backup Cloning of Database Using RMAN, Duplication Database using RMAN, CDB & PDB Database Management, What is Flash Recovery of Database Use Flashback Query, Use Flashback Table Operations, Recover Table Data From Flashback Recovery, Recover Columns Data from Flashback Recovery Restore Table from Recycle Bin, Manage Pluggable & Container Database Manage Security of Database Through RMAN Database Audit Concepts, Database Security Auditing Generate Database Documentation From Database Tools Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces Audit of Unused Memory , Query Optimization & runtime Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Graduates & Students of Computer Science, Software Engineering etc. Course Project Participants of the course will develop a commercial level database during the course Oracle Database 12c. They will also demonstrate their proficiency in common DBA tasks by performing them under the supervision of the course trainers. Certificate On successful completion of the course participants will be awarded participation certificate from EVS. Exam-1: Oracle Database SQL: 1Z0-071 Exam-2: Oracle Database 12c Administration: 1Z0-062 Exam-3: Oracle Database 12c: Advanced Administration: 1Z0-063 Duration & Frequency Total Duration of the course is 3 months (12 Weeks, with 3 classes of 1.5 hours in a week).

Free Seminar on Feb 10, 2020 at 06:00 PM It is one of the best Oracle Database Development / Oracle Database Administration courses in Lahore, Rawalpindi & Islamabad. It covers database development and administration using Oracle 12c. It includes understanding database concept; creating databases using Oracle 12c; querying and manipulating data using PL / SQL and taking advantage of Oracle’s Multitenant-Architecture for cloud computing. The course not only teaches the skills required to Oracle DBA for performing his routine operations but also teaches him the skills required to become a top-performing Oracle DBA. It includes deployment of backup and recovery and its cloud computing strategies. Brief Contents What is Database, Type of Databases, Data Types Difference between Liner & Non Liner Databases What is No SQL Database, What is ATL32-U Database, Object Oriented Database How to Setup Virtual Machine, How to Install Database on Windows Environment How to Install Database on Linux Environment, How to Test Database after installation Trouble Shooting of Database During Installation Introduction of Data Structure, Introduction of Table Structure Select Statement, Database Keys, Distinct Statement, Joining of Tables Null Values, NVL Values, Table Alias Identification of Data, Identification of Primary & Foreign Key Arithmetic Expressions, Add Running Total, Add Union Intersections Null If Function, Data Sorting, To Date & Automatic Date Calculations Formulas Introduction of Sub Query, Return Single Row from Sub Query, Return Multiple Row from Sub Query, Where Claus in Sub Query, Inner Joins, Outer Joins, Conversion of Data, Conversion of Data Num To Char, Conversion of Dates What is Aggregation Rule, What is Group by & Having Functions Applying Aggregation Rules, Applying Group by Functions, Apply Having Function Use Multiple Tables in Group By Function, Conversion of Data, Conversion of Data Num To Char, Sorting of Data, Order By of Data Introduction of Tables, Creation of Tables, Update Table Columns, Drop Table Columns How to Define Primary Key, How to Define Foreign Key What is Star Schema, How to Build Star Schema, How to Drop Table, Update of Data in Tables, Insert of Data in Tables, Introduction of Sequences How to Build Auto Incremental Columns, How to Build Sequence in Table Columns What is Loop Functionality, How to Insert Data in Tables through Loop Functionality How to Update Data in Tables Through Loop, How to Delete Data from Tables How to Clone Tables, How to Fetch Query from Multiple Databases Tables How to Display all Tables in User, How to Check Table Space, How Count Rows of Tables, Rownum Function in Tables, Introduction of Functions Type of Functions, How to Build Function in Database, How to Run Function in Database How to use Data Types in Functions, Method to Create Function, Method to Alter Functions Purpose of Functions, Method to Call Function in Database Query How to Optimize Query Through Functions Introduction of Data Views, De-Normalize Table Data in Views, Hierarchy of Views Method to Create Data Views, Method to Alter Data Views, What is Procedure, Why we use Procedures, How to Build Procedure Insert, Update & Delete Data Through Procedure Alteration of Procedure, Drop Procedures What is Package, How to Build Package, Purpose to Build Package How to Send E-Mail Through Database Package List of Major Architecture Components of Database, Explain the Memory Structures Describe the Background Process, Correlate the Logical and Physical Storage Structures What are Database Management Tools, How to Use Database Management Tools How to Install Database Management Tools, Start & Shut Down Database Services Difference Between Immediate Start/Shutdown & Immediate Start/Shutdown Services View Database Logs, What is Network Environment, How to Configure Network Environment What is TNS Listener, How to Configure TNS Listener, Trouble Shooting of TNS Listener Services How to Configure Network Side Configurations What is Table Space, What is Table Partition, How to Manage Table Spaces What is Undo Data, How to Apply Patches on Database, Difference Between Undo & Redo Data, Space Management of Databases Managing Database Roles, Changing Database Privilege Database Compressions, Describing the Locking Mode, Unlocking of Data Release of Expired Users, Database Backup Description, How to Backup Database How to Restore Database Through Dumps, Backup Database without shutting it down Generate Database Alerts, Small Briefing of Database Auditing What is Database Patch, How to Download & Apply Database Patches What is Database Scheduler, Create Schedule of Database Jobs, Use Task Manager for Database Scheduler, Cloning of Database, Duplication of Database Move Database From One Server to Another Server Introduction of RMAN, How to Use RMAN from SQL Plus, How to Connect Database with RMAN, Use SQL in RMAN What is Recovery Catalog, How to Configure Recovery Catalog in RMAN How to Generate Scripts for Recovery Catalog in RMAN, Export & Import Recovery Catalog What is Data backup Through RMAN, Create Backup Plan Strategy using RMAN Database Backup Configuring Fast Recovery Data, How to Use Incremental Backup Manage Backups, Backup Database on No Archive & Archive Mode How to Backup Non-Database Files, Secure Backup Cloning of Database Using RMAN, Duplication Database using RMAN, CDB & PDB Database Management, What is Flash Recovery of Database Use Flashback Query, Use Flashback Table Operations, Recover Table Data From Flashback Recovery, Recover Columns Data from Flashback Recovery Restore Table from Recycle Bin, Manage Pluggable & Container Database Manage Security of Database Through RMAN Database Audit Concepts, Database Security Auditing Generate Database Documentation From Database Tools Auditing of User Privileges, Checking of Login Audits, Checking of Unused Spaces Audit of Unused Memory, Query Optimization & runtime Training Methodology Lectures & Demos by industry experts Project Driven Hands-On approach Focus on latest tools, technologies & industry practices Projects, assignments & quizzes for participant’s evaluation Audience Programmers, Software Developer, Web Developers Software Analysts, Software Designers and Software Architects Graduates & Students of Computer Science, Software Engineering etc. Course Project Participants of the course will develop a commercial level database during the course Oracle Database 12c. They will also demonstrate their proficiency in common DBA tasks by performing them under the supervision of the course trainers. Certificate On successful completion of the course participants will be awarded participation certificate from EVS. Exam-1: Oracle Database SQL: 1Z0-071 Exam-2: Oracle Database 12c Administration: 1Z0-062 Exam-3: Oracle Database 12c: Advanced Administration: 1Z0-063 Duration & Frequency Total Duration of the course is 3 months (12 Weeks, with 3 classes of 1.5 hours in a week). Date Feb 12th

building#739,f block siddique chowk,near city super mart,satellite town rawalpindi Access Comprehensive Oracle Database Training – Explore New Features and Develop Advanced Oracle Database Administration Skills. Database Security. Enterprise Manager. High Availability, including RAC, ASM, Clusterware, and Data Guard. Oracle Database Appliance (ODA) Exadata Database Machine. Views: 1

Microsoft Project 2007/10/13/16/19 Oracle Primavera P6 Latest R16.2 Enterprise System Basic and Advanced Level Training (Corporate & Individual classes) Sunday Open. 01-Project management Tools: a)-Bar Chart b)-PERT c)-CPM 02-Project Planning 03-Project Scheduling 04-Project Cost Estimation-Resource Management 05-WBS Operation (Presentation Development) 06-Project Approval (Schedule & Budget) 07-Project Execution Process 08-Collection and Recording of Project Progress 09-Monitoring and Controlling of Deviations 10-Special Project Reports (Printable) Schedule Tabular Reports Resource Tabular Reports Project Cost Tabular Reports Graphical Reports & more Final Check List as per Employer’s Demand 01-Bar Charts. 02-Use of Logic Diagram. 03-S-Curve (Resource Curve) Development. 04-Milestones Activities- Start Milestone and Finish Milestone. 05-Critical and Non Critical Activities, Critical and Non Critical Path. 06-Critical Path Development- Practical Application of CPM Technology. 07-Resource, and Equipment Loading. 08-Resource Leveling. 09-Productivity / Progress Curves Development. 10-Schedule Forecasting / Look-Ahead Schedule. 11-Global Changes of Duration, Quantity and Cost. 12-Baseline Plan (Target Project) Development. 13-WBS (Work Breakdown Structure) Development and Application. 14-Monitoring Project Performance through Earned Value Method. 15-Histograms and Productivity Report. 16-Reports Analysis. 17-Recording of Project Progress and Monitoring Actual Time and Cost Applied. 18-Application of Cost Control Techniques for UN-favorable Variance Control. Completion of Syllabus is Guaranteed. Contact No.: Engr SAMAR ABBAS 0301-8359071 Skype I’D: Samar50546 Address: Lahore, Islamabad, Multan, Gujarat, Faisalabad and Other Cities and other Countries Individual bases and Groups. Oracle Primavera-P6 R21.12 Practical Training (0301-8359071) from Sep 10th

ASIPT Systems®: Offering a Special Discounts for 2015 on Oracle ERP, SAP ERP, MCSE, SPSS, MS Project, Oracle Primavera Trainings. Limited time Offer, Hurry-up to get registration. => Achieve Your Desired Goals => Exclusive Tips & Techniques to become an expert => Unique Practical Material ================================================= 10-A Wahdat Road near Butt Sweet, Lahore, Pakistan. +92-42-35912800 | +92-345-0786662

Rudra IT Solutions is one of the Promote leading IT Services and Oracle Global Trade Management Online Training solutions along with IT Online training conservatory, with the latest Industry offering technology from Jan 29th

Rudra IT Solutions is one of the Promote leading IT Services and Oracle Apps ASCP Online Training along with IT Online training conservatory, with the latest Industry offering technology Our Location - #Hyderabad #India #USA #UK #Australia #NewZealand #UAE #canada #banglore #chennai #SaudiArabia # Pakistan #Singapore #Kuwait #Bangalore #Mumbai Follow this link to view more courses details - https://www.rudraitsolutions.com/oracle-process-manufactur…/ rudraitsol@gmail.com, info@rudraitsolutions.com Call US:- +91-9652574678, 281-742-3556 from Feb 27th

SAP ERP, Oracle, MS Project, PMP,SPSS, Adv. Excel, Peachtree/Tally/QuickBooks, IELTS, MS Office 2013, try to Register before 10 August 2015. Contact to ASIPT: 042-35912800, 0345- 0786662, Skype: asipt.training, info@asipt.net

☎️ Learn From Home ???? ✅ Best Training for Engineer's ???? ????Live Online Training ???? Oracle Primavera P6 R19.12 ???? Microsoft Project Professional Mudassar Malik Trainer and Consultant Whatsapp#????: 0092-301-481-6616 from Sep 1st

Eligibility Criteria: • ACCA Part Qualified or Finalist, M.com • One year experience will be preferred. • Excellent communication, Interpersonal and presentation skills (Urdu & English) • Proficient at Oracle R12 expert user • Ability to manage multiple tasks with challenging timelines • Good in accounts knowledge and record keeping • Candidate should be self starter with excellent analytical skills • Good team player • Proficient at Microsoft Office specially on Ms Excel Salary & Other Perks: • Permanent Position with Long Weekend (Saturday/Sundays are off) • Annual/Medical Leaves • Exceptional Learning & Growth Opportunities

ASIPT Systems: New Batches of Oracle Financial R12 EBS and Computerized Accounting on 31-08-2015 at 11:30AM and 07:45PM = contact to register 042-35912800, 03450786662:Email:info@asipt.net

We are offering MS Project 2007 and Primavera P6 Practical Training (Corporate & Individual?Classes) After Completion of Practical Training on Primavera P6 & MS Project 2007 at ICBT, the Participants will become competent to Work in the following Special Industrial Demanded Areas Special 10 Points for Project Planning and Control 01-Project Planning 02-Project Scheduling 03-Project Cost Estimation 04-Project Approval-Baseline Setup 05-Project Execution-Kick offMeeting 06-Collection of Project Progress 07-Recording of Project Progress 08-Monitoring for Deviations 09-Control Applications onDeviations 10-Project Closing and Review Institute of?Computer & Business Techniques Siddique Trade Centre Gulberg Lahore. 0300-4068316

Synergy Education Services (SES), a company of Synergy Computers (Pvt.) Ltd., offers Java (Module 1: Fundamentals + Module 2: Advance Programming with Java) Training that prepares you for OCJP certification. Fee: PKR 21,930 Synergy Computers (Pvt) Ltd. is today one of the leading technology company in the country providing best off the shelf solutions for Technology Infrastructures and Education Services.

Special Points for Project planning and Control I. Project Planning II. Project Scheduling III. Project Cost Estimation IV. Project Approval – Baseline Setup V. Project Execution Kick off Meeting VI. Collection Of Project Progress VII. Recording of Project Progress VIII. Monitoring for Deviation IX. Control Application on Deviation X. Control Application on Deviation Training instructor and Consultant : Mudassar Malik

Accountech SAP Training in Lahore New Batches Starting Soon! Learn SAP Business One & secure a lucrative job in any of the multinationals in Pakistan, Dubai and Middle East. Trainer Expert Qualified Chartered Accountant Contents Covered Financials Sale & Receivables Purchase & Payables Inventory Production Business Partners Administration Banking Reporting MRP HR Our Most Popular Courses: Sap Training in Lahore Advance Excel Training in Lahore Quick Books Training in Lahore PeachTree Training in Lahore Tally ERP Training in Lahore Xero Accounting Training in Lahore Sage 50 training in Lahore Myob Training in Lahore Business Modeling Training in Lahore Financial Modeling Training in Lahore Oracle training in Lahore MS Office Training in Lahore Note: Special Discounts offer for Students of B.com & M.com, so get registered now to avail this golden opportunity. Call us or visit our office to get discounted registered! Contact us now for a free consultation or visit our office. Facebook: www.facebook.com/accountechts Blog: www.accountechpk.blogspot.com website: www.accountech.com.pk Mobile: 0331-8433334 Address: A-1 Aiback Block New Garden Town Near Barkat Market Lahore

Accountech is offering practical course of WordPress web development in which all the practical elements will be covered from scratch no previous experience is required for this course matric students are highly encouraged to join this practical course to secure your better future in the field of Web development Those who are interested must come and contact us…. Our Most Popular Courses: Sap Training in Lahore Advance Excel Training in Lahore Quick Books Training in Lahore PeachTree Training in Lahore Tally ERP Training in Lahore Xero Accounting Training in Lahore Sage 50 training in Lahore Myob Training in Lahore Business Modeling Training in Lahore Financial Modeling Training in Lahore Oracle training in Lahore MS Office Training in Lahore Note: Special Discounts offer for Students of B.com & M.com, so get registered now to avail this golden opportunity. Call us or visit our office to get discounted registered! Contact us now for a free consultation or visit our office. Facebook: www.facebook.com/accountechts Blog: www.accountechpk.blogspot.com website: www.accountech.com.pk Mobile: 0331-8433334 Address: A-1 Aiback Block New Garden Town Near Barkat Market Lahore