1190 Installation courses delivered Online

This course for beginners will help you build a solid foundation in programming with Python 3. We will cover core concepts such as Python statements, variables, data types, lists, typecasting, comments, conditional statements, loops, file handling, OOP concepts, and more. A carefully structured course with live demonstrations to get you started.

Duration 5 Days 30 CPD hours This course is intended for This course is designed for API developers. Overview Configure services in Cloud Manager for an on-premises installation of API Connect Create a catalog and Developer Portal Create consumer and provider organizations Create, test, and publish SOAP, REST, and GraphQL APIs Create message processing policies that transform API requests and responses Authorize client API requests with security definitions Enforce an OAuth flow with an OAuth 2.0 API security provider Perform advanced testing of APIs by using the Test tab and the Local Test Environment Define products and plans in API Manager Stage, publish, version, migrate, deprecate, and retire products and APIs Manage member roles and permissions in the Developer Portal Create an application and subscribe to a plan Review API analytics in the Developer Portal Review analytics dashboards and visualizations in API Manager Customize the Developer Portal This course teaches you how to configure a newly built API Connect 10 environment. You are taught how to configure a catalog with the gateway, portal, and analytics services and set up the environment for API development. You then define API interfaces according to the OpenAPI specification. You build SOAP and REST based APIs along with a GraphQL API. You assemble message processing policies and define client authorization schemes, such as OAuth 2.0, in the API definition. You verify the proper sequencing of policies in the assembly tester and further test your APIs in the new Test tab and Local Test Environment. After building and testing your APIs, you publish them and make them available on the Developer Portal. You manage all aspects of the provider organization in the API Manager user interface to create, publish, version, and retire API artifacts such as products, plans and APIs themselves. You also learn how to manage consumer organizations who use the APIs that are made available on the Developer Portal. You learn how to add members to the consumer organization that provides access to the APIs on the Developer Portal. You learn how the layout of the Developer Portal can be customized. Finally, you call the APIs on the secure gateway and you view the graphs and metrics of API usage. Course Outline Introduction to IBM API Connect V10 Exercise: Reviewing the API Connect development and runtime environments Managing catalogs and organizations Exercise: Managing catalogs and consumer organizations Defining APIs in API Manager Exercise: Defining an API that calls an existing SOAP service Defining a REST API in API Manager Exercise: Defining a REST API from a target service Assembling message processing policies Exercise: Assembling message processing policies Declaring client authorization requirements Creating an OAuth 2.0 provider Exercise: Implementing OAuth 2.0 security Testing and debugging APIs Exercise: Introduction to the Test tab Creating and testing a GraphQL API Exercise: Creating and testing a GraphQL API Testing an API in the Local Test Environment Exercise: Testing an API in the Local Test Environment Publishing and managing products and APIs Exercise: Define and publish an API product The product lifecycle Exercise: Subscribing and testing APIs in the Developer Portal Exercise: Managing and approving API Products Subscribing and testing APIs in the Developer Portal API Analytics Exercise: Calling an API on the gateway and monitoring API usage Customizing the Developer Portal Exercise: Customizing the Developer Portal Additional course details: Nexus Humans WD515G Create, Secure, and Publish APIs with IBM API Connect 10 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 WD515G Create, Secure, and Publish APIs with IBM API Connect 10 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 This SQL course will unlock your full potential and will show you how to excel in a career in SQL. So upskill now and reach your full potential. Everything you need to get started in SQL is available in this course. Learning and progressing are the hallmarks of personal development. This SQL will quickly teach you the must-have skills needed to start in the relevant industry. In This Mental Health Course, You Will: Learn strategies to boost your workplace efficiency. Hone your SQL skills to help you advance your career. Acquire a comprehensive understanding of various SQL topics and tips from industry experts. Learn in-demand SQL skills that are in high demand among UK employers, which will help you to kickstart your career. This SQL course covers everything you must know to stand against the tough competition in the SQL field.  The future is truly yours to seize with this SQL. Enrol today and complete the course to achieve a SQL certificate that can change your professional career forever. Additional Perks of Buying a Course From Institute of Mental Health Study online - whenever and wherever you want. One-to-one support from a dedicated tutor throughout your course. Certificate immediately upon course completion 100% Money back guarantee Exclusive discounts on your next course purchase from Institute of Mental Health Enrolling in the SQL course can assist you in getting into your desired career quicker than you ever imagined. So without further ado, start now. Process of Evaluation After studying the SQL course, your skills and knowledge will be tested with a MCQ exam or assignment. You must get a score of 60% to pass the test and get your certificate.  Certificate of Achievement Upon successfully completing the SQL course, you will get your CPD accredited digital certificate immediately. And you can also claim the hardcopy certificate completely free of charge. All you have to do is pay a shipping charge of just £3.99. Who Is This Course for? This SQL is suitable for anyone aspiring to start a career in SQL; even if you are new to this and have no prior knowledge on SQL, this course is going to be very easy for you to understand.  And if you are already working in the SQL field, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  Taking this SQL course is a win-win for you in all aspects.  This course has been developed with maximum flexibility and accessibility, making it ideal for people who don't have the time to devote to traditional education. Requirements This SQL course has no prerequisite.  You don't need any educational qualification or experience to enrol in the SQL course. Do note: you must be at least 16 years old to enrol. Any internet-connected device, such as a computer, tablet, or smartphone, can access this online SQL course. Course Curriculum Unit 01: Course and Instructor Introduction Course and Instructor Introduction 00:05:00 Unit 02: Laying out the foundation - Overview & Installation Pre-requisites & Different Editions of SQL Server 00:06:00 Downloading Express Edition & sample database 00:03:00 Installing the downloads & Configuration 00:19:00 The sa Login 00:04:00 Wrap up - what we went over! 00:01:00 Unit 03: Core concepts - Taming the RDBMS beast! What is RDBMS? 00:12:00 Where does SQL Server fit in? 00:02:00 Basic database objects 00:16:00 Different Files that got installed - MDF & LDF 00:03:00 Wrap up - what we went over! 00:01:00 Unit 04: Tool of the trade - SQL Server Management Studio Getting started with SSMS 00:07:00 Getting around Object Explorer 00:05:00 Query Window 00:06:00 Pre-built DB - system database 00:04:00 Wrap up - what we went over! 00:01:00 Unit 05: Simple SELECT Bare Minimum: SELECTING a literal 00:05:00 Retrieving / querying data from a table - using FROM clause 00:06:00 Playing with Column Names 00:03:00 Rearranging columns to your liking 00:01:00 Wrap up - what we went over! 00:01:00 Unit 06: Filtering out unwanted data Narrowing down and ordering result set - WHERE and ORDER clause 00:17:00 Narrowing down result set - BETWEEN / NOT BETWEEN 00:09:00 Narrowing down result set - IN and NOT IN operator 00:05:00 Narrowing down result set - Pattern Matching: LIKE and Wildcards 00:11:00 Wrap up - what we went over! 00:01:00 Unit 07: Expressions and Functions Dealing with nothing: NULL 00:06:00 Working with strings: Concatenation and other string functions 00:15:00 Working with dates: Date Functions 00:07:00 Some System Functions 00:05:00 Wrap up - what we went over! 00:02:00 Unit 08: Getting data out of multiple tables Joining multiple tables - INNER JOIN 00:09:00 Join types - OUTER JOIN - LEFT / RIGHT / FULL 00:08:00 Join types - CROSS JOIN 00:02:00 Holy UNION! 00:03:00 Subqueries 00:04:00 Wrap up - what we went over! 00:02:00 Unit 09: Summarizing and Grouping data DISTINCT and ALL Predicates 00:02:00 Aggregate Functions 00:03:00 GROUP BY clause / HAVING clause 00:04:00 WHERE and ORDER BY in aggregate queries 00:04:00 Wrap up - what we went over! 00:01:00 Unit 10: Bonus Bonus_Section 00:01:00

Quality Guarantee: Promising training excellence, satisfaction gurantee Accredited by CPD UK & Quality License Scheme Tutor Support Unlimited support via email, till you complete the course Recognised Certification: Accepted by thousands of professional bodies Start Anytime With 1 year access to the course materials Online Learning Learn from anywhere, whenever you want You can master the art of web design with our comprehensive WordPress Web Design Training Course. You will learn to create stunning and professional websites using the versatile WordPress platform with no prior coding experience required. This course at a glance Accredited by CPD UK Endorsed by Quality Licence Scheme Learn website online hosting plan and steps to install WordPress on the website Understand classic editor vs Gutenburg Know how to create WordPress website pages and menus Get acquainted with WordPress page builder familiarisation Understand WordPress home page design and development Know WordPress About us page design and development Discover free plugins to mimic the elementor pro and premium plugins Learn how to create a WordPress e-commerce store Understand WordPress website backup and official mail Learn how to export and import elementor pages Why WordPress Web Design Training Course right for you? This comprehensive online course is designed for those who want to understand WordPress elementor, website online hosting plan, and steps to install WordPress on the website. You will learn interesting concepts such as WordPress page builder familiarisation, home page design and development, About us page design and development, and much more. In addition, this extensive course will give you a solid knowledge of exporting and importing elementor pages, steps to create a WordPress eCommerce store and website backup. By the end of the course, you will have a broad understanding of WordPress installation, website backup, free plug-ins, web page design and development. WordPress Web Design Training Course Details Accredited by CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field.   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. Course Curriculum Introduction & Installing WordPress WordPress Elementor Course Outline Website Online Hosting Plan Installing WordPress on Our Website Installing WordPress Ocean WP Theme & Elementor Page Builder Classic Editor Vs Gutenburg (Optional) Creating WordPress Website Pages & Menus WordPress Page Builder Familiarization Quick Tour in Elementor Creative Art Directions & Layout Inspirations for WordPress Design Familiarize with Elementor Part 1 (sections) Familiarize with Elementor Part2 (widgets) Brain Storming & Tips for Fast Workflow with Elementor WordPress home page Design & development WordPress Header & Banner Design Part 1 WordPress Header & Banner Design Part2 WordPress Header & Banner Design Part3 WordPress Website Middle Sections Design & Development WordPress Png Section Design WordPress Email Opt-in Section Design WordPress Testimonials Section Design WordPress Image Carousel Section Design WordPress Website Footer Design WordPress Website Theme Customizer Tour & Logo Finalizing Our WordPress Home Page & Design Tips WordPress About Us Page Design & Development WordPress About Us Page Design Part1 WordPress About Us Design Part2 WordPress About Us Design Part3 WordPress Contact Us & Blog Page Design & Development WordPress Website Contact Us Page & Blog Page Design Creating WordPress Blog & Posting With Elementor WordPress Responsive Website & Publishing Website WordPress Mobile & Tablet Responsive Website Publishing WordPress Website & Creating Maintenance & Coming Soon Pages Free Plugins to Mimic The Elementor Pro & Premium Plugins Free Plugins to Convert Your Elementor Into Pro Crocoblock For Elementor Exporting & Importing Our Elementor Pages Exporting & Importing Our Elementor Web Pages Creating Our WordPress Ecommerce Store Installing Woocommerce Plugin ( For WordPress Ecommerce ) Making First Ecommerce Product (Simple Product) Variable Ecommerce Product Up Sells & Cross Sells WordPress Woocommerce Settings Ecommerce Discount Coupons Designing Ecommerce Store with Elementor & WordPress Theme WordPress Website Customization Converting WordPress Website to HTTPS (SSL Certificate) Google Analytics & Webmasters Tool Speeding Up Our WordPress Website Optimizing Images & Creative Art Directions Subdomain WordPress Website Backup, Official Email & More Website Domian Official Email WordPress Site Back up & Trust Lock Seal Who should take this course? This comprehensive course is suitable for anyone looking to improve their job prospects or aspiring to accelerate their career in this sector and want to gain in-depth knowledge of WordPress web design training . Entry Requirements There are no academic entry requirements for this course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This WordPress Web Design Training 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 can grasp from each section. In the assessment pass mark is 60%. Certification Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35. FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

This course will enhance your productivity and typing speed. From mastering the keyboard layout to building muscle memory you will learn to type effortlessly and accurately without looking at the keys. This Course At A Glance Accredited by CPD UK Endorsed by Quality Licence Scheme Discover essential things to know about touch typing Master the applications to help you to become an expert at touch typing Understand correct backspacing Learn how to tap on the keys Know how to focus on accuracy to enhance speed Learn touch typing cycles, speed improvement and maintenance Understand WPM Learn which fingers to use in touch typing Discover one language to learn touch typing Touch Typing Course Overview This extensive touch typing course is suitable for those who want to understand touch typing cycle rules, speed improvement tips, and maintenance. You will learn how to focus on accuracy to get speed, whys of touch-typing, and maintaining proper posture while typing. This online course will help you pick up the correct fingers, rhythm, correct backspacing, and tapping keys. You will study which fingers to use in touch typing, applications to help you become a master at touch typing, and essential things to know about Touch typing. By the end of the course, you will learn the effective methods and techniques to do touch typing, its rules, speed improvement and maintenance. Who should take this course? This touch typing course is perfect for those who want to enhance their touch typing speed, know applications to help you become a master at touch typing, and maintain a posture to touch type. Entry Requirements There are no academic entry requirements for this touch typing course, and it is open to students of all academic backgrounds. However, you are required to have a laptop/desktop/tablet or smartphone and a good internet connection. Assessment Method This touch typing 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%. Course Curriculum Introduction Master Touch Typing Promo Reminder! This Is a Real Course With Real Instructor Ready to Answer Questions Your Facebook Support Community Master at Touch Typing Quick Win - Focus On Accuracy to Get Speed Another Quick - Have Straight Arm and Hand Touch Typing Cycles Rules, Speed Improvement and Maintenance Understand Your Wpm Now and Type in Q&A Reasons You Learn Touch Typing One Language at a Time for Learning Touch Typing Understand Your Whys of Touch Typing You Have to Look the Text Not Keyboard Have Proper Posture While Typing Pick up the Correct Fingers The Number One Secret Is Rhythm Correct Backspacing Tap on the Keys More Accuracy More Speed Big Challenge - Listen and Type Summary of All Touch Typing Tips Learn Which Fingers Go Where in Touch Typing (With Google Classroom Practice) Welcome to Touch Typing Journey Guides You How to Place Your Hands Place Your Hands Better on Keyboard and Avoid Typing of 1QAZ Spacebar Guide Typing of 2WSX Typing of 3EDC Typing of 4RFV Typing of 5TGB Typing of YHN Typing of UJM Typing of 8IK, Typing of 9OL. Typing of 0p; Important Remainder of Keyboard View Reasons of Having Two Shift, Alt, and CTRL Button How You Can Join Your Google Classroom Applications That Can Help You to Become Master at Touch Typing Rapid Typing Installation Rapid Typing Configuration Rapid Typing Part 1 Rapid Typing Part 2 Typing of the Dead Mavis Beacon Teaches Typing Keyblaze Touch Typing Software Typing Master Online Touch Typing Important Things You Need to Know About Touch Typing Important Things You Need to Know About Touch Typing Same Rules Are Applied for Phone Touch Typing! Conclusion You Are Now Master of Touch Typing Supplementary Resources Supplementary Resources - Touch Typing Assessment Assessment - Touch Typing Recognised Accreditation CPD Certification Service 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. CPD certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Many organisations look for employees with CPD requirements, which means, that by doing this course, you would be a potential candidate in your respective field. Quality Licence Scheme Endorsed 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees.     Certificate of Achievement Endorsed Certificate from Quality Licence Scheme After successfully passing the MCQ exam you will be eligible to order the Endorsed Certificate by Quality Licence Scheme. 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. It will give you a competitive advantage in your career, making you stand out from all other applicants and employees. There is a Quality Licence Scheme endorsement fee to obtain an endorsed certificate which is £65. Certificate of Achievement from Lead Academy After successfully passing the MCQ exam you will be eligible to order your certificate of achievement as proof of your new skill. The certificate of achievement is an official credential that confirms that you successfully finished a course with Lead Academy. Certificate can be obtained in PDF version at a cost of £12, and there is an additional fee to obtain a printed copy certificate which is £35.   FAQs Is CPD a recognised qualification in the UK? CPD is globally recognised by employers, professional organisations and academic intuitions, thus a certificate from CPD Certification Service creates value towards your professional goal and achievement. CPD-certified certificates are accepted by thousands of professional bodies and government regulators here in the UK and around the world. Are QLS courses recognised? Although QLS courses are not subject to Ofqual regulation, they must adhere to an extremely high level that is set and regulated independently across the globe. A course that has been approved by the Quality Licence Scheme simply indicates that it has been examined and evaluated in terms of quality and fulfils the predetermined quality standards. When will I receive my certificate? For CPD accredited PDF certificate it will take 24 hours, however for the hardcopy CPD certificate takes 5-7 business days and for the Quality License Scheme certificate it will take 7-9 business days. Can I pay by invoice? Yes, you can pay via Invoice or Purchase Order, please contact us at info@lead-academy.org for invoice payment. Can I pay via instalment? Yes, you can pay via instalments at checkout. How to take online classes from home? Our platform provides easy and comfortable access for all learners; all you need is a stable internet connection and a device such as a laptop, desktop PC, tablet, or mobile phone. The learning site is accessible 24/7, allowing you to take the course at your own pace while relaxing in the privacy of your home or workplace. Does age matter in online learning? No, there is no age limit for online learning. Online learning is accessible to people of all ages and requires no age-specific criteria to pursue a course of interest. As opposed to degrees pursued at university, online courses are designed to break the barriers of age limitation that aim to limit the learner's ability to learn new things, diversify their skills, and expand their horizons. When I will get the login details for my course? After successfully purchasing the course, you will receive an email within 24 hours with the login details of your course. Kindly check your inbox, junk or spam folder, or you can contact our client success team via info@lead-academy.org

Highlights of the Course Course Type: Online Learning Duration: 6 Hours 34 Minutes 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 WordPress development Understand the core competencies and principles of WordPress development Explore the various areas of WordPress development Know how to apply the skills you acquired from this course in a real-life context Become a confident and expert WordPress developer WordPress Training Diploma Course Master the skills you need to propel your career forward in WordPress development. This course will equip you with the essential knowledge and skillset that will make you a confident WordPress developer and take your career to the next level. This comprehensive WordPress training diploma course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this WordPress training diploma 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 WordPress development practice and equip you with the essential skills, confidence and competence to assist you in the WordPress development industry. You'll gain a solid understanding of the core competencies required to drive a successful career in WordPress development. 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 WordPress developer or for people who are aspiring to specialise in WordPress development. Enrol in this WordPress training diploma 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 WordPress training diploma 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 WordPress development 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 WordPress training diploma 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 WordPress training diploma 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 WordPress training diploma 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. Course Curriculum Wordpress Complete Website MasterClass Introduction WordPress Complete Website MasterClass Promo 00:01:00 WordPress MasterClass Outline 00:01:00 WordPress MasterClass Resources & Assets 00:01:00 Website's Domain & Wordpress Installation & customization WordPress Website Hosting & website domain 00:07:00 Installing WordPress 00:04:00 WordPress tour 00:04:00 Creating WordPress website pages& Gutenberg tour 00:05:00 Creating website's Menus & static page 00:05:00 Installing WordPress Astra theme 00:04:00 Wordpress Page Builder Brizy Installing WordPress Plugin: Brizy 00:08:00 Brizy quick tour (pt1) 00:15:00 14 Brizy quick tour (pt2) 00:06:00 Wordpress Home Page Design Home page design outline & Blisk browser 00:03:00 Website's First Block design (Hero Block) 00:23:00 Business Brand Block design (2nd section) 00:10:00 Overlapping block Design in WordPress Brizy 00:23:00 Testimonials block design 00:02:00 email opt-in form using both WordPress Brizy 00:12:00 Map & contact Block design 00:04:00 WordPress Website's Header Area (Brizy pro) 00:06:00 WordPress Website Footer Area (Brizy pro) 00:07:00 Header Area (WordPress Theme's customizer - Free Brizy version) 00:08:00 Footer Area (WordPress theme's customizer - Brizy free version) 00:06:00 Wordpress Website Responsiveness WordPress Website Responsiveness for tablets 00:09:00 WordPress Website Responsiveness for Mobiles 00:12:00 About us, Contact Us Page & Wordpress Icon Site Icon WordPress Website's About us page design 00:22:00 WordPress website Contact page design 00:13:00 WordPress Site Icon & Astra theme's customizer 00:04:00 Establishing Blog on our Wordpress website Creating WordPress blog page & posts (free & pro Brizy users) 00:11:00 Blog post template (Brizy pro) 00:11:00 Establishing Ecommerce Store on our Wordpress Website Installing WordPress Woocommerce Plugin 00:06:00 Creating Woocommerce Simple Product 00:12:00 ecommerce store visuals (WordPress theme's customizer) 00:06:00 Creating Woocommerce variable products 00:06:00 Creating Discount Coupons & WordPress Wocommerce purchasing cycle 00:06:00 WordPress Woocommerce settings,tax,payment,emails explained 00:08:00 Adding Products&categories to our webpages (using WordPress brizy plugin) 00:08:00 Wordpress Website Optimizations & Technicals WordPress Website Performance optimization 00:10:00 WordPress website back up, transfer & restore 00:08:00 Website official email (domain email & device setup) 00:04:00 Understanding subdomains 00:06:00 Opt2:Alternative method using Cloudflare for WordPress Performance optimization 00:12:00 Optimizing images & creative images Art directions 00:11:00 Facebook Ads - Marketing your Wordpress Website's Products Creating Facebook business account & Creating Store's Page 00:03:00 Integrating facebook pixel 00:03:00 Creating Facebook Ads (campaigns) 00:03:00 Creating Facebook Ads (Ads) 00:02:00 Creating Facebook Ads ( Ad sets) 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

Highlights of the Course Course Type: Online Learning Duration: 2 hours 1 minute 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 touch typing Understand the core competencies and principles of touch typing Explore the various areas of touch typing Know how to apply the skills you acquired from this course in a real-life context Become a confident and touch typist Touch Typing Training Masterclass Program Course Master the skills you need to propel your career forward in touch typing. This course will equip you with the essential knowledge and skillset that will make you a confident touch typist and take your career to the next level. This comprehensive touch typing training masterclass program course is designed to help you surpass your professional goals. The skills and knowledge that you will gain through studying this touch typing training masterclass program 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 touch typing practice and equip you with the essential skills, confidence and competence to assist you in the touch typing industry. You'll gain a solid understanding of the core competencies required to drive a successful career in touch typing. 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 touch typist or for people who are aspiring to specialise in touch typing. Enrol in this touch typing training masterclass program 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 touch typing training masterclass program 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 touch typing 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 touch typing training masterclass program 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 touch typing training masterclass program 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 touch typing training masterclass program 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. Course Curriculum Introduction Master Touch Typing Promo 00:01:00 Reminder! This Is a Real Course with Real Instructor Ready to Answer Questions 00:22:00 Your Facebook Support Community 00:01:00 Master at Touch Typing Quick Win - Focus on Accuracy to Get Speed 00:01:00 Another Quick - Have Straight Arm and Hand 00:01:00 Touch Typing Cycles Rules, Speed Improvement and Maintenance 00:02:00 Understand Your WPM Now and Type in Q&A 00:01:00 Reasons You Learn Touch Typing 00:02:00 One Language at A Time for Learning Touch Typing 00:02:00 Understand Your Whys of Touch Typing 00:02:00 You Have to Look the Text Not Keyboard 00:02:00 Have Proper Posture While Typing 00:02:00 Pick up The Correct Fingers 00:01:00 Correct Backspacing 00:01:00 Tap on The Keys 00:01:00 More Accuracy More Speed 00:02:00 Big Challenge - Listen and Type 00:02:00 Summary of All Touch Typing Tips 00:11:00 Learn Which Fingers Go Where In Touch Typing (With Google Classroom Practice) Welcome to Touch Typing Journey 00:01:00 Guides You How To Place Your Hands 00:01:00 Place Your Hands Better on Keyboard and Avoid 00:02:00 Typing of 1QAZ 00:04:00 Spacebar Guide 00:01:00 Typing of 2WSX 00:02:00 Typing of 3EDC 00:01:00 Typing of 4RFV 00:01:00 Typing of 5TGB 00:01:00 Typing of YHN 00:02:00 Typing of UJM 00:01:00 Typing of 8IK, 00:01:00 Typing of 9OL. 00:01:00 Typing of 0p; 00:01:00 Important Remainder of Keyboard View 00:01:00 Reasons of Having Two Shift, Alt, and Ctrl Button 00:01:00 How You Can Join Your Google Classroom 00:03:00 Applications That Can Help You To Become Master At Touch Typing Rapid Typing Installation 00:03:00 Rapid Typing Configuration 00:02:00 Rapid Typing Part 1 00:06:00 Rapid Typing Part 2 00:04:00 Typing of The Dead 00:09:00 Mavis Beacon Teaches Typing 00:04:00 KeyBlaze Touch Typing Software 00:05:00 Typing Master 00:06:00 Online Touch Typing 00:05:00 Important Things You Need to Know About Touch Typing 00:03:00 Important Things You Need to Know About Touch Typing Same Rules Are Applied for Phone Touch Typing! 00:09:00 Conclusion You Are Now Master of Touch Typing 00:01:00 Supplementary Resources Supplementary Resources - The Complete Touch Typing Masterclass: Master Touch Typing 00:00: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

Register on the Python from Scratch today and build the experience, skills and knowledge you need to enhance your professional development and work towards your dream job. Study this course through online learning and take the first steps towards a long-term career. The course consists of a number of easy to digest, in-depth modules, designed to provide you with a detailed, expert level of knowledge. Learn through a mixture of instructional video lessons and online study materials. Receive online tutor support as you study the course, to ensure you are supported every step of the way. Get an e-certificate as proof of your course completion. The Python from Scratch is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablet, and smartphones. The course is designed to increase your employability and equip you with everything you need to be a success. Enrol on the now and start learning instantly! What You Get With The Python from Scratch Receive a e-certificate upon successful completion of the course Get taught by experienced, professional instructors Study at a time and pace that suits your learning style Get instant feedback on assessments 24/7 help and advice via email or live chat Get full tutor support on weekdays (Monday to Friday) 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 Certification Upon successful completion of the course, you will be able to obtain your course completion e-certificate free of cost. Print copy by post is also available at an additional cost of £9.99 and PDF Certificate at £4.99. Who Is This Course For: The course is ideal for those who already work in this sector or are an aspiring professional. This course is designed to enhance your expertise and boost your CV. Learn key skills and gain a professional qualification to prove your newly-acquired knowledge. Requirements: The online training is open to all students and has no formal entry requirements. To study the Python from Scratch, all your need is a passion for learning, a good understanding of English, numeracy, and IT skills. You must also be over the age of 16.  Course Content Python from Scratch 1a Python Course Introduction 00:04:00 1b Python Course Curriculum Overview 00:10:00 1c Python Whats New 00:04:00 2a command line basics in python 00:06:00 2b python installation 00:06:00 2c Pycham-ce ide installation.mp4 00:06:00 2d Setting up environment 00:07:00 2e running python code 00:10:00 2f git and github overview 00:04:00 3a Python Data Types 00:09:00 3b Python Arithmetic Operators Numbers 00:12:00 3b Python Arithmetic Operators Numbers.mp4 00:12:00 3f Variable Assignments 00:15:00 3g Strings Introduction 00:06:00 3h Indexing and Slicing with Strings 00:08:00 3k String Properties and Methods 00:12:00 3l Formatting strings in python 00:07:00 3n Lists in Python 00:11:00 3r Dictionaries in python 00:07:00 3v Tuples in Python 00:09:00 4a Comparison Operators in Python 00:15:00 4b Logical Operators in Python.mp4 00:08:00 5a If Elif and Else Statements in Python 00:08:00 5b For Loops in Python 00:08:00 5c While Loops in Python 00:04:00 6a Functions in Python 00:07:00 6b Methods in Python 00:11:00 6c List Methods in Python 00:11:00 6j i Nested Loop in Python 00:08:00 6j ii 2D Lists using Nested Loop in Python 00:06:00 7a Introduction of Object Oriented Programming in Python.mp4 00:11:00 7b Attributes and Class keyword 00:13:00 7c Class object, attributes and methods in Python 00:11:00 7d Inheritance 00:10:00 7e Encapsulation in Python 00:07:00 7f Polymorphism opps in Python 00:11:00 8a Pypi and Pip 00:06:00 8b Modules in Python 00:09:00 8c Packages in Python 00:09:00 9a Errors and Exception Handiling in Python 00:10:00 10a Guessing Game in Python 00:06:00 10b Car Game using Python 00:12:00 10c Dice Game using python 00:05:00 10d Card and Deck Game in Python.mp4 00:07:00 11a Decorators in Python 00:06:00 12a Python Generators 00:06:00 14a Built-in Modules Random Values 00:06:00 14b Datetime in Python 00:04:00 14d Timing your code execution 00:06:00 14e Regular Expressions -re.mp4 00:09:00 15a First Django Project creation 00:12:00 15b First Django App 00:05:00 15c View Functions in Django 00:03:00 15d URL Mapping on Django in Python 00:14:00 15e Models in django 00:06:00 15f Migrations in django 00:10:00 15g Admin in Django project.mp4 00:11:00 15h Customizing the Admin in Django project 00:05:00 15i Templates in Django project 00:10:00 15j Adding Bootstrap on django project 00:07:00 15k Rendering Bootstrap Cards in django project App 00:09:00 15l Navigation in django 00:03: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.

Maintaining your bike can be difficult, especially if you haste or become confused, resulting in mistakes. So, relax and join us on this bike repair adventure! Whether you want to fix bikes as a pastime or as a possible career, we've got you covered. Put this course in your shopping cart and obtain the confidence to perform basic bicycle maintenance. Are you looking to improve your current abilities or make a career move? Our unique Course might help you get there! Expand your expertise with high-quality training - study the course and get an expertly designed, great value training experience. Learn from industry professionals and quickly equip yourself with the specific knowledge and skills you need to excel in your chosen career through the Bike Maintenance online training course. This Bike Maintenance online training course is accredited by CPD with 10 CPD points for professional development. Students can expect to complete this Bike Maintenance training course in around 05 hours. You'll also get dedicated expert assistance from us to answer any queries you may have while studying our course. The Bike Maintenance course is broken down into several in-depth modules to provide you with the most convenient and rich learning experience possible. Upon successful completion of the course, an instant e-certificate will be exhibited in your profile that you can order as proof of your new skills and knowledge. Add these amazing new skills to your resume and boost your employability by simply enrolling on this course. With this comprehensive course, you can achieve your dreams and train for your ideal career. The course provides students with an in-depth learning experience that they can work through at their own pace to enhance their professional development. You'll get a Free Student ID card by enrolling in this course. This ID card entitles you to discounts on bus tickets, movie tickets, and library cards. This training can help you to accomplish your ambitions and prepare you for a meaningful career. So, join the course today - gear up with the essential skills to set yourself up for excellence! Some FAQ from Learners: Question: What are the minimum things you should take out with you when you go out on your ride? Answer: Mike: Drinks, banana/gels, mobile phone (charged), multi-tool, spare inner tube, puncture repair kit, tyre levers, CO2 cartridge and/or pump, emergency cash and a spare 'magic' chain link. You might also consider extra rain-protective clothing and a mini-chain tool. A motor-pacing scooter can also be handy! And if you are riding to get away from it all forget the phone. Question: How often should you clean your bike if you're riding 2-3 times a week or more? Is there any particular method you'd advise following? Mike: After every ride! Degrease your chain and any other oil-soiled components first - (I use a chain cleaning tool Car Plan degreaser), then clean with a proprietary detergent, rinse off, dry, lubricate the chain. Check cable operation and lubricate if necessary. Experts created the Beginner Bike Maintenance course to provide a rich and in-depth training experience for all students who enrol in it. Enrol in the course right now and you'll have immediate access to all of the course materials. Then, from any internet-enabled device, access the course materials and learn when it's convenient for you. Start your learning journey straight away with this Beginner Bike Maintenance course and take a step toward a brighter future! Why should you choose the course with Academy for Health & Fitness? Opportunity to earn a certificate accredited by CPD after completing this course Student ID card with amazing discounts - completely for FREE! (£10 postal charges will be applicable for international delivery) Globally accepted standard structured lesson planning Innovative and engaging content and activities Assessments that measure higher-level thinking and skills Complete the program in your own time, at your own pace Each of our students gets full tutor support on weekdays (Monday to Friday) *** Course Curriculum *** Beginner Bike Maintenance Module 01: Introduction to Motorbike Maintenance Things to Be Learnt Motorbike Tools Hand Tools Big Ticket Tools Safety Concerns Summary Module 02: Basics of Engine Two-Stroke Basics Four-Stroke Basics The Top and Bottom Ends Valves and Cams Engine Layout Summary Module 03: Engine Cooling and Lubrication Engine Cooling Air and Oil Cooling Changing Coolant Liquid Cooling Lubrication Synthetic Oil Vs. Mineral Oil Detergent Vs. Non-Detergent Oil Engine Oil and Lubrication Oil Change and Conventional Fork Oil Change Cartridge-Type Fork Oil Change Summary Module 04: Ignition Ignition Basic Battery, Coil Ignition and Installing Spark Plugs. Adjusting Ignition Timing and Maintaining Ignition System. Summary Module 05: Suspension Suspension Work of springs and Aftermarket Spring Kits Dampers and Suspension Tuning Front, Rear Suspension and Improving Suspension Setting Ride Height and Adjusting Rebound Damping Summary Module 06: Intake, Fuel, Clutch and Exhaust Systems Maintaining Fuel System and Fuel Injection Installing an Inline Fuel Filter Maintaining Clutch Adjusting and Replacing Clutch Improving Clutch and Automotive-Style Clutch Carburettor Types of Carburettors Synchronizing Carburettors Cleaning Petcock Strainers Exhaust System Scavenging Power Pipe Design Chain Cleaning and Lubrication Chain Adjustment Sprocket Replacement Summary Module 07: Electrical Maintenance How Wet-Cell Batteries Work Installing a New Battery Battery Breather Quick Charge Test Basic Wiring Technique Basic Circuit Facts Light Bulbs Checking Resistance Checking Sending Units Electrical Dos and Don'ts Summary Module 08: Wheels, Tires and Brakes Maintenance Wheels Wheels and Its Specifications Checking and Adjusting Wheel Alignment Checking and Truing Spoked Wheels Replacing Wheel Bearings and Seals Wheel Building and Truing Tires Changing Tubes and Tires. Balancing Tires. Brakes Replacing Brake Shoe Changing Brake Fluid Changing Brake Pads Rebuilding Callipers and Improving Brakes Maintaining Wheels and Tires Summary Module 09: Transmission, Frame and Steering Transmission Constant Mesh Transmission Shifting Gears Oil Additives Transmission Oil Change Frame The Motorbike Frame Types of Frame How the Frame Influence Handling Wheelbase Maintaining the Chassis Steering Checking and Adjusting Steering-Head Bearings Replacing Steering-Head Bearings Checking and Adjusting Swingarm Bearings Bolt Checking and Crash Damage Summary Module 10: Cleaning, Setting Up and Storage Washing, Waxing and Polishing Touching-Up Paint Winter Storage Storage Procedure Summary Module 11: Troubleshooting What to Do If a Bike Does not Start? Go with The Flow Basics of Troubleshooting Things Checking for Spark and Running Problem Troubleshooting the Charging System Checking Compression and Heli-Coil Installation Removing a Seized Bolt and a Stuck Screw Lubricating a Control Cable and Hand-Packing a Bearing Removing and Replacing a Seal Changing Hydraulic Fluid Summary Assessment Process Once you have completed all the course modules, your skills and knowledge will be tested with an automated multiple-choice assessment. You will then receive instant results to let you know if you have successfully passed the Beginner Bike Maintenance course. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone interested in learning more about the topic is advised to take this course. This course is open to everybody. Requirements You will not need any prior background or expertise to enrol in this course. Career path After completing this course, you are to start your career or begin the next phase of your career.

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