• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

5796 Character courses

Acting for TV/Film

4.9(23)

By Stage & the City

Acting for TV/Film course

Acting for TV/Film
Delivered In-PersonJoin Waitlist
£295

Adobe After Effects Training

4.9(27)

By Apex Learning

Give a compliment to your career and take it to the next level. This Adobe After Effects bundle will provide you with the essential knowledge to shine in your professional career. Whether you want to develop skills for your next job or elevate your skills for your next promotion, this Adobe After Effects bundle will help you stay ahead of the pack. Throughout the Adobe After Effects programme, it stresses how to improve your competency as a person in your chosen field while also outlining essential career insights in the relevant job sector. Along with this Adobe After Effects course, you will get 10 premium courses, an originalhardcopy, 11 PDF certificates (Main Course + Additional Courses) Student ID card as gifts. This Adobe After Effects Bundle Consists of the following Premium courses: Course 01: Complete Adobe After Effects CC Diploma Course 02: Adobe Lightroom Course 03: Basic Adobe Photoshop Course 04: 2D Animation: Adobe Animate Course 05: Adobe Illustrator Certificate Course Course 06: Adobe Premiere Pro Course 07: Adobe InDesign Training Course 08: Adobe Audition Course 09: Advanced Diploma in User Experience UI/UX Design Course 10: Logo Animation Fundamentals Course 11: Video Editing- DaVinci Resolve Enrol now in Adobe After Effects to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Adobe After Effects expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum : Course 01: Complete Adobe After Effects CC Diploma Module 01 Intro Video Animate Your Name Module 02 Understand the After Effects Workspace Starting a New Composition Adding Media to Your Project and Timeline Using the Basic After Effects Tools Create a Perfect Circle, Alignment, and Shape Colors Working in the Timeline Layer Properties Module 03 Animating in After Effects Position, Scale, and Rotation Animations Tips to Make Your Animations Look More Nautral Using the Graph Editor Challenge - Bouncing Ball Solution - Bouncing Ball Module 04 Working With Solid Layers and the ken Burns Effects Working With Shape Layers, Strokes, and Paths Adding Layer Styles Like Drop Shadow, Bevel, and Gradients Shape Effects - Trim Path Animation, Wiggle, and Zig Zag Module 05 Track Matte Animation - Make Layers Appear And Disappear Using Pre-Compositions to Group Layers Easily Reverse Complicated Animations Playing with Time Blend Modes Stabilize Shaky Footage Module 06 Intro to Motion Graphics Projects Clean Lower Third Logo Reveal Animation Bumper Colorful Transition Text with Mask Path Animation Text Bubble Animation Weather App 1 Weather App 2 Weather App 3 Module 07 Flat Animation Challenge Phil Designs his Flat Animation Scene Animating Fireworks with the Repeater Effect Module 08 Removing Green Screen Background Adding a Background that Matches the Foreground Adding Motion to a Still Image with the Puppet Tool Adding Movement with the Ripple Effect Module 09 Intro to 3D Swinging 3D Text Animation Build Out Your 3D Composition Animating Our 3D Scene Create Stars in After Effects Module 10 Using the Rotoscope Tool Cleaning Up Your Edges Finishing Our Rotobrush Animation Module 11 Easy Screen Replacement with Masks Replacing a Screen Version 2 Screen Replacement with Mocha Module 12 Using the Puppet Pin Tool Animating Your Puppet Pins Animated Blinking Eyes Adding Perspective with Animated Clouds Module 13 Applying Text Animation Presets Create a page Turn Effect with CC page Turn Radial and Linear wipes Color Correction in After Effects Module 14 Motion Tracking Basics Tracking Text and Visual Effects to Video Clip Tracking Rotation and Scale Adding Details to Our Text Module 15 Intro to Character Animation Design Your Character Rigging Your Character Animation Our Character Adding the Animated Background Adding Details to Character Movement Adding the Paper Cut Out Look Module 16 Exporting an H264 File From After Effects Exporting from After Effects with a Transparent Background Exporting from After Effects through Adobe Media Encoder Create an Animated GIF from After Effects Module 17 Audio Tips for After Effects Working with Premiere Pro Module 18 Expressions Basics Animate a Flickering with Expressions Module 19 Conclusion Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 115 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Adobe After Effects bundle. Requirements This Adobe After Effects course has been designed to be fully compatible with tablets and smartphones. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included

Adobe After Effects Training
Delivered Online On Demand
£39

20th May John Baker #Agent121. Looking for: YA/NA FANTASY, SFF, HORROR, ADULT FICTION

5.0(2)

By I Am In Print

LOOKING FOR: YA/NA FANTASY, SFF, HORROR, ADULT FICTION John Baker (he/him) joined the Bell Lomax Moreton agency in 2019, cultivating a list shaped around his passion for science fiction, fantasy, and horror, though has lately also branched out into action/adventure fiction. John focuses on authors writing in the Adult, New Adult, and YA spaces. John leads the wider agency's film & TV desk, is the Secretary of the Association of Author’s Agents, and the co-chair of the AAA’s Bridge Committee. He also serves on the Kingston University MA Publishing Advisory Board. Under the umbrella of speculative fiction, John is looking for fantasy, science fiction, horror, romantasy, or literary speculative fiction. He has built a reputation as a champion of underrepresented voices and stories, be it from creators hailing from the global majority and their diasporas or neurodiverse authors, and naturally gravitates towards this kind of storytelling. In short, if he’s never read a story like yours before, he wants to see it. Adult fantasy: John loves beefy epic fantasy, especially non-Anglo Christian-inspired. Give him an immersive world, a fresh magical or mythic system, and an exciting cast of characters and he’ll be happy. He is a broad church in the genre so loves a political fantasy, swords and sorcery, courtly intrigue, monster hunting and dastardly villains. John is keen to find an urban fantasy that feels fresh and fun and he’s a sucker for a heroic quest narrative. He’s also very open to fantasy that isn’t easily categorised, but it is playing in that world. John is keenly hunting for more historical fantasy, especially inspired by modern history. He’s had fun with mythological retellings in the past, but as ever, let’s make sure it’s shining the spotlight on new stories. He would also love fantasy that centres on types of relationships less celebrated in fantasy, such as established and secure married couples, or siblings. NA/YA fantasy: In this genre, most importantly, John wants to have a good time, whether it’s swoon-worthy kisses in lush ball gowns, or gruesome gore and monsters, so send him pacy, plot-filled adventures. He’d love more books that teenage boys would love: Skullduggery Pleasant forever! Romantasy: The thriving new romantasy genre comes with its own set of challenges, so John wants to know what makes your romantasy different; what will set it out from the (very crowded!) market. Give it completely barmy stakes, cool and unique new settings, or a love story that will make your jaw drop. To be clear, he’s happily sorted for a human person meets a fae creature in the spooky woods. Also, cosmic romance is the genre of the future. Give him romantasy in space. Easy. Horror: John and horror are old friends. He loves horror inspired by myth and folklore, subversive weird horror that leaves your eyebrows in your hairline, historical horror that pulls from ghastly true stories, and anything that you’ll be reading with the light on. He also loves a gothic element and is particularly looking for horror with a strong romantic throughline, fun YA horror, and female & NB horror authors. Science fiction: SF is coming back! And John has been shouting about that. He loves to see an adventurous found-family romp through space or an epic, crunchy space opera. Speculative near-future is fun too, in the vein of Black Mirror’s more uplifting episodes, (e.g. San Junipero). He loves YA science fiction as well; the more creative the better. Literary: John is open to finding more rich magical realism or something character-led yet supernatural and would love a high-concept mystery, in the vein of Stuart Turton. He also loves spec fic that uses the speculative lightly as a way of confronting a deeper truth in society today. Weird stuff: John wants books that will blow people’s minds and defy categorisation. This is hard to describe, but think Gideon The Ninth, The Library At Mount Char, This Is How You Lose The Time War. John loves a pitch that leaves the editors baffled but intrigued. Action/Adventure, Historical Adventure, Espionage: John is branching out into non-speculative adventures, such as John Le Carré, Lee Child, Ian Flemming, and Mick Herron. More as his taste develops, but the hunt is on! Not looking for: military sci-fi or hard SF, or anything with biblical “character wakes up in purgatory/heaven/hell” narratives. The right comedic fantasy has yet to hit his inbox, but please don’t comp Douglas Adams or Sir Terry. John would like you to submit a covering letter, 1-2 page synopsis and the first three chapters (or 5,000 words whichever is longest) of your manuscript in a single word document. (In addition to the paid sessions, John 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: Monday 12th May 2025

20th May John Baker #Agent121. Looking for: YA/NA FANTASY, SFF, HORROR, ADULT FICTION
Delivered Online + more
£72

Project Stakeholder Relationship Skills: Virtual In-House Training

By IIL Europe Ltd

Project Stakeholder Relationship Skills: Virtual In-House Training This course is designed to provide project managers with the ability to: Analyze the complexities of major stakeholder relationship categories Apply the most appropriate interpersonal relationship skills to the different categories of relationships Align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle What you Will Learn Examine traditional and non-traditional ways to identify and assess stakeholders Explain how competence, character, and trust lead to project success and strong relationships with stakeholders Utilize 'Embodied Leadership' skills to build stakeholder relationships Apply stakeholder engagement best practices to case study and real-life scenarios Getting Started Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations

Project Stakeholder Relationship Skills: Virtual In-House Training
Delivered OnlineFlexible Dates
£850

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)

4.3(5)

By Bayfield Training

Bayfield Training and the University of Cambridge Department of Land Economy This prestigious eight-week online Real Estate course is suitable for modellers new to Real Estate and experienced Real Estate Analysts looking to formalise their skill set. This course will equip you with skills to start building your own financial models and the certificate will give your employers and colleagues reassurance of your expertise. If you want to enhance your financial modelling skills over an extended period, the Real Estate Financial Modelling Certificate is the course for you. This online real estate course has been put together exclusively for the Real Estate Financial Modelling certificate, using state of the art digital resources such as animations, video-steps, digital whiteboard and video-interactions as well as the spreadsheets, text based resources and tutor contact you would expect from any of Bayfield Training’s classroom based courses.  Assessment is in the form of a guided model build exercise and written model appraisal. Participants benefit from an additional months access to the course platform after submission of the assessment. On this course you will: Become a competent model builder, building Real Estate Financial Models from scratch Learn tricks and concepts from financial modelling experts with decades of experience in practice and academia Learn how to use Real Estate Financial Models to make informed investment decisions Learn at a consistent pace over 8 weeks allowing you to take the time to fully grasp this important skill This course is suitable for: Chartered Surveyors Asset Managers Financial Controllers Financial Analysts Investment Managers Property Managers Real Estate Students/Recent Graduates Course Outline: Module 1 - Economic Context Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Introduction to Real Estate Asset Modelling and how it relates to and is distinct from Econometric Models. Why Real Estate Asset Modelling is important Understanding the occupier, asset and development markets and the relevant modelling approaches for each Real Estate Sub-Sector Key Performance Indicators Introduction to conventional valuations and financial mathematics Understanding and minimising errors in Financial Models Module 2 - Cash Flow Fundamentals Constructing a financial model from first principles. Understanding all the components of a basic cash flow model Understand why Corporate Finance Models and Real Estate Models are different Financial Model Design Making the link between valuations, income mathematics and discounted cash flows Internal Rate of Return, Net Present Value,Worth and other metrics Features and techniques to aid fast model building Module 3 - Developing the Cash Flow Adapting financial models for different periodicities and building rent functions for different rent behaviour. Understanding how leases vary with respect to rent over time: Rent Reviews, Break Clauses, Rent Free Periods, Lease Expiries etc. Developing the concept of a Rent Function in Excel Logic mathematics and Logic functions Projecting rent to adapt to different lease contracts and growth patterns Alternative solutions to Logic functions Comparative analysis of lease structures in different jurisdictions and adapting financial models Module 4 - Real Estate Data Understanding the different sources of data, constructing basic time series models and recognising basic patterns. Key Property market indicators Characteristics and application of key input metrics for Real Estate Appraisals Understanding the eight components of Real Estate Price Dynamics Awareness of the different sources of data Reading and using general property market reports Constructing basic time series models and recognising basic patterns Module 5 - Development Appraisals Constructing a development appraisal from first principles and understanding development return metrics. Understanding the key components of a development project Understanding the difference between development and investment appraisals Residual Appraisals and Profit Calculations Cost orientated cash flows and phased sales Cumulative construction cost patterns: incidental, fixed, loaded and S-curve Development return metrics and Modified IRRs Module 6 - Multi-let Cash Flows Constructing an advanced multi-let cash flow model and learn different techniques to build flexible rent functions. Multi-let and portfolio model design principles Building complex date functions and date series The three multi-let rent projection techniques Perpendicular Rent Functions Incorporate advanced rent adjustments into the Rent Function Incorporate sector and period varying rental growth rates Simplifying OPEX and CAPEX projections Discounting techniques on complex and volatile cash flows Module 7 - Project Finance Constructing a flexible Real Estate Debt Finance model. Revision of the Mathematics of amortisation and debt finance Basic senior debt models and geared net cash flow LTV, IRR and Interest Rate Dynamics Flexible term, repayment options and deferred interest Loan covenant tests Understanding different tranches of debt Understanding how complex debt structures impact the returns to different parties Module 8 - Model Interpretation and Risk Analysis Learn how to read, analyse and report on real estate financial models. Understand how to read models and develop an investment narrative Visualise model outputs using graph functions, conditional formatting, dynamic symbols and dashboards Learn how to use built-in Sensitivity, Scenario Analysis tools and third-party add-ins Learn how to construct varied project scenarios in a systematic way Introduction to Monte Carlo Analysis and VBA Optimising sale dates and other parameters Create well written, attractive and persuasive reports Included in the Course Bayfield Training and University of Cambridge Accredited Certificate & LinkedIn Proficiency Badge 64 CPD Hours 1 Month Post-Course Access to the Digital Platform - 12 Months Post-Course Access to the Platform can be purchased for an additional fee Course Files Q&A Webinars and Guest Speaker Webinars Further Learning Resources (Reading, Files and Videos) Post Course Support - Two Months of Questions & Answers 2024 Cohort Dates Include: 3rd June to 29th July 5th August to 25th September 2024 30th September to 25th November For more information, please contact Sam on the Bayfield Training Sales team: E - s.musgrave@bayfieldtraining.com T - 01223 517851 W - www.bayfieldtraining.com

University of Cambridge & Bayfield Training - Real Estate Financial Modelling Certificate (Online Self-Study)
Delivered Online & In-Person + more
£2,500

Unreal Engine 4: Game Design & Game Development - CPD Certified

4.7(47)

By Academy for Health and Fitness

Ever dreamt of creating your own video game? Did you know the UK games industry is booming, generating over £7 billion in 2023? Are you ready to be part of this exciting world? This Unreal Engine 4: Game Design & Game Development bundle provides essential knowledge and hands-on practice for mastering game development. It covers industry-standard tools like Cocos2d-x and Unreal Engine, crafting captivating 2D and 3D games, using Blender 3D for character life, and exploring game monetization. The goal is to take game ideas from concept to reality. This Gaming & Game Development Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Game Development using Cocos2d-x v3 C++ Course 02: Modern OpenGL 3D Game Course 03: Unreal Engine 4 for Beginners Course 04: Blender 3D - Create a Cartoon Character Course 05: Monetize Your Mobile Game or App Course 06: Make Cinematics Using Unreal Engine 5 Don't wait any longer to turn your dream of making games into reality. Enrol in the Game Design & Game Development Bundle today! Learning Outcomes of Unreal Engine 4: Game Design & Game Development: Create captivating games with Cocos2d-x v3 C++. Master 3D game development using Modern OpenGL. Craft engaging characters with Blender 3D. Monetise mobile games and apps effectively. Dive into game development with Unreal Engine 4. Produce cinematic experiences with Unreal Engine 5. Develop a comprehensive skill set for game creation. Why Choose Our Game Design & Game Development bundle? Get a free Game Design & Game Development CPD accredited certificate Get a free student ID card with Game Design & Game Development Training Get instant access to this Game Design & Game Development course. Learn Game Design & Game Development from anywhere in the world The Game Design & Game Development is affordable and simple to understand The Game Design & Game Development is an entirely online, interactive lesson with voiceover audio Lifetime access to the Game Design & Game Development course materials The Game Design & Game Development comes with 24/7 tutor support Embark on an immersive journey into the world of Gaming & Game Development with our all-encompassing 6-course bundle. Designed to equip you with hands-on skills and insights, this bundle covers everything from game creation with C++ to 3D game development and character design. Whether you're a beginner or an aspiring developer, our courses will enable you to bring your gaming dreams to life. Unlock the secrets to crafting captivating games and monetising your creations effectively. Game Development using Cocos2d-x v3 C++: Dive into the world of Cocos2d-x v3 C++ and build mesmerising games for multiple platforms. Modern OpenGL 3D Game: Master the art of 3D game development using Modern OpenGL, from graphics fundamentals to game mechanics. Blender 3D - Create a Cartoon Character: Unleash your creativity by designing unique cartoon characters using Blender 3D. Monetise Your Mobile Game or App: Discover the strategies and techniques to turn your mobile games and apps into profitable ventures. Unreal Engine 4 for Beginners: Dive into game development with Unreal Engine 4, learning the tools and techniques used by industry professionals. Make Cinematics Using Unreal Engine 5: Elevate your game storytelling with Unreal Engine 5 and create stunning cinematic experiences. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring Game Developers Creative Enthusiasts Mobile App Developers Beginners in Game Development Requirements You will not need any prior background or expertise. Career path Game Developer: £25,000 - £80,000 3D Artist/Animator: £20,000 - £60,000 Mobile App Developer: £25,000 - £70,000 Game Designer: £25,000 - £70,000 Unity Developer: £25,000 - £75,000 Cinematic Designer: £30,000 - £75,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Unreal Engine 4: Game Design & Game Development - CPD Certified
Delivered Online On Demand22 hours
£40

Vyond Mastery: Unleashing Animated Creativity

By Compete High

🚀 Unlock Your Creative Potential with Vyond Mastery: Unleashing Animated Creativity! 🚀 Are you ready to transform your ideas into captivating animations that grab attention, convey messages effectively, and elevate your content to the next level? Look no further! Introducing our groundbreaking online course: Vyond Mastery - Unleashing Animated Creativity!   🌟 What's Inside? ✨ Module 1: Getting Started with Vyond Master the basics of Vyond, from navigating the interface to creating your first animation. Learn insider tips and tricks for a seamless animation workflow. ✨ Module 2: Crafting Compelling Storylines Dive deep into the art of storytelling and discover how to structure narratives for maximum impact. Explore techniques to engage your audience emotionally through animated storytelling. ✨ Module 3: Advanced Animation Techniques Elevate your animations with advanced techniques and transitions. Uncover the secrets to fluid character movements and dynamic scene transitions. ✨ Module 4: Voiceovers and Sound Design Learn to integrate professional voiceovers and sound effects to enhance your animations. Discover the importance of audio in creating a memorable viewer experience. ✨ Module 5: Branding and Consistency Develop a consistent and memorable brand identity through your animations. Explore ways to align your animated content with your brand message and values. ✨ Module 6: Exporting and Sharing Your Masterpieces Get hands-on experience with exporting options and choose the best formats for various platforms. Learn strategies for sharing your animated creations effectively on social media and other channels.   🎓 Why Choose Vyond Mastery? Expert Guidance: Led by industry experts with years of experience in animation and storytelling. Practical Learning: Hands-on exercises and real-world examples to reinforce your skills. Lifetime Access: Learn at your own pace and revisit the course content whenever you need. Community Support: Connect with a community of like-minded learners and share your progress.   🌈 Who Can Benefit? Content Creators Marketers Educators Business Owners Social Media Managers   💥 Ready to Transform Your Ideas into Animated Masterpieces? Enroll Today! Unleash your creativity, captivate your audience, and make your mark with Vyond Mastery - Unleashing Animated Creativity! 🚀 Course Curriculum Basic Overview 00:00 Pricing 00:00 Vyond Resources 00:00 Interface and Timeline 00:00 Adding Templates 00:00 Character Library 00:00 Character Properties - Part-1 00:00 Character Properties - Part -2' 00:00 Character Properties - Part -3 00:00 Prop Library 00:00 Prop Properties 00:00 Chart Properties - Part 1 00:00 Chart Properties - Part 2 00:00 Text Library 00:00 Text Properties 00:00 Scene Transitions 00:00 Differences with Whiteboard Animation - Part 1 00:00 Differences with Whiteboard Animation - Part 2 00:00 Adding in the Camera to Zoom In 00:00 Conclusion 00:00 Advanced Overview 00:00 Video Script From Existing Video 00:00 Video Script From Existing Audio 00:00 Creating Video Scripts from An Existing Article Document 00:00 Creating Video Scripts From Existing PowerPoints 00:00 Structuring Your Script and Storyboard Document 00:00 Setting Up for the Audio Recording and Voiceover 00:00 Narration of your Audio Script 00:00 Creation of Scene Timings 00:00 Uploading The Audio to Vyond 00:00 Adding In Music 00:00 Scene Theme Selections 00:00 Storyboarding Scenes 00:00 Business and Contemporary Vs Whiteboard 00:00 Storyboarding Whiteboard Style Videos 00:00 Adding Images to Whitebord Style Videos 00:00 Adding the Camera and Exit Effect to Images 00:00 Changing the Background and the Text 00:00 Adding Scene Transitions to Sync Up Your 00:00 Conclusion 00:00

Vyond Mastery: Unleashing Animated Creativity
Delivered Online On Demand1 hour 22 minutes
£25

SQL Programming Masterclass

4.9(27)

By Apex Learning

Course Overview: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass. This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively.By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! Key Features of the Course: CPD certificate upon completion 24/7 learning assistance and support Who is This Course For? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. What You Will Learn: Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. Why Enrol in This Course: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. Requirements: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. Career Path: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: Data Analyst - Average UK salary: £35,000 per year Database Administrator - Average UK salary: £40,000 per year Business Intelligence Analyst - Average UK salary: £45,000 per year SQL Developer - Average UK salary: £40,000 per year Data Engineer - Average UK salary: £55,000 per year Software Developer - Average UK salary: £45,000 per year Data Scientist - Average UK salary: £60,000 per year Certification: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. Course Curriculum 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •Download PostgreSQL: 00:02:00 •Install PostgreSQL: 00:03:00 •Download SQLectron: 00:02:00 •Install SQLectron: 00:01:00 •Connect to PostgreSQL - Credentials: 00:01:00 •Connect to PostgreSQL Using SQLectron: 00:02:00 •Import Course Data Using SQLectron: 00:02:00 •FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data: 00:08:00 •Check Imported Data: 00:06:00 •What is a Database?: 00:01:00 •SQL Data Types: 00:02:00 •Finally Some Fun! Extracting Data Based on Requirements: 00:01:00 •Filtering Data using WHERE Keyword: 00:08:00 •Filter Data by Range Using BETWEEN: 00:03:00 •Filter Data by Set of Values Using IN: 00:03:00 •Filter Data by Date: 00:05:00 •More Filtering by Date: 00:03:00 •Another Query Filtering by Date: 00:01:00 •Filter Data by Strings: 00:04:00 •More Filtering by Strings: 00:05:00 •More Filtering by Strings 2: 00:10:00 •More Filtering by Strings 3: 00:02:00 •How to Ignore Caps when Filtering by String: 00:04:00 •AND Operator: 00:10:00 •OR Operator: 00:12:00 •NOT Operator: 00:09:00 •AND, OR & NOT Operators: Which Has the Highest Priority?: 00:06:00 •Basic Math Operations: 00:06:00 •Modulo Operator: 00:04:00 •Calculate The Net Salary for Employees: 00:06:00 •Filter Data with Math Equations: 00:03:00 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •Give Your Report Fields A Cool Name: 00:04:00 •A Report for Payroll: 00:07:00 •Order Records by Column: 00:06:00 •Order Records by Multiple Columns: 00:12:00 •How Alias Names Cannot Be Used with WHERE: 00:02:00 •LIMIT Record Count Fetched by Your Query: 00:08:00 •Fetch A Field's Unique Values Using DISTINCT: 00:03:00 •Using DISTINCT Keyword with Multiple Columns: 00:06:00 •What is a NULL Value Anyway?: 00:05:00 •Build More Sophisticated Queries with CASE Statements: 00:10:00 •Your Knowledge So Far Under A Great Test: 00:09:00 •Let Me Introduce You to Functions: 00:04:00 •SUM Function: 00:04:00 •AVG (Average) Function: 00:04:00 •COUNT Function: 00:07:00 •MIN & MAX Functions: 00:04:00 •How To Count Your Field's Unique Values: 00:04:00 •GROUP BY Clause: Use Functions with Dimensions: 00:06:00 •GROUP BY More Than One Dimension: 00:05:00 •Now For Some Tough Workout: 00:09:00 •Filter By Aggregate Functions with HAVING Clause: 00:08:00 •Character Functions - UPPER, LOWER & INITCAP: 00:08:00 •Character Functions - CONCAT & LENGTH: 00:10:00 •Character Functions - LPAD & RPAD: 00:13:00 •Character Functions - TRIM: 00:04:00 •Character Functions - REPLACE: 00:09:00 •Character Functions - SUBSTR: 00:10:00 •Number Functions - MOD & ROUND: 00:11:00 •Number Functions - TRUNC: 00:07:00 •Selectception: A Select Query inside another Select Query!: 00:06:00 •Auto Data Conversion in SQL: 00:11:00 •Cast Date to Character: 00:10:00 •Cast Number to Character: 00:09:00 •Cast Timestamp to Character: 00:07:00 •Cast Character to Number: 00:08:00 •Cast Character to Date & Timestamp: 00:09:00 •UNION: 00:03:00 •UNION ALL: 00:02:00 •Important Note about Combining Queries: 00:02:00 •INTERSECT: 00:01:00 •EXCEPT: 00:01:00 •Employees & Departments Tables Revised: 00:03:00 •Entity Relationship Diagram (ERD): 00:09:00 •Cartesian Join: 00:09:00 •Table Aliases with Joins: 00:07:00 •Why I Don't Recommend Cartesian Joins: 00:08:00 •Inner Join: 00:06:00 •In-Depth Look into Join Types in SQL: 00:03:00 •Outer Join - Right, Left & Full: 00:08:00 •INSERT a New Record to a Table: 00:09:00 •Insert Without Specifying Column Names: 00:09:00 •UPDATE a Record's Field Values: 00:07:00 •CAUTION! How an UPDATE Query Can Go Wrong: 00:04:00 •Update a Record Using Single-Row Functions: 00:04:00 •A Good Exercise: Extract Employee's Email Address: 00:02:00 •Solution: Extract Employee's Email Address: 00:13:00 •DELETE a Table's Record: 00:06:00 •Insert Records with Nested Select Queries: 00:06:00 •SQL Data Types Revised: 00:13:00 •Bookstore Data Set: Let's Move It to Database: 00:04:00 •Create Your First Table!: 00:08:00 •Insert Data to Your New Table: 00:08:00 •Change Column Data Type: 00:07:00 •Rename Column: 00:04:00 •Add a New Column to Table: 00:04:00 •Constraints in SQL: 00:01:00 •Primary Keys: 00:14:00 •NOT NULL Constraint: 00:05:00 •UNIQUE Constraint: 00:04:00 •DEFAULT Constraint: 00:04:00 •Foreign Keys: 00:08:00 •Use Foreign Keys with Joins - Books & Publishers: 00:06:00 •Foreign Keys - Properties: 00:06:00 •Drop Column: 00:01:00 •DROP Table: 00:01:00 •Create a New Table with Select Statement: 00:05:00 •A Trick to Create an Empty Table with Select Statement: 00:03:00 •Insert New Records Using Select Statement: 00:06:00 •Views: 00:03:00 •Schemas: 00:02:00 •Create & Use Schemas: 00:04:00 •Resources - SQL Programming Masterclass: 00:00:00

SQL Programming Masterclass
Delivered Online On Demand10 hours 47 minutes
£12

Autodesk Maya Basics to Advanced Level

By London Design Training Courses

Why Learn Autodesk Maya Basics to Advanced Level Course? Course info. Autodesk Maya is one of the best tools for 3D animation and visual effects. Learn Maya with our training courses covering sectors like Architecture, Games & Films, Animation, and Media. London Design Training Courses empower you to master Maya, transforming your 3d skills.  Duration: 40 hrs Method: 1-on-1. Schedule: Tailor your own schedule by pre-booking a convenient hour of your choice, available from Mon to Sat 9 am and 7 pm. Experience advanced-level Maya training covering essential aspects such as modeling, UV mapping, texturing, lighting, camera movement, and rigging. The course is tailored to your specific requirements and work preferences. You can discuss your learning goals with our trainer, and we will suggest a syllabus that meets your needs. Flexible Training Options: Choose in-class training at one of our UK center or attend live online sessions. Certified Tutors and Authoritative: London Design Training Course has all Autodesk Authorized Trainers. Hands-on Learning Approach: The training is practical and hands-on, combining theory and step-by-step demonstrations. You'll have ample time to practice techniques on your computer with Maya, and you can keep all the files you create. Compatible with Windows and Mac: Maya training is available for both Windows and Mac users, with options to suit any recent version of Maya. Maya Basic to Advanced Course Duration: 40 hours Course Description: In this course, you will learn the fundamental and advanced skills to create complex 3D models and animations using Autodesk Maya software. You will gain knowledge of the Maya interface, tools, and workflow. You will learn the essentials of modeling, texturing, rigging, animating, and rendering 3D models. You will also learn how to create advanced special effects and understand advanced modeling techniques. I. Introduction to Maya (3 hours) Overview of Maya and its Uses Maya interface and basic tools Navigation and viewport controls Creating and saving projects II. Basic Polygon Modeling (6 hours) Polygon modeling basics Creating basic shapes and objects Editing and modifying objects Creating complex objects with extrusions and bevels Creating organic shapes with NURBS III. Intermediate Modeling (6 hours) Advanced polygon modeling techniques Creating complex models with Booleans and deformers Creating and modifying curves and surfaces Creating organic shapes with sculpting tools Creating architectural models IV. Texturing and Materials (6 hours) Introduction to texturing Creating and applying materials Texture mapping and UV unwrapping Creating realistic materials with shaders Painting textures with the 3D paint tool V. Lighting and Rendering (6 hours) Basic lighting techniques Advanced lighting techniques Creating realistic lighting environments Setting up a camera and creating a composition Rendering still images and animations Output options and file formats VI. Animation (9 hours) Introduction to animation Keyframe animation and animation curves Creating and editing animation clips Rigging and animating a simple character Creating and editing motion paths and animation layers Creating complex character rigs Creating lip sync and facial animation Creating realistic animation with dynamics and simulations Cloth Animation Ncloth VII. Rigging (4 hours) Introduction to rigging Creating joints and skeletons Binding skin to joints and creating weight maps Creating simple rigging systems and rigging a character Creating complex rigging systems VIII. Special Effects (4 hours) Particle systems and dynamics Creating and manipulating fluids and fire effects Creating and editing special effects like explosions and smoke Creating advanced simulations with nCloth and nParticles Paint effects Mash Networks and Mash Animation IX. Advanced Rendering Techniques (2 hours) Render layers and passes Global illumination and ambient occlusion Mental Ray rendering and settings X. Conclusion and Next Steps (1 hour) Review of course content Tips for further learning and resources Q&A; and feedback Note: The above course outline is just a suggestion, and the course content and duration can be adjusted according to the needs and level of the learners. Proficiency in Advanced Maya Techniques: Participants will gain advanced skills in various aspects of Maya, including modeling, UV mapping, texturing, lighting, camera movement, and rigging. Tailored Training: The course is customized to meet the specific requirements of participants, focusing on their preferred techniques and work type. Hands-On and Practical Experience: The training is practical and hands-on, allowing participants to practice techniques on their own computers with Maya. Versatility in Operating Systems: Participants will be equipped to use Maya on both Windows and Mac systems. Accredited Certification: Upon successful completion, participants will receive an e-certificate, accredited by Autodesk Certified instructor, confirming their achievement in the Maya training course. Post-Course Support: After the training, participants are entitled to 30 days of email support from their Maya trainer, ensuring assistance with any post-course questions or issues. Up-to-Date and Relevant Learning: The training can be based on any recent version of Maya, providing participants with up-to-date knowledge and skills.

Autodesk Maya Basics to Advanced Level
Delivered in London or OnlineFlexible Dates
£1,400

Project Stakeholder Relationship Skills (On-Demand)

By IIL Europe Ltd

Project Stakeholder Relationship Skills (On-Demand) This course is designed to provide project managers with the ability to analyze the complexities of major stakeholder relationship categories; apply the most appropriate interpersonal relationship skills to the different categories of relationships; and align the dynamic needs of the stakeholders with a project's objective throughout the project life cycle. What you Will Learn Examine traditional and non-traditional ways to identify and assess stakeholders Explain how competence, character, and trust lead to project success and strong relationships with stakeholders Utilize 'Embodied Leadership' skills to build stakeholder relationships Apply stakeholder engagement best practices to case study and real-life scenarios Getting Started Foundation Concepts Stakeholders and project success Stakeholder management research Managing stakeholder relationships Identifying Stakeholders Stakeholder categories Stakeholder relationships across the project life cycle Tools and techniques for identifying stakeholders Assessing Stakeholders Assessing stakeholder relationships Recognizing stakeholder attitudes toward the project Analyzing stakeholders Using other types of stakeholder assessments Building Stakeholder Relationships The importance of psychological safety Building trust and getting results The anatomy of trust Navigating Challenging Situations Dynamics of conflict Responding to conflict Managing difficult conversations Summary and Next Steps

Project Stakeholder Relationship Skills (On-Demand)
Delivered Online On Demand15 minutes
£1,050