Oracle database training

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

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

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

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

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

Oracle Database 11g SQL Fundamentals Oracle Database 11g: Using SQL to Query Your Database Using SQL in Oracle Database 11g Retrieving, Restricting and Sorting Data Using Single-Row Functions Oracle Database 11g: Conversion Functions, Group Functions, and Joins Conversion Functions and Conditional Expressions Group Functions and Joins Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation Using Subqueries and Set Operators Manipulating Data Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms Using DDL Statements to Create and Manage Tables Creating Other Schema Objects Database PL/SQL Language 11g Release What's New in PL/SQL? 1 Overview of PL/SQL 2 PL/SQL Language Fundamentals 3 PL/SQL Data Types 4 PL/SQL Control Statements 5 PL/SQL Collections and Records 6 PL/SQL Static SQL 7 PL/SQL Dynamic SQL 8 PL/SQL Subprograms 9 PL/SQL Triggers 10 PL/SQL Packages 11 PL/SQL Error Handling 12 PL/SQL Optimization and Tuning 13 PL/SQL Language Elements 14 SQL Statements for Stored PL/SQL Units Oracle Forms Developer 10g: Build Internet Applications 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 Introducing Multiple Form Applications

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

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.

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 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 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 : 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.

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 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"