14628 Courses

Duration 2 Days 12 CPD hours This course is intended for This SQL training course is designed for students new to writing SQL queries. Overview Upon successful completion of this course, students will be able to: - Understand how relational databases work - Use SQL to output reports - Write queries to obtain data from multiple tables. Students will learn SQL to build applications or to generate business reports.The SQL learned in the course is applicable to all major databases. Relational Database Basics Brief History of SQL Relational Databases Popular Databases SQL Statements Simple SELECTs Introduction to the Northwind Database Some Basics SELECTing All Columns in All Rows Exploring the Tables SELECTing Specific Columns Sorting Records The WHERE Clause and Operator Symbols Using the WHERE clause to check for equality or inequality Using the WHERE clause to check for greater or less than Checking for NULL Using WHERE and ORDER BY Together The WHERE Clause and Operator Words More SELECTs with WHERE Checking Multiple Conditions Writing SELECTs with Multiple Conditions Advanced SELECTs Calculated Fields Calculating Fields Aggregate Functions and Grouping Working with Aggregate Functions Built-in Data Manipulation Functions Data Manipulation Functions Subqueries, Joins and Unions Subqueries Joins Using Joins Outer Joins Unions Working with Unions If time allows, one or more of the following may be covered: Conditional Processing with CASE INSERT, UPDATE, DELETE Student Challenges - Design your own reports

Excavator training for all levels from experienced operators to complete novice excavator training

Looking to master Linux? Explore IPSR's comprehensive Linux online training for a robust learning experience. Our meticulously designed Linux online training course covers everything, ensuring a deep understanding of Linux systems, commands, and administration. With IPSR's Linux online training, dive into the world of open-source mastery, learning from industry experts at your convenience. Gain hands-on experience and practical skills in Linux administration, scripting, security, and more. Our tailored curriculum and interactive sessions empower learners to tackle real-world challenges confidently. Join IPSR's Linux online training to unleash your potential and become proficient in Linux, setting yourself on a path to career success in the tech industry.

An online mental health awareness training course that is designed to support you to have confident conversations with xxxx,xxxxx & colleagues who have and are showing early signs and symptoms of mental health problems.

Embark on a journey into the world of professional hygiene with the 'British Cleaning' course, a comprehensive guide to mastering the art of cleaning. This programme offers an in-depth look at the cleaning industry, blending theoretical knowledge with practical skills. You'll explore various facets, from health and safety protocols to specialised cleaning methods. The curriculum is meticulously crafted, ensuring a rich learning experience. It encompasses the essentials of workplace cleanliness, delving into the intricacies of floor, carpet, and upholstery maintenance. Additionally, the course covers the effective use of cleaning chemicals, ensuring a safe and efficient approach to tackling dirt and grime. The second segment focuses on enhancing your proficiency in specific areas like window, glass, washroom, and kitchen cleaning. This variety ensures a well-rounded skill set, vital for thriving in the cleaning industry. With each module, you'll gain valuable insights into the practical application of cleaning techniques, preparing you for real-world challenges. Whether it's handling delicate fabrics or dealing with tough stains, this course equips you with the necessary expertise. Lastly, the course culminates with a focus on sustainability and eco-friendly practices, aligning with modern standards and public expectations. You'll learn how to choose and utilise environmentally responsible cleaning agents, contributing to a healthier planet. This contemporary approach not only enhances your skill set but also aligns with the growing demand for sustainable practices in every sector, including cleaning. Learning Outcomes Acquire foundational understanding of the cleaning industry and its standards. Develop expertise in various cleaning techniques and methods. Gain proficiency in using different cleaning chemicals safely and effectively. Master specialised skills in cleaning diverse environments, including washrooms and kitchens. Understand and implement eco-friendly cleaning practices. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Who is this course for? Individuals aspiring to pursue a career in the cleaning industry. Current cleaning professionals seeking to enhance their skills. Facility managers responsible for maintaining high standards of cleanliness. Entrepreneurs planning to start a cleaning business. Environmental enthusiasts aiming to learn sustainable cleaning practices. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path Domestic Cleaner: £18,000 - £22,000 per annum Commercial Cleaner: £19,000 - £23,000 per annum Cleaning Supervisor: £20,000 - £25,000 per annum Facility Manager: £30,000 - £40,000 per annum Carpet Cleaning Specialist: £20,000 - £26,000 per annum Window Cleaning Expert: £18,000 - £24,000 per annum Course Content British Cleaning Introduction to the Cleaning Industry Health and Safety in Cleaning Cleaning Techniques and Methods Cleaning Chemicals Workplace Cleaning Floor Cleaning and Maintenance Carpet and Upholstery Cleaning Window and Glass Cleaning Washroom Cleaning Kitchen Cleaning

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is as follows: Phone Network Administrators Phone Network Engineers Data System Administrators Entry-level Network Engineers Channel Partners/Resellers, Customers, Employees Overview Describe the Cisco Unified Communications Manager network, service, and features Understand the importance of and configuration of redundancy and high availability in the enterprise network Describe user configuration and the user web interface Explain basic phone options and the use of BAT Explain the route plan and on-net/off-net calling Describe the various media resources, including conferencing and MOH Describe the basic phone features and use of hunt groups Administering Cisco Unified Communications Manager (ACUCM) v12.0 is a 3-day training program that provides system administrators and networking professionals with an understanding of the Cisco Unified Communications Manager System. The Cisco IT training course teaches the concepts of IP telephony based in system administration, including its function, features, and configuration. This is an entry-level IP telephony course that begins with the basic concepts of IP telephony and very quickly moves the learner forward into an understanding of system concepts: clustering, creation of phones and users, route plans, digit manipulation, media resources, and phone features, which are all important to supporting IP telephony in the enterprise network. The course focuses on Cisco Unified Communications Manager version v12.x.The course is geared to individuals that will be using and managing the system and performing administration for Level 1 and Level 2 support. Level 1 support is geared toward supporting phone users and making moves, adds, and changes to the desktop phone environment. Level 2 support is oriented to supporting changes in the organization, such as opening new office locations or relocating departments. The Cisco training course does not cover issues of initial deployment, new cluster deployment or international deployments. Also, the course does not cover issues with the underlying network that involves routers, switches, or Cisco IOS software configuration. Exploring IP Telephone Traditional Voice versus IP Telephony Clustering Overview Intracluster Communications Cisco Unified Communications Manager Clusters Clustering Options Platform Requirements Describing Deployment Models Single-Site Deployment Centralized Call-Processing Deployment Distributed Call-Processing Deployment Distributed Single-Cluster Call-Processing Deployment Hybrid Call-Processing Deployment New Advanced Multicluster Options Understanding Advanced Multisite Features Need for CAC Deploying AAR Survivable Remote Site Telephony SRST Failover Logging in to Cisco Unified Communications Manager Logging In to Cisco Unified CM Administration and Cisco Unified Serviceability Logging In to Cisco Unified Operating System Administration and the DRS Navigation Menu Command-Line Interface Examining Basic Server Configuration Server Configuration?Eliminating DNS Reliance Configuring Enterprise Parameters Describing Multilevel Administration Configuring Multilevel Administration Creating End Users Creating Roles Creating User Groups Assigning Users to User Groups Configuring DRS Backup and Restore Procedures DRS Backup Procedures DRS Restore Procedures Understanding User Configuration Understanding User Management Configuring Users Using the User Web Pages Understanding the User Web Pages Using the User Web Pages Configuring System Parameter Cisco Unified CM Configuration Cisco Unified Communications Manager Group Configuration Phone NTP Configuration Date/Time Group Codecs and Regions Location Configuration Device Pool Configuration DHCP Service Configuration Device Defaults Configuration Clusterwide Parameters Licensing Supporting Cisco Unified IP Phones Cisco Unified IP Phones Overview Specialized Cisco Unified IP 7900 Series Phones Phone Button Templates Softkey Templates Exploring Phone Registration and IP Phone Communications Cisco Unified IP Phone Registration Cisco Unified IP Phone Configuration Utilizing the Bulk Administration Tool (BAT) Overview of Cisco Unified Communications Manager BAT Cisco Unified Communications Manager TAPS Implementing Dial Plan Connectivity Organizational Dial Plan Trunks Gateways Creating Route Plans Dial Plan Overview Route Pattern Overview Digit Collection Call Routing Configuring Transition Patterns and Route Filters Translation Patterns The 9.@ Pattern Route Filters Implementing Digit Manipulation Discard Digits Instruction Transformation Masks Route Plan Report Defining Class of Control Overview of Class of Control Partitions CSS Configuration PLAR Application Using Class of Control Features Call Restriction Time of Day Routing Traditional vs. Line/Device Approach Defining Media Resources Overview of Media Resources Conference Bridge Media Termination Points Transcoder Music on Hold Annunciator Exploring Media Resource Management MRG Management Configuring MRGs Configuring MRGLs Describing Basic Features Call Park Call Pickup Cisco Call Back Shared Lines with Barge and Privacy Exploring Hunt Groups Hunt Group Overview Line Group Configuration Hunt List Configuration Hunt Pilot Configuration Final Forwarding Describing Phone Services Cisco IP Phone Services Cisco Phone Services Configuration

SAP Training London: Overview What is SAP? SAP is one of the largest ERP(Enterprise Resource Planning) software in the world. It provides end to end solution for Financials, Manufacturing, Logistics, Distributions etc. SAP applications, built around their latest R/3 system, provide the capability to manage financial, asset, and cost accounting, production operations and materials, personnel, plants, and archived documents. The R/3 system runs on a number of platforms including Windows and MAC and uses the client/server model. SAP Business Cases/ Live Project Our SAP training courses are designed in a way which gives the students maximum exposure of real-life scenario through no of business cases and guidance on implementation by professional SAP Consultants. Free SAP Access Free SAP Sandbox Access provided for 6 months so that you can practice even after your SAP training course. Certificate of Attendance- You receive a certificate once you finish the course from Osborne Training,  You can also do an external exam to receive certification from SAP (Optional), for details on exam booking you may visit the SAP website. SAP Training Modules Available Financial & Controlling (FICO) High-Performance Analytic Appliance (HANA) Supply Relationship Management (SRM) Customer Relationship Management (CRM)

LGBTQIA+ Awareness training for individuals, companies and organisations

EQ is a pattern of how people's biases in their thinking leads them to think one choice or thing is better than another, as well as their clarity in differentiating within those biases to exercise clear and sound judgement. Where your thinking and responses lie within your biases spectrum, and your ability in adjusting to the situation you find yourself in, will determine responses equating to poor or strong Emotional Intelligence (EI). This course will enhance and promote the skill set necessary for any working leader or manager, allowing our in-depth emotional intelligence knowledge to be applied into your working environment. From an employer's perspective, this award can be a significant long-term return on investment by further developing your leaders and managers. What Does This Course Offer? Our program offers an EQ-SWOT™ assessment and EI Model in detail, and through activity and discussion we explore how applying and possibly adjusting, you may offer an improved Emotional Intelligence. Our learning experiences are successful because the outcomes are quickly embedded and demonstrate an immediate visible impact on the day-to-day working environment. Our engaging learning inspires employees to want to personally add value to the companies they work for. We also offer our Paradigm EQ-SWOT™ online assessment and report as a frame of reference within the program. This assessment should be completed before attending the program, and will be expanded upon during the program delivery. Course Content The Emotional Intelligence for Today’s Leadership and Management course covers the following topics: What makes EI so important within the workplace Self-Awareness and your EQ Profile The EQ unpacked Unconscious Bias & EI How to develop your EI quotient Accreditation Activity Our accredited tutors deliver training that encourages delegates to confidently and practically apply all they have learnt as soon as they get back into the business. To achieve this award, delegates need to prepare and deliver a 3 minute presentation* on the highlights of their learning and immediate application avenues when back in their working environment. *Participants will be given 30 minutes during the program to prepare for their 3 min presentation at the end of the program. Scheduled Course Dates Unfortunately this course is not currently scheduled as an open course as it is primarily run as an in-house programme. For more information, please contact us. In-House Courses This is our own management training course which has been developed and refined over the many years we have been providing it to delegates from organisations in virtually every industry. This means that the course syllabus is extremely flexible and can be tailored to your specific requirements. If you would like to discuss how we can tailor this management training course for you and/or run it at your premises, please contact us.

Duration 4 Days 24 CPD hours This course is intended for Information Assurance Managers/Auditors System Implementors/administrators IT Administrators Auditors/Auditees Federal Agencies/Contractors Security Vendors and Consulting Groups Overview Upon completion, the IS20 Security Controls candidate will be able to not only competently take the IS20 Controls exam but will also have an understanding of how to implement the top 20 most critical controls in the work place. IS20 controls are the Top Twenty Most Critical Security Controls in Information Technology.ÿ This 4 day training course covers proven tools and methodologies needed to execute and analyze the Top Twenty Most Critical Security Controls. Nearly all organizations that maintain sensitive information are adopting these Security Controls. These controls were chosen by leading government and private organizations who are experts on how attacks work and what can be done to prevent them from happening. The controls were selected as the best way to block known attacks as well as help search for and alleviate any damage from the attacks that are successful. This course allows the security professional to see how to implement controls in an existing network through highly effective and economical automation. For management, this training is the best way to distinguish how you will assess whether these security controls are effectively being administered. Introduction Critical Control 1 Critical Control 2 Critical Control 3 Critical Control 4 Critical Control 5 Critical Control 6 Critical Control 7 Critical Control 8 Critical Control 9 Critical Control 10 Critical Control 11 Critical Control 12 Critical Control 13 Critical Control 14 Critical Control 15 Critical Control 16 Critical Control 17 Critical Control 18 Critical Control 19 Critical Control 20