141 Courses

This course takes you through the concepts of Alteryx from scratch. With the help of interesting case studies, you will learn how to use Alteryx for joining datasets, performing union operations, finding and replacing text, sorting and filtering data, and a lot more.

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 Introduction Course Overview! 00:04:00 Installation And Getting Started The Final Milestone! 00:01:00 Installing and setting up PostgreSQL 00:09:00 Case Study : Demo Case Study Part 1 00:04:00 Case Study Part 2 00:06:00 Fundamental SQL statements CREATE 00:11:00 Exercise 1: Create DB and Table 00:01:00 INSERT 00:09:00 Import data from File 00:05:00 Exercise 2: Inserting and Importing 00:01:00 SELECT statement 00:03:00 SELECT DISTINCT 00:06:00 WHERE 00:04:00 Logical Operators 00:06:00 Exercise 3: SELECT & WHERE 00:01:00 UPDATE 00:05:00 DELETE 00:04:00 ALTER 00:17:00 Exercise 4: Updating Table 00:01:00 Restore And Back-Up Restore and Back-up 00:07:00 Exercise 5: Restore and Back-up 00:01:00 Selection Commands: Filtering IN 00:04:00 BETWEEN 00:05:00 LIKE 00:08:00 Exercise 6: In, Like & Between 00:01:00 Selection Commands: Ordering Side Lecture: Commenting in SQL 00:01:00 ORDER BY 00:07:00 LIMIT 00:03:00 Exercise 7: Sorting 00:01:00 Alias AS 00:03:00 Aggregate Commands COUNT 00:05:00 SUM 00:03:00 AVERAGE 00:03:00 MIN & MAX 00:04:00 Exercise 8: Aggregate functions 00:01:00 Group By Commands GROUP BY 00:12:00 HAVING 00:05:00 Exercise 9: Group By 00:01:00 Conditional Statement CASE WHEN 00:05:00 Joins Introduction to Joins 00:02:00 Inner Join 00:08:00 Left Join 00:07:00 Right Join 00:06:00 Full Outer Join 00:05:00 Cross Join 00:04:00 Except 00:03:00 Union 00:03:00 Exercise 10: Joins 00:01:00 Subqueries Subqueries 00:14:00 Exercise 11: Subqueries 00:01:00 Views And Indexes VIEWS 00:07:00 INDEX 00:06:00 Exercise 12: Views 00:01:00 String Functions LENGTH 00:03:00 Upper Lower 00:02:00 REPLACE 00:04:00 TRIM, LTRIM, RTRIM 00:07:00 CONCATENATION 00:03:00 SUBSTRING 00:06:00 LIST AGGREGATION 00:05:00 Exercise 13: String Functions 00:02:00 Mathematical Functions CEIL & FLOOR 00:03:00 RANDOM 00:05:00 SETSEED 00:04:00 ROUND 00:02:00 POWER 00:02:00 Exercise 14: Mathematical Functions 00:01:00 Date-Time Functions CURRENT DATE & TIME 00:04:00 AGE 00:03:00 EXTRACT 00:08:00 Exercise 15: Date-time functions 00:01:00 Pattern (String) Matching PATTERN MATCHING BASICS 00:07:00 ADVANCE PATTERN MATCHING (REGULAR EXPRESSIONS) 00:15:00 Exercise 16: Pattern Matching 00:01:00 Data Type Conversion Functions Converting Numbers/ Date to String 00:11:00 Converting String to Numbers/ Date 00:06:00 User Access Control Functions User Access Control 00:13:00 Bonus Section: Nail That Interview! Tablespace 00:05:00 PRIMARY KEY & FOREIGN KEY 00:05:00 ACID compliance 00:06:00 Truncate 00:04:00 Performance Tuning Tips TIP 1 (EXPLAIN) 00:04:00 TIP 2 00:01:00 TIP 3 00:02:00 TIP 4 (VACCUM) 00:01:00 TIP 5 00:02:00 TIP 6 (STRING FUNCTIONS) 00:02:00 TIP 7 (JOINS) 00:02:00 TIP 8 (SCHEMAS) 00:04:00 Bonus Section : Database Basics What is SQL 00:02:00 Tables and DBMS 00:03:00 Types of SQL commands 00:04:00 PostgreSQL 00:02:00 The Final Milestone! 00:01:00 Supplementary Resources Supplementary Resources - SQL Masterclass 00:00:00 Assessment Assessment - SQL Masterclass 00:10:00 Certificate of Achievement Certificate of Achievement 00:00:00 Get Your Insurance Now Get Your Insurance Now 00:00:00 Feedback Feedback 00:00:00

Duration 4 Days 24 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 8.0. 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 Explain the importance vSAN node hardware compatibility 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 Detail vSAN resilience and data availability Describe vSAN storage space efficiency Explain how vSAN encryption works Detail VMware HCI Mesh™ technology and architecture Detail vSAN File Service architecture and configuration Describe how to setup a stretched and a two-node vSAN cluster Describe 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 Use VMware Skyline Health to investigate and help determine failure conditions Discuss vSAN troubleshooting best practices Describe vSAN Express Storage Architecture™ concepts During this course, you will gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You will 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, troubleshooting and advanced vSAN cluster operations. You will learn these skills through the completion of instructor-led activities and hands-on lab exercises. COURSE INTRODUCTION * Introduction 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 VMware vSphere© Lifecycle ManagerTM to perform upgrades * Deploy and configure a vSAN Cluster using the Cluster QuickStart wizard * Manually configure a vSAN Cluster using VMware vSphere© Client? * Explain and configure vSAN fault domains * Using VMware vSphere© High Availability 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 MANAGING 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 VSAN HCI MESH * Understand the purpose of vSAN HCI Mesh * Detail vSAN HCI Mesh technology and architecture * Perform mount and unmount of a remote datastore VSAN FILE SERVICE AND ISCSI TARGET SERVICE * Understand the purpose of vSAN File Services * Detail vSAN File Services architecture * Configure vSAN File Shares * Describe vSAN iSCSI Target Service 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 storage policies for vSAN stretched cluster 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 CLUSTER MONITORING * Describe how the Customer Experience Improvement Program (CEIP) enables VMware to improve products and services * Use VMware Skyline Health for monitoring vSAN cluster health * Manage alerts, alarms, and notifications related to vSAN in VMware vSphere© Client? * Create and configure custom alarms to trigger vSAN health issues * Use IOInsight metrics for monitoring vSAN performance * Use a vSAN proactive test to detect and diagnose cluster issues VSAN TROUBLESHOOTING * Use a structured approach to solve configuration and operational problems * Apply troubleshooting methodology to logically diagnose faults and optimize troubleshooting efficiency * Use VMware Skyline Health to investigate and help determine failure conditions * Explain which log files are useful for vSAN troubleshooting VSAN EXPRESS STORAGE ARCHITECTURE * Understand the purpose of vSAN Express Storage Architecture * Describe the vSAN Express Storage Architecture components * Identify Storage Policy differences * Understand compression and encryption operation differences

Nowadays, Adobe After Effects CC broadly used in the post-production process of filmmaking and video production. In this Adobe After Effects CC course, you will equip yourself with multiple tools that empower you to improve your videos with expert motion graphics. Besides, you will learn powerful techniques to create the most detailed animations, implement animation effect, use graph editor, combine appealing backgrounds, colour creation, layouts and more. WHY CHOOSE THIS COURSE * Earn an e-certificate upon successful completion. * Accessible, informative modules taught by expert instructors * Study in your own time, at your own pace, through your computer tablet or mobile device * Benefit from instant feedback through mock exams and multiple-choice assessments * Get 24/7 help or advice from our email and live chat teams * Full Tutor Support on Weekdays COURSE DESIGN The course is delivered through our online learning platform, accessible through any internet-connected device. There are no formal deadlines or teaching schedules, meaning you are free to study the course at your own pace. You are taught through a combination of * Video lessons * Online study materials * Mock exams * Multiple-choice assessment CERTIFICATE OF ACHIEVEMENT Endorsed Certificate of Achievement from the Quality Licence Scheme Once the course has been completed and the assessment has been passed, all students are entitled to receive an endorsed certificate. This will provide proof that you have completed your training objectives, and each endorsed certificate can be ordered and delivered to your address for only £99.00. Please note that overseas students may be charged an additional £10 for postage. CPD Certificate of Achievement from Janets Upon successful completion of the course, you will be able to obtain your course completion e-certificate. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. ENDORSEMENT This course and/or training programme has been endorsed by the Quality Licence Scheme for its high-quality, non-regulated provision and training programmes. This course and/or training programme is not regulated by Ofqual and is not an accredited qualification. Your training provider will be able to advise you on any further recognition, for example progression routes into further and/or higher education. For further information please visit the Learner FAQs on the Quality Licence Scheme website. METHOD OF ASSESSMENT In order to ensure the Quality Licensing scheme endorsed and CPD acknowledged certificate, learners need to score at least 60% pass marks on the assessment process. After submitting assignments, our expert tutors will evaluate the assignments and give feedback based on the performance. After passing the assessment, one can apply for a certificate. COURSE CONTENT Introduction 0. After Effects Promo Video FREE 00:02:00 1.1 Intro Video 00:03:00 1.2 Project Files - Adobe After Effects CC 2017 Complete Training 00:00:00 1.3 Animate Your Name 00:07:00 After Effects Basics 2.1 Understand the After Effects Workspace 00:06:00 2.2 Starting a New Composition 00:08:00 2.3 Adding Media to Your Project and Timeline 00:05:00 2.4 Using the Basic After Effects Tools 00:10:00 2.5 Create a Perfect Circle, Alignment, and Shape Colors 00:03:00 2.6 Working in the Timeline 00:11:00 2.7 Layer Properties 00:09:00 Animating with Keyframes 3.1 Animating in After Effects 00:08:00 3.2 Position, Scale, and Rotation Animations 00:05:00 3.3 Tips to Make Your Animations Look More Nautral 00:04:00 3.4 Using the Graph Editor 00:06:00 3.5 Challenge - Bouncing Ball 00:01:00 3.6 Solution - Bouncing Ball 00:20:00 Shapes and Solid Layers 4.1 Working With Solid Layers and the ken Burns Effects 00:07:00 4.2 Working With Shape Layers, Strokes, and Paths 00:06:00 4.3 Adding Layer Styles Like Drop Shadow, Bevel, and Gradients 00:04:00 4.4 Shape Effects - Trim Path Animation, Wiggle, and Zig Zag 00:06:00 Important After Effects Skills 5.1 Track Matte Animation - Make Layers Appear And Disappear 00:09:00 5.2 Using Pre-Compositions to Group Layers 00:06:00 5.3 Easily Reverse Complicated Animations 00:02:00 5.4 Playing with Time 00:06:00 5.5 Blend Modes 00:06:00 5.6 Stabilize Shaky Footage 00:04:00 Motion Graphics Projects 6.1 Intro to Motion Graphics Projects 00:01:00 6.2 Clean Lower Third 00:09:00 6.3 Logo Reveal Animation Bumper 00:13:00 6.4 Colorful Transition 00:17:00 6.5 Text with Mask Path Animation 00:10:00 6.6 Text Bubble Animation 00:14:00 6.7 Weather App 1 00:16:00 6.8 Weather App 2 00:08:00 6.9 Weather App 3 00:07:00 Flat Animation Challenge 7.1 Flat Animation Challenge 00:03:00 7.2 Phil Designs his Flat Animation Scene 00:13:00 7.3 Animating Fireworks with the Repeater Effect 00:15:00 Green Screen (Chromakeying) 8.1 Removing Green Screen Background 00:07:00 8.2 Adding a Background that Matches the Foreground 00:08:00 8.3 Adding Motion to a Still Image with the Puppet Tool 00:06:00 8.4 Adding Movement with the Ripple Effect 00:06:00 3D Animations and the Camera Tool 9.1 Intro to 3D 00:10:00 9.2 Swinging 3D Text Animation 00:12:00 9.3 Build Out Your 3D Composition 00:06:00 9.4 Animating Our 3D Scene 00:08:00 9.5 Create Stars in After Effects 00:05:00 Rotoscoping 10.1 Using the Rotoscope Tool 00:07:00 10.2 Cleaning Up Your Edges 00:07:00 10.3 Finishing Our Rotobrush Animation 00:08:00 Screen Replacements 11.1 Easy Screen Replacement with Masks 00:10:00 11.2 Replacing a Screen Version 2 00:00:00 11.3 Screen Replacement with Mocha 00:08:00 Puppet Tool Animations 12.1 Using the Puppet Pin Tool 00:05:00 12.2 Animating Your Puppet Pins 00:03:00 12.3 Animated Blinking Eyes 00:08:00 12.4 Adding Perspective with Animated Clouds 00:07:00 Effects & Presets 13.1 Applying Text Animation Presets 00:00:00 13.2 Create a page Turn Effect with CC page Turn 00:10:00 13.3 Radial and Linear wipes 00:03:00 13.4 Color Correction in After Effects 00:04:00 Motion Tracking 14.1 Motion Tracking Basics 00:10:00 14.2 Tracking Text and Visual Effects to Video Clip 00:06:00 14.3 Tracking Rotation and Scale 00:12:00 14.4 Adding Details to Our Text 00:04:00 Character Animations 15.1 Intro to Character Animation 00:02:00 15.2 Design Your Character 00:15:00 15.3 Rigging Your Character 00:03:00 15.4 animation Our Character 00:10:00 15.5 Adding the Animated Background 00:09:00 15.6 Adding Details to Character Movement 00:07:00 15.7 Adding the Paper Cut Out Look 00:06:00 Exporting From After Effects 16.1 Exporting an H264 File From After Effects 00:07:00 16.2 Exporting from After Effects with a Transparent Background 00:04:00 16.3 Exporting from After Effects through Adobe Media Encoder 00:05:00 16.4 Create an Animated GIF from After Effects 00:07:00 After Effects Workflow + Tips 17.1 Audio Tips for After Effects 00:03:00 17.2 Working with Premiere Pro 00:06:00 Expressions 18.1 Expressions Basics 00:07:00 18.2 Animate a Flickering with Expressions 00:18:00 Conclusion 19.1 Conclusion 00:01:00 Assignment Assignment - Adobe After Effects CC 2 weeks, 1 day Order Your Certificate Order your Certificate QLS 00:00:00 FREQUENTLY ASKED QUESTIONS Are there any prerequisites for taking the course? There are no specific prerequisites for this course, nor are there any formal entry requirements. All you need is an internet connection, a good understanding of English and a passion for learning for this course. Can I access the course at any time, or is there a set schedule? You have the flexibility to access the course at any time that suits your schedule. Our courses are self-paced, allowing you to study at your own pace and convenience. How long will I have access to the course? For this course, you will have access to the course materials for 1 year only. This means you can review the content as often as you like within the year, even after you've completed the course. However, if you buy Lifetime Access for the course, you will be able to access the course for a lifetime. Is there a certificate of completion provided after completing the course? Yes, upon successfully completing the course, you will receive a certificate of completion. This certificate can be a valuable addition to your professional portfolio and can be shared on your various social networks. Can I switch courses or get a refund if I'm not satisfied with the course? We want you to have a positive learning experience. If you're not satisfied with the course, you can request a course transfer or refund within 14 days of the initial purchase. How do I track my progress in the course? Our platform provides tracking tools and progress indicators for each course. You can monitor your progress, completed lessons, and assessments through your learner dashboard for the course. What if I have technical issues or difficulties with the course? If you encounter technical issues or content-related difficulties with the course, our support team is available to assist you. You can reach out to them for prompt resolution.

COURSE OVERVIEW: Are you ready to embark on a journey into SQL Programming? Unlock the power of data manipulation and database management with the SQL Programming Masterclass.  This comprehensive course is meticulously designed throughout this masterclass to provide you with an in-depth understanding of SQL, starting from the basics and progressing to advanced topics. You will explore SQL data types, filtering and sorting data, working with functions, handle NULL values, and even diving into complex SQL concepts like joins, unions, etc. With a course duration of carefully crafted lessons, this Masterclass ensures you grasp SQL's nuances and develop the proficiency to apply these skills effectively. By the end of the SQL Programming Masterclass, you will be prepared to navigate the world of databases confidently. Enrol in this course today and start your journey! -------------------------------------------------------------------------------- KEY FEATURES OF THE COURSE: * CPD certificate upon completion * 24/7 learning assistance and support -------------------------------------------------------------------------------- WHO IS THIS COURSE FOR? This course is perfect for individuals seeking to enhance their data management and analysis skills. Whether you're a data analyst, database administrator, software developer, or professional looking to upskill, this course will empower you to harness the power of SQL programming. Prior programming experience is not mandatory, making it accessible to beginners and intermediate learners. -------------------------------------------------------------------------------- WHAT YOU WILL LEARN: * Foundations of SQL programming: Learn the basics of SQL, database management systems, and the tools used in this course, such as PostgreSQL and SQLectron. * Data manipulation: Master the art of extracting, filtering, and sorting data based on specific requirements using various SQL keywords and operators. * Advanced querying techniques: Dive deeper into SQL programming by exploring functions, grouping and aggregating data, and using advanced query techniques. * Data conversion and manipulation: Discover how to convert data types, concatenate strings, manipulate characters and numbers, and utilise case statements for more sophisticated queries. * Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. * Data modification: Learn how to insert, update, and delete records in a database, as well as manage table structures and constraints.Joining tables: Understand the different types of joins and how to combine data from multiple tables using join operations effectively. * Views and schemas: Explore the concepts of views and schemas, and learn how to create and use them to organise and present data effectively. -------------------------------------------------------------------------------- WHY ENROL IN THIS COURSE: Top-reviewed course: Join thousands of satisfied learners who have praised this course for its clear explanations, comprehensive content, and examples. Recently updated curriculum: Benefit from the most up-to-date information and industry best practices in SQL programming. In-demand skills: SQL programming is a highly sought-after skill in today's job market, opening up numerous career opportunities across industries. -------------------------------------------------------------------------------- REQUIREMENTS: No prior programming experience is required. All you need is a computer with an internet connection and a willingness to learn. -------------------------------------------------------------------------------- CAREER PATH: Upon completing the SQL Programming Masterclass, you'll have the knowledge and skills for various career paths, including: * Data Analyst - Average UK salary: £35,000 per year * Database Administrator - Average UK salary: £40,000 per year * Business Intelligence Analyst - Average UK salary: £45,000 per year * SQL Developer - Average UK salary: £40,000 per year * Data Engineer - Average UK salary: £55,000 per year * Software Developer - Average UK salary: £45,000 per year * Data Scientist - Average UK salary: £60,000 per year -------------------------------------------------------------------------------- CERTIFICATION: Upon completing the Hygiene and Infection Control CPD Level 4 course, you will receive a CPD certificate. It demonstrates your commitment to maintaining the highest standards of hygiene and infection control. -------------------------------------------------------------------------------- COURSE CURRICULUM 17 sections • 117 lectures • 10:47:00 total length •Introduction: 00:01:00 •Tools Used in This Course: 00:01:00 •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 •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 •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 •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 •Concatenate Strings with '||' Operator: 00:06:00 •Concatenate Strings with Numbers: 00:02:00 •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 •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 •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 •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 •Selectception: A Select Query inside another Select Query!: 00:06:00 •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 •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 •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 •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 •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 •Resources - SQL Programming Masterclass: 00:00:00

In this competitive job market, you need to have some specific skills and knowledge to start your career and establish your position. This Brow Lift & Lamination with Brow Hair Re-Modeling will help you understand the current demands, trends and skills in the sector. The course will provide you with the essential skills you need to boost your career growth in no time. The Brow Lift & Lamination with Brow Hair Re-Modeling will give you clear insight and understanding about your roles and responsibilities, job perspective and future opportunities in this field. You will be familiarised with various actionable techniques, career mindset, regulations and how to work efficiently. This course is designed to provide an introduction to Brow Lift & Lamination with Brow Hair Re-Modeling and offers an excellent way to gain the vital skills and confidence to work toward a successful career. It also provides access to proven educational knowledge about the subject and will support those wanting to attain personal goals in this area. LEARNING OBJECTIVES * Learn the fundamental skills you require to be an expert * Explore different techniques used by professionals * Find out the relevant job skills & knowledge to excel in this profession * Get a clear understanding of the job market and current demand * Update your skills and fill any knowledge gap to compete in the relevant industry * CPD accreditation for proof of acquired skills and knowledge WHO IS THIS COURSE FOR? Whether you are a beginner or an existing practitioner, our CPD accredited Brow Lift & Lamination with Brow Hair Re-Modeling is perfect for you to gain extensive knowledge about different aspects of the relevant industry to hone your skill further. It is also great for working professionals who have acquired practical experience but require theoretical knowledge with a credential to support their skill, as we offer CPD accredited certification to boost up your resume and promotion prospects. ENTRY REQUIREMENT Anyone interested in learning more about this subject should take this Brow Lift & Lamination with Brow Hair Re-Modeling. This course will help you grasp the basic concepts as well as develop a thorough understanding of the subject. The course is open to students from any academic background, as there is no prerequisites to enrol on this course. The course materials are accessible from an internet enabled device at anytime of the day. CPD CERTIFICATE FROM COURSE GATE At the successful completion of the course, you can obtain your CPD certificate from us. You can order the PDF certificate for £9 and the hard copy for £15. Also, you can order both PDF and hardcopy certificates for £22. CAREER PATH The Brow Lift & Lamination with Brow Hair Re-Modeling will help you to enhance your knowledge and skill in this sector. After accomplishing this course, you will enrich and improve yourself and brighten up your career in the relevant job market. COURSE CURRICULUM Introduction Introduction 00:01:00 The Treatment 01. Clean the eyebrows 00:03:00 02. Apply the product nr1 00:02:00 03. Removing the product nr1 00:02:00 04. Apply the product nr2 00:03:00 05. Removing the product nr2 00:02:00 06. Tint the eyebrows 00:10:00 07. Tweeze, wax, trim them 00:14:00 08. Strenghtening lotion and concealing 00:08:00 Types of Eyebrow Tint and Product Preparation Tint preparation 00:02:00 Resources Resources - Brow Lifting 00:00:00 Certificate and Transcript Order Your Certificates or Transcripts 00:00:00

Dive into the mesmerizing realm of animation and visual effects with our comprehensive 'Adobe After Effects CC Course.' Unleash your creativity as you journey through an extensive curriculum designed to transform novices into proficient animators. This course is not just about mastering tools; it's about crafting visual stories that captivate and inspire. From the basics of the After Effects workspace to advanced techniques in character animation, each module is a stepping stone towards unlocking your artistic potential. In this visually dynamic expedition, you'll animate your name, create motion graphics projects, replace screens seamlessly, delve into 3D animation, and even explore the fascinating world of character animation. Our modules are structured to guide you through the intricacies of After Effects, offering hands-on challenges and solutions to enhance your skills. Join us on this thrilling ride, where you're not just learning software - you're becoming a visual storyteller. Learning Outcomes * Master the After Effects workspace and essential tools. * Create captivating animations with position, scale, and rotation. * Utilize advanced techniques like motion tracking and rotoscoping. * Develop motion graphics projects, from lower thirds to transitions. * Harness the power of expressions for dynamic animations. WHY CHOOSE THIS ADOBE AFTER EFFECTS CC COURSE? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. Unlock career resources for CV improvement, interview readiness, and job success. WHO IS THIS ADOBE AFTER EFFECTS CC COURSE FOR? * Aspiring animators and visual storytellers. * Graphic designers eager to add motion to their creations. * Video editors looking to enhance their post-production skills. * Content creators aiming for engaging and dynamic visual content. * Anyone passionate about exploring the artistry of animation. CAREER PATH * Motion Graphics Designer: £25,000 - £40,000 * Visual Effects Artist: £30,000 - £50,000 * Animation Specialist: £28,000 - £45,000 * Video Content Creator: £22,000 - £35,000 * Multimedia Animator: £26,000 - £42,000 * Digital Media Producer: £32,000 - £48,000 PREREQUISITES This Adobe After Effects CC Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Adobe After Effects CC Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. CERTIFICATION After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. COURSE CURRICULUM Module: 01 1.1 Intro Video 00:03:00 1.3 Animate Your Name 00:07:00 Module: 02 2.1 Understand the After Effects Workspace 00:06:00 2.2 Starting a New Composition 00:08:00 2.3 Adding Media to Your Project and Timeline 00:05:00 2.4 Using the Basic After Effects Tools 00:10:00 2.5 Create a Perfect Circle, Alignment, and Shape Colors 00:03:00 2.6 Working in the Timeline 00:11:00 2.7 Layer Properties 00:09:00 Module: 03 3.1 Animating in After Effects 00:08:00 3.2 Position, Scale, and Rotation Animations 00:05:00 3.3 Tips to Make Your Animations Look More Nautral 00:04:00 3.4 Using the Graph Editor 00:06:00 3.5 Challenge - Bouncing Ball 00:01:00 3.6 Solution - Bouncing Ball 00:20:00 Module: 04 4.1 Working With Solid Layers and the ken Burns Effects 00:07:00 4.2 Working With Shape Layers, Strokes, and Paths 00:06:00 4.3 Adding Layer Styles Like Drop Shadow, Bevel, and Gradients 00:04:00 4.4 Shape Effects - Trim Path Animation, Wiggle, and Zig Zag 00:06:00 Module: 05 5.1 Track Matte Animation - Make Layers Appear And Disappear 00:09:00 5.2 Using Pre-Compositions to Group Layers 00:06:00 5.3 Easily Reverse Complicated Animations 00:02:00 5.4 Playing with Time 00:06:00 5.5 Blend Modes 00:06:00 5.6 Stabilize Shaky Footage 00:04:00 Module: 06 6.1 Intro to Motion Graphics Projects 00:01:00 6.2 Clean Lower Third 00:09:00 6.3 Logo Reveal Animation Bumper 00:13:00 6.4 Colorful Transition 00:17:00 6.5 Text with Mask Path Animation 00:10:00 6.6 Text Bubble Animation 00:14:00 6.7 Weather App 1 00:17:00 6.8 Weather App 2 00:08:00 6.9 Weather App 3 00:07:00 Module: 07 7.1 Flat Animation Challenge 00:03:00 7.2 Phil Designs his Flat Animation Scene 00:13:00 7.3 Animating Fireworks with the Repeater Effect 00:15:00 Module: 08 8.1 Removing Green Screen Backgroundc 00:07:00 8.2 Adding a Background that Matches the Foreground 00:08:00 8.3 Adding Motion to a Still Image with the Puppet Tool 00:06:00 8.4 Adding Movement with the Ripple Effect 00:06:00 Module: 09 9.1 Intro to 3D 00:10:00 9.2 Swinging 3D Text Animation 00:12:00 9.3 Build Out Your 3D Composition 00:06:00 9.4 Animating Our 3D Scene 00:08:00 9.5 Create Stars in After Effects 00:05:00 Module: 10 10.1 Using the Rotoscope Tool 00:07:00 10.2 Cleaning Up Your Edges 00:07:00 10.3 Finishing Our Rotobrush Animation 00:08:00 Module: 11 11.1 Easy Screen Replacement with Masks 00:10:00 11.2 Replacing a Screen Version 2 00:14:00 11.3 Screen Replacement with Mocha 00:08:00 Module: 12 12.1 Using the Puppet Pin Tool 00:05:00 12.2 Animating Your Puppet Pins 00:03:00 12.3 Animated Blinking Eyes 00:08:00 12.4 Adding Perspective with Animated Clouds 00:07:00 Module: 13 13.1 Applying Text Animation Presets 00:06:00 13.2 Create a page Turn Effect with CC page Turn 00:10:00 13.3 Radial and Linear wipes 00:03:00 13.4 Color Correction in After Effects 00:04:00 Module: 14 14.1 Motion Tracking Basics 00:10:00 14.2 Tracking Text and Visual Effects to Video Clip 00:06:00 14.3 Tracking Rotation and Scale 00:12:00 14.4 Adding Details to Our Text 00:04:00 Module: 15 15.1 Intro to Character Animation 00:02:00 15.2 Design Your Character 00:15:00 15.3 Rigging Your Character 00:03:00 15.4 animation Our Character 00:10:00 15.6 Adding Details to Character Movement 00:07:00 15.7 Adding the Paper Cut Out Look 00:06:00 Module: 16 16.1 Exporting an H264 File From After Effects 00:07:00 16.2 Exporting from After Effects with a Transparent Background 00:04:00 16.3 Exporting from After Effects through Adobe Media Encoder 00:05:00 16.4 Create an Animated GIF from After Effects 00:07:00 Module: 17 17.1 Audio Tips for After Effects 00:03:00 17.2 Working with Premiere Pro 00:06:00 Module: 18 18.1 Expressions Basics 00:07:00 18.2 Animate a Flickering with Expressions 00:18:00 Module: 19 19.1 Conclusion 00:01:00 Resources Resources -Adobe After Effects CC Course 00:00:00 Assignment Assignment - Adobe After Effects CC Course 00:00:00

Step into the vibrant world of web development with our 'jQuery Masterclass Course: JavaScript and AJAX Coding Bible.' This course is crafted to guide you through the intricate functionalities of jQuery, a powerful library that simplifies JavaScript programming. Starting with an introduction that sets the foundation, the course gradually unfolds the vast capabilities of jQuery, from simple selectors to complex AJAX operations. Each section is meticulously designed to build upon your skills, making the journey from novice to jQuery expert both engaging and informative. This course isn't just about learning to code; it's about empowering you to create interactive and dynamic web applications with ease and confidence. Progress through the curriculum to master various aspects of jQuery, including working with attributes and values, handling events, and manipulating HTML/CSS. You'll delve into traversing methods, learning to navigate and manipulate the Document Object Model (DOM) efficiently. The course also sheds light on creating visually appealing web pages with jQuery effects and animations. The comprehensive section on AJAX will equip you with the skills to make asynchronous requests, enhancing the user experience of your web applications. By the end of this course, you'll not only have a solid understanding of jQuery but also the practical know-how to implement it in real-world projects. Learning Outcomes * Understand the core concepts and functionalities of jQuery. * Master the use of selectors for manipulating DOM elements. * Gain proficiency in handling events and working with HTML/CSS in jQuery. * Learn to create dynamic web content and effects using jQuery. * Develop skills in AJAX for asynchronous web programming. WHY CHOOSE THIS JQUERY MASTERCLASS COURSE: JAVASCRIPT AND AJAX CODING BIBLE? 1. Unlimited access to the course for a lifetime. 2. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. 3. Structured lesson planning in line with industry standards. 4. Immerse yourself in innovative and captivating course materials and activities. 5. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. 6. Flexibility to complete the Course at your own pace, on your own schedule. 7. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 8. Unlock career resources for CV improvement, interview readiness, and job success. WHO IS THIS JQUERY MASTERCLASS COURSE: JAVASCRIPT AND AJAX CODING BIBLE FOR? * Web developers seeking to enhance their JavaScript and jQuery skills. * Front-end developers aiming to create more interactive web applications. * IT students and enthusiasts exploring web development technologies. * Professionals transitioning to web development and programming. * Anyone interested in learning jQuery for personal or professional web projects. CAREER PATH * Web Developer: £25,000 - £50,000 * Front-End Developer: £28,000 - £55,000 * JavaScript Developer: £30,000 - £60,000 * UI/UX Designer: £27,000 - £50,000 * Full Stack Developer: £35,000 - £70,000 * Web Application Developer: £32,000 - £65,000 PREREQUISITES This jQuery Masterclass Course: JavaScript and AJAX Coding Bible does not require you to have any prior qualifications or experience. You can just enrol and start learning.This jQuery Masterclass Course: JavaScript and AJAX Coding Bible 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 Section 01 : Introduction Introduction To This Course 00:02:00 Setup on Windows 00:03:00 Setup on Mac OS X 00:03:00 Setup on Linux 00:05:00 Online Code IDE 00:02:00 Uncompressed vs Minified vs Slim vs Slim Minified 00:05:00 Document Ready 00:03:00 Section 02 : Selectors Elements 00:03:00 All Elements 00:02:00 This Keyword 00:03:00 ID 00:02:00 Class 00:02:00 Multiple Items 00:03:00 First Element 00:02:00 Odd/Even 00:06:00 Element and Class 00:02:00 Children 00:04:00 Attributes 00:03:00 Type 00:04:00 Contains 00:03:00 Section 03 : Attributes/Values Get Attribute 00:02:00 Set Attribute 00:03:00 Set Attribute With Callback Function 00:03:00 Set Multiple Attributes 00:03:00 Remove 00:02:00 Text Attribute 00:02:00 Data Attribute 00:03:00 Value 00:03:00 HTML Value 00:02:00 Class 00:09:00 Section 04 : Events Binding & Unbinding 00:07:00 Attributes 00:04:00 Propagation 00:05:00 Prevent Default Behaviour 00:05:00 Mouse Single Click 00:02:00 Mouse Double Click 00:02:00 Mouse Enter Element 00:04:00 Mouse Leave Element 00:04:00 Mouse Hover 00:04:00 Mouse Down 00:03:00 Mouse Up 00:02:00 Keyboard Down 00:03:00 Keyboard Press 00:01:00 Keyboard Up 00:01:00 Form Submit 00:03:00 Form Change 00:03:00 Form Focus 00:04:00 Form Blur 00:02:00 Document/Window Scroll 00:03:00 Document/Window Resize 00:02:00 Combining Multiple Events Using A Single Selector 00:05:00 Section 05 : HTML/CSS Get and Set CSS Property 00:03:00 Set Multiple CSS Properties 00:02:00 Add, Remove and Toggle CSS Classes 00:06:00 Get and Set Element Dimensions 00:12:00 Adding Elements Using Append, Prepend, After and Before 00:05:00 Removing Elements Using Remove and Empty 00:06:00 Section 06 : Traversing Elements By Index 00:03:00 Child Elements 00:03:00 Parent Element 00:03:00 Sibling Elements 00:03:00 Filtering Elements 00:06:00 Section 07 : Effects Show, Hide and Toggle 00:11:00 Fading Using FadeIn, FadeOut, FadeToggle and FadeTo 00:06:00 Sliding Using SlideDown, SlideUp and SlideToggle 00:06:00 Animate 00:09:00 Stop Effects and Animations 00:03:00 Function Callback 00:03:00 Action and Method Chaining 00:05:00 Section 08: AJAX Load 00:05:00 Get JSON 00:04:00 GET Data 00:04:00 POST Data 00:05:00 Section 09 : Utility Functions Trim String 00:03:00 Extend 00:03:00 Extend Function 00:07:00 In Array 00:04:00 Each 00:03:00 Data Function 00:05:00 Proxy Function 00:03:00 Is Window Function 00:01:00 Now/Epoch Time Method 00:02:00 Number Check (isNumeric) 00:02:00 Dequeue 00:03:00 Global Evaluation 00:02:00 Section 10 : Resource Resource 00:00:00 Assignment Assignment - jQuery: JavaScript and AJAX Coding Bible 00:00:00

A comprehensive, simple, visual guide and a super-easy course using SAS with no installation on your computer necessary. This course uses the latest SAS Studio offered through SAS OnDemand and it's completely free. 12+ hours of knowledge-packed lectures, videos, quiz questions, followed by two practical and hands-on guided exercises and projects.

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. 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 Explain the importance vSAN node hardware compatibility Describe the use of VMware vSphere Lifecycle Manager™ to automate driver and firmware installations 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 Detail vSAN resilience and data availability Describe vSAN storage space efficiency Explain how vSAN encryption works Identify requirements to configure the vSAN iSCSI target Detail VMware HCI Mesh™ technology and architecture Detail vSAN File Service architecture and configuration Explain the use cases of vSAN Direct Configuration™ Describe how to setup a stretched and a two-node vSAN cluster Discuss vSAN cluster backup methodology Describe 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 During this five-day course, you will gain the knowledge, skills, and tools to plan and deploy a VMware vSAN? cluster. You will 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 will learn these skills through the completion of instructor-led activities and hands-on lab exercises. 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 Lifecycle Manager to perform upgrades * Deploy and configure a vSAN Cluster using the Cluster QuickStart wizard * Manually configure a vSAN Cluster using VMware vSphere© Client? * Explain and configure vSAN fault domains * Using VMware vSphere© High Availability 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 VMware HCI Mesh technology and architecture * Detail vSAN File Service architecture and configuration * Explain the use cases of vSAN Direct Configuration 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 VMware Skyline Health for monitoring vSAN cluster health * Manage alerts, alarms, and notifications related to vSAN in VMware vSphere© Client? * Create and configure custom alarms to trigger vSAN health issues * Use IOInsight metrics for monitoring vSAN performance * Analyse vsantop performance metrics * Use a vSAN proactive test to detect and diagnose cluster issues ADDITIONAL COURSE DETAILS: Notes Delivery by TDSynex, Exit Certified and New Horizons an VMware Authorised Training Centre (VATC) Nexus Humans VMware vSAN: Install, Configure, Manage [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: Install, Configure, Manage [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.