The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
-
-11%
Tune your databases with targeted queries and tuning methodology so you can identify problems before they arise.
Learn how to use advisors inside of an oracle database, as well as various tools provided by Oracle, in order configure the right settings for optimal performance. Gain skills in this Oracle database course to:
- use targeted query tuning and methodology to identify tuning problems in an Oracle database to take corrective action
- how to identify and tune a common database
- troubleshoot performance issues
- use advisors inside the database in order to understand in advance what settings need to be made and how to use the various tools provided by Oracle to configure the database
-
-11%
This course is targeted at Developers and Database Administrators and begins with the concepts of a relational database and the SQL programming language. It includes writing queries against single and multiple tables, manipulate data in tables, and create database objects.
You’ll also learn how to create sequences, synonyms, indexes, and views, manage schema objects, and manage data using subqueries. Additionally, the course covers controlling User Access and managing data in different time zones.
-
-11%
This course is targeted at Database Administrators and begins with explaining the architecture of an Oracle Database instance and the tools used to access it. The course includes creating and managing a database, configuring and managing Oracle Net Services along with creating and administering pluggable databases (PDBs). You learn how to create and manage database storage, users, backup, and implement database security.
Additionally, the course covers protection of database against failures, loading, and transporting data.
-
Explore the most advanced features and methods for achieving maximum performance, availability, and reliability using core database technologies and features. Learn how to leverage enhancements in multitenant architecture, manage security, use RMAN, understand general Database Administration functionality, implement big data, and more.
This OD-19c-PW: Oracle Database 19c: PL/SQL Workshop course introduces students to PL/SQL, Procedural Language for SQL. Explore the differences between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend and automate SQL.
-
The Oracle Database 19c: SQL Workshop course offers students an introduction to Oracle Database 19c database technology. 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 how to effectively manage and administer your Oracle Database.
This OD-19c-AW: Oracle Database 19c: Administration Workshop 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 Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you’ll begin to build a baseline of knowledge to propel your career in development. Learn To: Use Java programming language constructs to create a Java technology application. Use decision and looping constructs and methods to dictate program flow.
Understand basic object oriented concepts such as inheritance, encapsulation, and abstraction. Use and manipulate object references, and to write simple error handling code.Use the new SE 8 java.time and java.time.format packages to format and print the local date and time.Specify a data modification by passing a predicate lambda expression to the Collections class.
-
Architect a cloud-based infrastructure using Oracle Cloud Infrastructure services. Building on your skills obtained from the Oracle Cloud Infrastructure Administration Essentials course, explore deeper into the Oracle Cloud Infrastructure services to design and implement a secure and scalable cloud solution that meets HA and DR requirements. Design secure networks with disaster recovery options, and explore database capacity planning and advanced database features on OCI. Also explore the gamut of new services on OCI such as Streaming, Events, and Functions.
-
The Oracle Database 12c R2: Administration Workshop Ed 3 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.
-
In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.
Learn To:
- Develop appropriate backup and recovery procedures to address your business needs.
- Implement backup and recovery settings and perform backup operations to disk and tape.
- Employ Oracle Database recovery procedures to recover from media and other failures.
- Diagnose and repair data failures.
- Use Flashback Technologies and data duplication to complement backup and recovery procedures.
- Secure the availability of your database by appropriate backup and recovery strategies.
-
As organisations increasingly migrate to cloud environments, securing cloud infrastructure has become a top priority. Oracle Cloud Infrastructure (OCI) offers robust security measures, and professionals skilled in OCI security are in high demand. This course equips delegates with the expertise to implement, manage, and enhance security within OCI, ensuring compliance, mitigating threats, and strengthening overall cloud security strategies.
This course is ideal for security professionals, cloud architects, and IT administrators looking to deepen their understanding of OCI security. By mastering security best practices, access controls, and compliance frameworks, delegates can enhance their career prospects in cloud security. Gaining OCI security expertise will help them stand out in a competitive job market and open doors to advanced roles in cloud security and architecture.
This 4-day course provided by The Knowledge Academy offers a structured approach to mastering OCI security. It provides practical insights into securing cloud environments, managing identities, and implementing best practices. Delegates will learn how to mitigate security risks, handle incidents, and align with industry regulations. Completing this course will validate their ability to secure OCI resources, boosting their credibility and career opportunities in cloud security.
