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

3446 Design courses delivered Live Online

Crystal Reports 2016 - Part 2

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who know how to create basic list and group reports and need to create reports that include subreports, cross-tabs, advanced formulas, and charts based on more than one data series. They may also need to build tools that make it easier for other people to create reports. They may or may not have programming and/or SQL experience. Overview In this course, you will create complex reports using tools in Crystal Reports 2016. You will: Create automatic and manual running totals. Work with cross-tab reports. Add subreports. Create drill-downs in a report. Use SQL statements in report processing. Create complex formulas. Add charts to reports. Enhance report functionality. In this course, students will create complex reports & data sources using the tools in Crystal Reports 2016. Students will not only create more complex reports including sub-reports and cross-tabs, but will also increase their speed and efficiency. 1 - CREATING RUNNING TOTALS Topic A: Create a Running Total Field Topic B: Modify a Running Total Field Topic C: Create a Manual Running Total 2 - WORKING WITH CROSS-TABS Topic A: Create a Cross-Tab Report Topic B: Format a Cross-Tab Report Topic C: Create Groups in Cross-Tab Reports 3 - ADDING SUBREPORTS Topic A: Insert a Subreport Topic B: Edit a Subreport Topic C: Share Variables 4 - CREATING DRILL-DOWNS IN A REPORT Topic A: Create a Drill-Down Topic B: Create Headings for Drill-Down Data 5 - USING SQL STATEMENTS IN REPORT PROCESSING Topic A: Create a Report Using SQL Queries Topic B: Summarize Report Data Topic C: Create Joins Using SQL Topic D: Create Subqueries Topic E: Create an SQL Expression Field 6 - CREATING COMPLEX FORMULAS Topic A: Work with Loops Topic B: Work with Arrays 7 - ADDING CHARTS TO REPORTS Topic A: Create Charts Topic B: Create a Chart with Drill-Down Topic C: Create a Top N Chart Topic D: Create a Cross-Tab Chart Topic E: Create Charts for Grouped Data Topic F: Format a Chart Topic G: Create a Chart Template 8 - ENHANCING REPORT FUNCTIONALITY Topic A: Organize Data Based on a Hierarchy Topic B: Create a Dynamic Image Topic C: Create a Report Alert Topic D: Create a Geographic Map 9 - APPENDIX Appendix A: Managing Reports Appendix B: Processing Data on the Server Appendix C: Detecting and Fixing Problems

Crystal Reports 2016 - Part 2
Delivered OnlineFlexible Dates
£990

Get Confident with Zoom

5.0(50)

By Pochat Training

Get Confident with Zoom! 🎥💻 Join us for a series of hands-on 90-minute sessions designed to make online meetings and webinars stress-free. Each session focuses on a key feature—whether it’s hosting like a pro, managing breakout rooms, or making the most of Zoom’s hidden tools—so you’ll leave with practical skills you can use straight away.

Get Confident with Zoom
Delivered Online + more
£20

Advanced Programming Techniques with Python

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This course is designed for existing Python programmers who have at least one year of Python experience and who want to expand their programming proficiency in Python 3. Overview In this course, you will expand your Python proficiencies. You will: Select an object-oriented programming approach for Python applications. Create object-oriented Python applications. Create a desktop application. Create a data-driven application. Create and secure web service-connected applications. Program Python for data science. Implement unit testing and exception handling. Package an application for distribution.   Python continues to be a popular programming language, perhaps owing to its easy learning curve, small code footprint, and versatility for business, web, and scientific uses. Python is useful for developing custom software tools, applications, web services, and cloud applications. In this course, you'll build upon your basic Python skills, learning more advanced topics such as object-oriented programming patterns, development of graphical user interfaces, data management, creating web service-connected apps, performing data science tasks, unit testing, and creating and installing packages and executable applications. Selecting an Object-Oriented Programming Approach for Python Applications Topic A: Implement Object-Oriented Design Topic B: Leverage the Benefits of Object-Oriented Programming Creating Object-Oriented Python Applications Topic A: Create a Class Topic B: Use Built-in Methods Topic C: Implement the Factory Design Pattern Creating a Desktop Application Topic A: Design a Graphical User Interface (GUI) Topic B: Create Interactive Applications Creating Data-Driven Applications Topic A: Connect to Data Topic B: Store, Update, and Delete Data in a Database Creating and Securing a Web Service-Connected App Topic A: Select a Network Application Protocol Topic B: Create a RESTful Web Service Topic C: Create a Web Service Client Topic D: Secure Connected Applications Programming Python for Data Science Topic A: Clean Data with Python Topic B: Visualize Data with Python Topic C: Perform Linear Regression with Machine Learning Implementing Unit Testing and Exception Handling Topic A: Handle Exceptions Topic B: Write a Unit Test Topic C: Execute a Unit Test Packaging an Application for Distribution Topic A: Create and Install a Package Topic B: Generate Alternative Distribution Files Additional course details: Nexus Humans Advanced Programming Techniques with Python 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 Advanced Programming Techniques with Python 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.

Advanced Programming Techniques with Python
Delivered OnlineFlexible Dates
Price on Enquiry

BSL Training for Workplace – CPD Certified | Live Zoom Class [Business Customers Only]

By Lead Academy

This course will help you and your employees gain the necessary vocabulary, grammar, and conversational abilities from our qualified instructors. Additionally, our interactive lessons and hands-on activities will improve your BSL proficiency and comprehension. This Course At A Glance Live Zoom classes with an expert BSL tutor, Adam Linsdell. Gain an extensive understanding of deaf awareness. Acquire knowledge of several commonly used vocabulary words. CPD Accredited certificates are recognized by employers and professional organisations. Enhance your communication skills through practical exercises. BSL Training Course Overview This BSL training course, CPD certified workplace oriented classes, is an immersive 18-hour duration (3 hours per week) course designed to enhance your communication skills with deaf colleagues and customers in a specific workplace setting. This comprehensive program will equip you with the necessary tools to establish effective interactions and bridge the communication gap. Throughout the course, you will learn essential vocabulary, grammar, and conversational skills in British Sign Language (BSL). Additionally, you will gain insights into deaf culture and develop a deeper understanding of the challenges faced by individuals with hearing impairments in the workplace. By the end of this course, you will be able to confidently communicate using BSL and contribute to a more inclusive and accessible work environment. BSL Training for Workplace, Autumn 2025 Please book your place in advance Weekly via Zoom Online Live Class. You can attend the class online from home/workplace. Total Duration: 18 Hours Class Starts: August 08, 2025-October 10, 2025 Day & Time: 10:00 am – 12:00 pm (Thursday, 2 hours per week) Venue: Zoom Online Teacher: Adam Linsdell Who should take this course? BSL for the Workplace is perfect for individuals, employees, large or small businesses. Those who are seeking to improve their communication with deaf colleagues and customers in their professional environment can opt for this course. Whether you work in health and healthcare, retail and shopping, hospitality, cultural settings, or public services, this course will provide you with the skills needed to connect and engage with the deaf community. Learning Outcomes: Upon completing the BSL for the Workplace course, participants will achieve the following learning outcomes: Learn fingerspelling alphabets and words with accuracy Develop simple conversations and confidently ask questions on a range of everyday topics Fostering meaningful interactions with deaf colleagues and customers. Demonstrate basic vocabulary related to various topics, allowing for effective expression of ideas and needs. Discover workplace-specific vocabularies relevant to their professional setting Help you engage in specialised conversations and enhance workplace communication. Invest in your communication skills and create an inclusive workplace environment. Enrol in a BSL training course CPD certified workplace oriented classes today and unlock new opportunities for effective communication with the deaf community. Course Curriculum Greetings Learn essential BSL greetings to initiate conversations and create a welcoming atmosphere. These greetings include basic phrases such as “hello,” “good morning,” “how are you?” and more which are essential for establishing rapport and building relationships with deaf individuals. The BSL Alphabet and Fingerspelling Master the BSL alphabet and develop the ability to fingerspell words accurately, enabling effective communication of names, technical terms, and unfamiliar vocabulary. This skill is particularly useful in situations where there may be unfamiliar vocabulary or technical terms that need to be spelled out. Meeting People / Questions Enhance your conversational skills by learning how to introduce yourself, engage in small talk, and ask questions in BSL. These skills will allow you to confidently interact with Deaf individuals and create meaningful connections. Additionally, understanding how to ask questions in BSL will enable you to gather information and participate actively in conversations. Numbers and Number Related Vocabulary Acquire the knowledge to express age, money, and dates accurately in BSL, enabling seamless interactions in various contexts. Mastering numbers and number-related vocabulary in BSL will also help you navigate everyday situations such as shopping, making appointments, and discussing schedules. Being able to accurately express age, money, and dates will enhance your ability to communicate effectively and independently in the Deaf community. Transport / Travel Explore BSL vocabulary related to transportation and travel, enabling you to provide clear directions and discuss travel arrangements. You will learn signs for different modes of transportation such as cars, buses, trains, and aeroplanes, as well as how to ask for and give directions. Additionally, you will be able to discuss travel plans, including booking tickets and discussing itineraries. Telling the Time / Calendar Develop proficiency in expressing time and discussing calendar events in BSL, ensuring effective scheduling and time management. You will also become familiar with discussing different calendar events such as birthdays, holidays, and appointments. This will enable you to effectively manage your schedule and plan your activities accordingly. Weather Expand your vocabulary to discuss weather conditions, enabling you to engage in casual conversations and make relevant inquiries. This skill will also allow you to understand weather forecasts and prepare for any upcoming changes in the weather. Colours Learn the BSL signs for various colours, facilitating discussions about visual elements and enhancing your ability to describe objects accurately. This knowledge will enable you to express yourself more effectively and engage in a wider range of conversations. Describing People Develop the skills to describe individuals’ appearance and characteristics in BSL, allowing you to effectively communicate observations and share information. This skill will not only enhance your ability to interact with deaf individuals but also improve your overall communication skills. Additionally, being able to describe people accurately in BSL can help you navigate social situations and build stronger connections with others. Directions Master directional vocabulary in BSL, empowering you to provide clear instructions and navigate through spaces confidently. This skill will also boost your confidence when navigating unfamiliar spaces, as you will have the ability to clearly communicate directions and understand them yourself. Workplace-Specific Vocabulary Discover workplace-specific vocabulary tailored to your professional setting, such as health and healthcare, retail and shopping, hospitality, cultural settings, and public services. Use this vocabulary to develop simple conversations and strengthen your workplace communication skills. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Certificate of Achievement Certificate of Achievement from Lead Academy After successfully completing the live training, you will be eligible to receive your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version as well as hardcopy version at a free of cost.

BSL Training for Workplace – CPD Certified | Live Zoom Class [Business Customers Only]
Delivered OnlineFlexible Dates
£1,250

Building High-Performance Teams: In-House Training

By IIL Europe Ltd

Building High-Performance Teams: In-House Training This course pulls together the most current and popular theories and writings on this complex topic and presents this amalgamated view in a highly interactive workshop and activity-based approach. Students will understand and have the skills required to build and participate in high-performance project teams and will possess the insight to proactively affect change within their respective organizations by guiding the existing culture to one that promotes high performance. What you will Learn At the end of this program, you will be able to: Define a team and describe the optimum team size for effective performance Describe characteristics and guiding behaviors of high-performance teams Describe the major elements of each development stage in two distinct models Recognize cultural barriers in achieving high performance List the attributes of a high-performing corporate culture Assess your own corporate culture Discuss corporate leadership as a factor in building high-performance project teams Describe the three A's of selecting team members State three leadership responsibilities Describe leadership responsibilities, styles, and roles List and describe the eight components of the team charter model for building high-performance teams Foundation Concepts The Nature of Teams Characteristics of High-Performance Teams Understanding Team Development Stages of Team Development - Model 1 Stages of Team Development - Model 2 Designing a High-Performance Culture Corporate Cultures Corporate Leadership Establishing the Attributes of High Performance Choosing the Right People Team Effectiveness Team Leadership The Team Charter Model

Building High-Performance Teams: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,295

Effective Negotiation Skills for Business Success: In-House Training

By IIL Europe Ltd

Effective Negotiation Skills for Business Success: In-House Training Become skillful at dealing with unworkable differences - situations where there appears to be no acceptable compromise or acceptable solution. This interactive workshop shows you how to work towards agreements where all parties are satisfied that they have reached a wise outcome efficiently, and where they can come back to the table in the future because the relationship is intact. You will have the opportunity to re-visit a difficult / challenging negotiation that you experienced in the past as well as take part in progressively more challenging case studies that are tailored to the work you do. You will enhance your personal and professional life with powerful new negotiating skills. The goal of this workshop is to improve your negotiation skills by helping you to identify your own preferred negotiation style and strategies, and to learn about the need to plan for any upcoming negotiation. The workshop is also designed for you to experience typical negotiation situations at certain key points of the life cycle of a project, enabling you to develop an awareness of your effectiveness during negotiations at these stages. The majority of time is spent on practicing newly presented negotiation techniques and receiving feedback on application for further development and improvement. What you will Learn At the end of this program, you will be able to: Identify your preferred negotiation style and strategies Examine the Principled Negotiation Model Adapt your negotiation strategy to the progress of the negotiation Experience typical negotiation situations during the life cycle of a project Develop an awareness of your effectiveness during negotiations Improve your negotiation skills Negotiation Model Negotiation defined Negotiation phases Common approaches to negotiating Principled Negotiating Principled negotiation and the four rules Best alternative to a negotiated agreement Project Negotiation Simulation: Part 1 and Part 2 Project Negotiation Simulation: Part 1 Project Negotiation Simulation: Part 2 Negotiating Cases Negotiating cases

Effective Negotiation Skills for Business Success: In-House Training
Delivered in London or UK Wide or OnlineFlexible Dates
£1,295

Mac Support for PC Technicians

By Influential Training

Mac Support for PC, PC and Mac Support, PC to Mac support

Mac Support for PC Technicians
Delivered OnlineFlexible Dates
£1,045

BOX310 SAP BusinessObjects Dashboards 4.1

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for The primary audience for this course are Application Consultants, Business Analysts, and Business Process Owners/Team Leads/Power Users. In this course, students are enabled to transform Excel workbooks into captivating dashboards for executives and business users. Introduction to Dashboards Creating Interactive Dashboards Using an Embedded Excel Workbook in the Dashboard Data Visualizations with Charts Using Data in a Range Using Data in a Series Preparing Future Data by Ignoring End Blanks Dashboard Distribution Distributing a Dashboard Single Value Components Using Single Value Components Alerts Setting Up Alerts Selectors Using Selectors Setting Default Values for Selectors Selecting Multiple Items Common Components Using Images in a Dashboard Using Tables in a Dashboard Using an Interactive Calendar in a Dashboard Adding a URL to a Dashboard Components Used as Selectors Using the Chart Component as a Selector Using the Map Component as a Selector Format Options Configuring Proportional Size and Position Using Themes to Apply Formats Using Templates to Apply Formats Applying Globalization Dynamic Visability Adding Dynamic Visibility Using Formulas to Create Dynamic Visibility Creating Multi-Layer Dashboards Dashboard Design Optimization Optimizing Dashboard Design Dashboard Connection to Live Data Using Live Data Sources Setting Up an XML Connection Using Web Services to Connect to Data Using the Query Browser to Connect to Data Using the Portal Data Connection to Connect to Data Additional course details: Nexus Humans BOX310 SAP BusinessObjects Dashboards 4.1 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 BOX310 SAP BusinessObjects Dashboards 4.1 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.

BOX310 SAP BusinessObjects Dashboards 4.1
Delivered OnlineFlexible Dates
Price on Enquiry

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

KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek techniques for working with complex types of data resources. Overview Use Connector stages to read from and write to database tables Handle SQL errors in Connector stages Use Connector stages with multiple input links Use the File Connector stage to access Hadoop HDFS data Optimize jobs that write to database tables Use the Unstructured Data stage to extract data from Excel spreadsheets Use the Data Masking stage to mask sensitive data processed within a DataStage job Use the Hierarchical stage to parse, compose, and transform XML data Use the Schema Library Manager to import and manage XML schemas Use the Data Rules stage to validate fields of data within a DataStage job Create custom data rules for validating data Design a job that processes a star schema data warehouse with Type 1 and Type 2 slowly changing dimensions This course is designed to introduce you to advanced parallel job data processing techniques in DataStage v11.5. In this course you will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, you will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, you will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course. Accessing databases Connector stage overview - Use Connector stages to read from and write to relational tables - Working with the Connector stage properties Connector stage functionality - Before / After SQL - Sparse lookups - Optimize insert/update performance Error handling in Connector stages - Reject links - Reject conditions Multiple input links - Designing jobs using Connector stages with multiple input links - Ordering records across multiple input links File Connector stage - Read and write data to Hadoop file systems Demonstration 1: Handling database errors Demonstration 2: Parallel jobs with multiple Connector input links Demonstration 3: Using the File Connector stage to read and write HDFS files Processing unstructured data Using the Unstructured Data stage in DataStage jobs - Extract data from an Excel spreadsheet - Specify a data range for data extraction in an Unstructured Data stage - Specify document properties for data extraction. Demonstration 1: Processing unstructured data Data masking Using the Data Masking stage in DataStage jobs - Data masking techniques - Data masking policies - Applying policies for masquerading context-aware data types - Applying policies for masquerading generic data types - Repeatable replacement - Using reference tables - Creating custom reference tables Demonstration 1: Data masking Using data rules Introduction to data rules - Using the Data Rules Editor - Selecting data rules - Binding data rule variables - Output link constraints - Adding statistics and attributes to the output information Use the Data Rules stage to valid foreign key references in source data Create custom data rules Demonstration 1: Using data rules Processing XML data Introduction to the Hierarchical stage - Hierarchical stage Assembly editor - Use the Schema Library Manager to import and manage XML schemas Composing XML data - Using the HJoin step to create parent-child relationships between input lists - Using the Composer step Writing Hierarchical data to a relational table Using the Regroup step Consuming XML data - Using the XML Parser step - Propagating columns Topic 6: Transforming XML data - Using the Aggregate step - Using the Sort step - Using the Switch step - Using the H-Pivot step Demonstration 1: Importing XML schemas Demonstration 2: Compose hierarchical data Demonstration 3: Consume hierarchical data Demonstration 4: Transform hierarchical data Updating a star schema database Surrogate keys - Design a job that creates and updates a surrogate key source key file from a dimension table Slowly Changing Dimensions (SCD) stage - Star schema databases - SCD stage Fast Path pages - Specifying purpose codes - Dimension update specification - Design a job that processes a star schema database with Type 1 and Type 2 slowly changing dimensions Demonstration 1: Build a parallel job that updates a star schema database with two dimensions Additional course details: Nexus Humans KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing 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 KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing 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.

KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing
Delivered OnlineFlexible Dates
Price on Enquiry