4700 Operations courses in Farnborough delivered Online

Culinary Skills Training Course Overview Culinary Skills Training offers a comprehensive introduction to the art of cooking, aimed at equipping learners with essential kitchen techniques, food preparation methods, and an understanding of various cuisines. Whether you're pursuing a career in the culinary field or enhancing your home cooking, this course provides the foundational skills needed to excel. Through a structured approach, learners will gain valuable expertise in ingredient selection, cooking methods, and recipe creation, preparing them for a range of culinary opportunities. By the end, students will be confident in creating diverse dishes and managing kitchen operations efficiently. Course Description This course dives into the core aspects of culinary arts, covering key topics such as recipe formulation, ingredient preparation, cooking techniques, and food presentation. Learners will explore various cuisines, understanding both traditional and modern cooking styles. Each module is designed to foster an appreciation for the science of food, from balancing flavours to selecting the right tools. Participants will develop a strong understanding of kitchen management, hygiene standards, and the techniques needed to create high-quality dishes. Upon completion, learners will have the skills to work in diverse culinary environments, from restaurants to catering businesses. Culinary Skills Training Curriculum: Module 01: Introduction to Culinary Techniques Module 02: Recipe Development and Ingredient Selection Module 03: Cooking Methods and Techniques Module 04: Culinary Arts Across Cuisines Module 05: Kitchen Management and Hygiene Module 06: Food Presentation and Plating (See full curriculum) Who is this course for? Individuals seeking to improve their cooking skills for personal or professional use. Professionals aiming to enhance their culinary expertise for career advancement. Beginners with an interest in learning the basics of cooking. Aspiring chefs or individuals looking to switch to a culinary career. Career Path Chef Kitchen Manager Caterer Food Stylist Restaurant Owner Culinary Instructor

Sage 50 Payroll Complete Course Course Overview: The "Sage 50 Payroll Complete Course" is designed to provide a thorough understanding of payroll processing using Sage 50 software. It covers everything from the basics to intermediate-level payroll management, enabling learners to confidently handle payroll operations. This course is ideal for those looking to enhance their payroll skills and streamline processes in line with UK regulations. Learners will gain essential knowledge on managing employee records, tax calculations, and statutory deductions, providing them with the tools to ensure accuracy and compliance. By the end of the course, participants will be equipped to manage payroll functions efficiently, saving time and reducing errors, making them invaluable assets to any organisation. Course Description: This course offers in-depth coverage of Sage 50 Payroll, starting with essential payroll concepts and progressing to intermediate-level skills. Learners will explore topics such as setting up and maintaining employee records, calculating PAYE, National Insurance, and pension contributions, as well as processing holiday pay, sick leave, and other statutory deductions. The course is structured to help learners understand the complexities of payroll management, ensuring they can apply the knowledge in real-world scenarios. Throughout, learners will gain the confidence to navigate Sage 50 Payroll software and understand the payroll process within a UK context, adhering to current laws and regulations. Sage 50 Payroll Complete Course Curriculum: Module 01: Sage 50 Payroll For Beginners Module 02: Sage 50 Payroll Intermediate Level (See full curriculum) Who is this course for? Individuals seeking to gain proficiency in payroll management. Professionals aiming to advance their career in payroll administration. Beginners with an interest in payroll or accounting roles. Anyone looking to understand UK payroll processes. Career Path: Payroll Administrator Payroll Manager HR Officer Accounts Assistant Finance Officer

HR Management Course Overview: This HR Management Course is designed to equip learners with essential knowledge and skills required to effectively manage human resources within any organisation. Covering key aspects of HR management, including recruitment, performance management, employee relations, and legal considerations, the course offers a comprehensive understanding of the core responsibilities of HR professionals. Learners will gain the confidence to tackle HR challenges in the workplace, improve organisational culture, and ensure compliance with employment laws. By the end of the course, participants will be well-prepared to contribute to HR strategy and operational efficiency in various sectors. Course Description: This course delves deeper into HR functions, offering insights into crucial topics such as employee engagement, talent acquisition, workforce development, and conflict resolution. Learners will explore modern HR practices, the role of HR in organisational development, and the application of HR policies within different industries. The course provides a solid foundation in understanding HR operations, helping learners develop the skills needed to manage employee lifecycle processes effectively. Emphasis is placed on understanding legal frameworks, diversity and inclusion, and managing change within the workforce, preparing learners for dynamic HR roles in any business environment. HR Management Course Curriculum: Module 01: Introduction to HR Management Module 02: Recruitment and Selection Strategies Module 03: Employee Engagement and Retention Module 04: Performance Management and Development Module 05: Employment Law and Ethical Considerations Module 06: Compensation and Benefits Management Module 07: Workforce Diversity and Inclusion Module 08: Managing Change in the Workforce (See full curriculum) Who is this course for? Individuals seeking to build a career in HR management. Professionals aiming to enhance their HR skills for career progression. Beginners with an interest in human resources and organisational development. HR specialists looking to update their knowledge and practices. Career Path: HR Manager Recruitment Specialist Employee Relations Manager Talent Acquisition Specialist HR Consultant Learning and Development Coordinator

Project Planning for Everyone Course Overview: "Project Planning for Everyone" is designed to provide learners with the essential skills required to plan and manage projects effectively. This course covers the fundamental concepts of project planning, including the use of MS Projects for task management, data entry, and creating timelines. By the end of the course, learners will be equipped with the knowledge and confidence to plan projects efficiently, track progress, and ensure successful project delivery. Whether you’re new to project management or looking to refine your skills, this course offers practical value for all learners. Course Description: This course offers an in-depth introduction to project planning, with a focus on using MS Projects as a tool for creating project plans and tracking their progress. Learners will explore basic MS Projects features, including creating tasks, setting deadlines, and entering project data. The course progresses into more complex aspects, such as resource management and task dependencies, providing learners with a comprehensive understanding of project planning. The course includes a structured learning experience with clear objectives, enabling learners to build the skills necessary for effective project management. Upon completion, learners will have a solid foundation in project planning, ready to apply their skills in various professional settings. Project Planning for Everyone Curriculum: Module 01: Introduction Module 02: Basic M S Projects Module 03: Data Entry in MS Projects (See full curriculum) Who is this course for? Individuals seeking to improve their project management skills Professionals aiming to enhance their career development in project planning Beginners with an interest in project management and MS Projects Those interested in working within project management teams or handling individual projects Career Path: Project Manager Project Coordinator Operations Manager Scheduling Coordinator Team Leader in project-based industries

Day-to-Day Leadership Course Overview: This course on Day-to-Day Leadership equips learners with the essential tools and strategies to effectively lead on a daily basis. Covering key leadership principles and real-world applications, it focuses on enhancing decision-making, communication, and team management. Learners will explore situational leadership, practical models, and adaptable leadership styles that can be applied to diverse organisational settings. The course provides learners with the confidence to implement leadership strategies that foster collaboration, productivity, and team morale in their daily work. Course Description: The Day-to-Day Leadership course delves deeper into various leadership theories, including Situational Leadership, and offers a structured framework for leading teams effectively. Throughout the course, learners will engage with key concepts, including how to adapt leadership styles to different situations, develop key skills for motivating teams, and apply leadership strategies to ensure productivity and engagement. With an emphasis on real-world applications, learners will be guided through practical models and gain valuable insights into team dynamics, communication, and problem-solving. This course is ideal for individuals looking to enhance their leadership capabilities and progress in their professional development. Day-to-Day Leadership Curriculum: Module 01: Introduction to this Course Module 02: Introduction to Situational Leadership Module 03: A Practical Model for Day-to-Day Leadership Module 04: The Skills for Day-to-Day Leadership Styles Module 05: Bonus Content Module 06: Closing Section (See full curriculum) Who is this course for? Individuals seeking to develop leadership capabilities. Professionals aiming to enhance their team management skills. Beginners with an interest in leadership and management. Those interested in improving day-to-day workplace leadership. Career Path: Team Leader Operations Manager Project Manager Department Head Leadership Coach Organisational Development Specialist

How to Analyse & Maximize Restaurant Profits Course Overview This course on "How to Analyse & Maximize Restaurant Profits" offers comprehensive insights into understanding the financial dynamics of a restaurant business. It covers key concepts such as revenue analysis, menu optimisation, and cost control strategies to help learners identify areas of improvement for enhanced profitability. By the end of the course, learners will have a thorough understanding of the various factors influencing restaurant performance, from pricing strategies to inventory management. This course provides valuable skills that enable learners to make informed decisions that directly impact the bottom line of any restaurant business. Course Description In this course, learners will explore essential topics such as restaurant revenue analysis, menu engineering, and cost management. The course delves into the principles of profit maximisation, offering strategies to analyse sales data, optimise menu offerings, and manage food and labour costs efficiently. Learners will acquire skills in identifying profitable menu items, reducing waste, and increasing operational efficiency. This in-depth course is designed to equip participants with the knowledge and strategies needed to improve the profitability of a restaurant, ensuring they can make data-driven decisions to drive growth and sustainability. How to Analyse & Maximize Restaurant Profits Curriculum Module 01: Introduction Module 02: Restaurant Revenue Analysis Module 03: Menu Engineering Report Module 04: Cost Analysis & Management (See full curriculum) Who is this course for? Individuals seeking to understand restaurant profitability. Professionals aiming to enhance their skills in restaurant management. Beginners with an interest in the food and hospitality industry. Entrepreneurs looking to improve restaurant financial performance. Career Path Restaurant Manager F&B (Food and Beverage) Operations Manager Menu Analyst Financial Analyst in the hospitality industry Restaurant Owner/Entrepreneur

Leadership and Management Essential Skill Course Overview: The "Leadership and Management Essential Skill" course provides an in-depth exploration of key concepts, strategies, and tools essential for effective leadership and management. Learners will gain a comprehensive understanding of leadership theories, management principles, and the critical differences between the two. Designed for those seeking to enhance their managerial expertise, the course delves into leadership styles, their impact, and the common challenges leaders face. By completing this course, participants will be equipped to lead teams with confidence, make informed decisions, and effectively manage diverse challenges in the workplace. Course Description: This course covers a range of topics that are fundamental to leadership and management. Learners will explore core management principles, including decision-making and organisational strategies, and apply leadership theories to real-world scenarios. The course also examines the differences between leadership and management and provides insight into the obstacles leaders face, such as resistance to change and conflict resolution. Various leadership styles will be discussed, along with their impacts on team dynamics and the importance of mentoring. Upon completion, learners will possess a strong foundation in both leadership and management, enabling them to apply their knowledge to various professional environments. Leadership and Management Essential Skill Curriculum: Module 01: Principles of Management Module 02: Applied Theories on Leadership Module 03: Leadership and Management Differences & Applications Module 04: Obstacles in Leadership and Management Module 05: Different Leadership Styles Module 06: Impact of Different Leadership Style and Mentoring (See full curriculum) Who is this course for? Individuals seeking to develop leadership capabilities. Professionals aiming to advance in management roles. Beginners with an interest in leadership or management. Anyone looking to improve team and organisational performance. Career Path: Team Leader Project Manager Department Head Operations Manager Senior Executive Leadership Consultant

Are you embarking on the journey of mastering data analytics and visualisation in the UK? The 'Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7' is your beacon. Positioned to illuminate the intricate realm of Power BI, this course offers a comprehensive look into the foundational aspects and the advanced features that make Microsoft's tool a standout. With sections meticulously designed ranging from the fundamentals, like data transformation, to advanced concepts, such as integrating Power BI with Python and storytelling with data, this course ensures learners grasp the complete spectrum. With the rising emphasis on data analytics in today's business world, this course acquaints you with Power BI's prowess. It prepares you for the sought-after Microsoft Power BI certification in the UK. Learning Outcomes Comprehend the fundamental aspects of Power BI, from initiating a project to understanding the user interface. Develop proficiency in advanced data transformation techniques and data model creation. Integrate Python with Power BI and harness the benefits of both for enhanced data analytics. Master the art of 'Storytelling with Data' to deliver impactful presentations and reports. Understand and implement Row-Level Security and harness Power BI Cloud services efficiently. Why choose this Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7? 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 Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 for? Individuals keen on obtaining the Microsoft power bi certification UK. Analysts and data professionals aspiring to enhance their data visualisation skills. Business professionals wanting to leverage Power BI for insightful business decision-making. Tech enthusiasts aiming to amalgamate programming (Python) with data analytics. Those seeking to stay updated with the latest trends in Power BI and its evolving capabilities. Career path Data Analyst: Average Salary £30,000 - £40,000 Annually Business Intelligence Developer: Average Salary £35,000 - £45,000 Annually Power BI Developer: Average Salary £40,000 - £50,000 Annually Data Visualisation Specialist: Average Salary £32,000 - £42,000 Annually Business Intelligence Manager: Average Salary £45,000 - £55,000 Annually Data Strategy Consultant: Average Salary £50,000 - £60,000 Annually Prerequisites This Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 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 £135 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 Section 01: Introduction Welcome! 00:01:00 What is Power BI? 00:03:00 Download & Installing Power BI Desktop 00:04:00 Getting to know the interface 00:03:00 Mini Project: Transform Data 00:07:00 Mini Project: Visualize Data 00:05:00 Mini Project: Creating a Data Model 00:07:00 Course Outline: What will you learn in this course? 00:05:00 How to learn best with this course? 00:03:00 Section 02: Preparing our Project Creating our initial project file 00:04:00 Working with the attached project files 00:04:00 Section 03: Data Transformation - The Query Editor Exploring the Query Editor 00:06:00 Connecting to our data source 00:07:00 Editing rows 00:08:00 Changing data types 00:08:00 Replacing values 00:03:00 Close & Apply 00:03:00 Connecting to a csv file 00:03:00 Connecting to a web page 00:05:00 Extracting characters 00:06:00 Splitting & merging columns 00:09:00 Creating conditional columns 00:06:00 Creating columns from examples 00:09:00 Merging Queries 00:17:00 Pivoting & Unpivoting 00:06:00 Appending Queries 00:08:00 Practice & Solution: Population table 00:15:00 The Fact-Dimension-Model 00:09:00 Practice: Load the dimension table 00:04:00 Organizing our queries in groups 00:03:00 Entering data manually 00:05:00 Creating an index column 00:03:00 Workflow & more transformations 00:05:00 Module summary 00:05:00 Exercise 1 - Instruction 00:02:00 Exercise Solution 00:11:00 Section 04: Data Transformation - Advanced Advanced Editor - Best practices 00:09:00 Performance: References vs. Duplicating 00:10:00 Performance: Enable / Disable Load & Report Refresh 00:05:00 Group by 00:05:00 Mathematical Operations 00:05:00 Run R Script 00:15:00 Using Parameters to dynamically transform data 00:06:00 M formula language: Basics 00:07:00 M formula language: Values, Lists & Tables 00:14:00 M formula language: Functions 00:13:00 M formula language: More functions & steps 00:05:00 Exercise 2 - Instructions 00:01:00 Exercise 2 - solution 00:05:00 Section 05: Creating a Data Model Understanding the relationship 00:05:00 Create & edit relationships 00:06:00 One-to-many & one-to-one relationship 00:06:00 Many-to-many (m:n) relationship 00:08:00 Cross filter direction 00:06:00 Activate & deactivate relationships 00:06:00 Model summary 00:03:00 Exercise 3 Create Model 00:03:00 Exercise 3 Solution 00:02:00 Section 06: Data Visualization Our first visual 00:08:00 The format tab 00:12:00 Understanding tables 00:10:00 Conditional formatting 00:09:00 The Pie Chart 00:06:00 All about the filter visual 00:13:00 The filter pane for developers 00:09:00 Cross filtering & edit interactions 00:04:00 Syncing slicers across pages 00:07:00 Creating drill downs 00:08:00 Creating drill throughs 00:07:00 The tree map visual 00:07:00 The decomposition tree 00:05:00 Understanding the matrix visual 00:05:00 Editing pages 00:07:00 Buttons & Actions 00:09:00 Bookmarks to customize your report 00:10:00 Analytics and Forecasts with line charts 00:10:00 Working with custom visuals 00:07:00 Get data using R Script & R Script visual 00:08:00 Asking questions - Q&A visual 00:04:00 Wrap up - data visualization 00:08:00 Section 07: Power BI & Python Python in Power BI - Plan of attack 00:03:00 Setting up Python for Power BI 00:03:00 Transforming data using Python 00:11:00 Creating visualizations using Python 00:08:00 Violin plots, pair plots & ridge plots using Python 00:15:00 Machine learning (BayesTextAnalyzer) using Python 00:00:00 Performance & Troubleshooting 00:03:00 Section 08: Storytelling with Data Introduction 00:01:00 Show Empathy & Identify the Requirement 00:03:00 Finding the Most Suitable KPI's 00:02:00 Choose an Effective Visualization 00:04:00 Make Use of Natural Reading Pattern 00:03:00 Tell a Story Using Visual Cues 00:05:00 Avoid Chaos & Group Information 00:02:00 Warp Up - Storytelling with Data 00:02:00 Section 09: DAX - The Essentials Introduction 00:03:00 The project data 00:04:00 Measures vs. Calculated Columns 00:15:00 Automatically creating a date table in DAX 00:08:00 CALENDAR 00:05:00 Creating a complete date table with features 00:04:00 Creating key measure table 00:03:00 Aggregation functions 00:06:00 The different versions of COUNT 00:14:00 SUMX - Row based calculations 00:09:00 Section 10: DAX - The CALCULATE function CALCULATE - The basics 00:11:00 Changing the context with FILTER 00:07:00 ALL 00:08:00 ALL SELECTED 00:03:00 ALL EXCEPT 00:07:00 Section 11: Power BI Service - Power BI Cloud How to go on now? 00:03:00 Power BI Pro vs Premium & Signing up 00:04:00 Exploring the interface 00:04:00 Discovering your workspace 00:03:00 Connecting Power BI Desktop & Cloud 00:04:00 Understanding datasets & reports 00:03:00 Working on reports 00:04:00 Updating reports from Power BI Desktop 00:04:00 Creating and working with workspaces 00:07:00 Installing & using a data gateway 00:13:00 Get Quick Insights 00:03:00 Creating dashboards 00:04:00 Sharing our results through Apps 00:10:00 Power BI Mobile App 00:05:00 Creating the layout for the Mobile App 00:04:00 Wrap up Power BI Cloud 00:07:00 Section 12: Row-Level Security Introduction 00:03:00 Creating a Row-Level Security 00:05:00 Row-Level Security in the Cloud 00:04:00 Row-Level Security & Data Model 00:05:00 Dynamic Row-Level Security 00:07:00 Dynamic Many-to-Many RLS 00:04:00 Hierarchical Row-Level Security 00:13:00 Section 13: More data sources JSON & REST API 00:10:00 Setting up a local MySQL database 00:14:00 Connecting to a MySQL database in Power BI 00:05:00 Connecting to a SQL database (PostgreSQL) 00:05:00 Section 14: Next steps to improve & stay up to date Congratulations & next steps 00:06:00 The End 00:01:00 Resources Resources - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 00:00:00 Assignment Assignment - Advanced Diploma in Microsoft Power BI 2021 at QLS Level 7 04:00:00 Order your QLS Endorsed Certificate Order your QLS Endorsed Certificate 00:00:00

The Lean Six Sigma White Belt course introduces participants to the fundamental concepts of Lean, Six Sigma, and quality management. It covers the principles, tools, and methodologies used to improve processes and deliver better results. This course aims to provide a solid foundation in Lean Six Sigma principles and prepare participants to contribute effectively to improvement projects. Learning Outcomes: Understand the importance of quality and its impact on business performance. Learn the key principles and concepts of Lean and how to identify and eliminate various types of waste. Gain insights into Six Sigma's philosophy, DMAIC methodology, and its role in achieving Six Sigma quality. Discover the significance of the Voice of the Customer (VoC) and Critical to Quality (CTQ) parameters. Familiarize with essential quality tools such as Process Maps, Check Sheets, Histograms, Pareto Charts, Fishbone Diagrams, 5 Whys, and Run Charts. Develop an understanding of the roles and responsibilities in a Lean Six Sigma team and project. Identify improvement opportunities and contribute to process enhancements. Gain a comprehensive overview of the Lean Six Sigma approach to process improvement and customer satisfaction. Why buy this Lean Six Sigma White Belt course? 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 Lean Six Sigma White Belt course 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 Lean Six Sigma White Belt course 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 Lean Six Sigma White Belt course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Lean Six Sigma White Belt 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. Career path As this course comes with multiple courses included as bonus, you will be able to pursue multiple occupations. This Lean Six Sigma White Belt course is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Unit 01: Introduction Introduction 00:04:00 Unit 02: Quality Let's set the scene 00:03:00 What is quality? 00:05:00 Why a focus on quality is important 00:03:00 Unit 03: Lean What is Lean? 00:03:00 History of Lean 00:04:00 The 8 Wastes 00:01:00 Defects 00:02:00 Overproduction 00:02:00 Waiting 00:02:00 Non-utilised talent 00:03:00 Transport 00:02:00 Inventory 00:02:00 Motion 00:02:00 Extra-processing 00:02:00 VA vs. NVA 00:05:00 Creating value 00:04:00 Process 00:03:00 Unit 04: Six Sigma What is Six Sigma? 00:04:00 History of Six Sigma 00:02:00 Good quality vs. Six Sigma quality 00:04:00 DMAIC 00:05:00 Belts & roles 00:03:00 Six Sigma in action 00:06:00 Unit 05: The customer Voice of the customer 00:06:00 Critical to quality 00:04:00 Unit 06: The tools of quality The 7 tools of quality - a high level reminder 00:01:00 Process Map 00:06:00 Check sheet 00:04:00 Histogram 00:04:00 Pareto Chart 00:04:00 Fishbone Diagram 00:05:00 5 Whys 00:05:00 Run Chart 00:04:00 Unit 07: Close out Close out 00:06:00 Resources Resources - Lean Six Sigma White Belt course 00:00:00 Assignment Assignment - Lean Six Sigma White Belt course 00:00:00

Duration 3 Days 18 CPD hours This course is intended for This introductory-level course is for experienced DBAs who will be working with MongoDB. In order to gain the most from this course you should have: Prior practical experience in Database Administration Experience working with Linux and be comfortable working with command line Overview This skills-focused course is approximately 50% hands-on. Our engaging instructors and mentors are highly experienced practitioners who bring years of current 'on-the-job' experience into every classroom. Working in a hands-on learning environment, guided by our expert team, attendees will explore: The MongoDB Basic Architecture and Installation MongoDB administration User Management MongoDB security Indexes Backup & Recovery High Availability / Replication Diagnostics & Troubleshooting MongoDB is fast becoming the database of choice for big data applications, being one of the most popular and widely implemented NoSQL databases. Its scalability, robustness, and flexibility have made it extremely popular among business enterprises who use it to implement a variety of activities including social communications, analytics, content management, archiving and other activities. This has led to an increased demand for MongoDB administrators who have the skills to handle cross functional duties. Geared for experienced DBAs, MongoDB for DBAs is a three-day hands-on course that explores the concepts, architecture and pitfalls of managing a MongoDB installation. This course is targeted to the DBA who is familiar with the concepts and tasks of working with a Relational database and is not responsible for a NoSQL MongoDB database. You will learn the critical aspects of MongoDB and use it to solve data management challenges. You will learn to manage MongoDB effectively by gaining expertise in MongoDB administration tools, syntax, MongoDB installations, configurations, security, troubleshooting, backup, scaling and many other features. The focus of this course is on practical skills and applying the DBA existing database knowledge to a MongoDB installation. Introduction to MongoDB Basic Architecture and Installation Differentiate database categories Learn MongoDB design goals List MongoDB tools Describe JSON and BSON Understanding the basic concepts of a Database Database categories: What is NoSQL? Why NoSQL? Benefit over RDBMS Types of NoSQL Database, and NoSQL vs. SQL Comparison, ACID & Base Property CAP Theorem, implementing NoSQL and what is MongoDB? Graph Database Overview of MongoDB, Design Goals for MongoDB Server and Database, MongoDB tools Understanding the following: Collection, Documents and Key/Values, etc., Introduction to JSON and BSON documents Environment setup (live Handson) and using various MongoDB tools available in the MongoDB Package MongoDB Administration Take database backup and restore MongoDB© Export and import data from/ to a MongoDB© instance Check server status and DB status Monitor various resource utilization of a mongod instance Understand various optimization strategies Administration concepts in MongoDB Monitoring issues related to Database Monitoring at Server, Database, Collection level, and various Monitoring tools related to MongoDB Database Profiling, Locks, Memory Usage, No of connections, page fault etc., Backup and Recovery Methods for MongoDB Export and Import of Data to and from MongoDB Run time configuration of MongoDB Production notes/ best practices Data Managements in MongoDB (Capped Collections/ Expired data from TTL), TTL Collection Features GridFS Memory-Mapped Files Journaling Mechanics Storage Engines Power of 2-Sized Allocations No Padding Allocation Strategy Diagnosing Performance Issues Optimization Strategies for MongoDB Configure Tag Sets for Replica Set. Optimize Query Performance Monitoring Strategies for MongoDB . MongoDB Utilities MongoDB Commands MongoDB Management Service (MMS) Data Backup Strategies in MongoDB Copying Underlying Data Files Backup with MongoDump Fsync and Lock MongoDB Ops Manager Backup Software Security Strategies in MongoDB Authentication Implementation in MongoDB . Authentication in a Replica set Authentication on Sharded Clusters Authorization End-to-End Auditing for Compliance User Management Create a User Administrator. Add a User to a Database. Create/Assign User a Role. Verify/Modify a User Access/Privileges. Change a User?s Password MongoDB Security Knowing security concepts in MongoDB Understand how Authentication and Authorisation works Security Introduction Security Concepts Indexes Index Introduction, Index Concepts, Index Types Index Properties Index Creation and Indexing Reference Introduction to Aggregation Aggregation Approach to Aggregation sort Order Pipeline Operators and Indexes Text Indexes Aggregate Pipeline Stages Text Search MapReduce Index Creation Aggregation Operations Index Creation on Replica Set Remove, Modify, and Rebuild Indexes Listing Indexes Measure Index Use Control Index Use Index Use Reporting Geospatial Indexes MongoDB?s Geospatial Query Operators GeoWith Operator Backup & Recovery Import and Export MongoDB Data Restore and recovery of MongoDB(Including point in time Recovery) Restore a Replica Set from MongoDB Backups Recover Data after an Unexpected Shutdown Backup and Restore with Filesystem Snapshots Back Up and Restore with MongoDB Tools Backup and Restore Sharded Clusters High Availability (Replication ) Understand the concept of Replication in MongoDB© ? Create a production like Replica Set Introduction to Replication (High Availability), Concepts around Replication What is Replica Set and Master Slave Replication? Type of Replication in MongoDB How to setup a replicated cluster & managing replica sets etc., Master-Slave Replication Replica Set in MongoDB Automatic Failover Replica Set Members Write Concern Write Concern Levels Write Concern for a Replica Set Modify Default Write Concern Read Preference Read Preference Modes Blocking for Replication Tag Set Configure Tag Sets for Replica set. Replica Set Deployment Strategies . Replica Set Deployment Patterns Oplog File Replication State and Local Database, Replication Administration Diagnostics & Troubleshooting Troubleshoot slow queries Diagnose connectivity problems Understand diagnostic tools Learn common production issues Learn fixes and solutions. Additional course details: Nexus Humans Introduction to MongoDB for DBAs (TTDB4680) training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Introduction to MongoDB for DBAs (TTDB4680) course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.