306 Courses

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.

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.

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.

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.

Enhance your knowledge in Engineering Procurement Construction Contracts (EPC) with our EnergyEdge course. Join us for comprehensive classroom training today!

Handset and/or Voicemail Training 1600’s, 1400, 96/95 series handsets, J Series and voicemail One X Communicator One-X Mobile IX Workplace Desktop and Mobile App Web Conferencing Collaboration System Administration Training up to Release 11 Voicemail Pro Administration Training ACCS Agent, Supervisor and Administration Training XIMA/CHRONICALL/ACR Agent, Realtime, Recording and Reporting

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

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.

Facilitated by Registered Clinicians with extensive experience

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.