Use Delegation to Multiply your Effectiveness, Build Team Resilience, and Increase Motivation in your Team
Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs with basic Oracle 19c skills. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs andexercises. Working in a hands-on learning environment led by our expert facilitator, students will explore: Creating CDBs and Regular PDBs Managing CDBs and PDBs Backup and Duplicate Upgrading and Transporting CDBs and Regular PDBs Backup Strategies and Terminology Restore and Recovery Concepts Using Flashback Technologies Duplicating a Database Installing Grid Infrastructure and Oracle Database Patching Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Using General Overall Database Enhancements Monitoring and Tuning Database Performance Managing Application PDBs Managing Security in Multitenant databases Recovery and Flashback Configuring and Using RMAN Diagnosing Failures Performing Recovery Transporting Data RMAN Troubleshooting and Tuning Creating an Oracle Database by using DBCA Oracle Restart Upgrading the Oracle Database Installing Grid Infrastructure for a Standalone server Using Availability Enhancements Tuning SQL Statements Geared for participants experienced with Oracle 19c DBA essentials Oracle 19c Database Administration II (Oracle DBA II) expands their understanding of Oracle database administration. Throughout the course students will explore coverage of Multitenant (CDB/PDB), database tuning, SQL tuning, and backup and recovery: the skills needed to keep a database running reliably and efficiently. The current release of the database is used for exercises and demonstrations, and the content back-ported as necessary for previous releases. Creating CDBs and Regular PDBs Configure and create a CDB Create a new PDB from the CDB seed Explore the structure of PDBs Manage CDBs and PDBs Manage PDB service names and connections Manage startup, shutdown and availability of CDBs and PDBs Change the different modes and settings of PDBs Evaluate the impact of parameter value changes Performance management in CDBs and PDBs Control CDB and PDB resource usage with the Oracle Resource Manager Backup and Duplicate Perform Backup and Recover CDBs and PDBs Duplicate an active PDB Duplicate a Database Upgrading and Transporting CDBs and Regular PDBs Upgrade an Oracle Database Transport Data Backup Strategies and Terminology Perform Full and Incremental Backups and Recoveries Compress and Encrypt RMAN Backups Use a media manager Create multi-section backups of exceptionally large files Create duplexed backup sets Create archival backups Backup of recovery files Backup non database files Back up ASM meta data Restore and Recovery Concepts Employ the best Oracle Database recovery technology for your failure situation Describe and use Recovery technology for Crash, Complete, and Point-in-time recovery Using Flashback Technologies Configure your Database to support Flashback Perform flashback operations Duplicating a Database Duplicate Databases Install Grid Infrastructure and Oracle Database Install Grid Infrastructure for a Standalone server Install Oracle Database software Patching Grid Infrastructure and Oracle Database Patch Grid Infrastructure and Oracle Database Upgrading to Oracle Grid Infrastructure Upgrade Oracle Grid Infrastructure Using General Overall Database Enhancements Install Oracle Database software Create, Delete and Configure Databases using DBCA Creating CDBs and Regular PDBs Use Miscellaneous 19c New Features Monitoring and Tuning Database Performance Managing Memory Components Understanding the Automatic Workload Repository (AWR) Understanding the Advisory Framework Monitoring Wait Events, Sessions, and Services Managing Metric Thresholds and Alerts Understanding and Using the Performance Tuning Methodology Performing Performance Planning Understanding the Automatic Database Diagnostic Monitor (ADDM) Manage Application PDBs Explain the purpose of application root and application seed Define and create application PDBs Install, upgrade and Patch applications Create and administer Application PDBS Clone PDBs and Application containers Plug and unplug operations with PDBs and application containers Comparing Local Undo Mode and Shared Undo Mode Manage Security in Multitenant databases Manage Security in Multitenant databases Manage PDB lockdown profiles Audit Users in CDBs and PDBs Manage other types of policies in application containers Recovery and Flashback Restore and Recovering Databases with RMAN Perform CDB and PDB flashback Configuring and Using RMAN Configure RMAN and the Database for Recoverability Configure and Using an RMAN recovery catalog Diagnosing Failures Detect and repair database and database block corruption Diagnosing Database Issues Performing Recovery Restore and Recovering Databases with RMAN Perform Non RMAN database recovery Transporting Data Transport Data RMAN Troubleshooting and Tuning Interpret the RMAN message output Diagnose RMAN performance issues Creating an Oracle Database by using DBCA Create, Delete and Configure Databases using DBCA Oracle Restart Configure and use Oracle Restart to manage components Upgrade the Oracle Database Plan for Upgrading an Oracle Database Upgrade an Oracle Database Perform Post-Upgrade tasks Install Grid Infrastructure for a Standalone server Rapid Home Provisioning Using Availability Enhancements Use an RMAN recovery catalog Use Flashback Database Tuning SQL Statements Understanding the Oracle Optimizer Using the SQL Tuning Advisor Managing Optimizer Statistics Using the SQL Access Advisor Understanding the SQL Tuning Process Additional course details: Nexus Humans Oracle 19c Database Administration II (DBA II) (TTOR20619) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 19c Database Administration II (DBA II) (TTOR20619) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.
How to Select and Apply the Right Leadership Style for Every Situation
This comprehensive 3-hour Online Family First Aid course has been created by Mini First Aid to give you the knowledge to help a baby, child or adult with both minor and major first aid incidents as well as giving advice on how to manage a range of common illnesses and conditions.
The 2-hour Baby & Child First Aid class covers CPR, Choking, Bumps, Burns, Breaks, Bleeding, Febrile Seizures and Meningitis & Sepsis Awareness and will give everyone who attends the peace of mind they deserve.
The Facilitation Skills course offers quality training for aspiring facilitators who want to expand their knowledge of the framework required for effective facilitation. It covers essential topics such as dealing with difficult people, building consensus, and addressing group dysfunction. Throughout the course, learners will develop crucial skills in active listening, conflict solving and communication, and will be introduced to a wide range of intervention techniques to fast track their career. There are no entry requirements for this training program. Learning Objectives: Develop the key skills and practical knowledge to create an inclusive and harmonious environment for all Understand the basic principles of conflict management and conflict resolution Sharpen your skills in communication, leadership and people management Discover a wide range of intervention techniques and consensus-building strategies Who is this Course for? Facilitation Skills is perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Facilitation Skills is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum Module One: Getting Started Facilitation Skills 00:01:00 Module Two: Understanding Facilitation Understanding Facilitation 00:09:00 Understanding Facilitation Case Study 00:01:00 Module Three: Process vs. Content Process vs. Content 00:06:00 Process vs. Content Case Study 00:01:00 Module Four: Laying the Groundwork Laying the Groundwork 00:06:00 Laying the Groundwork Case Study 00:01:00 Module Five: Tuckman and Jensen"s Model of Team Development Tuckman and Jensen's Model of Team Development 00:07:00 Tuckman and Jensen's Model of Team Development Case Study 00:01:00 Module Six: Building Consensus Building Consensus 00:09:00 Building Consensus Case Study 00:01:00 Module Seven: Reaching a Decision Point Reaching a Decision Point 00:04:00 Reaching a Decision Point Case Study 00:01:00 Module Eight: Dealing with Difficult People Dealing with Difficult People 00:03:00 Dealing with Difficult People Case Study 00:01:00 Module Nine: Addressing Group Dysfunction Addressing the Group Dysfunction Case Study 00:01:00 Addressing the Group Dysfunction Case Study 00:01:00 Module Ten: About Intervention About Intervention 00:06:00 About Intervention Case Study 00:01:00 Module Eleven: Intervention Techniques Intervention Techniques 00:03:00 Intervention Techniques Case Study 00:01:00 Closing 00:01:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00
Award winning Baby & Child First Aid classes for parents, grandparents or anyone anyone who looks after babies and children. Delivered in a relaxed and comfortable style, designed to give you confidence to know what actions to take if faced with a medical emergency.
Learn Project Benefits Management Step-by-Step A comprehensive process that covers every stage of Project and Program Benefits Management
Overview of Functional Skills - IT In today's digital age, the world of IT (Information Technology) is a realm of endless possibilities. The UK's IT sector is booming, with a projected growth rate of 3.9% annually through 2024. This Functional Skills - IT course opens doors to a thriving industry that's shaping our future. From the intricate workings of hardware to the complexities of cloud computing, this comprehensive program covers it all. Dive into the heart of IT systems and uncover the secrets behind the technology that powers our modern world. You'll explore everything from basic components to advanced concepts like virtualisation and database management. This Functional Skills - IT course isn't just about understanding technology; it's about positioning yourself at the forefront of innovation. The UK's tech sector is valued at over £184 billion and growing. By mastering IT functional skills, you're not just learning; you're investing in a future-proof career. Whether you're a curious beginner or looking to upgrade your skills, this course provides the foundation you need to thrive in the digital economy. Don't miss this opportunity to become part of the UK's digital revolution. Enrol now and transform your understanding of IT! Get a Quick Look at The Course Content: This course in Functional Skills - IT covers the following learning points: This course in Functional Skills - IT covers the following learning points: Identify and describe various hardware elements in IT infrastructure. Explain operating systems and their role in computing. Explain operating systems and their role in computing. Grasp concepts of data storage, databases, and cloud computing. Recognise different IT management roles and career opportunities. This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Functional Skills - IT. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Functional Skills - IT course, you can order your CPD Accredited Digital / PDF Certificate for £5.99. Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Individuals seeking to enhance their basic IT knowledge and skills. Students preparing for further education in information technology. Professionals aiming to transition into IT-related roles. Job seekers looking to improve their employability in tech sectors. Anyone interested in understanding modern IT systems and practices. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Functional Skills - IT course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path IT Support Technician: £18K to £35K/year. Network Administrator: £25K to £40K./year Systems Analyst: £28K to £62K/year. IT Manager: £45k to £90k/year. Cyber Security Analyst: £35k to £60k/year. Course Curriculum Section 1: Introduction Unit 1: Introduction 00:01:00 Unit 2: Course Outline 00:06:00 Section 2: Information Technology Unit 1: Facts about Information Technology (IT) 00:05:00 Unit 2: What is Information Technology & How IT Works 00:02:00 Section 3: Components of IT Unit 1: IT Components 00:02:00 Section 4: Hardware Unit 1: What is Hardware 00:02:00 Unit 2: Examples of Computer 00:02:00 Unit 3: Computer Hardware Manufacturers 00:04:00 Unit 4: Hardware Jobs 00:05:00 Section 5: Operating System Unit 1: What is Operating System 00:02:00 Unit 2: Examples of Operating System 00:08:00 Unit 3: Operating System Jobs 00:10:00 Unit 4: OS Tools Related Jobs 00:02:00 Section 6: Application/Software Unit 1: What is Application/Software 00:03:00 Unit 2: Software Building Tools and Languages 00:03:00 Unit 3: Software/Application Building Jobs 00:03:00 Unit 4: Software/Application User Jobs 00:03:00 Section 7: Networking Unit 1: What is Computer Networking 00:02:00 Unit 2: Computer Network Companies 00:02:00 Unit 3: Network Jobs 00:04:00 Section 8: Security Unit 1: What is Computer Security 00:02:00 Unit 2: Security Companies 00:01:00 Unit 3: Security Jobs 00:03:00 Section 9: Traffic Flow & Enterprise Level IT Components Unit 1: How Information Flow within IT 00:02:00 Unit 2: Enterprise Level IT Components 00:02:00 Section 10: Storage Unit 1: What is Storage 00:05:00 Unit 2: Storage Companies and Technologies 00:02:00 Unit 3: Jobs in Storage 00:02:00 Section 11: Database Unit 1: What is Database 00:02:00 Unit 2: Database Type and Technologies 00:04:00 Unit 3: Database Jobs 00:02:00 Section 12: Virtualisation & Cloud Unit 1: What is Virtualisation 00:03:00 Unit 2: What is Cloud Technology 00:02:00 Unit 3: Virtualisation and Cloud Companies 00:02:00 Unit 4: Virtualisation and Cloud Jobs 00:02:00 Section 13: Management & Other IT Jobs Unit 1: IT Management Jobs 00:03:00 Unit 2: Other IT Jobs 00:09:00
Join a Climate Fresk Climate science workshop to learn about the causes and effects of climate change through a fun and collaborative experience.