19553 Courses in Cardiff delivered Online

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.

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 the Level 4 Diploma in Accounting and Business qualification is to provide learners with an understanding of accounting and business in the broader business context, and to provide them with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. 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 You will have an understanding of accounting and business in the broader business context. The programme will provide you with the practical, industry-focused skills to manage business finances, budgets and cash flow effectively, and to play a key role in business growth. Who is this course for? Working Professionals, A-Level holders, professionals working in range of industries looking for a career in finance and accountancy

Help with anxiety Life guidance Objective led life coaching Help with ptsd Help with exam stress Student dating advice Discovering your purpose Combat trauma issues High performance coaching Introspection test and personality test Confidence building Gain understanding of self Help with combating negative behavioural patterns https://relationshipsmdd.com/product/student-life-coaching-package/

This Functional Skills Maths Entry Level 1 course will assist you in displaying a solid understanding of the foundational concepts and basic principles of mathematics appropriate to the level, as well as the ability to use mathematical reasoning to solve routine issues in everyday contexts. Course Highlights: Course Type: Self-Paced Online Learning Total Qualification Time: 58 hours Guided Learning: 55 hours Accreditation: Pearson Edexcel Qualification: Nationally Recognised Qualification Study Materials: High-Quality E-Learning Study Materials Assessment: Internally graded and externally verified Access: 1 Year Access Certificate: Certificate upon completion of the official exam (hard copy) Tutor Support: Paid Tutor Support Customer Support: 24/7 live chat available Functional Skills Entry Level 1 Maths Course This Functional Skills Entry Level 1 Maths Course is regulated by Ofqual and accredited by Pearson Edexcel making it a nationally recognised qualification that will enhance your CV, helping you stand out from the rest of the candidates. You will acquire knowledge about the number system, common measures, geometry and handling data. Upon successful completion of this course, you will be able to apply your foundational mathematics knowledge in a range of practical scenarios. Why is this course right for you? This comprehensive Functional Skills Maths Entry Level 1 Course is suitable for: Anyone looking to secure a skill-oriented job People of all ages and academic backgrounds Anyone who wants to progress to functional skills level 1 or 2 Anyone who wants to take GCSE maths Anyone seeking to add a certified qualification to their university application Anyone aspiring to accelerate their career in this sector Anyone who wants to gain in-depth knowledge of functional skills in mathematics Whether you are a beginner into the field of functional maths or any professional seeking to reinforce your expertise in functional skills maths, this Functional Skills Maths Entry Level 1 Course will set you up with the advanced skills to boost your career profile. EXAM Booking & Results Details You can decide the exam date and place according to your convenience. Awarding Body Paper-Based Exam in Centre Results Pearson Edexcel Book within 15 days Get results in 20 working days *Offline examinations will be held at our Swindon and London centres. Please contact us for more information. Functional Skills Entry Level 1 Maths Qualification Purpose and Outcomes This Functional Skills Entry Level 1 Maths Qualification will help you to: Develop confidence in their application of basic mathematics concepts and abilities. Prove their understanding by using their abilities and expertise to complete easy tasks or simple mathematical equations. Acquire comprehensive problem-solving and underpinning skills to utilise mathematics in the course of everyday life. Course Curriculum Read, write, order and compare numbers up to 20 Use whole numbers to count up to 20 items, including zero Add numbers which total up to 20, and subtract numbers from numbers up to 20 Recognise and interpret the symbols +, – and = appropriately Recognise coins and notes and write them in numbers with the correct symbols (£ & p), where these involve numbers up to 20 Read 12-hour digital and analogue clocks in hours Know the number of days in a week, months and seasons in a year; be able to name and sequence Describe and make comparisons in words between measures of items including size, length, width, height, weight and capacity Identify and recognise common 2-D and 3-D shapes, including circles, cubes, rectangles (including squares) and triangle Use everyday positional vocabulary to describe position and direction, including left, right, in front, behind, under and above Read numerical information from lists Sort and classify objects using a single criterion Read and draw simple charts and diagrams, including a tally chart, block diagram/graph How This Course Will Work? This Functional Skills Entry Level 1 Maths course will help you build a solid foundation in mathematics. Throughout the course, it will provide you with various learning materials and activities to enhance your understanding of these subjects. Initial Assessment: To identify the current level of a student's abilities and recommend the appropriate course to enrol in upon completion. Diagnostic Assessment: Identifies skill gaps and produces an individual learning plan Learning Resources: Comprehensive video tutorials, practice quizzes & topic-based tests Progress Tracker: To record your progress in the course Free Mock Test: Access our free mock test facility for professional feedback and to prepare for the final exam. Entry Requirement This Functional Skills Entry Level 1 Maths qualification is available to all students of all academic backgrounds; no experience or previous qualifications are required. Exam Structure The Functional Skills Pearson Edexcel Qualification in Mathematics Level 1 consist of one externally assessed assessment that comprises two sections- a non-calculator section (calculator prohibited) and a calculator section (calculator permitted). The assessments are available as paper-based and onscreen, on-demand assessments. Section A (Non-calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 2o minutes 6 25% Section B (Calculator) Awarding Body Exam Duration Total Marks Questions Cover Pearson Edexcel 1 hour 18 75% Each Maths assessment is designed to enable a minimally competent learner to achieve a pass mark of 36 out of 60. However, the awarding process will determine specifically where the pass mark sits for each assessment version. Therefore, the pass mark may vary between assessments. Recognised Accreditation Pearson Edexcel is the most prestigious awarding body, for an academic and vocational qualifications. Pearson Edexcel qualifications are regulated by Ofqual and recognised by universities and employers across the world. Certification You will be rewarded with an Ofqual Regulated Pearson Edexcel Functional Skills Entry Level 1 (depending on what you choose as an accreditation) upon successful completion of this Functional Skills English Entry Level 3 Course and passing the assessments. A certified hard copy of this qualification will be posted at your given address which is accepted by employers and universities across the globe. You can flaunt this qualification in your CV which will give you a competitive advantage over others in case of securing a job. FAQs The Functional Maths level 1 Course is equivalent to? The Level 1 course is a fundamental level of proficiency in English, Maths, and ICT that is equivalent to a GCSE grade 1 to 3 (formerly G to D grades). It is a nationally recognised qualification in the UK that provides an alternative to GCSEs for individuals who still need to pass these subjects during their secondary education. Why should I take the Functional Skills Maths instead of the GCSE Maths? The functional maths course is comparatively easier than the GCSE math and additionally the value of it is also more than the GCSE math course. However, you should select the course that suits your needs, as both courses provide different values at different places. Which one is more difficult between Functional and GCSE Maths courses? The functional skills Maths course is more flexible than the GCSE math course since you have to sit for the official exam in the GCSE courses. What is the Difference between Functional Skills and GCSE? A Functional skills course develops for the one who wants to learn Math, English and ICT for individual achievement in daily work place and on the other hand, GCSE focuses on theories and tests your academic ability. How will I access the functional skills Maths level 1 course after payment? A confirmation email will be sent to your registered email after payment. Hereafter anytime, you can start your learning journey with Lead Academy. Will I get access to the Course if my location is outside the UK? Yes, you can. Since it is an e-learning course, anyone from anywhere can enrol in our courses. What is an Accredited course? The professional body approves the procedures if any e-learning platform claims its courses are accredited. What is the benefit of doing an accredited course? You will only realize the benefit of having an accredited certificate once you face the corporate world. As employees, job places, and more value the accredited certificate, you must own this certificate by doing the course with us.

The Level 4 Diploma in Law is a 120-credit Ofqual regulated qualification and is the equivalent level to the first year of a university degree. It has been designed for learners who wish to progress to university and, when taken in combination with the Level 5 Diploma in Law, allows learners to progress onto an LLB top-up degree programme (the final year of university). Key Highlights of Diploma in Law Level 4 qualification are: Program Duration: 9 Months (Fast Track 6 months duration course 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 Graded with Pass, Merit and Distinction Dedicated Student Success Manager Timely Doubt Resolution Regular Networking Events with Industry Professionals Become eligible to gain direct entry into relevant Undergraduate degree programme. Alumni Status No Cost EMI Option Requirements This Diploma in Law Level 4 (Accredited by Ofqual, UK and awarded by Qualifi, UK) qualifications has been designed to be accessible without artificial barriers that restrict access and progression. Learners will be expected to hold the following: Learners who have demonstrated some ability and possess Qualifications at Level 3 and Age: 16+ OR work experience in a business environment and demonstrate ambition with clear career goals; Level 4 qualification in another discipline and want to develop their careers in management. Career path Learners completing the Level 4 Diploma in Law can progress to: The Second year of an Undergraduate Degree, or Level 5 Diploma qualifications (click here to view) Directly into employment in an associated profession. Certificates Certificate of Achievement Hard copy certificate - Included Qualifi courses: Once you complete the course, you would be receiving a Physical hard copy of your Diploma along with its Transcript which we would Courier to your address via DHL or Royal Mail without any additional charge.

MASTERY OF TRANSLATION-FT is a fast-track 10-month Level 7 preparatory course towards the CIOL Diploma in Translation. It's 100% online, but with a human touch!

Level 1 Award in British Sign Language 1 to 1 Tutor Support-Live Zoom Class | Accredited by Signature | Ofqual Regulated | Interactive Training | Step by Step Guideline This qualification is designed to teach learners to communicate with Deaf people in British Sign Language (BSL) on a range of topics that involve simple, everyday language use. They will gain basic skills and confidence in production and reception of BSL. The course specification has been designed using the UK Occupational Language Standards 2010 at Level 1. **This course is distributed under the Lead Academy licence.** Learning outcomes: At the end of this unit, the successful learners will: Understand and communicate basic conversation when meeting people Know basic numbers Know different weather conditions and respond to questions about the weather Know a range of transport modes Communicate a range of directions Accredited by Signature Ofqual Regulated, Nationally Recognised Qualification Qualification: Signature Level 1 Award in British Sign Language (RQF) Qualification objectives At the end of the qualification, learners will be able to: Understand and use a limited range of simple words and sentences in BSL Take part in simple, everyday conversations in BSL Give and follow simple directions or instructions in BSL Give and follow simple familiar statements or descriptions in BSL Meet the Trainer Adam Linsdell Hello. My name is Adam and I am a British Sign Language Teacher. I am Deaf and have been using British Sign Language since I was a teenager. My personal experience of Deafness was my primary reason for learning BSL and why I have such a deep passion for this beautiful and expressive language. I have studied BSL to NVQ Level 6 and trained to become a teacher, enabling me to achieve my dream of teaching BSL in my local community. This opportunity has enabled me to work with the local Deaf community, building strong relationships and links. I have taught sign language throughout Cambridge, teaching at Anglia Ruskin University, Cambridge Regional College, Cambridgeshire Deaf Association and Cottenham Village College. Usually, I teach face to face but during lockdown my classes moved online - this has been a new experience and a great opportunity for me and my learners. Level 1 Award in British Sign Language, Winter 2022 Class starts 29th January 2022 - Course runs until 16th July 2022 Weekly via Zoom with 1 face to face session Day & Time: Saturday Mornings, 10.00am - 01.00pm Level 1 Award in BSL Jan 2022 Class Schedule Level 1 BSL Qualification Full Specification Venue: Zoom Online Teacher: Adam Linsdell Level 1 Award in British Sign Language is suitable for those who: Want to learn basic language skills to communicate simple conversations with Deaf people Want to learn new language skills as part of a programme of study Want to progress to more advanced study and/or employment using BSL in the future Are studying for personal development Are parents, family, friends or colleagues of Deaf people. Level 1 Award in British Sign Language is suitable for all ages, including pre-16. Requirements: Level 1 Award in British Sign Language can be taken without any previous BSL experience at any level. This qualification allows learners to gain basic skills and confidence in the two areas of production and reception of BSL. Total Learning Hours: 90 hours Guided Learning Hours (GLH): 64 hours GLH includes assessment time. Additional study hours include private study, homework, practice, etc Progression routes On completion of Signature Level 1 Award in British Sign Language, a wide range of further qualifications are available, including: Signature Level 2 Certificate in British Sign Language Signature Level 3 Certificate in British Sign Language Nationally Recognised Qualification: After successfully passing the official exam you will achieve Ofqual regulated nationally recognised Level 1 Award in British Sign Language Qualification that is valued by all the employers and academic institutes in the UK. Official Exam You will be assessed remotely via an online zoom exam that you can take from the comfort of your own home. When you will be ready for the exam there is an additional registration fee of £149 to book the official exam. **This course is distributed under the Lead Academy licence.** Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum Meeting People Meeting Familiar People Meeting Unfamiliar People in Familiar Surroundings Meeting Unfamiliar People in Public Places, Shops, Cafes, Offices, Etc Requesting Clarification Leave Taking Range of Vocabulary Using Numbers Basic Numbers Range of Vocabulary Weather Commenting on the Weather Range Of Vocabulary Transport Describing Different Ways of Travelling Range of Vocabulary Directions Giving and Describing Simple Directions Asking for Directions Range of Vocabulary Obtain Your Certificate

Diploma Course in Practioner Crystal Therapy. This is a great learning journey into the world of Crystals and how Crystals, through their own growth process, can mirror our human existence and offer healing in ways we never thought possible. The course will give you insights into how Crystals and their energy can Heal the human anatomy both physically, emotionally and ethereally. This course will allow you to engage with the energy of the Crystal and therefore bring that energy forth to help with the healing process of self and others.