1707 Courses

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

Embark on a transformative Python web development journey with this course and dive deep into creating a dynamic book rental system from scratch. Master Django's import-export capabilities, design elegant UI with Tailwind CSS, implement advanced features, and more. Elevate your skills and build real-world applications effortlessly!

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

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

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

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.

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.

Recognised Accreditation This course is accredited by continuing professional development (CPD). CPD UK is globally recognised by employers, professional organisations, and academic institutions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. What is CPD? Employers, professional organisations, and academic institutions all recognise CPD, therefore a credential from CPD Certification Service adds value to your professional goals and achievements. Benefits of CPD Improve your employment prospects Boost your job satisfaction Promotes career advancement Enhances your CV Provides you with a competitive edge in the job market Demonstrate your dedication Showcases your professional capabilities What is IPHM? The IPHM is an Accreditation Board that provides Training Providers with international and global accreditation. The Practitioners of Holistic Medicine (IPHM) accreditation is a guarantee of quality and skill. Benefits of IPHM It will help you establish a positive reputation in your chosen field You can join a network and community of successful therapists that are dedicated to providing excellent care to their client You can flaunt this accreditation in your CV It is a worldwide recognised accreditation What is Quality Licence Scheme? This course is endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. The Quality Licence Scheme is a brand of the Skills and Education Group, a leading national awarding organisation for providing high-quality vocational qualifications across a wide range of industries. Benefits of Quality License Scheme Certificate is valuable Provides a competitive edge in your career It will make your CV stand out Course Curriculum How to create tribes on social media Understanding Community Management 1.1 00:03:00 Why Should We Build Our Own Community 1.2 00:07:00 Create online tribes How to Create your Great Strategy 2.1 00:10:00 Using social media to build your community.2.2 00:07:00 Best Practices for Community Building 2.3 00:07:00 Growing your tribes on social media Creating content keeps your tribes alive.3.1 00:10:00 How to increase active participation in your communities.3.2 00:07:00 How to find brand ambassadors and influencers.3.3 00:07:00 How to promote your community.3.4 00:08:00 Measuring their success and performance How to scale your community.4.1mov 00:08:00 How to measure the growth of your fans.4.2 00:07:00 Demonstrate your influence in communities as a leader.4.3 00:05:00 Tools for managing audiences and communities Very good use of tools for community management.5.1mov 00:04:00 Welcome to the world of marketing where short video is king Modern digital marketing strategies1.1 00:05:00 The role of short-form video in social media marketing1.2 00:08:00 Techniques to create strong short-form video1.3 00:08:00 Digging deeper TikTok1.4 00:08:00 Digging deeper Instagram Reels1.5 00:05:00 Effective marketing strategies for TikTok videos Top Strategies for Creating Effective TikToks2.1 00:08:00 Understanding the TikTok algorithm2.2 00:08:00 Using hashtags effectively2.3 00:08:00 Capitalizing on trends and challenges2.4 00:08:00 Leveraging influencers2.5 00:08:00 Creating ads2.6 00:07:00 Using other TikTok tools and techniques2.7 00:06:00 Effective marketing strategies for instagram reels Connections between Reels and TikTok strategies3.1 00:07:00 Understanding the unique selling points of Instagram Reels.3.2 00:07:00 Implementing your social strategy for TikTok and Reels3.3 00:03:00 Creating a social media roadmap Set your goals.1.1 00:05:00 Define Your Target Audience.1.2 00:05:00 Choosing the most successful social networks Invest in smart channels.2.1 00:05:00 The most successful social networks.2.2 00:05:00 Social Networks for Message and Chat.2.3 00:05:00 Very important niche social networks.2.4 00:05:00 Great social media posting models How we can create great messages.3.1 00:05:00 Manage by setting a great calendar.3.2 00:05:00 Managing ads on social media.3.3 00:05:00 Effective sustainable communication with customers Achieve success with the masses by Building communities.4.1 00:05:00 Importance of customer service in social media.4.2 00:05:00 How can we turn social media into sales? Strengthen sales by directly supporting.5.1 00:07:00 Developing business by partnering with Influencers.5.2 00:04:00 Measuring social media in the most efficient way Connecting social networks with goals.6.1 00:05:00 Constantly making the best improvements to social media More than being active.7.1 00:05:00 Bring Great Apps to Life 7.2 00:05:00 Good understanding of content Content means too much.1.1 00:03:00 Content is more than all blogs and articles 1.2 00:02:00 Content is more than a cost understanding 1.3 00:02:00 Understand content marketing Understand Content Marketing 2.1 00:04:00 Where did This Content Marketing Come From 2.2 00:07:00 What is the Main Purpose of Content Marketing 2.3 00:04:00 Advanced goals of content marketing 2.4 00:04:00 Details for successful content marketing How to grow the niche content audience 3.1 00:04:00 Understanding a Different Brand Perspective 3.2 00:04:00 Presenting content experiments 3.3 00:05:00 Actively understanding content 3.4 00:03:00 Developing a successful content marketing strategy Forget what you know 4.1 00:04:00 Choosing the right audience 4.2 00:04:00 Our competitive analysis priority 4.3 00:04:00 Understand Your Right to Win 4.4 00:03:00 How we can create and source effective content Creating content on the customer journey 5.1 00:05:00 Choosing content marketing formats and channels 5.2 00:04:00 Source from anywhere 5.3 00:04:00 Making content very effective 5.4 00:04:00 Grow content operations Choosing a content calendar 6.1 00:04:00 Understand Content Processes 6.2 00:04:00 Clarifying roles and responsibilities 6.3 00:05:00 Content operations that come to life 6.4 00:03:00 Create advanced intelligence for content Selecting content KPIs 7.1 00:05:00 Monitoring content KPI data 7.2 00:05:00 Optimizing content performance regularly 7.3 00:06:00 Using content technology by constantly renewing it Finding content technology 8.1 00:03:00 Considering advanced content technology 8.2 00:04:00 Developing strategy for content technology 8.3 00:03:00 Seize content marketing opportunities Scaling Content Marketing 9.1 00:03:00 Succeeding as a Small Business 9.2 00:03:00 Succeed as a Large or Corporate Business 9.3 00:03:00 Instagram Profile Setup and Orientation Tour the Instagram user Interface 1.1 00:06:00 Convert to an Instagram Professional Account 1.2 00:04:00 Optimizing your Professional Instagram Profile 1.3 00:04:00 Optimizing Uploads of Photos and Videos 1.4 00:05:00 Modify Instagram Settings 1.5 00:04:00 Using Instagram on a Computer 1.6 00:02:00 Get Started with Marketing on Instagram Explore Models of Business Success 2.1 00:05:00 Built-in Tools for Marketing 2.2 00:04:00 Interact with the Community to Build Trust 2.3 00:05:00 Develop a Marketing Strategy for Instagram Content Ideas and Strategies for Instagram 3.1 00:05:00 Create a Unique Style on Instagram 3.2 00:04:00 Research your Competition on Instagram 3.3 00:04:00 Utilize Hashtags With a Posting Schedule 3.4 00:05:00 Implement Your Instagram Marketing Campaign Marketing with Instagram Stories 4.1 00:04:00 Marketing with Instagram Reels 4.2 00:04:00 Marketing With IGTV 4.3 00:05:00 Marketing With Live Video on Instagram 4.4 00:05:00 Using Instagram Shopping Posts 4.5 00:04:00 Content Marketing with Instagram Guides 4.6 00:04:00 Leveraging Instagram Paid ads 4.7 00:05:00 Optimize Your Marketing Strategy on Instagram Review Instagram Insights to Optimize Marketing Strategy 5.1 00:05:00 Run Polls and ask Questions on Instagram 5.2 00:05:00 Saving Instagram Stories as Story Highlights 5.3 00:04:00 Embedding Instagram Photos into Websites 5.4 00:02:00 Useful Instagram Enhancement Platforms 5.5 00:05:00 Additional Resources 5.6 00:02:00 Live Video Styles Live Educational Videos 1.1 00:05:00 Live Interview Videos 1.2 00:04:00 Live Demo Videos 1.3 00:04:00 Live Video Tours 1.4 00:04:00 Creating Live Video Content When to Create Live Video 2.1 00:04:00 Different live video platforms 2.2 00:05:00 Preparing for Your Live Video 2.3 00:03:00 Introductions and Conclusions in Your Live Video 2.4 00:05:00 Creating Engagement During Live Videos 2.5 00:03:00 Promoting Your Live Video Building your Live Video Audience 3.1 00:05:00 Sharing Your Live Video 3.2 00:05:00 Repurposing your Live Video 3.3 00:04:00 Launching Live Video Tools for Live Video 4.1 00:04:00 Visuals for Live Video 4.2 00:04:00 Start Creating Live Videos 4.3 00:01:00 Story Basics How Stories Connect 1.1 00:06:00 Story Types to Grow 1.2 00:07:00 Good Story Qualities 1.3 00:07:00 Building a Story Finding Your Story 2.1 00:05:00 Your Audience 2.2 00:04:00 Call to Action 2.3 00:06:00 Telling a Story Story Structure 3.1 00:06:00 Grabbing Attention 3.2 00:05:00 Deep Engagement 3.3 00:08:00 Growing Community 3.4 00:04:00 Interactive Stories 3.5 00:05:00 More More Material 4.1 00:03:00 Interview 4.2 00:03:00 Core Values 4.3 00:03:00 Connect Before Convincing 4.4 00:03:00 Crowdfunding 4.5 00:03:00 How to Start Your Story 4.6 00:03:00 Tell Stories in Person 4.7 00:03:00 Obtain Your Certificate Order Your Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Embarking on a journey into the digital realm? Dive deep into the vast ocean of web development with our course: 'Start Your Career as Web Developer - Complete Training'. This comprehensive programme unfolds the mysteries of HTML, revealing its foundational to advanced layers. As you delve further, JavaScript beckons, introducing you to its core elements, from basic operations to error handling. But that's not all. PHP emerges on the horizon, offering an exploration from rudimentary concepts to intricate object-oriented programming and real-world applications. Equip yourself with the essence of web development and illuminate the pathways of the digital world. Learning Outcomes Grasp the foundational to advanced principles of HTML. Understand and apply JavaScript concepts from introductory to advanced error handling techniques. Master PHP from its fundamental aspects to advanced object-oriented programming and database integration. Develop and implement web applications integrating PHP with MySQL. Implement client-side and server-side validations using JavaScript and PHP. Why choose this Start Your Career as Web Developer - Complete Training? 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 Start Your Career as Web Developer - Complete Training 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 Start Your Career as Web Developer - Complete Training for? Aspiring web developers seeking a structured pathway into the field. Current web designers looking to expand their skills into development. IT students aiming to bolster their academic understanding with applied knowledge. Entrepreneurs aiming to manage or understand their website's backend. Tech enthusiasts with a curiosity about the workings of web development. Career path Web Developer: £28,000 - £50,000 Front-End Developer: £30,000 - £50,000 Back-End Developer: £35,000 - £55,000 Full Stack Developer: £40,000 - £60,000 PHP Developer: £30,000 - £52,000 JavaScript Developer: £35,000 - £57,000 Prerequisites This Start Your Career as Web Developer - Complete Training does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Start Your Career as Web Developer - Complete Training was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tags 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:07:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statemen 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Coding Exercise 00:02:00 Solution for Coding Exercise 00:02:00 JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 PHP Introduction What is PHP 00:08:00 Installing XAMPP for PHP, MySQL and Apache 00:12:00 Installing Code Editor(Visual Studio Code) 00:07:00 Creating PHP Project on XAMPP 00:03:00 Hello World Program 00:06:00 PHP Basic Variables 00:16:00 Echo and Print 00:08:00 Data Types 00:11:00 Numbers 00:06:00 Boolean 00:04:00 Arrays 00:06:00 Multi-Dimensional Array 00:07:00 Sorting Arrays 00:04:00 Constants 00:05:00 PHP Strings Strings 00:04:00 String Formatting 00:05:00 String Methods 00:08:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Operators Arithmetic operators 00:03:00 Assignment operators 00:02:00 Comparison operators 00:05:00 Increment - decrement operators 00:03:00 Logical operators 00:06:00 Ternary operator 00:03:00 PHP Decision-making System If statement 00:05:00 If-else statement 00:02:00 If-else-if-else statement 00:03:00 Switch-case statement 00:05:00 PHP Control flow statements Flow Chart 00:06:00 While loop 00:09:00 Do-while loop 00:04:00 For loop 00:15:00 Foreach loop 00:04:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:01:00 PHP Functions Creating a Function 00:08:00 Function with Arguments 00:08:00 Default Argument 00:03:00 Function return values 00:06:00 Call-by-value 00:02:00 Call-by-reference 00:03:00 PHP Super globals $_POST Method 00:06:00 $_GET Method 00:02:00 PHP Advanced Form Handling 00:08:00 Date and Time 00:08:00 Include 00:06:00 Require 00:02:00 Sessions 00:08:00 File Reading 00:02:00 File Upload 00:06:00 PHP Object-oriented programming[OOPs] What is OOP 00:03:00 Class and Objects 00:11:00 Constructor 00:04:00 Destructor 00:03:00 Access Modifiers 00:10:00 Inheritance 00:12:00 Method overriding 00:06:00 Abstract Class 00:03:00 Interface 00:08:00 PHP - MySQL Application [CRUD] MySQL Basic PhpMyAdmin 00:04:00 Creating Database and Table 00:07:00 Database Connection 00:05:00 PHP Form Create records 00:16:00 PHP Form Reading records 00:11:00 PHP Form Update Data 00:15:00 PHP Form Delete record 00:04:00 PHP Real-world code forms Registration Form 00:04:00 MD5 Algorithm for Encrypting 00:03:00 Sha Algorithm 00:02:00 Login Form 00:12:00 PHP Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 Login Form Validation 00:05:00 Form Server-side all Data Validation 00:06:00 Form Server-side Validation 00:06:00 PHP Error handling Try-throw-catch 00:06:00 Try-throw-catch-finally 00:02:00