496 Courses

3ds max and Photoshop face to face training customised and bespoke.

Mosaic Summer School

Vray face to face training customised and bespoke.

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

About this training course This 3-days training will provide a comprehensive review of integrity of wells exposed to carbon dioxide (CO2) in the context of Carbon Capture Utilization for enhanced oil recovery and Storage (CCUS). CO2 geological storage is a proven technology to reduce greenhouse gas emissions from sources such as coal power plants, cement kilns and steel mills. Wells are widely considered the most critical containment element, especially older wells that are not used to inject CO2 or monitor the plume evolution in the storage reservoir. The main reason for this perceived risk is the high corrosion rate of carbon steel when exposed to wet CO2, and the tendency of Portland cement to react with the gas. The training course advanced contents build on 15 years' experience in carbon storage, both in the development and deployment of technologies. First-hand, in-depth knowledge of the subject will allow us to debunk myths and focus on the real challenges of wells encountering CO2. Training Objectives After the completion of this training course, participants will be able to: Explain the CCUS market drivers Examine the behavior of CO2, on surface and in the reservoir Diagnose cement defects and design repairs Understand the limits of Portland cement Assess the benefits of different technologies and materials Realize why geology is a dominant factor in cement performance Critically choose the most appropriate monitoring techniques Classify aging processes of cement, steel, and rock when exposed to CO2 Assess the risk of existing wells if they encounter the CO2 plume Examine recent advances in real-time approaches to the production monitoring and lift management Target Audience This training course is suitable and will greatly benefit: All surface technical personnel such as process engineers & technologists Facility engineers, production engineers & technologists Drilling engineers and Well engineers Design engineers and Integrity engineers P&A engineers and Cementing engineers Geologists Senior management executives will benefit from this training as covers an overview of the technical and commercial details of CO2 capture technologies and risks involved. Course Level Intermediate Training Methods The training instructor relies on a highly interactive training method to enhance the learning process. This method ensures that all participants gain a complete understanding of all the topics covered. The training environment is highly stimulating, challenging, and effective because the participants will learn by case studies which will allow them to apply the material taught in their own organization. Course Duration: 3 days in total (21 hours). Training Schedule 0830 - Registration 0900 - Start of training 1030 - Morning Break 1045 - Training recommences 1230 - Lunch Break 1330 - Training recommences 1515 - Evening break 1530 - Training recommences 1700 - End of Training The maximum number of participants allowed for this training course is 20. This course is also available through our Virtual Instructor Led Training (VILT) format. Trainer Your expert course leader is an engineer with a passion for well integrity and possesses 28 years of international experience in field operations, technology development and management in the oil & gas and carbon storage sectors. Since 2018 he is program chair of the Well Integrity Technical Section of the Society of Petroleum Engineers (SPE). He is also author or co-author of 31 technical papers, a book chapter on CO2 geological storage and 7 patent applications. He delivers training on well integrity, plug and abandonment, asset integrity, risk management and QHSE across the Eastern Hemisphere, and carries out active research on harnessing geological barriers, modeling leaks through cement, and quantifying methane emissions from oil & gas wells. He has extensive expertise in: Well integrity, cementing, corrosion, upstream oil & gas (drilling, completion), carbon capture and storage, mathematical modeling, risk management, reliability, HSSE (health/safety/security/environment), asset integrity, management systems, sustainable development, project management, portfolio management, training, and technology development and innovation. He has personally worked on CCS projects in Europe (France, Germany, Netherlands, Norway), Algeria, Japan and USA. Partial list of companies that have benefited from the trainer's expertise: Vermilion Energy Geostock Aker BP Shell Statoil ENI TNO Geogreen Wintershall Archer INA and many more Recent CCS consulting track record: Schlumberger Total Oxand TNO THREE60 Energy and others POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable

Autodesk Maya Basic to Fundamentals Training. Ideal for beginners, learn to navigate Maya's interface, create models, apply textures, animate objects, and delve into advanced topics. Engage in interactive in-person or online sessions. Access recorded lessons for review and receive lifelong email support. Learn 3D modeling and animation - enroll today! Click here for more info: Website Duration: 10 hours of immersive learning. Method: Personalized 1-to-1 sessions and Choose your own day and time Monday to Saturday 9 am to 7 pm. Course Overview: I. Introduction to Maya (1 hour) Maya overview and applications Basic interface and navigation tools Project creation and management II. 3D Modeling Techniques (2 hours) Polygon modeling fundamentals Creating, editing, and refining objects Advanced techniques like extrusions and bevels III. Texturing and Materials (1 hour) Introduction to texturing concepts Material creation and application Texture mapping, UV unwrapping, and image importing IV. Lighting and Rendering (1.5 hours) Basic lighting techniques and composition setup Rendering images and animations effectively Output options and file formats V. Animation Skills (2.5 hours) Keyframe animation and animation curves Character rigging and animation Special effects: particles, fluids, explosions, and smoke VI. Intermediate Modeling Techniques (1 hour) NURBS modeling basics and advanced curves/surfaces manipulation Creating organic shapes with NURBS and sculpting tools VII. Conclusion and Next Steps (0.5 hours) Course review and recap Further learning resources and tips Q&A and feedback session Autodesk Maya Basic to Fundamentals Training Course Key Learning Areas: Advanced modeling techniques: Surfaces, Polygons, Subdiv Modeling, etc. Deformation methods: Twist, Lattice, Flare, Bend Shape manipulation: Lines, Pen tools, Revolve, Loft, Planer, Text in Maya Animation: Keyframes, Path animations, Timeline Texturing and Rendering: Diffuse, Reflections, Transparency, Shaders, Resolution settings Lighting and Camera: Basic & advanced lights, Shadows, Camera effects, Path animation Note: The course content and duration are adaptable to cater to learners' needs and proficiency levels.   Maya Interface Proficiency: Participants will develop a comprehensive understanding of Maya's interface, tools, and workflow, allowing them to navigate seamlessly and manage projects efficiently. 3D Modeling Skills: Students will be equipped with polygon modeling techniques to create both basic and complex 3D models with precision. They will master the art of shaping and refining objects, elevating their creativity in 3D design. Texturing and Materials Mastery: Learners will gain expertise in texturing, applying materials, and incorporating images to enhance the visual appeal of their 3D models. They will create captivating surfaces with colors, textures, and reflectivity. Lighting and Rendering Expertise: Participants will learn essential lighting techniques to illuminate their scenes effectively. They will set up cameras and produce high-quality still images and dynamic animations with Maya's powerful rendering capabilities. Animation Techniques: Students will explore the world of animation, utilizing keyframe techniques and animation curves to bring their creations to life. They will delve into character rigging, animating characters with sophistication and realism. Special Effects and Dynamics: Learners will unleash their creativity with mesmerizing particle systems, fluid simulations, and dynamic effects. They will craft captivating visuals, such as explosions and smoke, adding depth and excitement to their projects. Intermediate Modeling Techniques: Participants will refine their skills with NURBS modeling, mastering curve and surface manipulation. They will create intricate organic shapes, pushing the boundaries of their artistic expression. Creative Problem-Solving: Throughout the course, students will tackle real-world projects, facing challenges that foster creative problem-solving skills. They will gain confidence in overcoming obstacles in 3D modeling and animation. Maya Essentials Basic to Fundamental Training Program: Course Focus: Autodesk Maya Essentials, covering fundamental concepts and techniques. Duration: Flexible scheduling, tailored to individual learning pace. Method: Personalized 1-1 training, interactive sessions, hands-on projects. Curriculum Highlights: Introduction to Maya (1 hour): Interface overview, navigation, project management. 3D Modeling Techniques (2 hours): Polygon basics, object creation, advanced editing. Texturing and Materials (1 hour): Texture mapping, material application, UV unwrapping. Lighting and Rendering (1.5 hours): Lighting fundamentals, composition setup, effective rendering. Animation Skills (2.5 hours): Keyframe animation, character rigging, special effects. Intermediate Modeling (1 hour): NURBS modeling, organic shapes, sculpting tools. Conclusion and Next Steps (0.5 hours): Course review, learning resources, Q&A session. These resources will complement your training, providing additional support and insights as you explore the world of Autodesk Maya. Explore the World of 3D Animation: Master the intricacies of 3D computer graphics and animation using Autodesk Maya. Delve into modeling, texturing, animation, and rendering to bring your creative visions to life. Practical Learning Experience: Dive into hands-on projects refining your skills. Craft 3D models, apply textures, animate characters, and produce polished renders. Recognized Industry Expertise: Gain proficiency in Autodesk Maya, a leading software in entertainment, gaming, and animation. Enhance your employability with highly sought-after skills, opening doors to diverse career paths. Endless Applications: Uncover Maya's versatility in entertainment, architectural visualization, product design, and more. Tailor your expertise to align with your passions and career aspirations. Reinforcement through Recordings: Access comprehensive lesson recordings for thorough review. Revisit specific topics, reinforcing your grasp of Autodesk Maya at your own pace. Continuous Guidance: Receive lifetime email support for ongoing mentorship. Seek answers, clarifications, and expert advice, ensuring your continuous growth even after completing the course.

During this 1 day intermediate level Adobe Illustrator course you will learn how to use Illustrator's tools to create stunning illustrations and type effects. Building on our Introduction to Illustrator (or your exisiting basic knowledge) you will learn how to work with colours, create printable documents, use gradients, layers, fonts, text effects, work with page and product design along with many other more advanced features.

Course Overview Lean Six Sigma is a proven combination of tools and techniques that has been used by leading organizations to improve efficiency, productivity and customer satisfaction. It achieves this by providing a rigorous and structured methodology and team approach to problem solving which leads to quality and performance improvements. Our Lean Six Sigma Green Belt training is a seven-day programme which includes an in-house project designed to provide participants with an understanding of the Six Sigma Green Belt Process and it’s practical application.  Trainees will enhance their current skills by developing a thorough understanding of the DMAIC (Define/Measure/Analyse/Improve/Control) methodology and its applications, creating a culture of problem solving and continuous improvement in their organization. In this way, key personnel become valuable contributors in achieving the larger goals and objectives of their organization. This powerful tool will enable you and your team to identify opportunities for improvement, and assist in the implementation of projects leading to efficiency by equipping key personnel with the expertise and the tools needed to manage and participate in cost reduction projects with innovative solutions.  Trainees will learn how to use data to pinpoint processes that need to be analysed and improved using the Six Sigma Tool sets, with a view to problem solving, increasing operational efficiency, improving productivity and customer satisfaction and the company’s overall business results. Our Lean Six Sigma Green Belt programme incorporates a project to be undertaken in your own organization during and after the training modules. This allows you to apply the tools, in your own working environment, to processes that are known to you, making the training relevant, and also leaving a improvement with measurable results in your organization. MINITAB (trial version can be downloaded free) and Excel software are used by participants during the training sessions and to complete their projects. Structure of the Course This 7-day training programme is divided into three modules as follows:  Define / Measure Phase - 3 days from Nov 25th to 27th, 2024 Analyse Phase - 2 days on January 13th &14th, 2025 Improve / Control Phase - 2 days on February 17th & 18th, 2025 A gap of 4 weeks between each module provides an opportunity for trainees to work on a project within their workplace, applying the methodology and tools learned during the previous module. Extra support can be provided between modules for each trainees with their project work. We provide a Lean Six Sigma Green Belt Manual for all delegates, and a Certification is awarded upon completion of the Green Belt training and ONE project by each trainee in which the targeted outcomes have been achieved. An outcome report and/or project presentation which demonstrates the use of the tools and methodology is required. Cost: £1,800 + VAT per person. What is included Seven days of face-to-face training delivered in 3 modules as listed above Project review and support for all participants during modules 2 & 3. Remote support available for the duration of the programme for trainees to consult with the trainer. All training material, and a Lean Six Sigma Green Belt Manual for all delegates Refreshments and lunch provided each day of training Free car park for all delegates Lean Six Sigma Green Belt certificate In-house Option This workshop can also be delivered in-house as a stand-alone training workshop or integrated into wider improvement activities. Contact us for more details at compete@cforc.org and we will be happy to discuss in the context of your own business needs. If you are not yet a member but are already thinking about joining CforC, you can find more information on how to become a member and the benefits by clicking here.

Discover the fundamentals of Small Modular Reactor (SMR) operations and design with EnergyEdge. Gain insights into clean energy solutions for a sustainable future. Enroll now!

Autocad face to face training customised and bespoke.