14306 Environment courses

Unveiling the art of 'Acrylic Nailing'! Delve deep into this transformative course designed meticulously for aspirants longing to master the realm of nail aesthetics. Our structured curriculum kicks off by demystifying the rudiments of nail extension techniques, leading you progressively to the captivating world of acrylic nail artistry. Let your creativity bloom as you gain profound insights into nail anatomy, nail product chemistry, and hands-on training in nail art, while also being well-equipped with essential knowledge about the health and safety norms in a beauty salon. Learning Outcomes Understand the underlying structure and anatomy of nails. Recognise common nail diseases and disorders, and their implications on nail treatments. Master the art of acrylic nail extensions, from application to advanced designs. Learn maintenance, care, and removal techniques for acrylic nails. Adopt best practices for health and safety in a salon environment. Why choose this Acrylic Nailing course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Acrylic Nailing 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. Who is this Acrylic Nailing course for? Aspiring nail technicians eager to specialise in acrylic extensions. Beauty professionals looking to expand their service offerings. Enthusiasts keen on learning the art of acrylic nailing for personal use. Salon owners aiming to upskill their staff and enhance client services. Individuals considering a career switch to the beauty and wellness industry. Career path Nail Technician: £18,000 - £25,000 per annum Beauty Therapist: £18,500 - £23,000 per annum Salon Manager: £25,000 - £32,000 per annum Acrylic Nail Specialist: £20,000 - £28,000 per annum Nail Art Designer: £19,000 - £27,000 per annum Beauty Salon Owner: £30,000 - £50,000+ per annum (varies based on salon success) Prerequisites This Acrylic Nailing does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Acrylic Nailing 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 Acrylic Nailing Module 01: Nail Extension Techniques: An Introduction 00:12:00 Module 02: Nail Anatomy 00:15:00 Module 03: Nail Diseases and Disorders 00:30:00 Module 04: Nail Product Chemistry Simplified 00:15:00 Module 05: Nail Extension Techniques 00:05:00 Module 06: Acrylic Nail Extension: Part-1 (Applying Tips to the Nails) 00:20:00 Module 07: Acrylic Nail Extension: Part-2 (Applying Overlays) 00:20:00 Module 08: Art in Acrylic Nails: Basic to Advance 00:05:00 Module 09: Hands-on Nail Art Training 00:05:00 Module 10: Maintaining Artificial Nails 00:15:00 Module 11: Acrylic Nail Removal 00:10:00 Module 12: Health and Safety in Beauty Salon 00:25:00 Module 13: Client Care and Communication 00:20:00 Mock Exam Mock Exam - Acrylic Nailing 00:20:00 Final Exam Final Exam - Acrylic Nailing 00:20:00

Immerse yourself in the world of figures and fiscal responsibility with the 'Accounting Fundamentals Diploma', a gateway to mastery in the robust field of accountancy. Encompassing a journey from the foundational stones of accounting to a sophisticated understanding of financial management, this course beckons aspirants to navigate through the riveting world of budgets, investments, and financial analysis, ensuring a comprehensive grasp of the monetary mechanics. As you delve into the vital initial modules, a thorough comprehension of who accountants are and the pivotal role they play in an organisation's financial stability becomes remarkably evident. Embark on an enlightening voyage through intricate financial pathways, exploring profound modules like financial statement creation and discerning analysis, thereby enabling the demystification of complex financial data. This exploration further unravels through enlightening perspectives on budgeting and its consequential significance, coupled with a sturdy introduction to the financial markets and bonds, providing you with the critical tools to forge fiscal prudence and strategising adeptness within any business environment. Learning Outcomes Attain a robust foundational knowledge of accounting principles and practices. Develop adeptness in creating, analysing, and interpreting financial statements. Gain proficiency in budget creation and understanding its strategic role in financial planning. Acquire skills to manage, analyse, and make informed decisions regarding investments. Understand and implement risk management strategies, focusing on auditing and fraud prevention. Why buy this Accounting Fundamentals Diploma? 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 Accounting Fundamentals Diploma for? Aspiring accountants seeking foundational knowledge in finance and accounting. Small business owners who wish to manage their own finances and understand financial strategies. Finance students who aim to supplement their academic knowledge with applied skills. Non-finance professionals aiming to gain an understanding of financial practices for career enhancement. Individuals exploring a career change into the financial sector without prior background. Career path Chartered Accountant: £50,000 - £60,000 Financial Analyst: £30,000 - £45,000 Investment Analyst: £45,000 - £65,000 Auditor: £35,000 - £55,000 Budget Analyst: £30,000 - £46,000 Risk Manager: £50,000 - £80,000 Prerequisites This Accounting Fundamentals Diploma 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: Introduction to Accounting Introduction to Accounting 00:07:00 Module 02: Who are Accountants? Who are Accountants? 00:06:00 Module 03: The Accounting System The Accounting System 00:07:00 Module 04: What are Financial Statements? What are Financial Statements? 00:08:00 Module 05: Introduction to Financial Statement Analysis Introduction to Financial Statement Analysis 00:11:00 Module 06: Budgeting and Its Importance Budgeting and Its Importance 00:08:00 Module 07: Financial Markets and Bonds Financial Markets and Bonds 00:13:00 Module 08: Dealing with Financial Risk Management Dealing with Financial Risk Management 00:12:00 Module 09: Investment Management and Analysis Investment Management and Analysis 00:09:00 Module 10: Auditing and Risk of Frauds Auditing and Risk of Frauds 00:11:00

The Business Intelligence Analyst Course aligns with current industry trends and market needs, addressing emerging opportunities and challenges in data-driven decision-making. As businesses increasingly rely on data for strategic planning, this course provides the foundational knowledge and skills required to interpret and leverage data effectively. It prepares learners to meet the growing demand for data analysis and interpretation in various sectors. The primary problem this course addresses is the gap in practical, accessible knowledge for analysing and interpreting business data. By bridging this gap, the course enables learners to transform raw data into meaningful insights. This ability is crucial for driving business growth, improving operational efficiency, and enhancing strategic decision-making processes across industries. In today's data-centric business environment, possessing skills in business intelligence and data analysis is not just advantageous but essential. This course equips learners with the knowledge to analyse data accurately, leading to informed decision-making and competitive advantage in various business contexts. Learning Outcomes Understand the basics and importance of Business Intelligence in modern business. Grasp real-time applications of Business Intelligence in industry scenarios. Learn statistical and data science fundamentals crucial for analysis. Gain proficiency in SQL for effective data management and querying. Master essential aspects of database management and operations. Explore data warehouse concepts and their relevance in data storage. Develop skills in data visualisation techniques for business insights. Acquire basic Python knowledge for data analysis applications. Why choose this Business Intelligence Analyst Course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Business Intelligence Analyst Course for? Individuals aspiring to become Business Intelligence Analysts. Professionals seeking to enhance their data analysis skills. Entrepreneurs needing to understand data for better business decisions. Managers and team leaders requiring data-driven decision-making abilities. Anyone interested in pursuing a career in data analysis and business intelligence. Career path Business Intelligence Analyst: £30,000 - £50,000 Data Analyst: £27,000 - £40,000 Database Administrator: £30,000 - £45,000 Data Scientist: £35,000 - £60,000 Business Analyst: £32,000 - £52,000 Prerequisites This Business Intelligence Analyst Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Business Intelligence Analyst 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-1: An Introduction to Business Intelligence An Introduction to Business Intelligence 00:46:00 Module-2: Real-time Business Intelligence Real-time Business Intelligence 00:35:00 Module-3: Fundamentals of Statistics and Data Science Fundamentals of Statistics and Data Science 00:50:00 Module-4: Fundamentals of SQL Fundamentals of SQL 00:40:00 Module-5: Database Management Essentials Database Management Essentials 00:50:00 Module-6: Data Warehouse Concepts Data Warehouse Concepts 00:38:00 Module-7: Data Visualisation in Business Intelligence Data Visualisation in Business Intelligence 00:35:00 Module-8: Basics of Python Basics of Python 00:27:00

Are you ready to embark on a journey that combines the joy of play with the profound impact it has on children's lives? Welcome to the Level 3 Diploma in Child Playwork, a course designed to unlock the secrets of fostering an environment where play becomes not just a pastime but a powerful tool for education, development, and well-being. In this course, we delve into the world of child playwork, exploring its myriad dimensions and uncovering the magic that lies within the realm of children's play.  Learning Outcomes of Level 3 Diploma in Child Playwork: Understand the fundamental principles and concepts of child playwork. Recognize the diverse benefits of playwork in education, social development, economics, and overall well-being. Gain insights into the role of playworkers and their significance in facilitating meaningful play experiences. Acquire the knowledge and skills necessary to design engaging and safe play spaces. Explore the potential negative consequences of play deprivation and the importance of promoting play in children's lives.   Why Choose This Level 3 Diploma in Child Playwork Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Certification After studying the course materials of the Level 3 Diploma in Child Playwork you will be able to take the MCQ test that will assess your knowledge. 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 Level 3 Diploma in Child Playwork course for? This Level 3 Diploma in Child Playwork course is ideal for Aspiring Child Playworkers looking to enter the field. Early childhood educators seeking to enhance their understanding of play's significance. Parents and caregivers interested in creating enriching play experiences for children. Education professionals aiming to integrate playwork principles into their teaching. Individuals passionate about children's well-being and eager to make a positive impact in their lives.   Prerequisites This Level 3 Diploma in Child Playwork 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 Playworker: £18,000 - £25,000 per annum Early Childhood Educator: £20,000 - £30,000 per annum Childcare Manager: £25,000 - £35,000 per annum Play Space Designer: £22,000 - £28,000 per annum Child Development Specialist: £25,000 - £35,000 per annum Health and Safety Manager (Childcare): £30,000 - £40,000 per annum Course Curriculum Module 01: Introduction to Child Playwork Introduction to Child Playwork 00:14:00 Module 02: Playwork and Playworkers Playwork and Playworkers 00:13:00 Module 03: Educational and Learning Benefits of Playwork Educational and Learning Benefits of Playwork 00:08:00 Module 04: Economic and Social Benefits of Playwork Economic and Social Benefits of Playwork 00:11:00 Module 05: Health and Well-Being Benefits of Playwork Health and Well-Being Benefits of Playwork 00:13:00 Module 06: Developmental Benefits of Playwork Developmental Benefits of Playwork 00:15:00 Module 07: Negative Impact of Play Deprivation Negative Impact of Play Deprivation 00:09:00 Module 08: Designing Play Spaces Designing Play Spaces 00:10:00 Module 09: Health and Safety Management in Playwork Health and Safety Management in Playwork 00:14:00

Imagine mastering the rapid-paced world of Forex trading with our 'Forex Scalping Strategy Course.' This course is your golden ticket to understanding the nuances of quick, short-term trading strategies that can significantly enhance your financial acumen. Initiating your journey with a fundamental introduction to Forex scalping, the course paves the way for an in-depth exploration of this thrilling trading method. As you progress, you'll delve into the vital role of indicators, learning to interpret them to make swift, yet astute trading decisions. Each section builds upon the last, culminating in advanced techniques that will elevate your trading prowess to new heights. Advancing through the course, you'll uncover the core of our scalping strategy, a treasure trove of insights and methodologies designed to sharpen your trading skills. The course is more than just theoretical knowledge; it's a practical guide to real-world Forex trading. You'll have the opportunity to apply your learning in simulated scenarios, providing a safe yet realistic environment to hone your skills. By the end of this course, you will not only understand the intricacies of Forex scalping but also be equipped to apply these strategies in live trading scenarios, turning knowledge into profitable action. Learning Outcomes Grasp the fundamental concepts and techniques of Forex scalping. Analyse and apply various indicators for effective short-term trading. Master the primary Forex scalping strategy taught in the course. Navigate and leverage advanced Forex trading methods and concepts. Translate theoretical learning into practical Forex trading applications. Why choose this Forex Scalping Strategy course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Forex Scalping Strategy course for? Novice traders eager to learn the basics and intricacies of Forex scalping. Experienced traders looking to refine and expand their short-term trading strategies. Finance students or professionals aiming to diversify their trading skill set. Individuals interested in a comprehensive understanding of Forex market indicators. Any trader seeking to transform their theoretical knowledge into actionable trading tactics. Career path Forex Trader - £35,000 - £60,000 Market Analyst - £40,000 - £65,000 Trading Strategy Consultant - £45,000 - £70,000 Financial Analyst - £38,000 - £58,000 Investment Advisor - £50,000 - £75,000 Risk Manager - £42,000 - £67,000 Prerequisites This Forex Scalping Strategy Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Forex Scalping Strategy 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 Section 01: Introduction Introduction 00:02:00 How to Choose a Broker for Scalping 00:01:00 How to Set up Chart 00:02:00 Section 02: Indicators Indicator Part 1 00:05:00 Indicator Part 2 00:06:00 Support and Resistance 00:05:00 Section 03: The Strategy The Secret Scalping Strategy 00:06:00 Section 04: Advance Stuff Golden Rules 00:05:00 Risk Management 00:02:00 Examples 00:10:00 Assignment Assignment - Forex Scalping Strategy Course 00:00:00

Description: A SCRUM master is a facilitator for the agile development team. A SCRUM master servers the Product owner in several ways such as - By finding methods for efficient Product Backlog management By facilitating the Scrum Team to understand the need for clear and concise Product Backlog items. By Understanding and analyzing product planning in an empirical environment. By educating the Product Owner to arrange the Product Backlog to maximise value. By Understanding and practicing agility. By Facilitating Scrum events The Scrum Product Owner Video Training Course provides all the necessary information related to SCRUM Product owner with a special focus on the topics like roles and responsibilities, planning, managing quality, change, and risk. Throughout the course, you will learn the sprint planning meeting, the ways of grooming the prioritized product backlog, the sprint review meeting, and shipping deliverables. In short, by the end of the Scrum Product Owner Video Training Course, you will learn how to use Scrum to optimise value, productivity, and goals. Assessment & Certification: To achieve a formal qualification, you are required to book an official exam separately with the relevant awarding bodies. However, you will be able to order a course completion CPD Certificate by paying an additional fee. Hardcopy Certificate by post - £19 Soft copy PDF via email - £10 Requirements Our Scrum Product Owner Video Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Introduction Introduction FREE 00:11:00 Introduction to Scrum Introduction to Scrum 00:01:00 Scrum Overview 00:21:00 Scrum Concepts & Principles 00:15:00 Scrum Phases & Processes 00:05:00 Introduction to Scrum Summary 00:02:00 Roles and Responsibilities Roles and Responsibilities 00:01:00 The Product Owner 00:06:00 The Scrum Master 00:04:00 The Scrum Team 00:09:00 Roles & Responsibility Summary 00:02:00 Manage Quality, Change, and Risk Planning 00:02:00 The Project Vision 00:11:00 User Group Meetings 00:11:00 Estimates 00:08:00 Prioritized Product Backlog 00:11:00 Release Plan 00:12:00 Planning Summary 00:02:00 Planning Manage Quality, Change, and Risk 00:01:00 Quality 00:07:00 Change 00:07:00 Risk 00:13:00 Manage Quality, Change & Risk Summary 00:02:00 Sprints Sprints 00:01:00 Sprint Planning Meeting 00:21:00 During the Sprint 00:07:00 Groom the Prioritized Product Backlog 00:04:00 Sprint Review Meeting 00:04:00 Ship Deliverables 00:02:00 Sprints 00:03:00 Mock Exam Mock Exam- Scrum Product Owner Video Training Course 00:20:00 Final Exam Final Exam- Scrum Product Owner Video Training Course 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Learn to build a RESTful API using ASP.NET Core Minimal API, entity framework, and employ enterprise-level development practices and patterns. We will implement various support tools for data validations, logging, documentation, and security. You will learn everything you need to know about building a Minimal API using .NET 6 (or .NET 7 preview).

If you want to teach English effectively, our 120-Hour TEFL (TESOL) Certificate Course is for you. Develop skills for teaching reading, writing, listening, and speaking. Manage your classroom and motivate your students. Discover professional development and employment opportunities in TEFL / TESOL.

Are you motivated to produce creative goods while keeping the environment in mind? Or do you just want to get started with a sustainable energy strategy? If so, this Sustainable Energy at QLS Level 4 is an ideal course for you! In this course, you will get an overview of sustainable energy. You will learn about solar energy, both thermal and photovoltaic basics, along with a foundation on geothermal energy. The core concepts of wind energy, bioenergy, and tidal energy will also be discussed. In addition, this course will also cover the environmental impacts, renewable energy and sustainable development. In the last module, we will discover the future of renewable energy in the UK. Anyone interested in alternative energy sources and environmental responsibility may desire to take this course. Using this course, you will be able to understand a range of vital issues, greatly increasing your employability. So, do not think twice; enrol now! Learning Outcome Upon successful completion of the Sustainable Energy at QLS Level 4 course, you will be able to: Get an introduction to sustainable energy. Improve your understanding of solar energy. Learn the core concepts of wind energy, bioenergy and geothermal energy. Understand the environmental impacts in the related industry. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Course? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standard-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** Here is the curriculum breakdown of the course: Module 01: An Introduction to Sustainable Energy Module 02: Solar Energy: Thermal Module 03: Solar Energy: Photovoltaics Module 04: Wind Energy Module 05: Bioenergy Module 06: Geothermal Energy Module 07: Tidal Energy Module 08: Environmental Impacts: A Global and Regional Assessment Module 09:Renewable Energy and Sustainable Development Module 10: The Future of Renewable Energy in the UK into the 2020s and Beyond Assessment Process We offer an integrated assessment framework to make the process of evaluation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this course. This will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrolment, and you can access the course materials from any location in the world. Requirements The program does not require any prior knowledge; everyone may participate! This course is open to anyone who is interested in learning from anywhere in the world. Every student must be over the age of 16 and have a passion for learning and literacy. This 100% online course can be accessed from any internet-connected device, such as a computer, tablet, or smartphone. This course allows you to study at your own speed and grow a quality skillset. Career path Renewable Energy Consultant Renewable Energy Broker Energy Manager In the UK, the average salary of these professions ranges from £25K-£55K per annum. Certificates CPD Accredited Certificate Digital certificate - £10 Diploma in Sustainable Energy at QLS Level 4 Hard copy certificate - £99 After successfully completing the Diploma in Sustainable Energy at QLS Level 4 course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for international delivery CPD Accredited Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery)

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?