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

17460 Teaching courses in Bolsover delivered On Demand

SQL NoSQL Big Data and Hadoop

4.9(27)

By Apex Learning

Overview This comprehensive course on SQL NoSQL Big Data and Hadoop will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This SQL NoSQL Big Data and Hadoop 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? At the end of the course there will be an online written test, which you can take either during or after the course. After successfully completing the test you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this SQL NoSQL Big Data and Hadoop. It is available to all students, of all academic backgrounds. Requirements Our SQL NoSQL Big Data and Hadoop 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 14 sections • 130 lectures • 22:34:00 total length •Introduction: 00:07:00 •Building a Data-driven Organization - Introduction: 00:04:00 •Data Engineering: 00:06:00 •Learning Environment & Course Material: 00:04:00 •Movielens Dataset: 00:03:00 •Introduction to Relational Databases: 00:09:00 •SQL: 00:05:00 •Movielens Relational Model: 00:15:00 •Movielens Relational Model: Normalization vs Denormalization: 00:16:00 •MySQL: 00:05:00 •Movielens in MySQL: Database import: 00:06:00 •OLTP in RDBMS: CRUD Applications: 00:17:00 •Indexes: 00:16:00 •Data Warehousing: 00:15:00 •Analytical Processing: 00:17:00 •Transaction Logs: 00:06:00 •Relational Databases - Wrap Up: 00:03:00 •Distributed Databases: 00:07:00 •CAP Theorem: 00:10:00 •BASE: 00:07:00 •Other Classifications: 00:07:00 •Introduction to KV Stores: 00:02:00 •Redis: 00:04:00 •Install Redis: 00:07:00 •Time Complexity of Algorithm: 00:05:00 •Data Structures in Redis : Key & String: 00:20:00 •Data Structures in Redis II : Hash & List: 00:18:00 •Data structures in Redis III : Set & Sorted Set: 00:21:00 •Data structures in Redis IV : Geo & HyperLogLog: 00:11:00 •Data structures in Redis V : Pubsub & Transaction: 00:08:00 •Modelling Movielens in Redis: 00:11:00 •Redis Example in Application: 00:29:00 •KV Stores: Wrap Up: 00:02:00 •Introduction to Document-Oriented Databases: 00:05:00 •MongoDB: 00:04:00 •MongoDB Installation: 00:02:00 •Movielens in MongoDB: 00:13:00 •Movielens in MongoDB: Normalization vs Denormalization: 00:11:00 •Movielens in MongoDB: Implementation: 00:10:00 •CRUD Operations in MongoDB: 00:13:00 •Indexes: 00:16:00 •MongoDB Aggregation Query - MapReduce function: 00:09:00 •MongoDB Aggregation Query - Aggregation Framework: 00:16:00 •Demo: MySQL vs MongoDB. Modeling with Spark: 00:02:00 •Document Stores: Wrap Up: 00:03:00 •Introduction to Search Engine Stores: 00:05:00 •Elasticsearch: 00:09:00 •Basic Terms Concepts and Description: 00:13:00 •Movielens in Elastisearch: 00:12:00 •CRUD in Elasticsearch: 00:15:00 •Search Queries in Elasticsearch: 00:23:00 •Aggregation Queries in Elasticsearch: 00:23:00 •The Elastic Stack (ELK): 00:12:00 •Use case: UFO Sighting in ElasticSearch: 00:29:00 •Search Engines: Wrap Up: 00:04:00 •Introduction to Columnar databases: 00:06:00 •HBase: 00:07:00 •HBase Architecture: 00:09:00 •HBase Installation: 00:09:00 •Apache Zookeeper: 00:06:00 •Movielens Data in HBase: 00:17:00 •Performing CRUD in HBase: 00:24:00 •SQL on HBase - Apache Phoenix: 00:14:00 •SQL on HBase - Apache Phoenix - Movielens: 00:10:00 •Demo : GeoLife GPS Trajectories: 00:02:00 •Wide Column Store: Wrap Up: 00:05:00 •Introduction to Time Series: 00:09:00 •InfluxDB: 00:03:00 •InfluxDB Installation: 00:07:00 •InfluxDB Data Model: 00:07:00 •Data manipulation in InfluxDB: 00:17:00 •TICK Stack I: 00:12:00 •TICK Stack II: 00:23:00 •Time Series Databases: Wrap Up: 00:04:00 •Introduction to Graph Databases: 00:05:00 •Modelling in Graph: 00:14:00 •Modelling Movielens as a Graph: 00:10:00 •Neo4J: 00:04:00 •Neo4J installation: 00:08:00 •Cypher: 00:12:00 •Cypher II: 00:19:00 •Movielens in Neo4J: Data Import: 00:17:00 •Movielens in Neo4J: Spring Application: 00:12:00 •Data Analysis in Graph Databases: 00:05:00 •Examples of Graph Algorithms in Neo4J: 00:18:00 •Graph Databases: Wrap Up: 00:07:00 •Introduction to Big Data With Apache Hadoop: 00:06:00 •Big Data Storage in Hadoop (HDFS): 00:16:00 •Big Data Processing : YARN: 00:11:00 •Installation: 00:13:00 •Data Processing in Hadoop (MapReduce): 00:14:00 •Examples in MapReduce: 00:25:00 •Data Processing in Hadoop (Pig): 00:12:00 •Examples in Pig: 00:21:00 •Data Processing in Hadoop (Spark): 00:23:00 •Examples in Spark: 00:23:00 •Data Analytics with Apache Spark: 00:09:00 •Data Compression: 00:06:00 •Data serialization and storage formats: 00:20:00 •Hadoop: Wrap Up: 00:07:00 •Introduction Big Data SQL Engines: 00:03:00 •Apache Hive: 00:10:00 •Apache Hive : Demonstration: 00:20:00 •MPP SQL-on-Hadoop: Introduction: 00:03:00 •Impala: 00:06:00 •Impala : Demonstration: 00:18:00 •PrestoDB: 00:13:00 •PrestoDB : Demonstration: 00:14:00 •SQL-on-Hadoop: Wrap Up: 00:02:00 •Data Architectures: 00:05:00 •Introduction to Distributed Commit Logs: 00:07:00 •Apache Kafka: 00:03:00 •Confluent Platform Installation: 00:10:00 •Data Modeling in Kafka I: 00:13:00 •Data Modeling in Kafka II: 00:15:00 •Data Generation for Testing: 00:09:00 •Use case: Toll fee Collection: 00:04:00 •Stream processing: 00:11:00 •Stream Processing II with Stream + Connect APIs: 00:19:00 •Example: Kafka Streams: 00:15:00 •KSQL : Streaming Processing in SQL: 00:04:00 •KSQL: Example: 00:14:00 •Demonstration: NYC Taxi and Fares: 00:01:00 •Streaming: Wrap Up: 00:02:00 •Database Polyglot: 00:04:00 •Extending your knowledge: 00:08:00 •Data Visualization: 00:11:00 •Building a Data-driven Organization - Conclusion: 00:07:00 •Conclusion: 00:03:00 •Assignment -SQL NoSQL Big Data and Hadoop: 00:00:00

SQL NoSQL Big Data and Hadoop
Delivered Online On Demand22 hours 34 minutes
£12

Introduction to the Paleo Diet Course

5.0(2)

By Training Express

The Paleo Diet is based on the principle of eating the way our prehistoric ancestors did, focusing on natural, unprocessed foods like lean meats, fish, fruits, vegetables, and nuts. This course offers a clear and comprehensive introduction to the Paleo way of eating, providing students with the essential knowledge to make informed dietary choices. Whether you're looking to improve your overall health or simply explore a new eating style, the Paleo Diet encourages an approach that is both simple and sustainable, prioritising whole foods that fuel the body without relying on modern processed alternatives. In this course, we cover the foundational principles of the Paleo Diet, its health benefits, and how to successfully incorporate it into your daily routine. You will learn about food groups that are encouraged and those that are excluded, as well as meal planning tips to make it easier to stick with the diet. Our expert-led lessons ensure that you gain a thorough understanding of how the Paleo Diet works, allowing you to make confident, health-conscious decisions that align with your lifestyle goals. This course provides valuable insights to guide you on your journey toward a more natural and balanced way of eating. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 01: Introduction to the Paleo Diet Module 02: Paleo Diet and the Health Benefits Module 03: Paleo Nutrition and Dietary Guidelines Module 04: Crafting the Paleo Palate Module 05: Addressing Challenges and Modifications Module 06: Sustaining the Paleo Lifestyle Module 07: Dietary Strategies for Specific Needs Module 08: Weightloss the Paleo Way Learning Outcomes: Understand the foundations of the Paleo Diet for better health. Explore the myriad health benefits associated with a Paleo lifestyle. Learn the essential dietary guidelines and principles of Paleo nutrition. Discover how to create delectable Paleo meals and snacks. Overcome challenges and adapt the Paleo Diet to your unique needs. Develop strategies for long-term sustainability and effective weight loss. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals seeking a healthier lifestyle. Nutrition enthusiasts and health-conscious individuals. Anyone interested in exploring the benefits of the Paleo Diet. Health coaches and fitness professionals. Those looking to address specific dietary needs. People on a weight loss journey. Individuals aiming to enhance their overall well-being. Anyone curious about the Paleo lifestyle's potential benefits. Career path Nutrition Consultant Health and Wellness Coach Personal Trainer Dietitian Culinary Instructor Food Blogger Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Introduction to the Paleo Diet Course
Delivered Online On Demand1 hour
£12

Achieving Social Relationship Goals Course

5.0(2)

By Training Express

Building strong social relationships is a goal many of us strive for, yet it can feel like a complex task. The "Achieving Social Relationship Goals Course" is designed to help you improve your social interactions, understand the dynamics of building meaningful connections, and ultimately strengthen your relationships. Whether you’re looking to enhance your friendships, deepen family bonds, or improve your workplace relationships, this course offers valuable insights into how relationships work and how to foster them with confidence. Through a combination of expert guidance and proven techniques, this course helps you navigate the challenges of building trust, communicating effectively, and managing expectations. With an emphasis on emotional intelligence and empathy, you'll learn how to foster connections that are genuine and sustainable. The practical strategies provided will assist you in recognising your relationship needs and offer the tools to form positive, lasting social bonds. Whether you’re struggling with social anxiety or simply want to take your relationships to the next level, this course provides a thoughtful and structured approach to achieving your social goals. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Social Relationship Goals Module 2: Effective Communication Skills Module 3: Conflict Resolution Strategies Module 4: Establishing Healthy Boundaries Module 5: Building Trust and Strengthening Relationships Module 6: Diversity and Inclusion in Relationships Module 7: Long-Term Relationship Maintenance Module 8: Social Relationships in the Digital Age Module 9: Action Planning and Goal Setting Learning Outcomes Master effective communication for impactful interactions. Resolve conflicts using proven strategies and maintain harmony. Establish and maintain healthy boundaries in diverse relationships. Build trust and strengthen connections for enduring relationships. Embrace diversity, fostering inclusivity in your social circles. Navigate the challenges of long-term relationship dynamics with confidence. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Professionals aiming to enhance workplace relationships. Students navigating the complexities of social interactions. Individuals committed to personal growth and relationship mastery. Couples seeking tools for sustaining long-term connections. Anyone eager to navigate the digital landscape of social relationships. Those wanting to build trust and strengthen connections in diverse environments. Individuals aspiring to resolve conflicts with finesse. Those interested in creating a strategic action plan for relationship goals. Career path Relationship Counsellor HR Specialist Communication Specialist Diversity and Inclusion Officer Social Media Manager Personal Development Coach Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Achieving Social Relationship Goals Course
Delivered Online On Demand1 hour
£12

Introduction to Aromatherapy Course

5.0(2)

By Training Express

Aromatherapy offers an ancient and therapeutic approach to wellbeing, using essential oils to create a harmonious balance for the body and mind. In this Introduction to Aromatherapy Course, you'll discover the fundamentals of this fascinating field and learn how scents can influence mood, promote relaxation, and even support physical health. With a mix of science and nature, this course is your gateway to understanding the basics of essential oils, their uses, and their impact on mental and emotional wellbeing. This course will guide you through key aromatherapy techniques, including how to blend oils effectively, the safety aspects to consider, and how essential oils can be integrated into daily life. Whether you're curious about the therapeutic benefits of scents or looking to add a touch of natural wellbeing to your routine, this course will provide you with the knowledge you need to start your journey in aromatherapy. With no previous experience necessary, it’s a perfect introduction to a world where nature’s scents hold the power to enhance your life. Key Features CPD Accredited FREE PDF + Hardcopy certificate Fully online, interactive course Self-paced learning and laptop, tablet and smartphone-friendly 24/7 Learning Assistance Discounts on bulk purchases Course Curriculum Module 1: Introduction to Aromatherapy Module 2: Essential Oils and Their Properties Module 3: Aromatherapy Techniques and Applications Module 4: Common Aromatherapy Blends and Recipes Module 5: Blending Techniques and Custom Formulations Module 6: Emotional Well-being and Aromatherapy Module 7: Physical Well-being and Aromatherapy Module 8: Safety and Ethical Practices in Aromatherapy Module 9: Aromatherapy for Special Populations Module 10: Business and Marketing in Aromatherapy Learning Outcomes: Explore essential oil properties for holistic well-being. Master diverse aromatherapy techniques for varied applications. Develop personalised blends catering to unique needs. Apply aromatherapy ethically and with safety in mind. Address emotional and physical concerns through aromatherapy. Navigate business and marketing strategies within the aromatherapy field. Accreditation This course is CPD Quality Standards (CPD QS) accredited, providing you with up-to-date skills and knowledge and helping you to become more competent and effective in your chosen field. Certificate After completing this course, you will get a FREE Digital Certificate from Training Express. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Wellness enthusiasts seeking holistic approaches. Individuals aspiring to enhance their therapeutic skills. Health practitioners interested in complementary therapies. Entrepreneurs looking to venture into aromatherapy products. Care professionals aiming to expand their toolkit. Those curious about the intersection of wellness and business. Parents exploring natural remedies for family well-being. Holistic health advocates keen on ethical practices. Career path Aromatherapist Wellness Consultant Essential Oil Retailer Spa and Wellness Centre Manager Holistic Health Practitioner Product Development Specialist Certificates Digital certificate Digital certificate - Included Once you've successfully completed your course, you will immediately be sent a FREE digital certificate. Hard copy certificate Hard copy certificate - Included Also, you can have your FREE printed certificate delivered by post (shipping cost £3.99 in the UK). For all international addresses outside of the United Kingdom, the delivery fee for a hardcopy certificate will be only £10. Our certifications have no expiry dates, although we do recommend that you renew them every 12 months.

Introduction to Aromatherapy Course
Delivered Online On Demand1 hour
£12

Retail Management and Merchandising

By Xpert Learning

About Course Master the art of Retail business with this comprehensive online course on Retail Management and Merchandising Retail Management Online course will teach you the basics to start a potential career or business in the promising field of the Retail Industry. Retail is an ever-growing industry. Retail management saves time and ensures that customers easily locate their desired merchandise and return home satisfied. Effective management avoids unnecessary chaos at the store and rather increases the sales of the store. Over the last couple of decades, total retail sales numbers in the United States have grown considerably, from just under 3 trillion U.S. dollars in 2000 to almost 6.6 trillion U.S. dollars in 2021. So it is definitely promising to start a business or career in the Retail industry. This Retail management online course will help individuals who are looking to start their career in the Retail management profession, or thinking about starting a business in this industry, This beginner's level course will be your stepping stone into the industry, and with a high level of professionalism, experience, and skills that it will enable, you have the potential to be en route to becoming a successful professional in the Retail industry. The retail Management online course is strategically divided into 9 modules to cover the key professional elements related to the Retail industry. It is designed in a way that not it will help the job seekers in this field but also the individuals with some experience who want to start a business. The course will help you learn from scratch and reach a higher level of professionalism. As you may know, organisational skills are important because good organisational skills establish trust and professionalism in the workplace. So, if you are looking to join the various Retail Management and organisational skills, then this Retail Management is your most desired course. What Will You Learn? Develop skills required for successful Retail Management and Merchandising Enhance communication skills for relationship selling and networking in retail management. Learn effective strategies for dealing with difficult customers and suppliers. Gain knowledge about stock management, including warehouse activities, aims of warehousing, material handling, and packaging. Course Content Introduction to Retail Management Productivity Techniques for Maximum Selling Communication Skills for Relationship Selling The Selling Process, Theories and Sales Promotions The Importance of Consumer Behavior Dealing with difficult customers Dealing with Suppliers Dealing with the management of stock Retail Merchandising Concluding Remarks A course by Xpert Learning RequirementsLearners with no prior Retail Management knowledge can enroll in this Retail Management course. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry. Audience Retail store owners or managers who want to improve their knowledge of retail management and merchandising strategies to increase their business profitability. Entry-level retail employees who want to develop their skills and knowledge of the retail business and eventually advance to managerial positions. Professionals from other fields who are considering a career change to retail management or who want to acquire knowledge about the retail industry.

Retail Management and Merchandising
Delivered Online On Demand1 hour 27 minutes
£9.99

Advanced Xero Accounting Course

By Xpert Learning

About Course Why should you enrol in the course? Xero is a cloud-based accounting software that is used by businesses of all sizes around the world. It is a powerful and easy-to-use tool that can help you to manage your finances more effectively. This online course will teach you everything you need to know about how to use Xero. You will learn how to set up your account, enter transactions, generate reports, and more. Whether you are a business owner, bookkeeper, or accountant, this course is for you. Learning outcomes of the course By the end of this course, you will be able to: Set up and manage a Xero account Enter transactions, including sales, purchases, and expenses Generate financial reports, such as profit and loss statements, balance sheets, and cash flow statements Reconcile bank accounts Process payroll File VAT returns Use advanced features of Xero, such as multi-currency and project tracking Target audience This course is ideal for: Business owners Bookkeepers Accountants Anyone who wants to learn how to use Xero Requirements for the course No prior experience with Xero is required Access to a computer with an internet connection Curriculum The course is divided into three levels: Beginner Intermediate Advanced The beginner level covers the basics of using Xero, such as setting up an account, entering transactions, and generating reports. The intermediate level covers more advanced topics, such as bank reconciliation, payroll, and VAT returns. The advanced level covers even more advanced topics, such as multi-currency and project tracking. Conclusion This online course is a comprehensive and easy-to-follow guide to using Xero. Whether you are a beginner or an experienced user, you will learn something new from this course. If you are interested in learning how to use Xero, I encourage you to enrol in this course today. What Will You Learn? Set up and manage a Xero account Enter transactions, including sales, purchases, and expenses Generate financial reports, such as profit and loss statements, balance sheets, and cash flow statements Reconcile bank accounts Process payroll File VAT returns Use advanced features of Xero, such as multi-currency and project tracking Course Content Getting Started Setting Up Xero How to activate Bank Feed on Xero Setting Up of The System Virtual Tour of Xero Adding a Business Bank Accounts and Cash Accounts on Xero Chart of Accounts and conversion balances Creating/Deleting (Tracking Categories) Customers and Suppliers Setting Up Customer and Supplier Create a Project Entering Purchase (Supplier Invoices), Purchase Credit Notes, Purchase Orders Entering Sales (Customer Invoice), Sales Credit Notes, Quotes Fixed Assets Entering Fixed Assets Inventory Bank Payments and Receipts Bank Feed or Import a Statement Entering Bank Payment and Bank Receipts Internal Bank Transfer Repeating Bill Cash Coding Petty Cash Petty Cash Bank Reconciliation Bank Reconciliation Business Credit Card Business Credit Card Aged Reports Aged Reports Payroll Payroll Vat Return Vat Return CIS Return CIS Return Accrual and Prepayment Accrual and Prepayment Accrued Income and Deferred Income Accrued Income and Deferred Income Depreciation Journal Depreciation Journal Management Reports Management Reports Preparation of Budget Preparation of Budget Cash Flow Cash Flow Payment Services on Xero Payment Services on Xero Bank Rules Bank Rules Multicurrency on Xero Multicurrency on Xero App Marketplace App Marketplace Introduction of Resources During Covid-19 Introduction of Resources during Covid-19 Correction of Errors Correction of Errors A course by Ujjwala D'Souza MAAT, Sage/Xero/Quickbooks Trainer/Advisor Material Includes Course Videos Coursebook RequirementsNo prior experience with Xero is requiredAccess to a computer with an internet connection Audience Business owners Bookkeepers Accountants Anyone who wants to learn how to use Xero Requirements No prior experience with Xero is required Access to a computer with an internet connection

Advanced Xero Accounting Course
Delivered Online On Demand
£9.99

Scope & Requirements Training - Complete Video Course

4.3(43)

By John Academy

Description: Scope and Requirement skill help you to develop the good understanding of project requirement. In the Scope & Requirements Training - Complete Video Course, you will learn the appropriate knowledge for increasing your scope and requirements. The Scope & Requirements Training - Complete Video Course includes the proper definition of scope, the ways of developing effective work breakdown structures, the requirement basics, the testable requirements, business domain modelling, and the Software Requirements Specifications. Throughout the Scope & Requirements Training - Complete Video Course, you will also learn the effective communication methods that are used for Project Management. You will learn the proper communication skill and listening skills so that you can use these two receptive skills for the growth of your business. The purpose of the course is to create more opportunities for your business. At the end of the course, you will know the essential tools and techniques for Project Requirements. Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Scope & Requirements Training - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Scope & Requirements Training - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Effective Listening Skills for Requirements Definition Listening FREE 00:09:00 Communication 00:09:00 To Be More Effective 00:19:00 Stakeholders Stakeholders 00:05:00 Stakeholder Questions 00:08:00 Scope Definition Scope Definition 00:15:00 Solution Assessment & Validation 00:13:00 The Project Data Sheet (PDS) 00:17:00 Creating Effective Work Breakdown Structures Creating Effective Work Breakdown Structures 00:08:00 Components of the WBS 00:13:00 Answer Four Key Questions 00:12:00 Requirements Basics Requirements Basics 00:05:00 What Makes A Good Requirement 00:10:00 Requirements 00:06:00 Use Cases Use Cases 00:07:00 Process for Developing a Use Case 00:04:00 Development Methodologies Development Methodologies 00:21:00 Rational Unified Process 00:14:00 The Scrum Flow 00:22:00 Testable Requirements Testable Requirements 00:09:00 Ambiguity Review 00:06:00 The Software Requirements Specification (SRS) The SRS 00:06:00 Quality Measures Related To Individual SRS 00:05:00 Business Domain Modeling Business Domain Modeling 00:05:00 BDM Example 00:06:00 Database Tables 00:03:00 Other Advanced Tools Other Advanced Tools 00:13:00 BlockSwimlane Workflow Diagram 00:13:00 Class Diagrams 00:11:00 Mock Exam Mock Exam- Scope & Requirements Training - Complete Video Course 00:20:00 Final Exam Final Exam- Scope & Requirements Training - Complete Video Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Scope & Requirements Training - Complete Video Course
Delivered Online On Demand5 hours 34 minutes
£11.99

Personal Planning & Development Course

4.3(43)

By John Academy

Description: This course is designed to help you grow and develop abilities to make the right decisions in life. You ought to always think out the issue before you make a decision. You'll make healthier decisions by viewing the total picture. If the issue is too huge for you to handle solo, ask for help. Talk with acquaintances, loved ones, or experts. In this course, y ou will also be guided to realise your true potentials. It will help you develop time management skills and personal effectiveness. It will also help you to build confidence and also be providing you with stress releasing techniques which will help you enjoy your personal as well as your professional life. With this course you will be able to increase your motivation. It will help you communicate with people easily with more confidence and this will increase your productivity. Who is the course for? This course is for people who are willing to help themselves to increase their confidence level and excel at their job. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment:  At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam. Certification: After you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognised accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path: Personal Planning & Development Course is a useful qualification to possess, and would be beneficial for the following careers: Child psychology Counsellor Personal development instructor Blogger. Chapter 01 Accepting the Facts 01:00:00 Chapter 02 Establishing Bravery 00:30:00 Chapter 03 Altering Habits 01:00:00 Chapter 04 Beauty is truth; truth beauty 00:30:00 Chapter 05 Favorable Contemplations 00:30:00 Chapter 06 Using Your Brain 00:30:00 Chapter 07 Wrapping Up 00:15:00 Mock Exam Mock Exam- Personal Planning & Development Course 00:20:00 Final Exam Final Exam- Personal Planning & Development Course 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Personal Planning & Development Course
Delivered Online On Demand4 hours 55 minutes
£11.99

Video Recording Training Course

4.3(43)

By John Academy

Description In today's time, most of us prefer to include video in any learning experiences, whether it is a tutorial video, DIY video or documentary video, people love learning from video. Research shows that people more likely to watch a video than to read documents, emails, or articles online. If you desire to learn to create professional looking videos, not for the sake of being trendy, but for numerous advantages video has for learning, then this Video Recording Training Course is what you need. Advances in video equipment and technology have made recording videos very easy and fast, although it is hardly ever possible to make engaging videos without having proper knowledge of it. In this course, you will follow a few helpful practices for creating winning videos in no time. You will learn how to record, edit, and share instructor-led video presentations, and more in a few very mild steps. Assessment: This course does not involve any MCQ test. Students need to answer assignment questions to complete the course, the answers will be in the form of written work in pdf or word. Students can write the answers in their own time. Once the answers are submitted, the instructor will check and assess the work. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Who is this Course for? Video Recording Training Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Video Recording Training Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. Module : 01 Tools I Personally Use for Recording 00:13:00 OBS Setup 00:10:00 Creating a Professional Background for $50 00:04:00 Product Creation On The Fly (Screencasting) 00:04:00 Your Lighting Setup 00:05:00 Module : 02 The Perfect Webcam Settings 00:07:00 Editing Your Videos with Paid Softwares 00:01:00 Editing Your Video with Free Softwares 00:01:00 Voice Inflection for 2X Sales 00:17:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Video Recording Training Course
Delivered Online On Demand1 hour 2 minutes
£11.99

SQL Database Administrator at QLS Level 5

4.5(3)

By Studyhub UK

Immerse yourself in the realm of database administration with the SQL Database Administrator at QLS Level 5 course. Gain mastery over SQL environment setup, statement fundamentals, advanced commands, and database creation. From optimizing queries to managing databases and tables, this course equips you with the skills to excel as a proficient SQL Database Administrator. Learning Outcomes Establish a strong foundation in SQL database administration, covering setup and configuration. Master SQL statement basics, including querying, filtering, and sorting data effectively. Utilize GROUP BY statements for data aggregation and summarization. Navigate the intricacies of table joins to extract meaningful insights from complex datasets. Demonstrate proficiency in advanced SQL commands and statements for enhanced database management. Why choose this SQL Database Administrator at QLS Level 5 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 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 Database Administrator at QLS Level 5 course for? Aspiring Database Administrators and SQL Professionals. Software Developers Seeking to Expand Their Database Management Skills. IT Professionals Interested in Database Administration. Data Analysts and Data Engineers Looking to Enhance Their SQL Knowledge Career path SQL Database Administrator - $60,000 to $110,000/year. Database Developer - $70,000 to $120,000/year. Data Engineer - $80,000 to $130,000/year. Database Manager - $90,000 to $150,000/year. Database Architect - $100,000 to $160,000/year Prerequisites This SQL Database Administrator at QLS Level 5 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. Endorsed Certificate of Achievement from the Quality Licence Scheme Learners will be able to achieve an endorsed certificate after completing the course as proof of their achievement. You can order the endorsed certificate for only £115 to be delivered to your home by post. For international students, there is an additional postage charge of £10. Endorsement The Quality Licence Scheme (QLS) has endorsed this course for its high-quality, non-regulated provision and training programmes. The QLS is a UK-based organisation that sets standards for non-regulated training and learning. This endorsement means that the course has been reviewed and approved by the QLS and meets the highest quality standards. Please Note: Studyhub is a Compliance Central approved resale partner for Quality Licence Scheme Endorsed courses. 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 Assignment Assignment - SQL Database Administrator at QLS Level 5 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

SQL Database Administrator at QLS Level 5
Delivered Online On Demand11 hours 50 minutes
£10.99