1575 Running courses in Liverpool delivered Online

Duration 3 Days 18 CPD hours This course is intended for This course is intended for information workers and data science professionals who seek to use database reporting and analysis tools such as Microsoft SQL Server Reporting Services, Excel, Power BI, R, SAS and other business intelligence tools, and wish to use TSQL queries to efficiently retrieve data sets from Microsoft SQL Server relational databases for use with these tools. Overview After completing this course, students will be able to: - Identify independent and dependent variables and measurement levels in their own analytical work scenarios. - Identify variables of interest in relational database tables. - Choose a data aggregation level and data set design appropriate for the intended analysis and tool. - Use TSQL SELECT queries to produce ready-to-use data sets for analysis in tools such as PowerBI, SQL Server Reporting Services, Excel, R, SAS, SPSS, and others. - Create stored procedures, views, and functions to modularize data retrieval code. This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. 1 - INTRODUCTION TO TSQL FOR BUSINESS INTELLIGENCE Two Approaches to SQL Programming TSQL Data Retrieval in an Analytics / Business Intelligence Environment The Database Engine SQL Server Management Studio and the CarDeal Sample Database Identifying Variables in Tables SQL is a Declarative Language Introduction to the SELECT Query Lab 1: Introduction to TSQL for Business Intelligence 2 - TURNING TABLE COLUMNS INTO VARIABLES FOR ANALYSIS: SELECT LIST EXPRESSIONS, WHERE, AND ORDER BY Turning Columns into Variables for Analysis Column Expressions, Data Types, and Built-in Functions Column aliases Data type conversions Built-in Scalar Functions Table Aliases The WHERE clause ORDER BY Lab 1: Write queries 3 - COMBINING COLUMNS FROM MULTIPLE TABLES INTO A SINGLE DATASET: THE JOIN OPERATORS Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSS JOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNER JOIN Understanding Joins, Part 3: The OUTER JOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTER JOINs Combining JOIN Operations with WHERE and ORDER BY Lab 1: Write SELECT queries 4 - CREATING AN APPROPRIATE AGGREGATION LEVEL USING GROUP BY Identifying required aggregation level and granularity Aggregate Functions GROUP BY HAVING Order of operations in SELECT queries Lab 1: Write queries 5 - SUBQUERIES, DERIVED TABLES AND COMMON TABLE EXPRESSIONS Non-correlated and correlated subqueries Derived tables Common table expressions Lab 1: Write queries 6 - ENCAPSULATING DATA RETRIEVAL LOGIC Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Lab 1: Encapsulating Data Retrieval Logic 7 - GETTING YOUR DATASET TO THE CLIENT Connecting to SQL Server and Submitting Queries from Client Tools Connecting and running SELECT queries from: Excel PowerBI RStudio Exporting datasets to files using Results pane from SSMS The bcp utility The Import/Export Wizard Lab 1: Getting Your Dataset to the Client Additional course details: Nexus Humans 55232 Writing Analytical Queries for Business Intelligence 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 55232 Writing Analytical Queries for Business Intelligence 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.

About this Training Course On a day-to-day basis, one of the most common technologies utilised in well intervention is Coiled Tubing. This is prevalent in the oil industry and the technology is used during drilling, completion and production phases of Oil & Gas wells worldwide. This 5 full-day course will look at the following areas: Equipment for surface and pressure control Assembly components for bottom-hole Details of the different types of interventions performed with Coiled Tubing, and How to deal with fatigue and corrosion. The aim of this course is to enable the participants to gain key knowledge that they will require to actively and efficiently participate in the planning, design, and / or execution of a Coiled Tubing intervention. With this, the participants will learn how to calculate the string operating limits and the volumes and rates during nitrogen interventions. The course will walk the participants through the emergency responses and contingencies to deal with in various scenarios. Time will be allocated for the participants to work on the practical exercises as well as real field cases and problems. This course can also be offered through Virtual Instructor Led Training (VILT) format. Training Objectives By the end of the course, the participants will be able to: Plan, design, manage and execute interventions for Coiled Tubing Enhance operational performance during interventions for Coiled Tubing Explain the recommended equipment for various Coiled Tubing field conditions and applications Discuss the proper pressure control equipment for any particular well condition Learn about the most commonly used downhole tools and explain their function Understand how to calculate and define string limits for Coiled Tubing Learn how to work safely with liquid nitrogen Target Audience This course is aimed at Drilling and completion engineers Production engineers Surface/subsurface engineers Operations engineers Service company managers Field engineers This course will also benefit professionals who would like to increase their knowledge in the planning, design and/or execution of Coiled Tubing and Liquid Nitrogen interventions. Course Level Basic or Foundation Training Methods Other than the daily quizzes to reinforce the materials presented in the session, the participants will work through exercises such as: Selecting suitable BHAs for various operations Rigging up equipment in the correct order and preparing an outline testing programme Carrying out suitable calculations to perform an N2 lift Preparing an outline programme for a balanced cement plug Identifying issues in various videos & photos and suggesting mitigations Basic N2 safety quiz Final exercise will be preparing an outline programme for a Proppant Clean out, including a detailed Risk Register and Mitigation options Trainer Your expert course instructor has over 40 years of experience in the Oil & Gas industry. During that time, he has worked exclusively in well intervention and completions. After a number of years working for intervention service companies (completions, slickline & workovers), he joined Shell as a well service supervisor. He was responsible for the day-to-day supervision of all well intervention work on Shell's Persian/Arabian Gulf platforms. This included completion running, coil tubing, e-line, slickline, hydraulic workovers, well testing and stimulation operations. An office-based role as a senior well engineer followed. He was responsible for planning, programming and organising of all the well engineering and intervention work on a number of fields in the Middle East. He had a brief spell as a Site Representative for Santos in Australia before joining Petro-Canada as Completions Superintendent in Syria, then moved to Australia as Completions Operations Superintendent for Santos, before returning to Shell as Field Supervisor Completions and Well Interventions in Iraq where he carried out the first ever formal abandonment of a well in the Majnoon Field. While working on rotation, he regularly taught Completion Practices, Well Intervention, Well Integrity and Reporting & Planning courses all over the world. In 2014, he started to focus 100% on training and became the Technical Director for PetroEDGE. Since commencing delivering training courses in 2008, he has taught over 300 courses in 31 cities in 16 countries to in excess of 3,500 participants. POST TRAINING COACHING SUPPORT (OPTIONAL) To further optimise your learning experience from our courses, we also offer individualized 'One to One' coaching support for 2 hours post training. We can help improve your competence in your chosen area of interest, based on your learning needs and available hours. This is a great opportunity to improve your capability and confidence in a particular area of expertise. It will be delivered over a secure video conference call by one of our senior trainers. They will work with you to create a tailor-made coaching program that will help you achieve your goals faster. Request for further information post training support and fees applicable Accreditions And Affliations

Level 3 & 7 Endorsed Diploma | QLS Hard Copy Certificate Included | Plus 5 CPD Courses | Lifetime Access

Basic Python syntax and principles of Object Orientated Programming. Most attendees are in-work IT Professional. Private individuals are also very welcome. Evening courses also running. Our Style: Hands-on, Practical Location: Online, Instructor-led Download: anaconda.com Duration: 6 weeks, 1 evening per week, 6pm - 8pm Times: arrange a time for your time zone

Linux Troubleshooting and Administration

Description Register on the AutoCAD Plugin Development Using VB.NET and Windows Forms 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 a certificate as proof of your course completion. The AutoCAD Plugin Development Using VB.NET and Windows Forms course is incredibly great value and allows you to study at your own pace. Access the course modules from any internet-enabled device, including computers, tablets, 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 This Course Receive a digital 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) Certificate of Achievement After the successful completion of the final assessment, you will receive a CPD-accredited certificate of achievement. The PDF certificate is for 9.99, and it will be sent to you immediately after through e-mail. You can get the hard copy for 15.99, which will reach your doorsteps by post.  Method of Assessment You need to attend an assessment right after the completion of this course to evaluate your progression. For passing the assessment, you need to score at least 60%. After submitting your assessment, you will get feedback from our experts immediately. Who Is This Course For The course is ideal for those who already work in this sector or are aspiring professionals. 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.   Course Content Course Outline Landing Page 00:02:00 Course Outline 00:03:00 Introduction Introduction 00:05:00 Who is this course for? 00:04:00 Tools Needed for this Course 00:01:00 What will you learn from this Course? What will you learn from this Course - Overview 00:06:00 Windows Form and Controls Windows Form and Controls - Overview 00:04:00 ControlsDemo Project - Overview 00:03:00 ControlsDemo Project - Creating the Project 00:04:00 Controls Demo Project - Designing the Form 00:19:00 ControlsDemo Project - Creating the Utility Class 00:10:00 ControlsDemo Project - Coding the Combobox Control 00:15:00 ControlsDemo Project - Coding the Textbox Control 00:10:00 ControlsDemo Project - Coding the Radiobutton Control 00:08:00 ControlsDemo Project - Coding the Checkbox Control 00:17:00 Developing Projects Draw Rectangle Project - Overview 00:03:00 Creating the DrawRectangle Project 00:04:00 DrawRectangle Project - Creating the Utility Class 00:20:00 DrawRectangle Project - Designing the Form 00:15:00 DrawRectangle Project - Coding the User Interface Part 1 00:24:00 DrawRectangle Project - Coding the User Interface Part 2 00:18:00 DrawRectangle Project - Running the Program 00:06:00 Automate Update Layer Project - Overview 00:02:00 Creating the AutomateUpdateLayer Project 00:03:00 AutomateUpdateLayer Project - Creating the Utility Class 00:17:00 AutomateUpdateLayer Project - Designing the User Interface 00:07:00 AutomateUpdateLayer Project - Coding the Form 00:18:00 AutomateUpdateLayer Project - Running the Program 00:07:00 Automatic Block Extractor Project - Overview 00:03:00 AutomaticBlockExtractor Project - Creating the Project 00:03:00 AutomaticBlockExtractor Project - Creating the User Interface 00:09:00 AutomaticBlockExtractor Project - Coding the Form 00:27:00 AutomaticBlockExtractor Project - Creating the Utility Class 00:27:00 AutomaticBlockExtractor Project - Running the Program 00:10:00 AutomateUpdateTextStyles Project - Overview 00:03:00 AutomateUpdateTextStyle Project - Creating the Project 00:02:00 AutomateUpdateTextStyle Project - Creating the User Interface 00:09:00 AutomateUpdateTextStyle Project - Coding the Form 00:20:00 AutomateUpdateTextStyle Project - Coding the Utility Class 00:16:00 AutomateUpdateTextStyle Project - Running the Program 00:08:00 Multiple Plot DWG to PDF Project - Overview 00:03:00 MultiplePlotDWGtoPDF Project - Creating the Project 00:04:00 MultiplePlotDWGtoPDF Project - Creating the User Interface 00:09:00 MultiplePlotDWGtoPDF Project - Coding the Form 00:20:00 MultiplePlotDWGtoPDF Project - Creating the Utility Class 00:30:00 MultiplePlotDWGtoPDF Project - Running the Program 00:13:00 Multiple Object Extractor Project - Overview 00:03:00 MultipleObjectExtractor Project - Creating the Project 00:02:00 MultipleObjectExtractor Project - Creating the User Interface 00:15:00 MultipleObjectExtractor Project - Coding the Form Load Event 00:05:00 MultipleObjectExtractor Project - Coding the Browse Buttons 00:10:00 MultipleObjectExtractor Project - Coding the Extract Button 00:20:00 MultipleObjectExtractor Project - Coding the ProcessDrawing Method 00:09:00 MultipleObjectExtractor Project - Coding the ProcessObjectExtraction Method 00:11:00 MultipleObjectExtractor Project - Coding the ExtractCircle Method 00:03:00 MultipleObjectExtractor Project - Coding the ExtractPolyline Method 00:09:00 MultipleObjectExtractor Project - Coding the ExtractMText Method 00:05:00 MultipleObjectExtractor Project - Coding the ExtractBlock Method 00:05:00 MultipleObjectExtractor Project - Running the Program 00:15: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.

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Enterprise network staff responsible for help desk support, system administration, and network design. Overview At Course Completion: - Features and functions of Group Policy - Use Group Policy management tools to manage security policies - Design a Group Policy infrastructure - Group Policy processing architecture - Back up, restore, import, and copy Group Policy Objects through the Group Policy - Management Console - Use Windows PowerShell to manage Group Policy - Implement security using Group Policy - Configure the desktop environment with Group Policy - Configure roaming profiles and Folder Redirection - Assign and publish software packages - Implement AppLocker and software restriction policies - Create and deploy Administrative Templates - Configure Group Policy preferences In this course, you will learn how to reduce costs and increase efficiencies in your network. You will discover how to consolidate the administration of an enterprise IT infrastructure with Group Policy, and you will learn to control and manage computer systems and domain users running Windows Server 2016 and Windows clients. Create Group Policies, implement administrative and security templates, and determine best practices when deploying software packages. Walk away with the experience and tools needed to optimize your enterprise systems and networks, implement administrative and security templates, and determine best practices when deploying software packages. 1 - Introduction to Configuration Management Configuration Management Overview Configuration Management Using Group Policy Group Policy Features Introduced with Later Versions of Windows Using Windows PowerShell in the Configuration Management Process 2 - Using Group Policy Management Tools Local and Domain Policies Using Group Policy Management Console Understanding Group Policy Refresh 3 - Designing a Group Policy Infrastructure Design Stages for a Group Policy Infrastructure Planning your Group Policy Design Designing Your Group Policy Solution Deploying Your Group Policy Solution Managing Your Group Policy Solution 4 - Understanding the Architecture of Group Policy Processing Group Policy Components in AD DS Understanding the Group Policy Deployment Order Modifying Group Policy Processing 5 - Troubleshooting and Backing Up GPOs Using Group Policy Troubleshooting Tools Integration of RSoP Functionality Group Policy Logging Options Backing Up, Restoring, Importing, and Copying GPOs Building Migration Tables 6 - Securing Windows Using Group Policy Exploring the Windows Security Architecture Securing User Accounts Exploring Security Policies Windows Firewall with Advanced Security Implementing Domain Security Security Policy Options for Window Client and Windows Server 7 - Implementing Application Security Using Group Policy Managing UAC Settings Defending Against Malware Using AppLocker to Restrict Software Implementing Windows App Security Settings 8 - Configuring the Desktop Environment with Group Policy Exploring Script Types and Controlling Script Execution Defining the Desktop, Start Menu, and Taskbar Settings Defining the Control Panel Settings Defining the Windows Components Settings Configuring the Printer Management and Pruning Settings Defining the Network Settings Discovering the new Group Policy Settings 9 - Implementing User State Virtualization Configuring Folder Redirection Managing Offline Files Implementing User Experience Virtualization OneDrive for Business 10 - Assigning and Publishing Software Packages Using MSI Packages to Distribute Software Using Group Policy as a Software Deployment Method Deploying Software Setting Up Distribution Points Using the Systems Center Configuration Manager to Distribute Software 11 - Configuration Management with Windows PowerShell Introducing Windows PowerShell Using Windows PowerShell Writing PowerShell Scripts Windows PowerShell Library for Group Policy Windows PowerShell-Based Logon Scripts 12 - Implementing PowerShell Desired State Configuration Introducing Group Policy Preferences Comparing Preferences and Policy Settings Options for Applying Preferences Configure Preference Settings 13 - Configuring Group Policy Preferences Introducing Group Policy Preferences Comparing Preferences and Policy Settings Options for Applying Preferences Configuring Preferences Settings Additional course details: Nexus Humans 50255 Managing Windows Environments with Group Policy 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 50255 Managing Windows Environments with Group Policy 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.

EFQM Performance Improvement Practitioner Course A 2-day deep-dive workshop on RADAR and how to use it as an agile project performance framework. The essential course for anyone wanting to learn more about the RADAR logic and how to build a continuous improvement culture and mindset across your whole organisation.   Who is it for? This course is suitable for anyone who wants to understand the RADAR logic and how it can be used to make their organisation more effective. Whilst this training is effective as a stand-alone course; it is also a Level 1 option for anyone considering one of the EFQM qualification routes as a way of progressing their management development and career.   Benefits By the end of the course, participants will be able to: Explain the overall RADAR logic Explain the main principles of positive culture and mindset for driving performance Describe how RADAR can be implemented into an organisation to improve performance at every level Identify how to use RADAR to drive the management agenda Apply RADAR across day-to-day initiatives and key projects as an agile project performance framework. Programme The main topics covered during the EFQM Performance Improvement Practitioner training are: RADAR logic and examples of how it can be used Using RADAR to drive the management agenda Using RADAR to drive strategic initiatives Using RADAR to set up strategic KPI’s RADAR as a Performance Improvement Framework Case studies and group exercises RADAR Improvement Matrix self-assessment The training is spread over two days and is delivered in a virtual classroom setting (Zoom or Microsoft Teams), using videos, group discussions, case studies and activities in breakout rooms and presentations from the trainer.   Further Development The EFQM Performance Improvement Practitioner training provides core knowledge about the RADAR Logic. In some cases, the training will have fulfilled an individual's learning needs. In many cases, the individual will want to consolidate their learning by applying the theory to a practical task. We encourage you to apply RADAR to a practical, work-based project, and we provide guidance on how to approach and complete your project.    Completion of the RADAR Performance Improvement Project also allows you to progress to one of the advanced EFQM qualification programmes: EFQM Performance Improvement Leader, EFQM Assessor or EFQM Organisational Change Leader.   EFQM Performance Improvement Leader If you successfully complete the EFQM Performance Improvement Practitioner training and the subsequent project, you are invited to apply for the EFQM Performance Improvement Leader assessment. You will be guided and coached by an EFQM trainer and asked to present your project to the EFQM expert panel. Here you will answer questions about how you applied the RADAR logic and principles (we provide participants with templates for running the project, as well as a high-level mid-term review). You will also receive feedback on how to improve and maximise the use of RADAR for future endeavours. Dates and time: This is a two day on-line workshop delivered on the 12th of June & 18th of June from 9:00 AM to 3:30 PM GMT Cost: £1000 + VAT

This course is the fastest way to start applying your basic Golang knowledge in the real-world and learning how projects are actually built. This course has no boring theory, no long introductions, no beating around the bush or wasting time, and just pure coding on the projects and learning from actually doing - not just watching.

Description Pet Business Training course is designed for individuals who want to open their own pet business. By completing the