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

1138 Statistics courses

Depression Counselling Course Online

By Lead Academy

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want This is a comprehensive program designed to equip you with the knowledge and skills needed to effectively support individuals struggling with depression. Through this course, you will gain a deep understanding of the causes, symptoms and various types of depression, along with therapeutic approaches for treatment. This course at a glance Eligible to apply for the insurance Accredited by International Practitioners of Holistic Medicine (IPHM) Accredited by CPD UK Endorsed by Quality Licence Scheme Understand melancholy and the history of counselling Identify the signs of depression in both earlier and later stages Discover the relationship between depression and brain, depression and neurons, and stress and depression Learn how depression affects the brain and neurons in various ways Understand how environmental and health factors impact depression Learn how depression affects the sleep cycle or leads to sleep disorders Identify different types of depression and classification methods Understand the types of depression - dysthymia, premenstrual dysphoric disorder, bipolar depression, and atypical depression Understand how depression affects elderly people including the psychological and health factors Recognise different types of medicines that can be used to treat depression Get acquainted with different types of depression such as neurogenesis, serotonin syndrome, and tyramine Understand the various aspects of complementary alternative therapies such as yoga, omega 3 fatty acids, diet, exercise, etc that can be used to withstand depression Understand the how to use various counselling approaches such as person-centred therapy, couple therapy, gestalt therapy, CBT, REBT, etc to combat depression Why Depression Counselling Course right for you? This extensive Counselling for Depression Training is designed for those suffering from depression and who want to know quick and easy solutions to overcome the mental disease or anyone who wishes to pursue their studies in the counselling industry. This course aims to provide you with the necessary information and training to advance your career in the field of counselling and assisting people to fight depression.This course will give you an in-depth and concise understanding of the essential concepts of depression, as well as an overview of all the relatable causes of depression. You will learn what causes depression, history of counselling, symptoms to diagnose depression, and risk factors. This course will also teach you a variety of counselling techniques to combat depression at both the root and terminal levels. Upon successful completion of this Counselling for Depression Training, you will obtain theoretical counselling skills and knowledge to treat people suffering from anxiety, depression, or any mental disorder. 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. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example, progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. Depression Counselling Course Details Accredited by International Practitioners of Holistic Medicine (IPHM) is a leading accredited organisation that certifies and regulates alternative therapists, healers, and training providers around the world. After completing the IPHM accredited course you will be eligible to apply for the insurance.   CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Introduction About the Course About the Tutor What Causes Depression Introduction Melancholy and the History of Counselling Signs of Depression Depression and the Brain Depression and Neurons Stress and Depression Environmental and Health Factors Depression and Sleep Disorders Somatic Symptoms Risk Factors Different Types of Depression Classifying Depression & Different Classification Methods Cyclothymia Depression and Creative Minds Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression Dysthymia, Pre-Menstrual Dysphoric Disorder, and Atypical Depression Bipolar / Manic Depression Antenatal & Postpartum Depression Bereavement and Grief Dysthymia in Children and Adolescents Depression and the Elderly Psychosocial & Health Factors in the Elderly Different Types of Medicine Neurogenesis Monoamine Oxidase Inhibitors Serotonin Syndrome Selective Serotonin Reuptake Inhibitors Tyramine Medication Statistics and Doctors in the UK & USA Complementary Alternative Therapies Lifestyle Management, Diet, Exercise, Meditation St John's Wort (Hypericum Perforatum) Omega 3 Fatty Acids Tai Chi, Qigong Yoga Acupuncture Art Therapy & Music Therapy Counselling Approaches to Depression Person Centred Therapy Family or Couples Therapy Stepped Care Model (Approach) Psychodynamic/Dynamic Interpersonal Therapy Rational Emotive Behavioural Therapy Clinical Hypnotherapy & Cognitive Behavioural Therapy Clinical Hypnotherapy for Post Traumatic Stress Disorder Gestalt Therapy The Therapeutic Relationship Knowledge and Qualities Necessary to a Counsellor Thank You and Good Bye! Who should take this course? This depression counselling course is primarily aimed at: Therapist Psychologist Depression Counsellor Aspiring Depression Counsellor Students of Psychology and Counselling Aspiring depression counsellors or interested counsellors looking to thrive in this position are also highly encouraged to take this course to upscale one step ahead of others in terms of professional development. This training, on the other hand, is not limited to a particular profession or field of endeavour. It may also be beneficial to a broader group of people who wish to learn more about depression counselling in order to help themselves or people around them combat depression. Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This depression counselling course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Depression Counselling Course Online
Delivered Online On Demand
£25

Management Complete Course (Operation, HR, Admin, Security, Retail)

4.5(3)

By Studyhub UK

Overview Uplift Your Career & Skill Up to Your Dream Job - Learning Simplified From Home! Kickstart your career & boost your employability by helping you discover your skills, talents and interests with our special Management Complete Course (Operation, HR, Admin, Security, Retail) Course. You'll create a pathway to your ideal job as this course is designed to uplift your career in the relevant industry. It provides professional training that employers are looking for in today's workplaces. The Management Complete Course (Operation, HR, Admin, Security, Retail) Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Management Complete Course (Operation, HR, Admin, Security, Retail) Course has been designed by industry experts to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This Management Complete Course (Operation, HR, Admin, Security, Retail) Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into elementary modules, allowing our students to grasp each lesson quickly. At StudyHub, we don't just offer courses; we also provide a valuable teaching process. When you buy a course from StudyHub, you get unlimited Lifetime access with 24/7 dedicated tutor support. Why buy this Management Complete Course (Operation, HR, Admin, Security, Retail)? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Management Complete Course (Operation, HR, Admin, Security, Retail) 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 course for? This Management Complete Course (Operation, HR, Admin, Security, Retail) course is ideal for Students Recent graduates Job Seekers Anyone interested in this topic People already working in the relevant fields and want to polish their knowledge and skill. Prerequisites This Management Complete Course (Operation, HR, Admin, Security, Retail) does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Management Complete Course (Operation, HR, Admin, Security, Retail) 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 As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Management Complete Course (Operation, HR, Admin, Security, Retail) is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Management Complete Course (Operation, HR, Admin, Security, Retail) Operations Management Introduction to Operations Management 00:23:00 Project Management 00:22:00 Business Development and Succession Planning 00:27:00 Process Management 00:26:00 Supply Chain Management 00:23:00 Planning & Forecasting Operations 00:23:00 Procurement & Purchasing Management 00:23:00 Manufacturing & Delivery Operations 00:19:00 Quality Management 00:23:00 Managing Risk and Recovery 00:29:00 Performance Management 00:21:00 Talent Management 00:20:00 Communication Skills 00:26:00 Negotiation Techniques 00:19:00 Conflict Management 00:17:00 Stress Management 00:19:00 Time Management 00:40:00 Business Environment 00:19:00 Business Writing Skills 00:39:00 HR Management Course Module 01: Introduction to Human Resource 00:17:00 Module 02: Employee Recruitment and Selection Procedure 00:32:00 Module 03: Employee Training and Development Process 00:22:00 Module 04: Performance Appraisal Management 00:19:00 Module 05: Employee Relations 00:14:00 Module 06: Motivation and Counselling 00:19:00 Module 07: Ensuring Health and safety at the Workplace 00:17:00 Module 08 : Employee Termination 00:15:00 Module 09: Employer Record and Statistics 00:11:00 Module 10: Essential UK Employment Law 00:26:00 Administrative Management Module 01: Introduction to Office Administration 00:16:00 Module 02: Skills of an Effective Administrator 00:17:00 Module 03: Business Etiquette 00:21:00 Module 04: Business Telephone Skills 00:21:00 Module 05: Representing Your Boss and Company 00:36:00 Module 06: Mail Services and Shipping 00:27:00 Module 07: Travel Arrangements 00:26:00 Module 08: Organising Meeting and Conferences 00:27:00 Module 09: Organisational Skills 00:27:00 Module 10: Customer Service 00:18:00 Module 11: Effective Planning and Scheduling 00:48:00 Module 12: Invoicing/Petty Cash 00:29:00 Security Management Diploma Module 01: Introduction to Security Management 00:30:00 Module 02: Organisational Security Management 00:26:00 Module 03: Security Risk Analysis and Risk Reduction 00:23:00 Module 04: Physical and Information Security Protection 00:32:00 Module 05: Business Resilience and Crisis Management 00:17:00 Module 06: Cyber Security and Fraud Prevention 00:25:00 Module 07: Security Investigations and Threat Awareness 00:24:00 Module 08: Laws and Regulations 00:25:00 Retail Management Introduction to Retail Management 00:22:00 Retail Strategy 00:13:00 Retail Buying and Merchandising 00:17:00 Retail Pricing 00:32:00 Supply Chain Management in Retailing 00:12:00 The Sales Process and Dealing with Customers at the Checkout 00:10:00 Importance of Consumer Behaviour 00:12:00 Taking Trends and Targeting Customers Effectively 00:11:00 The Importance of Communicating with Customers 00:18:00 Choosing a Retail Location 00:14:00 Retail Psychology 00:13:00 Negotiate the Right Deal with Suppliers 00:12:00 Develop Store Security Procedures 00:16:00 Management Skills for Leading Your Team 00:17:00 Selling in Multiple Channels1 00:21:00 Retail Brand Management 00:16:00 Health & Safety for Retail Stores 00:21:00 Consumer Rights Act 00:15:00 Mock Exam Mock Exam - Management Complete Course (Operation, HR, Admin, Security, Retail) 00:20:00 Final Exam Final Exam - Management Complete Course (Operation, HR, Admin, Security, Retail) 00:20:00

Management Complete Course (Operation, HR, Admin, Security, Retail)
Delivered Online On Demand24 hours
£10.99

Excel 2007 Simplified

By iStudy UK

Description This course is aimed at the excel user who already knows the basics of Excel 2007. This course will help you to go beyond the basics - to reach a higher-intermediate level. With shortcuts, tricks and tips - you will be able to work smarter and faster. If you want to be fairly competent on the software, then this course will be very handy. Its a lot quicker to be shown things, then to try and muddle through and work things out by yourself. Guaranteed, there'll be some items which we cover, that you have no idea that Excel was capable of doing! We don't want you to spend a day of your life in the classroom... learn 99 quick and very useful, practical things which you can apply on your job or on your projects. We'll cover: Working with Data - using series, symbols and special characters, hide rows and freeze panels Formulas and Functions - Calculate the duration between two dates/times, best loan terms, create conditional formula and conditional sums Copying Data - transposing rows into columns and paste specials Using Excel lists - sort and filter a list, remove duplicate records, count filtered records, look up information in a list Data Patterns - Pivot tables, pivot charts, what-if analysis Creating charts - histogram, trendlines, piecharts, error bars Presenting data - formatting columns and numbers Saving and printing worksheets - printing multiple worksheets, area, cell ranges, repeat headings of a row or column Extending excel - hyperlinks, embed a chart, importing a worksheet Customizing Excel - custom workspace, custom view, macros The target audience is those who have a basic level with Excel and want to learn other handy functions and features. We use Excel 2007 only in this course. If you have Excel 2003, this course will be difficult to follow as although the functions and features exist in 2003, the layout changed very dramatically between the two versions. Excel 2007 isn't too dissimilar from 2010. Where necessary, we provide a spreadsheet - but as long as you have Excel 2007, you'll be able to copy and do exactly what you see on the screen by pausing the video and following along. The course will take approx 7.5 hours to complete. Take this course if you want to take your basic understanding of Excel to a higher intermediate-level. What Will I Learn? Work with Formulas and Functions Copy data and formats Use excel lists Create charts Present worksheets nicely Save and print worksheets Who is the target audience? This is for those who are beginners in Excel and want to take it further to higher intermediate level - using Excel 2007 You should know the 'basics' in Excel and we take it from near-beginner, to higher intermediate Requirements Students will need to have Excel 2007 installed, as this is the system used in the teaching Introduction to the course and your tutor Data Enter numbers and fractions 00:05:00 Dates and Times 00:08:00 Name Cells and Ranges 00:04:00 Validate Data entry using a pick list FREE 00:07:00 Extend a series of dates with autofill 00:04:00 Add a symbol or special character 00:04:00 Compare multiple spreadsheets using freeze panels 00:06:00 Hide rows 00:04:00 Keyboard 00:10:00 Speak Cells 00:04:00 Find and replace data 00:10:00 Formulas and Functions Add values 00:03:00 Function wizard 00:06:00 Formulas with comments 00:04:00 OneNote 00:06:00 Define a constant 00:04:00 Apply names in functions 00:05:00 Figure out the best loan terms 00:04:00 Internal Rates of Return 00:04:00 Nth largest value 00:04:00 Large, Small, Max, Min 00:04:00 Conditional formula 00:03:00 Conditional formula with names 00:04:00 Conditional sum 00:03:00 Count If 00:02:00 Inner calculator 00:02:00 Square Roots 00:03:00 Calculate the duration between two times 00:04:00 Calculate days between two dates 00:04:00 Copying Data, Formats etc., Copy a range 00:03:00 Transpose a row into a column FREE 00:02:00 Chart formatting 00:07:00 Copy styles to another workbook 00:07:00 Paste special and copying worksheets 00:06:00 Track changes while Editing 00:06:00 Lists Enter list data using a form 00:05:00 Searching through a data list 00:04:00 Import a word list into excel 00:04:00 Sort a list 00:02:00 Filter a list 00:02:00 Sort by multiple criteria FREE 00:03:00 Find averages in a sorted group 00:05:00 Filter by multiple criteria 00:03:00 Remove duplicate records from a list 00:03:00 Count filtered records 00:07:00 Filter by multiple criteria in the same column 00:06:00 Chart a filtered list 00:02:00 Look up information in a List 00:05:00 Data Patterns Create a PivotTable 00:05:00 Modify a PivotTable and layout 00:03:00 Find the average of a field 00:04:00 Create a calculated field 00:03:00 Calculated fields and charts FREE 00:02:00 Hide rows and columns in a PivotTable 00:02:00 AutoFormat a PivotTable 00:01:00 Create a PivotChart 00:03:00 Turning on the Data Analysis function so that statistical information can be run 00:02:00 Describe Data with Statistics 00:03:00 Discover associations within your data 00:03:00 Product Numbers 00:02:00 What-if analysis 00:05:00 Goal seek 00:06:00 Creating Charts Create a Chart 00:06:00 Modify Chart details 00:04:00 Change the Chart Type 00:03:00 Add a Trendline to a Chart 00:06:00 Remove Chart Data 00:02:00 Add chart data 00:02:00 Missing chart data 00:04:00 Error bars 00:04:00 Pull a slice from a Pie Chart 00:03:00 Label slices of a Pie Chart 00:04:00 Histogram 00:06:00 Paste a chart into Word 00:03:00 Amending a chart in Word 00:02:00 Paste-link a Chart into Word 00:05:00 Worksheets Format Numbers as Percentages 00:04:00 Format Currencies in Currency and Accounting Formats 00:03:00 Format Column Headings 00:05:00 Format Quickly with Format painter FREE 00:02:00 Insert a background image into your worksheet 00:03:00 Create a Transparent image 00:03:00 Saving and Printing Worksheets Save a workbook as a Template 00:07:00 Save a workbook as an XML spreadsheet 00:05:00 Print multiple cell ranges on One Page 00:03:00 Print multiple worksheets of a workbook 00:01:00 Page set up, header, footer, margins - 1 page printing 00:04:00 Repeat Headings of a Row or Column 00:07:00 Print functions to show calculations & comments 00:07:00 Extending Excel Hyperlink a worksheet to another office document 00:03:00 Embed a chart within PowerPoint 00:05:00 Publish an Interactive Workbook 00:05:00 Import a Worksheet into Access 00:09:00 Use Excel Data to create labels in Word 00:10:00 Customizing Excel Launch a specific Workbook when Excel Opens 00:03:00 Save Time by Creating a Custom View 00:03:00 Create a Custom Number Format 00:06:00 Changing Text to Columns 00:05:00 Create a Macro to Format Numbers 00:06:00 Online Live Webinar Course-S3_W4_L1 - 42 - Excel Made simple 01:00:00

Excel 2007 Simplified
Delivered Online On Demand8 hours 4 minutes
£25

HR, Bookkeeping and Payroll Management

4.7(160)

By Janets

Follow your dreams by enrolling on the HR, Bookkeeping and Payroll Management course today and develop the experience, skills and knowledge you need to enhance your professional development. HR, Bookkeeping and Payroll Management will help you arm yourself with the qualities you need to work towards your dream job. Study the HR, Bookkeeping and Payroll Management training course online with Janets through our online learning platform and take the first steps towards a successful long-term career. The HR, Bookkeeping and Payroll Management course will allow you to enhance your CV, impress potential employers, and stand out from the crowd.  This HR, Bookkeeping and Payroll Management course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Study the HR, Bookkeeping and Payroll Management course through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the HR, Bookkeeping and Payroll Management course, to ensure you are supported every step of the way. Get a digital certificate as proof of your HR, Bookkeeping and Payroll Management course completion. Janets is one of the top online training course providers in the UK, and we want to make education accessible to everyone! Learn the essential skills you need to succeed and build a better future for yourself with the HR, Bookkeeping and Payroll Management course. The HR, Bookkeeping and Payroll Management course is designed by industry experts and is tailored to help you learn new skills with ease.  The HR, Bookkeeping and Payroll Management is incredibly great value and allows you to study at your own pace. With full course access for one year, you can complete the HR, Bookkeeping and Payroll Management when it suits you. Access the HR, Bookkeeping and Payroll Management course modules from any internet-enabled device, including computers, tablets, and smartphones. The HR, Bookkeeping and Payroll Management course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the HR, Bookkeeping and Payroll Management now and start learning instantly! What You Get Out Of Studying HR, Bookkeeping and Payroll Management With Janets: Receive a digital Certificate upon successful completion of the HR, Bookkeeping and Payroll Management course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) Description The HR, Bookkeeping and Payroll Management training course is delivered through Janets' online learning platform. Access the HR, Bookkeeping and Payroll Management content from any internet-enabled device whenever or wherever you want to. The HR, Bookkeeping and Payroll Management course has no formal teaching deadlines, meaning you are free to complete the course at your own pace. Method of Assessment  To successfully complete the HR, Bookkeeping and Payroll Management course, students will have to take an automated multiple-choice exam. This exam will be online and you will need to score 60% or above to pass the HR, Bookkeeping and Payroll Management course. After successfully passing the HR, Bookkeeping and Payroll Management course exam, you will be able to apply for a CPD-accredited certificate as proof of your HR, Bookkeeping and Payroll Management qualification. Certification All students who successfully complete the HR, Bookkeeping and Payroll Management course can instantly download their digital certificate. You can also purchase a hard copy of the HR, Bookkeeping and Payroll Management course certificate, which will be delivered by post for £9.99. Who Is This Course For: The HR, Bookkeeping and Payroll Management is ideal for those who already work in this sector or are an aspiring professional. This HR, Bookkeeping and Payroll Management course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The HR, Bookkeeping and Payroll Management is open to all students and has no formal entry requirements. To study the HR, Bookkeeping and Payroll Management course, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16. Career Path: The HR, Bookkeeping and Payroll Management is ideal for anyone who wants to pursue their dream career in a relevant industry. Learn the skills you need to boost your CV and go after the job you want. Complete the HR, Bookkeeping and Payroll Management and gain an industry-recognised qualification that will help you excel in finding your ideal job. Course Content Human Resource Management Introduction to Human Resources 00:20:00 Employee Recruitment and Selection Procedure 00:35:00 Employee Training and Development Process 00:24:00 Performance Appraisal Management 00:22:00 Employee Relations 00:15:00 Motivation and Counselling 00:19:00 Ensuring Health and Safety at the Workplace 00:16:00 Employee Termination 00:15:00 Employer Records and Statistics 00:11:00 Essential UK Employment Law 00:27:00 Bookkeeping & Payroll Basics Module 1: Payroll Basics 00:10:00 Module 2: Company Settings 00:08:00 Module 3: Legislation Settings 00:07:00 Module 4: Pension Scheme Basics 00:06:00 Module 5: Pay Elements 00:14:00 Module 6: The Processing Date 00:07:00 Module 7: Adding Existing Employees 00:08:00 Module 8: Adding New Employees 00:12:00 Module 9: Payroll Processing Basics 00:11:00 Module 10: Entering Payments 00:12:00 Module 11: Pre-Update Reports 00:09:00 Module 12: Updating Records 00:09:00 Module 13: e-Submissions Basics 00:09:00 Module 14: Process Payroll (November) 00:11:00 Module 15: Employee Records and Reports 00:13:00 Module 16: Editing Employee Records 00:07:00 Module 17: Process Payroll (December) 00:12:00 Module 18: Resetting Payments 00:05:00 Module 19: Quick SSP 00:10:00 Module 20: An Employee Leaves 00:13:00 Module 21: Final Payroll Run 00:07:00 Module 22: Reports and Historical Data 00:08:00 Module 23: Year-End Procedures 00:09:00 Sage 50 Payroll Intermediate Level Module 1: The Outline View and Criteria 00:11:00 Module 2: Global Changes 00:07:00 Module 3: Timesheets 00:12:00 Module 4: Departments and Analysis 00:11:00 Module 5: Holiday Schemes 00:10:00 Module 6: Recording Holidays 00:12:00 Module 7: Absence Reasons 00:13:00 Module 8: Statutory Sick Pay 00:16:00 Module 9: Statutory Maternity Pay 00:17:00 Module 10: Student Loans 00:09:00 Module 11: Company Cars 00:13:00 Module 12: Workplace Pensions 00:21:00 Module 13: Holiday Funds 00:13:00 Module 14: Process Payroll (November) 00:16:00 Module 15: Passwords and Access Rights 00:08:00 Module 16: Options and Links 00:10:00 Module 17: Linking Payroll to Accounts 00:08:00 Frequently Asked Questions Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

HR, Bookkeeping and Payroll Management
Delivered Online On Demand10 hours 28 minutes
£25

Oracle 19c Database Administration I (DBA I) (TTOR20519)

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This hands-on course is geared for experienced DBAs new to Oracle 19c, who can work in Linux and have basic experience with SQL scripting. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to: How to use tools to access an Oracle Database Generate database creation scripts by using DBCA How to create a container database (CDB) by using the CREATE DATABASE command Learn about Startup and shut down Oracle databases Initialization parameter files and initialization parameters Tools that are used to administer Oracle Net Services How to use the Oracle Connection Manager Control utility to administer Oracle Connection Manager How to create a new PDB from the PDB seed. Logical and physical storage structures in an Oracle database Usage of Oracle Database features that save space Explanation of DML and undo data generation Learn about general architecture of Oracle Data Pump and SQL*Loader How to use SQL*Loader to load data from a non-Oracle database (or user files) Bonus Content / Time Permitting: Explanation of maintenance windows Bonus Content / Time Permitting: Employ basic monitoring procedures and manage performance Oracle 19C Database Administration I (Oracle DBA I) is a comprehensive, hands-on course provides concrete information on the design of an Oracle Database instance and database, allowing you to manage your database investment. In this class, you will learn how to create database storage structures that align with your requirements and business models. You will also learn how to create users and administer databases as well as harden the databases to meet your business requirements. This is the foundational course for learning about Oracle Database and it does not assume prior knowledge or Oracle technologies, however you should have incoming experience working with SQL, and be comfortable with Linux and working from the command line. This training is NOT Official Oracle University training. This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. Introduction to Oracle Database Oracle Multitenant Container Database Oracle Database Instance Configurations Database Sharding Oracle Database Server Accessing an Oracle Database Oracle Database Tools Database Tool Choices SQL Developer Enterprise Manager Database Express Creating an Oracle Database by Using DBCA Planning the Database Choosing a Database Template Configuration Assistant Creating an Oracle Database by Using a SQL Command Creating a Container Database Enable Pluggable Database Starting Up and Shutting Down a Database Instance Starting the Oracle Database Instance Shutting Down an Oracle Database Instance Opening and Closing PDBs Managing Database Instances Investigating Initialization Parameter Files Viewing Initialization Parameters by Using SQL*Plus Modifying Initialization Parameters by Using SQL*Plus Viewing Diagnostic Information Oracle Net Services Overview Oracle Net Services Components Oracle Net Listener Configuring Naming Methods Configuring the Oracle Network to Access a Database Creating a Net Service Name for a PDB Configuring and Administering the Listener Exploring the Default Listener Creating a Second Listener Connecting to a Database Service Using the New Listener Configuring a Shared Server Architecture Configuring Shared Server Mode Configuring Clients to Use a Shared Server Configuring Oracle Connection Manager for Multiplexing and Access Control Oracle Connection Manager Processes Filtering Rules Session Multiplexing Creating PDBs Creating a New PDB from the PDB Seed Cloning Remote PDBs in Hot Mode Relocating PDBs Managing PDBs Renaming a PDB Setting Parameter Values for PDBs Database Storage Overview Logical and Physical Database Structures Tablespaces and Data Files Types of Segments Monitoring Tablespace Space Usage Creating and Managing Tablespaces Viewing Tablespace Information Creating a Tablespace Managing Temporary and Permanent Tablespaces Improving Space Usage Managing Space in Tablespaces Using Compression Enabling the Resumable Space Allocation Feature Creating and Managing User Accounts Creating Common and Local Users Creating a Local User for an Application Exploring OS and Password File Authentication Configuring Privilege and Role Authorization Granting a Local Role (DBA) to PDBADMIN Using SQL*Developer to Create Local Roles Configuring User Resource Limits Using SQL*Developer to Create a Local Profile & Users Configuring a Default Role for a User Implementing Oracle Database Auditing Enabling Unified Auditing Creating Audit Users Creating an Audit Policy Introduction to Loading and Transporting Data General Architecture Oracle Data Pump SQL Loader Loading Data into a PDB from an External File Moving Data from One PDB to Another PDB Transporting a Tablespace Using External Tables to Load and Transport Data Querying External Tables Unloading External Tables Automated Maintenance Tasks Overview Automated Maintenance Tasks Maintenance Windows Predefined Maintenance Windows Bonus: Managing Tasks and Windows Enabling and Disabling Automated Maintenance Tasks Modifying the Duration of a Maintenance Window Bonus: Database Monitoring and Performance Tuning Overview Performance Planning Considerations Automatic Workload Repository (AWR) Advisory Framework Bonus: Monitoring Database Performance & Processes Server-Generated Alerts Setting Metric Thresholds Performance Monitoring Examining the Database Background Processes Bonus: Tuning Database Memory Viewing Memory Configurations Bonus: Analyzing SQL and Optimizing Access Paths Using the Optimizer Statistics Advisor

Oracle 19c Database Administration I (DBA I) (TTOR20519)
Delivered OnlineFlexible Dates
Price on Enquiry

LEAN SIX SIGMA GREEN BELT

By EduHubInstitute

We offer the most advanced “Certified Six Sigma Green Belt Course” as per the curriculum outline of The ASQ Body of Knowledge and accredited by top international Lean & Six Sigma accreditation bodies. Six Sigma Green Belt Deliverables: 22+ hours of Instructor-led interactive virtual classroom session on the weekend Access to 45+ hours of Module based Six Sigma lectures via LMS 100+ Toolkits and Project Templates for Analysis and Implementation Soft copy of Lean Six Sigma Green Belt Body of Knowledge Live Data-oriented project, with Scenario and Analysis Methodology 20+ Dummy Projects and Case studies for Lean Six Sigma Application Support via subject expert through telephonic discussion on the weekend Sample Questions and Examination Guide for Certification Preparation Pre and Post assignments for process groups and knowledge areas Project implementation support and Data visualization using MINITAB PRO CLSSGB certification examination anytime within the 90 days course duration Certification Validation Tool for third-party credentials validation PARTICULARS Duration (Hours) 1. Define Phase 22 2. Measure Phase 14 3. Analyse Phase 20 4. Improve Phase 7 5. Control Phase 7 Total Duration 70 (Hours) Introduction Become an expert in six sigma methodology by getting hands-on knowledge on DMAIC, Project Charter, Process Capability, FMEA, Sigma calculation, Test of Hypothesis, Control Charts, VSM, JIT using real case scenarios and real-life examples. Lean and DMAIC methodologies using live projects. The Six Sigma Certification is accredited by The Council for Six Sigma Certification. The certification also acknowledges the BOK outline of The American Society for Quality, USA. The course features world-class content with live projects and MINITAB PRO driven data analysis training with end to end support in project implementation by Master Black Belt Experts and Trainers. What is Six Sigma Certification? A person with Six Sigma certification has problem-solving abilities. Someone may gain Green Belt, Black Belt or Master Black Belt certification. The higher certification one attains, the more is the ability to solve complex organizational problems. Six Sigma certification is a process of individual’s knowledge validation using a classification system, generally referred to as "Belts" (Green Belt, Black Belt, Master Black Belt) This verification test individual commands over six sigma methodology and tools. The belt classification shows the position these certified individuals would occupy in an organizational structure and job roles. Six Sigma Green Belt training is especially for the future project leaders of Lean Six Sigma projects. We deliberately mix non-profit with profit participants. There will then be fun, useful discussions and knowledge exchanges during the training sessions. In addition, there are also many self-employed people who follow the LSS Green Belt training to increase their expertise as in a trimmer. What do you do to get the Six Sigma Green Belt certificate? Our Six Sigma Green Belt training consists of a number of components: Training: in an intensive training program you learn the background of Lean and Six Sigma and we put what we have learned into practice with different simulations. Extra: With our Body of Knowledge and whitepapers you place what you have learned in a theoretical framework. The program also contains various homework assignments, in which we focus, among other things, on the use of MINITAB PRO. Follow-up: During the training, you will receive an access code to an e-learning module. You can pass the substance again in an interactive way. Exam: On the last training day you will make the CLSSGB Green Belt exam. If you succeed, you will immediately receive the official Certified Lean Six Sigma Green Belt certification. Global Recognition of Your Certification: Agenda Overview of Six Sigma and the organizationSix Sigma and organizational goalsValue of six sigmaOrganizational goals and six sigma projectsOrganizational drivers and metricsLean principles in the organizationLean conceptsValue-streaming mappingDesign for six sigma (DFSS) methodologiesRoadmaps for DFSSBasic failure mode and effects analysis (FMEA)Design FMEA and process FMEA Define PhaseProject identificationProject SelectionProcess elementsBenchmarkingProcess inputs and outputsOwners and stakeholders Voice of the customer (VOC) Customer identificationCustomer dataCustomer requirements Project Management Basics Project charterProject scopeProject metricsProject planning toolsProject documentationProject risk analysisProject closureManagement and planning toolsBusiness results for projectsProcess performance CommunicationTeam dynamics and performanceTeam stages and dynamicsTeam roles and responsibilitiesTeam toolsTeam Communication Measure PhaseProcess analysis and documentationProbability and statisticsBasic probability conceptsCentral limit theorem, Statistical distributions, Collecting and summarizing dataTypes of data and measurement scalesSampling and data collection methodsDescriptive statisticsGraphical methodsMeasure Phase (contd E. Measurement system analysis (MSA) F. Process and performance capabilityProcess performance vs. process specificationsProcess capability studiesProcess capability (Cp, Cpk) and process performance (Pp, Ppk) indicesShort-term vs. long-term capability and sigma shift Analyze PhaseExploratory data analysisMulti-vari studiesCorrelation and linear regression B, Hypothesis testingBasics Tests for means, variances, and proportionsIntroduction to MINITAB Data analysis Improve Phase of Six SigmaDesign of experiments (DOE)Basic terms, DOE graphs, and plotsThe root cause analysisLean Tools 1. Waste elimination 2. Cycle-time reduction 3. Kaizen and kaizen blitz V1. Control PhaseStatistical process control (SPC)SPC BasicsRational subgroupingControl chartsControl planLean tools for process controlTotal productive maintenance (TPM)Visual factory Project Implementation & SupportMINITAB Practice and guidance for projectProject implementation supportTemplates and Toolkits application for Project workSupport on Data Project, Implementation and project completion BenefitsFrom the course Learn the principles and philosophy behind the Six Sigma technique Learn to apply statistical methods to improve business processes Design and implement Six Sigma projects in a practical scenario Learn the DMAIC process and various tools used in Six Sigma methodology Knowledge of Six Sigma Green Belt Professional enables you to understand real-world business problems, increase an organization's revenue by streamlining the process, and become an asset to an organization According to Villanova University, employers such as United Health Group, Honeywell, GE and Volkswagen have been actively seeking professionals with Six Sigma to fill a variety of positions The Training enhances your skills and enables you to perform roles like Quality Manager, Quality Analyst, Finance Manager, Supervisor, Quality Control, etc. According to Indeed.com, the national average salary for a Six Sigma Green Belt is $72,000 per year in the United States.   From the workshop Instructor LED training by Six Sigma Black Belt and Master Belt experts to make candidate learn the real scenario of six sigma tools and methodology Learn the principles and philosophy behind the Six Sigma method Dummy project by instructors to make candidate get a hands-on six sigma projects Downloadable Six Sigma PPT & Six Sigma PDF Industry Based case studies High-Quality training from an experienced trainer The Program extensively uses Minitab, specialized statistical software. It provides you with a thorough knowledge of Six Sigma philosophies and principles (including supporting systems and tools). Know about six sigma certification cost and six sigma green belt certification cost. Who should attend? The Six Sigma program is designed for professionals and students who want to develop the ability to lead process improvement initiatives. Six Sigma tools and process is widely used in all business processes. Six Sigma is applicable in all industry and in all functional areas. An indicative list of participants in our Green Belt program could include: Financial/business analyst Commodity manager Project manager Quality manager Production manager Production Engineer Business development manager Manufacturing process engineer Continuous improvement director Business managers or consultants Project manager/Program Manager Director or VP of operations CEO, CFO, CTO Certification On successful completion of the course and course requisites, the candidate will receive Internationally recognized Six Sigma Green Belt Certification. This course offers Six Sigma Certification Validation Tool for Employers Your Six Sigma Certification Validation Tool can be used by employers, clients and other stakeholders to validate the authenticity of your Six Sigma Certifications you have received. Using the programming code located on your certified LSSGB certification, one can see all your training and certification details online.

LEAN SIX SIGMA GREEN BELT
Delivered OnlineFlexible Dates
£199.99

KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing

By Nexus Human

Duration 2 Days 12 CPD hours This course is intended for Experienced DataStage developers seeking training in more advanced DataStage job techniques and who seek techniques for working with complex types of data resources. Overview Use Connector stages to read from and write to database tables Handle SQL errors in Connector stages Use Connector stages with multiple input links Use the File Connector stage to access Hadoop HDFS data Optimize jobs that write to database tables Use the Unstructured Data stage to extract data from Excel spreadsheets Use the Data Masking stage to mask sensitive data processed within a DataStage job Use the Hierarchical stage to parse, compose, and transform XML data Use the Schema Library Manager to import and manage XML schemas Use the Data Rules stage to validate fields of data within a DataStage job Create custom data rules for validating data Design a job that processes a star schema data warehouse with Type 1 and Type 2 slowly changing dimensions This course is designed to introduce you to advanced parallel job data processing techniques in DataStage v11.5. In this course you will develop data techniques for processing different types of complex data resources including relational data, unstructured data (Excel spreadsheets), and XML data. In addition, you will learn advanced techniques for processing data, including techniques for masking data and techniques for validating data using data rules. Finally, you will learn techniques for updating data in a star schema data warehouse using the DataStage SCD (Slowly Changing Dimensions) stage. Even if you are not working with all of these specific types of data, you will benefit from this course by learning advanced DataStage job design techniques, techniques that go beyond those utilized in the DataStage Essentials course. Accessing databases Connector stage overview - Use Connector stages to read from and write to relational tables - Working with the Connector stage properties Connector stage functionality - Before / After SQL - Sparse lookups - Optimize insert/update performance Error handling in Connector stages - Reject links - Reject conditions Multiple input links - Designing jobs using Connector stages with multiple input links - Ordering records across multiple input links File Connector stage - Read and write data to Hadoop file systems Demonstration 1: Handling database errors Demonstration 2: Parallel jobs with multiple Connector input links Demonstration 3: Using the File Connector stage to read and write HDFS files Processing unstructured data Using the Unstructured Data stage in DataStage jobs - Extract data from an Excel spreadsheet - Specify a data range for data extraction in an Unstructured Data stage - Specify document properties for data extraction. Demonstration 1: Processing unstructured data Data masking Using the Data Masking stage in DataStage jobs - Data masking techniques - Data masking policies - Applying policies for masquerading context-aware data types - Applying policies for masquerading generic data types - Repeatable replacement - Using reference tables - Creating custom reference tables Demonstration 1: Data masking Using data rules Introduction to data rules - Using the Data Rules Editor - Selecting data rules - Binding data rule variables - Output link constraints - Adding statistics and attributes to the output information Use the Data Rules stage to valid foreign key references in source data Create custom data rules Demonstration 1: Using data rules Processing XML data Introduction to the Hierarchical stage - Hierarchical stage Assembly editor - Use the Schema Library Manager to import and manage XML schemas Composing XML data - Using the HJoin step to create parent-child relationships between input lists - Using the Composer step Writing Hierarchical data to a relational table Using the Regroup step Consuming XML data - Using the XML Parser step - Propagating columns Topic 6: Transforming XML data - Using the Aggregate step - Using the Sort step - Using the Switch step - Using the H-Pivot step Demonstration 1: Importing XML schemas Demonstration 2: Compose hierarchical data Demonstration 3: Consume hierarchical data Demonstration 4: Transform hierarchical data Updating a star schema database Surrogate keys - Design a job that creates and updates a surrogate key source key file from a dimension table Slowly Changing Dimensions (SCD) stage - Star schema databases - SCD stage Fast Path pages - Specifying purpose codes - Dimension update specification - Design a job that processes a star schema database with Type 1 and Type 2 slowly changing dimensions Demonstration 1: Build a parallel job that updates a star schema database with two dimensions Additional course details: Nexus Humans KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

KM423 IBM InfoSphere DataStage v11.5 - Advanced Data Processing
Delivered OnlineFlexible Dates
Price on Enquiry

Identifying Domestic Abuse

By Safe Space Consultancy

Identifying Domestic Abuse (CPD). A good introductory seminar for anyone who wants to learn about the complex nature of domestic abuse. You will have increased knowledge of domestic abuse in general, an increased ability to identify the early signs of domestic abuse and knowledge of next steps to support.

Identifying Domestic Abuse
Delivered OnlineFlexible Dates
£25 to £30

Introduction to SQL Programming Basics (TTSQL002)

By Nexus Human

Duration 3 Days 18 CPD hours This course is intended for This is an introductory level SQL course, appropriate for anyone needing to interface with an Oracle database or those needing a general understanding of Oracle database functionality. That would include end users, business analysts, application developers and database administrators. Overview Working in a hands on learning environment led by our expert practitioner, attendees will explore: Basic RDBMS Principles The SQL Language and Tools Using SQL Developer SQL Query Basics WHERE and ORDER BY Functions ANSI 92 Joins ANSI 99 Joins Subqueries Regular Expressions Analytics A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. A full presentation of the basics of relational databases and their use are also covered. Basic RDBMS Principles Relational design principles Accessing data through a structured query language Entity relationship diagrams Data Domains Null values Indexes Views Denormalization Data Model Review The SQL Language and Tools Using SQL*Plus Why Use SQL*Plus When Other Tools Are Available? Starting SQL*Plus EZConnect SQL Commands PL/SQL Commands SQL*Plus Commands The COLUMN Command The HEADING Clause The FORMAT Clause The NOPRINT Clause The NULL Clause The CLEAR Clause Predefined define variables LOGIN.SQL Command history Copy and paste in SQL*Plus Entering SQL commands Entering PL/SQL commands Entering SQL*Plus commands Default output from SQL*Plus Entering Queries What about PL/SQL? Using SQL Developer Choosing a SQL Developer version Configuring connections Creating A Basic Connection Creating A TNS Connection Connecting Configuring preferences Using SQL Developer The Columns Tab The Data Tab The Constraints Tab The Grants Tab The Statistics Tab Other Tabs Queries In SQL Developer Query Builder Accessing Objects Owned By Other Users The Actions Pulldown Menu Differences between SQL Developer and SQL*Plus Reporting Commands Missing In SQL Developer General Commands Missing In SQL Developer Data Dictionary report User Defined reports Using scripts in SQL Developer WHERE and ORDER BY WHERE clause basics Comparison operators Literals and Constants in SQL Simple pattern matching Logical operations The DUAL table Arithmetic operations Expressions in SQL Character operators Pseudo columns Order by clause basics Ordering Nulls Accent and case sensitive sorts Sampling data WHERE and ORDER BY in SQL Developer All, Any, Some Functions The basics of Oracle functions Number functions Character functions Date functions Conversion functions Other functions Large object functions Error functions The RR format mode; Leveraging your knowledge ANSI 92 JOINS Basics of ANSI 92 Joins Using Query Builder with multiple tables Table Aliases Outer joins Outer Joins In Query Builder Set operators Self-referential joins Non-Equijoins ANSI 99 Joins Changes with ANSI99 CROSS Join NATURAL Join JOIN USING JOIN ON LEFT / RIGHT OUTER JOIN FULL OUTER JOIN Subqueries Why use subqueries? WHERE clause subqueries FROM clause subqueries HAVING clause subqueries CORRELATED subqueries SCALAR subqueries DML and subqueries EXISTS subqueries Hierarchical queries TOP N AND BOTTOM N queries Creating subqueries using Query Builder Regular Expressions Available Regular Expressions Regular Expression Operators Character Classes Pattern matching options REGEX_LIKE REGEXP_SUBSTR REGEXP_INSTR REGEXP_REPLACE REGEXP_COUNT Analytics The WITH clause Reporting aggregate functions Analytical functions User-Defined bucket histograms The MODEL clause PIVOT and UNPIVOT Temporal validity More Analytics RANKING functions RANK DENSE_RANK CUME_DIST PERCENT_RANK ROW_NUMBER Windowing aggregate functions RATIO_TO_REPORT LAG / LEAD Linear Regression functions Inverse Percentile functions Hypothetical ranking functions Pattern Matching Additional course details: Nexus Humans Introduction to SQL Programming Basics (TTSQL002) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to SQL Programming Basics (TTSQL002) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

Introduction to SQL Programming Basics (TTSQL002)
Delivered OnlineFlexible Dates
Price on Enquiry

Functional Skills Maths - Level 1 (Updated 2022)

5.0(10)

By Apex Learning

Overview This comprehensive course on Functional Skills Maths - Level 1 (Updated 2022) will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Functional Skills Maths - Level 1 (Updated 2022) comes with accredited certification from CPD, 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 Functional Skills Maths - Level 1 (Updated 2022). It is available to all students, of all academic backgrounds. Requirements Our Functional Skills Maths - Level 1 (Updated 2022) 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 Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more! Course Curriculum 24 sections • 114 lectures • 11:37:00 total length •Lecture 1: Introduction Video: 00:02:00 •Lecture 2: Quick Guide: 00:01:00 •Lecture 1: Read & Write Large Numbers Part 1: 00:08:00 •Lecture 2: Read & Write Large Numbers Part 2: 00:13:00 •Lecture 3: Compare and Order Large Numbers: 00:12:00 •Downloadable Resources: 00:00:00 •Lecture 1: Why do you Round off a Number?: 00:03:00 •Lecture 2: Rounding off techniques: 00:07:00 •Lecture 3: Practice Problems Part 1: 00:09:00 •Lecture 4: Practice Problems Part 2: 00:08:00 •Lecture 5: Rounding to Significant Figures: 00:15:00 •Downloadable Resources: 00:00:00 •Lecture 1: Number System: 00:07:00 •Lecture 2: Integers and Ordering of Integers: 00:08:00 •Lecture 3: Addition and Subtractions of Integers: 00:10:00 •Lecture 4: Operations on Integers: 00:06:00 •Lecture 5: Multiplication and Division of Integers: 00:07:00 •Downloadable Resources: 00:00:00 •Lecture 1: Factors and Multiples Basics: 00:07:00 •Lecture 2: Divisibility tests for 2,3,4,5,6: 00:07:00 •Lecture 3: Divisibility tests for 7,8,9,10,11: 00:11:00 •Lecture 4: Prime Factorisation: 00:13:00 •Lecture 5: Highest Common Factor HCF: 00:13:00 •Lecture 6: HCF - Division Method: 00:10:00 •Lecture 7: Least Common Multiple LCM: 00:14:00 •Downloadable Resources: 00:00:00 •Lecture 1: Classification of Fractions: 00:09:00 •Lecture 2: Convert mixed to improper and improper to mixed fractions: 00:05:00 •Lecture 3: Equivalent Fractions: 00:07:00 •Lecture 4: Comparing Fractions after converting to like fractions: 00:09:00 •Lecture 5: Reducing a fraction to the lowest term: 00:05:00 •Lecture 6: Addition & Subtraction of fractions: 00:09:00 •Lecture 7: Multiplication and Division of Fractions: 00:11:00 •Lecture 8: Find Fractions of whole number quantities or measurements: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Expanded form of Decimals: 00:08:00 •Lecture 2: Expanded form to Decimal form: 00:03:00 •Lecture 3: Writing fractions to Decimals: 00:04:00 •Lecture 4: Converting Decimals to a fraction: 00:05:00 •Lecture 5: Like & Unlike Decimals: 00:04:00 •Lecture 6: Comparing & Ordering Decimal Numbers: 00:09:00 •Lecture 7: Addition and Subtraction of Decimals: 00:06:00 •Lecture 8: Multiplication of Decimals: 00:07:00 •Lecture 9: Division of Decimals: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: Multiply whole numbers and decimals by 10,100 & 1000: 00:09:00 •Lecture 2: Divide whole numbers and decimals by 10,100 & 1000: 00:05:00 •Downloadable Resources: 00:00:00 •Lecture 1: Squaring of one-digit and two-digit numbers: 00:06:00 •Lecture 1: Simple Formula in words for one step or two steps operations: 00:09:00 •Downloadable Resources: 00:00:00 •Lecture 1: Intro to the metric system: 00:09:00 •Lecture 2: Length, Mass & Capacity: 00:10:00 •Lecture 3: Length, Mass & Capacity Addition & Subtraction: 00:05:00 •Lecture 1: Converting 12-hour time to a 24-hour time: 00:04:00 •Lecture 2: Converting 24-hour time to a 12-hour time: 00:05:00 •Lecture 3: Conversion to different units of Time: 00:09:00 •Lecture 4: Addition with Time: 00:08:00 •Lecture 5: Subtraction with Time: 00:08:00 •Lecture 6: Multiplication with Time: 00:07:00 •Lecture 7: Division with Time: 00:06:00 •Lecture 8: Finding Time interval between given timings Part 1: 00:05:00 •Lecture 9: Finding Time interval between given timings Part 2: 00:10:00 •Lecture 10: Past Paper problem Q1: 00:02:00 •Lecture 11: Past Paper problem Q2: 00:02:00 •Lecture 12: Past Paper problem Q3: 00:05:00 •Lecture 13: Past Paper problem Q4: 00:03:00 •Lecture 14: Past Paper problem Q5: 00:02:00 •Lecture 1: Order of Operations - PEMDAS: 00:10:00 •Lecture 2: Practice Problems on - PEMDAS: 00:05:00 •Downloadable Resources: 00:00:00 •Lecture 1: Estimation and approximation: 00:07:00 •Lecture 2: Estimation using Fractions and Decimals: 00:03:00 •Lecture 1: Simple Ratio and Direct Proportion Part 1: 00:09:00 •Lecture 2: Simple Ratio and Direct Proportion Part 2: 00:04:00 •Lecture 3: Simple Ratio and Direct Proportion Part 3: 00:04:00 •Lecture 1: Scale Drawing: 00:06:00 •Lecture 1: What is the meaning of Percentage?: 00:02:00 •Lecture 2: Percentage to Fraction: 00:07:00 •Lecture 3: Percentage of a quantity and conversation to Decimal: 00:05:00 •Lecture 4: Expressing one Quantity as a Percentage of another Quantity: 00:07:00 •Lecture 5: Calculate Percentages of amounts, increase, decrease by 5,10,15%: 00:11:00 •Lecture 1: Calculate simple interest in multiples of 5% on amounts of money: 00:11:00 •Lecture 2: Calculate discounts in multiples of 5% on amounts of money: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Problems based on Money: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: What is statistics?: 00:04:00 •Lecture 2: Representation of discrete data in Tables: 00:11:00 •Lecture 3: One-way Tables: 00:03:00 •Lecture 4: Two-way Tables: 00:04:00 •Lecture 5: Grouping of a discrete data Part 1: 00:05:00 •Lecture 6: Grouping of a discrete data Part 2: 00:04:00 •Lecture 7: Represent discrete data in Bar Charts (Graphs)Part 1: 00:08:00 •Lecture 8: Represent discrete data in Bar Charts (Graphs)Part 2: 00:07:00 •Lecture 9: Pie Charts (Circle graphs) Part 1: 00:08:00 •Lecture 10: Pie Charts (Circle graphs) Part 2: 00:05:00 •Lecture 11: Pie Charts (Circle graphs) Part 3: 00:08:00 •Lecture 12: Mean & Range: 00:09:00 •Downloadable Resources: 00:00:00 •Lecture 1: Probability on a scale from 0 to 1: 00:12:00 •Lecture 2: Probabilities of simple events Part 1: 00:03:00 •Lecture 3: Probabilities of simple events Part 2: 00:06:00 •Downloadable Resources: 00:00:00 •Lecture 1: Lines & Angles: 00:08:00 •Lecture 2: Introduction to Triangles: 00:05:00 •Lecture 3: Polygons: 00:05:00 •Lecture 4: More 2D Figures: 00:07:00 •Lecture 5: Line symmetry: 00:05:00 •Lecture 1: Area & Perimeter Part 1: 00:08:00 •Lecture 2: Area & Perimeter Part 2: 00:06:00 •Lecture 3: Area & Perimeter Part 3: 00:08:00 •Downloadable Resources: 00:00:00 •Lecture 1: Calculation of the volumes & Surface Area of cubes and cuboids: 00:08:00

Functional Skills Maths - Level 1 (Updated 2022)
Delivered Online On Demand11 hours 37 minutes
£12