160 Courses in London

About this Virtual Instructor Led Training (VILT)  Electrification of the transportation sector will impact the power system in several ways. Besides the additional load, local impact on the grid needs to be managed by the grid operators. Simultaneously charging of many electric vehicles (EVs) might exceed the limits in specific locations. On the other hand, EVs can provide flexibility and other ancillary services that will help grid operators. This 3 half-day VILT course will provide a complete overview of integrating electric vehicles (EVs) into the power grid. It will cover the whole value chain from grid operations to the car battery. This includes the control room, possible grid reinforcement, demand side management and power electronics. This course will demonstrate the impact on the grid and solutions for a safe & cost-effective grid plan and operation, with examples of successful integration of EVs. The course will also provide vital knowledge about technology used for EVs such as power electronics, demand side management, communication and batteries. In this context, the focus will be on power electronics as it has the highest impact on the grid. The grid planning tool, pandapower, is introduced as an open source tool for power system modelling. The set-up of the training course allows for discussion and questions. Questions can be formulated by the participants upfront or during the training. This course is delivered in partnership with Fraunhofer IEE. Training Objectives At the end of this course, the participants will: Understand the charging options for EVs and its impact on the grid and batteries Identify system services for EVs with regards to voltage quality at the point of common coupling Discover what are the 'grid friendly' and grid supporting functions in EVs Uncover the different applications, standards and data researched on EVs Examine the application of a grid planning tool (pandapower) for power system modelling Be able to develop code snippets with pandapower Apply and execute a code example for power system modelling with pandapower Target Audience EV and grid project developers and administrators Power grid operators and planners EPC organisations involved in grid development EV/ battery manufacturers and designers EV transport planners and designers Government regulators and policy makers Training Methods The VILT will be delivered online in 3 half-day sessions comprising 4 hours per day, with 2 x 10 minutes breaks per day, including time for lectures, discussion, quizzes and short interactive exercises. Additionally, some self-study will be requested. Participants are invited but not obliged to bring a short presentation (10 mins max) on a practical problem they encountered in their work. This will then be explained and discussed during the VILT. A short test or quiz will be held at the end of every session/day. Trainer Our first course expert is Head of Department Converters and Electrical Drive Systems at Fraunhofer IEE and Professor for Electromobility and Electrical Infrastructure at Bonn-Rhein-Sieg University of Applied Sciences. He received his engineering degree in automation in 2008 by the THM Technische Hochschule Mittelhessen (FH Giessen-Friedberg). Afterwards he studied power engineering at University of Kassel and received his diploma certificate in 2010. In 2016 he received the Ph.D. (Dr.-Ing.) from the University of Hannover. The title of his dissertation is Optimized multifunctional bi-directional charger for electric vehicles. He has been a researcher at the Fraunhofer IEE in Kassel since 2010 and deals with power converters for electric vehicles, photovoltaics and wind energy. His current research interests include the bidirectional inductive power transfer, battery charger and inverter as well as new power electronic components such as SiC MOSFETs and chokes. Additionally, our key expert is Chairman of the IEEE Joint IAS/PELS/IES German Chapter and a member of the International Scientific Committee of the EPE Association. Our second course expert is deputy head of energy storage department at Fraunhofer IEE. Prior to this he was the Director of Grid Integration department at SMA Solar Technology AG, one of the world's largest manufacturers of PV power converters. Before joining SMA, our course expert was manager of the Front Office System Planning at Amprion GmbH (formerly RWE TSO), one of the four German transmission system operators. He holds a degree of electrical engineering of the University of Kassel, Germany. In 2003 he finished his Ph.D. (Dr.-Ing.) on the topic of wind power forecasting at the 'Institute of Solar Energy Supply Technology' (now Fraunhofer IEE) in Kassel. In 2004 he started his career at RWE TSO with main focus on wind power integration and congestion management. Our course expert is chairman of the IEC SC 8A 'Grid Integration of Large-capacity Renewable Energy (RE) Generation' and has published several papers about grid integration of renewable energy source and forecasting systems on books, magazines, international conferences and workshops. Our third course expert is Research Associate at Fraunhofer IEE. He is actively working on different projects related to the integration of electric vehicle charging into the electric distribution grid. The focus of this work concerns time series based simulations for grid planning and operation in order to investigate the effect of a future rollout of electric vehicles and charging infrastructure on economics e.g. costs for grid reinforcement. He completed his master degree (MSc.) in Business Administration and Engineering: Electrical Power Engineering at RWTH Aachen University, Germany. Our trainers are experts from Fraunhofer Institute for Energy Economics and Energy System Technology (Fraunhofer, IEE), Germany. The Fraunhofer IEE researches for the national and international transformation of energy supply systems 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 about post training coaching support and fees applicable for this. Accreditions And Affliations

First Aid Courses. These can be at your venue or our training centre.

Level 7 MBA programme 

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Supporting Microsoft SQL server course description A concise hands on course enabling delegates to manage and administer a Microsoft SQL server database. What will you learn Install SQL server. Backup SQL server databases. Recover SQL server databases. Secure SQL server databases. Perform routine maintenance. Automate tasks. Supporting Microsoft SQL server course details Who will benefit: Anyone working with Microsoft SQL server Prerequisites: Supporting Windows server. Duration 3 days Supporting Microsoft SQL server course contents SQL server introduction Platform, Tools, services. Installation. Creating databases. Backups Back up types, transaction logging, restoring from a backup: Full database, individual files. Security Users, server roles, database roles. Permissions. Monitoring Routine database maintenance. Performance data. Jobs and alerts The SQL server agent, database mail, alerts, jobs.

Oracle SQL training course description The Oracle SQL course is designed to give delegates practical experience in writing SQL statements and scripts using Oracle SQL. The basic SELECT statement, the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create SQL statements to query database tables. Use standard aggregate functions and related SELECT statement clauses. Join Tables. Use basic subqueries and the set operators. Use numeric, character and date functions. Use conversion and other miscellaneous functions. Use SQL parameters. Use complex subqueries. Create and alter tables and views. Insert, update and delete rows in database tables. Manage sequences and synonyms. Oracle SQL training course details Who will benefit: Anyone who needs to use and understand Oracle SQL to query and update data in an Oracle database. Prerequisites: None. Duration 3 days Oracle SQL training course contents Retrieving data with the SELECT statement The SELECT statement, The SELECT and FROM clauses, Conditions and the WHERE clause, Other conditional operators, Logical operators, The ORDER BY clause, Column aliases, Arithmetic expressions, Precedence of operators. Aggregate functions Overview of built In aggregate functions, The GROUP BY clause, The HAVING clause. Joining tables Overview of table joins, Inner joins, Table aliases, Outer joins, Self joins, ANSI standard joins. Basic subqueries and set operators Overview of subqueries, Basic subqueries, Set operators, The union, intersect and ,minus operators. Numeric, character and data functions Function types, Using the table dual to try out functions, Numeric functions, Character functions, String concatenation, Date arithmetic and date functions. Conversion and miscellaneous functions Conversion functions, The NVL and NVL2 functions, The DECODE function, CASE expressions, The COALESCE and NULLIF functions. SQL parameters Command line substitution parameters, The accept command, The define and undefine commands. Complex subqueries Subqueries usage, In-line views, Top-N queries, Subqueries with joins, Multi column subqueries, Correlated subqueries, Subquery rules, Using the ANY, ALL and SOME operators. Managing data Inserting rows, Updating rows, Deleting rows, Verifying updates, Transaction control, Commit and rollback, Savepoints, Commits and constraints, Amending data in SQL developer. Managing tables Creating tables, Specifying constraints, Altering tables, columns and constraints, Dropping tables, columns and constraints, Recovering dropped tables, Copying tables. Managing indexes and views Creating indexes, Dropping indexes, Listing indexes, Creating and using views, Dropping views, Listing views. Managing sequences and synonyms Create a sequence, View sequence details, Create a synonym, List synonyms.

Database design training course description Although this course mentions Microsoft Access the same course can be run with a variety of different databases. The duration of the course is dependent on the experience of the delegates. What will you learn Name and give 3 types of database structure. Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to query and define databases. Describe the principles of relational database design and 3 types of relational joins. Normalise a given flat file table into relational tables. Database design training course details Who will benefit: Anyone who needs to be able to design an efficient, watertight database following the best practice of the principles of Relational Database design. Prerequisites: None. Duration 3 days Database design training course contents Database structure and terminology. Principles of Relational Database Design. Types of relationship. Normal Forms. Practical examples of relational database design. Hands-on creation of a database. On paper design a relational database applicable to the delegates work.

Database fundamentals training course description This three-day training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. What will you learn Describe core database concepts. Create database objects. Manipulate data. Describe data storage. Administer a database. Create a relational database consisting of 3 related tables. Database fundamentals training course details Who will benefit: Those working with databases. Prerequisites: None. Duration 3 days Database fundamentals training course contents Understanding core database concepts Flat-type databases, hierarchical databases, relational databases, database fundamentals, relational database concepts, using the SQL Server Management Studio Interface. Data Manipulation Language (DML), Data Definition Language (DDL), using DDL statements. Creating database objects Defining data types, using built-in data types, using exact numeric data types, using approximate numeric data types. Creating and using tables. Creating views. Creating stored procedures, SQL injections. Manipulating data Using Queries to select data, combining conditions, using the BETWEEN clause, using the NOT clause, using the UNION clause, using the EXCEPT and INTERSECT clauses, using the JOIN clause. Using Queries to insert data, Inserting data. Updating data and databases, Using the UPDATE statement. Deleting data, Using the DELETE statement, truncating a table with TRUNCATE TABLE, deleting a table with DROP TABLE, using referential integrity. Understanding data storage Normalising a database, normalization, first normal form, second normal form, third normal form, fourth normal form, fifth normal form. Primary, foreign and composite keys, clustered and non-clustered indexes, creating a non-clustered table. Administering a Database Securing Databases, server-level security, database-level security, Windows security, SQL authentication, database server roles, granting access to a database, fixed database roles, object permissions, managing roles, ownership chains, reviewing a sample security model. Backing up and restoring databases, recovery models, backup devices.

Facilitated by Registered Clinicians with extensive experience

The BB Glow Facial is one of the newer facial treatments to reach the beauty market and is becoming an increasingly popular choice for many clients. A BB Glow Foundation Facial is a highly effective micro-needling treatment with immediate, lasting effects. This safe and intensive skin treatment can improve the facial tone and smooth out imperfections, freckles, and wrinkles. The treatment goal of using the micro-needle therapy system is to lighten and smooth the face's skin tone. In this course, you will learn how to create a semi-permanent foundation lasting for months, which hides facial imperfections. Learn the newest mesotherapy treatment loved by the world, which can also be available in your beauty salon. Course Entry Requirements:  This course is available for those that meet at least one of the following: Minimum 18 years NVQ Level 2 Beauty or equivalent desirable Good command of English Needling accredited training Course Pre-Study/Practical & Length: 20 hours of pre-study E-learning and 1 practical day Course Agenda This courses theory knowledge is delivered through our interactive e-learning training portal and completed with either: One day onsite training One day Zoom based training All courses are kept to a reduced size, with a maximum of six attendees per course. Areas covered in this course: Anatomy and physiology of face and skin The choice of colour for the type of skin Written documentation (treatment card) Photographic documentation The principles of hygiene Purpose of the treatment and the obtained effect Assessment of customer expectations Contraindications for BB Glow treatments Preparation of clients and positions for the procedure Application rules for anaesthesia Possible complications after treatments Types of pigments Insurance Practice: Practice on models Demonstration of the procedure on the model Enrolling in our BB Glow Foundation Training Course offers numerous benefits for students, as well as significant advantages for clients and potential earning potential. Let's explore these benefits in detail: Benefits for Students: Expertise in BB Glow Foundation: Our training course equips students with the knowledge and skills to master the BB Glow Foundation technique. You will learn the latest application techniques, colour theory, product selection, and client consultation. This specialised training will set you apart as a skilled BB Glow artist. Practical Hands-on Experience: We prioritise practical learning by providing extensive hands-on training opportunities. Under the guidance of experienced instructors, you will have the chance to practice the BB Glow Foundation technique on models. This practical experience will enhance your confidence and proficiency in delivering excellent results. Professional Advancement: By enrolling in our BB Glow Foundation Training Course, you are investing in your professional advancement. You will expand your skill set, stay updated with industry standards, and gain expertise in the popular BB Glow technique. This will enhance your professional reputation and open doors to new career opportunities. Benefits for Clients: Flawless and Radiant Skin: BB Glow Foundation is a popular semi-permanent makeup technique that creates the appearance of flawless, radiant skin. By enrolling in our training course, you will be able to offer this highly sought-after treatment to your clients. They will benefit from a semi-permanent foundation that evens out skin tone, hides imperfections, and provides a natural-looking glow. Time-saving Solution: Clients who opt for BB Glow Foundation can save time in their daily makeup routine. The semi-permanent nature of the treatment eliminates the need for daily foundation application, saving clients valuable time and effort. They can wake up with a fresh-faced look and feel confident throughout the day. Customised Results: As a trained BB Glow artist, you will have the expertise to customise the treatment to suit each client's skin tone and preferences. By selecting the appropriate pigments and adjusting the intensity, you can achieve personalised results that enhance the client's natural beauty. Clients will appreciate the tailored approach and individualized outcomes. Earning Potential: By offering BB Glow Foundation as part of your services, you can significantly increase your earning potential. The popularity of BB Glow treatments has been growing, and clients are willing to invest in achieving flawless, long-lasting skin. As a skilled BB Glow artist, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients are more likely to become repeat customers and refer others, further boosting your earning potential. Enrolling in our BB Glow Foundation Training Course will not only benefit you as a student but also provide valuable advantages for your clients and potential earning potential in the beauty industry. Begin your journey toward professional excellence and financial success by enrolling today. Frequently Asked Questions (FAQ) about our BB Glow Foundation Training Course: Is this course suitable for beginners or those with prior experience? Our BB Glow Foundation Training Course is designed for both beginners and experienced professionals in the beauty industry. Whether you are new to semi-permanent makeup or already have a background in the field, our course will provide you with the necessary knowledge and skills to master the BB Glow Foundation technique. What qualifications or prerequisites do I need to enrol in the course? No specific qualifications are required to enrol in our BB Glow Foundation Training Course. However, a passion for the beauty industry and a desire to learn and improve your skills are highly recommended. Our course is open to anyone who wants to gain expertise in the BB Glow technique. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in BB Glow Foundation. This certification recognises your skills and expertise in performing the BB Glow technique. It can enhance your professional credibility and assist you in building your career in the beauty industry. What topics are covered in the course curriculum? Our course curriculum covers a wide range of topics related to BB Glow Foundation, including skin anatomy and physiology, product knowledge, colour theory, sanitation and hygiene, consultation and client assessment, application techniques, aftercare, and touch-up procedures. The curriculum is designed to provide a comprehensive understanding of the technique and its application. Are there any hands-on training opportunities? Absolutely! Our BB Glow Foundation Training Course includes extensive hands-on training sessions. You will have the opportunity to practice the BB Glow technique on models under the guidance of experienced instructors. This practical experience is essential to develop your skills and confidence in performing the treatment effectively. Will I have access to ongoing support after completing the course? Yes, we provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you embark on your career in BB Glow Foundation. We aim to support your continued growth and success. Are there financing options available for the course? We offer flexible payment options and financing plans to make our BB Glow Foundation Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans. If you have any additional questions or require further clarification, please feel free to contact us. We are here to assist you throughout your training journey and beyond. Course Benefits Benefits for Students Expertise in BB Glow Foundation: Our training course equips students with the knowledge and skills to master the BB Glow Foundation technique. You will learn the latest application techniques, colour theory, product selection, and client consultation. This specialised training will set you apart as a skilled BB Glow artist. Practical Hands-on Experience: We prioritise practical learning by providing extensive hands-on training opportunities. Under the guidance of experienced instructors, you will have the chance to practice the BB Glow Foundation technique on models. This practical experience will enhance your confidence and proficiency in delivering excellent results. Professional Advancement: By enrolling in our BB Glow Foundation Training Course, you are investing in your professional advancement. You will expand your skill set, stay updated with industry standards, and gain expertise in the popular BB Glow technique. This will enhance your professional reputation and open doors to new career opportunities. Benefits for Clients Flawless and Radiant Skin: BB Glow Foundation is a popular semi-permanent makeup technique that creates the appearance of flawless, radiant skin. By enrolling in our training course, you will be able to offer this highly sought-after treatment to your clients. They will benefit from a semi-permanent foundation that evens out skin tone, hides imperfections, and provides a natural-looking glow. Time-saving Solution: Clients who opt for BB Glow Foundation can save time in their daily makeup routine. The semi-permanent nature of the treatment eliminates the need for daily foundation application, saving clients valuable time and effort. They can wake up with a fresh-faced look and feel confident throughout the day. Customised Results: As a trained BB Glow artist, you will have the expertise to customise the treatment to suit each client's skin tone and preferences. By selecting the appropriate pigments and adjusting the intensity, you can achieve personalised results that enhance the client's natural beauty. Clients will appreciate the tailored approach and individualised outcomes. Earning Potential By offering BB Glow Foundation as part of your services, you can significantly increase your earning potential. The popularity of BB Glow treatments has been growing, and clients are willing to invest in achieving flawless, long-lasting skin. As a skilled BB Glow artist, you can attract a larger clientele and set competitive pricing for your services. Satisfied clients are more likely to become repeat customers and refer others, further boosting your earning potential. Enrolling in our BB Glow Foundation Training Course will not only benefit you as a student but also provide valuable advantages for your clients and potential earning potential in the beauty industry. Begin your journey toward professional excellence and financial success by enrolling today. Frequently Asked Questions Where is the Cosmetic College The Cosmetic College is located at: 3 Locks Court, 429 Crofton Road, Orpington, BR6 8NL 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. 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 Is this course suitable for beginners or those with prior experience? Our BB Glow Foundation Training Course is designed for both beginners and experienced professionals in the beauty industry. Whether you are new to semi-permanent makeup or already have a background in the field, our course will provide you with the necessary knowledge and skills to master the BB Glow Foundation technique. Will I receive a certification upon completion? Yes, upon successfully completing our training course, you will receive a certification in BB Glow Foundation. This certification recognises your skills and expertise in performing the BB Glow technique. It can enhance your professional credibility and assist you in building your career in the beauty industry. What topics are covered in the course curriculum? Our course curriculum covers a wide range of topics related to BB Glow Foundation, including skin anatomy and physiology, product knowledge, colour theory, sanitation and hygiene, consultation and client assessment, application techniques, aftercare, and touch-up procedures. The curriculum is designed to provide a comprehensive understanding of the technique and its application. Are there any hands-on training opportunities? Absolutely! Our BB Glow Foundation Training Course includes extensive hands-on training sessions. You will have the opportunity to practice the BB Glow technique on models under the guidance of experienced instructors. This practical experience is essential to develop your skills and confidence in performing the treatment effectively.  Will I have access to ongoing support after completing the course? Yes, we provide ongoing support to our students even after they complete the training course. Our instructors and support staff are available to answer any questions, provide guidance, and offer assistance as you embark on your career in BB Glow Foundation. We aim to support your continued growth and success.  Are there financing options available for the course? We offer flexible payment options and financing plans to make our BB Glow Foundation Training Course more accessible. Please reach out to our admissions team for detailed information on available payment options and financing plans. If you have any additional questions or require further clarification, please feel free to contact us. We are here to assist you throughout your training journey and beyond.