1127 Courses in Cardiff delivered Online

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 HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX? 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 HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX does not require you to have any prior qualifications or experience. You can just enrol and start learning.This HR, Payroll, PAYE, TAX 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 HR, Payroll, PAYE, TAX is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum HR Management - Updated Version Module 01: Introduction to Human Resource 00:17:00 Module 02: Employee Recruitment and Selection Procedure 00:32:00 Module 03: Employee Training and Development Process 00:22:00 Module 04: Performance Appraisal Management 00:19:00 Module 05: Employee Relations 00:14:00 Module 06: Motivation and Counselling 00:19:00 Module 07: Ensuring Health and safety at the Workplace 00:17:00 Module 08 : Employee Termination 00:15:00 Module 09: Employer Record and Statistics 00:11:00 Module 10: Essential UK Employment Law 00:26:00 HR Management - Old Version Module 01: Human Resource Management Human Resource Management 01:00:00 Module 02: HR Planning, Recruitment and Selection HR Planning, Recruitment and Selection 01:00:00 Module 03: Induction, Training and Development Induction, Training and Development 00:45:00 Module 04: HR Department's Responsibilities HR Department's Responsibilities 00:45:00 Module 05: The UK Recruitment Legislations Guide The UK Recruitment Legislations Guide 00:20:00 Module 06: Organizational Culture Organisational Culture 00:45:00 Module 07: Motivation, Counseling, Resignations and Retirement Motivation, Counseling, Resignations and Retirement 01:00:00 Module 08: Performance Appraisal & Remuneration Policy Performance Appraisal 00:45:00 Remuneration Policy 00:15:00 Module 09: Records and Statistics Records and Statistics 00:30:00 Module 10: Industrial Relations Industrial Relations 00:15:00 Module 11: The UK Recruitment Industry Statistics The UK Recruitment Industry Statistics 00:25:00 Payroll Management Course Module 01: Payroll System in the UK Payroll System in the UK 01:05:00 Module 02: Payroll Basics Payroll Basics 00:10:00 Module 03: Company Settings Company Settings 00:08:00 Module 04: Legislation Settings Legislation Settings 00:07:00 Module 05: Pension Scheme Basics Pension Scheme Basics 00:06:00 Module 06: Pay Elements Pay Elements 00:14:00 Module 07: The Processing Date The Processing Date 00:07:00 Module 08: Adding Existing Employees Adding Existing Employees 00:08:00 Module 09: Adding New Employees Adding New Employees 00:12:00 Module 10: Payroll Processing Basics Payroll Processing Basics 00:11:00 Module 11: Entering Payments Entering Payments 00:12:00 Module 12: Pre-Update Reports Pre-Update Reports 00:09:00 Module 13: Updating Records Updating Records 00:09:00 Module 14: e-Submissions Basics e-Submissions Basics 00:09:00 Module 15: Process Payroll (November) Process Payroll (November) 00:16:00 Module 16: Employee Records and Reports Employee Records and Reports 00:13:00 Module 17: Editing Employee Records Editing Employee Records 00:07:00 Module 18: Process Payroll (December) Process Payroll (December) 00:12:00 Module 19: Resetting Payments Resetting Payments 00:05:00 Module 20: Quick SSP Quick SSP 00:09:00 Module 21: An Employee Leaves An Employee Leaves 00:13:00 Module 22: Final Payroll Run Final Payroll Run 00:07:00 Module 23: Reports and Historical Data Reports and Historical Data 00:08:00 Module 24: Year-End Procedures Year-End Procedures 00:09:00

This course is aimed at managers and staff in all industries who play a role in reducing drug, alcohol and substance misuse in the UK. The course starts with official statistics to illustrate the scale of drug and alcohol abuse in the UK. You'll learn in detail about commonly used drugs, including cannabis, cocaine, heroin, LSD, ecstasy and some new designer drugs. Turning to alcohol abuse, the course will show you how to introduce a 4-stage plan to deal with any problems - including how to write an effective Drug and Alcohol Policy. Beyond this the course will explore best business practice in terms of HR, legislation, spotting signs of drug misuse and the implementation of workplace solutions. The course also explains how the Advisory, Conciliation and Arbitration Service (ACAS) can help with effective alcohol and drugs policies and the development of related management skills. Finally, it looks at current drug treatments and the options for outside support available to individuals and organisations.

Unlock your potential as a Business Intelligence Analyst! Master data analysis, reporting, and visualisation skills to drive informed business decisions.

***24 Hour Limited Time Flash Sale*** Basics of Data Science - CPD Certified Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter In a world where 2.5 quintillion bytes of data are produced every day, how can professionals leverage this data for strategic decision-making and competitive advantage? In the UK, the data science industry is booming, with an estimated increase in demand for data scientists and analytics professionals by over 28% by 2020. This Basics of Data Science bundle gives you diverse analytical skills to launch or advance your analytics career. Designed to cater to the needs of both seasoned professionals and aspiring newcomers, our Basics of Data Science bundle is a comprehensive program that will equip you with the essential skills and knowledge you need to succeed. Whether you're looking to advance in your current role or embark on a new career journey, this bundle has everything you need to take your professional life to the next level. But that's not all. When you enrol in Basics of Data Science Online Training, you'll receive 30 CPD-Accredited PDF Certificates, Hard Copy Certificates, and our exclusive student ID card, all absolutely free. Courses Are Included In this Bundle: Course 01: Diploma in Data Analysis Fundamentals Course 02: Business Intelligence and Data Mining Course 03: Google Data Studio: Data Analytics Course 04: Statistics Course 05: Statistical Analysis Course 06: Statistics & Probability for Data Science & Machine Learning Course 07: Microsoft Power BI - Master Power BI in 90 Minutes! Course 08: R Programming for Data Science Course 09: PowerBI Formulas Course 10:Time Management Training - Online Course Course 11: Excel Data Analysis Course 12: Stock Trading Analysis with Volume Trading Course 13: Fundamentals of Business Analysis Course 14: Minute-Taking Executive Training Course 15: Financial Modeling Using Excel Course 16: Complete Communication Skills Master Class for Life Course 17: Public Speaking Course 18: Data Science & Machine Learning with Python Course 19: Quick Data Science Approach from Scratch Course 20: Strategic Planning and Analysis for Marketing Course 21: Understanding Financial Statements and Analysis Course 22: Master JavaScript with Data Visualization Course 23: Receptionist Skills Course 24: Python Data Science Course 25: Research Methods in Business Course 26: Technical Analysis Masterclass for Trading & Investing Course 27: SAS Programming Basic to Advanced Course 28: Investment Analyst Course 29: Financial Analysis Course 30: Excel Data Tools and Data Management With Basics of Data Science, you'll embark on an immersive learning experience that combines interactive lessons with voice-over audio, ensuring that you can learn from anywhere in the world, at your own pace. And with 24/7 tutor support, you'll never feel alone in your journey, whether you're a seasoned professional or a beginner. Learning Outcomes of this Bundle Collect, clean, and transform complex datasets using Python and R Create insightful dashboards and visualizations in Power BI Apply statistical techniques to interpret trends and make predictions Build financial models to determine business value and opportunity Automate analytical tasks through SAS and JavaScript Communicate data-driven insights to stakeholders effectively Don't let this opportunity pass you by. Enrol in the Basics of Data Science today and take the first step towards achieving your goals and dreams. Why buy this Bundle? Free CPD Accredited Certificate upon completion of Basics of Data Science Get a free student ID card with Basics of Data Science Lifetime access to the Basics of Data Science course materials Get instant access to this Basics of Data Science course Learn the Basics of Data Science from anywhere in the world 24/7 tutor support with the Basics of Data Science course. Start your learning journey straightaway! Basics of Data Science premium bundle consists of 30 precisely chosen courses on a wide range of topics essential for anyone looking to excel in this field. Each segment of Basics of Data Science is meticulously designed to maximise learning and engagement, blending interactive content and audio-visual modules for a truly immersive experience. Certification You have to complete the assignment given at the end of the Basics of Data Science course. After passing the Basics of Data Science exam You will be entitled to claim a PDF & Hardcopy certificate accredited by CPD Quality standards completely free. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Basics of Data Science course is ideal for: Students seeking mastery in the Basics of Data Science Professionals seeking to enhance the Basics of Data Science skills Individuals looking for a Basics of Data Science-related career. Anyone passionate about the Basics of Data Science Requirements This Basics of Data Science doesn't require prior experience and is suitable for diverse learners. Career path This Basics of Data Science bundle will allow you to kickstart or take your career in the related sector to the next stage. Data Analyst Business Analyst Data Scientist Marketing Analyst Financial Analyst Certificates CPD Accredited Digital certificate Digital certificate - Included CPD Accredited Hard copy certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Unlock your potential and redefine your career path in the vibrant world of recruitment. Imagine mastering the art of connecting talented individuals with their dream roles, while driving businesses towards unparalleled success. Our comprehensive course offers you an in-depth journey through the intricacies of the recruitment landscape, from its rich history to the dynamic, evolving trends that shape the industry today. You'll delve into the core principles and strategies that underpin successful recruitment practices, gaining valuable insights into industry statistics and legislation. Key Features: CPD Certified Free Certificate Developed by Specialist Lifetime Access Prepare to elevate your business acumen as you explore the essential components of developing a robust recruitment strategy. Learn the secrets to attracting top talent and managing candidates with finesse, while acquiring the skills needed to secure high-value clients. This course is designed to empower you with the knowledge and techniques required to excel in recruitment consulting, ensuring you have the tools to run a successful recruiting service. Transform your approach to recruitment and embark on a journey towards becoming an influential consultant in a competitive global market. Join us and start shaping the future of work today. Course Curriculum Module 01: History and Development of the Recruitment Industry Module 02: The UK Recruitment Industry Statistics Module 03: The Worldwide Employment Industry Module 04: The UK Recruitment Legislations Guide Module 05: Basics of Recruitment Module 06: Overview of the Recruitment Cycle Module 07: Developing a Business Strategy and Key Performance Indicators Module 08: Recruitment Strategy Module 09: Candidate Attraction Module 10: Candidate Management Module 11: Client Acquisition Module 12: How to Become a Successful Recruitment Consultant Module 13: How to Successfully Run a Recruiting Service Learning Outcomes: Understand the evolution of the recruitment industry and its global impact. Analyse UK recruitment statistics and their implications. Comprehend UK recruitment legislation and its application. Master the fundamentals and complete cycle of recruitment. Develop effective recruitment strategies and performance indicators. Learn techniques for successful candidate attraction and management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring recruitment consultants. HR professionals seeking specialised recruitment knowledge. Business owners in the recruitment industry. Career changers interested in recruitment consulting. Recruitment team leaders and managers. Career path Recruitment Consultant Talent Acquisition Specialist Recruitment Manager HR Recruitment Coordinator Recruitment Business Partner Recruitment Agency Director Certificates Digital certificate Digital certificate - Included Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

[vc_row][vc_column][vc_column_text] Description: Want to learn the secrets of the stock market? If you're considering becoming a stock market trader, take the steps to fast and smart cash with this stock market trading course and learn how to trade stocks online. This Diploma in Stock Market Course is designed to explore the online stock market and financial markets in detail. You will learn all about stocks and shares investments, and their variable differences. In this stock market masterclass, you will get an introduction to market trends, understand currency conversion and statistics, and explore the risks and rewards of trading. Every stock trader should be aware of the risks and in this course, you will learn the basics of risk management. You will also gain an understanding of when to invest and review different options in trading. Throughout this stock trading course, you will familiarise with the role of a professional trader and trading strategies, as well as common mistakes to avoid in stock trading. Other topics covered include Forex trading, buzz words and technical analysis. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hard copy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. [/vc_column_text][/vc_column][/vc_row] Stock Market Basics Introduction To Stocks Basics 00:30:00 About Share Basics 00:30:00 The Difference Between Stocks And Shares 00:30:00 Concept Of Fundamentals Of The Stock Market 00:30:00 How Exactly Do Stock Prices Get Determined? 00:30:00 Benefits Of Using Stocks And Shares 01:00:00 When To Get Out Of The Stock Market 00:30:00 Wrapping Up 00:15:00 Stock Market Statistics Understanding the stock market 01:00:00 Identifying trends 01:00:00 What is Forex? 01:00:00 Basics of currency conversion 01:00:00 Understanding Statistics 01:00:00 Forex Volatility And Market Expectation 01:00:00 Aspects Of The Trade 01:00:00 Risk Management 01:00:00 'Buzz' Words 01:00:00 Expert Trading Options 01:00:00 Other Trading Options 01:00:00 In Review 01:00:00 One Final Option 00:30:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diploma in Stock Market 00:30:00 Final Exam Final Exam- Diploma in Stock Market 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

The Horticulture Diploma & Organic Gardening Certification Online course offers comprehensive training in horticulture, covering topics such as botany, soil science, plant nutrition, plant pests and diseases, organic gardening concepts, and landscaping. Participants will also learn about plant propagation, indoor plants, ornamental horticulture, and permaculture, preparing them for a rewarding career in horticulture and organic gardening. Learning Outcomes: Understand the principles of botany and plant classification. Gain knowledge of soil science and the nutritional requirements of plants. Identify and manage plant pests and diseases in an organic gardening context. Learn techniques for weed control, plant propagation, and selecting native and exotic plants. Acquire skills in lawn care, indoor plant maintenance, and plant protection in different settings. Discover the essentials of landscaping, garden design, and ornamental horticulture. Master the principles and practices of permaculture and arboriculture in horticulture. Gain insights into horticulture statistics and the latest developments in the industry. Who is this course for? This Horticulture & Organic Gardening does not require you to have any prior qualifications or experience. You can just enrol and start learning. The course is for anyone who wants to learn more about organic gardening and horticulture or start their own organic garden. Prerequisites This Horticulture & Organic Gardening 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 Horticulture & Organic Gardening is a great way for you to gain multiple skills from the comfort of your home. This course is ideal for  Gardeners Garden Associates Research Scientists Horticulture Consultants Horticulture Inspectors Horticulture Technicians Plant Pathologists Groundskeepers Garden Maintenance Officers Landscape Assistants Course Curriculum Module 01: Basic Botany Basic Botany 00:28:00 Module 02: Plant Classification Plant Classification 00:11:00 Module 03: Soil Science Soil Science 00:23:00 Module 04: Plant Nutrition Requirements Plant Nutrition Requirements 00:22:00 Module 05: Plant Pests and Diseases Plant Pests and Diseases 00:41:00 Module 06: Basic Concepts of Organic Gardening Basic Concepts of Organic Gardening 00:21:00 Module 07: Weed Control Weed Control 00:20:00 Module 08: Plant Propagation Plant Propagation part 01 00:31:00 Plant Propagation Part 02 00:42:00 Module 09: Amenity Horticulture, Plant Selection and Native Plants Amenity Horticulture, Plant Selection and Native Plants 00:36:00 Module 10: Exotic Plants Exotic Plants 00:35:00 Module 11: Indoor Plants Indoor Plants 00:30:00 Module 12: Lawns Lawns 00:13:00 Module 13: Planting and Plant Care Planting and Plant Care 00:10:00 Module 14: Plant Nodes and Indigenous Plants Plant Nodes and Indigenous Plants 00:21:00 Module 15: Plant Protection, Landscaping and Garden Design Plant Protection, Landscaping and Garden Design 00:23:00 Module 16: Ornamental Horticulture Ornamental Horticulture 00:20:00 Module 17: Permaculture Permaculture 00:16:00 Module 18: Arboriculture Arboriculture 00:11:00 Module 19: Horticulture Statistics Horticulture Statistics 00:33:00 Module 20: Results from the 2018 Seasonal Labour in Horticulture End of Year Results from the 2018 Seasonal Labour in Horticulture End of Year 00:35:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support | All-Inclusive Cost

Duration 3 Days 18 CPD hours This course is intended for This course is intended for system administrators, network administrators and application developers responsible for the customization of traffic flow through a BIG-IP system. This course provides networking professionals a functional understanding of iRules development. The course builds on the foundation of the Administering BIG-IP or Configuring LTM course, demonstrating how to logically plan and write iRules to help monitor and manage common tasks involved with processing traffic on the BIG-IP system. Extensive course labs consist of writing, applying and evaluating the effect of iRules on local traffic. This hands-on course includes lectures, labs, and discussions. Module 1: Setting Up the BIG-IP System Introducing the BIG-IP System Initially Setting Up the BIG-IP System Archiving the BIG-IP System Configuration Leveraging F5 Support Resources and Tools Module 2: Getting Started with iRules Customizing Application Delivery with iRules Triggering an iRule Leveraging the DevCentral Ecosystem Creating and Deploying iRules Module 3: Exploring iRule Elements Introducing iRule Constructs Understanding iRule Events and Event Context Working with iRule Commands Logging from an iRule Using SYSLOG-NG (LOG Command) Working with User-Defined Variables Working with Operators and Data Types Working with Conditional Control Structures (IF and SWITCH) Incorporating Best Practices in iRules Module 4: Developing and Troubleshooting iRules Mastering Whitespace and Special Symbols Grouping Strings Developing and Troubleshooting Tips Using Fiddler to Test and Troubleshoot iRules Module 5: Optimizing iRule Execution Understanding the Need for Efficiency Measure iRule Runtime Efficiency Using Timing Statistics Modularizing iRules for Administrative Efficiency Using Procedures to Modularize Code Optimizing Logging Using High-Speed Logging Commands in an iRule Implementing Other Efficiencies Using Looping Control Structures (WHILE, FOR, FOREACH Commands) Module 6: Securing Web Applications with iRules Integrating iRules into Web Application Defense Mitigating HTTP Version Attacks Mitigating Path Traversal Attacks Using iRules to Defends Against Cross-Site Request Forgery (CSRF) Mitigating HTTP Method Vulnerabilities Securing HTTP Cookies with iRules Adding HTTP Security Headers Removing Undesirable HTTP Headers Module 7: Working with Numbers and Strings Understanding Number Forms and Notation Working with Strings (STRING and SCAN Commands) Combining Strings (Adjacent Variables, CONCAT and APPEND Commands) Using iRule String Parsing Functions (FINDSTR, GETFIELD, and SUBSTR Commands) Module 8: Processing the HTTP Payload Reviewing HTTP Headers and Commands Accessing and Manipulating HTTP Headers (HTTP::header Commands) Other HTTP commands (HTTP::host, HTTP::status, HTTP::is_keepalive, HTTP::method, HTTP::version, HTTP::redirect, HTTP::respond, HTTP::uri) Parsing the HTTP URI (URI::path, URI::basename, URI::query) Parsing Cookies with HTTP::cookie Selectively Compressing HTTP Data (COMPRESS Command) Module 9: Working with iFiles and Data Groups Working with iFiles Introducing Data Groups Working with Old Format Data Groups (MATCHCLASS, FINDCLASS) Working with New Format Data Groups (CLASS MATCH, CLASS SEARCH) Module 10: Using iRules with Universal Persistence, Stream, and Statistics Profiles Implementing Universal Persistence (PERSIST UIE Command) Working with the Stream Profile (STREAM Command) Collecting Statistics Using a Statistics Profile (STATS Command) Collecting Statistics Using iStats (ISTATS Command) Module 11: Incorporating Advanced Variables Reviewing the Local Variable Namespace Working with Arrays (ARRAY Command) Using Static and Global Variables Using the Session Table (TABLE Command) Processing Session Table Subtables Counting ?Things? Using the Session Table

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?