26224 Courses in Nottingham delivered Online

Buy Big. Save Big! Save now: £1233! Offer Ends Soon; Hurry Up! The construction industry is one of the most hazardous in the UK, with a disproportionately high number of accidents and fatalities. In 2021/22, there were 37 fatal injuries to workers in the construction industry in Great Britain. This Diploma in Construction Safety at QLS Level 5 course is endorsed by the Quality Licence Scheme and accredited by CPD (with 170 CPD points) to make your skill development and career progression related to construction safety substantial and easier than ever! This comprehensive Construction Safety Training course bundle addresses this critical concern. Through twelve meticulously designed modules, it equips learners with essential knowledge and skills to manage health and safety effectively on construction sites. It emphasises risk assessment, legal compliance, accident reporting, and site-specific safety issues, ensuring participants are well-versed in current best practises and safety standards. By completing the Construction Safety Training course, learners not only enhance their understanding of construction safety but also position themselves as valuable assets to any construction team. Invest in your safety and the safety of others. Enrol in our Construction Safety Training bundle today! Learning Outcomes of Construction Safety Training Understand and manage health and safety on construction sites effectively. Conduct thorough risk assessments and identify common construction risks. Comprehend and apply health and safety laws in the workplace. Accurately report accidents and implement preventive measures. Address general site issues including equipment and personnel safety. Mitigate risks in working at heights, excavation, and confined spaces. Why Choose Our Construction Safety Training Course? The opportunity to earn a certificate endorsed by the Quality Licence Scheme Get a free student ID card with Construction Safety Training Training Get instant access to this Construction Safety Training course. Learn Construction Safety Training from anywhere in the world The Construction Safety Training is affordable and simple to understand The Construction Safety Training is an entirely online, interactive lesson with voiceover audio Lifetime access to the Construction Safety Training course materials The Construction Safety Training comes with 24/7 tutor support Start your learning journey right away with this Construction Safety Training course! *** Course Curriculum *** Here is the curriculum breakdown of this Construction Safety course. Module 1: Managing Health and Safety Module 2: Risk Assessment and Common Risks Module 3: Health and Safety at Work and the Laws Module 4: Reporting Accidents at Work Module 5: General Site Issues Module 6: Working at Height Module 7: Excavation Work and Confined Spaces Module 8: Work Equipment Module 9: Manual and Mechanical Handling Module 10: Chemical and Biological Health Hazards and Control Module 11: Electrical Hazards and Control Module 12: Fire Hazards and Control Assessment Process of Construction Safety Training We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit it. You will be entitled to claim a certificate endorsed by the Quality Licence Scheme and a CPD-accredited certificate after you have completed all the exams. Show off Your New Skills with a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the Construction Safety course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of 119 GBP inside the UK 129 GBP (including postal fees) for international delivery CPD 170 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Construction Safety Training course is ideal for: Construction professionals Site managers Safety officers Project supervisors Aspiring builders Compliance officers Requirements You will not need any prior background or expertise in this Construction Safety Training course. Career path This Construction Safety Training course will allow you to kickstart or take your career to the next stage in the related sector such as: Health and Safety Manager Construction Safety Tutor Health and Safety Advisor Construction Safety Officer Health and Safety Manager Construction Manager Construction Safety Specialist

Duration 3 Days 18 CPD hours This course is intended for System integrators, Consultants, Solution architects Overview By the end of the course, you should be able to meet the following objectives: Create a vSphere design given a case study Identify and assess the business objectives of the vSphere environment Identify business requirements, constraints, assumptions, and risks, for all layers in the vSphere environment Apply a framework to a design Analyze design choices for vCenter, ESXi, storage, networking, vSphere clusters, and virtual machines Identify design decisions to ensure manageability, which include scalability, capacity planning and lifecycle management Identify design decisions to ensure that the vSphere environment is highly available Identify design decisions to ensure that the vSphere environment performs well Identify design decisions to ensure that the vSphere environment is secure Identify design decisions to ensure that the vSphere environment can recover from data loss or disaster This three-day course equips you with the knowledge, skills, and abilities to design a VMware vSphere 8 virtual infrastructure. You follow a proven approach to design a virtualization solution that ensures availability, manageability, performance, recoverability, and security. The approach presented follows VMware best practices. This course discusses the benefits and risks of available design alternatives and provides information to support making sound design decisions. Course Introduction Introductions and course logistics Course objectives Infrastructure Assessment Describe various design framework principles Follow a proven process to design a virtualization solution Define customer business objectives and requirements Use a systematic method to evaluate and document a conceptual model Create a logical design from a conceptual model Recognize key information contained in the physical design Designing for Manageability: Capacity Planning Make capacity planning design decisions that adhere to business requirements Design capacity planning strategies that meet the needs of the vSphere environment and follow VMware best practices Calculate compute and storage requirements for the VMs in the vSphere environment Designing for Manageability: Scalability Make scalability design decisions that adhere to business requirements Design scalability strategies that meet the needs of the vSphere environment and follow VMware best practices Designing for Manageability: Lifecycle Management Make lifecycle management design decisions that adhere to business requirements Design lifecycle management strategies that meet the needs of the vSphere environment and follow VMware best practices Designing for Availability Make availability design decisions that adhere to business requirements Design availability strategies that meet the needs of the vSphere environment and follow VMware best practices Designing for Performance Make performance design decisions that adhere to business requirements Design performance strategies that meet the needs of the vSphere environment and follow VMware best practices Designing for Security Make security design decisions that adhere to business requirements Design security strategies that meet the needs of the vSphere environment and follow VMware best practices Designing for Recoverability Make recoverability design decisions that adhere to business requirements Design recoverability strategies that meet the needs of the vSphere environment and follow VMware best practices Additional course details:Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSphere: Design [V8] 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 VMware vSphere: Design [V8] 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 Experienced system administrators and system integrators responsible for implementing VMware Horizon, Citrix XenApp and XenDesktop, and RDHS solutions. Overview By the end of the course, you should be able to meet the following objectives: Describe the features and functions of App Volumes and VMware Dynamic Environment Manager Demonstrate the architectures of App Volumes and VMware Dynamic Environment Manager Install and configure App Volumes Create and deploy Application Packages and writable volumes Install and configure VMware Dynamic Environment Manager Manage application configurations, user environment settings, and personalization settings This three-day course builds your skills in application management using VMware App Volumes© and VMware Dynamic Environment Manager©. You learn how to use App Volumes to deliver applications and data to desktops and users in seconds and at scale. You gain skills in managing application life cycles from installation to update and replacement. You also learn how to use VMware Dynamic Environment Manager to provide personalization and dynamic policy configuration across virtual, physical, and cloud-based environments to simplify end-user profile management. Course Introduction Introductions and course logistics Course objectives Overview of Application and Profile Management Profile Management Application Management Overview of App Volumes Describe the basic architecture and operation of App Volumes Explain the function of App Volumes Manager Explain the function of App Volumes Agent Describe the principles of SAM List the stages of application package life cycle Describe what is a writable volume and how it differs from an AppStack Identify the major requirements to deploy App Volumes App Volumes components App Volumes Installation Overview Describe the installation sequence for the App Volumes Manager Describe the App Volumes operation modes for packages and writable volumes Describe the App Volumes hypervisor connection types and their relationships with operation modes Describe the process of initial configuration of the App Volumes Manager Describe the basic configuration parameters and where these are configured in the App Volumes Manager Web interface Install and perform the initial configuration of the App Volumes Manager in a lab environment Describe the installation steps for the App Volumes Agent Install the App Volumes Agent in target client machines in a lab environment Working with Application Packages Explain the concept of simplified application packaging List the steps of application package life cycle Differentiate between an application, package, and program Create an application package Use markers to assign the new version of an application package Edit an application Edit a package Working with Writable Volumes Overview Describe what a writable volume is and where it is used Compare AppStacks with writable volumes Describe the operation of a writable volume Explain how to assign a writable volume to a desktop Create and assign a writable volume in a lab environment Working with AppStacks Explain how applications in an AppStack are available to a user Describe how to create an AppStack and populate it with applications Describe how to update an application in an existing AppStack Overview of Dynamic Environment Manager Describe VMware Dynamic Environment Manager and its architecture Describe the functional areas and benefits of VMware Dynamic Environment Manager Describe VMware Dynamic Environment Manager features and how it manages profiles Installation of Dynamic Environment Manager Recognize considerations for planning a Dynamic Environment Manager deployment Identify pre-configuration requirements before installing and starting the Dynamic Environment Manager - Management Console Recognize key steps in the installation process of Dynamic Environment Manager Describe the initial configuration process for the management console and FlexEngine Application Configuration Management Explain how a user can use the Dynamic Environment Manager Self-Support tool to recover from application configuration mistakes Explain how administrators and support staff can use the Dynamic Environment Manager Helpdesk Support Tool to troubleshoot profile problems Describe how the Dynamic Environment Manager SyncTool enables and synchronizes the offline use of Dynamic Environment Manager Describe how the Dynamic Environment Manager Application Profiler can be used to create predefined configurations for applications Application Configuration Management Predefined and user-customized application settings Using Application Profiler Using the Self-Support Tool Using the Helpdesk Support Tool

Duration 2 Days 12 CPD hours This course is intended for System architects, system administrators, IT managers, VMware partners, and individuals responsible for implementing and managing vSphere architectures who want to deploy vSphere 8.0 into their existing vSphere environment. Overview By the end of the course, you should be able to meet the following objectives: Recognize the importance of key features and enhancements in vSphere 8.0 Describe vCenter Server, VMware ESXi, storage, virtual machine, and security enhancements in vSphere 8.0 Describe the purpose of vSphere Distributed Services Engine Update an ESXi host equipped with a Data Processing Unit (DPU) using vSphere Lifecycle Manager Identify devices supported for system storage on ESXi 8.0 Recognize enhancements to VM hardware compatibility settings VMware vSphere Memory Monitoring and Remediation and the improvements to vSphere DRS Recognize the new Virtual Non-Uniform Memory Access (vNUMA) topology settings of a VM in vSphere Client Use vSphere Lifecycle Manager and Auto Deploy to manage the configuration specifications for the hosts in a cluster Recognize the vSphere Lifecycle Manager and Auto Deploy enhancements in vSphere 8.0 Recognize the cloud benefits that VMware vSphere+ brings to on-premises workloads Recognize technology that is discontinued or deprecated in vSphere 8.0 In this two-day course, you explore the new features and enhancements following VMware vCenter Server 8.0 and VMware ESXi 8.0. Real-world use-case scenarios, hands-on lab exercises, and lectures teach you the skills that you need to effectively implement and configure VMware vSphere 8.0. Course Introduction Introductions and course logistics Course objectives Artificial Intelligence and Machine Learning Describe how device groups support AI and ML in vSphere 8 Describe how device virtualization extensions support AI and ML in vSphere 8 vSphere Distributed Services Engine Describe the benefits of Distributed Services Engine Explain how Distributed Services Engine works Recognize use cases for Distributed Services Engine Install ESXi on a host equipped with a DPU View DPU information in vSphere Client Add an ESXi host equipped with a DPU to a cluster Update an ESXi host equipped with a DPU using vSphere Lifecycle Manager Create a vSphere Distributed Switch for network offloads Add a host with a DPU to the vSphere Distributed Switch Configure a VM to use Uniform Passthrough Mode vSphere and vCenter Management Review the improvements to the communication between vCenter and ESXi hosts Review the enhancements to the vCenter recovery process ESXi Enhancements Describe the function of the central configuration store in ESXi Explain how ConfigStore affects your interaction with ESXi configuration files Recognize the supported system storage partition configuration on ESXi 8.0 Identify devices supported for system storage on ESXi 8.0 Configure an RDMA host local device on ESXi vSphere Storage Describe the vSAN Express Storage Architecture Recognize the benefits of using vSAN Express Storage Architecture Describe the benefits of using NVMe Recognize the support for NVMe devices in vSphere Guest OS and Workloads Review the enhancements of the latest virtual hardware versions Describe the features introduced with virtual hardware version 20 Create a snapshot of a VM with an NVDIMM device Resource Management View energy and carbon emission metrics in vRealize Operations Manager Describe the VMware vSphere Memory Monitoring and Remediation (vMMR) functionality Describe how vMMR enhances the performance of vSphere DRS Security and Compliance Describe how to handle vTPM secrets when cloning a VM Manage OVF templates for VMs that are configured with vTPM Deploy an OVF template with vTPM Describe the enhancements to trusted binary enforcement in ESXi Describe ESXi 8 enhanced security features vSphere Lifecycle Manager Describe the enhancements to life cycle management of standalone ESXi hosts Manage the configuration profiles of ESXi hosts in a cluster with vSphere Lifecycle Manager Use Auto Deploy to boot a host with the desired image and configuration specifications Upgrade multiple ESXi hosts in a cluster in parallel Stage an ESXi host image prior to remediation Auto Deploy Manage custom host certificates using Auto Deploy vSphere with Tanzu Describe the features of the Tanzu Kubernetes Grid 2.0 offering Announcing vSphere+ Describe the functionality and benefits of vSphere+

Duration 2 Days 12 CPD hours This course is intended for Designed for individuals new to the business analyst role or those who supervise and/or work with business analysts. Overview Understand the role of the business analyst Discuss industry standards/resources for obtaining more information about business analysis Acquire a solid understanding of the various tasks/activities that comprises business analysis Recognize the pre and post project business analysis activities Learn how to plan, elicit, analyze, model, and test requirements This is an introductory course designed to provide students with a basic understanding of the benefits, functions and impact a business analyst has within an organization. The course discusses the business analysis process as it is applied throughout a project as well as the pre-project activities that comprise strategy analysis. Students learn how a business analyst supports the project throughout the solution development life cycle, from defining business needs and solution scope to validating that requirements have been met in the testing phase and ensuring the solution continues to provide value after implementation. Introduction to Business Analysis Business analysis defined The activities that comprise business analysis IIBA/PMI and the goals of a professional association IIBA?s BABOK© Guide and PMI?s Practice Guide in Business Analysis Exercise: Requirements challenges The IIBA? and the role of the Business Analyst Business analyst defined BA role vs. PM role Importance of communication/collaboration The deliverables produced as part of business analysis The BA career path Exercise: Review case Study Strategy Analysis and Change The definition of Strategy Analysis Components of Strategy Analysis Identifying stakeholders and business needs Exercises: Business Need development and RACI Stakeholder Identification Understanding and Defining Solution Scope Defining Solution Scope Project scope vs. product scope Defining a problem statement Techniques for defining scope Exercises: Conduct a brainwriting session and create a context diagram Optional exercise: Create a Use Case Diagram Understanding Requirements Define the term requirement Understand requirement types Present the requirements process Requirements vs. specifications and business rules Exercise: Identify Requirements Planning & Eliciting Requirements The Requirements Work Plan (RWP) Components of the RWP Identifying good questions for elicitation Active listening Categories and types of elicitation techniques Exercise: Planning for elicitation Analzying & Documenting Requirements Understanding requirements analysis The Business Requirements Document (BRD) The BRD vs. the functional requirements specification BRD components The purpose of packaging requirements Exercise: Analyzing Requirements Elicitation & Process Modeling Why models are created Objectives of modeling What is process management Understanding process modeling Modeling using BPMN AS-IS vs. TO-BE modeling BPMN subclasses BPMN simple structure Prototyping Business Process Modeling case study Exercises: Modeling and create a Prototype of your application Verifying & Validating Requirements The difference between validation and verification Characteristics of good requirements Risks associated with requirements Types of testing approaches Creating a test plan Requirements traceability matrix Verified and validated requirements Exercise: Testing Requirements Additional Resources Helpful links for obtaining additional business analysis information Additional course details: Nexus Humans BA01 - Business Analysis Essentials 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 BA01 - Business Analysis Essentials 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.

Nowadays, Adobe After Effects CC broadly used in the post-production process of filmmaking and video production. In this Adobe After Effects CC course, you will equip yourself with multiple tools that empower you to improve your videos with expert motion graphics. Besides, you will learn powerful techniques to create the most detailed animations, implement animation effect, use graph editor, combine appealing backgrounds, colour creation, layouts and more. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.

The purpose of this Adobe Premiere Pro CC course is to provide you with the necessary editing techniques, and teach you the several panel windows to editing clips, including audio work, creating sequence presets, titles, keyboard shortcuts, colour correction, exporting media, etc. Upon successful completion, you will be able to get started with Adobe's video editing program and create appealing visual and audio stories in the quickest time possible. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate.

From dreaming to constructing, the transition is an intricate journey. 'From Blueprint to Reality: Building Construction Fundamentals' is your key to unravelling the multifaceted universe of construction. With a comprehensive curriculum encompassing everything from Construction Management to the nuances of Demolition, this course delves deep, offering insightful perspectives on the construction industry's inner workings. Stepping into this course, one gets a holistic view of the industry, covering a range of topics including site set-up, vital regulations, risk management, and even the intricate aspects of electricity. A significant emphasis is laid on modules such as Occupational Health Management and Construction Project Management, ensuring learners are well-equipped with robust knowledge. Learning Outcomes Understand the core concepts of construction management and site preparation. Grasp the essentials of CDM regulations and their application. Evaluate and manage risks, focusing on occupational health. Develop expertise in cost estimation and materials management for construction projects. Master the practical aspects like working at heights, scaffolding, and excavations. Why buy this From Blueprint to Reality: Building Construction Fundamentals? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this From Blueprint to Reality: Building Construction Fundamentals for? Aspiring construction managers seeking a comprehensive understanding of the field. Architects desiring an in-depth look at construction operations. Safety officers keen to enhance their knowledge in construction health and safety. Quantity surveyors aiming to expand their expertise in cost estimation. Professionals in the construction sector looking to upskill and gain a competitive edge. Career path Construction Manager: £50,000 - £70,000 Site Supervisor: £30,000 - £45,000 Health and Safety Manager: £35,000 - £55,000 Quantity Surveyor: £40,000 - £60,000 Project Manager: £45,000 - £75,000 Demolition Specialist: £30,000 - £50,000 Prerequisites This From Blueprint to Reality: Building Construction Fundamentals does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Construction Management Construction Management 00:08:00 Module 02: Site Set-Up Site Set-Up 00:16:00 Module 03: Construction Design and Management (CDM) Regulations Construction Design and Management (CDM) Regulations 00:08:00 Module 04: Risk Identification, Assessment and Management Risk Identification, Assessment and Management 00:11:00 Module 05: Management of Occupational Health Management of Occupational Health 00:12:00 Module 06: Cost Estimation in the Construction Industry Cost Estimation in the Construction Industry 00:19:00 Module 07: Management of Material for Construction Management of Material for Construction 00:10:00 Module 08: Electricity Electricity 00:15:00 Module 09: Working at Height Working at Height 00:14:00 Module 10: Scaffolding Scaffolding 00:07:00 Module 11: Excavations and Confined Space Excavations and Confined Space 00:15:00 Module 12: Demolition Demolition 00:12:00 Module 13: Construction Project Management Construction Project Management 00:20:00

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL. Overview Discuss basic relational database concepts Use some of the OLAP features of DB2, such as GROUPing and RANKing functions Create tables, views and indexes Use referential integrity, check constraints and triggers Use outer joins, and join tables to themselves Use CASE expressions, and the CAST function Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables Use complex subqueries Use a greater number of scalar SQL functions Use advanced SQL constructs, such as recursive SQL and table expressions Define User-Defined Distinct Types and User-Defined Functions Avoid several of the most common causes for poorly-performing SQL This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows. Introduction Identify the purpose of the clauses in the SELECT statement Describe the key differences among the IBM DB2 platforms Describe and use some of the OLAP features of DB2, such as GROUPING functions like CUBE and ROLLUP, and the RANK, DENSE_RANK and ROW_NUMBER functions Create Objects Code statements to: Create tables and views, Alter tables, Create indexes, Implement referential integrity (RI), and Define triggers and check constraints Identify impacts and advantages of referential integrity, including impacts of delete rules Identify considerations when using triggers and check constraints Define and make use of INSTEAD OF triggers Join Retrieve data from more than one table via inner and outer joins Use outer joins (LEFT, RIGHT, FULL) Use ANTI JOINS Join a table to itself Use UNION and UNION ALL Use EXCEPT and INTERCEPT CASE, CAST, Summary Tables, and Materialized Query Tables Identify when CASE expressions can be used Code CASE expressions in SELECT list and in the WHERE clause Identify when CAST specifications can be used Identify the advantages of using Summary (Materialized Query) Tables and Temporary tables Identify the advantages of using Materialized Query Tables (MQTs) Identify when and how to use Temporary tables Using Subqueries Code subqueries using the ALL, ANY/SOME, and EXISTS keywords Code correlated subqueries Choose the proper type of subquery to use in each case Scalar Functions Extend your knowledge of scalar functions which: Manipulate arithmetic data, Manipulate date values, and Manipulate character data Examples of scalar functions that are addressed in this course: SUBSTR POSSTR COALESCE/VALUE DECIMAL ROUND DIGITS CHAR DATE/TIME Table Expressions and Recursive SQL Identify reasons for using table expressions and recursive SQL Use nested and common table expressions Identify the difference between views and table expressions Code recursive SQL Control the depth of recursion when coding recursive SQL UDTs/UDFs and Performance Describe the concepts behind User-Defined Types, User-Defined Functions and Stored Procedures Predict when queries will use indexes to get better performance Identify concepts of predicate processing State introductory concepts about index structure State general best practices advice Additional course details: Nexus Humans CE131 IBM DB2 SQL Workshop for Experienced Users training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the CE131 IBM DB2 SQL Workshop for Experienced Users course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Duration 1 Days 6 CPD hours This course is intended for The audience for this course includes professionals who are new to Looker who are interested in leveraging Looker for data analysis, visualization, and reporting. The course is designed for individuals seeking to gain a comprehensive understanding of Looker's functionalities and apply these skills in their organizations to drive data-driven decision-making. Overview Working in a hands-on learning environment led by our expert facilitator, you'll explore and gain: Solid foundation in Looker's platform: Acquire a comprehensive understanding of Looker's key features, functionality, and interface, enabling you to effectively utilize the platform for your data analysis and visualization needs. Proficiency in LookML and data modeling: Develop essential skills in Looker's unique data modeling language, LookML, to create efficient and customized data models tailored to your organization's specific requirements. Expertise in creating Explores: Learn how to build, customize, and save Explores with dimensions, measures, filters, and calculated fields, empowering you to analyze your data and uncover valuable insights in a short amount of time. Mastery of dashboard design and visualization: Gain the skills to design visually appealing and informative dashboards, create various types of visualizations, and customize them to effectively communicate your data story. Improved content organization with folders and boards: Understand how to effectively use folders and boards in Looker to organize, manage, and discover content, making your data insights easily accessible for you and your team. Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker is a one day, hands-on course designed to equip professionals from a variety of backgrounds with the knowledge and skills needed to harness the full potential of their data using Looker's powerful platform. With the guidance of our expert trainers, you will gain a basic understanding of Looker's features, enabling you to create visually engaging, interactive, and insightful reports and dashboards to drive informed decision-making. Throughout this interactive workshop, you will explore Looker's key functionalities, including connecting to data sources, mastering LookML, building custom Explores, and designing captivating dashboards. With about 40% of the course dedicated to hands-on labs and a guided project, you will have ample opportunity to apply the skills you've learned in real world scenarios. Don't miss this opportunity to elevate your data analysis and visualization capabilities, enhance your professional skill set, and unlock the power of data-driven decision making. Getting Started with Looker Overview of Looker and its key features Navigating the Looker interface Connecting to Data Sources and LookML Basics Setting up and managing data connections Exploring database schemas Understanding LookML: Looker's data modeling language Creating and Customizing Explores Building and customizing Explores Adding dimensions, measures, and filters Creating calculated fields Data Visualization and Dashboard Design Creating visualizations using Looker's visualization library Customizing chart types, colors, and labels Displaying visualizations in dashboards Organizing Content with Folders and Boards Introduction to folders and boards in Looker Creating and managing folders for organizing content Setting up boards for easy content discovery Hands-on Workshop and Project Participants work on a guided project to apply the skills learned Wrap-up and Q&A Additional course details: Nexus Humans Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) 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 Looker Basics: Quick Start to Analyzing and Visualizing Data using Looker (TTDVLK01) 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.