1141 Courses in Liverpool

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.

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Excel but different. Harness this most powerful tool but on a course tailored to your business and needs. Using case studies relevant to your business and often actual files your firm uses on a daily basis we embark on a voyage of discovery. This isn't a boring "watch what I do and copy" course. This is exciting, engaging, funny and enjoyable. Delegates will learn relevant skills but also, because of the delivery methods they will gain an increased enjoyment of using Excel and will retain and implement all of the material covered. They also have access to the trainer for an unlimited amount of time after the course to continue to grow their knowledge

Emotional Intelligence Training

Our Foundation Aesthetics Course is designed for aspiring aesthetics practitioners looking to gain essential skills and knowledge in a supportive and professional setting. Led by an Advanced Practitioner from an established training provider, this comprehensive course covers the foundational techniques needed to safely and effectively administer aesthetics treatments, focusing on quality, patient care, and best practices. Throughout the course, learners will gain hands-on experience with real models and in-depth guidance on essential procedures. Key areas covered include anatomy, facial mapping, safety protocols, and best practices for administering aesthetic treatments. By the end of the course, participants will be equipped with the foundational skills, knowledge, and confidence needed to start their journey in the aesthetics industry. The course will include: - Foundation Level Basic Botulinum Toxin type A training - Foundation Level Basic Dermal Filler training - Microneedling - Dermaplaning - Fat Dissolving injections - Skin Boosters - Lumi Eyes - Complications Management L7 - Safe Practice in Medicine L7 - Qualsafe Level 3 Award in Emergency First Aid at Work (RQF) - CPR - Anaphylaxis Learners will require 3 models each over the duration of this course. 1 model will be required on day two and 2 models will be required on day three. Models are to be arranged by the learners themselves. Start and Finish times: Day 1 - 9am until 4pm Days 2 and 3 - 9.30am until 4.30pm Entry requirements: Must be a minimum of 18 years of age Basic Maths and English skills Learners will complete the course with 10 nationally recognised qualifications, and the ability to gain insurance to start practicing immediately. Take this opportunity to build a future in the aesthetics industry with the knowledge and confidence that only the best training can provide. Book now to secure your place and start your journey towards a rewarding career!

FourSquare Training specialise in private, corporate Microsoft 365 courses delivered at your premises and tailored to your needs.

Are you ready to become an advanced aesthetics practitioner? Join Our 5-Day Advanced Aesthetics Course! Our 5-day advanced course is your pathway to mastery! Led by a highly skilled advanced practitioner from an industry-recognized training provider, this intensive program dives deep into advanced techniques, patient care, and business best practices. Course Summary: Unlock your potential in the world of aesthetics with our intensive 5-day Immersive Advanced Aesthetics Course, perfect for beginners and those ready to take the first steps toward a career in aesthetics! Under the guidance of an experienced advanced practitioner from a reputable training provider, you'll gain foundational knowledge, hands-on experience, and advanced skills in aesthetic techniques, patient care, and business insights. Course Overview: This course covers everything from essential aesthetic principles to advanced skin and facial treatments. You'll learn how to perform injectables, skin rejuvenation techniques, and patient consultations, empowering you to administer aesthetic procedures with confidence and precision. Each module is designed to give you practical skills that translate directly to real-world application. The course will include: - Foundation Level Basic Botulinum Toxin type A training - Foundation Level Basic Dermal Filler training - Advanced Botulinum Toxin type A training - Advanced Dermal Filler training - Microneedling - Dermaplaning - Fat Dissolving injections - Skin Boosters - Lumi Eyes - Complications Management L7 - Safe Practice in Medicine L7 - Qualsafe Level 3 Emergency First Aid at Work (RQF) - CPR - Anaphylaxis *FREE Qualsafe Level 1 Award in Introduction to Mental Health in the Workplace (RQF) course * Learners will require 4 live models each for this course and these models are to be arranged by the learner themselves. x 1 model will be required on day 3 - Dermaplaning - Microneedling x2 models required for day 4 Model 1 Foundation dermal filler (Lips, Marionette lines, nasolabial folds) Fat dissolving injections Model 2 Advanced dermal filler (Jaw, chin, cheeks, and nose) x1 model will be required on day 5 - Skin booster - Lumi eyes Start and Finish times: Day 1 Course start time 09:00am Course finish times 16:00am Day 2 – 5 Course start time 09:30am Course finish time 16:30am Entry requirements: Minimum age of 18 Basic Maths and English skills Learners will leave with 12 nationally recognised qualifications, and the ability to gain insurance to start practicing straight away as an advanced aesthetics practitioner.

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.

Managing meetings, Meeting Management, Efficient Meetings, Moccasin Approach, Moccasin Manager,

FourSquare Training specialise in private, corporate Microsoft Teams courses delivered at your premises and tailored to your needs.