44296 Courses

Course Overview: Medication errors significantly cause patient harm, resulting in avoidable complications and even loss of life. Medication errors affect 1 out of every 30 patients in health care. More than a quarter of these errors are viewed as severe or life-threatening. 50% of the preventable damage in health care is related to medications. This reminds us of the significance of medical administration. At Apex Learning, we share the goal of millions of people to make the world better, and we know that, as a company, our actions significantly influence society. Keeping that in mind, we have prepared this Medication Administration Level 4 course very carefully to counter medication errors. From our side, we have given it our best shot; now it is your turn. Enrol now and be a part of our commitment towards society. What Can You Expect From The Course? Understanding the legal and regulatory framework surrounding medication management. Developing a comprehensive knowledge of safe handling and administration of medicines. Conducting sufficient medication risk assessments to ensure patient safety. Learning the procedures for handling, recording, and storing medications accurately. Gaining insights into different drug formulations and administration methods. Key Features of the Course: CPD Certificate: Upon successful completion, you will receive a Continuing Professional Development (CPD) certificate, recognised and valued by employers across the healthcare sector. 24/7 Learning Assistance: Our dedicated team of tutors will be available round-the-clock to support and guide you throughout your learning journey, ensuring your success. Who is This Course For? This Medication Administration Level 4 course is ideal for healthcare professionals, including nurses, care assistants, and support workers, who play a vital role in medication administration. If you are passionate about patient safety and aspire to advance your career in the healthcare sector, this course is tailor-made for you. What You Will Learn: In this comprehensive Medication Administration Level 4 course, you will acquire a deep understanding of safe handling practices and gain essential knowledge to ensure the proper administration of medications. Through the course modules, you will develop the following skills and expertise: First, you will delve into the fundamental principles and practices of safely handling medicines. You will explore the legislation and guidance surrounding medication management, equipping yourself with a solid understanding of the legal and regulatory frameworks that govern medication administration. Additionally, you will learn the principles of safe and appropriate handling of medicines, including best practices for storage, transfer, and disposal. This knowledge will enable you to ensure the integrity and efficacy of medications while minimising the risk of harm. Next, you will focus on the specific challenges and considerations when handling medicines in social care settings. You will gain insights into obtaining consent to treatment and medication administration's ethical implications. You will also learn about the requirements for specific services, such as different levels of care and support needed for individuals receiving medications. Through detailed modules, you will master the step-by-step procedure for handling medication safely and accurately, understanding the six critical rights of medication administration that contribute to patient safety. Furthermore, you will explore covert medication administration and its guidelines and ethical considerations. Why Enrol in This Course: Enhance your healthcare career with our highly recommended Medication Administration Level 4 course. With top ratings from past learners, a regularly updated curriculum, and trending relevance in the healthcare field, this course equips you with essential skills for safe medication administration. Requirements: To enrol in this Medication Administration Level 4 course, you should have a basic understanding of healthcare practices and have access to a reliable internet connection to access the course materials and resources. Career Path: Upon completing this Medication Administration Level 4 course, you will be equipped with the skills to pursue various healthcare roles. Here are seven course-related professions, along with their average annual salaries in the UK: Medication Safety Officer - £35,000 Clinical Nurse Educator - £40,000 Care Quality Manager - £45,000 Pharmacy Technician - £25,000 Residential Care Manager - £30,000 Community Support Worker - £20,000 Care Home Administrator - £22,000 Certification: Upon completing the Medication Administration Level 4 course, you will receive a CPD certificate to validate your newly acquired skills and enhance your professional credentials in the healthcare sector. Enrol today and unlock your potential in medication administration! Gain the knowledge and skills to make a real difference in patient care and take a significant step forward in your healthcare career. Course Curriculum 16 sections • 16 lectures • 06:43:00 total length •Introduction to Safe Handling of Medicines: 00:25:00 •Legislation and Guidance of Medication Management: 00:18:00 •Principles of Safe and Appropriate Handling of Medicines: 00:31:00 •Medication Risk Assessment Guidance: 00:22:00 •Handling Medicines in Social Care Settings: 00:58:00 •Consent to Treatment: 00:29:00 •Requirements for Specific Services: 00:43:00 •Levels of Care and Support: 00:12:00 •Procedure for Handling Medication: 00:17:00 •The Six Rights of Medication Administration: 00:21:00 •Covert Administration of Medication: 00:20:00 •Recording Procedures: 00:20:00 •Storage of Medication: 00:13:00 •Transfer and Disposal of Medication: 00:16:00 •Drug Formulation and Ways of Taking It: 00:58:00 •Assignment - Medication Administration Level 4: 00:00:00

Overview This comprehensive course on English for Job Interview will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This English for Job Interview comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this English for Job Interview. It is available to all students, of all academic backgrounds. Requirements Our English for Job Interview is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 3 sections • 47 lectures • 02:58:00 total length •How to Use this Course?: 00:06:00 •Better Fluency Habits - Best Learning Habits for a Better Performance: 00:09:00 •Strategies to Research Companies for Your Field: 00:13:00 •Starting Your Vocabulary and Pronunciation List: 00:09:00 •Question 1: Tell Me about Yourself: 00:06:00 •Job Interview Audio Samples Question 1: Tell Me about Yourself: 00:01:00 •Question 2: What are Your Key Strength?: 00:04:00 •Job Interview Audio Samples Question 2: What are Your Key Strengths?: 00:01:00 •Question 3: Why Should We Hire You?: 00:03:00 •Job Interview Audio Samples Question 3: Why Should We Hire You?: 00:01:00 •Question 4: What are Your Weaknesses or Weak Points?: 00:03:00 •Job Interview Audio Samples Question 4: What is Your Weak Point?: 00:01:00 •Question 5: Where Do You See Yourself in 5 Years?: 00:04:00 •Job Interview Audio Samples Question 5: Where Do You See Yourself in 5 Years?: 00:01:00 •Question 6: Why Do You Want this Job?: 00:05:00 •Job Interview Audio Samples Question 6: Why Do You Want this Job? ]: 00:01:00 •Question 7: Why Did You (or Why Do You Want to) Leave your Current Employer?: 00:04:00 •Job Interview Audio Samples Question 7: Why Did You (or Why Do You Want to) Leave Your Current Employer?: 00:01:00 •Question 8: When are You Available to Start?: 00:04:00 •Job Interview Audio Samples Question 8: When are You Available to Start?: 00:01:00 •Question 9: How Do You Deal with Pressure or Stress?: 00:04:00 •Job Interview Audio Samples Question 9: How Do You Deal with Pressure or Stress?: 00:01:00 •Question 10: How Did You Hear about the Position?: 00:02:00 •Job Interview Audio Samples Question 10: How Did You hear about the Position?: 00:01:00 •Question 11: What Do You Know about our Company?: 00:03:00 •Job Interview Audio Samples Question 11: What Do You Know about our Company?: 00:01:00 •Question 12: Do You Have Any Questions?: 00:03:00 •Job Interview Audio Samples Question 12: Do You Have Any Questions?: 00:01:00 •Question 13: What are Your Salary Expectations?: 00:04:00 •Job Interview Audio Samples Question 13: What are Your Salary Expectations?: 00:01:00 •Question 14: Describe Yourself in Three Words/ Describe Your Personality: 00:04:00 •Job Interview Audio Samples Question 14 : Describe Yourself in Three Words/ Describe Your Personality: 00:12:00 •Question 15: What Do You Like to Do in Your Free Time?: 00:03:00 •Job Interview Audio Samples Question 15: What Do You Like to Do in Your Free Time?: 00:01:00 •5 Kinds of STAR Question: 00:09:00 •How to Find STAR Interview Stories: 00:04:00 •How to Write Your STAR Answers: 00:05:00 •How to Combine Your Stories with the 5 Categories of Question: 00:03:00 •How to Answer Difficult Interview Questions and the STAR Interview Technique: 00:03:00 •Tell me about a time when you worked successfully as a Member of a Team?: 00:07:00 •Describe a Difficult Situation or Task that you had to Deal with?: 00:07:00 •Tell me about Your Biggest Achievement to Date: 00:06:00 •Tell me about a Time When you worked with a Difficult Team Member: 00:04:00 •Tell me about a Time When you had to make a Difficult Decision: 00:03:00 •STAR Sample Answers Video 1: 00:04:00 •STAR Sample Answers Video 2: 00:04:00 •Assignment - English for Job Interview: 00:00:00

Overview This comprehensive course on Business Analystics for Beginners Using SASS will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Business Analystics for Beginners Using SASS comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast-track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Business Analystics for Beginners Using SASS. It is available to all students, of all academic backgrounds. Requirements Our Business Analystics for Beginners Using SASS is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 13 sections • 73 lectures • 08:10:00 total length •SAS Introduction: 00:07:00 •Introduction to SAS Program: 00:05:00 •Read SAS Dataset: 00:09:00 •Practice Read Dataset: 00:08:00 •Practical Example on Read Dataset: 00:02:00 •Introduction to SAS Dataset: 00:12:00 •SAS Dataset Practical Example: 00:07:00 •SAS Dataset Practical Program: 00:06:00 •DateValue: 00:03:00 •SAS Formats Part 1: 00:13:00 •SAS Formats Part 2: 00:09:00 •Reading Excel Worksheets: 00:05:00 •Reading Excel Worksheet Example: 00:11:00 •Date Format Example: 00:06:00 •Raw Data File Standard Part 1: 00:09:00 •Raw Data File Standard Part 2: 00:08:00 •Raw Data File Standard Example: 00:06:00 •Raw Data File Non Standard: 00:07:00 •Raw Data File Non Standard Example: 00:06:00 •Length Statement: 00:02:00 •Compilation Execution: 00:04:00 •Heading: 00:01:00 •Dataerrors: 00:05:00 •Data Errorsz Example: 00:03:00 •Validate Data Procfreq: 00:05:00 •Validate Data Procpront: 00:07:00 •Validate Data Peocmeans: 00:05:00 •Dat Constant: 00:07:00 •Assignment Statement: 00:09:00 •If Then Statement: 00:09:00 •If Then Do End Statement: 00:09:00 •Diff Where and If Statement: 00:02:00 •Keep Drop: 00:08:00 •Keep Drop Example: 00:04:00 •Append: 00:09:00 •Append Examples part 1: 00:09:00 •Append Examples part 2: 00:07:00 •Concatenate: 00:12:00 •Merge: 00:06:00 •Merge One to One: 00:07:00 •Merge One to Many: 00:04:00 •Merge Non Match: 00:04:00 •Global Statements: 00:09:00 •Global Statements Examples Part 1: 00:08:00 •Global Statements Examples Part 2: 00:06:00 •Title n Foot Note: 00:05:00 •Title n Foot Note Example: 00:08:00 •By Statement: 00:08:00 •Multiple Where Stament: 00:03:00 •ODS: 00:07:00 •ODS Example: 00:04:00 •Sas Date Function: 00:10:00 •Sas Date Function Example: 00:08:00 •Sas Functions Part 1: 00:10:00 •Sas Functions Part 2: 00:08:00 •Sas Functions: 00:07:00 •Sas Functions Example Part 1: 00:07:00 •Sas Functions Example Part 2: 00:09:00 •Multiple SAS Datasets Part 1: 00:05:00 •Multiple SAS Datasets Part 2: 00:02:00 •Multiple SAS Datasets Example: 00:09:00 •Select Group: 00:09:00 •Select Group Example: 00:08:00 •Do Loop Part 1: 00:07:00 •Do Loop Part 2: 00:06:00 •Do Loop Example: 00:07:00 •Array Part 1: 00:05:00 •Array Part 2: 00:08:00 •Array DoLoop: 00:06:00 •ArrayTemp: 00:05:00 •Array Example: 00:10:00 •Sas Statement Part 1: 00:04:00 •Sas Statement Part 2: 00:05:00

Overview This comprehensive course on Solidworks: Beginner to Advanced will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Solidworks: Beginner to Advanced comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Solidworks: Beginner to Advanced. It is available to all students, of all academic backgrounds. Requirements Our Solidworks: Beginner to Advanced is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 14 sections • 94 lectures • 05:14:00 total length •About the course: 00:02:00 •Course concept: 00:01:00 •Creating a New Document: 00:01:00 •User Interface: 00:02:00 •Mouse Movements - Sketch: 00:02:00 •Mouse Movements - Part: 00:03:00 •Creating a Sketch Document: 00:02:00 •Basic Sketch Tools: 00:07:00 •Dimensions and Relations: 00:12:00 •Mirror Entities: 00:02:00 •Linear and Circular Sketch Pattern: 00:06:00 •Units: 00:02:00 •Sketch to Part Conversion: 00:03:00 •Opening/Saving Part Document: 00:01:00 •Extruded Boss Base: 00:03:00 •Extruded Boss Base Additional: 00:04:00 •Extruded Cut: 00:03:00 •Sketch on the Part: 00:02:00 •Sketch on the New Plane: 00:05:00 •Draft: 00:03:00 •Shell: 00:02:00 •Fillet and Chamfer: 00:03:00 •Convert and Offset Entities: 00:02:00 •Lofted Boss: 00:03:00 •Revolved Boss: 00:02:00 •Swept Boss: 00:05:00 •Part and Sketch Modification: 00:02:00 •3D Sketch: 00:03:00 •Density and Material: 00:02:00 •Measuring Tools: 00:03:00 •Linked Dimensions: 00:04:00 •Equations: 00:05:00 •Mirror: 00:03:00 •Hole Wizard: 00:03:00 •Reference Geometry: 00:03:00 •Feature Scope: 00:02:00 •Creating a Design Table: 00:06:00 •Adding Configurations: 00:05:00 •Inserting Part Relative to the Origin: 00:02:00 •Inserting Parts Relative to Planes: 00:02:00 •Standard Mates: 00:04:00 •Move Components: 00:02:00 •Mirror Component: 00:01:00 •Distance and Angle: 00:04:00 •Profile Centre: 00:04:00 •Symmetry and Width: 00:05:00 •Path Mate: 00:05:00 •Linear Coupler: 00:06:00 •Collision Detection: 00:02:00 •Interference Detection: 00:03:00 •Assembly Features: 00:02:00 •Subassembly: 00:03:00 •Creating a Drawing Sheet: 00:01:00 •Orthographic Views and Edit Sheet: 00:04:00 •Projected View and View Properties: 00:02:00 •Smart Dimension and Model Item: 00:05:00 •Saving Options: 00:01:00 •Relative to Model View: 00:03:00 •Section View: 00:04:00 •Auxiliary View: 00:03:00 •Detail View: 00:02:00 •Broken Out Section: 00:02:00 •Break View: 00:02:00 •Alternate Position View: 00:02:00 •View Focus: 00:02:00 •Bill of Materials (BOM): 00:03:00 •Bom Sort: 00:01:00 •Missing Item in Bom: 00:02:00 •Custom Properties: 00:02:00 •Equations in Bom: 00:03:00 •Show/Hide Component: 00:02:00 •Linked Notes: 00:02:00 •Measuring Tool: 00:02:00 •Isometric Section View: 00:01:00 •Applying Materials: 00:08:00 •Appearance: 00:05:00 •Working with Woods: 00:05:00 •Working with Glass: 00:04:00 •Scene: 00:04:00 •Light: 00:07:00 •Camera: 00:04:00 •Decals: 00:07:00 •Text: 00:05:00 •Options: 00:04:00 •Rendering Panel: 00:03:00 •Schedule Rendering: 00:02:00 •Creating Motion Study: 00:02:00 •Animation Wizard: 00:08:00 •Applying Motor: 00:04:00 •Appearance and Camera Position: 00:07:00 •Walkthrough Part-1: 00:09:00 •Walkthrough Part-2: 00:06:00 •Resources - Solidworks: Beginner to Advanced: 00:00:00 •Assignment - Solidworks: Beginner to Advanced: 00:00:00

Overview This comprehensive course on Landscape Photography will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Landscape Photography comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Landscape Photography. It is available to all students, of all academic backgrounds. Requirements Our Landscape Photography is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 11 sections • 79 lectures • 05:13:00 total length •Module 01: Introduction to Nature Photography: 00:02:00 •Module 02: What Is Landscape Photography?: 00:01:00 •Module 01: Overall: 00:01:00 •Module 02: Camera: 00:02:00 •Module 03: Sensors: 00:02:00 •Module 04: Lenses: 00:03:00 •Module 05: Pro vs Budget Lenses: 00:03:00 •Module 06: Prime Lenses: 00:02:00 •Module 07: Tripod: 00:03:00 •Module 08: Filters: 00:02:00 •Module 09: Other Accessories: 00:04:00 •Module 01: Introduction to Camera Basic: 00:01:00 •Module 02: ISO: 00:03:00 •Module 03: ISO Practical: 00:03:00 •Module 04: ISO Practical Night: 00:02:00 •Module 05: Shutter Speed: 00:01:00 •Module 06: Practical of Shutter Speed: 00:03:00 •Module 07: Shutter Speed Waterfall: 00:04:00 •Module 08: Aperture: 00:03:00 •Module 09: Practical Aperture: 00:05:00 •Module 10: Aperture Low Light Photography: 00:03:00 •Module 11: Exposure Triangle: 00:03:00 •Module 12: Aperture Priority: 00:03:00 •Module 01: Introduction to Advanced Camera Basics: 00:02:00 •Module 02: Histogram: 00:03:00 •Module 03: Expose to the Right: 00:02:00 •Module 04: Metering Modes: 00:02:00 •Module 05: Exposure Compensation: 00:02:00 •Module 06: RAW vs JPEG: 00:03:00 •Module 07: What is RAW?: 00:02:00 •Module 08: Dynamic Range: 00:03:00 •Module 09: White Balance: 00:03:00 •Module 01: Introduction to Focusing: 00:01:00 •Module 02: Hyperfocal Distance vs Single Point: 00:03:00 •Module 03: Aperture in Focusing: 00:02:00 •Module 04: Aperture, Focusing & Lens: 00:03:00 •Module 05: Focusing with a Wide-Angle Lens: 00:05:00 •Module 06: Focusing For Telephoto Photography: 00:04:00 •Module 01: What is a Polarizing Filter?: 00:02:00 •Module 02: How a Polarizer Works Near Waterfalls: 00:03:00 •Module 03: How a Polarizer Works Reducing Haze: 00:03:00 •Module 04: What is Nd Filter?: 00:02:00 •Module 05: Nd Filter to Achieve Silky Water: 00:04:00 •Module 06: What is Color Cast?: 00:02:00 •Module 01: Introduction to Exposure: 00:01:00 •Module 02: Dynamic Range & Expose to the Right: 00:04:00 •Module 03: The Impact of Light in Photography: 00:03:00 •Module 04: Finding the Correct Light: 00:04:00 •Module 05: Single Exposure Sunset: 00:04:00 •Module 06: Why Exposure Bracketing Helps You to Take Better Image: 00:05:00 •Module 01: Introduction to Composition: 00:01:00 •Module 02: Element of Composition: 00:03:00 •Module 03: Rules of Third: 00:04:00 •Module 04: Farming a Subject: 00:02:00 •Module 05: Leading Lines: 00:05:00 •Module 06: Diagonals: 00:03:00 •Module 07: Using S and Z curves: 00:05:00 •Module 08: Changing Perspective with Different Focal Ranges: 00:05:00 •Module 09: Changing Perspective through Framing: 00:02:00 •Module 10: Simple Reflection Photography: 00:03:00 •Module 01: Wide-Angle Photography: 00:04:00 •Module 02: Telephoto Photography: 00:06:00 •Module 03: Focus Stacking: 00:12:00 •Module 04: Panoramic: 00:07:00 •Module 05: Creating Scales: 00:03:00 •Module 06: Minimalist Nature Photography: 00:04:00 •Module 07: Creating Leading Lines from Long Exposure: 00:04:00 •Module 01: Introduction to Photo Editing: 00:01:00 •Module 02: Editing in Lightroom: 00:06:00 •Module 03: Global Adjustment: 00:21:00 •Module 04: Local Adjustment: 00:12:00 •Module 05: Histogram (Expose to the Right): 00:07:00 •Module 06: Grab Filter Effect: 00:12:00 •Module 07: Editing an Image like a Professional: 00:17:00 •Module 08: How to Focus Stack: 00:12:00 •Module 09: How to Remove Color Cast: 00:04:00 •Module 10: How to Blend Multiple Image: 00:05:00 •Module 11: How to Stitch a Pano: 00:07:00 •Assignment - Landscape Photography: 00:00:00

Overview This comprehensive course on Django Rest Framework Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Django Rest Framework Level 4 comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Django Rest Framework Level 4. It is available to all students, of all academic backgrounds. Requirements Our Django Rest Framework Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 15 sections • 82 lectures • 04:40:00 total length •Module 01: Course and Instructor Introduction: 00:03:00 •Module 02: How to make the best of this course: 00:02:00 •Module 01: What is REST?: 00:06:00 •Module 02: Why REST: 00:08:00 •Module 03: What and Why DJango REST Framework: 00:06:00 •Module 01: Install DJango: 00:03:00 •Module 02: Install DJango REST Framework: 00:01:00 •Module 03: Install MySql and MySql workbench: 00:03:00 •Module 04: Launch MySql workbench: 00:02:00 •Module 05: Install python mysqlclient: 00:01:00 •Module 06: Install ATOM: 00:03:00 •Module 07: Install Postman: 00:01:00 •Module 01: Create the project: 00:02:00 •Module 02: Create a view: 00:02:00 •Module 03: Configure the URL and TEST: 00:03:00 •Module 04: Create app level urls: 00:02:00 •Module 05: Create a model class: 00:03:00 •Module 06: Configure the database and run migrations: 00:03:00 •Module 07: Use the model in the view and test: 00:03:00 •Module 01: DRF Components: 00:06:00 •Module 02: Function Based Views: 00:05:00 •Module 03: Serializers: 00:04:00 •Module 04: Create the Project: 00:02:00 •Module 05: Create the Model: 00:02:00 •Module 06: Create the Serializer: 00:02:00 •Module 07: GET single student: 00:04:00 •Module 08: Create Student: 00:04:00 •Module 09: Implement Non Primary Key Based Operations: 00:07:00 •Module 10: Use @api_view: 00:01:00 •Module 11: Configure the URLs: 00:02:00 •Module 12: Test: 00:07:00 •Module 13: Test Using Postman: 00:04:00 •Module 01: Introduction: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Implement Non Primary Key Based Operations: 00:06:00 •Module 04: Implement Primary Key Based Operations: 00:07:00 •Module 05: Configure the URLs and TEST: 00:04:00 •Module 01: Introduction: 00:05:00 •Module 02: Non Primary Key based operations: 00:04:00 •Module 03: Primary Key based operations: 00:02:00 •Module 04: Configure the URLs and TEST: 00:02:00 •Module 01: Generics: 00:03:00 •Module 02: Generics in action: 00:03:00 •Module 01: Introduction: 00:03:00 •Module 02: Create ViewSet: 00:02:00 •Module 03: Configure URLs and Test: 00:04:00 •Module 01: Create the Project: 00:03:00 •Module 02: Create model: 00:03:00 •Module 03: Create Serializers: 00:04:00 •Module 04: Create REST endpoints: 00:03:00 •Module 05: Configure URLs: 00:02:00 •Module 06: Test: 00:03:00 •Module 01: Introduction: 00:06:00 •Module 02: Pagination in action: 00:05:00 •Module 03: Pagination at class level: 00:03:00 •Module 04: Using LimitOffsetPagination: 00:01:00 •Module 01: Introduction: 00:04:00 •Module 02: Authentication in action: 00:03:00 •Module 03: Authorization in action: 00:06:00 •Module 04: Global Security: 00:04:00 •Module 01: Usecase: 00:01:00 •Module 02: Create the Project: 00:01:00 •Module 03: Create Model Classes: 00:03:00 •Module 04: Create Reservation Model: 00:01:00 •Module 05: Create Serializers: 00:01:00 •Module 06: Create ViewSets: 00:02:00 •Module 07: Configure the Router: 00:02:00 •Module 08: Run Migrations: 00:01:00 •Module 09: Initial round of testing: 00:04:00 •Module 10: Implement findFlights endpoint: 00:03:00 •Module 11: Test findFlights: 00:05:00 •Module 12: Implement Save Reservation: 00:06:00 •Module 13: Test Save Reservation: 00:04:00 •Module 01: In-Built Validations: 00:04:00 •Module 02: Allowing Blank and Null Values: 00:02:00 •Module 03: Create Custom Validator: 00:05:00 •Module 04: Two more ways: 00:07:00 •Module 01: Introduction: 00:03:00 •Module 02: Configure Token Auth: 00:05:00 •Module 03: Create Users and Token: 00:04:00 •Module 04: Token Auth in action: 00:03:00 •Module 05: Automate Token Creation: 00:09:00

Overview Cloud computing has become the backbone of businesses and organisations across the globe. Our 'Cloud Computing / CompTIA Cloud+ (CV0-002)' course will equip you with the knowledge and skills needed to excel in this burgeoning industry. The demand for cloud computing professionals is soaring, with an estimated 61% of companies already using cloud-based applications. This dynamic field offers lucrative opportunities and a wide salary range, making it a wise career choice.  Cloud computing professionals are in high demand worldwide, and this course empowers you to join their ranks. With a focus on CompTIA Cloud+ (CV0-002), you'll gain a comprehensive understanding of cloud technologies, deployment models, security protocols, and much more.  This course is your ticket to your career in cloud computing. Enrol today! How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Cloud Computing / CompTIA Cloud+ (CV0-002). It is available to all students, of all academic backgrounds. Requirements Our Cloud Computing / CompTIA Cloud+ (CV0-002) is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 11 sections • 100 lectures • 10:39:00 total length •Introduction to the Cloud: 00:04:00 •Cloud+ Exam Info: 00:08:00 •What Can Cloud+ Do For You?: 00:03:00 •Preparing for the Cloud+ Exam: 00:06:00 •Setting up Your Cloud Accounts: 00:06:00 •Defining the Cloud: 00:08:00 •Deployment Models: 00:05:00 •Public Cloud (Demo): 00:08:00 •Private Cloud (Demo): 00:06:00 •Community Cloud (Demo): 00:06:00 •Hybrid Cloud (Demo): 00:05:00 •Additional Models: 00:05:00 •Cloud Architectures: 00:06:00 •Capacity, Elasticity, and Support Agreements: 00:08:00 •Resource Balancing: 00:07:00 •Change Management: 00:07:00 •Deployment Exam Objectives Explained: 00:06:00 •Cloud Component Interactions, Part 1: 00:07:00 •Cloud Component Interaction, Part 2: 00:08:00 •Non-Cloud Component Interactions: 00:09:00 •Platforms and Applications: 00:05:00 •Baselines (Lab): 00:07:00 •Target Hosts: 00:05:00 •Existing Systems (Lab): 00:09:00 •Architecting for Elements and Targets (Demo): 00:07:00 •Selecting Deployment Tools (Demo): 00:07:00 •Executing a Deployment Plan (Demo): 00:09:00 •Evaluating Testing Plans: 00:05:00 •Testing Techniques: 00:05:00 •Analyzing Testing Results: 00:04:00 •Baseline Confirmation (Lab): 00:08:00 •Deployment Problem Resolution (Lab): 00:08:00 •Cloud Storage Types: 00:06:00 •Provisioning Storage: 00:06:00 •Storage Protection Capabilities: 00:09:00 •Storage Features: 00:06:00 •Access Protocols: 00:06:00 •Storage Management (Demo): 00:06:00 •Storage Security (Lab): 00:05:00 •Disaster Recovery Capabilities (Demo): 00:07:00 •Disaster Recovery Considerations: 00:05:00 •Business Continuity Plan (Lab): 00:07:00 •Compute Introduction: 00:06:00 •CPU Capabilities: 00:08:00 •Memory Requirements: 00:07:00 •Performance Considerations: 00:07:00 •Cost Considerations (Lab): 00:07:00 •Energy Savings: 00:05:00 •Dedicated vs. Shared Compute: 00:04:00 •High Availability and Disaster Recovery for Compute: 00:05:00 •Monitoring (Lab): 00:08:00 •Forecasting: 00:05:00 •Policies: 00:03:00 •Network Components (Demo): 00:09:00 •Network Protocols: 00:04:00 •Network Ports (Lab): 00:05:00 •Virtual Private Networks (VPNs): 00:08:00 •IDS/IPS: 00:07:00 •Segmentation: 00:09:00 •Network SLAs and Change Management: 00:04:00 •Networking in Different Models: 00:05:00 •Security Policies: 00:06:00 •Standards and Compliance (Demo): 00:05:00 •Identity, Authentication, and Authorization: 00:08:00 •Multi-Factor Authentication (Lab): 00:05:00 •Authorization (Lab): 00:08:00 •Encryption (Demo): 00:08:00 •Compute Security (Demo): 00:07:00 •Account Management (Lab): 00:07:00 •Segmentation (Lab): 00:05:00 •Security Tools (Demo): 00:07:00 •Security Services: 00:05:00 •Security Automation and Orchestration: 00:06:00 •Models and Security: 00:06:00 •Migration Types: 00:07:00 •Workload Management: 00:05:00 •Virtualizing Physical Systems: 00:06:00 •Migrating Security: 00:07:00 •Protocols and Services: 00:08:00 •Environmental Constraints: 00:07:00 •Planning Patch Management: 00:07:00 •Manual Patch Management: 00:04:00 •Automated Patch Management (Lab): 00:03:00 •Update Types: 00:08:00 •Automated Workflows (Lab): 00:07:00 •Backup Types (Lab): 00:10:00 •Backup Targets and Options: 00:07:00 •Maintenance Automation Techniques: 00:05:00 •Maintenance Automation Tasks: 00:07:00 •Provisioning and Deprovisioning: 00:07:00 •Application Life Cycle: 00:03:00 •Monitoring and Reporting (Lab): 00:07:00 •Monitoring Metrics: 00:06:00 •Troubleshooting Methodology: 00:08:00 •Troubleshooting Deployment: 00:07:00 •Troubleshooting Capacity: 00:08:00 •Troubleshooting Automation and Orchestration: 00:07:00 •Troubleshooting Connectivity: 00:10:00 •Troubleshooting Security: 00:09:00 •Resource - Cloud Computing / CompTIA Cloud+ (CV0-002): 00:00:00

Overview This comprehensive course on Counselling Complete Course will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Counselling Complete Course comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Counselling Complete Course. It is available to all students, of all academic backgrounds. Requirements Our Counselling Complete Course is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 29 sections • 119 lectures • 11:56:00 total length •About the Course & the Instructor: 00:03:00 •Definition of Counselling: 00:04:00 •The Counselling Relationship: 00:06:00 •The Development Cycle: 00:08:00 •Parent, Child, Teacher Relationships: 00:08:00 •The Complexities of Growth: 00:08:00 •Introduction - Psychological Development: 00:09:00 •Conflict and Stress: 00:11:00 •Behavioural Therapies: 00:07:00 •Working with Children: 00:07:00 •The Use of Language: 00:07:00 •Memory: 00:08:00 •Grief and Bereavement: 00:06:00 •Exploring Grief and Letting Go: 00:07:00 •Dysfunctional Families: 00:08:00 •What is Co-Dependency: 00:07:00 •Child Bullying and Child Abuse: 00:08:00 •Psychological Study of Education: 00:06:00 •Transformation: 00:07:00 •Using Newly Found Skills: 00:05:00 •Recovery - The Therapeutic Process: 00:05:00 •Moving on - Emotional Intimacy: 00:06:00 •Setting Up a Practice: 00:10:00 •About_Course: 00:03:00 •About_Tutor: 00:02:00 •Intro Depression: 00:05:00 •Melancholy_History: 00:07:00 •Signs of Depression: 00:07:00 •Brain_Depression: 00:06:00 •Neurons_Depression: 00:09:00 •Stress_Depression: 00:10:00 •Environment_Health: 00:04:00 •Sleep_Disorders: 00:06:00 •Somatic_Sympotoms: 00:06:00 •Risk_factors: 00:07:00 •Module_1_End_Qs: 00:05:00 •Classification_Methods: 00:07:00 •Cyclymia: 00:06:00 •Creativity_Depression: 00:07:00 •Dysthymia_Atypica: 00:07:00 •Bipolar_Manic: 00:06:00 •Antenatal_Postpaturm_D: 00:09:00 •Bereavement_Grief: 00:09:00 •Dysthymia_Children: 00:04:00 •Elderly: 00:06:00 •Psychosocial_Health_Elderly: 00:03:00 •Module_2_Qs: 00:04:00 •Neurogenesis: 00:04:00 •MOI: 00:04:00 •Serotonin_Syndrome: 00:03:00 •SSRIs: 00:03:00 •Tyramine: 00:03:00 •Medical_Stats: 00:10:00 •Module_3_Qs: 00:03:00 •Lifestyle_Diet_DD: 00:07:00 •St John's Wort: 00:05:00 •Omega_3: 00:04:00 •Tai_Chi_Qigong: 00:04:00 •Yoga: 00:04:00 •Acupuncture: 00:03:00 •Art_Music_Therapy: 00:08:00 •Module_4_Qs: 00:04:00 •Person_Centr_Appr: 00:07:00 •Family_Couples_Therapy: 00:09:00 •Step_Care_Approach: 00:10:00 •Psychodynamic_IPT: 00:06:00 •REBT: 00:06:00 •Hypnotherapy: 00:05:00 •Hypnotherapy_PTSD: 00:05:00 •Gestalt_Therapy: 00:06:00 •Therapeutic_Relationship: 00:07:00 •Knowledge_Qualities: 00:03:00 •Module_5_Qs: 00:03:00 •Thanks_GoodBye!: 00:03:00 •Introduction: About instructor & the course: 00:02:00 •The Moral Model: 00:06:00 •The Psychological Model: 00:07:00 •The Psychological Model: 00:09:00 •The Socio-Cultural Model: 00:05:00 •Pharmacotherapy: 00:03:00 •The Minnesota Model: 00:04:00 •Counselling and Therapy: 00:07:00 •Harm Reduction Model: 00:05:00 •Treatments in Practice: 00:05:00 •Drug policies, Legislation and Decriminalisation: 00:09:00 •Community change, Outreach, Harm Reduction or Abstinence: 00:06:00 •Alcohol and Drug education: 00:06:00 •Alcohol- and drug related issues in the workplace: 00:05:00 •Codependency, Children of alcoholic families, parenting styles, family factors: 00:08:00 •Relapse for families, 'letting go', dependent attitudes and dependent behaviours: 00:05:00 •Al-Anon: 00:05:00 •The Intervention Approach: 00:05:00 •Why be a 'helper': 00:03:00 •'Helper' qualities and attitudes: 00:04:00 •Counselling / 'helping' skills: 00:04:00 •About the Instructor & the Course: 00:03:00 •What is counselling: Introduction to Counselling Theory: 00:07:00 •Core Skills in Counselling: 00:07:00 •Counselling Approaches in Counselling: 00:09:00 •What is 'Grief' and 'Bereavement'?: 00:09:00 •The Role of the Bereavement Counsellor: 00:07:00 •Beliefs that people held about 'death' and 'dying': 00:09:00 •A child and adolescent view of death: 00:07:00 •Spirituality and Religion: 00:08:00 •The process of dying: 00:07:00 •Stages of Grief: 00:08:00 •What is 'Complicated grief'?: 00:09:00 •Sadness Vs Depression: 00:06:00 •Grief Vs Depression: 00:05:00 •Types of Depression: 00:09:00 •Diagnosis of Depression: 00:05:00 •Treatments available for depression: 00:08:00 •Grief counselling: The loss of 'self': 00:07:00 •Adjusting to violent death: 00:08:00 •Counselling the dying: 00:07:00 •Acceptance, Surrender, and 'Letting go': 00:05:00 •Ending long-term counselling and follow-up: 00:07:00 •Thank You and Good Bye!: 00:01:00 •Assignment - Counselling Complete Course: 00:00:00

Overview of Safeguarding Children Level 3 Ever dream of a world where every child feels safe? This critical need for protectors is why the Level 3 Safeguarding Children course exists. Statistics show that 8.1% of UK children experience abuse yearly [NSPCC]. This course equips you to be a champion for their well-being. Designed for teachers, social workers, or anyone passionate about child protection, this course empowers you. Delve into the core principles, legal frameworks, and various forms of abuse - physical, emotional, neglect, and sexual exploitation. Recognise the signs and symptoms to identify at-risk children. But safeguarding goes beyond identification. Learn to respond effectively to disclosures. Create a safe space, listen attentively, and avoid judgment. Understanding the reporting process ensures concerns are addressed swiftly. The course tackles complexities by developing your risk assessment skills. Learn to mitigate these risks through interventions and ensure a child's safety. Accurate and confidential record-keeping is crucial, and you'll gain the knowledge to maintain clear investigation records. These skills open doors to rewarding careers. Social workers (£27,000-£42,000) play a vital role [Indeed]. Children's nurses (£25,000-£35,000) care for abused children [NHS Careers]. Police officers (£26,000-£40,000) working with vulnerable people can significantly impact [Police.uk]. For those passionate about youth development, youth workers (£21,000-£30,000) offer mentorship in safe environments [Glassdoor]. Schools play a vital role, too, with Educational Safeguarding Officers (£28,000-£38,000) ensuring student safety [Tes]. This Level 3 course is your first step towards making a positive impact. Enrol today and become a champion for child safety. Imagine the difference you can make. The future of our children depends on it. Get a quick look at the course content: This Safeguarding Children Level 3 Course will help you to learn: Understand the essentials of safeguarding children. Gain insight into key laws and guidance related to safeguarding children. Learn about child abuse and its various forms. Become aware of child sexual exploitation and its implications. Know how to respond to disclosure and the process of reporting. Learn about risk assessment and what steps to take post-referral. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access This course covers everything you must know to stand against the tough competition. The future is truly yours to seize with this Safeguarding Children Level 3. Enrol today and complete the course to achieve a certificate that can change your career forever. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Safeguarding Children Level 3 course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Requirements You don't need any educational qualification or experience to enrol in the Safeguarding Children Level 3 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 course. Career Path Safeguarding Officer - £23K to £32K/year Child Welfare Social Worker - £25K to £37K/year School Counsellor - £21K to £33K/year Community Healthcare Worker - £18K to £28K/year Child Psychologist - £34K to £52K/year Course Curriculum Safeguarding Children Module 01: Introduction to Safeguarding 00:21:00 Module 02: Laws and Guidance 00:43:00 Module 03: Child Abuse 00:49:00 Module 04: Child Sexual Exploitation 00:38:00 Module 05: Responding to Disclosure and Reporting 00:25:00 Module 06: Risks and Risk Assessment 00:16:00 Module 07: Things to Do after Referral 00:24:00 Module 08: Record Keeping 00:18:00 Mock Exam Mock Exam - Safeguarding Children Level 3 00:20:00 Final Exam Final Exam - Safeguarding Children Level 3 00:20:00

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