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

17197 Manager courses

HGV Mechanic & MET Technician

4.7(47)

By Academy for Health and Fitness

Unleash your potential in the world of HGV Mechanics & MET Technician training with our comprehensive 6-course bundle. As the demand for skilled technicians in this field continues to surge, with job openings projected to grow by 3% annually (source: Bureau of Labor Statistics), our expert-led program equips you with the knowledge and hands-on skills needed to excel. Join us today to rev up your career in HGV mechanics and MET technician roles! This HGV Mechanic & MET Technician Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Heavy Goods Vehicle Course 02: Car Mechanic and Repair Training Course 03: Delivery Driver Training Course 04: Transport Management Diploma Course 05: Freight Consultant Training Course 06: MET Technician Learning Outcomes: Master HGV maintenance for safe and efficient transportation. Develop car mechanic and repair skills for vehicle maintenance. Excel as a professional delivery driver with specialised training. Attain a Transport Management Diploma for logistics leadership. Become a Freight Consultant with expertise in supply chain management. Specialise in MET Technician training for vehicle accident repair. Acquire a versatile skill set for the automotive and logistics industries. Embark on a transformative journey into the world of HGV Mechanics & MET Technician training with our comprehensive 6-course bundle. These courses are meticulously designed to provide you with essential skills and knowledge in HGV maintenance, automotive repair, and logistics management. Whether you aspire to become an expert mechanic, a logistics leader, or a vehicle repair specialist, our courses equip you with the expertise needed to succeed in these dynamic industries. Heavy Goods Vehicle: Master the art of HGV maintenance, ensuring safety and efficiency in heavy transport operations. Car Mechanic and Repair Training: Develop expertise in car mechanics and repair, a valuable skill for vehicle maintenance and service. Delivery Driver Training: Become a professional delivery driver, honing your skills to meet the demands of the modern delivery industry. Transport Management Diploma: Attain a diploma that opens doors to leadership roles in the transportation sector, offering a deep understanding of logistics and supply chain management. Freight Consultant Training: Dive into the world of logistics and freight management, mastering the intricacies of supply chain optimisation. MET Technician: Specialize in MET Technician training, gaining proficiency in vehicle accident repair and restoration. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring HGV Mechanics Automotive Repair Enthusiasts Delivery Service Professionals Logistics and Transport Enthusiasts Requirements You will not need any prior background or expertise. Career path HGV Mechanic: £20,000 - £45,000 Automotive Technician: £20,000 - £40,000 Delivery Driver: £20,000 - £35,000 Transport Manager: £30,000 - £70,000 Freight Consultant: £25,000 - £60,000 MET Technician: £20,000 - £45,000 Enroll today and accelerate your career in HGV mechanics, automotive repair, and logistics management! Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

HGV Mechanic & MET Technician
Delivered Online On Demand26 hours
£40

Social Housing Management

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Social Housing Management Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Social Housing Management Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Social Housing Management Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Social Housing Management Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Social Housing Management? 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 Social Housing Management 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Social Housing Management course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Social Housing Management does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Social Housing Management was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Social Housing Management is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Social Housing Management Module 01: Introduction to Social Housing Introduction to Social Housing 00:16:00 Module 02: Tenant Selection and Tenant Management Tenant Selection and Tenant Management 00:29:00 Module 03: Managing Rental Income and Arrears Managing Rental Income and Arrears 00:25:00 Module 04: Maintenance, Safety, and Security of Social Housing Maintenance, Safety, and Security of Social Housing 00:34:00 Module 05: Resident Involvement in Social Housing Resident Involvement in Social Housing 00:32:00 Module 06: Dealing with Anti-Social Behaviours Dealing with Anti-Social Behaviours 00:40:00 Module 07: Career Prospects of Social Housing Manager Career Prospects of a Social Housing Manager 00:25:00

Social Housing Management
Delivered Online On Demand3 hours 21 minutes
£10.99

Accident Investigation

4.5(3)

By Studyhub UK

Step into the realm of incident analysis with our Accident Investigation course, where unraveling the mysteries behind the unforeseen becomes your newfound expertise. Within the embrace of this curriculum, learners will delve into the essence of investigations, beginning with an in-depth understanding of the process. As you traverse through the modules, the course illuminates the pivotal reasons behind thorough accident scrutiny, cultivating a mindset focused on prevention and improvement. Advance through the structured journey from procedural strategies to inquisitive interviews, each step a building block towards analytical proficiency. Equip yourself with the acumen to document scenes with precision, analyse causative factors with insight, and forge preventative measures from lessons learned. Your progress will culminate in the ability to craft reports that not only communicate facts but also pave the way for enhanced safety protocols, making this course an invaluable beacon for those dedicated to fostering safer environments. Learning Outcomes Gain a robust understanding of the accident investigation process. Comprehend the importance of incident inquiries for preventative measures. Develop skills in documenting and scrutinising accident scenes meticulously. Acquire techniques for conducting insightful interviews and cause analysis. Learn to formulate and communicate preventive strategies effectively. Why choose this Accident Investigation 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 Accident Investigation course for? Individuals pursuing a role in occupational health and safety. Team leaders responsible for workplace safety and compliance. Safety officers within industrial, construction, or manufacturing sectors. Risk assessment consultants focusing on accident prevention. Professionals in human resources managing workplace safety training. Career path Safety Officer: £25,000 - £40,000 Risk Assessor: £30,000 - £45,000 Health and Safety Advisor: £35,000 - £50,000 Compliance Manager: £40,000 - £60,000 Operations Manager: £45,000 - £70,000 Senior HSE Consultant: £50,000 - £75,000 Prerequisites This Accident Investigation does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Accident Investigation 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 Module 01: Understanding the Investigation Understanding the Investigation 00:14:00 Module 02: Why Investigate? Why Investigate? 00:19:00 Module 03: Accident Investigation Procedure Accident Investigation Procedure 00:16:00 Module 04: Documenting The Accident Scene Documenting The Accident Scene 00:15:00 Module 05: Conducting Effective Interviews Conducting Effective Interviews 00:15:00 Module 06: Investigation and Cause Analysis Investigation and Cause Analysis 00:19:00 Module 07: Developing Solutions Developing Solutions 00:19:00 Module 08: Report Documentation and Communication Report Documentation and Communication 00:20:00 Assignment Assignment - Accident Investigation 00:00:00

Accident Investigation
Delivered Online On Demand2 hours 17 minutes
£10.99

Recruitment

4.5(3)

By Studyhub UK

Embark on a comprehensive journey into the dynamic world of 'Recruitment.' In an era where identifying the right talent is paramount for organisational success, this course serves as a beacon for aspirants wishing to delve deep into the recruitment industry. From understanding the legislative backdrop in the UK to mastering client and candidate management, each module has been meticulously designed to provide you with a 360-degree view of the recruitment landscape. Whether you're looking to enhance your skills or kick-start your own recruiting service, this course promises to be your trusted guide. Learning Outcomes Gain a foundational understanding of the significance and nuances of recruitment. Familiarise oneself with the legislative framework governing recruitment in the UK. Develop expertise in effective candidate attraction, management, and interview processes. Master the art of client acquisition, strategy, and relationship management. Understand the key indicators that drive success within the recruitment industry. Why choose this Recruitment 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 Recruitment 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 Recruitment course for? Aspiring recruitment consultants eager to enter the industry. HR professionals aiming to bolster their recruitment strategies. Entrepreneurs considering launching their own recruitment service. Sales professionals transitioning into recruitment roles. Business leaders keen on understanding the recruitment ecosystem. Career path Recruitment Consultant - £20,000 - £30,000 HR Manager - £35,000 - £50,000 Talent Acquisition Specialist - £28,000 - £42,000 Recruitment Agency Owner - Variable (based on agency success) Client Relationship Manager (Recruitment) - £30,000 - £45,000 Head of Recruitment - £45,000 - £70,000 Prerequisites This Recruitment does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Recruitment 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 Recruitment Module 01 - Introduction to Recruitment: Importance and Implications 00:17:00 Module 02 - An Overview of the Recruitment Industry 00:26:00 Module 03 - The UK Recruitment Legislation 00:19:00 Module 04 - Sales and Selling in the Recruitment Industry 00:11:00 Module 05 - The Recruitment Process 00:47:00 Module 06 - Key Performance Indicators for the Recruitment Industry 00:25:00 Module 07 - Candidate Attraction for Recruitment 00:35:00 Module 08 - Candidate Management 00:22:00 Module 09 - Candidate Interview Processes 00:24:00 Module 10 - Client Acquisition 00:36:00 Module 11 - Client Strategy in the Recruitment Sector 00:25:00 Module 12 - Client Management 00:27:00 Module 13 - Steps to Starting and Running a Successful Recruiting Service 00:23:00 Mock Exam Mock Exam - Recruitment 00:20:00 Final Exam Final Exam - Recruitment 00:20:00

Recruitment
Delivered Online On Demand6 hours 17 minutes
£10.99

Business Analyst

4.5(3)

By Studyhub UK

Welcome to the dynamic realm of the 'Business Analyst' course, where your journey to mastering the art of business analysis begins. Step into the world of strategic decision-making, problem-solving, and innovation. This course is your gateway to becoming a proficient business analyst, equipped with the knowledge and skills to drive positive change within organizations. In this comprehensive program, you'll embark on an exploration of business processes, analysis planning, stakeholder management, and more. From investigating techniques to ratio analysis, you'll delve deep into the tools and methodologies that define successful business analysis. Upon completion, you'll be well-prepared to navigate the world of business, making informed decisions that drive growth and efficiency. Learning Outcomes Understand the fundamentals of business analysis. Analyze and optimize business processes. Develop strategic analysis and product scope. Evaluate solutions and assess their impact. Master stakeholder analysis and management. Why choose this Business Analyst 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 Business Analyst course for? Aspiring business analysts. Professionals seeking to enhance their analytical skills. Students interested in strategic decision-making. Individuals looking to drive business improvement. Anyone passionate about problem-solving in a business context. Career path Business Analyst: £30,000 - £70,000 Data Analyst: £25,000 - £55,000 Financial Analyst: £30,000 - £70,000 Project Manager: £35,000 - £80,000 Management Consultant: £40,000 - £90,000 Product Manager: £40,000 - £90,000 Prerequisites This Business Analyst does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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 Module 01: Introduction to Business Analysis Introduction to Business Analysis 00:15:00 Module 02: Business Processes Business Processes 00:45:00 Module 03: Business Analysis Planning and Monitoring Business Analysis Planning and Monitoring 00:28:00 Module 04: Strategic Analysis and Product Scope Strategic Analysis and Product Scope 00:29:00 Module 05: Solution Evaluation Solution Evaluation 00:25:00 Module 06: Investigation Techniques Investigation Techniques 00:46:00 Module 07: Ratio Analysis Ratio Analysis 00:27:00 Module 08: Stakeholder Analysis and Management Stakeholder Analysis and Management 00:23:00 Module 09: Process Improvement with Gap Analysis Process Improvement with Gap Analysis 00:26:00 Module 10: Documenting and Managing Requirements Documenting and Managing Requirements 00:27:00 Module 11: Career Prospect as a Business Analyst in the UK Career Prospect as a Business Analyst in the UK 00:14:00

Business Analyst
Delivered Online On Demand5 hours 5 minutes
£10.99

Emotional Intelligence and Social Management Diploma

4.5(3)

By Studyhub UK

Ignite Your Emotional Intelligence: Embark on the Social Management Diploma Journey Welcome to a transformative expedition into the realm of emotional intelligence and social mastery. Our course, 'Emotional Intelligence and Social Management Diploma,' is a captivating odyssey designed to unravel the nuances of emotional intelligence and refine your social acumen. Dive into modules that dissect the essence of emotional intelligence, from verbal and non-verbal communication skills to tools empowering emotional regulation. This course isn't just educational; it's an immersive experience crafted to elevate your interpersonal dynamics and foster a profound understanding of social responsibility. Learning Outcomes Acquire tools and techniques to regulate and control your emotions effectively. Develop both verbal and non-verbal communication skills for impactful interaction. Understand the role of social responsibility in personal and professional contexts. Explore the application of emotional intelligence in diverse business scenarios. Unleash your potential to make a lasting impression in personal and professional spheres. Why choose this Emotional Intelligence and Social Management Diploma? 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 Emotional Intelligence and Social Management Diploma for? Individuals eager to enhance their emotional intelligence and social skills. Professionals seeking to excel in interpersonal dynamics and communication. Entrepreneurs and business leaders aiming to foster a socially responsible work environment. Students and graduates preparing for a successful entry into the professional world. Anyone desiring to create a positive impact in both personal and professional relationships. Career path Emotional Intelligence Consultant: £30,000 - £45,000 Corporate Social Responsibility Officer: £25,000 - £40,000 Communication Specialist: £28,000 - £42,000 Human Resources Manager: £35,000 - £50,000 Business Relationship Manager: £30,000 - £45,000 Personal Development Coach: £25,000 - £40,000 Prerequisites This Emotional Intelligence and Social Management Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Emotional Intelligence and Social Management Diploma 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 Module 01: Introduction to Emotional Intelligence What is Emotional Intelligence 00:13:00 Module 02: Skills in Emotional Intelligence Skills in Emotional Intelligence 00:06:00 Module 03: Verbal Communication Verbal Communication Skills 00:05:00 Module 04: Non-Verbal Communication Non-Verbal Communication Skills 00:05:00 Module 05: Social Management and Responsibility Social Management and Responsibility 00:06:00 Module 06: Tools to Regulate Your Emotions Tools to Regulate Your Emotions 00:06:00 Module 07: Gaining Control Gaining Control 00:07:00 Module 08: Business Practices (I) Business Practices (I) 00:07:00 Module 09: Business Practices (II) Business Practices (II) 00:07:00 Module 10: Making an Impact Making an Impact 00:07:00

Emotional Intelligence and Social Management Diploma
Delivered Online On Demand1 hour 9 minutes
£10.99

Linear Algebra for Data Science in Python

By Packt

Get started with using linear algebra in your data science projects

Linear Algebra for Data Science in Python
Delivered Online On Demand56 minutes
£22.99

Level 3 Diploma in Recruitment Consultant

By EduXpress

In the dynamic world of business, the role of a Recruitment Consultant has become pivotal, particularly in the UK. With a staggering 75% of HR managers struggling to attract skilled candidates, as per recent UK statistics, the demand for adept recruitment consultants is soaring. This course, 'Recruitment Consultant,' is meticulously designed to transform enthusiasts into astute professionals, adept at navigating the complexities of talent acquisition. Emphasising the art of matchmaking between companies and potential employees, it provides an in-depth understanding of the recruitment process. Participants will learn to identify and engage top talent, ensuring their skills align with organisational needs, thus fostering both individual and business growth. Learning Outcomes Master the techniques of effective candidate sourcing and engagement. Develop expertise in crafting compelling job descriptions. Gain insights into modern recruitment strategies and tools. Understand legal aspects and ethical practices in recruitment. Acquire skills in negotiation and candidate assessment. Learn to build and maintain professional networks. Enhance communication skills for diverse recruitment contexts. Understand market trends and their impact on recruitment. Who Is This Course For? Individuals aspiring to enter the recruitment industry. HR professionals seeking to specialise in recruitment. Career advisors aiming to broaden their service range. Business owners looking to improve their hiring process. Graduates interested in a career in human resources. Why Choose Us? Lifetime access to course materials Full tutor support is available Monday through Friday for all courses Learn essentials skills at your own pace from the comfort of your home Gain a thorough understanding of the course Access informative video modules taught by expert instructors 24/7 assistance and advice available through email and live chat Study the course on your computer, tablet, or mobile device Improve your chances of gaining professional skills and earning potential by completing the course. Why should you study this course? The course offers a comprehensive introduction to the subject matter and provides a solid foundation for further study. It will also help students to gain knowledge and skills that can be applied in their professional or personal life. Assessment The course includes a series of quizzes that will test your understanding and retention of the material covered in the course. The quizzes will help you to identify areas where you may need further practice, and you will have the opportunity to review the course materials as needed. Upon successfully passing the final quiz, you will be able to order your certificate of achievement. Career Path Recruitment Consultant: £22,000 - £30,000 Senior Recruitment Consultant: £28,000 - £35,000 Recruitment Manager: £35,000 - £50,000 Talent Acquisition Specialist: £30,000 - £45,000 HR Manager: £35,000 - £55,000 Head of Recruitment: £50,000 - £70,000 Course Content Recruitment Consultant Level 3 Diploma Module 1: Introduction to Recruitment Consultancy Module 2: UK Employment Law Module 3: The Recruitment Process Module 4: Interview Techniques Module 5: Candidate Assessment and Selection Module 6: Sourcing Candidates Module 7: Recruitment Analytics and Metrics Module 8: Marketing and Sales in Recruitment Module 9: Recruitment Technology and Software Module 10: Client Relationship Management

Level 3 Diploma in Recruitment Consultant
Delivered Online On Demand
£10.49

Level 3 Teaching Assistant Diploma - Specialist Support with Children (RQF)

4.5(212)

By The Learning College Group

If you’re interested in becoming a fully qualified Teaching Assistant, but don’t know where to start your learning journey, then the Teaching Assistant Level 3 Diploma training course could be the perfect option for you. Learn the skills and knowledge needed to succeed! The Teaching Assistant Level 3 Diploma course has been designed by our team of teaching experts to provide you with a complete overview of what is needed to become a successful TA. Enrol on the Teaching Assistant Level 3 Diploma course today and kickstart a new and exciting career helping children reach their full potential.

Level 3 Teaching Assistant Diploma - Specialist Support with Children (RQF)
Delivered Online On Demand1 hour
£41.58 to £449

SQL Programming Course

4.7(47)

By Academy for Health and Fitness

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

SQL Programming Course
Delivered Online On Demand8 hours
£12