Software courses delivered Online

SQL Queries Course, 1-Day. Basic SQL syntax. This course is good for any database, covering standard SQL. Most attendees are in-work IT Professional. Private individuals are also very welcome.

Practical SQL Advanced Intensive Course , exploring the advanced and less commonly used SQL Statements and techniques. We also learn Data Definition Language and Data Manipulation Language statements. as well as course automation of queries using T-SQL. Hands-on, Practical SQL Advanced Course. PCWorkshops SQL Advanced Course Certificate. Max 4 people per course; we keep it personalised.

At this Oracle SQL Fundamentals course, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom functions, and table variables. Course level is beginners to intermediate.

This Renewables Technical Surveying training short two day course is specifically designed for individuals and companies that want to train themselves and their staff on exactly how to carry out Renewables Technical Site Surveying prior to any renewables installation measures, this includes for heating systems, solar systems and EV Charge point installations. The course is primarily aimed at Energy Suppliers, Equipment Manufacturers, Renewable Installers, Domestic Energy Assessors, Retrofit Assessors, Retrofit Co-ordinators, Renewables sales staff and suitable individuals with a basic level of knowledge in varying building structures, heating systems and varying renewable technologies.

Duration 1 Days 6 CPD hours This course is intended for Looking for a way to extend your business operations? Look no further than the App in a Day workshop! In this one day course you will learn to build a custom, secure business application that you can share across your organise and will run across multiple platforms including tablets and mobile devices. Power Platform is a secure and scalable platform for building your own applications. In this course, you will learn how to build an application from the ground up by building the required UX, Backend, and frontend. All this without writing any code. Overview Some of the applications of the Power Platform you will learn to build will allow you to potentially: A) Share information with trusted colleagues and associates B) Monitor and manage your business operations C) Monitor and manage your customers D) Share business news on social media E) Share business photos and footage This course will teach you how to build your own application that is completely secure and private. Power Apps Canvas App Connect to data sources and filter results based on specified criteria Work with screens and navigation Use controls, properties, formulas, and actions to customize the user experience Display the logged in user?s name Configure app settings Save and share an app Run an app on a mobile device Microsoft Dataverse Create and customize a custom table Use the Form control Save data into the Microsoft Dataverse using the Form control Microsoft Dataverse Create a standalone Model-driven app. Customize forms for the Model-driven app Use a Business Process Flow to guide users through a process Microsoft Dataverse Create a flow that is triggered when a new Microsoft Dataverse row is created Automate sending approval requests Customize the approval based on the Microsoft Dataverse row Use the Approval centre

PYTHON BOOTCAMP: This 12-week Python Data Analytics Data Boot Camp is designed to give you a complete skill set required by data analysts . You will be fully fluent and confident as a Python data analyst, with full understanding of Python Programming. From Data, databases, datasets, importing, cleaning, transforming, analysing to visualisation and creating awesome dashboards The course is a practical, instructor-lead program.

Python Unittest Course Summary. Testing plays a major role in software development. This course will explain Python Unit Testing using the unittest built-in module. We'll cover issues before going to the production itself and the basics of testing in Python. Location: Instructor-led, Online. Our Style: Hands-on, Practical Course. Group Size: Max 4 people per group. Qualification: PCWorkshops Unittest Certification Duration: 1-Day, 10am-5pm Unittest topics UnitTest Framework - Home UnitTest Framework - Overview UnitTest - Framework UnitTest - API UnitTest - Assertion UnitTest - Test Discovery UnitTest - Skip Test UnitTest - Exceptions Test UnitTest - Time Test UnitTest - Unittest2 UnitTest - Signal Handling UnitTest - Doctest UnitTest - Doctest API UnitTest - Py.test Module Nose Testing - Framework Nose Testing - Tools Included with Python Unittest Course Python Unittest Certificate on completion Python Unittest Videos Python Unittest Notes Python Unittest Examples Practical Python Unittest exercises

Python Data Analytics with Python using Numpy, Pandas, Dataframes. Most attendees are in-work Data Professional. Private individuals are very welcome. Our Style: Hands-on, Practical Location: Online, Instructor-led

Android Studio Taster Course. Brilliant for a beginner to get started quickly. introduction to the Android Studio environment, to get you started. An interesting and fun session. Hands-on, Practical Course, Instructor-led. 1 hour In our London classroom or online with Gotomeeting.com

Learn the essentials of software development. And increase your confidence when working with developers. Why take this course? Talk with confidence about web and internet technologies Build better relationships with developers on your team Create smarter designs with a deeper understanding of technical constraints Understand the concepts behind coding without needing to code Who is it for? All UX professionals Format Online, self-paced Duration 6 weeks (recommended) Commitment 3 hours per week What you’ll learn Over 6 weeks, you’ll learn about the key concepts and processes involved in software development. You'll understand how code works, so that you can collaborate more effectively with developers. Module 1 The software landscape Understand the relationship between hardware and software. Module 2 Layers of software Dig into each layer of the tech stack, from the front-end to the back-end. Module 3 Front-end technologies Get up to speed on the roles of HTML, CSS and Javascript. Module 4 Back-end technologies Explore the back-end, APIs and common programming languages. Module 5 How developers work Learn about common development workflows, from waterfall to agile. Module 6 Effective collaboration Get practical guidance on how to work well with development teams.