5817 Computing courses in Downpatrick delivered Online

Course Description Take your critical thinking abilities to the next level with the Critical Thinking and Decision Making: Part 1 course. In this course, you will learn the basic principles of critical thinking. You will be able to understand the connection between critical thinking and the judgment of claims. Here, you will achieve the ability to identify the barriers to critical thinking. This Critical Thinking and Decision Making: Part 1 course will help you understand the benefits and importance of critical thinking. Join the course and boost your critical thinking skills.  Learning outcome  Understand the core concept of critical thinking Familiarise with the principles of the judgment of claims Learn about the barriers of critical thinking Know the importance of critical thinking How Much Critical Thinkers Earn Senior - £39,000 - £50,000(Appx.) Average - £32,000 - £38,000(Appx.) Starting - £21,000 - £31,000(Appx.) Requirements Our Critical Thinking and Decision Making: Part 1 is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Critical Thinking and Decision Making: Part 1 Module 01: Introduction to Critical Thinking 00:23:00 Module 02: Critical Thinking and the Judgment of Claims 00:19:00 Module 03: Benefits and Barriers of Critical Thinking 00:32:00 Module 04: Importance of Critical Thinking 00:17:00 Assignment Assignment - Critical Thinking and Decision Making: Part 1 00:00:00

🌟 Unlock Your Excel Potential with Microsoft Excel 2019 - Intermediate Level Training! 🌟 Master the art of Excel with our comprehensive online course designed specifically for intermediate learners. Elevate your skills, boost productivity, and excel in spreadsheet management like never before. 📊 Course Curriculum 📊 🔹 Section 1 - Excel - Intermediate: Dive into the intermediate level of Excel functionalities, bridging the gap between basic and advanced techniques. 🔹 Section 2 - Lists: Learn the art of managing data efficiently with lists, organizing information for streamlined analysis and presentation. 🔹 Section 3 - DataBase Functions: Harness the power of database functions, empowering you to manipulate data with ease and precision. 🔹 Section 4 - Data Validation: Ensure data accuracy and integrity by implementing effective data validation techniques, preventing errors in your spreadsheets. 🔹 Section 5 - Importing and Exporting: Master the process of importing and exporting data seamlessly, integrating external information into your Excel sheets effortlessly. 🔹 Section 6 - Creating Basic Charts: Transform data into impactful visuals with basic chart creation, enhancing your ability to communicate insights effectively. 🔹 Section 7 - Pivot Tables: Unlock the potential of pivot tables, harnessing their analytical power to summarize and analyze complex data sets effortlessly. 🔹 Section 8 - Working with Large Data: Navigate and manipulate extensive data sets efficiently, optimizing your workflow with strategies tailored for large-scale information. 🔹 Section 9 - LookUp Functions: Explore lookup functions to search for and retrieve specific data, refining your ability to find information swiftly. 🔹 Section 10 - Advanced Functions: Elevate your Excel proficiency with advanced functions, expanding your capabilities to handle complex calculations and tasks. 🔹 Section 11 - Excel Intermediate - Conclusion: Wrap up your intermediate Excel journey, reinforcing key concepts and preparing you for further advancements. 🎓 Why Choose Our Course? 🎓 🚀 Comprehensive Learning: A structured curriculum tailored to the needs of intermediate Excel users, covering a wide array of functionalities. 👨‍🏫 Expert Guidance: Led by industry experts well-versed in Excel, ensuring a rich learning experience with practical insights. 🤝 Interactive Learning: Engage with interactive exercises and real-life examples, solidifying your understanding through hands-on practice. 📈 Career Growth: Acquire skills highly sought after in the job market, giving you a competitive edge in various professional domains. 🔓 Don't miss this opportunity to take your Excel skills to the next level! Enroll now and unleash your potential with Microsoft Excel 2019 - Intermediate Level Training. 🔓 Course Curriculum Section 1 - Excel - Intermediate Excel Intermediate Introduction 00:00 Intermediate Shortcut Keys 00:00 Section 2 - Lists What are Lists 00:00 Sorting a List 00:00 Sorting - Multiple Criteria 00:00 Custom Sort 00:00 What are Filters 00:00 Format a List as a Table 00:00 Section 3 - DataBase Functions Introduction to DataBase Functions 00:00 DSum Function 00:00 DSum Function - Single Criteria 00:00 DSum Function - Multiple Criteria 00:00 DAverage 00:00 DCount Function 00:00 Subtotal 00:00 Section 4 - Data Validation Data Validation - List 00:00 Data Validation - Decimal 00:00 Input and Error Messages 00:00 Section 5 - Importing and Exporting Importing Data from Text Files 00:00 Importing Data from MS Access 00:00 Exporting Data to a Text File 00:00 Section 6 - Creating Basic Charts Creating Basic Charts 00:00 The Chart Ribbon 00:00 Adding and Modifying Data on a Chart 00:00 Formatting Charts 00:00 Section 7 - Pivot Tables Understanding Pivot Tables 00:00 Creating Pivot Tables 00:00 Pivot Table Calculations 00:00 Grouping Pivot Table Data 00:00 Formatting Pivot Table Data 00:00 Drilling Down into Pivot Table Data 00:00 Creating Pivot Charts 00:00 Filtering Pivot Table Data 00:00 Filtering using the Slicer 00:00 Section 8 - Working with Large Data Grouping Data 00:00 Consolidating Data 00:00 Section 9 - LookUp Functions VLookUp 00:00 HLookUp 00:00 Index and Match 00:00 Section 10 - Advanced Functions FV Function 00:00 PMT Function 00:00 Hyperlinks 00:00 Text to Columns 00:00 Section 11 - Excel Intermediate - Conclusion Excel Intermediate - Conclusion 00:00

Reliability Centred Maintenance (RCM) is commonly used to help establish safe minimum levels of maintenance, determine changes to operating procedures and help establish maintenance regimes and plans. Successful implementation can result in cost savings, machine uptime and improved risk management. But the devil's in the detail - how can you achieve these benefits and successfully implement RCM in your organisation? This programme will help you do just that. Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. To provide a better understanding of RCM, particularly: What, why, how and who? Opportunities and benefits Risks Cost effectiveness Note: this is a purely indicative outline. The content, duration, objectives and material used can all be adapted to match your specific requirements. 1 What is maintenance? Why maintain? Traditional maintenance methods Common current practices and trends 2 What is Reliability Centred Maintenance? Its history Its development Current usage Where can it be cost-effective? 3 How does it work? Basic features Key criteria Maintenance options Key outcomes 4 Making the business case and preparing the strategy Identifying and quantifying current risks Identifying and quantifying current costs Motivating decision-makers Identifying and empowering those who have to deliver the results Educating / gaining buy-in from interested parties 5 Implementation Identify business functions Prioritise functions Verify correct usage Identify failure modes Identify the consequences of failure Understand the failure process Specify the appropriate maintenance action(s) 6 Ongoing requirements Monitoring Recording Analysis Continuous re-evaluation 7 Open discussion Sharing experience and addressing specific issues of interest to participants Course review Close

Learning Objectives Introduction , Getting Started with Excel , Creating Workbooks and Using Templates , Entering Data , Excel Formula Basics , Adjusting a Worksheet , Formatting and Aligning Data , Using Cell Styles and Themes , Inserting Objects and Graphics , Proofing a Workbook , Printing an Excel File , Managing Worksheets , Navigating and Viewing Excel Files , Conclusion   Pre-Requisites Basic Computer Skills   Description Microsoft Excel is one of the major workhorses in the Microsoft Office suite of applications and arguably the most widely-used Office product. A solid understanding of how to use this program is vital to nearly everyone in most industries today. This course is designed specifically to teach you the fundamentals of Excel and give you the skills you need to begin to create and manipulate worksheets. Specifically, you will understand how to create, save, enter data, and print spreadsheets in addition to learning how to create formulas and use functions to calculate in Excel. You will learn how to enter data, format spreadsheets, manipulate columns and rows, add headers and footers, and use page setup options to prepare them for printing. You will also learn how to handle large worksheets or multiple workbooks, use styles and themes, insert various graphic objects, and options for proofing your workbooks. Section 01 Lesson 01: What is Excel 00:03:00 Lesson 02: Opening Excel 00:04:00 Lesson 03: Navigating the Excel User Interface-v2 00:06:00 Lesson 04: Navigating the Excel User Interface 00:04:00 Lesson 05: Using the Excel Ribbon 00:07:00 Lesson 06: Understanding Excel Worksheet Components 00:07:00 Lesson 07: Using the Backstage View 00:06:00 Section 02 Lesson 01: Creating a New Workbook 00:06:00 Lesson 02: Saving an Excel Workbook 00:05:00 Lesson 03: Using the Accessibility Checker 00:04:00 Lesson 04: Using the Accessibility Checker-v3 00:04:00 Section 03 Lesson 01: Navigating a Worksheet by Mouse or Keyboard 00:05:00 Lesson 02: Understanding Excel Data Types 00:04:00 Lesson 03: Using the Inking Tools 00:05:00 Lesson 04: Using the Inking Tools-v3 00:03:00 Lesson 05: Working with Cell and Range Addressing 00:05:00 Lesson 06: Using Various Data Selection Techniques 00:05:00 Lesson 07: Working with Common Excel Commands 00:06:00 Lesson 08: Using Flash Fill and Autofill 00:06:00 Section 04 Lesson 01: What are Formulas and Functions 00:05:00 Lesson 02: Understanding the Components of a Formula 00:05:00 Lesson 03: Understanding Calculation Hierarchy and the Order of Operations 00:03:00 Lesson 04: Creating Basic Formulas 00:05:00 Lesson 05: Working with Basic Functions and AutoSum 00:06:00 Lesson 06: Using Cell References 00:05:00 Lesson 07: Using the Quick Analysis Tool 00:03:00 Section 05 Lesson 01: Modifying Columns and Rows 00:06:00 Lesson 02: Hiding and Unhiding Columns and Rows 00:06:00 Section 06 Lesson 01: Formatting and Aligning Data 00:07:00 Lesson 02: Merging Data 00:07:00 Lesson 03: Wrapping Text and Adjusting Orientation 00:06:00 Lesson 04: Formatting Numbers 00:05:00 Lesson 05: Using the Format Painter 00:04:00 Section 07 Lesson 01: Using Cell Styles 00:06:00 Lesson 02: Applying Themes 00:05:00 Section 08 Lesson 01: Inserting and Formatting Images and Shapes 00:08:00 Lesson 02: Inserting and Formatting SmartArt 00:05:00 Lesson 03: Working with Icons 00:04:00 Lesson 04: Inserting Hyperlinks 00:06:00 Lesson 05: Inserting Symbols and Equations 00:05:00 Lesson 06: Inserting WordArt and Text Boxes 00:05:00 Lesson 07: Inserting 3-D Models 00:04:00 Lesson 08: Arranging Objects 00:06:00 Section 09 Lesson 01: Using Find and Replace 00:05:00 Lesson 02: Using Go To and Go To Special 00:03:00 Lesson 03: Using the Spell Checker 00:05:00 Lesson 04: Using the Thesaurus and Translation Features 00:05:00 Lesson 05: Using the resolve Feature-v3 00:02:00 Section 10 Lesson 01: Printing and Previewing Excel Files 00:06:00 Lesson 02: Creating Custom Margins and Scaling 00:05:00 Lesson 03: Adding Headers and Footers 00:04:00 Lesson 04: Formatting a Page with the Page Layout Tab 00:06:00 Lesson 05: Printing Titles and Specific Worksheet Areas 00:03:00 Lesson 06: Exporting to PDF-v3 00:02:00 Lesson 07: Exporting to PDF and XPS 00:04:00 Section 11 Lesson 01: Renaming and Coloring Worksheet Tabs 00:03:00 Lesson 02: Adding, Deleting and Navigating Worksheets 00:03:00 Lesson 03: Hiding and Unhiding Worksheets 00:03:00 Section 12 Lesson 01: Viewing Workbooks 00:03:00 Lesson 02: Using Zoom Tools 00:03:00 Lesson 03: Configuring Sheet Options 00:05:00 Lesson 04: Using the Freeze Panes and Split Commands 00:04:00 Lesson 05: Adjusting Worksheet Properties 00:04:00 Lesson 06: Viewing Workbook Statistics-v3 00:02:00 Course Recap Recap 00:02:00 Final Exam Final Exam - Excel 365 Beginner 00:20:00

Duration 5 Days 30 CPD hours This course is intended for This class is designed for email digital marketers who manage the email channel for their organization. Whether you are new to Marketing Cloud or looking for tips on how to improve your existing customer journeys, this class is a great place to start. No prior knowledge of Marketing Cloud is needed. Overview When you complete this course, you will be able to: Explain compliance concepts to ensure optimal deliverability. Use tools within Marketing Cloud to uphold deliverability standards. Utilize Email Design best practices to ensure the best customer experience. Develop effective, relevant messages using Content Builder. Design and test different delivery methods and options when sending an email message. Design and execute customer journeys using automation tools within Marketing Cloud. Differentiate the use cases for different automation activities in Automation Studio and Journey Builder. Define fundamental data management and structure terminology. Use data segmentation tools to create targeted emails. Apply a simple data model concept to a real-world scenario. Define subscriber statuses, unsubscribe methods, and preferences. Analyze marketing campaigns using common KPIs. Solve a common marketing problem using troubleshooting guidance. Prioritize testing methods and tools to ensure quality control. Explain fundamental account and sending administration. Know where to go for more information, guidance, and support. Describe capabilities across the platform. Start your journey to becoming a Marketing Cloud Specialist. In this 5-day, expert-led class, you will learn how to build customer journeys within Marketing Cloud. Our team of Marketing Cloud pros will walk you through best practices related to executing, monitoring, and analyzing your journeys, arming you with the tools and know-how to design personalized journeys and engage with your customers in a whole new way. Course Outline Introduction to Salesforce Marketing Cloud Administration Subscriber and Data Management Email Message Design and Creation Message Testing, Delivery, and Email Marketing Best Practices Marketing Automation Analytics and Troubleshooting Summary

Duration 5 Days 30 CPD hours This course is intended for This class is intended for DBAs and IT Professionals who are responsible for administration and maintenance of PostgreSQL, and want to increase proficiency and learn best practices. Targeted at: DBAs and Architects, and appropriate for Analysts, Support Engineers, and other IT professionals Overview Please refer to overview This is an immersive 5-day class that offers hands-on labs and combines the core topics from Foundations of Postgres Administration and Advanced PostgreSQL Administration into a one-week class, with significant savings over list price. Upon course completion, you will be prepared to manage mission critical PostgreSQL installations, and perform core administration tasks with confidence and skill. Course Outline 1 - POSTGRES SYSTEM ARCHITECTURE 2 - INSTALLATION AND GETTING STARTED 3 - CONFIGURATION, CREATING, MANAGING DATABASES 4 - USER TOOLS ? USING PSQL 5 - GUI TOOLS - USING PGADMIN 4 6 - SECURITY BASICS 7 - SQL PRIME BACKUP AND RECOVERY 8 - ROUTINE MAINTENANCE 9 - POSTGRES DATA DICTIONARY 10 - MOVING DATA 11 - SQL TUNING 12 - PERFORMANCE TUNING 13 - STREAMING REPLICATION 14 - TABLE PARTITIONING 15 - EXTENSION MODULES 16 - MONITORING 17 - UPGRADING BEST PRACTICES

Duration 5 Days 30 CPD hours This course is intended for This introductory-level Python course is geared for experienced web developers new to Python who want to use Python and Django for full stack web development projects. Overview Working in a hands-on learning environment, guided by our expert team, attendees will learn to: Develop full-stack web sites based on content stored in an RDMS Use python data types appropriately Define data models Understand the architecture of a Django-based web site Create Django templates for easy-to-modify views Map views to URLs Take advantage of the built-in Admin interface Provide HTML form processing Geared for experienced web developers new to Python, Introduction to Full Stack Web Development with Python and Django is a five-day hands-on course that teaches students how to develop Web applications using the Django framework. Students will explore the basics of creating basic applications using the MVC (model-view-controller) design pattern, as well as more advanced topics such as administration, session management, authentication, and automated testing. This comprehensive, practical course provides an in-depth exploration of working with the programming language, not an academic overview of syntax and grammar. Students will immediately be able to use Python to complete tasks in the real world. The Python Environment Starting Python Using the interpreter Running a Python script Getting help Editors and IDEs Getting Started Using variables Built in functions Strings Numbers Converting among types Writing to the screen Command line parameters Flow Control About flow control Conditional expressions Relational and Boolean operators while loops Lists and Tuples About sequences Lists and list methods Tuples Indexing and slicing Iterating through a sequence Sequence functions, keywords, and operators List comprehensions Working with Files File overview The with statement Opening a file Reading/writing files Dictionaries and Sets About dictionaries Creating and using dictionaries About sets Creating and using sets Functions Returning values Function parameters Variable Scope Sorting with functions Errors and Exception Handling Exception overview Using try/catch/else/finally Handling multiple exceptions Ignoring exceptions Modules and Packages Creating Modules The import statement Module search path Creating packages Classes About OO programming Defining classes Constructors Properties Instance methods and data Class/static methods and data Inheritance Django Architecture Django overview Sites and apps Shared configuration Minimal Django layout Built in flexibility Configuring a Project Executing manage.py Starting the project Generating app files App configuration Database setup The development server Using cookiecutter Creating models Defining models Related objects SQL Migration Simplel model access Login for Nothing and Admin for Free Setting up the admin user Using the admin interface Views What is a view HttpResponse URL route configuration Shortcut: get_object_or_404() Class-based views Templates About templates Variable lookups The url tag Shortcut: render() Querying Models QuerySets Field lookups Chaining filters Slicing QuerySets Related fields Q objects Advanced Templates Use Comments Inheritance Filters Escaping HTML Custom filters Forms Forms overview GET and POST The Form class Processing the form Widgets Validation Forms in templates Automated Testing Why create tests? When to create tests Using Django's test framework Using the test client Running tests Checking code coverage

Duration 3 Days 18 CPD hours This course is intended for Application ConsultantBusiness AnalystBusiness Process ArchitectBusiness Process Owner / Team Lead / Power UserExecutiveIndustry SpecialistProgram/Project Manager Overview This course will prepare you to:Describe the motivation for S/4HANA Enterprise ManagementExecute innovative logistics processes in the areas of logistics planning and execution in S/4HANA, especially in manufacturing, procurement, and salesLearn about the simplification listOutline the SAP User Experience strategyUse SAP Fiori among other user interfaces to execute logistics processesOutline different migration strategies Students will learn to execute innovative logistics processes in the areas of logistics planning and execution in S/4HANA, especially in manufacturing, procurement, and sales. Motivation and Functional Overview of SAP S4/HANA (Materials Management and Operations)Simplification ListSAP User Experience, especially SAP FioriInnovative Logistics Processes in the Areas of Logistics Planning and Execution in S/4HANA, especially in Manufacturing, including MRP Life and Production Planning / Detailed Scheduling (PP/DS) Procurement, Sales, including Back Order Processing, and Extended Warehouse Management (EWM) Migration Scenarios

Duration 3 Days 18 CPD hours This course is intended for This course is intended for application administrators, developers, IT leaders, and application architects. Overview As a result of attending this course, students should be able to configure, secure, and manage a Red Hat JBoss AMQ 7.0 broker to create and integrate message-driven applications. Red Hat© AMQ Administration (AD440) helps system administrators, architects, and developers acquire the skills they need to administer the message broker, Red Hat JBoss AMQ. Through numerous hands-on exercises, the student will create, configure, manage, and monitor broker instances including hardened, clustered brokers that provide high availability and failover. This course is based on Red Hat JBoss AMQ 7.0. Red Hat JBoss AMQ, part of the Red Hat application integration suite, provides application administrators, software architects, and developers the ability to integrate disparate applications in a decoupled manner using enterprise messaging paradigms. Providing a highly performant and robust message broker, router, and client libraries for numerous languages, Red Hat JBoss AMQ is the solution for asynchronous and synchronous messaging. Red Hat AMQ Administration (AD440) helps system administrators, architects, and developers acquire the skills they need to administer Red Hat JBoss AMQ. Through numerous hands-on exercises, the student will create, configure, manage, and monitor broker instances including hardened, clustered brokers that provide high availability and failover. Course introduction Introduce and review the course. Install the broker Install JBoss AMQ, create a broker instance, and verify connectivity to the instance. Configuration Configure message addresses and queues. Secure access to the broker Configure authentication, authorization, and encryption on the broker. Configure broker persistence Configure zero, file-based, and database-backed persistence. Manage broker resource consumption Configure the broker to limit memory and other resource consumption. Implement broker clustering, high availability, and failover Create a scalable and highly available cluster of brokers. Monitor and manage the broker Monitor and manage broker resources using logging and the web console. Route messages to brokers Install JBoss AMQ interconnect and configure routes to brokers. Comprehensive review of Red Hat AMQ administration Configure Red Hat JBoss AMQ brokers and verify proper operation.

Duration 3.25 Days 19.5 CPD hours This course is intended for This course is intended for IT administrators with a minimum 2-5 years of experiencing working with Microsoft Windows Server, Windows 10, and Office 365 licensing. The course will utilize a pre-provisioned lab environment which includes Microsoft 365 E5 licenses and Enterprise Mobility and Security E5 licenses for each student. Powershell management topics will be discussed where applicable in the respective topics. This course will address Windows devices only enrolled in Intune. Configuring and Licensing Intune Endpoint Manager - quick discussion, portal access Discuss which licenses include Intune Discuss Microsoft Intune device-only subscription Discuss Azure Active Directory basic, P1, P2 licensing Intune setup and overview of capabilities Supported configurations Logging in and using Intune Admin portal via Azure Portal and via Endpoint manager site Configure a domain name (needed to support labs though may be done already for E1B/district) Add users and groups in Azure Portal Configure Azure AD connect and discuss AAD Connect Health Assigning licenses manually, via Powershell, and via AAD groups Set the MDM authority and enable device enrollment Add Apps to Intune - covered in detail in a later topic Configuring device profiles - covered in detail in a later topic Company Portal discussion - covered in detail in a later topic Configure app policies - covered in detail in a later topic Windows device management What is co-management - brief discussion on Endpoint Manager with Configuration Manager Registering, joining, hybrid join to Azure AD Enrollment method capabilities Azure AD joined Azure AD joined with Autopilot (User driven mode) Azure AD joined with Autopilot (Self deploying mode) Autopilot pre-provisioned deployment (formally known as white-glove) Device group tags for profile deployment Troubleshooting Autopilot Policy conflicts Known issues Using Powershell to connect to and manage Intune Software deployment Add apps to Intune Windows Store apps Microsoft Store for Business apps LOB apps - Sideloading Adding Win32 apps Running Powershell Scripts on devices Assigning Apps Monitor Apps Discovered Apps Configure Apps App Configuration Policies Office app policys Custom OMA-URI Policies Troubleshooting Managing devices Windows 10 Feature Updates Update rings to manage updates Mapping drives to SMB shares Discuss OneDrive for Business Manage Enterprise Wireless - Windows Configuration Designer, provisioning packages Implementing Conditional Access - device based, app based Printer management Universal Print Deploying printer settings Remote administration Intune Device Management Inventory Fresh Start Full Scan Remote Lock Restart Sync devices Bulk device actions Teamviewer integration requirements Intune Reporting Accessing Reports Exporting Reports using Graph