• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

1091 Courses in Cardiff delivered Live Online

Applied Strategic Healthcare Leadership

By HFX Training

Applied Strategic Healthcare Leadership Course An ACHE-Accredited Executive Program | $1,200 USD Sharpen Your Strategic and Financial Leadership in Healthcare This highly interactive program is designed exclusively for executives and fellows of the American College of Healthcare Executives (ACHE) who are ready to elevate their strategic and financial decision-making capabilities through immersive simulation-based learning. Delivered over a series of six engaging Zoom sessions, the Applied Strategic Healthcare Leadership Course equips you with critical tools to drive performance in your healthcare organization while earning 12 ACHE continuing professional education credits. What Makes This Course Unique? Simulation-Based Learning: Leverage the industry-leading Healthcare Hero hospital management simulation, used in top-tier MHA and MBA programs globally. Team-Based Executive Challenge: Work in teams to manage a virtual hospital, facing real-world challenges and dynamic market forces. Experiential Learning: Make executive-level decisions across strategy, operations, and finance in a safe, competitive environment that mirrors the complexities of modern healthcare. Facilitated by Experts: Guided by experienced healthcare and simulation facilitators with deep knowledge of executive leadership and health system strategy. Course Format 6 x 2-hour Zoom sessions (12 contact hours total) The zoom sessions will run weekly from Saturday 11am-1pm Eastern, starting on April 5th Combines strategic and financial management lectures with 8 intensive simulation rounds Practice rounds to build confidence, followed by a competitive live game Final session includes a powerful executive debrief to help you apply insights directly to your organization Key Learning Outcomes By completing this program, you will: ✔ Apply advanced strategy frameworks tailored to healthcare ✔ Strengthen your financial leadership with healthcare-specific KPIs and analysis ✔ Improve team-based executive decision-making under real-world pressure ✔ Learn how to balance mission, margin, and market dynamics ✔ Take home actionable insights to drive performance improvement in your role Who Should Enroll This course is ideal for: ACHE members and fellows seeking executive-level simulation training Healthcare executives responsible for strategy, operations, or finance MHA/MBA graduates looking to sharpen applied skills Leaders preparing for expanded organizational responsibility Program Fee 💲 $1,200 USD (Includes full simulation access, live facilitation, team coaching, and all course materials.) Enroll Now About the Simulation Healthcare Hero is a highly acclaimed hospital management simulation designed to challenge participants with the real-world complexities of running a competitive healthcare system. Trusted by leading universities and executive education programs worldwide. Frequently Asked Questions 1. Who is this course designed for? This program is specifically designed for healthcare executives, ACHE members, and fellows who wish to enhance their strategic, financial, and leadership capabilities through applied learning. It’s also ideal for senior managers preparing for executive roles. 2. How does the Healthcare Hero simulation work? Healthcare Hero is an interactive, web-based hospital management simulation. Working in teams, you will make key decisions across hospital strategy, operations, and finance, while competing against other teams in a dynamic, simulated healthcare market. No prior simulation experience is required—full guidance will be provided. 3. How much time will I need to commit? The program consists of 6 x 2-hour Zoom sessions (12 hours total), spread over several weeks. Between sessions, you may wish to review materials or discuss strategies with your team, but no additional time commitment is required. 4. What topics will be covered? You will explore critical areas such as healthcare strategy, financial management, team leadership, and decision-making under pressure. The course blends applied simulation rounds with lectures on strategic management and financial leadership in healthcare. 5. Will I earn ACHE continuing professional education (CPE) credits? Yes, this program is eligible for 12 ACHE-approved CPE credits, contributing toward your ongoing professional development. 6. Do I need prior experience with simulations? No simulation experience is needed. The first sessions include practice rounds and onboarding to help you get comfortable with the platform and decision-making process. 7. How will teams be formed? Participants will be assigned to teams during the first session to encourage collaboration, peer learning, and networking. Team performance will be key to success in the simulation. 8. What’s included in the course fee? Your $1,200 USD fee includes access to the Healthcare Hero simulation, live facilitation, course materials, team coaching, and participation in all Zoom sessions. 9. Is there a certificate of completion? Yes, participants will receive a certificate of completion after finishing the course and simulation rounds. This can be used to demonstrate CPE credits to ACHE. 10. Can I cancel or transfer my registration? Cancellations are allowed up to 14 days before the course start date for a full refund. Transfers to a future cohort are available subject to availability. Please contact us directly to process cancellations or transfers.

Applied Strategic Healthcare Leadership
Delivered OnlineFlexible Dates
$1,200

Advanced financial analysis (In-House)

By The In House Training Company

In today's competitive business world firms are under unprecedented pressure to deliver value to their shareholders and other key stakeholders. Senior executives in all parts of the organisation are finding that they need some degree of financial know how to cope with the responsibility placed on them as business managers and key decision-makers; monitoring and improving business performance, investing in capital projects, mergers and acquisitions: all require some degree of financial knowledge. The key financial skills are not as difficult to learn as many people believe and in the hands of an experienced senior executive they can provide a formidable competitive advantage. After completing this course delegates will be able to: Understand fundamental business finance concepts; understand, analyse and interpret financial statements: Profit Statement, Balance Sheet and Cashflow Statement Understand the vital difference between profit and cashflow; identify the key components of working capital and how they can be managed to generate strong cashflow Evaluate pricing decisions based on an understanding of the nature of business costs and their impact on gross margin and break-even sales; managing pricing, discounts and costs to generate strong business profits; understand how lean manufacturing methods improve profit Use powerful analytical tools to measure and improve the performance of their own company and assess the effectiveness of their competitors Apply and interpret techniques for assessing and comparing investment opportunities in capital projects, business acquisitions and other ventures; understand and apply common methods of business valuation Understand the role of business finance in formulating and implementing competitive business strategy; the role of budgeting as part of the planning process and the various approaches to budgeting and performance measurement 1 Basic principles Delivering value to key stakeholders Accounting concepts, GAAP, IFRS and common terms Understanding and using the balance sheet Understanding and using the profit statement Recognising the vital difference between profit and cashflow Understanding and using the cashflow statement What financial statements can and cannot tell us 2 Managing and improving cashflow Sources of finance and their advantages and disadvantages What is working capital and why is it so important? Managing stocks, debtors and creditors Understanding how working capital drives business growth Understanding and avoiding the over-trading trap Unlocking the funds tied up in fixed assets: asset backed loans and leasing 3 Managing and improving profit Understanding how profits generate cashflow The fundamental nature of costs: fixed and variable business costs Understanding gross margin and break-even How common pricing methods affect gross margin and profit Effective strategies to improve gross margin Using value chain analysis to reduce costs Lean manufacturing methodsUnderstanding Just-in-time, 6 Sigma and Kaizen methods Improving profitEffective and defective strategies 4 Measuring and managing business performance Measures of financial performance and strength Investor behaviour: the risk and reward relationship Return on investment (ROI): the ultimate measure of business performance How profit margin and net asset turnover drive return on net assets Why some companies are more profitable that others Understanding competitive advantage: cost and differentiation advantage Why great companies failWhat happened to Kodak? Using a 'Pyramid of Ratios' to improve business performance Using Critical Success Factors to develop Key Performance Indicators 5 Budgeting and forecasting methods Using budgets to support strategy Objectives and methods for effective budgets Using budgets to monitor and manage business performance Alternative approaches to budgeting Developing and implementing Balanced Scorecards Beyond Budgeting Forecasting methods and techniques Identifying key business drivers Using rolling forecasts and 'what-if' models to aid decision-making

Advanced financial analysis (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

Healthcare Hero Instructor Training Certification: Level 1

By HFX Training

At HFX Training, we are passionate about business simulations because they bring learning to life through hands-on experience. This Level 1 Certification Program is the first step in our Instructor Training Certification Pathway, equipping you to confidently use the Healthcare Hero simulation in your teaching environment. In this program, you will experience the simulation as a student, navigating its complexities and dynamics. Upon successfully completing Level 1, you’ll be ready to advance to Level 2 Training, where you will deepen your expertise in simulation facilitation and administration. The program is cohort-based, and the timetable is coordinated in advance through discussions with the HFX team to ensure maximum participation. For more information on the program structure, instructional materials, and certification requirements, please read on. What to Expect: The Healthcare Hero simulation places you in charge of a fictional hospital. Over eight simulation rounds - each representing one quarter of business operations - you will make strategic decisions to optimize patient care while managing staffing, capacity, quality, and finances. Throughout the simulation, you’ll navigate challenges like healthcare and economic crises, all while balancing the needs of multiple stakeholders. Your ultimate goal is to outperform competing hospitals managed by other participants in the program. Program and Certification Requirements This program equips you to confidently lead the simulation by requiring more than attendance or participation. To earn certification, you must: Thoroughly Prepare: Review all instructional materials and the scenario manual before the course begins. Fully Participate: Attend all Zoom sessions and complete each simulation round with focus and effort. Demonstrate Mastery: Show a comprehensive understanding of the simulation’s dynamics, decision-making processes, and strategies during practice and live rounds. Engage in Reflection: Actively participate in debrief sessions, assess your performance, and identify strategies for improvement. This certification ensures you are equipped to facilitate this complex simulation with confidence. Auditing the course is an option, but participants who choose to audit will not receive certification. Program Format The program is delivered intensively over one or more Zoom sessions, totaling six hours. This compressed format demands your full attention and focus to successfully navigate the simulation’s complexities. Eligibility Requirements: By registering for this training program, you acknowledge the following: You have discussed your needs with the HFX team and confirmed that the simulation aligns with your class or program objectives. You are an instructor at an academic institution. You agree to the confidentiality terms and commit not to distribute, disclose, or replicate any program content for purposes outside of this training. This program is offered in goodwill to academic instructors as a resource to enhance their teaching. As part of this agreement, you understand that all materials, including the simulation itself, are proprietary to HFX and its partners. Any use of these materials for purposes beyond this program, such as developing similar tools or simulations, is strictly prohibited. Course Structure: After registering, you will gain immediate access to the simulation’s instructional materials. This includes: The Scenario Manual: Your guide to understanding the game. The Capacity Planner Worksheet and Financial Planning Worksheet: Tools to help you strategize. The Strategy Planning Exercise: Designed to align your decisions with overall objectives. The Portal Guide: A walkthrough of the simulation platform. The program unfolds in four key phases: Phase 1: Pre Zoom Call / Study / Set Up Register using the button at the bottom of this page. Review the instructional materials thoroughly. Once the cohort is finalized, you will be sent your login credentials for the simulation itself. Try to submit decisions for the first practice round using the simulation portal at www.simulationportal.com. Phase 2: Play We run two practice rounds over the first 2 hours of the zoom call. This allows you to familiarize yourself with the platform and decision-making process, and think through what your strategy might be in the live game. The simulation resets ("zeroed") after the practice rounds. A brief session will clarify lessons learned and expectations for the live rounds. Over eight rounds, you’ll compete against other participants while refining your strategic decisions. Phase 3: Feedback Reflect on your performance during a structured debrief, including: Strengths and areas for improvement. Insights into competitors’ strategies. Strategic lessons learned, and applicability to local healthcare organizations. Phase 4: Implementation Planning Work with the HFX team to plan your first application of the simulation in a teaching environment. Certification Outcome Upon completing this program, you will earn the HFX Instructor Training Certification: Level One, signifying your expertise in conducting impactful simulation-based training using Healthcare Hero.

Healthcare Hero Instructor Training Certification: Level 1
Delivered OnlineFlexible Dates
$2,000

Business Skills for the IT Professional - BCS Course

5.0(12)

By Duco Digital Training

This practitioner-level 4 award encourages individuals in IT and technical roles to explore the many teams, ideas, and functions within an organisation and maximise their contribution. You will achieve this by learning the key concepts and considering behaviour and response in different scenarios.

Business Skills for the IT Professional - BCS Course
Delivered OnlineFlexible Dates
£625

Coaching for Results (Second Edition)

By Nexus Human

Duration 1 Days 6 CPD hours This course is intended for This course is intended for working professionals in various job roles, both native and non-native English speakers, who use formal and informal written communications in the course of business, and who seek to improve their grammar usage. Overview In this course, you will develop the skills to coach for results. You will: Define coaching and determine how you want to coach. Build a foundation for coaching. Establish a coaching process. Execute a coaching plan. Coach teams and coach remotely. As a leader in your organization, you're expected to help people meet or exceed expectations and to help ensure productivity and profitability for the organization. Coaching is a leadership tool that is effective in improving performance and contributing to the goals of the organization. In this course, you will build a foundation for coaching, establish a coaching process, execute a coaching plan, and explore strategies for coaching in different business scenarios. Many different factors can affect employee performance. When performance problems arise, people need to be supported to get back on track and do their jobs well. Coaching is an effective way of confirming an employee's value while improving performance. Coaching contributes to employee retention because it offers the opportunity to grow, provides motivation, and supports learning. Coaching also enhances the image and effectiveness of managers and supervisors. Defining Yourself as a Coach Define Coaching Determine a Coaching Approach Developing Core Coaching Skills Evaluate Performance Develop Essential Interpersonal Skills Establishing a Coaching Process Initiate the Coaching Relationship Agree on a Coaching Plan Executing the Coaching Plan Coach Adjust the Coaching Plan Verify That Goals Have Been Met Coaching in Different Business Scenarios Coach a Team Coach Remotely

Coaching for Results (Second Edition)
Delivered OnlineFlexible Dates
Price on Enquiry

Women in Banking Leadership Workshop

5.0(1)

By Own Your Success

Women in Banking Leadership Workshop Workshop Overview: Unleash your potential - The Banking and Financial Services industry is a constantly changing sphere that calls for emerging leaders to adapt and grow in order to thrive and succeed. Often those wanting to take the next step in the field find it hard to see their full value and potential, slowing their progress in a world full of opportunities. Emerging leaders will need to understand their professional values and know how to cultivate a growth mindset to stand out and fulfil their career desires.  This interactive virtual workshop will provide emerging leaders within the field the skills to understand the strengths that they are able to bring to the corporate table to confidently unleash their potential. It will particularly benefit those who aspire to move beyond early management to broader leadership roles. Kat will guide attendees to unlock their potential through releasing self-doubt, connecting to their unique contribution and forming a confident, strategic leader that will drive an organisation to success. Our Aims for the Workshop: Navigate key challenges and change in fast-paced work-places Understand the value of embracing complexity, uncertainty and diversity Negotiate diversity and inclusion biases, enablers and blocker Topic 1 Define your leadership style What are the capabilities, attributes and skills of an influential leader? What is your unique contribution? Is this congruent with your personal brand? Align your leadership strengths and values with the expectations and culture of your organisation. Topic 2 Leading with Emotional Intelligence (EQ) Understand your EQ and its impact on the way you are perceived as a leader Leverage your EQ in the workplace both in person and online Embrace qualities of empathy and authenticity to become a better leader Topic 3 Interactive Panel Q&A Discussion: Open Q&A with Senior Female leaders within the banking sector. Please see below the panel and biographies of each panellist. Topic 4 How to be known as a strategic leader Understand the uplevel from management to leadership and how to articulate your strategy How to translate broad leadership tools and tactics into practical, personalised results Move from transactional to transformational leadership Topic 5 Strengthen your resilience and resolve What is stress and how do you “show-up” on a bad day? Bounce back from challenging situations and predicaments Effectively manage conflict and turn negativity into an opportunity Who will attend? Emerging Leaders looking to step into management roles Current Leaders looking to progress into senior management roles This workshop is open to any woman who works in the banking sector that wants to take her next step in their career; women include trans women and non-binary people who are comfortable in a female-centred group. Group Rate Discounts 2-3 people, 7% discount 4+ people, 20% discount We have two group rates which you can take advantage of depending on the size of the group you wish to book: Option 1️⃣ Groups between 2 & 3 are eligible for the 7% Discount. Please use this code at checkout: GROUP 2+  Option 2️⃣ For groups of over 4+ attendees, the eligible discount is 20%. Please use this code at checkout: GROUP 4+  Where do I add the discount code?  Your Facilitator Kat Hutchings Kat coaches Executives and senior leaders in scale businesses to develop their leadership capability, build high-performing teams and create a culture that motivates and delivers. She works with them to identify their unique contribution and lead in a way that's aligned with who they are. Clients that work with Kat connect to their sense of purpose and how they contribute to the organisation. This creates a ripple effect through their team as they step into more powerful and impactful leadership. Kat coaches for insight - because a single insight can inspire action that changes everything.  Client outcomes include improved sales performance, successful delivery of change & transformation programmes and greater employee engagement & wellbeing.  Kat is an accredited Professional Executive Coach with the Association for Coaching and a Master NLP Practitioner. She has studied neuroscience, mindfulness and resilience, often bringing these insights to her coaching and training.  Combined with her experience as a leader in Financial Services, Kat’s clients find her to be commercially minded, knowledgeable and positively challenging. Her background as a corporate banker means Kat is quickly able to understand the context, including a firm’s strategy, vision and drivers. As a former Head of Coaching for the London & South East region of a FTSE 100 organisation, Kat is also well versed in leadership development programmes – their design, delivery and embedding through coaching. Outside of her coaching work, Kat spends lots of time with her husband and 2 young children. She enjoys trying different wines, talking to interesting people, having new experiences and buying flowers. THE PANEL The final panel is coming soon ⏳

Women in Banking Leadership Workshop
Delivered OnlineFlexible Dates
£525

Sales superheros (In-House)

By The In House Training Company

Are your sales people too stressed, running on adrenalin, perhaps driving towards burnout, struggling to reach targets? Wouldn't you rather they delivered consistently good performance, sustainable over longer periods of time, with less stress (for both them and you)? This uniquely empowering workshop will help your team develop naturally high levels of focus, energy and motivation. They will attain a sense of grounded euphoria, giving them a very distinct and ethical edge in selling. A one-day programme, it gives salespeople an introduction to the 'Natural Superheroes' concepts and resources, tools and techniques, to help them improve their sales performance - realising greater sales potential, developing deeper and more profitable client relationships, winning more business. Through this experience, sales teams gain: Information about profiling clients to instantly understand more about their deepest drives and true needs so they can be genuinely met and, where possible, exceeded Insights into deep, honest and very 'real' reasons for sales procrastination - participants are given specific workable strategies they can easily apply to overcome sales resistance, by tapping their natural motivational styles An understanding of communicating at the very highest levels with different people so they truly understand your sales message and have a significantly more positive sales experience A realisation of their very specific natural sales talents as individuals and as a team A deeper level of experience and understanding of what specifically drives their own behaviour and the behaviour of their clients - these unique insights explain not only how but exactly why people behave the way they do An experience of what it takes to be unshakeable under pressure and manage the sales processes and relationships to a positive outcome for all Brand-new insights into working with and handling difficult people across all levels of authority An understanding of the pitfalls and the psychological traps we set ourselves which cause unnecessary stress, anxiety and frustration on a daily basis and, in turn, limit our sales performance Access to very simple and practical tools that massively increase self-awareness, engender accountability and responsibility and develop emotional sales mastery 1 Introducing 'Natural Superheroes' for sales What is a 'Natural Superhero'? Defining emotional intelligence in the context of sales and why it is so important Knowing yourself - why most people don't know themselves at all and how we can understand exactly what drives our behaviour for the purpose of improving sales performance specifically Knowing exactly why others, and specifically clients and team members, behave the way they do - understanding the real motives behind people's good and bad behaviour in a sales meeting Simple steps to freeing yourself of any anxiety, pressure and false sense of limitation when selling Being yourself in sales - why this is not as easy as it sounds but how you can make it effortless How to take control of achieving the sales performance you really need and want for yourself and others Strategies that raise your self-awareness, increase an authentic and sustainable sense of self-confidence, in difficult situations and in moments of crisis 2 Understanding yourself, your team members and your customers - using the Enneagram Introducing the Enneagram and why it is so valuable to sales people and their clients Exploring the 9 types of motivational drives and why people have different reasons for buying from you Core types and wings - understanding the influence of other motivations either side of the core Enneagram type How to confirm the profile of your client - using celebrities from the world of politics, cinema, sports - we explore how to identify each type - what are their core drives, why have they arisen and how can we use these insights to help you in improving your sales performance The 3 levels of behaviour within your personal profile and that of your clients Lookalike Enneagram types - mistaken identities - how to avoid these traps when profiling your clients and your team How to communicate effectively in a sales environment with each of the different Enneagram types - communication strategies for positive impact on morale, performance and, ultimately, sales results How to interpret and make use of the results of your online personal profile - participants complete an online profile before the event and have the opportunity to analyse their results with a view to improving their sales performance How sales teams sabotage their own performance and that of other people within the team - and how to stop it Uncovering your particular edge in a sales role - what unconsciously trips you up as a sales person? How the Enneagram helps us in sustaining a truly great sales performance over time 3 Why positive thinking alone doesn't work in sales Why 'PMA' does not stand for positive mental attitude when selling - learn its alternative meaning that can serve you even more effectively in a sales role 3 steps and exercises that naturally increase PMA The value of making unconscious thinking conscious and how to do this without any pain or discomfort in a sales meeting Why each Enneagram type has a different experience of PMA in terms of their outward behaviour and how to know when you are maximising your sales performance 4 Measuring success How to measure the development of your individual profile as a sales person Development planning and review Into the future - how to continue your Natural Superhero development

Sales superheros (In-House)
Delivered in Harpenden or UK Wide or OnlineFlexible Dates
Price on Enquiry

From Data to Insights with Google Cloud Platform

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform Overview This course teaches students the following skills: Derive insights from data using the analysis and visualization tools on Google Cloud Platform Interactively query datasets using Google BigQuery Load, clean, and transform data at scale Visualize data using Google Data Studio and other third-party platforms Distinguish between exploratory and explanatory analytics and when to use each approach Explore new datasets and uncover hidden insights quickly and effectively Optimizing data models and queries for price and performance Want to know how to query and process petabytes of data in seconds? Curious about data analysis that scales automatically as your data grows? Welcome to the Data Insights course! This four-course accelerated online specialization teaches course participants how to derive insights through data analysis and visualization using the Google Cloud Platform. The courses feature interactive scenarios and hands-on labs where participants explore, mine, load, visualize, and extract insights from diverse Google BigQuery datasets. The courses also cover data loading, querying, schema modeling, optimizing performance, query pricing, and data visualization. This specialization is intended for the following participants: Data Analysts, Business Analysts, Business Intelligence professionals Cloud Data Engineers who will be partnering with Data Analysts to build scalable data solutions on Google Cloud Platform To get the most out of this specialization, we recommend participants have some proficiency with ANSI SQL. Introduction to Data on the Google Cloud Platform Highlight Analytics Challenges Faced by Data Analysts Compare Big Data On-Premises vs on the Cloud Learn from Real-World Use Cases of Companies Transformed through Analytics on the Cloud Navigate Google Cloud Platform Project Basics Lab: Getting started with Google Cloud Platform Big Data Tools Overview Walkthrough Data Analyst Tasks, Challenges, and Introduce Google Cloud Platform Data Tools Demo: Analyze 10 Billion Records with Google BigQuery Explore 9 Fundamental Google BigQuery Features Compare GCP Tools for Analysts, Data Scientists, and Data Engineers Lab: Exploring Datasets with Google BigQuery Exploring your Data with SQL Compare Common Data Exploration Techniques Learn How to Code High Quality Standard SQL Explore Google BigQuery Public Datasets Visualization Preview: Google Data Studio Lab: Troubleshoot Common SQL Errors Google BigQuery Pricing Walkthrough of a BigQuery Job Calculate BigQuery Pricing: Storage, Querying, and Streaming Costs Optimize Queries for Cost Lab: Calculate Google BigQuery Pricing Cleaning and Transforming your Data Examine the 5 Principles of Dataset Integrity Characterize Dataset Shape and Skew Clean and Transform Data using SQL Clean and Transform Data using a new UI: Introducing Cloud Dataprep Lab: Explore and Shape Data with Cloud Dataprep Storing and Exporting Data Compare Permanent vs Temporary Tables Save and Export Query Results Performance Preview: Query Cache Lab: Creating new Permanent Tables Ingesting New Datasets into Google BigQuery Query from External Data Sources Avoid Data Ingesting Pitfalls Ingest New Data into Permanent Tables Discuss Streaming Inserts Lab: Ingesting and Querying New Datasets Data Visualization Overview of Data Visualization Principles Exploratory vs Explanatory Analysis Approaches Demo: Google Data Studio UI Connect Google Data Studio to Google BigQuery Lab: Exploring a Dataset in Google Data Studio Joining and Merging Datasets Merge Historical Data Tables with UNION Introduce Table Wildcards for Easy Merges Review Data Schemas: Linking Data Across Multiple Tables Walkthrough JOIN Examples and Pitfalls Lab: Join and Union Data from Multiple Tables Advanced Functions and Clauses Review SQL Case Statements Introduce Analytical Window Functions Safeguard Data with One-Way Field Encryption Discuss Effective Sub-query and CTE design Compare SQL and Javascript UDFs Lab: Deriving Insights with Advanced SQL Functions Schema Design and Nested Data Structures Compare Google BigQuery vs Traditional RDBMS Data Architecture Normalization vs Denormalization: Performance Tradeoffs Schema Review: The Good, The Bad, and The Ugly Arrays and Nested Data in Google BigQuery Lab: Querying Nested and Repeated Data More Visualization with Google Data Studio Create Case Statements and Calculated Fields Avoid Performance Pitfalls with Cache considerations Share Dashboards and Discuss Data Access considerations Optimizing for Performance Avoid Google BigQuery Performance Pitfalls Prevent Hotspots in your Data Diagnose Performance Issues with the Query Explanation map Lab: Optimizing and Troubleshooting Query Performance Advanced Insights Introducing Cloud Datalab Cloud Datalab Notebooks and Cells Benefits of Cloud Datalab Data Access Compare IAM and BigQuery Dataset Roles Avoid Access Pitfalls Review Members, Roles, Organizations, Account Administration, and Service Accounts

From Data to Insights with Google Cloud Platform
Delivered OnlineFlexible Dates
Price on Enquiry

Learning & Development Level 5

By Rachel Hood

Ensuring learning and development contributes to improved performance in the workplace at an individual, team and organisation level.

Learning & Development Level 5
Delivered OnlineFlexible Dates
Price on Enquiry

Oracle Database 19c: New Features for Administrators

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Oacle Database Administrators System Administrators Developers Overview Understand the concept, benefits, configuration, and usage of the new features and enhancements in database overall area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the security area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the availability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in the performance area Understand the concept, benefits, configuration, and usage of the new features and enhancements in big data and data warehousing area Understand the concept, benefits, configuration, and usage of the new features and enhancements in diagnosability area Understand the concept, benefits, configuration, and usage of the new features and enhancements in sharding area The course provides the Oracle Database 19c new features and enhancements related to database overall, security, availability, performance, data warehousing, and diagnosability. In the lessons, you learn the new and enhanced features of Oracle Database 19c amongst different areas such as database overall, security, availability, performance, big data and warehousing, and diagnosability. Using General Database Overall EnhancementsUsing Security EnhancementsUsing Availability EnhancementsUsing Performance EnhancementsUsing Big Data and Data Warehousing EnhancementsUsing Diagnosability EnhancementsSharding Enhancements

Oracle Database 19c: New Features for Administrators
Delivered OnlineFlexible Dates
Price on Enquiry