25252 Courses delivered Online

Intro to SQL training course description A hands on course focusing on the use of SQL. In particular this course does not concentrate on any particular version of SQL but rather enables delegates to recognise the differences found in SQL on different platforms. What will you learn Explain the difference between standard SQL and different flavours. Use SQL statements to query databases. Use SQL statements to define databases. Intro to SQL training course details Who will benefit: Anyone working with databases. Prerequisites: None. Duration 2 days Intro to SQL training course contents What is SQL? What is SQL? History, standards, What is SQL used for? Dialects, ANSI SQL, PL/SQL, Transact SQL, front ends. Database basics RDBMS, Tables. Hands on Investigating a database. Basic SQL commands SQL Overview: SQL DML, SQL DDL, SQL queries. SELECT, WHERE and ORDER BY clauses. Combining conditions. IN, LIKE and BETWEEN. Hands on Querying a database from existing tables. SQL data retrieval Scalar functions. Hands on Selecting data from an existing database. More SQL data retrieval Scalar functions, variations. Aggregate functions, GROUP BY. HAVING. Hands on Selecting data from an existing database. Table joins Multiple tables, joins, keys, inner joins, left joins, right joins. Hands on Selecting data from an existing database. SQL basic data manipulation INSERT, UPDATE, MERGE, DELETE. Transaction controls: COMMIT, ROLLBACK. Hands on Modifying data in tables. SQL Data Definition USE, CREATE, DROP, TRUNCATE, ALTER. Hands on Managing new tables and columns. Data control GRANT, REVOKE. Hands on Defining permissions.

This week long CPD accredited training is ideal for those Real Estate professionals, who are looking to bolster the DCF modelling skills. This course covers Real Estate Investment, Development, Finance & Risk.

Introduction to watercolour Artist-taught watercolour course that will get you inspired and confident to practise with this wonderful medium!

Live online course with study materials and certificate of completion included This beginner's WordPress course will enable you to create your own website using the world's favourite content management system. The user friendly web based software enables you to quickly and easily get your website up and running. This one day course will teach you how to write, edit and manage your WordPress site and also to use image, audio and video content. Whether you are seeking to learn WordPress for your own personal posts or for business and marketing purposes this course will get you up and running right away. Resources Introduction to WordPress Description Completing this course will enable you to do the following and more: Become familiar with the WordPress CMS Install and configure WordPress Manage WordPress themes Understand the WP interface and the dashboard Add users and assigning different user roles Set-up reading options Create, add, update and assign menus Understand Posts and Pages Edit and format content Use the Gutenberg block editor Create and manage your homepage Carry out customisations Understand SEO optimisation For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wishes to learn how to create and manage websites with WordPress. No previous knowledge or experience of WordPress is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included

How to safely use an AED CPD Accredited, Interactive Short Course (via Zoom) 1½ hr courseLearn how to use an AED safelyAED: Automated External DefibrillatorLearn from the comfort of your own home, great for CPD Course Contents The Chain of Survival How to give CPR DR ABC Introduction to an AED Aspects of an AED Safety aspects of using an AED How to use an AED on an adult, child and infant/baby Please note: this course is aimed as a reminder of how to provide first aid, not a first time training session. Giving CPD especially needs to be taught in person, with lots of chances to practice Benefits of this Short Course There are over 30,000 out-of-hospital cardiac arrests a year But just 1 out of 10 survive Improved help by the public, and access to defibrillators (AEDs) gives a higher chance of survival Learn how to use an AED and (potentially) save someone's life when it matters most This could be a friend or even a loved one...

Get hands-on with our Introduction to Handyperson and Electrical Work course. Learn basic repairs, electrical safety, wiring principles, and valuable skills for home maintenance.

Advanced Swift 4 Design Patterns with Reactive Programming with RxSwift.

🚀 Introduction to Coaching Course: Unlock Your Coaching Potential! 🌟 Discover the art of coaching with our CPD Accredited 'Introduction to Coaching' course. 🎓 Gain insights into the GROW Model, motivation techniques, and advanced questioning skills. Ideal for aspiring coaches and professionals seeking career development.

The comprehensive Introduction to Arduino has been designed by industry experts to provide learners with everything they need to enhance their skills and knowledge in their chosen area of study. Enrol on the Introduction to Arduino today, and learn from the very best the industry has to offer! This best selling Introduction to Arduino has been developed by industry professionals and has already been completed by hundreds of satisfied students. This in-depth Introduction to Arduino is suitable for anyone who wants to build their professional skill set and improve their expert knowledge. The Introduction to Arduino is CPD-accredited, so you can be confident you're completing a quality training course will boost your CV and enhance your career potential. The Introduction to Arduino is made up of several information-packed modules which break down each topic into bite-sized chunks to ensure you understand and retain everything you learn. After successfully completing the Introduction to Arduino, you will be awarded a certificate of completion as proof of your new skills. If you are looking to pursue a new career and want to build your professional skills to excel in your chosen field, the certificate of completion from the Introduction to Arduino will help you stand out from the crowd. You can also validate your certification on our website. We know that you are busy and that time is precious, so we have designed the Introduction to Arduino to be completed at your own pace, whether that's part-time or full-time. Get full course access upon registration and access the course materials from anywhere in the world, at any time, from any internet-enabled device.  Our experienced tutors are here to support you through the entire learning process and answer any queries you may have via email.

Live online course with study materials and certificate of completion included This HTML course will provide you with an easy to follow, hands-on introduction to HTML and CSS, the basic coding languages which drive the internet. Participants will learn how to create an attractive and well-structured web page using basic HTML and CSS. This workshop is highly recommended for anyone wishing to learn how to create websites and also for people who already use applications such as Dreamweaver or WordPress and need more control over their web output. Resources Introduction to HTML & CSS Course Information Description Completing this course will enable you to do the following and more: Understand what HTML and CSS are and how they work together Learn basic HTML elements Learn how to create hyperlinks Work with images Use DIVs, forms and lists to arrange content Create page structure Use Cascading Style Sheets to control the layout and look of HTML elements Use Developer Tools to preview CSS changes Know how and when to use Inline CSS Create code that is both readable, compliant with HTML5 standards Understand what makes good SEO For the full course content please download the course information pdf listed above. Who is this course for? This workshop is suitable for anyone with basic PC or Mac skills who wants to understand how the web works. No previous knowledge or experience of HTML or CSS is necessary. Requirements Attendees should have basic PC or Mac skills. You will need a broadband internet connection to participate in this live online course. Certificates Certificate of completion Digital certificate - Included