• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1119 Courses in Cardiff delivered Online

Data Science with Python Bundle - 8 Courses Bundle

By NextGen Learning

Are you ready to embark on an enlightening journey of wisdom with the Data Science bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - Data Science with Python. Delve into eight immersive CPD Accredited courses, each a standalone course: Python from Scratch Quick Data Science Approach from Scratch Python Data Science with Numpy, Pandas and Matplotlib Complete Python Machine Learning & Data Science Fundamentals SQL for Data Science, Data Analytics and Data Visualization Data Science & Machine Learning with R from A-Z Statistics & Probability for Data Science & Machine Learning R Programming for Data Science Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the Data Science with Python bundle illuminate your path to wisdom. The Data Science with Python bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across eight carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the Data Science with Python package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the Data Science bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the Data Science with Python community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the Data Science bundle. Establish robust bases across each course nestled within the Data Science bundle. Decipher intricate concepts through the articulate content of the Data Science bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the Data Science bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The Data Science bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the Data Science bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The Data Science bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the Data Science bundle allows learners to make meaningful contributions to their chosen fields. Embark on the Data Science journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Career path Armed with the Data Science bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the Data Science bundle lays a solid groundwork. Certificates CPD Certificate Of Completion Digital certificate - Included 8 Digital Certificates Are Included With This Bundle CPD Quality Standard Hardcopy Certificate (FREE UK Delivery) Hard copy certificate - £9.99 Hardcopy Transcript - £9.99

Data Science with Python Bundle - 8 Courses Bundle
Delivered Online On Demand31 hours
£39

Slips, Trips and Falls

5.0(3)

By TNA Training & Safety Consultants

This course will introduce you to some of the statistics relating to slips, trips and falls and dispel some of the myths surrounding them. It also touches on the law as it relates to slips, trips and falls. It contains real examples of where things have gone wrong and some practical steps that could have been taken to prevent these incidents. The course also covers some of the straightforward changes that can be made in most businesses to significantly reduce the risk of a slip, trip or fall incident occurring.

Slips, Trips and Falls
Delivered Online On Demand
£35

Level 7 Advanced Diploma in Strategic People Management

4.5(3)

By Studyhub UK

The Level 7 Advanced Diploma in Strategic People Management course offers comprehensive training in human resources and people management. Covering modules on HR introduction, employee recruitment and selection, training and development, performance appraisal, employee relations, motivation and counselling, workplace health and safety, employee termination, employer records and statistics, and essential UK employment law. Learning Outcomes: Develop a strong understanding of human resources management principles and practices. Acquire skills in employee recruitment and selection, identifying the right candidates for various roles. Learn techniques for employee training and development to enhance their skills and productivity. Understand the significance of performance appraisal management in evaluating employee performance. Gain insights into promoting positive employee relations, motivation, and counseling in the workplace. Learn strategies for ensuring workplace health and safety and safeguarding employee well-being. Familiarize yourself with the employee termination process, adhering to legal and ethical considerations. Understand the importance of employer records and statistics in effective people management. Acquire essential knowledge of UK employment law, including regulations and compliance requirements. Why buy this Level 7 Advanced Diploma in Strategic People Management? 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 course for? Individuals aspiring to embark on a career in human resources. Managers seeking to enhance their team-leading capabilities. Business owners aiming to streamline their HR processes. Graduates desiring a foundational understanding of people management. HR professionals looking to update their knowledge with current UK legal standards. Career path HR Assistant: £18,000 - £25,000 Annually Recruitment Consultant: £22,000 - £30,000 Annually Training and Development Officer: £24,000 - £35,000 Annually HR Manager: £35,000 - £50,000 Annually Employee Relations Advisor: £28,000 - £40,000 Annually Health and Safety Coordinator: £22,000 - £30,000 Annually Prerequisites This Level 7 Advanced Diploma in Strategic People Management does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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: People Management Strategies People Management Strategies 00:16:00 Module 02: Introduction to Human Resources Introduction to Human Resources 00:20:00 Module 03: Organisational Structures Organisational Structures 00:19:00 Module 04: Essential UK Employment Law Essential UK Employment Law 00:30:00 Module 05: Employee Recruitment and Selection Procedure Employee Recruitment and Selection Procedure 00:35:00 Module 06: Employee Training and Development Process Employee Training and Development Process 00:24:00 Module 07: Performance Appraisal Management Performance Appraisal Management 00:22:00 Module 08: Employee Relations Employee Relations 00:19:00 Module 09: Motivation and Counselling Motivation and Counselling 00:22:00 Module 10: Ensuring Health and Safety at the Workplace Ensuring Health and Safety at the Workplace 00:19:00 Module 11: Employee Termination Employee Termination 00:18:00 Module 12: Employer Records and Statistics Employer Records and Statistics 00:17:00 Assignment Assignment - Level 7 Advanced Diploma in Strategic People Management 00:00:00

Level 7 Advanced Diploma in Strategic People Management
Delivered Online On Demand4 hours 21 minutes
£10.99

Diploma in People Management Training and Recruitment Process

4.5(3)

By Studyhub UK

Overview The Diploma in People Management Training and Recruitment Process course offers comprehensive training in human resources and people management. Covering modules on HR introduction, employee recruitment and selection, training and development, performance appraisal, employee relations, motivation and counselling, workplace health and safety, employee termination, employer records and statistics, and essential UK employment law. Learning Outcomes: Develop a strong understanding of human resources management principles and practices. Acquire skills in employee recruitment and selection, identifying the right candidates for various roles. Learn techniques for employee training and development to enhance their skills and productivity. Understand the significance of performance appraisal management in evaluating employee performance. Gain insights into promoting positive employee relations, motivation, and counseling in the workplace. Learn strategies for ensuring workplace health and safety and safeguarding employee well-being. Familiarize yourself with the employee termination process, adhering to legal and ethical considerations. Understand the importance of employer records and statistics in effective people management. Acquire essential knowledge of UK employment law, including regulations and compliance requirements. Why buy this Diploma in People Management Training and Recruitment Process? 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 Diploma in People Management Training and Recruitment Process 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? Individuals aspiring to embark on a career in human resources. Managers seeking to enhance their team-leading capabilities. Business owners aiming to streamline their HR processes. Graduates desiring a foundational understanding of people management. HR professionals looking to update their knowledge with current UK legal standards. Prerequisites This Diploma in People Management Training and Recruitment Process does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in People Management Training and Recruitment Process 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 HR Assistant: £18,000 - £25,000 Annually Recruitment Consultant: £22,000 - £30,000 Annually Training and Development Officer: £24,000 - £35,000 Annually HR Manager: £35,000 - £50,000 Annually Employee Relations Advisor: £28,000 - £40,000 Annually Health and Safety Coordinator: £22,000 - £30,000 Annually Course Curriculum Module 01: Introduction to Human Resources Introduction to Human Resources 00:20:00 Module 02: Employee Recruitment and Selection Procedure Employee Recruitment and Selection Procedure 00:35:00 Module 03: Employee Training and Development Process Employee Training and Development Process 00:24:00 Module 04: Performance Appraisal Management Performance Appraisal Management 00:22:00 Module 05: Employee Relations Employee Relations 00:19:00 Module 06: Motivation and Counselling Motivation and Counselling 00:22:00 Module 07: Ensuring Health and Safety at the Workplace Ensuring Health and Safety at the Workplace 00:19:00 Module 08: Employee Termination Employee Termination 00:18:00 Module 09: Employer Records and Statistics Employer Records and Statistics 00:17:00 Module 10: Essential UK Employment Law Essential UK Employment Law 00:30:00 Assignment Assignment - Diploma in People Management Training and Recruitment Process 00:00:00

Diploma in People Management Training and Recruitment Process
Delivered Online On Demand3 hours 46 minutes
£10.99

Data Analytics

4.8(9)

By Skill Up

Boost your advanced analytics skills by choosing our excellent course. We are providing one of the best online data analytics programs!

Data Analytics
Delivered Online On Demand12 hours 26 minutes
£25

HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma

4.5(3)

By Studyhub UK

Overview Embarking on a journey with the 'HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma' course presents an illuminating path into the intricacies of modern business management. Diving deep into twelve comprehensive modules, learners uncover the nuances of Human Resource Management, from recruitment strategies to understanding the bedrock of the UK's payroll system. Grasping the essence of organisational culture, performance metrics, and the technicalities of PAYE and Tax, participants will be primed to navigate the complex web of today's corporate world with confidence and finesse. With a spotlight on both theoretical insights and real-world applications, this diploma aims to equip you with a robust foundation in HR processes and the pivotal role of finance in business management. As businesses evolve, so does the demand for specialists who are adept at merging HR practices with financial wisdom. By the end of this course, you'll be empowered with the expertise to bridge these two vital domains, heralding success in the ever-evolving business landscape. Your learning journey culminates with a comprehensive conclusion and a pointer to the subsequent steps, ensuring you're not only well-versed in the subject but also equipped to apply this knowledge in practical scenarios. A world of opportunities awaits the ambitious learner, and this course is your compass to navigate it. Learning Outcomes Demonstrate a clear understanding of HR management's core principles and practices. Apply the UK recruitment legislation and industry statistics in organisational contexts. Design and implement effective strategies for employee training, development, and performance appraisals. Master the intricacies of payroll management, including the specifics of the UK system. Interpret and manage financial records, statistics, and the core elements of PAYE, Tax, and NI. Why buy this HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma? 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, Accounting and Bookkeeping Diploma 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? Individuals looking to launch or advance their careers in HR and financial management. Business owners wanting a deeper understanding of HR processes and financial systems. Job seekers aiming to diversify their skill set in the corporate domain. Graduates keen on specialising in HR and finance. HR professionals wishing to update their knowledge in line with the latest UK legislations and industry standards. Prerequisites This HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma 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 Human Resource Manager: £30,000 - £55,000 Annually Recruitment Specialist: £25,000 - £50,000 Annually Payroll Administrator: £20,000 - £35,000 Annually Financial Accountant: £35,000 - £60,000 Annually Tax Consultant: £28,000 - £52,000 Annually Bookkeeping Specialist: £22,000 - £40,000 Annually Course Curriculum 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 Module 12: Introduction to Payroll Management Introduction to Payroll Management 00:10:00 An Overview of Payroll 00:17:00 Module 13: The UK Payroll System Running the payroll - Part 1 00:14:00 Running the payroll - Part 2 00:18:00 Manual payroll 00:13:00 Benefits in kind 00:09:00 Computerised systems 00:11:00 Total Photo scenario explained 00:01:00 Module 14: Brightpay Brightpay conclude 00:03:00 Find software per HMRC Brightpay 00:03:00 Add a new employee 00:14:00 Add 2 more employees 00:10:00 Payroll settings 00:04:00 Monthly schedule - Lana 00:14:00 Monthly schedule - James 00:08:00 Directors NI 00:02:00 Reports 00:02:00 Paying HMRC 00:05:00 Paying Pensions 00:04:00 RTI Submission 00:02:00 Coding Notices 00:01:00 Journal entries 00:07:00 Schedule 00:03:00 AEO 00:06:00 Payroll run for Jan & Feb 2018 00:13:00 Leavers - p45 00:03:00 End of Year p60 00:02:00 Installing Brightpay 00:13:00 Module 15: Paye, Tax, NI PAYE TAX 00:13:00 NI 00:11:00 Pensions 00:06:00 Online calculators 00:07:00 Payslips 00:03:00 Journal entries 00:07:00 Conclusion and Next Steps Conclusion and Next Steps 00:08:00 Assignment Assignment - HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma 00:00:00

HR, Payroll, Paye, Tax, Accounting and Bookkeeping Diploma
Delivered Online On Demand12 hours 12 minutes
£10.99

Lean Six Sigma Black Belt Certification Program: In-House Training

By IIL Europe Ltd

Lean Six Sigma Black Belt Certification Program: In-House Training This course is specifically for people wanting to become Lean Six Sigma Black Belts, who are already Lean Six Sigma practitioners. If advanced statistical analysis is needed to identify root causes and optimal process improvements, (Lean) Six Sigma Green Belts typically ask Black Belts or Master Black Belts to conduct these analyses. This course will change that. Green Belts wanting to advance their statistical abilities will have a considerable amount of hands-on practice in techniques such as Statistical Process Control, MSA, Hypothesis Testing, Correlation and Regression, Design of Experiments, and many others. Participants will also work throughout the course on a real-world improvement project from their own business environment. This provides participants with hands-on learning and provides the organization with an immediate ROI once the project is completed. IIL instructors will provide free project coaching throughout the course. What you Will Learn At the end of this program, you will be able to: Use Minitab for advanced data analysis Develop appropriate sampling strategies Analyze differences between samples using Hypothesis Tests Apply Statistical Process Control to differentiate common cause and special cause variation Explain and apply various process capability metrics Conduct Measurement System Analysis and Gage R&R studies for both discrete and continuous data Conduct and analyze simple and multiple regression analysis Plan, execute, and analyze designed experiments Drive sustainable change efforts through leadership, change management, and stakeholder management Successfully incorporate advanced analysis techniques while moving projects through the DMAIC steps Explain the main concepts of Design for Six Sigma including QFD Introduction: DMAIC Review IIL Black Belt Certification Requirements Review Project Selection Review Define Review Measure Review Analyze Review Improve Review Control Introduction: Minitab Tool Introduction to Minitab Minitab basic statistics and graphs Special features Overview of Minitab menus Introduction: Sampling The Central Limit Theorem Confidence Interval of the mean Sample size for continuous data (mean) Confidence Interval for proportions Sample size for discrete data (proportions) Sampling strategies (review) Appendix: CI and sample size for confidence levels other than 95% Hypothesis Testing: Introduction Why use advanced stat tools? What are hypothesis tests? The seven steps of hypothesis tests P value errors and hypothesis tests Hypothesis Testing: Tests for Averages 1 factor ANOVA and ANOM Main Effect Plots, Interaction Plots, and Multi-Vari Charts 2 factor ANOVA and ANOM Hypothesis Testing: Tests for Standard Deviations Testing for equal variance Testing for normality Choosing the right hypothesis test Hypothesis Testing: Chi Square and Other Hypothesis Test Chi-square test for 1 factor ANOM test for 1 factor Chi-square test for 2 factors Exercise hypothesis tests - shipping Non-parametric tests Analysis: Advanced Control Charts Review of Common Cause and Special Cause Variation Review of the Individuals Control Charts How to calculate Control Limits Four additional tests for Special Causes Control Limits after Process Change Discrete Data Control Charts Control Charts for Discrete Proportion Data Control Charts for Discrete Count Data Control Charts for High Volume Processes with Continuous Data Analysis: Non-Normal Data Test for normal distribution Box-Cox Transformation Box-Cox Transformation for Individuals Control Charts Analysis: Time Series Analysis Introduction to Time Series Analysis Decomposition Smoothing: Moving Average Smoothing: EWMA Analysis: Process Capability Process capability Discrete Data: Defect metrics Discrete Data: Yield metrics Process Capability for Continuous Data: Sigma Value Short- and long-term capabilities Cp, Cpk, Pp, Ppk capability indices Analysis: Measurement System Analysis What is Measurement System Analysis? What defines a good measurement system? Gage R&R Studies Attribute / Discrete Gage R&R Continuous Gage R&R Regression Analysis: Simple Correlation Correlation Coefficient Simple linear regression Checking the fit of the Regression Model Leverage and influence analysis Correlation and regression pitfalls Regression Analysis: Multiple Regression Analysis Introduction to Multiple Regression Multicollinearity Multiple Regression vs. Simple Linear Regression Regression Analysis: Multiple Regression Analysis with Discrete Xs Introduction Creating indicator variables Method 1: Going straight to the intercepts Method 2: Testing for differences in intercepts Logistic Regression: Logistic Regression Introduction to Logistic Regression Logistic Regression - Adding a Discrete X Design of Experiments: Introduction Design of Experiment OFAT experimentation Full factorial design Fractional factorial design DOE road map, hints, and suggestions Design of Experiments: Full Factorial Designs Creating 2k Full Factorial designs in Minitab Randomization Replicates and repetitions Analysis of results: Factorial plots Analysis of results: Factorial design Analysis of results: Fits and Residuals Analysis of results: Response Optimizer Analysis of results: Review Design of Experiments: Pragmatic Approaches Designs with no replication Fractional factorial designs Screening Design of Experiment Case Study Repair Time Blocking Closing: Organizational Change Management Organizational change management Assuring project sponsorship Emphasizing shared need for change Mobilizing stakeholder commitment Closing: Project Management for Lean Six Sigma Introduction to project management Project management for Lean Six Sigma The project baseline plan Work Breakdown Structure (WBS) Resource planning Project budget Project risk Project schedule Project executing Project monitoring and controlling and Closing Closing: Design for Lean Six Sigma Introduction to Design for Lean Six Sigma (DMADV) Introduction to Quality Function Deployment (QFD) Summary and Next Steps IIL's Lean Six Sigma Black Belt Certification Program also prepares you to pass the IASSC Certified Black Belt Exam (optional)

Lean Six Sigma Black Belt Certification Program: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£6,295

Positive Handling in Schools-CPD Approved

By BAB Business Group

Positive Handling is a very serious subject. Knowing when and how to act in a difficult situation can be the difference between a positive outcome and a potentially career ending prosecution. This course will start by looking at some examples and statistics which highlight the seriousness and extent of aggressive pupil behaviour, it will then go on to explain how you can identify the stages of aggression and provide some tips on how you could de-escalate a pupil before they lash out. It also looks at where the law stands on this subject and finally best practice in theory if you ever do need to restrain a pupil.

Positive Handling in Schools-CPD Approved
Delivered Online On Demand
£30

Recruitment Consultant, HR Audi & Change Management

By Imperial Academy

3 QLS Endorsed Diploma | QLS Hard Copy Certificate Included | 10 CPD Courses | Lifetime Access | 24/7 Tutor Support

Recruitment Consultant,  HR Audi & Change Management
Delivered Online On Demand
£399

Oracle 19c Database Tuning (TTOR21519)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This intermediate-level course requires students have incoming experience working with Oracle Database 18 or higher. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore: The Oracle Database Architecture Query Optimizer Tuning Container Databases and Pluggable Databases Oracle 19c Tuning features Evaluating Execution Plans Oracle Tuning Tools Using Automatic Workload Repository Join Types AWR Using Baselines Additional AWR performance tools Optimizer Statistics Monitoring a Service Bind Variables and database parameters Oracle's Real Application Testing (RAT) SQL Tuning Advisor Automatic Sql Tuning Sql Plan Management Shared Pool Tuning Tuning the database buffer cache Tuning the PGA (Program Global Area) Automatic Memory Management (AMM) Tuning Segment Space Utilization (ASSM) Automatic Storage Management Oracle 19C Database Tuning is an intermediate level course for Oracle database experienced attendees that explores core tuning skills such as Database parameters, SQL Tuning Advisor, SQL Access Advisor, Adaptive SQL plans and more. Overview Oracle Database Architecture Instance Definition Define SGA Define Background Processes Datafile Definition Query Optimizer SQL Parsing Optimizing Terms Optimizing Methods Query Plan Generation Query Plan Control Tuning Container Databases and Pluggable Databases Pluggable tuning parameters Define Container tuning structure Using PDB$SEED Create a new PDB Plug and unplug a PDB Oracle 12c Tuning features Identifying and Using Oracle's Heat Map 12c Compression Levels and Types Evaluating Execution Plans Defining SQL execution plans Automatic Workload Repository Reading execution plans Oracle Tuning Tools Monitoring tools overview Enterprise Manager Dynamic Performance Views Automatic Workload Repository Automatic Database Diagnostic Monitor Sql Tuning Advisor SQL Access Advisor Sql Access Advisor DB operation Tuning DB operation Active Reporting Using Automatic Workload Repository Defining AWR AWR Settings Creating AWR Baselines Metrics, Alerts, and Thresholds Defining Metrics Setting Alerts Setting Corrective Actions User Defined Metrics Metric Dynamic Views Join Types Nested Loops Join Sort Merge join Hash Join and Cartesian Join Equijoins and Nonequijoins Outer Joins Semijoins AWR Using Baselines Creating AWR baselines Creating AWR Repeating baselines Moving Window Baseline Additional AWR performance tools Automatic Maintenance Tasks Segment Advisor Statistics Gathering Automatic Tuning Optimizer Automatic Database Diagnostic Monitor Active Session History (ASH) Optimizer Statistics Optimizer Statistics Overview Table and Index Statistics Statistic Preferences Statistics Gathering e) Locking Statistics, Export/Import Statistics Pending and published statistics Optimizer Hints Optimizer Paths Cost Base Optimization Monitoring a Service Overview of what is an Oracle Service Creating an Oracle Service for Single instance and RAC Monitoring a Service Resource Management and a Service Enterprise Manager and a Service Bind Variables and database parameters Bind variable definition Cursor_sharing parameter Adaptive Cursor Sharing Oracle's Real Application Testing (RAT) Sql Performance Analyzer overview Sql Performance Analyzer Options Database Parameter changes Database version changes Creating SQL Tuning Sets Database Replay Overview Database Replay Configuration Database Replay Options SQL Tuning Advisor SQL Tuning Advisor: Overview SQL Tuning Advisor Limited Mode Sql Tuning Advisor Comprehensive mode Sql Tuning Profiles SQL Access Advisor SQL Access Advisor: Overview Sql Access Advisor options SQL Access Advisor and Sql Tuning Sets Sql Access Advisor and AWR Results and Implementation Automatic Sql Tuning Automatic Sql Tuning Maintenance Task Automatic Tuning Optimization implementation(ATO) Automatic Tuning Optimization Results Enable/Disable Automatic Tuning Optimization Sql Plan Management Sql plan Management and baseline overview Enable sql plan management Loading Sql Plan baselines into the SGA Adaptive plan management Shared Pool Tuning Shared pool architecture Shared pool parameters Library Cache Dictionary cache Large pool considerations and contents Tuning the database buffer cache Database buffer cache overview Database buffer cache parameters Oracle and Dirty reads and writes Automatic Shared Memory Management (ASMM) Buffer Cache goals and responsibility Buffer Cache pools Tuning the PGA (Program Global Area) PGA Overview PGA Database Parameters Temporary Segments Temporary Tablespace Sizing the PGA Automatic Memory Management (AMM) Oracle's Automatic Memory Management Overview Database Auto-tuned Parameters Database Non Auto-tuned Parameters Automatic Memory Management Hints and Sizing suggestions AMM versus ASMM Tuning Segment Space Utilization (ASSM) Overview of Automatic Segment Space Management Defining the DB_BLOCK_SIZE Defining DB_nk_CACHE_SIZE parameter The DB_BLOCK_SIZE Parameter Overview of table compression, block chaining, and block migration Automatic Storage Management Overview of ASM Definition of Grid Infrastructure ASM Instance ASM Diskgroups ASM Diskgroup parameters and templates ASMCMD

Oracle 19c Database Tuning (TTOR21519)
Delivered OnlineFlexible Dates
Price on Enquiry