Oracle

The Oracle Database: SQL Workshop II Ed 2 course will help students enhance their skills as Application developers by learning to manage the database objects, data dictionary views and multicolumn subqueries. Students also learn to write more efficient queries using the functions supporting the timezone and regular expressions. Learn To: Grant and revoke privileges and roles. Manage schema objects and data dictionary views. Write efficient and complex subqueries. Use the in-built functions supporting the usage of regular expressions and time zone.

In the Oracle Database: SQL Tuning for Developers course, you learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code. Learn the different ways in which data can be accessed efficiently. In this course, you will be introduced to Oracle Database Exadata Express Cloud Service. Learn To: Use Oracle tools to identify inefficient SQL statements. Use Automatic SQL Tuning. Use Real Time SQL monitoring. Write more efficient SQL statements. Monitor and trace high load SQL statements. Manage optimizer statistics on database objects. Understand the optimizer process steps and operators. Interpret execution plans. Perform application tracing. Gain an understanding of the Oracle Database Exadata Express Cloud Service.

This Oracle Solaris 11 Building Private Clouds course explores how cloud administration training combines multiple enterprise-level technologies to demonstrate a full cloud infrastructure deployment using SPARC technology. This course uses the "Oracle Optimized Solution for Enterprise Cloud Infrastructure on SPARC" as a guideline. Learn To: Plan for and deploy a private Infrastructure as a Service cloud. Combine various Oracle technologies into a robust cloud infrastructure. Practice cloud component creation and configuration tasks by performing a series of guided hands-on labs. Perform the critical steps associated with the configuration of cloud and related facilities. Benefits To You Enrolling in this course allows you to use the skills you learn to effectively deploy a cloud solution. You'll develop the skills to combine virtualization and system management technologies. Configuring Infrastructure as a Service This is an advanced course offering that encompasses multiple Oracle technologies (Oracle Solaris 11,Oracle Enterprise Manager Ops Center 12c and Oracle VM Server for SPARC). Expert Oracle University instructors focus on the skills and knowledge required for configuring the Infrastructure as a Service (IaaS) cloud, as well as best practices. This course is ideal for experienced system administrators who are responsible for planning and performing Cloud creation and administration tasks in a virtualized datacenter. Gain Hands-On Experience This course also offers hands-on labs, which include business scenarios that showcase best practices when managing the cloud infrastructure. Please note that it's assumed that you already have the skills and knowledge necessary to administer Oracle Solaris 11.

The Oracle Solaris 11 Zones Administration training is an advanced course offering that builds on Oracle Solaris 11 system administration courses. Expert Oracle University instructors will help you develop the skills and knowledge required to administer Oracle Solaris Zones server virtualization technology. Learn To: Plan infrastructure consolidation using zone. Configure nonglobal zones including: solaris native zones, solaris10 zones, and kernel zones. Administer zones. Migrate global and nonglobal zones. Manage zone resources including: CPUs, memory, networks, and storage. Optimize zones. Troubleshoot zone problems. Benefits to You By taking this course, you'll get a chance to examine various aspects of planning for implementing server virtualization in an enterprise environment. Throughout the course, you'll practice server virtualization by performing a series of guided hands-on labs that walk you through the critical tasks associated with server and network virtualization activities. Participate in Hands-On Labs These labs include case studies that showcase best practices when deploying Oracle Solaris Zones server virtualization technology. This course does not address system virtualization related tasks specific to Solaris 10 (or other) operating systems. Rather, it focuses on thevirtualization technology as implemented in the Oracle Solaris 11 operating system. Required Prerequisite Knowledge This course is intended for IT architects and system administrators who are responsible for planning and performing server virtualization tasks in the datacenter. It assumes you already have the skills and knowledge necessary to administer Oracle Solaris 11.

Oracle Solaris 11 is the first and only fully virtualized operating system proving fast and secure deployment of services in a large-scale cloud environment. Learn about the new features and functionality of Oracle Solaris 11 and how these new features and improvements will make it easier to deploy services to the enterprise. Learn To: Implement the new packaging system. Use the default file system, ZFS. Improve your data management capabilities. Deliver fully virtualized networking. Use the advanced user, application and device security. Work with an operating system that improves performance and reduces total cost of ownership. Learn from Expert Oracle University Instructors When you enroll in this course, you'll get the chance to learn from Oracle University experts who know Solaris 11 inside and out. Through a combination of instruction and hands-on exercises, you'll develop your Solaris 11 expertise to improve how your organization manages data.

The Transition to Oracle Solaris 11 training builds on your system administration experience with Oracle Solaris 10 and teaches you the skills and knowledge to transition from Oracle Solaris 10 to Oracle Solaris 11. It's ideal for system administrators who have experience with Oracle Solaris 10 and IT architects responsible for planning and performing transitioning tasks. Learn To: Examine various aspects of planning for the transition from Oracle Solaris 10 to Oracle Solaris 11. Understand the new features delivered with Oracle Solaris 11 including Automated Installer (AI), Image Packaging System (IPS), and network virtualization. Describe and use new features introduced in Oracle Solaris 11.3. Practice transitioning to the Oracle Solaris 11 operating environment by performing a series of guided hands-on labs. Benefits to You The System Administrator will benefit from this course because they will be exposed to the new features delivered with Oracle Solaris 11.3 including verified boot for Kernel Zones, Kernel Zones live migration for SPARC, virtualized clocks for zones, first boot service creation tool, secure live migration, and non-root live migration. Operating System Migration Activities You'll engage in lab exercises that will walk you through critical tasks associated with operating system migration activities. These labs include case studies that showcase best practices when transitioning from Oracle Solaris 10 to Oracle Solaris 11. Throughout the course, you'll transition to the Oracle Solaris 11 operating environment by performing a series of guided hands-on labs that walk you through critical tasks associated with operating system activities. Don't Have Oracle Solaris 10 System Administration Experience? You should consider taking the Oracle Solaris 11 System Administration course followed by the Oracle Solaris 11 Advanced System Administration course. There are a number of new technologies that were introduced in Oracle Solaris 10 which teach you expected prerequisite knowledge you should have before taking this course. Without skills in those areas, you may not be able to keep pace with the course; this course takes you through rapid, in-depth coverage of Oracle Solaris 11 technologies and builds on your Oracle Solaris 10 knowledge.

The Shell Programming course provides students with the skills to read, write, and debug UNIX shell scripts. The course begins by describing simple scripts to automate frequently executed commands and continues further by describing conditional logic, user interaction, loops, menus, traps, and functions. This course is intended for system administrators who have mastered the basics of any flavor of the UNIX OS, such as Oracle Solaris and Oracle Linux, and would like to interpret the various boot scripts as well as create their own scripts to automate their day-to-day tasks. Learn To: Create scripts to automate system administration tasks. Set local and environmental variables. Automate tasks by using regular expression characters with the grep, sed, and nawk utilities. Create interactive scripts by using flow control constructs. Perform string manipulation and integer arithmetic on shell variables. Debug errors in scripts.

The Perl Programming course is a comprehensive course that explains the Perl programming language, from basic through advanced syntax. This course is aimed at a wide range of job roles, including Programmers, System Administrators, Web Authors, and Operators. The course provides the fundamentals needed to use the Perl programming language to write quick yet powerful scripts for a range of purposes, as well as provides an overview of Common Gateway Interface Programming, Object-Oriented Perl and Perl Debugging. The course is taught on the Oracle Solaris Operating Environment. However, the material is suitable for any operating system, including Linux, UNIX, and Windows. Learn To: Describe the Perl Programming Language. Implement Scalars. List Control Structures. Implement Arrays. Describe Hashes. Implement Basic I/O and Regular Expressions. Describe Subroutines and Modules. Manipulate Files and Directories. Implement Perl. Benefits To You The Perl Programming course provides students with the fundamentals to create functional Perl scripts. The course introduces students to data structures, flow control mechanisms, regular expressions, and subroutines and modules in the form of example scripts and lab scripts. The course concludes with an overview of implementing Perl with regard to Common Gateway Interface (CGI) Programming, Object-Oriented Perl and Perl Debugging. This course however, does not cover the construct of the Perl Programming Language itself or complex Perl functions used for high-level programming. Rather, it focuses mainly on the implementation of the language to create simple and functional Perl scripts.

The Oracle Solaris Containers Administration course offers a practical, guided experience working with Oracle Solaris Containers, the Oracle virtualization feature comprised of Oracle Solaris Zones and Oracle Solaris Resource Controls. Containers are used to create isolated environments for running applications, and enable server consolidation with low overhead. In this course, you gain the knowledge critical to properly implement and manage these important capabilities in the Oracle Solaris Operating System. The hands-on practice exercises offered in this course involve accessing equipment that resides at a location other than where the training is delivered. Learn To: Configure Zones Install Zones Administer Zones Configure Zone file systems and networking Configure Migrate Zones Administer packages and patches within Zones

The Oracle Solaris Cluster 4.x Administration Ed 4 course provides students with the essential information and skills needed to install and administer Oracle Solaris Cluster 4.3 hardware and software systems. Students are introduced to Oracle Solaris Cluster 4.3 hardware and software product features, hardware configuration, software installation along with configuration, data service configuration, and system operation. Students will get the opportunity to explore various use cases such as integrating Oracle database 12c as failover application, configuring Oracle Solaris cluster using unified archives. Learn To: Describe Oracle Solaris Cluster hardware and software. Establish Cluster node console connectivity. Prepare for the Oracle Solaris Cluster installation. Configure the Oracle Solaris Cluster software. Configure Oracle Solaris Cluster quorum devices and device fencing. Use Cluster commands to administer global properties, quorum, disk paths, and interconnect components. Configure volume management with ZFS and Solaris Volume Manager. Manage the public network with IPMP and link aggregation. Describe resources and resource groups, configure a failover data service resource group (Network File System [NFS]), and configure a scalable data service resource group (Apache), Advanced Resource Group Relationships. Configure solaris10 branded zone, kernel zones, build zone clusters, migrate scalable application from global zone to zone cluster. Explore Oracle Solaris Cluster use cases. Benefits to You This course provides an intensive hands-on experience for key system administration tasks aimed at giving students experience installing, configuring, and managing an Oracle Solaris Cluster 4.3 environment. Students will get the opportunity to explore various use cases integrating Oracle database 12c as failover application, configuring Oracle Solaris cluster using unified archives.

This Oracle Solaris 11 ZFS Administration training expands your mastery of the ZFS facilities management in the Oracle Solaris 11 operating system. You are presented with complex and integrated ZFS administration concepts that are supported by an intensive hands-on experience. Learn To: Manage the ZFS root pool. Manage ZFS pools and data sets. Provision remote storage clients. Backup and restore ZFS pools and data sets. Migrate ZFS data sets to other systems. Protect your ZFS-based data. Monitor, tune and troubleshoot ZFS environment. Benefits to You By taking this course, system administrators will learn how to get the most out of ZFS on your systems. You'll walk away with the ability to use ZFS with other technologies; you'll also know how to use ZFS to fulfill business needs by following the example of the fictional company presented within the course. Explore Advanced Technologies This course highlights an array of advanced subjects and technologies. These include managing the ZFS root pool, protecting data using ZFS access control lists and implementing the ZFS delegated administration model.

The Oracle Solaris 11 System Administration for Experienced UNIX/Linux Administrators course is for skilled AIX/Linux/HP-UX administrators who need to make informed decisions as they adopt, deploy, and administer Oracle Solaris 11 in their data centers. The course is extensively built around a hands-on experience, meant to impart application-level skills and knowledge to successfully administer Oracle Solaris 11. Learn To: Understand the merits of using some of the key features and technologies of Oracle Solaris 11. Manage system software by using IPS. Administer services using SMF. Administer file systems using ZFS. Implement network virtualization using VNICS and etherstubs. Implement operating system virtualization using Oracle Solaris Zones. Benefits to You Oracle Solaris 11 provides the most robust environment for your data center with best in class reliability and scalability. Lab exercises show how to use advanced features such as scalable data management, built-in virtualization, and fully integrated security to get the most from your Oracle Solaris 11 deployment.

The Oracle Solaris 11 Network Administration course provides students with the knowledge and skills necessary to configure and administer a reliable, scalable, highly available, resource-optimized, and secure enterprise-grade network infrastructure, both physical and virtual, by using the various networking features and technologies in Oracle Solaris 11. Some of the key features of Software Defined Networking (SDN) covered in this course include VNICs, etherstub, VLAN, PVLAN, VXLAN, EVS, and reflective relay. Learn To: Explain the fundamentals of networking. Configure a virtual network. Configure network high availability. Configure network services. Configure network resources. Implement network security. Diagnose networking issues. Benefits To You This course uses extensive hands-on approach to explain the networking capabilities introduced, enhanced, or modified in Oracle Solaris 11. Through scenarios and illustrations, the course explains how the network virtualization features and technologies in Oracle Solaris 11 make a good case for network consolidation, geographies notwithstanding. The course also covers some of the observability tools used for diagnosing and troubleshooting networking issues.

No hands-on lab environment for TOD course medium The Oracle Solaris 11 Fault Analysis and Troubleshooting course are designed to teach intermediate-level system administrators on how to troubleshoot problems. Learn To: Use various troubleshooting techniques and tools to analyze and resolve system faults Troubleshoot problems with booting a SPARC-based system Troubleshoot problems with IPS and AI Troubleshoot physical and virtual network issues Troubleshoot problems with zones Benefits To You System administrators will benefit from this course because they are exposed to the types of problems they encounter on the job and given the opportunity to resolve these problems with little to no guidance using the techniques and tools they are presented within the class. Given a "safe" training environment in which to work through a multitude of system faults, system administrators will leave the course confident in their ability to troubleshoot all areas of the Oracle Solaris 11 operating system. Hands On Experience The Oracle Solaris 11 Fault Analysis and Troubleshooting course is designed to teach intermediate-level system administrators on how to troubleshoot problems. With extensive hands-on labs taught on SPARC hardware, this course provides system administrators the in-depth experience they need to quickly and expertly troubleshoot a wide-range of system faults. Note: This course does not address performance management issues. These issues are addressed in the Oracle Solaris 11 Performance Management course. This course does not go deeply into ZFS, DTrace, or Core and Crash dump analysis. These issues are addressed in other Oracle Solaris course offerings.

This Oracle Solaris 11 Dynamic Tracing training is designed for advanced system administrators, application or kernel developers, and software support personal that can use DTrace to diagnose applications and system problems. The course introduces students to the DTrace technology along with the various system observability tools, such as sar, vmstat, mpstat, iostat, netstat, prstat, kstat, and procfs to identify issues. In addition, the course also covers creating custom D scripts, best practices of using DTrace, and a few case studies around using DTrace to solve issues. Learn To: Describe Dynamic Tracing. Create DTrace Scripts to Collect System Information. Trace User Applications with DTrace. Perform Anonymous and Speculative Tracing in DTrace. Apply Best Practices for Using DTrace. Benefits To You The Oracle Solaris 11 Dynamic Tracing course provides you with the ability to use DTrace to diagnose application and system problems. You first learn about the basic topics, such as DTrace features and architecture, and then move to advanced topics, such as creating DTrace scripts to collect system information, tracing user applications, performing anonymous and speculative tracing, and applying best practices for using DTrace scripts.

This OpenStack Administration Using Oracle Solaris 11 training is an advanced course offering that encompasses multiple Oracle technologies (Oracle Solaris 11.3, and Oracle VirtualBox). Expert Oracle University instructors focus on helping you develop the skills and knowledge required for configuring Infrastructure as a Service (IaaS) using OpenStack with Oracle Solaris 11. Learn To: Describe the OpenStack Framework. Configure a Single-Node OpenStack setup. Configure a Multi-Node OpenStack setup. Administer identity resources. Administer system resources. Troubleshoot OpenStack. Benefits to You By taking this course, you'll reap the benefits of participating in a series of guided hands-on labs that walk you through the full spectrum of OpenStack functionalities. You'll gain hands-on, real-world experience configuring and administering single and multiple node OpenStack setups. These labs are designed around scenarios to enhance the learning experience of setting up the cloud infrastructure using OpenStack with Oracle Solaris 11. Please Note This course is intended for experienced Oracle Solaris system administrators responsible for planning and administering cloud infrastructures in a virtualized datacenter. It was developed using OpenStack Juno release covering the OpenStack implementation in Oracle Solaris 11.3.

This Managing Oracle Database on Oracle Solaris 11 Ed 1 training teaches DBAs how to optimally configure an Oracle Solaris 11 environment. It's specially designed for Database Administrators running their database applications on Oracle Solaris 11. Learn To: Plan for an Oracle Database deployment on Oracle Solaris 11. Configure Oracle Solaris 11 Facilities to use with Oracle Database. Virtualize Database instances. Configure Oracle Solaris 11 Virtual Machines for an Oracle Database deployment. Troubleshoot Oracle Database on Oracle Solaris. Benefits to You By taking this course, yo'll walk away with the knowledge and skills to maximize the performance of Oracle Database 11g or Oracle Database 12c, through a combination of interactive instruction and hands-on exercises. You'll get a chance to practice database management tasks by performing a series of guided hands-on labs that walk you through the critical tasks in Oracle Solaris 11 associated with database installation, optimization and management.

Oracle Solaris Security provides enterprise-class features to help you protect your applications and your data. Security Administrators can minimize and harden Oracle Solaris to implement a secure foundation for deploying services. The Configuring Security on the Solaris 10 Operating System course provides students with the knowledge and skills to implement these features and customize security on Oracle Solaris 10 systems.