141 Courses

Duration 5 Days 30 CPD hours This course is intended for Storage and virtual infrastructure consultants, solution architects, and administrators who are responsible for production support and administration of VMware vSAN [v7] Overview By the end of the course, you should be able to meet the following objectives: Describe vSAN concepts Detail the underlying vSAN architecture and components Explain the key features and use cases for vSAN Identify requirements and planning considerations for vSAN clusters Describe the different vSAN deployment options Explain how to configure vSAN fault domains Detail how to define and create a VM Storage policy Discuss the impact of vSAN storage policy changes Describe vSAN storage space efficiency Explain how vSAN encryption works Identify requirements to configure vSAN iSCSI target Detail HCI Mesh technology and architecture Detail vSAN file service architecture and configuration Explain the use cases of vSAN Direct Describe how to setup stretched and two-node vSAN clusters Explain the importance vSAN node hardware compatibility Describe the use of VMware vSphere Lifecycle Manager™ to automate driver and firmware installations Detail vSAN resilience and data availability Discuss the vSAN cluster backup methodology Describe the vSAN maintenance mode and data evacuation options Define the steps to shut down a vSAN cluster for maintenance Explain how to use proactive tests to check the integrity of a vSAN cluster Use VMware Skyline Health™ for monitoring vSAN health Apply a structured approach to troubleshoot vSAN cluster configuration and operational problems During this five-day, intensive course, you gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You learn about managing and operating vSAN. This course focuses on building the required skills for common Day-2 vSAN administrator tasks such as vSAN node management, cluster maintenance, security operations, and advanced vSAN cluster operations.You also focus on learning the tools and skills necessary to troubleshoot vSAN 7 implementations and gain practical experience with vSAN troubleshooting concepts through the completion of instructor-led activities and hands-on lab exercises.This course is a combination of the following courses: VMware vSAN: Plan and Deploy, VMware vSAN: Management and Operations, and VMware vSAN: Troubleshooting. COURSE INTRODUCTION * Introductions and course logistics * Course objectives INTRODUCTION TO VSAN * Describe vSAN architecture * Describe the vSAN software components: CLOM, DOM, LSOM, CMMDS, and RDT * Identify vSAN objects and components * Describe the advantages of object-based storage * Describe the difference between All-Flash and Hybrid vSAN architecture * Explain the key features and use cases for vSAN * Discuss the vSAN integration and compatibility with other VMware technologies PLANNING A VSAN CLUSTER * Identify requirements and planning considerations for vSAN clusters * Apply vSAN cluster planning and deployment best practices * Determine and plan for storage consumption by data growth and failure tolerance * Design vSAN hosts for operational needs * Identify vSAN networking features and requirements * Describe ways of controlling traffic in a vSAN environment * Recognize best practices for vSAN network configurations DEPLOYING A VSAN CLUSTER * Recognize the importance of hardware compatibility * Ensure the compatibility of driver and firmware versioning * Use tools to automate driver validation and installation * Apply host hardware settings for optimum performance * Use vSphere Life Cycle Manager to perform upgrades * Deploy and configure a vSAN Cluster using Cluster Quickstart wizard * Manually configure a vSAN Cluster using vSphere Client * Explain and configure vSAN fault domains * Using vSphere HA with vSAN * Understand vSAN Cluster maintenance capabilities * Describe the difference between implicit and explicit fault domains * Create explicit fault domains VSAN STORAGE POLICIES * Describe a vSAN Object * Describe how objects are split into components * Explain the purpose of witness components * Explain how vSAN stores large objects * View object and component placement on the vSAN Datastore * Explain how storage policies work with vSAN * Define and create a virtual machine storage policy * Apply and modify virtual machine storage policies * Change virtual machine storage policies dynamically * Identify virtual machine storage policy compliance status * VSAN RESILIENCE AND DATA AVAILABILITY * Describe and configure the Object Repair Timer advanced option * Plan disk replacement in a vSAN cluster * Plan maintenance tasks to avoid vSAN object failures * Recognize the importance of managing snapshot utilization in a vSAN cluster CONFIGURING VSAN STORAGE SPACE EFFICIENCY * Discuss Deduplication and Compression techniques * Understand Deduplication and Compression overhead * Discuss Compression only mode * Configure Erasure Coding * Configure swap object Thin Provisioning * Discuss Reclaiming Storage Space with SCSI UNMAP * Configure TRIM/UNMAP VSAN SECURITY OPERATIONS * Identify differences between VM encryption and vSAN encryption * Perform ongoing operations to maintain data security * Describe the workflow of Data-in Transit encryption * Identify the steps involved in replacing Key Management Server INTRODUCTION TO ADVANCED VSAN CONFIGURATIONS * Identify requirements to configure vSAN iSCSI target * Detail HCI Mesh technology and architecture * Detail vSAN File Service architecture and configuration * Explain the use cases of vSAN Direct VSAN CLUSTER MAINTENANCE * Perform typical vSAN maintenance operations * Describe vSAN maintenance modes and data evacuation options * Assess the impact on cluster objects of entering maintenance mode * Determine the specific data actions required after exiting maintenance mode * Define the steps to shut down and reboot hosts and vSAN clusters * Use best practices for boot devices * Replace vSAN Nodes VSAN STRETCHED AND TWO NODE CLUSTERS * Describe the architecture and uses case for stretched clusters * Detail the deployment and replacement of a vSAN Witness node * Describe the architecture and uses case for two-node clusters * Explain the benefits of vSphere HA and vSphere Site Recovery Manager in a vSAN stretched cluster * Explain storage policies for vSAN stretched cluster * VSAN CLUSTER MONITORING * Describe how the Customer Experience Improvement Program (CEIP) enables VMware to improve products and services * Use vSphere Skyline Health for monitoring vSAN Cluster Health * Manage alerts, alarms, and notifications related to vSAN in vSphere Client * Create and configure custom alarms to trigger vSAN health issues * Use IO Insight metrics for monitoring vSAN performance * Analyse vsantop performance metrics * Use vSAN Proactive Test to detect and diagnose cluster issues VSAN TROUBLESHOOTING METHODOLOGY * Use a structured approach to solve configuration and operational problems * Apply troubleshooting methodology to logically diagnose faults and optimize troubleshooting efficiency VSAN TROUBLESHOOTING TOOLS * Use Skyline Health for vSAN to identify and correct issues in VMware vSAN * Discuss the ways to run various command-line tools * Discuss the ways to access VMware vSphere ESXi Shell * Use commands to view, configure, and manage your VMware vSphere environment * Discuss the esxcli vsan namespace commands * Use log files to help vSAN troubleshooting ADDITIONAL COURSE DETAILS: Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Fast Track (v7) 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 VMware vSAN: Fast Track (v7) 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.

OVERVIEW By enroling in Mastering SQL Programming, you can kickstart your vibrant career and strengthen your profound knowledge. You can learn everything you need to know about the topic. The Mastering SQL Programming course includes all of the most recent information to keep you abreast of the employment market and prepare you for your future. The curriculum for this excellent Mastering SQL Programming course includes modules at all skill levels, from beginner to expert. You will have the productivity necessary to succeed in your organisation once you have completed our Mastering SQL Programming Program. So enrol in our Mastering SQL Programming course right away if you're keen to envision yourself in a rewarding career. DESCRIPTION Enroling in this Mastering SQL Programming course can improve your Mastering SQL Programming perspective, regardless of your skill levels in the Mastering SQL Programming topics you want to master. If you're already a Mastering SQL Programming expert, this peek under the hood will provide you with suggestions for accelerating your learning, including advanced Mastering SQL Programming insights that will help you make the most of your time. This Mastering SQL Programming course will act as a guide for you if you've ever wished to excel at Mastering SQL Programming. WHY CHOOSE US? * After successfully completing the Mastering SQL Programming Course, you will receive a FREE PDF Certificate as evidence of your newly acquired abilities. * Lifetime access to the whole collection of Mastering SQL Programming learning materials. * Online test with immediate results * Enroling in the course has no additional cost. * You can study and complete the Mastering SQL Programming course at your own pace. * Study for the Mastering SQL Programming course using any internet-connected device, such as a computer, tablet, or mobile device. WHO IS THIS COURSE FOR? This Mastering SQL Programming course is a great place to start if you're looking to start a new career in Mastering SQL Programming field. This training is for anyone interested in gaining in-demand Mastering SQL Programming proficiency to help launch a career or their business aptitude.  REQUIREMENTS The Mastering SQL Programming course requires no prior degree or experience. All you require is English proficiency, numeracy literacy and a gadget with stable internet connection. Learn and train for a prosperous career in the thriving and fast-growing industry of Mastering SQL Programming, without any fuss. CAREER PATH This Mastering SQL Programming training will assist you develop your Mastering SQL Programming ability, establish a personal brand, and present a portfolio of relevant talents. It will help you articulate a  Mastering SQL Programming professional story and personalise your path to a new career. Furthermore, developing this Mastering SQL Programming skillset can lead to numerous opportunities for high-paying jobs in a variety of fields. COURSE CURRICULUM Unit 01: Introduction Introduction 00:01:00 Tools Used in This Course 00:01:00 Unit 02: Setting up Course Tools Download PostgreSQL 00:02:00 Install PostgreSQL 00:03:00 Download SQLectron 00:02:00 Install SQLectron 00:01:00 Connect to PostgreSQL - Credentials 00:01:00 Connect to PostgreSQL Using SQLectron 00:02:00 Import Course Data Using SQLectron 00:02:00 FOR WINDOWS 32-BIT USERS: Download, Install, Configure & Import Data 00:08:00 Unit 03: Browsing & Filtering Data Check Imported Data 00:06:00 What is a Database? 00:01:00 SQL Data Types 00:02:00 Finally Some Fun! Extracting Data Based on Requirements 00:01:00 Filtering Data using WHERE Keyword 00:08:00 Filter Data by Range Using BETWEEN 00:03:00 Filter Data by Set of Values Using IN 00:03:00 Filter Data by Date 00:05:00 More Filtering by Date 00:03:00 Another Query Filtering by Date 00:01:00 Filter Data by Strings 00:04:00 More Filtering by Strings 00:05:00 More Filtering by Strings 2 00:10:00 More Filtering by Strings 3 00:02:00 How to Ignore Caps when Filtering by String 00:04:00 Unit 04: Filter Data with AND, OR, NOT Operators AND Operator 00:10:00 OR Operator 00:12:00 NOT Operator 00:09:00 AND, OR & NOT Operators: Which Has the Highest Priority? 00:06:00 Unit 05: Math Operations Basic Math Operations 00:06:00 Modulo Operator 00:04:00 Calculate The Net Salary for Employees 00:06:00 Filter Data with Math Equations 00:03:00 Unit 06: String Concatenation Concatenate Strings with '||' Operator 00:06:00 Concatenate Strings with Numbers 00:02:00 Unit 07: Tidy Up Your Results: Sorting, Alias Names, Limit Records Give Your Report Fields A Cool Name 00:04:00 A Report for Payroll 00:07:00 Order Records by Column 00:06:00 Order Records by Multiple Columns 00:12:00 How Alias Names Cannot Be Used with WHERE 00:02:00 LIMIT Record Count Fetched by Your Query 00:08:00 Unit 08: NULL, DISTINCT & CASE Statements Fetch A Field's Unique Values Using DISTINCT 00:03:00 Using DISTINCT Keyword with Multiple Columns 00:06:00 What is a NULL Value Anyway? 00:05:00 Build More Sophisticated Queries with CASE Statements 00:10:00 Your Knowledge So Far Under A Great Test 00:09:00 Unit 09: Functions in SQL: Multiple-Row Functions Let Me Introduce You to Functions 00:04:00 SUM Function 00:04:00 AVG (Average) Function 00:04:00 COUNT Function 00:07:00 MIN & MAX Functions 00:04:00 How To Count Your Field's Unique Values 00:04:00 GROUP BY Clause: Use Functions with Dimensions 00:06:00 GROUP BY More Than One Dimension 00:05:00 Now For Some Tough Workout 00:09:00 Filter By Aggregate Functions with HAVING Clause 00:08:00 Unit 10: Functions in SQL: Single-Row Functions Character Functions - UPPER, LOWER & INITCAP 00:08:00 Character Functions - CONCAT & LENGTH 00:10:00 Character Functions - LPAD & RPAD 00:13:00 Character Functions - TRIM 00:04:00 Character Functions - REPLACE 00:09:00 Character Functions - SUBSTR 00:10:00 Number Functions - MOD & ROUND 00:11:00 Number Functions - TRUNC 00:07:00 Unit 11: Nested Queries Selectception: A Select Query inside another Select Query! 00:06:00 Unit 12: Casting & Data Conversion Auto Data Conversion in SQL 00:11:00 Cast Date to Character 00:10:00 Cast Number to Character 00:09:00 Cast Timestamp to Character 00:07:00 Cast Character to Number 00:08:00 Cast Character to Date & Timestamp 00:09:00 Unit 13: Combination Relationships UNION 00:03:00 UNION ALL 00:02:00 Important Note about Combining Queries 00:02:00 INTERSECT 00:01:00 EXCEPT 00:01:00 Unit 14: Joins in SQL Employees & Departments Tables Revised 00:03:00 Entity Relationship Diagram (ERD) 00:09:00 Cartesian Join 00:09:00 Table Aliases with Joins 00:07:00 Why I Don't Recommend Cartesian Joins 00:08:00 Inner Join 00:06:00 In-Depth Look into Join Types in SQL 00:03:00 Outer Join - Right, Left & Full 00:08:00 Unit 15: Data Manipulation (DML) INSERT a New Record to a Table 00:09:00 Insert Without Specifying Column Names 00:09:00 UPDATE a Record's Field Values 00:07:00 CAUTION! How an UPDATE Query Can Go Wrong 00:04:00 Update a Record Using Single-Row Functions 00:04:00 A Good Exercise: Extract Employee's Email Address 00:02:00 Solution: Extract Employee's Email Address 00:13:00 DELETE a Table's Record 00:06:00 Insert Records with Nested Select Queries 00:06:00 Unit 16: SQL Data Definition Language (DDL) SQL Data Types Revised 00:13:00 Bookstore Data Set: Let's Move It to Database 00:04:00 Create Your First Table! 00:08:00 Insert Data to Your New Table 00:08:00 Change Column Data Type 00:07:00 Rename Column 00:04:00 Add a New Column to Table 00:04:00 Constraints in SQL 00:01:00 Primary Keys 00:14:00 NOT NULL Constraint 00:05:00 UNIQUE Constraint 00:04:00 DEFAULT Constraint 00:04:00 Foreign Keys 00:08:00 Use Foreign Keys with Joins - Books & Publishers 00:06:00 Foreign Keys - Properties 00:06:00 Drop Column 00:01:00 DROP Table 00:01:00 Create a New Table with Select Statement 00:05:00 A Trick to Create an Empty Table with Select Statement 00:03:00 Insert New Records Using Select Statement 00:06:00 Views 00:03:00 Schemas 00:02:00 Create & Use Schemas 00:04:00 Assignment Assignment -Mastering SQL Programming 00:00:00

Automate your Excel workflow, accelerate your productivity, and master the fundamentals of programming with VBA!

HIGHLIGHTS OF THE COURSE * Course Type: Online Learning * Duration: 5 Hours * Tutor Support: Tutor support is included * Customer Support: 24/7 customer support is available * Quality Training: The course is designed by an industry expert * Recognised Credential: Recognised and Valuable Certification * Completion Certificate: Free Course Completion Certificate Included * Instalment: 3 Installment Plan on checkout -------------------------------------------------------------------------------- WHAT YOU WILL LEARN FROM THIS COURSE? * Gain comprehensive knowledge about Autodesk Revit * Understand the core competencies and principles of Autodesk Revit * Explore the various areas of Autodesk Revit * Know how to apply the skills you acquired from this course in a real-life context * Become a confident and expert Autodesk Revit architecture -------------------------------------------------------------------------------- AUTODESK REVIT COURSE Master the skills you need to propel your career forward in Autodesk Revit. This course will equip you with the essential knowledge and skillset that will make you a confident Autodesk Revit architecture and take your career to the next level. This comprehensive Autodesk Revit course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this Autodesk Revit course will help you get one step closer to your professional aspirations and develop your skills for a rewarding career. This comprehensive course will teach you the theory of effective Autodesk Revit practice and equip you with the essential skills, confidence and competence to assist you in the Autodesk Revit industry. You'll gain a solid understanding of the core competencies required to drive a successful career in Autodesk Revit. This course is designed by industry experts, so you'll gain knowledge and skills based on the latest expertise and best practices. This extensive course is designed for Autodesk Revit architecture or for people who are aspiring to specialise in Autodesk Revit. Enrol in this Autodesk Revit course today and take the next step towards your personal and professional goals. Earn industry-recognised credentials to demonstrate your new skills and add extra value to your CV that will help you outshine other candidates. WHO IS THIS COURSE FOR? This comprehensive Autodesk Revit course is ideal for anyone wishing to boost their career profile or advance their career in this field by gaining a thorough understanding of the subject. Anyone willing to gain extensive knowledge on this Autodesk Revit can also take this course. Whether you are a complete beginner or an aspiring professional, this course will provide you with the necessary skills and professional competence, and open your doors to a wide number of professions within your chosen sector. ENTRY REQUIREMENTS This Autodesk Revit course has no academic prerequisites and is open to students from all academic disciplines. You will, however, need a laptop, desktop, tablet, or smartphone, as well as a reliable internet connection. ASSESSMENT This Autodesk Revit course assesses learners through multiple-choice questions (MCQs). Upon successful completion of the modules, learners must answer MCQs to complete the assessment procedure. Through the MCQs, it is measured how much a learner could grasp from each section. In the assessment pass mark is 60%. ADVANCE YOUR CAREER This Autodesk Revit course will provide you with a fresh opportunity to enter the relevant job market and choose your desired career path. Additionally, you will be able to advance your career, increase your level of competition in your chosen field, and highlight these skills on your resume. 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 Supplementary Resources Supplementary Resources - Autodesk Revit 00:00:00 [SKIP IF NOT NECESSARY] Download,Install and Troubleshooting Introduction To Download And Install Revit 00:01:00 System Requirements 00:02:00 Certified Hardware 00:01:00 Subscriptions 00:01:00 Revit VS Revit LT 00:02:00 Installing Revit On An Apple MAC 00:01:00 Getting Started 00:01:00 Creating An Account 00:01:00 Installing The Software 00:03:00 Configuring The Library And Template File Paths 00:05:00 Introduction to the Beginners Course Introduction To The Beginners Course 00:02:00 Touring the Interface 1.1 Start Screen [NOTES ATTACHED] 00:02:00 1.2 File Tab, Quick Access Toolbar & Info Centre 00:04:00 1.3 Tabs, Ribbons & Panels 00:01:00 1.4 Properties Palette & Project Browser 00:03:00 1.5 Status Bar, View Controls, Selection Toggles & Context Menu 00:08:00 1.6 Navigating The Drawing Area 00:03:00 1.7 Contextual Tab 00:02:00 1.8 Terminology 00:03:00 Introduction to Walls 2.1 Introduction To Walls & The Wall Panel 00:11:00 2.2 Wall Option Bar 00:11:00 2.3 Wall Properties Palette 00:03:00 Basic Tools 3.1 Align, Offset, Mirror - Pick Axis, Mirror - Draw Axis 00:04:00 3.2 Move, Copy, Rotate, Trim/Extend to corner, T/E single element, T/E multiple 00:07:00 3.3 Split element, Pin, Array, Scale, Delete 00:07:00 Datum Elements 4.1 Defining The Buildings Levels & Creating Reference Levels2 00:13:00 4.2 Creating The Grid System 00:06:00 Major Components 5.1 Placing Structural Columns On The Grid 00:04:00 5.2 Placing Architectural Columns On The Grid 00:03:00 5.3 Placing The External Walls 00:04:00 5.4 Placing The Internal Wall 00:06:00 5.5 Using The Equality Constraints 00:07:00 5.6 Placing The Ground Floor Slab 00:06:00 5.7 Placing A Boundary Footpath 00:03:00 Minor Components 6.1 Placing Doors From The Type Selector 00:05:00 6.2 Loading Doors From The Library 00:02:00 6.3 Creating A New Door Type 00:05:00 6.4 Adding A Wall Opening 00:07:00 6.5 Editing The Walls Profile To Create An Opening 00:02:00 6.6 Adding A Structural Opening To The Wall 00:03:00 6.7 Placing Windows 00:04:00 Creating the next level 7.1 Increasing Top Constraint 00:04:00 7.2 Placing The First Floor Slab 00:05:00 7.3 Adding A Shaft Opening To The Slab 00:03:00 7.4 Selection Filter And Aligned To Selected Levels 00:07:00 Vertical Circulation 8.1 Stair By Component 00:06:00 8.2 Stair By Sketch 00:04:00 8.3 Creating Project Stair 00:07:00 8.4 Placing A Railing 00:02:00 8.5 Creating A Railing 00:07:00 Roof Component 9.1 Introduction To Roof By Footprint 00:12:00 9.2 Pitched Roof By Footprint 00:05:00 9.3 Flat Roof By Footprint 00:04:00 9.4 Roof By Extrusion 00:03:00 Curtain Walls 10.1 Introduction To Curtain Walls 00:06:00 10.2 Constructing A Curtain Wall 00:04:00 10.3 Create 'Curtain Wall - Entrance' 00:10:00 10.4 Create 'Curtain Wall - Rear' 00:05:00 10.5 Create 'Curtain Wall - Front' 00:03:00 Reflected Ceiling Plan 11.1 Introduction To Reflected Ceilings 00:06:00 11.2 Adjusting The Ceiling Position 00:01:00 11.3 Creating The First Floor Ceiling Plan 00:02:00 11.4 Adding Components To The Ceiling 00:07:00 11.5 Example Of Rendered Ceiling Components 00:02:00 Creating a 2D Detail (Callout) 12.1 Setting Up A Callout 00:04:00 12.2 Masking And Filled Regions 00:02:00 12.3 Detail Components And Repeating Detail Components 00:07:00 12.4 Placing Insulation 00:01:00 12.5 Using The Detail Line And Creating A Line Style 00:03:00 12.6 Adding Text with Leaders 00:04:00 12.7 Adding Break Lines 00:01:00 Dimensions 13.1 Introduction To Dimensions By Individual References 00:04:00 13.2 Dimension By Entire Wall 00:02:00 13.3 Witness Lines 00:01:00 13.4 Modifying A Dimension 00:01:00 Tags, Schedules & Legends 14.1 Introduction To Tags 00:04:00 14.2 Adding Information To The Tags 00:05:00 14.3 Placing Window Tags 00:05:00 14.4 Placing Wall Tags 00:02:00 14.5 Applying Tags To First Floor 00:02:00 14.6 Creating A Room And Placing Room Tags 00:09:00 14.7 Creating A Room Legend 00:03:00 14.8 Creating A Room Schedule 00:05:00 14.9 Creating A Door Schedule 00:11:00 14.10 Creating A Window Schedule 00:03:00 14.11 Creating A Door & Window Legend 00:10:00 Visualisations 15.1 Introduction To Shadows And Sun settings 00:03:00 15.2 Creating A One-Day Solar Study 00:03:00 15.3 Introduction To Rendering And Rendering First Image 00:13:00 15.4 Rendering Second Image 00:07:00 15.5 Introduction To Walkthroughs 00:06:00 15.6 Modifying A Walkthrough 00:02:00 15.7 Creating A Walkthrough Over Two Levels 00:06:00 Create Sheets & Print 16.1 Opening A Sheet And Overview Of The Title-Block 00:02:00 16.2 Setting Up A Sheet part 1 00:09:00 16.3 Setting Up A Sheet Part 2 00:09:00 16.5 Loading An A2 Title-Block 00:03:00 16.6 Duplicating Views 00:03:00 16.7 Page Setup & Printing 00:03:00 Assessment Assessment - Autodesk Revit 00:10:00 Certificate of Achievement Certificate of Achievement 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

[ Updated 2024 ] Join the 5,000+ satisfied students who have completed our Car Mechanic online course and achieved success. Your vehicle is not just a mode of transportation, but also a significant investment in your life. So imagine the horror of watching its value plummet! But fear not, for there is a solution to avoid this nightmare. Regular maintenance of your car is essential, and Car Mechanic & Repair Training with Car Restoration/ Detailing (Car Maintenance) course will equip you with the skills to do it yourself and save you a fortune! Every vehicle develops flaws in its engine or other components as time passes. If these issues are not addressed promptly, they can escalate into major problems, causing significant headaches and expenses. By taking good care of your car, you will prolong the life of your engine and enjoy a smooth driving experience. Moreover, a well-maintained vehicle is less likely to suffer from issues like breakdowns, brake failures, or engine disruptions, ensuring you reach your destination safely. But that's not all! By acquiring basic knowledge of car mechanics, you open up an exciting opportunity to start a career as a mechanic. Even if you're not interested in making a profession out of it, having a solid understanding of car maintenance is an invaluable asset. Car Mechanic & Repair Training with Car Restoration/ Detailing (Car Maintenance) course has covered you, providing you with all the essential knowledge you need to maintain your car in easy-to-understand and comprehensive modules. Additional Resources in this premium Training * Resources 1: Car Restoration * Resources 2: Automotive Engineering: Onboard Diagnostics * Resources 3: Diploma in Supercharger Automobile Engineering * Resources 4: Engine Lubrication Systems Online Course What you'll discover: * Understanding vehicle upkeep and safety. * How to perform basic auto maintenance. * Wheels, brakes, tyres, and engine are all included. * Vehicles with warning lights. * How to identify many different parts of your car. * What should the components of your vehicle look like? * Understand when and why your vehicle requires service. * Understand the proper tools for the job and how to use them. This Car Mechanic course teaches fundamental topics and essential skills needed for car maintenance, including automotive systems like cooling, fuel, and electrical, as well as checking tire pressure, changing a tire, and inspecting the brake system. So, without further ado, add this Car Mechanic Training to your basket and explore under the hood of your car. Key Benefits * CPD UK certification * Engaging earning materials * The course contains voiceover and visual elements for your comfort * Get 24/7 access to all content for all time. * Each of our students gets full tutor support on weekdays (Monday to Friday) Why CPD UK Certification? * Achieving CPD UK certificates can help you stand out in your profession and enhance your employability prospects. * By participating in CPD activities, you can stay up-to-date with the latest industry trends and innovations, and improve your knowledge and skills. * CPD UK certificates demonstrate your commitment to continuing professional development and can lead to increased recognition and credibility within your field. Transform your career with this course! Perfect your skills and stand out in the employment market with our comprehensive training program. Impress potential employers and add valuable expertise to your resume. Module Attributes: The bundle course has been meticulously designed to deliver maximum information in minimum time. This approach enables learners to easily comprehend the core concepts and confidently apply them to diverse real-life scenarios. Course Curriculum: ** Car Mechanic Training ** * Module 01: Introduction to Safety and Maintenance * Module 02: General Maintenance for Car Mechanics * Module 03: Vehicle Warning Lights * Module 04: Tyres and Wheels * Module 05: The engine * Module 06: The Cooling System * Module 07: The Fuel System * Module 08: The Electrical System * Module 09: The drivetrain * Module 10: The Braking System ** Car Restoration ** * Module 01: Car Restoration plan * Module 02: Restoring the Car's Interior * Module 03: Restoring the Car's Exterior * Module 04: Restoring the Engine * Module 05: Reassemble & Test Drive ** Automotive Engineering: Onboard Diagnostics ** * Unit 01: Introduction * Introduction * Brief history & Basic working of OBD * Unit 02: Various Aspects Of Onboard Diagnostics * Onboard diagnostic apps * Exhaust gas-Diagnostics * APPS on Onboard diagnostics * Unit 03: Various Systems * Engine -Diagnostics * Diagnostics-spark plug * Diagnostics- Fuel injection * Diagnosis -Lubrication ** Diploma in Supercharger Automobile Engineering ** * Introduction * Advantages & Main Components Of Superchargers * Types Of Superchargers * Brand Names & Models ** Engine Lubrication Systems Online Course ** * Introduction * Functions & Components Of Lubrication System * Basic Working Of The Lubrication System * Properties, Additives & Designations Of Lube Oils * Lab Analysis & Diagnostics Of The Lubrication Oil Exam and Assessment * Mock Exam * Final Exam (MCQ Based, 60% Marks to Pass) Recommended Additional Materials * Car Repair Manuals for Car Mechanics * Car Mechanic Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). CPD 50 CPD hours / points Accredited by The CPD Certification Service WHO IS THIS COURSE FOR? This course is ideal for- * Car Restoration * Mechanical Field Technician * Electrical, and Trim * MET Technician * Motorcycle Mechanic * Driver CPC * Automotive Engineering * Engineering Management * DIY REQUIREMENTS No prior qualifications are necessary to join our course, meaning it's open to anyone with a passion for learning. So, whether you're a seasoned professional or a complete newbie, come and join us on this exciting journey. CAREER PATH Learn industry-specific skills with our courses and explore potential job opportunities, such as: * Car Mechanic * Mechanical Engineer * Electrician * HGV Training * HGV Mechanic * Automotive Technician * Mechanic Apprentice * Automotive Service Technician * Automotive Engineer * Parts Specialist * Service Advisor Average salary of these jobs- £30,000 to £70,000 per annum. CERTIFICATES CERTIFICATE OF COMPLETION Digital certificate - £9 CERTIFICATE OF COMPLETION Hard copy certificate - £15 CPD Accredited Certification * Hardcopy Certificate (within the UK): £15 * Hardcopy Certificate (international): £15 + £10 (postal charge) = £25

Master 75+ Excel tips and techniques and become a certified POWER USER, with unique hands-on demos and real-world projects to help you wrangle, analyze, and visualize your data in Excel.

Embark on this course in web development with HTML, CSS, JS, and React for a comprehensive training program designed to empower beginners and experienced designers alike with the essential skills needed to create captivating and dynamic websites. Explore the power of React.js, HTML5, CSS3, JavaScript, and build scalable components with React.

Become a MET technician and repair vehicles of all kinds. Learn how to identify and fix damage to mechanical, electrical, and trim components.

Expand your VBA knowledge further and learn some of the more advanced coding features. -------------------------------------------------------------------------------- COURSE OVERVIEW Duration: 2 days (13 hours) This course is aimed at experienced VBA users or those who have attended our Part 1 [https://www.underscore-group.com/training/training-courses/technical-and-office-programs/vba-in-excel/] course and have started to use the language. Part 2 expands on the huge array of commands and elements of the data model that can be used and looks at building more complex VBA models OBJECTIVES  By the end of the course you will be able to: * Use comparison operators and system functions * Use Arrays * Work with ranges * Work with the worksheets and workbooks collections and objects * Use application objects * Use the FileSystemObject * Create function procedures * Import and save text files * Connect to other applications CONTENT COMPARISON OPERATORS   * Using Comparison operators and functions * The LIKE function * Wildcards * Using SELECT Case SYSTEM FUNCTIONS   * The VAL function * Case functions * Trim functions * Text functions * Date functions EXCEL WORKSHEET FUNCTIONS   * Using Excel functions in VBA ARRAYS   * Creating arrays * Using arrays * Ubound and Lbound * Single and multi dimensional arrays * Static vs dynamic arrays WORKING WITH RANGES   * Creating range objects * Passing data between range objects and arrays * Using Transpose THE EXCEL OBJECT MODEL   * The object browser WORKING WITH COLLECTIONS   * Collections * Creating object variables * Setting object variables * The For Each . . . Next Loo SHEET COLLECTIONS   * The worksheets collection * The worksheet object * The sheets collection * Using object * Grouping worksheets * Using Typename THE WORKBOOK COLLECTION   * The workbooks collection * Setting workbook variables APPLICATION OBJECTS   * Excel default information * Display/alerts * Screen updating * Status bar * On Time * Using Wait SYSTEMS DIALOG BOXES   * Showing dialog boxes * Using dialog boxes WORKING WITH FILES   * Searching for files and folders * The DIR function * The FileSystemObject FUNCTION PROCEDURES   * Creating functions * Adding arguments * Calling functions WORKING WITH TEXT FILES   * Searching for files and folders * The DIR function * The FileSystemObject * Using the FILE and FOLDER collections SHARING DATA WITH OTHER APPLICATIONS   * Early vs Late Binding * Setting references to other applications * Creating application variables * Setting application variables