1966 Courses in London

Can be run as a one day or two day course. Whereas the one day course concentrates on Speaking Skills in delivering a talk and allows time for participants to prepare and deliver a very short talk, the two day course offers the opportunity for participants to deliver a longer (15 minute) talk and includes consideration of other situations where speaking skills are important such as talking in meetings, talking at interviews etc.

This Skills for Care Endorsed & CPD accredited training has been designed for existing Social care Staff in line with CQC requirements . Delivered by experienced and professional tutors and trainers with over 25 years of combined experience.

Basics to Essential Photoshop Skills Course, Master retouching, layers, color, correction, shapes, and symbols. Delve into graphic design, photo editing, and digital art. Elevate your skills from beginner to pro, gaining expertise in UX strategies, ensuring your websites are impactful and user-friendly. Click here for more info: Website Duration: 16 hours Method: Personalized 1-on-1 sessions ensure individual attention. Schedule: Customize your learning with pre-booked sessions available Monday to Saturday, from 9 am to 7 pm. Module 1: Introduction to Photoshop (2 hours) Understanding the Photoshop interface and workspace Navigating tools, panels, and menus Essential keyboard shortcuts for efficient workflow Introduction to different file formats and their uses Module 2: Basic Image Editing Techniques (2 hours) Cropping, resizing, and straightening images Color adjustments and corrections using adjustment layers Removing blemishes and distractions with healing tools Introduction to layers and blending modes Module 3: Advanced Image Manipulation (2 hours) Creating composite images with layer masks Utilizing advanced selection tools for precise editing Applying filters and special effects for creative enhancements Mastering text and typography in Photoshop Module 4: Graphic Design and Layout (2 hours) Designing banners, posters, and social media graphics Working with shapes, gradients, and patterns Creating visually appealing typography compositions Introduction to vector graphics and custom shapes Module 5: Web and UI Design (2 hours) Designing user interfaces for websites and applications Creating web-ready graphics and optimizing images Prototyping interactive elements and buttons Designing responsive layouts for various devices Module 6: Introduction to 3D and Animation (2 hours) Creating 3D objects and text Basic 3D manipulation and lighting effects Introduction to animation with the Timeline panel Exporting animations and interactive multimedia Module 7: Project-Based Learning (2 hours) Applying learned techniques to real-world projects Designing a digital artwork, website mockup, or social media campaign Receiving instructor feedback for skill refinement Final presentation of completed projects and portfolio building Upon completing our personalized Photoshop Mastery course, you'll: Master Tools: Excel in Photoshop's essential and advanced tools, including image manipulation and graphic design techniques. Design Expertise: Develop skills in creating compelling graphics, web layouts, and interactive UI designs. 3D & Animation Skills: Understand 3D manipulation, lighting, and basic animation techniques. Career Opportunities: This course prepares you for roles such as Graphic Designer, Web/UI Designer, Digital Artist, Photo Retoucher, 3D Artist, or Entrepreneur in the design industry. Dive deep into the world of Photoshop with our exclusive 1-on-1 training program. Tailored to your pace and skill level, this course offers a comprehensive understanding of Photoshop's essentials and advanced features. From image editing to graphic design and 3D manipulation, master Photoshop with personalized attention and hands-on guidance. Key Details: Personalized Attention: Enjoy dedicated 1-on-1 sessions with an experienced Photoshop instructor, ensuring focused learning and personalized guidance. Tailored Curriculum: The course content is customized based on your goals, allowing you to explore specific areas of interest and address individual challenges. Flexible Scheduling: Schedule sessions at your convenience, accommodating your busy lifestyle. Choose from weekdays or weekends, morning or evening, for a flexible learning experience. Hands-on Learning: Engage in practical, real-time exercises and projects tailored to your interests, reinforcing your skills and boosting confidence. In-depth Exploration: Cover a wide range of topics, including image editing, graphic design, 3D manipulation, web design, and more, delving deep into each area for a thorough understanding. Interactive Q&A: Participate in interactive Q&A sessions during each class, clarifying doubts and gaining valuable insights from your instructor. Lesson Recordings: Access recordings of your sessions for review and reinforcement, ensuring you grasp every concept and technique thoroughly. Ongoing Support: Benefit from continuous email support even after the course completion, receiving guidance on projects and addressing any post-training queries. Solid Foundation: Develop foundational Photoshop skills, mastering essential techniques for image editing and graphic design. Versatile Editing: Learn retouching, color correction, and photo enhancement for professional-quality results. Efficient Workflow: Optimize your work with layer management, non-destructive editing, and time-saving tricks. Creative Mastery: Harness Photoshop's power to create digital art, manipulate images, and design stunning graphics. Real-world Application: Apply skills to diverse projects like photo editing, web design, and social media graphics. Flexible Review: Access recorded lessons for convenient review of specific techniques or workflows. Lifelong Support: Enjoy lifetime email assistance for guidance, questions, and clarifications even after course completion.

Venepuncture and cannulation course Venepuncture training for healthcare professionals Cannulation skills development Intravenous access techniques Blood sample collection training Infection control in venepuncture Hands-on venepuncture practice Cannula insertion training Nursing revalidation hours CPD accredited course Healthcare professional skills development Venepuncture and cannulation procedures Venepuncture certification program Intravenous catheter insertion Best practices in venepuncture Patient assessment for venepuncture Troubleshooting venepuncture complications Venepuncture and cannulation simulation Real-life venepuncture scenarios Healthcare career advancement with venepuncture skills

One-day Practical Skills Course for Aspiring Cardiothoracic Trainees. The inaugural course of the London School of Cardiothoracics.

Administering Microsoft SQL Server course description This course provides students with the knowledge and skills to maintain a Microsoft SQL Server database. The course focuses on how to use SQL Server 2016 product features and tools related to maintaining a database. Note: This course is designed for customers who are interested in learning SQL Server 2014 or SQL Server 2016. It covers the new features in SQL Server 2016, but also the important capabilities across the SQL Server data platform. What will you learn Describe core database administration tasks and tools. Configure SQL Server databases and storage. Import and export data. Monitor SQL Server. Trace SQL Server activity. Manage SQL Server security. Audit data access and encrypt data. Administering Microsoft SQL Server course details Who will benefit: Individuals who work with SQL Server databases. Individuals who develop applications that deliver content from SQL Server databases. Prerequisites: Introduction to data communications & networking. Duration 3 days Administering Microsoft SQL Server course contents Introduction to SQL Server administration Database administration, SQL Server platform, database management tools and techniques. Hands on SQL Server Management Studio, sqlcmd Windows PowerShell with SQL Server. Working with databases and storage Data storage with SQL Server, managing storage for system databases, managing storage for user databases, moving database files, configuring the buffer pool extension. Hands on Configuring tempdb storage, creating databases, attaching a database. Importing and exporting data Transferring data, importing and exporting table data, copying or moving a database. Hands on import and export wizard, bcp utility, BULK INSERT statement, OPENROWSET function. Monitoring SQL Server 2014 Monitoring SQL Server, dynamic management views and functions, performance monitor. Hands on Baseline metrics, monitoring a workload. Tracing SQL Server activity Tracing workload activity, using traces. Hands on Capturing a trace in SQL Server profiler, generating tuning recommendations. Managing SQL Server security SQL Server security, server-level security, database-level principals, database permissions. Hands on SQL Server security. Testing access.

This is a theoretical and practical introductory group tuition during which you will be taught common, essential leather crafting and basic sewing techniques.You will be taught how to correctly use hand tools, how to hand sew leather and understand the most common finishing techniques used in bag and accessory making.You will learn about different types of leather and understand how to select the correct type of material(s) for your project. You will receive an overview of the technical aspects of working with leather and constructing bags and accessories such as preparing, marking, cutting, gluing, reinforcing, debossing and more.You will produce your own samples of work to take home with you.You will receive relevant, useful and informative handouts as well as lists of leather and tool suppliers.This is a professional course delivered by a prototype maker and manufacturer, with the aim of providing an overview and hands-on experience on more common leather working practices.   At the end of the tuition you will have:– Gained an understanding of leather types and tanning methods– Understood what it means to work with different leather types and thicknesses and have the ability to source and select the correct tools and materials for your projects.– Gained confidence in using specific tools for preparing, marking, finishing and cutting leather.– Understood and practiced leather craft techniques such as beveling and burnishing techniques– Learnt basic leather hand sewing techniquesWHAT WILL BE TAUGHT?Below is a list of topics covered during the classes:– Understanding leather: overviews on types of leather, tanning, finishings and best use– Vegan leathers: an overview on different types and features– Understanding the importance of choosing the right materials for your project and the right tools for your materials– Leather preparing, pattern placement and marking on leather– Cutting complex shapes using a variety of tools– Using leather punches– Understanding the use of skiving, beveling and grooving– Finishing leather edges: painting vs burnishing– Using various leather glues and tapes– Understand the use of reinforcements, fusings and stabilisers to back leather– To learn basic leather hand sewing techniques– To understand the tools and materials used in saddle stitching– Prototyping and manufacturing leather goods: mentions of different working methods, machines and tools   IMPORTANT TO KNOW:We will always try to cover as much on the syllabus as possible and depending on your ability and previous experience, we might not be able to complete the program or we might instead be able to teach you additional techniques relating to the above listed topics, such as:– Understanding fittings, closure types, fastening techniques and tools: sam browns, magnets, pop buttons, eyelets, etc– Sew and finish simple zips styles, handles and straps– Understanding options and the construction of how to line bags and accessories INCLUDED IN THE COURSE:You will be provided with useful digital and paper handouts which contain:– A list of tools and materials used during the lesson(s), including a description of what they are and how they are used– A list of recommended suppliers for both leather and fittings (physically in London and online)– A glossary containing information about leather types and characteristics WHAT ARE THE ENTRY REQUIREMENTS?This course is suitable for total beginners, beginners with some experience and intermediate.You should be able to use measurements and understand verbal and written English instructions.   ARE THERE ANY OTHER COSTS? IS THERE ANYTHING I NEED TO BRING?Materials are included.Feel free to bring a notepad, if you would like to take some notes, we will provide the rest. HOW LONG IS THIS TUITION?:This tuition will require up to 6.5 hours to complete.We aim to provide customised and high quality tuition services and by only allowing up to 6 students at a time, we are able to focus on each person needs and interests.As every student has a different level of ability and previous experience, this course might lead some students to complete the core aspects of the lesson in a shorter time frame than others.Students who complete the course early will be welcome to stay and use the studio facilities to exercise on the topics of the lesson.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Project Accounting and Finance Skills: In-House Training Do you manage both project schedules and budgets, but do not have insight into how actual results relate to the approved budget? Do you desire to have more clarity about the relationship between your project's performance with the accounting and financial systems in your organization? Do you need to understand financial and accounting terminology to bridge the gap between the 'world of finance' and the 'world of project management? Organizations have a need to manage-by-projects, because projects are the means to deliver on strategic goals and objectives. Therefore, the project manager must have an understanding of the financial world of investments to ensure the organization will realize expected business value. This requires a foundation in the principles of accounting and finance to comprehend how the project's contribution provides an organization with a competitive advantage. Learn what you must do to give your organization the assurance it needs that its investment in your project will realize business value. Learn what you must do to give your organization the assurance it needs to know that its investment in your project will realize business value. What You Will Learn At the end of this program, you will be able to: Explain the aspects of classical corporate accounting and finance effects on managing projects Determine how your project fits into the corporate income statement, balance sheet, and cash flow statement Analyze the financial aspects of managing projects Use earned value management as the basis for decision making throughout the project life Recognize the importance of the project manager's financial responsibilities Focus on what PMs do and should be doing, in support of accounting and finance Use financial information within a project environment to meet financial results Track and analyze the project's financial status and forecast with the goal of realizing benefits Generate work performance data to ensure a project's outcome aligns with financial metrics Foundation Concepts Accounting and Finance Terms and Concepts Accounting and Finance Essentials Financial Terms and Concepts Projects as Financial Investments Overview of 'Two Worlds' Project as Investments Accounting and Finance World: Standards, Principles and Practices Accounting and Finance Standards and Principles Accounting and Finance Practices Capital Budgeting Corporate Budgeting Accounting and Finance World: Economic Project Selection Methods Economic Project Selection Methods Economic Project Selection and the Business Case Project Management World Project Management and Financial Controls Project Management and Work Performance Data Project Management and Earned Value Management Project Management and Work Performance Reporting

Develop your technical report writing and presentation skills with EnergyEdge's course designed for oil & gas professionals. Sign up now!