17380 Other courses in Windlesham delivered Online

What you will learn from this course? Gain comprehensive knowledge about weight loss and fitness Understand the core competencies and principles of weight loss and fitness Explore the various areas of weight loss and fitness Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert weight loss coach or fitness coach Course Highlights Course Type: Self-paced online course Duration: 3 hours 18 minutes Tutor Support: Full tutor support is included Customer Support: 24/7 customer support is available Healthy Eating & Diet Planning - Nutrition Online Training Course Master the skills you need to propel your career forward in weight loss and fitness. This course will equip you with the essential knowledge and skillset that will make you a confident weight loss coach or fitness coach and take your career to the next level. This comprehensive healthy eating & diet planning - nutrition course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this healthy eating & diet planning - nutrition 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 weight loss and fitness practice and equip you with the essential skills, confidence and competence to assist you in the weight loss and fitness industry. You'll gain a solid understanding of the core competencies required to drive a successful career in weight loss and fitness. 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 weight loss coach or fitness coach or for people who are aspiring to specialise in weight loss and fitness. Enrol in this healthy eating & diet planning - nutrition 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 healthy eating & diet planning - nutrition 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 weight loss and fitness 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 healthy eating & diet planning - nutrition 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 healthy eating & diet planning - nutrition 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 healthy eating & diet planning - nutrition 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. Study Plex Subscription Study plex also provides a subscription option that allows you unlimited access to more than 700+ CPD courses for learning. You only need to spend £79 to take advantage of this fantastic offer, and you'll get an unlimited subscription for a full year. Additionally, you can cancel your membership from your account at any time by getting in touch with our friendly and devoted customer care team. Visit our subscriptions page for more details if you're interested. Why you should train with Study Plex? At Study Plex, you will have the chance to build social, technical and personal skills through a combination of extensive subjects tailored according to your interest. Along with receiving comprehensive knowledge and transferable skills, there are even more reasons o be involved with us, which include: Incredible Customer Support: We offer active customer service in the form of live chat, which you can access 24/7 Expert Tutor Support: You'll have access to our devoted and dedicated tutor support with all of our courses whenever you need it. Price Justified by Quality: We ensure that you will have the best experience possible for the price you are paying for the course. Money-back Guarantee: We provide a money-back guarantee if you are not satisfied with the course's quality. There is a 14-day time limit on this option (according to the terms and conditions). Instalment Facility: If your course costs more than £50, you can pay in three instalments using the instalment option. Satisfaction Guarantee: Our courses are designed to meet your demands and expectations by all means. 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 Introduction & What you will learn in the course 00:03:00 who this course is for 00:01:00 What Is Nutrition? 00:01:00 The 5 principles of healthy Eating 00:04:00 The True Dieting Pyramid 00:04:00 Calorie Balance Calories Explained 00:03:00 Bodyweight And Health 00:05:00 Calories & Bodyweight In A Healthy Diet 00:01:00 The Twinkie Diet - An Extreme Example 00:01:00 Weight Loss And Health 00:02:00 How Many Calories Should You Consume Per Day? 00:02:00 Healthy Weight Ranges Explained 00:01:00 How To Lose Weight Part 1 00:03:00 How To Lose Weight Part 2 00:02:00 How To Take Diet Breaks Correctly 00:05:00 How To Properly Track Your Calories 00:05:00 How To Lose Weight Without Tracking Calories 00:04:00 Food Composition Food Composition Explained 00:02:00 Protein Composition 00:02:00 Carbohydrates Composition 00:03:00 Fat Composition 00:01:00 Recommendations Food Composition 00:03:00 Macronutrients Macronutrients Explained 00:01:00 The Relationship Between Protein And Health 00:02:00 Complete & Incomple Protein 00:01:00 Protein Needs For General Health 00:02:00 Fat Needs For General Health 00:03:00 Carbohydrate Needs For General Health 00:01:00 Macronutrients Recommendations 00:03:00 Nutrient Timing Nutrient Timing Explained 00:02:00 Nutrient Timing Pros & Cons 00:03:00 Nutrient Timing Recommendations 00:02:00 Supplements Supplements Explained 00:03:00 Why Multivitamins Aren't A Good Idea 00:02:00 The Best Supplements To Boost Immunity 00:04:00 The Best Supplements For Vegans & Vegetarians 00:02:00 The Best Supplements For Joint & Bone Health 00:02:00 The Best Supplements For Fat Loss 00:04:00 The Best Supplements For Improved Sleep 00:02:00 The Best Supplements For More Focus & Concentration 00:02:00 How To Boost Testoterone 00:06:00 Supplements Recommendations 00:01:00 Common Diet Trends Explained The Fundamentals Of Healthy Eating 00:02:00 Making Small Changes Towards A Healthier Diet 00:03:00 How To Read A Nutrition Label 00:03:00 Healthy Eating Fundamentals Health Myths Overview 00:01:00 Dieting Myth #1: Carbs Are Bad For You 00:01:00 Dieting Myth #2: Fat Is Bad For You 00:01:00 Dieting Myth #3: Protein Is Bad For You 00:03:00 Dieting Myth #4: Eating Eggs Raises Cholesterol 00:01:00 Dieting Myth # 5: Avoid Salt At All Cost 00:01:00 Dieting Myth #6: Eat Several Small Meals To Boost Metabolism 00:01:00 Dieting Myth #7: Diet Foods Lead To Fat Loss 00:01:00 Dieting Myth #8: Red Meat Causes Cancer 00:02:00 How To Do Your Own Research 00:04:00 Health Myths, Diet Fads & More Common Diets Introduction 00:01:00 Gluten Free Diet Explained 00:03:00 Paleo Diet Explained 00:03:00 Low Carb Explained 00:03:00 Intermittent Fasting 00:03:00 Vegan Diet Explained 00:05:00 Micronutrients (Vitamins & Minerals) Vitamin A 00:01:00 Vitamin B 00:01:00 Vitamin C 00:01:00 Vitamin D 00:01:00 Vitamin E 00:01:00 Vitamin K 00:01:00 Calcium 00:01:00 Magnesium 00:01:00 Phosphorus 00:01:00 Potassium 00:01:00 Sodium 00:01:00 Copper 00:01:00 Zinc 00:01:00 Water 00:04: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

🍬 Unlock the Sweet Success with Our Confectionary Making Course! 🍭 Are you ready to turn your passion for sweets into a lucrative career? Look no further! Our comprehensive Confectionary Making course is designed to take you on a delightful journey through the art and science of creating mouthwatering treats. Whether you're an aspiring pastry chef, a baking enthusiast, or simply someone who loves to indulge in sweet creations, this course is your golden ticket to mastering the craft of confectionary.   🌟 Why Choose Our Confectionary Making Course? 🌟 Expert Guidance: Learn from seasoned confectionary experts who have mastered the art of creating delectable sweets. Our instructors bring years of industry experience to the table, ensuring you receive top-notch guidance every step of the way. Hands-On Learning: Get ready to roll up your sleeves and dive into the world of confectionary making! Our course emphasizes practical, hands-on learning, allowing you to hone your skills through immersive, interactive activities. Comprehensive Curriculum: From classic confections like chocolates and candies to trendy treats like macarons and cake pops, our course covers it all. Explore a wide range of techniques, recipes, and flavor combinations to unleash your creativity in the kitchen. Flexibility and Convenience: Life is busy, but that shouldn't stop you from pursuing your passion for confectionary making. Our course offers flexible scheduling options and convenient online access, so you can learn at your own pace, anytime, anywhere. Networking Opportunities: Connect with fellow confectionary enthusiasts from around the globe! Our vibrant online community provides a supportive platform where you can share ideas, troubleshoot challenges, and forge valuable connections within the industry.   🎯 Who is This For? 🎯 Our Confectionary Making course is perfect for anyone with a sweet tooth and a desire to explore the world of pastry arts. Whether you're a baking novice eager to learn the basics or a seasoned professional looking to refine your skills, this course is tailored to suit learners of all levels. If you dream of crafting stunning desserts that delight the senses and bring joy to others, then this course is for you!   🚀 Career Path 🚀 Embark on a sweet journey toward a fulfilling career in the confectionary industry! With the skills and knowledge gained from our course, you'll be well-equipped to pursue various exciting career opportunities, including: Pastry Chef: Bring your culinary creations to life as a skilled pastry chef in restaurants, bakeries, hotels, and catering companies. Chocolatier: Dive into the world of chocolate-making and dazzle customers with handcrafted truffles, bonbons, and other chocolate delights. Entrepreneur: Turn your passion for confectionary making into a thriving business venture! Launch your own bakery, confectionary shop, or online dessert boutique and share your sweet creations with the world. Food Blogger/Influencer: Showcase your confectionary masterpieces on social media platforms and build a loyal following as a food blogger or influencer. Culinary Educator: Share your expertise with aspiring confectioners by teaching classes, workshops, or private lessons in the art of sweet-making.   Don't let your dreams melt away - enroll in our Confectionary Making course today and take the first step toward a sweet and successful future! 🍫✨   FAQ (Frequently Asked Questions) - Confectionary Making Q1: What is confectionary making? Confectionary making is the art and science of creating various sweet treats such as candies, chocolates, pastries, and desserts. It involves a combination of techniques including cooking, baking, molding, and decorating to produce delicious and visually appealing confections. Q2: Who can participate in a confectionary making course? Confectionary making courses are designed for individuals of all skill levels, from beginners with little to no experience in baking or cooking, to seasoned bakers looking to expand their repertoire. Whether you're a hobbyist interested in learning new recipes or a professional seeking to enhance your culinary skills, there's something for everyone in a confectionary making course. Q3: What will I learn in a confectionary making course? In a confectionary making course, you will learn a variety of techniques and recipes for creating different types of sweets and desserts. This may include learning how to temper chocolate, make caramel, sculpt marzipan figures, bake pastries, and much more. Additionally, you'll gain knowledge about ingredient selection, flavor pairing, and presentation techniques to elevate your confections to the next level. Q4: Do I need any special equipment or ingredients to participate? While some confectionary making techniques may require specialized equipment such as candy thermometers, pastry bags, or chocolate molds, many recipes can be made using basic kitchen tools and ingredients. Your course instructor will provide guidance on any necessary equipment and ingredients for each recipe, and may also offer alternatives or substitutions to accommodate different skill levels and budgets. Q5: Can I accommodate dietary restrictions in confectionary making? Yes, many confectionary making courses offer options for accommodating dietary restrictions such as gluten-free, dairy-free, or vegan diets. Additionally, instructors may provide tips and substitutions for adjusting recipes to meet specific dietary needs without sacrificing flavor or texture. If you have any dietary concerns, be sure to communicate them with your instructor beforehand so they can tailor the course content accordingly. Course Curriculum Module 1 Introduction To Confectionary Making Introduction To Confectionary Making 00:00 Module 2 Cakes and Candies Cakes and Candies 00:00 Module 3 Coloured Confectionaries Coloured Confectionaries 00:00

BRIT Creative Coaching is structured for Performing Arts Students to reach their goals. Discover and build new skills that you need outside the studio.

To provide a fundamental understanding of building services in the context of: The working environment The success of the core business The health and safety of the occupants Operating cost and environmental impact The optimisation of cost and value Strategies for continuous improvement DAY ONE 1 Building services fundamentals The function of services in commercial buildings and their importance to the core businessElectrical servicesLightingHeatingVentilation and air conditioningLiftsWater Understanding IT and communication systems Practical exercises 2 The provision of comfort and safety Statutory requirementsHealth and safety legislationControl of contractorsRisk assessmentFire precautionsLegionella, sick building and other risks Business requirementsUnderstanding user requirementsMatching systems to business needs Practical exercises 3 Getting the design right What the FM needs to know about design and its procurementSuccessful space planningRelationship between services, space planning and designGetting the brief rightSupplier selection and management Practical exercises DAY TWO 4 Operation and maintenance Why maintain?Maintenance contractsInput and output specificationsResource optionsContracts - principal elementsTendering - key stepsSelection criteriaOperational criteriaMaintenance trends Performance-based service provisionInput and output specificationsKPIs and thresholdsRisk containmentValue-add opportunitiesPerformance contract strategy Practical exercises 5 Contingency planning Being ready for the unexpected Identifying and reducing riskInternal risksExternal risksIdentifying threats at your site Managing riskProtective systemsOccupier obligationsFire managementTesting Practical exercises 6 Commissioning services systems Physical commissioning Common problems Typical costs Commissioning stages Continuous commissioning Energy efficiency and the scope for environmental improvement Practical exercises 7 Satisfying the occupants Obtaining and responding to feedbackWhen to get feedbackWhyHowWhat to do with it Practical exercises 8 'Air time' Sharing experience and addressing specific issues of interest to participants Course review Close

2 QLS Endorsed Courses | CPD Certified | Free PDF & QLS Hardcopy Certificates | 180 CPD Points | Lifetime Access

Stress can affect negatively especially in your working habits and daily routine. To overcome stress, you need to know an effective strategy to eliminate or minimize stress which can be possible through stress management. Take this Professional Diploma in Stress Management Strategy for you to avoid any stress that can contribute to the deterioration of your physical, mental, and emotional health. Dealing with stress can only be possible if you learn how to have a positive mindset and motivation to have a healthy lifestyle. Course Highlights The price is for the whole course including final exam - no hidden fees Accredited Certificate upon successful completion at an additional cost Efficient exam system with instant results Track progress within own personal learning portal 24/7 customer support via live chat Professional Diploma in Stress Management Strategy has been given CPD accreditation and is one of the best-selling courses available to students worldwide. This valuable course is suitable for anyone interested in working in this sector or who simply wants to learn more about the topic. If you're an individual looking to excel within this field then Professional Diploma in Stress Management Strategy is for you. We've taken this comprehensive course and broken it down into several manageable modules which we believe will assist you to easily grasp each concept - from the fundamental to the most advanced aspects of the course. It really is a sure pathway to success. All our courses offer 12 months access and are designed to be studied at your own pace so you can take as much or as little time as you need to complete and gain the full CPD accredited qualification. And, there are no hidden fees or exam charges. We pride ourselves on having friendly and experienced instructors who provide full weekday support and are ready to help with any of your queries. So, if you need help, just drop them an email and await a speedy response. Furthermore, you can check the validity of your qualification and verify your certification on our website at anytime. So, why not improve your chances of gaining professional skills and better earning potential. Assessment and Certification 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. After you have successfully passed the final exam, you will be able to order an Accredited Certificate of Achievement at an additional cost of £19 for a PDF copy and £29 for an original print copy sent to you by post or for both £39. Career Path Not only does our CPD and CiQ accredited course look good on your CV, setting you apart from the competition, it can be used as a stepping stone to greater things. Further advance your learning, launch a new career or reinvigorate an existing one. On successful completion of this course, you have the potential to achieve an estimated salary of £35,000. The sky really is the limit. Course Curriculum Stress Management Basics What Is Stress? 00:30:00 Causes Of Stress 01:00:00 The Effects Of Stress 00:30:00 Recognise The Warning Signs 00:15:00 Lingering Stress 00:15:00 Stress And Panic Attacks 00:30:00 Solutions On Living A Stress-Free Life 01:30:00 Conclusion 00:15:00 Advanced Stress Management Introduction 00:15:00 Recognizing your stress Levels & triggers 01:00:00 Why do these changes occur frequently? 00:15:00 What does stress do to you? 00:15:00 Beware! Before seeking medical attention… 00:30:00 Medical stress solutions analyzing 00:30:00 The importance of stress management 01:00:00 Other things that might help in Stress Management 00:30:00 The Uses of Herbs and supplements in stress Management for stress relief 01:00:00 Conclusion 00:15:00 Mock Exam Mock Exam - Professional Diploma in Stress Management Strategy 00:20:00 Final Exam Final Exam - Professional Diploma in Stress Management Strategy 00:20:00

AAT Level 4 Professional Diploma in Accounting AAT Level 4 is the highest level or final stage of the AAT Accounting qualification. This qualification provides the skills necessary for a 'Finance Officer' role including the complex management accounting tasks, general management skills, drafting financial statements and specialist learning areas. This provides you with an opportunity to become a professional member of AAT and use MAAT after your name. You are also entitled to exemptions in the UK's chartered and certified accounting qualifications. Besides, if you want to pursue your career further in University, you are entitled to exemptions for up to two years in various universities in the UK. You will be awarded “AAT Level 4 Professional Diploma in Accounting certificate” from the Association of Accounting Technicians (AAT), once you have passed all the professional-level qualification exams and skill tests. Once you finish Level 4 you become a professional member of AAT and you may use MAAT after your name to stand out from the crowd as an officially Accredited Accountant. What you will gain? Here you'll learn how to draft financial statements for limited companies, perform complex management accounting tasks and develop your own management skills, perform tax calculation for business & individuals and other specialist learning areas. The Level 4 Professional Diploma in Accounting covers the following areas: Management Accounting: Budgeting Management Accounting: Decision and Control Financial Statements of Limited Companies Accounting Systems and Controls Business Tax Personal Tax

Level 3 QLS Endorsed | 120 CPD Points| +Gifts: QLS Certificate + PDF Certificate | Lifetime Access| 24/7 Learner Support

A 1 hour guide to building a Circle of Support around a disabled adult

This comprehensive course, 'SQL for Data Science, Data Analytics, and Data Visualization,' covers essential SQL concepts and tools for working with data. Participants will learn to manipulate, analyze, and visualize data using SQL Server, Azure Data Studio, and other relevant tools. The course also delves into advanced SQL commands, stored procedures, and data import/export, making it ideal for aspiring data professionals. Learning Outcomes: Set up and configure SQL Server and SQL Azure Data Studio for data analysis. Master SQL statements for data manipulation, data structure, and user management. Utilize SQL queries, joins, and aggregate functions for efficient data analysis. Understand SQL constraints, views, and advanced commands for in-depth data exploration. Create and implement SQL stored procedures to automate tasks. Leverage Azure Data Studio for data visualization and perform data analysis with SQL. Why buy this SQL for Data Science, Data Analytics and Data Visualization? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the SQL for Data Science, Data Analytics and Data Visualization there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This SQL for Data Science, Data Analytics and Data Visualization course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This SQL for Data Science, Data Analytics and Data Visualization does not require you to have any prior qualifications or experience. You can just enrol and start learning.This SQL for Data Science, Data Analytics and Data Visualization was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This SQL for Data Science, Data Analytics and Data Visualization is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Getting Started Introduction 00:03:00 How to get course requirements 00:03:00 Getting started on Windows, Linux or Docker 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 Section 02: SQL Server setting up Section Introduction 00:02:00 Microsoft SQL Server Installation 00:19:00 SQL Server Management Studio (SSMS) Installation 00:08:00 How to connect MS SQL (Windows Authentication) 00:04:00 How to connect MS SQL (SQL Server Authentication) 00:03:00 Download and Restore Sample Database 00:07:00 Section 03: SQL Azure Data Studio What is Azure Data Studio 00:06:00 Azure Data Studio Installation steps 00:07:00 Azure Data Studio to Connect SQL Server 00:09:00 Create a Database 00:07:00 Create a Table 00:09:00 Insert Data rows 00:07:00 View the Data returned by Query 00:03:00 Section 04: SQL Database basic SSMS Section Introduction 00:01:00 Overview of Databases8 00:11:00 Creating Database 00:05:00 SQL Data Types 00:03:00 Column Data Types on SSMS 00:04:00 Creating Table 00:09:00 Overview of Primary Key and Foreign Key 00:04:00 Primary Key 00:04:00 Foreign Key 00:07:00 Creating Temporary tables 00:06:00 Section 05: SQL Statements for DATA Section Introduction 00:01:00 Insert statement 00:08:00 Update statement 00:05:00 Delete statement 00:03:00 Section 06: SQL Data Structure statements Section Introduction 00:01:00 CREATE table statement 00:03:00 DROP statement 00:02:00 ALTER statement 00:05:00 TRUNCATE statement 00:04:00 COMMENT in query 00:01:00 RENAME 00:02:00 Section 07: SQL User Management Create Database user 00:04:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 08: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:07:00 SELECT DISTINCT 00:03:00 SELECT with column headings 00:03:00 Column AS statement 00:02:00 Section 09: Filtering Data rows SELECT WHERE Clause - theory 00:04:00 SELECT WHERE Clause - practical 00:07:00 Section 10: Aggregate functions Sum() 00:08:00 Min()-Max() 00:06:00 Section 11: SQL Query statements Order By statement 00:05:00 SELECT TOP clause in SQL 00:04:00 BETWEEN command 00:08:00 IN operator 00:04:00 Wildcard Characters and LIKE 00:05:00 Section 12: SQL Group by statement Section Introduction 00:01:00 Group by - theory8 00:03:00 Group by - practical 00:05:00 HAVING statement 00:04:00 Section 13: JOINS for Multiple table Data Analysis Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:08:00 Left outer join 00:03:00 Right outer join 00:02:00 Full outer join 00:01:00 Union 00:03:00 Cartesian Product with the Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 14: SQL Constraints Section introduction 00:01:00 Check constraint 00:07:00 NOT NULL constraint 00:08:00 UNIQUE constraint 00:05:00 Section 15: Views Creating Views 00:04:00 Reporting with multiple tables 00:03:00 Section 16: Advanced SQL commands Section Introduction 00:01:00 Timestamp 00:04:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:04:00 String functions 00:05:00 Sub Query 00:03:00 SELECT with calculations 00:06:00 Section 17: SQL Stored procedures Create stored procedure 00:05:00 Stored procedure with parameter 00:04:00 Section 18: Azure Data Studio Visualization Installing SandDance Extension 00:03:00 Visualization Charts 00:05:00 Multiple Table Data Charts 00:06:00 Section 19: Azure Studio SQL for Data Analysis Type Decision for Data Analysis 00:13:00 Data Analysis with Case Statement and String Text 00:09:00 Section 20: Import & Export data Section Introduction 00:01:00 Import Flat File 00:05:00 Import .csv or excel file 00:03:00 Export Data to Excel or any format 00:06:00 Section 21: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:04:00 Restoring Database backup 00:04:00