59545 Courses

Overview This comprehensive course on Spanish Language : Intermediate Level will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Spanish Language : Intermediate Level 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? 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 Spanish Language : Intermediate Level. It is available to all students, of all academic backgrounds. Requirements Our Spanish Language : Intermediate Level 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 1 sections • 21 lectures • 03:59:00 total length •Learn Spanish - The Past I- Simple and Compound: 00:10:00 •Learn Spanish - The Past I- Simple and Compound (Contrast): 00:14:00 •Learn Spanish - The Past II- Past Perfect: 00:07:00 •Learn Spanish - The Past III- Past Imperfect: 00:09:00 •Learn Spanish - The past IV- Contrast: 00:10:00 •Learn Spanish - The Gender of nouns: 00:15:00 •Learn Spanish - The Number of nouns: 00:07:00 •Learn Spanish - Informal affirmative imperative 1: 00:11:00 •Learn Spanish - Informal affirmative imperative 2: 00:04:00 •Learn Spanish - Formal affirmative imperative: 00:09:00 •Learn Spanish - Affirmative imperative: 00:12:00 •Learn Spanish - The indefinite: 00:14:00 •Learn Spanish - Quantifiers: 00:16:00 •Learn Spanish - The frequency: 00:14:00 •Learn Spanish - Perfect future: 00:09:00 •Learn Spanish - The simple conditional: 00:10:00 •Learn Spanish - Conditional Sentences: 00:14:00 •Learn Spanish - In the car: 00:10:00 •Learn Spanish - The negative imperative: 00:10:00 •Learn Spanish - Pronouns: 00:10:00 •Learn Spanish - Present Subjunctive: 00:24:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum How to Discover Amazing Startup Ideas How to Discover Amazing Startup Ideas - Start by Asking these 5 Questions 00:06:00 Spotting Problems Simplified - Overview 00:02:00 Problem Spotting Simplified - Part 1 00:07:00 Problem Spotting Simplified - Part 2 00:09:00 Problem Spotting Simplified - Part 3 00:06:00 Problem Spotting Simplified - Part 4 00:06:00 Problem Spotting Simplified - Part 5 00:01:00 Problem Spotting Simplified - Part 6 00:02:00 Problem Spotting Simplified - Part 7 00:04:00 Problem Spotting Simplified - Part 8 00:04:00 Problem Spotting Simplified - Part 9 00:08:00 The Elusive Problem-Solution Fit Evaluating The Problem-Solution Fit 00:06:00 Problem Assessment - Evaluating the Problem-Solution Fit 00:11:00 Solution Assessment - Evaluating the Problem-Solution Fit 00:08:00 Identifying your Core Customers - Draw your Buyer Avatar/Persona 00:04:00 Evaluating The Product-Market Fit Is your Startup the Next Unicorn? Assessing The Potential of your Startup Idea - Start with the Competition 00:13:00 Assessing the Market for your Startup - Evaluating the Playground 00:07:00 Draw your Startup Blueprint on "Lean Canvas" Draw your Startup Blueprint on “Lean Canvas” 00:12:00 What is Idea Validation and Why Is It a Must-Do Step for Any Startup? What is Idea Validation and Why Is It a Must-Do Step for Any Startup? 00:10:00 13 Approaches to Test Your Startup Ideas 13 Approaches to Test Your Startup Idea 00:06:00 Results of Idea Validation 00:01:00 The Entrepreneurship Trap Entrepreneurs are Resourceful 00:02:00 Entrepreneurship is a Mindset 00:01:00 The Entrepreneurship Trap 00:01:00 Startup Core Characteristics and Failure Rates What is a Startup 00:01:00 Startup Core Characteristics and Failure Rates 00:02:00 Failure Implications For Startup Investors & Failure Rates by Industry 00:03:00 There's No Survivorship Bias 00:01:00 Uncover The #1 Reason Why Most Startups Fails Why Startups Fail - Reason 20 00:02:00 Why Startups Fail - Reason 19 to 15 00:07:00 Why Startups Fail - Reason 14 to 10 00:04:00 Why Startups Fail - Reason 9 to 5 00:04:00 Why Startups Fail - Reason 4 to 2 00:03:00 Uncover The #1 Reason Why Most Startups on the Face of Planet Earth Have Failed 00:03:00 Bonus: Profitable App Development Blueprint for Startups Profitable App Development Blueprint for Startups 00:37:00 Supplementary Resources Supplementary Resources - Entrepreneurship: 60 Day Startup Launch Blueprint 00:00:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Overview This comprehensive course on SEN Teaching Assistant and SENCO Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SEN Teaching Assistant and SENCO Training 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 SEN Teaching Assistant and SENCO Training. It is available to all students, of all academic backgrounds. Requirements Our SEN Teaching Assistant and SENCO Training 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 1 sections • 16 lectures • 03:58:00 total length •Module 01: Special Education Needs (SEN): An Overview: 00:08:00 •Module 02: SEN Support: 00:12:00 •Module 03: High-Quality Teaching for Pupils with SEN: 00:09:00 •Module 04: SEN Teaching Methodologies: 00:20:00 •Module 05: Communication and Interaction: 00:16:00 •Module 06: Cognition and Learning: 00:20:00 •Module 07: Social, Emotional and Mental Health Difficulties: 00:11:00 •Module 08: Sensory or Physical Needs: 00:15:00 •Module 09: The SENCO Role in Policy and Practice: 00:12:00 •Module 10: Roles and Responsibilities within whole School SEN Co-ordination: 00:12:00 •Module 11: The SENCO and the Senior Leadership Team: 00:14:00 •Module 12: Supporting Colleagues and working with Professionals and Organisations beyond the School: 00:24:00 •Module 13: Developing Relationship with Pupils and Parents: 00:19:00 •Module 14: SENCO's Role in Leading and Managing SEND Administration: 00:17:00 •Module 15: Challenges and Opportunities: 00:16:00 •Module 16: Developing Inclusive Practice and the Future SENCO Role: 00:13:00

Overview Become a gifted event planner or manager, and polish your creative mind and meticulous eye for detail, with our Level 3 - Event Management & Wedding Plannercourse.A brilliant event planner has tremendous creativity, but also needs management skills. This expert-designed Level 3 - Event Management & Wedding Planner course will educate you on every event-related concept and help you develop skills like efficiency, multi-tasking and much more. Furthermore, it will coach you in all the fundamentals, from initial brainstorming and concept development to working hands-on with clients. So, enrol in the Level 3 - Event Management & Wedding Planner course and make every event unforgettable! 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 Level 3 - Event Management & Wedding Planner. It is available to all students, of all academic backgrounds. Requirements Our Level 3 - Event Management & Wedding Planner 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 7 sections • 7 lectures • 02:17:00 total length •Wedding Planner as a Profession: 00:18:00 •The Big Day Planning: 00:19:00 •Wedding Party Dresses: 00:30:00 •The Reception, Party and Gifts: 00:20:00 •Final Budget: 00:13:00 •Wedding Planner Business Marketing: 00:16:00 •Starting a Business as a Wedding Planner: 00:21:00

Overview This comprehensive course on Food Safety Complete Bundle- Food Safety, Food Allergens & HACCP will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Food Safety Complete Bundle- Food Safety, Food Allergens & HACCP 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 Food Safety Complete Bundle- Food Safety, Food Allergens & HACCP. It is available to all students, of all academic backgrounds. Requirements Our Food Safety Complete Bundle- Food Safety, Food Allergens & HACCP 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 3 sections • 36 lectures • 16:22:00 total length •Food Safety - Introduction: 00:30:00 •Supervision of Food Safety: 00:37:00 •Food Safety Legislation: 00:34:00 •Food Safety Management Systems: 00:44:00 •Food Safety Management Tools: 00:30:00 •Microbiology: 00:28:00 •Contamination Hazards: 00:28:00 •Controlling Contamination: 00:39:00 •Bacterial Food Poisoning and Food-Borne Illness: 00:32:00 •Non-bacterial Food Poisoning: 00:32:00 •Personal Hygiene: 00:30:00 •Food and Temperature Control: 00:34:00 •Checking, Verifying and Recording Temperature: 00:25:00 •Food Spoilage and Preservation: 00:38:00 •Food Premises and Equipment The Design and Construction: 00:35:00 •Waste Disposal, Cleaning and Disinfection: 00:35:00 •Pest Management: 00:29:00 •Food Safety Training for the Staff: 00:29:00 •Module 01: An Introduction to HACCP: 00:15:00 •Module 02: HACCP and Food Safety Legislation: 00:25:00 •Module 03: Food Safety Hazards: 01:00:00 •Module 04: Planning a HACCP System: 00:40:00 •Module 05: Creating the HACCP System: 00:20:00 •Module 06: Principle 1 - Hazard Analysis: 00:15:00 •Module 07: Principle 2 - Critical Control Points: 00:12:00 •Module 08: Principle 3 - Critical Limits: 00:20:00 •Module 09: Principle 4 - Monitoring Critical Control Points: 00:20:00 •Module 10: Principle 5 - Corrective Action: 00:25:00 •Module 11: Principle 6 - Verification of the HACCP System: 00:30:00 •Module 12: Principle 7 - Documentation: 00:16:00 •Module 13: Implementing the HACCP System: 00:12:00 •Module 14: HACCP Alternatives: 00:15:00 •Basics of Food Allergens: 00:13:00 •Allergen Guidance for Food Businesses: 00:22:00 •Allergen Guidance for Consumers: 00:14:00 •Allergic Reactions and Treatments: 00:19:00

Overview This comprehensive course on The Birth of the Railway Age in Glasgow will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This The Birth of the Railway Age in Glasgow 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 The Birth of the Railway Age in Glasgow. It is available to all students, of all academic backgrounds. Requirements Our The Birth of the Railway Age in Glasgow 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 1 sections • 5 lectures • 01:07:00 total length •Module 01: The Monkland Canal: 00:16:00 •Module 02: The Monklands and Kirkintilloch Railway: 00:12:00 •Module 03: The Garnkirk and Glasgow Railway: 00:12:00 •Module 04: The Story of the Railway Works in Springburn Glasgow: 00:20:00 •Module 05: The Ballachulish Railway: 00:07:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Supplementary Resources Supplementary Resources - Web Design Masterclass 00:00:00 Photoshop Crash Course for Web Design Aligning Layers 00:13:00 Stack, Copy + Delete Layers 00:04:00 Organize Layers 00:02:00 Layer Styles 00:02:00 Shapes 101 00:03:00 5 Essential Tools 101 00:06:00 Gradient Tools 101 00:05:00 Smart Objects 101 00:03:00 History Panel 101 00:03:00 Retouching Tools 101 - Stamp Tool 00:12:00 Retouching Tools 101 - Patch Tool 00:11:00 Retouching Tools 101 - Content Aware Tool 00:04:00 Anatomy of Website - for Web Designers Header 00:04:00 Navigation 00:07:00 Hero 00:11:00 Body 00:02:00 Footer 00:02:00 Sidebar 00:02:00 Web Design Styles Brief History & My Thoughts 00:09:00 7 Popular Web Design Styles 00:19:00 Get Inspired 00:08:00 Grid System + Bonus Tip Grid System 00:04:00 Bonus: Pixel Perfect 00:04:00 Photoshop Web Design Project 1 - Nike Briefing Of Project 00:05:00 Images 00:05:00 Retouch Images 00:13:00 Retouch Like a Pro - Quick Tip 00:03:00 Header Part 1 00:07:00 Header Part 2 00:11:00 Mega Menu 00:20:00 Hero 00:06:00 Body 00:04:00 Footer 00:21:00 Photoshop Web Design Project 2 - Manhattan Logo Redesign 00:05:00 Header 00:03:00 Hero Part 1 00:28:00 Hero Part 2 00:03:00 Social Proof - Body Part 1 or Part of Hero? 00:06:00 Body Part 2 00:07:00 Body Part 4 - Part 1 00:10:00 Body Part 4 - Part 2 00:05:00 Footer 00:04:00 Final Tweaks 00:09:00 Photoshop Web Design Project 3 - Seaside Briefing of Project 00:17:00 Logo 00:02:00 Header 00:09:00 Hero 00:08:00 Body - Services 00:15:00 Body - Samples Part 1 00:07:00 Body - Samples Part 2 00:11:00 Body - Samples Part 3 00:11:00 Body - Samples Part 4 00:11:00 Body - Contact 00:12:00 Footer 00:07:00 Tweaks 00:10:00 Photoshop Web Design Project 4 - Real Estate Briefing Of Project 00:21:00 Retouch Hero Image 00:15:00 Header 00:09:00 Hero 00:11:00 Custom Icons Part 1 00:11:00 Custom Icons Part 2 00:07:00 Body - Services 00:04:00 Body - Property Owner Call to Action 00:03:00 Body - Listings 00:14:00 Body - Blog + Sidebar 00:12:00 Footer 00:07:00 Tweaks 00:17:00 Photoshop Web Design Project 5 - Watkins Glen Briefing of Project 00:07:00 Header + Hero 00:07:00 Body - Things to do Part 1 00:04:00 Body - Things to do Part 2 00:11:00 Body - Info 00:12:00 Footer 00:03:00 Tweaks 00:06:00 Photoshop Web Design Project 6 - Retro Gallery Briefing Of Project 00:06:00 Logo 00:06:00 Header 00:13:00 Hero Part 1 - Custom Retro Slider 00:06:00 Hero Part 2 - Custom Retro Slider 00:04:00 Hero Part 3 - Custom Retro Slider 00:04:00 E-commerce Listings Part 1 00:06:00 E-commerce Listings Part 2 00:06:00 Footer 00:04:00 Photoshop Web Design Project 7 - Trek Mountain Bike Camp Briefing of Project 00:07:00 Watercolor 00:06:00 Header + Hero 00:08:00 Body Content 00:11:00 Body Register 00:04:00 Footer 00:02:00 Assessment Assessment - Web Design Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

QLS Endorsed + CPD QS Accredited - Dual Certification | Instant Access | 24/7 Tutor Support

Overview This comprehensive course on 'Learning Support Assistant' will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This 'Learning Support Assistant' 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 'Learning Support Assistant'. It is available to all students, of all academic backgrounds. Requirements Our 'Learning Support Assistant' 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 10 sections • 10 lectures • 03:53:00 total length •The Roles of a Learning Support Assistant (LSA): 00:26:00 •Working with Children in a School: 00:18:00 •Assessing Students: 00:12:00 •Skills of a Learning Support Assistant: 00:23:00 •Providing for All Children: 00:28:00 •Safeguarding and Wellbeing of Children and Young People: 00:22:00 •Dealing with Emergencies: 00:21:00 •Special Educational Needs (SEN): 00:38:00 •Professional Development: 00:24:00 •Time and Stress Management: 00:21:00