245 Courses in Sheffield delivered Online

MySQL foundation training course description The MySQL foundation course covers the basics of the SQL language as implemented by MySQL. The course is designed to give delegates practical experience in writing SQL statements using the MySQL client program and MySQL Workbench. The basic SQL statements, including the use of SQL functions and the basic table and view handling statements are introduced. What will you learn Create, alter and drop a MySQL database. Write SQL statements. Use SQL expressions and functions. Create and alter tables, indexes and views. Use transactions. Grant and revoke access privileges. Export and import data. MySQL foundation training course details Who will benefit: Anyone who needs to access and work with a MySQL Database. Prerequisites: An understanding of databases and exposure to information technology in general would be useful. Duration 3 days MySQL foundation training course contents Database concepts What is a database? database management systems, tables, rows and columns, indexes, primary keys, unique constraints and foreign keys, client-server architecture, supported data types, storage engines and table types, Information_Schema and MySQL Databases. Hands on using a database. Using the MySQL client What is the MySQL client? getting started and logging in, selecting a database, client commands, entering and executing SQL statements, retrieving previous commands, creating, editing and executing SQL files, redirecting output into a file, command line execution of MySQL scripts. Hands on Using the MySQL client. Basic SELECT The SQL SELECT statement, case sensitivity, quotes, statement terminator, syntax conventions, SELECT clause, FROM clause, conditions and the WHERE clause, logical operators, ORDER BY clause, column aliases, arithmetic expressions, precedence of operators. Hands on querying the sample database. LIMIT, UNION and AGGREGATE functions The LIMIT clause, UNION, UNION ALL, aggregate functions, GROUP BY clause, using Rollup with GROUP BY, HAVING clause. Hands on using limit, union and aggregate functions. Subqueries and joins Subqueries, cartesian products, table aliases, natural joins, join using, join on, multi-table joins. Hands on using subqueries and joins. Numeric and character functions Function types, testing functions, numeric functions character functions. Hands on using numeric and character functions. Data, time and other functions Date and time column types, date and time formats, Date format function, functions to return date time, functions to extract components from date time, date time arithmetic, miscellaneous functions. Hands on using date, time and other functions. Databases and tables Creating a database, selecting a database, creating tables, Auto_increment, show create table, column operations, constraint operations, copying tables, renaming tables, changing engine for tables, dropping tables, temporary tables. Hands on maintaining databases and tables. Indexes and views What is an index? creating an index, reviewing indexes, dropping indexes, what is a view? creating views, view restrictions, dropping views. Hands on maintaining indexes and views. Managing data Inserting rows, replacing rows, updating rows, deleting rows, Truncate statement, The COMMIT and ROLLBACK commands, savepoints, implicit commits. Hands on managing data. Access control Creating users, renaming users, dropping users, granting privileges, revoking privileges. Hands on creating users, granting and revoking. Import and export Exporting using SQL, importing using SQL, exporting from the command line, importing from the command line. Hands on export and import data.

Level 5 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Are you looking for an online course produced by industry professionals to boost your skills and knowledge in Property Valuation & Investment? Our online courses are the perfect way to gain formal (and additional informal) CPD hours for RICS APC and AssocRICS candidates, as well as qualified surveyors. Our courses are perfect to study over 6-8 weeks, using a variety of learning resources, including videos, quizzes, worked examples and text.

Cultural competence, or the ability to interact sensitively and respectfully with individuals from diverse backgrounds, is an essential skill. Many business professionals face challenges in this area, such as misinterpreting cultural norms, leading to misunderstandings, and even unintentionally offending partners or clients. Discover the knowledge and skills to bridge these cultural gaps, fostering positive relationships, and enhancing business success in a globalized world. Participants will gain insights into cultural differences, communication styles, and strategies for fostering cross-cultural understanding. Learning Objectives The following are some of the key outcomes in this course: Learn what it means to be culturally competent and why it's advantageous. Explore techniques for developing greater cultural competence in all facets of your organization. Understand why it's important to understand cultural differences and how you can overcome potential barriers when delivering a presentation to an audience from another culture. Explore the stages of cultural sensitivity and how to improve your ability to effectively and authentically interact across cultures. Target Audience Managers, Team Leaders, Young Professionals

Financial Modelling Training is yet another 'Teacher's Choice' course from Teachers Training for a complete understanding of the fundamental topics. You are also entitled to exclusive tutor support and a professional CPD-accredited certificate in addition to the special discounted price for a limited time. Just like all our courses, this Financial Modelling Training and its curriculum have also been designed by expert teachers so that teachers of tomorrow can learn from the best and equip themselves with all the necessary skills. Consisting of several modules, the course teaches you everything you need to succeed in this profession. The course can be studied part-time. You can become accredited within 5 hours studying at your own pace. Your qualification will be recognised and can be checked for validity on our dedicated website. Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification CPD Certification from The Teachers Training Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Module 01: Basic Financial Calculations Basic Financial Calculations 00:36:00 Module 02: Overview of Financial Markets, Financial Assets, and Market Participants Overview of Financial Markets, Financial Assets, and Market Participants 00:37:00 Module 03: Financial Statement Modelling Financial Statement Modelling 00:30:00 Module 04: Types of Financial Models Types of Financial Models 00:35:00 Module 05: Sensitivity Analysis Sensitivity Analysis 00:38:00 Module 06: Sales and Revenue Model Sales and Revenue Model 00:36:00 Module 07: Cost of Goods Sold and Inventory Model Cost of Goods Sold and Inventory Model 00:38:00 Module 08: Valuation Methods Valuation Methods 00:32:00

Multicultural teams within organizations offer a diverse range of perspectives and experiences, but they also present unique challenges. Employees often struggle with understanding and respecting cultural differences, which can lead to communication breakdowns and misunderstandings. Building a cohesive and inclusive multicultural team demands effective cross-cultural communication, fostering cultural sensitivity, and resolving conflicts that may arise due to varying cultural norms. By addressing these issues, businesses can harness the true potential of multicultural teams, improving collaboration, creativity, and overall performance. Learning Objectives The following are some of the key outcomes in this course: Explore what it means to be part of a multicultural team and explore basic strategies managers can use to lead. Understand what cultural appropriation is, why it's problematic, and how to avoid engaging in it. Learn how to establish conversational norms around political issues at work and get some specific strategies for promoting and engaging in respectful discussions with co-workers. Discover four ways to accommodate beliefs in the workplace and get a few organizational do's and don'ts for navigating this. Target Audience Managers, Team Leaders, Young Professionals

Imagine a world where every conversation you have is meaningful and impactful. 'Mindful Listening' is designed to transport you to such a world. This course opens with an exploration of mindful listening, introducing you to the profound impact of truly hearing and understanding others. As you navigate through this journey, you will unlock the secrets to not just hearing, but truly comprehending and empathetically engaging with those around you. As you delve deeper into the curriculum, you will explore the relationship between mindfulness, meditation, and effective communication. The skills taught in this course go beyond mere listening; they encompass self-awareness, empathy, and the ability to foster meaningful connections in both personal and professional settings. By the end of your journey, you will have woven mindful listening into the fabric of your daily life, influencing how you interact with the world around you, promoting cultural sensitivity, and making a positive social impact. Learning Outcomes Comprehend the essence of mindful listening and its benefits. Apply mindfulness meditation techniques to enhance listening skills. Develop heightened self-awareness for improved communication. Utilize mindful listening to strengthen relationships. Integrate mindful listening practices into various professional and cultural contexts. Why choose this Mindful Listening 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 Mindful Listening course for? Individuals seeking to improve personal and professional relationships. Professionals in counselling, therapy, or coaching roles. Team leaders and managers in business settings. Educators and trainers aiming to enhance communication skills. Anyone interested in personal development and effective communication. Career path Life Coach - £30,000 to £50,000 Human Resources Specialist - £28,000 to £45,000 Mental Health Counsellor - £27,000 to £42,000 Corporate Trainer - £30,000 to £48,000 Mediator or Conflict Resolution Specialist - £31,000 to £46,000 Customer Service Manager - £29,000 to £44,000 Prerequisites This Mindful Listening does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Mindful Listening 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 Mindful Listening Introduction to Mindful Listening 00:16:00 Module 02: The Fundamentals of Mindful Listening The Fundamentals of Mindful Listening 00:20:00 Module 03: Mindfulness Meditation Mindfulness Meditation 00:20:00 Module 04: Developing Self-Awareness Developing Self-Awareness 00:16:00 Module 05: Mindful Communication Mindful Communication 00:21:00 Module 06: Mindful Listening in Relationships Mindful Listening in Relationships 00:19:00 Module 07: Mindful Listening in Professional Settings Mindful Listening in Professional Settings 00:20:00 Module 08: Mindful Listening Practises Mindful Listening Practises 00:20:00 Module 09: Cultivating Empathy and Compassion Cultivating Empathy and Compassion 00:21:00 Module 10: Integrating Mindful Listening into Your Life Integrating Mindful Listening into Your Life 00:20:00 Module 11: Mindful Listening and Cultural Sensitivity Mindful Listening and Cultural Sensitivity 00:22:00 Module 12: Mindful Listening and Social Impac Mindful Listening and Social Impac 00:20:00 Module 13: Final Reflection and Integration Final Reflection and Integration 00:20:00 Mock Exam Mock Exam - Mindful Listening 00:20:00 Final Exam Final Exam - Mindful Listening 00:20:00

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

This course will show delegates how to appraise projects in Excel, incorporate and communicate updates as they happen and ultimately understand how to convert an opportunistic property investment into a core asset that can be sold on.

Free Level 7 QLS Endorsed Certificate | CPD & CiQ Accredited | Audio Visual Training | 180 CPD Points | Lifetime Access