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

3080 Exercises courses

REST API Automation Testing from Scratch - REST Assured Java

By Packt

This course has been updated with OAuth 2.0 Google Authentication real-time examples. 70% of the IT industry is now heading toward this API for automating services. Learn everything you need to know about REST API automation, even if you've never worked before on this domain.

REST API Automation Testing from Scratch - REST Assured Java
Delivered Online On Demand24 hours 5 minutes
£87.99

Introduction to MongoDB for Developers (TTDB4683)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced application developers new to MongoDB. Overview This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment, guided by our expert team, you'll explore: Storage Basics MongoDB Document Model MongoDB Setup CRUD: Basics through Advanced Concepts Performance: Basics through Advanced Concepts Aggregation: Basics through Advanced Concepts Replication: Basics through Advanced Concepts Sharding: Basics through Advanced Concepts Schema Design Security Basics, Authentication & Authorization Application Development and Drivers Geared for experienced developers, Introduction to MongoDB for Developers is a comprehensive course that provides you with hands-on experience with the MongoDB query language, aggregation framework, data modeling, indexes, drivers, basic performance tuning, high availability and scaling. Throughout the course, you?ll explore the MongoDB Atlas database environment in detail, gaining job-ready skills you can put right to work after class. Storage Basics What is a Storage Engine? WiredTiger Storage Engine In-Memory Storage Engine Encrypted Storage Engine MongoDB Document Model JSON and BSON MongoDB Data Types MongoDB Setup Atlas Setup / Local MongoDB Setup CRUD Basics Insert Command Find Command Query Operators Remove Command Updating Documents CRUD Advanced Bulk Writes Retryable Writes Find and Modify Transactions Performance Basics Indexes Aggregation Basics Aggregation Pipeline Concepts Aggregation Pipeline Stages Aggregation Pipeline Expressions Aggregation Advanced $lookup stage $graphLookup stage $expr operator Faceted Search Type Conversions Advanced Expression Operators Date Expression Operators Expression Variables Aggregation Pipeline Optimizations Aggregation in a Sharded Cluster Replication Basics MongoDB Replica Sets Replica Set Use Cases Replication Mechanics Replication Advanced Using Write Concern to Tune Durability Semantics Using Read Concern to Tune Read Isolation Using Read Preference Replica Set Tag Sets Sharding Basics Sharding Concepts When to Shard What is a Shard Key? Zoned Sharding / MongoDB Atlas Global Clusters Sharding Advanced Components of a Sharded Cluster Sharding Mechanics Choosing a Good Shard Key Schema Design Schema Design Core Concepts Common Patterns Security Basics Authentication & Authorization Network Encryption Encryption at Rest Auditing

Introduction to MongoDB for Developers (TTDB4683)
Delivered OnlineFlexible Dates
Price on Enquiry

Diploma in Pet Dog Care

4.3(43)

By John Academy

Do you have a a dog? Or do you just love dogs? And do you want to learn what is needed to take care of your extended family? Then this diploma in caring for your pet dog is for you to be able to take care of your dog the best way you could. Description: A puppy can be a loving expansion to your family but whether you're an expert pet parent or a first-time adopter, it's essential to keep your dog's prosperity and satisfaction a top need. The Diploma in Caring for your Pet Dog will give some important tips for all puppy gatekeepers that are useful when you deal with your pooch. Having another puppy or grown-up pooch is an energizing minute and a point of reference for the whole family and since puppies are known as man's closest companion and a steadfast canine is something beyond a pet since they are dealt with as a cherished individual from the family. In addition, having a puppy as a pet resembles having a youngster but physically there is really no relationship however puppies are feeling creatures and need care and love too like a kid. Thusly, in the mission to be a not too bad and disapproving of the canine proprietor, the proprietor ought to have the ability to play out some to a great degree principal exercises that are essential in this demeanor, which will be by and large invited by your pet. The Diploma in Dog Care will most likely help you with the essential puppy mind on how you ought to look after your puppies, what things they need and how veterinarian will have the capacity to help you. Who is the course for? Dog owners and lovers who want to learn how to take of their dogs Dog breeders, groomers, handlers, and trainers who want to know how to care for dogs properly. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diploma in Pet Dog Care is perfect for dog owners and lovers who want to live peacefully with their obedient and well-behaved dogs. The course can also help the following dog-related careers: Animal Behaviourist Dog Breeder Dog Groomer Dog Handler Dog Service Trainer Dog Sitter Dog Trainer. Module-1 Understanding the appropriate food ingredients 00:30:00 Dogs need different diets at different ages 00:15:00 Vitamin and mineral supplements 00:15:00 Boredom and variety 00:15:00 Cost of feeds 00:15:00 Dry vs. Canned food 00:15:00 Homemade diets 00:15:00 Module-2 Food allergies 00:30:00 How much should I feed my dog? 00:30:00 How often should I feed my dog? 00:30:00 Signs of ill health 00:30:00 Heart worm, fleas and other parasites 00:30:00 Heartworm prevention 00:15:00 Common questions about heartworm 00:30:00 Module-3 Fleas and other parasites 00:30:00 Do parasites cause 'Scooting'? 00:15:00 Preventing dental disease 00:30:00 Home dental care 00:30:00 Veterinary dental treatments 00:30:00 The importance of the physical examination 00:30:00 Why are regular check-ups important? 00:15:00 Module-4 What happens during an examination? 00:30:00 How often should my pet be examined? 00:15:00 How to administer medicine 00:30:00 Nursing a sick dog 00:30:00 Vaccinations 00:30:00 Common questions about vaccinations 00:30:00 Spaying and neutering 00:30:00 Module-5 Spaying of the Female dog 00:30:00 Surgical neutering of the male dog 00:30:00 Pet health insurance 00:30:00 Clipping a dog 00:15:00 First steps in grooming 00:30:00 Bathing a dog 00:30:00 Pet Identification 00:30:00 Mock Exam Mock Exam- Diploma in Pet Dog Care 00:20:00 Final Exam Final Exam- Diploma in Pet Dog Care 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Diploma in Pet Dog Care
Delivered Online On Demand15 hours 25 minutes
£25

Aruba Networks - Aruba Switching Fundamentals For Mobility, Rev. 16.41 (ASFM)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for IT Professionals who deploy small-to- medium scale enterprise network solutions based on Aruba products and technologies Overview Upon completion of this course, you will be able to:Explain how Aruba networking solutions meet customers? requirementsExplain how Aruba AirWave provides unified wireless and wired network managementDescribe in-band management and out-of-band managementComplete the initial setup on ArubaOS switchesControl access to switches for both in-band and out-of-band managementManage software and configuration files on ArubaOS switchesExplain use cases for VLANs and configure port-based VLANs on ArubaOS switchesUnderstand and configure Rapid Spanning Tree Protocol (RSTP)Understand and configure Multiple Spanning Tree Protocol (MSTP)Differentiate between different types of link aggregation and understand the benefits of Link Aggregation Control Protocol (LACP)Configure and troubleshoot link aggregation on ArubaOS switchesConfigure static routes on ArubaOS switches and interpret IP routing tablesConfigure a basic Open Shortest Path First (OSPF) solutionDescribe how Virtual Switching Framework (VSF) works and the advantages that it providesConfigure and verify a simple VSF fabricDescribe the basics of wireless communications and 802.11 standardsDefine a wireless LAN (WLAN) and differentiate between wireless security optionsConfigure basic settings on Aruba Instant APsConfigure AirWave management settings on an IAP clusterConfigure SNMP v2c settings on ArubaOS switchesDiscover ArubaOS switches in AirWave and bring switches and IAPs under monitoring and managementImplement zero touch provisioning (ZTP) for Aruba IAPs and ArubaOS switches This course teaches you the fundamental skills necessary to configure and manage modern, open standards-based networking solutions. This course consists of approximately 20% lecture and 80% hands-on lab exercises to help you learn how to implement and validate small to medium enterprise network solutions. This 3-day course prepares network professionals for the HPE ATP - Aruba Mobile First Solutions V1 certification exam.In this course, participants learn about ArubaOS switch technologies including: VLANs, securing access, redundancy technologies such as MSTP, link aggregation techniques including LACP, and switch virtualization with Aruba?s Virtual Switching Framework (VSF). You also learn about IP Routing including static and dynamic IP routing with OSPF. This course teaches you how to deploy Aruba wireless Access Points and configure Aruba Clustering technology. It also teaches you how to configure, manage and monitor the network with the Aruba AirWave management solution. Introduction to Aruba, a Hewlett Packard Enterprise companySwitch CLI (Command Line Interface) NavigationProtecting Management AccessManagement of Software and ConfigurationsVLANSSpanning Tree Protocol (STP)Link AggregationIP RoutingVirtual Switching Framework (VSF)Wireless for Small-to-Medium Businesses (SMBs)Aruba AirWave

Aruba Networks - Aruba Switching Fundamentals For Mobility, Rev. 16.41 (ASFM)
Delivered OnlineFlexible Dates
Price on Enquiry

Paralegal Training

4.7(160)

By Janets

Unlock a rewarding career with our comprehensive Paralegal Training. Gain essential legal knowledge, hone research skills, and master the art of legal documentation. Elevate your professional journey with practical insights and hands-on experience. Start your path to success today.

Paralegal Training
Delivered Online On Demand
£25

Insurance Training Course

By Compete High

🎉 Unlock the doors to success with our comprehensive Insurance Training Course! 🎓 Whether you're diving into the world of insurance for the first time or looking to level up your skills, this course is your ultimate guide to mastering the ins and outs of the insurance industry.   🔍 What can you expect from our Insurance Training Course? Let's dive in! 💡 Learn from Experts: Our course is curated by industry experts with years of experience in the insurance field. You'll benefit from their insights, tips, and real-world examples that will help you navigate the complexities of insurance with confidence. 📚 Comprehensive Curriculum: From the fundamentals of insurance principles to advanced topics like risk management and underwriting, our course covers it all. You'll gain a solid understanding of key concepts, regulations, and best practices that are essential for success in the insurance industry. 💼 Practical Skills Development: Theory is important, but so is hands-on experience! That's why our course is designed to provide you with practical skills that you can apply directly in your insurance career. Whether it's assessing risk, calculating premiums, or handling claims, you'll develop the skills employers are looking for. 👩‍🏫 Flexible Learning: We understand that everyone has different schedules and learning preferences. That's why our course offers flexible learning options, including online modules, video lectures, and interactive exercises. Learn at your own pace, whenever and wherever you want. 🌟 Career Advancement Opportunities: Whether you're aiming for a career as an insurance agent, underwriter, claims adjuster, or risk manager, our course will equip you with the knowledge and skills you need to succeed. Stand out from the competition and advance your career with confidence.   🚀 Who is this for? Our Insurance Training Course is perfect for: Aspiring insurance professionals looking to kickstart their careers. Current insurance employees seeking to expand their knowledge and skillset. Individuals considering a career change to the insurance industry. Entrepreneurs or small business owners who want to understand insurance for their businesses. Students or recent graduates interested in pursuing a career in insurance. No matter where you are in your career journey, our course will empower you to reach your goals in the insurance industry.   🛣️ Career Path The insurance industry offers a wide range of career opportunities, and our course can help you unlock them. Here are just a few potential career paths you could pursue after completing our Insurance Training Course: Insurance Agent/Broker: Help individuals and businesses find the right insurance coverage to meet their needs. Underwriter: Assess risks and determine coverage and premiums for insurance policies. Claims Adjuster: Investigate insurance claims and determine the extent of coverage and payouts. Risk Manager: Identify and analyze potential risks for businesses and recommend strategies to mitigate them. Actuary: Use mathematical and statistical methods to assess risk and uncertainty in the insurance industry. And these are just a few examples! With the knowledge and skills gained from our course, you'll have the flexibility to pursue various career paths within the dynamic and rewarding field of insurance. Ready to embark on your insurance journey? Enroll in our Insurance Training Course today and take the first step towards a successful and fulfilling career in insurance! 🎉   FAQs 1. What is insurance? Insurance is a contract between an individual or entity (the insured) and an insurance company (the insurer), whereby the insurer agrees to provide financial protection or reimbursement against specified losses in exchange for payment of premiums. It helps individuals and businesses mitigate financial risks by transferring them to the insurance company. 2. Why is insurance important? Insurance is crucial for protecting individuals, businesses, and assets against unexpected events and losses. It provides financial security and peace of mind, ensuring that individuals and businesses can recover from accidents, natural disasters, liability claims, and other unforeseen circumstances without facing severe financial hardship. 3. What types of insurance are there? There are various types of insurance tailored to different needs and risks. Common types of insurance include: Health insurance Life insurance Property insurance (e.g., homeowners insurance, renters insurance) Auto insurance Liability insurance Business insurance (e.g., commercial property insurance, professional liability insurance) Travel insurance 4. How does insurance work? Insurance works on the principle of risk pooling and sharing. Policyholders pay premiums to the insurance company, which pools these funds to cover potential losses. When a covered event occurs, policyholders can file a claim with the insurance company, and if the claim is approved, the insurer provides financial compensation or coverage as per the terms of the policy. 5. What is the role of an insurance agent? Insurance agents act as intermediaries between insurance companies and customers. They help individuals and businesses assess their insurance needs, recommend suitable policies, explain coverage options and terms, and assist with the purchasing process. They also provide ongoing customer support, handle policy renewals, and facilitate claims processing. 6. How do I choose the right insurance policy? Choosing the right insurance policy depends on various factors, including your individual or business needs, budget, risk tolerance, and preferences. It's essential to evaluate different policy options, compare coverage features and premiums, and consider factors such as deductibles, limits, exclusions, and the financial strength and reputation of the insurance company. Working with a knowledgeable insurance agent or broker can also help you make informed decisions. 7. Is insurance regulated? Yes, insurance is regulated by government authorities to ensure consumer protection, solvency of insurers, and fair practices within the industry. Regulations may vary by country or jurisdiction and typically involve licensing requirements for insurers and agents, financial reporting standards, consumer protection laws, and oversight by regulatory agencies or departments. Compliance with regulations helps maintain the stability and integrity of the insurance industry.   Remember, while this FAQ section provides general information, specific details may vary based on your location, insurance type, and individual circumstances. It's always advisable to consult with insurance professionals or industry experts for personalized guidance and advice. Course Curriculum Module 1_ Introduction to Insurance. Introduction to Insurance. 00:00 Module 2_ Types of Insurance Policies. Types of Insurance Policies. 00:00 Module 3_ Underwriting and Risk Assessment. Underwriting and Risk Assessment. 00:00 Module 4_ Claims and Loss Adjustments. Claims and Loss Adjustments. 00:00 Module 5_ Regulatory and Legal Issues in Insurance. Regulatory and Legal Issues in Insurance. 00:00

Insurance Training Course
Delivered Online On Demand5 hours
£25

Crisis communications

By Rough House Media

Are you confident your organisation could cope if a bad news story went viral and you were besieged by the media? Would you be able to fend off a determined and aggressive journalist, take control and deliver your key messages? Our crisis communications courses show you how to cope when your organisation is under fire, and protect your good name. We can: Train your spokespeople to handle challenging interviews, pitting their wits against a hostile reporter Train your PR team to manage communications during an unfolding crisis Deliver a fast-paced crisis simulation where your team have to decide how to handle the press during an unfolding emergency Facilitate a crisis strategy workshop, where we work together to develop your crisis communications strategy All of our crisis communications courses are bespoke, so we will design each one to meet your specific needs. Areas we can cover include: How a crisis can escalate in seconds How journalists respond to bad news stories How to develop effective key messages & write holding statements How to manage your social media How to take control of an interview and get your message across How to handle press conferences and doorsteps Venue We deliver courses in the most appropriate format for your circumstances – whether face to face or online. Face to face courses are portable: they can be held in purpose-built studios, at your own offices or at an external venue. In the latter two cases, we create a mock studio for the practical exercises. Online courses give you flexibility and enable you to offer training to delegates from all over the world. We have run virtual courses for people from the Far East, South Asia, North America and Europe, as well as the UK.

Crisis communications
Delivered in Richmond or UK Wide or OnlineFlexible Dates
Price on Enquiry

How to speak in public with Karen Hale - Speak up and be heard

By The Motivation Clinic

An interactive workshop with Karen Hale. Learn how to gain the confidence, skills and techniques to speak up so you can be heard. "There are two types of speakers: Those who get nervous and those who are liars." - Mark Twain Is this you? Promotions not applied for, jobs roles not tried for, networking events not attended? Parties avoided, family ceremonies not spoken at, too much left unsaid? Do you have excellent ideas that get lost in time because you are fearful of voicing them. Have you missed opportunities because it involves showing up? Do you stay silent in meetings? Do you have a brilliant business idea that isn’t being pursued because you know it will involve some kind of networking or public speaking? If the answer to any/most of these is YES, then read on... This workshop is strange by its nature. Why would someone who disliked public speaking, go to a place where they would speak in public? This is why.... Because Karen has analysed what makes a good communicator when speaking informally to people; she has taken those aspects and developed a group of exercises that allows you to use these exact techniques when speaking at networking events and in public. Added to that, Karen provides a smorgasbord of methods on how to control nerves to ensure you communicate at your authentic best. Please note: everybody in the room will be there for the same reason as you! You will be supported and encouraged and will learn how to turn fear into empowerment! About Karen: An empowerment and public speaking coach with over 30 years experience in coaching and advising individuals and business leaders from a diverse range of sectors on effective communication skills. It takes a second to form a first impression about a person. Your body language, clothes, speech and personal presence convey messages about your background, skills and expertise. Karen works with her clients to ensure they make that first impression powerful and authentic so they get remembered for the right reasons. By creating a confident and authentic presence you increase your visibility and your credibility. “Karen is a truly special individual. She made me feel totally at ease and was able to help me stand and speak confidently for the first time and she did that all with huge warmth and a lot of humour.” She fulfils her greatest passion on a daily basis, helping people present themselves to the outside world in the very best way. She has enabled hundreds of people to move on in their life and careers and build their growth, confidence and image. Karen works across a huge spectrum - from CEOs in FTSE 100 companies to Foundation Class university students at UAL coaching presentation skills. She coaches senior individuals and consults to leading global banks, private banks and family offices, advising business leaders and their teams. She is Central School of Speech and Drama trained. Kind words about Karen... I have had the absolute pleasure of working with Karen numerous times over the past 16 years to assist me in my various corporate roles. Karen has always been the person I have turned to first and foremost when I have needed help with my personal brand, presence and communication, helping me develop confidence in public speaking and showing up in front of the camera. A HUGE thank you for Monday – you were wonderful. The feedback we have had has been unbelievable – I can honestly say in all my years in this industry I have never heard such positive comments on every aspect. Karen has an incredible gift of making you feel completely at ease and is able to bring the best out of a person with ease. She is friendly, approachable and warm and I now refer Karen to everybody I know who needs assistance with any type of public speaking, communication and confidence requirement. The results speak for themselves. Highly recommend! You can contact Karen at: https://www.linkedin.com/in/karen-hale-8925862b/ / 07956626740 For any questions regarding this event, please contact the organiser lara@themotivationclinic.co.uk / 07817247727 - thank you!

How to speak in public with Karen Hale - Speak up and be heard
Delivered OnlineFlexible Dates
£5

Animal Carer & Behaviourist Certificate

5.0(1)

By Course Gate

Gain a deeper understanding of animal behaviour and psychology with our Animal Carer & Behaviourist Certificate course. Explore the evolution of pets, delve into the unique characteristics of dogs, cats, and rabbits, and learn practical skills to foster a nurturing environment for animals.

Animal Carer & Behaviourist Certificate
Delivered Online On Demand2 hours 14 minutes
£11.99

The Complete SQL from Scratch: Bootcamp

5.0(10)

By Apex Learning

Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00

The Complete SQL from Scratch: Bootcamp
Delivered Online On Demand6 hours 39 minutes
£12