6634 Admin courses

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites * Basic understanding of relational databases. * Basic Windows knowledge. MODULE 1: INTRODUCTION TO TRANSACT-SQL * What is Transact-SQL * The SELECT statement * The WHERE clause * Sorting results * Calculations * CASE expressions MODULE 2: JOINING TABLES WITH TRANSACT-SQL * The JOIN clause * Inner joins * Outer joins * Self joins and cross joins MODULE 3: FILTERING AND SORTING RESULTS * Implement the ORDER BY clause * Filter data with the WHERE clause * Limit the number of rows returned by a query * Implement NULL logic MODULE 4: SQL SERVER DATA TYPES * Understand data types * Implement string data types * Implement temporal data types MODULE 5: INSERTING, UPDATING AND DELETING DATA * Insert new records * Update existing records * Delete data MODULE 6: USING SQL SERVER FUNCTIONS WITH TRANSACT-SQL * Understand function types in SQL Server * Convert data using functions * Implement logical functions * Work with NULL data using functions MODULE 7: AGGREGATING DATA WITH TRANSACT-SQL * Implement aggregation in SQL Server * Group records in SQL Server * Filter aggregated data MODULE 8: IMPLEMENT SUBQUERIES WITH TRANSACT-SQL * Implement scalar and multi-valued sub-queries * Implement correlated subqueries * Implement existence checks with subqueries MODULE 9: CREATE QUERIES THAT USE TABLE EXPRESSIONS * Create views * Create table-valued functions * Implement derived tables * Implement common table expressions MODULE 10: USE UNION, INTERSECT, EXCEPT AND APPLY ON MULTIPLE SETS OF DATA * Write queries with the UNION operator * Write queries with the INTERSECT and EXCEPT operators * Write queries with the APPLY operator MODULE 11: IMPLEMENT WINDOW FUNCTIONS IN QUERIES * Understand window functions * Impement window functions MODULE 12: USE PIVOT AND GROUPING SETS IN QUERIES * Implement PIVOT in queries * Implement grouping sets in queries MODULE 13: USE STORED PROCEDURES IN QUERIES * Query data with stored procedures * Interact with stored procedures using input and output parameters * Write simple stored procedures * Pass dynamic SQL to SQL Server MODULE 14: IMPLEMENT PROGRAMMING FEATURES IN TRANSACT-SQL * Understand T-SQL programming elements * Implement loops and conditions in T-SQL queries MODULE 15: ADD ERROR HANDLING TO QUERIES * Understand SQL Server error handling * Implemet structured exception handling MODULE 16: USE TRANSACTIONS IN QUERIES * Understand database transactions * Implement transactions in T-SQL

Duration 5 Days 30 CPD hours This course is intended for This course is intended for existing IT professionals who have some networking knowledge and experience and are looking for a single course that provides insight into core and advanced networking technologies in Windows Server. This audience would typically include: Network administrators who are looking to reinforce existing skills and learn about new networking technology changes and functionality in Windows Server. System or Infrastructure Administrators with general networking knowledge who are looking to gain core and advanced networking knowledge and skills on Windows Server. Overview Plan and implement an IPv4 network. Implement Dynamic Host Configuration Protocol (DHCP). Implement IPv6. Implement Domain Name System (DNS). Implement and manage IP address management (IPAM). Plan for remote access. Implement DirectAccess. Implement virtual private networks (VPNs). Implement networking for branch offices. Configure advanced networking features. Implement Software Defined Networking. 55343A is the Community Courseware equivalent of retired Legacy Course 20741BC - Networking with Windows Server 2016. This 5-day classroom-based course provides the fundamental networking skills required to deploy and support Windows Server in most organizations. It covers IP fundamentals, remote access technologies, and more advanced content including Software Defined Networking. Although this course and the associated labs are written for Windows Server 2022, the skills taught will also be backwards compatible for Server 2016 and Server 2019. Prerequisites In addition to professional experience, students who attend this training should already have the following technical knowledge: Experience working with Windows Server Knowledge of the Open Systems Interconnection (OSI) model Understanding of core networking infrastructure components and technologies such as cabling, routers and switches Familiarity with networking topologies and architectures such as local area networks (LANs), wide area networks (WANs) and wireless networking Some basic knowledge of the TCP/IP protocol stack, addressing and name resolution Experience with and knowledge of virtualization Hands-on experience working with the Windows client operating systems such as Windows 10 or Windows 11 1 - PLANNING AND IMPLEMENTING AN IPV4 NETWORK * Planning IPv4 addressing * Configuring an IPv4 host * Managing and troubleshooting IPv4 network connectivity 2 - IMPLEMENTING DHCP * Overview of the DHCP server role * Deploying DHCP * Managing and troubleshooting DHCP 3 - IMPLEMENTING IPV6 * Overview of IPv6 addressing * Configuring an IPv6 host * Implementing IPv6 and IPv4 coexistence * Transitioning from IPv4 to IPv6 4 - IMPLEMENTING DNS * Implementing DNS servers * Configuring zones in DNS * Configuring name resolution between DNS zones * Configuring DNS integration with Active Directory Domain Services (AD DS) * Configuring advanced DNS settings 5 - IMPLEMENTING AND MANAGING IPAM * Overview of IPAM * Deploying IPAM * Managing IP address spaces by using IPAM 6 - REMOTE ACCESS IN WINDOWS SERVER * Overview of remote access * Implementing the Web Application Proxy 7 - IMPLEMENTING DIRECTACCESS * Overview of DirectAccess * Implementing DirectAccess by using the Getting Started Wizard * Implementing and managing an advanced DirectAccess infrastructure 8 - IMPLEMENTING VPNS * Planning VPNs * Implementing VPNs 9 - IMPLEMENTING NETWORKING FOR BRANCH OFFICES * Networking features and considerations for branch offices * Implementing Distributed File System (DFS) for branch offices * Implementing BranchCache for branch offices 10 - CONFIGURING ADVANCED NETWORKING FEATURES * Overview of high performance networking features * Configuring advanced Microsoft Hyper-V networking features 11 - IMPLEMENTING SOFTWARE DEFINED NETWORKING * Overview of SDN. * Implementing network virtualization * Implementing Network Controller

Duration 5 Days 30 CPD hours This course is intended for This course is intended for entry-level computer support professionals with a basic knowledge of computer hardware, software, and operating systems who wish to increase their knowledge and understanding of networking concepts and acquire the required skills to prepare for a career in network support or administration, or who wish to prepare for the CompTIA Network+ certification. CompTIA Network+ is the first certification IT professionals specializing in network administration and support should earn. Network+ is aimed at IT professionals with job roles such as network administrator, network technician, network installer, help desk technician, and IT cable installer. This course is also designed for students who are seeking the CompTIA Network+ certification and who want to prepare for the CompTIA Network+ N10-008 Certification Exam. Overview In this course, you will describe the major networking technologies and systems of modern networks and configure, manage, and troubleshoot modern networks. Explain the OSI and TCP/IP Models. Explain properties of network traffic. Install and configure switched networks. Configure IP networks. Install and configure routed networks. Configure and monitor ports and protocols. Explain network application and storage issues. Monitor and troubleshoot networks. Explain network attacks and mitigations. Install and configure security devices. Explain authentication and access controls. Deploy and troubleshoot cabling solutions. Implement and troubleshoot wireless technologies. Compare and contrast WAN technologies. Use remote access methods. Identify site policies and best practices. CompTIA's Network+ certification is a foundation-level certification designed for IT professionals with around one year of experience, whose job role is focused on network administration. The CompTIA Network+ exam will certify the successful candidate has the knowledge and skills required to troubleshoot, configure, and manage common network devices; establish basic network connectivity; understand and maintain network documentation; identify network limitations and weaknesses; and implement network security, standards, and protocols. The candidate will have a basic understanding of enterprise technologies, including cloud and virtualization technologies. The Official CompTIA© Network+© (Exam N10-008): will teach you the fundamental principles of installing, configuring, and troubleshooting network technologies and help you to progress a career in network administration. In this course, you will build on your existing user-level knowledge and experience with personal computer operating systems and networks to master the fundamental skills and concepts that you will need to use on the job in any type of networking career. Prerequisites * CompTIA A+ Certification (Exams 220-1001 and 220-1002) 1 - EXPLAINING THE OSI AND TCP/IP MODELS * Topic A: Explain OSI Model Layers * Topic B: Explain the TCP/IP Suite 2 - EXPLAINING PROPERTIES OF NETWORK TRAFFIC * Topic A: Explain Media Types and Access Methods * Topic B: Deploy Ethernet Standards * Topic C: Configure and Monitor Network Interfaces 3 - INSTALLING AND CONFIGURING SWITCHED NETWORKS * Topic A: Install and Configure Hubs and Bridges * Topic B: Install and Configure Switches * Topic C: Compare and Contrast Network Topologies * Topic D: Compare and Contrast Network Types 4 - CONFIGURING IP NETWORKS * Topic A: Configure IPv4 Addressing Components * Topic B: Test IP Interfaces with Command Line Tools * Topic C: Configure IPv4 Subnets * Topic D: Configure Private and Public IPv4 Addressing Schemes * Topic E: Configure IPv6 Addressing Components * Topic F: Configure DHCP Services 5 - INSTALLING AND CONFIGURING ROUTED NETWORKS * Topic A: Explain Characteristics of Routing * Topic B: Install and Configure Routers 6 - CONFIGURING AND MONITORING PORTS AND PROTOCOLS * Topic A: Explain the Uses of Ports and Protocols * Topic B: Use Port Scanners and Protocol Analyzers * Topic C: Explain the Use of Name Resolution Services * Topic D: Configure DNS and IPAM Services 7 - EXPLAINING NETWORK APPLICATION AND STORAGE SERVICES * Topic A: Explain the Uses of Network Applications * Topic B: Explain the Uses of Voice Services and Advanced Networking Devices * Topic C: Explain the Uses of Virtualization and Network Storage Services * Topic D: Summarize the Concepts of Cloud Services 8 - MONITORING AND TROUBLESHOOTING NETWORKS * Topic A: Monitor Network Interfaces and Logs * Topic B: Explain Network Troubleshooting Methodology * Topic C: Troubleshoot Common Network Services Issues 9 - EXPLAINING NETWORKING ATTACKS AND MITIGATIONS * Topic A: Summarize Common Networking Attacks * Topic B: Explain the Characteristics of VLANs * Topic C: Explain the Characteristics of NAT and Port Forwarding 10 - INSTALLING AND CONFIGURING SECURITY DEVICES * Topic A: Install and Configure Firewalls and Proxies * Topic B: Explain the Uses of IDS/IPS and UTM 11 - EXPLAINING AUTHENTICATION AND ACCESS CONTROLS * Topic A: Explain Authentication Controls and Attacks * Topic B: Explain the Uses of Authentication Protocols and Directory Services * Topic C: Explain the Uses of Port Security and NAC * Topic D: Implement Network Device Hardening * Topic E: Explain Patch Management and Vulnerability Scanning Processes 12 - DEPLOYING AND TROUBLESHOOTING CABLING SOLUTIONS * Topic A: Deploy Structured Cabling Systems * Topic B: Deploy Twisted Pair Cabling Solutions * Topic C: Test and Troubleshoot Twisted Pair Cabling Solutions * Topic D: Deploy Fiber Optic Cabling Solutions 13 - IMPLEMENTING AND TROUBLESHOOTING WIRELESS TECHNOLOGIES * Topic A: Install and Configure Wireless Technologies * Topic B: Troubleshoot Wireless Performance Issues * Topic C: Secure and Troubleshoot Wireless Connectivity 14 - COMPARING AND CONTRASTING WAN TECHNOLOGIES * Topic A: Compare and Contrast WAN Core Service Types * Topic B: Compare and Contrast WAN Subscriber Service Types * Topic C: Compare and Contrast WAN Framing Service Types * Topic D: Compae and Contrast Wireless and IoT WAN Technologies 15 - USING REMOTE ACCESS METHODS * Topic A: Use Remote Access VPNs * Topic B: Use Remote Access Management Methods 16 - IDENTIFYING SITE POLICIES AND BEST PRACTICES * Topic A: Manage Networks with Documentation and Diagrams * Topic B: Summarize the Purposes of Physical Security Devices * Topic C: Compare and Contrast Business Continuity and Disaster Recovery Concepts * Topic D: Identify Policies and Best Practices

Duration 5 Days 30 CPD hours This course is intended for This course is targeted to those seeking A+ Certification and anyone in these roles: IT Support Specialist Helpdesk Technician Field Technician Tier I Support Specialist Desktop Support Specialist Associate Network Engineer Systems Support Technician Junior Systems Administrator Overview At completion of this course, you will be able to: Install and configure end-user devices and software Address connectivity problems Perform basic cybersecurity mitigations Troubleshoot common problems to diagnose and resolve issues Demonstrate basic knowledge of scripting, the cloud, and virtualization CompTIA A+ certified professionals are proven problem solvers. They support today?s core technologies from security to networking to virtualization and more. CompTIA A+ is the industry standard for launching IT careers into today?s digital world. This course, prepares you for the CompTIA A+ Certification exams 220-1101 and 220-1102. LESSON 1: INSTALLING MOTHERBOARDS AND CONNECTORS * Topic 1A: Explain Cable Types and Connectors * Topic 1B: Install and Configure Motherboards * Topic 1C: Explain Legacy Cable Types LESSON 2: INSTALLING SYSTEM DEVICES * Topic 2A: Install and Configure Power Supplies and Cooling * Topic 2B: Select and Install Storage Devices * Topic 2C: Install and Configure System Memory * Topic 2D: Install and Configure CPUs LESSON 3: TROUBLESHOOTING PC HARDWARE * Topic 3A: Apply Troubleshooting Methodology * Topic 3B: Configure BIOS/UEFI * Topic 3C: Troubleshoot Power and Disk Issues * Topic 3D: Troubleshoot System and Display Issues LESSON 4: COMPARING LOCAL NETWORKING HARDWARE * Topic 4A: Compare Network Types * Topic 4B: Compare Networking Hardware * Topic 4C: Explain Network Cable Types * Topic 4D: Compare Wireless Networking Types LESSON 5: CONFIGURING NETWORK ADDRESSING AND INTERNET CONNECTIONS * Topic 5A: Compare Internet Connection Types * Topic 5B: Use Basic TCP/IP Concepts * Topic 5C: Compare Protocols and Ports * Topic 5D: Compare Network Configuration Concepts LESSON 6: SUPPORTING NETWORK SERVICES * Topic 6A: Summarize Services Provided by Networked Hosts * Topic 6B: Compare Internet and Embedded Appliances * Topic 6C: Troubleshoot Networks LESSON 7: SUMMARIZING VIRTUALIZATION AND CLOUD CONCEPTS * Topic 7A: Summarize Client-Side Virtualization * Topic 7B: Summarize Cloud Concepts LESSON 8: SUPPORTING MOBILE DEVICES * Topic 8A: Set Up Mobile Devices and Peripherals * Topic 8B: Configure Mobile Device Apps * Topic 8C: Install and Configure Laptop Hardware * Topic 8D: Troubleshoot Mobile Device Issues LESSON 9: SUPPORTING PRINT DEVICES * Topic 9A: Deploy Printer and Multifunction Devices * Topic 9B: Replace Print Device Consumables * Topic 9C: Troubleshoot Print Device Issues LESSON 10: CONFIGURING WINDOWS * Topic 10A: Configure Windows User Settings * Topic 10B: Configure Windows System Settings LESSON 11: MANAGING WINDOWS * Topic 11A: Use Management Consoles * Topic 11B: Use Performance and Troubleshooting Tools * Topic 11C: Use Command-line Tools LESSON 12: IDENTIFYING OS TYPES AND FEATURES * Topic 12A: Explain OS Types * Topic 12B: Compare Windows Editions LESSON 13: SUPPORTING WINDOWS * Topic 13A: Perform OS Installations and Upgrades * Topic 13B: Install and Configure Applications * Topic 13C: Troubleshoot Windows OS Problems LESSON 14: MANAGING WINDOWS NETWORKING * Topic 14A: Manage Windows Networking * Topic 14B: Troubleshoot Windows Networking * Topic 14C: Configure Windows Security Settings * Topic 14D: Manage Windows Shares LESSON 15: MANAGING LINUX AND MACOS * Topic 15A: Identify Features of Linux * Topic 15B: Identify Features of macOS LESSON 16: CONFIGURING SOHO NETWORK SECURITY * Topic 16A: Explain Attacks, Threats, and Vulnerabilities * Topic 16B: Compare Wireless Security Protocols * Topic 16C: Configure SOHO Router Security * Topic 16D: Summarize Security Measures LESSON 17: MANAGING SECURITY SETTINGS * Topic 17A: Configure Workstation Security * Topic 17B: Configure Browser Security * Topic 17C: Troubleshoot Workstation Security Issues LESSON 18: SUPPORTING MOBILE SOFTWARE * Topic 18A: Configure Mobile OS Security * Topic 18B: Troubleshoot Mobile OS and App Software * Topic 18C: Troubleshoot Mobile OS and App Security LESSON 19: USING SUPPORT AND SCRIPTING TOOLS * Topic 19A: Use Remote Access Technologies * Topic 19B: Implement Backup and Recovery * Topic 19C: Explain Data Handling Best Practices * Topic 19D: Identify Basics of Scripting LESSON 20: IMPLEMENTING OPERATIONAL PROCEDURES * Topic 20A: Implement Best Practice Documentation * Topic 20B: Use Proper Communication Techniques * Topic 20C: Use Common Safety and Environmental Procedures

Duration 3 Days 18 CPD hours This course is intended for The intended audience for this course is information security and IT professionals, such as network administrators and engineers, IT managers, and IT auditors, and other individuals who want to learn more about information security, who are interested in learning in-depth information about information security management, who are looking for career advancement in IT security, or who are interested in earning the CISM certification. Overview Establish and maintain a framework to provide assurance that information security strategies are aligned with business objectives and consistent with applicable laws and regulations. Identify and manage information security risks to achieve business objectives. Create a program to implement the information security strategy. Implement an information security program. Oversee and direct information security activities to execute the information security program. Plan, develop, and manage capabilities to detect, respond to, and recover from information security incidents. In this course, students will establish processes to ensure that information security measures align with established business needs. Prerequisites Information security governance Information risk management Information security program development Information security program management Incident management and response 1 - INFORMATION SECURITY GOVERNANCE * Develop an Information Security Strategy * Align Information Security Strategy with Corporate Governance * Identify Legal and Regulatory Requirements * Justify Investment in Information Security * Identify Drivers Affecting the Organization * Obtain Senior Management Commitment to Information Security * Define Roles and Responsibilities for Information Security * Establish Reporting and Communication Channels 2 - INFORMATION RISK MANAGEMENT * Implement an Information Risk Assessment Process * Determine Information Asset Classification and Ownership * Conduct Ongoing Threat and Vulnerability Evaluations * Conduct Periodic BIAs * Identify and Evaluate Risk Mitigation Strategies * Integrate Risk Management into Business Life Cycle Processes * Report Changes in Information Risk 3 - INFORMATION SECURITY PROGRAM DEVELOPMENT * Develop Plans to Implement an Information Security Strategy * Security Technologies and Controls * Specify Information Security Program Activities * Coordinate Information Security Programs with Business Assurance Functions * Identify Resources Needed for Information Security Program Implementation * Develop Information Security Architectures * Develop Information Security Policies * Develop Information Security Awareness, Training, and Education Programs * Develop Supporting Documentation for Information Security Policies 4 - INFORMATION SECURITY PROGRAM IMPLEMENTATION * Integrate Information Security Requirements into Organizational Processes * Integrate Information Security Controls into Contracts * Create Information Security Program Evaluation Metrics 5 - INFORMATION SECURITY PROGRAM MANAGEMENT * Manage Information Security Program Resources * Enforce Policy and Standards Compliance * Enforce Contractual Information Security Controls * Enforce Information Security During Systems Development * Maintain Information Security Within an Organization * Provide Information Security Advice and Guidance * Provide Information Security Awareness and Training * Analyze the Effectiveness of Information Security Controls * Resolve Noncompliance Issues 6 - INCIDENT MANAGEMENT AND RESPONSE * Develop an Information Security Incident Response Plan * Establish an Escalation Process * Develop a Communication Process * Integrate an IRP * Develop IRTs * Test an IRP * Manage Responses to Information Security Incidents * Perform an Information Security Incident Investigation * Conduct Post-Incident Reviews

This five-day Site management safety training scheme (SMSTS) course is designed for site managers, agents and persons who are, or are about to be, responsible for planning, organising, monitoring, controlling and administering groups of staff within a construction environment. The course covers all relevant legislation and other aspects which affect safe working in the building, construction and civil engineering industries. It highlights the need for risk assessment in the workplace, the implementation of the necessary control measures, and adequate communication to sustain a health and safety culture among the workforce. Delivered interactively, the course includes group and individual exercises, discussions and projects.

Do you want to boost your medical career by learning about the cannulation process? This comprehensive cannulation course is ideal for you!  You can learn about the whole venepuncture and cannulation procedure in this Venepuncture and Cannulation Training Course, as well as the safest methods for handling, flushing, and removing a cannula. This course will provide you with the necessary training to flourish in your profession, whether you are a novice or an experienced individual wishing to enhance your career in the healthcare industry.  -------------------------------------------------------------------------------- Course Highlights * Designed by healthcare professionals   * Accredited by the CPD Certification   * Recognised and Valuable Certification   * Self-Paced Online Theoretical Learning   * High-Quality  Study Materials  * Interactive practical training   -------------------------------------------------------------------------------- PRACTICAL DAY CLASS SCHEDULE – 1 DAY FACE-TO-FACE TRAINING  Venue Location London: Bank Studio, 23 Park Royal Road, NW10 7JH Date: 23rd June, 2024 Date: 25th August, 2024 Date: 29th October, 2024 Time: 10:00 am – 05:00 pm Venue Location Birmingham:  44 Blucher Street, Birmingham, B1 1QJ Date: 24th October, 2024 Date: 21st August, 2024 Date: 12th December, 2024 Time: 10:00 am – 05:00 pm This extensive IV Cannulation Course covers the following credentials:  * Selection of veins for cannulation  * Arm and hand physiology and anatomy  * Types of cannula   * Process of cannulation   * Safety measures   * Proper insertion of the cannula   CLASSROOM-BASED CANNULATION COURSE   Practical learning   We offer comprehensive theoretical study materials and practical sessions for our cannulation training. As part of the practical training, you will receive practical dry lab demonstrations and hands-on experience to justify your role.  -------------------------------------------------------------------------------- WHO IS THIS VENEPUNCTURE AND CANNULATION COURSE FOR?  This Venepuncture and Cannulation course is primarily aimed at:  * Health Visitors  * Healthcare professionals   * Nurses, midwives, pharmacists and doctors  * Freshers looking to begin their career in the healthcare sector  * Anyone looking to enhance their cannulation skills  AIMS AND LEARNING OUTCOMES OF THIS VENEPUNCTURE AND CANNULATION TRAINING COURSE  * Know how to select the appropriate veins for cannulation   * Understand the anatomy and physiology of hands and arms   * Recognise the various sizes of a cannula   * Identify the risks concerning cannulation   * Know how to insert the cannula properly   * Recognise the safety precautions that should be maintained   * Gain knowledge about the dressing procedure   * Know how to safely flush and remove a cannula   * Learn how to securely dispose of all the sharps   Learning how to perform Phlebotomy Training  [https://lead-academy.org/phlebotomy-training]and Catheterisation Training [https://lead-academy.org/course/catheterisation-training] can help you to provide better care to your patients. By being able to insert a catheter quickly and effectively, you can administer necessary treatments more efficiently, which can improve patient outcomes and reduce discomfort. ENTRY REQUIREMENTS * There are no academic entry requirements for this cannulation course, and it is open to students of all educational backgrounds.   * You need to join the Phlebotomy Training [https://lead-academy.cademy.co.uk/phlebotomy-training?occurrence=713e1556-934e-4302-afbd-b40a2d7a548d] before attending the Cannulation Training. ASSESSMENT METHOD In this Venepuncture and Cannulation training, learners will be assessed via observation. That means during the practical training, you will be observed by the supervisor/trainer. Upon successful demonstration of blood sampling and blood draw, you will be awarded a CPD-accredited certificate accepted by thousands of professional bodies and government regulators in the UK and worldwide. Whether you are a fresher looking to kickstart your career in healthcare or practising healthcare looking to enhance your cannulation skills, this course will help you achieve your professional aspirations by all means.   -------------------------------------------------------------------------------- COURSE CURRICULUM 1. Cannulation Training - Course Introduction 2. What are Venepuncture and Cannulation 3. Anatomy and Physiology of the Circulatory System 4. Legal Aspects of Venepuncture (Phlebotomy) and Cannulation 5. Practitioner Requirements 6. Professional Competence and Accountability 7. Documentation and Record Keeping 8. Vicarious Liability 9. Consent 10. Influencing Factors during Venepuncture 11. Infection Prevention and Management 12. Haemolysis 13. Selecting Correct Equipment 14. Procedure of Venepuncture and Cannulation 15. Order of Draw 16. Peripheral Cannula and Venepuncture 17. Procedure Prior to Cannulation 18. During Cannulation 19. Cannula Size and Cannulation Aftercare 20. Removal of Cannulation 21. Complications 22. Cannulation Training - Conclusion -------------------------------------------------------------------------------- RECOGNISED ACCREDITATION This course is accredited by Continuing Professional Development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. -------------------------------------------------------------------------------- CERTIFICATE OF ACHIEVEMENT ON SUCCESSFUL COMPLETION OF THE CANNULATION COURSE, YOU WILL BE ELIGIBLE TO OBTAIN A CPD-ACCREDITED CERTIFICATE OF ACHIEVEMENT AS PROOF OF YOUR NEW SKILL. THE CERTIFICATE OF ACHIEVEMENT IS AN OFFICIAL CREDENTIAL THAT CONFIRMS THAT YOU SUCCESSFULLY FINISHED A COURSE WITH LEAD ACADEMY. 

Duration 2 Days 12 CPD hours This course is intended for The primary audience for this course are persons who are new to reporting with Microsoft© SQL Server© Report Builder and SSRS, persons who are transitioning from another reporting software application, and persons who are existing Report Builder and SSRS report authors. The secondary audience for this course are persons who are using Report Designer (SSRS). Course participants may be business analysts, programmer analysts, data analysts, database administrators, or IT professionals and may or may not have experience with Microsoft© SQL Server© Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL) experience. Overview After completing this course, students will be able to: Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators. In this course, students will continue their learning on the foundations of report writing with Microsoft© SQL Server© Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data. 1 - PARAMETER REPORTS * Parameterized Reporting * Create Report Parameters * Modify Report Parameters * Provide Default Parameter Values * Provide Available Values for Parameters * Lab: Creating Parameterized Reports 2 - LIST DATA REGIONS * Introducing the List Data Region * Create Reports Using List Data Regions * Modify Reports Which Use List Data Regions * Lab: Creating List Reports 3 - ENHANCING REPORTS WITH COMPLEX EXPRESSIONS * Formatting Reports * Top N Reports * Running Values * Lab: Enhancing Reports with Complex Expressions 4 - ENHANCE REPORTS WITH IMAGES AND SUBREPORTS * Add Images to Reports * Retrieve Images from a Database * Introducing SSRS (SQL Server Reporting Services) Report Server * Add Subreports to Reports * Lab: Working With Images and Subreports 5 - DRILLDOWN AND DRILLTHROUGH REPORTS * Add and Configure Drilldown Reporting * Add and Configure Drillthrough Reporting * Lab: Add Drilldown and Drillthrough Functionality to Reports 6 - SPARKLINES, DATA BARS, AND INDICATORS * Sparklines * Data Bars * Indicators * Lab: Adding Sparklines, Data Bars, and Indicators to Reports ADDITIONAL COURSE DETAILS: Nexus Humans 55128 Writing Reports with Report Builder and SSRS Level 2 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 55128 Writing Reports with Report Builder and SSRS Level 2 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.

Level 5 QLS Endorsed Course with FREE Certificate | CPD & CiQ Accredited | 150 CPD Points | Lifetime Access

***24 Hour Limited Time Flash Sale*** Office Admin, Secretarial & PA Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unlock the doors to a fulfilling career with our Office Admin, Secretarial & PA bundle! This comprehensive package features 3 QLS-endorsed courses: Office Management, Legal Advisor, and GDPR Certificate, supplemented by 5 valuable CPD QS accredited courses: Legal Advisor, Business Writing, Document Control, Meeting Management Online - CPD Accredited, and Employment Law. This unique blend provides you with a hardcopy certificate and a profound understanding of key areas such as office administration, legal advisory, and GDPR practices. You will be well-equipped to handle office management duties, legal matters, document control, meeting management, and even master business writing skills. Dive into our Office Admin, Secretarial & PA bundle and evolve into the administrative professional you aspire to be! Key Features of the Office Admin, Secretarial & PA Bundle: * 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Office Admin, Secretarial & PA bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. * QLS Course 01: Office Management * QLS Course 02: Admin, Secretarial & PA Diploma * QLS Course 03: Minute Taking Executive Training * 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. * Course 01: Legal Advisor * Course 02: Business Writing * Course 03: Document Control * Course 04: Meeting Management Online - CPD Accredited * Course 05: Employment Law * In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. * Course 01: Professional CV Writing * Course 02: Job Search Skills * Course 03: Self Esteem & Confidence Building * Course 04: Professional Diploma in Stress Management * Course 05: Complete Communication Skills Master Class * Convenient Online Learning: Our Office Admin, Secretarial & PA courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Upon completing this bundle, you will: * Have an in-depth understanding of the principles and practices of office management. * Gain knowledge of legal advising in a business setting. * Understand GDPR regulations and its impact on businesses. * Master business writing techniques for effective communication. * Learn the process and importance of document control in businesses. * Develop skills to efficiently manage online meetings. * Understand Employment Law and its role in office administration. Our Office Admin, Secretarial & PA bundle offers a robust learning experience, bridging the gap between theory and practice. From Office Management to Legal Advisory and GDPR principles, you will acquire comprehensive knowledge to run an office efficiently. The Business Writing course will enable you to convey your thoughts effectively, while Document Control and Meeting Management courses enhance your organizational skills. Employment Law is another integral part of this bundle, offering you insights into legal responsibilities and employee rights. Each course in this bundle complements the other, forming a comprehensive curriculum that adds significant value to your professional journey. CPD 250 CPD hours / points Accredited by CPD Quality Standards WHO IS THIS COURSE FOR? This course bundle is perfect for: * Individuals aiming to begin their career in office administration, secretarial or PA roles. * Professionals seeking to enhance their skills in office management and legal advisory. * Existing office administrators or secretaries looking to advance their career. * Anyone interested in mastering the art of business writing, document control, and meeting management. CAREER PATH * Office Manager: The annual salary ranges between £22,000 to £45,000. * Legal Advisor: The annual salary ranges from £30,000 to £90,000. * GDPR Compliance Officer: The annual salary ranges from £25,000 to £65,000. * Business Writer: The annual salary ranges from £20,000 to £55,000. * Document Control Manager: The annual salary ranges from £25,000 to £60,000. CERTIFICATES DIGITAL CERTIFICATE Digital certificate - Included HARD COPY CERTIFICATE Hard copy certificate - Included