• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

8433 Courses

Level 4 Diploma in Counselling Practice

By Step Into Learning

Do you want a rewarding career working directly with people? Would you like to make a difference to their everyday lives? If you are warm, open and compassionate and can bring a patient and non-judgemental attitude, a career in counselling could be for you. The Level 3 Certificate is the second stage on the journey to becoming a qualified counsellor.

Level 4 Diploma in Counselling Practice
Delivered In-Person in Launceston + 1 moreFlexible Dates
£2,882

Showreel Booster Weekend Course

By Actors Studio

With Sarah Hannah Introduction Looking to film a fresh scene for your acting showreel but want to improve your confidence on camera before shooting? Look no further! Join our weekend intensive screen acting course designed to push you further, increase your knowledge, and elevate your screen acting techniques. Meet Your Tutor Sarah Hannah Actress, Acting and Audition Coach Sarah Hannah is a highly experienced Professional Actress, Acting and Audition Coach. Bringing her extensive experience of working on stage and on screen, Sarah will focus on enhancing your presence on camera and cover the technical skills required of a professional screen actor. Course Outline This immersive experience goes beyond the basics, increasing your knowledge and enhancing your toolbox of screen acting techniques. Following a day of filming with a professional crew, you’ll receive a digital copy of your edited scene—an impressive addition to your showreel, showcasing your refined skills. This course is suitable if you have had previous acting training are a drama school graduate or professional actor. Additional Information Features Suitable if you are (17 yrs+) and have had previous acting training, drama school graduate or professional actor Attracts a varied age range from 17 yrs+. International Students Welcome The course is taught in English, so it is important that you have proficient English language skills Small Class Size Create a truthful and technically confident on screen performance In-depth exploration of screen acting techniques Film a scene that will be edited for your acting showreel Suitable follow-on course if you have completed our Crash Course Weekend Beginners Course Learning Outcomes Create a truthful and technically confident on screen performance In-depth exploration of screen acting techniques Film a scene that will be edited for your acting showreel Improve your collaboration skills within a group Course Location Actors Studio, Pinewood Studios, Pinewood Road, Iver Heath, Buckinghamshire, SL0 0NH Free parking available at Pinewood Studios Nearest Train Stations: Uxbridge Tube Station, Slough and Gerrards Cross. Transfer from station to Pinewood Studios – 10 minutes Coffee shop on site (may not be open at weekends) Excellent transport links from London

Showreel Booster Weekend Course
Delivered In-PersonFlexible Dates
£349

Windows server 2019 administration

5.0(3)

By Systems & Network Training

Windows server 2019 administration course description This five-day instructor-led course is designed primarily for IT professionals who have some experience with Windows Server. It is designed for professionals who will be responsible for managing identity, networking, storage and compute by using Windows Server 2019, and who need to understand the scenarios, requirements, and options that are available and applicable to Windows Server 2019. The course teaches IT professionals the fundamental administration skills required to deploy and support Windows Server 2019 in most organizations. What will you learn Administrate Windows Server 2019. Configure file servers and storage. Manage Hyper-V virtualization and containers. Implement HA and disaster recovery solutions. Implement service monitoring and performance monitoring, and apply troubleshooting. Perform upgrades and migration related to AD DS, and storage. Windows server 2019 administration course details Who will benefit: Technical staff working with Windows server 2019. Prerequisites: TCP/IP foundation for engineers. Some Windows experience. Duration 5 days Windows server 2019 administration course contents Windows server administration overview Windows server administration principles and tools, Introducing Windows Server 2019, Windows Server Core Overview. Lab: Deploying and configuring Server Core, Implementing and using remote server administration. Identity Services in Windows server AD DS, Windows Server domain controllers, Azure AD, Group Policy, Active Directory Certificate Services. Lab: Deploying a new domain controller on Server Core, Configuring Group Policy, Deploying and using certificate services. Network Infrastructure services in Windows server DHCP, DNS services, IPAM. Lab: Deploying and configuring DHCP, Deploying and configuring DNS. File Servers and Storage management Volumes and file systems, sharing in Windows Server, Storage Spaces in Windows Server, Data Deduplication, Iscsi, Distributed File System. Lab: Implementing Data Deduplication, Configuring iSCSI storage, Configuring redundant storage spaces, Implementing Storage Spaces Direct. Hyper-V virtualization and containers Hyper-V in Windows Server, Configuring VMs, Securing virtualization in Windows Server, Containers in Windows Server, Overview of Kubernetes. Lab: Creating and configuring VMs, Installing and configuring containers. High Availability in Windows Server Planning for failover clustering implementation, Creating and configuring failover cluster, stretch clusters, High availability and disaster recovery solutions with Hyper-V VMs. Lab: Configuring iSCSI storage, Configuring a failover cluster, Deploying and configuring a highly available file server, Validating the highly available file server deployment. Disaster recovery in Windows Server Hyper-V Replica, Backup and restore infrastructure in Windows Server. Lab: Implementing Hyper-V Replica, Implementing backup and restore with Windows Server Backup. Windows Server security Credentials and privileged access protection, Hardening Windows Server, Just Enough Administration in Windows Server, Securing and analyzing SMB traffic, Windows Server update management. Lab: Configuring Windows Defender Credential Guard, Locating problematic accounts, Implementing LAPS. Remote Desktop Services in Windows Server Remote Desktop Services, session-based desktop deployment, personal and pooled virtual desktops. Lab: Implementing RDS, Configuring RemoteApp collection settings, Configuring a virtual desktop template. Remote access and web services in Windows Server Overview of RAS in Windows Server, Implementing VPNs, Implementing NPS, Implementing Always On VPN, Implementing Web Server in Windows Server. Lab: Implementing Web Application Proxy, Implementing VPN in Windows Server, Deploying and Configuring Web Server. Monitoring, performance, and troubleshooting Windows Server monitoring tools, Performance Monitor, Monitoring event logs for troubleshooting. Lab: Establishing a performance baseline, Identifying the source of a performance problem, Viewing and configuring centralized event logs, Identifying the source of a performance problem, Describe monitoring tools and performance monitoring in Windows Server, Describe event logging and perform event logging monitoring for troubleshooting purposes. Upgrade and migration in Windows Server AD DS migration, Storage Migration Service, Windows Server migration tools. Lab: Selecting a process to migrate server workloads, Planning how to migrate files by using Storage Migration Service.

Windows server 2019 administration
Delivered in Internationally or OnlineFlexible Dates
£2,797

Cryotherapy (Fat Freezing) Training Course

By Cosmetic College

Our accredited Cryotherapy (fat freezing) training course will give you in-depth training on what Cryotherapy is and how to safely and effectively perform the treatment on clients. Our Cryotherapy (fat freezing) training course will give you in-depth training on what Cryotherapy is and how to safely and effectively perform the treatment on clients. The CPD Group accredits our course. Course Entry Requirements: This course is suitable for both medics and non-medics. Level 3 in Beauty Therapy or equivalent is desirable Good command of English A minimum of 18 years Training is complimentary when you purchase the Beautier Cryo Pro machine. Contact us for the course and machine package prices. Course Pre-Study/Practical & Length: Training includes online theory plus 1-day face-to-face practical training and ongoing support. Course Agenda: During the training day, you will learn: - What Cryotherapy is - How our weight affects our health - How Cryotherapy works - Introduction to the operation of your machine - Client Consultation - Client Safety - Contraindications to treatment - Areas that can be treated - How to perform a treatment - Handset positioning for all areas - Side Effects - Pre and Post-treatment advice - Machine Maintenance - General Troubleshooting - FAQs Course Benefits Student Benefits Comprehensive Knowledge: By enrolling in this course, you will gain a comprehensive understanding of cryotherapy and its application in fat reduction and body contouring. You will learn about the science behind fat freezing, the technology involved, treatment protocols, and safety considerations. This knowledge will make you a confident and competent practitioner in cryotherapy. Practical Hands-on Experience: Our training course emphasises practical training, allowing you to gain hands-on experience in performing cryotherapy treatments. Under the guidance of experienced instructors, you will learn the correct application techniques, treatment planning, and client assessment. This practical experience will enhance your skills and prepare you to deliver effective treatments. Diversify Your Skill Set: Cryotherapy is a popular non-surgical body sculpting technique that is in high demand. By enrolling in this course, you will expand your skill set and offer a sought-after treatment to your clients. Diversifying your services can attract new clients and increase your earning potential. Client Satisfaction: Cryotherapy provides clients with a non-invasive and non-surgical option for fat reduction and body contouring. By learning the techniques and protocols of cryotherapy, you can help clients achieve their desired body goals and boost their self-confidence. Client satisfaction will contribute to your professional reputation and potentially lead to referrals. Client Benefits Effective Fat Reduction: Cryotherapy treatments can selectively target and eliminate unwanted fat cells in specific areas of the body, such as the abdomen, thighs, arms, and love handles. By providing cryotherapy services, you can help clients achieve noticeable and long-lasting fat reduction results. Non-Invasive and Safe: Cryotherapy is a non-invasive alternative to surgical procedures, offering clients a safe and comfortable treatment option. Clients can benefit from fat reduction without the risks, downtime, or scarring associated with invasive methods. Body Contouring and Improved Confidence: Cryotherapy can help clients contour their bodies and achieve a more sculpted appearance. By reducing stubborn fat deposits, cryotherapy can enhance body shape and proportions, leading to improved confidence and self-esteem. Earning Potential Expanded Service Offerings: Offering cryotherapy services can attract new clients and increase your revenue streams. By diversifying your services to include fat freezing, you can cater to clients seeking non-surgical body sculpting solutions. Repeat Clients and Referrals: Satisfied clients who achieve their desired fat reduction results are more likely to become repeat customers. They may also refer their friends, family, and acquaintances to experience cryotherapy treatments with you. This can significantly contribute to your earning potential. Growing Demand: Cryotherapy for fat reduction and body contouring has gained significant popularity in recent years. As more individuals seek non-invasive alternatives to surgical procedures, the demand for cryotherapy services continues to grow. By becoming a skilled cryotherapy practitioner, you position yourself to meet this demand and increase your earning potential. Frequently Asked Questions How can I book? We have a few options for you to book. You can book by selecting an available training date above here on our website, by contacting us through email at hello@cosmetic.college or by contacting us on 0333 015 5117. Where is the Cosmetic College The Cosmetic College is located at: 3 Locks Court, 429 Crofton Road, Orpington, BR6 8NL Is a deposit required to book? All enrolments are charged an administration fee which is non-refundable. When you enrol you can elect to pay a deposit of 10% plus the administration fee or pay the total training course in full. We have full details of the terms and conditions of training course enrolments here What is the course duration? 1 day + pre-study via our online learning platform. What will I learn in this training course? In this course, you will learn about the principles of cryotherapy, the science behind fat freezing, and the technology used in the process. You will also gain practical knowledge and hands-on experience in performing cryotherapy treatments, including client assessment, treatment planning, application techniques, and post-treatment care. Are there any prerequisites for enrolling in the course? No specific prerequisites are required to enrol in the Cryotherapy (Fat Freezing) Training Course. However, having a basic understanding of anatomy and physiology can be beneficial. We welcome individuals from various backgrounds, including beauty professionals, aestheticians, and those interested in entering the field of non-surgical body sculpting. Will I receive a certification upon completion of the course? Yes, upon successful completion of the Cryotherapy (Fat Freezing) Training Course, you will receive a certification. This certification will validate your training and demonstrate your competence in performing cryotherapy treatments for fat reduction and body contouring. Is hands-on training included in the course? Absolutely! Our training course includes hands-on training to ensure that you gain practical experience in performing cryotherapy treatments. Under the guidance of our experienced instructors, you will have the opportunity to practice the techniques on models, allowing you to develop confidence and proficiency in delivering effective treatments. What equipment and technology will be used during the training? We use state-of-the-art cryotherapy equipment and technology in our training course. You will learn how to operate and utilise the specific equipment used for fat freezing treatments. Our instructors will guide you on the correct usage and ensure your understanding of the technology involved. Can I start offering cryotherapy services after completing the course? Yes, upon completion of the Cryotherapy (Fat Freezing) Training Course, you will have the knowledge and skills to start offering cryotherapy services to your clients. You will be equipped to provide safe and effective treatments, helping clients achieve their desired fat reduction and body contouring goals.

Cryotherapy (Fat Freezing) Training Course
Delivered In-PersonFlexible Dates
£350

CWISA Wireless IoT Solutions Administrator

5.0(3)

By Systems & Network Training

CWISA training course description This CWISA course covers wireless technologies with reference to IoT. It examines from an IoT perspective how wireless works, and is an excellent introduction to IoT for the wireless engineer. Topics range from wireless technologies, RF, to mobile networks, IoT, and security. What will you learn Describe wireless networking and IoT technologies. Explain basic RF communications. Plan wireless solutions. Describe how to implement wireless solutions. Use best practices in implementing wireless solutions. CWISA training course details Who will benefit: Anyone working with IoT technologies. Prerequisites: RF fundamentals. Duration 4 days CWISA training course contents Introduction to wireless technologies History of wireless, radio waves and frequencies, wireless technologies and related components, common components of wireless solutions, LAN networking requirements, Network security, Implementing wireless solutions, staging, documentation, security updates, Industry organizations, IEEE, compatibility and certification groups. Wireless network use cases Wireless BANs, Wireless PANs, Wireless LANs, Wireless MANs, Wireless WANs, Wireless sensor networks, New network driver-Internet of Things, IoT for industry (IIoT), IoT for connected vehicles, Residential environments, Retail, Education (K12), Higher education, Agriculture, Smart cities / Public access, Health care, Office buildings, Hospitality, Industry, Stadiums, arenas, and large public venues. Planning wireless solutions Identifying use cases and applications, common wireless requirements and constraints, performing a wireless system design, selecting and evaluating design parameters. RF communications RF wave characteristics, RF propagation behaviours, RF signal metrics, fundamentals of wireless modulation. other wireless carriers, common frequency bands. Radio frequency hardware Hardware levels, basic RF hardware components (circuit board level), RF link types (use category). RF device types. Mobile communications networks Mobile networks, LTE, 5G, Use cases. Short-range, low-rate, and low-power networks RF and speed, RF and range, RF and power, 802.11, 802.15.4, Bluetooth, LoRa (Long range) / LoRaWAN, ZigBee, 6LoWPAN, NB-IoT and LTE-M. Wireless sensor networks What is a Wireless Sensor Network (WSN)? WSN applications, Sensors and actuators, WSN architectures, Planning a WSN. Internet of Things (IoT) Internet of Things (IoT) defined, IoT history and its definition revisited, one more comment on the definition of IoT, IoT verticals, Oil & Gas, IoT structure/ architecture basics, IoT connected objects. Securing wireless networks Confidentiality, integrity and availability, Privacy, non-repudiation, authenticity & safety, Importance of authentication in wireless networks, Key cryptographic technologies & concepts, Authentication methods, Authorisation, OAuth 2.0 authorisation framework, monitoring. Troubleshooting wireless solutions Proper solutions design, designing and implementing wireless solutions, basic installation procedures, general configuration considerations, troubleshooting and remediation, troubleshoot common problems in wireless solutions. Programming, scripting and automation What is an API? categories of APIs, common API communication methods, choosing a language, why are we integrating systems? Application & integration architectures. Data structures & types, XML, YAML, API types.

CWISA Wireless IoT Solutions Administrator
Delivered in Internationally or OnlineFlexible Dates
£2,797

Rеsin Floor Courses

By Gafflow Resin Solutions

When it comes to booking a resin course, either for a career in resin flooring, or for your own resin pouring projects, you are in absolutely the best place. Our courses not only provide you with the knowledge and skill you’ll need to work with resin surfaces, but the enthusiasm too. You will leave us full of ideas and a desire to get started pouring the flooring, immediately! Our resin installers are not just resin trainers, we work in the industry, completing regular resin installations for both residential and commercial clients and we pass all of our knowledge through experience onto you, our clients. Our courses will give you both practical and theoretical knowledge in order to understand all aspects of a resin business. Depending on the course you undertake, you will learn about: Health and Safety aspects to working with resin. The benefits of Epoxy Resin Flooring. How to calculate quantities of resin products according to the size of your project. How to prime your surfaces for resin pouring, and which surfaces are suitable. How to apply long lasting top coats. How to deal with potential issues and troubleshooting with resin products. How to use resin to create other stunning surfaces - not just floors! How to effectively cost your epoxy resin projects, whether it's for flooring or any other resin surface. Unique sales and marketing advice for your resin business. We have an expert team of graphic designers, copy writers and website designers, all experienced in the resin industry. Our experts are highly trained and experienced when it comes to resin pouring. We have completed a huge number of installations and trained many people to do the same. Our passion and enthusiasm is infectious and we do not leave you behind once you have finished your resin floor training course.  We offer ongoing advice and support, discount on resin products and resin specific industry business advice. We are also on hand to help you with your own resin installations should you need an extra hand. A brilliant asset to have whilst establishing your own resin pouring company.  Our resin training courses leave you INSPIRED, EDUCATED and RARING TO GET STARTED. We cannot wait to meet you!    1 Day Taster Course – £295 Everything you need to know to start working with resin and create stunning resin floors. You will leave this one day taster session knowing how to successfully install a range of resin products, the maintenance and aftercare. Lunch included. 3 Day Intensive Course – £995 The training programme spans over three days of immersive learning, with both theory and hands-on workshops. The resin course will be held in our training unit where you will have your own individual training bay, enabling you to get a true sense of installing on a real floor. You will work with our industry experts, learning all steps to working with resin products to create visually stunning, long lasting floors.  Full resin floor installation process from preparation through to the finish. Detailed run through of all products used in the creation of resin flooring. Our course teaches you how to create special flooring effects using our resin products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Full technical support and exclusivity to a range of our resin floor products. 5 Day 1-1 training – £3500 The most advanced course we offer. This 1 to 1 training is in-depth and is a complete journey into the world of resin. Learning 1 to 1 with industry professionals. Completing a full installation process, from preparation through to the finish. In-depth presentation and theory. Learn how to create special flooring effects using our products. Learn the secrets to creating similar floor designs as seen on our social media pages. Create your own sample board to take home. Lunch provided. Training manuals provided. Advice on costing installation. Marketing advice on how to create a successful business. Full technical support and exclusivity to a range of our products. On Site Masterclass – £POA Every so often we bring you the most unique experience by joining us for an on-site masterclass. If you’re keen to learn more, please let us know and we’ll add you to the list! What support do I get after a course? Rest assured we remain on hand to give you any advice you may need. From product choices to technical questions, we remain contactable. We also offer ongoing business support with a range of bespoke packages to get you set up.  We have helped many people start their resin flooring businesses and know what works! We have ongoing support for marketing / graphic design / websites with bespoke packages. Please let us know and we’ll talk you through.

Rеsin Floor Courses
Delivered In-Person in LondonFlexible Dates
£295 to £3,500

MySQL for developers

5.0(3)

By Systems & Network Training

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797

Maintenance Planning, Scheduling & Control

By EnergyEdge - Training for a Sustainable Energy Future

About this Training Course Whether you are maintaining an oil rig or processing plant, good quality maintenance is critical to delivering a safe reliable product to your customers. Whatever your level of maintenance experience, this course will equip you with the valuable skills and understanding that will enhance your maintenance career. Too often the maintenance department is seen as the cause of why assets are unavailable, in poor condition yet are costing too much to maintain. By comparison, pace setting companies see maintenance as adding value to their assets and employ an integrated, holistic approach to their maintenance activities. This course will help you move towards that pace setting performance. This course is based on an integrated maintenance model that has been used by leading companies and consultants with success and recognised as best practice. Participants will learn the total impact that maintenance can have on a business, identify key elements (and value) of effective maintenance for their own plants to not only reduce costs but also improve performance. The critical types of maintenance will be covered from day-to-day activities to shutdowns and reliability improvement. The course will break down traditional functional boundaries and encourage a holistic approach to maintenance. With an organisation's maintenance process only as good as its weakest link, this course will guide participants through all the key steps of a maintenance process and its supply chain. Participants will understand what is considered a good standard for each step in the maintenance process, how to identify the weakest links and subsequently how they can accelerate their performance improvement. Participants will have the option of gaining a Bronze Level qualification from the Academy of Turnarounds Operations of Maintenance. For those who obtain a pass, they will receive a Pass certificate and for those who achieve the top quartile score, they will receive a Distinction level pass. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, participants will be able to: Explain the challenges and objectives facing maintenance organisations today Demonstrate the importance of work order systems and use techniques for time estimations and priority assignments Prepare a preventive maintenance program Apply project management techniques to effectively manage major maintenance activities and shut downs Use capital budgeting techniques to evaluate maintenance capital expenditures Demonstrate understanding of how to maintain the optimal stock levels of spare parts to ensure operational continuity Prepare the right Key Performance Indicators (KPIs) to evaluate and improve performance in maintenance Target Audience This course is not just for maintenance professionals. Maintenance teams cannot perform without effective integration with operations and supply chain functions. Availability losses are often caused by operations or design issues and pace setting companies have generated significant benefits by integrating operation and maintenance strategies and working more collaboratively. This course will help all members of the operations and maintenance teams and their supply chain better understand their respective roles in ensuring that maintenance is benefitting and not inhibiting their business. Course Level Basic or Foundation Trainer Your expert course leader is a highly experienced facilitator in maintenance improvement, change management, continuous improvement and capability development as a management coach and trainer. He has a strong focus on people with an emphasis on developing people and the practicalities of improving maintenance performance rather than just the theory. He has worked internationally across Europe, America, the Middle East and Africa with extensive experience in Oil and Gas, the Chemicals sector and manufacturing as well as working with clients in Steel and Power Generation. As a result, he can bring best practice from a wide variety of sources. He spent the first fifteen years of his career as a specialist trainer working for companies such as Lloyds British Training Services and Rolls Royce. He then went on to work as a Principal consultant for ABB consulting for 15 years. During this time, he refined some of the established improvement tools including how and when to apply them for maximum impact whilst still continuing to develop and deliver training in support of this. Recent work has included improvements to the Work Order to Work Execution processes of Engineering departments and focused on Reliability, Planning and Scheduling. This ongoing field experience has helped him test and refine specialist training in a number of areas. He has been able to use his own experience to contribute with other maintenance specialists to the Carcharodon models of excellence. Its methodologies are recognised as 'Best of the Best' standards providing the inspiration for two books, projects that have won awards such as the prodigious UK Chemical Industries annual Excellence in Engineering award and form the basis of this training. He was recently awarded a national award as coach of the year. He uses the same skills to ensure that he does not just preach maintenance best practice, he discusses it, explains it and ensures that delegates have a much more personal and flexible experience. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Maintenance Planning, Scheduling & Control
Delivered in Internationally or OnlineFlexible Dates
£3,009 to £3,499

Hydra Dermabrasion Facials Training Course

By Cosmetic College

Hydra-Dermabrasion Facial is designed for the experienced beauty facial specialist who wants to as a new treatment to their menu; you will need to have completed a Facial diploma or equivalent first for all the underpinning knowledge and experience needed for advanced facial treatments. Want to step into the next era of skin rejuvenation? Hydradermabrasion is a refreshing, exfoliating and hydrating facial suitable for all skin types and ages.  Remove blocked pores, resurface the skin, and brighten and plump with long term scientific evidence to support the regeneration of the epidermal barrier and an increase in collagen production.  Clients love this new alternative to microdermabrasion which is non-invasive, gentle yet effective. Course prerequisites No previous experience is necessary. However, we would recommend facial and skin training course for students new to the industry. Good command of English Minimum 18 years Course structure This course structure consists of online independent study, vertical lectures and an in house practical session. All courses are intimate with four learners in class 2-1 ratio. Areas covered within the course: Bespoke First Aid for the Beauty Sector Health, Safety and Hygiene for the Beauty Sector Anatomy and Physiology What are Hydra-Dermabrasion Facials? Benefits of Hydra-Dermabrasion Facials Facial Products and Equipment Full consultation process Treatment Set-Up Client Consultation Process and Procedure Hydra-Dermabrasion Facial Step by Step Procedure Hydra-Dermabrasion Facial Demonstration Aftercare The technology you will learn: Hydro peel skin cleansing Radiofrequency skin tightening Ultrasound Ion face lifting Transdermal infusion Frequently Asked Questions How can I book? We have a few options for you to book. You can book by selecting an available training date above here on our website, by contacting us through email at hello@cosmetic.college or by contacting us on 0333 015 5117. Where is the Cosmetic College The Cosmetic College is located at: 3 Locks Court, 429 Crofton Road, Orpington, BR6 8NL Is a deposit required to book? All enrolments are charged an administration fee which is non-refundable. When you enrol you can elect to pay a deposit of 10% plus the administration fee or pay the total training course in full. We have full details of the terms and conditions of training course enrolments here What is the course duration? 1 day + pre-study via our online learning platform. What qualifications do I need to be able to enrol on this course? No prior qualifications or experience is required for you to enrol onto this course, however for those new to the industry we recommend to enrol onto our Facial & Skincare course to maximise their potential with this course.

Hydra Dermabrasion Facials Training Course
Delivered In-PersonFlexible Dates
£350

HARNESS & LANYARD COURSE

4.6(26)

By MCL Height Safety

This course is for persons required to work in specified locations, e.g. MEWP’s, scaffolding, window cleaners, lift engineers and maintenance operatives. The course provides skills, knowledge and competence to select and use the correct harness and lanyard for the work task.

HARNESS & LANYARD COURSE
Delivered In-PersonFlexible Dates
£145