19379 Courses in London delivered Online

The objective of Level 5 Diploma in Health and Social Care Management qualification (accredited by OTHM) is to equip learners with the underpinning knowledge, understanding and skills required for a career in the Health and Social Care sector at a Managerial level. The programme enables learners to demonstrate their skills by producing evidence from their work or training activities. Learners will acquire Care Management Skills in the Health and Social Care sector. Program Overview Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn The programme will equip you with the underpinning knowledge, understanding and skills required for a career in the Health and Social Care sector at a Managerial level. You would also acquire Care Management Skills. Who is this course for? The programme will equip you with the underpinning knowledge, understanding and skills required for a career in the Health and Social Care sector at a Managerial level. You would also acquire Care Management Skills.

The objective of the OTHM Level 3 Foundation Diploma for Higher Education Studies is to provide learners with a foundation to provide an entry route to UK and international university courses. It is designed to ensure that each learner is equipped with knowledge of study skills, mathematics, computing, society and culture, business and accounting, providing the knowledge and skills to adapt rapidly to change and progress with their learning. Successful completion of the Level 3 Foundation Diploma for Higher Education Studies provides learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 9 Months (Can be fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn The programme ensure that each learner is equipped with knowledge of study skills, mathematics, computing, society and culture, business and accounting, providing the knowledge and skills to adapt rapidly to change and progress with their learning. Who is this course for? Working Professionals, O-Level holders, professionals working in Education and Training Institutions, Human resource consultants

he objective of the OTHM Level 3 Foundation Diploma in Accountancy is to provide learners with a foundation for a career in a range of organisations in relation to financial management and accountancy. It is designed to ensure that each learner is equipped with knowledge of accountancy, and the skills to adapt rapidly to change and progress with their learning. Successful completion of the Level 3 Foundation Diploma in Accountancy provides learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 6 Months (Can be fast tracked) Program Credits: 60 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn The programme provide learners with a foundation for a career in a range of organisations in relation to financial management and accountancy. You would get equipped with knowledge of accountancy, and the skills to adapt rapidly to change and progress with your learning. Who is this course for? Working Professionals, O-Level holders, professionals working in range of industries looking for a career in finance and accountancy

The objective of the OTHM Level 4 Diploma in Health and Social Care Management qualification is to equip learners with the underpinning knowledge, understanding and skills required for a career in the health and social care sector at a managerial level. The programme enables learners to demonstrate their skills by producing evidence from their work or training activities. Learners will acquire care management skills in the Health and Social Care sector. Program Overview Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn The programme will equip you with the underpinning knowledge, understanding and skills required for a career in the health and social care sector at a managerial level. The programme enables learners to demonstrate their skills by producing evidence from their work or training activities. Who is this course for? Working Professionals, A-Level holders, learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

The objective of the fast track Level 3 Foundation Diploma for Higher Education Studies is to provide learners with a foundation to provide an entry route to UK and international university courses. It is designed to ensure that each learner is equipped with knowledge of study skills, mathematics, computing, society and culture, business and accounting, providing the knowledge and skills to adapt rapidly to change and progress with their learning. Successful completion of the fast track Level 3 Foundation Diploma for Higher Education Studies provides learners with the opportunity to progress to further study or employment. Key Highlights of Foundation Diploma for Higher Education Studies - Level 3 (Fast track mode) Program Duration: 6 Months (Regular duration of 9 months also available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Who is this course for? Open Entry. No formal qualification is required Career path After completion of this course qualification will meet the University standard academic entry requirements. However, each applicant will be subject to individual assessment and other entry requirements which may affect university entry. University of Sunderland, UK Progress to all Undergraduate courses within the Faculty of Business, Law and Tourism Certificates Certificate of Achievement Digital certificate - Included Othm courses: Once you complete the course, you would be receiving a digital copy of your Diploma along with its Transcript which can be downloaded from the awarding body website without any additional charge. You can also order Hard copy certificate by paying a nominal cost directly to the awarding body.

The objective of the OTHM Level 3 Diploma in Education and Training qualification is to develop learners' understanding of theory and practice in education. It provides learners with an opportunity to engage with the issues and challenges facing professionals and in their own country. The units will provide knowledge that underpins the ability to work as an effective practitioner in the education sector. They combine both theoretical and practical knowledge in the education profession and will develop and enhance knowledge and skills in the areas of approaches to teaching and learning, developing resources and reflective practice. Program Overview Key Highlights Program Duration: 9 Months (Can be fast-tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn Develop learners' understanding of theory and practice in education. Will train you to work as an effective practitioner in the education sector. It further develop and enhance knowledge and skills in the areas of teaching and learning, developing resources and reflective practice. Who is this course for? Working Professionals, O-Level holders, professionals working in Education and Training Institutions, Human resource consultants

The objective of fast track Level 5 Diploma in Business Management qualification (accredited by OTHM) is to provide learners with an excellent foundation for a career in a range of organisations. It is designed to ensure that each learner is 'business ready': a confident, independent thinker with a detailed knowledge of business and management, and equipped with the skills to adapt rapidly to change.The content of the qualification is focused on people management, managing projects, marketing, finance for managers, business law, business ethics and social responsibility. The qualification is ideal for those who have started, or are planning to move into, a career in private or public sector business. Successful completion of the fast track Level 5 Diploma in Business Management qualification will provide learners with the opportunity to progress to further study or employment. Program Overview Key Highlights Program Duration: 6 Months (Regular duration mode available) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Direct entry into Year 1 of a three-year UK Bachelor's degree LSBR Alumni Status No Cost EMI Option Top Skills You Will Learn You will get knowledge and skills required by a middle manager who is involved in people management, managing projects, marketing, finance, business law, business ethics and social responsibility. Who is this course for? Working Professionals, A-Level / Level 4 / Year 1 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.

Querying Microsoft SQL Server course description This course covers the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server and provides the foundation for all SQL Server-related disciplines; namely, database administration, database development and business intelligence. This course helps prepare for exam 70-761. Note: This course is designed for SQL Server 2014or SQL Server 2016. What will you learn Write SELECT statements. Create and implement views and table-valued functions. Transform data by implementing pivot, unpivot, rollup and cube. Create and implement stored procedures. Add programming constructs such as variables, conditions, and loops to T-SQL code. Querying Microsoft SQL Server course details Who will benefit: Database administrators, database developers, and business intelligence professionals. SQL power users, namely, report writers, business analysts and client application developers. Prerequisites: Database fundamentals Duration 5 days Querying Microsoft SQL Server course contents Introduction to Microsoft SQL Server Management studio, creating and organizing T-SQL scripts, using books online. Hands on working with SQL Server tools. T-SQL querying Introducing T-SQL, sets, predicate logic, logical order of operations in SELECT statements, basic SELECT statements, queries that filter data using predicates, queries that sort data using ORDER BY. Hands on introduction to T-SQL querying. Writing SELECT queries Writing simple SELECT statements, eliminating duplicates with DISTINCT, column and table aliases, simple CASE expressions. Hands on writing basic SELECT statements. Querying multiple tables cross joins and self joins, write queries that use Inner joins, write queries that use multiple-table inner joins, write queries that use self-joins, write queries that use outer joins, write queries that use cross joins. Hands on querying multiple tables. Sorting and filtering data Sorting data, filtering data with predicates, filtering data with TOP and OFFSET-FETCH, working with unknown values, WHERE clause, ORDER BY clause, TOP option, OFFSET-FETCH clause. Hands on sorting and filtering data. SQL Server data types Introducing SQL Server data types, Character data, date and time data, queries that return date and time data, write queries that use date and time functions, write queries that return character data, write queries that return character functions. Hands on working with SQL Server data types. DML Adding data to tables, modifying and removing data, generating automatic column values, Inserting records with DML, updating and deleting records using DML. Hands on using DML to modify data. Built-in functions Queries with built-in functions, conversion functions, logical functions, functions with NULL, queries that use conversion functions, queries that use logical functions, queries that test for nullability. Hands on built-in functions Grouping and aggregating data Aggregate functions, the GROUP BY clause, filtering groups with HAVING, queries that use the GROUP BY clause, queries that use aggregate functions, queries that use distinct aggregate functions, queries that filter groups with the HAVING clause. Hands on grouping and aggregating data. Subqueries Self-contained subqueries, correlated subqueries, EXISTS predicate with subqueries, scalar and multi-result subqueries. Hands on subqueries. Table expressions Views, inline table-valued functions, derived tables, common table expressions. queries that use views, write queries that use derived tables, Common Table Expressions (CTEs), write queries that se inline Table valued expressions (TVFs). Hands on table expressions. Set operators The UNION operator, EXCEPT and INTERSECT, APPLY, queries that use UNION set operators and UNION ALL, CROSS APPLY and OUTER APPLY operators. Hands on set operators. Windows ranking, offset, and aggregate functions OVER, window functions, ranking functions, offset functions, window aggregate functions. Hands on; windows ranking, offset, and aggregate functions. Pivoting and grouping sets PIVOT and UNPIVOT, grouping sets, queries that use the PIVOT operator, queries that use the UNPIVOT operator, queries that use the GROUPING SETS CUBE and ROLLUP subclauses. Hands on pivoting and grouping sets Executing stored procedures Querying data with stored procedures, passing parameters to stored procedures, simple stored procedures, dynamic SQL, the EXECUTE statement to invoke stored procedures. Hands on executing stored procedures. Programming with T-SQL T-SQL programming elements, controlling program flow, declaring variables and delimiting batches, control-of-flow elements, variables in a dynamic SQL statement, synonyms. Hands on programming with T-SQL Error handling T-SQL error handling, structured exception handling, redirect errors with TRY/CATCH, THROW to pass an error message back to a client. Hands on implementing error handling. Implementing transactions Transactions and the database engines, controlling transactions, BEGIN, COMMIT, and ROLLBACK, adding error handling to a CATCH block. Hands on implementing transactions.

Become a financial crime prevention superhero with LGCA’s help! Pick up everything you need to know to join a company’s AML function and start fighting crime with your newfound knowledge and skills. The Certificate in AML provides participants with a thorough understanding of what constitutes Money Laundering (ML) and how financial institutions should respond to increasingly complex attempts by criminal individuals and entities to process proceedings from illegal activities in a manner that enables them to enjoy such illegal proceedings. Study method Online, self-paced Duration 25 hours Access to content 360 days Certification Certificate in Anti Money Laundering (AML) Additional info Exam(s) / assessment(s) is included in price Description About the Certificate Participants will investigate what is ML, what constitutes a risk-based approach in dealing with ML and the relevant policies and procedures that may be adopted by a financial institution as part of a coherent AML Strategy. In addition, participants will be provided with an overall assessment of international economic sanctions and how these are valuable tools in combating ML. The Certificate also offers participants, a practical perspective of how AML attempts have been formally incorporated and have led to the creation of legal frameworks that aim to prevent ML practices. The knowledge obtained by undertaking this Certificate is an invaluable asset for professionals that seek to enhance their career prospects in AML which is becoming an increasingly significant issue for financial institutions. Topics covered • Money laundering methods, techniques, red flags, key risk areas and compliance best practices & checklists • KYC and CDD: Beneficial ownership, money laundering risks in gatekeeper roles, politically exposed persons, and much more • Economic Sanctions and relevant frameworks • Vulnerabilities of Financial Institutions • Legal Framework for AML – A practical perspective • Case Studies and analysis Expected Learning Outcomes • Identify ML-related risks and dangers that need to be dealt with through a rigid AML strategy • Understand ML risk assessment and management and learn how to design a comprehensive AML risk-based approach • Review the relevant processes and procedures that need to be adopted as part of an AML strategy • Gain a practical perspective through a review of the relevant legal framework that covers AML • Understand the importance of sanctions and how these can be utilised as a tool to combat ML Format • Register at any time • Study in your own time and at your own pace (you have up to 3 months to complete the Certificate) • Assessed by an online multiple-choice exam What is included • 25 hours of self-paced online interactive learning including analysis of 5 practical case studies • 1-year free AGRC membership • Online Exam and AGRC Certificate Completion Requirements • Success in all the unit tests. Each unit is allocated two, three or four Multiple Choice questions (MCQs). In total 33 MCQs with a pass mark of 70% and an unlimited number of attempts. Each unit test is 10 minutes. • Success in the final test of 40 MCQs for the completion and award of the Certificate in Anti Money Laundering, issued by the Association of Governance, Risk and Compliance (AGRC). The pass mark is 70% and two attempts are permitted. The final test is 60 minutes. Who is this course for? Individuals who aspire to a career in AML, staff with specific anti-money laundering duties and staff working in financial services who want a comprehensive training in AML. No previous knowledge or experience is required although it is assumed that participants have good knowledge of English and a sound education background. Requirements No previous knowledge or experience is required though it is assumed that participants have good knowledge of English and sound educational background. Career path AML Officer, MLRO, Head of Back Office, Compliance Officer, Risk Manager, Manager, Director

Accounting and finance are at the very heart of business operations. From banking to manufacturing, from huge service industries to micro businesses, the ability to manage, plan and account for money is still the ultimate measure of business success and the key driver of growth. The objective of Level 6 Diploma in Accounting and Business qualification (accredited by Othm) is to provide learners with the knowledge and skills required by a middle or senior manager in an organisation, and who may be involved in managing organisational finances, investment and risk, audit and assurance, or research. Many accountants occupy key managerial positions in business, yet few are qualified managers. In the increasingly complex modern business environment, there is a high demand for skilled professionals who can work flexibly in teams across business boundaries. Key Highlights Program Duration: 9 Months (Can be Fast tracked) Program Credits: 120 Designed for working Professionals Format: Online No Written Exam. The Assessment is done via Submission of Assignment Tutor Assist available Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Master's degree programme LSBR Alumni Status No Cost EMI Option Who is this course for? Working Professionals, Level 5 / Year 2 of a three-year UK Bachelor's degree holders or learners who are looking for Career Progression and a formal undergraduate qualification leading to award of degrees in future.