- Professional Development
- Medicine & Nursing
- Arts & Crafts
- Health & Wellbeing
- Personal Development
5266 Courses delivered Online
Course Overview: Imagine the power of interacting with databases, organising vast information, and extracting valuable insights - all at your fingertips. This might seem like a formidable task, but SQL, or Structured Query Language, brings this within reach. It is one of the most in-demand skills in the tech industry, with a projected 10% job growth rate over the next decade. Our course, The Complete SQL from Scratch: Bootcamp, provides a thorough understanding of SQL, irrespective of your prior familiarity with it. This comprehensive course walks you through the journey from the fundamentals of databases to the intricate functionalities of SQL. The curriculum includes detailed discussions on database creation, table manipulation, SQL statements, and utilisation of various operators. Moreover, it also covers essential operations like data backup and restoration, thus preparing learners for real-life database management scenarios. The course design ensures a smooth transition from one concept to another, enabling learners to solidify their understanding at each step. Enrol today and start learning SQL! Key Features of the Course: CPD certificate: Upon completion of the course, you'll receive a CPD certificate that you can use to demonstrate your skills to employers. 24/7 Learning Assistance: Our team of experts is available 24/7 to answer your questions and help you progress through the course. Interesting learning materials: The course is packed with engaging videos, interactive exercises, and quizzes to help you learn SQL in a fun and effective way. Who is This Course For? The Complete SQL from Scratch: Bootcamp course is suitable for anyone interested in diving into the world of databases or enhancing their skills further. Beginners with no prior knowledge and professionals seeking an in-depth understanding of SQL would equally benefit from the course. What You Will Learn: Through The Complete SQL from Scratch: Bootcamp , you will learn: An in-depth understanding of databases and their functions. Familiarity with PostgreSQL installation and various connections. Proficiency in manipulating data including insert, update, delete operations. A comprehensive grasp of complex SQL commands and queries. Skills to design and alter table structures using SQL scripts. Advanced knowledge about SQL statements, their structure, and usage. Competence in data backup and restoration in databases. Why Enrol in This Course: The Complete SQL from Scratch: Bootcamp course is reviewed as a top choice among learners, and is recently updated to match the trending industry needs. By enrolling, you will acquire a set of skills that are crucial in today's data-centric world, enhancing your employability and competitive edge. Requirements: No prior experience is required A computer with internet access Career Path: Database Administrator (average UK salary £47,000) Data Analyst (£40,000), Business Analyst (£43,000) SQL Developer (£45,000) Database Engineer (£48,000) Systems Analyst (£41,000) Data Architect (£62,000). Certification: After successfully completing the course, you will receive a CPD certificate, signifying your expertise in SQL. This course is your stepping stone to becoming a proficient database professional. Enrol and Lets get started! Course Curriculum 12 sections • 56 lectures • 06:39:00 total length •Introduction: 00:04:00 •Course Curriculum overview: 00:04:00 •Overview of Databases: 00:08:00 •PostgreSQL Installation: 00:13:00 •Connecting to PostgreSQL using psql: 00:04:00 •Connecting to PostgreSQL using PgAdmin: 00:07:00 •Basic of Database and Tables: 00:06:00 •Data Types: 00:07:00 •Primary Keys and Foreign Keys: 00:04:00 •Create Table in SQL Script: 00:17:00 •Insert: 00:05:00 •Update: 00:05:00 •Delete: 00:03:00 •Alter Table: 00:05:00 •Drop Table: 00:02:00 •Check Constraint: 00:12:00 •NOT NULL Constraint: 00:04:00 •UNIQUE Constraint: 00:06:00 •Overview of Challenges: 00:04:00 •SQL Statement Basic: 00:07:00 •SELECT Statement: 00:12:00 •SELECT DISTINCT: 00:10:00 •Column AS Statement: 00:07:00 •COUNT: 00:07:00 •SELECT WHERE Clause - One: 00:06:00 •SELECT WHERE Clause - Two: 00:11:00 •ORDER: 00:05:00 •LIMIT: 00:04:00 •BETWEEN keyword usage on real time: 00:08:00 •IN Operator: 00:06:00 •LIKE and ILIKE: 00:10:00 •Overview of GROUP BY: 00:03:00 •Aggregation Function: 00:12:00 •GROUP BY - One: 00:05:00 •GROUP BY - Two: 00:06:00 •HAVING on SQL Statement: 00:04:00 •Overview of JOINS: 00:07:00 •Introduction to JOINS: 00:06:00 •AS Statement table: 00:05:00 •INNER Joins: 00:14:00 •Full Outer Joins: 00:04:00 •Left Outer join: 00:03:00 •Right Outer Join: 00:05:00 •Union: 00:05:00 •Basic of Advanced SQL Commands: 00:04:00 •Timestamps: 00:17:00 •Extract from Timestamp: 00:05:00 •Mathematical Functions: 00:06:00 •String Functions: 00:16:00 •SubQuery: 00:08:00 •Overview of Databases and Tables: 00:02:00 •Creating a Database backup: 00:03:00 •Restoring a Database from backup: 00:04:00 •Overview Assessment Test: 00:02:00 •Mock Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00 •Final Exam - The Complete SQL from Scratch: Bootcamp: 00:20:00
Social Science Diploma Course
By The Teachers Training
Embark on a comprehensive exploration of social sciences with our Diploma Course. Dive deep into diverse disciplines such as sociology, psychology, anthropology, and more. Gain valuable insights into human behavior, societal structures, and cultural dynamics. Whether you're a student, professional, or enthusiast, this course equips you with essential knowledge and critical thinking skills to navigate the complexities of the social world. Enroll now and embark on a rewarding journey of discovery in the realm of social sciences.
When you're looking at a successful restaurant, you're also looking at a well-organized management system. Without proper knowledge of managing every sector of the business, it's doomed to fail. This is one of the best food business management courses which covers a broad range of topics from how to decide and design on the concept to maintain the insurance policy. After finishing, you'll have a wealth of knowledge in various topics related to this field. You'll be able to write a solid business plan and make the right strategy for your business. You'll also have some heads up about your upcoming challenges and will learn how to tackle them efficiently. This course will also provide you with some real-life success stories and discuss how they did it. Why Choose this Course? Get a Food and Beverage Manager Training Diploma E-Certificate upon successful completion for free. 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 Food and Beverage Manager course is delivered through our online learning platform, accessible through any internet-connected device. No formal deadlines or teaching schedules are included, providing a flexible study plan. We broke down the course into several manageable modules which we believe will assist you to grasp each concept more efficiently - from the fundamentals to the most advanced aspects of the course. The experts will teach you through a combination of: Video tutoring Online study supplies Mock tests Multiple-choice evaluation Certification After completing the Food and Beverage Manager course successfully, you'll get an e-certificate without any cost. If you desire a print copy of the certificate, we can send it to you by post. For this, you will need to pay a minute amount of additional cost, which is £9.99 and PDF Certificate is available at £4.99. Who is this course for? The Food and Beverage Manager course is suitable for anyone who wants to gain extensive knowledge, potential experience, and professional skills in the related field. Industry experts designed this course, so you don't have to worry about the quality. Most importantly, this course does not require any experience or qualification to get enrolled. You will learn everything that is needed from this complete Food and Beverage Manager course. This is an excellent opportunity for anyone to learn more and advance their learning skills, launch a new career or reinvigorate an existing one.
Discover the secrets to achieving peak performance in sports with our Sports Psychology Course. Learn essential principles, coaching techniques, and strategies to enhance mental toughness and wellbeing in athletes. Ideal for aspiring sports psychologists, coaches, and athletes. Enrol today and take your sporting career to new heights!
Description: The Diploma in Perseverance course will equip you with the appropriate skills in your life. This course covers the perseverance methods as well as the knowledge, information and strategies of perseverance in many aspects of your life including getting through school, raising children, build a house, dieting, travelling, dealing with death, living longer, living with parents, finding direction in life, staying healthy, studies, getting the dream job, your love, habits, getting out of debt, making money and many other aspects of your life. This course will teach you the appropriate perseverance methods and skills required in most important steps in your life. Who is the course for? Anyone who want to assess how effective a goal will be in driving perseverance in any scenario and want to identify the key obstacle to achieving a goal. People who want to develop their abilities in managing setbacks, challenges, or obstacles in their work. 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 recognised 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 Diploma in Perseverance course will be very beneficial and helpful, especially to health and sport-minded people like: Businessmen Company Employees Fitness Instructor Personal Trainer Sports Administrator Wellness Coach And Much More! Module 01 How to have Perseverance to get through school 00:30:00 How to have Perseverance to build a house 01:00:00 How to use Perseverance and dieting 01:00:00 How to use Perseverance while traveling 00:30:00 How to use Perseverance and working at night 00:30:00 How to use Perseverance and staying in Night College 00:30:00 How to use Perseverance and raising children 01:00:00 Using Perseverance and dealing with death 01:00:00 Perseverance methods 00:30:00 Module 02 Perseverance teachings for your life 01:00:00 Perseverance and learning to dance 01:00:00 Perseverance and dealing with your parents living with you 00:30:00 Perseverance - the meaning of 01:00:00 Perseverance to keep healthy 00:30:00 Perseverance to want to live longer 01:00:00 Perseverance to find direction in life 00:30:00 Perseverance to help your children find love in their life 00:30:00 Perseverance to avoid money problems 01:00:00 Module 03 Perseverance to teach obedience in children 00:30:00 Perseverance and your pride 01:00:00 Perseverance and finding that perfect house 02:00:00 using perseverance and sports to get ahead 01:00:00 using perseverance and grades to get scholarships 00:30:00 using perseverance to keep up on your studies 00:30:00 five methods of using perseverance in disciplining your children 00:30:00 Five methods of using perseverance to get the job you want 01:00:00 Module 04 You can push yourself hard to go forward and become a success 00:30:00 five methods of using perseverance to learn something new daily 01:00:00 five methods of using perseverance to get along with someone you don't like 00:30:00 three methods of perseverance methods for your pride 00:30:00 Three methods of perseverance methods for finding love in life 00:30:00 Three methods of perseverance for self confidence building 00:30:00 Three methods of perseverance for controlling your habits 00:30:00 Three methods of perseverance for continuing with school 00:30:00 Three methods of perseverance to get out of debt 00:30:00 Module 05 Five methods of perseverance to put more time in your day 01:00:00 Five methods of perseverance to clean the clutter from your life 00:30:00 Perseverance to make millions 01:00:00 Perseverance to make more money 00:30:00 Perseverance to get through hard times 00:30:00 Perseverance to get through the pain of life 00:30:00 Perseverance to build a better life 01:00:00 How to have Perseverance after the birth of a child 01:00:00 Perseverance to do more in life than just get by 00:30:00 Perseverance to become more than you were before 01:00:00 Perseverance to build more fun into your life 00:30:00 Mock Exam Mock Exam- Diploma in Perseverance 00:20:00 Final Exam Final Exam- Diploma in Perseverance 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
Description: Family support workers are social services professionals who provide assistance and guidance to children and families in need. They work in settings such as foster care or adoption agencies, child protective services agencies or family services organizations. The Family Support Worker Course aims to provide great insight into the skills and knowledge related to working with children and families. This course will discuss the key skills and knowledge related to working with families, identifying and resolving family difficulties, safeguarding in the home and more. This course will provide a great insight into this field of study with the use of practical examples throughout the course. Whether working in this field already, you want to get started working in within the field of family support work, or just interested in this field of study, this course will cover a range of modules and provide multiple examples for assessment. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. 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. Who is this Course for? Family Support Worker Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Family Support Worker Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. 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. Module 1 - The role of family support worker The functions, work environment, and daily activities of a family support worker 00:15:00 The key responsibilities of a family support worker and different specialisations 00:15:00 The key qualities of a family support worker and what a family support worker should expect 00:15:00 Duties as a family support worker 00:15:00 Professional development, career prospects, and anticipated salary as a family support worker 00:05:00 A day in the life of a family support worker 00:15:00 Pros and cons of being a family support worker 00:05:00 Work-life balance as a family support worker 00:15:00 Top tips for family support workers 00:05:00 Module 2 - Legislation, policy, and guidance Introduction to legislation, policy, and guidance 00:05:00 Overview of legislation - England 00:15:00 The Children and Families Act 2014 00:30:00 Policy and guidance - England 00:15:00 Overview of legislation - Scotland 00:05:00 Policy and guidance - Scotland 00:15:00 Overview of legislation - Northern Ireland 00:05:00 Policy and guidance - Northern Ireland 00:05:00 Overview of legislation - Wales 00:05:00 Policy and guidance - Wales 00:05:00 Module 3 - The family issues and solving them Parental mental health - how to help children living with parents with mental health problems 00:15:00 Parental mental health - assessing the risk of mental health problems 00:05:00 Parental mental health - intervention and support for children and families 00:15:00 Parental substance misuse - how to help children living with parents who misuse alcohol and drugs 00:05:00 Parental substance misuse - assessing the risk of parental alcohol and drug misuse 00:05:00 Parental substance misuse - intervention and support for children and families 00:05:00 Domestic abuse - what is domestic abuse? 00:05:00 Separation, divorce, and parental responsibility 00:05:00 Separation, divorce, and contact 00:05:00 General advice on talking about difficult topics 00:15:00 Books to help talking about difficult topics 00:15:00 Module 4 - Safeguarding - assessing need and providing help Introduction to safeguarding - a child-centred, coordinated approach 00:30:00 Early help 00:30:00 Access, referral, and information sharing 00:30:00 Disabled children, carers, youth establishments, and contextual safeguarding 00:15:00 Assessment purpose, protocols, principles, and parameters 00:15:00 Analysis, outcomes, and timeliness 00:30:00 Processes for managing individual Part 1 00:30:00 Processes for managing individual Part 2 00:15:00 Processes for managing individual Part 3 00:15:00 Module 5 - Building relationships Types of family and what makes healthy families 00:15:00 Why relationships are key to good social work 00:30:00 The importance of relationships in social work to relationships in social work 00:30:00 The personal qualities required for relationship building 00:15:00 Working on empathy to build relationships 00:15:00 The professional attributes required for relationship building 00:15:00 Self-knowledge and professional use of self in relationship building 00:15:00 Taking an individualised approach, involving the parents, what parents want from the relationship, sharing information, and building trust 00:30:00 Challenges in relationship building 00:15:00 The difference between getting the relationship right and getting it wrongb 00:30:00 Mock Exam Mock Exam- Family Support Worker Course 00:30:00 Final Exam Final Exam- Family Support Worker Course 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00
