Duration 2 Days 12 CPD hours This course is intended for This is an advanced course for DBAs and technical individuals who plan, implement, and maintain Db2 11.1 databases Overview Please refer to course overview This course is designed to teach you how to:Perform advanced monitoring using the Db2 administrative views and routines in SQL queries.Manage the disk space assigned in Database Managed Storage (DMS) and Automatic Storage table spaces, including the activities of the rebalancer.Use SQL queries and Db2 commands to check the high water mark on table spaces and to monitor the rebalance operation.Utilize the REBUILD option of RESTORE, which can build a database copy with a subset of the tablespaces using database or tablespace backup images.Plan and execute the TRANSPORT option of RESTORE to copy schemas of objects between two Db2 databases.Create incremental database or tablespace level backups to reduce backup processing and backup image storage requirements.Implement automatic storage management for table spaces and storage groups or enable automatic resize options for DMS managed table spaces to reduce administration requirements and complexity.Describe the various types of database memory including buffer pools, sort memory, lock memory and utility processing memory.Adjust database or Db2 instance configuration options to improve application performance or processing efficiency.Implement Db2 Self Tuning Memory management for specific database memory areas. Advanced MonitoringDb2 Table Space ManagementDb2 Database Memory ManagementDatabase rebuild supportDb2 database and tablespace relocationDb2 Incremental Backup
Duration 4.5 Days 27 CPD hours This course is intended for This intermediate course is for people who are new to the RACF component of the z/OS Security Server, and responsible for security administration. This includes people who are planning to implement RACF for the first time, and people who are security administrators in installations where RACF is already implemented. Those inexperienced z/OS users may find the course Basics of z/OS RACF Administration (ES19) more appropriate Overview Identify the security requirements of a system Evaluate the facilities and options of RACF Define users to RACF Set up a RACF group structure Use RACF to protect resources Select options to tailor RACF Evaluate and implement RACF database and performance options Identify tools available for auditing Administer the system so that it is consistent with the installation's security goals Be a more effective security administrator using the RACF component of the z/OS Security Server to define users, set up group structures, define general resources, protect z/OS data sets, & use several RACF utilities. Security and RACF overview . Administering groups and users . Protecting z/OS data sets . Introduction to user administration and delegation and general resources . RACF database, tables, and performance options . RACF utilities and exits . RACF options . Auditing the RACF environment . Storage management and RACF . Security for JES facilities . Security classification .
Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD
Duration 3 Days 18 CPD hours This course is intended for Experienced system integrators and consultants responsible for designing and deploying vSphere environments Overview By the end of the course, you should be able to meet the following objectives: Identify the business objectives for the vSphere environment Identify business requirements, constraints, assumptions, and risks for all layers in the vSphere environment Apply a framework to a design Analyze design choices and best-practice recommendations Create a design that ensures availability, manageability, performance, recoverability, and security Design the core management infrastructure for an enterprise Design the virtual data center for an enterprise Design the compute infrastructure for an enterprise Design the storage and networking infrastructures for an enterprise Design virtual machines to run applications in a vSphere infrastructure Design security, manageability, and recoverability features for an enterprise This three-day training course equips you with the knowledge, skills, and abilities to design a VMware vSphere© 7 virtual infrastructure. You follow a proven approach to design a virtualization solution that ensures availability, manageability, performance, recoverability, and security, and that uses VMware best practices. This course discusses the benefits and risks of available design alternatives and provides information to support making sound design decisions. Given a case study, you practice your design skills by working with peers on a design project Course Introduction Introductions and course logistics Course objectives Infrastructure Assessment Follow a proven process to design a virtualization solution Define customer business objectives Gather and analyze business and application requirements Document design requirements, constraints, assumptions, and risks Use a systematic method to evaluate and document design decisions Create a conceptual design Core Management Infrastructure Determine the number of VMware vCenter© Server ApplianceTM instances to include in a design Choose the appropriate single sign-on identity source Choose the time synchronization method Choose methods to collect log files and VMware ESXi? core dumps Design a vCenter Server deployment topology that is appropriate for the size and requirements of the data center Virtual Data Center Infrastructure Calculate total compute capacity requirements for a virtual data center Create a virtual data center cluster design that meets business and workload requirements Evaluate in the virtual data center the use of several management services, such as VMware vSphere© High Availability and VMware vSphere© Distributed Resource Scheduler? Evaluate the use of resource pools in the virtual data center design Compute Infrastructure Create a compute infrastructure design that includes the appropriate ESXi boot, installation, and configuration options Choose the ESXi host hardware for the compute infrastructure Storage Infrastructure Calculate storage capacity and performance requirements for a design Evaluate the use of different storage platforms and storage management solutions Design a storage platform infrastructure and storage management architecture that meets the needs of the vSphere environment Network Infrastructure Evaluate the use of different network component and network management solutions Design a network component architecture that includes information about network segmentation and virtual switch types Design a network management architecture that meets the needs of the vSphere environment Virtual Machine Design Make virtual machine design decisions, including decisions about resources Design virtual machines that meet the needs of the applications in the vSphere environment and follow VMware best practices Infrastructure Security Make security design decisions for various layers in the vSphere environment Design a security strategy that meets the needs of the vSphere environment and follows VMware best practices Infrastructure Manageability Make infrastructure manageability design decisions that adhere to business requirements Design an infrastructure manageability strategy that meets the needs of the vSphere environment and follows VMware best practices Infrastructure Recoverability Make infrastructure recoverability design decisions that adhere to business requirements Design an infrastructure recoverability strategy that meets the needs of the vSphere environment and follows VMware best practices Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSphere: Design [v7.0] 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 VMware vSphere: Design [v7.0] 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 lecture and exercise-based course is for individuals who want to understand how to install, configure, and manage an IBM Spectrum Scale storage cluster. Overview After completing this course, you should be able to: Summarize the key features of IBM Spectrum Scale Describe IBM ESS and Spectrum Scale RAID Install IBM Spectrum Scale and configure a cluster Manage a cluster Implement information lifecycle management (ILM) Configure IBM Spectrum Scale high availability features Back up critical cluster data This course is intended for IT professionals tasked with administering an IBM Spectrum Scale storage cluster in environments running Linux and AIX nodes. The course includes information on installing, configuring, and monitoring an IBM Spectrum Scale cluster. Many Spectrum Scale features are described in lecture materials and then implemented in lab exercises. These features include: Storage management, high availability options, cluster management, and information lifecycle management (ILM) tools. Note: Although the lab environment is running the Linux operating system, the differences in Spectrum Scale compared with an AIX environment are minor. Therefore, the skills acquired during the course can be applied in both Linux and AIX environments. Welcome and course overview Unit 1 - IBM Spectrum Scale overview Exercise 1 - Cluster node preparation Unit 2 - Installation and cluster configuration Exercise 2 - Installation and cluster configuration Unit 3 - Cluster management Exercise 3 - Cluster management and configuration Unit 4 - Information Lifecycle Management (ILM) Exercise 4 - Storage pools, filesets, and policies Unit 5 - High availability and cluster data backups Exercise 5 - Replication and snapshots Course wrap-up and evaluation
Duration 5 Days 30 CPD hours About Oracle Database Oracle Database Architecture Database Instance and Storage Starting and stopping Oracle Database Connecting with Oracle Database: Oracle Net Services User and Access Management Authentication Authorisation Auditing Backup & Recovery Data Pump Cold/Hot Backup Flashback RMAN Database Performance and Tuning Transaction Management and Undo Execution Plans and Indexes Enterprise Manager Diagnostics & Tuning Packs Other performance and tuning methods Optional: Introduction to High Availability Automatic Storage Management (ASM) Real Application Clusters (RAC) Data Guard and Active Data Guard Additional course details: Nexus Humans Oracle DBA 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 DBA 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.
Unlock the essentials of material management with our comprehensive course. Explore key modules including forecasting, inventory management, material requirements planning, and purchasing and supply chain management. Gain practical insights into materials handling and effective stores management. Designed for professionals and students alike, this course equips you with the skills to efficiently manage materials and streamline supply chain operations. Join us and enhance your expertise in material management. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Through this programme, students study key components of efficient material management. They start by comprehending the basics, such as the significance of demand forecasting and effective inventory planning and management techniques. They go into detail on material requirements planning, which is an essential ability to guarantee that the appropriate materials are accessible when needed. In order to educate students on how to strategically buy materials and efficiently manage the complete supply chain, purchasing and supply chain management are addressed. The training also covers material handling procedures, with a focus on secure and effective ways to move and store things. In order to maximise accessibility and inventory management, learners ultimately get insights into store administration and control, including how to arrange and supervise material storage. All things considered, this curriculum gives students the real-world information and abilities needed for efficient material management in a variety of businesses. Course Curriculum: Module 01: Introduction to Material Management Module 02: Forecasting Module 03: Inventory Management, Planning and Control Module 04: Material Requirements Planning Module 05: Purchasing and Supply Chain Management Module 06: Materials Handling Module 07: Stores Management and Control Learning Outcomes Understand principles of material management and its importance in industries. Apply forecasting techniques to predict material demand accurately. Implement strategies for effective inventory planning and control procedures. Utilise material requirements planning (MRP) to optimise production processes. Analyse purchasing strategies and their impact on supply chain efficiency. Evaluate methods for efficient material handling and storage management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Material Management 1:04:23 1: Module 01: Introduction to Material Management 07:48 2: Module 02: Forecasting 06:42 3: Module 03: Inventory Management, Planning and Control 09:53 4: Module 04: Material Requirements Planning 10:58 5: Module 05: Purchasing and Supply Chain Management 08:04 6: Module 06: Materials Handling 07:02 7: Module 07: Stores Management and Control 12:56 8: CPD Certificate - Free 01:00 Who is this course for? Professionals seeking knowledge in logistics and supply chain management. Students pursuing careers in operations or industrial management. Individuals interested in enhancing their understanding of inventory control. Career path Warehouse Manager Procurement Officer Inventory Controller Logistics Coordinator Supply Chain Analyst Materials Planner Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Unlock the essentials of material management with our comprehensive course. Explore key modules including forecasting, inventory management, material requirements planning, and purchasing and supply chain management. Gain practical insights into materials handling and effective stores management. Designed for professionals and students alike, this course equips you with the skills to efficiently manage materials and streamline supply chain operations. Join us and enhance your expertise in material management. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access Through this programme, students study key components of efficient material management. They start by comprehending the basics, such as the significance of demand forecasting and effective inventory planning and management techniques. They go into detail on material requirements planning, which is an essential ability to guarantee that the appropriate materials are accessible when needed. In order to educate students on how to strategically buy materials and efficiently manage the complete supply chain, purchasing and supply chain management are addressed. The training also covers material handling procedures, with a focus on secure and effective ways to move and store things. In order to maximise accessibility and inventory management, learners ultimately get insights into store administration and control, including how to arrange and supervise material storage. All things considered, this curriculum gives students the real-world information and abilities needed for efficient material management in a variety of businesses. Course Curriculum: Module 01: Introduction to Material Management Module 02: Forecasting Module 03: Inventory Management, Planning and Control Module 04: Material Requirements Planning Module 05: Purchasing and Supply Chain Management Module 06: Materials Handling Module 07: Stores Management and Control Learning Outcomes Understand principles of material management and its importance in industries. Apply forecasting techniques to predict material demand accurately. Implement strategies for effective inventory planning and control procedures. Utilise material requirements planning (MRP) to optimise production processes. Analyse purchasing strategies and their impact on supply chain efficiency. Evaluate methods for efficient material handling and storage management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Introduction to Material Management 1:04:23 1: Module 01: Introduction to Material Management 07:48 2: Module 02: Forecasting 06:42 3: Module 03: Inventory Management, Planning and Control 09:53 4: Module 04: Material Requirements Planning 10:58 5: Module 05: Purchasing and Supply Chain Management 08:04 6: Module 06: Materials Handling 07:02 7: Module 07: Stores Management and Control 12:56 8: CPD Certificate - Free 01:00 Who is this course for? Professionals seeking knowledge in logistics and supply chain management. Students pursuing careers in operations or industrial management. Individuals interested in enhancing their understanding of inventory control. Career path Warehouse Manager Procurement Officer Inventory Controller Logistics Coordinator Supply Chain Analyst Materials Planner Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.
Construction Management Course This Construction Management Course is our highest-level course, designed for passionate candidates about climbing the corporate ladder to top-level leadership positions. This course is a must-take for those looking for a job in Construction Management Course. This course will give you a comprehensive but easy-to-understand overview of the new construction industry. It will help you hone your practical skills, gain experience, and strengthen your faith in order for you to become a competent and capable Construction Management Course leader. Learning Outcomes After completing this Construction Management Course you will be able to: Describe the importance and features of construction management. Describe how to use methods like project life cycle management, site audit, and cost management. Plan, procure, purchase, and manage material and equipment. Take a broad look at human resource management and on-site interactions. Describe risk and value management, as well as health and wellness. Why Choose Construction Management Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Course developed by industry experts. MCQ quiz after each module to assess your learning. Automated and instant assessment results. 24/7 support via live chat, phone call or email. Main Course: Construction Management Course Free Courses Course 01: Level 7 Project Management Course 02: Property Management [ Note: Free PDF certificate as soon as completing the Construction Management Course ] Construction Management Course Course Curriculum of Construction Management Course Module 01: Introduction to Construction Management Module 02: Arrangement of Construction Projects Module 03: Work Breakdown Structure Explained Module 04: The Process of Estimation and Resources Allocation for a Project Module 05: Planning Project Effectively Module 06: Project Risk Management Module 07: Estimating Cost Module 08: Initial Site Investigation and Assessment Module 09: Site Organisation Module 10: Planning for Construction Equipment Module 11: Managing Construction Equipment Module 12: Managing Construction Materials Module 13: Human Resources Management (HRM) Module 14: Building Better Teams Module 15: Managing Conflict Module 16: Managing Anger and Violence in the Workplace Module 17: Storage Management Module 18: Purchasing and Vendor Management Module 19: Quality Control for Construction Works Module 20: Legal Features of Contracting Assessment Method of Construction Management Course After completing each module of the Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Construction Management Course After completing the MCQ/Assignment assessment for this course, you will be entitled to a Certificate of Completion from Training Tale. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? This Construction Management Course is recommended for anyone looking for work in the construction industry. Requirements There are no specific requirements for the Construction Management Course does not require any advanced knowledge or skills. Career path Construction Management Course Certificates Certificate of completion Digital certificate - Included
Course Overview Food allergies can have serious consequences, even death. Therefore, if you are or want to work in the food industry, you must learn about food allergens to ensure food safety. The Food Allergy Awareness Course is the perfect place to start gathering your knowledge in this area. This course is developed with easy and informative modules. From these modules, you will get introduced to different types of food allergies and their symptoms. In addition, the course will cover lessons on food legislation and help you acquire the skills required to take food safety measures. Then you will learn the strategies to manage food-related risks and be able to raise awareness about food allergies. Enrol in the Food Allergy Awareness Course and develop the expertise to service safe and healthy food to your consumers. Course Sneak Peek Learning Outcomes Get introduced to different food allergens Learn about the causes and symptoms of different food allergies Understand the legislation regarding food safety Develop the skills and knowledge required for taking safety precautions Build your expertise in managing food-related risks Understand how to create awareness for food allergies and their consequences Course Promo Why Should Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Food Safety Management Storage Management Who Should Take this Food Allergy Awareness Course? Whether you're an existing practitioner or an aspiring professional, this course will enhance your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Food Allergy Awareness Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing and passing the Food Allergy Awareness Course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in Hard Copy at £39 or in PDF format at £24. Career Path This exclusive Food Allergy Awareness Course will equip you with effective skills and abilities and help you explore career paths such as ChefsRestaurant Owner Restaurant staffCaterer Course Curriculum Module 01: Understanding Food Allergies Understanding Food Allergies 00:10:00 Module 02: More Causes and Symptoms of Food Allergies More Causes and Symptoms of Food Allergies 00:10:00 Module 03: Allergen Facts and Legislation Allergen Facts and Legislation 00:10:00 Module 04: Practical Precautions and Consumer Protection Practical Precautions and Consumer Protection 00:12:00 Module 05: Managing Risks and Storing Food Managing Risks and Storing Food 00:11:00 Module 06: Allergy Awareness and Support Allergy Awareness and Support 00:11:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00