1712 Courses in Cardiff delivered Online

Learning and applying new visual techniques can often be a daunting experience. This is especially true if you need to generate and code data visualizations yourself. This course focuses specifically on how to create many different types of graphs and all their possible options and sub-options.

24-Hour Knowledge Knockdown! Prices Reduced Like Never Before Did you know that according to a recent British Council study, strong English language skills are a top requirement for 82% of employers in the UK? Do you want to improve your English communication or even teach it to others? This comprehensive bundle offers everything you need to master English grammar, spelling, punctuation, and gain the qualifications to teach English as a foreign language (TEFL/TESOL). Our Teaching English Grammar & (TEFL/TESOL) course is designed to equip you with the essential knowledge and skills to master English grammar, spelling, and punctuation, boosting your confidence and communication effectiveness. You'll gain a solid understanding of sentence structure, question formation, and the correct use of punctuation marks and capitalization. We'll also tackle common spelling mistakes and equip you with techniques to improve your accuracy in this English Grammar, Spelling & Punctuation course. For those who aspire to teach English, this bundle includes TEFL/TESOL training courses. Learn effective lesson planning techniques and explore best practices for teaching English to non-native speakers. Master the art of pronunciation and hone your communication skills to become a successful English language instructor. Courses Are Included in this Teaching English Grammar & (TEFL/TESOL) Bundle: Course 01: 120 hours TEFL (TESOL) Masterclass Course 02: English: Spelling, Punctuation, and Grammar Course 03: Lesson Planning for Teaching Course 04: Basics of English for Beginners Course 05: Essential TEFL Training Course 06: Reach an Advanced Level in English as a Foreign Language Course 07: Explore the Fundamentals of English Tenses Course 08: British English Pronunciation Course Course 09: 200 Common English Idioms and Phrases Course 10: Level-3 English Grammar Course Course 11: Master English Speaking 1 Learning Outcomes of Teaching English Grammar & (TEFL/TESOL) Gain a solid understanding of English grammar rules and sentence structures. Master the art of spelling and punctuation to enhance your written communication. Develop a strong foundation in British English pronunciation. Learn effective teaching methodologies for TEFL/TESOL certification. Plan engaging and comprehensive lessons for your English language learners. Explore a wide range of common English idioms and phrases for natural communication. Invest in your future with this valuable skill. Strong English opens doors to better career opportunities, increased earning potential, and greater self-assurance. Take control of your communication and watch your career flourish! Enrol now! Why Choose Us? Get a Free CPD Accredited Certificate upon completion of English Grammar Get a free student ID card with English Grammar Training program (£10 postal charge will be applicable for international delivery) The English Grammar is affordable and simple to understand This course is entirely online, interactive lesson with voiceover audio Get Lifetime access to the English Grammar course materials The English Grammar comes with 24/7 tutor support Start your learning journey straightaway! *** Course Curriculum *** Course 01: 120 hours TEFL (TESOL) Masterclass Module 01: Introduction to English Language Teaching & Learning Module 02: Linguistics Module 03: English Pronunciation Module 04: Teaching Grammar and Vocabulary Module 05: Language Teaching Methodologies Module 06: Teaching Receptive Skills: Reading Module 07: Teaching Productive Skills: Writing Module 08: Teaching Receptive Skills: Listening Module 09: Teaching Productive Skills: Speaking Module 10: Lesson Planning and Creating Materials Module 11: Use of Games and Activities Module 12: Technology in Second Language Teaching & Learning Module 13: Classroom Management and Student Motivation Module 14: Teaching English: Situational Approach Module 15: Professional Development and Employment Course 02: English: Spelling, Punctuation, and Grammar Introduction to the Course Basics of Grammar The Basics of Sentence Structure of Sentence Questions Punctuation and Capitalisation Spelling Common Mistakes and Ways to Improve Course 03: Lesson Planning for Teaching Module 1: An Introduction To Planning And Teaching Module 2: Planning And Preparation In Teaching Module 3: Curriculum Module 4: Structure And Format Module 5: Methodology Module 6: Objectives And Learning Aims Module 7: Assessment And Evaluation =========>>>>> And 8 More Courses <<<<<========= How will I get my Certificate? After successfully completing the course, you will be able to order your Certificates as proof of your achievement. PDF Certificate: Free (Previously it was £12.99*11= £143) CPD Hard Copy Certificate: £29.99 CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this bundle. This bundle is ideal for: Beginners Intermediate Learners Advanced Learners English Teachers Future TEFL/TESOL Instructors Requirements You will not need any prior background or expertise to enrol in this bundle. Career path After completing this bundle, you are to start your career or begin the next phase of your career. Teacher Trainer Tutor Writer Editor Translator Certificates CPD Accredited Digital Certificate Digital certificate - Included Upon passing the Course, you need to order a Digital Certificate for each of the courses inside this bundle as proof of your new skills that are accredited by CPD QS for Free. CPD Accredited Hard Copy Certificate Hard copy certificate - £29.99 Please note that International students have to pay an additional £10 as a shipment fee.

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 ABAP Code Data Services Made Easy 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 the professional training that employers are looking for in today's workplaces. The ABAP Code Data Services Made Easy Course is one of the most prestigious training offered at Skillwise and is highly valued by employers for good reason. This ABAP Code Data Services Made Easy 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 ABAP Code Data Services Made Easy Course, like every one of Skillwise'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 Skillwise, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from Skillwise, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this ABAP Code Data Services Made Easy ? Lifetime access to the course forever Digital Certificate, Transcript, and student ID are all included in the price Absolutely no hidden fees Directly receive CPD Quality Standard-accredited qualifications after course completion Receive one-to-one assistance 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 ABAP Code Data Services Made Easy 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This ABAP Code Data Services Made Easy course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already work in relevant fields and want to polish their knowledge and skills. Prerequisites This ABAP Code Data Services Made Easy does not require you to have any prior qualifications or experience. You can just enrol and start learning. This ABAP Code Data Services Made Easy was made by professionals and it is compatible with all PCs, Macs, 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 a bonus, you will be able to pursue multiple occupations. This ABAP Code Data Services Made Easy is a great way for you to gain multiple skills from the comfort of your home. Introduction and Free System Set-up Trainer Intro and Course Overview 00:04:00 Free System Setup using CAL and GCP 02:04:00 CDS Basics Normal CDS, Parameterized CDS, How to call CDS in Program 02:14:00 Association, Association with PATH EXPRESSION, Different types of Association 01:57:00 CDS Intermediate CDS Table Function and Inbuilt Functions 01:37:00 OData with CDS using Annotations and VDM(Virtual Data model) 02:01:00 CDS Advance VDM - Transient Provider 01:55:00 VDM - Consumption View RSRT 01:12:00 HANA Text Search Hana Text Search, Fuzzy Search and DCL 01:31:00 HANA ALV IDA ALV IDA 02:30:00

17 Free PDF Certificates | 17-in-1 Bundle | CPD Approved | Free Retake Exam | Tutor Support

Overview HTML and CSS Coding: Beginner to Advanced Course is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this HTML and CSS Coding: Beginner to Advanced Course and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 05 Hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Getting Started Introduction 00:03:00 Course Curriculum 00:07:00 How To Get Course Requirements 00:02:00 Getting Started On Windows, Linux Or Mac 00:02:00 How To Ask A Great Questions 00:01:00 Setting Up Development Environment Introduction 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview Of A Webpage 00:05:00 Full HTML Code Page 00:07:00 First Hello World! Webpage 00:09:00 HTML Fundamentals Introduction 00:03:00 Heading 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 ID's In CSS 00:06:00 Comments In HTML 00:04:00 Summary 00:04:00 HTML Intermediate Introduction 00:02:00 Images 00:12:00 Forms 00:05:00 Form Actions 00:04:00 Br Tag 00:03:00 Marquee 00:06:00 Text Area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div Tag 00:06:00 Google Maps 00:07:00 Summary 00:02:00 HTML Advanced Introduction 00:02:00 HTML5 Audio 00:07:00 HTML5 Video 00:05:00 Progress Bar 00:04:00 Drag And Drop 00:18:00 Canvas 00:06:00 I Frames 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 YouTube Video Linking 00:04:00 Creating Responsive Page 00:05:00 Summary 00:02:00 HTML Expert Introduction 00:02:00 Registration Form 00:04:00 Login Form 00:04:00 About Us Form 00:02:00 Contact Us Form 00:10:00 Footer Form 00:03:00 Integrate All Together 00:07:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:02:00 Summary 00:02:00 HTML Website Project Introduction 00:02:00 Challenge - HTML 5 Clock Face With Numbers 00:05:00 Project Overview 00:03:00 Conclusion On Project 00:01:00 Summary 00:02:00 CSS Fundamentals Introduction 00:03:00 CSS Syntax 00:05:00 Creating A First Page With CSS Style 00:13:00 Inline CSS 00:06:00 Internal CSS 00:05:00 CSS External 00:10:00 CSS Classes 00:09:00 CSS IDs 00:06:00 Colors 00:08:00 Backgrounds 00:04:00 Floating 00:09:00 Positioning 00:06:00 Margins 00:07:00 Padding 00:04:00 Borders 00:03:00 Summary 00:02:00 CSS Intermediate Introduction 00:02:00 Styling Text 00:07:00 Aligning Text 00:04:00 Styling Links 00:10:00 Font Family 00:07:00 Font Styles 00:03:00 Applying Google Fonts 00:07:00 Box Model 00:09:00 Icons 00:09:00 Tables 00:16:00 Navigation-Menu 00:11:00 Dropdowns 00:15:00 Summary 00:02:00 CSS Advanced Introduction 00:02:00 Advanced Selectors 00:05:00 Forms 00:17:00 Website Layout 00:21:00 Rounded Corners 00:08:00 Color Keywords 00:06:00 Animations 00:08:00 Pseudo Classes 00:03:00 Gradients 00:03:00 Shadows 00:03:00 Calculations 00:05:00 Creating Responsive Page 00:06:00 Summary 00:02:00 CSS Expert Introduction 00:01:00 Button Styles 00:06:00 Flexbox 00:14:00 CSS Grid 00:15:00 Pagination 00:07:00 Multiple Columns 00:06:00 Image Reflection 00:02:00 UI - UX Design 00:09:00 Social Media Icons 00:08:00 Coding Exercise 00:01:00 Solution For Coding Exercise 00:03:00 Summary 00:02:00 CSS Website Project Introduction 00:01:00 CSS Project Getting 00:05:00 CSS Project Overview 00:08:00 Summary 00:01:00 Publish Your Website For Live Introduction 00:02:00 Installing Free FTP Solution (FileZilla) 00:04:00 Setting Up FTP (File Transfer Protocol) 00:03:00 Publish Website To Hosting Server 00:04:00 Summary 00:01:00

Duration 5 Days 30 CPD hours This course is intended for Network design engineers Network engineers System administrators Overview After taking this course, you should be able to: Design Enhanced Interior Gateway Routing Protocol (EIGRP) internal routing for the enterprise network Design Open Shortest Path First (OSPF) internal routing for the enterprise network Design Intermediate System to Intermediate System (IS-IS) internal routing for the enterprise network Design a network based on customer requirements Design Border Gateway Protocol (BGP) routing for the enterprise network Describe the different types and uses of Multiprotocol BGP (MP-BGP) address families Describe BGP load sharing Design a BGP network based on customer requirements Decide where the L2/L3 boundary will be in your Campus network and make design decisions Describe Layer 2 design considerations for Enterprise Campus networks Design a LAN network based on customer requirements Describe Layer 3 design considerations in an Enterprise Campus network Examine Cisco SD-Access fundamental concepts Describe Cisco SD-Access Fabric Design Design a Software-Defined Access (SD-Access) Campus Fabric based on customer requirements Design service provider-managed VPNs Design enterprise-managed VPNs Design a resilient WAN Design a resilient WAN network based on customer requirements Examine the Cisco SD-WAN architecture Describe Cisco SD-WAN deployment options Design Cisco SD-WAN redundancy Explain the basic principles of QoS Design Quality of Service (QoS) for the WAN Design QoS for enterprise network based on customer requirements Explain the basic principles of multicast Designing rendezvous point distribution solutions Describe high-level considerations when doing IP addressing design Create an IPv6 addressing plan Plan an IPv6 deployment in an existing enterprise IPv4 network Describe the challenges that you might encounter when transitioning to IPv6 Design an IPv6 addressing plan based on customer requirements Describe Network APIs and protocols Describe Yet Another Next Generation (YANG), Network Configuration Protocol (NETCONF), and Representational State Transfer Configuration Protocol (RESTCONF) The Designing Cisco Enterprise Networks (ENSLD) v1.1 course gives you the knowledge and skills you need to design an enterprise network. This course serves as a deep dive into enterprise network design and expands on the topics covered in the Implementing and Operating Cisco© Enterprise Network Core Technologies (ENCOR) v1.0 course.This course also helps you prepare to take the 300-420 Designing Cisco Enterprise Networks (ENSLD) exam which is part of the CCNP© Enterprise and Cisco Certified Specialist - Enterprise Design certifications. Course Outline Designing EIGRP Routing Designing OSPF Routing Designing IS-IS Routing Design Case Study Activity: Designing Enterprise Connectivity Designing BGP Routing and Redundancy Understanding BGP Address Families and Attributes Design Case Study Activity: Designing an Enterprise Network with BGP Internet Connectivity Designing the Enterprise Campus LAN Designing Layer 2 Campus Design Case Study Activity: Designing an Enterprise Campus LAN Designing Layer 3 Campus Discovering the Cisco SD-Access Architecture Exploring Cisco SD-Access Fabric Design Exploring Cisco SD-Access Site Design Strategy and Considerations Design Case Study Activity: Designing Cisco SD-Access in the Enterprise Designing Service Provider-Managed VPNs Designing Enterprise-Managed VPNs Designing WAN Resiliency Design Case Study Activity: Designing Resilient Enterprise WAN Examining Cisco SD-WAN Architectures Examining Cisco SD-WAN Deployment Design Considerations Designing Cisco SD-WAN Routing and High Availability Design Case Study Activity: Designing Resilient Enterprise Cisco SD-WAN Understanding QoS Designing LAN and WAN QoS Design Case Study Activity: Designing QoS in an Enterprise Network Exploring Multicast with Protocol-Independent Multicast-Sparse Mode (PIM-SM) Designing Rendezvous Point Distribution Solutions Designing an IPv4 Address Plan Exploring IPv6 Deploying IPv6 Design Case Study Activity: Designing an Enterprise IPv6 Network Introducing Network APIs and Protocols Exploring YANG, NETCONF, RESTCONF, and Model-Driven Telemetry Additional course details: Nexus Humans Cisco Designing Cisco Enterprise Networks v1.1 (ENSLD) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Cisco Designing Cisco Enterprise Networks v1.1 (ENSLD) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

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

This Adobe Illustrator CC Advanced is designed for the intermediate Illustrator user. Through the course, you will learn more advanced aspects of how to create artwork for illustrations, logos, stationery, page layouts, posters and more! Take your Adobe Illustrator skills to the next level as you explore the potential of gradient meshes, symbols, graphic styles, and effects to enhance your artwork. Improve your workflow and technical command as you tackle projects that include photo-realistic illustration, pattern making, information graphics, and product mockup. Explore advanced techniques used by professionals to create infographics, trace artwork, apply dynamic effects, work with 3D, perspective grids and other great Adobe Illustrator features. Learn which tools are best suited to a UI design workflow and how to customize Illustrator in a way that fits your style and flow. What Will I Learn? Advanced Color and Swatches Shape Building Importing Graphics Understanding Masking Requirements Adobe Illustrator Introduction or equivalent knowledge Chapter 1 Introduction 00:04:00 OpenType SVG and Variable Fonts 00:06:00 Converting Type to Outlines 00:03:00 Using Type Styles 00:08:00 Placing Type from Files 00:04:00 Using Find and Replace 00:05:00 Working with Area Type Options 00:05:00 Threading Type 00:03:00 Wrapping Text Around Objects 00:04:00 Chapter 2 Creating Swatch Groups 00:03:00 Using the Color Guide Panel 00:03:00 Recoloring Artwork 00:07:00 Creating Patterns 00:08:00 Using Blends 00:08:00 Working with the Gradient Tool 00:09:00 Applying a Gradient Mesh 00:08:00 Using the Freeform Gradient Tool 00:07:00 Using Live Paint 00:06:00 Chapter 3 Using Advanced Pen Features 00:09:00 Transforming Shapes 00:08:00 Working with Effects and the Appearance Panel 00:09:00 Adding 3D Effects 00:09:00 Mapping Artwork onto 3D Objects 00:08:00 Using Envelope Distort 00:06:00 Using Graphic Styles 00:06:00 Working with Symbols 00:05:00 Using the Symbol Tools 00:09:00 Using the Puppet Warp Tool 00:05:00 Chapter 4 Placing Raster Images 00:04:00 Tracing Over Raster Images 00:06:00 Using Image Trace 00:10:00 Chapter 5 Understanding Clipping Masks 00:04:00 Using Opacity Masks 00:05:00 Chapter 6 Creating a Perspective Grid 00:06:00 Drawing Shapes on the Grid 00:05:00 Adding Illustrations to the Grid 00:05:00 Chapter 7 Working with Actions 00:10:00 Working with Artboards 00:07:00 Mastering the Align Panel 00:06:00 Customizing Illustrator Toolbars 00:05:00 Using Global Edits 00:04:00 Saving and Sharing Sets 00:07:00 Layer Tips and Tricks 00:05:00 Conclusion Course Recap 00:01:00

Overview We all know the rule of 'The Customer Comes First', but when do they stay with you? When can a business ensure its customer base to be loyal and retainable? While there are multiple factors at play here, but one of the keys to customer retention is quality customer service.   Businesses nowadays rely heavily on people skilled in customer service and customer satisfaction - which is often hard to come by. To bridge that skill gap, empower human resources with outstanding customer support & service capabilities, and help business owners/managers gather essential knowledge to run & manage the relevant operations smoothly, we have put together this carefully-crafted course with the help of our learning resource development team. If you are someone who wants to build a career in this promising field, our course will be your perfect guide along the road. This course focuses on providing beginners' with the base, helping moderately-skilled learners to level up their understandings, and enabling professionals to fill in the blanks of the updates within the fields of customer experience enhancement.    Reflecting the above-mentioned promises, this Customer Service course focuses on helping the learners develop the following skills: Effective communication & active listening Problem solving Attentiveness Anger Management Time Management Stress Management Conflict resolution Customer relationship management Customer experience enhancement Customer service evaluation Email writing & etiquettes Positive attitude & body language   So, enrol now, develop these in-demand skills of the 21st century and make meaningful connections with your customers around the globe.   Who is this course for? If you run a business or work for one, you have to understand what your customers want, how to serve them properly, and repeat this process - no matter what your job description says or whichever department you work in. Having said that, people falling into either one of the below groups will benefit the most from this course: Jobseekers in fields related to customer service/customer support/customer experience Amateurs or professionals with intermediate skills in the above-mentioned fields Business-owners/managers/team leaders Business students People looking to get certified in customer service   Career Path This Customer Service course paves the way for a handful of career opportunities, with roles such as: Customer Service Representative/Executive/Officer Customer Service Advisor/Specialist Customer Service Manager Also, the job roles related to customer support/customer experience will also be available to you. While the salaries for the above-mentioned jobs vary based on responsibilities, the levelwise breakdown of expected salaries are - Entry level: £16,750 - £20,750 Mid-level: £26,400 - £36,800 Senior level: £35,00 - £50,500 Course Curriculum Module 1 - Basics of Customer Service Basics of Customer Service 00:00 Module 2 - Why Customer Service Matters Why Customer Service Matters 00:00 Module 3 - What's Different about Good Service What's Different about Good Service 00:00 Module 4 - First Steps and Body Language First Steps and Body Language 00:00 Module 5 - Effective Communication Strategies Effective Communication Strategies 00:00 Module 6 - Phone Tone and Etiquette Phone Tone and Etiquette 00:00 Module 7 - Relationship Building Relationship Building 00:00 Module 8 - Turning Complaints into Opportunities Turning Complaints into Opportunities 00:00 Module 9 - E-Mail Etiquette E-Mail Etiquette 00:00 Module 10 - Customer Relationship Management (CRM) Customer Relationship Management (CRM) 00:00 Module 11 - Empowering Great Customer Service Empowering Great Customer Service 00:00 Module 12 - Evaluating and Measuring Customer Service Evaluating and Measuring Customer Service 00:00

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