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

2032 Character courses in Cardiff delivered On Demand

Fashion & Beauty Course Level 3

4.5(3)

By Studyhub UK

The Fashion & Beauty Course Level 3 offers comprehensive training in various aspects of the beauty industry, including makeup application, professional makeup and beauty tips, manicure, pedicure, hairdressing, and hairstyling techniques. Learning Outcomes: Develop a thorough understanding of makeup techniques, from basic application to professional makeup and beauty tips for various occasions. Learn the art of manicure and pedicure, including nail care, grooming, and creating beautiful nail designs. Acquire essential skills in hairdressing and hairstyling, mastering various hair techniques and styles to create stunning looks for clients. Why buy this Fashion & Beauty Course Level 3? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Fashion & Beauty Course Level 3 you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Fashion & Beauty Course Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning. Prerequisites This Fashion & Beauty Course Level 3 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Fashion & Beauty Course Level 3 is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Makeup Makeup Supplies 00:30:00 Makeup Application Women/Girls 00:30:00 Makeup Application Guys 00:30:00 Cleansing & Hairstyles 00:15:00 Professional Makeup and Beauty Tips Body Products Basics 01:00:00 Be Educated On Toxins And Detoxing 01:00:00 Using Bath Products 01:00:00 Sunless Tanning 01:00:00 Body Makeup 01:00:00 The Latest In Support Garments 01:02:00 How Looking Great Makes You Feel Great 00:30:00 Manicure The Nail Salon Basics 00:30:00 Nail Anatomy 00:14:00 Nail Structure 00:15:00 Manicure 00:15:00 Manicure Pedicure Process 00:15:00 Giving French Manicure 00:15:00 Gel Manicures and Pedicures 01:00:00 Nail Filing 00:15:00 Nail Clipping 00:15:00 Hand Massage 00:15:00 Nail Polishing 00:15:00 Nail Care Products 00:30:00 Professional Nail Tips 00:15:00 Pedicure Pedicure Treatment 00:30:00 Scrub Pedicure 00:15:00 Aromatherapy Pedicure 00:30:00 Hard Skin Removal 00:15:00 Foot Massage 00:15:00 Taking care of Feet 00:15:00 Hairdressing Who are Hairdressers? 00:19:00 Anatomy of the skull 00:15:00 Hair Type 00:13:00 Face shapes, Characteristics & Style concepts 00:15:00 Hair Salon Equipments & Furnitures 00:15:00 Cutting the Hair 00:15:00 Cutting hair - One length hair 00:15:00 Cutting hair - Uniform Layer 00:15:00 Cutting hair - Short graduation 00:15:00 Cutting hair - Long graduation 00:15:00 Cutting hair - Curly hair 00:15:00 Cutting hair - Fringes 00:15:00 Braiding Hair 00:15:00 Applying Braiding Techniques 01:00:00 Finishing Hair 00:15:00 Health & Safety in Hairdressing 01:00:00 Hairstyling About Of Hair Style 00:30:00 Check Out Your Face Shape 01:00:00 Choosing Your Style On Your Shape 01:00:00 Best Hairstyles For A Long Face 00:30:00 Best Hairstyles For A Square Face 00:30:00 Best Hairstyles For A Round Face 00:30:00 Best Hairstyles For A Heart Shaped Face 01:00:00 How To Love Your Style 00:30:00

Fashion & Beauty Course Level 3
Delivered Online On Demand25 hours
£10.99

Legal Office Administration

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Legal Office Administration Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Legal Office Administration Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Office Administration Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Legal Office Administration Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Legal Office Administration? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Legal Office Administration there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Legal Office Administration course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Legal Office Administration does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Legal Office Administration was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Legal Office Administration is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Certification for Paralegals Certifications 00:07:00 The Law Office Ethical Considerations 00:10:00 The Basics 00:04:00 Client Relations 00:05:00 Dealing With Mail 00:05:00 File Management 00:03:00 Use Of Technology 00:06:00 Skills that Every Legal Secretary Should Have 00:06:00 Billing How Attorneys Charge 00:09:00 Time and Cost Entries 00:05:00 Trust Accounts 00:04:00 Docket Administration 00:05:00 Preparing Legal Documents Basic Preparation 00:13:00 Legal Citations 00:05:00 The Law Library 00:05:00 Litigation What is Litigation 00:04:00 Delivery of Documents 00:04:00 Motions Prior to and During Trial 00:07:00 Contracts The Basics 00:04:00 The Essential Elements 00:03:00 Remedies for Breach of Contract 00:04:00 Torts The Goal of Tort Law 00:10:00 Negligence 00:11:00 Strict Liability 00:07:00 Criminal Law and Procedure Criminal Law Basics 00:20:00 Criminal Procedure 00:15:00 Family Law Marriage 00:08:00 Annulment and Divorce 00:05:00 Child Custody 00:09:00 Business Law Types of Organizations 00:07:00 Corporations 00:09:00 Real Estate The Basics 00:10:00 Documenting Transactions 00:12:00 Estate Planning and Guardianship The Basics 00:07:00 Characteristics of a Will 00:08:00 Types of Trusts and Funding 00:04:00 Elder Law 00:06:00 Bankruptcy The Basics 00:14:00 Mock Exam Mock Exam- Legal Office Administration 00:20:00 Final Exam Final Exam- Legal Office Administration 00:20:00

Legal Office Administration
Delivered Online On Demand5 hours 20 minutes
£10.99

Electronic Device and Circuits Protection Training

4.5(3)

By Studyhub UK

Step into electronic protection with our comprehensive course on Electronic Device and Circuits Protection Training. Embark on a journey that unravels the intricacies of safeguarding electronic devices and circuits against unforeseen hazards. From fundamental principles to advanced techniques, this course equips learners with the knowledge and skills to navigate the complex landscape of electronic protection. Throughout the curriculum, learners will explore essential topics such as diodes, fuses, circuit breakers, and transient voltage suppressors. Each unit is meticulously crafted to provide a deep understanding of the underlying mechanisms and practical applications. By combining theoretical insights with hands-on exercises, this course ensures a holistic learning experience that fosters proficiency and confidence in electronic protection techniques. Upon completion, learners will emerge with a robust skill set ready to tackle real-world electronic device and circuit protection challenges. Whether you're a budding electronics enthusiast, a seasoned technician, or an aspiring engineer, this course offers invaluable insights and practical expertise to propel your journey in the dynamic field of electronic protection. Learning Outcomes: Understand the fundamental principles of electronic devices and circuit protection. Identify and analyse different types of protective components such as diodes, fuses, and circuit breakers. Gain proficiency in selecting and applying transient voltage suppressors and bypass capacitors. Demonstrate knowledge of advanced protection mechanisms, including metal oxide varistors and glass discharge tubes. Apply theoretical concepts to practical scenarios, ensuring adequate protection of electronic systems. Why buy this Electronic Device and Circuits Protection Training? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Electronic Device and Circuits Protection Training there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Electronic Device and Circuits Protection Training for? Electronics enthusiasts seeking to expand their knowledge in device protection. Technicians aiming to enhance their skills in electronic circuit safeguarding. Engineering students looking to specialise in electronics and circuits. Professionals in the electrical industry seeking to broaden their expertise. Individuals interested in pursuing careers related to electronic device protection. Prerequisites This Electronic Device and Circuits Protection Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electronic Device and Circuits Protection Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Electronic Engineer: £25,000 - £55,000 Annually Electrical Technician: £20,000 - £40,000 Annually Circuit Design Engineer: £30,000 - £60,000 Annually Electronics Technician: £18,000 - £35,000 Annually Power Systems Engineer: £35,000 - £70,000 Annually Maintenance Electrician: £22,000 - £40,000 Annually Course Curriculum Unit 01: Introduction 1.1 Introduction to the Course 00:01:00 Unit 02: Diodes 2.1 Diode Introduction 00:01:00 2.2 Diode Working 00:04:00 2.3 Using Diode in Series 00:02:00 2.4 Using Diode in Parallel 00:02:00 2.5 Diode Protection: Relay Example 00:01:00 2.6 Diode Selection 00:01:00 Unit 03: Fuse 3.1 Introduction to Fuses 00:01:00 3.2 Fast Blow Fuse vs Slow Blow Fuse 00:02:00 3.3 Selection of Fuses 00:01:00 Unit 04: Re-settable Fuses: PTC 4.1 Re-settable Fuse Introduction 00:01:00 4.2 Re-settable Fuse Working 00:01:00 4.3 Re-settable Fuse Selection 00:01:00 Unit 05: Circuit Breakers 5.1 Introduction 00:01:00 5.2 Selection of Circuits 00:01:00 Unit 06: Transient Voltage Suppressors 6.1 Transient Voltage Suppressors 00:02:00 Unit 07: Bypass Capacitors 7.1 Bypass capacitors 00:02:00 Unit 08: Zener Diode 8.1 Zener Diode Introduction 00:01:00 8.2 Zener Diode Circuit 00:01:00 8.3 Zener Diode Selection 00:01:00 Unit 09: TVS Diodes 9.1 TVS Diode Introduction 00:01:00 9.2 TVS Diode Working 00:03:00 9.3 TVS Diode Selection 00:01:00 Unit 10: Metal Oxide Varistors: MOV 10.1 MOV Introduction 00:01:00 10.2 MOV Characteristics 00:01:00 10.3 MOV Selection 00:01:00 Unit 11: Glass Discharge Tube: GDT 11.1 GDT Working 00:03:00 11.2 GDT Selection 00:01:00 Unit 12: Power Supply Protection 12.1 Power Supply Introduction 00:01:00 12.2 Under-voltage Protection 00:02:00 12.3 Over-voltage Protection 00:01:00 12.4 Short Circuit Protection 00:02:00 Assignment Assignment - Electronic Device and Circuits Protection Training 00:00:00

Electronic Device and Circuits Protection Training
Delivered Online On Demand46 minutes
£10.99

Agile Scrum Master Certification

4.5(3)

By Studyhub UK

Unlock the door to innovation and efficiency with our 'Agile Scrum Master Certification' course. Dive into a transformative learning experience that transcends traditional development models, equipping you with the skills to thrive in the dynamic landscape of Agile methodologies. This course, guided by the 2020 Scrum Guide, is your gateway to mastering Scrum principles, events, artifacts, and scaling techniques. Delight in a bonus full eBook, providing you with a comprehensive resource to solidify your Agile expertise. Learning Outcomes Understand the evolution from traditional development models to the Agile framework. Master the core principles and practices outlined in the 2020 Scrum Guide. Navigate the intricacies of Scrum teams, events, and artifacts for effective project management. Explore advanced topics such as Agile requirements, estimation techniques, and metrics. Prepare for the PSM1 certification with expert guidelines, tips, and tricks. Why choose this Agile Scrum Master Certification? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Agile Scrum Master Certification for? Project managers seeking to enhance their project delivery efficiency. Aspiring Scrum Masters eager to lead Agile teams to success. Professionals transitioning to Agile methodologies for project management. Team members looking to contribute effectively in Agile environments. Individuals preparing for the PSM1 certification. Career path Agile Scrum Master: £40,000 - £65,000 Project Manager (Agile Focus): £45,000 - £70,000 Agile Coach: £50,000 - £80,000 Product Owner: £42,000 - £68,000 Senior Project Manager (Agile): £55,000 - £90,000 Scrum Trainer: £60,000 - £100,000 Prerequisites This Agile Scrum Master Certification does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Agile Scrum Master Certification was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum OBJECTIVES AND TARGETS Objectives and Targets 00:09:00 Download: course curriculum in pdf 00:05:00 FROM THE TRADITIONAL DEVELOPMENT MODEL TO THE AGILE Waterfall. Typical challenges 00:05:00 Agile history and 2001's Manifesto 00:11:00 Agile. A different approach 00:04:00 Agile benefits 00:02:00 When agile is best applied + success factors 00:03:00 Download: Agile Vs Waterfall. Overview diagram 00:01:00 Download: Agile Vs Waterfall side by side by project stage 00:04:00 2020 SCRUM GUIDE: WHAT'S NEW! 2020 SCRUM GUIDE: WHAT'S NEW! 00:22:00 BONUS: FULL EBOOK OF THE COURSE! BONUS - Full eBOOK of the Course 00:01:00 SCRUM Download: the Scrum Guide 00:14:00 Download: the Scrum Glossary 00:08:00 Download: Framework Navigator 00:01:00 Scrum introduction 00:12:00 Theory and values 00:08:00 THE SCRUM TEAM The Scrum Team - Introduction 00:08:00 Product, Product Goal and Product Owner 00:14:00 Developers 00:03:00 The scrum master 00:08:00 Characteristics of a perfect scrum master 00:23:00 SCRUM EVENTS Introduction 00:03:00 The Sprint 00:06:00 Download: Diagram of a typical Sprint (with events, roles, artifacts) 00:01:00 The sprint planning 00:10:00 The daily scrum 00:04:00 The sprint review 00:06:00 The sprint retrospective 00:05:00 SCRUM ARTIFACTS Product backlog 00:08:00 Sprint backlog 00:02:00 Increment and definition of done 00:04:00 Commitments 00:04:00 SCALING SCRUM Introduction 00:02:00 Scrum of scrums 00:02:00 Nexus framework 00:05:00 Download: the Nexus Framework poster 00:01:00 SCRUM IN PRACTICE ! A day in the life of a typical Sprint 00:32:00 AGILE REQUIREMENTS Products, Initiatives, Epics, Features, Stories and Tasks 00:11:00 ESTIMATION TECHNIQUES Underlying theory, t-shirt sizing, planning poker 00:09:00 Bucket system, affinity mapping, time unit 00:04:00 AGILE METRICS Underlying theory. Velocity 00:07:00 Sprint burn-down 00:08:00 Release burn-up, cumulative flow, other metrics 00:06:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS How to best prepare for PSM I Certification 00:09:00 PSM1 CERTIFICATION PREPARATION GUIDELINES, TIPS & TRICKS PSM I EXAM SIMULATOR #1 and #2 (80+80 HIGH QUALITY QUESTIONS. REAL MODE) 00:01:00 Assignment Assignment - Agile Scrum Master Certification 00:00:00

Agile Scrum Master Certification
Delivered Online On Demand5 hours 16 minutes
£10.99

Team Building Masterclass

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Team Building Masterclass Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Team Building Masterclass Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Team Building Masterclass Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Team Building Masterclass Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Team Building Masterclass? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Team Building Masterclass there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Team Building Masterclass course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Team Building Masterclass does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Team Building Masterclass was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Team Building Masterclass is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Introduction Introduction 00:04:00 Module 01: Qualities of a Successful Team Qualities of a Successful Team 00:04:00 Goals & Objectives for Working as a Team 00:05:00 5 Reasons Why Your Entire Team Should Contribute to Your Content Efforts 00:05:00 How Team Members can Support One Another's Well-Being 00:03:00 The Five Business Benefits of a Diverse Team 00:04:00 Effective Leadership: Why it's Important and How It's Achieved 00:05:00 Module 02: Communicating Effectively as a Team Communicating Effectively as a Team 00:05:00 7 Ways to Improve Team Communication 00:04:00 Advantages & Disadvantages of Group Cohesiveness & Productivity 00:04:00 3 Crucial Steps to Create Role Clarity within Your Team 00:05:00 Why Consistency Matters in Leadership 00:04:00 Importance of Courtesy in Business Communication 00:04:00 Module 03: Team Building Models Team Building Models 00:04:00 Traditional Team Building Model 00:03:00 Team Spirit Built from the Top 00:04:00 The Cutting Edge Team 00:05:00 What Are the Characteristics of a Task Force Group in Business? 00:03:00 Module 04: Team Building Process Team Building Process 00:05:00 The Forming Stage 00:04:00 The Storming Stage 00:04:00 The Norming Stage 00:04:00 The Performing Stage 00:04:00 The Adjourning Stage 00:05:00 Challenges of Managing a Virtual Team 00:05:00 The Cyber Team Model 00:03:00 Module 05: Challenges of Managing a Virtual Team How to Communicate With Remote Teams 00:03:00 How to Manage Remote Project Teams Effectively 00:04:00 10 Ways to Build Positive and Effective Work Relationships 00:04:00 7 Ways to Recover Your Team from Focus Loss 00:04:00 6 Ways Managers can Increase Team Accountability 00:04:00 Module 06: Team Building Exercises Team Building Exercises 00:03:00 Magic Cane (Helium Stick) 00:03:00 Barter Puzzle 00:03:00 Bridge Build 00:03:00 What's my name? 00:03:00 Grab Bag Skits 00:02:00 Conclusion Review 00:03:00 Assignment Assignment - Team Building Masterclass 00:00:00

Team Building Masterclass
Delivered Online On Demand2 hours 28 minutes
£10.99

Developing Game in Unity 3D

4.5(3)

By Studyhub UK

Embark on a journey through the digital realms with our 'Developing Game in Unity 3D' course, a comprehensive pathway designed to transform enthusiasts into skilled creators. This course opens with an introduction to Unity 3D, setting the stage for an immersive learning experience. As you progress, the curriculum meticulously builds your knowledge from fundamental concepts in 'Basic Building Blocks' to more complex ideas in 'Advanced Scratching and Winning Options.' The course culminates in the creation and animation of your own game, ensuring a complete understanding of both the technical and creative aspects of game development. Delving deeper, the course structure is carefully crafted to ensure a seamless learning experience. Starting from assembling simple game components, you will gradually move towards more intricate processes such as creating custom animations and game building. Each section is a step-up from the last, ensuring a steady but challenging learning curve. The 'Winning Managers' and 'Finishing the Game' sections are particularly noteworthy, blending theory with practical applications to produce a holistic understanding of game development in Unity 3D. This course isn't just about learning; it's about creating. By the end of your journey, you will have not only absorbed valuable knowledge but also applied it in building a game from scratch. This hands-on approach ensures that learners leave with a portfolio-ready project, showcasing their newly acquired skills in Unity 3D game development. Learning Outcomes: Acquire foundational understanding of Unity 3D game development. Develop skills in constructing basic game elements and structures. Learn to integrate multiple game components into a cohesive unit. Master the art of creating custom animations for game characters. Gain expertise in finalizing and launching a complete game. Why buy this Developing Game in Unity 3D course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Developing Game in Unity 3D there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? Individuals aspiring to become game developers. Hobbyists seeking to deepen their understanding of 3D game creation. Students looking to supplement their game development education. Professionals aiming to transition into the gaming industry. Creative minds interested in exploring the intersection of technology and art. Prerequisites This Developing Game in Unity 3D does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Developing Game in Unity 3D was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Game Developer: £30,000 - £50,000 annually Unity Developer: £35,000 - £55,000 annually Animator: £25,000 - £40,000 annually Game Designer: £27,000 - £45,000 annually Project Manager (Gaming): £40,000 - £60,000 annually QA Tester: £20,000 - £35,000 annually Course Curriculum Section 01: Introduction Course Trailer 00:02:00 Lecture 01: Course Introduction 00:01:00 Section 02: Basic Building Blocks Lecture 02: Shader Graph UI Shader: Vignette 00:06:00 Lecture 03: Shader Graph UI Shader: Tileable Pattern 00:08:00 Lecture 04: Line Drawing 00:10:00 Lecture 05: Shader Graph UI Shader: Scratching Material 00:12:00 Lecture 06: Sampling 00:12:00 Section 03: Putting Blocks Together Lecture 07: Creating Board Image 00:08:00 Lecture 08: Creating Ticket Section 00:08:00 Lecture 09: Creating Ticket 00:07:00 Lecture 10: Scratching Integration Part 1 00:12:00 Lecture 11: Scratching Integration Part 2 00:03:00 Section 04: Winning Managers Lecture 12: Win Settings 00:07:00 Lecture 13: Winning Panel Manager 00:07:00 Lecture 14: Button Manager 00:06:00 Lecture 15: Filling Board Images Part 1 00:13:00 Lecture 16: Filling Board Images Part 2 00:08:00 Lecture 17: Finish by Winning Images 00:06:00 Section 05: Creating Basic Game Lecture 18: Game Loop 00:06:00 Lecture 19: Creating Scoreboard 00:12:00 Lecture 20: Creating Save and Load Manager 00:07:00 Section 06: Advanced Scratching and Winning Options Lecture 21: Ticket Section Group One By One Ticket 00:20:00 Lecture 22: Ticket Section Group All At Once Ticket 00:11:00 Lecture 23: Any Sprite 00:08:00 Section 07: Finishing the Game Lecture 24: Section Random Color 00:03:00 Lecture 25: Ticket Provider 00:07:00 Lecture 26: Creating Main Menu 00:06:00 Section 08: Creating custom Animation System Lecture 27: Custom Animation System Part 1 00:14:00 Lecture 28: Custom Animation System Part 2 00:13:00 Section 09: Creating Game Animations Lecture 29: Main Menu Animation 00:04:00 Lecture 30: Sections Animation 00:08:00 Lecture 31: Scoreboard Animation 00:14:00 Lecture 32: Winning Sprites Animation 00:10:00 Lecture 33: Scratching Finished Animation 00:08:00 Lecture 34: Winning Panel Animation 00:19:00 Section 10: Building your game Lecture 35: Build the game For Mobile Phone 00:05:00 Section 11: Initial Scratching Lecture 36: Initial Scratching Animation 00:12:00 Resources Resource - Developing Game in Unity 3D 00:00:00

Developing Game in Unity 3D
Delivered Online On Demand5 hours 23 minutes
£10.99

SQL Database Administrator at QLS Level 5

4.5(3)

By Studyhub UK

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

SQL Database Administrator at QLS Level 5
Delivered Online On Demand11 hours 50 minutes
£10.99

Electrical Engineering for Electrical Substations

4.5(3)

By Studyhub UK

Embarking on a journey through the realm of electrical substations, the 'Electrical Engineering for Electrical Substations' course illuminates the path for aspiring electrical engineers. Imagine plunging into the intricacies of electrical substations, a pivotal component in our electrified world. This course offers a unique blend of theoretical knowledge and practical insights, vital for anyone keen on mastering the core elements of electrics and electronics. From the fundamentals in Unit 1, diving into the design of earthing systems in Unit 2, to the nuanced introduction to substation design in Unit 3, students are equipped with a comprehensive understanding of this specialised field. Moreover, the course is an opportunity to enhance one's prospects in various electrical engineering jobs, paving the way for a lucrative career. The course builds a strong foundation in electrical engineering principles and opens doors to diverse opportunities such as electrical engineering apprenticeships. It serves as a stepping stone for those seeking to delve deeper into the field, potentially leading to roles in designing and managing the heart of electrical systems - the substations. This is more than just an educational journey; it's a route to a rewarding career marked by competitive electrical engineering salaries and fulfilling job roles. For those fascinated by the latest technological advancements, the course touches upon the electrifying world of electric car engines, integrating modern innovation with traditional electrical engineering concepts. This unique blend of old and new prepares learners for a future where electrical engineering expertise is valued and essential. Imagine being at the forefront of this exciting field, where every day brings new challenges and opportunities. Learning Outcomes Gain a comprehensive understanding of the basics of electrical substations. Acquire knowledge in designing effective earthing systems. Learn the principles of substation design and management. Develop an appreciation of the integration between traditional electrical engineering and modern innovations like electric car engines. Prepare for a diverse range of electrical engineering roles in various sectors. Why buy this Electrical Engineering for Electrical Substations? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Electrical Engineering for Electrical Substations there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Electrical Engineering for Electrical Substations course for? Individuals aspiring to become electrical engineers. Professionals seeking to expand their knowledge in substation design and management. Students interested in pursuing a career in electrical engineering. Technicians aiming for an electrical engineering apprenticeship. Anyone interested in the technological aspects of electric car engines. Prerequisites This Electrical Engineering for Electrical Substations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Electrical Engineering for Electrical Substations was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Electrical Engineer: Average Salary £28,000 - £40,000 annually Substation Design Engineer: Average Salary £32,000 - £48,000 annually Electrical Project Manager: Average Salary £35,000 - £55,000 annually Senior Electrical Engineer: Average Salary £40,000 - £60,000 annually Electrical Engineering Technician: Average Salary £25,000 - £35,000 annually Renewable Energy Engineer: Average Salary £30,000 - £45,000 annually Course Curriculum Electrical Engineering for Electrical Substations Unit 1: Basics of Electrical Substations Module 1: Introduction To Electrical Substation 00:06:00 Module 2: Construction of Electrical Substation and Transformers 00:09:00 Module 3: Instrument Transformers and Principle of Operation of Trip Circuit 00:13:00 Module 4: Types Of Circuit Breakers And Fuses 00:23:00 Module 5: Types of Relays According to Function, Construction and Time Characteristics 00:06:00 Module 6: Definition of Busbar and Its Schemes 00:17:00 Module 7: Construction of Underground Cables 00:10:00 Module 8: Construction of Overhead Transmission Lines 00:15:00 Module 9: Comparison between Underground Cables and Overhead Transmission Lines@ 00:05:00 Module 10: Types of Switches In Power System and Substations 00:08:00 Module 11: Importance of Capacitor Banks in Power System 00:08:00 Module 12: Other Important Components in Electrical Substation 00:07:00 Module 13: Classification of Substations 00:05:00 Module 14: Relation between Voltage and Substations 00:02:00 Module 15: Air Insulated Substation and Gas Insulated Substation 00:09:00 Module 16: Importance of Ring Main Unit in Power System 00:07:00 Module 17:Extra Images 00:01:00 Unit 2: Design of Earthing System Module 1: Effect of Current on Human Body 00:09:00 Module 2: Types of Electric Hazards 00:08:00 Module 3: Classification of Earthing Systems 00:24:00 Module 4: Components of Earthing System 00:09:00 Module 5: Design and Resistance of Earthing Electrode 00:12:00 Module 6: Design and Resistance of Earthing Conductor 00:13:00 Module 7: Earth Resistance by Megger and Three Point Method 00:03:00 Module 8: Design Earthing or Ground Grid Using ETAP 00:21:00 Unit 3: Introduction to Design of Substation Module 1: What Ip or Ingress Protection 00:05:00 Module 2: Selection of Busbars in Electrical Substation 00:11:00 Module 3: Design of Substations 00:19:00 Module 4: Single Line Diagram of 66 to 11kv Substation 00:20:00 Assignment Assignment -Electrical Engineering for Electrical Substations 00:00:00

Electrical Engineering for Electrical Substations
Delivered Online On Demand5 hours 5 minutes
£10.99

Diploma in Forensic Science & Analysis at QLS Level 5

4.5(3)

By Studyhub UK

Embarking upon the Diploma in Forensic Science & Analysis at QLS Level 5 offers a fascinating journey into criminal investigation and psychological analysis. Envision yourself at the forefront of crime-solving, where every clue is a piece of a complex puzzle. This course is not just an academic pursuit; it's a pathway to becoming a pivotal part of the justice system. With a focus on forensic psychology, learners are equipped with the knowledge to understand the minds behind criminal acts, enhancing their capability to contribute significantly in real-world scenarios. The curriculum delves deep into the intricacies of forensic psychology, from the introduction to advanced concepts like theories of offending and the role of forensic psychology in police investigations and courtrooms. This comprehensive study not only sharpens your analytical skills but also prepares you for various forensic science jobs. A degree in forensic science can be the key to unlocking a rewarding career, marked by competitive forensic science salaries and the opportunity to work in esteemed organisations like the Centre of Forensic Sciences or the Metropolitan Police Forensic Science Laboratory. This course is a gateway to various opportunities, from forensic science and anthropology to roles requiring forensic science apprenticeships. The knowledge gained here sets the foundation for a lucrative career, where the forensic science pay rate reflects the high value of these skills in solving crimes and upholding justice. So, seize this chance to transform your curiosity into a professional asset and elevate your career trajectory in this dynamic and ever-evolving field. Learning Outcomes: Acquire a thorough understanding of forensic psychology and its application in criminal investigations. Develop the ability to analyse personal attributes of offenders and understand the psychological theories behind offending. Gain insights into the role of forensic psychology within police investigations and courtroom settings. Master research methods specific to forensic psychology, enhancing investigative and analytical skills. Understand the ethical considerations and practical challenges in the practice of forensic psychology. Why buy this Diploma in Forensic Science & Analysis at QLS Level 5? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Diploma in Forensic Science & Analysis at QLS Level 5 for? Individuals aspiring to careers in forensic science, seeking foundational knowledge in forensic psychology. Law enforcement personnel aiming to enhance their investigative skills with psychological insights. Legal professionals interested in understanding the psychological aspects of criminal behaviour and courtroom dynamics. Psychology graduates or students looking to specialise in forensic psychology. Career changers or enthusiasts intrigued by the intersection of psychology and criminal justice. Prerequisites This Diploma in Forensic Science & Analysis at QLS Level 5 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Diploma in Forensic Science & Analysis at QLS Level 5 was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Forensic Psychologist: £35,000 - £50,000 Per Annum Crime Scene Investigator: £20,000 - £40,000 Per Annum Forensic Anthropologist: £30,000 - £45,000 Per Annum Police Detective: £30,000 - £50,000 Per Annum Forensic Science Technician: £25,000 - £40,000 Per Annum Legal Consultant: £40,000 - £70,000 Per Annum Certification After studying the course materials of the Diploma in Forensic Science & Analysis at QLS Level 5 there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99. Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Introduction Interventions to reduce risk of re-offending 00:07:00 History of development of Forensic Psychology 00:06:00 Research Methods in Forensic Psychology Research Design and Methodology 00:12:00 Critical evaluation of psychological research 00:09:00 Theories of Offending Introduction to theories of offending 00:06:00 Theories of sexual offending 00:08:00 Theories of violent offending 00:08:00 Theories of fire-setting behaviour 00:08:00 Personal Attributes of Offenders Personal characteristics of offenders 00:06:00 Personality disordered offenders 00:06:00 Psychopathic offenders 00:07:00 Mental Illness and offending 00:07:00 Forensic Psychology in Police Investigations An Introduction to Offender Profiling 00:05:00 Approaches to Offender Profiling 00:05:00 The Effectiveness of Offender Profiling 00:06:00 Forensic Psychology in the Courtroom Eye-witness testimony 00:09:00 Expert witness testimony 00:04:00 Attitudes towards victims 00:06:00 Forensic Psychology in Practice 'What works' literature in reducing re-offending 00:06:00 Incident management (Crisis Negotiation) 00:08:00 Introduction: About the Course and the Tutor 00:03:00 Mock Exam Mock Exam - Forensic Science Course 00:20:00 Final Exam Final Exam - Forensic Science Course 00:20:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Diploma in Forensic Science & Analysis at QLS Level 5
Delivered Online On Demand3 hours 2 minutes
£10.99

SQL For Data Analytics & Database Development

4.5(3)

By Studyhub UK

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the SQL For Data Analytics & Database Development Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

SQL For Data Analytics & Database Development
Delivered Online On Demand7 hours 50 minutes
£10.99