1738 Basic courses in Manchester delivered Live Online

Duration 2 Days 12 CPD hours This course is intended for This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of Overview Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses Code inner joins and non-correlated subqueries Use SQL arithmetic operations Use scalar and column functions Use UNION and UNION ALL INSERT, UPDATE and DELETE rows Code simple CREATE TABLE and CREATE VIEW statements This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment. Outline Introduction Simple SQL Queries Retrieving Data from Multiple Tables Scalar Functions and Arithmetic Column Functions and Grouping UNION and UNION ALL Using Subqueries Maintaining data

Duration 3 Days 18 CPD hours This course is intended for Information System Owners Analysts Ethical Hackers ISSOs Cyber Security Managers IT Engineers Overview Upon completion, the Certified Vulnerability Assessor candidate will be able to competently take the exam. This course provides a solid understanding of the tools an IT engineer needs to review an Information System. In this course, you will learn the importance of vulnerability assessments and how they are used to prevent serious cyber break-ins. Lessons include understanding malware and viruses and how they can infiltrate an organization?s network. After you take this course, you will be able to assess a company?s security posture and perform a basic vulnerability test.ÿPlus, you will be able to generate reports to guide new security implementation. Course Outline Why Vulnerability Assessment Vulnerability Types Assessing the Network Assessing Web Servers and Applications Assessing Remote and VPN Services Vulnerability Assessments & Tools of the Trade Output Analysis

Following on from the Macros course look at how you can write your own Visual Basic code within Excel to fully automate tasks and save time. Course overview Duration: 2 days (13 hours) Our VBA in Excel course is an introduction to using the Visual Basic for Applications language for programming in Excel. It looks at structures, syntax and coding standards. This course is designed for existing experienced users of Excel who can record and run macros and those who have dabbled in VBA but would like some formal training and help to put some structure to their code. Objectives  By the end of the course you will be able to: Write visual basic procedures Create event and general procedures Use commands from the Excel data model Use statements and functions Use a selection of debugging tools Create and use variables and constants Use different types of loops Create an Excel user form Content The VBA environment Project explorer Excel objects Modules Properties window Code window Code structure Code structure Navigating within your code Adding comments Using WITH Steps to creating a VBA procedure Procedures Sub procedures Event procedures Calling procedures The Excel data model Workbook commands Worksheet commands Excel selection methods Data manipulation commands Debugging Using breakpoints Stepping through code The immediate window The watch window The locals window points Variables and Constants Declaring variables Declaring multiple variables Variable data types Concatenation Scope of variables Constants Declaring constants Using constants Scope of constants Looping Do while loops Do until loops For next loops Conditional Statements IF statement SELECT CASE statement Comparison statements Logical operators Creating a User Form Form layout The control toolbox Naming conventions Adding objects Naming objects Captions Displaying the form Object properties Object properties Setting properties at design time Setting properties at run time Interconnectivity between the user form and Excel Comparing values Transferring information Running code

Adobe After Effects Fast-Track Course (Live Online) through our comprehensive course, beginners, intermediate, and advanced learners. Perfect your skills at the top Training Centre in the UK. Dive into motion graphics and animation with hands-on training led by expert tutors ensuring a practical and interactive learning experience. Click here for more info: Website Duration: 5 hours Approach: Personalized 1-on-1sessions and Customized content. Schedule: Select your preferred hour from Monday to Saturday between 9 am and 7 pm. Adobe After Effects Essentials (5-hour course) Session 1: Introduction to After Effects (1 hour) Overview of After Effects and its applications in motion graphics and visual effects. Understanding the workspace and interface. Importing and organizing assets for seamless workflow. Creating projects and compositions. Session 2: Animation Basics (1.5 hours) Working with layers: Adding, editing, and arranging layers in the timeline. Keyframe animation: Introduction to keyframes and creating simple animations. Motion paths: Manipulating motion paths for dynamic animations. Easing motion: Applying ease in and ease out to smoothen animations. Animation presets: Utilizing built-in presets for efficient animation. Session 3: Effects and Compositing (1.5 hours) Applying effects: Adding visual effects to layers and compositions. Compositing techniques: Understanding blending modes and layer styles. Masking and track mattes: Using masks to control the visibility of layers and apply effects. Motion tracking: Applying tracking data to objects in a scene. Session 4: Text and Shape Animation (1 hour) Text animation: Creating and animating text layers with different styles. Shape layers: Introduction to shape layers and their applications. Animating shapes: Using shape layers to create dynamic animations. Session 5: Final Project and Exporting (1 hour) Applying all the learned techniques to create a final motion graphics project. Refining the project and adding finishing touches. Understanding export settings and rendering the final output. Read the usefull Blogs https://realanimationworks.com/government-funded-interior-design-courses-in-london-your-path-to-creative-excellence/ Upon completing the Adobe After Effects Essentials course, participants will: Master the Interface: Understand After Effects' layout, tools, and key functionalities, gaining confidence in navigating the software. Animation Proficiency: Gain expertise in animating images, videos, and text layers using keyframes, easing techniques, and smooth transitions. Effects Application: Learn to apply, customize, and animate various visual effects, enhancing the overall visual appeal of multimedia projects. Masking and Precision Editing: Master the art of creating and animating masks for detailed and accurate editing, enabling seamless integration of visual elements. Advanced Compositing Skills: Explore advanced compositing techniques for combining multiple elements seamlessly, achieving professional-level visual integration. Export and Rendering Mastery: Understand export settings, ensuring optimal video quality for diverse output formats. Learn the art of efficient rendering for polished final products. Certificate of Completion: Receive a certificate validating the successful completion of the course, showcasing newfound skills to potential employers or clients. Practical Knowledge: Acquire practical insights and techniques applicable to real-world projects, ensuring the ability to create visually captivating multimedia content independently. Lifetime Learning Support: Benefit from lifetime email support, enabling continuous learning and assistance with any post-course queries or challenges. After Effects CC Training: From Novices to Experts Immerse yourself in the world of motion graphics and VFX with our Adobe Certified After Effects Courses, suitable for total novices and experts alike. Learn to create captivating motion graphics, smooth animations, and stunning special effects in a professional environment. Choose from four learning options: London Classroom: Attend in-person sessions 1-2-1 in our dynamic studio. Live Online Classes: Join interactive classes from the comfort of your home or office. Bespoke Training: Tailor the course to your specific needs and preferences. Whichever path you select, all options cover the same lesson plan delivered by our Certified Professional Trainers. Rest assured, your learning experience is fully supported by our 100% Satisfaction Guarantee. Personalized After Effects Training: Tailored for You! Custom one-on-one sessions, in-person or online. Work with your files, learn at your pace. Expert trainers in London. Team training available. Benefits: Unlimited post-course support via phone/email. Access to training materials and a handbook. Free pre-course consultation. Achieve impressive results: create captivating videos, animated logos, and more. Master cinematic effects and enhance your visual storytelling skills.

Duration 5 Days 30 CPD hours This course is intended for This advanced course is for: AIX technical support personnel Performance benchmarking personnel AIX system administrators Overview Define performance terminology Describe the methodology for tuning a system Identify the set of basic AIX tools to monitor, analyze, and tune a system Use AIX tools to determine common bottlenecks in the Central Processing Unit (CPU), Virtual Memory Manager (VMM), Logical Volume Manager (LVM), internal disk Input/Output (I/O), and network subsystems Use AIX tools to demonstrate techniques to tune the subsystems In this course, students will develop the skills to measure, analyze, and tune common performance issues on IBM Power Systems running AIX. Day 1 Performance analysis and tuning overview Data collection Monitoring, analyzing, and tuning CPU usage Day 2 Virtual memory performance monitoring and tuning Day 3 Physical and logical volume performance File system performance monitoring and tuning Day 4 File system performance monitoring and tuning Network performance Day 5 NFS performance Performance management methodology

SAP SD Training SAP SD (Sales & Distribution) module is a logistics module part which is a very important component of the SAP Business suite. SAP SD module empowers you to manage customer relationship starting from raising a quotation to sales order and billing of the product or service. This module is highly linked to other SAP modules like SAP Material Management and PP (Production Planning). Powered with an understanding and knowledge of the comprehensive functionality in SAP SD, you can easily manage the entire customer life cycle efficiently and intelligently. SAP SD Introductions and Master Data Document Types for Pre sales and Sales Documents Pricing Process and Determination Sales Cycles - sales processes Free goods Processing Revenue Account Determination SD Basic Functions Special Sales - Special Processes Invoicing Plan Variant Configuration Special Sales- Special Processes Case Study - business case Integration with Other Modules and support

Duration 4 Days 24 CPD hours This course is intended for This course is best suited to systems administrators and IT managers. Overview Skills gained in this training include:Determining the correct hardware and infrastructure for your clusterProper cluster configuration and deployment to integrate with the data centerConfiguring the FairScheduler to provide service-level agreements for multiple users of a clusterBest practices for preparing and maintaining Apache Hadoop in productionTroubleshooting, diagnosing, tuning, and solving Hadoop issues Cloudera University?s four-day administrator training course for Apache Hadoop provides participants with a comprehensive understanding of all the steps necessary to operate and maintain a Hadoop cluster. The Case for Apache Hadoop Why Hadoop? Core Hadoop Components Fundamental Concepts HDFS HDFS Features Writing and Reading Files NameNode Memory Considerations Overview of HDFS Security Using the Namenode Web UI Using the Hadoop File Shell Getting Data into HDFS Ingesting Data from External Sources with Flume Ingesting Data from Relational Databases with Sqoop REST Interfaces Best Practices for Importing Data YARN & MapReduce What Is MapReduce? Basic MapReduce Concepts YARN Cluster Architecture Resource Allocation Failure Recovery Using the YARN Web UI MapReduce Version 1 Planning Your Hadoop Cluster General Planning Considerations Choosing the Right Hardware Network Considerations Configuring Nodes Planning for Cluster Management Hadoop Installation and Initial Configuration Deployment Types Installing Hadoop Specifying the Hadoop Configuration Performing Initial HDFS Configuration Performing Initial YARN and MapReduce Configuration Hadoop Logging Installing and Configuring Hive, Impala, and Pig Hive Impala Pig Hadoop Clients What is a Hadoop Client? Installing and Configuring Hadoop Clients Installing and Configuring Hue Hue Authentication and Authorization Cloudera Manager The Motivation for Cloudera Manager Cloudera Manager Features Express and Enterprise Versions Cloudera Manager Topology Installing Cloudera Manager Installing Hadoop Using Cloudera Manager Performing Basic Administration Tasks Using Cloudera Manager Advanced Cluster Configuration Advanced Configuration Parameters Configuring Hadoop Ports Explicitly Including and Excluding Hosts Configuring HDFS for Rack Awareness Configuring HDFS High Availability Hadoop Security Why Hadoop Security Is Important Hadoop?s Security System Concepts What Kerberos Is and How it Works Securing a Hadoop Cluster with Kerberos Managing and Scheduling Jobs Managing Running Jobs Scheduling Hadoop Jobs Configuring the FairScheduler Impala Query Scheduling Cluster Maintainence Checking HDFS Status Copying Data Between Clusters Adding and Removing Cluster Nodes Rebalancing the Cluster Cluster Upgrading Cluster Monitoring & Troubleshooting General System Monitoring Monitoring Hadoop Clusters Common Troubleshooting Hadoop Clusters Common Misconfigurations Additional course details: Nexus Humans Cloudera Administrator Training for Apache Hadoop 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 Cloudera Administrator Training for Apache Hadoop 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.

Duration 3 Days 18 CPD hours This course is intended for Application consultants Overview In this course, participants use and customize functions in delivery processing. In this course, students learn the customizing settings of delivery documents and the set-up of corresponding functions. Idea and Function of the Delivery Document Explaining the Concept and Structure of the Delivery Document Basic Organizational Units for the Delivery Process Maintaining the Organizational Units for Delivery Processes Controlling Deliveries Controlling Delivery Documents The Goods Issue Process Based on the Delivery Adjusting Automatic Determination of Relevant Fields for Outbound Delivery Creation Adjusting Delivery and Transportation Scheduling Processing Outbound Deliveries Using the Outbound Delivery Monitor Processes and Functions based on the Delivery Picking Outbound Deliveries Packing Materials Handling Goods Issues Using Special Functions in Deliveries Further Application Areas of the Delivery Document Transferring Stock Between Plants Performing Goods Receipts Using Deliveries Specified Delivery Scenario Setting Up a Specified Delivery Scenario

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level course for experienced software developers seeking to enhance and extend their core web development skillset leveraging JavaScript. Attendees should have practical experience developing basic software applications. This course provides an excellent foundation for continued learning to gain in-demand skills in in-demand skills and technologies such as NodeJS, Angular, React, Redux and more. This course can also be tailored for less experienced or non-developers as needed. Please inquire for details. Overview Throughout this course, students will explore the practical use of the umbrella of technologies that work in conjunction with JavaScript as well as some of the tools, toolkits, and frameworks that can be used in conjunction with web development and deployment. The course thoroughly explores JavaScript and how it is used within the context of web applications, walking students through the different technologies that are used with JavaScript and exploring core aspects of JavaScript in terms of web applications, security, tools, and frameworks. This skills-focused course is approximately 50% hands-on lab to lecture ratio. Our instructors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working within in a hands-on learning environment guided by our expert team, attendees will learn to: Understand what JavaScript is and how it is used within the context of web applications Work with the different technologies that are the foundation for web applications. Understand and work with the fundamental aspects of JavaScript in terms of web applications, security, tools, and frameworks Learn to how to effectively work with the newest advances in JavaScript such as ES6 and TypeScript Develop code using conventions and optimal constructs for performance Introduction to JavaScript | Modern JavaScript Essentials is a hands-on geared for web developers who need to learn basic JavaScript to use with today's systems and architectures to build sophisticated web interfaces. The training will guide students through a balanced mixture of theory and practical labs to gain core JavaScript development skills and have them explore its related technologies through to the use of tools and libraries to ease the development of advanced web applications. Course attendees will be able to hit the ground running right after class, applying essential JavaScript to projects at both an architectural as well as a line by line coding level. HTML Refresher (optional) HTMLÿ HTML5 CSS Refresher (optional) CSSÿ CSS3 Overview Introduction to JavaScript JavaScript Basics Debugging Tools JavaScript Functions JavaScript Arrays, Math and Date JavaScript Event Handling and the DOM Object-Oriented JavaScript Advanced JavaScript Topics The Next Step TypeScript Introduction to JSON and Ajax JavaScript Best Practices JavaScript Scheduling, Execution, and Security HTML5 JavaScript API Working with XML (Optional) XML DOM Mechanics XSLT Applied Additional course details: Nexus Humans Introduction to JavaScript | Modern JavaScript Essentials (TT4110) 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 Introduction to JavaScript | Modern JavaScript Essentials (TT4110) 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.

Duration 5 Days 30 CPD hours This course is intended for This course is recommended for technical professionals who support, install, deploy or administer Check Point products. This course is recommended for technical professionals who perform advanced deployment configurations of Check Point products. Overview CCSA Know how to perform periodic administrator tasks. Describe the basic functions of the Gaia operating system. Recognize SmartConsole features, functions, and tools. Understand how SmartConsole is used by administrators to give user access. Learn how Check Point security solutions and products work and how they protect networks. Understand licensing and contract requirements for Check Point security products. Describe the essential elements of a Security Policy. Understand the Check Point policy layer concept. Understand how to enable the Application Control and URL Filtering software. Blades to block access to various applications. Describe how to configure manual and automatic NAT. Identify tools designed to monitor data, determine threats and recognize opportunities for performance improvements. Describe different Check Point Threat Prevention solutions for network attacks. Articulate how the Intrusion Prevention System is configured, maintained and tuned. Understand the Infinity Threat Prevention system. Knowledge about Check Point's IoT Protect. CCSE Provide an overview of the upgrade service and options available. Explain how to perform management upgrade and migration. Articulate the process using CPUSE features. Articulate the purpose and function of Management High Availability. Explain Primary vs Secondary, Active vs Standby and Synchronization. Explain disaster recovery steps in case the primary management server becomes unavailable. Provide overview of Central Deployment in SmartConsole. Articulate an understanding of Security Gateway cluster upgrade methods. Explain about Multi Version Cluster (MVC) upgrades. Discuss Gaia Commands and how they are used. Explain the main processes on s and s. Describe how to work with scripts and SmartTasks to configure automatic actions. Explain the Management Data Plane Separation (MDPS) Explain kernel operations and traffic flow Articulate Dynamic and Updatable Objects in Security Gateways Explain the policy installation flow and files used. Describe the use of policy installation history. Explain concurrent and accelerated install policy. Describe an overview of APIs and ways to use and authenticate. Explain how to make changes in GAIA and management configuration. Explain how to install policy using API. Explain how the SecureXL acceleration technology enhances and optimizes Security Gateway performance. Learn basic concepts and develop skills necessary to administer IT security fundamental tasks. CCSA Outline Configure the Security Management Server. Use the WebUI to run the First Time Wizard. Install the Smart Console. Install the Alpha Gateway using the network detailed in the course topology. Demonstrate how the Security Management Server and Gateway communicate. Test SIC Status. Create multiple administrators and apply different roles and permissions for simultaneous administration. Validate existing licenses for products installed on the network. Create and configure host, network and group objects. Create a simplified Security Policy. Demonstrate how to use Security Zones in policy. Demonstrate how to share a layer between Security Polices. Configure Network Address Translation for server and network objects. Enable Identity Awareness. Deploy user access roles for more granular control of the security Policy. Generate network Traffic and use traffic visibility tools to monitor the data. Use SmartConsole and SmartView Monitor to view status, alerts, and block suspicious traffic. CCSE Outline Prepare for a Security Management Server Upgrade Upgrade the Security Management Server Deploy a Secondary Security Management Server Configure a Distributed Log Server Upgrade a Security Gateway from SmartConsole Work with the Command Line Use Scripts and SmartTasks Configure Dynamic Objects Monitor Traffic Verify Policy Installation and Status Work with Gaia and Management APIs Work with Acceleration Features Configure a Locally Managed Site to Site VPN Configure a Site to Site VPN with an Interoperable Device Configure Remote Access VPN Configure Mobile Access VPN Configure a High Availability Cluster Work with ClusterXL Configure Policy Compliance Deploy SmartEvent