38836 Courses in Cardiff delivered Online

Duration 2 Days 12 CPD hours This course is intended for Security administrators who are responsible for using SaltStack SecOps to manage the security operations in their enterprise Overview By the end of the course, you should be able to meet the following objectives: Describe the architecture of SaltStack Config and SaltStack SecOps Integrate SaltStack Config with directory services. Configure roles and permissions for users and groups to manage and use SaltStack SecOps Use targeting to ensure that the jobs run on the correct minion systems Use remote execution modules to install the packages, transfer files, manage services, and manage users on minion systems Manage configuration control on the minion systems with states, pillars, requisites, and declarations Use Jinja and YAML code to manage the minion systems with the state files Enforce the desired state across minion systems automatically Use SaltStack SecOps to update the compliance and vulnerability content libraries Use SaltStack SecOps to enforce compliance and remediation on the infrastructure with industry standards Use SaltStack SecOps to provide automated vulnerability scanning and remediation on your infrastructure This two-day, hands-on training course provides you with the advanced knowledge, skills, and tools to achieve competency in using VMware vRealize© Automation SaltStack© SecOps. SaltStack SecOps allows you to scan your system for compliance against security benchmarks, detect system vulnerabilities, and remediate your results. This course enables you to create the SaltStack SecOps custom compliance libraries and use SaltStack SecOps. In addition, this course provides you with the fundamentals of how to use VMware vRealize© Automation SaltStack© Config to install software and manage system configurations. Course Introduction Introductions and course logistics Course objectives SaltStack Config Architecture Identify the SaltStack Config deployment types Identify the components of SaltStack Config Describe the role of each SaltStack Config component SaltStack Config Security Describe local user authentication Describe LDAP and Active Directory authentication Describe the roles and permissions in vRealize Automation for SaltStack Config Describe the roles and permissions in SaltStack Config Describe the SecOps permissions in SaltStack Config Describe the advanced permissions available in SaltStack Config Targeting Minions Describe targeting and its importance Target minions by minion ID Target minions by glob Target minions by regular expressions Target minions by lists Target minions by compound matching Target minions by complex logical matching Remote Execution and Job Management Describe remote execution and its importance Describe functions and arguments Create and manage jobs Use the Activities dashboard Configuration Control Through States, Pillars, Requisites, and Declarations Define the SaltStack states Describe file management in SaltStack Config Create the SaltStack state files Identify the components of a SaltStack state Describe pillar data and the uses of pillar data Configure pillar data on the SaltStack Config master server Use pillar data in variables in the state files Describe the difference between IDs and names in the state files Use the correct execution order Use requisites in the state files Using Jinja and YAML Describe the SaltStack Config renderer system Use YAML in the state files Use Jinja in the state files Use Jinja conditionals, lists, and loops Using SaltStack SecOps Comply Describe the SaltStack SecOps Comply architecture Describe CIS and DISA STIG benchmarks Describe the SaltStack SecOps Comply security library Describe the remediation differences between SaltStack SecOps and VMware Carbon Black© Create and manage the policies Create and manage the custom checks Run assessments on the minion systems Use SaltStack SecOps to remediate the noncompliant systems Manage the SaltStack SecOps Comply configuration options Manage the benchmark content ingestion Using SaltStack SecOps Protect Describe Common Vulnerabilities and Exposures (CVEs) Use the Protect dashboard Create and manage the policies Update the vulnerability library Run the vulnerability scans Remediate the vulnerabilities Manage the vulnerability exemptions

Music Audio Stories presents Can You Spell It? Free Video Series ▫️Fun videos to help your child learn to pronounce and spell colours and develop visual and reading skills. We are thrilled to introduce our video series called, Can You Spell It? Children will learn how to pronounce and spell each colour and enjoy seeing our flower characters. With illustrations, voice-overs, animations, and music, this video series will help to teach children to spell in a fun and easy way. Children will: ▪️See examples of each colour ▪️Learn how to spell each colour ▪️Hear how each colour is pronounced ▪️Gain better reading skills ▪️Improve concentration and visual skills ▪️Love the illustrated flower characters ▪️Enjoy sound effects and music ⏰ Videos are released on Saturdays at 11 am on YouTube. Subscribe on YouTube at: https://www.youtube.com/user/MusicAudioStories and hit the bell to make sure you don't miss a new video. Video Series Playlist: https://shorturl.at/IDVL5 Find out why it's important to develop colour recognition here: https://musicaudiostories.com/blog/can-you-spell-it Enjoy! ♥ Music Audio Stories - Making learning easy and fun! Music Audio Stories is an original company specialising in entertaining music audiobooks, picture books, interactive activities, fun videos, and unique storytelling with multi-award-winner, 'Storytime with Anna Christina'. Music Audio Stories are interactive audiobooks with full orchestral scores and magical soundtracks, catchy sing-along songs and fun stories that teach and uplift little listeners. Videos include uniquely entertaining Storytimes with music, sound effects, narration, voice-overs, illustrations, and animations. Plus delightful activity videos for listening, learning, reading, drawing, and lots of fun! ---------- Website: http://www.musicaudiostories.com/ Storytime: http://storytimewithannachristina.com/ ---------- Subscribe to get a free music audiobook at: http://www.musicaudiostories.com/#subscribe ---------- Twitter: https://twitter.com/musicaudiostory Instagram: https://www.instagram.com/musicaudiostories/ Facebook: https://www.facebook.com/musicaudiostories/ Storytime with Anna Christina Instagram: https://www.instagram.com/storytimewithannachristina/

Music Audio Stories presents Can You Count It? Free Video Series ▫️ Fun videos to help your child learn numbers 1 to 10, and develop visual and spelling skills. We are thrilled to introduce our video series called, Can You Count It? Children will learn numbers 1 to 10, see how to spell and pronounce each number, and enjoy counting to 10 with fun illustrations and numbers. With illustrations, voice-overs, animations, and music, this video series will help to teach children to count in a fun and easy way. Children will: ▪️See examples of each number ▪️Hear how each number is pronounced ▪️Learn how to spell each number ▪️Have fun counting the numbers ▪️Improve concentration and visual skills ▪️Love the fun illustrations and characters ▪️Enjoy sound effects and music ⏰ Videos are released on Saturdays at 11 am on YouTube. Subscribe to our channel here: https://www.youtube.com/user/MusicAudioStories and hit the bell to make sure you don't miss a new video. Video Series Playlist: https://shorturl.at/xlNdy Find out why it's important to develop colour recognition here: https://musicaudiostories.com/blog/can-you-count-it Enjoy! ♥ Music Audio Stories - Making learning easy and fun! Music Audio Stories is an original company specialising in entertaining music audiobooks, picture books, interactive activities, fun videos, and unique storytelling with multi-award-winner, 'Storytime with Anna Christina'. Music Audio Stories are interactive audiobooks with full orchestral scores and magical soundtracks, catchy sing-along songs and fun stories that teach and uplift little listeners. Videos include uniquely entertaining Storytimes with music, sound effects, narration, voice-overs, illustrations, and animations. Plus delightful activity videos for listening, learning, reading, drawing, and lots of fun! ---------- Website: http://www.musicaudiostories.com/ Storytime: http://storytimewithannachristina.com/ ---------- Subscribe to get a free music audiobook at: http://www.musicaudiostories.com/#subscribe ---------- Twitter: https://twitter.com/musicaudiostory Instagram: https://www.instagram.com/musicaudiostories/ Facebook: https://www.facebook.com/musicaudiostories/ Storytime with Anna Christina Instagram: https://www.instagram.com/storytimewithannachristina/

Are you confident your organisation could cope if a bad news story went viral and you were besieged by the media? Would you be able to fend off a determined and aggressive journalist, take control and deliver your key messages? Our crisis communications courses show you how to cope when your organisation is under fire, and protect your good name. We can: Train your spokespeople to handle challenging interviews, pitting their wits against a hostile reporter Train your PR team to manage communications during an unfolding crisis Deliver a fast-paced crisis simulation where your team have to decide how to handle the press during an unfolding emergency Facilitate a crisis strategy workshop, where we work together to develop your crisis communications strategy All of our crisis communications courses are bespoke, so we will design each one to meet your specific needs. Areas we can cover include: How a crisis can escalate in seconds How journalists respond to bad news stories How to develop effective key messages & write holding statements How to manage your social media How to take control of an interview and get your message across How to handle press conferences and doorsteps Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Duration 5 Days 30 CPD hours This course is intended for IT professionals with five to eight years of experience in these roles: Data center engineers Network designers Network administrators Network engineers Systems engineers System administrator Consulting systems engineers Technical solutions architects Server administrators Network managers Cisco integrators or partners Overview After taking this course, you should be able to: Describe the Layer 2 and Layer 3 forwarding options and protocols used in a data center Describe the rack design options, traffic patterns, and data center switching layer access, aggregation, and core Describe the Cisco Overlay Transport Virtualization (OTV) technology that is used to interconnect data centers Describe Locator/ID separation protocol Design a solution that uses Virtual Extensible LAN (VXLAN) for traffic forwarding Describe hardware redundancy options; how to virtualize the network, compute, and storage functions; and virtual networking in the data center Describe solutions that use fabric extenders and compare Cisco Adapter Fabric Extender (FEX) with single root input/output virtualization (SR-IOV) Describe security threats and solutions in the data center Describe advanced data center security technologies and best practices Describe device management and orchestration in the data center Describe the storage options for compute function and different Redundant Array of Independent Disks (RAID) levels from a high-availability and performance perspective Describe Fibre Channel concepts, topologies, architecture, and industry terms Describe Fibre Channel over Ethernet (FCoE) Describe security options in the storage network Describe management and automation options for storage networking infrastructure Describe Cisco UCS servers and use cases for various Cisco UCS platforms Explain the connectivity options for fabric interconnects for southbound and northbound connections Describe the hyperconverged solution and integrated systems Describe the systemwide parameters for setting up a Cisco UCS domain Describe role-based access control (RBAC) and integration with directory servers to control access rights on Cisco UCS Manager Describe the pools that may be used in service profiles or service profile templates on Cisco UCS Manager Describe the different policies in the service profile Describe the Ethernet and Fibre Channel interface policies and additional network technologies Describe the advantages of templates and the difference between initial and updated templates Describe data center automation tools The Designing Cisco Data Center Infrastructure (DCID) v7.0 course helps you master design and deployment options focused on Cisco© data center solutions and technologies across network, compute, virtualization, storage area networks, automation, and security. You will learn design practices for the Cisco Unified Computing System? (Cisco UCS©) solution based on Cisco UCS B-Series and C-Series servers, Cisco UCS Manager, and Cisco Unified Fabric. You will also gain design experience with network management technologies including Cisco UCS Manager, Cisco Data Center Network Manager (DCNM), and Cisco UCS Director. This course helps you prepare to take the exam, Designing Cisco Data Center Infrastructure (300-610 DCID) Describing High Availability on Layer 2 Overview of Layer 2 High-Availability Mechanisms Virtual Port Channels Cisco Fabric Path Virtual Port Channel+ Designing Layer 3 Connectivity First Hop Redundancy Protocols Improve Routing Protocol Performance and Security Enhance Layer 3 Scalability and Robustness Designing Data Center Topologies Data Center Traffic Flows Cabling Challenges Access Layer Aggregation Layer Core Layer Spine-and-Leaf Topology Redundancy Options Designing Data Center Interconnects with Cisco OTV Cisco OTV Overview Cisco OTV Control and Data Planes Failure Isolation Cisco OTV Features Optimize Cisco OTV Evaluate Cisco OTV Describing Locator/ID Separation Protocol Locator/ID Separation Protocol Location Identifier Separation Protocol (LISP) Virtual Machine (VM) Mobility LISP Extended Subnet Mode (ESM) Multihop Mobility LISP VPN Virtualization Describing VXLAN Overlay Networks Describe VXLAN Benefits over VLAN Layer 2 and Layer 3 VXLAN Overlay Multiprotocol Border Gateway Protocol (MP-BGP) Ethernet VPN (EVPN) Control Plane Overview VXLAN Data Plane Describing Hardware and Device Virtualization Hardware-Based High Availability Device Virtualization Cisco UCS Hardware Virtualization Server Virtualization SAN Virtualization N-Port ID Virtualization Describing Cisco FEX Options Cisco Adapter FEX Access Layer with Cisco FEX Cisco FEX Topologies Virtualization-Aware Networking Single Root I/O Virtualization Cisco FEX Evaluation Describing Basic Data Center Security Threat Mitigation Attack and Countermeasure Examples Secure the Management Plane Protect the Control Plane RBAC and Authentication, Authorization, and Accounting (AAA) Describing Advanced Data Center Security Cisco TrustSec in Cisco Secure Enclaves Architecture Cisco TrustSec Operation Firewalling Positioning the Firewall Within Data Center Networks Cisco Firepower© Portfolio Firewall Virtualization Design for Threat Mitigation Describing Management and Orchestration Network and License Management Cisco UCS Manager Cisco UCS Director Cisco Intersight Cisco DCNM Overview Describing Storage and RAID Options Position DAS in Storage Technologies Network-Attached Storage Fibre Channel, FCoE, and Internet Small Computer System Interface (iSCSI) Evaluate Storage Technologies Describing Fibre Channel Concepts Fibre Channel Connections, Layers, and Addresses Fibre Channel Communication Virtualization in Fibre Channel SAN Describing Fibre Channel Topologies SAN Parameterization SAN Design Options Choosing a Fibre Channel Design Solution Describing FCoE FCoE Protocol Characteristics FCoE Communication Data Center Bridging FCoE Initialization Protocol FCoE Design Options Describing Storage Security Common SAN Security Features Zones SAN Security Enhancements Cryptography in SAN Describing SAN Management and Orchestration Cisco DCNM for SAN Cisco DCNM Analytics and Streaming Telemetry Cisco UCS Director in the SAN Cisco UCS Director Workflows Describing Cisco UCS Servers and Use Cases Cisco UCS C-Series Servers Fabric Interconnects and Blade Chassis Cisco UCS B-Series Server Adapter Cards Stateless Computing Cisco UCS Mini Describing Fabric Interconnect Connectivity Use of Fabric Interconnect Interfaces VLANs and VSANs in a Cisco UCS Domain Southbound Connections Northbound Connections Disjoint Layer 2 Networks Fabric Interconnect High Availability and Redundancy Describing Hyperconverged and Integrated Systems Hyperconverged and Integrated Systems Overview Cisco HyperFlex? Solution Cisco HyperFlex Scalability and Robustness Cisco HyperFlex Clusters Cluster Capacity and Multiple Clusters on One Cisco UCS Domain External Storage and Graphical Processing Units on Cisco HyperFlex Cisco HyperFlex Positioning Describing Cisco UCS Manager Systemwide Parameters Cisco UCS Setup and Management Cisco UCS Traffic Management Describing Cisco UCS RBAC Roles and Privileges Organizations in Cisco UCS Manager Locales and Effective Rights Authentication, Authorization, and Accounting Two-Factor Authentication Describing Pools for Service Profiles Global and Local Pools Universally Unique Identifier (UUID) Suffix and Media Access Control (MAC) Address Pools World Wide Name (WWN) Pools Server and iSCSI Initiator IP Pools Describing Policies for Service Profiles Global vs. Local Policies Storage and Basic Input/Output System (BIOS) Policies Boot and Scrub Policies Intelligent Platform Management Interface (IPMI) and Maintenance Policies Describing Network-Specific Adapters and Policies LAN Connectivity Controls SAN Connectivity Controls Virtual Access Layer Connectivity Enhancements Describing Templates in Cisco UCS Manager Cisco UCS Templates Service Profile Templates Network Templates Designing Data Center Automation Model-Driven Programmability Cisco NX-API Overview Programmability Using Python Cisco Ansible Module Use the Puppet Agent Additional course details: Nexus Humans Cisco Designing Cisco Data Center Infrastructure v7.0 (DCID) 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 Data Center Infrastructure v7.0 (DCID) 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.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for: Solutions architects and cloud architects seeking their AWS Certified Solutions Architect - Associate certification Customers and APN Partners who have 6 to 12 months of experience with AWS including a strong architecture background and experience Individuals who prefer an instructor led course for training and exam readiness Individuals who have not taken the Architecting on AWS course in the last ~6 months Overview In this course, you will learn to: Make architectural decisions based on AWS architectural principles and best practices Leverage AWS services to make your infrastructure scalable, reliable, and highly available Leverage AWS Managed Services to enable greater flexibility and resiliency in an infrastructure Make an AWS-based infrastructure more efficient to increase performance and reduce costs Use the Well-Architected Framework to improve architectures with AWS solutions Navigate the logistics of the examination process, exam structure, and question types Identify how questions relate to AWS architectural concepts Interpret the concepts being tested by an exam question This five-day, instructor-led course helps busy architects get away from the day-to-day to get focused and ready for their AWS Certified Solutions Architect ? Associate exam. Attendees learn the fundamentals of building IT infrastructure on AWS, so they can build scalable and resilient solutions in the cloud, by spending the first 3 days on the Architecting on AWS course. They?ll start getting in the exam readiness mindset with bonus end of module quizzes. Next, they?ll learn strategies to answer exam questions and avoid common mistakes with the Exam Readiness: AWS Certified Solutions Architect ? Associate half-day course. The course broadens attendees? knowledge of AWS services with deep dives into Amazon Redshift, Amazon Kinesis, and AWS Key Management Service, and then concludes with two quizzes and an instructor guided review of the AWS Certified Solutions Architect ? Associate practice exam. Architecting on AWS Module 1: Introduction Module 2: The Simplest Architectures Hands-On Lab 1: Hosting a Static Website Module 3: Adding a Compute Layer Module 4: Adding a Database Layer Hands-On Lab 2: Deploying a Web Application on AWS Module 5: Networking in AWS Part 1 Hands-On Lab 3: Creating a Virtual Private Cloud Architecting on AWS (continued) Module 6: Networking in AWS Part 2 Module 7: AWS Identity and Access Management (IAM) Module 8: Elasticity, High Availability, and Monitoring Hands-On Lab 4: Creating a Highly Available Environment Module 9: Automation Hands-On Lab 5: Automating Infrastructure Deployment with AWS CloudFormation Module 10: Caching Architecting on AWS (continued) Module 11: Building Decoupled Architectures Module 12: Microservices and Serverless Architectures Hands-On Lab 6: Implementing a Serverless Architecture with AWS Managed Services Module 13: RTP/RPO and Backup Recovery Setup Module 14: Optimizations and Review Exam Readiness: AWS Certified Solutions Architect -- Associate Module 0: The Exam Module 1: Design Resilient Architectures Module 2: Design Performant Architectures Module 3: Specify Secure Applications and Architectures Module 4: Design Cost-Optimized Architectures Module 5: Define Operationally Excellent Architectures Exam Readiness Additional deep dive of AWS services Quiz #1 Practice exam: AWS Certified Solutions Architect ? Associate Quiz #2 Wrap-up

Dysphagia presents a multifaceted challenge that can culminate in aspiration, malnutrition, and a diminished quality of life. This course serves as a comprehensive exploration of dysphagia, unravelling its root causes, evaluation techniques, and measures for ensuring secure swallowing practices.

Generating new leads and new business can be both time-consuming and frustrating. It's not easy - it takes skill, careful preparation and the creation of effective models and methods, even perhaps using formal approaches and scripts. Once generated, a new lead or enquiry must also be carefully managed to maximise the potential revenue it can generate. But it's crucial to get it right. If your company can afford not to worry about getting new business - congratulations! If your company is completely confident that it is performing at peak potential in generating new leads - again, congratulations! But if your company is working in the real world, couldn't your team do with some help, to become even just that little bit more effective, to make the process just that little less painful? This highly practical, intensive workshop gives sales teams the proven strategies and tactics they need to build a sustainable new business pipeline. This course will help participants: Develop a clear and consistent process for new business development and lead-generation Master the secret of effective new business development and lead-generation - 'only sell the appointment or next stage of the sales process, not your product or service' Set and achieve the right level of new business development and lead-generation activity to achieve your personal and organisational sales goals Apply the key principles of effective prospecting and pipeline management using a proven toolkit and approach Overcome the most common 'put-offs' when conducting telephone or face-to-face business-development and lead-generation activities Develop an engaging telephone voice and manner - and a 'networking personality' Qualify potential opportunities with more accuracy on a consistent basis Prioritise opportunities and manage their time when sourcing new business Discover online sources of leads, contacts and referrals Overcome psychological blocks to cold or warm calling - theirs and the client's Identify potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Make outbound sales or appointment calls with improved confidence, control and results Improve the conversion of calls to appointments by using more effective questions and sales messages Get past gatekeepers and assistants more effectively Make the most of your CRM software and systems 1 Online marketing - what works! Workshop overview and learning objectives Choosing your social media channels LinkedIn for sales and marketing Designing and implementing an effective new business email campaign online Creating a lead-generation strategy online - with case studies Avoiding common mistakes in social media marketing Case study: 'Best practice in social media sales and marketing' Using blogs and video-based marketing (eg, YouTube) New trends and how to keep your finger on the 'social media' pulse Twenty essential websites and online marketing tools 2 Making appointments by telephone Planning the call, telephone techniques, integrating with email and online marketing Developing a clear and consistent process to appointment-making Setting and achieving the right level of telephone activity to achieve your appointment goals Applying the key principles of effective prospecting and pipeline management generation, using a proven toolkit and approach Overcoming the most common 'put-offs' to seeing or engaging with you Overcoming psychological blocks to cold or warm calling - yours and the client's Identifying potential prospects - and decision-makers and influencers within target prospects - with greater accuracy Making outbound sales or appointment calls with improved confidence, control and results Improving conversion of calls to appointments by using more effective questions and sales messages The five keys to developing an engaging telephone voice and approaching manner 3 Power networking Strategies for networking and B2B referral-based marketing The importance, and different types, of networking How to work a room - preparation and strategy Communication dynamics in networking - the power of the listening networker Assumptions when networking Business networking etiquette Making connections, asking for cards, contact details and referrals, gaining follow-up commitments Building relationships - follow-up and follow-through 4 Developing new leads Strategies for first-time sales calls Gaining rapport and opening first-time and new business sales calls effectively Advanced consultative selling - questioning techniques to quickly and efficiently uncover opportunities, need areas and preferences Presenting your solution to a new or first-time customer - creating an enthusiastic and compelling personalised and persuasive summary of your proposal Value message - differentiate your solutions clearly and accurately, with tailored value statements Presenting the right initial USPs, features and benefits and making them relevant and real to the customer Smart ways to position price, emphasise value and be a strong player without being the cheapest or leading on price Learn and use advanced techniques to determine customer needs, value and decision-making criteria in depth on a first-time call 5 Organised persistence - CRM and prospect-tracking Organised persistence - sales tracking, following up on 'sleeping' customers, gaining referrals, time and territory management Maintaining a good database for maximising new business ROI Developing a contact strategy with different types and levels of contact Analysing your contact base using state-of-the-art software and tools Making the most of your CRM systems and solutions Understanding that your attitude makes a difference when sourcing new business Setting SMART objectives for new business development and lead-generation Practical exercise - setting personal development and business goals Time management tips to improve daily productivity New business pipeline management strategies for peak sales performance 6 Workshop summary and close Practical exercise - developing your new business action plan Review and feedback

Duration 3 Days 18 CPD hours This course is intended for This course is intended for: Database architects Database administrators Database developers Data analysts and scientists Overview This course is designed to teach you how to: Discuss the core concepts of data warehousing, and the intersection between data warehousing and big data solutions Launch an Amazon Redshift cluster and use the components, features, and functionality to implement a data warehouse in the cloud Use other AWS data and analytic services, such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3, to contribute to the data warehousing solution Architect the data warehouse Identify performance issues, optimize queries, and tune the database for better performance Use Amazon Redshift Spectrum to analyze data directly from an Amazon S3 bucket Use Amazon QuickSight to perform data analysis and visualization tasks against the data warehouse Data Warehousing on AWS introduces you to concepts, strategies, and best practices for designing a cloud-based data warehousing solution using Amazon Redshift, the petabyte-scale data warehouse in AWS. This course demonstrates how to collect, store, and prepare data for the data warehouse by using other AWS services such as Amazon DynamoDB, Amazon EMR, Amazon Kinesis, and Amazon S3. Additionally, this course demonstrates how to use Amazon QuickSight to perform analysis on your data Module 1: Introduction to Data Warehousing Relational databases Data warehousing concepts The intersection of data warehousing and big data Overview of data management in AWS Hands-on lab 1: Introduction to Amazon Redshift Module 2: Introduction to Amazon Redshift Conceptual overview Real-world use cases Hands-on lab 2: Launching an Amazon Redshift cluster Module 3: Launching clusters Building the cluster Connecting to the cluster Controlling access Database security Load data Hands-on lab 3: Optimizing database schemas Module 4: Designing the database schema Schemas and data types Columnar compression Data distribution styles Data sorting methods Module 5: Identifying data sources Data sources overview Amazon S3 Amazon DynamoDB Amazon EMR Amazon Kinesis Data Firehose AWS Lambda Database Loader for Amazon Redshift Hands-on lab 4: Loading real-time data into an Amazon Redshift database Module 6: Loading data Preparing Data Loading data using COPY Data Warehousing on AWS AWS Classroom Training Concurrent write operations Troubleshooting load issues Hands-on lab 5: Loading data with the COPY command Module 7: Writing queries and tuning for performance Amazon Redshift SQL User-Defined Functions (UDFs) Factors that affect query performance The EXPLAIN command and query plans Workload Management (WLM) Hands-on lab 6: Configuring workload management Module 8: Amazon Redshift Spectrum Amazon Redshift Spectrum Configuring data for Amazon Redshift Spectrum Amazon Redshift Spectrum Queries Hands-on lab 7: Using Amazon Redshift Spectrum Module 9: Maintaining clusters Audit logging Performance monitoring Events and notifications Lab 8: Auditing and monitoring clusters Resizing clusters Backing up and restoring clusters Resource tagging and limits and constraints Hands-on lab 9: Backing up, restoring and resizing clusters Module 10: Analyzing and visualizing data Power of visualizations Building dashboards Amazon QuickSight editions and feature

Understanding a buildings heat loss for heating engineers