Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL
Course Overview The Adobe Premiere Pro CC course is designed to provide learners with a comprehensive understanding of the software's advanced features, enabling them to create and edit professional-quality videos. Through this course, students will gain the essential skills to work efficiently with various multimedia elements, enhance their video editing techniques, and explore key tools such as colour correction, sound editing, and effects application. This course offers practical insights into working with Adobe Premiere Pro, equipping learners to create high-impact, visually appealing content. Upon completion, students will be proficient in all key aspects of video editing, ready to apply their skills in various industries such as film production, marketing, and online media. Course Description This Adobe Premiere Pro CC course takes an in-depth approach to mastering the video editing software. Learners will explore a range of topics, from setting up the workspace and understanding the interface to advanced techniques such as multi-camera editing, transitions, and colour grading. The course also covers sound editing, the use of effects, and tips for efficient workflows. Students will develop proficiency in editing both short and long-form content, ensuring that they are capable of handling a variety of editing tasks. With a focus on developing professional skills, learners will gain the confidence to use Adobe Premiere Pro CC for a wide array of video production needs. By the end of the course, learners will be well-equipped to produce polished video content for different platforms, making them highly marketable in the creative and media industries. Course Modules Module 01: Introduction to Adobe Premiere Pro CC Module 02: Setting up the Workspace and Interface Module 03: Importing and Organising Media Module 04: Basic Editing Tools and Techniques Module 05: Working with Audio Module 06: Transitions and Effects Module 07: Colour Correction and Grading Module 08: Advanced Video Editing Techniques Module 09: Multi-Camera Editing Module 10: Exporting and Rendering Video Projects Module 11: Working with Titles and Graphics Module 12: Final Project and Portfolio Development (See full curriculum) Who is this course for? Individuals seeking to enhance their video editing skills. Professionals aiming to develop expertise in video production. Beginners with an interest in video editing and media production. Creative individuals interested in improving their technical video editing abilities. Career Path Video Editor Content Creator Multimedia Specialist Film Production Assistant Digital Media Producer Marketing Video Editor Post-production Specialist
Course Overview This comprehensive course in Animal Care and Psychology offers a deep dive into the welfare, behaviour, and care of various animal species. Covering everything from animal health and nutrition to psychology, learners will explore key topics essential for understanding and improving animal welfare. With an emphasis on both theoretical and practical aspects of animal care, this course equips learners with the knowledge required for a career in animal welfare, psychology, or veterinary support. By the end of the course, students will gain a holistic understanding of animal needs, behaviour, and the role of psychology in their care, making them well-prepared for roles in animal-related industries. Course Description The Animal Care and Psychology course covers a broad range of topics aimed at providing learners with an understanding of animal behaviour, health, and care. Learners will explore animal health and nutrition, hygiene, and first aid, while also diving into the specific needs of different species such as dogs, cats, horses, birds, and reptiles. The course also highlights the importance of animal psychology and its impact on their well-being, behaviour, and interactions with humans. Through engaging content and diverse modules, students will gain the knowledge and skills necessary for understanding and meeting the needs of animals in various environments, enabling them to pursue careers in animal care, psychology, and welfare. Course Modules Module 01: Introduction to the Care and Animal Welfare of All Species Module 02: Basic Animal Health & Nutrition Module 03: Hygiene and First Aid for Animal Module 04: Getting to Know the Dogs & Puppies Module 05: Getting to Know the Kittens and Cats Module 06: Learning about Horses Module 07: Learning about Birds Module 08: Specific Information on Rabbits & Guinea-Pigs Module 09: Specific Information on Ornamental Fish Module 10: Specific Information on Reptiles Module 11: Animal Psychology (See full curriculum) Who is this course for? Individuals seeking to develop a deeper understanding of animal care and psychology. Professionals aiming to expand their knowledge in animal welfare and psychology for career advancement. Beginners with an interest in animals and their care. Those seeking a career in animal welfare, psychology, or related fields. Career Path Animal Care Worker Animal Welfare Officer Veterinary Assistant Animal Behaviourist Pet Groomer Animal Trainer Wildlife Conservationist Zoo Keeper
Course Overview This comprehensive course in Digital Marketing offers an in-depth exploration of the strategies that define modern online success. From brand positioning and content creation to platform-specific approaches across Facebook, Instagram, and YouTube, this guide covers every key area to help learners thrive in a fast-evolving marketing landscape. You will examine essential digital concepts such as SEO, mobile outreach, and email campaign structuring, all while gaining the strategic mindset needed to implement effective marketing solutions. By the end of this course, learners will have a strong understanding of how to structure marketing plans, reach targeted audiences through various channels, and evaluate digital performance metrics. This course is ideal for those looking to enhance their marketing knowledge, keep up with digital trends, and align themselves with career opportunities in a digitally driven economy. Course Description The course delves into the strategic core of digital marketing, equipping learners with the knowledge to understand consumer behaviour, design impactful campaigns, and master various online platforms. You will begin with the fundamentals before advancing through growth hacking techniques, customer journey mapping, and platform-specific strategies across Facebook, Instagram, Twitter, and more. Topics such as SEO, email communication, content strategy, and mobile marketing are presented with clarity, ensuring learners develop a thorough grasp of marketing logic and campaign planning. This course also explores how to build audience engagement and interpret campaign performance using reliable frameworks. Whether you're aiming to support a brand, manage digital channels, or enhance visibility through marketing strategies, this course offers a structured foundation that meets the demands of today’s digital environment. Course Modules Module 01: Fundamentals of Digital Marketing Module 02: Growth Hacking Module 03: Customer Journey Module 04: Content Marketing Module 05: SEO Module 06: E-Mail Marketing Module 07: Facebook Marketing Module 08: Instagram Marketing Module 09: Twitter Marketing Module 10: YouTube Marketing Module 11: Mobile Marketing (See full curriculum) Who is this course for? Individuals seeking to understand digital marketing strategy from the ground up. Professionals aiming to expand their expertise in multi-channel marketing. Beginners with an interest in online promotion, brand development, or digital outreach. Entrepreneurs, freelancers, and content creators wanting to enhance their marketing knowledge. Career Path Digital Marketing Executive Social Media Manager SEO Specialist Content Marketing Strategist Email Marketing Coordinator Digital Campaign Analyst Brand Engagement Consultant Online Marketing Assistant
Course Overview The Care Certificate (15 Standards) course offers a foundational introduction to essential standards for individuals working in health and social care roles across the UK. Covering all 15 standards required by the Care Quality Commission (CQC), this course is designed to ensure learners understand their responsibilities, safeguarding protocols, and person-centred care approaches. It supports individuals in developing the knowledge needed to meet industry expectations in line with the Skills for Care guidelines. Upon completion, learners will be able to demonstrate a firm grasp of care values, communication techniques, infection control, and equality and diversity awareness, helping them integrate confidently into care settings. The Care Certificate provides an excellent starting point for those new to care roles or seeking to align their current practices with professional benchmarks. Course Description This course comprehensively covers the 15 core standards of the Care Certificate, including duty of care, communication, privacy and dignity, safeguarding adults and children, and health and safety. It provides detailed theoretical understanding to help learners develop a values-based approach aligned with UK care sector expectations. The course is structured to improve understanding of policies, legal frameworks, and workplace responsibilities in social care environments. Learners will explore topics such as person-centred support, infection prevention, mental health awareness, and handling information in care settings. The course supports learners in enhancing their understanding of the principles and frameworks that underpin professional conduct in care roles, helping them demonstrate competency across a wide range of subject areas relevant to both domiciliary and residential care roles. Course Modules: Module 01: Understand Your Role Module 02: Your Personal Development Module 03: Duty of Care Module 04: Equality and Diversity Module 05: Work in a Person-Centred Way Module 06: Communication Module 07: Privacy and Dignity Module 08: Fluids and Nutrition Module 09: Awareness of Mental Health, Dementia and Learning Disabilities Module 10: Safeguarding Adults Module 11: Safeguarding Children Module 12: Basic Life Support Module 13: Health and Safety Module 14: Handling Information Module 15: Infection Prevention and Control (See full curriculum) Who is this course for? Individuals seeking to start a career in health and social care. Professionals aiming to meet mandatory training requirements for care roles. Beginners with an interest in understanding care standards and regulations. Volunteers or support workers looking to formalise their knowledge in care settings. Career Path Care Assistant Support Worker Domiciliary Carer Healthcare Assistant Residential Care Worker Adult Social Care Professional
Course Overview This comprehensive course on "Pet Sitting and Dog Walking" offers learners the essential knowledge and skills to start and manage a successful pet care business. Covering everything from understanding animal behaviour to setting up and running your own business, the course equips you with the necessary tools to provide excellent care for pets. Learners will explore various animal species, including dogs, cats, birds, rabbits, guinea pigs, fish, and reptiles, gaining valuable insights into each animal's needs. The course also provides important information on licencing, legislation, safety protocols, and emergency procedures. By the end of this course, learners will be well-prepared to offer professional pet sitting and dog walking services, ensuring a safe and caring environment for pets under their supervision. Course Description This course delves into the key aspects of running a pet sitting and dog walking service. From understanding the legalities of starting a pet care business to learning how to manage various pet species, the course covers essential topics that every pet sitter and dog walker must know. Learners will explore the various requirements for licences and business setup, and gain in-depth knowledge about the animals they will be caring for, including dogs, cats, birds, rabbits, guinea pigs, fish, and reptiles. Additional modules focus on managing business operations, addressing safety concerns, and responding to emergencies. Through this course, learners will develop the expertise needed to build and manage a professional pet sitting and dog walking business, ensuring the safety and well-being of the pets in their care. Course Modules Module 01: Introduction to Pet Sitting Module 02: Licences and Legislation Module 03: Setting up Your Own Pet Sitting Business Module 04: Managing Your Pet Sitting Business Module 05: Getting to Know the Dogs & Puppies Module 06: Dog Walking Module 07: Getting to Know the Kittens and Cats Module 08: Learning about Birds Module 09: Specific Information on Rabbits & Guinea-Pigs Module 10: Specific Information on Ornamental Fish Module 11: Specific Information on Reptiles Module 12: Safety and Emergencies (See full curriculum) Who is this course for? Individuals seeking to start a career in pet care. Professionals aiming to expand their business into pet sitting and dog walking. Beginners with an interest in animal care and handling. Pet lovers who want to understand pet needs and safety in-depth. Career Path Pet Sitting Service Owner Dog Walker Pet Care Advisor Animal Welfare Consultant Veterinary Assistant
Course Overview The Fashion and Lifestyle Blogging course is designed to equip aspiring bloggers with the essential knowledge, strategies, and inspiration to succeed in the vibrant digital landscape. From setting up a blog to curating compelling content and engaging audiences across social platforms, learners will explore the full blogging journey. This course emphasises brand building, collaboration opportunities, and monetisation strategies, offering real-world insights into navigating the blogging industry. Upon completion, learners will be able to create, manage, and promote a professional blog with a confident understanding of personal branding, photography, networking, and industry partnerships. Whether aiming to establish an independent blog or to enhance a professional portfolio, learners will gain skills that are transferable across the broader fields of media, marketing, and communications. Course Description This comprehensive course in Fashion and Lifestyle Blogging provides an in-depth exploration of the key elements required to build a successful blog. Learners will be guided through the foundations of blogging, content creation techniques, photography essentials, and social media engagement strategies. Special attention is given to networking, brand collaboration, and monetisation opportunities, empowering learners to transform their passion into a sustainable presence. The course also covers branding principles and offers pathways for continued growth within the blogging sphere. Through structured modules, participants will acquire a thorough understanding of the digital environment and sharpen their skills in storytelling, image curation, and community building. By the end of the programme, learners will possess the confidence to carve out a distinctive online identity and explore diverse opportunities within the dynamic worlds of fashion, lifestyle, and digital media. Course Modules Module 01: Blogging 101 Module 02: Starting Out and Setting Up Module 03: Content Creation Module 04: Photography and Imagery Module 05: Staying Social Module 06: Networking and Events Module 07: Working with Brands Module 08: Monetising Your Blog Module 09: Building a Brand Module 10: Growing as a Blogger Module 11: The Fashion and Lifestyle Blogger Roundup (See full curriculum) Who is this course for? Individuals seeking to build a professional presence in blogging. Professionals aiming to expand into the digital media and influencer sectors. Beginners with an interest in fashion, lifestyle, and online content creation. Creatives and entrepreneurs looking to establish or enhance their personal brand. Social media users wishing to transition into content creation careers. Career Path Fashion Blogger Lifestyle Content Creator Digital Marketing Assistant Brand Collaboration Coordinator Influencer Marketing Specialist Social Media Manager Creative Content Consultant PR and Communications Officer
Course Overview Unlock your full creative potential with Creative Writing: Write Stories Like a Professional Writer! This course provides a comprehensive introduction to the art and craft of writing across a wide range of genres. Whether you aspire to write novels, poetry, children's books, or compelling non-fiction, this course offers practical insights and structured guidance to elevate your writing skills. Learners will explore key techniques for character development, dialogue creation, and story structuring, while gaining a deeper understanding of critical thinking and business writing. By the end of the course, you will be equipped with the knowledge and confidence to write professionally, refine your work through editing, and pursue opportunities for publication. Course Description Creative Writing: Write Stories Like a Professional Writer! takes you on an enriching journey through the world of creative writing. Covering fiction, non-fiction, poetry, and professional writing, the course develops both foundational and advanced writing techniques. Learners will engage with modules on writing horror and thriller stories, creating believable characters, crafting realistic dialogue, and understanding the publishing process. The course also introduces vital skills such as critical thinking and business writing to enhance versatility. With a focus on structured development and creativity, learners will build the confidence to produce polished, compelling pieces that meet professional standards. This course is suitable for individuals at all stages of their writing journey, offering the tools needed to transform ideas into powerful written works. Course Modules Module 01: Introduction to Creative Writing Module 02: The Development of Creative Writing Module 03: Novel Writing Module 04: Writing Non-Fiction Module 05: Creating Fictional Characters Module 06: Writing Realistic Dialogue Module 07: Writing Horrors, Thriller and Murder Stories Module 08: Writing for Children Module 09: Writing Poetry Module 10: Proposal Writing Module 11: Critical Thinking Module 12: Business Writing Module 13: Other Writings Module 14: Editing, Evaluating and Getting Published (See full curriculum) Who is this course for? Individuals seeking to master creative writing and storytelling techniques. Professionals aiming to enhance their communication and writing skills for diverse applications. Beginners with an interest in exploring the field of creative writing. Writers looking to prepare manuscripts for publication or self-publishing. Career Path Author Copywriter Content Writer Scriptwriter Editor Publishing Assistant Communications Officer Journalist Creative Writing Tutor
Course Overview: The "Event Management - Party Planner" course provides a comprehensive introduction to the dynamic field of party planning. Learners will explore the essential skills, techniques, and strategies needed to plan and execute various types of events. This course offers in-depth coverage of critical aspects such as budgeting, theme selection, venue requirements, and vendor coordination, helping learners develop the expertise required for a successful career in event management. With a focus on both the creative and logistical sides of party planning, this course provides learners with the tools to craft memorable events while managing the details with precision. Upon completion, learners will have the knowledge to confidently plan and organise events, providing exceptional experiences for clients. Course Description: This course covers a wide range of topics aimed at equipping learners with the essential knowledge and skills to succeed as a party planner. Learners will gain an understanding of different types of events, the critical skills required for planning, and how to start and manage a successful party planning business. Topics such as budgeting, guest demographics, theme selection, food and beverage management, and vendor coordination are explored in detail. Additionally, the course focuses on client acquisition, networking, and creating memorable events that leave a lasting impact. Learners will also delve into the logistical and organisational aspects of event management, ensuring they are well-prepared to handle all elements of a party planning project from start to finish. Course Modules: Module 01: Introduction to Party Planner Module 02: Types of Parties - Overview Module 03: Skills You Need to Be a Party Planner Module 04: Starting Your Party Planning Business Module 05: Party Planning Business Functions Module 06: Initial Planning & Budgeting Module 07: Guest Demographics Module 08: Choosing a Theme Module 09: Venue Requirements Module 10: Food and Beverage Module 11: Vendors Every Party Planner Should Know Module 12: Generating a Client Base Module 13: Networking Module 14: Making the Party Memorable (See full curriculum) Who is this course for? Individuals seeking to become professional party planners. Professionals aiming to expand their event management skills. Beginners with an interest in event planning and organisation. Anyone looking to start their own event planning business. Career Path: Event Planner Party Planner Wedding Planner Event Coordinator Corporate Event Organiser Venue Manager Event Consultant
Duration 5 Days 30 CPD hours This course is intended for Network Engineers, Network Administrators, Network Security Engineers, and NOC Administrators Overview Successful completion of this five-day, instructor-led course will help enhance your understanding of how to design, implement, and effectively operate a Prisma SDWAN solution. You will get hands-on experience configuring Prisma SD-WAN with a branch and datacenter, configure policies, and use Prisma SD-WAN services. The Prisma SD-WAN Design and Operation (EDU-238) course describes the next generation Prisma SD-WAN solution, the capability and value it provides over legacy WAN and SD-WAN implementations, and how to configure, operate, and troubleshoot the solution.This course is intended for people who must configure, maintain, and use wide area networks, from data centers, to branches, to the cloud. This class is powered by Cloud Harmonics. Course Outline Module 1 - Solution Overview Module 2 - Branch Design Module 3 - Routing Module 4 - Policy Module #1 - Application Path and QoS Policy Module 5 - Policy Module #2 - NAT, ZBFW and Security Module 6 - Event Policy Management Services Module 7 - DNS and DHCP Services Module 8 - Operations and Troubleshooting Module 9 - CloudBlades Module 10 - Integrating Prisma SD-WAN and Prisma Access for SASE Implementation Module 11 - DevOps Module 12 - Next Steps