17720 Courses delivered On Demand

Embark on the 'Chef Training Certificate' journey to transform your culinary passion into a prestigious career. This course transcends mere recipe learning, offering a deep dive into cooking mastery, from essential knife skills to crafting diverse, intricate dishes. It's a comprehensive pathway to becoming a culinary expert, encompassing everything from pastry chef intricacies to the rigorous chef training courses in the UK. As you progress, you'll engage in continuous learning and adapt to the dynamic demands of being a chef, including perfecting saucier skills, choosing specialties, and understanding restaurant management. This UK-based program equips you with a diverse skill set, preparing you for a successful career in the ever-changing culinary world, shaping you from an enthusiast to a professional chef. Learning Outcomes Acquire comprehensive knowledge of cooking techniques and food preparation skills. Develop expertise in catering to diverse taste preferences and dietary requirements. Master the art of using kitchen equipment efficiently and safely. Gain insights into the business aspects of culinary arts, including restaurant management. Enhance creativity in meal presentation and recipe innovation. Why buy this Chef Training Certificate? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Chef Training Certificate 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 Chef Training Certificate course for? Aspiring chefs seeking foundational and advanced culinary skills. Culinary enthusiasts aiming to professionalize their cooking abilities. Individuals interested in specializing in pastry or gourmet cuisine. Career changers exploring opportunities in the culinary industry. Hospitality professionals looking to expand their culinary expertise. Prerequisites This Chef Training Certificate does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Chef Training Certificate 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 Head Chef: £28,000 - £55,000 Per Annum Pastry Chef: £20,000 - £35,000 Per Annum Sous Chef: £22,000 - £30,000 Per Annum Catering Manager: £25,000 - £40,000 Per Annum Food Stylist: £20,000 - £45,000 Per Annum Restaurant Manager: £24,000 - £50,000 Per Annum Course Curriculum Cooking (Chef) Course Can TV Chefs Teach You To Cook? 00:05:00 Improving Cooking And Food Preparation Skills 00:05:00 Catering To Unique Tastes 00:30:00 Qualities Of A Successful Chef 00:30:00 Achieve Perfection As A Saucier 00:05:00 Becoming The Perfect Chef 00:25:00 Equipment For Perfect Chefs 00:15:00 How To Become The Perfect Chef: Attending School 00:05:00 The Keys To Getting and Using Feedback 00:05:00 What Can You Do With A Culinary Degree 00:20:00 Knife Skills For The Perfect Chef 00:10:00 Making Meals Easy to Eat Healthy 00:05:00 Plating for the At Home Chef 00:10:00 Perfect Chefs Choose A Speciality 00:05:00 Finding Local Cooking Classes 00:05:00 How Can You Become a Professional Chef 00:10:00 The Physical Qualities of the Perfect Chef 00:05:00 The Importance of Testing Recipes 00:05:00 The Chefs Important Baking Tools 00:25:00 The Learning Curve To Becoming The Perfect Chef 00:05:00 The Job of a Professional Chef 00:05:00 The Mix of Sweet, Spicy and Savory 00:05:00 The Perfect At Home Chef 00:10:00 The Perfect Chef Opens A Restaurant 00:05:00 The Physical Demand of Being a Chef 00:05:00 Recipes Recipe - I 00:10:00 Recipe - II 00:10:00 Recipe - III 01:00:00 Recipe - IV 00:10:00 Recipe - V 00:10:00 Recipe - VI 00:10:00 Recipe - VII 00:10:00 Recipe - VIII 00:10:00 Recipe - IX 00:10:00 Recipe - X 00:10:00 Recipe - XI 00:10:00 Recipe - XII 00:15:00 Recipe - XIII 00:10:00 Recipe - XIV 00:10:00 Recipe - XV 00:00:00 Recipe - XVI 00:10:00 Recipe -XVIII 00:10:00 Recipe -XVIII 00:10:00 Recipe -XIX 00:10:00 Recipe -XX 00:10:00 Recipe-XXI 00:10:00 Recipe-XXII 00:10:00 Recipe-XXIII 00:10:00 Recipe-XXIV 00:10:00 Recipe-XXV 01:00:00 Recipe-XXVI 01:00:00 Recipe-XXVII 01:00:00 Recipe-XXVIII 01:00:00 Recipe-XXIX 01:00:00 Recipe-XXX 01:00:00 Recipe-XXXI 01:00:00 Recipe-XXXII 01:00:00 Recipe-XXXIII 01:00:00 Recipe-XXXIV 01:00:00 Recipe-XXXV 01:00:00 Recipe-XXXVI 01:00:00 Recommended Reading Recommended Reading : Chef Training Certificate 00:00:00 Assignment Assignment - Chef Training Certificate 00:00:00

Get Xero Advisor certified and boost your knowledge of the nation's leading Cloud accounting software, with our Xero Bookkeeping and Budgeting course! The Xero Bookkeeping and Budgeting For Everyone is ideal for small business owners, aspiring bookkeepers and accountants, covering the fundamental principles of Cloud accounting, with instruction on how to set up and run Xero. We've taken this comprehensive professional diploma and broken it down into several manageable modules which will assist you to easily grasp each concept - from the fundamentals to the most advanced aspects of the course. It really is a sure pathway to success! Learning Outcomes Navigate Xero's interface and features for optimal bookkeeping efficiency. Process financial transactions, including sales and purchases, with proficiency. Conduct bank reconciliations and manage cash flows with precision. Administer payroll duties and handle asset registries meticulously. Prepare and submit VAT returns, adhering to UK tax legislation. Why choose this Xero Bookkeeping and Budgeting course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Xero Bookkeeping and Budgeting For Everyone Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this Xero Bookkeeping and Budgeting course for? Aspiring bookkeepers seeking to specialise in Xero software. Business owners aiming to manage their finances independently. Accountancy students enhancing their proficiency in cloud-based systems. Finance professionals diversifying their skill set. Small to medium-sized enterprise (SME) managers overseeing financial operations. Career path Xero Certified Bookkeeper: £18,000 - £28,000 Accounts Assistant: £17,000 - £25,000 Financial Controller: £25,000 - £50,000 Payroll Administrator: £19,000 - £27,000 VAT Specialist: £22,000 - £35,000 Management Accountant: £24,000 - £40,000 Prerequisites This Xero Bookkeeping and Budgeting For Everyone does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Xero Bookkeeping and Budgeting For Everyone 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:02:00 Getting Started Introduction - Getting Started 00:01:00 Signing up to Xero 00:04:00 Quick Tour of Xero 00:12:00 Initial Xero Settings 00:13:00 Chart of Accounts 00:14:00 Adding a Bank Account 00:08:00 Demo Company 00:04:00 Tracking Categories 00:07:00 Contacts 00:12:00 Invoices and Sales Introduction - Invoices and Sales 00:01:00 Sales Screens 00:04:00 Invoice Settings 00:13:00 Creating an Invoice 00:17:00 Repeating Invoices 00:07:00 Credit Notes 00:10:00 Quotes Settings 00:03:00 Creating Quotes 00:07:00 Other Invoicing Tasks 00:03:00 Sending Statements 00:03:00 Sales Reporting 00:05:00 Bills and Purchases Introduction - Bills and Purchases 00:01:00 Purchases Screens 00:04:00 Bill Settings 00:02:00 Creating a Bill 00:13:00 Repeating Bills 00:05:00 Credit Notes 00:06:00 Purchase Order Settings 00:02:00 Purchase Orders 00:08:00 Batch Payments 00:12:00 Other Billing Tasks 00:02:00 Sending Remittances 00:03:00 Purchases Reporting 00:05:00 Bank Accounts Introduction - Bank Accounts 00:01:00 Bank Accounts Screens 00:07:00 Automatic Matching 00:04:00 Reconciling Invoices 00:06:00 Reconciling Bills 00:03:00 Reconciling Spend Money 00:05:00 Reconciling Receive Money 00:04:00 Find and Match 00:04:00 Bank Rules 00:09:00 Cash Coding 00:04:00 Remove and Redo vs Unreconcile 00:04:00 Uploading Bank Transactions 00:07:00 Automatic Bank Feeds 00:06:00 Products and Services Introduction - Products and Services 00:01:00 Products and Services Screen 00:02:00 Adding Services 00:03:00 Adding Untracked Products 00:03:00 Adding Tracked Products 00:07:00 Fixed Assets Introduction - Fixed Assets 00:01:00 Fixed Assets Settings 00:05:00 Adding Assets from Bank Transactions 00:06:00 Adding Assets from Spend Money 00:05:00 Adding Assets from Bills 00:02:00 Depreciation 00:04:00 Payroll Introduction - Payroll 00:01:00 Payroll Settings 00:15:00 Adding Employees 00:18:00 Paying Employees 00:10:00 Payroll Filing 00:04:00 VAT Returns Introduction - VAT Returns 00:01:00 VAT Settings 00:02:00 VAT Returns - Manual Filing 00:06:00 VAT Returns - Digital Filing 00:02:00 Mock Exam Mock Exam - Xero Bookkeeping and Budgeting For Everyone 00:20:00 Final Exam Final Exam - Xero Bookkeeping and Budgeting For Everyone 00:20:00

Overview of Criminal Investigation Pursue a captivating and rewarding career in criminal investigation with our comprehensive course. In the United Kingdom, crime rates continuously challenge law enforcement agencies, heightening the demand for skilled criminal investigators. Our meticulously designed curriculum will equip you with the essential tools and knowledge to excel in this highly specialized field. From mastering advanced forensic techniques to exploring the complexities of criminal psychology, you'll gain a holistic understanding of the investigative process. Become a vital asset in the pursuit of justice, ensuring no stone is left unturned in uncovering the truth behind even the most complex cases. This Criminal Investigation course covers the following topics: Develop an understanding of various aspects of the criminal investigation. Gain knowledge on the collection, preservation, and analysis of physical evidence. Explore the various facets of criminology and criminal psychology. Understand the types of domestic investigations and victimology. Learn tracing, surveillance, and effective interrogation techniques. Delve into the details of the Criminal Justice System in England and Wales. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Criminal Investigation course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? This Criminal Investigation is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements You don't need any educational qualification or experience to enrol in the Criminal Investigation course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career Path The certification and skills you get from this Criminal Investigation Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Module 01: Required Skills to Become a Criminal Investigator Required Skills to Become a Criminal Investigator 00:19:00 Module 02: An Introduction to a Private Detective An Introduction to a Private Detective 00:16:00 Module 03: Criminal Intelligence Criminal Intelligence 00:17:00 Module 04: Crime Scene Investigation Crime Scene Investigation 00:17:00 Module 05: Collecting and Packaging Physical Evidence Collecting and Packaging Physical Evidence 00:42:00 Module 06: Fingerprints: Your Personal Signature Fingerprints: Your Personal Signature 00:39:00 Module 07: DNA Analysis DNA Analysis 00:35:00 Module 08: Criminology and Criminal Psychology Criminology and Criminal Psychology 00:13:00 Module 09: Violent Crimes and Cyber Criminology Violent Crimes and Cyber Criminology 00:14:00 Module 10: Business Theft and fraud Business Theft and fraud 00:12:00 Module 11: Domestic Investigation and Types Domestic Investigation and Types 00:15:00 Module 12: Victimology Victimology 00:11:00 Module 13: Dealing with Crime Dealing with Crime 00:10:00 Module 14: Tracing and Surveillance Techniques Tracing and Surveillance Techniques 00:13:00 Module 15: Effective Interrogation Techniques Effective Interrogation Techniques 00:14:00 Module 16: Basic Operations of Firearms Basic Operations of Firearms 00:10:00 Module 17: Firearms Examination Firearms Examination 01:21:00 Module 18: Forensic Psychology Forensic Psychology 00:12:00 Module 19: The Criminal Justice System in England and Wales The Criminal Justice System in England and Wales 00:13:00

Overview of Healthcare Assistant Training Experience on a journey towards a fulfilling career in healthcare, an industry brimming with opportunities and growth. In the UK, the healthcare sector is a vital component of society, offering employment and a chance to make a meaningful difference in people's lives. With a focus on industrial knowledge and understanding, the Healthcare Assistant Training course equips you with the essential skills and insights needed in this dynamic field.  Dive into various aspects of healthcare, from legal and ethical practices to advanced technological solutions. This Healthcare Assistant Training course is a gateway to a world where compassion meets expertise, preparing you for a range of roles in this ever-evolving industry. Join us to become part of a community dedicated to care and excellence. Get a quick look at the course content: This Healthcare Assistant Training Course will help you to learn: Gain proficiency in various healthcare settings and practices. Understand legal ethical standards in healthcare comprehensively. Develop skills in maintaining and handling medical records. Learn the importance of confidentiality in medical environments. Acquire knowledge of health, safety, and hygiene in nursing. Understand patient mobility issues and caregiver roles effectively. This course covers the topics you must know to stand against the tough competition. The future is truly yours to seize. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-To-One Support from a Dedicated Tutor Throughout Your Course. Study Online - Whenever and Wherever You Want. Instant Digital/ PDF Certificate. 100% Money Back Guarantee. 12 Months Access. Process of Evaluation After studying the course, your skills and knowledge will be tested with an MCQ exam or assignment. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement Certificate of Completion - Digital / PDF Certificate After completing the Healthcare Assistant Training course, you can order your CPD Accredited Digital / PDF Certificate for £5.99.  Certificate of Completion - Hard copy Certificate You can get the CPD Accredited Hard Copy Certificate for £12.99. Shipping Charges: Inside the UK: £3.99 International: £10.99 Who Is This Course for? Aspiring healthcare assistants seeking foundational skills. Nurses and support workers aim for skill enhancement. Current healthcare workers are updating post-Covid-19 skills. Individuals interested in health and social care roles. Tech enthusiasts are exploring AI in healthcare applications. Requirements You don't need any educational qualification or experience to enrol in the Healthcare Assistant Training course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online course. Career path Healthcare Assistant - £18K to £25K/year. Infection Control Nurse - £25K to £35K/year Nursing Assistant - £17K to £25K/year. Social Care Worker - £16K to £22K/year. Medical Records Clerk - £17K to £24K/year. Course Curriculum Healthcare Assistant Training Module 1: Working in Different Healthcare Settings 00:15:00 Module 2: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 1 00:50:00 Module 3: Understanding Legal, Professional Standards of Practice and Ethical Aspects of Health Care Part - 2 00:48:00 Module 4: Maintaining Medical Records 00:22:00 Module 5: Confidentiality in a Medical Environment 00:17:00 Module 6: Health and Safety Responsibilities 00:51:00 Module 7: Hygiene in Nursing 00:30:00 Module 8: Infection Control 00:57:00 Module 9: Mobility and Immobility Issues of Patients in Nursing 00:15:00 Module 10: Rights and Responsibilities as a Health and Social Care Worker 00:39:00 Module 11: Role as A Caregiver and Healthcare Professional 00:23:00 Module 12: Providing Care or Treatment to People Who Lack Capacity 00:11:00 Module 13: Managing Service Delivery in Health and Social Care 00:11:00 Module 14: Medical Jargon and Terminology 00:28:00 Module 15: Effects of Covid-19 on Human Life 00:19:00 Module 16: Preventions and Social Measures to Be Taken 00:28:00 Module 17: Information Technology in Health Care 00:16:00 Module 18: Artificial Intelligence, Data Science and Technological Solutions against Covid-19 00:19:00 Assignment Assignment - Healthcare Assistant Training 00:00:00

***Accounting & Finance - Level 5*** Accounting and finance assist businesses in measuring, monitoring, and planning their operations. This Accounting & Finance - Level 5 course has been designed to provide a thorough introduction to business Accounting and Finance as both an idea and a profession. This Accounting & Finance - Level 5 course will equip you with in-demand accounting and finance skills as well as the ability to complete practicable processes while working in an organisation. This could be tricky, especially if this is your first consignment in the accounting and finance sector. Our Accounting & Finance - Level 5 course provides a solid understanding of accounting and financial methods, concepts, and duties to properly prepare you for a career in the accounting and finance sector. ***Others Benefits of this Accounting & Finance - Level 5 Course Free One PDF Certificate Lifetime Access Unlimited Retake Exam Tutor Support [ Note: Free PDF certificate as soon as completing the course ] ***Accounting & Finance - Level 5*** Detailed Course Curriculum of this Accounting & Finance - Level 5 Course: Module 1: Essentials of Accounting and Finance Identify the Non-Financial Manager's Concern with Finance The Importance of Finance Financial and Operating Environment Module 2: Types of Cost Data and Cost Analysis The Importance of Cost Data Types of Costs How Do Your Costs Behave? Segregating Fixed Cost and Variable Cost Cost Allocation Cost Analysis What You Can Learn from the Japanese? Module 3: Contribution Analysis Should You Accept a Special Order? How Do You Determine a Bid Price? Determining Profit from Year to Year Are You Utilising Capacity? Module 4: Break-Even and Cost-Volume-Profit Analysis What is Cost-Volume-Profit Analysis? What and Why of Break-Even Sales? What is the Margin of Safety? Cash Break-Even Point What is Operating Leverage? Sales Mix Analysis Module 5: Relevant Cost and Making Short-Term Decisions What Costs Are Relevant to You? Accepting or Rejecting a Special Order Pricing Standard Products Determining Whether to Sell or Process Further Adding or Dropping a Product Line Utilising Scarce Resources Don't Forget the Qualitative Factors Module 6: Forecasting Cash Needs and Budgeting Forecasts Using Forecasts Preparing Financial Forecasts Budgets The Sales Budget The Production Budget The Direct Material Budget The Direct Labour Budget The Factory Overhead Budget The Ending Inventory The Selling and Administrative Expense Budget The Cash Budget The Budgeted Income Statement The Budgeted Balance Sheet A Shortcut Approach to Formulating the Budget Module 7: Cost Control and Variance Analysis Defining a Standard The Usefulness of Variance Analysis Setting Standards Determining and Evaluating Sales Variances Cost Variances Labour Variances Overhead Variances The Use of Flexible Budgets in Performance Reports Standards and Variances in Marketing Sales Standards Variances in Warehousing Costs Module 8: Managing Financial Assets Working Capital Financing Assets Managing Cash Properly Getting Money Faster Delaying Cash Payments Opportunity Cost of Foregoing a Cash Discount Volume Discounts Module 9: Managing Accounts Receivable and Credit Credit References Credit Policy Analysing Accounts Receivable Module 10: Managing Inventory Inventory Management Considerations Inventory Analysis Determining the Carrying and Ordering Costs The Economic Order Quantity (EOQ) Avoiding Stock Outs Determining the Reorder Point or Economic Order Point (EOP) The ABC Inventory Control Method Supply Chain Management Module 11: The Time Value of Money Future Values - How Money Grows Future Value of an Annuity Present Value - How Much Money is Worth Now? Present Value of Mixed Streams of Cash Flows Present Value of an Annuity Perpetuities Applications of Future Values and Present Values Module 12: Capital Budgeting Decisions Types of Investment Projects What Are the Features of Investment Projects? Selecting the Best Mix of Projects With a Limited Budget Income Taxes and Investment Decisions Types of Depreciation Methods How Does MACRS Affect Investment Decisions? The Cost of Capital Module 13: Improving Managerial Performance What is Return on Investment (ROI)? What Does ROI Consist of? - Du Pont Formula ROI and Profit Objective ROI and Profit Planning ROI and Return on Equity (ROE) Module 14: Sources of Short-Term Financing Trade Credit Cash Discount When are Bank Loans Advisable? Working with a Bank Issuing Commercial Paper Using Receivables for Financing Using Inventories for Financing Module 15: Considering Term Loans and Leasing Intermediate-Term Bank Loans Using Revolving Credit Insurance Company Term Loans Financing with Equipment Leasing Module 16: Long-Term Debt and Equity Financing Types of Long-Term Debt Equity Securities How Should You Finance? Module 17: Accounting Conventions and Recording Financial Data Double Entry and the Accounting Equation Assessment Method After completing each module of the Accounting & Finance - Level 5 course, you will find automated MCQ quizzes. To unlock the next module, you need to complete the quiz task and get at least 60% marks. Once you complete all the modules in this manner, you will be qualified to request your certification. Certification After completing the MCQ/Assignment assessment for this Accounting & Finance - Level 5 course, you will be entitled to a Certificate of Completion from Training Tale. It will act as proof of your extensive professional development. The certificate is in PDF format, which is completely free to download. A printed version is also available upon request. It will also be sent to you through a courier for £13.99. Who is this course for? Accounting & Finance - Level 5 This Accounting & Finance - Level 5 course is ideal for: Candidates interested to start a career in accountancy Business owners seeking to look after their own accounts Existing accountancy workers in seeking higher positions or promotion Accountancy workers with no formal qualifications Anyone wishing to boost their career prospects. Requirements Accounting & Finance - Level 5 There are no specific requirements for Accounting & Finance - Level 5 course because it does not require any advanced knowledge or skills. Students who intend to enrol in this Accounting & Finance - Level 5 course must meet the following requirements: Good command of the English language Must be vivacious and self-driven Basic computer knowledge A minimum of 16 years of age is required Career path Accounting & Finance - Level 5 This Accounting & Finance - Level 5 course may lead you to a variety of career opportunities. Accounts Assistant Accounts Payable & Expenses Supervisor Accounts Payable Clerk Audit Trainee Payroll Administrator / Supervisor Tax Assistant / Accountant. Accounting Clerk Auditing Clerk Accounts Receivable Clerk Certificates Certificate of completion Digital certificate - Included

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 Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets? 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 Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Oil Market: Trading, Pricing & Future Oil Markets 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 Oil Market: Trading, Pricing & Future Oil Markets is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Crude Oil: A Unique Raw Material Introduction 00:04:00 A Marker Price 00:02:00 Different strategies 00:02:00 Section 02: International Oil Trade Introduction 00:01:00 The 1970s : Long term contracts 00:02:00 The 1980s : The development of spot markets 00:02:00 The netback contracts 00:05:00 The 1990s : The development of financial markets 00:02:00 Section 03: Prices on the Oil Markets Introduction 00:01:00 The different types of agreements 00:03:00 Crude oil price setting mechanism 00:02:00 Product price setting mechanism 00:02:00 Section 04: Trading On the Oil Markets Barter agreements 00:01:00 Single cargo sales 00:02:00 Long term contracts 00:02:00 Section 05: The Spot Markets Definition 00:02:00 Spot markets in the world 00:02:00 Operators on the spot markets 00:01:00 The balance between crude oil and product prices 00:02:00 Section 06: Spot Crude Oil Prices Spot transactions 00:02:00 The Brent market 00:02:00 The Brent crude oil 00:01:00 Price transparency 00:03:00 Indexing crude oil prices : The adjustment factor 00:03:00 Indexing crude oil prices : Reference indices 00:02:00 Indexing crude oil prices : The price timing 00:06:00 The limitation of the system 00:03:00 Section 07: Petroleum Products Price Setting Mechanism Example #1 : The Rotterdam products market 00:03:00 How prices are reported 00:02:00 Section 08: The Physical Futures Markets The forward market 00:03:00 The principle of cover 00:02:00 Speculation 00:01:00 The players on the forward markets 00:01:00 Dated Brent and 15 Day Brent 00:05:00 The limitations of the forward markets 00:01:00 Section 09: The Financial Futures Markets The historical development of the petroleum exchanges 00:03:00 Futures contracts 00:01:00 How the markets work : Generalities 00:02:00 How the markets work : The clearing house 00:01:00 How the markets work : The deposit 00:01:00 How the markets work : The margin call 00:01:00 The participants 00:04:00 Pricing structures : Backwardation and Contango 00:02:00 The limitations of the futures markets 00:07:00 Section 10: Derivative Products: Swaps and Options The definition of an option 00:01:00 Example of the use of an option : Call option 00:02:00 Example of the use of an option : Put option 00:01:00 The cost of an option 00:02:00 The definition of a swap 00:01:00 Example of the use of a swap 00:04:00 Section 11: Course Conclusion Course conclusion 00:02:00 Assignment Assignment - Oil Market: Trading, Pricing & Future Oil Markets 00:00:00

Unravel the complexities of financial markets with the 'Day Trading & Scalping Strategies' course. This program is a comprehensive guide for those aspiring to master the art of quick, profitable trading. The course begins with an introduction to the fundamental concepts of day trading and scalping, setting a solid foundation for more advanced strategies. Learners are introduced to a variety of tools and techniques, each designed to navigate the fast-paced world of short-term trading. The curriculum is crafted to ensure a deep understanding of market dynamics and the skills needed to make informed trading decisions. Advance through the course to explore specialized strategies using tools like MACD, Moving Averages, RSI, and EMA's, each section providing a detailed approach to utilizing these indicators effectively. The course also emphasizes the critical aspect of risk management, ensuring traders are well-equipped to handle market volatility. As you progress, you'll encounter strategies tailored for different markets, including cryptocurrencies, forex, and stocks, offering a broad perspective on day trading and scalping techniques. The final section provides bonus content, further enriching your trading toolkit. Whether you're a novice looking to enter the world of trading or an experienced trader seeking to refine your strategies, this course offers valuable insights and practical skills. Learning Outcomes Understand the principles and techniques of day trading and scalping. Develop skills in utilizing MACD, Moving Averages, RSI, and EMA's for trading strategies. Master the art of risk management in day trading. Learn specialized strategies for trading in crypto, forex, and stock markets. Enhance decision-making abilities in fast-paced trading environments. Why choose this Day Trading & Scalping Strategies course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Day Trading & Scalping Strategies course for? Individuals interested in learning day trading and scalping techniques. Traders seeking to diversify their strategy portfolio. Beginners aiming to enter the financial trading market. Investors looking to enhance their short-term trading skills. Finance professionals seeking advanced trading strategies. Career path Day Trader: £30,000 - £100,000+ Financial Analyst: £35,000 - £60,000 Risk Manager: £40,000 - £70,000 Trading Strategy Consultant: £45,000 - £80,000 Cryptocurrency Trader: £30,000 - £90,000+ Forex Trader: £30,000 - £100,000+ Prerequisites This Day Trading & Scalping Strategies does not require you to have any prior qualifications or experience. You can just enrol and start learning. This course 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Section 01: Introduction Introduction to the Course 00:04:00 Section 02: Risk Management Introduction to Risk Management 00:02:00 What a Risk Management? 00:03:00 Why Risk Management is So Important 00:18:00 Why You Have to Manage Your Risk 00:18:00 My Risk Management System 00:12:00 You Can't Progress in Something That You Don't Measure 00:09:00 Section 03: Professional Day trading/Scalping strategy with MACD Introduction 00:02:00 Trading on 2 different timeframe 00:10:00 How to add it to your screen 00:05:00 The rules that you have to follow 00:15:00 Let's practice it 00:30:00 Results from the practice 00:10:00 Class project 00:01:00 Section 04: Day trading / scalping PRO strategy with Moving averages Introduction 00:04:00 How to put it on your screen 00:05:00 The criteria needed 00:19:00 Entries, exits and stop losses practice 00:24:00 51% profits on the account in 6 weeks on 1 pair 00:15:00 Class project 00:01:00 Section 05: Day trading / scalping strategy with RSI and EMA's Introduction 00:03:00 The setup 00:09:00 The Criteria 00:14:00 Practice 00:30:00 22 % profit on account in 30 trades 00:14:00 68 % Win Rate 00:01:00 Section 06: Day trading strategies with Stochastic indicator and EMA's Introduction 00:03:00 Why you have to be using multiple timeframes 00:09:00 Introduction to using Stochastic indicator with an EDGE 00:08:00 First strategy - How to set it up on your chart 00:07:00 First strategy - Criteria 00:30:00 First strategy - Practice 00:20:00 Second strategy - Criteria 00:12:00 Second strategy - Practice 00:15:00 Class project 00:01:00 Section 07: 2 Scalping/ Day trading strategies for Crypto/Forex/Stocks Introduction 00:03:00 The first Scalping / Day trading strategy 00:14:00 Volatility is key 00:08:00 Practice of the First strategy 00:17:00 Second scalping / day trading strategy and how to set it up 00:04:00 Criteria for the second strategy 00:04:00 Backtesting the second strategy 00:23:00 Class project 00:01:00 Section 08: Bonus How to Know When to Take Profits 00:35:00 Hull Moving Average 00:06:00 7 Habits Belief of Successful Traders 00:17:00 Momentum Play with Multiple Timeframes 00:20:00 Assignment Assignment - Day Trading & Scalping Strategies in 2021 00:00:00

Unlock the secrets to landing your dream mechanical engineering job. Our Crack Your Mechanical Engineer Interview course equips you with the essential knowledge and interview techniques to impress employers. From fundamental mechanical engineering principles to in-demand industry specialisations, gain the confidence to ace your interview and launch a fulfilling career. Learning Outcomes: Master foundational mechanical engineering concepts. Explore diverse fields like manufacturing and material science. Gain a solid understanding of strength of materials and theory of machines. Delve into automotive engineering and fluid mechanics. Solidify your grasp of thermodynamics, RAC & HMT. Why buy this Crack Your Mechanical Engineer Interview course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Certification After studying the course materials of the Crack Your Mechanical Engineer Interview 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? Individuals seeking mechanical engineer jobs. Graduates with a mechanical engineering degree. Professionals aiming to transition into mechanical engineering. Aspiring engineers seeking a strong foundation in the field. Anyone interested in understanding mechanical engineering concepts. Prerequisites This Crack Your Mechanical Engineer Interview does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Crack Your Mechanical Engineer Interview 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 Mechanical Engineer: £30,000 - £60,000 Per Annum Design Engineer: £35,000 - £70,000 Per Annum Production Engineer: £32,000 - £58,000 Per Annum Maintenance Engineer: £30,000 - £55,000 Per Annum Project Engineer: £40,000 - £80,000 Per Annum Manufacturing Engineer: £38,000 - £65,000 Per Annum Course Curriculum Section 01: Introduction Scope of the course 00:03:00 Section 02: Basic Mechanical Engineering (BME) Introduction to Basic Mechanical Engineering 00:02:00 Explain the term torque 00:03:00 State Archimedes Principle 00:02:00 What is the importance of tolerance in engineering? 00:04:00 Explain different types of fits 00:03:00 Section 03: Manufacturing & Material Science Introduction to Manufacturing & Material Science 00:01:00 Define pitting 00:03:00 Distinguish Between A Jig And Fixture 00:03:00 Explain knurling 00:03:00 Why is heat treatment of steel metal crucial? 00:03:00 What is extruded aluminium? 00:02:00 What do you mean by annealing? 00:04:00 How is martensite structure formed in steel? 00:04:00 Section 04: Strength Of Material (SOM) Introduction to Strength Of Material 00:01:00 Define a uniformly distributed load 00:04:00 Define Buckling Factor 00:02:00 Is it the stress that produces strain or vice-versa 00:04:00 What is the value of modulus of elasticity of steel? 00:03:00 What is Stress Concentration? 00:03:00 Section 05: Theory Of Machine (TOM) Introduction to Theory Of Machine 00:01:00 What is gear ratio? 00:01:00 What do you mean by cotter joint 00:04:00 What are the advantages of Gear drive? 00:04:00 What are the benefits of cycloidal gears? 00:03:00 Section 06: Automobile Engineering Introduction to automobile engineering 00:01:00 What are the various types of brakes? 00:03:00 Differentiate between scavenging and supercharging 00:03:00 In IC engine, which part is known as column? 00:03:00 What causes white smoke in two-stroke locomotive engines? 00:03:00 What is the difference between turbochargers and superchargers? 00:02:00 Section 07: Fluid Mechanics (FM) Introduction to Fluid Mechanics 00:01:00 Explain The Difference Between Rotational And Irrotational Flow? 00:03:00 Navier Stokes Equation Represents The Conservation Of Which Quantity? 00:03:00 What are major and minor head losses in a fluid flow system? 00:03:00 What is a Newtonian fluid? 00:05:00 What are the differences between elbows and bends? Which has greater head losses? 00:05:00 What is the ratio of the thickness of TBL to the thickness of HBL? 00:03:00 Section 08: Thermodynamics Introduction to Thermodynamics 00:01:00 What is the second law of thermodynamics? 00:04:00 What is the difference between the heat engine & heat pump? 00:05:00 Section 09: RAC & HMT Introduction to RAC & HMT 00:01:00 What is Refrigeration? What is the unit of refrigeration? 00:03:00 Which Cycle is used in Air Refrigeration System? 00:02:00 What do you mean by emissive power? 00:02:00 What is Under-cooling or Sub-cooling of refrigeration system? 00:03:00 Explain mechanical refrigeration 00:02:00 What is heat transfer co-efficient? 00:01:00 Section 10: Miscellaneous What is the advantage of using pneumatic? 00:03:00 Define least count and how to calculate for vernier callipers? 00:02:00 Why do you need a biological shield in nuclear plants? 00:03:00 What Is The Value Of Coefficient Of Friction For Ball Bearing? 00:02:00

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 Legal Secretary and Office Skills Diploma 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 Legal Secretary and Office Skills Diploma Course is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This Legal Secretary and Office Skills Diploma 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 Legal Secretary and Office Skills Diploma 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 Legal Secretary and Office Skills Diploma? 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 Legal Secretary and Office Skills Diploma 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 free. Original Hard Copy certificates need to be ordered at an additional cost of £8. Who is this course for? This Legal Secretary and Office Skills Diploma 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 Legal Secretary and Office Skills Diploma does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Legal Secretary and Office Skills Diploma 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 Legal Secretary and Office Skills Diploma is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Legal Secretary Module 01: Introduction to Legal Secretary 00:25:00 Module 02: English Law & Legal Systems 00:35:00 Module 03: The Legal Workplace & Professionals 00:47:00 Module 04: Law of Contract & Law of Tort 00:31:00 Module 05: Wills, Probate and Estate Law Practice 00:17:00 Module 06: Property Law & Conveyancing Practice 00:21:00 Module 07: Family Law and Insurance Practice 00:26:00 Module 08: Professional Writings and Documents 00:30:00 Module 09: Document Proofreading and Editing 00:07:00 Module 10: Meeting Management & Minute Taking 01:09:00 Module 11: Customer Service and Telephone Handling Skills 00:23:00 Module 12: Data Management and Record-Keeping 00:16:00 Module 14: Other Essential Skills for Secretarial Role 00:22:00 Module 15: Professional Conduct and Ethics 00:24:00 Microsoft Word Essentials New Word Document and Templates 00:02:00 Tabs, Ribbons and Groups 00:03:00 Zoom and Rulers in Word 00:02:00 Editing the Word Document 00:03:00 Insert Pictures with Word 00:05:00 Insert Shape and Text Box in Word 00:02:00 Review Tab in Word 00:03:00 Layout in Word 00:02:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft PowerPoint Essentials New PowerPoint Presentation and Templates 00:02:00 Tabs Ribbons and Groups in PowerPoint 00:03:00 First Slide and Designing the Slide 00:02:00 Home Tab and Updates in PowerPoint 00:02:00 Buttons in PowerPoint 00:01:00 Inserting Pictures in PowerPoint 00:04:00 Presentation Mode 00:01:00 Animations Tab 00:05:00 File Options in Word 00:02:00 Closing and Reopening in Word 00:01:00 Microsoft Outlook Essentials Setting Up Outlook with Accounts 00:03:00 Tabs, Ribbons and Groups in Outlook 00:03:00 Navigation Bar in Outlook 00:01:00 Organizing Outlook with Favorites and Folders 00:03:00 Additional Options inside Outlook Tabs 00:01:00 Reading, Writing and Receiving Emails 00:08:00 Attaching Items in Outlook Mails 00:03:00 The View Tab in Outlook 00:02:00 Create a Rule to move emails to a folder 00:04:00 Insert a screen shot from Excel 00:02:00 Microsoft Excel - Top 50 Keyboard Shortcuts Formatting Excel Keyboard Shortcuts 00:02:00 Table Excel Keyboard Shortcuts 00:02:00 Editing Excel Keyboard Shortcuts 00:05:00 Formula Excel Keyboard Shortcuts 00:03:00 Workbook Excel Keyboard Shortcuts 00:02:00 Handy Excel Shortcuts Keyboard Shortcuts 00:05:00 Assignment Assignment - Legal Secretary and Office Skills Diploma 01:00:00

In an era awash with data, understanding it is the key to unlocking significant opportunities. Enter the realm of 'SQL For Data Analytics & Database Development'. Dive deep into the heart of data manipulation, exploration, and insight generation. This course unfurls the magic behind SQL, drawing back the curtain on the tools that empower businesses globally. Understanding SQL's profound capabilities opens doors to a world where data-driven decision-making is not just an advantage but an imperative. It isn't simply about data storage. This course unravels the art of analytics, shedding light on how to glean valuable insights from vast data lakes. The path of SQL isn't merely technical; it's the spine of transformative decisions in today's leading industries. Offering a systematic approach to database development, we invite you to embark on this illuminative journey, stitching the threads of raw data into the fabric of meaningful stories. Come harness the power of SQL. Whether your intent is data analytics or the intricate craft of database development, this is your gateway. Let us guide you, from the rudimentary steps to mastering advanced commands, constructing your data narrative, and informing the future. Learning Outcomes: Comprehend the fundamental architecture of SQL and its environment. Acquire proficiency in basic and advanced SQL statements. Understand and implement GROUP BY statements for data aggregation. Master the concepts and applications of JOINS in databases. Cultivate the ability to create and structure databases and tables. Delve into advanced SQL commands, enhancing data manipulation and querying capabilities. Construct efficient database models, fostering optimal data storage and retrieval.   Video Playerhttps://studyhub.org.uk/wp-content/uploads/2021/03/SQL-DATA-ANALYSIS.mp400:0000:0000:00Use Up/Down Arrow keys to increase or decrease volume. Why choose this SQL For Data Analytics & Database Development course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments are designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the SQL For Data Analytics & Database Development Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Who is this SQL For Data Analytics & Database Development course for? Aspirants seeking to transition into data-driven roles in various industries. Database administrators aiming to broaden their analytical capabilities. Business analysts eager to enhance their data querying skills. Researchers in need of comprehensive data management tools. Tech enthusiasts wanting to grasp the underpinnings of database systems. Career path Data Analyst - Average salary: £35,000 - £50,000 Per Annum Database Developer - Average salary: £40,000 - £55,000 Per Annum Business Intelligence Analyst - Average salary: £38,000 - £52,000 Per Annum SQL Developer - Average salary: £42,000 - £58,000 Per Annum Database Administrator (DBA) - Average salary: £45,000 - £60,000 Per Annum Data Engineer - Average salary: £47,000 - £63,000 Per Annum Prerequisites This SQL For Data Analytics & Database Development 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Course Introduction Introduction 00:04:00 Course Curriculum Overview 00:05:00 Overview of Databases 00:10:00 SQL Environment Setup MySQL Installation 00:16:00 MySQL Workbench Installation 00:09:00 Connecting to MySQL using Console 00:09:00 SQL Statement Basics Overview of Challenges 00:04:00 SQL Statement Basic 00:16:00 SELECT Statement 00:09:00 SELECT DISTINCT 00:05:00 Column AS Statement 00:12:00 COUNT built-in Method usage 00:11:00 SELECT WHERE Clause - Part One 00:05:00 SELECT WHERE Clause - Part Two 00:11:00 SQL Statement Basic 00:16:00 SQL Limit Clause Statement 00:09:00 SQL Using BETWEEN with Same Column Data 00:11:00 How to Apply IN Operator 00:11:00 Wildcard Characters with LIKE and ILIKE 00:11:00 GROUP BY Statements Overview of GROUP BY 00:06:00 Aggregation function SUM() 00:09:00 Aggregation MIN() and MAX() 00:05:00 GROUP BY - One 00:09:00 GROUP BY - Two 00:12:00 HAVING Clause 00:05:00 JOINS Overview of JOINS 00:04:00 Introduction to JOINS 00:04:00 AS Statement table 00:03:00 INNER Joins 00:14:00 FULL Outer Join 00:11:00 LEFT Outer JOIN 00:08:00 RIGHT JOIN 00:08:00 Union 00:07:00 Advanced SQL Commands / Statements Timestamps 00:12:00 EXTRACT from timestamp 00:10:00 Mathematical Functions 00:12:00 String Functions 00:22:00 SUBQUERY 00:13:00 Creating Database and Tables Basic of Database and Tables 00:06:00 DataTypes 00:10:00 Primarykey and Foreignkey 00:06:00 Create Table in SQL Script 00:13:00 Insert 00:11:00 Update 00:07:00 Delete 00:04:00 Alter Table 00:09:00 Drop Table 00:05:00 NOT NULL Constraint 00:08:00 UNIQUE Constraint 00:09:00 Databases and Tables Creating a Database backup 00:12:00 10a Overview of Databases and Tables 00:05:00 10c Restoring a Database 00:07:00