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

8275 Insights courses in Manchester delivered Online

Corporate Risk And Crisis Management - CPD Accredited Course

5.0(14)

By Training Express

In today’s dynamic business landscape, understanding how to identify, assess, and manage risks is crucial for maintaining organisational stability and resilience. This course offers a thorough introduction to the principles of risk analysis and corporate risk management, guiding learners through the processes that help protect businesses from financial and operational uncertainties. Participants will explore a range of risk management strategies tailored to corporate environments, providing essential insights into minimising potential threats while safeguarding assets and reputation. Beyond risk, the course delves into the complexities of crisis management, covering how organisations can prepare for, respond to, and recover from disruptive incidents. From crisis communication to the establishment of effective emergency response plans and team coordination, this training equips learners with the knowledge needed to handle crises systematically and with confidence. The post-crisis phase is also examined, emphasising the importance of reflection and improvement to strengthen future responses. Delivered fully online, this course is ideal for professionals seeking to enhance their understanding of risk and crisis management without the need for physical attendance. Additionally, you get: Free exam Free assessment Free certificate Free Tutor support Hurry up and enrol, before the offer expires! Course Curriculum: Module 01: Introduction to Risks and Risk Analysis Module 02: Process of Risk Analysis and Management Module 03: Corporate of Risk Management Module 04: Managing Financial Risks Module 05: Introduction to Crisis and Crisis Management Module 06: Crisis Response and Communication Module 07: Incidents Management and Emergency Response Plan Module 08: Crisis Management Team Module 09: Post Crisis Phase Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Corporate Risk And Crisis Management - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Corporate Risk And Crisis Management - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Corporate Risk And Crisis Management - CPD Accredited training.

Corporate Risk And Crisis Management - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Waiter - CPD Accredited Course

5.0(14)

By Training Express

Serving with skill, attentiveness, and confidence is at the heart of successful food and beverage service. This CPD-accredited Waiter course offers a structured pathway into the world of customer-facing hospitality roles, guiding learners through the essential elements of excellent service. From customer interaction and hygiene standards to equipment handling and beverage knowledge, each module is crafted to build understanding of what it takes to create a positive dining experience. With a focus on technique, safety, and effective communication, the course explores vital topics such as food and beverage control, risk awareness, and sales approaches. Whether you're looking to gain knowledge for entry into hospitality or refine your existing expertise, this course delivers professional insights with clarity and purpose—designed for flexible, online study with no in-person attendance required. Still not convinced? Take a glimpse of the key benefits you'll get with - Lessons prepared in collaboration with Professionals User-friendly Learner Management System (LMS) Syllabus designed in line with the standards of the UK Education System Updated Study Materials focusing both on Knowledge and Skill based training Guidance to expand in 'a' territory and move forward with Waiter profession Free Assessment to test learners' knowledge and skills Course Curriculum: Module 01: Customer Service and Service Sequence Module 02: Equipment Handling Technique Module 03: Hygiene Module 04: Beverage and Tobacco Module 05: Understanding Risks and Preventive Measures Module 06: Food & Beverage Control and Selling Techniques Module 07: Tips and Hints for Success in Waiter profession Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing the Waiter - CPD Accredited course. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Waiter - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Waiter - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Waiter - CPD Accredited training.

Waiter - CPD Accredited Course
Delivered Online On Demand1 hour
£23

Kitchen Gardening - CPD Accredited Course

5.0(14)

By Training Express

Discover the joy of cultivating your own fresh produce with our Kitchen Gardening CPD Accredited Course. This course guides you through everything needed to create a flourishing garden, from the initial planning stages to the careful harvesting and storage of your crops. Whether you have a small balcony or a backyard, you’ll gain valuable insights into selecting the right vegetables and crops suited to your space and climate. Learn how to prepare your soil thoughtfully and establish healthy garden beds that promote strong growth and bountiful yields. With a focus on eco-friendly methods, this course also covers sustainable pest management techniques, helping you nurture your garden in harmony with nature. Throughout the modules, you’ll uncover best practices for maintaining your garden, ensuring it remains productive and vibrant across seasons. Designed for gardeners of all levels, this course offers a balanced mix of theory and practical advice, making it simple to bring your gardening ambitions to life from the comfort of home. Grow your knowledge and enjoy the satisfaction of fresh, homegrown produce all year round. Course Curriculum: Module 01: Introduction to Kitchen Gardening Module 02: Planning for Kitchen Gardening Module 03: Choosing Vegetables for Your Garden Module 04: Choosing Crops for Your Garden Module 05: Preparing Your Soil with Care Module 06: Preparing the Bed and Planting Your Crops Module 07: Maintaining your Garden and Best Practices Module 08: Practicing Eco-Friendly Pest Management Module 09: Harvesting Your Crops and Storing Safely Course Assessment You will immediately be given access to a specifically crafted MCQ test upon completing an online module. For each test, the pass mark will be set to 60%. Accredited Certificate After successfully completing this Kitchen Gardening - CPD Accredited course, you will qualify for the CPD Quality Standards (CPD QS) certified certificate from Training Express. CPD 10 CPD hours / points Accredited by The CPD Quality Standards (CPD QS) Who is this course for? The Kitchen Gardening - CPD Accredited training is ideal for highly motivated individuals or teams who want to enhance their skills and efficiently skilled employees. Requirements There are no formal entry requirements for the course, with enrollment open to anyone! Career path Learn the essential skills and knowledge you need to excel in your professional life with the help & guidance from our Kitchen Gardening - CPD Accredited training.

Kitchen Gardening - CPD Accredited Course
Delivered Online On Demand1 hour
£23

THE AUDIO BOOK Life's a Dance: A Ballroom Metaphor—Achieve Your Desires By Dancing To Your Natural Rhythm

By Ely Wellbeing

Discover Life’s A Dance: A Ballroom Metaphor by Evan Jeposa – an inspiring self-help guide that blends ballroom dancing with personal development. Learn how to overcome life’s challenges, build confidence, and unlock your potential using the transformative power of rhythm, balance, and connection. Explore practical tools like NLP to achieve success in life and relationships. Start your journey today! 💃 Life’s A Dance: A Ballroom Metaphor by Evan Jeposa is more than a book—it’s your guide to living with confidence, purpose, and rhythm! 🌟 Learn to overcome challenges, build meaningful connections, and break through life’s plateaus using the art of ballroom dancing and NLP techniques. Whether you’re a dancer or seeking personal growth, this book will inspire and empower you. Ready to lead your life’s dance? 💪📚 📖 Grab your copy now! 🎯 #LifesADance #SelfHelpBooks #PersonalGrowth #BallroomDancing #Motivation

THE AUDIO BOOK Life's a Dance: A Ballroom Metaphor—Achieve Your Desires By Dancing To Your Natural Rhythm
Delivered Online On Demand1 hour
$13.34

THE PDF BOOK Life's a Dance: A Ballroom Metaphor – Achieve Your Desires By Dancing To Your Natural Rhythm

By Ely Wellbeing

Discover Life’s A Dance: A Ballroom Metaphor by Evan Jeposa – an inspiring self-help guide that blends ballroom dancing with personal development. Learn how to overcome life’s challenges, build confidence, and unlock your potential using the transformative power of rhythm, balance, and connection. Explore practical tools like NLP to achieve success in life and relationships. Start your journey today! 💃 Life’s A Dance: A Ballroom Metaphor by Evan Jeposa is more than a book—it’s your guide to living with confidence, purpose, and rhythm! 🌟 Learn to overcome challenges, build meaningful connections, and break through life’s plateaus using the art of ballroom dancing and NLP techniques. Whether you’re a dancer or seeking personal growth, this book will inspire and empower you. Ready to lead your life’s dance? 💪📚 📖 Grab your copy now! 🎯 #LifesADance #SelfHelpBooks #PersonalGrowth #BallroomDancing #Motivation

THE PDF BOOK 
Life's a Dance: A Ballroom Metaphor – Achieve Your Desires By Dancing To Your Natural Rhythm
Delivered Online On Demand1 hour
$13.34

Adult Care Management Course

5.0(14)

By Training Express

The Adult Care Management Course is designed for those who aspire to lead and innovate within adult care settings, offering a thorough grounding in essential management principles. This course covers critical topics such as service development planning, effective communication, partnership working, and team support. It delves into safeguarding practices and the promotion of education within care environments, ensuring managers are well-equipped to handle the unique challenges that arise in adult care. Participants will also explore strategies to manage stress and maintain well-being, alongside approaches to overcome barriers common in care settings. Whether you are new to adult care management or seeking to broaden your understanding, this course provides insightful knowledge tailored for today’s care landscape. Delivered entirely online, it offers flexibility and depth, ideal for busy professionals looking to enhance their skills without needing to attend in person. This course is your opportunity to gain confidence and expertise in managing adult care services with professionalism and care-focused leadership. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to Adult Care Module 02: Creating a Service Development Plan Module 03: Importance of Communication Module 04: Partnership Working Module 05: Supporting and Encouraging the Team Module 06: Supporting Education in Adult Care Module 07: Safeguarding in Adult Care Module 08: Managing Stress and Maintaining Well-Being Module 09: Overcoming Barriers in Adult Care Settings Learning Outcomes: Enhance adult care skills for optimal service provision. Foster productive teamwork and communication in care settings. Develop a robust service development plan tailored to individual needs. Safeguard and protect adults, ensuring their well-being. Overcome common barriers encountered in adult care settings. Maintain personal well-being and manage stress effectively. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring adult care professionals Individuals seeking to upskill in the care industry Caregivers and support workers Healthcare assistants and volunteers Social workers and case managers Anyone passionate about enhancing adult care skills Career path Adult Care Coordinator Care Support Worker Social Care Assistant Community Support Worker Care Team Leader Safeguarding Officer Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Adult Care Management Course
Delivered Online On Demand1 hour
£12

SEO Masterclass

5.0(1)

By Course Gate

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This SEO Masterclass will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The SEO Masterclass will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to SEO Masterclass and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. Learning Objectives Learn the fundamental skills you require to be an expert Explore different techniques used by professionals Find out the relevant job skills & knowledge to excel in this profession Get a clear understanding of the job market and current demand Update your skills and fill any knowledge gap to compete in the relevant industry CPD accreditation for proof of acquired skills and knowledge Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited SEO Masterclass is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement Anyone interested in learning more about this subject should take this SEO Masterclass. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path The SEO Masterclass will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. Course Curriculum Section 01: SEO & Inbound Marketing Become a Master of Search Engine Optimization and Inbound Marketing Today 00:05:00 Transcending keywords and link building with a mindset of serving viewers and solving 00:10:00 How I get 2 5+ million impressions a month on Google and YouTube 00:19:00 How To Get 1,000 Clicks A Day From Google Organic Search 00:15:00 Top 25 SEO Tips for 2020! 00:23:00 Worst SEO strategies I have confirmed are terrible 00:11:00 Section 02: Building Connections Aiming for Lifetime Connections 00:07:00 Where to start Fix and improve what we see! 00:06:00 Play nice with others! Haters and competitors are friends! 00:08:00 Tutorials build a rock solid foundation 00:04:00 Entertain to keep people coming back and have fun 00:07:00 Stories stick with us 00:06:00 Long videos, posts, and descriptions ideal like Wikipedia 00:05:00 Section 03: Hosting and Optimization Scalable web host makes viral growth possible and high ranking easier 00:13:00 Email marketing helps build relationships and links naturally 00:12:00 Word Press Plug-in Setup + Best Dashboard Performance Settings 00:20:00 HTTPS is included as a ranking factor in Google 00:01:00 Ensure complete coverage of your own name in search results 00:05:00 Register your domain for a long time to show stability over time 00:04:00 Edit the date published when making any changes 00:02:00 Setup automatic sharing on social media to help get viewers 00:04:00 Section 04: Google Analytics Insights Google analytics introduction for beginners 00:04:00 Google analytics admin dashboard for account and property creation plus Ad Words link 00:07:00 Google analytics home dashboard from users, sessions, channel, and device 00:12:00 Site speed and suggestions to improve user experience and rank higher 00:09:00 Behaviour tab with all pages to see where more traffic is 00:05:00 Acquisition source medium and referrals for understanding how we get traffic 00:10:00 Conversion tracking and advanced features 00:04:00 Section 05: Google Webmaster Tools and Search Console Google webmaster tools settings to become a verified owner 00:03:00 New Google search console overview 00:04:00 Submit a Word Press XML sitemap fast with Yoast SEO plugin 00:03:00 Performance reports for queries, pages, countries, and devices 00:10:00 Welcome to the top! 00:03:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

SEO Masterclass
Delivered Online On Demand4 hours 21 minutes
£11.99

Red Hat Virtualization (RH318)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Linux system administrators, virtualization administrators, and hybrid infrastructure engineers interested in deploying large-scale virtualization solutions and managing virtual servers in their datacenters, based on the Red Hat Virtualization open virtualization management platform. Overview Configure Red Hat Virtualization Configure networking and storage for use with Red Hat Virtualization Manage user accounts and access to the Red Hat Virtualization environment Install and manage virtual machines in Red Hat Virtualization Use templates for rapid virtual machine deployment Manage virtual machine snapshots and images Migrate virtual machines and explore high-availability options Deploy, configure, manage, and migrate virtual environments Red Hat Virtualization (RH318) teaches you the skills needed to deploy, administer, and operate virtual machines in your organization using Red Hat© Virtualization. Through numerous hands-on exercises, you will demonstrate the ability to deploy and configure the Red Hat Virtualization infrastructure and use it to provision and manage virtual machines. This offering also prepares you for the Red Hat Certified Specialist in Virtualization exam. This course is based on Red Hat Enterprise Virtualization 4.3 and Red Hat Enterprise Linux© 7.6 and 8, as well as Red Hat Hyperconverged Infrastructure for Virtualization 1.6. 1 - Red Hat Virtualization overview Explain the purpose and architecture of Red Hat Virtualization. 2 - Install and configure Red Hat Virtualization Install a minimal Red Hat Virtualization environment and use it to create a virtual machine. 3 - Create and manage datacenters and clusters Organize hypervisors into groups using datacenters and clusters. 4 - Manage user accounts and roles Configure user accounts using a central directory service, then use roles to assign access to resources based on job responsibilities. 5 - Adding physical hosts Add additional Red Hat Virtualization hosts automatically, and move and remove hosts from datacenters as needed. 6 - Scale Red Hat Virtualization infrastructure Add Red Hat Virtualization hosts automatically, configure Red Hat Enterprise Linux hosts when appropriate, and move and remove hosts from data centers as needed. 7 - Manage Red Hat Virtualization networks Separate network traffic into multiple networks on one or more interfaces to improve the performance and security of Red Hat Virtualization. 8 - Manage Red Hat Virtualization storage Create and manage data and ISO storage domains. 9 - Deploy and manage virtual machines Operate virtual machines in the Red Hat Virtualization environment. 10 - Migrate virtual machines Migrate and control automatic migration of virtual machines. 11 - Manage virtual machine images Manage virtual machine snapshots and disk images. 12 - Automating virtual machine deployment Automate deployment of virtual machines by using templates and cloud-init. 13 - Back up and upgrade Red Hat Virtualization Back up, restore, and upgrade the software in a Red Hat Virtualization environment. 14 - Explore high-availability practices Explain procedures to improve the resilience and reliability of Red Hat Virtualization by removing single points of failure and implementing high-availability features. 15 - Perform comprehensive review Demonstrate skills learned in this course by installing and configuring Red Hat Virtualization; using the platform to create and manage virtual machines; and backing up and updating components of Red Hat Virtualization. Additional course details: Nexus Humans Red Hat Virtualization (RH318) 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 Red Hat Virtualization (RH318) 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.

Red Hat Virtualization (RH318)
Delivered OnlineFlexible Dates
Price on Enquiry

Red Hat High Availability Clustering (RH436)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for Senior Linux system administrators who use high-availability clustering and fault-tolerant shared storage technologies to maximize resiliency of production services. Overview Install and configure a Pacemaker-based high availability cluster. Create and manage highly available services. Troubleshoot common cluster issues. Work with shared storage (iSCSI) and configure multipathing. Implement Logical Volume Manager (LVM) in cluster-aware configurations. Configure GFS2 file systems on storage shared by multiple nodes. Deploy reliable, available critical production services in a high availability cluster In the Red Hat High Availability Clustering (RH436) course, you will learn how to provide highly available network services to a mission-critical enterprise environment through the deployment and management of shared storage and server clusters. Created for senior Linux system administrators, this 4-day course strongly emphasizes lab-based activities. You will set up a cluster of systems running the Pacemaker component of the Red Hat Enterprise Linux High-Availability Add-On, and deploy Linux-based services such as web servers and databases on that cluster. Cluster storage components from the Resilient Storage Add-On are also covered; installations and applications that require multiple cluster nodes can access the same storage simultaneously. This includes Logical Volume Manager (LVM) Shared Volume Groups, Red Hat Global File System 2 (GFS2), and Device-Mapper Multipath. This course is based on Red Hat Enterprise Linux 8.3. Prerequisites Red Hat Certified System Administrator (RHCSA) exam (EX200) and associated courses. Red Hat Cerfitied Engineer (RHCE) exam (EX294) and associated courses. 1 - Creating high availability clusters Create a basic high availability cluster. 2 - Managing cluster nodes and quorum Manage node membership in the cluster and describe how it impacts cluster operation. 3 - Isolating malfunctioning cluster nodes Isolate unresponsive cluster nodes to protect data and recover services and resources after a failure. 4 - Creating and configuring resources Create basic resources and resource groups to provide highly available services. 5 - Troubleshooting high availability clusters Identify, diagnose, and fix cluster issues. 6 - Automating cluster and resource deployment Deploy a new high availability cluster and cluster resources using Ansible automation. 7 - Managing two-node clusters Operate two-node clusters while identifying and avoiding issues specific to a two-node cluster configuration. 8 - Accessing iSCSI storage Configure iSCSI initiators on your servers to access block-based storage devices provided by network storage arrays or Ceph storage clusters. 9 - Accessing storage devices resiliently Configure resilient access to storage devices that have multiple access paths. 10 - Configuring LVM in clusters Select, configure, and manage the correct LVM configuration for use in your cluster. 11 - Providing storage with the GFS2 cluster file system Use the GFS2 cluster file system to simultaneously pProvide tightly coupled shared storage that can be accessed by multiple nodes. 12 - Eliminating single points of failure Identify and eliminate single points of failure in your cluster to decrease risk and increase average service availability. Note: Course outline is subject to change with technology advances and as the nature of the underlying job evolves. For questions or confirmation on a specific objective or topic, please contact a training specialist. Additional course details: Nexus Humans Red Hat High Availability Clustering (RH436) 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 Red Hat High Availability Clustering (RH436) 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.

Red Hat High Availability Clustering (RH436)
Delivered OnlineFlexible Dates
Price on Enquiry

CE131 IBM DB2 SQL Workshop for Experienced Users

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL. Overview Discuss basic relational database concepts Use some of the OLAP features of DB2, such as GROUPing and RANKing functions Create tables, views and indexes Use referential integrity, check constraints and triggers Use outer joins, and join tables to themselves Use CASE expressions, and the CAST function Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables Use complex subqueries Use a greater number of scalar SQL functions Use advanced SQL constructs, such as recursive SQL and table expressions Define User-Defined Distinct Types and User-Defined Functions Avoid several of the most common causes for poorly-performing SQL This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows. Introduction Identify the purpose of the clauses in the SELECT statement Describe the key differences among the IBM DB2 platforms Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and the RANK, DENSE_RANK and ROW_NUMBER functions Create Objects Code statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints Identify impacts and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define and make use of INSTEAD OF triggers Join Retrieve data from more than one table via inner and outer joins Use outer joins (LEFT, RIGHT, FULL) Use ANTI JOINS Join a table to itself Use UNION and UNION ALL Use EXCEPT and INTERCEPT CASE, CAST, Summary Tables, and Materialized Query Tables Identify when CASE expressions can be used Code CASE expressions in SELECT list and in the WHERE clause Identify when CAST specifications can be used Identify the advantages of using Summary (Materialized Query) Tables and Temporary tables Identify the advantages of using Materialized Query Tables (MQTs) Identify when and how to use Temporary tables Using Subqueries Code subqueries using the ALL, ANY/SOME, and EXISTS keywords Code correlated subqueries Choose the proper type of subquery to use in each case Scalar Functions Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data Examples of scalar functions that are addressed in this course: SUBSTR POSSTR COALESCE/VALUE DECIMAL ROUND DIGITS CHAR DATE/TIME Table Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQL Use nested and common table expressions Identify the difference between views and table expressions Code recursive SQL Control the depth of recursion when coding recursive SQL UDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored Procedures Predict when queries will use indexes to get better performance Identify concepts of predicate processing State introductory concepts about index structure State general best practices advice Additional course details: Nexus Humans CE131 IBM DB2 SQL Workshop for Experienced Users 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 CE131 IBM DB2 SQL Workshop for Experienced Users 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.

CE131 IBM DB2 SQL Workshop for Experienced Users
Delivered OnlineFlexible Dates
Price on Enquiry