4199 Courses

The Power of Acknowledgment (On-Demand) The Power of Acknowledgment is an ingenious and proven clear-cut behavioral change model. These behaviors and actions, when properly practiced by people on an ongoing basis, are transformational. They help people feel engaged, inspired and appreciated in heartfelt and authentic ways. According to author/trainer Judith W. Umlas' experience of 14 years of training and delivery practice globally, it will change your interactions with everyone in both your personal and professional life in profound and positive ways. In a business context, acknowledging others canincrease customer engagement and bottom-line results when you communicate with authenticity and understanding ofothers' needs. Acknowledging people can have a deep and powerful impact on changing attitudes, fostering collaboration, and achieving successful outcomes. The goal of this workshop experience is to identify and employ techniques for creating a more positive and meaningful connection between you and the people around you, and to improve your ability to develop a more rewarding and successful personal and professional life. You will learn valuable tools that you can put into immediate action. These will help you overcome barriers to acknowledging others in heartfelt and authentic ways. Inspiring stories, videos, and case studies will move and energize you. You will learn to practice new or enhanced communication skills in an interactive, engaging, high-impact way. This workshop is developed by author and trainerJudith W. Umlaswith 16 years of global training and delivery experience. Judy is the author of the ground-breaking bookThe Power of Acknowledgement, and creator ofThe Center for Grateful Leadership. Her work has been a catalyst for immediate, positive change in the lives of hundreds of thousands of people, and the lives of others that are part of their world. What You Will Learn At the end of this program, you will be able to: Use the 7 Key Principles of Acknowledgment Practice the 5 C's of Acknowledgment Improve your relationships in all facets of life Identify myths that get in the way of your expressing heartfelt and authentic acknowledgment, appreciation and gratitude to your team members and others Be a Champion for Change where you live, in your workplace and community Acknowledge people on a regular basis in ways that make a profound difference to them, to you, and to any organization The Power of Acknowledgment The 7 Principles of Acknowledgment Transforming Challenging Relationships Through Acknowledgment´ The Five Cs of Acknowledgement

You may be progressing your Reiki journey from Reiki Practitioner Level II (Okuden), or you may find yourself, as a current Reiki Master Practitioner, drawn to the wonderful and pure frequency of Reiki that is possible with Holy Fire III. Start your Reiki Master Practitioner journey with Sensei Alison, Advanced Reiki Master and Teacher. Find out more about Alison, Reiki and the British Reiki Circle at: https://british-reiki-circle.cademy.co.uk/about

Become a certified UI designer Learn how to create beautiful, pixel-perfect user interfaces Accelerate your career with an in-demand skillset Get a professional qualification in just 12 weeks Manage your own schedule with our flexible, self-paced online course Expand your career options UI skills are needed worldwide, and demand is growing. With a globally recognised qualification, you’ll become a more valuable, sought-after professional. Design with confidence You’ll understand the ‘why’ of good UI design by knowing the principles behind it. You’ll be able to defend your decisions and design with confidence. Work in a creative, rewarding job UI designers add personality and visual appeal to user interfaces. It’s an enjoyable career that rewards creativity: the perfect entry into tech for visually-minded people. A flexible, university-backed curriculum Our curriculum is university credit-rated and approved by the industry. Over 12 weeks, you’ll learn the principles and skills you need to become a confident UI designer. Study method Online, self-paced Duration 12 weeks Access to content 12 months Qualification Professional Certificate in UI Design Awarded by Scottish Qualifications Authority trading as SQA Additional info Exam(s) / assessment(s) is included in price Tutor is available to students Description During this 12 week, online course you will learn: Introduction to UI Design Brand and Personality Layout Design Principles Interactivity Typography Colour, shapes and effects Iconography and imagery Design process Presenting ideas UI design tools You will also work on a project and your portfolio with access to weekly mentor sessions, an active student community, and support from our student success team. Who is this course for? Graphic designers and digital designers who want to upskill to UI design UI designers who want to strengthen their knowledge and craft UX professionals who want to become more rounded product designers Anybody with a design background looking for a creative job in tech Requirements You don’t need experience in design or technology to enrol in our courses, although having one or both is a definite bonus. Our students come from a diverse mix of backgrounds, including project management, development, graphic design, product management, business analysis and so on. You need to be motivated and committed. We set a high bar. Studying for one of our professional qualifications requires a certain amount of time, energy and focus. You need to be comfortable learning in English. All video lessons, course materials, webinars, correspondence and the final exam are delivered in English. Career path Students typically graduate into UI Designer jobs. The average UI Designer salary in the UK with 3-5 years experience is £62,500. This is based on data from Payscale, Totaljobs, Indeed, Talent, and Glassdoor

12 week nutrition transformation. One to one and group support via live webinars and at home preparation. Get your health goals back on track with this guided nutrition course.

Step into the world of environmental healing with 'Ecological Restoration: Principles and Practices.' This course is an invitation to become a custodian of nature, restoring balance and vitality to ecosystems. Your educational adventure commences with an immersive introduction to ecological restoration, where you will grasp the essence of harmonizing nature's intricate systems with human activities. This program isn't just about absorbing knowledge; it's a clarion call to those who envision a greener, more sustainable world. As you journey deeper into the curriculum, you will engage with the vital processes of ecological assessment and planning, gaining expertise crucial for addressing environmental challenges. The course intricately weaves through the legal, policy, and ethical realms of ecological restoration, arming you with the knowledge to adeptly navigate its complexities. Delve into the science of community assembly and landscape ecology, crucial for a comprehensive understanding of ecosystem dynamics. The latter modules focus on hands-on restoration techniques and sustainable management practices, setting the stage for you to make a real-world impact. The course concludes by looking ahead, preparing you to be a vanguard in the ever-evolving sphere of ecological restoration. Learning Outcomes Acquire fundamental understanding of ecological restoration concepts. Develop expertise in ecological assessment and restoration planning. Learn about the legal, ethical, and policy frameworks in restoration. Understand community assembly theory and principles of landscape ecology. Gain practical skills in restoration techniques and sustainable resource management. Why choose this Ecological Restoration: Principles and Practices 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 Ecological Restoration: Principles and Practices course for? Aspiring and practicing environmental scientists. Conservationists and environmental managers. Individuals in environmental policy and law. Academics and students in ecology and related fields. Urban and landscape planning professionals. Career path Environmental Restoration Planner - £24,000 to £46,000 Wildlife Conservation Officer - £27,000 to £41,000 Habitat Restoration Engineer - £29,000 to £48,000 Resource Management Advisor - £31,000 to £53,000 Ecological Field Technician - £25,000 to £39,000 City and Regional Planning Specialist - £28,000 to £44,000 Prerequisites This Ecological Restoration: Principles and Practices does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Ecological Restoration: Principles and Practices 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 Ecological Restoration Introduction to Ecological Restoration 00:17:00 Module 02: Ecological Assessment and Planning Ecological Assessment and Planning 00:25:00 Module 03: Legal, Policy, and Ethical Considerations Legal, Policy, and Ethical Considerations 00:23:00 Module 04: Community Assembly Theory and Landscape Ecology Community Assembly Theory and Landscape Ecology 00:19:00 Module 05: Restoration Techniques and Interventions Restoration Techniques and Interventions 00:25:00 Module 06: Monitoring and Adaptive Management Monitoring and Adaptive Management 00:22:00 Module 07: Sustainable Resource Management and Future Directions Sustainable Resource Management and Future Directions 00:24:00

Have you ever encountered Anti-Social Behaviour and felt completely helpless? Maybe you've witnessed it on the streets or even experienced it yourself. It's a widespread issue that affects countless individuals, families, and communities. But what if there was a way to understand it better and learn how to prevent it? Our Anti-Social Behaviour course is designed to do just that. We've assembled a team of researchers and academics who have studied this topic extensively and condensed their knowledge into six modules. Each module is carefully crafted to provide you with a comprehensive overview of Anti-Social Behaviour, including its causes, impact, and prevention. Whether you're a concerned citizen or a professional in the field, this course is for you. You'll gain a deeper understanding of the factors that contribute to Anti-Social Behaviour and how it can be prevented. The course is delivered in a theoretical format, with no need for hands-on experience or practical skills. So why wait? Enrol right now! This Certificate in Anti Social Behaviour at QLS Level 3 course is endorsed by The Quality Licence Scheme and accredited by CPD QS (with 120 CPD points) to make your skill development & career progression more accessible than ever! Learning Outcomes Gain an in-depth understanding of the causes and impact of Anti-Social Behaviour Learn about the family influences that contribute to Anti-Social Behaviour Understand the Anti-Social Behaviour Order and how it is used in the UK Explore the link between anger and Anti-Social Behaviour Understand the traits and characteristics of those with Antisocial Personality Disorder Learn effective prevention strategies to reduce Anti-Social Behaviour in your community Why Prefer This Anti Social Behaviour Course? Opportunity to earn certificate a certificate endorsed by the Quality Licence Scheme & another accredited by CPD QS after completing the Anti Social Behaviour course Get a free student ID card! (£10 postal charge will be applicable for international delivery) Innovative and engaging content. Free assessments 24/7 tutor support. ****Course Curriculum**** Here is the curriculum breakdown of this Anti Social Behaviour Module 01: Overview of Anti Social Behaviour Module 02: Family Influences on Anti Social Behaviour Module 03: Anti Social Behaviour Order Module 04: Anger and Anti Social Behaviour Module 05: Understanding Antisocial Personality Module 06: Prevention of Anti Social Behaviour Assessment Process 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 Certificate in Anti Social Behaviour at QLS Level 3 course exam, you will be able to request a certificate at an additional cost that has been endorsed by the Quality Licence Scheme. CPD 120 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This course is perfect for: Concerned citizens who want to make a positive impact in their community Professionals working in fields such as social work, law enforcement, and community development Students and researchers interested in the topic of Anti-Social Behaviour Anyone who has experienced or witnessed Anti-Social Behaviour and wants to learn more Individuals interested in gaining theoretical knowledge on the topic Career path Our course will prepare you for a range of careers, including: Social Worker: £20,000-£40,000 per year Police Officer: £20,000-£50,000 per year Youth Worker: £17,000-£30,000 per year Community Development Officer: £20,000-£35,000 per year Criminal Justice Lawyer: £25,000-£100,000 per year Researcher in Criminology/Social Sciences: £25,000-£45,000 per year Certificates Certificate of completion Digital certificate - £10 Certificate in Anti Social Behaviour at QLS Level 3 Hard copy certificate - £89 Show off Your New Skills with a Certificate of Completion After successfully completing the Certificate in Anti Social Behaviour at QLS Level 3, 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 - £89 inside the UK £10 (including postal fees) for International Delivery Certificate Accredited by CPD QS £29 for Printed Hard Copy Certificate inside the UK £39 for Printed Hard Copy Certificate outside the UK (International Delivery)

🏠Welcome to the ultimate Housing Support Worker Training, your pathway to a rewarding career in social services! Are you passionate about making a positive impact in your community? Are you ready to embark on a fulfilling journey where you can empower individuals and families facing housing challenges? Look no further! Our comprehensive course equips you with the essential skills and knowledge needed to thrive in this vital role. 🌟   🔍 Discover the Benefits: Expert Guidance: Learn from seasoned professionals in the field who bring years of real-world experience to the table. Our instructors are dedicated to your success and will provide personalized support every step of the way. Practical Skills: Gain hands-on experience through immersive simulations, case studies, and role-playing exercises. Develop the ability to assess housing needs, advocate for clients, and navigate complex social systems effectively. Holistic Approach: Explore a range of topics, including housing laws and regulations, crisis intervention techniques, mental health awareness, and community resources. Our comprehensive curriculum ensures you're well-prepared to address diverse needs and challenges. Networking Opportunities: Connect with fellow students and industry professionals, expanding your professional network and opening doors to potential job opportunities. Our community is supportive and inclusive, fostering collaboration and growth. Flexible Learning: Access course materials anytime, anywhere, with our convenient online platform. Whether you're juggling work, family, or other commitments, our flexible schedule allows you to pursue your passion on your own terms.   🎯 Who is this for? This course is ideal for individuals seeking a meaningful career in social services, including: Aspiring social workers looking to specialize in housing support Community advocates passionate about homelessness prevention Case managers interested in expanding their skill set Recent graduates seeking to enter the field of human services Anyone with a heart for helping others and a desire to make a difference in their community No prior experience is required - just a dedication to learning and a commitment to serving others.   🚀 Career Path: Upon completing our Housing Support Worker Training, you'll be well-equipped to pursue various rewarding career paths, including: Housing Support Worker: Provide direct assistance to individuals and families experiencing housing instability, helping them access safe and affordable housing options. Case Manager: Advocate for clients, coordinate services, and develop personalized action plans to address housing needs and promote stability. Social Worker: Work within government agencies, nonprofit organizations, or healthcare settings to provide comprehensive support to vulnerable populations, including housing assistance. Community Outreach Coordinator: Engage with local communities to raise awareness, advocate for policy changes, and connect individuals with vital resources and services. With the demand for housing support workers on the rise, there's never been a better time to embark on this fulfilling career path. Take the first step towards making a meaningful difference in the lives of others - enroll in our Housing Support Worker Training today! Don't miss out on this opportunity to turn your passion for helping others into a rewarding career. Join us and become a catalyst for positive change in your community. Let's build a brighter future together! 🏡💼   🔍 Frequently Asked Questions (FAQ): Q: Can I enroll in the Housing Support Worker Training course without any prior experience in social services? A: Absolutely! Our course is designed to accommodate individuals from diverse backgrounds, including those who may be new to the field of social services. Our comprehensive curriculum covers all the essential knowledge and skills you'll need to succeed as a housing support worker, regardless of your previous experience. Q: How long does it take to complete the course? A: The duration of the Housing Support Worker Training course varies depending on factors such as your individual pace of learning and the specific program structure. However, most students can expect to complete the course within a few months of part-time study. Our flexible schedule allows you to progress at your own speed, ensuring you can balance your studies with other commitments. Q: Will I receive a certificate upon completion of the course? A: Yes, upon successfully completing the Housing Support Worker Training course, you will be awarded a certificate of completion. This certificate validates your achievement and demonstrates your readiness to enter the field of housing support. Our certificates are recognized and respected by employers in the social services sector. Q: Are there any prerequisites for enrolling in the course? A: There are no strict prerequisites for enrolling in the Housing Support Worker Training course. However, a genuine passion for helping others and a commitment to making a positive impact in your community are highly recommended. Additionally, while prior experience in social services is not required, having a basic understanding of human services concepts may be beneficial. Q: Is financial aid available for the course? A: We understand that investing in your education is a significant decision, and we strive to make our courses accessible to all individuals. While specific financial aid options may vary depending on your location and circumstances, we encourage you to explore potential scholarships, grants, or tuition assistance programs that may be available to you. Our admissions team is also available to provide guidance and support as needed. Q: How can I access the course materials? A: Our Housing Support Worker Training course is delivered through a user-friendly online platform, allowing you to access course materials anytime, anywhere, as long as you have an internet connection. Upon enrollment, you'll receive login credentials that grant you access to the full suite of resources, including lectures, readings, assignments, and interactive learning activities. Our platform is designed to accommodate a variety of learning styles and preferences, ensuring you have everything you need to succeed in your studies. Course Curriculum Module 1_ Introduction to the Role of a Housing Support Worker. Introduction to the Role of a Housing Support Worker. 00:00 Module 2_ Understanding and Assessing the Needs of Clients. Understanding and Assessing the Needs of Clients. 00:00 Module 3_ Housing Resources and Referral. Housing Resources and Referral. 00:00 Module 4_ Case Management. Case Management. 00:00 Module 5_ Advocacy and Systems Navigation. Advocacy and Systems Navigation. 00:00

Falls can happen to anyone, but the consequences can be serious, particularly for vulnerable individuals. Our Falls Prevention Basics Course offers a solid foundation for understanding why falls occur and how simple yet effective strategies can reduce risks. Whether you are supporting others or simply aiming to sharpen your knowledge, this course equips you with the insight needed to spot hazards and create safer environments with confidence. Designed with everyday relevance in mind, this course unpacks essential theories, explores common risk factors, and highlights preventive measures in a clear and straightforward manner. It is perfect for anyone seeking to enhance safety awareness without wading through jargon. Engage with easy-to-follow modules at your own pace and leave with the knowledge that could make a real difference in daily life. 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 Module 1: Falls Prevention Awareness Module 2: Risk Factors Module 3: Signs and Symptoms Module 4: Diagnosis and Treatment Module 5: Falls Risk Assessment Module 6: Preventive Strategies Learning Outcomes: Identify key factors contributing to falls for effective risk mitigation. Recognize early signs and symptoms, facilitating timely interventions. Understand diverse preventive strategies tailored to individual needs. Develop skills in comprehensive falls risk assessment for personalised care. Apply diagnostic insights to inform appropriate treatment measures. Contribute to a safer community by implementing proactive falls prevention measures. 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. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Healthcare professionals Caregivers and support staff Fitness and wellness enthusiasts Community health workers Occupational health and safety officers Rehabilitation specialists Social workers Individuals seeking to enhance their health knowledge Career path Healthcare Assistant Community Support Worker Occupational Therapist Social Services Officer Rehabilitation Coordinator Health and Safety Advisor Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. 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.

Start on a transformative journey into the heart of sustainable urban living with our Sustainable Urban Gardening and City Planning course. This unique program is your gateway to exploring the foundations of urban gardening, providing you with the knowledge to transform concrete jungles into thriving green spaces. Key Features: CPD Certified Developed by Specialist Lifetime Access From strategizing your urban garden plan to mastering crucial gardening techniques tailored for city environments, each module is a step towards creating lush, sustainable landscapes. Dive into container gardening strategies and the world of vertical gardening, unlocking the secrets of green walls that redefine urban aesthetics. Learn to craft edible urban landscapes, bringing both beauty and bounty to your city surroundings. Uncover the art of urban gardening in low-light conditions and discover sustainable irrigation techniques through rainwater harvesting. Delve into fostering biodiversity in urban settings and discover the power of community engagement and advocacy, turning your urban oasis into a sustainable haven. Join us in reshaping the urban landscape, where every module is a seed for a greener, more sustainable future. Course Curriculum Module 1: Exploring Urban Gardening Foundations Module 2: Strategizing an Urban Garden Plan Module 3: Crucial Gardening Techniques for Urban Environments Module 4: Container Gardening Strategies in Urban Spaces Module 5: Vertical Gardening and the World of Green Walls Module 6: Creating Edible Urban Landscapes Module 7: Urban Gardening in Low-Light Conditions Module 8: Sustainable Irrigation with Rainwater Harvesting Techniques Module 9: Urban Gardening and Fostering Biodiversity Module 10: Promoting Community Engagement and Advocacy for Sustainable Cities Learning Outcomes: Explore urban gardening foundations for sustainable and vibrant city landscapes. Strategize an urban garden plan, integrating greenery into urban planning. Master crucial gardening techniques adapted for thriving urban environments. Implement container gardening strategies in limited urban spaces effectively. Embrace vertical gardening and green walls, enhancing urban aesthetics sustainably. Create edible urban landscapes, harmonizing beauty and practicality seamlessly. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Urban dwellers keen on transforming their living spaces into green sanctuaries. City planners and architects interested in integrating sustainable green spaces. Environmentalists advocating for biodiversity and sustainable urban development. Community leaders aiming to foster green initiatives and engagement in cities. Gardening enthusiasts seeking eco-friendly practices for urban cultivation. Career path Urban Garden Planner Sustainable City Planner Green Space Architect Urban Biodiversity Consultant Community Engagement Coordinator for Sustainable Initiatives Urban Agriculture Advocate Certificates Digital certificate Digital certificate - Included Will be downloadable when all lectures have been completed.

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