37852 Sup courses

Overview This comprehensive course on IsiXhosa for Healthcare: The Pharmacist will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This IsiXhosa for Healthcare: The Pharmacist 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 IsiXhosa for Healthcare: The Pharmacist. It is available to all students, of all academic backgrounds. Requirements Our IsiXhosa for Healthcare: The Pharmacist 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 • 28 lectures • 02:07:00 total length •Meeting the patient: 00:06:00 •Meeting the patient - 2: 00:06:00 •Personal Details - 1: 00:05:00 •Personal Details - 2: 00:05:00 •What is troubling you?: 00:05:00 •Pain-related questions and responses: 00:06:00 •Additional health problems: 00:07:00 •Current medication and allergies: 00:06:00 •Suggesting and supplying alternative medication: 00:07:00 •How to apply lotion: 00:02:00 •How to take tablets: 00:02:00 •How and when to take medication: 00:02:00 •The correct quantities to take: 00:01:00 •Where to store medication: 00:01:00 •Precautions when taking medication: 00:03:00 •Possible side-effects or problems: 00:07:00 •How to use an asthma pump: 00:02:00 •How to use a nebuliser: 00:02:00 •How to use a thermometer: 00:03:00 •Parts of the body -1: 00:05:00 •Parts of the body -2: 00:03:00 •Parts of the body -3: 00:04:00 •Parts of the body -4: 00:04:00 •Treating a patient with flu symptoms: 00:08:00 •Treating a patient with constipation: 00:12:00 •Treating a baby with nappy rash: 00:04:00 •Euphemisms: 00:09:00 •Resource: 00:00:00

Overview The demand for skilled cybersecurity professionals is soaring in today's digital landscape. The CompTIA CySA+ Cybersecurity Analyst (CS0-002) course is your gateway to a lucrative and rewarding career in this high-demand industry. This course delves deep into various aspects of cybersecurity, from threat analysis and vulnerability identification to incident response and digital forensics. It's designed to ensure you're ready to excel in the field. This course covers various topics, including threat intelligence, vulnerability identification, incident response, and forensics analysis.  With 60+ hours of engaging content, our expert instructors will equip you with the knowledge and skills required to excel in the CompTIA CySA+ certification exam and kickstart your career in cybersecurity. Enrol in the CompTIA CySA+ Cybersecurity Analyst (CS0-002) course today and secure your future in this high-demand industry! 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 CompTIA CySA+ Cybersecurity Analyst (CS0-002). It is available to all students, of all academic backgrounds. Requirements Our CompTIA CySA+ Cybersecurity Analyst (CS0-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. 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 22 sections • 96 lectures • 11:35:00 total length •Introduction: 00:02:00 •All about the Exam: 00:08:00 •What's New on the CompTIA CySA+ Exam?: 00:05:00 •Meet the Instructors: 00:02:00 •Thinking like the Enemy: 00:09:00 •Tools of the Trade: 00:08:00 •Intelligence Sources and Confidence Levels: 00:08:00 •Threat Indicators and Actors: 00:08:00 •Threat Trends: 00:07:00 •Intelligence Cycle and ISACs: 00:06:00 •Attack Frameworks: 00:06:00 •Threat Research: 00:11:00 •Threat Modeling and Intelligence Sharing: 00:06:00 •Vulnerability Identification: 00:07:00 •Scanning Parameters and Criteria: 00:09:00 •Scanning Special Considerations: 00:06:00 •Validation: 00:03:00 •Remediation and Mitigation: 00:08:00 •Inhibitors to Remediation: 00:07:00 •Web Applications Scanners, Part 1: 00:10:00 •Web Applications Scanners, Part 2: 00:05:00 •Scanning: 00:06:00 •Configuring and Executing Scans: 00:08:00 •Vulnerability Scanning: 00:10:00 •Reverse Engineering: 00:08:00 •Enumeration: 00:06:00 •Wireless Assessment Tools: 00:08:00 •Cloud Assessment Tools: 00:04:00 •Mobile and IoT: 00:10:00 •Embedded and Firmware Systems (RTOS, SoC, and FPGA): 00:09:00 •Access and Vehicles Risk: 00:08:00 •Automation and Control Risk: 00:10:00 •Cloud Models: 00:07:00 •Remote Service Invocation (FaaS, IaC, API): 00:10:00 •Cloud Vulnerabilities: 00:06:00 •Injection and Overflow Attacks: 00:09:00 •Injection and Overflow Attacks: 00:09:00 •Exploits: 00:08:00 •Application Vulnerabilities, Part 1: 00:08:00 •Application Vulnerabilities, Part 2: 00:07:00 •Network Architecture and Asset Management: 00:09:00 •Protecting Your Territory: 00:05:00 •Identity and Access Management: 00:11:00 •Encryption and Active Defense: 00:08:00 •Platforms: 00:07:00 •SOA and DevSecOps: 00:09:00 •Secure Software Development: 00:08:00 •Best Coding Practices: 00:04:00 •Trusted Hardware: 00:10:00 •Hardware Encryption: 00:04:00 •Hardware Security: 00:08:00 •Data Analytics: 00:10:00 •Endpoint Security: 00:08:00 •Recon Results, Part 1: 00:13:00 •Recon Results, Part 2: 00:05:00 •Impact Analysis: 00:05:00 •Collective Tools: 00:09:00 •Query Writing: 00:07:00 •E-mail Analysis, Part 1: 00:10:00 •E-mail Analysis, Part 2: 00:08:00 •Permissions: 00:09:00 •Firewalls: 00:08:00 •Intrusion Prevention Rules: 00:05:00 •DLP and Endpoint Detection: 00:05:00 •Threat Hunting and the Hypothesis: 00:06:00 •Threat Hunting Process: 00:07:00 •Results and Benefits: 00:05:00 •Workflow and Scripting: 00:07:00 •API and Malware Signature Creation: 00:08:00 •Threat Feeds and Machine Learning: 00:06:00 •Protocols, Standards, and Software Engineering: 00:05:00 •IR Roles and Responsibilities: 00:08:00 •IR Active Preparation: 00:10:00 •Incident Response Process: 00:07:00 •Network Symptoms: 00:04:00 •Host Symptoms: 00:08:00 •Application Symptoms: 00:04:00 •Digital Forensics: 00:10:00 •Seizure and Acquisitions: 00:05:00 •Forensics Acquisition Tools: 00:09:00 •Mobile, Virtualization, and Cloud: 00:06:00 •Forensics Analysis, Part 1: 00:04:00 •Forensics Analysis, Part 2: 00:08:00 •Packet Capture: 00:12:00 •Data Privacy and Security: 00:06:00 •Nontechnical Controls: 00:09:00 •Technical Controls: 00:08:00 •Business Impact Analysis: 00:05:00 •Risk Identification: 00:05:00 •Risk Calculation and Communication: 00:06:00 •Training: 00:04:00 •Supply Chain Assessment: 00:04:00 •Frameworks: 00:13:00 •Policies and Procedures: 00:05:00 •Controls and Procedures: 00:08:00 •Verification: 00:06:00

Overview The Diploma in Professional Chef course is specifically designed to prepare students for the demands of this rapidly growing industry. With over 15 hours of content spread across various essential topics, this course provides a comprehensive understanding of the culinary world. It covers various topics such as improving cooking and food preparation skills, catering to unique tastes, and mastering the art of saucier. The Diploma in Professional Chef course delves deep into the intricacies of becoming a successful chef, with modules dedicated to the physical qualities and demands of a chef and the importance of testing recipes.  It also provides insights into the business side of the culinary world, with modules like Food Business Basics and Marketing and Quality Control. The course also offers many recipes and cooking tips, from traditional Italian and Chinese cooking to modern culinary trends. 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 Diploma in Professional Chef. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Professional Chef 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 5 sections • 92 lectures • 14:45:00 total length •Can TV Chefs Teach You To Cook?: 00:30:00 •Improving Cooking And Food Preparation Skills: 00:15:00 •Catering To Unique Tastes: 00:30:00 •Qualities Of A Successful Chef: 00:30:00 •Achieve Perfection As A Saucier: 00:30:00 •Becoming The Perfect Chef: 01:00:00 •Equipment For Perfect Chefs: 00:30:00 •How To Become The Perfect Chef: Attending School: 00:30:00 •The Keys To Getting and Using Feedback: 00:30:00 •What Can You Do With A Culinary Degree: 01:00:00 •Knife Skills For The Perfect Chef: 00:30:00 •Making Meals Easy to Eat Healthy: 00:30:00 •Plating for the At Home Chef: 00:30:00 •Perfect Chefs Choose A Speciality: 00:30:00 •Finding Local Cooking Classes: 00:30:00 •How Can You Become a Professional Chef: 00:30:00 •The Physical Qualities of the Perfect Chef: 00:15:00 •The Importance of Testing Recipes: 00:15:00 •The Chefs Important Baking Tools: 01:00:00 •The Learning Curve To Becoming The Perfect Chef: 00:15:00 •The Job of a Professional Chef: 00:30:00 •The Mix of Sweet, Spicy and Savory: 00:30:00 •The Perfect At Home Chef: 00:30:00 •The Perfect Chef Opens A Restaurant: 00:15:00 •The Physical Demand of Being a Chef: 00:15:00 •Buying Kitchen Equipment: Tips And Tricks To Save Money: 01:00:00 •The Well Equipped Kitchen: 00:15:00 •Take Inventory: 01:00:00 •Be Wary Of The Latest Trends: 01:00:00 •Inexpensive Vs. Cheap: 00:15:00 •Needing Vs. Wanting: 01:00:00 •Comparison Shopping: 01:00:00 •How To Find The Best Deals: 01:00:00 •Secrets Of Outdoor Cooking Recipes: 01:00:00 •Once A Month Cooking Recipes: 00:15:00 •Mother's Day Cooking Made Easy: 01:00:00 •Mardi Gras Cooking Cajun Style: 00:30:00 •Learn To Cook Italian Food On Vacation: 01:00:00 •Cooking With A Dutch Oven: 01:00:00 •Recipes Of Italian Vegetarian Cooking: 01:00:00 •Home Cooking Network: An Array Of Recipes: 00:30:00 •America's Home Cooking: The Television Program: 01:00:00 •A Wonderful Experience With Outdoor Cooking Burners: 00:30:00 •Cooking For Sunday Dinner: 01:00:00 •Healthy Cooking Oils: 01:00:00 •Cooking Cajun Food: 01:00:00 •Paula's Home Cooking Recipes: 00:30:00 •The Importance Of Eating A Healthful Vegetarian Diet: 01:00:00 •Italian Food On A Date: 00:30:00 •The History Of Pasta In Italian Food: 01:00:00 •Review Of Different Vegetarian Cooking Shows: 00:30:00 •Italian Cooking Brochutto: 01:00:00 •Cooking Christmas Cookies: 01:00:00 •Back To Beginning For President's Day Cooking: 00:30:00 •Microwave Bacon Cooking Equipment: 00:30:00 •Cheap Italian Food In Milan: 01:00:00 •Chinese Cooking Wok: 01:00:00 •7 Useful Cooking Tips And Hints: 01:00:00 •Down Home Cooking: 00:30:00 •Italian Cooking School: 00:30:00 •Cooking Games: 00:30:00 •Italian Cooking Recipes: 00:30:00 •French Cooking Holidays: 00:30:00 •Food Business Basics: 01:00:00 •Put Together Your Business Concept: 00:30:00 •Identify your Target Market: 00:30:00 •Identify Your Competition: 00:30:00 •Write A Mission Statement: 00:30:00 •Downline Basics: 00:30:00 •Equipment And Supplies: 00:30:00 •Marketing And Quality Control: 00:30:00 •Wrapping Up: 00:15:00 •Recipe - I: 01:00:00 •Recipe - II: 01:00:00 •Recipe - III: 01:00:00 •Recipe - IV: 01:00:00 •Recipe - V: 01:00:00 •Recipe - VI: 01:00:00 •Recipe - VII: 01:00:00 •Recipe - VIII: 01:00:00 •Recipe - IX: 01:00:00 •Recipe - X: 01:00:00 •Recipe - XI: 00:30:00 •Recipe - XII: 00:30:00 •Recipe - XIII: 00:15:00 •Recipe - XIV: 00:30:00 •Recipe - XV: 00:30:00 •Recipe - XVI: 01:00:00 •Recipe -XVII: 01:00:00 •Recipe -XVIII: 01:00:00 •Recipe -XX: 01:00:00 •Recommended Reading: Diploma in Professional Chef: 00:00:00

Overview This comprehensive course on Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query 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 Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query. It is available to all students, of all academic backgrounds. Requirements Our Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible on tablets and smartphones so you can access your course on wifi, 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 12 sections • 76 lectures • 06:08:00 total length •Course Outline and Introduction: 00:04:00 •Minimum Requirements for the Course: 00:01:00 •Prepayments Introduction: 00:01:00 •Month End Date Prepaid Expenses Amortization Calculation: 00:00:00 •Exact Prepaid Expenses Payment Date Calculation: 00:00:00 •Prepaid Expenses Accounting Definition: Prepayments: 00:03:00 •Prepaid Expense Example: How Accounting works for Prepayments: 00:03:00 •Advantages and Disadvantages of Prepaid Expenses: 00:03:00 •Introduction to PRO Excel Models and Formulas: 00:06:00 •Date Function: 00:05:00 •EOMONTH Function: 00:04:00 •DATEVALUE function: 00:03:00 •IF Function: 00:08:00 •IFS Function (Office 365 Only): 00:07:00 •VLOOKUP Function: 00:07:00 •MATCH Function: 00:05:00 •INDIRECT Function: 00:02:00 •NAMED Ranges: Name Manager: 00:03:00 •Advanced Version of VLOOKUP Function: 00:07:00 •Introduction to Model and Control Panel Tab (Important Sheet Tab): 00:08:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 1): 00:05:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 2): 00:06:00 •Formula Based Prepaid Expenses Model - Deep Dive (Part 3): 00:06:00 •IFS Function - Month End date Prepayment calculation: 00:04:00 •Prepaid Expenses - Closing Balance Summary Tab (Formula Based Summary): 00:09:00 •Protecting Formulas Cells and Fields in the Model: 00:04:00 •Exact Date Prepaid Amortisation calculation Intro: 00:03:00 •Formulas update and Model Changes for Exact Prepaid Exps Calculation: 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 1): 00:04:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 2): 00:03:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 3): 00:02:00 •Formulas Update for Exact Date Prepaid Exps Amortisation (Part 4): 00:07:00 •IFS Function - Exact Date Prepayments Amortisation: 00:04:00 •Data Validation Controls (Enhancing Data Input Controls with Protection): 00:10:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 1): 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (Part 2): 00:09:00 •Additional Material: Resources: 00:00:00 •Power Query and Pivot Table Prepayment Summary Table Intro: 00:06:00 •What is Power Query and Some Awesome Resources for Power Query learning: 00:07:00 •Power Query and Pivot Table Summary - Deep Dive (Part 1): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 2): 00:04:00 •Power Query and Pivot Table Summary - Deep Dive (Part 3): 00:05:00 •Power Query and Pivot Table Summary - Deep Dive (Part 4): 00:09:00 •Using Array Formulas to Add Formula Protection: 00:04:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 1: 00:02:00 •Bonus: Allocate Prepaid Expenditure Cost Centre Wise - 2: 00:08:00 •Bonus: Prepayment Model with Opening Balance Calculation (PQ and PT Version): 00:13:00 •Changing Macros Security in Excel: 00:05:00 •Complete Walkthrough - Advanced VBA Prepaid Expenses Amortisation Model: 00:06:00 •Bonus : New Version - Excel VBA Model for Prepayment Expenditure: 00:08:00 •Dynamic Dashboard Overview: 00:07:00 •Importing Profit and Loss Statements Source Files and creating YTD P&L Sheets: 00:08:00 •Creating Dynamic Data Validation: 00:02:00 •Creating Named Ranges for Dynamic Table Arrays: 00:03:00 •Dynamic Date Column Headings for each Divisional PL Table: 00:02:00 •Dynamic Month and YTD Dashboard tables headings (PRO TIP): 00:03:00 •Dynamic VLOOKUP Formula - Preparing First section of the Dashboard: 00:04:00 •Creating Rolling Dashboard with Dynamic VLOOKUP Function: 00:08:00 •IMPORTANT : Error Checking for your reports/Dashboard (PRO TIP): 00:03:00 •Data Prep for Visualization: AREA Charts (Awesome trick using #NA Function): 00:05:00 •Visualization: AREA Charts for Month - Revenue, Gross Profit and Net Profit: 00:05:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 1): 00:03:00 •Visualization DONUT Charts Revenue, Gross Profit and Net Profit (Part 2): 00:06:00 •Introduction - Formula-less Dashboard - Fully Dynamic and easily refreshed: 00:05:00 •Understanding the data files before building dashboard: 00:02:00 •Consolidating Reports with Power Query (Get & Transform) , How to install PQ: 00:08:00 •Dynamic File Path Trick in Power Query with Parameters (Amazing trick): 00:06:00 •Conditional Cumulative totals with SUMIFS Function: 00:04:00 •Bonus: Conditional Cumulative totals with Power Query Custom Formula (M Code): 00:06:00 •Dashboard Creation - Pivot Table showing Month and YTD KPIs division wise: 00:06:00 •Dashboard Creation Donuts Charts linked with Pivot Table (Replicate Charts fast): 00:08:00 •Dashboard Creation - Line Charts: 00:08:00 •Update Dashboard with Additional Divisional Data with Few Click (Magical): 00:03:00 •Thank you: 00:02:00 •Ultimate Prepaid Expenditure Model (Super Bonus): 00:02:00 •Resources - Microsoft Excel: Automated Dashboard Using Advanced Formula, VBA, Power Query: 00:00:00

Overview This comprehensive course on Healthy Fitness will deepen your understanding on this topic .After successful completion of this course you can acquire the required skills in this sector. This Healthy Fitness 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 Healthy Fitness . It is available to all students, of all academic backgrounds. Requirements Our Healthy Fitness 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 7 sections • 108 lectures • 05:35:00 total length •Day 01 -Leg Blast: 00:10:00 •Day 02 -Upper Body: 00:11:00 •Day 03 -Cardio Blast: 00:10:00 •Day 04 -Dynamic Upper Body: 00:10:00 •Day 05 -Dynamic Lower Body: 00:12:00 •Day 06 -Core: 00:09:00 •Day 07 -Stretching and Isometrics: 00:16:00 •Beginning High Intensity Training: 00:04:00 •HIT Recovery: 00:04:00 •Science of Body building: 00:04:00 •Foundations of HIT: 00:03:00 •Debunking Myths of Lifting: 00:04:00 •The Most Important Thing In Training: 00:04:00 •HIT Workout Day One: 00:04:00 •HIT Workout Day Two: 00:04:00 •HIT Diet: 00:04:00 •Beginning High Intensity Training: 00:04:00 •Foundations Of HIT: 00:03:00 •Debunking Myths Of Lifting: 00:04:00 •Science of Bodybuilding: 00:04:00 •The Most Important Thing In Training: 00:04:00 •HIT Recovery: 00:04:00 •HIT Workout Day One: 00:04:00 •HIT Diet: 00:04:00 •HIT Workout Day Two: 00:04:00 •Not All Strength is Created Equal: 00:06:00 •Body Weight Training: 00:04:00 •Gym Based Training: 00:07:00 •A Simple Workout You Can Do Anywhere: 00:07:00 •Crossfit: is it for you?: 00:05:00 •Stretching: Why It's So Important: 00:07:00 •HIIT and TABATA Explained: 00:05:00 •How to Hire A Personal Trainer: 00:10:00 •Paleo Diet Explained: 00:05:00 •Creating Your Own Training Program: 00:06:00 •Introduction: 00:01:00 •The Importance Of Joint Health: 00:07:00 •A Look At Common Joint Problems: 00:07:00 •Exercise Your Joints: 00:08:00 •Balance Your Diet: 00:08:00 •Watch Your Weight: 00:06:00 •Home Remedies For Easing Joint Pains: 00:07:00 •Best Supplements For Joint Health: 00:10:00 •Other Options To Treat Joint Pains: 00:07:00 •Conclusion: 00:01:00 •Clips Home Fitness Man: 00:02:00 •Workout Aid your Recovery: 00:01:00 •Workout Aim past your goal: 00:01:00 •Workout Air Your Dirty Laundry: 00:01:00 •Workout Avoid Tendinitis: 00:01:00 •Workout Back Flys: 00:01:00 •Workout Back to Comfort: 00:01:00 •Workout Be a Lightweight: 00:01:00 •Workout Be an Early Bird: 00:01:00 •Workout Be an Energizer Bunny: 00:01:00 •Workout Become a Better Runner: 00:01:00 •Workout Bike more Efficiently: 00:01:00 •Workout Bike Uphill Better: 00:01:00 •Workout Biking: 00:01:00 •Workout Break out the Cash: 00:01:00 •Workout Breathe as You Rise: 00:01:00 •Workout Build Your Back: 00:01:00 •Workout Catch Baseballs Better: 00:01:00 •Workout Catch the Spiral: 00:01:00 •Workout Chin-Ups: 00:01:00 •Workout Close Grip Bench: 00:01:00 •Workout Close Grip Lat Pull-Down: 00:01:00 •Workout Count Backwards from 100: 00:01:00 •Workout Create Constructive Sleep Habits: 00:01:00 •Workout Crumple and Crush: 00:01:00 •Workout Crunches: 00:01:00 •Workout Deadlift: 00:01:00 •Workout Dips: 00:01:00 •Workout Diversify for Ultimate Success: 00:01:00 •Workout Do it in Parts: 00:01:00 •Workout Elliptical: 00:01:00 •Workout Exercise Bike: 00:01:00 •Workout Incline Dumbbell Press: 00:01:00 •Workout Incline Reverse Flys: 00:01:00 •Workout Jump Rope: 00:01:00 •Workout Jumping Jacks: 00:01:00 •Workout Knee Push-Ups: 00:01:00 •Workout Leg Curls: 00:01:00 •Workout Leg Extensions: 00:01:00 •Workout Leg Press: 00:01:00 •Workout Leg Raises: 00:01:00 •Workout Lower Back Raises: 00:01:00 •Workout Lunges: 00:01:00 •Workout Military Press: 00:01:00 •Workout Oblique Crunches: 00:01:00 •Workout Oblique Sit-Ups: 00:01:00 •Workout Overhead Triceps Extension: 00:01:00 •Workout Preacher Curl: 00:01:00 •Workout Pull-Ups: 00:01:00 •Workout Push-Ups: 00:01:00 •Workout Runner: 00:01:00 •Workout Running Treadmill: 00:01:00 •Workout Seated Row: 00:01:00 •Workout Shoulder Press: 00:01:00 •Workout Side Dumbbell Raise: 00:01:00 •Workout Single Arm Curl: 00:01:00 •Workout Sit-ups: 00:01:00 •Workout Squats: 00:01:00 •Workout Triceps Kickback: 00:01:00 •Workout Upright Barbell Rows: 00:01:00 •Workout Walking: 00:01:00 •Workout Wide Grip Pull-Down: 00:01:00 •Assignment - Healthy Fitness: 00:00:00

Overview This comprehensive course on Web Design in Affinity Designer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Web Design in Affinity Designer 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 Web Design in Affinity Designer. It is available to all students, of all academic backgrounds. Requirements Our Web Design in Affinity Designer 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 26 sections • 87 lectures • 07:29:00 total length •Introduction to the course: 00:02:00 •What is Affinity Designer and how to set it up for web design?: 00:03:00 •Affinity Designer's web design abilities: 00:09:00 •First 5 principles of good web design: 00:04:00 •The remaining 5 principles of good web design: 00:05:00 •The most important factor to consider before choosing colours: 00:04:00 •Mix colours for the best possible User Experience: 00:05:00 •Choose the 'psychologically right' colours: 00:05:00 •Easy tools for choosing errorproof colour schemes: 00:07:00 •A super short history of web typography: 00:03:00 •Choose the right fonts for body text: 00:05:00 •Choose the right fonts for headings: 00:04:00 •Mix fonts for headings and body text: 00:04:00 •The perfect font for User Interface design: 00:03:00 •Header, branding, navigation and Hero sections.: 00:04:00 •The centre and bottom sections of your website design: 00:04:00 •What are grids and how to use them: 00:03:00 •Design your very own grid: 00:04:00 •1-7 web design trends that rule the web design world: 00:09:00 •Where to find the RIGHT inspiration for your next design: 00:02:00 •Every website design needs scaffolding: 00:03:00 •Building your wireframe in Designer: 00:05:00 •Continue building the library: 00:10:00 •Use the assets to create a wireframe: 00:11:00 •Wireframing online: 00:04:00 •Talk about images and icons: 00:06:00 •Create font styles in Affinity Designer: 00:04:00 •The Design Part Overview: 00:06:00 •Create the Colour Swatches: 00:04:00 •Create the Text Styles: 00:08:00 •Take a Look at the Icons and Images: 00:03:00 •Start with Creating the Logo: 00:03:00 •Build the Menu Links: 00:04:00 •Add the Social Media Icons: 00:07:00 •Start by Adding the Main Image: 00:07:00 •Quickly Resize the Image: 00:03:00 •Make the Image a Bit Darker: 00:03:00 •Add the Main Text: 00:05:00 •Add the Slider Navigation: 00:04:00 •Start Creating the First Featured Section: 00:04:00 •Add the Featured Items: 00:10:00 •Add the Second Featured Item Section: 00:06:00 •Start Creating the Blog Section: 00:08:00 •Replace the Images: 00:03:00 •Start Building the Image Gallery: 00:07:00 •Create the First Column of the Footer: 00:04:00 •Finish the Design and the Whole Footer: 00:04:00 •Discover the Wireframe for the Design: 00:06:00 •Discover the Blog Design: 00:06:00 •Take a Look at Our Assets: 00:06:00 •Create the Logo and Nav: 00:08:00 •Add the Social Media Icons: 00:07:00 •Add the First Images: 00:07:00 •Add the Shading to the Images: 00:08:00 •Add the Navigation Buttons: 00:05:00 •Create a Container the Blog Post: 00:05:00 •Add the First Pieces of Text: 00:04:00 •Add the Remaining Pieces of Text: 00:06:00 •Start Creating the Blog Post Grid: 00:06:00 •Create the First Blog Post Card: 00:05:00 •Add the Remaining Cards: 00:07:00 •Add the Older Post Link: 00:04:00 •Explore the Sidebar Project: 00:03:00 •Create the Search Box: 00:04:00 •Create the About Me Section: 00:07:00 •Create the Text Section of the Sidebar: 00:05:00 •Create the First Container for the Most Popular Posts: 00:04:00 •Create the List of the Most Popular Blog Posts: 00:07:00 •Create the Ads Section: 00:03:00 •Start Creating the Footer: 00:04:00 •Explore Different Footer Concepts: 00:03:00 •Finish Creating the Footer: 00:07:00 •Explore the Single Post Design: 00:03:00 •Create the Featured Image and the Post Container: 00:06:00 •Add the Blog Post Title: 00:06:00 •Add the Paragraphs and Images: 00:10:00 •Add the Social Media Icons: 00:07:00 •Add the pre-Next Post Navigation: 00:08:00 •Add the Related Posts Section: 00:07:00 •Start Creating the Comments Section: 00:05:00 •Create the Texts for the Comments: 00:06:00 •Create the Post Comment Form: 00:09:00 •Delivering the design to the client: 00:04:00 •Delivering the file to the developer: 00:03:00 •Use the Export Persona to Export the Assets in Bulk: 00:02:00 •Thanks for Watching the Course: 00:01:00 •Assignment - Web Design in Affinity Designer: 00:00:00

Course Overview: Embark on an exhilarating journey into modern web designing with our captivating Counselling Course - Modern Web Designing - Level 2. This course presents an invaluable opportunity to explore the latest techniques and trends in web design, providing you with the skills to create visually stunning and user-friendly websites that captivate audiences.The Modern Web Designing - Level 2 course is meticulously designed to equip learners with a profound understanding of contemporary web design. It dives deep into essential components, ranging from the foundational pillars of HTML and CSS to the flexible utilities of Bootstrap, culminating in creating engaging landing pages and professional business sites. Enrol today and unlock your potential in the exciting world of modern web design. Key Features of the Course: CPD Certificate: Upon completing this course, you will receive a Continuing Professional Development (CPD) certificate, adding a valuable credential to your portfolio. 24/7 Learning Assistance: We will be available round the clock to provide comprehensive learning support, ensuring your success throughout the course. Who is This Course For? This course is tailored for individuals passionate about web design and those seeking to enhance their knowledge in this field. Whether you are a freelancer, entrepreneur, or aspiring web designer, this course will give you the essential skills and knowledge to excel in modern web design. What You Will Learn: In this comprehensive Counselling Course - Modern Web Designing - Level 2, you will undergo a transformative journey to become a skilled web designer. Starting with the fundamentals of HTML and CSS, you will learn to create and structure web pages, manipulate text and images, and create hyperlinks for seamless navigation. Building on this foundation, you will delve deeper into CSS, mastering the art of styling web pages with colours, borders, fonts, and backgrounds. You will also gain expertise in positioning, padding, and margin to achieve precise layout control. The course then introduces you to Bootstrap, a widely-used framework that enhances your design process. You will learn to install and utilise Bootstrap, harnessing its grid system to create responsive layouts adaptable to various screen sizes. Furthermore, you will incorporate interactive elements like images and buttons into your web pages using Bootstrap. As the course progresses, you will focus on creating specific types of websites. You will learn to design compelling landing pages that entice visitors and drive action. Techniques for showcasing key information, incorporating eye-catching images, and collecting user data through opt-in forms will be explored. Additionally, you will master the creation of business websites, implementing advanced techniques such as fancy fonts, dynamic carousels, Google Maps integration, and Font Awesome icons. Why Enrol in This Course: Top Reviewed Course: Our Counselling Course - Modern Web Designing - Level 2, has garnered rave reviews from learners worldwide, attesting to its effectiveness in delivering helpful and actionable knowledge. Recently Updated: This course has been meticulously updated to incorporate the latest trends, techniques, and best practices in modern web designing, ensuring you receive the most relevant and up-to-date training. Trending Skill: Web design is a highly sought-after skill in the digital era, with a growing demand for talented designers who can create captivating online experiences. By mastering this skill, you will be a valuable asset in the job market. Requirements: To enrol in this course, you only need a basic understanding of computer operations and access to a computer with an internet connection. No prior experience in web design is required. Career Path: Upon completing this course, you can pursue various rewarding careers in the field of web design, including: Web Designer - Average UK Salary: £30,000 to £45,000 Front-end Developer - Average UK Salary: £25,000 to £50,000 UI/UX Designer - Average UK Salary: £35,000 to £55,000 Freelance Web Designer - Average UK Salary: £200 to £400 Digital Agency Designer - Average UK Salary: £25,000 to £40,000 E-commerce Website Designer - Average UK Salary: £30,000 to £45,000 Graphic Designer - Average UK Salary: £20,000 to £35,000 Certification: Upon completing this course, you will receive a CPD certificate, demonstrating your proficiency in modern web design. This certificate will testify to your skills and enhance your credibility in the field. Don't miss out on this exciting opportunity to master the art of modern web design. Enrol in our Counselling Course - Modern Web Designing - Level 2 today and unlock your potential in the captivating world of web design. Course Curriculum 8 sections • 66 lectures • 08:06:00 total length •1.1 Intro: 00:03:00 •1.2 Install the Tools and Get Started: 00:05:00 •2.1 Intro to HTML: 00:01:00 •2.2 What is HTML: 00:11:00 •2.3 Start a New HTML File & Use Tags: 00:12:00 •2.4 Header Tags: 00:05:00 •2.5 Edit Text: 00:09:00 •2.6 Links: 00:09:00 •2.7 Images: 00:10:00 •2.8 Lists: 00:04:00 •2.9 Challenge 1: 00:16:00 •2.10 HTML Outro: 00:01:00 •3.1 CSS Intro: 00:04:00 •3.2 Add CSS Styles: 00:16:00 •3.3 Classes and IDs: 00:07:00 •3.4 Borders: 00:06:00 •3.5 Sizing: 00:04:00 •3.6 Padding and Margin: 00:07:00 •3.7 Text Styles: 00:04:00 •3.8 DIVs: 00:08:00 •3.9 Postioning: 00:08:00 •3.10 Hover: 00:03:00 •3.11 Easily Center Elements: 00:02:00 •3.12 Fonts: 00:06:00 •3.13 Challenge: 00:23:00 •3.14 CSS Outro: 00:01:00 •4.1 Intro to Bootstrap: 00:02:00 •4.2 Install Bootstrap: 00:10:00 •4.3 Indenting and Containers: 00:07:00 •4.4 The Grid System: 00:16:00 •4.5 Images: 00:07:00 •4.6 Buttons: 00:06:00 •4.7 Challenge 3: 00:11:00 •4.8 Bootstrap Outro: 00:01:00 •5.1 Landing Page Intro: 00:01:00 •5.2 Sketch Your Landing Page: 00:05:00 •5.3 The Top Section: 00:16:00 •5.4 Polish the Top Section: 00:06:00 •5.5 Adding Images: 00:11:00 •5.6 The Main Points Section: 00:14:00 •5.7 Collecting Emails With an Opt-In Form: 00:11:00 •5.8 Challenge 4: 00:03:00 •5.9 Landing Page Outro: 00:02:00 •6.1 Business Site Intro: 00:01:00 •6.2 Sketch Up: 00:03:00 •6.3 Using Fancy Font Logo: 00:07:00 •6.4 Carousel Basics: 00:10:00 •6.5 Carousel Extras: 00:09:00 •6.6 Text on Images: 00:15:00 •6.7 Phone Number Icon: 00:04:00 •6.8 Google Maps: 00:13:00 •6.9 Font Awesome: 00:09:00 •6.10 Challenge 4: 00:08:00 •6.11 Business Site Outro: 00:01:00 •7.1 Intro: 00:01:00 •7.2 Portfolio Sketch: 00:08:00 •7.3 Jumbotron: 00:10:00 •7.4 Nav Bar: 00:24:00 •7.5 Panels: 00:11:00 •7.6 Challenge 5: 00:13:00 •7.7 Portfolio Outre: 00:01:00 •8.1 Hosting: 00:01:00 •8.2 Bluehost: 00:06:00 •8.3 Uploading: 00:05:00 •8.4 Tips: 00:11:00 •8.5 Hosting Outro: 00:01:00

Level 2 Microsoft Office Essentials

Overview This comprehensive course on Train the Trainer will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Train the Trainer 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? After successfully completing the course 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 Train the Trainer. It is available to all students, of all academic backgrounds. Requirements Our Train the Trainer 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 35 sections • 98 lectures • 18:47:00 total length •Introduction to Trainer Bootcamp: 00:13:00 •What Makes a Great Trainer?: 00:18:00 •Make Them Feel Safe Before Class Introduction: 00:05:00 •Make Comfortable Small Talk - Part 1: 00:17:00 •Make Comfortable Small Talk - Part 2: 00:20:00 •Make Comfortable Small Talk - Activity Feedback: 00:09:00 •Make an Impressive First Impression: 00:15:00 •Give Last Minute Reminders - Part 1: 00:19:00 •Give Last Minute Reminders - Part 2: 00:15:00 •Give Your Introduction - Part 1: 00:18:00 •Give Your Introduction - Part 2: 00:20:00 •Give Your Introduction - Part 3: 00:00:00 •Find Out About Them: 00:18:00 •Reveal the Takeaways: 00:13:00 •Set Boundaries and Expectations - Part 1: 00:18:00 •Set Boundaries and Expectations - Part 2: 00:06:00 •Give the Lesson Hook: 00:07:00 •Do an Oral Review - Part 1: 00:17:00 •Do an Oral Review - Part 2: 00:04:00 •Send Them to Break: 00:04:00 •Walk and Talk During Break: 00:11:00 •Bring Them Back From Break: 00:13:00 •Workbook - Train the Trainer - Part 1: 00:00:00 •Introduction: 00:11:00 •Build Pre-Activity Credibility and Rapport: 00:15:00 •Hook the Trainees on the Activity - Part 1: 00:15:00 •Hook the Trainees on the Activity - Part 2: 00:12:00 •Craig Czarnecki - 1-3 Get Buy-In for the Activity: 00:06:00 •Craig Czarnecki - 1-1 Part 1 Activity - Get Buy In for the Activity: 00:11:00 •Craig Czarnecki - 2-1 Find Trainees Who Need Help: 00:10:00 •Craig Czarnecki - 2-2 Find Trainees Who Need Help: 00:19:00 •Craig Czarnecki - 2-3 Activity Find Trainees Who Need Help: 00:18:00 •Craig Czarnecki - 3-1 Activity Tutor Effectively During Activities: 00:17:00 •Craig Czarnecki - 3-2 Tutor Effectively During Activities: 00:11:00 •Craig Czarnecki - 3-3 Tutor Effectively During Activities: 00:20:00 •Craig Czarnecki - 3-4 Activity Tutor Effectively During Activities: 00:19:00 •Craig Czarnecki - 3-5 Activity Tutor Effectively During Activities: 00:09:00 •Craig Czarnecki - 4-1 Manage the Activity Pace: 00:17:00 •Craig Czarnecki - 4-2 Activity Manage the Activity Pace: 00:14:00 •Craig Czarnecki - 5 Activity Prepare to Lead an Activity: 00:18:00 •Craig Czarnecki - Activity Highlight Video: 00:00:00 •Workbook - Training on Facilitating Classroom Activity: 00:00:00 •0.1 Craig Czarnecki - Coach Intro Part 1: 00:19:00 •0.2 Craig Czarnecki - Coach Intro Part 2: 00:07:00 •1.1 Craig Czarnecki - Coach Learn About the Trainer - Recognize the Trainers Strengths: 00:13:00 •1.2 Craig Czarnecki - Coach Learn About the Trainer - Gauge areas for improvement: 00:07:00 •1.3 Craig Czarnecki - Coach Learn About the Trainer - Identify what's Important to the trainer: 00:03:00 •1.4 Craig Czarnecki - Coach Identify the Trainers Style: 00:01:00 •2.1 Craig Czarnecki - Coach Create Initial Value for the Trainer - Create Deliverables for the kickoff meeting: 00:08:00 •2.2 Craig Czarnecki - Coach Create Initial Value for the Trainer - Create a hook for the kickoff meeting: 00:10:00 •2.3 Craig Czarnecki - Coach Create Initial Value for the Trainer - Prepare for the kickoff meeting: 00:07:00 •3.1.1 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 1: 00:10:00 •3.1.2 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 2: 00:14:00 •3.1.3 Craig Czarnecki - Make a Good First Impression - Build a Teammate Relationship Immediately Part 3: 00:16:00 •3.2.1 Craig Czarnecki - Make a Good First Impression - Discuss the Process for Trainer Growth Part 1: 00:12:00 •3.2.2 Craig Czarnecki - Make a Good First Impression - Discuss the Process for Trainer Growth part 2: 00:12:00 •4.1 Craig Czarnecki - Observe the Trainer in the Classroom - Prepare for the Classroom Observation: 00:15:00 •4.2.1 Craig Czarnecki - Observe the Trainer in the Classroom - Master 7 Keys to Effective Note-Taking Part 1: 00:14:00 •4.2.2 Craig Czarnecki - Observe the Trainer in the Classroom - Master 7 Keys to Effective Note-Taking Part 2: 00:14:00 •4.3 Craig Czarnecki - Observe the Trainer in the Classroom - Apply 4 Quick Steps to Classroom Oberserations: 00:09:00 •4.4.1 Craig Czarnecki - Observe trainer activity part 1: 00:19:00 •4.4.2 Craig Czarnecki - Observe trainer activity part 2: 00:18:00 •5.1.1 Craig Czarnecki - Write a Classroom Observation Summary - Identify Strengths and Areas for Improvement Part 1: 00:12:00 •5.1.2 Craig Czarnecki - Write a Classroom Observation Summary - Identify Strengths and Areas for Improvement part 2: 00:13:00 •5.2.1 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 1: 00:19:00 •5.2.2 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 2: 00:17:00 •5.2.3 Craig Czarnecki - Write a Classroom Observation - Record Strengths and Areas for Improvement Part 3: 00:18:00 •5.3 Craig Czarnecki - Write a Classroom Observation - Record the Main Strength of the Trainer: 00:35:00 •Introduction and Welcome: 00:00:00 •Open Well: 00:27:00 •Communicate Effectively: 00:15:00 •Provide In Class Support: 00:17:00 •Workbook - Train the Trainer Coliseum: How to Train Very Large Classes: 00:00:00 •Introduction and Welcome: 00:19:00 •Take Good Care Of Yourself: 00:06:00 •Manage Your Stress: 00:09:00 •Anticipate Unexpected Issues: 00:08:00 •Get Help And Make It Helpful: 00:00:00 •Help Them Get It: 00:14:00 •Manage Large Classes: 00:09:00 •Have Fun Your Way: 00:13:00 •Control Tough Customers: 00:10:00 •Engage Adult Students With Ease: 00:02:00 •Interpret Your Feedback: 00:02:00 •Wrap Up Questions And Answers: 00:04:00 •Introduction and Welcome: 00:06:00 •Hog-Tie the Talk Hogs: 00:20:00 •Give the Experts the Spotlight: 00:12:00 •Simmer Down the Know-it-Alls: 00:11:00 •Placate Resenters - Part 1: 00:11:00 •Placate Resenters - Part 2: 00:14:00 •Handle the Fault-Finders: 00:11:00 •Shut Down the Hecklers: 00:10:00 •Stimulate Stubborn Passivists: 00:06:00 •Engage the Distracted Inefficient: 00:07:00 •Workbook - Train the Trainer Serenity Course: 00:00:00 •Assignment - Train the Trainer: 00:00:00 •Order Your Certificate: 00:00: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