1127 Courses in Cardiff delivered Online

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?

Course Objectives The goal of this course is to provide you with the knowledge required to use more advanced functions and formulas and work with various tools to analyse and present data in spreadsheets, such as sorting, filtering, applying conditional formatting and charting the data. ' Customer Feedback Really useful and engaging course. Learnt a lot that will be very beneficial in my job. Trainer was great. Kelly Moreley - TACT Very happy with the course. Worked as a good refresher from what I knew already and enhanced my knowledge further in formulas + vlookup and shortcut keys. Jenny Price - Acer 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored training courses: In, in company training, you can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Recap on Excel formulas and calculations Overview of formulas in Excel Relative, Absolute and Mixed cell references Group editing worksheets Autofill and Flash Fill Changing Excel’s environment Options Changing the default number of sheets Creating an Autofill Custom List Adding tools to the Quick Access Toolbar Mastering Excel Tables Introducing Excel Tables Formatting a Table Creating Calculated Columns Using Slicers to filter your data Using Totals to get statistics out of your data Removing duplicates Converting Tables back to normal Ranges Using names Ranges In Excel formulas As a way of navigating through the workbook Advanced Formulas Simple IF examples Using IF to check if a cell is blank Nested IFs VLOOKUP HLOOKUP Text Functions Date Functions Conditional formatting Apply Conditional Formatting Customising Conditional Formatting Using Icons in Conditional Formatting Using Formulas to conditionally format cells Linking spreadsheets and workbooks Making a reference to another worksheet Making a reference to another workbook Editing links Troubleshooting links Analysing databases Quick analysis Sorting a database Apply filters to a database Advance filter Sorting and Filtering by Conditional Formats Charts Analyse trends in data using Sparklines Creating charts from start to finish Exploring the different Chart Types Apply Chart Styles Formatting Chart Elements Filtering Charts by Series or Categories Adding a Trendline to a Chart Create a Chart Template Attaching security to a spreadsheet and workbook Protect Cells Protect Structure of worksheets Protect a Workbook by adding passwords Introduction to Pivot Tables What are Pivot Tables? Using recommended pivot tables to analyse your data Who is this course for? Who is this course for? For those who want to explore in more detail formulas and functions, data analysis and data presentation. Requirements Requirements Preferably, delegates would have attended the Excel Introduction course. Career path Career path Excel know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Certificates Certificates Certificate of completion Digital certificate - Included

This course begins with establishing the motivation for reinforcement learning and then progresses on to equipping you with all the necessary theory. Each section of the course helps you not only understand the fundamentals of RL but also gain necessary coding skills by taking you through exercises. By the end of the course, you will be able to complete a project using the OpenAI Gym toolkit.

When introducing epilepsy, we must first recognise that there are around 40 different types of seizures. Statistics show that one in five people will have a seizure at some time in their life although only some of these will be caused by epilepsy. Epilepsy is a neurological condition that affects the brain and the nervous system and is covered by the Equality Act 2010. The condition can affect people for only a portion of their life, or it can be lifelong. Because of the varied nature of the condition an awareness of epilepsy and the actions you can take if you are present during a seizure is incredibly useful for those who work in health and social care. This course will give you an overview of epilepsy. It lists the methods of diagnosis, what a seizure is and how the brain can be affected. It will introduce some possible seizure triggers and describe what to do when someone has a seizure. It will also discuss some of the treatments offered to people with epilepsy and provide practical advice on what you can do if you witness someone having a seizure.

Electricity is the lifeblood of modern society, it enhances our quality of life and we are becoming increasingly reliant on it to power tools and devices we use for work and entertainment. However, although electricity has many benefits it can also be a hidden killer as it can’t be seen, felt, smelled or heard until someone comes into contact with it. This course will start by covering the many benefits electricity brings to society, as well as its key components voltage, current and resistance. It will explain the two main types of electricity, cover UK accident and death statistics, and describe a simple way of remembering the electrical hazards. It then goes on to provide basic instructions about how you could safely help someone you suspect has received an electric shock. Towards the end of the course it includes an overview of the main standards, guidance and legislation that control the use of electricity in the workplace, and finish off by looking at simple maintenance plans and portable appliance testing including who within an organisation would be best to carry out the various checks.

In this course, you will quickly learn how to build DNNs (Deep Neural Networks) and how to train them. This learning-by-doing course will also help you master the elementary concepts and methodology with Python. You need to have a basic knowledge of python to get the best out of this course.

Embark on a transformative journey into data analytics with our comprehensive course. Discover the power of data & analytics through engaging modules designed to equip you with skills and knowledge. Whether you're a novice or a seasoned professional, this data analytics course is your gateway to unlocking the potential of big data analytics. From understanding the basics like what is data analytics and harnessing the power of statistics to mastering data visualisation tools, each step is crafted to empower you with the tools necessary to navigate the world of data analytics confidently. With the Google Data Analytics Professional Certificate, you'll gain invaluable insights and practical experience that can catapult you into lucrative data analytics jobs. From enhancing your employability to boosting your earning potential, this course opens doors to a myriad of opportunities in this field. Learning Outcomes: Acquire a solid foundation in data analytics principles and techniques. Develop proficiency in using various data analytics tools and software. Gain skills in data mining, storage, and visualisation. Cultivate a data-analytic mindset to tackle complex problems effectively. Explore career pathways in data science with confidence and clarity. Why buy this Data Analytics 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 Data Analytics 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 Data Analytics course for? Aspiring data analysts seeking to kickstart their careers. Professionals looking to enhance their skillset in this field. Students interested in exploring the fascinating world of data science. Entrepreneurs aiming to leverage analytics for business growth. Individuals seeking to transition into lucrative data analytics jobs. Prerequisites This Data Analytics does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Data Analytics 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 Data Analyst: £25,000 - £50,000 Per Annum Data Scientist: £30,000 - £70,000 Per Annum Business Intelligence Analyst: £28,000 - £55,000 Per Annum Data Engineer: £35,000 - £65,000 Per Annum Database Administrator: £25,000 - £55,000 Per Annum Analytics Manager: £40,000 - £80,000 Per Annum Course Curriculum Module 01: Introduction to the World of Data Introduction to the World of Data 01:00:00 Module 02: Basics of Data Analytics Basics of Data Analytics 00:40:00 Module 03: Statistics for Data Analytics Statistics for Data Analytics 01:00:00 Module 04: Actions Taken in the Data Analysis Process Actions Taken in the Data Analysis Process 00:55:00 Module 05: Gathering the Right Information Gathering the Right Information 01:00:00 Module 06: Storing Data Storing Data 01:15:00 Module 07: Data Mining Data Mining 01:00:00 Module 08: Excel for Data Analytics Excel for Data Analytics 01:20:00 Module 09: Tools for Data Analytics Tools for Data Analytics 01:20:00 Module 10: Data-Analytic Thinking Data-Analytic Thinking 01:10:00 Module 11: Data Visualisation That Clearly Describes Insights Data Visualisation That Clearly Describes Insights 00:45:00 Module 12: Data Visualisation Tools Data Visualisation Tools 01:00:00 Assignment Assignment - Data Analytics 00:00:00

Course Overview Use Microsoft's benchmark business application to its full potential by taking this Advanced Excel Analytics by Real World Projects course. Using expert guidance, the contents will familiarise you with the broad range of functionalities on Excel, empowering you to deliver enhanced information analysis and accurate conclusions more effectively across an organisation. This progressive Excel learning experience will teach you how to download and manipulate complex data patterns and any collection of figures or statistics. You will become intuitively aware of how to arrange this for visual and investigative purposes. The coaching delivers a masterclass for core competencies that will take you from being a regular analyst to a sought-after Excel expert in all forms of data presentations. Make your mark in Microsoft skills and take your office abilities to the next level. This best selling Advanced Excel Analytics by Real World Projects has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Advanced Excel Analytics by Real World Projects is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Advanced Excel Analytics by Real World Projects is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Advanced Excel Analytics by Real World Projects is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Advanced Excel Analytics by Real World Projects, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Advanced Excel Analytics by Real World Projects will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Advanced Excel Analytics by Real World Projects to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

24 Hours Left! Don't Let Winter Sale Slip Away - Enrol Now! With over 100,000 civil engineers in the UK, the demand for data-savvy professionals is high. According to a recent study, 72% of UK civil engineering firms are investing in data analytics to enhance decision-making processes, with data engineering experiencing a 40% year-on-year growth. This surge outpaces other tech sectors, highlighting the critical role of data engineers in big data and advanced analytics. This Data Engineering bundle empowers you to capitalise on this growing trend, equipping you with the proficiency to extract valuable insights from vast datasets, optimise project planning, and enhance overall efficiency. Embark on a transformative journey with our Data Engineering Bundle, thoroughly crafted to bridge the skill gap in one of the UK's fastest-growing job markets. Our bundle offers a comprehensive exploration into the world of data, equipping you with the analytical prowess to harness, process, and visualise data effectively. From mastering SQL programming to delving into the complexities of machine learning with R, this bundle is your gateway to becoming a data engineering maestro. In today's data-driven landscape, possessing a robust set of analytical skills is no longer a luxury but a necessity. With an emphasis on Data engineering, our courses are designed to foster a deep understanding of data analytics, visualisation, and mining, ensuring you can convert raw data into strategic insights that propel business decisions. Seize the opportunity to be at the helm of innovation and become the architect of tomorrow's data landscape with our Data Engineering Bundle. Join us now! Courses are Included in This Data Engineering Bundle: Course 01: Introduction to Data Analysis Course 02: Data Science & Machine Learning with R Course 03: Data Analytics with Tableau Course 04: SQL Programming Masterclass Course 05: Excel Pivot table for Data analytics Course 06: Data analytics with Excel Course 07: Python for Data Analysis Course 08: Basic Google Data Studio Course 09: Business Intelligence and Data Mining Masterclass Course 10: Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query Course 11: JavaScript Functions for Data Analyst Course 12: GDPR Data Protection Level 5 Course 13: GDPR Training Course 14: Learn Programming with Python Course 15: Data Center Training Essentials: General Introduction Course 16: Quick Data Science Approach from Scratch Course 17: Statistics & Probability for Data Science & Machine Learning Course 18: Master JavaScript with Data Visualization Course 19: Excel Data Tools and Data Management Course 20: Cloud Computing Essentials for Data Analysis Learning Outcomes of Data Engineering Bundle: Gain proficiency in SQL for complex database management and analytics tasks. Master R for data science and machine learning applications in various industries. Develop advanced Excel skills, including data analytics and pivot table expertise. Acquire hands-on experience with Tableau for effective data visualisation. Learn Python programming essentials for data analysis and engineering solutions. Understand Google Data Studio to create dynamic reports and dashboards. Why Choose Our Data Engineering Course? FREE Data Engineering certificate accredited Get a free student ID card with Data Engineering Training Get instant access to this Data Engineering course. Learn Data Engineering from anywhere in the world The Data Engineering is affordable and simple to understand The Data Engineering is an entirely online, interactive lesson with voiceover audio Lifetime access to the Data Engineering course materials The Data Engineering comes with 24/7 tutor support Start your learning journey straightaway with our Data Engineering Bundle! This Data Engineering bundle will equip you with the skills and knowledge to become a data-savvy civil engineer. You will learn how to collect, analyze, and interpret data to improve infrastructure projects and processes. This Data Engineering bundle includes courses on data analysis, data science, machine learning, SQL programming, Excel pivot tables, Excel data analytics, Python for data analysis, Google Data Studio, business intelligence, data mining, GDPR data protection, JavaScript functions for data analysts, and Python programming. Assessment Process of Data Engineering Once you have completed all the courses in the Data Engineering bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterwards. CPD 200 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Data Engineering bundle is suitable for everyone. Also, our Data Engineering Bundle is perfect for: Aspiring data engineers Business intelligence analysts Data-driven marketers IT professionals Statistics enthusiasts Career changers Requirements You will not need any prior background or expertise in the Data Engineering Bundle. Career path This Data Engineering bundle will allow you to kickstart or take your career to the next stage in the related sector such as: Data Analyst BI Developer ML Engineer Data Scientist Database Administrator Data Strategist Certificates CPD Accredited Digital Certificate Digital certificate - Included CPD Accredited Hard Copy Certificate Hard copy certificate - Included If you are an international student, then you have to pay an additional 10 GBP for each certificate as an international delivery charge.

Overview For the definitive and certified training in Human Resources, take this training and drive your company to its full potential. This comprehensive course offers an in-depth overview of all the factors and practices that control and influence HR in an organisation. The HR Practice Essentials Level 4 course delivers a masterclass in HR principles and will swiftly enable you to become a skilled practitioner in the area. You will be taught how to capture and analyse essential performance statistics. Additionally, you will learn how to support change, recruit staff, reward employees, manage business relations, organise training, and all the other duties that an HR manager will uphold. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is this course for? There is no experience or previous qualifications required for enrolment on this HR Practice Essentials Level 4. It is available to all students, of all academic backgrounds. Requirements Our HR Practice Essentials Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management , Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 14 sections • 14 lectures • 04:21:00 total length •Module 01: Introduction to Human Resource: 00:17:00 •Module 2: Employee Recruitment and Selection Procedure: 00:32:00 •Module 3: Skills of an Effective Administrator: 00:17:00 •Module 4: Employee Training and Development Process: 00:22:00 •Module 5: Performance Appraisal Management: 00:19:00 •Module 6: Employee Relations: 00:14:00 •Module 7: Motivation and Counselling: 00:19:00 •Module 8: Ensuring Health and safety at the Workplace: 00:17:00 •Module 9: Employee Termination: 00:15:00 •Module 10: Business Etiquette: 00:21:00 •Module 11: Employer Record and Statistics: 00:11:00 •Module 12: Business Telephone Skills: 00:21:00 •Module 13: Representing Your Boss and Company: 00:36:00 •Assignment - HR Practice Essentials Level 4: 00:00:00