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

226 Courses in Cardiff delivered Online

RCN Accredited Asthma and COPD Course NORFOLK ICB ONLY

By BBO Training

'RCN Accredited Asthma and COPD' CourseThis course is a collaborative offering between your employer and BBO Training Ltd., designed to equip experienced healthcare professionals working in primary care settings with a comprehensive and holistic approach to managing patients with asthma and COPD. Even for those already holding a Diploma in either of these areas, the course has proven to be highly valuable, as indicated by positive evaluations from healthcare professionals.Course AimThe primary objective of this course is to provide qualified healthcare professionals with the necessary knowledge and skills to deliver effective asthma and COPD services in collaboration with their medical colleagues within the community healthcare setting. The course aims to raise awareness of these chronic conditions within the community, ensuring safe practice through the utilization of Patient Group Directions (PGDs) and protocols where appropriate. Participants will be clinically and theoretically prepared to establish and manage review and diagnostic clinics within their competency framework. Furthermore, the course emphasizes the clear differentiation between asthma and COPD.Clinical Practice Program and CompetenciesThroughout the course, you, along with your primary mentor, will organise and validate your clinical engagements, both under supervision and independently. By the time of your final assessment, these forms should be fully completed and ready for submission, accompanied by both your and your mentor's evaluations. Additionally, maintaining a log of all clinical hours and interactions is required, with a minimum of 36 hours.Teaching and Learning ApproachUpon completing this course, students will have the opportunity to:1. Participate in various sessions, including workshops, simulations, discussions, seminars, and tutorials, which can be conducted either virtually or in-person.2. Gain practical experience in asthma and COPD management within their local healthcare settings.3. Develop an in-depth understanding of treatments, including their composition, efficacy, indications, contraindications, and mechanisms of action, through clinical practice.4. Enhance advisory skills related to respiratory care on a broader scale.5. Attend dedicated sessions for clinical practice.6. Document a minimum of 36 hours of supervised clinical practice and maintain an ongoing reflective diary.Expected Course ContentWorkshops, Discussion Groups, Lectures, and Assessment: 40 hoursClinical Practice: A minimum of 36 hoursVisits and Private Study: 44 hoursPrivate study time is essential for reading, conducting factual research on treatments through online sources, and accessing the library for literature searches. This time will facilitate writing, referencing, completing your reflective diary, and preparing for the final assessment.AssessmentSuccessful completion of all components is required. Components 2 to 4 must be passed to complete the course. A resit option is available for any component that is not initially passed, limited to one attempt.1. Reflective Diary: This ongoing document, produced by the student throughout the course, is validated by both the student and mentor. While not directly marked, its completion is integral to your portfolio of evidence.2. Clinical Outcomes: These must be validated and passed by your mentor, with all outcomes achieved, along with a log of clinical hours.3. VIVA: A minimum pass mark of 50% is required.4. Test of Knowledge: A minimum pass mark of 50% is necessary (conducted at the end of the initial study days).Learning OutcomesUpon completion of this course, students will be capable of:1. Evaluating and showcasing clinical competence through a reflective diary/log.2. Demonstrating clinical assessment and treatment proficiency in a VIVA examination and knowledge assessment.3. Effectively educating individuals about self-management and enhancing their understanding of their condition.4. Displaying sensitivity and competence in obtaining comprehensive patient histories.5. Adapting care for diverse patient groups and their unique needs.6. Fulfilling professional responsibilities, including meticulous record-keeping and maintaining confidentiality.7. Teaching the use of various inhalers and assessment equipment.8. Developing fundamental assessment and examination techniques for respiratory conditions.9. Operating with Patient Group Directions and protocols for asthma and COPD care.10. Assessing, planning, implementing, and evaluating individual patient needs comprehensively.

RCN Accredited Asthma and COPD Course NORFOLK ICB ONLY
Delivered OnlineFlexible Dates
£1,200

Professional Certificate in Understanding Strategic Models & Tools in London 2024

4.9(261)

By Metropolitan School of Business & Management UK

The course explores the nature and utility of tools and models in the development of organizational strategy. The learner will be able to strategise based on the theoretical perspectives offered in this programme and utilise the power of strategic analysis tools. After the successful completion of this lecture, you will be able to understand the following: What are strategic models? Strategic Models & Tools. Mintzberg Model of Strategy Ansoff Matrix Balanced Mandatory Card Analysis Sensitivity Analysis Organisational Integration Merger And Acquisition Gap Analysis Product Portfolio VIDEO - Course Structure and Assessment Guidelines Watch this video to gain further insight. Navigating the MSBM Study Portal Watch this video to gain further insight. Interacting with Lectures/Learning Components Watch this video to gain further insight. Understanding Strategic Models & Tools Quiz: Understanding Strategic Models & Tools Put your knowledge to the test with this quiz. Read each question carefully and choose the response that you feel is correct. All MSBM courses are accredited by the relevant partners and awarding bodies. Please refer to MSBM accreditation in about us for more details. There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. The certificate is designed to enhance the knowledge of the learner in the field. This certificate is for everyone eager to know more and gets updated on current ideas in their respective field. We recommend this certificate for the following audience. CEO, Director, Manager, Supervisor Learning and Development Manager Strategy Manager Change Manager Organizational Behaviour Specialist Operations Manager Team Lead Average Completion Time 2 Weeks Accreditation 1 CPD Hour Level Advanced Start Time Anytime 100% Online Study online with ease. Unlimited Access 24/7 unlimited access with pre-recorded lectures. Low Fees Our fees are low and easy to pay online.

Professional Certificate in Understanding Strategic Models & Tools in London 2024
Delivered Online On Demand14 days
£27

Bereavement and Grief Counselling

4.5(3)

By Studyhub UK

Embark on a transformative journey of healing and support with our 'Bereavement and Grief Counselling' course. Delve into the complexities of grief and bereavement, exploring the profound impact of loss on individuals and communities. From understanding the concept of counselling to addressing special issues in grief, this course offers comprehensive insights and practical strategies to navigate the grieving process. Throughout this course, you'll uncover the nuances of bereavement and grief, gaining a deep understanding of when grief begins and how it manifests in different circumstances. Explore the effects of sudden death and learn how to navigate mourning specific losses with empathy and sensitivity. Dive into the complexities of complicated grief reactions, equipping yourself with the skills to provide meaningful support to those experiencing profound loss. By the end of this course, you'll emerge with the knowledge and expertise to provide compassionate bereavement counselling and facilitate grief resolution. Gain insights into supporting children through grief and learn about ethical considerations in grief counselling practice. Whether you're a professional seeking to expand your skills or someone passionate about supporting others through challenging times, this course provides invaluable guidance and resources for navigating the delicate terrain of grief and bereavement. Learning Outcomes: Understand the concept of counselling and its application in bereavement support. Identify the stages and manifestations of grief and bereavement in life. Recognize the impact of sudden death and specific losses on the grieving process. Navigate complicated grief reactions with empathy and sensitivity. Provide professional help and ethical support for individuals experiencing grief and bereavement. Why buy this Bereavement and Grief Counselling? 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. Certification After studying the course materials of the Bereavement and Grief Counselling there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this Bereavement and Grief Counselling course for? Counsellors and therapists seeking to specialize in grief and bereavement counselling. Healthcare professionals interested in expanding their expertise in supporting patients through loss. Educators and social workers aiming to better understand and address grief in their communities. Individuals looking to provide compassionate support to friends and family members experiencing bereavement. Anyone interested in learning about the complexities of grief and enhancing their ability to provide meaningful support. Prerequisites This Bereavement and Grief Counselling does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Bereavement and Grief Counselling 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. Career path Counsellor: £24,000 - £40,000 Per Annum Social Worker: £25,000 - £40,000 Per Annum Psychologist: £35,000 - £60,000 Per Annum Hospice Care Worker: £20,000 - £30,000 Per Annum Mental Health Nurse: £24,000 - £40,000 Per Annum Bereavement Support Worker: £20,000 - £35,000 Per Annum Course Curriculum Module 01: Concept of Counselling Concept of Counselling 00:10:00 Module 02: Bereavement and Grief in Life Bereavement and Grief in Life 00:10:00 Module 03: When Does Grief Begin? When Does Grief Begin? 00:10:00 Module 04: Effect of Sudden Death Effect of Sudden Death 00:10:00 Module 05: Mourning Specific Losses Mourning Specific Losses 00:10:00 Module 06: Complicated Grief Reactions Part 1 Complicated Grief Reactions Part 1 00:10:00 Module 07: Complicated Grief Reactions Part 2 Complicated Grief Reactions Part 2 00:10:00 Module 08: Special Issues in Grief Special Issues in Grief 00:10:00 Module 09: Children and Grief Children and Grief 00:10:00 Module 10: Professional Help for Adults Professional Help for Adults 00:10:00 Module 11: Grief Counselling and Grief Resolution Grief Counselling and Grief Resolution 00:10:00 Module 12: Ethical Issues in Grief Counselling Practice Ethical Issues in Grief Counselling Practice 00:10:00

Bereavement and Grief Counselling
Delivered Online On Demand2 hours
£10.99

Financial Modelling Best Practices

By Capital City Training & Consulting Ltd

Enroll today to learn methods and techniques used to build financial models at the world's leading banks and financial institutions. Create rigorous models, gain strategic insight and advance your finance career. 8+ Hours of Video 17+ Hours to Complete50+ Interactive Exercises1 Recognised Certificate Course Overview Our comprehensive Best Practice Financial Modelling certification program teaches the essential skills needed to build robust forecast models for companies, and prepare you for careers in investment banking, private equity, corporate finance, and business valuation. “I was previously unsure of all the financial jargon and concepts, now I feel I have taken steps towards getting the big picture of finance. I really liked the Excel web integration!” Rachel Crawford Course Highlights Essentials of financial model construction and design principles Flexible time frameworks, forecasting operations, and linking historical data Working capital modelling from an analyst perspective Depreciation, debt structuring, interest expenses, and tax modelling Key analysis techniques like DuPont Analysis and Discounted Cash Flow Sensitivity analysis, scenario modelling, credit, and liquidity analysis Certificate Upon Successful Completion

Financial Modelling Best Practices
Delivered Online On Demand8 hours
£150

Debt Collector (Debt Management) Diploma Training

By Compliance Central

Incredible Things Originate from a Little Bundle Special Price Cut Offer Are you looking to enhance your Debt Collector skills? If yes, then you have come to the right place. Our comprehensive courses on Debt Collector will assist you in producing the best possible outcome by mastering the Debt Collector skills. Get 6 CPD Accredited Courses for only £41! Offer Valid for a Limited Time!! Hurry Up and Enrol Now!!! Course 01: Debt Management Plan Course 02: Financial Modelling and Valuation Methods Course 03: Financial Analysis Course 04: Pension Course 05: Principles of Insurance & Insurance Fraud Course 06: Financial Investigator/Fraud Investigator The Debt Collector bundle is for those who want to be successful. In the Debt Collector bundle, you will learn the essential knowledge needed to become well versed in Debt Collector. Our Debt Collector bundle starts with the basics of Debt Collector and gradually progresses towards advanced topics. Therefore, each lesson of this Debt Collector course is intuitive and easy to understand. Why would you choose the Debt Collector course from Compliance Central: Lifetime access to Debt Collector courses materials Full tutor support is available from Monday to Friday with the Debt Collector course Learn Debt Collector skills at your own pace from the comfort of your home Gain a complete understanding of Debt Collector course Accessible, informative Debt Collector learning modules designed by expert instructors Get 24/7 help or advice from our email and live chat teams with the Debt Collector bundle Debt Collector Curriculum Breakdown of the Debt Collector Bundle Curriculum Breakdown of the Debt Collector Bundle Course 01: Debt Management Plan Module 01: Introduction to Debt Management Introduction to Debt Management Module 02: Long Term and Short Term Debt Long Term and Short Term Debt Module 03: Identifying Your Debt Identifying Your Debt Module 04: Debt Management Plan Debt Management Plan Module 05: Debt Assessment Debt Assessment Module 06: Debt Financing Debt Financing Module 07: Building Budget Building Budget Module 08: Debt Counselling Debt Counselling Module 09: When Is Debt Good? When Is Debt Good? Module 10: Avoiding Debt Problems Avoiding Debt Problems Module 11: How to Handle Debt Collectors How to Handle Debt Collectors Module 12: How to Get Out of Debt How to Get Out of Debt Module 13: Dealing with Bankruptcy and Insolvency Dealing with Bankruptcy and Insolvency Module 14: Laws and Regulations Laws and Regulations Course 02: Financial Modelling and Valuation Methods Module 01: Basic Financial Calculations Basic Financial Calculations Module 02: Overview of Financial Markets, Financial Assets, and Market Participants Overview of Financial Markets, Financial Assets, and Market Participants Module 03: Financial Statement Modelling Financial Statement Modelling Module 04: Types of Financial Models Types of Financial Models Module 05: Sensitivity Analysis Sensitivity Analysis Module 06: Sales and Revenue Model Sales and Revenue Model Module 07: Cost of Goods Sold and Inventory Model Cost of Goods Sold and Inventory Model Module 08: Valuation Methods Valuation Methods Course 03: Financial Analysis Section-1. Introduction Financial Statement Analysis Objectives Financial Analysis Methods in Brief Ratio Analysis Section-2. Profitability Gross Profit Operating Margin Ratios Net Profit Expense Control Ratios ClassRoom Discussion for some other expenses Use of Profitability Ratio to Understand Competitive advantage and Business Models Section-3. Return Ratio Return on Assets and FIxed Assets Return on Capital Employed Case Study Analysis of three telecom companies Cautions for using return ratios on face value Ratios which help to understand how efficiently assets are used How we measure utilisation of assets not recorded in Balance Sheet Section-4. Liqudity Ratio Liquidity Ratio to understand Risk inherent in companies Long Term Liquidity Ratios Section-5.Operational Analysis Financial Analysis Measure meant to understand efficiency in other operations Summarise - Ratios use for operational analysis Dupont Analysis to understand opportunities in optimising return on equity Section-6. Detecting Manipulation Detecting Manipulation in accounts - Fake Sales Detecting Manipulation - Wrong Depreciation and others Pricing Decisions How to make Capex Decisions Course 04: Pension Pension Module 01: Overview of the UK Pension system Module 02: Type of Pension Schemes Module 03: Pension Regulation Module 04: Pension Fund Governance Module 05: Law and Regulation of Pensions in the UK Module 06: Key Challenges in UK Pension System Course 05: Principles of Insurance & Insurance Fraud Principles of Insurance & Insurance Fraud Module 01: Principles of Insurance Module 02: General Insurance Module 03: Insurance Fraud Module 04: Underwriting Process Course 06: Financial Investigator/Fraud Investigator Module 01: Introduction to Financial Investigator Introduction to Financial Investigator Module 02: Introduction to Financial Investigation Introduction to Financial Investigation Module 03: Characteristics of Financial Crimes Characteristics of Financial Crimes Module 04: Categories of Financial Crimes Categories of Financial Crimes Module 05: Financial Crime Response Plan Financial Crime Response Plan Module 06: Collecting, Preserving and Gathering Evidence Collecting, Preserving and Gathering Evidence Module 07: Laws against Financial Fraud Laws against Financial Fraud CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? The Debt Collector bundle helps aspiring professionals who want to obtain the knowledge and familiarise themselves with the skillsets to pursue a career in Debt Collector. It is also great for professionals who are already working in Debt Collector and want to get promoted at work. Requirements To enrol in this Debt Collector course, all you need is a basic understanding of the English Language and an internet connection. Career path The Debt Collector bundle will enhance your knowledge and improve your confidence in exploring opportunities in various sectors related to Debt Collector. Debt Recovery Specialist: £20,000 to £35,000 per year Collections Agent: £18,000 to £30,000 per year Credit Control Officer: £22,000 to £35,000 per year Debt Collection Team Leader: £25,000 to £45,000 per year Certificates CPD Accredited PDF Certificate Digital certificate - Included Get 6 CPD accredited PDF certificate for Free. Hard copy certificate Hard copy certificate - £9.99 CPD Accredited Hard Copy Certificate for £9.99 each. Delivery Charge: Inside the UK: Free Outside of the UK: £9.99

Debt Collector (Debt Management) Diploma Training
Delivered Online On Demand18 hours
£41

Supporting Vulnerable Clients

By Immigration Advice Service

A course designed for Immigration Advisors to support clients with mental health and trauma related experiences. View our Supporting Vulnerable Clients training course dates below, available remotely via Microsoft Teams. Empower yourself with the essential skills to support and advocate for vulnerable clients in our comprehensive 4 hour course on Supporting Vulnerable Clients. This course is designed to equip professionals with the knowledge and techniques needed to navigate complex situations containing , vulnerability, trauma, communication styles, and more. Moving beyond theory, this course offers participants hands-on skills practice and immersive activities to deepen their understanding of trauma and trauma responses. Join us in this engaging virtual session to elevate your ability to make a positive impact on the lives of vulnerable clients. Professionals learn to deliver disappointing news with sensitivity, navigating emotional responses such as anger, upset, and blame. Techniques for gracefully concluding conversations are explored, ensuring that participants leave with the skills to handle even the most challenging client interactions. Whilst this course is designed for Immigration Advisors, Solicitors and those working with clients in a range of capacities, this is an open course to individuals with experiences in alternative fields and available to those with an interest in attending.   Course joining links, materials and instructions are sent out 24hours before the course starts. Immigration Advice Service has been providing professional immigration services for over 10 years in the public, private and corporate sectors. Our Supporting Vulnerable Clients training course will give you all the knowledge you need about how to support clients with mental health and trauma related conditions. This an opportunity not to be missed by Immigration Advisors, Lawyers, Solicitors and Legal Professionals. Topics: What is “vulnerability” and what makes a client vulnerable? Trauma Impact of trauma on behaviour, communication Introduction to protective factors To recognise, highlight, empower Building rapport Responding to disclosures Responding with empathy Processing disclosures – emotionally and for administrative purposes Navigating uncertainty Having conversations about potential changes to the law when you don’t have the answers Managing aggression & understanding communication styles & cultural differences Delivering disappointing news Navigating expressions of emotion following this – anger, upset, blaming etc Preparing for & ending conversations Supporting yourself – looking after yourself   Session will include skills practice, & developing an understanding of trauma and trauma responses

Supporting Vulnerable Clients
Delivered OnlineFlexible Dates
£120

MySQL for developers

5.0(3)

By Systems & Network Training

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

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

How To Deal With Difficult People Training

4.8(9)

By Skill Up

Description Engaging in art licensing is a perfect opportunity to improve your passive earnings. The Art Licensing: Sell Your First

How To Deal With Difficult People Training
Delivered Online On Demand1 hour 24 minutes
£25

Financial Modelling Course - Learn Online

4.9(27)

By Apex Learning

Overview This comprehensive course on Financial Modelling Course - Learn Online will deepen your understanding on this topic.After successful completion of this course you can acquire the required skills in this sector. This Financial Modelling Course - Learn Online comes with accredited certification, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. Who is This course for? There is no experience or previous qualifications required for enrolment on this Financial Modelling Course - Learn Online. It is available to all students, of all academic backgrounds. Requirements Our Financial Modelling Course - Learn Online is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G.There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Having these various qualifications will increase the value in your CV and open you up to multiple sectors such as Business & Management, Admin, Accountancy & Finance, Secretarial & PA, Teaching & Mentoring etc. Course Curriculum 1 sections • 8 lectures • 04:26:00 total length •Module 01: Basic Financial Calculations: 00:34:00 •Module 02: Overview of Financial Markets, Financial Assets, and Market Participants: 00:35:00 •Module 03: Financial Statement Modelling: 00:28:00 •Module 04: Types of Financial Models: 00:33:00 •Module 05: Sensitivity Analysis: 00:36:00 •Module 06: Sales and Revenue Model: 00:34:00 •Module 07: Cost of Goods Sold and Inventory Model: 00:36:00 •Module 08: Valuation Methods: 00:30:00

Financial Modelling Course - Learn Online
Delivered Online On Demand4 hours 26 minutes
£12

Domestic Violence and Unconscious Bias Training - QLS Endorsed Training

By Imperial Academy

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

Domestic Violence and Unconscious Bias Training - QLS Endorsed Training
Delivered Online On Demand
£300
1...56789...23