Oracle Autonomous Database Workshop training course is designed for developers, administrators, architects and anyone who wants to learn about the first Autonomous Database in the market. In this course, you will be taught how to provision an Oracle Autonomous Database Cloud Service instance on Oracle Cloud that is suitable for your workload and requirements.
-
Learn to write well-tuned SQL statements for the Oracle database.
This Oracle Database course teaches you how to write well-tuned SQL statements appropriate for the Oracle database. This Oracle SQL Tuning for Developers Workshop will help you explore Oracle SQL statement tuning.
MySQL Cloud Service provides numerous benefits over an on-premise database. It is easy to create a cloud instance, with flexible options for computing power, memory, and storage. GUI tools are available for backup and restore as well as patching and rolling back. After completing this course, you can take advantage of those benefits to use MySQL Cloud Service to its best advantage.
-
The Oracle Database 19c: Data Warehousing Techniques course teaches you the various Data Warehousing concepts and techniques related to data extraction, transformation, and loading phases. You will learn about the different changed data capture methods for data refresh, and how to define summary management and implement materialized views. You will also learn about the role of warehouse metadata along with the various data warehouse implementation considerations.
-
The nature of leadership has changed over the period. The longstanding top-down, command & control leadership style is not successful in the current and adaptive work environment. These environments require a paradigm shift in leaders and their understanding of what constitutes effective leadership.
This set of Learning Outcomes focuses on developing leaders who are adaptive and agile in their leadership style.
Leaders learn to lead themselves first and create an environment that will allow agility to thrive. In this two-day Agile leadership training, participants learn why we need enterprise agility, the vital personal competencies to lead the transformation, and the organizational elements required to survive and thrive in today’s turbulent environment.
-
The ICP-CAT: Enterprise Agile Coaching is the second of two knowledge-based certifications on the Enterprise Agile Coaching Track. This certification focuses on the field of Enterprise Agile Coaching, explores the core elements of an agile transformation, and links the core enterprise coaching competencies in a way that empowers coaches to act as agents of change in organizations.
The Learning Outcomes also delve into the pursuit of professional mastery and Enterprise Agile Coaching’s ethical considerations. They then look at elements central to agile transitions, such as organizational and human change processes, transformation strategies, addressing organizational impediments, and communicating, educating, and facilitating enterprises. As an advanced path, most Enterprise Agile Coaching courses involve combining classroom learning and ongoing group discussions around practical experience in the field.
-
Oracle SOL Tuning for Developers Workshop course helps you learn how plans are tuned execution of Oracle SOL statements. You will learn how to write well-tuned SOL statements out of the box that are perfectly suited to Oracle DBMS.
-
This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You’ll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.
Learn To:
- Use SQL with aggregation operators, SQL for Analysis and Reporting functions.
- Group and aggregate data using the ROLLUP and CUBE operators, the GROUPING function, Composite Columns and the concatenated Groupings.
- Analyze and report data using Ranking functions, the LAG/LEAD Functions and the PIVOT and UNPIVOT clauses.
- Perform advanced pattern matching.
- Use regular expressions to search for, match and replace strings.
- Gain an understanding of the Oracle Business Intelligence Cloud Service.
-
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.
-
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
-
The Oracle Database: SQL Workshop I Ed 3 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 course provides an overview of the Oracle Database 18c new features and enhancements related to Multitenant architecture, security, RMAN, general database areas, performance, data warehousing and Sharding.
Learn To:
- Use new features like Application PDB Fleet and PDB snapshots carousel of the Multitenant architecture.
- Understand new features like PDB keystores and encryption of sensitive data in Database Replay files of the Security.
- Benefit from new features like reuse of preplugin backups and duplication of active PDBs into an existing CDB of RMAN.
- Use new features like private temporary tables and online modification of partitioning and subpartitioning strategy of General Database.
- Configure and use new features like Automatic In-Memory Management in Performance.
- Manipulate new features like inline external tables and polymorphic table functions of the Data Warehousing.
- Understand enhancements like user-defined sharding method and support for PDBs as shards in Sharding.
-
This UNIX and Linux Essentials course is designed for users and administrators who are new to the Oracle Linux and Oracle Solaris operating systems. It will help you develop the basic UNIX skills needed to interact comfortably and confidently with the operating system.
Learn To:
- Manage files and directories from the command line and learn to use the vim editing tool.
- Perform remote connections and file transfers.
- Customize the user environment and use advanced shell features in shell scripts.
- Archive and compress files and directories.
- Understand and manage process control.
- View and modify file and directory permissions.
Benefits to You
Learn to work effectively with UNIX and Oracle Linux environments and master the fundamental administrative tasks for these operating systems. These are the first steps to ensuring fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto Oracle Cloud or private clouds.
