10072 Office courses

Duration 4 Days 24 CPD hours This course is intended for This is an intermediate course for experienced DBAs and technical individuals, with experience on other relational database platforms, who plan, implement, and maintain Db2 11.1 for Linux, UNIX, and Windows databases. These skills can also be utilize to support cloud based databases using Db2 on Cloud or Db2 Hosted environments. Overview Please refer to course overview This course teaches you to perform, basic and advanced, database administrative tasks using Db2 11.1. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. The access strategies selected by the Db2 Optimizer will be examined using the Db2 Explain tools. Various diagnostic methods will be presented, including using various db2pd command options. Students will learn how to implement automatic archival for database logs and how to plan a redirected database restore to relocate either selected table spaces or an entire database. The REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces, will be discussed. We will also cover using the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases. The selection of indexes to improve application performance and the use of SQL statements to track database performance and health will be covered. This course provides a quick start to Db2 database administration skills for experienced relational Database Administrators (DBA). Overview of Db2 11Command Line Processor (CLP) and GUI UsageThe Db2 EnvironmentCreating Databases and Data PlacementCreating Database ObjectsMoving DataBackup and RecoveryLocks and ConcurrencyDatabase Maintenance, Monitoring and Problem DeterminationSecurityDatabase Rebuild SupportDb2 Database and Table Space RelocationUsing Explain ToolsUsing Indexes for PerformanceAdvanced Monitoring

Duration 5 Days 30 CPD hours This course is intended for Administrator Architect Database Administrator Overview To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database. Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases. It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database. Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud. This course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases. You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods. CDB BasicsCDB and Regular PDBsApplication PDBs and Application InstallationPDB CreationCDB and PDB ManagementStorageSecurityBackup and DuplicateRecovery and FlashbackPerformance MonitoringResources AllocationData MovementUpgrade methods

Duration 2 Days 12 CPD hours This course is intended for The audience for this course is data professionals and data architects who want to learn about migrating data platform technologies that exist on Microsoft Azure and how existing SQL based workloads can be migrated and modernized. The secondary audience for this course is individuals who manage data platforms or develop applications that deliver content from the existing data platform technologies. Overview Understand Data Platform Modernization Choose the right tools for Data Migration Migrate SQL Workloads to Azure Virtual Machines Migrate SQL Workloads to Azure SQL Databases Migrate SQL Workloads to Azure SQL Database Managed Instance In this course, the students will explore the objectives of data platform modernization and how it is suitable for given business requirements. They will also explore each stage of the data platform modernization process and define what tasks are involved at each stage, such as the assessment and planning phase. Students will also learn the available migration tools and how they are suitable for each stage of the data migration process. The student will learn how to migrate to the three target platforms for SQL based workloads; Azure Virtual Machines, Azure SQL Databases and Azure SQL Database Managed Instances. The student will learn the benefits and limitations of each target platform and how they can be used to fulfil both business and technical requirements for modern SQL workloads. The student will explore the changes that may need to be made to existing SQL based applications, so that they can make best use of modern data platforms in Azure. Introducing Data Platform Modernization Understand Data Platform Modernization Understanding the stages of migration Data Migration Paths Choose the right tools for Data Migration Discover the Database Migration Guide Build your data estate inventory using Map Toolkit Identify Migration candidates using Data Migration Assistant Evaluate a Data workload using Database Experimentation Assistant Data Migration using Azure Database Migration Service Migrate non-SQL Server workloads to Azure using SQL Migration Assistant Migrating SQL Workloads to Azure Virtual Machines Considerations of SQL Server to Azure VM Migrations SQL Workloads to Azure VM Migration Options Implementing High Availability and Disaster Recovery Scenarios Migrate SQL Workloads to Azure SQL Databases Choose the right SQL Server Instance option in Azure Migrate SQL Server to Azure SQL DB offline Migrate SQL Server to Azure SQL DB online Load and Move data to Azure SQL Database Migrate SQL Workloads to Azure SQL Database Managed Instance Evaluate migration scenarios to SQL Database Managed Instance Migrate to SQL Database Managed instance Load and Move data to SQL Database Managed instance Application Configuration and Optimization

Anti-Social Behaviour (ASB) Awareness Course provides a thorough understanding of ASB types, family influences, and prevention strategies. Suitable for HR professionals, managers, social workers, and concerned individuals, it offers CPD certification and accessible learning materials.

Gain expertise in workplace health and safety with our comprehensive Health and Safety Executive course. Learn essential regulations, risk assessment, and safety management strategies for a safer work environment. Perfect for professionals across industries seeking to enhance their safety knowledge and compliance skills.

Online Life Drawing with no extra cost for Guidance/tuition with UK and international attendance. Low Cost membership available.

3 in 1 Package | Updated New Course 2023 | CPD Certified | 30 CPD Points | Free Certificates | Lifetime Access

Emergency Disaster Recovery during Wildfire for Woodland Officers Explore critical aspects of forestry, including the roles of Forest Rangers in the UK, wildfire safety precautions, effective action plans during wildfires, post-fire recovery strategies, the impact of heat waves and climate change, and the crucial role of Rangers in protecting our woodlands. Master Forestry roles in wildfire safety and recovery. Learn Forestry strategies for action during wildfires. Understand the Forestry impact of heat waves and climate change. Learning Outcomes: Define Forestry roles of UK forest rangers. Explain Forestry wildfire safety precautions. Develop Forestry action plans for wildfires. Implement Forestry wildfire recovery strategies. Analyse Forestry impact of heatwaves and climate change. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Emergency Disaster Recovery during Wildfire for Woodland Officers Course Syllabus Forest Rangers in UK: Explore the pivotal role of forest rangers in UK Forestry, focusing on woodland protection. Wildfire Safety Precautions: Learn key safety precautions within Forestry to prevent and manage wildfires effectively. Action Plan During Wildfires: Develop comprehensive Forestry action plans for effective wildfire response and management. Wildfire Recovery: Understand post-wildfire recovery strategies in Forestry, including reforestation and habitat restoration. Heat Waves and Climate Change: Examine how heatwaves and climate change influence Forestry, particularly wildfire risks and management. Role of Rangers: Delve into the specific responsibilities of Forestry rangers during wildfire emergencies, ensuring efficient response and coordination.

Fraud is a growing threat in the world of customer service. Be equipped with the knowledge and skills to combat it with our Customer Service Fraud Officer course. Learn about risk management, types of fraud, prevention and detection, evidence gathering, investigations, UK government legislation, and court processes. According to the UK's National Fraud & Cyber Crime Reporting Centre, over 4 million fraud incidents were reported in the country in 2020 alone. The increasing number of fraud cases has made it necessary for organisations to invest in prevention measures and hire experts to handle fraudulent activities. This is where our Customer Service Fraud Officer course comes in, providing you with the knowledge and skills to prevent, detect, and respond to fraud effectively. This extensive course covers various modules, including fraud prevention, detection, evidence, response, investigation, and UK government legislation related to fraud. With these modules, you will understand fraud types, risk management principles, and the appropriate response to fraud. Learning Outcomes: Understand the role of a Fraud Officer and the impact of it on customer service. Learn effective risk management techniques to minimise fraud incidents. Identify various types of fraud and the methods used to prevent and detect them. Gain knowledge of evidence collection and handling for use in fraud investigations. Develop a comprehensive understanding of the UK government legislation and court processes. Apply the acquired knowledge to respond to fraud incidents effectively. This course is perfect for anyone who wants to enhance their knowledge and skills in fraud prevention and management. Whether you are working in the customer service industry or interested in pursuing a career in fraud prevention, this course will give you a strong foundation in the subject. Our course will help you develop a deep understanding of fraud without requiring practical experience. Our Customer Service Fraud Officer course is designed to provide you with a comprehensive understanding of fraud and equip you with the necessary skills to prevent, detect, and respond to these activities. Through nine modules, you will learn about various types and prevention, detection, evidence, response, investigation, and UK government legislation and court processes. Join us today and take the first step towards becoming a fraud prevention expert. Enrol now and become a valuable asset to any organisation, protecting customers and businesses from fraudulent activities. Certification Upon completion of the course, learners can obtain a certificate as proof of their achievement. You can receive a £4.99 PDF Certificate sent via email, a £9.99 Printed Hardcopy Certificate for delivery in the UK, or a £19.99 Printed Hardcopy Certificate for international delivery. Each option depends on individual preferences and locations. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course will be especially helpful for: Customer service representatives Fraud prevention officers Law enforcement professionals Requirements Without any formal requirements, you can delightfully enrol in this course. Career path Some career paths related to this industry in the UK are: Customer Service Representative: £16,000 - £25,000 Fraud Prevention Officer: £25,000 - £40,000 Fraud Investigator: £30,000 - £50,000 Risk Manager: £35,000 - £75,000 Compliance Officer: £25,000 - £50,000 Law Enforcement Officer: £20,000 - £50,000

Enrol in our Certificate in Anti Money Laundering (AML) course to learn essential concepts and regulations, acquire valuable skills, and receive a CPD certificate. Ideal for professionals in finance, compliance, law enforcement, or anyone keen on preventing money laundering. Kickstart your career in financial crime prevention today!