Oracle Training

Home » Oracle Training

Oracle Database 11g Performance Tuning

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.

Learn To:

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

Oracle Database 11g: Administration Workshop I Release 2

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

Learn To:

  • Install Oracle Grid Infrastructure.
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Perform backup and recovery.

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.

Oracle Database: PL/SQL Fundamentals

This training will teach you the basics of PL/SQL, syntax, blocks and programming constructs. By enrolling in a Self-Study Course, you’ll be able to learn at your own pace, when it’s most convenient for you.

Learn To:

  • Identify the programming extensions that PL/SQL provides to SQL.
  • Write PL/SQL code to interface with the database.
  • Design PL/SQL anonymous blocks that execute efficiently.
  • Use PL/SQL programming constructs and conditional control statements.
  • Seamlessly integrate procedural constructs with SQL.
  • Handle run-time errors.
  • Create stored procedures and functions.

Develop Your PL/SQL Fundamental Skills

The Procedural Language extension to SQL (PL/SQL) is Oracle Corporation’s standard data access language for relational databases. Invest in this course to develop core PL/SQL skills that will serve you well in your career.

Who is it for?

  • Application Developers
  • Database Administrators
  • Database Designers
  • Forms Developer
  • Technical Consultant
  • PL/SQL Developer

Oracle Database: SQL Workshop I

The  course offers students an introduction to Oracle Database 12c database technology. The students are also introduced to Oracle Database Exadata Express Cloud Service. In this class 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 database objects.

Learn To:

  • Identify what a SQL statement is.
  • Understand the Oracle Relational Database.
  • Use SQL Developer.
  • Write reports using SQL Statements.
  • Manipulate data in relational tables and save the data.

Benefits To You

Students use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is introduced as an optional tool. Demonstrations and hands-on practice reinforce the fundamental concepts.

Oracle BI 11g R1: Build Repositories

This training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you’ll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company’s business requirements.

Learn To:

  • Build and execute analyses to test and verify a dimensional business model.
  • Use the Oracle BI Adminstration Tool to administer Oracle BI Server.
  • Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository.
  • Build a dimensional business model to address business intelligence requirements.
  • Validate your work by creating and running analyses, and verifying query results using the query log.

Benefits to You

By taking this course, you’ll walk away with the ability to transform your organization’s data into intelligence, which will improve your day-to-day decision making. This new knowledge will help you provide time-critical, relevant and accurate insights. Furthermore, you’ll develop skills that will help you become more efficient at building repositories.

Build Logical Business Models

This course will also teach you how to import schemas, design and build logical business models and expose business models to users in the Oracle BI user interface. While constructing the repository, you’ll learn how to build physical and logical joins, simple measures and calculation measures.

Model Logical Dimension Hierarchies

You’ll then extend the initial repository and learn how to model more complex business requirements. This includes logical dimension hierarchies, multiple logical table sources, aggregate tables, partitions and time series data.

Implement Oracle BI Server Security

Oracle University instructors will also walk you through implementing the Oracle BI Server security and managing the Oracle BI Server cache. You’ll learn how to set up a multi-user development environment and use Administration Tool wizards and utilities to manage, maintain and enhance repositories.

Oracle WebLogic Server 12c: Administration I

This training teaches you how to install and configure Oracle WebLogic Server 12c. It gives administrators an overview of the basic concepts and architecture of WebLogic Server.

Learn how to:

  • Install, configure, and administer Oracle WebLogic Server.
  • Monitor domain resources.
  • Deploy applications.
  • Create a domain.
  • Start servers.
  • Monitor domain resources.
  • Set up and use node manager.
  • Deploy applications.
  • Configure database resources.
  • Configure a cluster.

Benefits to You

After taking this course, you’ll be able to improve the performance and scalability of your organization’s applications and services with the #1 application server. You’ll simplify deployment and significantly improve time-to-market.

Oracle Solaris 10 Operating System Essentials

This course explores the key features and capabilities of the Solaris 10 OS. Interact with expert Oracle University instructors through formalized instruction, discussions, question and answers sessions and hands-on exercises.

Learn To:

  • Understand fundamental command-line features of the Solaris OS.
  • Explore file system navigation, the vi text editor and file permissions.
  • Work with access control lists (ACLs), command shells and file compression.
  • Understand basic network use.
  • Read shell scripts.

Benefits to You

Investing in this course will enable your organization’s platforms to work with greater efficiency with the Oracle Solaris 10 Operating System. You’ll benefit from instruction on key features and capabilities, enabling you to perform file and directory management, control the user work environment, archive files and use remote commands.

System Administration for the Oracle Solaris 10 OS, Part 1

This course helps you gain expertise in the basic system administration concepts of Oracle Solaris 10. Expert Oracle University instructors will help you become further engaged with the most efficient, secure and reliable operating system.

You can use this course as a stepping stone to learn advanced technologies taught in System administration for the Oracle Solaris 10 OS Part 2 course.

This course counts towards the hands-on course requirement for the Oracle Solaris 10 System Administrator Certification. Only Classroom Training or Live Virtual Class formats of this course will meet the certification hands-on requirement. Self-Study Courses and Knowledge Center courses DO NOT meet the hands-on Requirement.

Learn To:

  • Perform basic system installation and configuration on Oracle Solaris 10 1/13 OS.
  • Maintain and operate Oracle Solaris 10 1/13.
  • Effectively administer file systems, users, services, processes, packages and network interfaces.
  • Manage local disk devices.
  • Perform mounts and unmounts.
  • Describe interface configurations.

Oracle Solaris 11 System Administration

The training covers the full range of introductory system administration tasks on Oracle Solaris 11.3 OS. The topics covered range from installing the operating system on a single system, to monitoring and basic troubleshooting. The Oracle Solaris 11 System Administration course is designed to provide new system administrators, as well as enterprise system administrators who are new to the Oracle Solaris 11 Operating System, with the skills they need to perform their job tasks successfully and efficiently.

Learn To:

  • Perform software installation and software package updates.
  • Manage services, processes and access controls.
  • Administer data storage, zones, network and users.

Benefits to You

The course provides an intensive hands-on experience for key system administration tasks with the goal of making the system administrator job-ready.

Oracle VM Server for x86: Administration

The course explores building the infrastructure for open cloud computing. Expert Oracle University instructors will show you how to support enterprise applications by deploying pooled server resources to create virtual machines.

Learn To:

  • Plan a virtual solution.
  • Install the Oracle VM Server for x86 and the Oracle VM Manager software.
  • Configure network resources to provide isolation and redundancy.
  • Add SAN and NFS to provision storage for the virtual environment.
  • Create server pools and repositories to support application workloads.
  • Speed up virtual machine deployment with templates and virtual appliances.
  • Use virtual machine high availability.
  • Use server pool policies to maximize the performance of your server workloads.

Benefits to You:

Using the Oracle VM application-driven architecture is different from using traditional virtualization. Built with the application stack and manageability in mind, Oracle VM offers a complete lifecycle compute stack virtualization. This course delivers the skill to help you consolidate the server foot print, while acquiring the tools to deploy or consolidate application workloads to a virtualized environment or migrate to a open cloud infrastructure.

Oracle VM Server for x86: Implementation

The course teaches you how to enhance cloud effectiveness with rapid deployment of cloud resources and applications. You will learn how to administer, redistribute, troubleshoot and protect Oracle VM resources to ensure seamless and continuous access of your applications.

Oracle VM offers a dynamic architecture which allows you to effectively deploy server virtualization to consolidate application workloads and ensure uninterrupted cloud services. Using extensive hands-on practices, this course prepares you to respond quickly to changing business conditions.

Learn To:

  • Administer the Oracle VM environment by using the appropriate management tools.
  • Redeploy cloud resources to meet requirements.
  • Track and solve issues at each operational layer.
  • Protect Oracle VM resources.
  • Incorporate key components into your disaster and recovery strategy.

Benefits to You

Maximize Cloud Resources

Server virtualization is the first step to delivering application and cloud services. In your Oracle VM environment, you have the ability to deploy and redeploy standardized and pre-configured software appliances to meet workload objectives and to redistribute physical and virtual resources to maximize resources for your application workload. In this course, you learn the tools and processes to accelerate your private cloud deployments and to redeploy resources effectively.

Increase Application Availability

Virtual environments introduce challenges for isolating and solving problems. Learn to detect problems at every layer of the Oracle VM environment, how to capture a configuration snapshot of your environment before making changes and as a way to communicate vital information about your environment to Oracle support.

Protect Cloud Resources

You learn to identify the resources that you must protect, and the steps to back up and recover these resources. You explore environment-wide recovery scenarios and gain knowledge that you can use as a blueprint for your disaster recovery strategy.

Java SE 7 Fundamentals

This training teaches students with little or no programming experience to begin to learn programming using the Java programming language. It explores the significance of object-oriented programming, the keywords and constructs of the Java programming language and the steps required to create simple Java technology programs.

Learn To:

  • Use various Java programming language constructs to create several Java technology applications.
  • Use decision and looping constructs and methods to dictate program flow.
  • Perform basic error handling for your Java technology programs.
  • Implement intermediate Java programming and object-oriented (OO) concepts in Java technology programs.
  • Demonstrate knowledge of Java technology and the Java programming language.

Benefits to You

By investing in this course, you’ll develop a solid foundation in the Java programming language upon which to base continued work and training. It features the Java Platform, Standard Edition 7 (Java SE 7), and uses the Java SE Development Kit 7 (JDK 7) product.

Java SE 7 Programming

This Java Programming training covers the core Application Programming Interfaces (API) you’ll use to design object-oriented applications with Java. Expert Oracle University instructors will teach you how to write database programs with JDBC.

Learn To:

  • Create Java technology applications with the latest JDK 7 Technology and the NetBeans Integrated Development Environment (IDE).
  • Enhance object-oriented thinking skills using design patterns and best practices.
  • Identify good practices in the use of the language to create robust Java applications.
  • Manipulate files, directories and file systems.
  • Write database applications using standard SQL queries through JDBC.
  • Create high-performance, multi-threaded applications.
  • Create classes that subclass other classes, extend abstract classes and program with interfaces.
  • Properly use exceptions and the Collections framework.
  • Develop applications that manipulate files, directories and file systems.

Benefits to You

By enrolling in this course, you’ll learn how to boost the productivity, communication and collaboration of your organization. At the same time, you’ll develop the knowledge and skills to reduce the cost of application ownership through more efficient development and deployment techniques. Maintain your edge in the job market by staying current with the global standard for developing networked applications.