25200 Courses delivered Online

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

Empower Your Financial Wisdom In today's fast-paced financial landscape, understanding investment risk and taxation is not just an asset, it's a necessity. Our Introduction to Investment Risk and Taxation bundle offers you a golden opportunity to master these crucial areas. With a total of 10 CPD-accredited and QLS-endorsed courses, this bundle is tailored to transform beginners into expert investors with the ability to navigate the world of finance. Each course in the bundle is designed to build your expertise from the ground up. You'll learn about investment strategies, risk assessment, the pivotal role of taxation in investment decisions and more. What sets this bundle apart is the dual certification: for each course completed, you'll earn both a CPD and a QLS certificate, totalling 20 certificates(10 in PDF and 10 in hardcopy format). This improves your learning experience and significantly enhances your professional profile. But our commitment to your growth doesn't end with certification. Learners also receive full study assistance and career support, ensuring they're not just learning but also applying their newfound knowledge in real-world scenarios. Whether you're looking to advance in your career, manage your personal finances better, or simply understand the complexities of the financial market, our Introduction to Investment Risk and Taxation bundle is your key to unlocking a wealth of knowledge and opportunities. Enrol today and redefine your financial future! Courses Included In this Introduction to UK Financial Regulation and Professional Integrity: Course 01: UK Tax Accounting Course 02: Anti-Money Laundering (AML) and Financial Crime Course 03: Accounting Essentials and UK Taxation Course 04: Central Banking Monetary Policy Course 05: Banking and Finance Accounting Statements Financial Analysis Course 06: Introduction to Banking Course 07: Self-Assessment Tax Return Filing UK Course 08: UK Tax Reforms and HMRC Legislation Course 09: Financial Controller Training Course 10: Financial Statement Analysis Masterclass What Will You Learn? After completing this Introduction to UK Financial Regulation and Professional Integrity bundle, you will be able to: Gain a comprehensive understanding of investment principles and risk management strategies. Develop expertise in interpreting and applying taxation laws to investment decisions. Learn to assess and mitigate financial risks in diverse market scenarios effectively. Acquire skills in strategic financial planning and asset management. Understand the impact of global economic changes on investments and taxation. Enhance your ability to make informed investment choices for long-term gains. Cultivate critical thinking skills for analysing financial reports and market trends. Build a strong foundation in ethical investment practices and compliance standards. Embark on a journey to financial expertise with our Introduction to Investment Risk and Taxation bundle. This collection of 10 CPD-accredited and 10 QLS-endorsed courses equips you with the knowledge to navigate the complexities of the financial world. From mastering risk management to understanding the complexities of taxation in investments, this bundle is your gateway to becoming a proficient investor. With dual certification and career support, this bundle is an invaluable asset for anyone looking to excel in finance. CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Introduction to UK Financial Regulation and Professional Integrity bundle is perfect for: Individuals seeking a career in finance, investment, or risk management. Professionals aiming to improve their financial decision-making skills. Entrepreneurs looking to manage business finances and investments effectively. Personal finance enthusiasts keen on mastering investment and taxation strategies. Students and recent graduates looking to enter the financial sector. Career path Upon completion of these courses, you can pursue many rewarding career paths, such as: Financial Analyst: £35,000 - £80,000 per year. Investment Manager: £40,000 - £100,000 per year. Risk Management Consultant: £45,000 - £90,000 per year. Tax Advisor: £30,000 - £75,000 per year. Portfolio Manager: £50,000 - £120,000 per year. Compliance Officer: £35,000 - £85,000 per year. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included

Description Introduction To Banking Diploma Introduction To Banking Diploma is a meticulously designed online course tailored for individuals aspiring to gain a foundational understanding of the banking sector. It provides a comprehensive overview of the diverse aspects and functions of banks, from the rudimentary structures to the more advanced banking services. This course offers a detailed perspective on the varying types of banks and elucidates the procedures for opening bank accounts. The first module of this diploma focuses on providing a panoramic view of the banking landscape, aiming to elucidate the intricate tapestry of financial institutions. It embarks on a journey to explore various types of banks and the myriad of services they provide, fostering a deep understanding of the fundamental components of the banking sector. Here, learners will acquire a foundational knowledge of the essential structures and functions of banks, paving the way for more advanced learning. In this course, special attention is paid to the exploration of savings and investments. Participants will gain insights into the different saving options available, understand investment opportunities, and learn to discern the most beneficial choices based on individual financial goals and circumstances. This segment empowers learners with the knowledge to make informed decisions on savings and investments to achieve financial stability and growth. Additionally, the course offers invaluable insights into borrowing money, providing clarity on the principles and practices of acquiring loans. It demystifies the complexities around borrowing, offering strategic guidelines to navigate the loan acquisition process effectively. This will enable learners to approach borrowing with confidence and a solid understanding of the associated responsibilities and implications. A pivotal aspect of the Introduction To Banking Diploma is the exploration of banking services specifically tailored for businesses. It provides learners with a robust understanding of the myriad of financial services available to businesses, elucidating how these services can facilitate operational efficiency and financial growth. Participants will comprehend the essential banking services crucial for the smooth functioning and success of any business entity. In addition, the course delves into the realm of international banking, elucidating the nuances of global financial services and transactions. It provides an extensive overview of the mechanisms and regulations governing international banking, aiding learners in understanding the dynamics of cross-border financial activities. This knowledge is pivotal for those who wish to engage in international business or financial activities. The Introduction To Banking Diploma also emphasizes the significant impact of digital banking and innovation on the banking sector. It offers profound insights into the latest advancements and technological interventions in banking, showcasing how these innovations are reshaping the way financial transactions are conducted. Learners will become adept at leveraging digital banking solutions, embracing the convenience and efficiency offered by technological advancements in banking. Furthermore, the course extensively covers the crucial aspects of ethics and social responsibility in banking. It instils a profound understanding of the ethical considerations and social responsibilities inherent to banking, fostering a sense of integrity and ethical conduct amongst learners. This knowledge is vital in cultivating responsible and ethically sound banking professionals. The course also provides strategic insights for navigating financial crises, offering robust strategies and solutions to cope with financial downturns effectively. It equips learners with the necessary tools and knowledge to mitigate the impacts of financial crises, ensuring sustained financial stability and resilience. In conclusion, the Introduction To Banking Diploma is an enlightening journey through the multifaceted world of banking. It is an invaluable resource for aspiring banking professionals or anyone seeking to enhance their knowledge and understanding of the banking sector. The course is delivered online, allowing for a flexible and convenient learning experience, accessible to learners anywhere in the world. What you will learn 1:The Banking Landscape 2:Types of Banks 3:Opening a Bank Account 4:Savings and Investments 5:Borrowing Money 6:Banking Services for Businesses 7:International Banking 8:Digital Banking and Innovation 9:Ethics and Social Responsibility 10:Navigating Financial Crises Course Outcomes After completing the course, you will receive a diploma certificate and an academic transcript from Elearn college. Assessment Each unit concludes with a multiple-choice examination. This exercise will help you recall the major aspects covered in the unit and help you ensure that you have not missed anything important in the unit. The results are readily available, which will help you see your mistakes and look at the topic once again. If the result is satisfactory, it is a green light for you to proceed to the next chapter. Accreditation Elearn College is a registered Ed-tech company under the UK Register of Learning( Ref No:10062668). After completing a course, you will be able to download the certificate and the transcript of the course from the website. For the learners who require a hard copy of the certificate and transcript, we will post it for them for an additional charge.

Introduction to Agile and Scrum: Virtual In-House Training This half-day course provides an overview of Agile principles and mindset, and the Scrum framework as a key Agile approach. It will provide you with the key benefits of an Agile approach, and its differences with the traditional Waterfall method. Lastly, as Agile is looked upon more frequently as an alternative delivery method, you will review situations where Agile can be adapted outside of software development, where it is most commonly used. What you will Learn At the end of this program, you will be able to: Explain the basics and benefits of using an Agile approach Describe the Scrum framework, its events, artifacts and roles and responsibilities Illustrate Agile approaches outside of Software Development Getting Started Introduction Course structure Course goals and objectives Agile Introduction What is Agile? Agile Benefits Agile Methods Overview of Scrum Scrum Overview Scrum Events Scrum Artifacts Scrum Roles Definition of Done Agile Approaches Outside of Software Development Agile in other environments Product Development Course Development Marketing Agile Project Candidates Summary What Agile is not... Concerns and Pitfalls

24 Hour Flash Deal **25-in-1 Introduction to Securities & Investment Mega Bundle** Introduction to Securities & Investment Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the Introduction to Securities & Investment package online with Studyhub through our online learning platform. The Introduction to Securities & Investment bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This Introduction to Securities & Investment course provides complete 360-degree training on Introduction to Securities & Investment. You'll get not one, not two, not three, but twenty-five Introduction to Securities & Investment courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these Introduction to Securities & Investment courses are yours for as long as you want them once you enrol in this course This Introduction to Securities & Investment Bundle consists the following career oriented courses: Course 01: Investment: Complete Investing Course Course 02: Fundamentals of Corporate Finance Course 03: Investment Banking Operations Professional Course 04: Finance: Financial Risk Management Course 05: Economics Level 2 Diploma Course 06: Finance Law Fundamentals: Legal Aspects of Financial Transactions Course 07: Financial Reporting Course 08: Capital Budgeting & Investment Decision Rules Course 09: Raise Money and Valuation for Business Course 10: Financial Analysis Methods Course 11: Tax Strategy and Financial Planning for Beginners Course 12: Understanding Financial Statements and Analysis Course 13: Financial Management Professional Training Certification Course 14: Diploma in Accountancy Course 15: Cashflow Management and Forecasting Course 16: Real Estate Investment and Property Management Diploma Course 17: Financial Trading Certification and Risk Management Diploma Course 18: Stock Trading Diploma Course 19: Stock Market Day Trading Strategies Course 20: Navigating Corporate Tax Return Procedures in the UK Course 21: International Banking: Global Operations and Cross-Border Transactions Course 22: FinTech Course 23: Cryptocurrency: Wallets, Investing & Trading Course 24: Anti Money Laundering (AML) Course 25: Security Management and Fraud Prevention Training In this exclusive Introduction to Securities & Investment bundle, you really hit the jackpot. Here's what you get: Step by step Introduction to Securities & Investment lessons One to one assistance from Introduction to Securities & Investment professionals if you need it Innovative exams to test your knowledge after the Introduction to Securities & Investment course 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five Introduction to Securities & Investment courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your Introduction to Securities & Investment certificate and transcript on the next working day Easily learn the Introduction to Securities & Investment skills and knowledge you want from the comfort of your home The Introduction to Securities & Investment course has been prepared by focusing largely on Introduction to Securities & Investment career readiness. It has been designed by our Introduction to Securities & Investment specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The Introduction to Securities & Investment Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Introduction to Securities & Investment bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Introduction to Securities & Investment Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into Introduction to Securities & Investment Elementary modules, allowing our students to grasp each lesson quickly. The Introduction to Securities & Investment course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Introduction to Securities & Investment training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in Introduction to Securities & Investment Progression : CISI Level 3 Certificate for Introduction to Securities & Investment, CISI International Introduction to Investment Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. Requirements To participate in this Introduction to Securities & Investment course, all you need is - A smart device A secure internet connection And a keen interest in Introduction to Securities & Investment Career path You will be able to kickstart your Introduction to Securities & Investment career because this course includes various courses as a bonus. This Introduction to Securities & Investment is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore Introduction to Securities & Investment career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

This course will take you from the basics of Rust to understanding how to use all its features effectively for writing clear and effective code. With the help of engaging exercises and explanations, you'll learn the basic syntaxes, iterators, generics, borrow checker, code documentation, pointer lifetimes, and much more.

Introduction to Agile for Executives: Virtual In-House Training This session provides executives with an overview of Agile values and principles, the key benefits of an Agile approach, and its differences with the traditional Waterfall method. During the session, we compare and contrast the major Agile methods, with an emphasis on Scrum, as the most popular in the market. And most importantly, we present some criteria for Agile Transformation, possible certifications to pursue, and what is needed at the senior leadership level to achieve the best business results. What you will Learn At the end of this program, you will be able to: Explain the basics and benefits of using an Agile approach Describe the Scrum framework, its events, artifacts, and roles and responsibilities Illustrate an Agile approach outside of Software Development Define Scaled Agile Determine how to support an Agile transformation for your organization Getting Started Introduction Course structure Course goals and objectives Agile Introduction What is Agile? Agile benefits Agile myths and realities Overview of Agile Methods Overview of Agile methods Scrum method Lean and Kanban methods Criteria and certifications What Executives Need to Know About Agile Agile is not just for IT Agile can be scaled Agile transformation needs your support Summary and Next Steps Review Personal Action Plan

Update and renewal option for Geopace Training Certificate holders Update and renew your existing certificate ... Recommended certificate renewal after 18 months Nationally Recognised Dual Accreditations Open College Network Accredited (Advanced Level) CPD Accredited (The CPD Certification Service) Recaps phlebotomy theory incl. legislation Updates your certification and compliancy Awards cumulative credits and CPD points awarded Basic understanding of English language required Download a certificate on completion of your online course APPLICANTS ARE REQUIRED TO HAVE COMPLETED AN ACCREDITED INTRODUCTION TO PHLEBOTOMY COURSE

Introduction to Project Management: In-House Training This course provides practical insights into what is project management and how it is performed in a structured manner. This course provides practical insights into what is project management and how it is performed in a structured manner. You will learn how projects are selected, initiated, planned, executed, monitored and control, as well as closed, which could serve you ubiquitously. The goal of this course is to provide a minimally essential orientation to practical project management concepts, tools, and techniques. You will be provided with enough of these that can be applied from both a project manager and a key stakeholder perspective. What you Will Learn You will learn how to: Articulate on the basics of the project management profession Explain project management terms and concepts in practice Speak on how projects originate in mature organizations Employ a disciplined approach to initiating, planning, and managing projects to closure Identify and describe the roles and responsibilities of key project stakeholders Consider standard project processes to implement based upon the PMBOK® Guide Getting Started Introductions Course orientation Participants' expectations Foundation Concepts Key terms and concepts Organizational framework Leadership framework Originating and Initiating Originating projects Initiating projects Planning Planning overview Scope and quality planning Resources and risk planning Schedule and cost planning Project baselining Executing and Controlling Executing Monitoring and Controlling Closing Project closing overview Closing administratively Closing financially Summary and Next Steps Review of goals, objectives, key concepts, and expectations Evaluations

Introduction to Design Thinking: Virtual In-House Training Innovation is the cornerstone of highly successful companies, especially those that continue to be successful over the years and decades. Design thinking practices fuel this continual innovation, as they are the critical links from inspiration to delivery, concept to showroom floor, and start-up to global business. Design thinking is a structured approach to promoting innovation and creative problem-solving. It is not a new approach. It has been around for centuries, as the art, architecture, and inventions of mankind illustrate. By examining the steps to achieving great design and maximum utility of product, design thinking approaches provide a framework in which to develop new solutions to problems and new products to sell. This highly interactive course is designed to help participants think like designers to generate innovation, and to help teams to produce more innovation and creativity. Since design thinking is based on doing rather than thinking, we participants are challenged to apply the techniques, in the classroom, to create new ideas and solutions to a case study project. What you will Learn At the end of this program, you will be able to: Explain the underlying principles and value of using Design Thinking for innovation Describe the basic concepts of the Stanford Model for Design Thinking Evaluate a set of basic Design Thinking techniques for application to your projects Apply tools, techniques, and skills aligned with the 5 stages of the Stanford Model Drive innovation through Design Thinking at some level in your work environment Foundation Concepts Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks Stages of Design Thinking Problems and solutions The Design Thinking difference Design Thinking skills and abilities Design Thinking mindset Design Thinking frameworks General Practices Team formation Visualization Improvisation Personalization Empathize Practices Overview of Empathize techniques Observation Engagement Interviews Define Practices Overview of Define practices Unpacking techniques Defining the customer techniques Integrating the Define experience Ideate Practices Overview of Ideate practices Reusable techniques for the Ideate stage New Ideate techniques to explore Prototype & Test Practices Overview of Prototype practices Examples of prototypes Overview of Testing practices Forms of testing techniques Adopt and Adapt Design Thinking Overview of Design Thinking implementation Design Thinking implementation challenges Success in implementing Design Thinking Summary and Next Steps Workshop summary Next steps: Personal Action Plans