Learn how to use this powerful tool to import and clean data and create some amazing visuals. Course overview Duration: 2 days (13 hours) Power BI Desktop is a powerful tool for working with your data. It enables you to import multiple data sources and create effective visualisations and reports. This course is an introduction to Power BI to get you started on creating a powerful reporting capability. You should have a good working knowledge of Excel and managing data before attending. Objectives By the end of the course you will be able to: Import data from multiple data sources Edit and transform data before importing Create reports Create different visualisations Create data models Build data relationships Use the drill down features Create measures Use the Power BI Service Build dashboards Use the mobile app Content Essentials Importing Data Power BI Overview Data sources Importing data Transforming Your Data Editing your data Setting data types Removing columns/rows Choosing columns to keep Setting header rows Splitting columns Creating Reports Creating and saving reports Adding pages Renaming pages Interactivity Refreshing your data Adding Columns Columns from example Custom columns Conditional columns Append Queries Importing folders Setting up and using append queries Creating Chart Visualisations Adding chart elements Choosing chart types Setting properties Setting values, axis and legends Using tooltips Visual filters Setting page and report filters Creating Tables, Cards, Gauges and Maps Adding table elements Adding maps Working with cards Working with matrices KPIs and Gauges Conditional Formatting Setting rules Removing conditional formatting Working with Data Models Merge Queries Setting up and using merge queries Merging in columns of data Creating a Data Model The data model Multiple data tables Connecting tables Building relationships Relationship types Building visuals from multiple tables Unpivoting Data Working with summary data Unpivoting data Using Hierarchies Using built in hierarchies Drill down Drill up See next level Expand a hierarchy Create a new hierarchy Grouping Grouping text fields Grouping date and number fields Creating Measures DAX functions DAX syntax Creating a new measure Using quick measures Using the PowerBI Service Shared workspaces My workspace Dashboards Reports Datasets Drill down in dashboards Focus mode Using Q&A Refreshing data Using Quick Insights Power BI Mobile App Using the Power BI Mobile App
A Complete Guide for Effective LinkedIn Ads' is a comprehensive course that covers the fundamentals of setting up and managing successful LinkedIn Ads campaigns. Participants will learn to drive website traffic, utilize sponsored messages, generate leads, and effectively manage billing centers on the platform. Learning Outcomes: Understand the basics of LinkedIn Ads and their role in digital marketing. Learn how to set up LinkedIn Ads to drive targeted website traffic. Discover techniques for leveraging sponsored messages to engage with the audience. Acquire the skills to create and optimize LinkedIn Ads for lead generation. Gain proficiency in managing the billing center for efficient campaign budgeting and monitoring. Why buy this Excel VBA/Macros Foundations? 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 Excel VBA/Macros Foundations 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 Excel VBA/Macros Foundations 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 Excel VBA/Macros Foundations does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Excel VBA/Macros Foundations 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 Excel VBA/Macros Foundations is a great way for you to gain multiple skills from the comfort of your home. Course Curriculum Section 01: Introduction Recording Macros vs Writing VBA 00:04:00 Understanding Objects in Excel VBA 00:07:00 Understanding VBA Syntax and Parts of Speech 00:10:00 Activating the Developer tab 00:01:00 Recording a basic Macro 00:05:00 Absolute vs Relative Macro recording 00:04:00 Section 02: Exploring the Visual Basic Environment Introduction to the Visual Basic Environment 00:02:00 The Project Explorer 00:02:00 The Properties Window 00:02:00 The Code Window 00:04:00 Immediate, Locals and Watch Window 00:03:00 Dealing with Modules 00:03:00 Comments in Excel VBA 00:01:00 Section 03: The Range Object Introduction and Changing Cell Values 00:10:00 Adding a text to a cell 00:01:00 Dealing with Named Ranges 00:03:00 Value vs Text Property 00:04:00 Row and Column properties 00:02:00 The Select Method 00:02:00 The Count Property 00:04:00 The Address Property 00:09:00 The Formula Property 00:03:00 The Number Format Property 00:07:00 The Font Property 00:08:00 Section 04: Understanding the Cells Collection Object What is the cells object? 00:06:00 Using the Cells collection to affect cells positionally within a range 00:05:00 Affecting all cells within a sheet 00:02:00 Combining Range and cells objects 00:03:00 Section 05: Working with Sheets/Worksheets Selecting Sheets 00:06:00 Adding Sheets 00:11:00 Sheets vs Worksheets 00:04:00 Copying Sheets 00:05:00 Moving Sheets 00:01:00 Deleting Sheets 00:04:00 Section 06: Understanding Variables in Excel VBA Introduction to Variables 00:06:00 Variable Data Types 00:09:00 Declaring Variables 00:14:00 Object Variables 00:08:00 Calling a procedure from Another Procedure & Variable Scope 00:03:00 Public and Private Variables 00:07:00 Declaring Constants 00:04:00 Exercises-Variables 00:06:00 Section 07: Dealing with Workbooks Referring to Workbooks-Different ways 00:04:00 Closing Workbooks 00:03:00 Adding and Saving Workbooks Part 1 - Save method 00:04:00 Adding and Saving Workbooks Part 2 - Save as method 00:10:00 Opening Workbooks 00:06:00 Section 08: Must Know Excel VBA Logic Finding the Last row 00:09:00 Finding the Last Column 00:04:00 Finding the next row 00:04:00 The WITH Statement 00:04:00 Comparison operators in Excel VBA 00:01:00 IF Statements- Simple IF Statements 00:07:00 IF THEN ELSE Structure 00:03:00 IF THEN ELSEIF Structure 00:07:00 Nested IFs 00:04:00 OR - AND logical operators 00:07:00 NOT Logical operator 00:03:00 CASE Statements Part 1 - Single Case Statements 00:09:00 CASE Statements Part 2 - Nested Case Statements 00:06:00 Case Statements-Exercise 00:01:00 GOTO and Labels 00:03:00 Section 09: Looping in Excel VBA Loops-Introduction 00:01:00 FOR NEXT Loop 00:11:00 Exit For 00:09:00 Exercise - For Next loop 00:01:00 FOR EACH Loop - Intro 00:07:00 FOR EACH Loops - More examples 00:05:00 Do Loop - Introduction 00:04:00 Do Loop Example 00:01:00 Do Until 00:02:00 Do While 00:02:00 Do while vs Do until - Movies Example 00:04:00 Exit Do Statement 00:05:00 Exercise - Do Loop 00:01:00 Section 10: Interacting with Your Users The Messagebox - Introduction 00:03:00 Messagebox -Inputs 00:07:00 Messagebox - Capturing the User's input 00:05:00 Adding a new line to your VBA Strings 00:02:00 The Inputbox - introduction 00:04:00 Inputbox - Example1 - Capturing a user's name 00:05:00 Inputbox -Employee Database Example Part 1 00:05:00 Inputbox -Employee Database Example Part 2 00:04:00 Exercise - InputBox 00:02:00 Section 11: Error Handling in Excel VBA Error Handling - Introduction 00:09:00 Different Error types in action 00:04:00 On Error Goto statement 00:04:00 Resetting the error handling Status with On Error Goto 00:02:00 The Err Object 00:07:00 Setting a Breakpoint 00:02:00 Section 12: Triggering Code with Events! Worksheet Events -Selection change 00:08:00 Worksheet Events - Worksheet Activate event 00:03:00 Worksheet Events - Deactivate event 00:02:00 Worksheet Events - Before Delete Event 00:02:00 Worksheet Events - Before Double click event 00:08:00 Worksheet Events - Before Right Click event 00:03:00 Worksheet Events - Calculate event 00:03:00 Enabling and Disabling Events 00:03:00 Worksheet events - Worksheet change event 00:11:00 Workbook Events - Follow Hyperlink event 00:02:00 Worksheet events -Exercise 00:01:00 Workbook Events - Workbook open event 00:05:00 Workbook Events - Workbook Activate event 00:02:00 Workbook Events - Workbook Before save event 00:06:00 Workbook Events - Workbook Aftersave event 00:04:00 Workbook Events - Workbook Beforeclose event 00:09:00 Workbook Events - Workbook BeforePrint event 00:03:00 Workbook Events -Workbook De-activate events 00:02:00 Workbook Events - New Chart event 00:08:00 Workbook Events -New sheet event 00:03:00 Workbook Events - Sheet calculate event 00:03:00 Workbook Events - Sheet De-activate event 00:06:00 Workbook Events - Follow Hyperlink event 00:02:00 Workbook Events - Workbook Window Activate event 00:06:00 Workbook Events - Workbook Window De-Activate event 00:02:00 Workbook Events - Window Resize event 00:02:00 Exercise- Workbook Events 00:01:00 Resources Resources - Excel VBA/Macros Foundations 00:00:00 Assignment Assignment - Excel VBA/Macros Foundations 00:00:00
Join Heidi Steel, former teacher, child development and unschooling enthusiast for this webinar on the Power of Play. This webinar will explore the essential role of play in unschooling and how it contributes to children's learning, development, and well-being. Discover the benefits of play beyond the “Early Years.” Find strategies to keep play alive and tips for overcoming common challenges. Gain a deeper understanding of the important role of play in unschooling, Equip yourself with the knowledge and tools needed to create a rich, joyful and expansive learning environment for their children. A recording of this webinar is included and available for two weeks after the live event. These webinars are FREE for Unschooling Village Hub Members along with a back catalogue of Unschooling Webinars, regular live coaching sessions, and discounts on coaching and mentoring services. Sign up for just £20 per month. Yes! I want to join the LPL Unschooling Village Hub
Equality,Diversity : Equality, Diversity Do you always try to learn new things in order to increase your knowledge and skills? so, you can try out this course on Equality,Diversity : Equality, Diversity. In order to explain the Equality & Diversity component, this specialised Equality,Diversity : Equality,Diversity course has decorated in total 7 different modules. You will be familiar with the objectives of equality & diversity as well as relevant legal framework. This Equality,Diversity : Equality, Diversity training will make your understanding of discrimination and diversity promotion apparent. Establishing connections between values, attitudes, and beliefs is the goal of this equality & diversity course. You will gain a thorough understanding of stereotypes and prejudices by taking t his course on Equality,Diversity : Equality,Diversity. You will learn about institutional and individual discrimination in the final module of the equality & diversity course. If you want to see yourself in productive work, enrol in this Equality,Diversity : Equality & Diversity course right away! Learning Outcome of Equality,Diversity You will know a brief about Equality,Diversity : Equality,Diversity. Gain a brief knowledge about Equality,Diversity : Equality,Diversity Legislation. Equality,Diversity : Equality,Diversity course will give you an idea about Discrimination. You will learn about the connections between values, attitudes, and beliefs in the equality & diversity course. Equality,Diversity : Equality,Diversity course will clear your idea about Stereotypes and Prejudices.. Main Course: Equality and Diversity Free Courses are including with this Equality & Diversity: Equality & Diversity Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Care Certificate Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Health & Social care Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Youth Work Certificate Course Along with The Equality and Diversity: Equality & Diversity Course, We Offer a free Adult Nursing Course Special Offers of this Equality,Diversity Course This Equality,Diversity : Equality,Diversity Course includes a FREE PDF Certificate. Lifetime access to this Equality,Diversity : Equality,Diversity Course Instant access to this Equality,Diversity : Equality,Diversity Course Get FREE Tutor Support to this Equality & Diversity: Equality & Diversity Course Equality & Diversity: Equality & Diversity The Equality, Diversity: Equality, Diversity Course covers discrimination in all of its forms. You will learn about the four primary forms of prejudice in this course on equality and diversity, along with instances. In addition to the Equality Act of 2010, the nine protected features are included in this Equality and Diversity. We will be discussing case studies from the real world of harassment, bullying, and discrimination as our Equality & Diversity course comes to an end. Who is this course for? Equality,Diversity : Equality, Diversity Students, new graduates, and job seekers alike can enrol in this Equality,Diversity : Equality & Diversity course to advance their knowledge and abilities. Requirements Equality,Diversity : Equality, Diversity To enrol in this Equality & Diversity Course, students must fulfil the following requirements. To join in our Equality,Diversity : Equality & Diversity Course, you must have a strong command of the English language. To successfully complete our Equality,Diversity : Equality & Diversity Training Course, you must be self driven. To complete our Equality,Diversity : Equality & Diversity Training Course, you must have a basic understanding of computers. A minimum age limit of 15 is required to enrol in this Equality,Diversity : Equality & Diversity Training Course. Career path Equality,Diversity : Equality, Diversity Courses on Equality,Diversity : Equality & Diversity will enable you to pursue a variety of occupations, including those as an HR professional, a business owner, or in a related field.
From planning to executing the whole project, it is a highly stressful and challenging task. Not everyone can fill up this role; however, people who have the ability will find lucrative opportunities in their career journey. Train yourself through the Business and Project Management Diploma course if you want to be in the winning team. This course is designed to provide you with the fundamental skills to thrive in the field of business and project management. The Business and Project Management Diploma course will guide you through the whole process of business and project management. In this engaging course, you will learn about organisational structure design, business process management, business planning, business analysis and more. The easy-to-follow modules will help you attain the essential skills for strategic planning and branding. You will receive training on the fundamentals of project management and grasp the essential skills required for handling projects. This is not the end; this course will also introduce you to the ins and outs of the Six Sigma and Lean. This Business and Project Management Diploma course will be a blessing for your career. It will give you adequate skills and a valuable certificate to boost your career. So enrol now and get a step closer to a brilliant career. Learning Outcomes Learn how to design the organisational structure Familiarise yourself with the fundamentals of business process management Gain the essential knowledge for business planning and analysis Develop the key skills for strategic planning Understand the techniques of branding Build adequate expertise to manage projects Learn the essentials of Six Sigma and Lean process Enrich your knowledge of project communication and quality management Who is this Course for? Business and Project Management Diploma 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 Business and Project Management Diploma is fully compatible with any kind of device. Whether you are using Windows computers, 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. 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 the cost of £39 or in PDF format at the cost of £24. 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 After completing this Business and Project Management Diploma course, you will be able to build up accurate knowledge and skills to pursue a career in the following professions. Project Manager Project coordinator Project consultant Human Resource Manager Office Manager Business Administrator Business Consultant Assistant Manager Business Analyst Introduction to Business Management Designing Your Organizational Structure 00:30:00 Introduction to Operations Management 00:15:00 Understanding Financial Terms 00:30:00 Getting the Right People in Place 00:15:00 Getting Your Product Together 00:15:00 Building a Corporate Brand 00:30:00 Marketing Your Product 01:00:00 Selling Your Product 00:15:00 Planning for the Future 00:15:00 Goal Setting and Goal Getting 00:30:00 Succession Planning 101 00:15:00 Managing Your Money 00:15:00 Ethics 101 00:15:00 Building a Strong Customer Care Team 00:15:00 Training Employees for Success 00:15:00 Leadership Essentials 00:15:00 Business Process Management The Fundamentals of Business Process Management 00:30:00 Defining Business Process Management 00:30:00 The Business Process Life Cycle 00:15:00 Making the Change 00:15:00 The Vision Phase 00:15:00 The Design Phase 01:00:00 How Does It Look? 00:15:00 The Modeling Phase 00:30:00 Execution Phase 00:07:00 The Monitoring Phase 00:30:00 The Optimizing Phase 01:00:00 Business Planning and Analysis Business Planning Basics 01:00:00 Market Evaluation 01:00:00 Analyze Competition 01:00:00 Determine A Marketing Strategy 01:00:00 Decide What Extras You May Need Like Staff etc 00:30:00 The Dangers In Not Making A Business Plan 00:15:00 Strategic Planning Understanding Strategic Planning 00:15:00 Designing Our Vision 00:15:00 On a Mission 00:15:00 Performing a SWOT Analysis 00:15:00 Setting Goals 00:30:00 Assigning Roles, Responsibilities, and Accountabilities 00:30:00 The Full Picture 00:15:00 Gathering Support 00:15:00 Getting There 00:15:00 Lean Process Understanding Lean 00:30:00 The Toyota Production System 00:30:00 The Toyota Production System House 00:15:00 The Five Critical Improvement Concepts 00:15:00 Understanding Value with the Kano Model 00:15:00 Types of Waste 00:15:00 Creating a Lean Enterprise 00:15:00 The Plan, Do, Study, Act (PDSA) Cycle 00:15:00 Using the R-DMAIC-S Model 00:15:00 Lean Thinking Tools 00:15:00 Kaizen Events 00:00:00 Data Gathering and Mapping 00:30:00 A Plan to Take Home 00:15:00 Business Branding Defining Branding 00:15:00 What Are You All About? 00:30:00 Creating a Mission 00:15:00 Creating a Vision of the Future 00:15:00 Positioning Your Brand 00:15:00 Developing Your Style 00:15:00 Developing a Brand Name and Slogan 00:15:00 Creating a Visual Identity 00:30:00 Living Your Brand 00:05:00 Connecting with Customers 00:15:00 Launching Your Brand 00:15:00 Taking Your Brand's Pulse 00:15:00 Performing a SWOT Analysis 00:15:00 Measuring Brand Health with a Balanced Scorecard 00:15:00 Middleton's Brand Matrix 00:15:00 Interpreting Evaluation Results 00:15:00 Keeping the Brand Alive 00:15:00 Going Beyond the Brand 00:15:00 Branding Strategy Defining the Terms 00:30:00 Building Your Social Media Branding Strategy 00:15:00 Identifying Your Social Media Audience 00:15:00 The Key Social Media Platforms 00:30:00 Creating Brand-Focused Messages 00:30:00 Project Management Introduction 01:00:00 Creating a Project Management Methodology 01:00:00 Where Does The Buck Stop? 01:00:00 Can You Manage Yourself Out Of A Paper Bag? 00:30:00 Setting the Stage for a Successful Project 01:00:00 The Importance of Developing and Maintaining A Budget 01:00:00 Taking Action - Execution of the Plan 01:00:00 Your Personality and Project Management Style 01:00:00 The Cycle of Decision Making 01:00:00 Getting Your Project Back On Track 01:00:00 Keep It Moving 01:00:00 Problems and Solutions 01:00:00 Professional Project Management Module One - Getting Started 00:30:00 Module Two - Key Concepts (I) 01:00:00 Module Three - Key Concepts (II) 01:00:00 Module Five - Initiation (II) 01:00:00 Module Six - Planning (I) 01:00:00 Module Seven - Planning (II) 01:00:00 Module Eight - Planning Tools 01:00:00 Module Nine - Executing the Project 01:00:00 Module Ten - Maintaining and Controlling the Project 01:00:00 Module Eleven - Closing Out 01:00:00 Module Twelve - Wrapping Up 00:30:00 Planning the Project Define the Project Requirements 00:28:00 Create Your Project Plan 00:38:00 Execute the Project Plan 00:13:00 Monitor the Progress of the Project 00:20:00 Negotiate for Success 00:16:00 Evaluate the Process 00:19:00 Teams & Leadership 00:35:00 Teams 00:33:00 Conflict 00:34:00 Project Communication Project Communication 00:25:00 Didactic Communications 00:22:00 Basic Meeting Rules 00:21:00 Introducing Scope Management 00:07:00 Defining Scope and WBS 00:10:00 WBS and Control 00:07:00 Working with Time Management 00:21:00 Scheduling and the Critical Path Method 00:20:00 The Critical Chain Method 00:18:00 Introduction to Cost Management 00:15:00 Deprecation and Control Costs 00:14:00 Forecasting 00:24:00 Project Quality Management A Theoretical Perspective 00:18:00 Planning Quality 00:15:00 Finalizing Quality Management 00:12:00 What is Risk Management 00:13:00 Risk Analysis 00:08:00 Risk Responses 00:14:00 Project Performance 00:25:00 The Keys to Success 00:22:00 Project Performance Key Values 00:24:00 Developmental Methodologies 00:25:00 Methodology Types 00:26:00 Selecting a Methodology 00:22:00 Effective Budgets & Schedules 00:25:00 Resource Estimating 00:26:00 Estimating Techniques 00:26:00 Six Sigma & Lean Process Module One - Getting Started 00:30:00 Module Two - Understanding Lean 01:00:00 Module Three - Liker's Toyota Way 01:00:00 Module Four - The TPS House 01:00:00 Module Five - The Five Principles of Lean Business 01:00:00 Module Six - The First Improvement Concept (Value) 01:00:00 Module Seven - The Second Improvement Concept (Waste) 01:00:00 Module Eight - The Third Improvement Concept (Variation) 01:00:00 Module Nine - The Fourth Improvement Concept (Complexity) 01:00:00 Module Ten - The Fifth Improvement Concept (Continuous Improvement) 01:00:00 Module Eleven - The Improvement Toolkit 00:30:00 Module Twelve - Wrapping Up 01:30:00 Mock Exam Mock Exam- Business and Project Management Diploma 00:30:00 Final Exam Final Exam- Business and Project Management Diploma 00:30:00 Certificate and Transcript Order Your Certificates and Transcripts 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.
Office Admin and Receptionist Course Overview: The Office Admin and Receptionist Course, an essential part of the evolving industry, caters to the increasing demand for skilled professionals in office administration. In today's dynamic business environment, efficient office management and exceptional receptionist skills are crucial for organisational success. This course equips individuals with the necessary knowledge and skills to excel in administrative roles, addressing emerging opportunities and challenges in the field. No matter the type or the size of an organisation, every office needs a receptionist and someone to take care of the administrative tasks. Therefore, if you can train yourself in administrative and receptionist work, you will have a lot of job opportunities knocking at your door. The Office Admin and Receptionist Course will provide you with quality training. It will equip you with the essential skills and confidence to carry out the responsibilities. The Office Admin and Receptionist Course help you acquire the essential skills to become a proficient receptionist or an office admin. In this course, you will learn how to represent your company in the best possible manner. The easy-to-follow modules will help you in developing your telephone skills. Furthermore, you will become competent in record keeping and filing. In addition, this valuable course will teach you organisation skills, communication skills, time management skills, and more. Most importantly, this course will provide you with quality training in MS Excel. At the end of this Office Admin and Receptionist Course, you will receive a valuable certificate. This certificate will elevate your resume and increase your employability. So enrol now and get ready for a brilliant career. Learning Outcomes Understand the roles and responsibilities of a receptionist and an office administration Learn how to represent your boss and your company properly Develop the essential skills to handle the business telephones Enrich your knowledge of record keeping and filing system Build your organisation skills, communication skills and business writing skills Gain expertise on managing petty cash Become competent in MS Excel Who is the Office Admin and Receptionist Course for? This Office Admin and Receptionist Course is the perfect training ground for future office admins and receptionists. It will provide a clear understanding of their roles and responsibilities and also support in fulfilling these office administration responsibilities. Why Choose this Office Admin and Receptionist Course? Affordable, well-structured and high-quality e-learning study materials Engaging tutorial videos, materials from the industry-leading experts Opportunity to study in a user-friendly, advanced online learning platform Efficient exam systems for the assessment and instant result UK & internationally recognised accredited qualification Access the course content on mobile, tablet, or desktop from anywhere, anytime Excellent career advancement opportunities 24/7 student support via email. Entry Requirement This course is available to all learners of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. A good understanding of the English language, numeracy, and ICT are required to attend this course. Assessment At the end of the course, you will be required to sit for 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. Certificate of Achievement After completing this course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates & Transcripts can be obtained either in Hardcopy at £14.99 or in PDF format at £11.99. Career Path The Office Admin and Receptionist Course is a useful qualification to possess, especially to people with careers in: Administrative Assistant Secretary Administrator Office Manager Receptionist Office Administrator Office Admin and Receptionist Course - Updated Version Introduction to Reception and Receptionist 00:29:00 Business Telephone Skills 00:19:00 Representing Your Boss and Company 00:34:00 Mail Services and Shipping 00:25:00 Travel Arrangements 00:24:00 Organising Meeting and Conferences 00:25:00 Time Management 00:35:00 Record Keeping and Filing Systems 00:28:00 Business Writing Skills 00:40:00 Organisational Skills 00:25:00 Communication Skills 00:25:00 Customer Service 00:16:00 Effective Planning and Scheduling 00:39:00 Invoicing/Petty Cash 00:27:00 Business Environment 00:16:00 Advanced MS Excel How to Get the most of the course 00:01:00 Text formulas in Excel 00:08:00 Text Formulas Exercise 00:01:00 Text Formulas Exercise (answers) 00:01:00 Mathematical Formulas In Excel 00:04:00 Mathematical Formulas Exercise 00:01:00 Mathematical Formulas Exercise (answers) 00:01:00 Date and Time Formulas In Excel 00:06:00 Date and Time Formulas Exercise 00:01:00 Date and Time Exercise Formulas (answers) 00:01:00 Logic Formulas In Excel 00:12:00 Logic Formula Exercise 00:01:00 Logic Formula Exercise (answers) 00:01:00 Financial Formula In Excel 00:06:00 Financial Formula Exercise 00:01:00 Financial Formula Exercise (answers) 00:02:00 Informational Formula In Excel 00:04:00 Informational Formula Exercise 00:01:00 Informational Formula Exercise (answers) 00:01:00 Getting Traffic To Your Site 01:00:00 Menu Example with Excel Vlookup 00:08:00 Wildcard Search with Excel Vlookup 00:09:00 Looking to the Left with Excel Vlookup 00:17:00 2-Way Lookup 00:14:00 Comparing Lists with Excel Vlookup 00:03:00 Microsoft Excel Vlookup Tips and Tricks 00:14:00 Power Query Intro and Excel version 00:03:00 Excel Power Query - Introduction 00:03:00 Enabling M in Power Query 00:02:00 Transform Data - Trim in Excel Power Query 00:05:00 Transform Data - Format Dates and Values in Excel Power Query 00:02:00 Simple Expressions 00:08:00 Simple Expressions - Nested Expressions 00:03:00 Transform Data - Parsing URLs in Excel Power Query 00:05:00 Variables 00:08:00 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 Office Admin and Receptionist Course - Old Version Admin Support Module One - Getting Started 00:30:00 Module Two - Getting Organized (I) 01:00:00 Module Three - Getting Organized (II) 01:00:00 Module Four - Managing Time 01:00:00 Module Five - Getting It All Done On Time 01:00:00 Module Six - Special Tasks 01:00:00 Module Seven - Verbal Communication Skills 01:00:00 Module Eight - Non-Verbal Communication Skills 01:00:00 Module Nine - Empowering Yourself 01:00:00 Module Ten - The Team of Two 01:00:00 Module Eleven - Taking Care of Yourself 01:00:00 Module Twelve - Wrapping Up 00:30:00 Administrative Management Module One - Getting Started 00:30:00 Module Two - Why Your Office Needs Administrative Procedures 01:00:00 Module Three - Gathering the Right Tools 01:00:00 Module Four - Identifying Procedures to Include 01:00:00 Module Five - Top Five Procedures to Record 01:00:00 Module Six - What to Include in Your Binder (I) 01:00:00 Module Seven - What to Include in Your Binder (II) 01:00:00 Module Eight - Organizing Your Binder 01:00:00 Module Nine - What Not to Include in the Procedure Guide 01:00:00 Module Ten - Share Office Procedure Guide 01:00:00 Module Eleven - Successfully Executing the Guide 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Module One - Getting Started 00:30:00 Module Two - Remove the Clutter 01:00:00 Module Three - Prioritize 01:00:00 Module Four - Scheduling Your Time 01:00:00 Module Five - To Do Lists 01:00:00 Module Six - Paper and Paperless Storage 01:00:00 Module Seven - Organization in Your Work Area 01:00:00 Module Eight - Tools to Fight Procrastination 01:00:00 Module Nine - Organizing Your Inbox 01:00:00 Module Ten - Avoid the Causes of Disorganization 01:00:00 Module Eleven - Discipline is the Key to Stay Organized 01:00:00 Module Twelve - Wrapping Up 00:30:00 Organisational Skills Course for Administrator- Activities 00:00:00 Receptionist Receptionist 00:30:00 Importance of Receptionist 00:15:00 Different Types of Receptionist & Roles 01:00:00 Communication Skills for Receptionist 01:00:00 Telephone Skills 01:00:00 Listening Skills 01:00:00 Taking Messages 00:30:00 Presenting & Appearance 00:30:00 Reservation Procedure 00:15:00 Confidentiality Checklist 00:15:00 Being Organized as Receptionist 00:15:00 Becoming a Successful Receptionist 00:15:00 Customer Relations & Dealings Module One - Getting Started 00:30:00 Module Two - The Right Attitude Starts with You 01:00:00 Module Three - Stress Management (Internal Stressors) 01:00:00 Module Four - Stress Management (External Stressors) 00:30:00 Module Five - Transactional Analysis 01:00:00 Module Six - Why are Some Customers Difficult 01:00:00 Module Seven - Dealing with the Customer Over the Phone 01:00:00 Module Eight - Dealing with the Customer In Person 01:00:00 Module Nine - Sensitivity in Dealing with Customers 01:00:00 Module Ten - Scenarios of Dealing with a Difficult Customer 01:00:00 Module Eleven - Following up With a Customer Once You Have Addressed Their Issue 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Skills Module One - Getting Started 00:30:00 Module Two - Core Skills Required 01:00:00 Module Three - Self-Management (I) 01:00:00 Module Four - Self-Management (II) 01:00:00 Module Five - Time Management (I) 01:00:00 Module Six - Time Management (II) 01:00:00 Module Seven - Organizing and Planning (I) 01:00:00 Module Eight - Organizing and Planning (II) 01:00:00 Module Nine - Communication (I) 01:00:00 Module Ten - Communication (II) 01:00:00 Module Eleven - Additional Challenges 01:00:00 Module Twelve - Wrapping Up 00:30:00 Professional Telephone Receptionist Course - Activities 00:00:00 Recommended Reading Recommended Reading : Office Admin and Receptionist Course 00:00:00 Refer A Friend Refer A Friend 00:00:00 Mock Exam Mock Exam- Office Admin and Receptionist Course 00:30:00 Final Exam Final Exam- Office Admin and Receptionist Course 00:30:00 Order Your Certificates and Transcripts Order Your Certificates and Transcripts 00:00:00
This Design Patterns course is a unique offering that focuses on modern C++ features and behavioral design patterns. The course content is extensive and carefully curated, with a deep dive into each pattern to ensure a thorough understanding of its implementation. Gain a comprehensive understanding of the pattern's intricacies.
This course is designed for beginners and covers a wide range of topics including syntax, data structures, modules, and advanced techniques such as testing and memory allocations. It also includes real-life problem-solving exercises to ensure hands-on learning. Gain efficient programming skills and be proficient in Rust with this course.
Care Certificate: Care Certificate Online Training Introducing the Care Certificate: Your Pathway to Excellence in the Caring Profession Are you passionate about making a positive impact on the lives of others? Do you aspire to build a rewarding career in the caring profession? Look no further! The Care Certificate, our comprehensive Care Certificate course, is here to equip you with the knowledge and skills you need to excel in the world of care. The Care Certificate is a collection of agreed-upon standards that specify the knowledge, abilities, and attitudes that are required of various work categories in the health and social care sectors. The Care Certificate course is made up of the 15 minimum standards that should be covered if you are 'new to care' and should be part of a comprehensive induction course. The standards of Care Certificate are: Understand your role Your personal development Duty of care Equality and diversity Work in a person centred way Communication Privacy and dignity Fluids and nutrition Awareness of mental health, dementia and learning disabilities Safeguarding adults Safeguarding children Basic life support Health and safety Handling information Infection prevention and control Benefits of taking this Care Certificate course Industry-Recognized Accreditation: The Care Certificate is a nationally recognized qualification that serves as a testament to your commitment to providing high-quality care. Developed by industry experts and this Care Certificate holds immense value and is widely accepted across the care sector. Comprehensive and Engaging Content: Our Care Certificate: Care Certificate course curriculum is thoughtfully designed to cover all essential aspects of care provision. From person-centred care and safeguarding principles to infection control and communication techniques. With his Care Certificate you will gain a holistic understanding of the fundamental principles that underpin excellent care practice. Flexibility and Convenience: We understand the demands of a busy schedule. That's why we offer the Care Certificate: Care Certificate online, allowing you to learn at your own pace and from the comfort of your own home. Whether you are a full-time professional or a student, our flexible course structure ensures that you can fit your learning around your existing commitments. Experienced and Supportive Instructors: Our Care Certificate: Care Certificate course instructors are seasoned professionals with extensive experience in the care industry. They bring real-world insights and knowledge to the table, ensuring that you receive valuable guidance and mentorship throughout your learning journey. Enhanced Career Prospects: The Care Certificate is highly regarded by employers in the care sector. By obtaining this Care Certificate, you will significantly enhance your employability and open doors to a wide range of care settings, including hospitals, residential care homes, domiciliary care agencies, and community care centres. This Care Certificate: Care Certificate course serves as a strong foundation for further professional development and career progression. Ongoing Support and Resources: Our commitment to your success extends beyond the completion of the Care Certificate: Care Certificate course. With this Care Certificate course you will have access to a wealth of additional resources, including updated care guidelines, industry insights, and professional networking opportunities. We believe in empowering you with the tools you need to thrive in your care career. Don't miss out on this exceptional opportunity to elevate your care skills and take your career to new heights. Enrol in the Care Certificate: Care Certificate today and embark on a transformative journey of professional growth and personal fulfilment. Invest in your future. Invest in excellence. Enrol in the Care Certificate: Care Certificate now! Courses you will Get with Care Certificate: Care Certificate Course Course 01: Care Certificate Course 02: Social Worker Course 03: Level 6 Diploma in Health and Social Care Management Course 04: Level 2 Certificate in Preparing to Work in Adult Social Care [ Note: Free PDF certificate as soon as completing the Care Certificate: Care Certificate course] Care Certificate: Care Certificate Online Training Course Curriculum of Care Certificate: Module 01: Understand Your Role Experiences, Attitudes And Beliefs Values, Aims And Objectives Rights And Responsibilities At Work Confidentiality Working conditions Agreed ways of Working Reporting Errors Whistleblowing Working In Partnership Effective Partnership Working Advice And Support Module 02: Developing A Personal Development Plan Supervision and appraisal Agreeing your objectives Developing your knowledge, skills and understanding Learning and development Receiving feedback The Care Certificate Continuing your learning Module 03: Duty of care Supporting Independence Comments And Complaints Incidents, Errors And Near Misses Legislation of Care Certificate Managing Conflict And Difficult Situations Module 04: Equality and diversity Ways of working that reduce the likelihood of discrimination Valuing diversity The Equality Act 2010 and protected characteristics Other legislation of Care Certificate The code of conduct Reflecting to discover discrimination Information, advice and support Module 05: Work in a person-centred way Person-centred values in practice Working in a way that promotes person-centred values Promoting dignity The important of finding out the history, preferences, wishes and needs of the individual The changing needs of the individual Supporting individuals to plan for their future wellbeing and fulfilment, including end-of-life care Minimising environmental factors that may cause discomfort or distress Being aware of actions that may be causing discomfort or distress to individuals Supporting individuals to minimise pain or discomfort Supporting individuals to maintain their identity and self-esteem Supporting the individual using person-centred values Module 06: Communication Types of communication in Care Certificate Communication with other workers and individuals Communication and language needs, wishes and preferences Communicating by touch or physical contact Some specialist methods of communication Barriers to effective communication Reducing barriers to communication Checking to understand Additional information and support Confidentiality Limits to confidentiality Module 07: Privacy and dignity Privacy of Information Privacy and dignity in care and support Making choices Care Certificate Risk assessment Supporting active participation Selfcare Module 08: Fluids and nutrition The Importance of Good Nutrition And Hydration in Maintaining Health And Wellbeing Signs And Symptoms of Poor Nutrition And Hydration Supporting individuals to have access to fluids, food and nutrition in accordance with their care plan Module 09: Awareness of mental health, dementia and learning disability Mental health conditions Depression Anxiety Psychosis Dementia Learning disabilities Mistaking conditions Care and support Promoting positive attitudes The social model of disability, positive attitudes and person-centred practice Adaptations Reporting concerns The importance of early detection and diagnosis Adapting care and support Legal frameworks, policies and guidelines Mental capacity Making an assessment of capacity Module 10: Safeguarding adults Your Responsibilities Types of abuse and neglect - signs and indicators Protecting adults from abuse and neglect Six key principles underpin all adult safeguarding work Safeguarding adults reviews (SARs) Sources of advice and information Promoting dignity and rights The importance of individualised person-centred care Multi-agency Working Managing Risk in Care Certificate Complaints Spotting signs of abuse or neglect Reporting and responding to abuse and neglect Whistleblowing Legislation Information sharing Confidentiality Module 11: Safeguarding children What is Child Abuse? The impact of a parent’s/carer’s physical and mental health or domestic violence on a child's Wellbeing Children’s Rights Actions to Take When Abuse is Suspected or Alleged Internet and Online Social Networking Risks Legislation and Safeguarding Module 12: Basic life support Basic Life Support (BLS) Further training beyond the Care Certificate Cardiopulmonary resuscitation (CPR) Obstructed airway (adult) Obstructed airway (infant and child) Confidentiality Record keeping Refresher training Module 13: Health and safety Health and safety policies and procedures agreed with the employer Who is responsible for health and safety in your workplace? Health and safety tasks that require special training Accidents and sudden illness Medication and healthcare activities and tasks Hazardous substances in your workplace Fire safety Signs and indicators of stress in yourself and others Module 14: Handling information Legislation The Freedom of Information Act 2000 Handling information in health and social care Care plans Reporting concerns Module 15: Infection prevention and control The Chain of infection Breaking the Chain Your Health and Hygiene ‘5 moments’ for Hand Hygiene Hand Washing Personal Protective Equipment (PPE) Safe Handling of Waste Soiled Linen Assessment Method of Care Certificate: Care Certificate After completing Care Certificate: Care Certificate Course, you will get quizzes to assess your learning. You will do the later modules upon getting 60% marks on the quiz test. Apart from this, you do not need to sit for any other assessments. Certification of Care Certificate: Care Certificate After completing the Care Certificate: Care Certificate course, you can instantly download your certificate for FREE. The hard copy of the certification will also be delivered to your doorstep via post, which will cost £13.99. Who is this course for? Care Certificate: Care Certificate Online Training This Care Certificate: Care Certificate course is ideal for anyone looking to secure a role in the social care sector. Requirements Care Certificate: Care Certificate Online Training To enrol in this Care Certificate: Care Certificate Course, students must fulfil the following requirements: Good Command over English language is mandatory to enrol in our Care Certificate: Care Certificate Course. Be energetic and self-motivated to complete our Care Certificate: Care Certificate Course. Basic computer Skill is required to complete our Care Certificate: Care Certificate Course. If you want to enrol in our Care Certificate: Care Certificate Course, you must be at least 15 years old. Career path Care Certificate: Care Certificate Online Training This Care Certificate: Care Certificate course will prepare you for a variety of job paths, including the following: Child Support Worker Medical Assistant Care Worker Social Worker