2220 Courses in Cardiff delivered Live Online

Autocad face to face training customised and bespoke Online or Face to Face

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

This advanced Level 3 EFT training is geared to those tapping practitioners who are looking to advance their skills to a significantly elevated level of expertise. The art of EFT delivery is emphasized, working with difficult/challenging clients and issues are explored, further refinement of techniques is honed, and additional advanced techniques are demonstrated and taught.

Update and renewal option for Geopace Training Certificate holders Update and renew your existing certificate ... Recommended certificate renewal after 18 months Nationally Recognised Dual Accreditations Open College Network Accredited (Advanced Level) CPD Accredited (The CPD Certification Service) Recaps phlebotomy theory incl. legislation Updates your certification and compliancy Awards cumulative credits and CPD points awarded Basic understanding of English language required Download a certificate on completion of your online course APPLICANTS ARE REQUIRED TO HAVE COMPLETED AN ACCREDITED INTRODUCTION TO PHLEBOTOMY COURSE

Introducing the Occupational Therapy Package: Empowering Independence and Enhancing Daily Living Are you seeking specialized support to enhance your daily living skills and regain independence in your life? Miss Date Doctor’s Occupational Therapy Package offers you expert guidance and personalized interventions to overcome challenges and achieve your goals. Occupational therapy is a client-centered approach that focuses on improving functional abilities and promoting independence in various aspects of life. Our experienced occupational therapists are committed to empowering you to participate fully in meaningful activities and overcome obstacles that may be affecting your daily functioning. Here’s how the Occupational Therapy Package can support you: Comprehensive Assessment: Our occupational therapists will conduct a thorough assessment of your physical, cognitive, and emotional abilities to understand your unique needs and challenges. Personalized Goals: Based on the assessment, we’ll work with you to set personalized goals that align with your aspirations and desired outcomes. Functional Interventions: Through a range of evidence-based interventions, we’ll address challenges related to self-care, productivity, and leisure activities, helping you regain independence in your daily life. Adaptive Techniques: Our therapists will introduce you to adaptive techniques and assistive devices that can support your engagement in various activities and promote greater autonomy. Workplace Support: For individuals seeking occupational therapy for work-related challenges, we’ll provide support and recommendations to improve workplace ergonomics, time management, and productivity. Cognitive Strategies: If cognitive challenges are affecting your daily functioning, our occupational therapists will introduce cognitive strategies to enhance memory, attention, and executive functions. Sensory Integration: For individuals experiencing sensory processing difficulties, our therapists will employ sensory integration techniques to help you better process sensory information and improve daily functioning. Lifestyle Modification: Occupational therapy goes beyond managing symptoms; it aims to improve overall well-being. We’ll work with you to make lifestyle modifications that promote health and balance. The Occupational Therapy Package at Miss Date Doctor is tailored to meet your unique needs and goals. Our compassionate occupational therapists will collaborate with you every step of the way to ensure that your therapy experience is positive, empowering, and transformative. Experience the benefits of occupational therapy and embrace a more independent and fulfilling life. Invest in your well-being and unlock your potential to thrive in everyday activities. Take the first step towards empowerment and enhanced daily living with the Occupational Therapy Package. Let our expert therapists guide you towards a life filled with greater independence, productivity, and satisfaction. 4 X 1 hour https://relationshipsmdd.com/product/occupational-therapy-package/

Historical Association webinar series: Practical approaches to disciplinary concepts in primary history Presenter: Emmy Quinn This session will show teachers how to introduce the concept of significance to children using both individuals and events. It will give ideas of units around individuals and events and how to move beyond significance being “important”, for example significant at the time and significant today. The session will explore how significance can be used in a local study rather than focusing on a well-known event or individual. To use your corporate webinar offer for this webinar please complete this form: https://forms.office.com/e/95945xGxdh

Level 4 Award 12 credits This package entitles you to the relevant required courses to achieve a Level 4 Award and is equal to 12 credits. After purchase, we will be in touch to discuss your module options. Please see individual module pages for more details, as well as applicable dates & times.

The course is relevant to anyone requiring an understanding of the use of Agile or looking to adopt it. This includes, but is not limited to, organisational leaders and managers, marketing executives and managers, and/or all professionals working in an Agile environment, including software sesters, developers, business analysts, UX designers, project management office (PMO), project support and project coordinators.

Learn 3ds Max + Arnold Photo Realistic Rendering Workflow. Enhance your skills with our Arnold renderer training for 3ds Max users. Learn to create lifelike 3D scenes and animations, mastering accurate light simulation. Explore essential Arnold features in lighting, materials, and rendering. Click here for more info: Website Training duration: 10 hrs. Method: 1-on-1 and Personalized attention. Schedule: Choose a convenient time from Monday to Saturday, 9 am to 7 pm, and book your slot. Course Duration: 10 hours Course Outline: Session 1: Introduction to Arnold Renderer (1 hour) Unveiling Arnold Renderer's features and capabilities Understanding the benefits of Arnold in 3ds Max Setting up Arnold renderer and exploring its interface Mastering the workflow for exceptional results Session 2: Basic Arnold Shading (1 hour) Navigating the Arnold shading network Creating essential materials with Arnold shaders Working with diverse shader types (standard, Lambert, etc.) Elevating visuals with maps and textures in Arnold's materials Session 3: Arnold Lighting Techniques (1.5 hours) Embracing the art of lighting with Arnold Lights Implementing various light types (area lights, spotlights, etc.) Creating ambiance with Arnold skydome and environment lighting Illuminating scenes using physical sky and image-based lighting Session 4: Arnold Cameras and Rendering Settings (1.5 hours) Mastering Arnold cameras and their settings Achieving depth of field and motion blur effects in Arnold Configuring optimal rendering settings for superior results Fine-tuning rendering with the Arnold Render Setup dialog Session 5: Advanced Arnold Shading (1.5 hours) Creating intricate materials with advanced Arnold shaders Realistic surfaces with Arnold's procedural textures Harnessing the power of advanced shading nodes (bump, displacement, etc.) Unleashing specialized effects with Arnold shaders (subsurface scattering, hair, etc.) Session 6: Arnold Rendering Optimization (1 hour) Streamlining rendering settings for enhanced efficiency Leveraging Arnold features like adaptive sampling and denoising Noise reduction techniques for smoother Arnold renders Troubleshooting common rendering issues and their solutions Session 7: Advanced Lighting Techniques (1 hour) Crafting lifelike lighting setups with Arnold's prowess Exploring advanced lighting properties (exposure, color temperature, etc.) Enhancing lighting with Arnold light filters and modifiers Implementing captivating effects like volumetric lighting and caustics Session 8: Arnold AOVs and Compositing (1 hour) Understanding Arnold AOVs (Arbitrary Output Variables) Configuring and rendering AOVs for post-production control Compositing AOVs for artistic adjustments in post-production Leveraging AOVs for fine-tuning the final image Session 9: Arnold for Animation and Motion Graphics (1 hour) Integrating Arnold seamlessly into animation and motion graphics projects Rendering animation sequences with finesse Managing motion blur and time-based effects with Arnold Unveiling Arnold's potential for particle rendering and dynamic effects Session 10: Arnold Tips, Tricks, and Best Practices (1 hour) Exploring advanced techniques and workflows for exceptional results Optimizing scene setup for enhanced rendering performance Troubleshooting tips for common issues and errors in Arnold Q&A session and final review to consolidate knowledge Upon completing this course, you will: Gain a solid understanding of Arnold, its rendering concepts, and its integration into 3D projects. Master the setup of Arnold renderer, optimizing performance, and ensuring compatibility with various platforms. Effectively create and manage materials for Arnold, enabling you to produce realistic and visually appealing scenes. Demonstrate proficiency in working with different shapes, lighting techniques, cameras, and shaders to enhance the visual quality of your 3D projects. Harness the power of textures to add depth and realism to your rendered scenes. Utilize Arnold scene sources efficiently, empowering you to streamline your workflow and achieve desired results in a faster and more organized manner. Overall, this course equips you with the necessary skills to confidently utilize Arnold in your projects and achieve exceptional rendering outcomes. Arnold is an advanced Monte Carlo ray tracing renderer designed for feature-length animation and visual effects. This comprehensive course equips you with the skills to produce photo-realistic 3D rendered scenes and animations. Learn accurate light simulation, artistic style techniques, and more. Our 3ds Max - Rendering with Arnold training is customizable, offering one-to-one sessions. Whether in-class or live online, our Autodesk Certified Instructors with vast rendering experience will guide you through hands-on exercises and provide a training guide for future reference. Upon completing the course, you'll receive an e-certificate and liftime email support from your Arnold trainer. Prior experience with 3ds Max is recommended, but no prior Arnold knowledge is required. Choose the Arnold version that suits your needs for this training course. Lifetime email support provided. Comprehensive handouts and useful documents included. Flexible financial support options available, including installment packages and funding through job center plus and DWP (Contact us for details). Money-back guarantee: Unsatisfied after your first session? We address your concerns and offer a refund if needed (Terms and conditions may apply). Assistance with computer optimization for improved software performance in Autocad, 3ds Max, and Photoshop on both MAC and PC platforms. Industry connections for portfolio promotion and job opportunities.

PRODUCT DESIGN face to face training customised and bespoke.