Oracle

This course is designed to provide you with a firm foundation in administration of an Oracle database. In this course you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner. This course provides detailed information on the architecture of an Oracle Database instance and database, enabling you to effectively manage your database resources. You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. Basic information on backup and recovery techniques is presented in this course. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.

This Oracle Application Express Workshop II Ed 2 training will build on the knowledge learned in the 5-day Oracle Application Express Workshop I course. You’ll examine topics that including learning how to use collections, add dynamic actions, create and customize plug-ins, and create and consume a RESTful Web Service. Learn To: Extend Your applications using collections, dynamic application and plug-ins. Create and use RESTful Web Services. Make your application accessible. Customize themes and templates. Establish a master application and corporate theme that many applications can use. Migrate an existing application to a new theme. Incorporate a jQueryUI ThemeRoller theme into your mobile application. Secure, deploy and maintain your applications. Optimize your application performance.

This Oracle Application Express Workshop I Ed 2 training teaches you how to quickly and efficiently develop database-centric web applications using Oracle Application Express. Explore implementing security in your applications, managing application navigation, basic validation and debugging techniques used while developing an application in Oracle Application Express. Learn To: Create database applications for both desktop and mobile interfaces. Add various components like new pages, reports regions, items and other components required to enhance an application. Create processes, validations, computations and dynamic actions within an application. Change the look and feel of your web applications using built-in themes and templates. Create and use shared components for an application. Understand managing and using session state variables. Implement security in an application. Manage application navigation using shared components. Improvise your application by creating calendars, charts and trees. Extend your application by adding advanced features like printing, BLOB object, data loading, site and more. Enable feedback mechanisms from the application and tracking the feedback from Oracle APEX.

The MySQL for Database Administrators course teaches DBAs and other database professionals how to maximize their organization’s investment in MySQL and about the benefits of using the MySQL Cloud Service. Learn to configure the MySQL Server, set up replication and security, perform database backups, optimize query performance, and ensure high availability. Through a variety of realistic, hands-on activities, expert MySQL instructors will teach you to install, configure, secure, and maintain your database server which you can deploy on-premise or as a MySQL Cloud Service instance. Learn To: Install and configure MySQL Server and client programs. Recognize the key components of the MySQL architecture. Secure your server. Troubleshoot server slowdowns and other issues. Improve query performance. Configure and administer a variety of replication topologies. Understand the benefits of MySQL Cloud.

The MySQL Performance Tuning course teaches you how to tune MySQL for optimal performance. You will learn best practices for configuring, monitoring, and troubleshooting your server, databases and queries using a range of tools. Learn To: Understand performance tuning concepts. Benchmark your MySQL server. Tune MySQL server settings. Investigate performance metrics with a range of system databases, command-line and graphical tools. Design your databases for optimal performance. Optimize slow queries. Troubleshoot common performance problems. Scale your hardware and application environment as your database grows.

The MySQL for Developers training course teaches developers you how to develop console and web applications using MySQL with your choice of the PHP, Java, or Python programming languages. Expert Oracle University instructors will guide you through realistic hands-on activities in which you will learn how to use Connectors to access MySQL databases, query the database effectively, present data in different formats, and how to use MySQL's support for JSON and spatial data. Learn to:  Program with Connectors  Write console and web applications  Optimize query performance  Write stored routines and triggers  Store, access, and analyze geospatial data  Use X DevAPI to access JSON data in document store

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster’s open-source and enterprise components. Learn To: Install and configure MySQL Cluster nodes. Design simple and advanced cluster topologies. Secure cluster nodes and data. Backup and restore cluster data. Troubleshoot common cluster problems. Monitor and optimize cluster performance. Use enterprise tools to manage large cluster deployments.

The MySQL for Database Administrators enables DBAs and other database professionals to maximize their organization's investment in MySQL. Learn to configure the MySQL Server, set up replication and security, perform database backups and recoveries, optimize query performance, and configure for high availability.  Install and configure MySQL Server and client programs  Recognize the key components of the MySQL architecture  Manage user accounts and secure your server  Troubleshoot server slowdowns and other issues  Backup and recover MySQL database  Configure and administer a variety of replication topologies

The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service. Learn To: Explain the relational database model. Describe the features and benefits of MySQL. Install and configure the MySQL server and clients. Design efficient databases. Use Structured Query Language (SQL) to build your database and query data. Employ appropriate MySQL tools. Gain an understanding on the MySQL Cloud Service.

The Java SE 7: Develop Rich Client Applications training takes you through the process of designing a rich client application using Java SE 7 and Java FX 2. Using the Model-View-Controller (MVC) pattern and a case study approach, you’ll learn to analyze, design and develop the user interface, connect the user interface to a database and finally connect the user interface to a RESTful web service. Learn To: Create a graphical user interface using Java FX. Connect a Java FX GUI to database using JPA. Connect a Java FX GUI to a RESTful web service. Package and deploy a Java FX application. Sign a Java FX application. connect their application to a RESTful web service using JAX-RS and the Jersey API.

This Object-Oriented Analysis and Design Using UML training teaches you how to effectively use object-oriented technologies and software modeling as applied to a software development process. Expert Oracle University instructors present one practical, complete, object-oriented analysis and design (OOAD) road map from requirements gathering to system design. Learn To: Use object-oriented technologies. Use Unified Modeling Language 2.2. Perform object-oriented analysis and design. Follow a software development process using an OO software project. Create a system design (the Solution model) supporting the functional requirements (FRs).

This Java SE 8 Programming training covers the core language features and Application Programming Interfaces (API) you will use to design object-oriented applications with Java Standard Edition 8 (Java SE 8) Platform. Learn To: Create Java technology applications with the latest JDK Technology Develop your object-oriented skills Identify good practices in the use of the language to create robust Java application Use Lambda expressions in Java applications Store and manipulate data using collections Manipulate files, directories and file systems Connect to databases using standard SQL queries through JDBC Create high-performance multi-threaded applications

This Java Performance Tuning with Mission Control and Flight Recorder training helps you build a conceptual background for Java garbage collection. Expert Oracle University instructors will teach you how it it applies to Java garbage collectors on the Hotspot JVM, including the new G1 garbage collector. Learn To: Monitor, profile and tune your Java applications. Use command line and visual tools to perform these tasks. Get hands on practice with Visual VM, Java Mission Control, Flight Recorder and the NetBeans IDE. Use these tools and techniques to analyze Java 7 and earlier JVMs. Effectively apply tools like Java Mission Control and Flight Recorder to your daily work.

This Java SE 7 Fundamentals training teaches students with little or no programming experience to begin to learn to program 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.

This Java Performance Tuning and Optimization training will teach you about performance tuning methodologies, performance tuning theories and practical tips to solve difficult performance problems for Java applications. Expert Oracle University instructors will help you expand your skills during a series of labs derived from real world performance tuning issues. Learn To: Set up a performance tuning environment. Tune the performance of a Java application at the language level. Monitor Java applications. Apply rigor to the task of performance tuning. Use various tools and mechanisms for monitoring, profiling and tuning Java applications. Apply best practices for performance testing. Tune garbage collection in a Java application.

This JavaScript and HTML5 course features the JavaScript language, from language fundamentals to dynamic interactions with browsers, DOM, HTML5, CSS3, JSON, REST, AJAX, WebSocket, and jQuery. This course includes several demos for the student to hack in each lesson. This JavaScript and HTML5 course teaches you how to code application logic in web applications using JavaScript and how to create HTML5 pages to parse and send data using HTML5 forms. Create and modify the Document Object Model(DOM), create responsive layouts with CSS3, store local data with JSON, and draw on HTML5 canvas. Students will add interactive behaviors to web pages creating better user experiences and add dynamic data using AJAX, REST and WebSocket with JavaScript.  Learn To: Code application logic using JavaScript to control user interactions and display data. Create applications with HTML5 forms to send data to services. Debug and inspect web applications and styles using browser's tools. Create design templates and standards using CSS and JavaScript that adapt to different devices including mobile with Media Queries and Responsive Design. Read and validate data from HTML5 forms using JavaScript. Parse, modify, and validate data using Javascript API. Add interactivity in HTML5 forms using events and DOM modification. Store and send JavaScript Object data to services, local storage or across different pages and HTML5 elements using JavaScript Object Notation. Draw on HTML5 canvas using JavaScript. Store user data in web applications using HTML5 Local Storage Create JavaScript code to retrieve and display dynamic data from REST services using AJAX. Create JavaScript code to interact with WebSocket for real-time communication. Create jQuery code to animate elements, handle DOM, events, or AJAX responses. Benefits to You This course will prepare any web developer with enough JavaScript, HTML5 and CSS3 knowledge to build complex and modern sites and for those looking to develop Java EE front-end web applications.

The Java SE: Exploiting Modularity and Other New Features course introduces the Java module system and other recent features that are carried forward to Java SE 11, including JShell, convenience methods, new techniques for working with streams, and managing deprecated APIs. Java SE: Exploiting Modularity and Other New Features introduces the Java module system and other new features, including JShell, convenience methods, new techniques for working with streams, and managing deprecated APIs. These features were introduced in versions after Java 8, and therefore new to developers migrating to Java 11.  Learn To: Design applications to take advantage of the module system and its more reliable configuration, improved security and performance, and more easily scalable applications. Migrate existing applications to a modular applications in a step-by-step manner, choosing which parts of the application to migrate first. Deal with common problems encountered in migrating an application, including, cyclic dependencies and split packages. Use services to make modularized applications more robust and easily extensible. Create multi-release JAR files that can be run on different Java releases. Use convenience methods to reduce code that seems verbose, inefficient or boilerplate, and increase readability. Use JShell to quickly run small code experiments and test new APIs. Benefits To You: By enrolling in this course, you'll learn how to use the module system to design applications with explicit dependencies and encapsulation at the JAR level, ensuring more reliable configuration, improved security and enhanced performance. You'll also get a chance to experiment with new features that ease development. These include convenience methods that make your code more readable and succinct, and JShell, an easy way to test code snippets and APIs.

This Java Design Patterns training reviews common patterns specific to Java SDK & EE development. Lab exercises teach you to identify, apply and re-factor these patterns into code, using a NetBeans or Eclipse IDE and the GlassFish Application Server v3. This Java Patterns course reviews common and emerging patterns specific to Java SDK and EE development. You'll learn the depth and evolution of pattern-based techniques in Java, with particular emphasis on Java EE 6 conventions. Learn To: Dinstinguish between Java EE 5 and Java EE 6 pattern-based features. Implement relevant patterns in each tier of the Java EE environment. Re-factor code to improve inter-tier communications. Relate pattern-based development to an implementation architecture. Apply object-oriented pronciples and design guidelines. Implement well-known patterns to Java-specific code problems. Lab Exercises The lab exercises show you how to identify, apply and re-factor selected patterns into code, using a NetBeans or Eclipse IDE and the GlassFish Application Server v3. You'll also learn a subset of UML notation to expedite communicating through design instead of code. Java Design Patterns In design patterns, the responsibility of each component is identified by role. The conventions of design pattern documentation make it easier for development teams to communicate their programming intentions and provide a reference point for the entire Java development community. Java-Based Frameworks The Java language and popular Java-based frameworks incorporate more proven development practices into their programming interfaces with each major release. These practices, referred to as design patterns, document well-known names, code implementation and re-factoring techniques, and the risks and trade-offs associated with using them.