25202 Business courses

Elevate your environmental consciousness with our Environmental Awareness Training. From pollution understanding to sustainable practices and legal standards, this course empowers you with the knowledge to make a positive impact on our planet.

The Line Management course aims to provide individuals with comprehensive knowledge about the roles, responsibilities, and essential skills necessary to excel as a competent line manager.

Understand how to effectively manage conflict and learn that conflict can be healthy and need not damage relationships. Course overview Duration: 1 day (6.5 hours) Conflict and differences of opinion are inevitable in the today’s fast moving, complex business world, some would argue they are even necessary. This highly interactive and practical course addresses the many aspects of effectively managing conflict and will help you ensure that conflict can be healthy and need not damage the relationship. This workshop has been specifically designed to give you an opportunity to learn and test a range of influencing and conflict handling models and techniques. The course is aimed at anyone who interacts with others on a regular basis. Objectives  By the end of the course you will be able to: Utilise influencing skills to pre-empt and defuse conflict Resolve conflict by choosing the right approach Recognise the impact of non-verbal communication in managing conflict Use language skills necessary to get you message across in the ‘right’ way Present your case in a reasonable and responsible manner Identify behaviours that can help or hinder interactions with others Apply different techniques for managing conflict positively and for dealing with aggression Content Developing Influence Networking Sources of influence Influencing techniques Effective Behaviour Choosing the right approach Techniques to pre-empt or defuse conflict Behavioural styles and their impact on working relationships Triggers to aggressive behaviour Managing conflict flash points Dealing with different behaviour types Developing Skills Communication skills in conflict situations Using the right language Verbal and non verbal communications Managing our body language Your conflict management style analysis Thomas Killman Conflict Handling Instrument Working in groups Practical exercises and case studies The language of mediation Transactional Analysis Practical Practical exercises Case studies Personal action planning

Initiate a transformative journey towards personal growth with our course, 'Building Self-Confidence: A Holistic Approach.' This course is a beacon for those seeking to enhance their self-assurance and personal presence in all aspects of life. It starts with an in-depth exploration of what confidence truly means, setting the tone for a deeper self-understanding. Each module is carefully designed to guide you from recognizing your current confidence levels to pinpointing the challenges that hinder your self-assurance. This course is not merely about theoretical knowledge; it's an interactive journey aimed at fostering a robust sense of self-confidence that resonates in your personal and professional life. Progress through the curriculum to learn practical strategies for building self-confidence, including how to develop a positive physical presence and effectively communicate your newfound confidence. The course also delves into the importance of demonstrating confidence in the workplace, offering insights and techniques to assert yourself in professional environments. The final module on building respectful relationships ties together the skills and knowledge acquired throughout the course, emphasizing the role of confidence in forming healthy, productive relationships. By completing this course, you will emerge not just with a theoretical understanding of confidence, but with practical tools and a renewed sense of self, ready to tackle life's challenges with poise and assurance. Learning Outcomes Gain a comprehensive understanding of the nature of self-confidence. Learn to accurately assess and identify your current confidence levels. Develop practical strategies for overcoming personal confidence barriers. Enhance your physical presence and communication skills to reflect confidence. Understand the importance of confidence in building professional relationships and workplace dynamics. Why choose this Building Self-Confidence: A Holistic Approach course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Building Self-Confidence: A Holistic Approach course for? Individuals seeking to boost their self-confidence and self-esteem. Professionals aiming to improve their workplace presence and assertiveness. Students and young adults preparing for new challenges and opportunities. Team leaders and managers looking to foster a confident work environment. Anyone interested in personal development and effective communication skills. Career path Life Coach: £25,000 - £50,000 Human Resources Specialist: £27,000 - £45,000 Public Relations Officer: £24,000 - £40,000 Corporate Trainer: £30,000 - £55,000 Personal Development Consultant: £28,000 - £52,000 Team Leader/Manager: £32,000 - £60,000 Prerequisites This Building Self-Confidence: A Holistic Approach does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Building Self-Confidence: A Holistic Approach was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Understanding Confidence Understanding Confidence 00:12:00 Module 02: Assessing Your Confidence Assessing Your Confidence 00:08:00 Module 03: Identifying Your Sticking Points Identifying Your Sticking Points 00:06:00 Module 04: Building Self-Confidence Building Self-Confidence 00:12:00 Module 05: Developing Physical Confidence Developing Physical Confidence 00:09:00 Module 06: Communicating Your Confidence Communicating Your Confidence 00:09:00 Module 07: Demonstrating Confidence in the Workplace Demonstrating Confidence in the Workplace 00:14:00 Module 08: Building Respectful Relationships Building Respectful Relationships 00:07:00

Embark on a transformative journey with our Diet and Nutrition Coach Certification course, designed to equip you with the expertise needed to excel in the dynamic field of nutrition coaching. Delve into the intricate realm of nutrition theory, energy metabolism, and food digestion as you hone your skills to become a proficient nutrition coach. Whether you're aspiring to launch a rewarding career or enhance your knowledge, our comprehensive curriculum caters to beginners and advanced learners alike, ensuring a seamless learning experience. As you immerse yourself in this course, you'll unravel the complexities of working with clients, mastering the art of assisting them in weight loss and muscle building journeys. From decoding famous diets to crafting optimal nutrition plans for athletes, you'll gain invaluable insights into the diverse facets of nutrition coaching. With the flexibility of online learning, our UK-based programme opens doors to endless opportunities, empowering you to become a sought-after fitness and nutrition coach in your locality or beyond. Elevate your expertise with our online nutrition coach certification, tailored to meet the demands of the ever-evolving wellness industry. Join our community of learners and embark on a transformative journey towards becoming a certified nutrition coach, equipped with the knowledge and skills to make a meaningful impact on individuals' health and well-being. Learning Outcomes: Master the fundamental principles of nutrition theory and energy metabolism. Develop proficiency in crafting personalised nutrition plans for clients to aid in weight loss and muscle building. Acquire in-depth knowledge of various diets and supplements, enhancing your ability to cater to diverse client needs. Hone your communication and coaching skills to effectively support clients in achieving their health goals. Gain practical experience through case studies and client interactions, preparing you for real-world scenarios as a nutrition coach. Why buy this Diet And Nutrition Coach Certification? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Diet And Nutrition Coach Certification: Beginner To Advanced there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Diet And Nutrition Coach Certification course for? Individuals passionate about health and wellness. Fitness enthusiasts seeking to expand their expertise. Health professionals aiming to integrate nutrition coaching into their practice. Career changers aspiring to enter the nutrition coaching industry. Anyone interested in understanding the science behind nutrition and its practical applications. Prerequisites This Diet And Nutrition Coach Certification: Beginner To Advanced does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diet And Nutrition Coach Certification: Beginner To Advanced was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Nutrition Coach: £20,000 - £35,000 per annum Fitness and Nutrition Coach: £25,000 - £40,000 per annum Online Nutrition Coach UK: £20,000 - £45,000 per annum Online Nutrition Coaching Centre Oowner: Earnings vary based on experience and location. Course Curriculum Introduction Introduction & What You Will Learn 00:03:00 How To Get Your Certificate 00:01:00 The Roles & Responsibilitites Of A Diet Coach 00:02:00 Nutrition Theory What Is Nutrition 00:01:00 Meal Planning Explained 00:04:00 Calories Explained 00:04:00 Macronutrients Explained 00:01:00 What Is Protein: Explained 00:02:00 How Much Protein Does Your Body Need 00:04:00 What Is Dietary Fat: Explained 00:03:00 How Much Fat Does Your Body Need 00:04:00 What Are Carbohydrates: Explained 00:03:00 The Different Types Of Carbs 00:05:00 How Much Protein Does Your Body Need 00:04:00 Meal Timing Explained 00:01:00 When & How Often Should You Consume Protein 00:04:00 When & How Often Should You Consume Carbs 00:02:00 When & How Often Should You Consume Fat 00:01:00 Food Sources Explained 00:02:00 Protein Composition 00:02:00 Carbohydrate Composition 00:03:00 Fat Composition 00:01:00 Energy Metabolism Energy Metabolism Explained 00:02:00 Aerobic vs Anaerobic Energy Metabolism 00:02:00 Food Digestion Digestion Introduction 00:03:00 Carbohydrate Digestion 00:02:00 Protein Digestion 00:02:00 Fat Digestion 00:02:00 Working With Clients Client Assessment 00:01:00 Client Interview 00:04:00 How To Set SMART Dieting Goals 00:06:00 How To Design Your First Diet Plan 00:09:00 Body Mass Index Explained 00:03:00 Helping Clients Lose Weight The Science Of Successful Weight Loss 00:05:00 Determining Calorie Needs 00:03:00 How To Take Diet Breaks Correctly 00:05:00 Breaking Through Fat Loss Plateaus 00:04:00 Explaining Unexpected Weight Changes 00:03:00 Is Starvation Mode Real? 00:03:00 Helping Client Build Muscle How To Create A Muscle Building Diet 00:04:00 The Perfect Pre-Workout Meal 00:04:00 The Perfect Post-Workout Meal 00:02:00 The Best Muscle Building Foods 00:02:00 Foods To Boost Testosterone 00:04:00 What Should You Eat Before Going To Bed To Build Muscle 00:03:00 Famous Diet Explained Famous Diets Introduction 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:04:00 Low Carb Diet Explained 00:03:00 Intermittent Fasting Explained 00:03:00 Vegan Diet Explained 00:05:00 Ketogenic Diet Explained 00:06:00 Optimal Diet For Athletes Athlete Diets Introduction 00:01:00 Strength Training 00:02:00 Endurance Training 00:02:00 Ball Sports & Martial Arts 00:02:00 Supplements Supplement Introduction 00:01:00 Whey Protein 00:06:00 BCAAs 00:04:00 Creatine 00:04:00 Fish Oil 00:03:00 Glutamine 00:05:00 caffeine 00:04:00 Vitamins & Minerals Vitamin A 00:03:00 Vitamin B 00:02:00 Vitamin C 00:03:00 Vitamin D 00:02:00 Vitamin E 00:01:00 Vitamin K 00:01:00 9 Calcium supplements copy 00:03:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Iron 00:01:00 Zinc 00:02:00

Unlock the mysteries of the mind with our transformative course, 'Meditation and Mindfulness.' Dive into the depths of your consciousness as we guide you through the labyrinth of thoughts and emotions. Discover the power of meditation to quiet the chaos within and unleash your inner tranquillity. From the enigmatic workings of criminal minds to the serene practices of mindfulness meditation, embark on a journey towards self-discovery and inner peace. Myriad paths await exploration in the realm of meditation. Learn how to meditate with expert guidance, from the gentle embrace of sleep meditation to the profound depths of transcendental meditation. Delve into the nuances of mindfulness meditation, honing your awareness and cultivating a sense of presence in each moment. Through guided meditation, unlock the secrets to calming the restless mind and nurturing a deeper connection to yourself and the world around you. As you navigate through our comprehensive curriculum, you'll gain invaluable insights into the art of meditation and mindfulness. Master techniques for overcoming anxiety and stress, equipping yourself with powerful anti-anxiety skills and concepts. Harness the transformative potential of meditation to cultivate a greater sense of calm, clarity, and well-being in your daily life. Join us on this journey of self-discovery and embark on a path towards a more harmonious existence. Learning Outcomes: Develop a deep understanding of meditation techniques, including sleep meditation and transcendental meditation. Acquire practical skills for meditation for sleep. Cultivate heightened awareness and presence through guided meditation sessions. Explore the intricate workings of the mind and its impact on emotional well-being. Discover the transformative power of meditation in fostering inner peace and resilience. Why buy this Meditation and Mindfulness course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Meditation & Mindfulness there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Meditation and Mindfulness course for? Individuals are seeking effective strategies for how to meditate and manage anxiety and stress. Anyone interested in exploring the profound benefits of meditation and mindfulness. Students looking to enhance their mental well-being and emotional resilience. Professionals in high-pressure environments seeking tools for maintaining balance and clarity. Those curious about the intersection of psychology and contemplative practices. Prerequisites This Meditation & Mindfulness does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Meditation & Mindfulness was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Meditation Instructor: £20,000 - £35,000 Per Annum Mindfulness Coach: £25,000 - £40,000 Per Annum Mental Health Counsellor: £30,000 - £45,000 Per Annum Wellness Consultant: £25,000 - £40,000 Per Annum Stress Management Specialist: £25,000 - £40,000 Per Annum Holistic Therapist: £20,000 - £35,000 Per Annum Course Curriculum Introduction & First Concepts Introduction To Mindful Meditation 00:06:00 Understanding Mindful Meditation 00:05:00 How To Practice Mindful Meditation 00:06:00 Understanding & Beating Anxiety Still More Mindful Meditation Techniques 00:05:00 Mindful Meditation & Your Brain 00:04:00 Why Is Awareness So Important 00:09:00 More Anti-Anxiety Skills & Concepts Mindful Meditation & Work 00:05:00 Mindful Meditation & Relationships 00:04:00 Mindful Meditation & Happiness 00:05:00 Famous & Successful People Who Meditate 00:04:00 Great Mindful Meditation Apps 00:05:00 The Many Benefits Of Mindful Meditation 00:09:00 How To Create A Mindful Life 00:06:00 Conclusion Conclusion - Final Thoughts & Tips 00:01:00 Assignment Assignment - Meditation & Mindfulness 00:00:00

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Kettlebell Fitness Training Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Kettlebell Fitness Training Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Kettlebell Fitness Training Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Kettlebell Fitness Training Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Kettlebell Fitness Training? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Kettlebell Fitness Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Kettlebell Fitness Training course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Kettlebell Fitness Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Kettlebell Fitness Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Kettlebell Fitness Training is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction 00:03:00 How To Properly Choose A Kettlebell 00:03:00 Benefits Of Kettebell Training 00:10:00 Common Kettlebell Mistakes Common Mistakes During Kettlebell Exercises 00:03:00 Common Mistakes During Kettlebell Exercises 00:03:00 Kettlebell Workout Ways To Use Kettlebells 00:03:00 Kettlebell Workouts For Beginners 00:21:00 Kettlebell Workout Plans 00:06:00 Kettlebell Workout Tips & Tricks 00:02:00 Conclusion Conclusion 00:03:00 Assignment Assignment - Kettlebell Fitness Training 00:00:00

Embrace the art of effortless communication with our comprehensive Master Yourself in Talking with Strangers course. This transformative journey will equip you with the knowledge and skills to confidently navigate social interactions, build meaningful connections, and overcome the fear of striking up conversations with strangers. Ditch the awkward silences and self-doubt, and unlock the confidence to initiate and engage in engaging conversations with anyone, anywhere. Discover the psychology behind effective communication, understanding how to read social cues, adapt your approach to different personalities, and maintain engaging conversations. Learning Outcomes Eradicate the fear of approaching and conversing with strangers Master the art of initiating and maintaining engaging conversations Develop effective communication skills to build meaningful connections Understand the psychology behind effective communication and social cues Adapt your conversational approach to suit different personalities and situations Why choose this Master Yourself in Talking with Strangers course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Master Yourself in Talking with Strangers course for? Individuals seeking to overcome shyness and social anxiety to confidently connect with others Professionals aiming to expand their network and build meaningful relationships Anyone interested in improving their communication skills and conversational fluency Individuals who want to feel more comfortable and confident in social settings Those seeking to enhance their personal and professional life through effective communication Career path Human Resources Specialist (£30,000 - £50,000) Sales Representative (£30,000 - £50,000) Account Executive (£40,000 - £60,000) Public Relations Specialist (£35,000 - £55,000) Customer Service Representative (£25,000 - £45,000) Entrepreneur (£50,000 - £100,000) Prerequisites This Master Yourself in Talking with Strangers does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Master Yourself in Talking with Strangers was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Course Overview Welcome 00:01:00 Disclaimer 00:02:00 Section 02: The Formula How to Deal with Rejection 00:03:00 Who are the Right People for You (The LA Rule, Step 1) 00:01:00 Where to Meet the Right People 00:04:00 What to Talk About (The LA Rule, Step 2) 00:02:00 What to Talk About with COMPLETE STRANGERS 00:06:00 Have a Joke to Spare 00:05:00 Unspoken Words 00:07:00 How to Maintain the Relationship 00:01:00 Section 03: Summary The Most Important Things from the Course 00:01:00 Section 04: End Thank You 00:01:00 Assignment Assignment - Master Yourself in Talking with Strangers 00:00:00

Limited Time Sales: CPD Certified | 37 Video Lessons | Free PDF Certificate | Lifetime Access

Duration 5 Days 30 CPD hours This course is intended for Data Warehouse AdministratorDatabase Administrators Overview Use the Oracle Database tuning methodology appropriate to the available toolsUtilize database advisors to proactively tune an Oracle Database InstanceUse the tools based on the Automatic Workload Repository to tune the databaseDiagnose and tune common SQL related performance problemsDiagnose and tune common Instance related performance problemsUse Enterprise Manager performance-related pages to monitor an Oracle DatabaseGain an understanding of the Oracle Database Cloud Service In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service. Introduction Course Objectives Course Organization Course Agenda Topics Not Included in the Course Who Tunes? What Does the DBA Tune? How to Tune Tuning Methodology Basic Tuning Diagnostics Performance Tuning Diagnostics Performance Tuning Tools Tuning Objectives Top Timed Events DB Time CPU and Wait Time Tuning Dimensions Time Model Dynamic Performance Views Using Automatic Workload Repository Automatic Workload Repository Overview Automatic Workload Repository Data Enterprise Manager Cloud Control and AWR Snapshots Reports Compare Periods Defining the Scope of Performance Issues Defining the Problem Limiting the Scope Setting the Priority Top SQL Reports Common Tuning Problems Tuning During the Life Cycle ADDM Tuning Session Performance Versus Business Requirements Using Metrics and Alerts Metrics and Alerts Overview Limitation of Base Statistics Benefits of Metrics Viewing Metric History Information Viewing Histograms Server-Generated Alerts Setting Thresholds Metrics and Alerts Views Using Baselines Comparative Performance Analysis with AWR Baselines Automatic Workload Repository Baselines Moving Window Baseline Baselines in Performance Page Settings Baseline Templates AWR Baseslines Creating AWR Baselines Managing Baselines with PL/SQL Using AWR-Based Tools Automatic Maintenance Tasks ADDM Performance Monitoring Using Compare Periods ADDM Active Session History New or Enhanced Automatic Workload Repository Views Emergency Monitoring Real-time ADDM Real-Time Database Operation Monitoring Overview Use Cases Defining a Database Operation Scope of a Composite Database Operation Database Operation Concepts Identifying a Database Operation Enabling Monitoring of Database Operations Identifying, Starting, and Completing a Database Operation Monitoring Applications What is a Service? Service Attributes Service Types Creating Services Managing Services in a Single-Instance Environment Where are Services Used? Using Services with Client Applications Services and Pluggable Databases Identifying Problem SQL Statements SQL Statement Processing Phases Role of the Oracle Optimizer Identifying Bad SQL Top SQL Reports SQL Monitoring What is an Execution Plan? Methods for Viewing Execution Plans Uses of Execution Plans Influencing the Optimizer Functions of the Query Optimizer Selectivity Cardinality and Cost Changing Optimizer Behavior Optimizer Statistics Extended Statistics Controlling the Behavior of the Optimizer with Parameters Enabling Query Optimizer Features Reducing the Cost of SQL Operations Reducing the Cost Index Maintenance SQL Access Advisor Table Maintenance for Performance Table Reorganization Methods Space Management Extent Management Data Storage Using SQL Performance Analyzer Real Application Testing: Overview Real Application Testing: Use Cases SQL Performance Analyzer: Process Capturing the SQL Workload Creating a SQL Performance Analyzer Task SQL Performance Analyzer: Tasks Parameter Change SQL Performance Analyzer Task Page SQL Performance Management Maintaining SQL Performance Maintaining Optimizer Statistics Automated Maintenance Tasks Statistic Gathering Options Setting Statistic Preferences Restore Statistics Deferred Statistics Publishing Automatic SQL Tuning Using Database Replay Using Database Replay The Big Picture System Architecture Capture Considerations Replay Considerations: Preparation Replay Considerations Replay Options Replay Analysis Tuning the Shared Pool Shared Pool Architecture Shared Pool Operation The Library Cache Latch and Mutex Diagnostic Tools for Tuning the Shared Pool Avoiding Hard Parses Reducing the Cost of Soft Parses Sizing the Shared Pool Tuning the Buffer Cache Oracle Database Architecture: Buffer Cache Buffer Cache: Highlights Database Buffers Buffer Hash Table for Lookups Working Sets Buffer Cache Tuning Goals and Techniques Buffer Cache Performance Symptoms Buffer Cache Performance Solutions Tuning PGA and Temporary Space SQL Memory Usage Performance Impact Automatic PGA Memory SQL Memory Manager Configuring Automatic PGA Memory Setting PGA_AGGREGATE_TARGET Initially Limiting the size of the Program Global Area (PGA) SQL Memory Usage Automatic Memory Oracle Database Architecture Dynamic SGA Granule Memory Advisories Manually Adding Granules to Components Increasing the Size of an SGA Component Automatic Shared Memory Management: Overview SGA Sizing Parameters: Overview Performance Tuning Summary with Waits Commonly Observed Wait Events Additional Statistics Top 10 Mistakes Found in Customer Systems Symptoms Oracle Database Cloud Service: Overview Database as a Service Architecture, Features and Tooling Software Editions: Included Database Options and Management Packs Accessing the Oracle Database Cloud Service Console Automated Database Provisioning Managing the Compute Node Associated With a Database Deployment Managing Network Access to Database as a Service Scaling a Database Deployment Performance Management in the Database Cloud Environment Performance Monitoring and Tuning What Can be Tuned in a DBCS Environment?