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

37572 Courses delivered Online

Supervisor Training Course

4.7(26)

By Academy for Health and Fitness

Our Aim is Your Satisfaction! Offer Ends Soon; Hurry Up!! Are you looking to improve your current abilities or make a career move? Our unique Supervisor Training course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great-value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Supervisor Training online training course. This course is endorsed by The Quality Licence Scheme and accredited by CPD (with 120 CPD points) The Supervisor course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling in this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This course can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the course today - gear up with the essential skills to set yourself up for excellence! Experts created the Supervisor Training course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this course and take a step toward a brighter future! Why Prefer this Supervisor Course? Opportunity to earn a certificate endorsed by the Quality Licence Scheme and another 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) Standard-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 *** Diploma in Supervisor Training at QLS Level 4 Module 01: Fundamentals of Supervisor Training The Importance of Training Supervisors The Five Keywords of Supervision Realities of Training New Supervisors Top Mistakes Made by New Supervisors Supervision as a Profession Summary Module 02: Understanding the Role of Supervision Defining Supervision Professional SupervisionLine Management or Managerial Supervision Types of Supervision Roles of a Supervisor Successful Supervisors Do Things Differently Summary Module 03: Essential Skills in Supervision Problem Solving and Decision Making Planning Delegation Basics of Internal Communications Meeting Management Summary Module 04: Recruitment and Dismissal Recruitment Process Overview The Hiring Process in Eight Steps Dismissal of an Employee Summary Module 05: Employee Management Goal Settings Motivation Observation and Feedback Addressing Performance Issues Conducting Performance Reviews Summary Module 06: Communication Skill Development Listening Actively Choosing the Right Words Using an Appropriate Tone of Voice Using the Appropriate Body Language Adjusting with Different Personalities Conducting Effective Meetings Summary Module 07: Interactive Training for New Supervisors Individual Training Small-Group Training How to Create Successful Training Program Tips on Designing Effective Training What to Look for in Training Importance of Evaluation Levels of Training Evaluation Improvement of Training Summary Module 08: Conflict Management Why Conflicts Happen Managing Conflict Based on Personality Types Managing Conflict Based on Perception Managing Conflict Based on Goals Handling Common Conflict Situations Summary Module 09: Cybersecurity for Employees What Is Cybersecurity? Importance of Cybersecurity Benefits of Cybersecurity Training Getting Employees on Board with Cybersecurity Awareness Training Summary Assessment Process We offer an integrated assessment framework to make the process of evaluation and accreditation for learners easier. You have to complete the assignment questions given at the end of the course and score a minimum of 60% to pass each exam. Our expert trainers will assess your assignment and give you feedback after you submit the assignment. After passing the exam, you will be able to request a certificate with additional cost that has been endorsed by the Quality Licence Scheme. Show off Your New Skills With a Certificate of Completion Endorsed Certificate of Achievement from the Quality Licence Scheme After successfully completing the course, you can order an original hardcopy certificate of achievement endorsed by the Quality Licence Scheme. The certificate will be home-delivered, with a pricing scheme of - 99 GBP inside the UK 109 GBP (including postal fees) for international delivery Certificate Accredited by CPD Upon finishing the course, you will receive an accredited certification that is recognised all over the UK and also internationally. The pricing schemes are - 10 GBP for Digital Certificate 29 GBP for Printed Hardcopy Certificate inside the UK 39 GBP for Printed Hardcopy Certificate outside the UK (international delivery) CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Is This Course Right for You? Anyone interested in learning more about this subject should take this Supervisor Training course. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. All are welcome to take this course. There are no prerequisites for enrollment, and you can access the course materials from any location in the world. Requirements This Supervisor course is open to anyone who is interested in learning from anywhere in the world. Career path This Supervisor course will allow you to kickstart or take your career in the related sector.

Supervisor Training Course
Delivered Online On Demand3 weeks
£12

Medical Teaching Advanced Diploma

4.5(3)

By Studyhub UK

24 Hour Flash Deal **33-in-1 Medical Teaching Advanced Diploma Mega Bundle** Medical Teaching Advanced Diploma Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Medical Teaching Advanced Diploma package online with Studyhub through our online learning platform. The Medical Teaching Advanced Diploma bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Medical Teaching Advanced Diploma course provides complete 360-degree training on Medical Teaching Advanced Diploma. You'll get not one, not two, not three, but thirty-three Medical Teaching Advanced Diploma courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Medical Teaching Advanced Diploma courses are yours for as long as you want them once you enrol in this course This Medical Teaching Advanced Diploma Bundle consists the following career oriented courses: Course 01: Medical Teaching Course 02: Anatomy and Physiology of Human Body Course 03: Human Anatomy, Physiology and Medical Terminology Diploma Course 04: Biochemistry Course 05: Molecular Genetics Course 06: Neurology, Neurological Assessments & Medication Course 07: Understanding the Immune System Course 08: Radiography Course 09: Dermatology Course 10: Common Childhood Illnesses & Paediatric First Aid Course 11: Paediatric Care Course Course 12: Geriatric Nutrition and Well-being Course 13: Emergency Care Worker Course 14: Paramedicine Study Course 15: Basic Cardiac (Heart) Care Course 16: Medical Jargon for Healthcare Assistant Course 17: Psychological Wellbeing and Crisis Intervention Course 18: Mental Health and Psychiatry Training Course 19: Pharmacology Diploma Course 20: Clinical Pharmacy Certificate Program and Professional Standards Course 21: Medical coding Training Course 22: Medical Transcription Diploma Course 23: Medical & Clinical Administrator Course 24: Nurse Prescribing and Medicine Management Course 25: Infection Control & Medicine Handling Course 26: Medical Law Course 27: Clinical Governance in Adult Care Course 28: Research in Adult Care Course 29: Clinical Research Administration: Navigating the Healthcare Landscape Course 30: Leadership Skills for UK Health Care Professionals Course 31: Health Economics and Health Technology Assessment Course 32: Public Health Course 33: International Healthcare Policy In this exclusive Medical Teaching Advanced Diploma bundle, you really hit the jackpot. Here's what you get: Step by step Medical Teaching Advanced Diploma lessons One to one assistance from Medical Teaching Advanced Diploma professionals if you need it Innovative exams to test your knowledge after the Medical Teaching Advanced Diploma course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all thirty-three Medical Teaching Advanced Diploma courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Medical Teaching Advanced Diploma certificate and transcript on the next working day Easily learn the Medical Teaching Advanced Diploma skills and knowledge you want from the comfort of your home The Medical Teaching Advanced Diploma course has been prepared by focusing largely on Medical Teaching Advanced Diploma career readiness. It has been designed by our Medical Teaching Advanced Diploma specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Medical Teaching Advanced Diploma Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Medical Teaching Advanced Diploma bundle course has been created with thirty-three premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Medical Teaching Advanced Diploma Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Medical Teaching Advanced Diploma Elementary modules, allowing our students to grasp each lesson quickly. The Medical Teaching Advanced Diploma course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Medical Teaching Advanced Diploma training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Medical Teaching Advanced Diploma Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Medical Teaching Advanced Diploma course, all you need is - A smart device A secure internet connection And a keen interest in Medical Teaching Advanced Diploma Career path You will be able to kickstart your Medical Teaching Advanced Diploma career because this course includes various courses as a bonus. This Medical Teaching Advanced Diploma is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Medical Teaching Advanced Diploma career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Medical Teaching Advanced Diploma
Delivered Online On Demand7 days
£329

School Administrator Training Part - 1

By iStudy UK

Course Description Get instant knowledge from this bite-sized school administrator training part - 1 course. This course is very short and you can complete it within a very short time. In this school administrator training part - 1 course you will get fundamental ideas of school administration, the key strategy of workplace development, safeguard students and so on. Enrol in this course today and start your instant first step towards introduction to school administration. learn faster for instant implementation. Learning outcome Familiarise with school administration Understand the types of schools in the UK Gain in-depth knowledge of the workplace development Deepen your understanding of creating and maintaining a school culture Know how to safeguard students Understand the educational administration and management How Much Do School Administrators Earn? Senior - £42,000 (Apprx.) Average - £26,000 (Apprx.) Starting - £16,000 (Apprx.) Requirement Our School Administrator Training Part - 1 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. School Administrator Training Part - 1 Module 01: Introduction to School Administration 00:12:00 Module 02: Types of Schools In The UK 00:15:00 Module 03: Workplace Development 00:12:00 Module 04: Creating and Maintaining a School Culture 00:13:00 Module 05: Educational Administration and Management 00:11:00 Module 06: Safeguarding Students 00:14:00 Assignment Assignment - School Administrator Training Part - 1 00:00:00

School Administrator Training Part - 1
Delivered Online On Demand1 hour 17 minutes
£25

V-Ray for Rhino Essentials Training

By ATL Autocad Training London

Why Choose V-Ray for Rhino Essentials Training? Master photorealistic rendering in Rhino with our intensive V-Ray training. Led by certified experts, learn lighting, material manipulation, rendering configurations, textures, and global illumination.  Check our Website Training Duration: 10 hours Approach: 1-on-1, in-Person and Live online and Customized Content.   Flexibility: 1-on-1 sessions scheduled at your convenience, from Mon to Sat between 9 am and 7 pm. Vray for Rhino Essentials - 10 Hours Course Session 1: Introduction to Vray and Rhino Integration Overview of Vray: Understanding its importance in architectural and product visualization. Setting up Vray in Rhino: Installation, basic configurations, and interface exploration. Understanding the Rhino-Vray workflow: Navigating between Rhino and Vray seamlessly. Session 2: Basic Lighting Techniques Exploring different light sources: Domes, spotlights, and area lights. Adjusting light intensity and color temperature for realistic ambiance. Creating natural lighting scenarios: Daylight, twilight, and night scenes. Session 3: Mastering Material Creation Introduction to Vray materials: Diffuse, reflection, refraction, and bump maps. Crafting realistic materials: Wood, glass, metal, and fabrics. Utilizing the material editor efficiently for precise adjustments. Session 4: Advanced Rendering Configurations Global Illumination: Understanding photon mapping and irradiance mapping. Fine-tuning render settings: Quality vs. speed, resolution, and anti-aliasing. Exploring Vray frame buffer: Post-processing and image enhancement. Session 5: Texture Manipulation and Mapping Understanding UV mapping: Unwrapping complex geometries for accurate textures. Applying textures in Vray: Diffuse, bump, displacement, and normal maps. Realistic texture manipulation: Scaling, rotation, and blending textures seamlessly. Session 6: Camera Settings and Scene Composition Camera configurations: Focal length, depth of field, and exposure settings. Composing visually appealing scenes: Rule of thirds, focal points, and balance. Rendering interior and exterior scenes: Managing lighting challenges and reflections. Session 7: Real-Time Feedback and Interactive Rendering Introduction to Vray interactive rendering: Real-time feedback for quick adjustments. Utilizing Vray's denoiser for noise reduction in interactive mode. Enhancing productivity with interactive rendering: Modifying materials and lighting on the fly. Session 8: Optimizing Render Times Efficient render optimization techniques: Reducing noise and enhancing quality. Distributed rendering: Utilizing multiple machines for faster rendering. Troubleshooting common rendering issues: Flickering, artifacts, and texture problems. Session 9: Post-Processing and Presentation Post-production in Photoshop: Enhancing renders, adding depth, and adjusting colors. Creating compelling visual narratives: Adding people, context, and atmosphere. Designing professional presentation boards: Layout, annotations, and graphic elements. Session 10: Final Project and Portfolio Review Participants showcase their final Vray-rendered projects. Instructor-led critique and feedback session. Tips for building a strong portfolio: Choosing the best renderings and presenting your work effectively. By the end of this 10-hour course, participants will have a comprehensive understanding of Vray for Rhino, enabling them to create photorealistic renderings and significantly enhance their design visualization skills. Upon completing the Vray for Rhino Essentials course, participants will: Master Lighting Techniques: Expertly utilize various light sources. Create realistic lighting scenarios for diverse scenes. Advanced Material Proficiency: Manipulate complex materials and textures for lifelike renders. Understand reflective surfaces and material interaction. Optimize Rendering Settings: Fine-tune render configurations for optimal quality and speed. Implement noise reduction techniques for cleaner renders. Texture Mapping Mastery: Perfect UV mapping methods for accurate texture application. Seamlessly blend textures for realistic surface mapping. Effective Camera Use and Composition: Configure camera settings, depth of field, and exposure. Compose visually appealing scenes for impactful renders. Real-Time Rendering Skills: Utilize interactive rendering for immediate feedback and adjustments. Enhance scenes in real time for efficient workflow. Post-Processing Expertise: Enhance renders in post-production using software tools. Add depth, adjust colors, and create visually compelling final images. Professional Presentation Techniques: Design layouts, annotations, and context to create impactful visual narratives. Curate a strong portfolio with the best-rendered projects. By honing these skills, participants will produce photorealistic renders and significantly enhance their architectural and product visualization capabilities. Skills You'll Gain: Master lighting techniques for realistic visualization. Learn material manipulation and texture enhancement in Vray. Understand advanced rendering configurations for high-quality results. Explore global illumination concepts for lifelike scenes. Career Opportunities: Upon completing Vray for Rhino Essentials, you'll be well-equipped for various roles in the design and visualization industry, including: Architectural Visualizer: Create stunning architectural visualizations for presentations and client approvals. Product Designer: Enhance product design by creating photorealistic prototypes and visualizations. Interior Designer: Craft immersive interior spaces with realistic lighting and material textures. 3D Visualization Artist: Work in animation studios, gaming companies, or marketing agencies, producing high-quality 3D visualizations. Freelance Rendering Specialist: Offer your skills on platforms like Upwork or Fiverr, providing rendering services to clients worldwide. Course Highlights: Acquire fundamental skills in V-Ray for Rhino, covering lighting, materials, and rendering setups. Explore advanced techniques for lifelike textures, reflections, and global illumination effects. Master the workflow for crafting architectural renderings, both interior and exterior. Harness the power of V-Ray features like proxies, fur, and particle systems for dynamic visuals. Optimize render times and quality using efficient techniques and expert tips. Validate your expertise with a Certificate of Completion, showcasing your V-Ray proficiency. Access recorded lessons for future reference, enabling self-paced learning and continuous improvement. Professional Guidance: Learn from certified tutors and industry experts with extensive practical experience. Gain valuable insights and personalized feedback as you progress through the course, ensuring a comprehensive understanding of V-Ray for Rhino.

V-Ray for Rhino Essentials Training
Delivered in London or OnlineFlexible Dates
£360

CPR Training

5.0(10)

By Apex Learning

Overview This comprehensive course on CPR Training will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This CPR Training comes with accredited certification, 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 CPR Training. It is available to all students, of all academic backgrounds. Requirements Our CPR Training 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 Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 2 sections • 3 lectures • 06:08:00 total length •Introduction to CPR: 00:04:00 •Procedure for CPR: 00:04:00 •Additional Reading Materials - CPR Training: 06:00:00

CPR Training
Delivered Online On Demand6 hours 8 minutes
£12

Purchase Ledger Training

By Compete High

Overview With the ever-increasing demand for Purchase Ledger in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Purchase Ledger may be. Learning about Purchase Ledger or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Purchase Ledger . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Purchase Ledger is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Purchase Ledger course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Purchase Ledger course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Purchase Ledger course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Purchase Ledger , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Purchase Ledger , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Purchase Ledger , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Purchase Ledger course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 1 - Introduction to Purchase Ledger Introduction to Purchase Ledger 00:00 Module 2 - Purchase Ledger Account Purchase Ledger Account 00:00 Module 3 - Purchase Ledger Control Account Purchase Ledger Control Account 00:00 Module 4 - The Sales Ledger and the Purchase Ledger The Sales Ledger and the Purchase Ledger 00:00 Module 5 - Difference Between Sales Ledger and Purchase Ledger Difference Between Sales Ledger and Purchase Ledger 00:00 Module 6 - Reconciliation Reconciliation 00:00 Module 7 - Paperless Purchase Paperless Purchase 00:00 Module 8 - Auditing - Vouching of Ledger Auditing - Vouching of Ledger 00:00

Purchase Ledger Training
Delivered Online On Demand8 hours
£25

MySQL for developers

5.0(3)

By Systems & Network Training

MySQL for developers training course description This MySQL Developers training course is designed for MySQL Developers who have a good understanding of a MySQL database and experience of using SQL commands. The course provides further practical experience in more advanced MySQL commands and SQL statements including Stored Routines, Triggers and Event Scheduling. What will you learn Provide the skills needed to write more advanced queries and database maintenance statements on a MySQL database. Use advanced features of the MySQL Client. Use advanced data types. Manage the structure of databases and tables. Manage and using indexes. Write complex SQL query statements. Use advanced SQL expressions. Use advanced SQL functions. Perform advanced Insert, Update, Delete, Replace and Truncate Operations. Use user variable syntax and properties. Import and export data from within MySQL. Import and export data from the command line. Perform complex joins to access multiple tables. Perform complex subqueries. Create, manage and us views. Use prepared statements. Create and use stored routines. Create and use triggers. Obtain database metadata. Optimize queries. Work with the main storage engines. Debug MySQL applications. MySQL for developers training course details Who will benefit: MySQL Developers who have a basic understanding of a MySQL database and SQL commands as covered on the Introduction to MySQL course. Prerequisites: MySQL foundation Duration 5 days MySQL for developers training course contents Introduction Administration and Course Materials, Course Structure and Agenda, Delegate and Trainer Introductions. Client/server concepts MySQL client/server architecture, Server modes, Using client programs, Logging in options, Configuration files, Precedence of logging in options Hands on Using client/server The MySQL client program Using MySQL interactively, The MySQL prompts, Client commands and SQL statements, Editing, Selecting a database, Help, Safe updates, Using script files, Using a source file, Redirecting output into a file, Command line execution, Mysql output formats, Overriding the defaults, Html and xml output, MySQL Utilities. Hands on Using the MySQL client program Data types Bit data type, Numeric data types, Auto_increment, Character string data types, Character sets and collation, Binary string data types, Enum and Set data types, Temporal data types, Timezone support, Handling Missing Or Invalid Data Values, SQL_MODE options. Hands on Using data types Identifiers Using Quotes with identifier naming, Case sensitivity in Identifier naming, Qualifying columns with table and database names, Using reserved words as identifiers, Function names Hands on Using identifiers Databases Database properties, Creating a database, Selecting a database, Altering databases, Dropping databases, Obtaining database metadata, The SHOW command, The INFORMATION_SCHEMA database, The SHOW CREATE command Hands on Using databases Tables and indexes Table properties, Creating tables, Create table using Select or Like, Temporary tables and memory tables, Altering tables, Adding columns, Changing column widths and types, Renaming columns, Dropping columns, Adding constraints, Dropping constraints, Renaming tables, Change the table storage engine, Multiple alterations, Dropping tables, Emptying tables, Obtaining table metadata, Show create table, The information_schema, Index introduction, Structure of a mysql index, Creating and dropping indexes, Creating an index, Altering a table to add an index, Specifying index type, Dropping indexes, Obtaining Index Metadata. Hands on Creating, altering and dropping tables/indexes Querying for data The SQL select statement and MySQL differences, Advanced order by, Order by and collation, Order by with enum datatype, Order by with Set datatype, Ordering with distinct and group by Special features of union, Limit and order by clauses, Group By clause, Group_concat, Using Rollup in a Group By clause. Hands on Querying for data SQL Expressions and functions Components of expressions, Nulls, Numeric expressions, String expressions, Temporal expressions, Comparison functions, Flow control functions, Numeric functions, String functions, Temporal functions. Hands on Using expressions and functions Updating data Update operations and privileges, Inserting rows, Insert using a set clause, Inserting duplicate values, Replacing rows, Updating rows, Update using the order by and limit clauses, Deleting rows, The delete and truncate statements. Exercise: Inserting, updating, replacing and deleting data Connectors MySQL client interfaces, MySQL connectors, Oracle and community conectors, Connecting to MySQL server using Java and PHP connectors, MySQL and NoSQL, Innodb integration with memcached. Obtaining database metadata What is metadata?, The mysqlshow utility, The show and describe commands, Describing tables, The information_schema, Listing tables, Listing columns, Listing views, Listing key_columns_usage. Hands on Obtaining database metadata Debugging Mysql error messages, The show statement, Show errors, Show count(*) errors, Show warnings, Show count(*) warnings, Note messages, The perror utility. Hands on Debugging Joins Overview of inner joins, Cartesian product, Inner joins with original syntax, Non equi-join, Using table aliases to avoid name clashes, Inner Joins With ISO/ANSI Syntax, Outer Joins, Left outer joins, Right outer joins, Full outer joins, Updating multiple tables simultaneously, Updating rows in one table based on a condition in another, Updating rows in one table reading data from another, Deleting from multiple tables simultaneously, Deleting rows in one table based on a condition in another. Hands on Coding joins Subqueries Types of subquery, Multiple-column subqueries, Correlated subqueries, Using the ANY, ALL and SOME operators, Using the EXISTS operator, Subqueries as scalar expressions, Inline views, Converting subqueries to joins, Using subqueries in updates and deletes. Hands on Coding subqueries Views Why views are used, Creating views, View creation restrictions, View algorithms, Updateable views, Altering and dropping views, Displaying information about views, Privileges for views. Hands on Using views Import and Export Exporting using SQL, Privileges required to export data, Importing using SQL, Messages when loading data, Privileges required to load data, Exporting from the command line, Mysqldump main options, Importing from the command line, Mysqlimport main options. Hands on Importing and exporting User variables and prepared statements Creating User variables, User variables in a select, Prepared statements, The prepare statement, The execute statement, The deallocate statement, Using prepared statements in code, with connectors. Hands on Using variables and prepared statements Introduction to stored routines Types of stored routines, Benefits of stored routines, Stored routine features, Differences between procedures and functions, Introduction to the Block, Declaring variables and constants, Assigning values to variables, Definer rights and invoker rights, Using SELECT in stored routines, Altering and dropping stored routines, Obtaining stored routine metadata, Stored routine privileges and execution security. Hands on Writing simple stored routines Stored routines - program logic The IF .. THEN .. ELSEIF construct, The CASE statement, The basic loop, The while loop, The repeat loop, The iterate statement, Nested loops. Hands on Writing stored routines with program logic Stored routines - exception handlers and cursors Dealing with errors using Exception handlers, Cursors, What is a cursor?, Cursor operations, Declaring cursors, Opening and closing cursors, Fetching rows, Status checking. Hands on Writing stored routines with program logic Procedures with parameters Creating procedures with parameters, Calling Procedures With Parameters. Hands on Writing stored routines with parameters Functions What is a function?, The create function statement, Executing functions, Executing functions from code, Executing functions from SQL statements, The deterministic and SQL clauses. Hands on Writing functions Triggers Trigger creation, Restrictions on triggers, The create trigger statement, Using the old and new qualifiers, Managing triggers, Destroying triggers, Required privileges. Hands on Writing triggers Basic optimizations Normalisation of data to third normal form, Using indexes for optimization, General query enhancement, Using Explain to analyze queries, Choosing an INNODB or MYISAM storage engine, Using MySQL Enterprise Monitor in query optimization. Hands on Making use of basic optimizations More about indexes Indexes and joins Hands on Investigating indexes and joins

MySQL for developers
Delivered in Internationally or OnlineFlexible Dates
£2,797

Level 3 Teaching Assistant Award with Primary Teaching

By Kingston Open College

Premium Bundle of all Time | Ofqual Regulation + NCFE Awards + CPD Accreditation | Assessment & Tutor Support Included

Level 3 Teaching Assistant Award with Primary Teaching
Delivered Online On Demand5 days
£350

Paramedicine Training Study - CPD Accredited

4.7(26)

By Academy for Health and Fitness

24 Hours Left! Don't Let the Winter Deals Slip Away - Enrol Now! 6 in 1 Paramedicine Training Study Bundle "The paramedic is the critical link between life and death, between the healthcare system and the patient." Paramedicine workers are crucial members of the healthcare system who provide essential medical care and support to people in emergency situations. They play a vital role in the community by responding to emergency calls, assessing patients, and providing appropriate treatment and care. This Paramedicine Training Study Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Paramedic Study Course 02: Physiotherapy Diploma Course 03: Anatomy and Physiology of the Human Body Course 04: Public Health Course 05: Medical Law Course 06: Workplace First Aid Level 3 Our Paramedic Study course is designed to teach you from basic human anatomy to medical and legal issues. This course covers a wide range of topics that are essential for paramedicine. You will learn about common injuries, infection control, fluid and electrolyte balance, ambulance maintenance, and more. Throughout the bundle, you will also gain knowledge on basic first aid, paediatric first aid, and other medical emergencies. With a focus on initial assessment and effective communication, this course will help you prepare for the challenges of working in emergency medical services. Whether you're interested in a career in the ambulance service or want to enhance your existing healthcare knowledge, our Paramedicine Training Study course could be the perfect place to start. Learning Outcomes of Paramedicine Training Study: Understand basic human anatomy and physiology Demonstrate knowledge of common injuries and infection control Explain the principles of fluid and electrolyte balance Assess and manage medical emergencies Understand the importance of ambulance maintenance and safety Demonstrate an understanding of medical and legal issues Develop effective communication and interpersonal skills Apply critical thinking and problem-solving skills in emergency situations Why Prefer Us? All-in-one package of 6 premium courses' bundle Earn a certificate accredited by Get a free student ID card! (£10 postal charges will be applicable for international delivery) Globally accepted standard lesson planning Free Assessments 24/7 tutor support. Start your learning journey straightaway! *** Course Curriculum *** Our Paramedicine Training Study bundle courses consist of the following learning modules: Course 01: Paramedicine Training Study Module 01: Introduction to Paramedicine Training Study Module 02: Basic Human Anatomy Module 03: Basic First Aid Module 04: Paediatric First Aid Module 05: Common Injuries Module 06: Infection Control Module 07: Other Medical Emergency Module 08: Initial Assessment Module 09: Fluid and Electrolyte Balance Module 10: Ambulance Maintenance Module 11: Medical and Legal Issues Assessment Process Once you have completed all the courses in the Paramedicine Training Study bundle, you can assess your skills and knowledge with an optional assignment. Our expert trainers will assess your assignment and give you feedback afterward. CPD 65 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in pursuing a career in emergency medical services Healthcare professionals seeking to enhance their knowledge and skills Individuals looking to enter the healthcare industry Requirements You will not need any prior background or expertise. Career path Enrolling on this Paramedicine Training Study bundle package can lead you to the following career paths: Paramedic Paramedic Practitioner Prison Nurse Peripatetic Nurse Trainee Critical Care Paramedic Paramedic Advisor Clinical Nurse Clinical Assessor And many more! These job prospects generally pay between £15,000- £35,000 a year.

Paramedicine Training Study - CPD Accredited
Delivered Online On Demand40 hours
£29

Adobe Illustrator and Photoshop Masterclass Training

By ATL Autocad Training London

Adobe Illustrator and Photoshop Masterclass Training, your gateway to Photoshop and Illustrator. Learn with the best software for publishing and marketing materials. This comprehensive training covers Photoshop, Illustrator, and InDesign, offering step-by-step tutorials tailored for creative professionals. Click here for more info: Website Duration: 10 hours Approach: Individualized, Tailored Content, Flexible Pace, Personal Support Scheduling Flexibility: 1-on-1 sessions from Mon to Sat, 9 am to 7 pm, based on your availability. Course Title: Adobe Photoshop and Illustrator Mastery Workshop Duration: 10 Hours (Divided into 10 Modules) Module 1: Introduction to Adobe Photoshop (1 hour) Familiarization with Photoshop interface and tools Understanding bitmap graphics and resolution Basic image editing techniques (cropping, resizing, color adjustments) Significance of layers in design Module 2: Essential Photoshop Tools (1 hour) Mastery of selection tools (Marquee, Lasso, Magic Wand) Understanding brushes and their settings Introduction to the Pen tool for precise selections Working adeptly with layers and layer styles Module 3: Advanced Image Editing (1 hour) Proficiency in advanced color adjustments (Curves, Levels, Hue/Saturation) Techniques for photo retouching and manipulation Creating composite images using blending modes Application of filters and special effects for creative designs Module 4: Introduction to Adobe Illustrator (1 hour) Exploration of Illustrator interface and tools Working with vector graphics and paths Basic shapes and drawing tools Understanding anchor points and handles Module 5: Creating Vector Artwork (1 hour) Expert use of the Pen tool for precise vector illustration Creating and editing shapes and objects Mastery in handling gradients and patterns Understanding the Appearance panel Module 6: Illustrator Typography (1 hour) Text tools and advanced formatting options Crafting text effects and artistic typography Integration of text with shapes and images Working adeptly with text on a path Module 7: Combining Photoshop and Illustrator (1 hour) Importing Illustrator files into Photoshop and vice versa Efficient use of smart objects and vector shapes in Photoshop Creation of custom brushes and patterns in Illustrator for seamless use in Photoshop Designing posters and flyers by combining elements from both software Module 8: Integration with InDesign (1 hour) Exporting assets from Photoshop and Illustrator for InDesign Crafting layouts in InDesign using assets from both programs Understanding print and digital design nuances Preparing files for printing and online use Module 9: Advanced Techniques and Tips (1 hour) Creating custom actions and automation in Photoshop Mastery in advanced selection techniques Utilizing Illustrator's advanced tools (Pathfinder, Shape Builder, etc.) Exploration of creative design styles and trends Module 10: Final Projects and Portfolio (1 hour) Individual or group projects incorporating Photoshop and Illustrator skills Detailed review and feedback on the projects Preparation of a portfolio showcasing the work   Upon completion of the Adobe Photoshop and Illustrator Mastery Workshop, participants will: Master Advanced Design Techniques: Acquire expert skills in both Adobe Photoshop and Illustrator, delving into advanced tools, filters, and effects for intricate design work. Seamlessly Integrate Software: Learn to seamlessly integrate Photoshop and Illustrator, enabling the creation of dynamic and visually appealing designs by leveraging the unique strengths of both programs. Develop Creative Problem-Solving: Cultivate creative problem-solving abilities by exploring diverse design styles and industry-relevant trends, empowering the creation of innovative and captivating visuals. Construct Professional Portfolios: Gain the expertise to construct professional portfolios, showcasing a diverse range of projects incorporating advanced Photoshop and Illustrator techniques. Collaborate on Real-World Projects: Collaborate effectively on real-world design projects, combining Photoshop and Illustrator skills to produce high-quality marketing materials, promotional content, and digital artwork. Career Opportunities: Upon mastering Photoshop and Illustrator, participants can pursue a range of creative careers, including: Graphic Designer: Craft visually appealing designs for print and digital media, ranging from marketing materials to social media graphics. Digital Illustrator: Create intricate digital illustrations and artworks for various applications, including book covers, digital publications, and games. Web Designer: Develop engaging and user-friendly website layouts and elements, optimizing user experience through appealing visuals. Advertising Artist: Design compelling advertisements for print and online platforms, captivating audiences and promoting brands effectively. Freelance Designer: Work as a freelance designer, taking on diverse projects from clients and agencies, showcasing versatility in both Photoshop and Illustrator skills. By mastering these Adobe tools, participants open doors to a multitude of creative opportunities in the ever-expanding digital design industry. Skills Acquired: Participants in the Adobe Illustrator and Photoshop Masterclass Training will develop advanced skills in vector graphics, digital illustration, and photo manipulation using Adobe Illustrator and Photoshop. Key skills include: Precision Vector Graphic Design in Illustrator Creative Digital Illustration Techniques Advanced Photo Editing and Manipulation in Photoshop Job Opportunities: Upon completion, individuals can pursue roles such as: Graphic Designer Digital Illustrator Advertising Creative Branding Specialist Elevate Your Design Skills: Master Adobe Illustrator and Photoshop, crafting stunning graphics, logos, and digital illustrations. Understand design principles, tools, and workflows. Receive a recognized Certificate of Completion and access recorded lessons for future reference. Expert Guidance, Your Schedule: Learn from certified experts, tailored to your timetable-flexible online or in-person sessions, Monday to Sunday, 9 am to 8 pm. Enjoy lifetime email support for seamless learning. Unleash Your Creativity Today: Enroll now to ignite your creative potential in Adobe Illustrator and Photoshop. Elevate your designs effortlessly.

Adobe Illustrator and Photoshop Masterclass Training
Delivered in London or OnlineFlexible Dates
£348