7453 Courses delivered Online

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Introduction to Agile: Scrum and Project Management bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 33 course mega bundle that will exceed your expectations within your budget. The Introduction to Agile: Scrum and Project Management related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Introduction to Agile: Scrum and Project Management bundle will help you build a solid foundation to become a proficient worker in the sector. This Introduction to Agile: Scrum and Project Management Bundle consists of the following 30 CPD Accredited Premium courses - Course 01 :Agile and Scrum Course Course 02 :Complete Scrum Agile Training Course 03 :Agile Scrum Master Certification Course 04 :Project Management Training Course 05 :Practical Project Management Course 06 :Project Management: How to Build a Project Charter Course 07 :Business Project Manager Training Course 08 :Cost Control & Project Scheduling Course 09 :Introduction to Manufacturing Accounting: Project Costing Course 10 :Planning & Control Using Microsoft Project 2013, 2016 & 2019 Course 11 :Strategic Business Management - Online Diploma Course Course 12 :Business Performance Management Course 13 :Diploma in Lean Process and Six Sigma Course 14 :Financial Management Course 15 :Financial Analysis Course 16 :Financial Statement Analysis Masterclass Course 17 :Basic Business Finance Course 18 :Diploma in Business Analysis Course 19 :People Management Diploma Course 20 :Meeting Management Online Course 21 :Compliance Administrator Course 22 :Maximise Your Personal Productivity: Negotiation Skills Course Course 23 :Industrial and Organisational Psychology Course 24 :Dealing with Conflict at Work Course 25: Minute Taking Executive Training Course 26: Receptionist Skills Course 27: Time Management Training - Online Course Course 28: Complete Communication Skills Master Class for Life Course 29: Public Speaking Course 30: 10 Soft Skills for Workplace 3 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 01 :Career Development Plan Fundamentals Course 02 :CV Writing and Job Searching Course 03 :Interview Skills: Ace the Interview Learning Outcome This tailor-made Introduction to Agile: Scrum and Project Management bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Introduction to Agile: Scrum and Project Management Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 330 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Introduction to Agile: Scrum and Project Management bundle! This bundle is also ideal for professionals looking for career advancement. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Introduction to Agile: Scrum and Project Management Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields.

Are you consistently battling the clock, feeling there aren't enough hours in a day? Introducing the 'Time Management at QLS Level 3' course - a beacon for those seeking to optimise every moment. Dive deep into the crux of why managing your hours and minutes matters, exploring the myriad benefits. Unearth your current work methodologies, discern what truly matters, and bid farewell to the art of dilly-dallying. By the end, you'll not only set precise goals but also learn the secret sauce of executing them while skirting around common time traps. Ever felt your creative juices being hampered by poor time skills? Our modules equip you with techniques specifically tailored for creative endeavours. And to top it off, learn the finesse of anticipation and plug those pesky time leaks ensuring maximum efficiency. So, why wait? Take control of your hours, minutes, and seconds. Start a journey where you don't chase time; you master it. Learning Outcomes Understand the significance and advantages of adept time utilisation. Evaluate one's existing work methodologies and discern key priorities. Develop strategies to overcome procrastination and set clear, achievable objectives. Acquire tools and techniques to both plan and execute tasks efficiently. Recognise and mitigate common time siphons, enhancing productivity. Why choose this Time Management at QLS Level 3 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 Time Management at QLS Level 3 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 Time Management at QLS Level 3 course for? Individuals struggling to balance work, leisure, and personal commitments. Managers seeking to enhance their team's productivity and workflow. Creatives desiring a structured approach without stifling innovation. Students aiming for better academic achievements through improved scheduling. Entrepreneurs looking to maximise outcomes with limited time resources. Career path Project Manager: £45,000 - £70,000 Operations Director: £60,000 - £90,000 Productivity Consultant: £40,000 - £65,000 Creative Director: £50,000 - £80,000 Personal Coach (Time Management Specialisation): £30,000 - £55,000 Organisational Development Specialist: £35,000 - £60,000 Prerequisites This Time Management at QLS Level 3 does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Time Management at QLS Level 3 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £85 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Course Curriculum Module 01: Importance and Benefits of Time Management Importance and Benefits of Time Management 00:11:00 Module 02: Assess Your Current Work Practice Assess Your Current Work Practice 00:19:00 Module 03: Identifying the Priorities Identifying the Priorities 00:36:00 Module 04: Say 'No' to Procrastination Say 'No' to Procrastination 00:42:00 Module 05: Set Your Goals Set Your Goals 00:24:00 Module 06: Plan the Work Plan the Work 00:36:00 Module 07: Work the Plan Work The Plan 00:18:00 Module 08: Effective Time Management Techniques Effective Time Management Techniques 00:10:00 Module 09: Combat the Time Wasters Combat the Time Wasters 00:28:00 Module 10: Time Management for Creative Work Time Management for Creative Work 00:36:00 Module 11: The Art of Anticipating The Art of Anticipating 00:15:00 Module 12: Avoid Time Leaks Avoid Time Leaks 00:28:00 Assignment Assignment - Time Management at QLS Level 3 02:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

Unlock the secrets of the food industry with our comprehensive course in Food Technology and Food Processing Techniques. Delve into the science behind what we eat, from understanding food chemistry to exploring the cutting-edge realm of biotechnology. With modules spanning from the microscopic world of food microbiology to the practicalities of packaging and sustainability, you'll gain a holistic view of the field. Dive deep into processing techniques, equipping yourself with essential knowledge for a sustainable future in the food industry. Discover the intricacies of food production and preservation in a course designed to empower your understanding of the food technology landscape. With expertly crafted modules and hands-on learning, you'll be well-prepared to tackle challenges and seize opportunities in this dynamic field. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum of Food Technology and Food Processing Techniques Module 01 : Introduction to Food Technology Module 02 : Food Chemistry Module 03 : Food Biotechnology Module 04 : Food Microbiology Module 05 : Food Processing Techniques Part-1 Module 06 : Food Processing Techniques Part-2 Module 07 : Food Packaging and Sustainability Learning Outcomes: Analyze food compositions for optimal processing efficiency. Apply biotechnological methods for food production enhancement. Evaluate microbial impacts on food safety and preservation techniques. Demonstrate proficiency in various food processing techniques. Implement sustainable packaging solutions in food industry practices. Comprehend the broader implications of food technology on environmental sustainability. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals transitioning to remote work. Individuals seeking to enhance virtual collaboration skills. Remote employees looking to boost productivity. Freelancers and independent contractors. Managers overseeing remote teams. Students preparing for a virtual work landscape. Entrepreneurs building virtual businesses. Anyone eager to excel in remote work scenarios. Career path Remote Team Manager Virtual Project Coordinator Freelance Consultant Online Business Owner Virtual Communication Specialist Remote Productivity Coach Certificates Digital certificate Digital certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

***Personal Development : Personal Development*** Do you want to focus your attention on improving your sense of self, identity, knowledge, and desires? You can only do that if you enrol in our specific personal development course. You gain a solid awareness of individual growth, academic development, and individual development from this personal development. In addition to these, personal development courses also emphasise the mental, social, spiritual, and emotional aspects of personal growth. You may improve your productivity, self-assurance, time management abilities, and creativity with the aid of this personal development course. Additionally, this personal development training teaches you how to control your stress at work and communicate effectively. Enrol in our personal development course to unlock your hidden potential! Learning Outcomes Of Personal Development course After completing the Personal Development course, the learner will be able to - Learn everything there is to know about personal productivity and efficiency. Personal development teaches how to optimise your time. Personal development helps you learn how to improve your presentation skills. You can understand how to improve your research abilities in this personal development course. Personal development describes how to improve your presence. Learning the basics of self confidence and personality is also part of personal development training. Special Offers of this Personal Development: Personal Development Course This Personal Development Course includes a FREE PDF Certificate. Lifetime access to this Personal Development Course Instant access to this Personal Development Course Get FREE Tutor Support from Monday to Friday in this Personal Development Course >> Main Course: Personal Development >> Free Courses*** Course 01: Level 7 Diploma in Leadership and Management Course Course 02: Communication Skills Course Other Benefits of this Personal Development Course Free 03 PDF Certificate Lifetime Access Free Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the Personal Development course ] ***Personal Development : Personal Development*** Detailed Course Curriculum Industry Experts Designed this Personal Development course into 12 detailed modules. Assessment Method of Personal Development After completing each module of the Personal Development Course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Certification of Personal Development After completing the MCQ/Assignment assessment for this Personal Development course, you will be entitled to a Certificate of Completion from Training Tale which is completely free to download. Who is this course for? Personal Development : Personal Development This course is suitable for anyone who is dedicated to their professional development. Requirements Personal Development : Personal Development There are no specific requirements for this Personal Development course because it does not require any advanced knowledge or skills. Career path Personal Development : Personal Development This Level 5 Diploma in Personal Development could be the key to the leadership career of your dreams.

Do you want to prepare for your dream job but strive hard to find the right courses? Then, stop worrying, for our strategically modified Creative Writing, Copy Writing bundle will keep you up to date with the relevant knowledge and most recent matters of this emerging field. So, invest your money and effort in our 37 course mega bundle that will exceed your expectations within your budget. The Creative Writing, Copy Writing related fields are thriving across the UK, and recruiters are hiring the most knowledgeable and proficient candidates. It's a demanding field with magnitudes of lucrative choices. If you need more guidance to specialise in this area and need help knowing where to start, then StudyHub proposes a preparatory bundle. This comprehensive Creative Writing, Copy Writing bundle will help you build a solid foundation to become a proficient worker in the sector. This Creative Writing, Copy Writing Bundle consists of the following 30 CPD Accredited Premium courses - Course 1: Creative Writing Course 2: Copywriting Course Level 4 Course 3: Novel Writing and Publishing Course 4: Creative Writing Course: Writing Storybooks For Children Course 5: Diploma in Drama and Comedy Writing Course 6: Creative Writing Course - Short Stories Course 7: Creative Writing Course - Fiction Course 8: Creative Writing Course - Horror Course 9: Creative Writing Course - Novel Course 10: Creative Writing Course - Thriller Course 11: Creative Nonfiction Book Writing Course 12: News Writing: Journalism 101 Course 13: Selling E-books: The Best Way of Earning Online Course 14: Basics of Shopify: Earn through E-books Course 15: Blogger for Beginners Course 16: Business Writing Course 17: Business Writing - How You Can Become a Great Writer Course 18: Business Writing: Influence Your Readers Course 19: Write and Publish a Research Paper: Complete Guide v6 Course 20: How to Write a Research Paper in Law and Humanities Course 21: Freelance Masterclass - Become An Expert Copywriter Course 22: Content Writing & Copy Writing For SEO and Sales Course 23: Email Writing Training Course 24: Medieval History Course 25: Military History Course 26: Creative Advertising and Graphic Design for Everyone Course 27: Boost Your Confidence and Self-Esteem Course 28: Foundations of Leadership and Negotiation Skills Development Course 29: Personal Development and Productivity Level 2 Course 30: Public Speaking 7 Extraordinary Career Oriented courses that will assist you in reimagining your thriving techniques- Course 1: Career Development Plan Fundamentals Course 2: CV Writing and Job Searching Course 3: Interview Skills: Ace the Interview Course 4: Video Job Interview for Job Seekers Course 5:Create a Professional LinkedIn Profile Course 6:Business English Perfection Course Course 7:Networking Skills for Personal Success Learning Outcome This tailor-made Creative Writing, Copy Writing bundle will allow you to- Uncover your skills and aptitudes to break new ground in the related fields Deep dive into the fundamental knowledge Acquire some hard and soft skills in this area Gain some transferable skills to elevate your performance Maintain good report with your clients and staff Gain necessary office skills and be tech savvy utilising relevant software Keep records of your work and make a report Know the regulations around this area Reinforce your career with specific knowledge of this field Know your legal and ethical responsibility as a professional in the related field This Creative Writing, Copy Writing Bundle resources were created with the help of industry experts, and all subject-related information is kept updated on a regular basis to avoid learners from falling behind on the latest developments. Certification After studying the complete training you will be able to take the assessment. After successfully passing the assessment you will be able to claim all courses pdf certificates and 1 hardcopy certificate for the Title Course completely free. Other Hard Copy certificates need to be ordered at an additional cost of •8. CPD 370 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Ambitious learners who want to strengthen their CV for their desired job should take advantage of the Creative Writing, Copy Writing bundle! This bundle is also ideal for professionals looking for career advancement. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this course, all you need is - A smart device A secure internet connection And a keen interest in Creative Writing, Copy Writing Career path Upon completing this essential Bundle, you will discover a new world of endless possibilities. These courses will help you to get a cut above the rest and allow you to be more efficient in the relevant fields. Certificates CPD Accredited Digital certificate - Included CPD Accredited Hard copy certificate - Included

A positive work culture is essential for any organisation that wants to be successful. It can help to attract and retain top talent, boost productivity, and improve customer satisfaction. But how do you create a positive work culture? That's where this Building a Positive Work Culture: Principles of Organisational Behaviour Management course comes in.   In this course, you will learn the principles of organisational behaviour management. We will teach you about the essentials of leadership, decision-making, power and politics in an organisational setting. Explore the importance of effective team management, conflict resolution and negotiation in promoting a harmonious workplace. Learn to use practical learning and performance management insights to drive productivity and job satisfaction. This course also addresses the vital aspect of managing organisational change, enabling you to lead your team smoothly through transitions.   Finally, learn about organisational culture and its impact on behaviour. The curriculum ends with an understanding of how you can leverage these principles to build a culture that promotes positivity and overall well-being. By the end of the course, you will know how to build and maintain a positive work culture. Enrol today, and embark on a path to transforming your work environment into a beacon of positivity and productivity! Learning Outcomes: Upon completion of the Building a Positive Work Culture course, you will be able to:   Understand the fundamental principles of Organisational Behaviour Management. Comprehend the influence of individual behaviour, personality, and values in organisations. Gain insights into managing workplace emotions, attitudes, and stress effectively. Learn the principles of employee motivation and effective communication. Acquire skills in leadership and performance management. Understand the dynamics of power, politics, and decision-making in organisations. Master techniques for managing conflict, negotiation, and organisational change. Grasp the impact of organisational culture on behaviour and performance. Who is this course for: This Building a Positive Work Culture course is ideal for:   Aspiring and existing managers seeking to enhance their leadership skills. HR professionals aiming to create a positive work environment. Team leaders and supervisors focused on boosting team performance. Professionals seeking a career change into organisational development roles. Business owners wanting to improve their company culture. Certification After studying the course materials of the Sourdough Cooking Essentials: Discover Artisan Cooking course, there will be a written assignment test which you can take either during or at the end of the course. After passing the test, you will have a range of certification options.    A CPD Accredited PDF Certificate - £4.99 A CPD Accredited Hardcopy Certificate - £8.00. A PDF Transcript - £4.99 A Hardcopy Transcript - £9.99.   Select according to your needs, and we assure timely delivery of your chosen certificate. Requirements This professionally designed Sourdough Cooking Essentials: Discover Artisan Cooking course does not require you to have any prior qualifications or experience. It is open to everyone, and you can access the course from anywhere at any time. Just enrol and start learning! Career Path:  Completing this course paves the way for many exciting career opportunities. Participants can consider roles such as Organisational Development Manager, HR Manager, or Team Lead. Additionally, it opens doors to consultative roles, offering guidance to businesses on fostering a positive work culture. The skills acquired also equip learners for leadership positions across various sectors. Course Curriculum Module 01: Introduction to Organisational Behaviour Management Introduction to Organisational Behaviour Management 00:07:00 Module 02: Individual Behaviour, Personality and Values in Organisations Individual Behaviour, Personality and Values in Organisations 00:10:00 Module 03: Workplace Emotions, Attitudes and Stress Workplace Emotions, Attitudes and Stress 00:09:00 Module 04: Foundations of Employee Motivation Foundations of Employee Motivation 00:09:00 Module 05: Perception and Communication Perception and Communication 00:10:00 Module 06: Leadership Management in Organisations Leadership Management in Organisations 00:09:00 Module 07: Understanding Management Understanding Management 00:10:00 Module 08: Learning and Performance Management Learning and Performance Management 00:09:00 Module 09: Work Teams and Groups Management Work Teams and Groups Management 00:10:00 Module 10: Managing Power and Political Behaviour in Organisations Managing Power and Political Behaviour in Organisations 00:09:00 Module 11: Decision-making in Organisations Decision-making in Organisations 00:08:00 Module 12: Organisational Culture: The Impact on Organisational Behaviour Organisational Culture: The Impact on Organisational Behaviour 00:09:00 Module 13: Managing Conflict and Negotiation Managing Conflict and Negotiation 00:10:00 Module 14: Organisational Change Management Organisational Change Management 00:10:00

Overview By enroling in Speed Reading, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The Speed Reading course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Speed Reading course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Speed Reading Program. So enrol in our Speed Reading course right away if you're keen to envision yourself in a rewarding career. Description Enroling in this Speed Reading course can improve your Speed Reading perspective, regardless of your skill levels in the Speed Reading topics you want to master. If you're already a Speed Reading expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Speed Reading insights that will help you make the most of your time. This Speed Reading course will act as a guide for you if you've ever wished to excel at Speed Reading. Why Choose Us? After successfully completing the Speed Reading Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. Lifetime access to the whole collection of Speed Reading learning materials. Online test with immediate results Enroling in the course has no additional cost. You can study and complete the Speed Reading course at your own pace. Study for the Speed Reading course using any internet-connected device, such as a computer, tablet, or mobile device. Who Is This Course For? This Speed Reading course is a great place to start if you're looking to start a new career in Speed Reading field. This training is for anyone interested in gaining in-demand Speed Reading proficiency to help launch a career or their business aptitude.  Requirements The Speed Reading course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Speed Reading, without any fuss. Career Path This Speed Reading training will assist you develop your Speed Reading ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a Speed Reading professional story and personalise your path to a new career. Furthermore, developing this Speed Reading skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. Course Curriculum Module 01: Introduction to Speed Reading Introduction to Speed Reading 00:24:00 Module 02: Preparing Yourself for Effective Speed Reading Module 02: Preparing Yourself for Effective Speed Reading 00:14:00 Module 03: Speed Reading: Benefits and Obstacles Speed Reading: Benefits and Obstacles 00:23:00 Module 04: Relationship Between Reading and the Brain Relationship Between Reading and the Brain 00:23:00 Module 05: Skills and Techniques for Speed Reading Skills and Techniques for Speed Reading 00:20:00 Module 06: How to Improve Your Memory? How to Improve Your Memory? 00:24:00 Mock Exam Mock Exam - Speed Reading 00:20:00 Final Exam Final Exam - Speed Reading 00:20:00

Facebook is the world’s largest social network. With over a billion users it’s very likely that a proportion of your target customer audience will have a Facebook account. This course will look in detail at the use of Facebook as part of your marketing activity.

LinkedIn is a very valuable tool to find the key decision makers within certain companies. It’s used for finding the best point of contact, gaining familiarity with their background before a call or sales pitch and a lot more. Find out how it can be used to enhance your business.

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