1392 Courses in London

The Level 2 NVQ Diploma in Trowel Occupations provides a nationally recognised qualification for those working in the construction and the built environment and specialise in the erection of masonry structures. Upon completion of the qualification, you will be awarded the NVQ Level 2 Diploma in Trowel Occupations which allows the holder to obtain the Blue Skilled Worker CSCS Card. The qualification modules will be discussed and agreed upon with each individual candidate to ensure that the qualification will be suited to your job role. Each candidate will be allocated a qualified assessor to provide support throughout the qualification and provide information, advice and guidance to candidates in order that they can achieve the qualification. If you require further information or are looking to undertake this qualification, please contact us. CSCS Cards Candidates can undertake the CSCS test and obtain the red (Provisional) CSCS card on signing up for various qualifications. The red card can usually be obtained within 7 to 14 days and can be used to access the construction sites for a period of 12 months. Upon completion the card is upgraded to the full 5 year CSCS Card.

Breakups can be hard to deal with but when you have a child together it can make things even tougher Communication issues with your ex Co-parenting issues Moving on with a new partner Trying to rekindle things with your ex Struggling to move on because of the child you have together Drama with your ex and coping with it 7 weeks of daily support 1 week free 30 min per day Dating advice for singles https://relationshipsmdd.com/product/single-parent-issues-with-my-ex/

Reconnect and resolve conflicts with expert couples counselling in London. Our skilled therapists provide a safe and supportive space for partners to communicate effectively, address underlying issues, and improve their relationship. Whether you're dealing with infidelity, communication breakdowns, or other challenges, our tailored approach can help you build a stronger and more loving partnership. Key areas: relationship counselling, marriage counselling, couples therapy, partnership therapy, conflict resolution, relationship support, communication therapy. 3 x 1 hour sessions 

Why Book Revit Basic to Advanced Training Course? Learn BIM and Revit for engineers and architects, supporting 2-D and 3-D design for large-scale projects and combing with AutoCAD. Check our Website How to Book? 1-on-1 training tailored to your schedule. Book your sessions from Monday to Saturday between 9 am and 7 pm or call 02077202581 to book over the phone. Training Details: Duration: 16 hours Flexible scheduling, split across multiple days Method: 1-on-1 (In-person or Live Online) and Personalized attention Course Overview: I. Revit Fundamentals (1 hour) Understanding Revit's Purpose and Applications Navigating the Revit Interface and Essential Tools Mastering Navigation and Viewport Controls Creating and Managing Projects II. Project Setup (1 hour) Initiating a New Project Configuring Project Levels, Grids, and Site Information Defining Project Units for Precision III. Basic Modeling Techniques (2 hours) Building Walls, Doors, and Windows Designing Floors, Ceilings, Roofs, Stairs, and Railings IV. Advanced Modeling Skills (4 hours) Crafting Custom Parametric Families Utilizing Conceptual Modeling Tools Designing Complex Forms and Shapes Enhancing Models with Lighting and Materials Achieving Realism through 3D Rendering V. Views, Sheets, and Annotations (2 hours) Managing Views and Sheets Effectively Incorporating Schedules and Tags Crafting Detail Annotations for Construction Documents VI. Phasing, Worksharing, and Collaboration (2 hours) Understanding Phasing and Design Options Mastering Work Sharing and Collaboration Techniques VII. Project Collaboration and Management (1 hour) Establishing Work Sharing Environments Monitoring Worksets and User Activities Synchronizing Worksets for Seamless Collaboration VIII. Advanced Documentation Skills (2 hours) Creating Advanced Schedules and Legends Developing Construction Documents with Sheets and Title Blocks Customizing Schedules and Keynotes for Precision IX. Course Conclusion and Next Steps (1 hour) Reviewing Course Highlights Exploring Further Learning Resources and Tips Interactive Q&A Session and Feedback Opportunities Download Revit Master Revit Proficiency: Acquire advanced skills in Revit for 3D modeling, parametric design, and efficient project management. Craft Complex Architectural Designs: Create intricate building components, custom families, and detailed construction documents. Seamless Collaboration: Expertise in project collaboration, phasing, and work sharing, ensuring smooth teamwork and synchronization. Enhanced Visualization: Learn advanced rendering techniques for realistic 3D visualizations of architectural concepts. Customize Workflows: Adapt Revit tools, optimize workflows, and enhance efficiency in project execution. Career Opportunities: Architectural Designer: Create architectural plans, 3D models, and construction documents. BIM Specialist: Develop detailed digital models in collaboration with architects and engineers. Construction Documenter: Prepare comprehensive construction documents, including plans and schedules. Project Manager: Oversee projects, ensuring timely completion and adherence to design specifications. Revit Specialist/Trainer: Provide Revit training and support services to individuals, firms, or educational institutions. Elevate Your Revit Skills with Our Advanced Training! Our Revit Basic to Advanced Training Course is tailored to enhance your expertise in Autodesk Revit. Delivered through in-person or live online sessions, this program covers advanced modeling, parametric families, collaboration tools, and project phasing. Course Benefits: Master Advanced Skills: Learn intricate 3D modeling, design complex building components, and implement advanced BIM workflows. Expert Instruction: Industry professionals guide you through advanced concepts via engaging demonstrations and hands-on exercises. Flexible Learning: Choose in-person or live online sessions with interactive instruction and personalized guidance. Lesson Recordings: Access class recordings for convenient review and practice, reinforcing your learning. Lifetime Support: Benefit from lifetime email support for ongoing guidance from our experienced instructors. Enhance your Revit proficiency, streamline design processes, and boost project efficiency. Whether you're an architect, engineer, or design professional, this course unlocks advanced Revit skills. Join our training for comprehensive learning and expert support! Individualized Training: Experience personalized attention and tailored guidance. Flexible Learning Hours: Select your preferred schedule for training sessions. Ongoing Support: Access complimentary online assistance even after course completion. Comprehensive Learning Materials: Receive detailed PDF resources for effective learning. Certificate of Attendance: Earn a certificate acknowledging your course completion. Affordable Pricing: Enjoy budget-friendly training rates. Software Setup Help: Get assistance with software configuration on your device. Referral Benefits: Receive discounts on future courses by referring a friend. Group Discounts: Avail special rates for group training sessions. Extended Availability: Access training sessions every day with extended operating hours. Customized Curriculum: Engage in tailored training designed to meet your specific requirements.

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

Who is this course for? Mastering 3ds Max: Complete Basic to Advanced Training. Looking to learn 3D modelling and animation? Look no further than our comprehensive 3ds Max beginner course! Gain a strong foundation in 3ds Max and learn essential skills for creating stunning 3D models and visualizations. Check our Website Training Duration: 40 hours Method: 1-on1 Sessions and Customized Content. Schedule: Choose your preferred time slot between 9 am and 7 pm, Mon to Sat, tailored to fit your schedule. Course Title: 3ds Max and V-Ray Comprehensive Training Program (40 Hours) Course Overview: Dive deep into the world of 3D visualization and rendering with our intensive 3ds Max and V-Ray training program. Over the course of 40 hours, you'll master the fundamental concepts, advanced techniques, and practical applications of both 3ds Max and V-Ray, empowering you to create stunning, photorealistic visualizations for various industries. Course Outline: Module 1: Introduction to 3ds Max (8 hours) Understanding the 3ds Max interface and tools Basic 3D modeling techniques and workflows Material creation and texture mapping Lights and cameras setup for scenes Module 2: Advanced 3ds Max Techniques (8 hours) Character modeling and animation Particle systems and dynamics Advanced lighting and shading techniques Scene composition and camera animation Module 3: V-Ray Fundamentals (8 hours) Introduction to V-Ray rendering engine V-Ray materials and texture mapping Lighting with V-Ray lights and HDRI maps V-Ray camera settings and depth of field Module 4: Advanced V-Ray Rendering (8 hours) Global illumination and image-based lighting V-Ray proxies and instancing Advanced V-Ray shaders and displacement maps Render elements and post-production techniques Module 5: Architectural Visualization with V-Ray (8 hours) Interior and exterior scene setup Realistic materials for architectural elements Lighting strategies for different times of the day Creating lifelike environments and atmospheric effects Course Features: Hands-On Learning: Engage in practical exercises and real-world projects to reinforce your skills and knowledge. Industry-Standard Tools: Work with the latest versions of 3ds Max and V-Ray, widely used in the professional 3D visualization industry. Expert Instruction: Learn from certified trainers and industry professionals with extensive experience in 3D modeling and rendering. Project-Based Assessments: Apply learned techniques to comprehensive projects, receiving feedback and guidance to refine your skills. Flexible Learning: Choose between in-person and online sessions, accommodating various schedules and learning preferences. Upon completing this 40-hour course, you will be equipped with the expertise to create visually stunning 3D renderings and animations, making you proficient in both 3ds Max and V-Ray for a successful career in architectural visualization, gaming, film production, and more. Upon completion, participants will: Master 3ds Max & V-Ray: Acquire advanced skills in 3ds Max and V-Ray for creating realistic 3D visualizations. Expert in Architectural Visualization: Specialize in architectural visualization techniques, ideal for interior designers and architects. Project-Based Proficiency: Apply learned skills to real projects, developing a professional portfolio. Recommended Jobs: Architectural Visualization Artist 3D Animator Product Visualization Specialist Interior Designer VR Developer Freelance 3D Artist Game Environment Artist Visualization Consultant This training opens doors to diverse roles in architecture, gaming, design, and more. Duration: 40 Hours Focus: Master 3ds Max and V-Ray for advanced 3D visualizations and architectural rendering. Learning Format: One-on-One Training for personalized attention. Availability: Book your sessions Monday to Saturday, 9 am to 7 pm, tailored to your schedule. Outcome: Expertise in 3ds Max, V-Ray, and specialized architectural visualization skills. Practical Focus: Hands-on projects and real-world applications for skill reinforcement. Certification: Upon completion, receive a certificate showcasing your advanced 3D modeling and rendering skills. This one-on-one course offers tailored training sessions from Monday to Saturday, 9 am to 7 pm, ensuring personalized attention and flexibility to suit your schedule. Download 3ds max Ongoing Email Support: We offer continuous email assistance, ensuring your queries are promptly addressed even after the course completion. Comprehensive Resources: Access extensive handouts and valuable documents designed to reinforce your learning experience. Flexible Financial Options: Explore adaptable financial support options, including installment plans and assistance through job center plus and DWP. Reach out to us for specific details. Satisfaction Guarantee: Although it's highly improbable given our exceptional quality and skilled tutors, if you find dissatisfaction after your initial session, we will promptly address your concerns. If necessary, a refund may be provided (Terms and conditions apply). Optimized Software Experience: Receive guidance on optimizing your computer for enhanced software performance in applications like Autocad, 3ds Max, and Photoshop, whether you're on MAC or PC platforms. Industry Connections: Leverage our industry ties as we actively showcase your portfolio to potential employers. Many of our students have secured jobs through our recommendations, offering valuable career opportunities.

Strengthen your relationship with professional marriage counselling in London, UK. Our skilled therapists provide tailored sessions to address marital challenges such as communication issues, trust problems, and intimacy concerns. With a focus on fostering a deeper connection and understanding, our counselling services aim to help you build a resilient and loving marriage. Key areas: couples therapy UK, relationship counselling UK, marital therapy UK, marriage support UK, UK marriage counselling, relationship therapy UK, marriage guidance UK. 3 x 1 hour sessions 

Neurodiversity awareness training, Neurodiversity awareness,

Project Management Fundamentals Many projects are performed by highly competent and effective people who have little or no project management training. They perform projects like process improvement, marketing campaign development, new product development, event planning and production, and other 'tasks' which are projects. Project Management Fundamentals (PMF) is designed to support those people who need a solid foundation in project management, without being unnecessarily burdened to learn it while on the job. The course offers practical skills, concepts, and principles that can be taken back to the workplace, along with insights needed to adapt them to specific project environments. In today's environment, that means possibly adapting to Agile / Iterative methods. So, we have recently added key Agile concepts to provide a basic understanding of shifting towards agility. Since PMF's course goal is to achieve quality performance by learning effective planning and control, the focus is on a process orientation and an analytical, systems-oriented approach. Together, these frameworks promote project-related problem solving and decision-making skills necessary for real world projects. They honor project needs for collaboration, clear communications among people, and interpersonal and relationship skills. Recognition of these needs are woven throughout PMF, but are highlighted in two specific areas: Module 2 - People and Projects Module 8 - Executing, Communicating, and Developing the Team What You Will Learn At the end of this program, you will be able to: Describe the value of strong project management Identify characteristics of a successful project and project manager Recognize how current agile / adaptive practices fit within project management Explore project management processes, including Initiating, Planning, Execution, Monitoring & Controlling, and Closing Utilize project management processes and tools, based on case studies and real-world situations Create an initial project plan Use standard project management terminology Foundation Concepts Project management and definitions Value and focus of PM Competing constraints and project success Project life cycles People and Projects People and projects overview The project manager The project team People and projects in organizations Initiating and Defining Requirements Initiating the project Developing the project charter Conducting stakeholder assessments Defining requirements Using the Work Breakdown Structure Defining the Work Breakdown Structure (WBS) Developing a usable WBS Using the WBS Managing Project Risk Making the case for risk management Overview to planning for risk Identifying risks Analyzing risks Planning responses to risks Implementing response and monitoring risks Considerations for adaptive environments Estimating Defining an estimate Estimating approaches Estimating practices Estimating cost Validating an estimate Scheduling Defining the scheduling process and related terminology Sequencing and defining dependencies Determining the critical path Considering schedule risks and optimizing the schedule Executing, Communicating, and Developing the Team From baseline to execution Project communications and stakeholder relationships High-performing teams Monitoring and Controlling Defining monitoring and controlling Viewing control through the competing demands lens Variance Analysis and corrective action (Earned Value) Considerations in adaptive environments Closing the Project Closing projects Focusing on project transition Focusing on post-project evaluations

Project Management Fundamentals: In-House Training Many projects are performed by highly competent and effective people who have little or no project management training. They perform projects like process improvement, marketing campaign development, new product development, event planning and production, and other 'tasks' which are projects. Project Management Fundamentals (PMF) is designed to support those people who need a solid foundation in project management, without being unnecessarily burdened to learn it while on the job. The course offers practical skills, concepts, and principles that can be taken back to the workplace, along with insights needed to adapt them to specific project environments. In today's environment, that means possibly adapting to Agile / Iterative methods. So, we have recently added key Agile concepts to provide a basic understanding of shifting towards agility. Since PMF's course goal is to achieve quality performance by learning effective planning and control, the focus is on a process orientation and an analytical, systems-oriented approach. Together, these frameworks promote project-related problem solving and decision-making skills necessary for real world projects. They honor project needs for collaboration, clear communications among people, and interpersonal and relationship skills. Recognition of these needs are woven throughout PMF, but are highlighted in two specific areas: Module 2 - People and Projects Module 8 - Executing, Communicating, and Developing the Team What You Will Learn At the end of this program, you will be able to: Describe the value of strong project management Identify characteristics of a successful project and project manager Recognize how current agile / adaptive practices fit within project management Explore project management processes, including Initiating, Planning, Execution, Monitoring & Controlling, and Closing Utilize project management processes and tools, based on case studies and real-world situations Create an initial project plan Use standard project management terminology Foundation Concepts Project management and definitions Value and focus of PM Competing constraints and project success Project life cycles People and Projects People and projects overview The project manager The project team People and projects in organizations Initiating and Defining Requirements Initiating the project Developing the project charter Conducting stakeholder assessments Defining requirements Using the Work Breakdown Structure Defining the Work Breakdown Structure (WBS) Developing a usable WBS Using the WBS Managing Project Risk Making the case for risk management Overview to planning for risk Identifying risks Analyzing risks Planning responses to risks Implementing response and monitoring risks Considerations for adaptive environments Estimating Defining an estimate Estimating approaches Estimating practices Estimating cost Validating an estimate Scheduling Defining the scheduling process and related terminology Sequencing and defining dependencies Determining the critical path Considering schedule risks and optimizing the schedule Executing, Communicating, and Developing the Team From baseline to execution Project communications and stakeholder relationships High-performing teams Monitoring and Controlling Defining monitoring and controlling Viewing control through the competing demands lens Variance Analysis and corrective action (Earned Value) Considerations in adaptive environments Closing the Project Closing projects Focusing on project transition Focusing on post-project evaluations