2524 Character courses delivered Online

Highlights of the Course Course Type: Online Learning Duration: 1 to 2 hours Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about animation Understand the core competencies and principles of animation Explore the various areas of animation Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert animator expert CrazyTalk Animator 3: Create an Animated Series Course Master the skills you need to propel your career forward in animation. This course will equip you with the essential knowledge and skillset that will make you a confident animator expert and take your career to the next level. This comprehensive create animated series course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this create animated series course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective animation practice and equip you with the essential skills, confidence and competence to assist you in the animation industry. You'll gain a solid understanding of the core competencies required to drive a successful career in animation. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for animator expert or for people who are aspiring to specialise in animation. Enrol in this create animated series course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive create animated series course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this animation can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This create animated series course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This create animated series course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction to CrazyTalk Animator What you will learn 00:08:00 Hard Evidence - Why Crazy Talk Animator is the best for YouTubers 00:15:00 Requirements for Animated Series 00:04:00 The Workflow for YouTube Animated Series 00:10:00 Overview of the Interface 00:10:00 Zooming and Navigation 00:11:00 Advantages of Animating in Crazy Talk Animator 3 Compose a scene quickly with Bonus Package Content 00:09:00 How quickly you can animate PSD Characters using Bones 00:06:00 Lightspeed Animation using Motion Clips 00:08:00 Create and Save Reusable Custom Content for Animated Series 00:10:00 Design and Prepare PSD Characters Importance of the visualization 00:03:00 Design a PSD character in Photoshop 00:05:00 Rig a character in Photoshop (Pipeline users) 00:12:00 Animate the Body Advanced Character Animation Adjusting Motion Clips Pt 1 00:10:00 Advanced Character Animation Adjusting Motion Clips Pt 2 00:17:00 Custom Character Animation 00:16:00 Hand in front and hand behind 00:06:00 Changing angle for G3 Character in Crazy Talk Animator 00:07:00 Replacement Animation - Changing Sprites 00:06:00 Removing Animation from Motion Clips 00:06:00 Facial Animation of Emotional Expressions Set up the Face Correctly for Head Rotation 00:05:00 Option 1 - Face Puppet - Quick Facial Animation 00:07:00 Option 2 - Face Key Editor - Advanced Facial Animation 00:14:00 Auto Lip-Sync 00:04:00 Adjusting Lip Sync 00:05:00 Extra Animation Tips Grabbing and Throwing Objects 00:07:00 Simple Motion Graphics using Elastic Motion 00:06:00 Animate a scene Steps to animate a scene 00:11:00 Putting Together All The Scenes 00:02:00 Conclusion 00:02:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Relationships play a pivotal role in our life satisfaction. By uncovering the root cause of our dissatisfaction in relation to others, we can become more fulfilled and enjoy a fuller life.

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.

Oracle SQL Advanced training course description The Oracle SQL Advanced course is designed to give delegates practical experience in using some of the more advanced features of Oracle SQL. Additional datatypes and the use of advanced SQL functions and expressions are covered together with enhanced table handling features. What will you learn Retrieve data using correlated subqueries, in-line views and multi-column subqueries. Use the WITH Clause. Inserting and Updating Rows Using Complex Subqueries Create Hierarchical Queries. Use ROLLUP, CUBE and GROUPING SETS group by enhancements. Implement the GROUPING and GROUPING_ID functions. Manage large data sets. Insert data conditionally and unconditionally. Merge Rows in a Table. Create TIMESTAMP and INTERVAL Datatypes. Use TIMESTAMP, TIMEZONE and INTERVAL functions and literals. Use regular expressions and implement related functions. Manage objects with the data dictionary. Manage schema objects. Perform flashback operations. Create and using external tables. Control user access to database objects. Oracle SQL Advanced training course details Who will benefit: Anyone who needs to use the more advanced features of SQL to improve their productivity in querying and updating an Oracle database. Prerequisites: Delegates should have attended the Oracle SQL course or have a similar level of experience. Duration 2 days Oracle SQL Advanced training course contents Retrieve data using subqueries ANY, ALL or SOME operators, Correlated subqueries, In-Line views, The Exists operator, The WITH clause, Multi-Column subqueries, Insert and update using a query, Correlated update and delete. Hierarchical queries Hierarchical data, The START WITH and CONNECT BY clauses, The LEVEL pseudo-column, Sequencing the output, Eliminating nodes and branches. Enhanced grouping features Review of basic grouping concepts, The ROLLUP and CUBE extensions, The GROUPING SETS extension, Using the GROUPING and GROUPING_ID functions. Manage large data sets Multi-table Inserts, Conditional and unconditional Inserts, Merging data into a table, Table and view based merge, A sub query based merge. Flashback technology Flashback query, The AS clause, Flashback table, Flashback drop. Date, time and time zone support Date, Timestamp and Interval datatypes, Handling dates and times, Handling intervals, Date, timestamp and interval functions and literals, Related NLS parameters. Regular expression support Regular expression notation, Character matching, Repetition operators, Sub expression grouping, Regular expression functions. Manage objects with the Data Dictionary The Data Dictionary, Useful Data Dictionary tables, Using the Data Dictionary. Manage schema objects Column operations, Constraint operations, Creating and dropping Indexes, B-Tree indexes, Function based indexes, Descending indexes, Creating and using external tables. Access control System privileges and roles, Create users, Alter user details, Grant and revoke object privileges.

 Course Description The Short Story Writing Certificate Course is for you, if you wish to write professionally or as a hobby, you will learn the skills and techniques required to write a successful short story and develop it throughout the course. You will be able to plan, write, submit, and sell your own commercial short stories. This course will cover generating ideas that will form the basis of sharp, compelling short stories, reading modern fiction with a critical eye to gain further understanding of the form, a wide range of key skills and writing techniques including plot, character, dialogue, structure and point-of-view. The course will also provide you with publishing ideas and resources for continuing your writing after the course is finished. 'Master the Art of Short Story Writing with The World's Foremost Writing Guru' * Harness your imagination quickly * Acquire the writing habit easily * Discover how to make your stories more commercial * Learn the habits of professional writers in just a few hours * Begin a new career as an author * Finally understand the needs of mainstream publishers and editors  Discover the reality of a writer's life, taught to you by the author of over thirty bestsellers. This course will take you on a thrilling journey, from acquiring the working writer's mindset to thinking of compelling ideas; from learning how to structure stories for maximum effect to correctly formatting and submitting your stories to editors and publishers. At the end of this course you can expect to be able to write commercial short stories easily and perhaps begin a whole new career as a freelance, paid author. Rob Parnell has been teaching writing for almost two decades. That experience has been synthesized into this unique course, then specifically designed and structured to help the beginner move from wannabe writer to professional wordsmith. Starting with an introduction to the writer's mindset, the course first focuses on mental preparation, ideal time management, goal-setting, and the importance of strong self-belief. There are pre-designed templates to aid in your understanding of these issues. In part two of the course, we look at inspiration and getting ideas, finding subject matter for your stories, as well as providing a clear guide to the fiction genres: romance, thrillers, horror, fantasy, and science fiction. In the third section, Rob Parnell reveals the tips and tactics of professional writers with crucial guidance on the creation of protagonists, building empathy, character motivation and agenda, dialogue, story setting, style, tone, description, point-of-view, plotting and much more. You will also discover the 7-Step Story Generator - a tool that allows you to develop and test any fiction idea. Plus, learn the ideal 5-Point Story Structure as well as how to easily create templates on which to hang commercial short stories. Along the way, there are text-based courses on character creation, plotting, and a special presentation of The Art of Story, a downloadable resource that fully explains the more technical aspects of ideal story structure. Rob also hosts a section on writing software, presenting the solution to any writer's needs. In part four, we explore the actual writing: how to write fluidly, without blocks, for maximum impact. How to create arresting opening paragraphs and compelling text. And, how to edit professionally for submission and publication. In part five, discover how to find and approach paying short story markets. A full market listing is available with the course. For those who want to self-publish, and start making money immediately, Rob presents crucial advice on formatting and publication through Amazon Kindle. This course is fully mentored - Rob is available on-line throughout your course journey to answer queries, offer guidance, and give support. Your very own writing guru is just a click away (via the Academy Console.) At the end of this course, you will possess a clear understanding of the short story marketplace and will therefore be ideally placed to compete in this exciting and fast-growing new career opportunity. At the very least, you'll be able to write fabulous short stories that people will love and admire! Plus, check out the bonus items at the bottom of this page! Introduction Introduction to Short Story Writing FREE 00:05:00 Foreword Who Am I to Run This Course? FREE 00:06:00 It's All About Mindset 00:07:00 What Tools Do You Need To Succeed? 00:05:00 Part One: Mindset Mental Preparation 00:04:00 Time Management 00:05:00 Self Belief 00:02:00 Goal Setting 00:01:00 Part Two: The Basics Subject Matter 00:04:00 Genre 00:07:00 Scope 00:02:00 Getting Ideas 00:02:00 Part Three: Construction Time The 7-Step Story Generator 00:02:00 Characters & Character Creation 00:03:00 Creating Protagonists 00:07:00 Character Motivation & Interactions 00:03:00 Story & Setting 00:03:00 The 5-Point Story Structure 00:02:00 Style & Tone 00:02:00 Point of View & Tense 00:03:00 Plotting & The Twist 00:03:00 Building a Short Story Template 00:02:00 Building a Short Story Template 00:02:00 Introduction to Scrivener All Hail Scrivener! 00:04:00 Part Four: Writing Your Story The Opening Paragraph 00:03:00 Fast Writing 00:04:00 The Second Draft 00:03:00 Polishing 00:04:00 Part Five: Submitting Your Work 6 Lectures It's All About Presentation 00:03:00 Dealing With Rejection 00:01:00 Rights and Payment 00:01:00 Kindle Publishing 00:03:00 Conclusion Short Stories 00:01:00 Resources Resources - Short Story Writing Certificate Course 00:00:00

LOOKING FOR: MG, YA AND ADULT SCI-FI / FANTASY, CHILDREN'S NON-FICTION After graduating from St Andrews University with a degree in English Literature and Art History, Maddy followed her love of literature to an internship at non-fiction literary agency Graham Maw Christie. At GMC, Maddy worked her way up to Agent and built a list of authors who wrote for both for adults and children, spanning history, tarot, and nature writing. An avid reader of anything magical, Maddy joined Madeleine Milburn in 2022 to build a list specialising in SFF. Maddy would like to see SFF across all genres for all ages, including: grim dark, thriller, historical, romance, cosy fantasy, sci-fi, epic, YA fantasy, dark academia, contemporary fantasy, fantasy middle-grade, mythology, fairy tale and queer fantasy. Inspiring children’s non-fiction. She loves worlds to get lost in, adventures that transform what it means to be a hero, and unique magic that offers as many problems as solutions. She likes books that make her cry and books that change her mind. Above all, when she finishes a story about another world, she wants it to have taught her a lesson which helps her live in this one. She loves all fantasy, but favours richly imagined, complex worlds with a history to discover and a future to protect. Worldbuilding is one of her favourite aspects of this genre and she is always looking for a new, dense world with series potential. Think Brandon Sanderson’s Cosmere or the Marvel Cinematic Universe – the bigger the better! Maddy also likes character-driven fantasy with a diverse cast to root for (or root against) and she wants to see a range of different relationships depicted authentically. She particularly like epics that dip into big, universal themes such as grief, climate change, or war and which ask impossible questions in the vein of R.F. Kuang or N.K. Jemisin. She is also excited by authors that play with form and language in a fantasy setting. In YA, she is looking for much the same as in an adult fantasy, but with younger protagonists and a closer focus on relationships. She wants to see the tropes she knows and loves in new and exciting forms and her favourite YA books often centre around belonging and becoming. She likes a dash of romance in everything, because she is sentimental that way, but it’s particularly important in the YA space. Sci-fi is a big passion of hers, especially when it comes with a strong hook. She is a huge fan of Becky Chamber’s The Long Way to a Small Angry Planet and Michaiah Johnson’s The Space Between Worlds. She likes space as a metaphor, and would love something that explores different alien species. Please send her your space operas and sci-fi romances which combine space, magic and mayhem! In fantasy middle grade, she favours whimsy and animal companions; she would love to follow a group of kids through magic school. She tends to look for plenty of humour with a strong friendship at the centre, and she wants middle grade stories which engage with the concerns of children growing up as well as offering an all-important escape (preferably on a dragon/unicorn’s back). She is also looking for children’s non-fiction for all ages. In this space, she wants something as creative as it is informative, and thinks diverse voices are increasingly important. Maddy would like you to submit a covering letter, one page synopsis and the first three chapters (Max 5000 words) of your completed manuscript in a single word document. (In addition to the paid sessions, Maddy is kindly offering one free session for low income/under-represented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Wednesday 17th September 2025

LOOKING FOR: ADULT FICTION, NON-FICTION Liza represents a range of fiction and non-fiction. On the fiction side, she is looking for historical fiction that is well researched, immerses readers in the era, and looks at overlooked characters from the past, or perhaps gives a new spin on someone we think we know. On the literary and upmarket side, she is looking for novels infused with emotions that capture the human experience and make readers think. If your literary novel is something that A24 productions might turn into a movie, this is Liza’s taste. When it comes to fantasy, she loves urban and grounded fantasy (no sci-fi please!), and is always happy to look at anything with a vampire, werewolf, witches, warlocks, fairies, and perhaps a sinister selkie or two. She is also very much looking for romantasy and is the best person at the agency to submit that too. For thrillers, send her anything set in an exotic location, high-concept, or things with a speculative twist. She loves when characters are put in situations she would never want to be in, and then they have to get out of it. Her recent favourite fiction includes: Notes on an Execution, Lady Macbethad, Hamnet, A Discovery of Witches, House of Earth and Blood, The Starless Sea, Piranesi, Our Wives Under the Sea, The Pisces, Such A Fun Age. When it comes to non fiction, she is looking for books that teach her something new or reframe a topic from an alternative point of view. This can include cookery, pop science, and social history. Liza’s recent favourite non-fiction include: The Five, A History of Art Without Men, Messalina, The Authority Gap, Finding The Mother Tree, Cook This Book, Dessert Person. Liza would like you to submit a covering letter, 1 - 2 page synopsis and the first 5000 words of your manuscript in a single word document.  (In addition to the paid sessions, Liza is kindly offering one free session for low income/underrepresented writers. Please email agent121@iaminprint.co.uk to apply, outlining your case for this option which is offered at the discretion of I Am In Print).  By booking you understand you need to conduct an internet connection test with I Am In Print prior to the event. You also agree to email your material in one document to reach I Am In Print by the stated submission deadline and note that I Am In Print take no responsibility for the advice received during your agent meeting. The submission deadline is: Wednesday 27th August 2025

MySQL Performance & Tuning training course description This MySQL Performance & Tuning course is designed for Database Administrators, Application Developers and Technical Consultants who need to monitor and tune the performance of MySQL servers and databases. The course provides practical experience in monitoring and tuning MySQL servers and databases. Note: This MySQL Performance & Tuning course does not cover clustering (other than at overview level), replication or non-standard storage engines such as Falcon and PBXT. What will you learn Develop a monitoring and tuning plan Use server configuration and status variables. Identify and improve problem queries. Make efficient use of indexes. Monitor and size memory caches and locks. Tune the MyISAM and InnoDB storage engine. Evaluate the use of partitioning for performance. MySQL Performance & Tuning training course details Who will benefit: Anyone who wishes to monitor and tune MySQL performance. Prerequisites: Delegates must have a working knowledge of MySQL Database Administration Duration 3 days MySQL Performance & Tuning training course contents Introduction to performance tuning Tuning overview, Resolving performance issues, Recommended approach to tuning, Items to evaluate, Where to look, Planning a monitoring routine, Building a new database for performance, Tuning an existing database, Setting suitable goals. MySQL performance tuning tools Administration tools, the information schema, performance-related SHOW commands, benchmarking tools, the MySQL performance schema, MonYog. Hands on Obtaining performance information. Schema design Normalisation, de-normalisation, naming conventions, load generation, stress testing and benchmarking tools, selecting data types, data types, character sets, choosing storage engines. Hands on effects of design on performance. Statement tuning Overview of statement tuning, identifying problem queries, the optimizer, explain, explain extended. Hands on identifying problem queries and using explain. Indexes Index overview, Types of index, Index tuning, Indexes and joins. Hands on Indexes and performance. Server configuration and monitoring Server configuration variables, server status variables, table cache, multi-threading, connection issues, query cache. Hands on setting and interpreting server variables and caching. Locking Types of locking, locking and storage engines, effects of locking on performance. Hands on locking and performance. The InnoDB engine Transactions, crash recovery, locking, monitoring InnoDB, caches and buffers, configuring data files, configuring the log files. Hands on InnoDB configuration and performance. Other storage engines MyISAM engine, merge engine, archive engine, memory engine, blackhole engine, CSV engine, the Spider engine, the ColumnStore engine, the MyRocks engine, mixing sorage engines. Hands on storage engine performance. Overview of clustering and performance Advantages of performance, advantages of clustering, performance issues and clustering, the NDBCluster engine, the Galera cluster, the Percona XtraDB cluster, MySQL InnoDB cluster, the federated engine, the federatedX engine, overview of other high availability techniques. NOSQL and Mencached overview. Dumping and loading data SQL statements versus delimited data, parameters affecting dump performance, parameters affecting load performance. Hands on dump and load performance. Partitioned tables Partitioned tables concepts, range partitioning, hash partitioning, key partitioning, list partitioning, composite partitioning or subpartitioning, partition pruning. Hands on partitioned table performance.

Face to Face training customised and bespoke. One to One Online or Face to Face

Develop an Endless Runner game to get familiar with the interface and game development process while learning how to use Unreal Engine 5. Even if an endless runner game isn't your interest, this course provides the steps necessary to create a video game from start to finish. Explore fundamental concepts about game-making and utilize that knowledge in your future projects.