• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

43146 Courses in Bradford delivered Online

Weight Loss Management Course

By Online Training Academy

Are you tired of struggling with fad diets and endless exercise routines? Say goodbye to the frustration and hello to success with our comprehensive Weight Loss Management Course! Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In this course, learners will discover the significance of nutrition for weight loss and overall health. They will delve into the world of essential micronutrients and how they play a vital role in maintaining a balanced diet. Through exploring weight control management techniques, learners will grasp effective strategies for achieving and maintaining a healthy weight. They will also gain insights into various methods and approaches for managing weight loss effectively. Additionally, learners will learn about eating disorders, their causes, and potential treatments, fostering an understanding of how to support individuals facing such challenges. Finally, the course will cover diet and nutrition-related diseases, equipping learners with knowledge to prevent and manage these conditions through proper dietary choices. Overall, this curriculum empowers learners with essential knowledge and skills to navigate their weight loss journey and promote overall well-being. Course Curriculum Module 01: Importance of Nutrition Module 02: Micronutrients Module 03: Weight Control Management Module 04: Weight Loss Management Module 05: Eating Disorders Module 06: Diet and Nutrition related Diseases Learning Outcomes: Understand the significance of balanced nutrition for weight management strategies. Identify essential micronutrients crucial for maintaining optimal health and weight. Implement effective strategies for controlling and managing body weight. Utilize evidence-based techniques for successful weight loss management. Recognize common eating disorders and their impact on weight management. Demonstrate knowledge of diet and nutrition-related diseases prevention and management. CPD 10 CPD hours / points Accredited by CPD Quality Standards Weight Loss Management Course 1:09:50 1: Module 01: Importance of Nutrition 11:34 2: Module 02: Micronutrients 12:48 3: Module 03: Weight Control Management 10:30 4: Module 04: Weight Loss Management 11:46 5: Module 05: Eating Disorders 10:32 6: Module 06: Diet and Nutrition related Diseases 11:40 7: CPD Certificate - Free 01:00 Who is this course for? Individuals seeking comprehensive knowledge on nutrition and weight management. Healthcare professionals aiming to enhance their expertise in weight management. Fitness enthusiasts interested in understanding effective weight loss strategies. Nutritionists and dietitians looking to expand their proficiency in weight management. Anyone committed to achieving and maintaining a healthy body weight. Career path Nutrition Advisor Weight Management Consultant Dietitian Health Educator Wellness Coach Eating Disorder Specialist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Weight Loss Management Course
Delivered Online On Demand1 hour 12 minutes
£12

Fundamental of Genetics

By Online Training Academy

Dive into the fascinating world of genetics with our comprehensive online course, designed to equip you with essential knowledge and skills in genetic science. Whether you're a student, healthcare professional, or simply curious about how genes shape life, this course offers invaluable insights and practical applications. Key Features: CPD Certified Free Certificate from Reed CIQ Approved Developed by Specialist Lifetime Access In the "Fundamentals of Genetics" course, learners delve into the core principles and applications of genetics. They begin by understanding foundational genetic concepts, exploring how genes work and their role in inheritance. Moving forward, learners explore genetics in the context of genomics, studying how entire genomes contribute to traits and diseases. They then examine genetic disorders, learning about various conditions caused by genetic mutations and their implications. The course highlights practical applications of genetic knowledge, showing learners how genetics is used in fields like medicine, agriculture, and forensics. Finally, learners delve into genetic counseling, understanding how professionals help individuals and families understand and cope with genetic conditions. Throughout the course, learners gain a comprehensive understanding of genetics, from basic principles to real-world applications, preparing them to grasp the impact of genetics on both scientific advancements and everyday life. Course Curriculum Module 01: Fundamental Genetic Concept Module 02: Genetics and Genomics Module 03: Genetic Disorders Module 04: Application of Genetics Knowledge Module 05: Genetic Counselling Learning Outcomes: Understand fundamental genetic concepts and their practical applications. Analyse the role of genetics and genomics in modern research. Identify various genetic disorders and their underlying genetic mechanisms. Apply genetic knowledge to real-world scenarios and case studies. Explain the principles and processes involved in genetic counselling. Evaluate ethical and social implications related to genetic information. CPD 10 CPD hours / points Accredited by CPD Quality Standards Fundamental of Genetics 36:29 1: Module 01: Fundamental Genetic Concept 05:34 2: Module 02: Genetics and Genomics 05:59 3: Module 03: Genetic Disorders 07:46 4: Module 04: Application of Genetics Knowledge 09:07 5: Module 05: Genetic Counselling 07:03 6: CPD Certificate - Free 01:00 Who is this course for? Students pursuing biology or related sciences degrees. Healthcare professionals seeking genetics knowledge enhancement. Researchers exploring genetic aspects in their field. Educators teaching genetics at secondary or tertiary levels. Individuals interested in genetic counselling careers. Career path Geneticist Research Scientist Clinical Geneticist Genetic Counsellor Biomedical Scientist Pharmaceutical Geneticist Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Fundamental of Genetics
Delivered Online On Demand1 minutes
£12

Certificate on Child Attachment

By Online Training Academy

Key Features: CPD Certified Child Attachment Course Free Certificate from Reed CIQ Approved Child Attachment Course Developed by Specialist Lifetime Access Course Curriculum: Module 01: Introduction to Child Attachment Module 02: Introduction to Child Psychology Module 03: Fundamentals of Attachment Theory Module 04: Assessments of Attachment Module 05: Attachment Disorder Module 06: Attachment-Focused Parenting Module 07: Emotions and Mind-Mindedness Module 08: Interventions, Treatment and Support Learning Outcomes: Understand child attachment theories and their implications in psychology. Assess attachment patterns and recognise signs of attachment disorder. Implement attachment-focused parenting techniques for healthy child development. Analyse emotions and promote mind-mindedness in child-parent interactions. Apply interventions and support strategies to address attachment-related challenges effectively. CPD 10 CPD hours / points Accredited by CPD Quality Standards Certificate on Child Attachment 1:44:51 1: Module 01: Introduction to Child Attachment Preview 12:34 2: Module 02: Introduction to Child Psychology 20:42 3: Module 03: Fundamentals of Attachment Theory 14:06 4: Module 04: Assessments of Attachment 10:51 5: Module 05: Attachment Disorder 11:11 6: Module 06: Attachment-Focused Parenting 14:28 7: Module 07: Emotions and Mind-Mindedness 09:26 8: Module 08: Interventions, Treatment and Support 10:33 9: CPD Certificate - Free 01:00 Who is this course for? This Certificate on Child Attachment course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Certificate on Child Attachment. Moreover, this course is ideal for: Parents seeking deeper understanding of child attachment and psychology. Childcare professionals aiming to enhance their knowledge and skills. Teachers desiring insights into fostering secure attachments in educational settings. Social workers involved in child welfare and family support services. Mental health practitioners interested in attachment-focused interventions. Requirements There are no requirements needed to enrol into this Certificate on Child Attachment course. We welcome individuals from all backgrounds and levels of experience to enrol into this Certificate on Child Attachment course. Career path After finishing this Certificate on Child Attachment course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Certificate on Child Attachment are: Child Psychologist - £30K to 60K/year. Social Worker - £24K to 40K/year. Family Therapist - £32K to 50K/year. Mental Health Nurse - £24K to 40K/year. School Counsellor - £22K to 35K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Certificate on Child Attachment
Delivered Online On Demand1 hour 42 minutes
£12

Brainspotting: Trauma Treatment

By Online Training Academy

Key Features: CPD Certified Brainspotting: Trauma Treatment Course Free Certificate from Reed CIQ Approved Brainspotting: Trauma Treatment Course Developed by Specialist Lifetime Access Course Curriculum Module 01: Introduction to Brainspotting Module 02: The Brainspotting Process Module 03: Brainspotting Techniques Module 04: Integrating Brainspotting with Other Modalities Module 05: Applications of Brainspotting Module 06: Brainspotting in Diverse Populations Module 07: Ethical Considerations and Professional Development Learning Outcomes: Master the foundational principles of the Brainspotting approach with precision and insight. Demonstrate proficiency in applying the Brainspotting Process to trauma treatment scenarios. Explore and implement advanced Brainspotting Techniques for enhanced therapeutic outcomes. Navigate the seamless integration of Brainspotting with diverse therapeutic modalities. Apply Brainspotting across various populations with cultural competence and sensitivity. Cultivate ethical considerations and foster continuous professional growth in your practice. CPD 10 CPD hours / points Accredited by CPD Quality Standards Brainspotting: Trauma Treatment 1:46:11 1: Module 1: Introduction to Brainspotting Preview 10:00 2: Module 2: The Brainspotting Process 14:22 3: Module 3: Brainspotting Techniques 13:00 4: Module 4: Integrating Brainspotting with Other Modalities 15:08 5: Module 5: Applications of Brainspotting 19:21 6: Module 6: Brainspotting in Diverse Populations 16:18 7: Module 7: Ethical Considerations and Professional Development 17:02 8: CPD Certificate - Free 01:00 Who is this course for? This Brainspotting: Trauma Treatment course is accessible to anyone eager to learn more about this topic. Through this course, you'll gain a solid understanding of Brainspotting: Trauma Treatment. Moreover, this course is ideal for: Therapists seeking advanced trauma treatment techniques. Mental health professionals aiming to enhance their therapeutic repertoire. Counselors looking to deepen their understanding of trauma interventions. Psychologists dedicated to expanding their skills in trauma-focused therapies. Social workers committed to providing more effective trauma treatment. Requirements There are no requirements needed to enrol into this Brainspotting: Trauma Treatment course. We welcome individuals from all backgrounds and levels of experience to enrol into this Brainspotting: Trauma Treatment course. Career path After finishing this Brainspotting: Trauma Treatment course you will have multiple job opportunities waiting for you. Some of the following Job sectors of Brainspotting: Trauma Treatment are: Clinical Psychologist - £38K to £62K/year. Psychotherapist - £30K to £50K/year. Trauma Counsellor - £28K to £45K/year. Psychiatric Nurse - £25K to £42K/year. Social Worker - £25K to £40K/year. Certificates Digital certificate Digital certificate - Included Reed Courses Certificate of Completion Digital certificate - Included Will be downloadable when all lectures have been completed.

Brainspotting: Trauma Treatment
Delivered Online On Demand1 hour 48 minutes
£12

Fitness Business - Sell Products, Training & Coaching Online

4.9(27)

By Apex Learning

Overview This comprehensive course on Fitness Business - Sell Products, Training & Coaching Online will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Fitness Business - Sell Products, Training & Coaching Online 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 Fitness Business - Sell Products, Training & Coaching Online. It is available to all students, of all academic backgrounds. Requirements Our Fitness Business - Sell Products, Training & Coaching Online 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 9 sections • 44 lectures • 03:08:00 total length •Who this course is for: 00:02:00 •What you will learn: 00:03:00 •Fitness Business Models Overview: 00:02:00 •The Coaching Business Model: 00:04:00 •Selling Products Business Model: 00:06:00 •Affiliate Marketing Business Model: 00:06:00 •Fitness Sponsorships: 00:02:00 •The First Steps: 00:03:00 •Finding The Right Fitness Niche: 00:04:00 •How To Identify The Ideal Coaching Client: 00:05:00 •How To Identify Your Clients Pain Points: 00:03:00 •How To Become An Expert: 00:04:00 •Understand What You Are Selling: 00:01:00 •Creating Your First Fitness Information Product: 00:07:00 •MVP - Minimal Viable Product: 00:03:00 •Creating Your First Workout Routine / Diet Plan: 00:04:00 •Writing Your First Fitness eBook: 00:06:00 •Recording Your First Fitness Video Course: 00:06:00 •Creating A Coaching Offer: 00:03:00 •Overview: 00:02:00 •Most Common Fitness Marketing Mistakes: 00:04:00 •Setting SMART Marketing Goals: 00:07:00 •Crafting A Stong Marketing Message: 00:06:00 •Choosing The Right Marketing Channel: 00:08:00 •Email Marketing For Your Product: 00:03:00 •How To Build An Email List: 00:03:00 •Your First Autoresponder Series: 00:10:00 •How To Build The Perfect Lead Magnet: 00:05:00 •How To Use WordPress For Your Fitness Business: 00:08:00 •Installing WordPress: 00:05:00 •Building A Landing Page: 00:06:00 •Building A Thank You Page: 00:03:00 •Starting A Niche Youtube Channel: 00:05:00 •Keyword Research For Youtube: 00:04:00 •My Youtube Content Strategy: 00:04:00 •How To Set Up Your First Lead Ad In Facebook: 00:06:00 •Affiliate Marketing Overview: 00:01:00 •Writing Blog Posts With Affiliate Links: 00:04:00 •Making Affiliate Sales With Youtube Videos: 00:03:00 •Motivation Intro: 00:01:00 •How To Deal With Difficult Customers / Clients: 00:03:00 •How To Deal With Email Overload: 00:04:00 •How To Develop The Mindset Of An Entrepreneur: 00:04:00 •How To Not Lose Track Of Your Business Goals: 00:05:00

Fitness Business - Sell Products, Training & Coaching Online
Delivered Online On Demand3 hours 8 minutes
£12

Teaching Assistant Complete Course (TA, SEN, Autism, ADHD & Dyslexia) - CPD Certified

4.7(160)

By Janets

Learning Outcomes Familiarise yourself with the duties of a teaching assistant Learn the essentials of curriculum development, monitoring and assessment Build your expertise in providing learning support to SEN students Enrich your understanding of SEN teaching methodologies Know the strategies to support students with dyslexia Develop the skills to deal with students with ADHD and Autism Teaching Assistant Complete Course Description The role of a teaching assistant has many folds. Learn how to fulfil each duty with proficiency from the Teaching Assistant Complete Course (TA, SEN, Autism, ADHD & Dyslexia) - CPD Certified course. This course is designed for both future and current TAs to help develop their expertise in this area. In this comprehensive online training, you will get introduced to the responsibilities of a teaching assistant. The course will show you how to create the perfect learning environment for the students. Furthermore, you will receive detailed lessons on SEN students and how to assist them. Here, you will get to learn about different effective SEN teaching methods. The course will also help you enhance your understanding of ADHD and dyslexia. By the end of this course, you will acquire the skills to support children with Autism. After completing the course you will receive a QLS- Endorsed certificate of achievement. This certificate will uplift your resume and boost your employability. Enrol today! Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Upon successful completion of the final assessment, you will be eligible to apply for the Quality Licence Scheme Endorsed Certificate of achievement. This certificate will be delivered to your doorstep through the post for £119. An extra £10 postage charge will be required for students leaving overseas.  CPD Accredited Certificate After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment At the end of the course, there will be an online MCQ assessment. In order to pass this exam, you must score at least 60%. When you submit the assessment, you will get the results immediately and can apply for your QLS- endorsed certificate. Career path This Teaching Assistant Complete Course is designed to help you extant your knowledge and understanding of this sector. After completing the course, you will be able to explore career options such as Teacher Teaching Assistant SEN Teacher Support Worker Course Contents Teaching Assistants SEN Support Training for Teaching Assistants Autism ADHD Dyslexia

Teaching Assistant Complete Course (TA, SEN, Autism, ADHD & Dyslexia) - CPD Certified
Delivered Online On Demand5 weeks
£9.99

Mental Health Care in Health & Social Care Settings

4.7(160)

By Janets

The Mental Health Care in Health & Social Care Settings is a wonderful learning opportunity for anyone who has a passion for this topic and is interested in enjoying a long career in the relevant industry. It's also for anyone who is already working in this field and looking to brush up their knowledge and boost their career with an acknowledged certificate. This Mental Health Care in Health & Social Care Settings consists of several modules that take around 3 hours to complete. The course is accompanied by instructional videos, helpful illustrations, how-to instructions and advice. The course is offered online at a very affordable price. That gives you the ability to study at your own pace in the comfort of your home. You can access the modules from anywhere and from any device. Please note: This course only gives you the theoretical knowledge that you need to excel in this field. This Mental Health Care in Health & Social Care Settings doesn't entitle you to practise as an expert in this specific field. Why choose this course Earn an e-certificate upon successful completion. Accessible, informative modules taught by expert instructors Study in your own time, at your own pace, through your computer tablet or mobile device Benefit from instant feedback through mock exams and multiple-choice assessments Get 24/7 help or advice from our email and live chat teams Full Tutor Support on Weekdays Course Design The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of Video lessons Online study materials Mock exams Multiple-choice assessment Certificate of Achievement Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £69. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Endorsement This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Method of Assessment In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. Course Content Mental Health Care in Health & Social Care Settings Mental Health Basics 00:30:00 Are you Resilient? 00:30:00 Take Good Care of Yourself 00:30:00 Healthy Relationships 00:30:00 Risk Factors 00:30:00 When Do You Need to See a Professional? 00:30:00 Assignment Assignment - Mental Health Care In Health & Social Care Settings 6 days, 3 hours Order Your Certificate Order your Certificate QLS 00:00:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

Mental Health Care in Health & Social Care Settings
Delivered Online On Demand7 days
£25

SQL For Data Analytics & Database Development

4.5(3)

By Studyhub UK

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development 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 SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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 Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00

SQL For Data Analytics & Database Development
Delivered Online On Demand7 hours 50 minutes
£10.99

Mushroom Growing Course

By Imperial Academy

Level 5 QLS Endorsed Course | CPD & CiQ Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

Mushroom Growing Course
Delivered Online On Demand
£12

Fire Risk Assessor QLS Training

By Imperial Academy

Level 3 QLS Endorsed Course | CPD Accredited | Audio Visual Training | Free PDF Certificate | Lifetime Access

Fire Risk Assessor QLS Training
Delivered Online On Demand
£12