* COVID-19: 1 Person per Room Health & Safety Policy *

eLearning Bundle - Oracle Online Course

Oracle TrainingeLearning Bundle - Oracle

by Certstaffix® Training

Length: 4 Course(s)      Price: $1250/person (US Dollars)      Bulk Pricing: 6+ Contact Us      Access Length: 6 Months      Category: Oracle

This eLearning Bundle includes these 4 courses: Introduction to SQL Training (Oracle), Advanced SQL Queries with Oracle, Oracle PL/SQL Training and Oracle 12c OCP 1Z0-062: Installation and Administration.

Certification exams are administered by third party testing companies. Our courses prepare you for the certification exam, which is an additional fee paid to the testing provider. You must contact testing provider to take a certification exam.
Purchase This Course ➥
Course Description: Print It | Download PDF | Email It

  Online Oracle Classes: Learn at Your Own Pace

We will enroll you into a demo (Windows 10) eLearning session. Login information will be emailed to you.

Prefer a self-paced learning solution to fit your own schedule? Certstaffix® Training offers eLearning courses bundled together:

  • Learn at your own pace - Start and stop as it is convenient for you. Pick up where you left off.
  • Lecture utilizing video and recorded screen shots
  • 6 month subscription length
  • Any software needed for training is provided in an online lab environment.

  Detailed Training Topics

Course Description: Print It | Download PDF | Email It
Oracle Training

Introduction to SQL Training (Oracle) - 16:07 hours

This training course provides a thorough introduction to SQL and shows you how to generate business reports from your relational database management system (RDBMS). The course begins by providing an overview of the history of SQL, how databases work, and common SQL statements. Then, you'll learn how to work with SQL, from creating reports with simple SELECT statements to writing queries to retrieve data from multiple tables. The course also covers conditional processing with the CASE function and how to insert, update and delete records. This SQL course is applicable for use with all major databases, including Oracle, SQL Server and MySQL. Differences between databases will be pointed out where they exist.

Advanced SQL Queries with Oracle - 21:52 hours

Master SQL using an Oracle database and prepare for the PL/SQL course by taking this advanced Oracle SQL training course. To begin, we'll introduce you to important concepts when working with Oracle databases so you can build a solid knowledge foundation. Then, you'll delve into more complex queries, including pseudo columns and functions, subqueries, joins, and analytic functions. You'll also learn how to perform conditional processing and work with character and non-character functions. Finally, we'll move beyond queries and show you how to change data in an Oracle database using SQL Data Manipulation Language (DML). By the end of this course, you will know how to use SQL to perform advanced queries and functions, and manipulate data, within an Oracle database.

Oracle PL/SQL Training - 23:07 hours

In this course, you'll learn how to use PL/SQL, Oracle's extension language for standard SQL. It allows you to write more sophisticated queries against an Oracle database. Designed for students already familiar with SQL, this course provides a thorough introduction to PL/SQL, explaining its main benefits, key components, and how to execute it on an Oracle database. You'll then learn how to define and work with variables, perform conditional and iterative processing, handle exceptions, and use SQL in PL/SQL for added versatility. From there, you'll move onto more complex tasks, such as working with nested blocks, subprograms, stored procedures and functions, packages, triggers, and Oracle-supplied packages. By the end of this course, you will know how to use the powerful PL/SQL language with your Oracle database.

Oracle 12c OCP 1Z0-062: Installation and Administration - 18:57 hours

This course is designed for the database administrator seeking to update their skills and professional credentials in relation to Oracle Database 12c, and in preparation for the certification exam. Proficient use of Oracle is essential to your ability to manage large amounts of data, whether in private industry or in government applications. This well-paced training guide demonstrates the latest features in a series of relaxed, conversational modules. Whether you are seeking a refresher on the fundamentals of Oracle or are preparing for the certification exam, this course offers a detailed explanation of every facet of the dynamic database. It covers essential features and functions of the Oracle 12c database management system, including platform compatibility, system architecture, and operating tools. Upon completion you'll have the practical skills and knowledge required to successfully complete the Oracle Database 12c Installation and Administration exam (1Z0-062) and excel as an Oracle database administrator.
Course Description: Print It | Download PDF | Email It