This course introduces students to the fundamentals of SQL using Oracle Database 11g database technology. In this course students learn the concepts of relational databases and the powerful SQL programming language. This course provides the essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create…
Oracle Courses
Microsoft SQL 2
The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. Course Objectives Elements that will be covered in this course are…
Oracle Database 11g SQL Fundamentals
This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider…
Oracle Database 10g Introduction to SQL Part I
This course is a common starting point for administrators, developers, and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database. Course Objectives This course covers the following elements: Relational databases & SQL Use SQL *Plus Building select statements Build where…
Oracle Database 10g Introduction to SQL Part II
The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. Course Objectives This course will cover the following elements: Learn to…
Oracle 10g Database Administration Certification
Exam 1Z1-042 This course is first step towards as an Oracle professional, designed to give you a firm foundation in basic database administration. In this class you will learn how to install and maintain an Oracle Database. You will gain a conceptual understanding of the Oracle database architecture and how its components work and interact…
Oracle Payables 11i Fundamentals
Exam IZ0-212 Oracle Payables 11i Fundamentals. In this course, participants learn how to set up and use Oracle Payables to manage the accounts payable process. Participants learn how to manage suppliers, process invoices as well as payments and generate key reports. Participants also learn how to approve invoices for payment, process stop and void payments,…
Oracle Financial Analyzer 11i for End Users
This course introduces learners to the interface and functionality of Oracle Financial Analyzer (OFA) 11i budget workstation, interactive Web environment, and Express Spreadsheet Add-In. Learners also will use case-study scenarios to explore the OFA and Oracle Express Server consolidated multidimensional database system. Additionally, learners will design and analyze financial documents, such as budgets and forecasts,…
11i E Business Suite Essentials For Implementer
Exam IZ0 200 11i E-Business Suite Essentials for Implementers. This course provides an overview of the Oracle E-Business Suite. It covers all the essential areas that a functional implementer should know to start the journey with Oracle Applications. Course Objectives Students learn about the major components of the 11i E-Business Suite architecture. They will be…
11i General Ledger Management Fundamentals
Course Objectives This course covers the following elements: Explain where multi-currency is a positioned with the Oracle general ledger business flow Identify the setup options to process journal entries Identify the features and functionality of the global consolidation system (GCS) Describe the types and components of journal entries Explain the Oracle general ledger revaluation and…