• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

572 Courses

IPAF Operator - eLearning theory module

By Kingfisher Access

MEWP OPERATOR ELEARNING IPAF’s eLearning for MEWP operators is available for all MEWP categories (1a, 1b, 3a, 3b) and takes around three hours to complete. The eLearning is broken down into manageable sections that you can complete at your own pace and can save and resume your training at any time. IPAF MEWP Operator eLearning training course is available in English, Dutch, French, German, Italian, Portuguese and Spanish.

IPAF Operator - eLearning theory module
Delivered Online On Demand3 hours
£50

Python Boot Camp, 12-weeks

4.6(12)

By PCWorkshops

Python Data Analytics boot camp. 12 1 day lessons, learn Python Basics through to machine learning and front-ends. With practical project to give you full confidence and credibility.

Python Boot Camp, 12-weeks
Delivered In-Person in London + more
£1,800

AUTHORISED ECONOMIC OPERATOR (AEO)

By Export Unlocked Limited

This module aims to develop knowledge and understanding of the status of an authorised economic operator in the export and in import of goods. This includes the advantages of the status, trusted trader, and the process securing the authorised economic operator status.

AUTHORISED ECONOMIC OPERATOR (AEO)
Delivered in Oldham or Online + more
£395

Marginal Field Development and Planning

By EnergyEdge - Training for a Sustainable Energy Future

Enhance your knowledge in marginal field development and planning with EnergyEdge's course. Enroll now to gain valuable insights.

Marginal Field Development and Planning
Delivered In-Person
£3,699 to £3,799

CCTV Operator Training

5.0(5)

By Wimbledon Training Services

This course is a legal requirement to obtain the SIA CCTV Licence which enables you to work as a CCTV (Closed Circuit Television) operator. CCTV Operatives usually work in a control room that is connected to a network of CCTV equipment. Employers typically include security companies, medium-large corporations, local authorities, the police, etc.

CCTV Operator Training
Delivered In-Person in WimbledonFlexible Dates
£240

Java Bootcamp, 12-weeks

4.6(12)

By PCWorkshops

Full stack, in depth , comprehensive in classroom 3 month training on Java programming. 1 lesson a week, the other days you work on your own on structured homework and supported with a 1-1 mentor.

Java Bootcamp, 12-weeks
Delivered In-Person in London + more
£2,100

EnergyEdge offers classroom training on EP technical services contracts to boost your knowledge and skills. Enroll now!

E&P Technical Services Contract
Delivered In-Person
£2,299 to £2,399

55366 Querying Data with Transact-SQL

By Nexus Human

Duration 5 Days 30 CPD hours This course is intended for This course is intended for novice database developers, database administrators, Business Intelligence developers, report creators, and application developers who have an understanding of relational database concepts and have basic Windows navigation skills. Overview Create single table SELECT queries Create multiple table SELECT queries Filter and sort data Insert, update, and delete data Query data using built-in functions Create queries that aggregate data Create subqueries Create queries that use table expressions Use UNION, INTERSECT, and EXCEPT on multiple sets of data Implement window functions in queries Use PIVOT and GROUPING SETS in queries Use stored procedures in queries Add error handling to queries Use transactions in queries This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join data from multiple tables, filter and sort data, modify data, use procedures and functions, and implement error handling. Prerequisites Basic understanding of relational databases. Basic Windows knowledge. Module 1: Introduction to Transact-SQL What is Transact-SQL The SELECT statement The WHERE clause Sorting results Calculations CASE expressions Module 2: Joining tables with Transact-SQL The JOIN clause Inner joins Outer joins Self joins and cross joins Module 3: Filtering and sorting results Implement the ORDER BY clause Filter data with the WHERE clause Limit the number of rows returned by a query Implement NULL logic Module 4: SQL Server data types Understand data types Implement string data types Implement temporal data types Module 5: Inserting, updating and deleting data Insert new records Update existing records Delete data Module 6: Using SQL Server functions with Transact-SQL Understand function types in SQL Server Convert data using functions Implement logical functions Work with NULL data using functions Module 7: Aggregating data with Transact-SQL Implement aggregation in SQL Server Group records in SQL Server Filter aggregated data Module 8: Implement subqueries with Transact-SQL Implement scalar and multi-valued sub-queries Implement correlated subqueries Implement existence checks with subqueries Module 9: Create queries that use table expressions Create views Create table-valued functions Implement derived tables Implement common table expressions Module 10: Use UNION, INTERSECT, EXCEPT and APPLY on multiple sets of data Write queries with the UNION operator Write queries with the INTERSECT and EXCEPT operators Write queries with the APPLY operator Module 11: Implement window functions in queries Understand window functions Impement window functions Module 12: Use PIVOT and grouping sets in queries Implement PIVOT in queries Implement grouping sets in queries Module 13: Use stored procedures in queries Query data with stored procedures Interact with stored procedures using input and output parameters Write simple stored procedures Pass dynamic SQL to SQL Server Module 14: Implement programming features in Transact-SQL Understand T-SQL programming elements Implement loops and conditions in T-SQL queries Module 15: Add error handling to queries Understand SQL Server error handling Implemet structured exception handling Module 16: Use transactions in queries Understand database transactions Implement transactions in T-SQL

55366 Querying Data with Transact-SQL
Delivered Online
£2,976

CCTV Operator Course

4.8(9)

By Skill Up

Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step

CCTV Operator Course
Delivered Online On Demand6 hours 23 minutes
£25

CCTV Operator Course

4.5(3)

By Studyhub UK

Embark on a journey into the world of surveillance with our comprehensive 'CCTV Operator Course.' In Module 01, delve into the operational requirements that lay the foundation for effective surveillance, setting the stage for an in-depth exploration. As you progress to Module 02, hone your skills and abilities as a CCTV operator, mastering the art of vigilant observation. Modules 03 and 04 unravel the intricacies of CCTV technology, providing a solid technical foundation to navigate the surveillance landscape. Module 05 and Module 06 transform you into a watchful guardian, teaching the nuances of monitoring cameras and conducting surveillance with precision. Data protection takes the spotlight in Module 07, ensuring you understand the regulations that govern your crucial role. Finally, Module 08 unveils the job requirements of a CCTV operator, equipping you for a fulfilling career in surveillance. Learning Outcomes Understand the operational requirements that form the backbone of effective surveillance. Hone essential skills and abilities crucial for success as a vigilant CCTV operator. Acquire a solid understanding of the basics of CCTV technology. Receive technical guidance to navigate and troubleshoot CCTV systems. Master the art of monitoring CCTV cameras, conducting watchful surveillance with precision. Why choose this CCTV Operator 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 CCTV Operator Course for? Individuals aspiring to pursue a career as a CCTV operator. Security professionals aiming to enhance their surveillance skills. Job seekers interested in roles related to security and surveillance. Entrepreneurs or business owners looking to bolster their premises' security. Students with an interest in technology and surveillance systems. Career path CCTV Operator: £20,000 - £30,000 Surveillance Specialist: £25,000 - £35,000 Security Supervisor: £22,000 - £32,000 Loss Prevention Officer: £18,000 - £28,000 Security Consultant: £30,000 - £45,000 Corporate Security Manager: £35,000 - £50,000 Prerequisites This CCTV Operator Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This CCTV Operator Course was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8. Course Curriculum Module 01: Operational Requirement Operational Requirement 00:12:00 Module 02: CCTV Operator Skills and Ability CCTV Operator Skills and Ability 00:11:00 Module 03: Basics of CCTV Basics of CCTV 00:10:00 Module 04: Technical Guidance Technical Guidance 00:09:00 Module 05: Monitoring CCTV Cameras Monitoring CCTV Cameras 00:10:00 Module 06: Watch Surveillance Watch Surveillance 00:09:00 Module 07: Data Protection Regulations Data Protection Regulations 00:10:00 Module 08: Job Requirements of a CCTV Operator Job Requirements of a CCTV Operator 00:10:00 Assignment Assignment - CCTV Operator Course 00:00:00

CCTV Operator Course
Delivered Online On Demand1 hour 21 minutes
£10.99