871 String courses in London delivered On Demand

Unlock the power of programming with our Basic C# Coding course, designed for beginners eager to embark on a coding journey. Dive into the world of C#, a versatile programming language that forms the backbone of numerous software applications. From understanding the foundations of C# and the .NET Framework to mastering key concepts like operators, statements, and control flow, this course offers a comprehensive introduction to C# coding. Get hands-on experience with arrays, lists, file structures, and dates, and learn essential debugging techniques to ensure your code runs smoothly. Whether you're looking to kickstart a career in software development or want to enhance your problem-solving skills, this course is the ideal starting point to unravel the art of programming. Learning Outcomes Gain a solid understanding of C# and the .NET Framework. Master C# basics, including operators, statements, and control flow. Explore the use of arrays, lists, and working with file structures. Learn to manipulate dates and effectively debug applications. Be prepared to take your coding skills to the next level with a strong foundation in C#. Why choose this Basic C# Coding course? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success. Who is this Basic C# Coding course for? Aspiring programmers and software development enthusiasts. Students and beginners seeking an introduction to C# coding. Professionals looking to enhance their problem-solving and logical thinking skills. Individuals considering a career in software development. Anyone curious about the world of programming and its endless possibilities. Career path Junior Software Developer: £20,000 - £35,000 Software Engineer: £30,000 - £60,000 Web Developer: £25,000 - £45,000 Application Developer: £25,000 - £50,000 Database Administrator: £25,000 - £45,000 Quality Assurance Analyst: £20,000 - £40,000 Prerequisites This Basic C# Coding does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Basic C# Coding 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 Course Introduction 00:02:00 Course Curriculum 00:07:00 How to get Pre-requisites 00:03:00 Getting Started on Windows or Linux 00:01:00 How to ask Great Questions 00:02:00 FAQ's 00:01:00 Section 02: Introduction to C# and .NET Framework Introduction to C# 00:07:00 C# vs .NET 00:04:00 What is CLR? 00:05:00 Architecture of .NET Application 00:09:00 Getting Visual Studio 00:07:00 First C# Hello World Application 00:16:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 05 Interview Questions and Answers 00:04:00 Section 03: C# Basic Introduction 00:03:00 Variables 00:24:00 C# Identifiers 00:08:00 Data Types 00:08:00 Type Casting 00:14:00 User Inputs 00:10:00 Comments 00:03:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 03 Interview Questions and Answers 00:02:00 Summary 00:02:00 Section 04: C# Operators Introduction 00:02:00 Arithmetic Operators 00:09:00 Assignment Operators 00:03:00 Comparison Operators 00:03:00 Logical Operators 00:03:00 Strings 00:10:00 String Properties 00:08:00 Booleans 00:06:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 03 Interview Questions and Answers 00:04:00 Summary 00:02:00 Section 05: C# Statements Introduction 00:02:00 If Conditions and Statements 00:12:00 Switch-Case Statements 00:09:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 03 Interview Questions and Answers 00:04:00 Summary 00:02:00 Section 06: C# Control Flow Statements Introduction 00:02:00 While Loop Statement 00:07:00 Do-While Statement 00:03:00 For Loop Statement 00:07:00 Foreach Statement 00:06:00 Break and Continue 00:03:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 03 Interview Questions and Answers 00:02:00 Summary 00:01:00 Section 07: C# Arrays and Lists Introduction 00:01:00 Arrays 00:13:00 Loop Through Arrays 00:10:00 Lists 00:07:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 03 Interview Questions and Answers 00:02:00 Summary 00:02:00 Section 08: Working with File Structure Introduction 00:01:00 System.IO Namespace 00:03:00 File and File Info 00:11:00 Directory and Directory Info 00:08:00 Getting File Path Information 00:05:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 03 Interview Questions and Answers 00:03:00 Summary 00:03:00 Section 09: Working with Dates Introduction 00:02:00 Datetime 00:10:00 TimeSpan 00:06:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 Summary 00:02:00 Section 10: Debugging Applications Introduction 00:02:00 Debugging Tools in Visual Studio 00:13:00 Call Stack Window 00:04:00 Locals and Autos Windows 00:04:00 Summary 00:02:00 Section 11: What's Next? Bonus Lecture for What Next? 00:02:00 Assignment Assignment - Basic C# Coding 00:00:00

A step-by-step guide that walks you through the fundamentals of Python programming followed using Python libraries to create random forest from scratch. A comprehensive course designed for both beginners with some programming experience or even those who know nothing about ML and random forest!

This course delves into the world of solar energy, providing comprehensive knowledge about solar power systems, components, installation, and design. From the fundamentals of PV system construction to advanced concepts like charge controllers and solar water pumping, participants will acquire the skills needed to harness the potential of solar energy for various applications. Learning Outcomes: Understand the basics of solar energy, including solar heating, irradiation, and panel technologies. Analyze the effects of insolation and temperature on the V-I curve of solar panels. Perform PV system installations, short circuit, and open circuit tests using appropriate tools. Master the installation of solar wires, cables, and mounting techniques. Evaluate shading, tilt angles, and their impact on solar energy systems. Comprehend charge controllers' significance and differentiate between PWM and MPPT types. Apply half-cut cell technology and design solar systems using junction boxes and inverters. Design complete solar energy systems, including off-grid and on-grid configurations. Why buy this Solar Energy?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Solar Energy you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Solar Energy course is ideal for Students pursuing degrees in renewable energy, engineering, or related disciplines. Engineers and technicians seeking to enhance their skills in solar energy systems. Professionals in the construction industry interested in integrating solar solutions. Entrepreneurs looking to venture into the solar energy sector. Prerequisites This Solar Energy was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Solar Installer: £20,000 - £30,000 Solar Energy Technician: £25,000 - £35,000 Solar System Designer: £30,000 - £40,000 Renewable Energy Engineer: £35,000 - £50,000 Solar Energy Consultant: £40,000 - £60,000. Course Curriculum Unit 1- Basics of Solar Energy System Module 1- Introduction To PV System Construction 00:24:00 Module 2- Solar Heating, Solar Irradiation And Panels 00:38:00 Module 3- Effect of Insolation and Temperature on V-I Curve 00:05:00 Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer 00:15:00 Module 5- Solar Wires And Cables Installation Process 00:22:00 Module 6- Mounting Of PV System 00:04:00 Module 7- Shading and Tilt angle In Solar Energy 00:15:00 Module 8- Half Cut Cell Technology In PV System For Solar Engineering 00:25:00 Module 9- Importance Of Charge Controller In Solar Energy System 00:03:00 Module 10- PWM And MPPT Charge Controllers 00:14:00 Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course 00:24:00 Module 12- Junction Box In Solar Energy System 00:04:00 Module 13- Wiring of Junction Box In Solar Energy System 00:05:00 Module 14- Function, Types And Data Sheet Of Inverter 00:55:00 Module 15- Determining PV Array Maximum System Voltage 00:09:00 Unit 2- Batteries in PV System Module 1- Construction And Types Of Batteries In Solar Energy System 00:09:00 Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System 00:07:00 Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System 00:03:00 Module 4- Cycle of Batteries 00:04:00 Unit 3- Components and Design of Off Grid Solar Energy System Module 1- Off-Grid Solar System 00:02:00 Module 2- Advantages of Off-Grid Solar System 00:02:00 Module 3- Equipment of Off-Grid Solar System 00:04:00 Module 4- Selection and Datasheet of the Panel 00:04:00 Module 5- Inverter Selection 00:02:00 Module 6- Example 1 On Designing Off Grid System 00:01:00 Module 7- Determine Power Consumption Demands 00:04:00 Module 8- Size the PV modules 00:05:00 Module 9- Inverter sizing 00:04:00 Module 10- Battery Sizing 00:08:00 Module 11- Solar Charge Controller Sizing 00:05:00 Module 12- MPPT Charge Controller Sizing 00:10:00 Module 13- Example 2 Design of an OFF Grid System 00:20:00 Unit 4- Designing of ON Grid Solar Energy System Module 1- Grid-Tied Solar System 00:03:00 Module 2- Advantages of Grid-Tied Solar System 00:04:00 Module 3- Equipment of Grid-Tied Solar System 00:03:00 Module 4- Example Design of an On Grid System 00:10:00 Module 5- PV Energy According to Area 00:02:00 Unit 5- Design of PV System Using PVSyst Programme Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program 00:28:00 Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program 00:12:00 Module 3- Mega PV System Design Using PVSyst Program For Solar Energy 00:29:00 Unit 6- Solar Water Pumping System Module 1- Introduction To Water Pumping System And Steps Of Design 00:24:00 Module 2- Solved Example On Solar Pumping System Design 00:23:00 Unit 7- Protection of PV System Module 1- Introduction to Protection Of PV System 00:07:00 Module 2- Selection of Fuses and Protection of String 00:13:00 Module 3- Protection of Arrays 00:07:00 Module 4- Protection of Inverter 00:07:00 Module 5- Protection of Transformer 00:07:00 Module 6- Surge Protection Device 00:02:00 Module 7- Grounding of PV System 00:07:00 Module 8- Types of BusBars in PV System and Selection of BusBars 00:12:00 Unit 8- Design Using Excel Sheet Module 1-Design Of Off Grid PV System Using Excel Sheet 00:26:00 Unit 9- Single Line Diagram of PV System Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers 00:45:00 Unit 10- MATLAB and ETAP PV Simulation Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics 00:28:00 Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink 00:25:00 Module 3- PV System Simulation Using ETAP Lesson 00:24:00 Assignment Assignment - Solar Energy 00:00:00

Start your data science journey with this carefully constructed comprehensive course and get hands-on experience with Python for data science. Gain in-depth knowledge about core Python and essential mathematical concepts in linear algebra, probability, and statistics. Complete data science training with 13+ hours of content.

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? Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. 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

This course is designed to help you understand the basic and advanced concepts of ethical hacking with ease. The course features interesting examples and coding activities in each video to keep you engaged and guides you effectively through writing programs to hack a system.

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Career path Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Join our Renewable Energy: Solar course and discover your hidden skills, setting you on a path to success in this area. Get ready to improve your skills and achieve your biggest goals. The Renewable Energy: Solar course has everything you need to get a great start in this sector. Improving and moving forward is key to getting ahead personally. The Renewable Energy: Solar course is designed to teach you the important stuff quickly and well, helping you to get off to a great start in the field. So, what are you looking for? Enrol now! You will Learn The Following Things: Learn strategies to boost your workplace efficiency. Hone your skills to help you advance your career. Acquire a comprehensive understanding of various topics and tips. Learn in-demand skills that are in high demand among UK employers This course covers the topic you must know to stand against the tough competition. The future is truly yours to seize with this Renewable Energy: Solar. Enrol today and complete the course to achieve a certificate that can change your career forever. Details Perks of Learning with IOMH One-to-one support from a dedicated tutor throughout your course. Study online - whenever and wherever you want. Instant Digital/ PDF certificate 100% money back guarantee 12 months access Process of Evaluation After studying the course, an MCQ exam or assignment will test your skills and knowledge. You have to get a score of 60% to pass the test and get your certificate. Certificate of Achievement After completing the Renewable Energy: Solar course, you will receive your CPD-accredited Digital/PDF Certificate for £5.99. To get the hardcopy certificate for £12.99, you must also pay the shipping charge of just £3.99 (UK) and £10.99 (International). Who Is This Course for? This Renewable Energy: Solar is suitable for anyone aspiring to start a career in relevant field; even if you are new to this and have no prior knowledge, this course is going to be very easy for you to understand.  On the other hand, if you are already working in this sector, this course will be a great source of knowledge for you to improve your existing skills and take them to the next level.  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 There is no prerequisite to enrol in this course. You don't need any educational qualification or experience to enrol in the Renewable Energy: Solar 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 course. Career Path The certification and skills you get from this Renewable Energy: Solar Course can help you advance your career and gain expertise in several fields, allowing you to apply for high-paying jobs in related sectors. Course Curriculum Unit 1- Basics of Solar Energy System Module 1- Introduction To PV System Construction 00:24:00 Module 2- Solar Heating, Solar Irradiation And Panels 00:38:00 Module 3- Effect of Insolation and Temperature on V-I Curve 00:05:00 Module 4- PV Installation, Short Circuit And Open Circuit Tests Using Avometer 00:15:00 Module 5- Solar Wires And Cables Installation Process 00:22:00 Module 6- Mounting Of PV System 00:04:00 Module 7- Shading and Tilt angle In Solar Energy 00:15:00 Module 8- Half Cut Cell Technology In PV System For Solar Engineering 00:25:00 Module 9- Importance Of Charge Controller In Solar Energy System 00:03:00 Module 10- PWM And MPPT Charge Controllers 00:14:00 Module 11- Understanding More about MPPT Solar Charge Controller For Solar Energy Course 00:24:00 Module 12- Junction Box In Solar Energy System 00:04:00 Module 13- Wiring of Junction Box In Solar Energy System 00:05:00 Module 14- Function, Types And Data Sheet Of Inverter 00:55:00 Module 15- Determining PV Array Maximum System Voltage 00:09:00 Unit 2- Batteries in PV System Module 1- Construction And Types Of Batteries In Solar Energy System 00:09:00 Module 2- Charging Of Lead Acid Batteries And Hydrometer In Solar Energy System 00:07:00 Module 3- Maintenance Of Batteries And Methods Of Charging In Solar Energy System 00:03:00 Module 4- Cycle of Batteries 00:04:00 Unit 3- Components and Design of Off Grid Solar Energy System Module 1- Off-Grid Solar System 00:02:00 Module 2- Advantages of Off-Grid Solar System 00:02:00 Module 3- Equipment of Off-Grid Solar System 00:04:00 Module 4- Selection and Datasheet of the Panel 00:04:00 Module 5- Inverter Selection 00:02:00 Module 6- Example 1 On Designing Off Grid System 00:01:00 Module 7- Determine Power Consumption Demands 00:04:00 Module 8- Size the PV modules 00:05:00 Module 9- Inverter sizing 00:04:00 Module 10- Battery Sizing 00:08:00 Module 11- Solar Charge Controller Sizing 00:05:00 Module 12- MPPT Charge Controller Sizing 00:10:00 Module 13- Example 2 Design of an OFF Grid System 00:20:00 Unit 4- Designing of ON Grid Solar Energy System Module 1- Grid-Tied Solar System 00:03:00 Module 2- Advantages of Grid-Tied Solar System 00:04:00 Module 3- Equipment of Grid-Tied Solar System 00:03:00 Module 4- Example Design of an On Grid System 00:10:00 Module 5- PV Energy According to Area 00:02:00 Unit 5- Design of PV System Using PVSyst Programme Module 1- Design of an Off Grid Solar Energy System Using PVSYST Program 00:28:00 Module 2- Design Of An On Grid Solar Energy System Using PVSyst Program 00:12:00 Module 3- Mega PV System Design Using PVSyst Program For Solar Energy 00:29:00 Unit 6- Solar Water Pumping System Module 1- Introduction To Water Pumping System And Steps Of Design 00:24:00 Module 2- Solved Example On Solar Pumping System Design 00:23:00 Unit 7- Protection of PV System Module 1- Introduction to Protection Of PV System 00:07:00 Module 2- Selection of Fuses and Protection of String 00:13:00 Module 3- Protection of Arrays 00:07:00 Module 4- Protection of Inverter 00:07:00 Module 5- Protection of Transformer 00:07:00 Module 6- Surge Protection Device 00:02:00 Module 7- Grounding of PV System 00:07:00 Module 8- Types of BusBars in PV System and Selection of BusBars 00:12:00 Unit 8- Design Using Excel Sheet Module 1-Design Of Off Grid PV System Using Excel Sheet 00:26:00 Unit 9- Single Line Diagram of PV System Module 1- Single Line Diagram Of PV System And Selection Of Fuses And Breakers 00:45:00 Unit 10- MATLAB and ETAP PV Simulation Module 1- Simulation Of PV Cell In MATLAB And Obtaining V-I Characteristics 00:28:00 Module 2- Get a Complete Grid Connected PV Solar Energy System In MATLAB Simulink 00:25:00 Module 3- PV System Simulation Using ETAP Lesson 00:24:00

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

Microblading Online Course What is Microblading? Microblading is a tattooing technique in which a small handheld tool made of several tiny needles is used to add semi-permanent pigment to the skin. Course Content History of Microblading Health & Safety at work How to do a risk assessment Preventing Legionella Control of substances hazardous to health regulations 2002 (COSHH) Code of Practice for hygiene in beauty salons The appearance of the therapist Sterilisation and disinfection The manual handling operations regulations 1992 Ergonomics The personal protective equipment at work regulations 1992 The provisions and use of work equipment regulations 1992 The Provisions and use of work equipment regulations 1998 The environmental protection act 1990 Safe disposal of sharps Tattoo regulations act W.E.E.E regulations 2006 The regulatory reform (fire safety) order 2005 Types of fire extinguishers The reporting or injuries, diseases and dangerous occurrences regulations 1995 Health and safety first aid regulations 1981 Electricity at work regulations 1989 Public liability and employers liability insurance The local authority licensing application Effective cleaning Types of cleaning agents Bloodborne pathogens Gloves Handwashing techniques Bloodborne pathogens policy and procedure Why clients may want Permanent Makeup Client satisfaction Equipment you will need Microblading consultation form Topical anaesthetic form Pre-procedure advice Permanent cosmetics aftercare Patch testing Contraindications Contra-actions Anatomy of skin Wound healing Lymphatic system Cardiovascular system Eyebrow symmetry Pigments Colour theory Colour correction/removal Trouble shootingTroubleshooting Skin tones Skin undertone test Colour changes Needle configuration Needle depths Microblading tools Anaesthetics Microblading information Worksheets Training Kit if purchased 2 x Pigment 1 x Piece Microblading Manual Pen 3 x Piece Eyebrow Practice Skin 1 x Piece Mapping String 1 x Piece Eyebrow Pen 3 x Sticky Stencil Ruler 5 x Pieces Microblading Needles 4 x Alcohol Pads 4 x Mixing Rings 4 x Mixing Swabs 4 x Mascara Wands 3 x Aftercare creams Certificate You will receive an end of course certificate which is accredited by the CPD Group and allows you to work in public. How do Online Courses work? http://www.kbhtrainingacademy.com/online-courses Duration of Course? You will have 6 months to complete the course before it expires. Will I require a model? Yes, 3 cases of studies are required to complete all of the required case studies. Are there video tutorials? Yes, you will have links to YouTube and training videos to watch the treatment being performed. Do I Need Experience Before Booking a Course? We’re pleased to offer courses to people with lots of different experiences. However, previous experience, nor qualifications are not necessary if you would like to enrol on our Course. We do however suggest our Eyebrow Shaping Course. Do you offer finance? http://www.kbhtrainingacademy.com/finance