Oracle certified

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

Oracle Database 11g: Performance Tuning DBA Release 2 Summary of Program This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You’ll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them. Key Learning: Describe Oracle tuning methodology. Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues. Use database advisors to correct performance problems proactively. Identify problem SQL statements & tune SQL performance problems. Monitor the Instance Performance using Enterprise Manager. Tune instance components, primarily using Instance parameters. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling smooth and rapid consolidation within your Datacenter. WHY CHOOSE OMNI ACADEMY 100% Student Satisfaction Get Oracle Certified Internship opportunities for Top students Duration: 10 Days – Approx (SAT or SUN 2HRS Classes) For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: PTCL: 3498-OMNI (6664) | M: 03377222191 | 0312216 9325 I03122169321 E: [email protected] | www.omni-academy.com IFb: www.facebook.com/Omniacademy

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

This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam. #Oracle 11G #Oracle certified associate #Oracle database #Oracle university #Administration Workshop Views: 3

Type Computer Oracle EBS R12- ERP Supplychain - SCM Training SDC Approved | Affiliated ERP Training Program Internships and job referrals available for top performing students. MHSG Consulting is offering an Oracle EBS R12- Supplychain Management – SCM Training program under Oracle Certified and experienced faculty, Forclassregistration pls. call . New batch starting 10 AUG, special discounts for group of four students. Oracle Supplychain Modules Supplychain Fundamentals Supplychain Application Setups Oracle Purchasing Oracle Inventory Management Using ERP Supplychain Reports Lab Work / Case Study Program Coordinator: For details pls. contact M: L: 021-, “Learn better to do better” Campus MHSG Consulting, D-67, Block-H, Allama Rasheed Turrabi Rd, N. Nazimabad, NEAR MAC Coaching - Karachi

Type Computer Oracle EBS R12- ERP Supplychain - SCM Training SDC Approved | Affiliated ERP Training Program Internships and job referrals available for top performing students. MHSG Consulting is offering an Oracle EBS R12- Supplychain Management – SCM Training program under Oracle Certified and experienced faculty, Forclassregistration pls. call . New batch starting 17 AUG, special discounts for group of four students. Oracle Supplychain Modules Supplychain Fundamentals Supplychain Application Setups Oracle Purchasing Oracle Inventory Management Using ERP Supplychain Reports Lab Work / Case Study Program Coordinator: For details pls. contact M: L: 021-, “Learn better to do better”

Type Computer Oracle EBS R12- ERP Human Capital Management - HR Training SDC Approved | Affiliated ERP Training Program Internships and job referrals available for top performing students. MHSG Consulting is offering an Oracle EBS R12- Human Capital Management – HCM Training program under Oracle Certified and Experienced faculty, For class registration pls. call . New batch starting 10 AUG, special discounts for group of four students. HCM Fundamentals HCM Application Setups Manage - New Hire, Promotion, Transfers Manage - Contracts, Qualifications Manage Salary (Salary basis) Hiring and Terminating Employee Using EPR Reports Lab Work / Case Study Program Coordinator: For details pls. contact M: L: 021-, “Learn better to do better” Campus MHSG Consulting, Block-H, Allama Rasheed Turrabi Rd, N. Nazimabad, NEAR MAC Coaching - Karachi

Type Avail 40 Discount till 24 AUG Oracle EBS R12- ERP Human Capital Management - HRM SDC Certificate Training SDC Approved | Affiliated ERP Training Program Internships and job referrals available for top performing students. MHSG Consulting is offering an Oracle EBS R12- Human Capital Management – HCM Training program under Oracle Certified and Experienced faculty, For class registration pls. call . New batch starting 24 AUG, special discounts for group of four students. HCM Fundamentals HCM Application Setups Manage - New Hire, Promotion, Transfers Manage - Contracts, Qualifications Manage Salary (Salary basis) Hiring and Terminating Employee Using EPR Reports Lab Work / Case Study Program Coordinator: For details pls. contact M: L: 021-, “Learn better to do better”

Type Computer Oracle EBS R12- ERP Human Capital Management - HRM SDC Certificate Training SDC Approved | Affiliated ERP Training Program Internships and job referrals available for top performing students. MHSG Consulting is offering an Oracle EBS R12- Human Capital Management – HCM Training program under Oracle Certified and Experienced faculty, For class registration pls. call . New batch starting 24 AUG, special discounts for group of four students. HCM Fundamentals HCM Application Setups Manage - New Hire, Promotion, Transfers Manage - Contracts, Qualifications Manage Salary (Salary basis) Hiring and Terminating Employee Using EPR Reports Lab Work / Case Study Program Coordinator: For details pls. contact M: L: 021-, “Learn better to do better”

Oracle ERP E-Business Suite R12 Supply Chain Management Cloud ERP Supply chain Management R12 Training SDC Certified Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance. Why Oracle ERP E-Business Suite? With hundreds of cross-industry capabilities spanning enterprise resource planning, customer relationship management, and supply chain planning, Oracle E-Business Suite applications help customers manage the complexities of global business environments no matter if the organization is small, medium, or large in size. As part of Oracle’s Applications Unlimited strategy, Oracle E-Business Suite applications will continue to be enhanced, thus protecting and extending the value of your software investment. Supplychain Management Training Overview ERP Supply Chain Management can automate detailed processes to drive cost savings and efficiency over business’ supply chain. With Supply Chain Management Training, learn how this cohesive yet flexible solution can deliver embedded analytics and adjust as conditions change. By attending this program, a combination of lecture, hands-on exercises, Students will gain valuable insight into the Supplychain key features and functions. The focus of the program will be to educate students on modern ERP Applications. ERP R12 SupplyChain Training -32 Credit Hours - What is Supplychain Management - ERP System Overview - ERP Application Navigation - ERP Supplychain Key Application Setups - ERP Inventory Management - ERP Purchasing Management - ERP Supplychain Reports - Case Study / Assignment * Upon completion Skill Development Council (Govt. of Pakistan) recognized training Certificate would be awarded to successful students. * Installment Fee Payment Options for deserving students For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 03122169325 | 03377222191 | PTCL: 021-34986664 | E: [email protected] | www.omni-academy.com I Fb: www.facebook.com/Omniacademy

Oracle ERP E-Business Suite R12 Supply Chain Management Cloud ERP Supply chain Management R12 Training SDC Certified Oracle E-Business Suite is the most comprehensive suite of integrated, global business applications that enable organizations to make better decisions, reduce costs, and increase performance. Why Oracle ERP E-Business Suite? With hundreds of cross-industry capabilities spanning enterprise resource planning, customer relationship management, and supply chain planning, Oracle E-Business Suite applications help customers manage the complexities of global business environments no matter if the organization is small, medium, or large in size. As part of Oracle’s Applications Unlimited strategy, Oracle E-Business Suite applications will continue to be enhanced, thus protecting and extending the value of your software investment. Supplychain Management Training Overview ERP Supply Chain Management can automate detailed processes to drive cost savings and efficiency over business’ supply chain. With Supply Chain Management Training, learn how this cohesive yet flexible solution can deliver embedded analytics and adjust as conditions change. By attending this program, a combination of lecture, hands-on exercises, Students will gain valuable insight into the Supplychain key features and functions. The focus of the program will be to educate students on modern ERP Applications. ERP R12 SupplyChain Training -32 Credit Hours - What is Supplychain Management - ERP System Overview - ERP Application Navigation - ERP Supplychain Key Application Setups - ERP Inventory Management - ERP Purchasing Management - ERP Supplychain Reports - Case Study / Assignment Special Discount: 10,000/- PKR For Limited Time only, fee may change without any prior notice for non-confirmed registrations. * Upon completion Skill Development Council (Govt. of Pakistan) recognized training Certificate would be awarded to successful students. * Installment Fee Payment Options for deserving students For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 03122169325 | 03377222191 | PTCL: 021-34986664 | E: [email protected] | www.omni-academy.com I Fb: www.facebook.com/Omniacademy

ORACLE R-12 Financials ERP Get Professional & Practical ERP Training  We are offering ORACLE R-12 Financials ERP Training in | Lahore | Islamabad | Faisalabad.  ORACLE R-12 Financials ERP Duration: 6 Weeks Knowledge Leader Consultants is the best training institute in Lahore for Professional ORACLE R-12 Financials ERP Training 15 Years Certified Experienced Trainer  Special Offer includes:  • Individual & Groups Training  • 100% Practical Computerized Training  • 100% Satisfaction  • Accounts Apply Manual to Computerized Software  • Study Material  • ERP Software Free Installation  • After Completion free Services  Please Contact us or Visit our Office for professional competent advice. from May 31st

ORACLE R-12 Supply Chain ERP Get Professional & Practical ERP Training  We are offering ORACLE R-12 Supply Chain ERP Training in | Lahore | Islamabad | Faisalabad.  ORACLE R-12 Supply Chain ERP Duration: 6 Weeks Knowledge Leader Consultants is the best training institute in Lahore for Professional ORACLE R-12 Supply Chain ERP Training 15 Years Certified Experienced Trainer  Special Offer includes:  • Individual & Groups Training  • 100% Practical Computerized Training  • 100% Satisfaction  • Accounts Apply Manual to Computerized Software  • Study Material  • ERP Software Free Installation  • After Completion free Services  Please Contact us or Visit our Office for professional competent advice. from Sep 2nd

Oracle Training On Demand Get Training ! Get Certified ! Registration Open “Enroll Soon” Note: Sat | Sun class, collect you admission kit for complete details about program. * Upon completion Skill Development Council (Govt. of Pakistan) recognized training Certificate would be awarded to successful students. For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 03122169325 | 03377222191 | PTCL: 021-34986664 | E: [email protected] | www.omni-academy.com I Fb: www.facebook.com/Omniacademy

Oracle Database SQL Expert Program Summary Recommended training provides the best course(s) to help you prepare for your exam. Exam topics may not map exactly. A multifaceted preparation approach is recommended. Restricting and Sorting Data Using Single-Row Functions to Customize Output Reporting Aggregated Data Using the Group Functions Displaying Data from Multiple Tables Using Subqueries to Solve Queries EXTRACT Managing Schema Objects Manipulating Large Data Sets Generating Reports by Grouping Related Data Using the Set Operators Manipulating Data Using DDL Statements to Create and Manage Tables Creating Other Schema Objects Managing Objects with Data Dictionary Views Controlling User Access Managing Data in Different Time Zones Retrieving Data Using Sub queries Hierarchical Retrieval Regular Expression Support Program Name: Oracle Database SQL Expert Training Track: DBA Duration: 2 Months For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 3498-OMNI (6664) | M: 03377222191 | 0312216 9325 I03122169321 E: [email protected] | www.omni-academy.com IFb: www.facebook.com/Omniacademy

?Oracle Human Capital Management program will help you develop a deeper understanding of how to use Core HR, iRecruitment, Self-Service HR (SSHR), Talent Management, Learning Management and Payroll systems work. Students earning this certification will be recognized as HCM Certified Specialists, which helps you to qualify for the EBS Human Capital Management Consultant career opportunities in Pakistan, GCC and across the globe. #Capital #Human capital #Omni Academy #Management consultant #EBS #Capital management #Oracle human capital management #Talent management #GCC #Pakistan #Capital management consultant Views: 5

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 , 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 CoursesRecknors Training Institute offering Oracle Certification courses:-Oracle R12 eBusiness Essentials for ImplementersFD01- ERP Application FundamentalsFD02- Access and navigate Oracle ApplicationsFD03- Understand key architectural componentsFD04- ERP System Administration ConceptsFD05- Define key and descriptive Flexfields Oracle R12 Financials Management ConsultantFIN01- Financials Management SetupsFIN02- General LedgerFIN03- ReceivablesFIN04- Payables Oracle R12 Supply Chain Management ConsultantSCM01- Supplychain Management SetupsSCM02- Purchasing ManagementSCM03- Order ManagementSCM04- Inventory Management Oracle R12 Human Capital Management ConsultantHCM01- HCM Application SetupsHCM02- Fundamentals - Employee Profile ManagementHCM03- Manage - New Hire, Promotion, TransfersHCM04- Manage - Contracts, QualificationsHCM05- Manage Salary (Salary basis)HCM06- Hiring and Terminating Employee Note: Weekend Batch also AvailablePackage includes:100% Hands-On Practical TrainingInstructor Based TrainingStudy MaterialSAP Software IDES Access 24/7Online classes are also Available in Pakistan & Aboard Recknors (Authorized Oracle & SAP Certified Trainer) Office Address: PLAZA NO.6, 3RD FLOOR COMMERCIAL AREA CAVALRY LAHORE CANTTPlease be-aware from Sub Standard Colleges/Institution have they other branches in different cities or not. Please confirm first from us.  

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 , 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 Implementer 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 Flexfields Oracle R12 Financials Management Consultant FIN01- Financials Management Setups FIN02- General Ledger FIN03- Receivables FIN04- Payables Oracle R12 Supply Chain Management Consultant SCM01- Supplychain 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) Office Address: PLAZA NO.6, 3RD FLOOR COMMERCIAL AREA CAVALRY LAHORE CANTT

NITT provides Oracle Database Trainings that can lower IT costs, while maintaining security. Expand your business with a broad portfolio as a database administrator. Learn how this technology enables your business to consolidate onto database clouds and engineering systems. Deep dive into Oracle Exadata and Oracle Database Appliance courses led by industrial expert and certified instructors. Explore Oracle Database categories. The course is designed to prepare the students for the professional developemnt using PHP programming language. We aim to cover PHP language from industry point of view so that our students can work in IT companies and can develop professional level website and web application, independently. Views: 35

Knowledge Leader Consultants Offers ORACLE R-12 Supply Chain ERP Training. Our ORACLE R-12 Supply Chain ERP training course includes basic to advanced levels based on individual requirements. We have a team of certified trainers who are working professionals with hands on real time ORACLE R-12 Supply Chain ERP Knowledge which will provide you an edge over other training institutes. from Sep 2nd

Knowledge Leader Consultants Offers ORACLE R-12 Financials ERP Training. Our ORACLE R-12 Financials ERP training course includes basic to advanced levels based on individual requirements. We have a team of certified trainers who are working professionals with hands on real time ORACLE R-12 Financials ERP Knowledge which will provide you an edge over other training institutes. from Sep 2nd

Recknors Institute Offering Discount upto 25% at New Year Certified Instructors, Hands on Training to Brighten your career. Recknors institute Cavalry Ground

Oracle Database: Introduction to SQL Ed 1.1 Summary of Program This Oracle Database: Introduction to SQL training helps you write subqueries, combine multiple queries into a single query using SET operators and report aggregated data using group functions. Learn this and more through hands-on exercises. Key Learning: • Understand the basic concepts of relational databases ensure refined code by developers. • Create reports of sorted and restricted data. • Run data manipulation statements (DML). • Control database access to specific objects. • Manage schema objects. • Manage objects with data dictionary views. • Retrieve row and column data from tables. • Control privileges at the object and system level. • Create indexes and constraints; alter existing schema objects. • Create and query external tables. Benefits to You Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database. WHY CHOOSE OMNI ACADEMY 100% Student Satisfaction Get Oracle Certified Internship opportunities for Top students Duration: 6 Days – Approx (SAT or SUN 2hrs Classes) For Details Contact Us: A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, and Karachi, Pakistan Call: 3498-OMNI (6664) | M: 03377222191 | 0312216 9325 I03122169321 E: [email protected] | www.omni-academy.com IFb: www.facebook.com/Omniacademy

The answer is a resounding YES for IT professionals who are looking to boost their career. While there are no guarantees, certification has been shown to enhance various aspects of an IT professional’s career. #Oracle #Java #Cloud #Service #Certified #Associate #Omni Academy #Training #Courses #Certification #Java cloud Service #Oracle Java Cloud Certification #Cloud Service Views: 3

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 , 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 CoursesRecknors Training Institute offering Oracle Certification courses:-Oracle R12 eBusiness Essentials for ImplementersFD01- ERP Application FundamentalsFD02- Access and navigate Oracle ApplicationsFD03- Understand key architectural componentsFD04- ERP System Administration ConceptsFD05- Define key and descriptive Flexfields Oracle R12 Financials Management ConsultantFIN01- Financials Management SetupsFIN02- General LedgerFIN03- ReceivablesFIN04- Payables Oracle R12 Supply Chain Management ConsultantSCM01- Supplychain Management SetupsSCM02- Purchasing ManagementSCM03- Order ManagementSCM04- Inventory Management Oracle R12 Human Capital Management ConsultantHCM01- HCM Application SetupsHCM02- Fundamentals - Employee Profile ManagementHCM03- Manage - New Hire, Promotion, TransfersHCM04- Manage - Contracts, QualificationsHCM05- Manage Salary (Salary basis)HCM06- Hiring and Terminating Employee Note: Weekend Batch also AvailablePackage includes:100% Hands-On Practical TrainingInstructor Based TrainingStudy MaterialSAP Software IDES Access 24/7Online classes are also Available in Pakistan & Aboard Recknors (Authorized Oracle & SAP Certified Trainer) Office Address: PLAZA NO.6, 3RD FLOOR COMMERCIAL AREA CAVALRY LAHORE CANTT Please be-aware from Sub Standard Colleges/Institution have they other branches in different cities or not. Please confirm first from us.  

We would like to inform you that the Functional Training on “E-Business Suite R 12 Financial Management Certified Implementation Specialist Course” will be commenced on Saturday, March 14, 2015 as weekend’s program. The course outlines are attached herewith and details are as follows: Oracle E-Business Suite 12 Financial Management Certified Implementation Specialist: Training and Certification: Module 1. EBS 12 Oracle Essentials for Implementers Module 2. EBS 12 Oracle General Ledger Management Fundamentals Module 3. EBS 12 Oracle Payables Management Fundamentals Online Exams: 1Z0-516 Oracle General Ledger Certified Specialist 1Z0-517 Oracle Payables Management Certified Specialist Duration of The Program: Ten Weeks (weekends) Program Certification Exams : 1Z0-516, 1Z0-517 Class Commencement : March 14, 2015 Delivery Mode : Hands On Training (ILT) Lead Trainer : Project Manager and EBS-R12 Consultant who successfully Implemented E-Business Suite R12 Benefits of the Program: The participants will get courseware, software, preparation material for certifications, hands-on training. Course Outlines : Standard OU Course Outline for the above-mentioned three courses. Course Fee : Subsidized Course Fee 90% Reduced Academic Fee; to be paid in favor of “Technology Education Academy”, seven days ahead of scheduled program. We offer the remaining core and advanced modules’ training of EBS-R12 such as on HRMS, Supply Chain Management, Cash Management, Asset Management, Order Management, Purchasing, Inventory Management, etc. at pretty affordable training charges. Please feel free to contact undersigned for timely registration. Thanking you and kind regards. Muhammad Ali Hashmi | Director | Technology Education Academy Suite D-4, Fourth Floor, Osif Centre, Block 13-A, Gulshan-e-Iqbal, University Road, Karachi-75300 Tel.#: +92 21 3 496 2327 | Cell.#: +92 321 8202003 | Email: shah@aazam.edu.pk

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)

FREE WORKSHOPS CERTIFIED ON 19TH MAY,2019 Oracle Fusion Cloud ERP Introduction - FREE WORKSHOP Free Workshop 19th May,19 at 12:00PM (Location: GULSHAN) 2 hours Oracle ERP Financials Applications - FREE WORKSHOP Free Workshop 19th May,19 at 12:00PM (Location: GULSHAN) 2 hours Oracle ERP Applications Introduction - FREE WORKSHOP Free Workshop 19th May,19 at 12:00PM (Location: GULSHAN) 2 hours Oracle ERP Supply Chain Introduction - FREE WORKSHOP Free Workshop 19th May,19 at 12:00PM (Location: GULSHAN) 2 hours Ethical Hacking - Hacking with Kali Linux - FREE WORKSHOP Free Workshop 19th May,19 at 02:00PM (Location: GULSHAN) 2 hours Diploma in HRMS Corporate HR Course - FREE WORKSHOP Free Workshop 19th May,19 at 02:00PM (Location: DHA) 2 hours CHRMP - Certified Human Resource - FREE WORKSHOP Free Workshop 19th May,19 at 01:00PM (Location: DHA) 2 hours Certified Supplychain Professional - FREE WORKSHOP Free Workshop 19th May,19 at 01:00PM (Location: DHA) 2 hours All workshops are available online and classroom (Both) Applicable on all courses in campus and online classes. ?? Call:GULSHAN: 0213-498-OMNI(6664) | +92.312.2169325 I DHA: +92. 0333 3808 376 Views: 4

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