2617 History courses

About Course Unlock key insights with our comprehensive guide to market research - propel your business towards unprecedented growth Our immersive online course on Market Research provides a comprehensive exploration into the intricate art and science of understanding consumer behaviour, trends, and market dynamics. Do you want to grow your business and take it to new heights? Achieving sustainable growth requires a deep understanding of your target audience and a keen awareness of industry trends. This marketing course equips you with the knowledge and skills required to understand your target customers and their needs. We start with a brief history and definition of 'market research' before we lay out the six steps of the market research process. This course examines the classifications of market research and explains how to identify research problems to set up the market research process. We show you how to develop and design a market research approach. We also trace the relationship between market problems and research design by distinguishing between exploratory, descriptive and causal research. The course goes over data analysis techniques and discusses how to deliver effective presentations of research findings to facilitate analysis and discussion. We cover qualitative and quantitative market research methods and provide examples to help you with questionnaire design with examples of open- and closed-end questions. We demonstrate data analysis techniques to help you leverage your research findings to make better business decisions. Finally, the course explains how to communicate research results while adhering to market research ethics. This course has no prerequisites and suits anyone interested in business and marketing. It is particularly useful for small business owners, entrepreneurs and marketers and helps you to create focused marketing campaigns that connect with your audience to boost customer engagement, brand loyalty and business success. Sign up to learn how to conduct market research that lets you understand consumer behaviour, spot gaps in the market and grow your business. Whether you're a budding marketer, a business owner, or a student of the commerce field, this course offers a comprehensive and practical guide to mastering market research. Enroll now to gain the knowledge and skills that can help shape business strategies, influence product development, and drive business success. What Will You Learn? Discuss the importance of market research in supporting marketing decision-making Identify the factors that influence the decision to conduct market research Outline the key components of a market research proposal Discuss the significance of problem identification in marketing research Analyse the key characteristics and advantages of qualitative research Recognise the factors that affect the sample size and accuracy in quantitative research Identify the key components and goals of a questionnaire Explain the importance of data validation and quality control Summarise the significance of the report and presentation as key components of marketing research Discuss the ethical principles of research methodology and the importance of integrity in market research Course Content Introduction to Market Research Introduction to Market Research The Market Research Process The Market Research Process Market Research Design Market Research Design Defining the Problem & Developing Research Approach Defining the Problem & Developing Research Approach Qualitative Market Research Qualitative Market Research Quantitative Market Research Quantitative Market Research Questionnaire Design Questionnaire Design Data Analysis Data Analysis Communicating Research Results Communicating Research Results Research Ethics Research Ethics Conclusion Conclusion A course by Xpert Learning Audience Marketers Current and aspiring product managers Business executives Consultants Entrepreneurs

If you do not have time to attend a class or work full-time but want to advance your education, this introduction to psychology course is ideal. This course can be completed at any time, from anywhere! This Psychology course provides up-to-date information about the world of psychology in an easy-to-follow format. This Psychology course will highlight interesting experiments in psychology and discuss the implications of those studies for our understanding of the human mind and behaviour. First, you will learn about the brain and some of the cognitive abilities it supports, such as memory, learning, attention, perception, and consciousness. Following that, we will take a look at human development in terms of growing up and growing old, as well as how the behaviour of others affects our thoughts and behaviour. Finally, we will discuss various types of mental illnesses and the available treatments to help those who are affected by them. This Psychology course is designed to boost your employability and provide you with the necessary skills to succeed. So, enrol in this Psychology course now and start learning! Learning Outcomes By the end of this Psychology course, the learner will be able to: Describe the fundamentals of psychology. Understand the evolution of psychology. Explain sensation and perception. Understand the states of consciousness. Gain in-depth knowledge about learning. Describe memories and forgetting. Explain thinking and intelligence. Understand emotion and motivation. Understand human development. Understand personality. Describe social psychology. Explain psychological disorders. Treat psychological disorders. Explain health stress and coping. Why Choose This Psychology 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. Free PDF certificate as soon as completing the course. ***Courses Included Of This Psychology bundle Course Course 01: Introduction to Psychology Course 02: Autism Diploma Course 03: ADHD Awareness Course Course 04: Diploma in Mastering Psychology >> Other Benefits of this Psychology Course Free 4 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Psychology course ] Course Curriculum Of Introduction to Psychology Module 01: Introducing Module 02: Central Questions, History, and Contemporary Perspectives Module 03: Sensation and Perception Module 04: States of Consciousness Module 05: Learning Module 06: Memories And Forgetting Module 07: Thinking and Intelligence Module 08: Emotion and Motivation Module 09: Human Development Module 10: Personality Module 11: Social Psychology Module 12: Psychological Disorders Module 13: Treating Psychological Disorders Module 14: Health Stress and Coping >>-------------<< Assessment Method After completing each module of the Psychology 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 After completing the MCQ/Assignment assessment for this Psychology 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? Psychology course is ideal for anyone interested in pursuing a career in psychology. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain accredited certification to prove your newly acquired knowledge. Requirements There are no specific requirements for this Psychology course because it does not require any advanced knowledge or skills. Career path This Psychology course will present you with the skills and certificates you need to demonstrate your new talents and increase the value of your CV. You will get a solid understanding of the basic abilities required to propel a successful career in your chosen industry. Certificates Certificate of completion Digital certificate - Included

Everyone wants to try brow lamination, which is a new popular treatment. Brow Lamination originated in Moscow and was brought to the UK. The treatment's goal is to achieve fuller, thicker, but still natural-looking brows. This treatment is ideal for clients who prefer the soft brow look but want their brows to appear well groomed, tidy, and fierce. The treatment will take up to 30 minutes to complete, with results lasting up to 2 months. This treatment works well with brow shaping and brow tinting, allowing you to offer a complete brow treatment to your clients. This Brow Lamination course will teach you how to effectively perform the popular brow lamination treatment on your clients. If you want to work as a makeup artist or makeup professional or learn more skills on brow lamination but aren't sure where to begin, this Brow Lamination course will provide you with a solid foundation to become a confident makeup artist or makeup professional and develop more advanced skills on brow lamination. Through this Brow Lamination course you will learn how to create perfectly styled brows. This Brow Lamination course will provide you with a competitive advantage in your career, allowing you to stand out from other applicants and employees. Our experts have designed this Brow Lamination course to help you learn fast and efficiently, at your own speed and convenience. Enrol now and start learning. Learning Outcomes After completing the Brow Lamination course, the learner will be able to - Gain a solid understanding of Brow Lamination Understand different products. Know how to maintain Hygiene, health and safety. Know how to do sterilisation. Understand professional ethics. Understand Anatomy and physiology. Know waxing and brow lamination steps. Know treatable non-medical conditions. Know how to do aftercare. << Courses 01: Brow Lamination Course << Courses 02: Hopi Ear Candling << Benefits of Brow Lamination Course >> Free 2 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Brow Lamination course] Course curriculum *** Brow Lamination Course *** Module 1: Brow Lamination What is Brow Lamination? Brow Lamination Kit Lamination Instructions Lamination benefits Potential Risks and Side effects Module 2: Essential Knowledge Health & Safety Anatomy and Physiology Skin diseases and disorders Consultation Card Patch testing Module 3: The Treatment Process Waxing and Brow Lamination Step Creating a Brow Map Aftercare of treatment ------------------------------- << Course 02: Hopi Ear Candling >> Module 1: Hopi Ear Candling What Are Hopi Ear Candles The History of Hopi Ear Candles Benefits of Hopi Ear Candles Module 2: The Treatment Process The Routine Equipment and Products Aftercare Module 3: Hygiene, Health and Safety Hygiene, Health and Safety Carrying out a Risk Assessment Storage and Insurance Module 4: Anatomy and Physiology The Ear and its Functions Facial Muscles Sinus Cavities Module 5: Client Consultation Client Consultation Contra-Indication Contra-Actions -------------------- Assessment Method After completing each module of the Brow Lamination 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 After completing the MCQ/Assignment assessment for this Brow Lamination 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 Brow Lamination course is appropriate for anyone who want to work as a makeup artist or makeup professional. Requirements There are no specific requirements for this course because it does not require any advanced knowledge or skills. Career path After completing this Brow Lamination Course, you may able to pursue a variety of promising career opportunities, such as: Beauty therapist Makeup artist Makeup professional

Are you passionate about natural medicine and eager to help others achieve optimal health and well-being? Our comprehensive Diploma on Homeopathy is designed to equip you with the knowledge and skills necessary to become a proficient practitioner in this holistic healing art. Join us and embark on a journey to understand and master the principles and practices of homeopathy, an effective and natural system of medicine. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access This Diploma in Homeopathy course provides a comprehensive overview of homeopathy, from its basic principles to its practical applications. Learners will start by understanding the history and foundational theories of homeopathy. They will gain skills in treating patients using homeopathic remedies and learn to apply these remedies for first aid. The course covers specialized treatments for skin problems, children, and women's health, as well as specific conditions affecting the reproductive, nervous, limbic, immune, digestive, circulatory, respiratory, and musculoskeletal systems. Additionally, students will explore homeopathy's role in modern healthcare and its potential future developments. By the end of the course, learners will be well-equipped to practice homeopathy effectively in various health situations. Course Curriculum Module 01: Introduction to Homoeopathy Module 02: Principles and Theories Behind the Practice Module 03: How to Treat Patients Module 04: Homoeopathic Remedies Module 05: First Aid with Homoeopathic Remedies Module 06: Homoeopathy for Skin Problems Module 07: Homoeopathy for Children and Women's Health Module 08: Practice of Homoeopathy on the Reproductive Systems Module 09: Practice of Homoeopathy on the Nervous System Module 10: Practice of Homoeopathy on the Limbic System Module 11: Practice of Homoeopathy on the Immune System Module 12: Practice of Homoeopathy on the Digestive System Module 13: Practice of Homoeopathy on the Circulatory System Module 14: Practice of Homoeopathy on the Respiratory System Module 15: Practice of Homoeopathy on the Musculoskeletal System Module 16: Homoeopathy's Role in Present and Future Learning Outcomes Understand the fundamental principles and theories behind homoeopathy practice. Learn how to effectively treat patients using homoeopathic methods. Identify and apply various homoeopathic remedies appropriately. Provide first aid using homoeopathic remedies in emergency situations. Address skin problems with specialised homoeopathic treatments. Apply homoeopathy to children's and women's health concerns. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma on Homeopathy 3:01:45 1: Module 01: Introduction to Homoeopathy 11:46 2: Module 02: Principles and Theories Behind the Practice 06:11 3: Module 03: How to Treat Patients 10:01 4: Module 04: Homoeopathic Remedies 19:26 5: Module 05: First Aid with Homoeopathic Remedies 10:00 6: Module 06: Homoeopathy for Skin Problems 07:42 7: Module 07: Homoeopathy for Children and Women's Health 12:02 8: Module 08: Practice of Homoeopathy on the Reproductive Systems 14:14 9: Module 09: Practice of Homoeopathy on the Nervous System 08:53 10: Module 10: Practice of Homoeopathy on the Limbic System 10:44 11: Module 11: Practice of Homoeopathy on the Immune System 10:19 12: Module 12: Practice of Homoeopathy on the Digestive System 13:38 13: Module 13: Practice of Homoeopathy on the Circulatory System 10:43 14: Module 14: Practice of Homoeopathy on the Respiratory System 14:26 15: Module 15: Practice of Homoeopathy on the Musculoskeletal System 11:05 16: Module 16: Homoeopathy's Role in Present and Future 09:35 17: CPD Certificate - Free 01:00 Who is this course for? Aspiring homoeopaths seeking comprehensive knowledge. Medical professionals exploring alternative treatments. Parents interested in natural health solutions. Holistic health enthusiasts. Individuals aiming to understand homoeopathic principles. Career path Homoeopathic Practitioner Alternative Medicine Consultant Wellness Clinic Specialist Health and Wellness Coach Homoeopathy Instructor Natural Health Advisor Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Are you passionate about natural medicine and eager to help others achieve optimal health and well-being? Our comprehensive Diploma on Homeopathy is designed to equip you with the knowledge and skills necessary to become a proficient practitioner in this holistic healing art. Join us and embark on a journey to understand and master the principles and practices of homeopathy, an effective and natural system of medicine. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access This Diploma in Homeopathy course provides a comprehensive overview of homeopathy, from its basic principles to its practical applications. Learners will start by understanding the history and foundational theories of homeopathy. They will gain skills in treating patients using homeopathic remedies and learn to apply these remedies for first aid. The course covers specialized treatments for skin problems, children, and women's health, as well as specific conditions affecting the reproductive, nervous, limbic, immune, digestive, circulatory, respiratory, and musculoskeletal systems. Additionally, students will explore homeopathy's role in modern healthcare and its potential future developments. By the end of the course, learners will be well-equipped to practice homeopathy effectively in various health situations. Course Curriculum Module 01: Introduction to Homoeopathy Module 02: Principles and Theories Behind the Practice Module 03: How to Treat Patients Module 04: Homoeopathic Remedies Module 05: First Aid with Homoeopathic Remedies Module 06: Homoeopathy for Skin Problems Module 07: Homoeopathy for Children and Women's Health Module 08: Practice of Homoeopathy on the Reproductive Systems Module 09: Practice of Homoeopathy on the Nervous System Module 10: Practice of Homoeopathy on the Limbic System Module 11: Practice of Homoeopathy on the Immune System Module 12: Practice of Homoeopathy on the Digestive System Module 13: Practice of Homoeopathy on the Circulatory System Module 14: Practice of Homoeopathy on the Respiratory System Module 15: Practice of Homoeopathy on the Musculoskeletal System Module 16: Homoeopathy's Role in Present and Future Learning Outcomes Understand the fundamental principles and theories behind homoeopathy practice. Learn how to effectively treat patients using homoeopathic methods. Identify and apply various homoeopathic remedies appropriately. Provide first aid using homoeopathic remedies in emergency situations. Address skin problems with specialised homoeopathic treatments. Apply homoeopathy to children's and women's health concerns. CPD 10 CPD hours / points Accredited by CPD Quality Standards Diploma on Homeopathy 3:01:45 1: Module 01: Introduction to Homoeopathy 11:46 2: Module 02: Principles and Theories Behind the Practice 06:11 3: Module 03: How to Treat Patients 10:01 4: Module 04: Homoeopathic Remedies 19:26 5: Module 05: First Aid with Homoeopathic Remedies 10:00 6: Module 06: Homoeopathy for Skin Problems 07:42 7: Module 07: Homoeopathy for Children and Women's Health 12:02 8: Module 08: Practice of Homoeopathy on the Reproductive Systems 14:14 9: Module 09: Practice of Homoeopathy on the Nervous System 08:53 10: Module 10: Practice of Homoeopathy on the Limbic System 10:44 11: Module 11: Practice of Homoeopathy on the Immune System 10:19 12: Module 12: Practice of Homoeopathy on the Digestive System 13:38 13: Module 13: Practice of Homoeopathy on the Circulatory System 10:43 14: Module 14: Practice of Homoeopathy on the Respiratory System 14:26 15: Module 15: Practice of Homoeopathy on the Musculoskeletal System 11:05 16: Module 16: Homoeopathy's Role in Present and Future 09:35 17: CPD Certificate - Free 01:00 Who is this course for? Aspiring homoeopaths seeking comprehensive knowledge. Medical professionals exploring alternative treatments. Parents interested in natural health solutions. Holistic health enthusiasts. Individuals aiming to understand homoeopathic principles. Career path Homoeopathic Practitioner Alternative Medicine Consultant Wellness Clinic Specialist Health and Wellness Coach Homoeopathy Instructor Natural Health Advisor Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

This exclusive Language and Speech Therapy Course provides learners with a comprehensive overview of the role of a Speech and Language Therapist, equipping you with the essential skills to advance your career. It includes speech science, speech anatomy, and the characteristics of speech in detail. This course will teach you how Speech and Language Therapists help children and adults with speech and language disorders, including swallowing, eating, and drinking issues. It covers the fundamentals of the speech chain model and walks you through the key stages of literacy and language development. This course includes case studies and practical exercises that will teach you how to assess your clients' needs, set long-term goals, and support them every step of the way to recovery using a variety of communication techniques. In addition, you will gain in-demand professional skills that will help you start your career successfully. Learning Objectives After completing this Language and Speech Therapy course, the learner will be able to: Understand the fundamentals of Speech & Language Therapy. Understand the study of communication. Explain components of normal speech, language & voice and communication disorders. Understand eating, drinking and swallowing disorders. Understand the speech & language therapy process. Why Choose Language & Speech Therapy Course from Us Self-paced course, access available from anywhere. Easy to understand, high-quality study materials. Language & Speech Therapy 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. Free PDF certificate as soon as completing the Language and Speech Therapy course. [ Note: Free PDF certificate as soon as completing the course] Course Curriculum of- *** Language & Speech Therapy *** Module 1: Speech & Language Therapy The Role of the Speech & Language Therapist The History of Speech & Language Therapy Practice The Speech and Language Therapy process The Role of The Speech and Language Therapy Assistant in Current Healthcare Practice The Scope of Practice of Speech & Language Therapy Summary Module 2: Study of Communication The Role of Interpersonal Communication The Components of Communication - Physical, Sensory, Cognitive, Perceptual, Interpersonal and Intrapersonal Communication Impairment or Disorder on the Individual How An Individual Interacts with Their Environment? And Many More... Module 3: Components of Normal Speech, Language & Voice and Communication Disorders Key Components of Speech, Language and Voice The Process of Normal Speech and Language Acquisition Effective Conversational Skills The Different Types of Impairments/Disorders of Normal Speech, Language and Voice And Many More... Module 4: Eating, Drinking and Swallowing Disorders Key Components of Eating, Drinking and Swallowing The Process of Normal Eating, Drinking and Swallowing Acquisition The Different Types of Difficulties of Eating, Drinking and Swallowing And Many More... Assessment Method After completing each module of the Language and Speech Therapy 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 After completing the MCQ/Assignment assessment for this Language and Speech Therapy 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 Language & Speech Therapy course is for anyone who wants to: Gain the skills needed to work in the teaching and childcare profession. Improve their speech therapy and language therapy skills. Make a career change and explore new career opportunities. Gain a formal, accredited qualification to improve their career opportunities. Requirements There are no specific requirements for this Language & Speech Therapy course because it does not require any advanced knowledge or skills. Career path Compete High provides the most expedient path to learning about Language & Speech Therapy, as well as the opportunity to practice your skills in a corporate setting. Certificates Certificate of completion Digital certificate - Included

Overview This comprehensive course on Learn Linux in 5 Days will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Learn Linux in 5 Days comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Learn Linux in 5 Days. It is available to all students, of all academic backgrounds. Requirements Our Learn Linux in 5 Days is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 10 sections • 45 lectures • 05:58:00 total length •Course Overview: 00:03:00 •Background and Introduction: 00:07:00 •Linux Distributions: 00:05:00 •Installing VirtualBox on Windows: 00:03:00 •Installing VirtualBox on Mac: 00:03:00 •Installing Linux Using an Image for VirtualBox: 00:05:00 •VirtualBox Troubleshooting Tips: 00:02:00 •When to Install Linux from Scratch: 00:15:00 •Installing CentOS from Scratch / CentOS Manual Installation Process: 00:23:00 •Getting Connected: 00:11:00 •Connect Directly: 00:02:00 •The Linux Directory Structure: 00:10:00 •The Shell: 00:08:00 •Basic Linux Commands: 00:05:00 •Teach Yourself to Fish: 00:06:00 •Working with Directories: 00:09:00 •Listing Files and Understanding LS Output: 00:12:00 •File and Directory Permissions Explained - Part One: 00:11:00 •File and Directory Permissions Explained - Part Two: 00:09:00 •View Files and the Nano Editor: 00:05:00 •Editing Files in Vi: 00:10:00 •Editing Files with Emacs: 00:06:00 •Finding Files and Directories: 00:07:00 •Graphical Editors: 00:04:00 •Deleting, Copying, Moving, and Renaming Files: 00:11:00 •Wildcards - Part One: 00:05:00 •Wildcards - Part Two: 00:07:00 •Input, Output, and Redirection: 00:08:00 •Comparing Files: 00:04:00 •Searching in Files and Using Pipes: 00:10:00 •Transferring and Copying Files over the Network: 00:07:00 •Customizing the Shell Prompt: 00:05:00 •Shell Aliases: 00:04:00 •Environment Variables: 00:08:00 •Processes and Job Control: 00:12:00 •Scheduling Repeated Jobs with Cron: 00:06:00 •Switching Users and Running Commands as Others: 00:08:00 •Shell History and Tab Completion: 00:13:00 •Installing Software on RPM Based Linux Distros: RedHat, CentOS, AlmaLinux, Rocky: 00:21:00 •Installing Software on Debian Based Linux Distros: Debian, Ubuntu, Kali Linux: 00:12:00 •Conclusion - Congratulations and Thank You!: 00:01:00 •Connecting to a Linux Virtual Machine over the Network: 00:11:00 •Bonus - Installing NGINX, MySQL, PHP, and WordPress on Ubuntu: 00:09:00 •Resources: 00:15:00 •Assignment - Learn Linux in 5 Days: 00:00:00

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?

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access