39805 Learning courses in Bradford delivered On Demand

Everywhere, from tiny businesses to major corporations, needs people skilled in SQL. In light of this, our online training course has been developed to help you succeed by equipping you with all the necessary skills. The importance of mastering SQL increases if you're looking for your first job in the data industry. You will learn about topics such as SQL fundamentals, data wrangling, SQL analysis, AB testing, distributed computing with Apache Spark, Delta Lake, and more through four increasingly more challenging SQL projects with data science applications. These subjects will equip you with the skills necessary to use SQL creatively for data analysis and exploration, write queries quickly, produce datasets for data analysis, conduct feature engineering, integrate SQL with other data analysis and machine learning toolsets, and work with unstructured data. This Specialisation is designed for a learner with little or no prior coding expertise who wants to become proficient with SQL queries. Experts have meticulously planned out the curriculum for the SQL Skills Training course with years of expertise. As a result, you will find it simple to learn the course material. Learning outcome After finishing the course, you'll Learn to utilise the tools for view creation Become familiar with updating columns and indexed views Be able to test and debug Be able to search a database using SQL Become more familiar with inline table-valued functions Learn the fundamentals of transactions and multiple statements Why Prefer US? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Standards-aligned lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full 24/7 tutor support *** Course Curriculum *** SQL Programming Course Module 01: Course Introduction Introduction Course Curriculum Overview Overview of Databases Module 02: SQL Environment Setup MySQL Installation MySQL Workbench Installation Connecting to MySQL using Console Module 03: SQL Statement Basics Overview of Challenges SQL Statement Basic SELECT Statement SELECT DISTINCT Column AS Statement COUNT built-in Method usage SELECT WHERE Clause - Part One SELECT WHERE Clause - Part Two Statement Basic Limit Clause Statement Using BETWEEN with Same Column Data How to Apply IN Operator Wildcard Characters with LIKE and ILIKE Module 04: GROUP BY Statements Overview of GROUP BY Aggregation function SUM() Aggregation MIN() and MAX() GROUP BY - One GROUP BY - Two HAVING Clause Module 05: JOINS Overview of JOINS Introduction to JOINS AS Statement table INNER Joins FULL Outer Join LEFT Outer JOIN RIGHT JOIN Union Module 06: Advanced SQL Commands / Statements Timestamps EXTRACT from timestamp Mathematical Functions String Functions SUBQUERY Module 07: Creating Database and Tables Basic of Database and Tables Data Types Primary key and Foreign key Create Table in SQL Script Insert Update Delete Alter Table Drop-Table NOT NULL Constraint UNIQUE Constraint Module 08: Databases and Tables Creating a Database backup 10a Overview of Databases and Tables 10c Restoring a Database CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The course can be helpful for anyone working in the SQL fields, whether self-employed or employed, regardless of their career level. Requirements You will not need any prior background or expertise to enrol in this course. Career path The vocation of SQL Skills Training moves very quickly but pays well. This position provides unparalleled satisfaction. This is your opportunity to learn more and start changing things. Query Language Developer Server Database Manager Python Developer Technical Consultant Project Implementation Manager Software Developer (SQL) Certificates Certificate of completion Digital certificate - £10

IASSC lean six sigma green belt course. Online, 24/7 access to content and exam. Fee includes learning content, live webinars, tutor support, and official IASSC exam.

4 in 1 Package | Updated New Course 2023 | CPD Certified | 40 CPD Points | Free Certificates | Lifetime Access

The Learning College Group offers this Teaching Assistant qualification that is fully Regulated and accepted in all schools across the UK. It enables you to work with children between the ages of 5-18 years. This Level 3 Teaching Assistant course is a recognised (RQF) qualification that can be studied in your own time from home. 1-2-1 Tutor support is provided with this Teaching Assistant course. OFSTED accepted and regulated by OFQUAL this qualification will be the required course to secure your job as a Teaching Assistant.

Overview This comprehensive course on Diploma in Lean Leadership and Change Management will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Diploma in Lean Leadership and Change Management 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 Diploma in Lean Leadership and Change Management. It is available to all students, of all academic backgrounds. Requirements Our Diploma in Lean Leadership and Change Management 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 7 sections • 81 lectures • 06:40:00 total length •Why 00:04:00 •What 00:04:00 •Curriculum 00:05:00 •How 00:04:00 •What is Culture: 00:06:00 •Culture Drivers: 00:08:00 •Resources: 00:05:00 •Activity 1: 00:03:00 •House of Lean: 00:03:00 •Evolution: 00:04:00 •Shingo: 00:09:00 •Honda: 00:09:00 •Activity 2: 00:02:00 •JIT: 00:07:00 •Kanban: 00:08:00 •Continuous Improvement and Leadership: 00:04:00 •Waste Intro: 00:10:00 •Forms of Waste 1: 00:06:00 •Management Waste: 00:07:00 •Activity3: 00:02:00 •Scientific Method: 00:07:00 •Gemba Walk: 00:06:00 •Heijunka: 00:05:00 •Visual Display: 00:07:00 •Activity 4: 00:02:00 •Kaizen: 00:06:00 •Lean Leadership Intro: 00:07:00 •The Mind of the Lean Leader: 00:04:00 •The Mind of the Lean Leader - Transitions: 00:07:00 •Lean Leadership1. External Challenge: 00:06:00 •Lean Leadership 2. Internal Challenge: 00:06:00 •Activity 5: 00:02:00 •Lead WSA: 00:02:00 •Be the Model: 00:03:00 •Coach Others: 00:07:00 •Motivation: 00:04:00 •Reinforce Your Strategy: 00:04:00 •Activity 6: 00:01:00 •Intrinsic Reinforcement: 00:08:00 •Paths to Lean: 00:05:00 •How You Change: 00:03:00 •Design Thinking: 00:08:00 •Design Process: 00:09:00 •Capability Analysis: 00:05:00 •Charter: 00:05:00 •Activity 7: 00:02:00 •Design Team: 00:06:00 •Discovery: 00:06:00 •Discover the Process: 00:07:00 •Dream: 00:07:00 •Design technical: 00:07:00 •Design Structure: 00:08:00 •Social Design: 00:06:00 •Activity 8: 00:03:00 •VON Case Study: 00:10:00 •WSA Summary: 00:04:00 •Activity 9: 00:02:00 •Why Teams: 00:06:00 •Types of Teams: 00:06:00 •Team Charter: 00:05:00 •Team Maturity: 00:05:00 •Team Roles and Responsibilities: 00:05:00 •Team Agenda: 00:05:00 •Activity 10: 00:02:00 •Facilitation 1: 00:06:00 •Facilitation 2: 00:04:00 •Team Scoreboard: 00:07:00 •Activity 11: 00:01:00 •Map Team's Work: 00:03:00 •Attitudes: 00:05:00 •Five Whys: 00:03:00 •PDSA 1: 00:04:00 •PDSA 2: 00:04:00 •PDCA example: 00:01:00 •Activity 12: 00:01:00 •A3: 00:06:00 •Standard Work: 00:05:00 •Leader Standard Work: 00:04:00 •Activity 13: 00:02:00 •Summary: 00:03:00 •Additional Study Materials: Diploma in Lean Leadership and Change Management: 00:00:00

ITIL® 4 Specialist: Create, Deliver and Support: On-Demand The ITIL® 4 Specialist: Create, Deliver, and Support module is part of the Managing Professional stream for ITIL® 4. Candidates need to pass the related certification exam for working towards the Managing Professional (MP) designation. This course is based on the ITIL® 4 Specialist: Create, Deliver, and Support exam specifications from AXELOS. With the help of ITIL® 4 concepts and terminology, exercises, and examples included in the course, candidates acquire the relevant knowledge required to pass the certification exam. What You Will Learn The learning objectives of the course are based on the following learning outcomes of the ITIL® 4 Specialist: Create, Deliver, and Support exam specification: Understand how to plan and build a service value stream to create, deliver, and support services Know how relevant ITIL® practices contribute to the creation, delivery, and support across the SVS and value streams Know how to create, deliver, and support services Organization and Culture Organizational Structures Team Culture Continuous Improvement Collaborative Culture Customer-Oriented Mindset Positive Communication Effective Teams Capabilities, Roles, and Competencies Workforce Planning Employee Satisfaction Management Results-Based Measuring and Reporting Information Technology to Create, Deliver, and Support Service Integration and Data Sharing Reporting and Advanced Analytics Collaboration and Workflow Robotic Process Automation Artificial Intelligence and Machine Learning CI / CD Information Model Value Stream Anatomy of a Value Stream Designing a Value Stream Value Stream Mapping Value Stream to Create, Deliver, and Support Services Value Stream for Creation of a New Service Value Stream for User Support Value Stream Model for Restoration of a Live Service Prioritize and Manage Work Managing Queues and Backlogs Shift-Left Approach Prioritizing Work Commercial and Sourcing Considerations Build or Buy Sourcing Models Service Integration and Management

The objective of the Level 7 Diploma in Health and Social Care Management qualification (accredited by OTHM) is to develop learners' understanding of policy, management theory and practice in health and social care. It provides you with an opportunity to engage with the challenges facing professionals, services users and policy makers in their own country. It will also provide you with the knowledge that underpins the ability to work as an effective manager in the hospitals/social care industry. It combines both theoretical and practical knowledge in the health and social care profession. This Level 7 Diploma in Health and Social Care Management qualification will develop and enhance knowledge and skills in the areas of leading change, effective performance, planning and accountability, development and team leadership. Learners will be able to work in a variety of roles within health care administration and/or management. Successful completion of the Level 7 Diploma in Health and Social Care Management qualification enables learners to progress into or within employment and/or continue their study towards a relevant Master's programme with advanced standing. Key Highlights of Diploma in Health and Social Care Management - Level 7 qualification are: Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Credits Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme. LSBR Alumni Status No Cost EMI Option This level 7 Diploma in Health and Social Care Management will develop and enhance knowledge and skills in the areas of leading change, effective performance, planning and accountability, development and team leadership. You will be able to work in a variety of roles within Health Care Administration and/or Management in the Hospitals / Social Care Industry You will be able to work in a variety of roles within Health Care Administration and/or Management in the Hospitals / Social Care Industry. Upon successful completion of the programme, you will also become eligible to gain direct entry into relevant Master's degree programme. Mandatory Units (Total Credits: 120) The programme involves delivery through on-line Learning Management System (LMS). This stage leads to award of Level 7 Diploma in Health and Social Care Management. The total credits earned will be 120 credits. Health and Social Care Leadership (20 credits) Managing People in Health and Social Care (20 credits) Managing Finance in the Health and Social Care Sector (20 credits) Health and Social Care Strategies and Policies (20 credits) Leading Change in Health and Social Care (20 credits) Research Methods for Healthcare Professionals (20 credits) Who is this course for? Working Professionals Level 6 / Year 3 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression. a formal Postgraduate qualification leading to award of degrees in future. Requirements For entry onto the Level 7 Diploma in Health and Social Care Management qualification, learners must possess: an honours degree in related subject or UK level 6 diploma or an equivalent overseas qualification. Learner must be 18 years or older at the beginning of the course. No formal qualification is required from mature learners (over 21 years) who have relevant management experience. Please speak to the Admission Counselors for waiver information. Career path Become eligible to gain direct entry into relevant Master's degree programme after completion of your Level 7 Diploma in Health and Social Care Management Completion of your qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry.

Awarded by ATHE + Ofqual Regulated + TOTUM Pro Discount Card + Tutor Support + Fully Online + Job Placement Assistance

Awarded by ATHE + Ofqual Regulated + Tutor Support + Fully Online + Job Placement Assistance

If you want to achieve a Level-3 Ofqual UK-Government Regulated TESOL certification in the most effective, time-saving and enjoyable way, embark on a thrilling learning adventure in TEFL Wonderland. Unlike the click-and-read TEFL courses, this play-and-practice expedition will engage all your senses and keep you motivated to achieve your learning mission.