2368 Courses

The Gold Card Training Programme is the most comprehensive electrician course available. We offer weekday, weekend and evening delivery options. JIB ECS (Gold) Card is quickly becoming a necessity when seeking work on commercial sites, or sub-contracting to larger contractors.

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

A workshop to reflect on important experiences in your life and to develop your autobiographical writing skills.

Maths English Verbal Reasoning Non-verbal Reasoning

Our combined "Highway Code andAccidents, Incidents, and Breakdowns Training" module offers a comprehensive learning experience for drivers. This training covers two essential aspects: understanding the Highway Code and road safety measures to handle accidents, incidents, and breakdowns. Highway Code Training Content: Course introduction, objectives, and expectations. Introduction to the Highway Code and its relevance. Types of road users and training for various groups. Respecting and understanding the risks to different road user categories. Confirmation of knowledge quizzes covering all aspects of the Highway Code and traffic regulations. Accidents, Incidents, and Breakdowns Training Content: Recognizing risks and potential incidents, including breakdowns, collisions, and other scenarios. Duty of care, taking preventative measures, and handling incidents. Understanding health and safety regulations and related statistics. Prevention strategies and appropriate responses in case of an incident. Personal safety and actions to be taken during a vehicle collision. Steps to follow when facing a breakdown, including monitoring gauges and risk assessments. Ensuring the safety of other road users and cooperating with emergency services and recovery operators. Handling bridge strikes, including prevention and actions in case of an incident. Join us to enhance your knowledge of the Highway Code and road safety preparedness. Register today to ensure your drivers are well-versed in the rules of the road and equipped to handle unexpected challenges on their journeys. #HighwayCode #RoadSafety #AccidentHandling #Breakdowns #SafetyTraining

As well as being the owner and manager of The Scottish Soapworks, Jenny is an award-winning graphic designer with many years of experience creating brands for a range of clients including Arran Aromatics, Fairtrade and Matthew Algie Coffee. These one-to-one brand design surgeries are perfect for creatives who want to start making money from selling what they make, or for existing entrepreneurs and small creative businesses who want to review their current branding. In this 1.5 hour, one-to-one brand design surgery you will discuss: your business idea; a brief to create your brand identity; and how you will apply your brand to ensure you have a recognisable 'look' across all your digital and printed products and marketing materials - everything from packaging to social media, and business cards to aprons. Jenny will follow up your session with notes from the conversation, and practical suggestions on how to design your brand, and apply it to various marketing materials. Appointments are available throughout the day and evening starting from 9.30am. More information  The Arienas Collective workshops, courses and events are run from a supportive and welcoming home-based environment within a Georgian mews home in Edinburgh’s City Centre New Town. We invite you to join us, leave any day-to-day worries behind, and immerse yourself in being creative. Spaces on our workshops and courses are limited so that our creative team of artists and makers can offer you the hands-on help and support you need to make the most of your time with us.  All the equipment and materials you will need are included in the price, unless stated otherwise, plus light refreshments (a selection of Shibui teas, coffee, hot chocolate, and sweet or savoury snacks). On full day workshops you are welcome to bring your own lunch to eat inside or out; or there are a wide range of independent sit-in or takeaway delis, cafés, and restaurants, plus supermarkets, within a 5-10 minute walk. PLEASE NOTE: Our workshop space is on the first-floor of a Georgian mews building and unfortunately we do not have lift access. The workshop space is in our home which is not nut free. Please let us know of any skin or food allergies before booking. Private workshop bookings Most of our workshops are also available to book for small private get-togethers; themed wedding and birthday celebrations; corporate team building and well-being purposes; and as in-store retail events. For larger groups, many of our workshops can be brought to a location of your choice. Please email Lynn or phone 07732 901150 for more information. Age restrictions Our workshops are planned with adults in mind. Many are suitable for teenagers, but some may require under 16s to be accompanied for insurance purposes. Please check with us before booking.

Enter the invigorating world of health and wellness with the 'Fitness Instructor Certification: Guiding Health and Wellness' course. Dive deep into the science behind nutrition, uncovering the roles of macronutrients and micronutrients, and discover how they support the body across various age groups. Your journey won't stop at food; this comprehensive course also offers a holistic understanding of physical activity, energy systems, and detailed strategies for cardiovascular exercises. Equipped with this knowledge, learners will be poised to inspire and guide others towards a healthier lifestyle. Learning Outcomes Gain comprehensive knowledge about the importance of both macro and micronutrients in a balanced diet. Understand the specific nutritional needs of adults and distinct groups. Grasp fundamental concepts related to physical activity and exercise. Analyse body composition, understanding the intricacies of body-fat levels and muscle mass. Master techniques related to fitness training, focusing on cardiovascular workouts. Why buy this Fitness Instructor Certification: Guiding Health and Wellness? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success Who is this Fitness Instructor Certification: Guiding Health and Wellness for? Aspiring fitness trainers wanting a thorough grounding in nutrition and exercise. Nutritionists keen on broadening their understanding of physical activity. Individuals aiming to craft personalised health regimes for themselves or loved ones. Health bloggers and influencers desiring credible knowledge to share with their audience. Anyone interested in leading a healthier lifestyle and assisting others on the same journey. Career path Fitness Instructor: £18,000-£30,000 p.a. Nutritionist: £23,000-£35,000 p.a. Personal Trainer: £20,000-£40,000 p.a. Gym Manager: £22,000-£32,000 p.a. Wellness Coach: £25,000-£45,000 p.a. Health Blogger/Influencer: £18,000 (starting) - earnings can vary based on popularity Prerequisites This Fitness Instructor Certification: Guiding Health and Wellness does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Fitness Instructor Certification: Guiding Health and Wellness was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Introduction to Fitness Training Introduction to Fitness Training 00:18:00 Module 02: Anatomy and Physiology Anatomy and Physiology 00:15:00 Module 03: Fundamentals of Exercise Programming Fundamentals of Exercise Programming 00:20:00 Module 04: Nutrition Basics for Fitness Nutrition Basics for Fitness 00:19:00 Module 05: Coaching Skills and Communication Coaching Skills and Communication 00:19:00 Module 06: Professional Practice and Business Skills Professional Practice and Business Skills 00:14:00 Module 07: Exercise Physiology and Kinesiology Exercise Physiology and Kinesiology 00:18:00 Module 08: Fitness Management, Tactical Strength and Conditioning Fitness Management, Tactical Strength and Conditioning 00:17:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

Why Learn SketchUp Evening Training Course? You will learn how to create and edit 3D models to a professional standard, ensuring you leave with the skills and confidence to fully take advantage of SketchUp and Layout software. You can book this course after work we are open 9 am to 7 pm. Course info Duration: 10 hrs. Method: 1-on-1, Personalized attention. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat between 9 am and 7 pm. SketchUp Evening Training Course Course Duration: 10 hours I. Introduction to SketchUp (1 hour) - Overview of SketchUp for interior design and architecture - Familiarization with the user interface and essential tools - Mastering navigation and viewport controls - Efficiently creating and managing interior design and architectural projects II. Creating Floor Plans (1 hour) - Importing floor plans and site plans for reference - Precision in drawing walls, windows, and doors - Effective management of floor levels - Organizing designs using Layers and Scenes III. Adding Furniture and Fixtures (2 hours) - Accessing and importing furniture and fixtures from the extensive 3D Warehouse - Crafting custom furniture and fixtures to suit specific design needs - Strategically placing and arranging elements within the space - Crafting and customizing materials to achieve the desired visual impact IV. Advanced Modeling Techniques (2 hours) - Employing advanced tools for creating intricate 3D models - Enhancing model organization using groups and components - Adding exquisite details and finishes to elevate design quality V. Layout for Construction Documents (2 hours) - Creating construction documents in Layout for clear communication - Seamlessly importing SketchUp models into Layout - Crafting detailed floor plans, elevations, and sections - Adding annotations and dimensions to facilitate construction VI. Introduction to Vray (1 hour) - Understanding the capabilities of Vray for SketchUp - Familiarization with the basic Vray interface and tools - Exploring Vray materials and textures for enhanced rendering VII. Advanced Rendering Techniques (1 hour) - Applying advanced rendering techniques to elevate SketchUp models - Creating artificial and natural lighting for realistic visualizations - Enhancing designs with entourage and landscaping elements VIII. Importing and Exporting (30 minutes) - Seamlessly importing and exporting files for versatile workflows - Ensuring file format compatibility with other software - Preparing models for 3D printing as required IX. Conclusion and Next Steps (30 minutes) - Comprehensive review of course content and key takeaways - Suggested further learning resources and avenues for improvement - Interactive Q&A session and feedback collection Download SketchUp | Free Trial of 3D Modeling Software SketchUp https://www.sketchup.com SketchUp's Intuitive Interface Helps You Communicate Ideas In 3D Fast. Subscribe Today!

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. Relational Databases & Data Models About Data Models About the Relational Model The Electronics Data Model About the Relational DBMS Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper Using the Database Interface About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Introduction to the SQL Language About the SQL Language Characteristics of SQL Introducing SQL Using Select SQL Rules The Select Statement The Select Statement Distinct/Unique Keyword Using Alias Names Restricting Results with the Where Clause About Logical Operators Equality Operator Boolean Operators REGEXP_LIKE() In Operator Sorting Data with the Order By Clause About the Order by Clause Multiple Column Sorts Specify the Sort Sequence About Null Values within Sorts Using Column Aliases Pseudo Columns, Functions & Top-N Queries Rowid Pseudo Column ORA_ROWSCN PSEUDO Column ROWNUM Pseudo Column About the Built-In Functions SYSDATE User & UID SESSIONTIMEZONE Function Using the Dual Table Row Limiting & Top-N Queries FETCH First x Rows Only Clause OFFSET x Rows Clause FETCH?PERCENT Clause The WITH TIES Option Joining Tables About Joins Inner Joins Reflexive Join Non-Key Join Outer Join Using the Set Operators About the Set Operators SQL Set Operator Examples UNION Example INTERECT Example MINUS Example UNION All Summary Functions Using Sub-Queries Finding Data with Sub-Queries Standard Sub-Queries Correlated Sub-Queries The EXISTS Operator Aggregating Data within Groups About Summary Groups Find Groups within the Tables Select Data From the Base Tables Select Groups from the Results Use DDL to Create & Manage Tables Create Table Statement Column Data Types Not Null Default Describe Alter Table Statement Drop Table Statement Table DDL Using SQL Developer Alter User Statement Alter Session Statement NLS_Language NLS_Date Use DML to Manipulate Data The Insert Statement The Delete Statement The Update Statement About Transactions Transaction Rollback Transaction Commit Transaction Savepoint The Set Transaction Statement Set Transaction Read Only Statement Rules Understanding the Data Models The Company Data Model The Electronics Data Model About the SQL-99 Standard SQL-92 & SQL-99 Cross Joins Natural Joins Inner Joins Implicit Inner Join Outer Joins Anti Joins Named Sub-Queries Enhancing Groups with Rollup & Cube Using Rollup The Grouping() Function Using Cube SQL Functions: Character Handling What are the SQL Functions? String Formatting Functions UPPER(), LOWER() Example INITCAP() Example Character Codes Functions CHR((), ASCII() Examples PAD & TRIM Functions RPAD() Example RTRIM() Example TRIM() Example String Manipulation Functions DECODE () Example SUBSTR() Example INSTR() Example TRANSLATE() Example REPLACE() Example String Comparison Functions LEAST() Example Phonetic Search Function SOUNDEX() Example SQL Functions: Numeric Handling About the Numeric Data Functions GREATEST() Example ABS() Example ROUND() Example TRUNC() Example SIGN() Example TO_NUMBER() Example & Data ype Conversions NULL VALUES FUNCTIONS NVL() & NVL2() Function NVL() Example (Character) NVL() Example (Numeric Loss of Data) NVL() Example (Numeric Output) NVL2() Example COALESCE() Function NULLIF() Function SQL Functions: Date Handling Date Formatting Functions TO_CHAR() & TO_DATE() Format Patterns TO_CHAR() Examples TO_DATE() Examples EXTRACT() Example Date Arithmetic Functions MONTHS_BETWEEN() Example ADD_MONTHS() Example LAST_DAY() Example NEXT_DAY() Example TRUNC(), ROUND() Dates Example NEW_ TIME() Example About V$TIMEZONE_NAMES CAST() FUNCTION & TIME ZONES Database Objects: About Database Objects About Database Objects About Schemas Making Object References Database Objects: Relational Views About Relations Views The Create View Statement Why Use Views? Accessing Views with DML Maintaining View Definitions Alter View Drop View DDL Using SQL Developer Database Objects: Indexes About Indexes Create & Drop Index Statements Indexes & Performance Data Dictionary Storage Database Objects: Creating Other Objects About Sequences Referencing NEXTVAL Referencing CURRVAL Within the DEFAULT Clause Alter Sequence & Drop Sequence ALTER SEQUENCE DROP SEQUENCE About Identity Columns CREATE TABLE?GENERATED AS IDENTITY ALTER TABLE?GENERATED AS IDENTITY Start With Limit Value ALTER TABLE...DROP IDENTITY About Synonyms CREATE & DROP SYNONYM Statements CREATE SYNONYM DROP SYNONYM Public Vs Private Synonyms CREATE SCHEMA AUTHORIZATION Database Objects: Object Management Using DDL The RENAME Statement TABLESPACE Placement CREATE TABLE?TABLESPACE The Comment Statement The TRUNCATE TABLE Statement Database Objects: Security About Object Security Grant Object Privileges Revoke Object Privileges Object Privileges & SQL Developer Data Integrity Using Constraints About Constraints NOT NULL Constraint NOT NULL Example CHECK Constraint UNIQUE Constraint PRIMARY KEY Constraint REFERENCES Constraint ON DELETE CASCADE Example ON DELETE SET NULL Example Constraints on Existing Tables Constraints & SQL Developer Managing Constraint Definitions RENAMING & DROPPING Constraints ENABLING & DISABLING Constraints DEFERRED Constraint Enforcement SET CONSTRAINTS Handling Constraint Exceptions Constraints with Views DATA Dictionary Storage The Data Dictionary Structure More About the Data Dictionary OBJECT-SPECIFIC Dictionary Views USER_UPDATABLE_COLUMNS The Dictionary Structure METADATA & SQL Developer Additional course details: Nexus Humans Oracle 12c SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.