Duration 3 Days 18 CPD hours Overview Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will explore: New Features Overview Multitenant New Features Security Features Cloud Services Networking Globalization Big Data Support Database Installation and Configuration Database Tuning Backup and Recovery Oracle 19c New Features is a hands-on course that explores the newest features such as Big Data Enhancements, Security, Multitenant features, Oracle Cloud Services, Networking, and much more. Oracle is one of the leading databases in industry today. Learn what their latest flagship product has to offer from industry experts. Oracle 19c New Features Overview Introduction to Oracle 19c New Features Oracle 19c Multitenant New Features Refreshable PDB Switchover PDB Integration with Data Guard PDB Snapshot Carousel CDB Fleet Management Oracle 19c Security Features Profile Lockdown Create a User Defined Master Encryption Key Encrypted Passwords in Database Links and Data Pump Create Keystores for Pluggable Databases Datapump and Unified Auditing Schema Only Accounts Oracle 19c Cloud Services Oracle IaaS Oracle Saas Oracle PaaS Oracle 19c Networking Database Connection Manager Database Proxy Support Tenant Isolation Oracle 19c Globalization New globalization for Bind Variables New Database Local Support Additional Unicode Support Big Data Support New Analytic Support Data Mining Data Warehouse Additional Parallel Processing Support Inline External Tables Database Installation and Configuration Zero Downtime Upgrades Dry Run Command implementation New location for Password File Improved Bulk Operations Database Tuning SQL Tuning Advisor and Exadata New SQL Tuning Set API Concurrent SQL and Sql Performance Analyzer Database In Memory Features In Memory Support for External Tables In Memory Features for Analytics Oracle 19c Backup and Recovery Active Pluggable Cloning Pluggable and non Pluggable Database Migration Additional course details: Nexus Humans Oracle 19c New Features (TTOR20019) 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 New Features (TTOR20019) 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 intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature
Duration 2 Days 12 CPD hours This course is intended for This course is intended for Data Warehouse Administrator, Database Administrator, Database Designer, Support Engineer, and Technical Administrator. Overview Upon successful completion of this course, students will be able to Install Oracle Grid Infrastructure for a Standalone Server, Configure ASMLIB and create ASM disk groups, Apply the latest patch set updates to the Grid Infrastructure software, Install Oracle Database software, Use Oracle Restart to manage components, Prepare the Linux operating system for Oracle software installation, Upgrade Oracle Database, Create a container database, Install Oracle Grid Infrastructure for an Independent Server, Create an Oracle Database using DBCA, and Install the latest patch set updates to the Oracle database software. This Oracle Database: Deploy, Patch and Upgrade Workshop gives you detailed information to help you install Oracle Database software. In this course, you will be introduced to Oracle Database Cloud Service. Oracle Database Overview Oracle Database Introduction Oracle Database Architecture Overview Oracle Database Instance Configurations Oracle Database Memory Structures Process Structures Database Storage Architecture Logical and Physical Database Structures Container and Pluggable Database Overview Installing Oracle Grid Infrastructure for a Standalone Server Overview of Oracle Grid Infrastructure for a Standalone Server System Requirements for Oracle Grid Infrastructure Configuring Storage for Oracle Automatic Storage Management (ASM) Installing Oracle Grid Infrastructure for a Standalone Server Upgrading Oracle Grid Infrastructure for a Standalone Server Installing Oracle Database Software Planning Your Installation System Requirements for Oracle Database Preparing the Operating System Using 4 KB Sector Disks Setting Environment Variables Checking the System Requirements Using the Oracle Universal Installer (OUI) Performing a Silent Mode Installation Creating an Oracle Database by Using DBCA Planning the Database Storage Structure Choosing non-CDB or CDB Types of Databases (based on workload) Choosing the Appropriate Character Set Understanding How Character Sets are Used Setting the NLS_LANG Initialization Parameter Using the Database Configuration Assistant (DBCA) Using Oracle Restart Oracle Restart Overview Oracle Restart Process startup Controlling Oracle Restart Choosing the Correct SRVCTL Utility Oracle Restart Configuration Using the SRVCTL Utility Obtaining Help for the SRVCTL Utility Starting Components by Using the SRVCTL Utility Introduction to Upgrading to Oracle Database Upgrade Methods Data Migration Methods Supported Releases for Direct Upgrade Overview of Upgrade Process Performing a Rolling Upgrade Upgrading a CBD Preparing to Upgrade to Oracle Database Developing a Test Plan Performance Testing Requirements for Databases Using Oracle Label Security or Oracle Database Vault Requirement for Databases Using Oracle Warehouse Builder Using the Pre-Upgrade Information Tool Backing Up the Database Installing the Oracle Database Software Preparing the New Oracle Home Upgrading to Oracle Database Upgrading by Using the Database Upgrade Assistant (DBUA) Manually Upgrading to Oracle Database Migrating a non-CDB to a CDB Performing Post-Upgrade Tasks Migrating to Unified Auditing Performing Post-Upgrade Tasks Following a Manual Upgrade Migrating Data by Using Oracle Data Pump Data Pump Overview Migrating by Using Data Pump Importing by Using a Network Link
Internal Audit Skills Diploma Course Overview The "Internal Audit Skills Diploma" offers an in-depth exploration of internal audit processes and procedures, providing essential knowledge for individuals seeking to excel in auditing roles. The course covers auditing as a form of assurance, the technology used in audits, internal control, risk management, and UK-specific audit standards. Upon completion, learners will have a solid understanding of internal audit processes, report generation, and the skills necessary to pursue a career as an auditor. Course Description This comprehensive diploma course equips learners with the key skills required for a successful career in internal auditing. Topics include auditing as a form of assurance, internal audit procedures, the integration of technology in audits, and methods for evaluating internal controls and risk. In addition, the course explores how to conduct audit interviews, report findings, and understand UK internal audit standards. Learners will also gain insights into the various career paths within auditing, making this course valuable for those looking to enter or advance in the industry. Internal Audit Skills Diploma Curriculum Module 01: Auditing as a Form of Assurance Module 02: Internal Audit Procedures Module 03: Technology-based Internal Audit Module 04: Internal Control and Control Risk Module 05: Audit Interviews Module 06: Reporting Audit Outcome Module 07: UK Internal Audit Standards Module 08: Career as an Auditor (See full curriculum) Who is this course for? Individuals seeking to enter the field of internal auditing. Professionals aiming to enhance their audit knowledge and career development. Beginners with an interest in auditing or risk management. Those pursuing a career in compliance, risk, or financial sectors. Career Path Internal Auditor Risk and Compliance Officer Audit Manager Financial Auditor Internal Controls Specialist Business Consultant
Duration 3 Days 18 CPD hours This course is intended for Channel and Customer Engineers Network Engineer System Engineer Wireless Engineer Consulting Systems Engineer Technical Solutions Architect Network Admisnistrator Wireless Design Engineer Network Manager Channel SEs Sales Engineer Channel AMs Account Manager Overview Upon completing this course, students will be able to meet these objectives: Understand the overall architecture of the Cisco security solutions and how APIs help enable security Understand how to use Cisco Firepower APIs Understand how pxGrid APIs function and their benefits Understand what capabilities the Cisco Stealthwatch APIs offer and construct API requests to them for configuration changes and auditing purposes Understand the features and benefits of using Cisco Stealthwatch Cloud APIs Learn how to use the Cisco Umbrella Investigate API Understand the Functionality provided by Cisco AMP and its APIs Learn how to use Cisco Threat Grid APIs to analyze, search, and dispose of threats This course demonstrates the tools and the benefits of leveraging programmability and automation in Cisco Security Solutions, including Cisco Firepower Management Center, Cisco Firepower Threat Defense, Cisco ISE, Cisco pxGrid, Cisco Stealthwatch Enterprise, Cisco Stealthwatch Cloud, Cisco Umbrella, Cisco AMP, Cisco Threat grid, and Cisco Security Management Appliances. Students will learn how to use the API for each Cisco security solution and specific applications of when the API benefits IT security content. Introducing Cisco Security APIs Role of APIs in Cisco Security Solutions Cisco Firepower, Cisco ISE, Cisco pxGrid, and Cisco Stealthwatch APIs Use cases and security workflow Consuming Cisco Advanced Malware Protection APIs Cisco AMP overview Cisco AMP endpoint API Cisco AMP use cases and workflows Discovery 1: Query Cisco AMP endpoint APIs for verifying compliance Using Cisco ISE Introducing Cisco Identity services engine Cisco ISE use cases Cisco ISE APIs Using Cisco pxGrid APIs Cisco pxGrid overview WebSockets and STOMP messaging protocol Discovery 2: Use the REST API and Cisco pxGrid with Cisco Identity services engine Using Cisco Threat Grid APIs Cisco threat grid overview Cisco threat grid API Cisco threat grid use cases and workflows Discovery 3: Construct a Python script using the Cisco threat grid API Investigating Cisco Umbrella Security Data Programmatically Cisco Umbrella investigate API overview Cisco Umbrella investigate API: Details Discovery 4: Query security data with the Cisco Umbrella investigate API Exploring Cisco Umbrella Reporting and Enforcement APIs Cisco Umbrella reporting and enforcement APIs: Overview Cisco Umbrella reporting and enforcement APIs: Deep dive Discovery 5: Generate reports using the Cisco Umbrella reporting API Automating Security with Cisco Firepower APIs Review basic constructs of Firewall policy management Design policies for automation Cisco FMC APIs in depth Discovery 6: Explore the Cisco Firepower management center API Cisco FTD automation with ansible Discovery 7: Use ansible to automate Cisco Firepower threat defense configuration Cisco FDM API in depth Discovery 8: Automate Firewall policies using the Cisco Firepower device manager API Operationalizing Cisco Stealthwatch and Its API Capabilities Cisco Stealthwatch overview Cisco Stealthwatch APIs: Details Discovery 9: Automate alarm policies and create reports using the Cisco Stealthwatch APIs Using Cisco Stealthwatch Cloud APIs Cisco Stealthwatch Cloud overview Cisco Stealthwatch Cloud APIs: Deep dive Discovery 10: Construct a report using Cisco stealthwatch Cloud APIs Describing Cisco Security Management Appliance APIs Cisco SMA APIs overview Cisco SMA API Discovery 11: Construct reports using Cisco SMA APIs
At HFX Training, we are passionate about business simulations because they bring learning to life through hands-on experience. This Level 1 Certification Program is the first step in our Instructor Training Certification Pathway, equipping you to confidently use the Healthcare Hero simulation in your teaching environment. In this program, you will experience the simulation as a student, navigating its complexities and dynamics. Upon successfully completing Level 1, you’ll be ready to advance to Level 2 Training, where you will deepen your expertise in simulation facilitation and administration. The program is cohort-based, and the timetable is coordinated in advance through discussions with the HFX team to ensure maximum participation. For more information on the program structure, instructional materials, and certification requirements, please read on. What to Expect: The Healthcare Hero simulation places you in charge of a fictional hospital. Over eight simulation rounds - each representing one quarter of business operations - you will make strategic decisions to optimize patient care while managing staffing, capacity, quality, and finances. Throughout the simulation, you’ll navigate challenges like healthcare and economic crises, all while balancing the needs of multiple stakeholders. Your ultimate goal is to outperform competing hospitals managed by other participants in the program. Program and Certification Requirements This program equips you to confidently lead the simulation by requiring more than attendance or participation. To earn certification, you must: Thoroughly Prepare: Review all instructional materials and the scenario manual before the course begins. Fully Participate: Attend all Zoom sessions and complete each simulation round with focus and effort. Demonstrate Mastery: Show a comprehensive understanding of the simulation’s dynamics, decision-making processes, and strategies during practice and live rounds. Engage in Reflection: Actively participate in debrief sessions, assess your performance, and identify strategies for improvement. This certification ensures you are equipped to facilitate this complex simulation with confidence. Auditing the course is an option, but participants who choose to audit will not receive certification. Program Format The program is delivered intensively over one or more Zoom sessions, totaling six hours. This compressed format demands your full attention and focus to successfully navigate the simulation’s complexities. Eligibility Requirements: By registering for this training program, you acknowledge the following: You have discussed your needs with the HFX team and confirmed that the simulation aligns with your class or program objectives. You are an instructor at an academic institution. You agree to the confidentiality terms and commit not to distribute, disclose, or replicate any program content for purposes outside of this training. This program is offered in goodwill to academic instructors as a resource to enhance their teaching. As part of this agreement, you understand that all materials, including the simulation itself, are proprietary to HFX and its partners. Any use of these materials for purposes beyond this program, such as developing similar tools or simulations, is strictly prohibited. Course Structure: After registering, you will gain immediate access to the simulation’s instructional materials. This includes: The Scenario Manual: Your guide to understanding the game. The Capacity Planner Worksheet and Financial Planning Worksheet: Tools to help you strategize. The Strategy Planning Exercise: Designed to align your decisions with overall objectives. The Portal Guide: A walkthrough of the simulation platform. The program unfolds in four key phases: Phase 1: Pre Zoom Call / Study / Set Up Register using the button at the bottom of this page. Review the instructional materials thoroughly. Once the cohort is finalized, you will be sent your login credentials for the simulation itself. Try to submit decisions for the first practice round using the simulation portal at www.simulationportal.com. Phase 2: Play We run two practice rounds over the first 2 hours of the zoom call. This allows you to familiarize yourself with the platform and decision-making process, and think through what your strategy might be in the live game. The simulation resets ("zeroed") after the practice rounds. A brief session will clarify lessons learned and expectations for the live rounds. Over eight rounds, you’ll compete against other participants while refining your strategic decisions. Phase 3: Feedback Reflect on your performance during a structured debrief, including: Strengths and areas for improvement. Insights into competitors’ strategies. Strategic lessons learned, and applicability to local healthcare organizations. Phase 4: Implementation Planning Work with the HFX team to plan your first application of the simulation in a teaching environment. Certification Outcome Upon completing this program, you will earn the HFX Instructor Training Certification: Level One, signifying your expertise in conducting impactful simulation-based training using Healthcare Hero.
This workshop has been designed to help managers understand their responsibilities and what they need to do to ensure compliance with current workplace legislation - including the fire safety and CDM regulations. The day will cover the legal background - including an appreciation of how safety legislation has evolved and why; the logic behind recent developments and the implications for staff and employers; key areas of current legislation; roles and responsibilities in health and safety management, including monitoring contractors and suppliers effectively; implementing sound health and safety policies and procedures; getting staff on board, and implementing effective systems. Also, recognising potential risks and hazards and developing strategies to minimise their impact in the workplace. This course will give participants an understanding of: The broader context of the key areas of health and safety regulation which apply to your organisation Existing health and safety practice and guide them in how to shape and implement an effective health and safety policy What they should do and the procedures to support it Potential areas of risk in the workplace - and how to take action to minimise the threat to staff safety How sound health and safety processes can contribute to business performance 1 Understanding the workplace legislation Overview of health and safety and workplace legislation Compliance, the role of the facilities manager, and who is accountable? Breakout session to discuss where we are now and to highlight issues of concern Applying required policies and procedures Developing and implementation/review of the safety policy Communicating with users, clients and contractors Health and safety manual 'Selling' health and safety 2 Key legislation - a practical working guide Asbestos Regulations Construction (Design and Management) Regulations 2007 / 2015 Control of Substances Hazardous to Health (COSHH) Regulations Disability Discrimination Act (DDA) Display Screen Equipment (DSE) Regulations 1992 Electricity at Work Regulations 1989 Fire Precautions (Workplace ) Regulations 2006 Health and Safety (Consultation with Employees) Regulations 1996 Health and Safety (First Aid) Regulations 1981 Health and Safety at Work etc. Act 1974 Management of Health and Safety at Work Regulations 1992 Manual Handling Operations Regulations 1992 Portable Appliance Testing (PAT) Provision and Use of Work Equipment Regulations 1992 REACH - Registration, Evaluation, Authorisation and restriction of Chemicals Reporting of Injuries, Diseases, and Dangerous Occurrences Regulations (RIDDOR) 1995 Waste Electrical and Electronic Equipment (WEEE) Regulations 2006 Work Equipment Regulations 3 Controlling contractors Understanding the Regulations Selecting and assessing contractors Understanding and setting accountability Why a method statement? How to apply a permit to work system Safe systems of work Round-table discussion to bring out issues from participants' own experience 4 Risk assessment Understanding your hazards Identifying specialist areas How to undertake these assessments Implementation of sound systems and processes Syndicate exercise identifying where assessments are needed and carrying out assessments 5 Keeping the work environment safe Sick building syndrome and legionella Asbestos Waste management Pest control Provisions for first aid Accident reporting and investigation At-work driver safety Security 6 Fire safety Understanding the Regulatory Reform Fire Safety Order Fire certificates The fire risk assessment Testing fire-fighting equipment? Emergency procedures Workshop to examine the procedures for dealing with different types of emergencies 7 Ergonomics programme Ergonomics - important or irrelevant? Are you complying with HSE regulations? Furniture and equipment Display screen equipment assessments Homeworking - your concern or not? Syndicate exercise to review what to do when relocating or refurbishing an office 8 Inspecting and auditing Role of Health and Safety Executive Inspectors - 'be prepared' FM role Staff/trade union involvement Independent audits Records and reports Communicating the results 9 Action plan Participants to list actions they need to take after the course
Diploma in Accountancy Course Overview The Diploma in Accountancy is designed for individuals seeking to develop a solid foundation in accounting principles and practices. This course covers a broad range of topics, from the basics of accounting to more advanced financial concepts. Learners will gain valuable knowledge on financial statements, bookkeeping, and budgeting, which will be essential in various accounting roles. By the end of the course, learners will be equipped to manage financial data and analyse financial performance effectively. The course will prepare learners for career progression in the finance and accounting sectors, offering practical insights into the core areas of accounting. Course Description This comprehensive course explores key accounting concepts, including the role of an accountant, accounting standards, double-entry bookkeeping, and the preparation of financial statements such as balance sheets, income statements, and cash flow statements. Learners will understand how to analyse financial data, manage budgets, and apply accounting principles to real-world scenarios. The course also includes modules on auditing and profit and loss statements, which will broaden learners’ understanding of financial accountability. Learners will gain the skills necessary to take on more advanced roles within the finance industry, and they will be equipped with a robust understanding of accounting practices that are applicable across a wide range of businesses. Diploma in Accountancy Curriculum Module 01: Introduction to Accounting Module 02: The Role of an Accountant Module 03: Accounting Concepts and Standards Module 04: Double-Entry Bookkeeping Module 05: Balance Sheet Module 06: Income Statement Module 07: Financial Statements Module 08: Cash Flow Statements Module 09: Understanding Profit and Loss Statement Module 10: Financial Budgeting and Planning Module 11: Auditing (See full curriculum) Who is this course for? Individuals seeking to build a career in accounting or finance Professionals aiming to enhance their understanding of accounting principles Beginners with an interest in finance or accounting Those seeking to improve their financial management skills Career Path Accountant Financial Analyst Auditing Assistant Budget Analyst Management Accountant Finance Manager Bookkeeper
Information Management Course Overview This Information Management course provides a comprehensive understanding of the principles and practices essential for effectively managing information in today’s data-driven world. It covers core topics such as strategic planning, databases, management information systems, and the auditing of information systems. The course is designed to enhance learners' understanding of how information can be efficiently organised, secured, and utilised for decision-making within organisations. Upon completion, learners will be equipped with the skills to manage data, ensure compliance with data protection laws, and address ethical and social issues surrounding information management. This course is ideal for individuals looking to advance their knowledge in information management and pursue a career in this dynamic field. Course Description The Information Management course explores critical aspects of managing data and information systems, offering in-depth insights into the processes and tools used in modern organisations. The course covers a broad range of topics, including developing information management strategies, understanding and implementing databases, and examining management information systems (MIS) for efficient decision-making. Learners will also gain knowledge of auditing information systems to ensure accuracy, integrity, and security. The ethical, legal, and social considerations of data protection and information governance are also discussed. Throughout the course, learners will engage with key theories and practices, preparing them to apply their knowledge to various industries, ensuring organisations meet legal requirements and maximise the value of their information assets. Information Management Curriculum Module 01: Introduction to Information Management Module 02: Information Management Strategy Module 03: Databases and Information Management Module 04: Management Information Systems (MIS) Module 05: Auditing Information Systems Module 06: Ethical and Social Issues and Data Protection (See full curriculum) Who is this course for? Individuals seeking to understand the principles of information management. Professionals aiming to enhance their knowledge of information governance and security. Beginners with an interest in data management and organisational systems. Anyone looking to develop skills for improving organisational efficiency and compliance. Career Path Data Analyst Information Manager Records Manager IT Compliance Officer Data Protection Officer Information Systems Auditor
Root Cause Analysis (RCA) is used to analyse the root causes of focus events with both positive and negative outcomes, but it is most commonly used for the analysis of failures and incidents. Causes for such events can be varied in nature, including design processes and techniques, organizational characteristics, human aspects and external events. RCA can be used for investigating the causes of non-conformances in quality (and other) management systems as well as for failure analysis, for example in maintenance or equipment testing.