Oracle

This Oracle Database 12c: Use XML DB training allows you to deep dive into the key features of Oracle XML DB. Through interactive instructions and hands-on exercises, expert Oracle University instructors will teach you how to use Oracle XML DB to store, access, manipulate, validate, search, update, annotate, transform, generate, import and export XML data. Learn To: Manage XML storage in Oracle XML DB. Retrieve XML data in Oracle XML DB. Create and use indexes on XML data. Generate and manipulate XML in Oracle XML DB. Use the Oracle XML DB Repository. Manage changes in an XML schema. Import and export XML data. Update XML content using XQuery update. Search XML content using XQuery Full-Text search.

This course introduces students to Oracle XML DB, a feature of the Oracle Database. Students learn to store, retrieve, generate, and manipulate XML data in Oracle Database 11g. Students learn about the different storage models for storing XML documents in Oracle XML DB. Students query XMLType data by using SQL/XML standard functions and XQuery. Students generate and manipulate XML data and learn to use Oracle XML DB Repository. In addition, students access and manipulate repository resources using protocols such as SQL, and PL/SQL. Students learn to manage changes in an XML schema after registering it with Oracle XML DB. Students also learn how to import and export XML data. Oracle SQL Developer is the major development tool in this course. SQL*Plus is also available as an optional tool. Learn To: Store and retrieve XML Data in Oracle XML DB Generate XML Data from relational data in the database Use XQuery to query, generate, and transform XML data Manipulate XML Data in Oracle XML DB Use Oracle XML DB Repository Export and Import XMLType Data

This XML Fundamentals training introduces you to the basics of XML. In this 2 day hands on course, you will learn the central XML technologies, including writing well formed and valid XML, creating Document Type Definitions (DTDs) and XML schema documents and using XPath and XQuery. Learn To: Create well-formed and valid XML documents. Use XML Namespaces in an XML document to resolve name ambiguities in XML documents. Create Document Type Definition and XML schema documents to validate XML documents. Use XPath expressions and functions to find and select nodes in XML documents. Transform XML documents by using stylesheets and XPath expressions. Use Oracle JDeveloper to view, create, edit, and test XML and other XML-related documents. Use XQuery to query, generate, and transform XML content. Identify the features and benefits of Oracle XML DB

Oracle WebLogic Server is a Java EE application environment that supports the deployment of mission critical applications using a robust, secure and scalable infrastructure. System administration of WebLogic Server includes a wide range of activities, from creating and configuring server domains, to deploying and securing applications, to monitoring and troubleshooting server, application and performance issues. In this course, students expand upon their basic administrative knowledge and experience, and learn more sophisticated techniques for working with WebLogic Server and integrating it within the rest of their enterprise. Particular attention is paid to the topics of authentication, enterprise messaging, clustering and performance. This course also covers some basic techniques for monitoring server health and for troubleshooting problems. Students continue to use tools such as the WebLogic Server Administration Console and WebLogic Server Scripting Tool (WLST) for performing these administration tasks. An appendix is included covering the differences between the 11g (10.3.3) and 12c (12.1.1) product versions with regard to Oracle WebLogic Server administration topics. Learn To Manage domains and templates Configure a highly available messaging infrastructure Automate server migration and failover Utilize LDAP for authentication Monitor servers using WLDF or SNMP This course is an upgrade of Oracle WebLogic Server 10g R3: Advanced System Administration.

This Oracle WebLogic Server 11g: Administration Essentials training teaches Web administrators techniques for installing and configuring Oracle WebLogic Server 11g. Expert Oracle University instructors will teach you how to deploy Java EE applications to Oracle WebLogic Server 11g using Administration Console and command-line and scripting tools like WLST. Learn How To: Describe the architecture of WebLogic Server including domains, servers and machines. Install, configure and use WebLogic Server. Perform routine Oracle WebLogic Server administration functions. Set up a cluster of servers and distribute applications and resources to the cluster. Configure Oracle HTTP Server as the Web-tier front end for Oracle WebLogic Server instances and clusters. Deploy different types of Java EE applications to Oracle WebLogic Server. Increase the performance and scalability of your organization’s applications and services with the #1 application server. Simplify deployment and significantly improve time-to-market. Configure Oracle HTTP Server You'll also learn to configure Oracle HTTP Server as the Web interface for Oracle WebLogic Server, along with supporting failover and load balancing for applications. Overview of Administrative Tasks This course provides an overview of the administrative tasks performed by a WebLogic Server administrator. At the end of the course, you will have gained knowledge at an associate level of competency. Appendix An appendix is included covering the differences between the 11g (10.3.3) and 12c (12.1.1) product versions with regard to Oracle WebLogic Server administration topics. The follow up Oracle WebLogic Server 11g: Advanced Administration course provides a more in depth coverage of administration tasks. This course is an upgrade of Oracle WebLogic Server 10g R3: System Administration.

Enterprise Manager Cloud Control provides a central, consolidated and intelligent IT management infrastructure across all application tiers. The WebLogic Server Management Pack enables Cloud Control users to monitor, manage, and troubleshoot WebLogic Server environments. WebLogic Server: Enterprise Manager Management Pack shows you how to integrate Cloud Control with the management life cycle of your WebLogic applications while adopting Oracle's best practices. Learn To: Use Cloud Control to monitor WebLogic servers and applications Use Cloud Control to administer WebLogic domains and deploy applications Use Cloud Control to clone and scale WebLogic environments Use Cloud Control to track and compare WebLogic configurations Use Cloud Control to analyze JVM and WebLogic diagnostics Taking this course will teach you how to more effectively manage your WebLogic environments. After you take this course, you will have the skills to keep track of server availability, key performance indicators, configuration changes, and patches. You will also learn how streamline general application lifecycle activities such as scale out, cloning, and application provisioning. Central Monitoring and Administration Discover multiple WebLogic deployments and monitor their availability and performance from a single interface. Maintain your domain configurations and ensure that they comply with Oracle and custom IT policies. Provisioning and Scaling Instantiate a new WebLogic domain from a standard profile or clone an existing domain. Quickly scale up or out an existing domain to adapt to larger workloads. Diagnostics Use both real time and historical metrics to troubleshoot JVM or server issues and get advice on the root cause of common WebLogic problems.

This Oracle WebLogic Server 12c: Performance Tuning Workshop teaches you how to monitor the effects of a running Oracle WebLogic Server application on the overall system. Expert instructors will teach you through interactive instruction, walking you through new concepts, and diving into real-world applications. Learn how to: Describe a typical performance methodology. Use a load-testing tool such as the Grinder. Use command-line and graphical tools such as jps, jcmd, Java VisualVM, Mission Control, and Flight Recorder. Generate and analyze performance data. Tune operating system resources. Tune Java Virtual Machine (JVM) and Oracle WebLogic Server parameters. Benefits to You Taking this course will help you develop the skills to increase the performance and scalability of your organization’s applications and services with the Oracle WebLogic Server -- the world's #1 application server. You'll learn how to simplify deployment and significantly improve time-to-market. Tune the System This training teaches you how to tune the system at different levels to ensure that applications run smoothly without overtaxing available resources. In addition, walk away with an understanding of how performance-test data is generated, gathered, analyzed, and saved. Identify Performance Differences Finally, you'll learn how to use a combination of tools to examine system resource, Java Virtual Machine, and Oracle WebLogic Server runtime metrics so that you can identify performance differences before and after configuration changes. You'll also practice analyzing these differences to determine the settings that optimize application performance.

This Oracle WebLogic Server 12c: Troubleshooting Workshop training teaches administrators how to diagnose and troubleshoot Oracle WebLogic Server 12c problems and issues. Emphasizing hands-on practices rather than lectures, the course requires prior WebLogic Server 12c administration experience. Learn How To: Diagnose WebLogic Server problems. Enable debugging for a WebLogic Server feature. Troubleshoot common WebLogic Server problems. Knowing how to diagnose and troubleshoot Oracle WebLogic Server issues increases the performance and scalability of your organization’s applications and services. Use Troubleshooting Tool. You learn how to use tools to assist in troubleshooting, including the WebLogic Server Administration Console, the Monitoring Dashboard, and the WebLogic Diagnostic Framework. In hands-on practices, you solidify your understanding of new topics by learning how to apply this knowledge to your daily job. Practice Troubleshooting Problems Enrolling in this course gives you a chance to practice troubleshooting problems. You'll use Oracle WebLogic server itself, along with the Java Virtual Machine, deployment of Java Enterprise Edition applications, Java Database Connectivity, Node Manager, WebLogic Server clusters, and WebLogic Server security.

This Oracle WebLogic Server 12c: JMS Administration training shows you how to configure, manage, and monitor WebLogic JMS resources according to proven best practices. Interact with expert Oracle University instructors through a combination of instruction and hands-on exercises that will reinforce your learning. Learn How To: Configure JMS servers and destinations. Configure JMS high availability. Migrate messages from a failed server. Monitor and tune JMS performance. JMS Clustering and High Availability. Troubleshoot JMS problems. Investigate, identify and fix common JMS issues with the help of a variety of tools. Introduce JMS Security. Increase the performance and scalability of your organization´s applications and services with the #1 application server. Simplify deployment and significantly improve time-to-market. High Availability This course will also teach you how to configure your WebLogic environment to provide load balancing and failover for JMS resources. You'll learn how to identify when to use configured and dynamic clusters for JMS. Furthermore, you'll develop the knowledge and skills to move JMS resources across servers in your cluster in response to a server failure or during scheduled server maintenance.

This Oracle WebLogic Server 12c: Administration I 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 Deploy share libraries and associated 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.

This Oracle WebLogic Server 12c: Administration I 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.

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections. Learn To: Apply PL/SQL designing best practices. Create PL/SQL applications that use collections. Work with JSON data in the database. Implement a virtual private database with fine-grained access control. Write code to interface with external C and Java applications. Write code to interface with large objects and use SecureFile LOBs. Write and tune PL/SQL code effectively to maximize performance.

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code. Learn To: Use various features of PL/SQL. Write anonymous blocks of code in PL/SQL. Use various PL/SQL conditional constructs and loops in program blocks. Interface the PL/SQL code with the database. Use stored procedures and functions in their program blocks. Handle Exceptions in PL/SQL code.

This Oracle Database 12c: 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. Learn this and more through hands-on exercises. Learn To: Understand the basic concepts of relational databases ensure refined code by developers. Create reports of sorted and restricted data. Run data manipulation statements (DML). Control database access to specific objects. Manage schema objects. Manage objects with data dictionary views. Retrieve row and column data from tables. Control privileges at the object and system level. Create indexes and constraints; alter existing schema objects. Create and query external tables.

This course is designed for developers with basic PL/SQL and SQL language skills. Students learn to develop, execute, and manage PL/SQL stored program units such as procedures, functions, packages, and database triggers. Students also learn to manage, PL/SQL subprograms and triggers. Learn To: Create, and execute stored procedures and functions. Design and use PL/SQL packages. Create overloaded package subprograms for more flexibility. Utilize Oracle-Supplied Packages in Application Development. Create triggers to solve business challenges. Build and execute SQL statements dynamically.

This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you’ll learn to develop stored procedures, functions, packages and more. Learn To: Conditionally control code flow (loops, control structures). Create stored procedures and functions. Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screen output and file output. Create custom packages for applications. Write Dynamic SQL code for applications.

The Oracle Database: SQL Workshop I Ed 2 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.

This Oracle Database: SQL and PL/SQL Fundamentals training delivers the fundamentals of SQL and PL/SQL along with the benefits of the programming languages using Oracle Database technology. You'll explore the concepts of relational databases. Learn To: Write queries against single and multiple tables, manipulate data in tables and create database objects.  Use single row functions to customize output. Invoke conversion functions and conditional expressions. Use group functions to report aggregated data. Create PL/SQL blocks of application code that can be shared by multiple forms, reports and data management applications. Develop anonymous PL/SQL blocks, stored procedures and functions. Declare identifiers and trap exceptions. Use DML statements to manage data. Use DDL statements to manage database objects.  Declare PL/SQL Variables. Conditionally control code flow (loops, control structures). Describe stored procedures and functions. Retrieve row and column data from tables.