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 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. 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. Course Outline Advanced Monitoring Db2 Table Space Management Db2 Database Memory Management Database rebuild supportDb2 database and tablespace relocation Db2 Incremental Backup Additional course details: Nexus Humans CL464G IBM Db2 11.1 Advanced Database Administration 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 CL464G IBM Db2 11.1 Advanced Database Administration 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.
This course enables providers and their staff to develop an understanding of the responsibilities and duties around the Mental Capacity Act 2005 (MCA). This essential training is for workers involved in the care, treatment and support of adults who may lack capacity in making life decisions. This training offers vital support for social care providers, so they comply with the Mental Capacity Act and Care Quality Commission requirements and promote human rights.
This course provides both underpinning knowledge of stoma care and practical techniques to deliver person centred support for someone who requires stoma care.
This course provides attendees with the knowledge required to assess and care for service users with dysphagia.
This course explores Autism and the current body of thinking and knowledge around Autistic Spectrum Disorders. This enables learners to consider how to adapt their practice with useful strategies to better support an individual with autism.
Interpreter: Basic Techniques of Dream Interpretation Prepare to embark on a fascinating journey into the realm of dreams with our Basic Techniques of Dream Interpretation Course. Gain a comprehensive Introduction to Dream Interpretation and delve into the intriguing Psychology of Dreams. Learning Outcomes: Identify the foundations of dream interpretation theory. Analyze the psychology underlying dream symbolism and content. Apply effective techniques for interpreting dreams. Examine common dream themes and their interpretations. Advance your proficiency in dream interpretation practice. More Benefits: LIFETIME access Device Compatibility Free Workplace Management Toolkit Interpreter: Basic Techniques of Dream Interpretation Course Syllabus Introduction to Dream Interpretation: Gain a foundational understanding of dream interpretation and its significance in psychology and personal development. The Psychology of Dreams: Explore the psychological aspects of dreams, including their role in the unconscious mind and their relevance in therapy. Techniques of Dream Interpretation: Learn practical techniques and methodologies for interpreting dreams effectively, including symbolism and analysis. Common Dreams and Their Meanings: Identify and interpret common types of dreams, uncovering their symbolic meanings and implications. The Universal Language of Dreams: Understand the idea of dreams as a universal language transcending cultural boundaries and how to interpret them cross-culturally. Advancing Your Dream Interpretation Practice: Further develop your skills and expertise in dream interpretation, enabling you to provide valuable insights to individuals seeking to understand their dreams.
This course is designed to suit a broad range of Care Sector staff. This training ensures that learners are equipped with a sufficient knowledge of mental health disorders so that they are able to manage and provide a high standard of support to affected service users. Learners will also know how to identify the symptoms of different mental disorders, adding real value to any organisation to which they provide services to.
What are the aims of this course? What learning disability is and isn't The facts of learning disabilities What barriers people with learning disabilities face Medical barriers Societal barriers How to support people with learning disabilities
This course will explore what we mean when we say someone has asthma
Dealing with Angry or Rude Customers Course Description Copyright Ross Maynard 2021 Course Description If you work in customer service in any way, then, from time to time, you are going to have to deal with angry or rude customers. This course will help you manage those stressful situations and support the customer as best you can. Anger is a normal and relatively common emotion caused by a perceived hurt or provocation. In some cases a customer’s anger or rude behaviour may be driven by the failings of your organisation or its products and services. In other cases, the problem may be outside your control but you still have to deal with the impact. In this course we look at anger in a customer service situation and how to deal with it. We review the nature and causes of anger; we look at how poor customer service can cause anger and what you can do to prepare your organisation to deal with anger. We cover the warning signs for anger and present a 12 step approach to dealing with an angry customer. We cover questions and short scripts that can help you start a discussion with an angry customer, and we consider why customers might be rude. Finally we look at managing the stress of dealing with an angry customer and finish the course with a review of the key learning points. I hope you find the course helpful. Key Learning Points On completion of the course, delegates will be able to: Understand the nature and causes of anger as an emotion. Consider their objectives when dealing with an angry customer. Help prepare their organisation for dealing with angry customers. Identify appropriate customer service metrics Work through a series of steps to deal with an angry customer. Use questions and short scripts to try to help a customer bring their anger under control . Consider why a customer might be rude, and how to deal with that rudeness. Understand how to manage the stress of dealing with angry or rude customers. Curriculum L1: Anger as an Emotion L2: Your Objectives when Dealing with Anger L3: Poor Customer Service L4: Preparing your Organisation L5: Warning Signs and What Not to Do L6: The 12 Steps to Dealing with Anger L7: Example Scripts for Angry Customers L8: Dealing with Rude Customers L9: Dealing with Stress, and Key Learning Points Pre-Course Requirements There are no pre-course requirements Additional Resources Copy of customer behaviour policy Course Tutor Your tutor is Ross Maynard. Ross is a Fellow of the Chartered Institute of Management Accountants in the UK and has 30 years’ experience as a process improvement consultant specialising in business processes and organisation development. Ross is also a professional author of online training courses. Ross lives in Scotland with his wife, daughter and Cocker Spaniel