17535 Basic courses delivered On Demand

Are you ready to embark on an enlightening journey of wisdom with the COSHH & Spill Management bundle, and pave your way to an enriched personal and professional future? If so, then Step into a world of knowledge with our course bundle - COSHH, Spill Management and Risk Assessments . Delve into eight immersive CPD Accredited courses, each a standalone course: Course 01: COSHH - Control of Substances Hazardous to Health Course 02: Chemical Spill Course 03: DSEAR Training Course 04: Spill Management Training Course 05: Lone Worker Safety Course 06: Working in Confined Spaces Course 07: Infection Control Course 08: Level 2 Health and Safety in the Workplace Traverse the vast landscapes of theory, unlocking new dimensions of understanding at every turn. Let the COSHH, Spill Management and Risk Assessments bundle illuminate your path to wisdom. The COSHH, Spill Management and Risk Assessments bundle offers a comprehensive exploration into a rich tapestry of vast knowledge across five carefully curated courses. The journey is designed to enhance your understanding and critical thinking skills. Each course within the bundle provides a deep-dive into complex theories, principles, and frameworks, allowing you to delve into the nuances of the subject matter at your own pace. In the framework of the COSHH, Spill Management and Risk Assessments package, you are bestowed with complimentary PDF certificates for all the courses included in this bundle, all without any additional charge. Adorn yourself with the COSHH & Spill Management bundle, empowering you to traverse your career trajectory or personal growth journey with self-assurance. Register today and ignite the spark of your professional advancement! So, don't wait further and join the COSHH, Spill Management and Risk Assessments community today and let your voyage of discovery begin! Learning Outcomes: Attain a holistic understanding in the designated areas of study with the COSHH & Spill Management bundle. Establish robust bases across each course nestled within the COSHH & Spill Management bundle. Decipher intricate concepts through the articulate content of the COSHH & Spill Management bundle. Amplify your prowess in interpreting, scrutinising, and implementing theories. Procure the capacity to engage with the course material on an intellectual and profound level. Become proficient in the art of problem-solving across various disciplines. Stepping into the COSHH & Spill Management bundle is akin to entering a world overflowing with deep theoretical wisdom. Each course within this distinctive bundle is an individual journey, meticulously crafted to untangle the complex web of theories, principles, and frameworks. Learners are inspired to explore, question, and absorb, thus enhancing their understanding and honing their critical thinking skills. Each course invites a personal and profoundly enlightening interaction with knowledge. The COSHH & Spill Management bundle shines in its capacity to cater to a wide range of learning needs and lifestyles. It gives learners the freedom to learn at their own pace, forging a unique path of discovery. More than just an educational journey, the COSHH & Spill Management bundle fosters personal growth, enabling learners to skillfully navigate the complexities of the world. The COSHH & Spill Management bundle also illuminates the route to a rewarding career. The theoretical insight acquired through this bundle forms a strong foundation for various career opportunities, from academia and research to consultancy and programme management. The profound understanding fostered by the COSHH & Spill Management bundle allows learners to make meaningful contributions to their chosen fields. Embark on the COSHH & Spill Management journey and let knowledge guide you towards a brighter future. CPD 80 CPD hours / points Accredited by CPD Quality Standards Who is this course for? COSHH & Spill Management Individuals keen on deepening their firm understanding in the respective fields. Students pursuing higher education looking for comprehensive theory modules. Professionals seeking to refresh or enhance their knowledge. Anyone with a thirst for knowledge and a passion for continuous learning. Requirements To enrol in this COSHH, Spill Management and Risk Assessments course, all you need is a basic understanding of the English Language and an internet connection. Career path Armed with the COSHH & Spill Management bundle, your professional journey can reach new heights. The comprehensive theoretical knowledge from this bundle can unlock diverse career opportunities across several fields. Whether it's academic research, consultancy, or programme management, the COSHH & Spill Management bundle lays a solid groundwork. Certificates CPD QS PDF Certificates Digital certificate - £4.99 CPD QS Hardcopy Certificate Hard copy certificate - £11.99

Explore the intricate world of orthodontic biomechanics with our comprehensive course. Master the fundamental concepts, advanced techniques, and cutting-edge technologies shaping modern orthodontics. From archwires to aligner therapy, delve into the biomechanics of tooth movement, anchorage control, and space closure. Elevate your practice with expert insights, ensuring precision in class II and class III corrections. Join us for a transformative learning experience in the dynamic intersection of orthodontics and biomechanics.

Wanna be a better and more successful Copywriter? Copywriting is the most useful skill a person can have, and learning how to write persuasive copy has the potential to change everything for you. If you want to learn how to write powerful copy that people want to pay you for, sign up for this complete accredited copywriting course today. If you want to meet your goals, it all comes down to your words; the words on your website, emails, newsletters, pitches, proposals, and brochures. And when you can write to persuade, many possibilities in your life and business open up to you. Learn more about the course on developing and writing portfolio, blogging, SEO copywriting, and other topics. Key highlights of the course: CPD Accredited Copywriting Course Lifetime Access Unlimited Retake Exam & Tutor Support Easy Accessibility to the Copywriting Course Materials 100% Learning Satisfaction Guarantee Self-paced Copywriting Course Modules What you will learn from the Copywriting course: Learn the ways to sell more products and services (just by being helpful!). Learn to compel your readers using timeless sales psychology. Learn to gently + ethically stoke people to act NOW. A comprehensive introduction to the course basics. Detailed understanding of writing techniques. Proficiency in writing eye-catching headlines. A solid grasp of attention-grabbing advertisements. Extensive knowledge of online and press-related copywriting. A clear idea of copywriting for mainstream media. Strong comprehension of Search Engine Optimisation (SEO). Reed courses certificate of completion Digital certificate - Included It will be downloadable when all lectures have been completed CPD 30 CPD hours / points Accredited by CPD Quality Standards Section 1: Overview 06:23 1: Course Overview 06:23 Section 2: Introduction to copywriting 16:13 2: Introduction 16:13 Section 3: Copywriting for Mainstream Media 09:00 3: Copywriting for Mainstream Media 09:00 Section 4: Copywriting for Other Media 11:17 4: Copywriting for Other Media 11:17 Section 5: Copywriting Skills 21:25 5: Essential Copywriting Skills 21:25 Section 6: Write a Better Copy 11:59 6: How to Write Better Copy 11:59 Section 7: Business Copywriting 28:35 7: Business Writing 28:35 Section 8: Press Related Copywriting 17:50 8: Press Related Copywriting 17:50 Section 9: Online Copywriting 24:07 9: Online Copywriting 24:07 Section 10: Eye-Catching Headlines 12:08 10: Eye-Catching Headlines 12:08 Section 11: Print Media Copywriting 15:04 11: Print Media Copywriting 15:04 Section 12: Attention Graving Advertisement 12:52 12: Attention Graving Advertisement 12:52 Section 13: Final Tips 11:38 13: Final Tips 11:38 FREE Bonus Module: Time Management 25:08 14: FREE Bonus Module: Time Management 25:08 Order Your CPD Quality Standard Certificate (Optional) 01:00 15: CPD Certificate (Optional) 01:00 Who is this course for? Anyone from any background can enrol in this course. Particularly, this Copywriting course is recommended for Novel Writer/ Story Writer Content Developer Journalist Report Writer Creative Copywriter Blogger Becoming a Freelancer SEO Copywriting Requirements Students seeking to enrol for this copywriting course should meet the following requirements; Basic knowledge of English Language, which you have already Basic Knowledge of Information & Communication Technologies for studying online or digital platform Stable internet or data connection to your learning devices Career path This copywriting course will provide you with all the knowledge and skills needed to be an expert copywriter.So, explore trendy and in-demand jobs such as, Technical Copywriter Content Specialist Conceptual Copywriter SEO Strategist Content and Copywriting Executive Explore each available role and how you can start your career as a copywriter. Certificates Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed. CPD Quality Standard Certificate Digital certificate - £7.99

***Limited Time Exclusive Bundle*** Get Hard Copy + PDF Certificates + Transcript + Student ID Card + e-Learning App as a Gift - Enrol Now Tired of browsing and searching for a Health and Social Care course you are looking for? Can't find the complete package that fulfils all your needs? Then don't worry as you have just found the solution. Take a minute and look through this extensive bundle that has everything you need to succeed. After surveying thousands of learners just like you and considering their valuable feedback, this all-in-one Health and Social Care bundle has been designed by industry experts. We prioritised what learners were looking for in a complete package and developed this in-demand Health and Social Care course that will enhance your skills and prepare you for the competitive job market. Also, our experts are available for answering your queries on Health and Social Care and help you along your learning journey. Advanced audio-visual learning modules of these Health and Social Care courses are broken down into little chunks so that you can learn at your own pace without being overwhelmed by too much material at once. Furthermore, to help you showcase your expertise in Health and Social Care, we have prepared a special gift of 1 hardcopy certificate and 1 PDF certificate for the title course completely free of cost. These certificates will enhance your credibility and encourage possible employers to pick you over the rest. This Bundle Consists of the following Premium courses: Course 01: Level 4 Diploma in Health and Social Care Management Course 02: Public Health Course 03: Mental Health Laws and Awareness - Level 2 Course 04: Adult Nursing Diploma Course 05: Family Support Worker Diploma Course 06: Counselling Course Course 07: Understanding Nutrition and Health Level 4 Course 08: Social Work Studies Diploma Course 09: Youth Work Certificate Complete Diploma Course 10: Safeguarding Children Level 3 Course 11: Domestic Violence and Abuse Awareness - Level 2 Course 12: Diabetes Care Diploma Course 13: Family Law 2021 Course 14: Personal Hygiene Enrol now in Health and Social Care to advance your career, and use the premium study materials from Apex Learning. The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Health and Social Care expertise and essential knowledge, which will assist you in reaching your goal. Curriculum of this Bundle Course 01: Level 4 Diploma in Health and Social Care Management Introduction Communication and its Relevance Rights and Responsibilities as a Health and Social Care Worker Role as A Caregiver and Healthcare Professional Working in Health and Social Care; Promoting Equality, Diversity and Rights Important Principles and Policies in Health and Social Care Work Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 Safeguarding Vulnerable Individuals Health and Safety Responsibilities The Economics of Healthcare Strategic Marketing Managing Finance Managing Service Delivery Course 02: Public Health Introduction to Public Health Principles of Public Health Understanding Epidemiology And much more... Course 03: Mental Health Laws and Awareness - Level 2 The Mental Capacity Act Interface with Legislation, Policy and Procedures Deprivation of Liberty Safeguards And much more... Course 04: Adult Nursing Diploma Introduction to Nursing Working in Different Healthcare Settings Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 And much more... Course 05: Family Support Worker Diploma Introduction to Family Support Work Legislation, Policy and Guidance Solving Family Issues - Part 1 And much more... Course 06: Counselling Course Introduction to the course Understanding Psychotherapy Starting Psychotherapy Practice And much more... Course 07: Understanding Nutrition and Health Level 4 Introduction to Nutrition Nutrients for Life - Nutrients for Life Macronutrients Nutrients for Life - Micronutrients Nutrition Requirements from Pregnancy to Teenage And much more... Course 08: Social Work Studies Diploma An Overview of Social Work Social Work Basics Theories of Social Work and Sociology Casework Process and Teamwork And much more... Course 09: Youth Work Certificate Complete Diploma Introduction to Youth Work Understanding Youth Work Ethical Conduct and Principles in Youth Work Societal Influence on Youth And much more... Course 10: Safeguarding Children Level 3 Laws and Guidance Social and Emotional Development Personality and Intellectual Development of Children And Many More... Course 11: Domestic Violence and Abuse Awareness - Level 2 Introduction to Domestic Violence & Abuse The Components of Domestic Violence The Impact of Domestic Violence on Victims And much more... Course 12: Diabetes Care Diploma What is Diabetes The Diabetes Challenge The Cost of Diabetes in Social Care Type 1 Diabetes And much more... Course 13: Family Law 2021 Introduction to Family Law Framing Family Law Marriage in Family Law Civil Partnership and Cohabitation And much more... Course 14: Personal Hygien Introduction to Personal Hygiene and a Brief History Looking Clean, Smelling Clean Improving and Maintaining Oral Health Care of the Eyes And much more... How will I get my Certificate? After successfully completing the course, you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this Health and Social Care bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this course expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Hard copy certificate - Included P.S. The delivery charge inside the UK is £3.99, and the international students have to pay £9.99. Certificate of completion Digital certificate - Included

Rational Emotive Behavior Therapy (REBT) was invented and developed by the American psychotherapist and psychologist Albert Ellis. It

Develop your graphic design skills and learn the professional Photoshop tools and techniques Looking to become a highly skilled Photoshop expert? Explore multiple graphic design training sessions and learn special Photoshop skills that’ll let you spread your creative wings. Here’s a Photoshop course full of valuable knowledge and tips that will help you edit and produce professional-grade images, photos, vectors and graphics by practicing with exciting tasks and exercises. The course is available for people with little or no experience in professional design and want to get their skills to a high level quickly. You can study at your own pace, anytime, anywhere; all you need is an internet connection. The flexibility of the course makes it easy to fit into your schedule and let you study stress-free from day one. You will master the Photoshop and learn everything about its interface and editing tools as well as how to use more advanced functions. Whether you want to use Photoshop for personal projects or integrate it into your professional work, this course has everything you need. Our expert will give you the tips on how to use Photoshop efficiently and will take you from beginner to pro. After taking the course, you will be completely comfortable navigating Photoshop and producing high-quality creative content. You will feel confident with your newfound ability to create astounding graphics with Photoshop. The Photoshop course explains everything in a simple, easy to follow format. Within it, you will find easy ways to use the vast array of tools available. You will learn from an expert with extensive professional Photoshop experience. Get creative! Start today! Join this comprehensive Photoshop course and get the benefits: Learning from a professional instructor24/7 access from any devicePractical exercisesTests, quizzes and recapsCertificate of completionExtra materials and downloadable bonuses100% satisfaction guarantee Your Singing Instructor: Claude Simmons Photoshop expert Learn from an industry-leading expert in the digital creative sector!  You will learn from a Photoshop pro with over 10 years of experience using the program in a professional capacity. The course instructor has worked with many global brands and will share his expertise on how to enhance your photos, create graphics and develop professionally. Our course expert is passionate about simplifying the creative process and inspiring you to produce visually pleasing content using Adobe Photoshop. He will share the top tips and tricks on how to deliver consistently high-quality content for your projects without breaking a sweat. Claude will guide you from the very basics to the complex tools, so you become proficient in all areas of Photoshop. Sign up today to learn from one of the top creatives in the industry. Overview of the course:   – VIDEO PRESENTATIONS –   1. Practical knowledge about using Photoshop for both fun and professional purposes Getting to grips with the graphic designer knowledge, including: composition, UX, using colors, typography, formats, styles and more! You will learn how to choose best tools for a professional effect, both hardware and software. 2. Step-by-step video guides for complete skill enhancement Learn about Adobe cloud environment and Photoshop image and photo enhancing capabilities, work space, file formats and color modes.   – PRACTICAL PART –   Training videos and video tutorials In the course you can find in-depth tutorials that will help you discover all useful functions including retouch and photomontage. With this comprehensive and intensive course you will gain new skills quickly, so that you can implement them right away.   – REPETITIONS AND TESTS –   1. Repetition of acquired knowledge and tests Throughout the course, you will have 5 repetitions and 5 tests that will allow you to consolidate your knowledge. 2. Final test Passing the final test means that you have the knowledge and skills needed to use Photoshop at a professional level.   – EXERCISES AND TASKS – Design preparation and workshop Efficient use of Photoshop interface Designing with basic tools Creating retouches and photomontages Advanced designing with expert features   – BONUS MATERIALS – Photoshop tips and tricks guide Compendium of image formats Layout templates Thematic combinations (themes) Experience Beginner-IntermediateLanguage English, German, French, Polish, Portuguese A letter from your expert instructor Why join the Kemp Center’s Photoshop course?Using digital creative platforms is a must in today’s world. Learning how to use Photoshop and gaining creative skills will give you an advantage, both professionally and while working on your passion projects. Photoshop can give you that extra edge. Stand out from others by showing you can create the thing that everyone wants – engaging graphic content.While learning Photoshop can enhance your career, it’s also very fun! You can use the program to retouch images, create compositions with graphics and text or create your own funny GIFs. Whatever you want to do, Photoshop has features to help you bring your creative visions to life. So don’t wait up, and start getting creative today!Our Photoshop course is comprehensive and covers all the basics but also teaches about Photoshop’s advanced features. After completing the course, you will become a confident graphic designer and, once you’re familiar with the interface, you can release your creative imagination.This course is for both beginners and more advanced users and you can decide yourself how deep you want to go with it.The course package contains extensive material presented in an engaging format. You will have a lot of fun going through the course on state of the art Kemp Center platform. You will learn and play by using specific examples, spaced repetitions and varied practical exercises. Taking the Photoshop course is a fun, affordable way to learn how to create and edit photos and graphics. Whatever your creative project is, Photoshop can do it. From creating image templates, mood boards or photo collages to designing your own 2D or 3D art, you will be able to do it all!Claude Simmons, Photoshop expert

Money talks—and in this Finance & Investment Course, it actually makes sense. Whether you're someone who reads the financial pages for fun or someone who still confuses stocks with socks, this course is tailored to give you a clearer understanding of how money works, grows, and flows. From basic budgeting and personal finance principles to the strategic side of investing, we break down the world of finance without turning it into a sleep-inducing spreadsheet session. It’s structured for those who want to make sharper financial choices, without needing a maths degree or a tie. The Finance & Investment Course also explores investment strategies, market movements, risk factors, and portfolio planning—minus the waffle. You’ll gain insights into stocks, bonds, funds, and more, in plain English. There’s no need to dress up for class or fight traffic to a lecture hall—everything is online, smartly written, and designed to suit your pace. If you’ve ever wondered where your money goes, or better yet, how to make it go further, this is your chance to learn with confidence and a few light chuckles along the way. Learning Outcomes By the end of the course, learners will be able to: Gain a thorough understanding of the financial industry and financial concepts Know the roles and responsibilities and gain the skills required to become a financial advisor Know how private wealth management is different from wealth management Learn about financial risks, financial risk management and the process of managing financial risks Gain in-depth knowledge on financial planning, its importance and objectives Become familiar with divorce financial planning, how to divide the money and property from splitting divorce costs and settlements Understand the basic principles of investing and how to build an investment portfolio Find out about Google Analytics, its features and uses Key Features of this Course : Instant e-certificate and hard copy dispatch by next working day Fully online, interactive course with audio voiceover Developed by professionals in the field Self-paced learning and laptop, tablet, smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases *** Additional Gifts *** Free Life coaching Course *** (Offer Ends Soon) *** Course Curriculum The detailed curriculum outline of our Finance & Investment course is as follows: ***Finance & Investment*** Module 01: Introduction to Finance Module 02: Essential Skill for Financial Advisor Module 03: Financial Planning Module 04: Wealth Management and Guide to Make Personal Financial Statements Module 05: Financial Risk Management and Assessment Module 06: Investment Planning Module 07: Divorce Planning Module 08: Google Analytics for Financial Advisors Accreditation All of our courses, including this course, are fully accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certification Once you've successfully completed your course, you will immediately be sent a digital certificate. Also, you can have your printed certificate delivered by post (shipping cost £3.99). Our certifications have no expiry dates, although we do recommend that you renew them every 12 months. Assessment At the end of the course, there will be an online assessment, which you will need to pass to complete the course. Answers are marked instantly and automatically, allowing you to know straight away whether you have passed. If you haven't, there's no limit on the number of times you can take the final exam. All this is included in the one-time fee you paid for the course itself. Who is this course for? Anyone with a knack for learning new skills can take this course. While this comprehensive training is popular for preparing people for job opportunities in the relevant fields, it also helps to advance your career for promotions. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the hard copy certificates for Free! The delivery charge of the hard copy certificate inside the UK is £3.99 each.

Explore the ancient art of Acupuncture Therapy in our comprehensive course. Learn about acupressure points, treatment for pain and mental health, professional standards, and much more. Ideal for aspiring practitioners and those seeking holistic health insights.

Overview This The Complete SQL : Bootcamp course will unlock your full potential and will show you how to excel in a career in The Complete SQL : Bootcamp. So upskill now and reach your full potential. Everything you need to get started in The Complete SQL : Bootcamp is available in this course. Learning and progressing are the hallmarks of personal development. This The Complete SQL : Bootcamp will quickly teach you the must-have skills needed to start in the relevant industry. In This The Complete SQL : Bootcamp Course, You Will: Learn strategies to boost your workplace efficiency. Hone your The Complete SQL : Bootcamp skills to help you advance your career. Acquire a comprehensive understanding of various The Complete SQL : Bootcamp topics and tips from industry experts. Learn in-demand The Complete SQL : Bootcamp skills that are in high demand among UK employers, which will help you to kickstart your career. This The Complete SQL : Bootcamp course covers everything you must know to stand against the tough competition in the The Complete SQL : Bootcamp field.  The future is truly yours to seize with this The Complete SQL : Bootcamp. Enrol today and complete the course to achieve a The Complete SQL : Bootcamp certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the The Complete SQL : Bootcamp course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the The Complete SQL : Bootcamp course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the The Complete SQL : Bootcamp course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This The Complete SQL : Bootcamp is suitable for anyone aspiring to start a career in The Complete SQL : Bootcamp; even if you are new to this and have no prior knowledge on The Complete SQL : Bootcamp, this course is going to be very easy for you to understand.  And if you are already working in the The Complete SQL : Bootcamp field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this The Complete SQL : Bootcamp course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This The Complete SQL : Bootcamp course has no prerequisite.  You don't need any educational qualification or experience to enrol in the The Complete SQL : Bootcamp course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online The Complete SQL : Bootcamp course. Moreover, this course allows you to learn at your own pace while developing transferable and marketable skills. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum overview 00:04:00 Overview of Databases 00:08:00 SQL Environment Setup PostgreSQL Installation 00:13:00 Connecting to PostgreSQL using psql 00:04:00 Connecting to PostgreSQL using PgAdmin 00:07:00 Creating Database and Tables 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 SQL Statement Basics 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 GROUP BY Statements 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 JOINS 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 Advanced SQL Commands 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 Databases and Tables Overview of Databases and Tables 00:02:00 Creating a Database backup 00:03:00 Restoring a Database from backup 00:04:00 Mock Exam Mock Exam - The Complete SQL from Scratch: Bootcamp 00:20:00 Final Exam Final Exam - The Complete SQL from Scratch: Bootcamp 00:20:00

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.