Introduction oracle

Oracle 11g Certification ORACLE DATABASE: INTRODUCTION TO SQL ED 1.1 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..... Discount upto Rs.5,000. ORACLE 10G – FORMS AND REPORTS DEVELOPER 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..... ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II RELEASE 2 This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You'll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery..... ORACLE DATABASE 11G: DATA GUARD ADMINISTRATION RELEASE 2 This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes..... ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I RELEASE 2 This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration..... ORACLE DATABASE 11G: PERFORMANCE TUNING DBA RELEASE 2 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. A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental Bakers/ Faysal Bank Call: 0337.7222 191, 0312.2169 325 PTCL: 3498-OMNI (6664) eMail: info@omni-academy.com Views: 6

Oracle 11g Certification ORACLE DATABASE: INTRODUCTION TO SQL ED 1.1 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….. Discount upto Rs.5,000. ORACLE 10G – FORMS AND REPORTS DEVELOPER 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….. ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP II RELEASE 2 This Oracle Database 11g: Administration Workshop II Release 2 training takes the database administrator beyond the basic tasks covered in the first workshop. You’ll begin by gaining a deep understanding of the most important responsibilities a DBA has: performing backup and recovery….. ORACLE DATABASE 11G: DATA GUARD ADMINISTRATION RELEASE 2 This Oracle Database 11g: Data Guard Administration Release 2 training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtimes….. ORACLE DATABASE 11G: ADMINISTRATION WORKSHOP I RELEASE 2 This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration….. ORACLE DATABASE 11G: PERFORMANCE TUNING DBA RELEASE 2 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. A-575, Block 5, KDA Scheme 24, Gulshan-e-Iqbal, Karachi, Pakistan Opposite: Continental Bakers/ Faysal Bank Call: 0337.7222 191, 0312.2169 325 PTCL: 3498-OMNI (6664) eMail: [email protected] Web: www.omni-academy.com

Oracle Database 12c SQL Fundamentals Certification Program Summary With Oracle Database 12c: SQL Fundamentals, you experience the benefits of an Oracle Database that is re-engineered for Cloud computing. Multitenant architecture brings enterprises unprecedented hardware and software efficiencies, performance and manageability benefits, and fast and efficient Cloud provisioning. Oracle Database 12c: SQL Fundamentals certifications emphasize the full set of skills that DBAs need in today’s competitive marketplace. Introduction • Describe the features of Oracle Database 12c • Describe the salient features of Oracle Cloud 12c • Explain the theoretical and physical aspects of a relational database • Describe Oracle server’s implementation of RDBMS and object relational database management system (ORDBMS) Retrieving Data using the SQL SELECT Statement • Explain the capabilities of SQL SELECT statements • Execute a basic SELECT statement Restricting and Sorting Data • Limit the rows that are retrieved by a query • Sort the rows that are retrieved by a query • Use ampersand substitution to restrict and sort output at runtime Using Single-Row Functions to Customize Output • Describe various types of functions available in SQL • Use character, number, and date functions in SELECT statements Using Conversion Functions and Conditional Expressions • Describe various types of conversion functions that are available in SQL • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions • Apply conditional expressions in a SELECT statement Reporting Aggregated Data Using the Group Functions • Identify the available group functions • Describe the use of group functions • Group data by using the GROUP BY clause • Include or exclude grouped rows by using the HAVING clause Displaying Data From Multiple Tables Using Joins • Write SELECT statements to access data from more than one table using equijoins and nonequijoins • Join a table to itself by using a self-join • View data that generally does not meet a join condition by using OUTER joins • Generate a Cartesian product of all rows from two or more tables Using Subqueries to Solve Queries • Define subqueries • Describe the types of problems that the subqueries can solve • Describe the types of subqueries • Write single-row and multiple-row subqueries • Using the SET Operators • Describe set operators • Use a set operator to combine multiple queries into a single query • Control the order of rows returned Managing Tables using DML statements • Truncate data • Insert rows into a table • Update rows in a table • Delete rows from a table • Control transactions Introduction to Data Definition Language • Categorize the main database objects • Explain the table structure • Describe the data types that are available for columns • Create a simple table • Explain how constraints are created at the time of table creation • Describe how schema objects work Program Name: Oracle Database 12c SQL Fundamentals Training Track: DBA Duration: 2 Months For Details Contact Us: 0312.2169 325, 0337.7222 191, PTCL: 3498-OMNI (6664) | E: [email protected]

Oracle BI(Business Intelligence) Publisher is the reporting solution to author, manage, and deliver all your reports and documents easier and faster than traditional reporting tools. Use your web browser or familiar desktop tools to create everything from pixel-perfect customer facing documents to interactive management reports against practically any data source. Oracle BI Publisher Training Curriculum Introduction to Oracle BI Publisher Oracle BI Publisher: Technology and Architecture Introduction To XML Standards Getting Started With Oracle BI Publisher: Creating A Simple Report Creating Simple RTF Templates Creating Parameters, List Of Values (LOVs), And Hyperlinks Working With PDF And EText Templates Using Oracle BI Publisher Enterprise Administration Creating Reports Based On Other Data Sources Please call us + 923464519919 or email us at naktakas@gmail.com Skype id naktakas Views: 7

Oracle E-Business Suite R12 Applications DBA Oracle E-Business Suite R12 Applications Administration – DBA Concept BEST COURSE TO UNDERSTAND THE APPS ADMIN & DBA CONCEPTS: At the end of Oracle E-Business Suite Administration course, you will get the knowledge of Oracle Applications Overview, Oracle Applications Components, Oracle Applications Architecture & Installations, Oracle Applications day-to-day database administration work, Oracle Applications Patching, Cloning, Monitoring and Troubleshooting. Course Content: Introduction to Oracle Applications ERP Oracle Applications Architecture & Installations Oracle Applications Administration Patch Administration Cloning System Administration Fundamentals Monitoring and Troubleshooting Requirements Working Experience on Windows PC Good Internet Connectivity (for Online Class) Basic database knowledge Training Track: Oracle E-Business Suite R12 Applications DBA Duration: Two Month (Approx) Flexible Class Options Morning | Evening Classes | Workshops | Fast-Track Week End Classes For Professionals SAT | SUN Online Classes – Live Virtual Class (L.V.C), Online Training A-242, Behind RAB Medical Hospital, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi. 0337-7222-191, 0312-2169-325 info@omni-academy.com Views: 17

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

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

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

Oracle Database 11g and 12c Introduction Free Workshop On 11th Nov,17 OR Call 0312.2169.325 / A-242, Behind RAB Medical Hospital, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi.E: info@omni-academy.com Views: 2

Oracle Fusion Cloud ERP Applications Introduction Free Workshop On 19th Nov,17 at 12pm / Call 0312.2169.325 / A-242, Behind RAB Medical Hospital, Sardar Ali Sabri Rd. Block-2, Gulshan-e-Iqbal, Karachi.E: info@omni-academy.com Views: 2

Oracle Fusion Cloud ERP Introduction Free Workshop With Certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 17th Feb,19 at 02:00 PM - 04:PM (Location: DHA) Views: 0

Oracle ERP Supply Chain Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 03rd Mar,19 at 02:00 PM - 04:PM (Location: GULSHAN) All workshops are available online and classroom (Both) Applicable on all courses in campus and online classes. Register Online https://goo.gl/i5jQHP For Course detail https://goo.gl/MSYxg3 ?? Call:GULSHAN: 0213-498-OMNI(6664) | +92.312.2169325 I DHA: +92. 0333 3808 376 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_erp_cloud Views: 6

Oracle ERP Applications Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 03rd Mar,19 at 02:00 PM - 04:PM (Location: GULSHAN) 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 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_sales_cloud Views: 7

Oracle Fusion Cloud ERP Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 03rd Mar,19 at 02:00 PM - 04:PM (Location: GULSHAN) 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 #Oracle_Cloud_Implementation #Oracle_ERP #Fusion_Cloud #Oracle_ERP_Support Views: 6

Oracle ERP Applications Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 16th Mar,19 at 02:00 PM - 04:PM (Location: DHA) 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 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_sales_cloud Views: 10

Oracle ERP Applications Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 16th Mar,19 at 02:00 PM - 04:PM (Location: DHA) 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 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_sales_cloud Views: 3

Oracle Fusion Cloud ERP Introduction - Free workshop with certificate Register to Join Online or In-class - Unlimited Learning   Free Workshop 16th Mar,19 at 02:00 PM - 04:PM (Location: DHA) 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 #Oracle_Cloud_Implementation #Oracle_ERP #Fusion_Cloud #Oracle_ERP_Support Views: 3

Oracle Database 11g and 12c Introduction - FREE WORKSHOP Register to Join Online or In-class - Unlimited Learning Free Workshop 13th Apr,19 at 04:00pm (Location: GULSHAN) 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 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_dba #dba_training #dba_course #dba_certification Views: 5

Oracle Database 11g and 12c Introduction - FREE WORKSHOP Register to Join Online or In-class - Unlimited Learning   Free Workshop 15th Jun,19 at 11:00 AM (Location: GULSHAN) 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: 35

Oracle ERP Applications Introduction - FREE WORKSHOP Register to Join Online or In-class - Unlimited Learning   Free Workshop 22nd Sep,19 at 11:00 AM (Location: GUL) 2 hours All workshops are available online and classroom (Both) ?? Call:GULSHAN: 0213-498-OMNI(6664) | +92.312.2169325 I DHA: +92. 0333 3808 376 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_sales_cloud Views: 1

Oracle ERP Supply Chain Introduction - FREE WORKSHOP Register to Join Online or In-class - Unlimited Learning   Free Workshop 22nd Sep,19 at 11:00 AM (Location: GUL) 2 hours All workshops are available online and classroom (Both) ?? Call:GULSHAN: 0213-498-OMNI(6664) | +92.312.2169325 I DHA: +92. 0333 3808 376 #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_erp_training #oracle_fusion_cloud #oracle_erp_cloud Views: 2

Oracle Database 11g and 12c & Modern SupplyChain Planning with ERP - FREE WORKSHOP Oracle Database 11g and 12c Introduction - FREE WORKSHOPRegister to Join Online or In-class - Unlimited Learning Free Workshop 05th May,19 at 11:AM (Location: GULSHAN) 2 hours All workshops are available online and classroom (Both) Applicable on all courses in campus and online classes.???? Join FREE Workshop & Training #oracle_training #oracle_course #oracle_certification #oracle_education_pakistan #oracle_dba #dba_training #dba_course #dba_certification Modern SupplyChain Planning with ERP - FREE WORKSHOPRegister to Join Online or In-class - Unlimited Learning Free Workshop 05th May,19 at 03:00PM (Location: DHA) 2 hours All workshops are available online and classroom (Both) Applicable on all courses in campus and online classes.???? Join FREE Workshop & Training 0213-498-OMNI(6664) | +92.312.2169325 I DHA: +92. 0333 3808 376 #DIPLOMA_SUPPLYCHAIN #SUPPLYCHAIN #SCM #SCM_COURSE #SCM Views: 0

Oracle SOA AIA Online Training Institute in India Course content: INTRODUCTION TO APPLICATION INTEGRATION ARCHITECTURE(AIA) Describe the AIA Concepts & Products Explain the AIA Value Proposition Explain Types of Integrations Supported by AIA Explain typical AIA Project Lifecycle ENTERPRISE MEDIATION (EBO, EBS, EBM) Describe Enterprise Business Objects Describe Enterprise Business Services Describe Enterprise Business Messages Describe Service Construction Outline SOA Development Lifecycle FUNCTIONAL DESIGN OF AN INTEGRATION Create a new AIA Project Add an existing service into an AIA Project Create a new service solution component request Analyze the Participating Application Connectivity Technology Define the Deployment Strategy TECHNICAL DESIGN OF AN INTEGRATION Introduce Technical Components of an AIA Project Analyze the ABM to EBM mapping Design the EBSs Design the EBFs Design the ABCSs BUSINESS PROCESS ORCHESTRATION Describe Concepts of Business Process Orchestration Create an Enterprise Business Flows (EBF) SERVICE DEPLOYMENT Explain AIA Deployment Plan Create a Bill of Materials Create a Deployment Plan Package Integration Solution (PIP) Deploy AIA Content Manually TESTING & MAINTENANCE Describe Test & Maintain AIA Integrations Create CAVS Simulators Describe Versioning Describe AIA Error Handling & Logging

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

Type Computer Oracle Forms & Reports Developer – 40% Discount Training 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. MHSG Consulting is offering Oracle Forms and Reports Developer Training program with 40% Fee discount, classes are starting from 24th Aug - For registration pls. call . 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 Program Coordinator: For details pls. contact M: L: , “Learn better to do better”

The Oracle Database 12c Learning path is designed to provide an effective curriculum plan for database administrators, system administrators and developers who are either new to their role or want to gain additional skills Oracle 12C DBA Modules:- 1. Oracle12C Introduction to SQL 2. Oracle 12C Admin, Install and Upgrade Accelerated 3. Oracle 12C Backup and Recovery 4. Oracle 12C Managing Multitenant Architecture Contact Us Tel.: +92 42 37173535-6 | Skype: academics.central Mail: info@mua-tech.com Location: Bridge Stone Building 2nd Floor, HSC, JMC Metro Station, Lytton Road Lahore Views: 19

Module-1: Oracle Database 10g: Introduction to SQL Module-2: Oracle Database 10g: Administration Workshop I Module-3: Oracle Database 10g: Administration Workshop II NOTE: *Fee course is Rs. /- per participant *10% discount per participant will be offered for a batch more than 5 students