2538 Courses in Cardiff delivered Live Online

Type of Education: %100 Online Duration: 24 Months IELTS Requirement: IELTS is not required

Duration 3.5 Days 21 CPD hours This course is intended for This course is for AWS Cloud Architects with expertise in designing and implementing solutions running on AWS who now want to design for Microsoft Azure. Overview After completing this course, students will be able to: Secure identities with Azure Active Directory and users and groups. Implement identity solutions spanning on-premises and cloud-based capabilities Apply monitoring solutions for collecting, combining, and analyzing data from different sources. Manage subscriptions, accounts, Azure policies, and Role-Based Access Control. Administer Azure using the Resource Manager, Azure portal, Cloud Shell, and CLI. Configure intersite connectivity solutions like VNet Peering, and virtual network gateways. Administer Azure App Service, Azure Container Instances, and Kubernetes. This course teaches Solutions Architects who have previously designed for Amazon Web Services how to translate business requirements into secure, scalable, and reliable solutions for Azure. Introduction to Azure Subscriptions and accounts Resource groups and templates in Azure Resource Manager Azure global infrastructure Azure regions Azure Availability Zones Comparison with AWS Implement Azure Active Directory Introduction to Azure Active Directory Domains and custom domains Safety features Guest users in Azure Active Directory Manage multiple directories Comparison with AWS Implement and manage hybrid identities Introduction to Azure AD Connect Comparison with AWS Implement virtual networking Azure Virtual Network and VNet peering VPN and ExpressRoute connections Comparison with AWS Implement VMs for Windows and Linux Configure high availability Comparison with AWS Implement load balancing and network security Implement Azure Load Balancer Implement an Azure Application Gateway Implement Azure Firewall Implement network security groups and application security groups Comparison with AWS Implement container-based applications Configure Azure Kubernetes Service Publish a solution on an Azure Container Instance Comparison with AWS Implement an application infrastructure Create an App Service plan Create and configure Azure App Service Configure networking for an App Service Introduction to Logic Apps and Azure Functions Comparison with AWS Implement storage accounts Azure Storage core concepts Managing the Azure Blob storage lifecycle Working with Azure Blob storage Comparison with AWS Implement NoSQL databases Introduction to Azure Cosmos DB Consistency Select appropriate CosmosDB APIs Set up replicas in CosmosDB Comparison with AWS DynamoDB Implement Azure SQL databases Configure Azure SQL database settings Implement Azure SQL Database managed instances Configure high availability for an Azure SQL database Comparison with AWS Implement cloud infrastructure monitoring Monitor security Monitor cost Configure a Log Analytics workspace Comparison with AWS Implement and manage Azure governance solutions Assign RBAC roles Configure management access to Azure Implement and configure an Azure Policy Comparison with AWS Manage security for applications Implement Azure Key Vault Implement and configure Azure AD Managed Identities Register and manage applications in Azure AD Comparison with AWS Migration, backup, and disaster recovery management Migrate workloads Implement Azure Backup for VMs Implement disaster recovery Comparison with AWS

Duration 5 Days 30 CPD hours This course is intended for Experienced system administrators, system integrators, and consultants responsible for implementing and managing VMware Cloud Foundation Overview By the end of the course, you should be able to meet the following objectives: Describe design implications of VMware Cloud Foundation standard or consolidated architecture List requirements for VMware Cloud Foundation deployment Describe the VMware Cloud Foundation bring-up process and the VMware Cloud Foundation architecture Perform VMware Cloud Foundation bring-up Describe physical and virtual networking considerations Outline VMware Cloud Foundation storage options Use the VMware Imaging Appliance to image ESXi hosts Describe VMware Cloud Foundation multi-instance federation Use VMware Cloud Foundation™ SDDC Manager™ to perform operational tasks Describe user roles in VMware Cloud Foundation and VMware vSphere Manage users and passwords using VMware Cloud Foundation Manage certificate rotation for VMware Cloud Foundation components Use Active Directory integration to automate certificate generation and rotation Describe workload domains Manage workload domains in VMware Cloud Foundation Manage VMware NSX-T™ for VMware Cloud Foundation Describe use cases for Application Virtual Networks (AVNs) Meet vSphere with VMware Tanzu™ requirements Deploy a vSphere with Tanzu enabled workload domain Manage VMware vSAN™ storage in a workload domain Create vSAN storage policies Describe Cloud Native storage Describe the importance of business continuity measures in VMware Cloud Foundation Plan appropriate backup and restore workflows for VMware Cloud Foundation components Implement stretched clusters in VMware Cloud Foundation workload domains This five-day course includes instruction on the capabilities of VMware Cloud Foundation? and how to successfully plan, deploy, manage, and operate hybrid and cloud infrastructures, including customization. The course explains the architecture of VMware Cloud Foundation and explains licensing, certificates, and storage and network management. The course also covers workload domains, availability, life cycle management, and troubleshooting. Course Introduction Introductions and course logistics Course objectives VMware Cloud Foundation Overview Describe the VMware Cloud Foundation solution Describe VMware Cloud Foundation architecture Identify VMware Cloud Foundation components Describe VMware Cloud Foundation topology Define VMware Cloud Foundation terminology Day Zero Tasks Identify the requirements for deploying VMware Cloud Foundation Identify management domain sizing considerations Identify workload domain sizing considerations Detail design considerations for ESXi in management and VI workload domains Detail design considerations for vCenter in management and VI workload domains Detail the VMware Cloud Foundation bring-up process Identify information required for the Planning and Preparation Workbook Identify information required for the Deployment Parameter Workbook Describe how VMware Cloud Builder automates the deployment process Explain how the Deployment Parameter Workbook is imported into VMware Cloud Builder Recognize the configuration validation process performed by VMware Cloud Builder Detail the deployment of the management domain Recognize the options to image a host Identify the key capabilities of VIA Recognize how to use VIA for imaging the ESXi Nodes Post Deployment Operations Understand VMware Cloud Foundation integration with VMware Single Sign-On Configure user access to VMware Cloud Foundation Describe the importance of user roles in vSphere Configure identity sources in vSphere to use with VMware Cloud Foundation Manage passwords in VMware Cloud Foundation Explain the importance of using VMware Cloud Foundation to manage passwords for vSphere components Detail the best practices for password management for VMware Cloud Foundation Retrieve and secure the password list Describe the process for rotating passwords not managed by VMware Cloud Foundation VMware Cloud Foundation License Management Describe how to add license keys to the VMware Cloud Foundation inventory Describe how to view license keys in SDDC Manager Describe how to assign license keys Describe how to remove license keys Describe how to replace expiring licenses VMware Cloud Foundation Networking with NSX-T Describe NSX Management plane and Control planes Detail design considerations for workload domains with shared NSX Manager instances Detail design considerations for workload domains with dedicated NSX Manager instances Describe the spine-and-leaf design Describe the addressing scheme for the underlay Recognize possible variations of the spine-and-leaf design Describe the multi-NIC design Describe NSX Edge node design and BGP peering with the physical network Describe cluster design and rack design Explain dynamic routing with BGP Explain virtual IP addressing Describe logical switching Detail NSX Edge functions Define application virtual networks Describe management domain rack options List NSX Edge cluster requirements for vSphere with Tanzu Discuss NSX Edge cluster placement considerations Describe NSX-T Data Center deployment in VMware Cloud Foundation Explain how logical routing works in NSX-T Data Center Identify NSX Edge functions Describe data plane preparation for NSX-T Data Center Edge nodes in a workload domain Recognize Tier-0 and Tier-1 gateway topologies Recognize features of NSX distributed firewalls Describe the benefits of NSX Federation in VMware Cloud Foundation Identify NSX Federation Use Cases Explain NSX Federation Components and Architecture Discuss NSX Federation configuration basics Managing Workload Domains Define workload domains Detail design considerations for vSphere networking in management and VI workload domains Detail design considerations for storage in management and VI workload domains Recognize design choices for a consolidated design or standard design List the types of workload domains State scale limits for workload domains Identify use cases for multiple clusters in a workload domain List workload domain prerequisites Explain how to create a workload domain Describe how to scale a workload domain Explain how to delete a workload domain Describe host decommissioning vSphere with Tanzu in VMware Could Foundation Discuss the vSphere with Tanzu solution Define the role of Spherelet Describe the supervisor cluster control plane Define vSphere with Tanzu namespaces Describe the role of NSX-T networking components Discuss vSphere with Tanzu networking topology Describe VMware Container Networking with Antrea Describe control plane VM management networking requirements Plan appropriate IP address CIDR ranges for pod, ingress, and egress networking Describe prerequisites for vSphere with Tanzu cluster compatibility Deploy vSphere with Kubernetes Create a vSphere namespace Configure limits and permissions for a vSphere namespace Enabling Harbor Image Registry VMware Cloud Foundation Storage Management Identify vSAN architecture and components Recognize storage options for VMware Cloud Foundation Recognize the connectivity options for supplemental storage Explain why vSAN is the best option for VMware Cloud Foundation storage Recognize vSAN design considerations Identify sizing and performance considerations that impact the storage design Describe vSAN requirements for the management and workload domains Define deduplication and compression Discuss how to scale vSAN clusters in VMware Cloud Foundation Explain how storage policies work with VMware Cloud Foundation vSAN clusters Explain storage policy failure tolerance rules Identify a VM storage policy compliance status Relate storage policies to Kubernetes storage classes Describe persistent volumes Monitor Cloud Native Storage in the vSphere Client Availability and Business Continuity Identify steps in the SDDC Manager backup and restore process Recognize the importance of external service availability Describe native vSphere availability options Identify steps in the NSX backup and restore process Identify stretched cluster use cases Identify stretched cluster components Recognize stretched cluster requirements in VMware Cloud Foundation Prepare and deploy a vSAN stretched cluster using APIs VMware Cloud Foundation Certificate Management Describe public key infrastructure (PKI) Explain the purpose of certificate signing requests (CSRs) List the available CA options in SDDC Manager Describe how to view certificates Explain how to generate a CSR Describe how to replace and install certificates for VMware Cloud Foundation components List the available CA options in SDDC Manager Explain how to configure the Microsoft CA server Describe how to install certificates issued by the Microsoft CA server Explain how to add OpenSSL CA in SDDC Manager Describe how to install certificates issued by OpenSSL CA Explain how to install certificates issued by third-party CAs

An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. An M&A specialist is a senior CFO with a proven track record of overseeing and implementing mergers and acquisitions. They may be hired on a full-time basis and carry a full CFO workload or can be recruited on a part-time or interim basis to focus on a specific merger or acquisition. This flexibility is ideal for start-ups and SMEs who don’t have the budget to recruit a full external team to oversee an M&A or to hire a full-time CFO. The CFO is a link between both companies engaged in the M&A, acting as the eyes and ears for both the board and CEO. Their financial skills enable them to identify potential M&A opportunities and incorporate risk management into their strategy to get the most value out of their deal. Most companies evolve their approach to mergers and acquisitions organically, especially those who rely on an M&A specialist instead of having a dedicated team that works solely on M&A. The CFO is responsible for considering any potential acquisitions, crunching the numbers involved, and ensuring due diligence. They’ll be responsible for determining the value of a potential M&A and presenting it to the company’s board and leadership team to determine whether to make the purchase. An M&A specialist is responsible for gathering the data – including both positive and negative factors – to present an objective look at the other organisation and the potential value the acquisition could bring. CFOs will spend most of their time getting to grips with the numbers involved, long before presenting the M&A proposal to the board. This exercise also requires them to have real-time insight into their own company’s performance, value, and finances to paint a wider picture. An M&A specialist will take the critical steps of ensuring that the numbers presented to them are correct. CFOs who don’t specialise in M&As will still have the skill set required to oversee the process but may lack the efficiency and unique insight of an M&A specialist. Companies that are exploring the option of a merger or being acquired by another company may also decide to recruit an M&A specialist to prepare their accounting. The organisation will want to ensure they present the correct numbers to get the correct valuation and prevent any delays further in the process if incorrect numbers pop up. Getting on top of the data early can enable CFOs to plan accordingly. Most will want to provide extra time within their strategy for any potential hiccups along the way. Spending more time on the data early on can speed up the process while still ensuring due diligence is met. Visit our website to learn more https://www.fdcapital.co.uk/mergers-and-acquistions-specialist/ Tags Online Events Things To Do Online Online Networking Online Business Networking #finance #insights #cfo #mergers #acquisitions

With the ongoing impact post pandemic and the shift to more remote working longer term, managing the mental health and well-being of our lawyers has become more important than ever. We know that as a HR professional / Head of People, you play a crucial role in ensuring the mental health and well-being of your firm. Often juggling this alongside many other responsibilities and demands on your time. A Head of People recently commented on what a lonely role this can be and we want to offer some support. That's why we're excited to invite you to our upcoming webinar on managing mental health and well-being in your firm. Webinar host, lawyer, coach and trainer specialising in lawyer wellbeing for the last 7 years, will offer valuable insights and practical tips on how you can support your lawyers' mental health during increasingly challenging times.

Overview In an era of constant learning and upskilling, the demand for efficient trainers is soaring. If you're passionate about sharing your knowledge and inspiring others to achieve their potential, then our Train the Trainer Level 5 QLS Endorsed Diploma course is tailor-made for you. Whether you're a professional trainer, manager, educator, or someone with a wealth of knowledge you wish to impart, becoming an effective trainer is both a rewarding journey and a valued skill. It’s not just about conveying information, it's about motivating, engaging and making a lasting impact on your learners. You’ll delve into the science of learning, discover how to train, and master the art of delivery and feedback with our Train the Trainer Masterclass Diploma. We believe that a great trainer is also a great storyteller, and we provide you with the tools to create compelling narratives that truly resonate with your audience. Perhaps you are a trainer seeking more knowledge in your field, or you aspire to be one. If so, don't waste any more time and have a look at our Train the Trainer course to get the best training from Nextgen Learning. Train the Trainer course is the opportunity to kickstart your exciting career and solidify your comprehensive knowledge. The best way for you to learn the subject thoroughly is through this Train the Trainer course. This Train the Trainer Level 5 QLS Endorsed Diploma course holds a prestigious CPD accreditation & QLS endorsement, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Train the Trainer course promises not just education but an evolving learning experience. Engage with this extraordinary Train the Trainer curriculum, and prepare to enrich your personal and professional development. So, if you are eager to see yourself in a gratifying career, then enrol in our Train the Trainer course today! What will make you stand out? On completion of this online Train the Trainer Level 5 QLS Endorsed Diploma course, you will gain: CPD QS Accredited After completing the Course, you will get the opportunity to order Accredited Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Train the Trainer course at your own pace. Study for the Train the Trainer Diploma course using any internet-connected device, such as a computer, tablet, or mobile device. ***ADDITIONAL GIFT*** Free Course: Leadership & Management Diploma - CPD Accredited Train the Trainer Course Curriculum : Module 01: Introduction and Welcome to Train the Trainer course Module 02: Make Them Feel Safe Before Class Module 03: Start with An Amazing Opener Module 04: Build Credibility and Rapport Qui Module 05: Workbook Assignment (Optional) - Train the Trainer Description The substantial Train the Trainer Diploma course is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this Train the Trainer Diploma course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Train the Trainer and explore the key topics. Therefore, reinforce your knowledge and furnish your skills by enrolling in our Train the Trainer course. Take one step closer to achieving your goal. Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the course, you will be eligible to order QLS Endorsed Hardcopy Certificate titled ‘Diploma in Train the Trainer at QLS Level 5’. £109 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Who is this course for? Is This Train the Trainer Course the Right Option for You? This Train the Trainer course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this Train the Trainer course. Career path This Train the Trainer Level 5 QLS Endorsed Diploma course aims to assist you in achieving your career goals. Including the potential careers: Corporate Trainer Training Manager Personal Coach Public Speaker Online Course Instructor Learning and Development Consultant Instructional Designer

Overview In an era of constant learning and upskilling, the demand for efficient trainers is soaring. If you're passionate about sharing your knowledge and inspiring others to achieve their potential, then our Train the Trainer Level 5 QLS Endorsed Diploma course is tailor-made for you. Whether you're a professional trainer, manager, educator, or someone with a wealth of knowledge you wish to impart, becoming an effective trainer is both a rewarding journey and a valued skill. It’s not just about conveying information, it's about motivating, engaging and making a lasting impact on your learners. You’ll delve into the science of learning, discover how to train, and master the art of delivery and feedback with our Train the Trainer Masterclass Diploma. We believe that a great trainer is also a great storyteller, and we provide you with the tools to create compelling narratives that truly resonate with your audience. Perhaps you are a trainer seeking more knowledge in your field, or you aspire to be one. If so, don't waste any more time and have a look at our Train the Trainer course to get the best training from Nextgen Learning. Train the Trainer course is the opportunity to kickstart your exciting career and solidify your comprehensive knowledge. The best way for you to learn the subject thoroughly is through this Train the Trainer course. This Train the Trainer Level 5 QLS Endorsed Diploma course holds a prestigious CPD accreditation & QLS endorsement, symbolising exceptional quality. The materials, brimming with knowledge, are regularly updated, ensuring their relevance. This Train the Trainer course promises not just education but an evolving learning experience. Engage with this extraordinary Train the Trainer curriculum, and prepare to enrich your personal and professional development. So, if you are eager to see yourself in a gratifying career, then enrol in our Train the Trainer course today! What will make you stand out? On completion of this online Train the Trainer Level 5 QLS Endorsed Diploma course, you will gain: CPD QS Accredited After completing the Course, you will get the opportunity to order Accredited Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials. The online test with immediate results You can study and complete the Train the Trainer course at your own pace. Study for the Train the Trainer Diploma course using any internet-connected device, such as a computer, tablet, or mobile device. ***ADDITIONAL GIFT*** Free Course: Leadership & Management Diploma - CPD Accredited Train the Trainer Course Curriculum : Module 01: Introduction and Welcome to Train the Trainer course Module 02: Make Them Feel Safe Before Class Module 03: Start with An Amazing Opener Module 04: Build Credibility and Rapport Qui Module 05: Workbook Assignment (Optional) - Train the Trainer Description The substantial Train the Trainer Diploma course is designed to help you demonstrate the preliminary to in-depth level of learning regarding this topic. Moreover, you will be provided with the most knowledgeable and informative modules for your lifetime by enrolling in this Train the Trainer Diploma course just once. Furthermore, as you proceed through the modules of this course, you will discover the fundamentals of Train the Trainer and explore the key topics. Therefore, reinforce your knowledge and furnish your skills by enrolling in our Train the Trainer course. Take one step closer to achieving your goal. Quality Licence Scheme Endorsed Certificate of Achievement: Upon successful completion of the course, you will be eligible to order QLS Endorsed Hardcopy Certificate titled ‘Diploma in Train the Trainer at QLS Level 5’. £109 GBP for addresses within the UK. Please note that delivery within the UK is free of charge. Please Note: NextGen Learning is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Who is this course for? Is This Train the Trainer Course the Right Option for You? This Train the Trainer course is recommended for anyone who is interested in learning more about this topic. You'll learn the fundamental ideas and gain a comprehensive understanding of the topic by taking this Train the Trainer course. Career path This Train the Trainer Level 5 QLS Endorsed Diploma course aims to assist you in achieving your career goals. Including the potential careers: Corporate Trainer Training Manager Personal Coach Public Speaker Online Course Instructor Learning and Development Consultant Instructional Designer

Sage Payroll Training Course - Fast Track This course brings you the skills you need to use this popular payroll program to confidently process any businesses payroll. Being able to use Sage 50 Payroll should lead to greater productivity. But it also helps the business conform to employment legislation and data security requirements. Furthermore, broken down into practical modules this course is a very popular and well received introduction to moving from manual payroll to computerised payroll. Moreover, it incorporates all the new government requirements for RTI reporting. Finally, Payroll is a vital role within any organisation. A career in payroll means specialising in a niche field with excellent progression opportunities. You will receive a CPD Completion certificate from Osborne Training once you finish the course. What skills will I gain? In this course you will be learning from Level 1 to Level 3 of Sage Computerised Payroll which could help you to land on your dream job in Payroll sector. Level 1 Introduction to payroll Introduction to Real Time Information (RTI) Preparing employee records Starters - new employees Calculation of Gross Pay The PAYE and National Insurance systems Creating Payslips and analysis Creating Backups and Restoring data Payment analysis Processing National Insurance contributions Voluntary deductions Processing Leavers Completing the payroll Procedures Level 2 Introduction to Payroll Introduction to Real Time Information (RTI) Preparing employee records Creating Backup and Restoring Data Starters - new employees Calculation of Gross Pay Deductions - Pension schemes and pension contributions Processing the payroll - introduction to the PAYE system Processing the payroll - income tax National Insurance contributions - Processing in the payroll Voluntary deductions Student Loan repayments Attachment of Earnings Orders & Deductions from Earnings Orders Processing Leavers Introduction to statutory additions and deductions Processing Statutory sick pay (SSP) Processing Statutory Paternity Pay (SPP) Statutory paternity pay and paternity leave Completing the processing of the payroll Creating Payslips and analysis Reports and payments due to HMRC Level 3 Advanced processing of the payroll for employees Preparation and use of period end preparation of internal reports Maintaining accuracy, security and data integrity in performing payroll tasks. Deductions - Pension schemes and pension contributions Processing the payroll -complex income tax issues Payroll Giving Scheme processing Processing Statutory Adoption Pay (SAP) Advanced Income tax implications for company pension schemes Student Loan repayments Processing Holiday Payments Processing Car Benefit on to the Payroll System Attachment of Earnings Orders & Deductions from Earnings Orders Leavers with complex issues Advanced processing of statutory additions and deductions Recovery of statutory additions payments - from HMRC Completing the processing of the payroll Complex Reports and payments due to HMRC Cost Centre Analysis Advanced, routine and complex payroll tasks Calculation of complex gross pay

Duration 5 Days 30 CPD hours This course is intended for This course is designed for students who want to learn the R programming language, particularly students who want to leverage R for data analysis and data science tasks in their organization. The course is also designed for students with an interest in applying statistics to real-world problems. A typical student in this course should have several years of experience with computing technology, along with a proficiency in at least one other programming language. Overview In this course, you will use R to perform common data science tasks.You will: Set up an R development environment and execute simple code. Perform operations on atomic data types in R, including characters, numbers, and logicals. Perform operations on data structures in R, including vectors, lists, and data frames. Write conditional statements and loops. Structure code for reuse with functions and packages. Manage data by loading and saving datasets, manipulating data frames, and more. Analyze data through exploratory analysis, statistical analysis, and more. Create and format data visualizations using base R and ggplot2. Create simple statistical models from data. In our data-driven world, organizations need the right tools to extract valuable insights from that data. The R programming language is one of the tools at the forefront of data science. Its robust set of packages and statistical functions makes it a powerful choice for analyzing data, manipulating data, performing statistical tests on data, and creating predictive models from data. Likewise, R is notable for its strong data visualization tools, enabling you to create high-quality graphs and plots that are incredibly customizable. This course will teach you the fundamentals of programming in R to get you started. It will also teach you how to use R to perform common data science tasks and achieve data-driven results for the business. Lesson 1: Setting Up R and Executing Simple Code Topic A: Set Up the R Development Environment Topic B: Write R Statements Lesson 2: Processing Atomic Data Types Topic A: Process Characters Topic B: Process Numbers Topic C: Process Logicals Lesson 3: Processing Data Structures Topic A: Process Vectors Topic B: Process Factors Topic C: Process Data Frames Topic D: Subset Data Structures Lesson 4: Writing Conditional Statements and Loops Topic A: Write Conditional Statements Topic B: Write Loops Lesson 5: Structuring Code for Reuse Topic A: Define and Call Functions Topic B: Apply Loop Functions Topic C: Manage R Packages Lesson 6: Managing Data in R Topic A: Load Data Topic B: Save Data Topic C: Manipulate Data Frames Using Base R Topic D: Manipulate Data Frames Using dplyr Topic E: Handle Dates and Times Lesson 7: Analyzing Data in R Topic A: Examine Data Topic B: Explore the Underlying Distribution of Data Topic C: Identify Missing Values Lesson 8: Visualizing Data in R Topic A: Plot Data Using Base R Functions Topic B: Plot Data Using ggplot2 Topic C: Format Plots in ggplot2 Topic D: Create Combination Plots Lesson 9: Modeling Data in R Topic A: Create Statistical Models in R Topic B: Create Machine Learning Models in R

Duration 3 Days 18 CPD hours This course is intended for This course is appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands-on learning environment led by our expert pracitioner you'll learn how to: Add Data, Retrieve, Sort and Organize a SQL Database Combine Data, Set Operators and Subqueries Manipulate Data and Data Definition Languages in SQL Work with Data Dictionary Views and Create Sequences, Indexes and Views Use Database Objects and Subqueries Perform Data and access control Perform other Advanced Level Database operations. Oracle 19C SQL Programming Fundamentals Is a three-day, hands-on course designed to equip you with the fundamental skills needed to set up, run and manage SQL databases using Oracle Database Technology. You will also be discovering all the tools and concepts required to organize data efficiently. Our engaging instructors and mentors are highly-experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course, you will learn the key elements of a database, and the way Oracle systems facilitate their induction in the system. You?ll also learn the tools and strategies you can implement to store, retrieve, compare and organize data according to your requirements. You?ll also explore the process of creating simple to complex reports from existing data. By the end of this course, you will also have hands-on knowledge of SQL systems that are required to proceed to other advanced to professional programs. Adding Data, Retrieving, Sorting and Organizing a SQL Database The building blocks of a database. How to add data to the database. The process of retrieving data using SQL functions. Multiple methods of sorting and organizing data. Using SQL functions to get the required simple to complex output. Various strategies for using functions and conditions to organize data. Combining Data, Set Operators And Subqueries Consolidating data using multiple functions and group operators. Fetching intelligent data reports using simple functions. Fetching data from multiple sources in the tables. Using Subqueries to compile data as required. Using Set operators to create smart data reports. Data Manipulation and Data Definition Languages in SQL Describing and managing data transaction using Data Definition Language. Categorize and review data tables using Data Definition Language. Data Dictionary Views and Creating Sequences, Indexes and Views How to manage and query Data Dictionary Views. The process of creating and using Sequences. How to create various types of Synonyms and Indexes. Creating simple and complex views and retrieving data. Understanding and using Database Objects and Subqueries Core concept and application of Schema Objects. Fetching required data with Subqueries. Using Subqueries to organize Data in SQL. Data and access control Assigning and revoking data access. Managing data access control according to user levels. Performing Advanced Level Database operations. Using advanced functions and performing data queries. Creating and managing time zone-based databases.