22064 Courses

Take your driving skills to the next level with the Driving Instructor Course. This course is built for aspiring driving instructors who wish to provide quality service to their customers. In this course, you will learn the essentials of driving and understand the strategies to provide effective instructions. The  Driving Instructor Course will teach you the roles and responsibilities of a driving instructor. From this resourceful course, you will understand the essentials of structured driving training. The modules will educate you on the process of ADI exams. In addition, you will learn valuable tips and tricks for driving smoothly. The course will also train you how to drive large vehicles.  Through this Driving Instructor Course, you will understand the strategies to deal with new customers. It will improve your communication skills and help you establish a flourishing career. Enrol today, and fast track your career. Learning Objectives Understand the role and responsibilities of a driving instructor Enrich your knowledge of structured driving training Learn the process of ADI exams Acquire the skills to become an excellent driver Know how to deal with new customers Improve your communication skills Develop the expertise to drive large vehicles Who is this Course for? Whether you are a beginner or an existing practitioner, our CPD accredited Driving Instructor course is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. Entry Requirement This course is available to all learners of all academic backgrounds. A good understanding of the English language, numeracy and ICT are required to attend this course. CPD Certificate from Course Gate At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £4.99 and the hard copy for £9.99. Also, you can order both PDF and hardcopy certificates for £12.99. Career path On successful completion of the Driving Instructor Course, learners can progress to a more advanced program from our course list. Career opportunities in this field include freelancing or working in-house, within a range of professional settings, with the opportunity to earn a high salary. Related professions in this industry include: Driving Instructor Truck Driving Instructor Driver Course Curriculum Module 01: The Driving Instructor The Driving Instructor 00:20:00 Module 02: Structured Driver Training Structured Driver Training 00:29:00 Module 03: The ADI Exams The ADI Exams 00:37:00 Module 04: Communication Skills and Dealing with a New Client Communication Skills and Dealing with a New Client 00:26:00 Module 05: Learning to Drive Learning to Drive 00:35:00 Module 06: Driving Large Vehicles Driving Large Vehicles 00:35:00 Module 07: Assessment Items Assessment Items 00:28:00 Module 08: Disabilities and Impairments Disabilities and Impairments 00:34:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Overview This comprehensive course on General Inorganic Chemistry will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This General Inorganic Chemistry 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 General Inorganic Chemistry. It is available to all students, of all academic backgrounds. Requirements Our General Inorganic Chemistry 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 22 sections • 151 lectures • 14:47:00 total length •Learning objectives: 00:10:00 •Example of a solved problem: 00:06:00 •System of measurement: 00:02:00 •International system of units: 00:05:00 •Temperature units and scales: 00:04:00 •Use and misuse of units: 00:03:00 •Dimensional analysis: 00:03:00 •Quantities and units: Solved problems: 00:10:00 •Atoms: 00:02:00 •Nuclei: 00:04:00 •Periodic table: 00:08:00 •Relative atomic masses: 00:04:00 •Moles: 00:05:00 •Symbols, formulas and molar masses: 00:04:00 •Atomic, molecular and molar masses - Problems with solutions: 00:16:00 •Empirical formula from composition: 00:04:00 •Composition from formula: 00:04:00 •Nuclidic molecular masses and chemical formulas: 00:05:00 •Formulas and compositions: Solved problems: 00:24:00 •Introduction to nomenclature: 00:03:00 •Naming binary compounds of nonmetals: 00:05:00 •Naming ionic compounds: 00:01:00 •Naming monoatomic cations: 00:06:00 •Naming polyatomic cations: 00:03:00 •Naming monoatomic anions: 00:02:00 •Naming oxyanions: 00:05:00 •Naming special anions: 00:01:00 •Putting the names of the ions together: 00:02:00 •Writing formulas for ionic compounds: 00:08:00 •Naming inorganic acids: 00:06:00 •Naming acid salts: 00:04:00 •Naming hydrates: 00:01:00 •Introduction to chemical equations: 00:02:00 •Molecular relations from equations: 00:05:00 •Mass relations from equations: 00:06:00 •Limiting reactant: 00:01:00 •Calculations from chemical equations: Solved problems: 00:24:00 •Types of chemical reactions: 00:04:00 •Pressure: 00:07:00 •Gas laws: 00:02:00 •Boyle's law: Constant temperature: 00:01:00 •Charles' law: Constant pressure: 00:01:00 •Gay-Lussac's law: Constant volume: 00:01:00 •Combined gas law: 00:01:00 •Density of an ideal gas: 00:03:00 •Dalton's law for partial pressures: 00:01:00 •Collecting a gas over a liquid: 00:02:00 •Deviation from ideal beahvior: 00:01:00 •Measurement of gases: Solved problems: 00:13:00 •Avogadro's hypothesis: 00:03:00 •Molar volume: 00:01:00 •Ideal gas law: 00:05:00 •Gas volume relations from equations: 00:04:00 •Gas stoichiometry involving mass: 00:05:00 •The ideal gas law: Solved problems: 00:13:00 •Heat: 00:04:00 •Energy and enthalpy: 00:05:00 •Enthalpy changes for various processes: 00:12:00 •Rules of thermochemistry: 00:09:00 •Thermochemistry - Problems with solutions: 00:21:00 •Characters of light: 00:05:00 •Interaction of light with matter: 00:08:00 •Particles and waves: 00:03:00 •Orbitals: 00:17:00 •The Pauli exclusion principle: 00:01:00 •Aufbau principle: 00:03:00 •Electron configuration: 00:11:00 •Atomic radii: 00:04:00 •Ionization energies: 00:03:00 •Electron affinity and magnetic properties: 00:05:00 •Atomic structure - Problems with solutions: 00:16:00 •Introduction to chemical bonding: 00:02:00 •Octet rule: 00:03:00 •Ionic bonding: 00:09:00 •Electron dot notation: 00:05:00 •Covalent bonding: 00:17:00 •Distinction between ionic and covalent bonding: 00:03:00 •Predicting the nature of bonding in compounds: 00:05:00 •Formal charges: 00:08:00 •Dipole moment and electronegativity: 00:04:00 •Hybrid orbitals: 00:10:00 •Crystals: 00:08:00 •Close packing: 00:04:00 •Crystal forces: 00:06:00 •Liquid forces: 00:03:00 •Solids and liquids: Solved problems: 00:22:00 •Introduction to redox reactions: 00:04:00 •Oxidation number: 00:09:00 •Oxidizing and reducing agents: 00:05:00 •Ionic notation for equations: 00:04:00 •Balancing oxidation-reduction equations: 00:11:00 •Oxidation-reduction: Solved problems: 00:14:00 •Composition of solutions: 00:01:00 •Concentrations: 00:02:00 •Molarity: 00:02:00 •Normality: 00:05:00 •Molality: 00:01:00 •Mole fraction: 00:01:00 •Comparison and summary of the concentration units: 00:04:00 •Dilution problems: 00:01:00 •Concentration of solutions: Solved problems: 00:14:00 •Reactions involving standard solutions: 00:04:00 •Reaction involving standard solutions: Solved problems: 00:13:00 •Introduction to chemical solutions: 00:02:00 •Vapor pressure lowering: 00:04:00 •Freezing point lowering: 00:05:00 •Boiling point lowering: 00:03:00 •Osmotic pressure: 00:03:00 •Solution of gases in liquids: 00:02:00 •Law of distribution: 00:01:00 •Properties of solutions: Solved problems: 00:13:00 •The first law: 00:02:00 •The second law: 00:06:00 •Entropy: 00:04:00 •The third law: 00:01:00 •Standard states: 00:06:00 •Chemical equilibrium: 00:03:00 •The equilibrium constant: 00:10:00 •Le Chatelier's principle: 00:14:00 •Thermodynamics - Problems with solutions: 00:18:00 •Arrhenius concept: 00:03:00 •Brönsted-Lowry concept: 00:08:00 •Lewis concept: 00:02:00 •Ionization of water: 00:07:00 •Hydrolysis: 00:06:00 •Buffer solutions: 00:06:00 •Indicators: 00:03:00 •Polytropic acids: 00:05:00 •Titration: 00:08:00 •Acids and bases - Problems with solutions: 00:21:00 •Coordination complexes: 00:08:00 •Solubility product: 00:02:00 •Precipitation: 00:05:00 •Complex ions and precipitates: Solved problems: 00:06:00 •Electrical units: 00:03:00 •Faraday's laws: 00:04:00 •Voltaic cells: 00:06:00 •Standard half-cell potential: 00:07:00 •Combining couples: 00:04:00 •Free energy and Nernst equation: 00:08:00 •Electrolysis: 00:06:00 •Electrochemistry: Solved problems: 00:16:00 •Introduction to rates of reactions: 00:01:00 •Rate constants and order of reactions: 00:11:00 •First order reactions: 00:02:00 •Other rate laws: 00:01:00 •Energy of activation: 00:01:00 •Mechanism of reaction: Molecularity: 00:05:00 •Mechanism of reaction: Energetics: 00:05:00 •Rates of reactions: Solved problems: 00:13:00 •Assignment -General Inorganic Chemistry: 00:00:00

Overview This comprehensive course on Data Visualization and Reporting with Power BI will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Data Visualization and Reporting with Power BI 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 Data Visualization and Reporting with Power BI. It is available to all students, of all academic backgrounds. Requirements Our Data Visualization and Reporting with Power BI 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 15 sections • 140 lectures • 14:25:00 total length •Welcome!: 00:01:00 •What is Power BI?: 00:03:00 •Download & Installing Power BI Desktop: 00:04:00 •Getting to know the interface: 00:03:00 •Mini Project: Transform Data: 00:07:00 •Mini Project: Visualize Data: 00:05:00 •Mini Project: Creating a Data Model: 00:07:00 •Course Outline: What will you learn in this course?: 00:05:00 •How to learn best with this course?: 00:03:00 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •Exploring the Query Editor: 00:06:00 •Connecting to our data source: 00:07:00 •Editing rows: 00:08:00 •Changing data types: 00:08:00 •Replacing values: 00:03:00 •Close & Apply: 00:03:00 •Connecting to a csv file: 00:03:00 •Connecting to a web page: 00:05:00 •Extracting characters: 00:06:00 •Splitting & merging columns: 00:09:00 •Creating conditional columns: 00:06:00 •Creating columns from examples: 00:09:00 •Merging Queries: 00:17:00 •Pivoting & Unpivoting: 00:06:00 •Appending Queries: 00:08:00 •Practice & Solution: Population table: 00:15:00 •The Fact-Dimension-Model: 00:09:00 •Practice: Load the dimension table: 00:04:00 •Organizing our queries in groups: 00:03:00 •Entering data manually: 00:05:00 •Creating an index column: 00:03:00 •Workflow & more transformations: 00:05:00 •Module summary: 00:05:00 •Exercise 1 - Instruction: 00:02:00 •Exercise 1 - Exercise Solution: 00:11:00 •Advanced Editor - Best practices: 00:09:00 •Performance: References vs. Duplicating: 00:10:00 •Performance: Enable / Disable Load & Report Refresh: 00:05:00 •Group by: 00:05:00 •Mathematical Operations: 00:05:00 •Run R Script: 00:15:00 •Using Parameters to dynamically transform data: 00:06:00 •M formula language: Basics: 00:07:00 •M formula language: Values, Lists & Tables: 00:14:00 •M formula language: Functions: 00:13:00 •M formula language: More functions & steps: 00:05:00 •Exercise 2 - Instructions: 00:01:00 •Exercise 2 - solution: 00:05:00 •Understanding the relationship: 00:05:00 •Create & edit relationships: 00:06:00 •One-to-many & one-to-one relationship: 00:06:00 •Many-to-many (m:n) relationship: 00:08:00 •Cross filter direction: 00:06:00 •Activate & deactivate relationships: 00:06:00 •Model summary: 00:03:00 •Exercise 3 Create Model: 00:02:00 •Exercise 3 Solution: 00:02:00 •Our first visual: 00:08:00 •The format tab: 00:12:00 •Understanding tables: 00:10:00 •Conditional formatting: 00:09:00 •The Pie Chart: 00:06:00 •All about the filter visual: 00:13:00 •The filter pane for developers: 00:09:00 •Cross filtering & edit interactions: 00:04:00 •Syncing slicers across pages: 00:07:00 •Creating drill downs: 00:08:00 •Creating drill throughs: 00:07:00 •The tree map visual: 00:07:00 •The decomposition tree: 00:05:00 •Understanding the matrix visual: 00:05:00 •Editing pages: 00:07:00 •Buttons & Actions: 00:09:00 •Bookmarks to customize your report: 00:10:00 •Analytics and Forecasts with line charts: 00:10:00 •Working with custom visuals: 00:07:00 •Get data using R Script & R Script visual: 00:08:00 •Asking questions - Q&A visual: 00:04:00 •Wrap up - data visualization: 00:08:00 •Python in Power BI - Plan of attack: 00:03:00 •Setting up Python for Power BI: 00:03:00 •Transforming data using Python: 00:11:00 •Creating visualizations using Python: 00:08:00 •Violin plots, pair plots & ridge plots using Python: 00:15:00 •Machine learning (BayesTextAnalyzer) using Python: 00:00:00 •Performance & Troubleshooting: 00:03:00 •Introduction: 00:01:00 •Show Empathy & Identify the Requirement: 00:03:00 •Finding the Most Suitable KPI's: 00:02:00 •Choose an Effective Visualization: 00:04:00 •Make Use of Natural Reading Pattern: 00:03:00 •Tell a Story Using Visual Cues: 00:05:00 •Avoid Chaos & Group Information: 00:02:00 •Warp Up - Storytelling with Data: 00:02:00 •Introduction: 00:03:00 •The project data: 00:04:00 •Measures vs. Calculated Columns: 00:15:00 •Automatically creating a date table in DAX: 00:08:00 •CALENDAR: 00:05:00 •Creating a complete date table with features: 00:04:00 •Creating key measure table: 00:03:00 •Aggregation functions: 00:06:00 •The different versions of COUNT: 00:14:00 •SUMX - Row based calculations: 00:09:00 •CALCULATE - The basics: 00:11:00 •Changing the context with FILTER: 00:07:00 •ALL: 00:08:00 •ALL SELECTED: 00:03:00 •ALL EXCEPT: 00:07:00 •How to go on now?: 00:03:00 •Power BI Pro vs Premium & Signing up: 00:04:00 •Exploring the interface: 00:04:00 •Discovering your workspace: 00:03:00 •Connecting Power BI Desktop & Cloud: 00:04:00 •Understanding datasets & reports: 00:03:00 •Working on reports: 00:04:00 •Updating reports from Power BI Desktop: 00:04:00 •Creating and working with workspaces: 00:07:00 •Installing & using a data gateway: 00:13:00 •Get Quick Insights: 00:03:00 •Creating dashboards: 00:04:00 •Sharing our results through Apps: 00:10:00 •Power BI Mobile App: 00:05:00 •Creating the layout for the Mobile App: 00:04:00 •Wrap up - Power BI Cloud: 00:07:00 •Introduction: 00:03:00 •Creating a Row-Level Security: 00:05:00 •Row-Level Security in the Cloud: 00:04:00 •Row-Level Security & Data Model: 00:05:00 •Dynamic Row-Level Security: 00:07:00 •Dynamic Many-to-Many RLS: 00:04:00 •Hierarchical Row-Level Security: 00:13:00 •JSON & REST API: 00:10:00 •Setting up a local MySQL database: 00:14:00 •Connecting to a MySQL database in Power BI: 00:05:00 •Connecting to a SQL database (PostgreSQL): 00:05:00 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Data Visualization and Reporting with Power BI: 00:00:00

Overview This comprehensive course on Complete Microsoft Power BI 2021 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Complete Microsoft Power BI 2021 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 Complete Microsoft Power BI 2021. It is available to all students, of all academic backgrounds. Requirements Our Complete Microsoft Power BI 2021 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 15 sections • 140 lectures • 14:25:00 total length •Welcome!: 00:01:00 •What is Power BI?: 00:03:00 •Download & Installing Power BI Desktop: 00:04:00 •Getting to know the interface: 00:03:00 •Mini Project: Transform Data: 00:07:00 •Mini Project: Visualize Data: 00:05:00 •Mini Project: Creating a Data Model: 00:07:00 •Course Outline: What will you learn in this course?: 00:05:00 •How to learn best with this course?: 00:03:00 •Creating our initial project file: 00:04:00 •Working with the attached project files: 00:04:00 •Exploring the Query Editor: 00:06:00 •Connecting to our data source: 00:07:00 •Editing rows: 00:08:00 •Changing data types: 00:08:00 •Replacing values: 00:03:00 •Close & Apply: 00:03:00 •Connecting to a csv file: 00:03:00 •Connecting to a web page: 00:05:00 •Extracting characters: 00:06:00 •Splitting & merging columns: 00:09:00 •Creating conditional columns: 00:06:00 •Creating columns from examples: 00:09:00 •Merging Queries: 00:17:00 •Pivoting & Unpivoting: 00:06:00 •Appending Queries: 00:08:00 •Practice & Solution: Population table: 00:15:00 •The Fact-Dimension-Model: 00:09:00 •Practice: Load the dimension table: 00:04:00 •Organizing our queries in groups: 00:03:00 •Entering data manually: 00:05:00 •Creating an index column: 00:03:00 •Workflow & more transformations: 00:05:00 •Module summary: 00:05:00 •Exercise 1 - Instruction: 00:02:00 •Exercise 1 - Exercise Solution: 00:11:00 •Advanced Editor - Best practices: 00:09:00 •Performance: References vs. Duplicating: 00:10:00 •Performance: Enable / Disable Load & Report Refresh: 00:05:00 •Group by: 00:05:00 •Mathematical Operations: 00:05:00 •Run R Script: 00:15:00 •Using Parameters to dynamically transform data: 00:06:00 •M formula language: Basics: 00:07:00 •M formula language: Values, Lists & Tables: 00:14:00 •M formula language: Functions: 00:13:00 •M formula language: More functions & steps: 00:05:00 •Exercise 2 - Instructions: 00:01:00 •Exercise 2 - solution: 00:05:00 •Understanding the relationship: 00:05:00 •Create & edit relationships: 00:06:00 •One-to-many & one-to-one relationship: 00:06:00 •Many-to-many (m:n) relationship: 00:08:00 •Cross filter direction: 00:06:00 •Activate & deactivate relationships: 00:06:00 •Model summary: 00:03:00 •Exercise 3 Create Model: 00:02:00 •Exercise 3 Solution: 00:02:00 •Our first visual: 00:08:00 •The format tab: 00:12:00 •Understanding tables: 00:10:00 •Conditional formatting: 00:09:00 •The Pie Chart: 00:06:00 •All about the filter visual: 00:13:00 •The filter pane for developers: 00:09:00 •Cross filtering & edit interactions: 00:04:00 •Syncing slicers across pages: 00:07:00 •Creating drill downs: 00:08:00 •Creating drill throughs: 00:07:00 •The tree map visual: 00:07:00 •The decomposition tree: 00:05:00 •Understanding the matrix visual: 00:05:00 •Editing pages: 00:07:00 •Buttons & Actions: 00:09:00 •Bookmarks to customize your report: 00:10:00 •Analytics and Forecasts with line charts: 00:10:00 •Working with custom visuals: 00:07:00 •Get data using R Script & R Script visual: 00:08:00 •Asking questions - Q&A visual: 00:04:00 •Wrap up - data visualization: 00:08:00 •Python in Power BI - Plan of attack: 00:03:00 •Setting up Python for Power BI: 00:03:00 •Transforming data using Python: 00:11:00 •Creating visualizations using Python: 00:08:00 •Violin plots, pair plots & ridge plots using Python: 00:15:00 •Machine learning (BayesTextAnalyzer) using Python: 00:00:00 •Performance & Troubleshooting: 00:03:00 •Introduction: 00:01:00 •Show Empathy & Identify the Requirement: 00:03:00 •Finding the Most Suitable KPI's: 00:02:00 •Choose an Effective Visualization: 00:04:00 •Make Use of Natural Reading Pattern: 00:03:00 •Tell a Story Using Visual Cues: 00:05:00 •Avoid Chaos & Group Information: 00:02:00 •Warp Up - Storytelling with Data: 00:02:00 •Introduction: 00:03:00 •The project data: 00:04:00 •Measures vs. Calculated Columns: 00:15:00 •Automatically creating a date table in DAX: 00:08:00 •CALENDAR: 00:05:00 •Creating a complete date table with features: 00:04:00 •Creating key measure table: 00:03:00 •Aggregation functions: 00:06:00 •The different versions of COUNT: 00:14:00 •SUMX - Row based calculations: 00:09:00 •CALCULATE - The basics: 00:11:00 •Changing the context with FILTER: 00:07:00 •ALL: 00:08:00 •ALL SELECTED: 00:03:00 •ALL EXCEPT: 00:07:00 •How to go on now?: 00:03:00 •Power BI Pro vs Premium & Signing up: 00:04:00 •Exploring the interface: 00:04:00 •Discovering your workspace: 00:03:00 •Connecting Power BI Desktop & Cloud: 00:04:00 •Understanding datasets & reports: 00:03:00 •Working on reports: 00:04:00 •Updating reports from Power BI Desktop: 00:04:00 •Creating and working with workspaces: 00:07:00 •Installing & using a data gateway: 00:13:00 •Get Quick Insights: 00:03:00 •Creating dashboards: 00:04:00 •Sharing our results through Apps: 00:10:00 •Power BI Mobile App: 00:05:00 •Creating the layout for the Mobile App: 00:04:00 •Wrap up - Power BI Cloud: 00:07:00 •Introduction: 00:03:00 •Creating a Row-Level Security: 00:05:00 •Row-Level Security in the Cloud: 00:04:00 •Row-Level Security & Data Model: 00:05:00 •Dynamic Row-Level Security: 00:07:00 •Dynamic Many-to-Many RLS: 00:04:00 •Hierarchical Row-Level Security: 00:13:00 •JSON & REST API: 00:10:00 •Setting up a local MySQL database: 00:14:00 •Connecting to a MySQL database in Power BI: 00:05:00 •Connecting to a SQL database (PostgreSQL): 00:05:00 •Congratulations & next steps: 00:06:00 •The End: 00:01:00 •Resources - Complete Microsoft Power BI 2021: 00:00:00

The Introduction To Ethical Hacking Mini Bundle is designed for curious minds who’d rather learn how systems break than sit through another vague tutorial about “cyber”. With modules on Cyber Security, GDPR, IT, Website Development, and Network Engineering, this bundle brings structure to the world of security—with zero cloak-and-dagger nonsense. Whether you're intrigued by how websites are built or how hackers slip through network gaps, this is a focused way to understand the building blocks. It’s straightforward, self-paced, and built for people who like clarity over chaos. The Introduction To Ethical Hacking Mini Bundle offers digital insights—minus the Hollywood soundtrack. Learning Outcomes: Understand key cyber threats and security methods across systems. Learn how GDPR relates to digital and online environments. Explore basic IT functions and digital system components. Gain insight into simple website structure and coding. Examine network design and fundamental communication protocols. Improve digital awareness for safe and smart browsing. Who is this Course For: Beginners interested in ethical hacking and system security. Students learning about data privacy and online systems. Tech-savvy individuals wanting basic network knowledge. Office workers handling digital and GDPR-sensitive material. Web enthusiasts curious about how websites are structured. Entry-level support staff in digital or IT departments. People exploring cyber safety as a new topic. Anyone who suspects “password123” isn’t a solid choice. Career Path: Cyber Security Assistant – £27,500/year IT Helpdesk Analyst – £26,000/year Junior Network Technician – £28,000/year Data Privacy Assistant – £25,500/year Website Administrator – £29,000/year Security Operations Support – £30,000/year

This isn’t your average timeline of dates and dusty maps. The Military & War History Mini Bundle takes a cross-cultural journey through English, Welsh, and Scottish military events—with anthropology and data entry tagging along to keep things orderly and insightful. You’ll explore how conflict shaped identity, decision-making, and societal shifts across centuries. From the Highland clans to trench-bound soldiers, this course sheds light on the people behind the uniforms—and the records behind the scenes. If you enjoy your history with a bit of structure and a side of strategy, this one hits the mark. 🟪 Learning Outcomes: Understand military developments across English, Welsh, and Scottish history. Explore anthropological themes within historical military contexts. Identify key events and their cultural implications over time. Learn data entry basics for historical and archival organisation. Examine societal change driven by military conflict and alliances. Develop historical insight across national and regional perspectives. 🟪 Who Is This Course For: History fans curious about British military and war legacies. Learners interested in the anthropology of military societies. Academic support staff handling history-based content systems. Heritage centre volunteers or aspiring history guides. Individuals exploring Celtic and Anglo history in depth. Writers or researchers working on conflict-related content. Data entry workers supporting academic and archival projects. Anyone interested in the human side of military history. 🟪 Career Path (UK Average Salaries): Historical Researcher – £29,000/year Data Entry Administrator (Heritage Sector) – £24,000/year Military Historian (Freelance/Academic) – £30,000/year Archive Assistant – £25,000/year Cultural Heritage Officer – £31,000/year Editorial Assistant (History Publications) – £27,000/year

The Agriculture Diplomas Mini Bundle delivers focused, online learning for anyone interested in the natural flow between cultivation and conservation. This set of diplomas connects the dots between greenhouse methods, gardening basics, and modern approaches to gas saving—all while keeping the mud firmly on the screen, not your boots. You’ll learn how the principles of horticulture can sit alongside environmentally sound choices in farming, gardening, and greenhouse usage. The courses are structured for accessible learning and presented in a digestible format, letting you grow your knowledge in between watering your plants—or your tea. 🔹 Learning Outcomes: Understand core horticulture principles and plant care techniques Learn gardening essentials for sustainable outdoor or indoor spaces Explore greenhouse systems and their environmental implications Study gas-saving approaches for agriculture and home settings Examine the role of environment management in growing industries Identify sustainable techniques used in today’s agricultural systems 🔹 Who is this Course For: Gardeners who want structured knowledge behind their skills Professionals in greenhouse operations needing environmental insight Anyone aiming to reduce energy use in growing spaces Entry-level staff in eco-agriculture organisations or charities Those interested in eco-friendly agricultural strategies People planning greenhouses or working in landscaping roles Career changers exploring online agriculture diploma options Students curious about nature, farming, or food production sectors 🔹 Career Path: Horticultural Technician – £21,000–£27,000 per year Sustainability Coordinator – £29,000–£38,000 per year Greenhouse Operations Assistant – £22,000–£30,000 per year Gardening Specialist – £20,000–£26,000 per year Environment Support Officer – £25,000–£34,000 per year Energy Efficiency Advisor (Agricultural Focus) – £30,000–£40,000 per year

The Farming & Horticulture Mini Bundle is designed for those looking to understand how seeds, sustainability, and spreadsheets all come together. With topics spanning from horticulture and gardening to procurement and greenhouse strategy, this bundle provides a balanced view of growing—and getting—what’s needed in agricultural settings. Whether you’re a green-fingered hobbyist, someone supporting procurement in land-based industries, or just curious about how nature and management meet, this set of online courses offers a fresh take. It’s all available online, so the only thing you’ll be digging into is the course content. 🔹 Learning Outcomes: Understand how procurement supports agriculture and horticultural projects Explore basic gardening knowledge for effective outdoor maintenance Learn key plant science and care principles in horticulture Study greenhouse management for plant production and care Identify purchasing strategies relevant to land-based operations Examine environmental roles in agricultural and horticultural planning 🔹 Who is this Course For: Gardeners looking to understand planning and environmental concepts Procurement staff working in land, environment, or farming sectors Anyone curious about horticulture and growing systems Newcomers to agricultural supply and resource management Entry-level professionals in landscape and environmental services People seeking knowledge of greenhouse and gardening practices Support staff in garden centres or plant-based organisations Students exploring agriculture through accessible online learning 🔹 Career Path: Procurement Assistant (Agriculture) – £24,000–£32,000 per year Horticulture Assistant – £20,000–£26,000 per year Greenhouse Grower Supervisor – £27,000–£35,000 per year Gardening Coordinator – £22,000–£28,000 per year Agricultural Buyer – £30,000–£45,000 per year Environment Officer (Land Use Focus) – £28,000–£40,000 per year

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

Master medication knowledge with pharmacy, biology, chemistry, psychology, and healthcare-focused training in one online bundle. Medication matters, especially when you're responsible for understanding what’s prescribed, why it’s needed, and how it works. This bundle brings together pharmacy technician training, healthcare, biology, chemistry, and psychology—designed for those needing a well-rounded view of how medicines support physical and mental health. You’ll gain insight into how medications interact with the body, what biological systems are involved, and the role of mental health understanding in treatment choices. The pharmacy module ties everything together, helping you grasp the essentials of medication handling in a clinical setting. Whether you're in a care, admin, or clinical support role, this bundle will give you the structure you need to support safe, informed decisions. Learning Outcomes: Understand the basic principles of pharmacy and medication handling. Explore how biology links to the body’s reaction to medicines. Recognise the chemical foundations behind common medications. Examine healthcare procedures related to medicine administration. Understand the psychological considerations in medication use. Identify links between symptoms, diagnosis and medication types. Who Is This Course For: Pharmacy assistants seeking medication knowledge structure. Healthcare staff needing drug-awareness in patient care. Social care workers handling medication administration records. Care staff supporting medication supervision and guidance. Medical admin staff processing medication-related documentation. Support workers assisting clients with treatment plans. Entry-level healthcare professionals working around prescriptions. Psychology staff reviewing medication in treatment contexts. Career Path (UK Average Salaries): Pharmacy Technician – £29,000 per year Medication Support Worker – £25,000 per year Health Care Assistant – £23,500 per year Medical Administrator – £24,000 per year Clinical Support Worker – £26,000 per year Psychology and Medication Assistant – £27,500 per year