Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL *Plus Setup JDeveloper About BIND and Substitution Variables Using SQL Developer Using SQL *Plus Choosing a Database Programming Language What is Database Programming PL/SQL Programming PL/SQL Performance Advantages Integration with Other Languages PL/SQL Language Essentials PL/SQL Program Structure Language Syntax Rules Embedding SQL Writing Readable Code Generating Readable Code Generating Database Output SQL * Plus Input of Program Block DECLARE Section About the Declare Section Declare Primitive Types Declaration Options Not Null Constant Data Dictionary Integration % Type Declare Simple User-Defined Types Type ? Table Type ? Record Extended User Defined Types BEGIN Section About the Begin Section Manipulating Program Data Logic Control & Braching GOTO LOOP IF-THEN-ELSE CASE EXCEPTION Section About the Exception Section Isolating the Specific Exception Pragma Exception_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT & Select ? Into Beyond the Basics : Explicit Cursors About Explicit Cursors Extend Cursor Techniques For Update of Clause Where Current of Clause Using for ? Loop Cursors Introduction Database Resident Programming Units About Database ? Resident Programs Physical Storage & Execution Types of Stored Program Units Stored Program Unit Advantages Modular Design Principles Creating Stored Procedures and Functions Stored Procedures & Functions Create Procedure / Create Function Creating Procedures & Functions Raise_Salary() Procedure Salary_Valid() function The Parameter Specification Default Clause System & Object Privileges Using the Development Tools Executing Stored Procedures and Functions Calling Procedures & Functions Unit Testing with Execute Anonymous Block Unit Testing Specifying a Parameter Notation SQL Worksheet Unit Testing Calling Functions from SQL Maintaining Stored Programming Units Recompiling Programs Mass Recompilation Using UTL_RECOMP() Dropping Procedures & Functions Drop Procedures & Functions Drop Procedure / Function Data Dictionary Metadata Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies Dependency Internals Tracking Dependencies The Dependency Tracking Utility SQL Developer Dependency Info Dependency Strategy Checklists Creating & Maintaining About Packages Creating Packages Maintaining Packages Performance Considerations Advanced Package Capabilities Definer & Invoker Rights White Lists & Accessible By Persistent Global Objects Defining Initilization Logic Object Orientation Support Advanced Cursor Techniques Using Cursor Variables Using SYS_REFCURSOR Using Cursor Expressions Using System Supplied Packages DBMS_OUTPUT() UTL_FILE() FOPEN() Example Database Trigger Concepts About Database Triggers DML Event Trigger Sub-Types Database Trigger Scenario Trigger Exhaustion Mechanisms Trigger within SQL Worksheet Creating Database Triggers Statement Level Triggers Using Raise Application_Error() Row-Level Triggers Examples of Triggers Employee_Salary_Check Example Employee_Journal Example Budget_Event Example Instead of Triggers Triggers within and Application Maintaining Database Triggers Call Syntax Trigger Maintenance Tasks Show Errors Trigger Drop Trigger Alter Trigger Multiple Triggers for a Table Handling Mutating Table Issues Implementing System Event Triggers What are System Event Triggers Defining the Scope Available System Events System Event Attributes
Overview of Leadership and Management The Leadership and Management course is the perfect opportunity for individuals looking to enhance their leadership skills and transform themselves into influential leaders and strategic thinkers. This comprehensive course provides valuable insights into management and leadership theories, team motivation, communication, and organizational excellence. By taking this course, you will gain the knowledge and expertise required to navigate the challenges of leading teams, driving organizational growth, and fostering a culture of excellence. With the ever-evolving corporate landscape, the need for strong leaders and managers has never been more critical. According to a recent survey by the Chartered Management Institute, over 75% of UK businesses consider strong leadership as a crucial factor in their success. Aspiring leaders and managers will learn how to master the art of communication and negotiation, harness the power of emotional intelligence, and effectively manage change. The Leadership and Management course equips you with a holistic toolkit to thrive in today's competitive business environment. Don't miss the chance to shape your future and join the ranks of successful leaders in your respective fields. Get a quick look at the course content: Demonstrate proficiency in UK payroll legislation and company settings. Effectively manage pension schemes and various pay elements. Confidently process monthly payrolls, handle pre-update reports, and update payroll records. Master e-submissions, year-end procedures, and historical data management. Navigate employee departures, manage final payroll runs, and generate comprehensive reports. This Leadership and Management Course will help you to learn: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Leadership and Management. 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 Leadership and Management 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? This Leadership and Management is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Leadership and Management 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 The certification and skills you get from this Leadership and Management Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Introduction to Leadership Module 01: Introduction to Leadership 00:30:00 Module 02: Inspiration and Leadership Module 02 : Inspiration and Leadership 00:30:00 Module 03: Setting Goals and Time Management Module 03: Setting Goals and Time Management 00:22:00 Module 04: Body Language and Effective Communication Module 04: Body Language and Effective Communication 00:30:00 Module 05: Self-Esteem and Assertiveness Skills Module 05: Self Esteem and Assertiveness Skills 00:24:00 Module 06: Business Management and Corporate Behaviour Module 06: Business Management Corporate Behaviour 00:16:00 Module 07: Meeting Management Module 07: Meeting Management 00:21:00 Module 08: Project Management Module 08: Project Management 00:23:00 Module 09: Risk Management Module 09: Risk Management 00:19:00 Module 10: Team Work and Team Building Module 10: Team Work Team Building 00:20:00 Module 11: Performance Management Module 11: Performance Management 00:17:00 Module 12: Critical Thinking: Implications for Leadership Module 12: Critical Thinking Implications for Leadership 00:20:00 Assignment Assignment - Leadership and Management 00:00:00
This course will show you why Hadoop is one of the best tools to work with big data. With the help of some real-world data sets, you will learn how to use Hadoop and its distributed technologies, such as Spark, Flink, Pig, and Flume, to store, analyze, and scale big data.
The Personal Training and Muscle Building Diploma course covers the essential concepts of personal training and muscle building. At first, you will learn about nutrition, Physiology and Kinesiology, Aerobic Training, and more. The course illustrates the techniques of Yoga and Fitness Testing. Throughout the course, you will learn the importance of fitness, metabolism, can you control metabolism and fitness of body and mind. The rest of the part of the course trains you how to build muscle. Other topics include the principles of exercising, the common fitness mistakes and more. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: This Diploma in Personal Training & Fitness course is a useful qualification to possess, and would be beneficial for the following careers: Personal training development instructors Motivational speaker Individual consular Time management coach. Personal Training Nutrition 00:30:00 Physiology and Kinesiology 00:30:00 Aerobic Training 01:00:00 Weight Training 00:30:00 Muscle Exercise Cross Reference 00:15:00 Fitness Testing 00:30:00 Stretching 00:15:00 Yoga 00:15:00 Pregnancy 00:15:00 Senior Fitness 00:30:00 Exercise Injury 00:30:00 Personal Training Tips 00:15:00 Personal Trainer Mistakes & Solutions 00:30:00 Muscle Building INTRODUCTION TO MUSCLE BUILDING 01:00:00 TRAINING EXERCISES 01:00:00 EXTENSIVE WORKOUTS 01:00:00 Power Foods Defined 01:00:00 Meal Plans: Print Out 01:00:00 Rested Performance and The Truth Behind Your Supplements 01:00:00 BODYBUILDING FOR WOMEN 01:00:00 A Note On Competitions 01:00:00 Benefits of Muscle Building 00:30:00 Final Words: Conclusion 00:15:00 Mock Exam Module 5: Compliance and Ethics 00:20:00 Final Exam Final Exam - Personal Training and Muscle Building Diploma 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
Are you ready to step into a supervisory role or enhance your existing skills? Our comprehensive Supervisor Training course is designed to equip you with the knowledge and tools necessary to excel in any supervisory position. Whether you're a new supervisor or looking to refine your leadership abilities, this course will provide you with the essential skills to manage teams effectively, communicate efficiently, and handle the challenges of supervision with confidence. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access In this Supervisor Training curriculum, learners will gain essential skills to effectively manage and lead teams. They will understand the important role of supervision and develop crucial communication skills needed to convey ideas clearly and build strong relationships with employees. The training covers effective methods for managing and guiding employees, including recruitment and dismissal processes. Learners will also learn strategies for handling conflicts that may arise in the workplace, promoting a harmonious work environment. Additionally, they will be trained in cybersecurity practices, ensuring they understand how to protect company and employee data. This curriculum provides interactive training tailored for new supervisors, equipping them with practical knowledge and tools to succeed in their roles and contribute positively to organizational growth and success. Course Curriculum Module 01: Fundamentals of Supervisor Training Module 02: Understanding the Role of Supervision Module 03: Essential Skills in Supervision Module 04: Communication Skill Development Module 05: Employee Management Module 06: Recruitment and Dismissal Module 07: Conflict Management Module 08: Interactive Training for New Supervisors Module 09: Cybersecurity for Employees Learning Outcomes: Understand fundamentals of supervision and its importance in organizations. Develop essential communication skills for effective supervisory roles. Manage employee performance and conduct recruitment and dismissal procedures confidently. Resolve conflicts in the workplace using effective conflict management strategies. Equip new supervisors with interactive training techniques for successful onboarding. Implement cybersecurity practices to ensure employee data protection and organizational security. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? New supervisors seeking foundational skills in management and leadership. Experienced employees transitioning into supervisory roles for career advancement. HR professionals involved in recruitment, employee management, and conflict resolution. Managers aiming to enhance their communication and supervision skills. Individuals interested in understanding the responsibilities of a supervisor. Career path Operations Supervisor Team Leader Shift Manager HR Supervisor Department Manager Office Supervisor Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Join our Quality Assurance course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Quality Assurance course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Quality Assurance course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Quality Assurance. 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 Quality Assurance 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. (Each) Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Quality Assurance is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand. On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level. This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Quality Assurance 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 The certification and skills you get from this Quality Assurance Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Defining Quality Defining Quality 00:20:00 Module 02: Role Of Monitoring And Controlling Quality Role Of Monitoring And Conrolling Quality 00:19:00 Module 03: Methods Of Controlling Quality Methods Of Controlling Quality 00:14:00 Module 04: Total Quality Management (TQM) Total Quality Management (TQM) 00:16:00 Module 05: Key Performance Indicators Key Performance Indicators 00:15:00 Module 06: Customer Satisfaction Customer Satisfaction 00:15:00 Module 07: Reviewing Quality Reviewing Quality 00:16:00
Overview Attain the best online training possible to become a sought-after manager who can steer Hotels and Hospitality services in successful directions. This Hospitality and Hotel Revenue Management Advanced Diplomacourse is designed to coach you in every aspect and element of Hospitality responsibilities and guarantees you are able to deliver outstanding customer service. The course is designed to prepare for the demands of customers in Hotels, and also such other events or locations, such as cruise ships, popular bars or clubs, restaurants, and high-profile tourist destinations. You will learn how to recruit and train staff, maintain housekeeping, upkeep a facility, and organise large-scale events and the appropriate catering. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this Hospitality and Hotel Revenue Management Advanced Diploma. It is available to all students, of all academic backgrounds. Requirements Our Hospitality and Hotel Revenue Management Advanced Diploma is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 22 lectures • 07:08:00 total length •Module 01: Introduction to Hospitality Management: 00:24:00 •Module 02: An Overview of Hotel Industry: 00:18:00 •The Process of Selection and Recruitment in Hospitality Industry: 00:21:00 •The Process of Development and Training in Hospitality Industry: 00:24:00 •Module 05: Management of Front Office Operations: 00:19:00 •Management of Housekeeping, Engineering and Security Operations: 00:27:00 •Management of Food and Beverage Operations: 00:20:00 •Management of Service Quality in Hospitality Industry: 00:20:00 •Marketing in Travel and Tourism Business: 00:24:00 •Module 10: Accounting in Hospitality Industry: 00:26:00 •Module 11: Customer Satisfaction: 00:20:00 •Module 12: E-Hospitality and Technology: 00:22:00 •Module 1. Fundamentals of Hotel Revenue Management: 00:16:00 •Module 2. Importance of Revenue Management: 00:20:00 •Module 3. Key Performance Indicator in Revenue Management: 00:18:00 •Module 4. Forecasting of Hotel Revenue Management: 00:21:00 •Module 5. Pricing of Hotel Revenue Management: 00:22:00 •Module 6. Profitable Distribution Strategy: 00:07:00 •Module 7. Overbooking Practices in Hotel Revenue Management: 00:10:00 •Module 8. How to Promote your Hotel: 00:15:00 •Module 9. Customer and Other Essential Factors: 00:13:00 •Module 10. The Future of Hotel Revenue Management in UK: 00:21:00
Duration 2 Days 12 CPD hours This course is intended for This course is for web developers who are well-versed in JavaScript and want to take their TypeScript knowledge to the next level. No prior TypeScript knowledge is required. Overview By completing this course, you will be able to build interesting TypeScript projects. This course will take your current TypeScript knowledge to the next level. Here are the important topics that this course will cover: - Learn the fundamentals of TypeScript - Build a weather forecast widget with Angular - Create building a note-taking client/server application using Angular, Node.js, and MongoDB - Create a real-time chat application with React In this course, you will begin by learning the fundamentals of TypeScript and then move toward advanced concepts. Then, learn how TypeScript relates to JavaScript that you may have written before. and understand the benefits of TypeScript and how it can help you avoid software defects. You will also learn to use type guards, check null and undefined, create tagged union types, and compare the performance of algorithms. Additionally, you will use TypeScript to build a weather forecast widget with Angular and then progress by building a note-taking client/server application using Angular, Node.js, and MongoDB, and finally create a real-time chat application with React. TypeScript Fundamentals Introduction to TypeScript Type Checking Advanced Type Analysis Features Comparing Performance of Algorithms Building a Weather Forecast Widget with Angular 4 Using Modules Creating the First Component Using the Component in Other Components Using the Main Component Note-Taking Client/Server App Setting up the Server Integrating with MongoDB Creating the Client Side with Angular Real-Time Chat Setting up the Project Writing the Server Creating the Chat Room Additional course details: Nexus Humans Building Web Applications With TypeScript, Angular, and React 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 Building Web Applications With TypeScript, Angular, and React 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.
Duration 3 Days 18 CPD hours This course is intended for This course is introductory-level, but technical in nature. In order to participate in the hands-pon labs you should have a basic understanding of database principles, basic scripting skills (in relation to Oracle) and basic analytics skills. Overview This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you'll explore: Core concepts of regular PDBs Creating a CDB, and then using different methods to create PDBs. How to start and shut down a CDB and how to open and close a PDB. Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption. Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs. How you can move data from a non-CDB environment to a PDB. How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager. The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands-on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). Multitenant Architecture CDB Basics CDB and Regular PDBs Application PDBs and Application Installation PDB Creation PDB Creation CDB and PDB Management Storage Security Security Backup and Duplicate Recovery and Flashback Performance Resources Allocation Data Movement Data Movement Upgrade Methods Miscellaneous Additional course details: Nexus Humans Oracle 19c Database Multitenant Architecture (TTOR20719) 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 Multitenant Architecture (TTOR20719) 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.
Duration 3 Days 18 CPD hours This course is intended for This course is introductory-level, but technical in nature. In order to participate in the hands-pon labs you should have a basic understanding of database principles, basic scripting skills (in relation to Oracle) and basic analytics skills. Overview This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: Core concepts of regular PDBs Creating a CDB, and then using different methods to create PDBs. How to start and shut down a CDB and how to open and close a PDB. Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption. Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs. How you can move data from a non-CDB environment to a PDB. How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager. The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). Multitenant Architecture CDB Basics CDB and Regular PDBs Application PDBs and Application Installation PDB Creation PDB Creation CDB and PDB Management Storage Security Security Backup and Duplicate Recovery and Flashback Performance Resources Allocation Data Movement Data Movement Upgrade Methods Miscellaneous Additional course details: Nexus Humans Oracle Database 19c Multitenant Architecture (TTOR20719) 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 Database 19c Multitenant Architecture (TTOR20719) 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.