8440 Confidence courses in Matlock delivered On Demand

***Care with Confidence: The Ultimate Guide to Adult Care and Adult Nursing Theory *** Did you know that according to a recent Age UK report, the number of people aged over 65 in the UK is expected to reach 22 million by 2050? This growing demographic creates a significant demand for skilled and compassionate adult care and adult nursing specialists. This course, Adult Care & Adult Nursing, equips you with the foundational knowledge and theoretical understanding to excel in this vital field of Adult Care & Adult Nursing. Through a series of engaging modules of this Adult Care & Adult Nursing course, you'll gain a comprehensive understanding of the intricacies of nursing and caring for older adults, empowering you to make a positive impact on their lives. Learning Outcomes By the end of this Adult Care & Adult Nursing course, you'll be able to: Explain the core principles and values underpinning Adult Care & Adult Nursing practice. Identify the legal and ethical considerations when Care & Adult for adult patients. Develop effective communication skills to build trusting relationships with patients and families. Implement strategies to ensure safety and hygiene in an Adult Care & Adult Nursing setting. Understand the importance of proper medication administration for adult patients. Apply your knowledge to various aspects of adult care, including nutrition, hydration, and mobility. Key Highlights for Adult Care & Adult Nursing Course: CPD QS Accredited Proficiency with this Adult Care & Adult Nursing course. After successfully completing the Adult Care & Adult Nursing course, you will receive a FREE PDF Certificate from REED as evidence of your newly acquired abilities. Lifetime access to the whole collection of learning materials of this Adult Care & Adult Nursing course. The online test with immediate results You can study and complete the Adult Care & Adult Nursing course independently. Study for the Adult Care & Adult Nursing course using any internet-connected device, such as a computer, tablet, or mobile device. This comprehensive Adult Care & Adult Nursing course provides a strong theoretical foundation for a successful career in Adult Care & Adult Nursing. You'll explore the different healthcare settings where you might find yourself working, from hospitals and care homes to patients' own residences. Modules on adult development and the specific needs of elderly patients ensure you can provide individualized and compassionate care. The course delves into the human body's intricate systems, including the immune system, for a holistic understanding of patient well-being. You'll learn about managing rest and sleep patterns, a crucial aspect of adult care. Furthermore, the Adult Care & Adult Nursing course equips you with the knowledge to assist patients with mobility issues and manage pain effectively. Proper nutrition and hydration are essential for adult health, and you'll explore the role of nurses in maintaining these aspects. Curriculum Breakdown of the Adult Care & Adult Nursing Course Module 01: Introduction to Adult Nursing Module 02: Working in Different Healthcare Settings Module 03: Understanding legal, professional standards of practice and ethical aspects of health care- Part 1 Module 04: Understanding legal, professional standards of practice and ethical aspects of health care- Part 2 Module 05: Effective Communication in Adult Nursing Module 06: Health and Safety in Adult Nursing Module 07: Hygiene in Nursing Module 08: Infection Control Module 09: Asepsis in Nursing Module 10: Medication Administration in Adult Nursing Module 11: Adult Care in Different Life Stages Module 12: Understanding Immune System in Nursing Module 13: Rest and Sleep Management in Nursing Module 14: Mobility and Immobility Issues of Patients in Nursing Module 15: Pain Management for Nurses Module 16: Nutrition in Nursing Module 17: Fluid and Electrolyte Balance Module 18: Assisting with Elimination Module 19: Oxygenation in Nursing CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Adult Care & Adult Nursing course is ideal for: Individuals seeking a career in Adult Care & Adult Nursing. Healthcare professionals looking to expand their knowledge in this specialized field. Personal caregivers who want to enhance their understanding of adult care. Anyone interested in learning more about caring for older adults. Those considering volunteering in an Adult Care & Adult Nursing home or hospice setting. Individuals with family members requiring adult care. After completing this Adult Care & Adult Nursing course, anyone can enrol in the following courses: Level 2 Certificate in Principles of Safeguarding and Dignity in Adult Care (RQF) Level 2 Certificate in Preparing to Work in Adult Social Care (RQF) Level 3 Diploma in Adult Care (RQF) Level 3 Diploma in Adult Care Level 3 Certificate in Preparing to Work in Adult Social Care (RQF) Level 4 Certificate in Principles of Leadership and Management for Adult Care (RQF) Level 5 Diploma in Leadership and Management for Adult Care (RQF) Requirements There are no specific prerequisites for this Adult Care & Adult Nursing course. However, a basic understanding of human biology would be beneficial. Career path A career in Adult Care & Adult Nursing offers a multitude of rewarding opportunities. Here are some potential paths you can explore: Registered Nurse specializing in Adult Care Care Home Nurse Dementia Care Specialist Rehabilitation Nurse Community Nurse working with Older Adults Nurse Educator specializing in Adult Care Research Nurse focusing on Age-Related Conditions Certificates CPD Accredited Hard Copy Certificate Hard copy certificate - Included CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: £3.99 each Outside of the UK: £9.99 each CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate

English has emerged as the global language of trade and commerce in the past few decades and also become the standard for all vital official communications. This English As A Second or Foreign Language course is an ideal course designed to improve your communicative ability and provide you with useful lessons for promoting the strength to communicate during socialising, delivering speeches, telephoning, emailing, marketing to important business contracts or even taking part in business meetings and negotiating. This comprehensive course also intends to build your confidence and fluency by assisting you to analyse tasks and take part in practice activities that progressively promote listening and speaking skills. By the time you complete this course, you'll have an outstanding command of English which required for any prominent jobs these days. Who is this course for? English As A Second or Foreign Language is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. This course is CPD accredited so you don't have to worry about the quality. Requirements Our English As A Second or Foreign Language is open to all from all academic backgrounds and there are no specific requirements to attend this course. It is compatible and accessible from any device including Windows, Mac, Android, iOS, Tablets etc. 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 £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. Career path This course opens a new door for you to enter the relevant job market and also gives you the opportunity to acquire extensive knowledge along with required skills to become successful. You will be able to add our qualification to your CV/resume which will help you to stand out in the competitive job industry. Course Curriculum English As A Second or Foreign Language Module 1_ Introduction to ESL_EFL 00:30:00 Module 2_ GREETINGS AND INTRODUCTIONS 00:20:00 Module 3_ INVITATIONS 00:30:00 Module 4_ SMALL TALK 00:30:00 Module 5_ SOCIALIZING 00:20:00 Module 6_ EATING OUT 00:30:00 Module 7_ TELEPHONING 00:30:00 Module 8_ CORRESPONDENCE 00:30:00 Module 9_ GETTING A NEW JOB 00:30:00 Module 10_ LOCATION 00:20:00 Module 11_ SHAPES & TRENDS 00:30:00 Module 12_ NUMBERS 00:30:00 Module 13_ Ideas for Practising English 00:30:00 Mock Exam Mock Exam - English As A Second or Foreign Language 00:20:00 Final Exam Final Exam - English As A Second or Foreign Language 00:20:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

CPD Accredited. This online course covers how to accurately record a 12 Lead ECG Recording and is suitable for any staff working in a healthcare environment who are required to undertake this skill as part of their role. This course acts as an ideal refresher if you have previously undertaken ECGs within your role and want to boost your confidence, or for staff who are brand new to this skill. The course will cover the basic anatomy and physiology of the heart, the conduction system and accurate placement of the leads, to allow you to practice this skill in your own time with the equipment in your environment.

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

CPD Accredited | Career Oriented Learning Modules | 24x7 Tutor Support | Lifetime Access

Description The purpose of the Massage Therapist and Nail Technician Diploma course is to teach you the practical skills of a massage therapist and nail technician. At first, you will learn the basic concepts of massage therapy and how massage therapy works, how to do massage therapy with aroma or the basics of aromatherapy that will be followed by the skills of Acupressure, Holistic Therapy, and Reflexology. Finally, the course teaches the techniques of nail design and manicure. Upon completion, you will be able to start your massage therapy centre or start your career as a massage therapist or nail technician. Who is this course for? This course would be ideal for people who wish to work as a massage therapist, beauty therapist and holistic therapist. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career path: After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Massage Therapy Introduction to Massage Therapy 00:15:00 Massage History 00:15:00 The Role of A Massage Therapist 00:30:00 Tissues, Organs, & Neuromuscular systems 01:00:00 General Benefits of Massage 00:15:00 Indian Head Massage 00:15:00 Facial Massage 00:30:00 Neck Massage 00:30:00 Back Massage 00:30:00 Full Body Massage 00:15:00 Swedish Massage 00:15:00 Sports Massage 00:30:00 LomiLomi Massage 00:15:00 Anti-Cellulite Massage 00:15:00 Hot Stone Massage 00:30:00 Thai Foot Massage 00:15:00 Prenatal Massage 00:15:00 Medical Massage 01:00:00 Baby Massage 01:00:00 Trigger Point Therapy 01:00:00 Thai Massage 01:00:00 Reflexology 01:00:00 How A Massage Therapist Can Start A Business 01:00:00 Marketing Your Business 01:00:00 Complimentary Massages 00:15:00 Building Your Clientele 00:30:00 Other Ways To Market Your Business 01:00:00 Conclusion to Massage 00:15:00 Aromatherapy What is Aromatherapy? 00:15:00 History of Aromatherapy 00:15:00 The Definition of Aromatherapy 00:15:00 What are Essential Oils? 00:15:00 Essential Oil Safety Information 00:15:00 Administration of Essential Oils 00:30:00 The Art of Blending 00:15:00 Blending Basics 00:15:00 Harmonizing Your Blend 00:30:00 Aromatherapy Baths 00:15:00 Aromatherapy for Stress 00:15:00 Aromatherapy for Children 00:14:00 Application of Essential Oils 00:15:00 Table of the Basic Methods of Use of Essential Oils 00:15:00 The Holistic Approach 00:30:00 Understanding Disease / Pathology 00:30:00 The Benefits of a Holistic Aromatherapy Treatment 00:15:00 Acupressure & Massage Acupressure 00:30:00 How Acupressure Works 00:30:00 Locating A Pressure Point 01:00:00 Acupressure Techniques 00:30:00 How To Apply Pressure 00:30:00 Breathing 00:30:00 Things To Be Careful Of 00:30:00 Acupressure For Specific Problems 00:30:00 If You Feel It's Not Working 00:15:00 Practical Self Massage 01:00:00 Handheld Massagers 00:30:00 Reflexology Introduction to Reflexology 00:15:00 Historical Roots 01:00:00 Benefits of Reflexology 01:00:00 Theories & Effect of Reflexology 01:00:00 Foot Reflexology 01:00:00 Reflexology Techniques 00:30:00 Reflexology Aftercare 00:15:00 Hand Reflexology 00:30:00 Special Reflexology Treatments 01:00:00 Reflexology Do's & Dont's 00:02:00 Nail Technician The Nail Salon Basics 00:30:00 Nail Anatomy 00:15:00 The Manicuring Process 00:30:00 The Process of Performing a Pedicure 00:30:00 Scrub Pedicure 00:15:00 Hydration Pedicure 00:30:00 Aromatherapy Pedicure 00:30:00 Acrylic Nail/Tip Application Process 00:30:00 Acrylic Powders 00:30:00 Professional Nail Tips 00:30:00 Nail Care Products 01:00:00 Trouble shooting acrylic nails 01:00:00 Business Plan 00:30:00 CLIENTS 00:00:00 Marketing 00:45:00 Nail Salon Professionalism 00:30:00 Your Skills 00:30:00 Health, Hygiene & Safety 01:00:00 Manicure and Pedicure Manicure 00:15:00 Nail Structure 00:15:00 Manicure 00:15:00 Giving French Manicure 00:15:00 Nail Filing 00:15:00 Nail Clipping 00:15:00 Hand Massage 00:15:00 Nail Polishing 00:15:00 Pedicure Treatment 00:30:00 Hard Skin Removal 00:15:00 Foot Massage 00:15:00 Taking care of Feet 00:15:00 Mock Exam Mock Exam- Massage Therapist and Nail Technician Diploma 00:30:00 Final Exam Final Exam- Massage Therapist and Nail Technician Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Highlights of the Course Course Type: Online Learning Duration: 2 Hours 26 Minutes Tutor Support: Tutor support is included Customer Support: 24/7 customer support is available Quality Training: The course is designed by an industry expert Recognised Credential: Recognised and Valuable Certification Completion Certificate: Free Course Completion Certificate Included Instalment: 3 Installment Plan on checkout What you will learn from this course? Gain comprehensive knowledge about Fusion 360 graphic designing Understand the core competencies and principles of Fusion 360 graphic designing Explore the various areas of Fusion 360 graphic designing Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert graphic designer Microsoft Office Excel 2016: Part 2 (Intermediate Level) Course Master the skills you need to propel your career forward in Microsoft Office Excel. This course will equip you with the essential knowledge and skillset that will make you a confident office admin and take your career to the next level. This comprehensive excel 2016 intermediate level course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this excel 2016 intermediate leve course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Microsoft Office Excel practice and equip you with the essential skills, confidence and competence to assist you in the Microsoft Office Excel industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Microsoft Office Excel. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for office admin or for people who are aspiring to specialise in Microsoft Office Excel. Enrol in this excel 2016 intermediate leve course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. Who is this Course for? This comprehensive excel 2016 intermediate leve course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Microsoft Office Excel can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. Entry Requirements This excel 2016 intermediate leve course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. Assessment This excel 2016 intermediate leve course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Advance Your Career This excel 2016 intermediate leve course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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. Course Curriculum Course Overview Introduction and Course Overview 00:02:00 Working with Functions Working and Function - Introduction 00:01:00 Work with Ranges - Introduction 00:01:00 Name and Edit Ranges 00:05:00 Use Defined Names in a Formula 00:03:00 Locate and Use Specialized Functions 00:05:00 Work with Logical Functions - Introduction (02:13) 00:02:00 IF Function 00:04:00 AND, OR and NOT Function 00:05:00 Combine Functions 00:06:00 Functions Similar to the IF Function 00:05:00 Work with Date and Time Functions - Introduction 00:01:00 TODAY, NOW and DATE Functions 00:03:00 NETWORKDAY, WEEKDAY, WORKDAY and ISOWeeknum Functions 00:05:00 Work with Text Functions - Introduction 00:01:00 LEFT, RIGHT and MID Functions 00:02:00 FIND Function 00:03:00 Text to Columns Feature 00:03:00 CONCATENATE Function 00:03:00 UPPER, LOWER and PROPER Functions 00:02:00 Practice File Working with Functions Practice File Working with Functions 00:00:00 Working with Lists Sort Data - Introduction 00:01:00 Sort Data 00:03:00 Filter Data - Introduction 00:01:00 Filter Data 00:02:00 Query Data with Database Functions 00:01:00 Database Functions 00:03:00 Outline and Subtotal Data - Introduction 00:01:00 Use Subtotals to Summarize Data 00:03:00 Practice File Working with Lists Practice File Working with Lists 00:00:00 Assessment Mock 1 Assessment Mock 1 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Analyzing Data Create and Modify Tables - Introduction 00:01:00 Create and Modify Tables 00:06:00 Use Summary Functions in Tables 00:03:00 Apply Intermediate Conditional Formatting - Introduction 00:01:00 Apply Intermediate Conditional Formatting 00:02:00 Apply Advanced Conditional Formatting - Introduction 00:01:00 Use Logical Functions to Apply Conditional Formatting 00:03:00 Practice File Analyzing Data Practice File Analyzing Data 00:00:00 Visualizing Data with Charts Create Charts - Introductions 00:01:00 Create Charts 00:04:00 Modify and Format Charts - Introduction 00:01:00 Modify and Format Charts 00:05:00 Use Advanced Chart Features - Introduction 00:01:00 Create a Dual-Axis Chart 00:04:00 Create a Chart Template 00:03:00 Visualizing Data with Charts - Best Practice 00:04:00 Practice File Visualizing Data with Charts Practice File Visualizing Data with Charts 00:00:00 Using PivotTables and PivotCharts Create a PivotTable - Introductions 00:01:00 Create a PivotTable 00:04:00 Analyze PivotTable Data - Introduction 00:01:00 Analyze PivotTable Data 00:04:00 Present Data with PivotCharts - Introduction 00:01:00 Present Data with PivotCharts 00:05:00 Filter Data by Using Timelines and Slicers - Introduction 00:01:00 Filter Data by Using Slicers and Timelines 00:04:00 Bonus Lecture 00:01:00 Practice File Using PivotTables and PivotCharts Practice File Using PivotTables and PivotCharts 00:00:00 Assessment Mock 2 Assessment Mock 2 - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Final Assessment Final Assessment - Microsoft Office Excel 2016: Part 2 (Intermediate Level) 00:10:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Empower your passion for education with the Teaching Assistant Advanced Diploma. Gain advanced skills in supporting diverse learners, develop effective teaching strategies, and contribute to inclusive learning environments. This comprehensive course equips you for a fulfilling career as a highly qualified teaching assistant.

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00