1324 Editor courses delivered Online

Duration 2 Days 12 CPD hours This course is intended for Developers & Developer Consultants Overview Learn simple ABAP codeTrace the flow of a program and troubleshoot simple problems In this course, students will learn simple ABAP code. Basics of ABAP Programming Developing a Simple ABAP Program Introducing ABAP Syntax Implementing a Simple Dialog Customizing the ABAP Editor Coding & Debugging in ABAP Defining Simple Variables Defining Text Symbols Performing Arithmetic Operations Using Simple Variables Using System Variables Debugging a Program Creating an ABAP List Processing Character Strings Current Flow Structures in ABAP Implementing Conditional Logic Implementing Loops Runtime Errors & Error Handling Analyzing Runtime Errors Implementing Error Handling Additional ABAP Programming Techniques Retrieving Data From the Database Describing Modularization in ABAP Using Function Modules Additional course details: Nexus Humans BC100 SAP Introduction to Programming with ABAP 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 BC100 SAP Introduction to Programming with ABAP 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.

Acceptance and Commitment CBT

What is this webinar about? Chronic physical illness is a significant risk factor for psychological symptoms, disorders and self-harm. However, evidence shows that Cognitive Behavioural Therapy can improve wellbeing for clients with chronic physical illnesses. This workshop looks at practical aspects of the use of CBT as part of the support and management of chronic physical illness and associated anxiety and depression. Key Topics (indicative) Overview CBT and Chronic Conditions Potential indications for the use of CBT in patients with chronic physical illness The Psychological Flexibility Model Examples Diabetes ME/CFS/SEID Pain Management Disability and WHODAS 2.0 Summary What have previous delegates said about similar webinars? Great workshop and lots of practical techniques to help my clients. Spot on - relevant to current (and future) client work. Recognised self and past clients in the material. Better understanding of rules v assumptions. Use of positives interesting. Great practical tools and techniques discussed, a lot of variation in presentation making it enjoyable and engaging. The dynamic model of low self esteem was particularly helpful for understanding LSE and how it can be treated. "It was fun. a very entertaining trainer. Good use of humour." "Loved the multimedia presentation". "Useful professionally and personally. Very enjoyable - lots of takeaway resources" "Fun, lively presentation . Two-way experience between the facilitator and the group. Very informative and enjoyable." "Excellent workshop. Informative, interesting, well presented. It was excellent." "Excellent course; excellent presentation; easy to understand". "Good balance of information and lots of useful practical ideas to use. Thank you!" "I enjoyed this training and the facilitator was very attentive and engaging with the training". "Clearly a knowledgeable and experienced facilitator. Helpful to be signposted to resources". "Good mix of presentation, discussion and exercises" "An engaging workshop with clear practical applications." "Excellent delivery and well explained. Articulate explanations of concepts. Great. Thanks!" Who is leading this webinar? Professor Patrick McGhee is a CBT therapist, psychologist and UK National Teaching Fellow. Educated at the universities of Glasgow and Oxford, he has completed CPD programmes at Harvard Business School and Ashridge. In 2017 he was a Visiting Fellow/Scholar at the universities of Cornell, Yale and MIT in the USA. He has taught, researched or practised in psychology and therapy for 30 years. His first post was a Research Fellow in Psychiatry and Psychology at St George's Hospital Medical School, University of London. He is the author of Thinking Psychologically (Palgrave) and co-editor of Accounting for Relationships (Methuen). He is an occasional columnist for the Guardian, the BBC and the Times Higher. He currently works in private practice in Greater Manchester. He has full accreditation from the British Association for Behavioural and Cognitive Psychotherapies. Who should attend? This workshop is aimed at therapists, counsellors, advisers, educationalists, health care workers, social workers and students in these areas. It is particularly useful for counsellors who do not normally work within a cognitive or behavioural model but want to explore tried and tested techniques. Similarly, counsellors and therapists working within this tradition are likely to find this workshop a useful refresher in the latest approaches. It is also suitable for anyone with an interest in contemporary practice in this area. Resources A full set of slides, with extensive clickable links to free online resources, is sent free to all delegates after the event. This also includes references to key sources and further reading. Additionally, an anonymous summary of participant contributions is provided free of charge. CPD A CPD Certificate of Attendance confirming 2 hours skills CPD is available free on request to all delegates who attend.

Linux Troubleshooting and Administration

Description: Adobe Premiere Pro CC is a robust, customizable, nonlinear video editor program. We are offering you a high-quality, comprehensive certificate course designed to help you master the techniques of Adobe Premiere Pro CC. Getting started with Adobe Premiere Pro CC might be difficult for amateurs, however, this course will certainly help you in making it accessible and approachable. From newbie to seasoned online entrepreneur can benefit from this process to learn editing videos in Adobe Premiere Pro. Through this Adobe Premiere Pro CC 2017 Complete Training course, you will introduce to the fundamental editing techniques, and learn the various panel windows to editing clips together, including audio work, creating sequence presets, titles, keyboard shortcuts, colour correction, exporting media and much more. Upon completion of the course, you will be able to get started with Adobe's video editing program and create appealing visual and audio stories like a pro. Who is the course for? You are a video creator (or want to make videos), and are wanting to edit videos with THE BEST video editing application today. You might know how to edit with Final Cut, iMovie, Sony Vegas, Premiere Elements, Windows Movie Maker, Camtasia, Screenflow, etc. But you want to transition to editing with Premiere Pro. You are a complete beginner who has never opened Premiere Pro (or have never learned how to use it properly). You have played around with Premiere Pro, but need some help becoming a more efficient editor. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Adobe Premiere Pro CC 2017 Complete Training 0 Adobe Premiere Pro CC Course Promo FREE 00:02:00 Introduction 1.1 Premuere Pro Course Intro - UPDATED 1 00:02:00 1.2 Quick Win - Stabilize ShakyVideo 00:04:00 1.2 Starting a New Project and Premiere Pro Orientation - UPDATE 1 00:13:00 1.3 Importing and Organizing 00:07:00 1.4 Quick win n_ Stablize your Videos 00:03:00 1.5 OPTIONAL - Use Media Browser to import Clips 00:02:00 Editing Your Video 2.1 Starting a New Sequence and Understanding the Timeline - UPDATE 1 00:06:00 2.2 Adding Clips to the Timeline, Syncing Footage, and Making Selects 00:12:00 2.3 Exercise - Syncing Video and Audio - UPDATE 1 00:01:00 2.4 Exercise Review - Syncing Video and Audio - UPDATE 1 00:03:00 2.5 Editing Tools 00:16:00 2.6 Adding bRoll Footage to Your Video 00:11:00 2.7 Adjusting Clip Size and Position - UPDATE 1 00:04:00 2.8 REVIEW Adjusting Clip Size and Position - UPDATE 1 00:00:00 2.9 Bonus - Editing Down an Interview - UPDATE 1 00:35:00 PP 2.10 Editing a Narrative Scene 00:11:00 Adding Video and Audio Transitions 3.1 Course Check In 00:01:00 3.2 Adding Video Transitions - UPDATE 1 00:08:00 3.3 Review Video Transitions - UPDATE 1 00:02:00 3.4 Adding Audio Transitions - UPDATE 1 00:04:00 3.5 Exercise - Create a Custom Blur Transition 00:07:00 PP 3.6 Trouble with Transitions 00:07:00 Adding Titles in Premiere Pro CC 2017.2 and 2018 4.1 Adding and Editing Titles 00:08:00 4.2 Create a Clean Lower Third Title 00:06:00 4.3 Create Scrolling End Credits 00:04:00 4.4 Exercise - Design Your Own Lower Third Titles 00:01:00 4.5 Exercise Review - Design Your Own Lower Third Titles 00:11:00 Adding Titles in Premiere Pro CC 2017.1 and Older 5 Tips for Beginner Video Editors 00:08:00 5.1 Adjusting Audio Levels in Premiere Pro 00:10:00 5.2 Adjusting Audio Channels 00:05:00 5.3 Fixing Audio with the Low and High Pass Filters 00:04:00 5.4 Improving Audio with EQ (Equalization) 00:08:00 5.5 Adjusting Audio Tracks with Effects 00:02:00 5.6 Exercise - Fixing Bad Audio 00:01:00 5.7 Exercise Review - Remove Bad Background Noise 00:05:00 5.8 Adding Music to Your Project and Making a Song Shorter 00:11:00 5.9 Easily Removing Background Noise with Audacity 00:05:00 Editing Audio PP 6.1 Color Correction with Lumetri Basics 00:09:00 PP 6.2 Exercise - Fix White Balance UPDATE 00:01:00 PP 6.3 Exercise Review - Fix White Balance UPDATE 00:03:00 PP 6.4 Creative Tab - Lumetri Color 00:06:00 PP 6.5 Curves Tab - Lumetri Color 00:04:00 PP 6.6 Color Wheels - Lumetri Color 00:02:00 PP 6.7 HSL Secondary - Lumetri Color 00:04:00 PP 6.8 Vignette - Lumetri Color 00:03:00 PP 6.9 Exercise - Matching Exposure 00:01:00 Color Correction and Grading 7.1 Adding Motion to Title Graphics 00:05:00 7.2 Add the Ken Burns Effect to Photos 00:02:00 7.3 Exercise - Add Motion to Video to Make it More Dynamic 00:01:00 7.4 Exercise Review - Add Motion to Video to Make it More Dynamic 00:06:00 7.5 OPTIONAL Adding Motion to Screenshots 00:08:00 Motion in Premiere Pro 8.1 Exporting a High-Quality, Small File-Size Video 00:09:00 PP 8.2 OPTIONAL - Export Settings - In Depth Review 00:12:00 8.3 Export a Full Resolution Video 00:01:00 8.4 Exporting Small File-Size Preview Video 00:02:00 8.5 Practice Exercise - Finish Course Project 00:01:00 Exporting Your Video 9.1 Adding and Adjusting Effects to Your Video Clips 00:07:00 9.2 Adjusting Effects with Keyframes 00:05:00 9.3 Using Lumetri Color Presets 00:04:00 9.4 Stabilize Shaky Footage with Warp Stabilizer 00:05:00 9.5 Exercise - Stabilize Shaky Video 00:01:00 9.6 Exercise Review - Stabilize Shaky Video 00:03:00 9.7 Make Footage More Cinematic with Overlays 00:07:00 9.8 Capture Still Images from Video 00:02:00 9.9 EXERCISE - Remove Noise and Grain from Video Clip UPDATED 00:07:00 Visual Effects and Advanced Premiere Pro Tips 10.1 Adjusting Clip Speed 00:05:00 10.2 Time Remapping and Speed Ramps 00:04:00 10.3 Slow Motion Video By Interpreting Frame Rates 00:02:00 10.4 Exercise - Speed Ramps 00:01:00 10.5 Exercise Review - Speed Ramps 00:01:00 Green Screen Editing - Chromakeying in Premiere Pro 11.1 Green Screen Tutorial (ChromaKeying) in Premiere Pro 00:08:00 11.2 Adding a Background to Green Screen Video 00:06:00 Conclusion 12.1 Conclusion 00:01:00 Resource Files Resource Files - Adobe Premiere Pro CC 2017 Complete Training 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Proofreading: Proofreading & Copy Editing Course Online If you have good grammar and writing skills and want to become a skilled proofreader, this Proofreading: Proofreading & Copy Editing Course is perfect. While scanning digital and offline content on various subject matters, you will become an expert in tracking errors. This comprehensive Proofreading: Proofreading & Copy Editing Course will teach you how to use effective editing tools like checking content for spelling, punctuation, and grammar mistakes, as well as basic formatting. The Proofreading: Proofreading & Copy Editing Course will also teach you tips and tricks for fast and efficient proofreading, ensuring that no errors are overlooked. After completing this Proofreading: Proofreading & Copy Editing Course, you will have the practical knowledge and skills to pursue a wide range of career opportunities in the field of proofreading. Special Offers of this Proofreading: Proofreading & Copy Editing Course This Proofreading: Proofreading & Copy Editing Course includes a FREE PDF Certificate. Lifetime access to this Proofreading: Proofreading & Copy Editing Course Instant access to this Proofreading: Proofreading & Copy Editing Course Get FREE Tutor Support from Monday to Friday in this Proofreading: Proofreading & Copy Editing Course Main Course: Level 5 Proofreading & Copy Editing Courses are Included in this Proofreading: Proofreading & Copy Editing Course Course 01: Level 4 Time Management Course Course 02: Anger Management [ Note: Free PDF certificate as soon as completing the Proofreading: Proofreading & Copy Editing Course] Proofreading: Proofreading & Copy Editing Course Online Industry Experts Designed this Proofreading: Proofreading & Copy Editing Course into 10 detailed modules. Course Curriculum of Proofreading & Copy Editing Course Module 01: An Overview of Proofreading Module 02: Use of the Style Guide Module 03: Spelling and Grammar Module 04: Paper-based Proofreading Module 05: On the Screen Proofreading Module 06: Basics of Copy Editing Module 08: Copy Editing - Checking Accuracy and Facts Module 9: Copy Editing - Legal Checks Module 10: Career Development Assessment Method of Proofreading Copy Editing After completing each module of the Proofreading: Proofreading & Copy Editing Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Proofreading Copy Editing After completing the MCQ/Assignment assessment for this Proofreading: Proofreading & Copy Editing Course, you will be entitled to a Certificate of Completion from Training Tale. Who is this course for? Proofreading: Proofreading & Copy Editing Course Online This Proofreading: Proofreading & Copy Editing Course is ideal for those who want to improve their proofreading & copy-editing skills and prepare for the job of their dreams! Requirements Proofreading: Proofreading & Copy Editing Course Online Students who intend to enrol in this Proofreading: Proofreading & Copy Editing Course must meet the following requirements: Proofreading: Good command of the English language Proofreading: Must be vivacious and self-driven Proofreading: Basic computer knowledge Proofreading: A minimum of 16 years of age is required Career path Proofreading: Proofreading & Copy Editing Course Online Candidates who complete the Proofreading: Proofreading & Copy Editing Course can pursue a wide range of jobs, including: Proofreader - Average income between £43K - £56K Copy Editor - Average income between £27K - £44.5K Content Writer - Average income between £44k - £58k Certificates Certificate of completion Digital certificate - Included

Overview From blog writing to technical writing, good non-fiction writing skills can open new doors of possibilities for your career. Master the art of non-fictional writing with our Non-Fiction Writing Essentials course. This course will allow you to acquire the skills you need to start non-fiction writing.  Through the course, you will get an overall understanding of non-fiction writing. The informative course will show you how to conduct research on non-fiction writing. You will also be able to grasp valuable writing techniques and craft complaining pieces. In addition, you will also acquire the skills for proofreading and editing. Finally, the course will help you understand the essentials of publishing and marketing non-fiction writing.  This course is the perfect training ground for aspiring professionals in this area. So, if you are ready to embark on the journey of non-fictional writing, enrol now! Course Preview Learning Outcomes Learn about different types of non-fiction writing Understand how to conduct research for non-fictional writing Grasp effective non-fictional writing techniques Develop the skills to proofread and edit your copies Understand the essentials of publishing and marketing non-fictional writings Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Meticulously crafted engaging and informative tutorial videos and materials Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email What Skills Will You Learn from This Course? Non-fictional writing Editing Publishing Marketing Who Should Take this Non-Fiction Writing Essentials? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Non-Fiction Writing Essentials course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Non-Fiction Writing Essentials Certification After completing and passing the Non-Fiction Writing Essentials course successfully, you will be able to obtain a Recognised Certificate of Achievement. Learners can obtain the certificate in hard copy at £14.99 or PDF format at £11.99. Career Path​ This exclusive Non-Fiction Writing Essentials course will equip you with effective skills and abilities and help you explore career paths such as  Copy-writer Content writer Technical writer Journalist Editor Module 01: Introduction to Non-Fiction Writing Introduction to Non-Fiction Writing 00:16:00 Module 02: Crafting Compelling Non-Fiction Narratives Crafting Compelling Non-Fiction Narratives 00:14:00 Module 03: Researching Creative Non-Fiction Researching Creative Non-Fiction 00:22:00 Module 04: Writing Techniques for Non-Fiction Genres Writing Techniques for Non-Fiction Genres 00:20:00 Module 05: Editing and Revising Editing and Revising 00:19:00 Module 06: Publishing and Marketing Publishing and Marketing 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Solid skills in interactive media design can be the turning point for your career in the interactive media industry. Grab the chance to secure this valuable skill set without stepping out of your house with our Interactive Media Design Course. Through this comprehensive course you will receive an in-depth understanding of interactive media design. The informative modules will educate you on the difference between UX and UI. along with that, you will be able to grasp a solid understanding of media tools and technologies and multimedia integration. By the end of this course, you will acquire the ability to design multiple platforms. So, if you are ready to take your skills to the next level enrol now! Course Preview Learning Outcomes Introduce yourself to the fundamentals of interactive media design Understand the differences between UX and UI Learn about interactive media tools and technologies Grasp the process of multimedia integration Develop the skills for designing multiple platforms Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? UX design UI design Multimedia integration Who Should Take This Interactive Media Design Course? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Interactive Media Design Course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Interactive Media Design Course will equip you with effective skills and abilities and help you explore career paths such as  Wed Designer Animator Digital Marketer Video Editor Module 01: Introduction to Interactive Media Design Introduction to Interactive Media Design 00:19:00 Module 02: Principles of Design Principles of Design 00:17:00 Module 03: User Experience (UX) and User Interface (UI) Design User Experience (UX) and User Interface (UI) Design 00:18:00 Module 04: Interactive Media Tools and Technologies Interactive Media Tools and Technologies 00:21:00 Module 05: Multimedia Integration Multimedia Integration 00:16:00 Module 06: Interactive Storytelling Interactive Storytelling 00:13:00 Module 07: Designing for Multiple Platforms Designing for Multiple Platforms 00:21:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Overview Explore the exciting world of children's literature with our premium Children's Literature Masterclass. Whether you are a parent or a professional in the relevant industry, this course is the perfect place to level up your knowledge in this area. In this course, you will learn about the theories of child development and literature. The course will enhance your understanding of different genres in child literature. In addition, you will learn about the major authors and their famous works. The course will also discuss diversity and representation portrayed in children's books. Here, you will also be able to view the literature through a critical approach. After completing the course, you will receive a recognised certificate of achievement. This certificate will help you add extra value to your resume and help you explore career options in the relevant fields. Enrol now! Course Preview Learning Outcomes Familiarise yourself with theories of child development and literature Learn about different genres in child literature Gain deep knowledge about the most famous authors in children's literature Understand the diversity and representation in children's books Deepen your knowledge of the critical approaches to children's literature Why Take This Course From John Academy? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result Earn UK & internationally recognised accredited qualification Easily access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities Get 24/7 student support via email. What Skills Will You Learn from This Course? Explore Children Literature Who Should Take this Children's Literature Masterclass? Whether you're an existing practitioner or an aspiring professional, this course is an ideal training opportunity. It will elevate your expertise and boost your CV with key skills and a recognised qualification attesting to your knowledge. Are There Any Entry Requirements? This Children's Literature Masterclass course is available to all learners of all academic backgrounds. But learners should be aged 16 or over to undertake the qualification. And a good understanding of the English language, numeracy, and ICT will be helpful. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path​ This exclusive Children's Literature Masterclass course will equip you with effective skills and abilities and help you explore career paths such as  Author Publisher Content Writer Editor Module 01: Introduction to Children's Literature Introduction to Children's Literature 00:20:00 Module 02: Classic Children's Literature Classic Children's Literature 00:19:00 Module 03: Children's Literature Genres Children's Literature Genres 00:18:00 Module 04: Major Authors in Children's Literature Major Authors in Children's Literature 00:14:00 Module 05: Diversity and Representation in Children's Books Diversity and Representation in Children's Books 00:14:00 Module 06: Critical Approaches to Children's Literature Critical Approaches to Children's Literature 00:18:00 Module 07: Contemporary Trends and Challenges Contemporary Trends and Challenges 00:18:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

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.