- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
Mental Capacity Training
By The Teachers Training
Empower yourself with essential knowledge and skills in our Mental Capacity Training Course. Learn about assessing mental capacity, understanding legal frameworks, and making decisions on behalf of others. Gain insights into supporting individuals with impaired capacity in a respectful and ethical manner. Whether you're a healthcare professional, caregiver, or legal practitioner, this course provides valuable expertise in navigating complex issues surrounding mental capacity.
With the help of our extensive 'CBT Practitioner' course, take a revolutionary step into the field of cognitive wellness. In just a blink, our succinct Introduction sets the stage, inviting you into the realms of this therapeutic art. Delve into Lesson 1.1 as we unravel the nuanced 'Definition of Concept' in a swift 5-minute session, laying the foundation for your CBT expertise. Traverse the intricate landscape of Lesson 1.2's '4 Factor Model,' discovering the keys to client understanding. With each lesson, from the dynamic exploration of client strengths and weaknesses to the artistry of structuring a CBT session in Lesson 1.5, this course is a symphony of knowledge, finely tuned to empower you as a CBT practitioner. Journey deeper into Lesson 2, where the intricacies of identifying triggers, feelings, physical reactions, and thoughts unfold like chapters in a gripping novel. Brace yourself for the transformative experience of cognitive restructuring and problem-solving in Lessons 3.1 to 3.4. The final crescendo leads you through behavioral activation and exposure therapy, equipping you with the skills to catalyze positive change. This course isn't just education; it's a roadmap to becoming a proficient CBT Practitioner, where every lesson is a stepping stone towards mastery. Learning Outcomes Define and articulate the concept of Cognitive Behavioral Therapy. Apply the 4 Factor Model for a holistic understanding of client dynamics. Demonstrate the skill of identifying triggers, feelings, physical reactions, and thoughts. Execute cognitive restructuring and problem-solving techniques effectively. Implement behavioral activation and exposure therapy for comprehensive client care. Why choose this CBT Practitioner course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this CBT Practitioner course for? Aspiring mental health professionals seeking CBT specialization. Psychology students desiring practical skills in client engagement. Counselors and therapists enhancing their toolkit with evidence-based practices. Individuals passionate about fostering positive behavioral change in themselves and others. Professionals aiming to contribute to mental wellness in various contexts. Career path CBT Practitioner: £30,000 - £50,000 Clinical Psychologist: £40,000 - £70,000 Counseling Therapist: £28,000 - £45,000 Behavioral Health Specialist: £35,000 - £55,000 Psychotherapist: £30,000 - £50,000 Mental Health Consultant: £35,000 - £60,000 Prerequisites This CBT Practitioner does not require you to have any prior qualifications or experience. You can just enrol and start learning. This CBT Practitioner 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum CBT Practitioner Introdution and overview 00:02:00 Lesson 1.1: Definition of Concept 00:05:00 Lesson 1.2: 4 Factor model 00:05:00 Lesson 1.3: Client strength+weakness 00:05:00 Lesson 1.4: Developing Goals 00:05:00 Lesson 1.5: structuring CBT session 00:05:00 Lesson 2.1: Identifying triggers 00:05:00 Lesson 2.2: Identifying feelings 00:05:00 Lesson 2.3: Identifying physical reactions 00:05:00 Lesson 2.4: Identifying thought part 1 00:05:00 Lesson 3.1: Cognitive restructuring part 1 00:05:00 Lesson 3.2: Cognitive restructuring part 2 00:05:00 Lesson 3.3: Problem solving part 1 00:05:00 Lesson 3.4: Problem Solving Part 2 00:05:00 Lesson 3.5: Behavioural Activation Part 1 00:05:00 Lesson 3.6: Behavioural activation part 2 00:05:00 Lesson 3.7: Exposure therapy part 1 00:05:00 Lesson 3.8: Exposure therapy part 2 00:05:00 Conclusion 00:02:00
Are you ready to unravel the mysteries of numbers? Dive into our compelling Financial Modelling at QLS Level 3 course and be at the heart of smart business decisions. Financial models don't just predict the future; they shape it. Our introduction lets you grasp this powerful tool's essence, preparing you for the exhilarating journey ahead. As you immerse deeper, you'll befriend a restaurant. Not just any restaurant, but one that becomes your canvas to paint financial concepts on. From the hustle of acquiring customers to the nitty-gritty of costs, the case study becomes your guide, blending theory with tangible examples. Learning Outcomes Understand the core principles and applications of financial modelling. Develop financial models anchored in real-world scenarios, using the case study approach. Gain proficiency in customer acquisition, revenue, and cost modelling. Master the intricacies of the three financial statement models. Acquire the skills to identify and rectify errors in financial models. Why choose this Financial Modelling at QLS Level 3 course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Financial Modelling at QLS Level 3 course for? Aspiring financial analysts keen to bolster their modelling expertise. Business owners aiming to gain insights into their company's financial health. Finance students looking to apply theoretical knowledge in practical scenarios. Investment bankers and consultants seeking to refine their financial modelling skills. Professionals in corporate finance aiming to understand business financials better. Career path Financial Analyst: £30,000 - £55,000 Investment Banker: £50,000 - £100,000+ Business Valuation Consultant: £40,000 - £70,000 Corporate Finance Manager: £60,000 - £90,000 Equity Research Analyst: £35,000 - £65,000 Financial Consultant: £40,000 - £75,000 Prerequisites This Financial Modelling at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Financial Modelling at QLS Level 3 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Section 01: Introduction Introduction to the course 00:02:00 Introducton to the Business Priocess 00:03:00 What is Financial Modelling 00:08:00 Starting Point of a Financial Model 00:04:00 First Steps before Starting to create Financial Model and Linking Business Model 00:07:00 Section 02: Case Study: Restaurant - Basic Model for Selecting Initial Idea Starting with End in Mind-Comparative P&L 00:13:00 Customer Acquisition Model 00:16:00 Revenue and Cost Models 00:22:00 Adding Product and Modelling Labour and Other Costs 00:21:00 Modelling Capital Investments and ROI Calc 00:10:00 Case Study: Restaurant - Basic Model for Selecting Initial Idea 00:00:00 Section 03: Business Plan and 3 Financial Statement Models Detailed Customer Acquisition Model and Revenue Model 00:17:00 Cost of Sale Model 00:08:00 Modelling Labour Cost 00:07:00 Modelling Other Operating Expenses 00:14:00 Modelling Balance Sheet 00:14:00 Fixing the Error in Financial Model and Brief of RR 00:07:00 Financial Model for Business plan for New Business 00:00:00 Assignment Assignment - Financial Modelling at QLS Level 3 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00
Embark on the 'Chef Training Certificate' journey to transform your culinary passion into a prestigious career. This course transcends mere recipe learning, offering a deep dive into cooking mastery, from essential knife skills to crafting diverse, intricate dishes. It's a comprehensive pathway to becoming a culinary expert, encompassing everything from pastry chef intricacies to the rigorous chef training courses in the UK. As you progress, you'll engage in continuous learning and adapt to the dynamic demands of being a chef, including perfecting saucier skills, choosing specialties, and understanding restaurant management. This UK-based program equips you with a diverse skill set, preparing you for a successful career in the ever-changing culinary world, shaping you from an enthusiast to a professional chef. Learning Outcomes Acquire comprehensive knowledge of cooking techniques and food preparation skills. Develop expertise in catering to diverse taste preferences and dietary requirements. Master the art of using kitchen equipment efficiently and safely. Gain insights into the business aspects of culinary arts, including restaurant management. Enhance creativity in meal presentation and recipe innovation. Why buy this Chef Training Certificate? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Chef Training Certificate 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 Chef Training Certificate course for? Aspiring chefs seeking foundational and advanced culinary skills. Culinary enthusiasts aiming to professionalize their cooking abilities. Individuals interested in specializing in pastry or gourmet cuisine. Career changers exploring opportunities in the culinary industry. Hospitality professionals looking to expand their culinary expertise. Prerequisites This Chef Training Certificate does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Chef Training Certificate 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 Head Chef: £28,000 - £55,000 Per Annum Pastry Chef: £20,000 - £35,000 Per Annum Sous Chef: £22,000 - £30,000 Per Annum Catering Manager: £25,000 - £40,000 Per Annum Food Stylist: £20,000 - £45,000 Per Annum Restaurant Manager: £24,000 - £50,000 Per Annum Course Curriculum Cooking (Chef) Course Can TV Chefs Teach You To Cook? 00:05:00 Improving Cooking And Food Preparation Skills 00:05:00 Catering To Unique Tastes 00:30:00 Qualities Of A Successful Chef 00:30:00 Achieve Perfection As A Saucier 00:05:00 Becoming The Perfect Chef 00:25:00 Equipment For Perfect Chefs 00:15:00 How To Become The Perfect Chef: Attending School 00:05:00 The Keys To Getting and Using Feedback 00:05:00 What Can You Do With A Culinary Degree 00:20:00 Knife Skills For The Perfect Chef 00:10:00 Making Meals Easy to Eat Healthy 00:05:00 Plating for the At Home Chef 00:10:00 Perfect Chefs Choose A Speciality 00:05:00 Finding Local Cooking Classes 00:05:00 How Can You Become a Professional Chef 00:10:00 The Physical Qualities of the Perfect Chef 00:05:00 The Importance of Testing Recipes 00:05:00 The Chefs Important Baking Tools 00:25:00 The Learning Curve To Becoming The Perfect Chef 00:05:00 The Job of a Professional Chef 00:05:00 The Mix of Sweet, Spicy and Savory 00:05:00 The Perfect At Home Chef 00:10:00 The Perfect Chef Opens A Restaurant 00:05:00 The Physical Demand of Being a Chef 00:05:00 Recipes Recipe - I 00:10:00 Recipe - II 00:10:00 Recipe - III 01:00:00 Recipe - IV 00:10:00 Recipe - V 00:10:00 Recipe - VI 00:10:00 Recipe - VII 00:10:00 Recipe - VIII 00:10:00 Recipe - IX 00:10:00 Recipe - X 00:10:00 Recipe - XI 00:10:00 Recipe - XII 00:15:00 Recipe - XIII 00:10:00 Recipe - XIV 00:10:00 Recipe - XV 00:00:00 Recipe - XVI 00:10:00 Recipe -XVIII 00:10:00 Recipe -XVIII 00:10:00 Recipe -XIX 00:10:00 Recipe -XX 00:10:00 Recipe-XXI 00:10:00 Recipe-XXII 00:10:00 Recipe-XXIII 00:10:00 Recipe-XXIV 00:10:00 Recipe-XXV 01:00:00 Recipe-XXVI 01:00:00 Recipe-XXVII 01:00:00 Recipe-XXVIII 01:00:00 Recipe-XXIX 01:00:00 Recipe-XXX 01:00:00 Recipe-XXXI 01:00:00 Recipe-XXXII 01:00:00 Recipe-XXXIII 01:00:00 Recipe-XXXIV 01:00:00 Recipe-XXXV 01:00:00 Recipe-XXXVI 01:00:00 Recommended Reading Recommended Reading : Chef Training Certificate 00:00:00 Assignment Assignment - Chef Training Certificate 00:00:00
This Level 2 Food Hygiene and Safety for Catering course has been designed to help you improve your knowledge of handling food in a catering environment. You will discover the legal requirements to prepare and serve food in the service industry. You will also discover HACCP, the multiple levels of hazards and their preventive measures, and much more including temperature control and handling basics. Knowledge and understanding of basic food hygiene and safety is a legal requirement so as not to contaminate food and to be safe at work at all times. The course provides learners with up-to-date food hygiene information using a range of written text, and video content to ensure learners thoroughly comprehend their food safety responsibilities. Who is the course for? All food handlers are required by European Union Regulation laws to go through an orientation training prior to starting a food handling job. This Level 2 Certificate in Food Hygiene and Safety for Catering course allows readers to learn about the basic food hygiene practices in order to be able to comply with all the legal requirements. This course is suitable for food handlers in any sector including fast-food outlets, takeaways, food trucks, bars, restaurants, hotels, cafes, hospitals, schools and colleges. 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 & Certification: Once you complete all the lessons/units, you are required to sit an exam which is multiple-choice. The pass mark is 60%. After successfully passing the exam you can obtain your certificate of achievement at an additional cost of £9. 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: Level 2 Certificate in Food Hygiene and Safety for Catering is a useful qualification to possess and would be beneficial for any professions or career from any industry you are in such as: Restaurateurs Hospitality managers Chefs Hotel and restaurant service staff Professional hygiene and safety officer. Food Hygiene and Safety for Catering Introduction to Food Safety and the Law 00:30:00 Bacteria and Microbiological Hazards 00:27:00 Physical, Chemical and Allergenic Hazards 00:25:00 Food Poisoning and Control Measures 00:23:00 Food Spoilage and Food Storage 00:25:00 Personal Hygiene 00:24:00 HACCP and Food Premises Part-01 00:27:00 HACCP and Food Premises Part -02 00:26:00 Cleaning 00:20:00 Mock Exam Mock Exam - Level 2 Certificate in Food Hygiene and Safety for Catering 00:20:00 Final Exam Final Exam - Level 2 Certificate in Food Hygiene and Safety for Catering 00:20:00 Refer A Friend Refer A Friend 00:00:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
The key to happiness is the capacity to control your feelings and know how to control the way you think. In this course, you will be learning what mindfulness means, and you could use it. You will also be introduced to cognitive restructuring and how to use it in the real world. Moreover, you will learn about stress and flow states that can be a hindrance in your peaceful thinking. You will also learn how to visualize and the importance of it. Thus, in this course, you will surely be able to know the power of mindfulness and how it can affect your life. Who is the course for? Professionals who are helping people build their personal goals People who have an interest in the personal development concepts 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 a cost of £39 or in PDF format at a 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: The Power of Mindfulness is a useful qualification to possess, and would be beneficial for the following careers: Career Coach Guidance Counsellors Life Coach Mentors Psychologists. The Power of Mindfulness Introduction 00:15:00 What is Mindfulness? 01:00:00 Starting Your Mindfulness Using Meditation 01:00:00 Introducing Cognitive Restructuring 00:30:00 How to Use Cognitive Restructuring in the Real World 00:30:00 Stress and Flow States 01:00:00 Why You Should Visualize 01:00:00 The Power of Belief 00:30:00 Conclusions 00:30:00 Mock Exam Mock Exam- The Power of Mindfulness 00:20:00 Final Exam Final Exam- The Power of Mindfulness 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics? 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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00
