19190 Teaching courses

Elevate your SQL skills with our comprehensive training course. Learn database management, query optimization, and data manipulation techniques. Enroll now to become proficient in SQL and propel your career in data-driven industries.

Mastering Critical Conversations (On-Demand) We will explore various obstacles to delivering 'challenging' messages effectively, including those that come from the external environment as well as those we encounter internally. After gaining insight into the brain science behind the biology of conflict and emotion, we will then examine a 5-step framework for delivering difficult messages. Paired and small group activities comprise a large portion of this interactive course, which culminates in a role play. What you will Learn At the end of this program, you will be able to: Recognize how a perceived threat by the brain translates into a physiological response of fight, flight, or freeze Utilize various techniques to mitigate an 'amygdala hijack' state Leverage a 5-step model to deliver 'challenging' news effectively Managing Difficult Conversations Obstacles to managing difficult conversations Understanding human nature Brain Science and the Biology of Emotion The unique challenge of social and emotional learning The limbic system and the amygdala hijack Self-regulation strategy for the amygdala hijack Delivering Challenging Messages Managing difficult conversations 5 steps for delivering a challenging message Verbal active listening techniques Preparing to deliver a challenging message (scenarios) Conversations Involving Emotion and Conflict Two types of conflict Spectrum of responses to conflict Psychological type preferences and conflict Critical conversation role play Creating an action plan

Mastering Critical Conversations: On-Demand We will explore various obstacles to delivering 'challenging' messages effectively, including those that come from the external environment as well as those we encounter internally. After gaining insight into the brain science behind the biology of conflict and emotion, we will then examine a 5-step framework for delivering difficult messages. Paired and small group activities comprise a large portion of this interactive course, which culminates in a role play. What You Will Learn At the end of this program, you will be able to: Recognize how a perceived threat by the brain translates into a physiological response of fight, flight, or freeze Utilize various techniques to mitigate an 'amygdala hijack' state Leverage a 5-step model to deliver 'challenging' news effectively Managing Difficult Conversations Obstacles to managing difficult conversations Understanding human nature Brain Science and the Biology of Emotion The unique challenge of social and emotional learning The limbic system and the amygdala hijack Self-regulation strategy for the amygdala hijack Delivering Challenging Messages Managing difficult conversations 5 steps for delivering a challenging message Verbal active listening techniques Preparing to deliver a challenging message (scenarios) Conversations Involving Emotion and Conflict Two types of conflict Spectrum of responses to conflict Psychological type preferences and conflict Creating an action plan

Overview Applied Economics Course 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 Applied Economics Course 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 05 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: General Concepts and Microeconomics Definition of 'Economy' and 'Economics' 00:04:00 Economics - Theoretical Foundations 00:01:00 Macro and Microeconomics 00:01:00 Microeconomics / Demand and Supply Analysis 00:03:00 The Law and Time of Supply 00:01:00 Equilibrium 00:01:00 Disequilibrium 00:02:00 Elasticity and Market Efficiency 00:02:00 Elasticity 00:03:00 Factors Affecting Demand Elasticity 00:02:00 Total and Marginal Revenue 00:03:00 Market Structure / Competitive Market 00:03:00 Monopoly 00:05:00 Monopoly and Efficient and Monopolistic Competition 00:03:00 Oligopoly and Monopoly 00:05:00 Monopsony in the Real World 00:01:00 Module 02: Macroeconomics Macroeconomics vs Microeconomics 00:03:00 Aggregated Demand and Supply, and GDP 00:03:00 Gross Domestic Product (GDP) 00:03:00 Economic Growth 00:02:00 Employment and Inflation 00:03:00 Full Employment and Underemployment 00:03:00 Natural Rate of Unemployment 00:03:00 Inflation 00:03:00 Deflation 00:03:00 Module 03: Economic Policies and Natural Market Failure Economic Policies 00:03:00 The Transition of Monetary Policy to the Economy 00:03:00 The Relationship between the Bank and the Government 00:02:00 Fiscal Policy 00:01:00 The Basics of Fiscal Policy 00:05:00 What does Fiscal Policy Affect? 00:01:00 Source of Market Failure 00:03:00 Externalities 00:02:00 Structural Market Failure 00:02:00 Information Asymmetry 00:03:00 Module 04: Exchange Rates and Trade Barriers Exchange Rate and Trade Barriers 00:03:00 Interest Rates 00:02:00 Components of Interest Rates 00:03:00 Trade Barriers 00:02:00 Tariffs 00:02:00 Taxation 00:03:00 Deadweight Loss 00:01:00 Module 05: Sub-Branches of Economics Financial Economics 00:02:00 International Economics 00:02:00 Transaction Cost 00:03:00 Labour Economics 00:02:00 Environmental Economics 00:02:00 Energy Economics 00:01:00 Assignment Assignment - Applied Economics 00:00:00

Duration 2 Days 12 CPD hours This course is intended for This course can be valuable for anyone who needs to write basic SQL or Transact-SQL queries. This includes anyone working with data as a data analyst, a data engineer, a data scientist, a database administrator or a database developer. It can also be useful for others peripherally involved with data, or wanting to learn more about working with data such as solution architects, students and technology managers. This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics. 1 - Introduction to Transact-SQL Work with schemas Explore the structure of SQL statements Examine the SELECT statement Work with data types Handle NULLs 2 - Sort and filter results in T-SQL Sort your results Limit the sorted results Page results Remove duplicates Filter data with predicates 3 - Combine multiple tables with JOINs in T-SQL Understand joins concepts and syntax Use inner joins Use outer joins Use cross joins Use self joins 4 - Write Subqueries in T-SQL Understand subqueries Use scalar or multi-valued subqueries Use self-contained or correlated subqueries 5 - Use built-in functions and GROUP BY in Transact-SQL Categorize built-in functions Use scalar functions Use ranking and rowset functions Use aggregate functions Summarize data with GROUP BY Filter groups with HAVING 6 - Modify data with T-SQL Insert data Generate automatic values Update data Delete data Merge data based on multiple tables Additional course details: Nexus Humans DP-080T00 Querying Data with Microsoft Transact-SQL training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the DP-080T00 Querying Data with Microsoft Transact-SQL course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Course Overview Learn how to use the most in-demand Java framework and become an expert in web development when you take this comprehensive training for Spring Boot Framework. Spring Boot is the popular open-source Java-based framework used to create microservices and helps developers create applications that run autonomously. By completing this training, you will have gained an industry advantage and awareness of valuable programming and Java scripting abilities. This Spring Boot tutorial is the perfect introduction to this helpful framework for all types of web developers. You will be taken through the concepts of Spring Stacks, guided through the procedure for practical implementations, and learn how to set up integral customer control stages. For the IT professional who wants to present or create a fully running application for specific uses, this invaluable knowledge will open many IT career doors for you. Spring into success by enrolling now. This best selling Spring Boot Framework has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Spring Boot Framework is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Spring Boot Framework is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Spring Boot Framework is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Spring Boot Framework, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Spring Boot Framework will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Spring Boot Framework to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Achieve proficiency in practical math skills with Functional Skills Maths Level 2. Build confidence and competence for everyday tasks and career advancement.

This course introduces you to SQL and Microsoft SQL Server in a practical way. You'll be able to learn the basics of SQL quickly and understand how to use SQL queries and statements with Microsoft SQL Server to extract data and analyze it for making productive marketing decisions.

Do you know how to maintain a safe and a respectful space at work? Is it accurate to say that you are missing leadership opportunities since you're sending the wrong message to others? Making everybody in your work environment feel welcome comes down to approaching everybody with respect. Enrol in this course and foster a safe & respectful workplace by learning how to treat everyone equally. Description: Equality and diversity exist to guarantee a comprehensive work environment, one where 'difference' is never an obstacle to landing a position or advancing in your profession. With the world ending up being more mobile and diverse, diversity has a vital importance in the work environment. This course will enable students to comprehend what diversity is all about, and how they can help make a more diverse world at work and home. So enrol! Who is the course for? Managers, supervisors and staff from various types of organisations who want to navigate workplace differences Students and business professionals who are interested in knowing more about the field of health and safety. Team leaders. Individuals who look forward to taking in leadership roles. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at the cost of £39 or in PDF format at the cost of £24. PDF certificate's turnaround time is 24 hours, and for the hardcopy certificate, it is 3-9 working days. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: The Diversity and Equality in Workplace Level 3 course will be very beneficial and helpful, especially to the following careers: Diversity program specialist. Diversity program officer. Policy analyst. Diversity and Equality in Workplace Module One - Getting Started 01:00:00 Module Two - Understanding Diversity 01:00:00 Module Three - Understanding Stereotypes 01:00:00 Module Four - Breaking Down the Barriers 00:30:00 Module Five - Verbal Communication Skills 00:30:00 Module Six - Non-Verbal Communication Skills 01:00:00 Module Seven - Being Proactive 00:30:00 Module Eight - Coping with Discrimination 01:00:00 Module Nine - Dealing with Diversity Complaints as a Person 01:00:00 Module Ten - Dealing with Diversity Complaints as a Manager 01:00:00 Module Eleven - Dealing with Diversity Complaints as an Organization 01:00:00 Module Twelve - Wrapping Up 00:15:00 Diversity and Equality Why Promote Equality and Diversity? 00:15:00 The Equality and Diversity Jigsaw Pieces 00:15:00 Integrating Equality and Diversity into Planning and Delivery 00:15:00 Building Equality into Teaching and Learning 00:15:00 Dealing with Harassment and Bullying 00:15:00 Diversity in Workplace: Disability Defining Terms 00:15:00 Dissecting Labels 00:30:00 Accessibility 00:15:00 The Cornerstones of Diversity 00:15:00 Encouraging Diversity by Hiring 00:30:00 Using the STOP Technique 00:15:00 Communication Essentials for Disability Awareness 00:30:00 Communication Styles 00:15:00 Critical Conversations 00:15:00 Activities Diversity and Equality in Workplace Level 3- Activities 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Diversity and Equality in Workplace Level 3 00:20:00 Final Exam Final Exam- Diversity and Equality in Workplace Level 3 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

***24 Hour Limited Time Flash Sale*** Financial Analysis, Corporate Finance with Financial Investigator Training Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Looking forward to becoming the Next Finance Guru in the world of fast-growing Corporates? Or want to be self-sufficient by enriching yourself with Finance knowledge? Welcome to the captivating world of financial analysis, corporate finance, and financial investigation. Our exclusive bundle, "Financial Analysis, Corporate Finance with Financial Investigator Training," is designed to empower learners like you with essential knowledge and skills in these dynamic fields. Embark on a journey that will not only expand your understanding but also boost your career prospects. With two QLS-endorsed courses and five CPD QS-accredited courses, this comprehensive bundle is a gateway to success. Within this bundle, you will find three QLS-endorsed courses that grant you industry-recognized qualifications. These courses, namely Financial Analysis, Introduction to Corporate Finance, and Finance: Financial Investigator, delve deep into their respective subjects and equip you with the expertise to excel. As a testament to your accomplishments, you will receive hardcopy certificates for each of these courses. Additionally, our bundle includes five CPD QS-accredited courses, ensuring that you stay at the forefront of the industry. Dive into the intricacies of Financial Management, Financial Risk Management, Accounting and Finance, Corporate Finance: Profitability in a Financial Downturn, and Corporate Finance: Working Capital Management. These courses provide valuable insights and keep you updated with the latest standards and practices. Moreover, as a bonus, you will receive five career-boosting courses absolutely free with this bundle. Enhance your professional journey with courses in Professional CV Writing, Job Search Skills, Self-Esteem & Confidence Building, Professional Diploma in Stress Management, and Complete Communication Skills Master Class. Immerse yourself in this unparalleled learning experience, seize the opportunity to gain a competitive edge, and unlock a world of possibilities in the realms of financial analysis, corporate finance, and financial investigation. Enrol today and embark on a transformative educational journey that will shape your future. Key Features of the Financial Analysis, Corporate Finance with Financial Investigator Training Bundle: 3 QLS-Endorsed Courses: We proudly offer 3 QLS-endorsed courses within our Financial Analysis, Corporate Finance with Financial Investigator Training bundle, providing you with industry-recognized qualifications. Plus, you'll receive a free hardcopy certificate for each of these courses. QLS Course 01: Financial Analysis QLS Course 02: Introduction to Corporate Finance QLS Course 03: Finance: Financial Investigator 5 CPD QS Accredited Courses: Additionally, our bundle includes 5 relevant CPD QS accredited courses, ensuring that you stay up-to-date with the latest industry standards and practices. Course 01: Financial Management Course 02: Finance: Financial Risk Management Course 03: Accounting and Finance Course 04: Corporate Finance: Profitability in a Financial Downturn Course 05: Corporate Finance: Working Capital Management In Addition, you'll get Five Career Boosting Courses absolutely FREE with this Bundle. Course 01: Professional CV Writing Course 02: Job Search Skills Course 03: Self-Esteem & Confidence Building Course 04: Professional Diploma in Stress Management Course 05: Complete Communication Skills Master Class Convenient Online Learning: Our Financial Analysis, Corporate Finance with Financial Investigator Training courses are accessible online, allowing you to learn at your own pace and from the comfort of your own home. Learning Outcomes: Acquire a comprehensive understanding of financial analysis and its practical applications. Develop a strong foundation in corporate finance, including financial planning and decision-making. Gain the skills to investigate financial activities, identify irregularities, and mitigate risks effectively. Analyse financial statements and interpret key financial ratios to assess business performance. Master the concepts of financial risk management and implement strategies to safeguard organisations. Demonstrate proficiency in accounting principles and practices, enabling informed financial decision-making. Learn techniques to optimise working capital management and navigate financial challenges during downturns. Explore the intricacies of financial analysis, corporate finance, and financial investigation with our comprehensive bundle, "Financial Analysis, Corporate Finance with Financial Investigator Training." This engaging course package is designed to provide you with the knowledge and expertise necessary to thrive in these interconnected domains. With three QLS-endorsed courses and five CPD QS-accredited courses, this bundle covers a wide range of topics, ensuring a well-rounded learning experience. Delve into the world of financial analysis, where you will gain a comprehensive understanding of its principles, techniques, and applications. Discover how financial statements are analysed, and learn to interpret key ratios to assess the financial health of organisations. Acquire the skills to make informed financial decisions and identify opportunities for growth and improvement. In the realm of corporate finance, you will explore the fundamental concepts that drive financial planning and decision-making within organisations. Understand the intricacies of capital budgeting, cost of capital, and capital structure, and develop the ability to optimise financial resources to maximise shareholder value. Moreover, gain insights into profitability management during financial downturns and learned strategies to navigate challenges successfully. The course also delves into the world of financial investigation, equipping you with the necessary skills to identify irregularities, detect fraud, and mitigate financial risks. Learn to apply investigative techniques and tools to uncover potential financial misconduct, ensuring the integrity and transparency of financial operations. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Finance professionals seeking to enhance their knowledge and skills in financial analysis, corporate finance, and financial investigation. Accounting professionals looking to broaden their understanding of financial management and corporate finance principles. Individuals interested in pursuing a career in finance, investment, or financial investigation. Entrepreneurs and business owners aim to make informed financial decisions and effectively manage their organisations' resources. Career path Financial Analyst: £35,000 - £70,000 Corporate Finance Manager: £50,000 - £100,000 Financial Investigator: £30,000 - £60,000 Risk Manager: £40,000 - £90,000 Accounting Manager: £35,000 - £70,000 Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included