3074 Courses in Glasgow delivered Online

Description Nowadays, SQL Developers are in-demand and becoming a SQL developer can be a rewarding and fulfilling profession. This SQL Masterclass: SQL for Data Analytic is intended for absolute beginners that concentrate on giving the appropriate knowledge of Microsoft SQL Server and help to acquire the skills and abilities to become an SQL Server developer as well as offer many job opportunities in the competitive job market. In this course, you will learn how to create databases, tables, design databases and tables. You will also learn to create flat file database, confidently use SSMS Tool as well as write basic T-SQL Queries. In addition to that, learn to create constraints and views in the most dynamic way possible. Enrol right now and start exploring SQL, the most popular relational database management system. Entry Requirement: This course is available to all learners, of all academic backgrounds. Learners should be aged 16 or over to undertake the qualification. Good understanding of English language, numeracy and ICT are required to attend this course. Assessment: At the end of the course, you will be required to sit an online multiple-choice test. Your test will be assessed automatically and immediately so that you will instantly know whether you have been successful. Before sitting for your final exam, you will have the opportunity to test your proficiency with a mock exam. Certification: After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24. Why choose us? Affordable, engaging & high-quality e-learning study materials; Tutorial videos/materials from the industry leading experts; Study in a user-friendly, advanced online learning platform; Efficient exam systems for the assessment and instant result; The UK & internationally recognized accredited qualification; Access to course content on mobile, tablet or desktop from anywhere anytime; The benefit of career advancement opportunities; 24/7 student support via email. Career Path After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market. SQL for Data Analytic - Beginner Level Module: 01 Introduction FREE 00:16:00 Tools for Creating Views 00:11:00 Examples 00:21:00 Updating Data Using a View 00:13:00 Columns and Indexed Views 00:18:00 Module: 02 Introduction Stored Procedures 00:18:00 Creating Stored Procedures 00:19:00 Returning Data 00:14:00 Module: 03 Testing and Debugging 00:17:00 Execute with Result Sets 00:11:00 Creating Triggers 00:26:00 Module: 04 Overview and Scalar Functions 00:20:00 Inline Table Valued Functions 00:11:00 Multi Statement 00:16:00 Views and Stored Procedures 00:18:00 Module: 05 Transaction Concepts 00:30:00 Applications and Transactions 00:13:00 Creating Explicit Transactions 00:29:00 Structured Error Handling 00:25:00 Module: 06 Introduction to SQL CLR 00:08:00 Writing SQL CLR Code 00:24:00 Using SQL CLR Code 00:22:00 SQL CLR Code 00:13:00 SQL CLR Security 00:20:00 SQL for Data Analytic - Intermediate Level Module: 07 Topic A Aggregates FREE 00:27:00 Topic B User Defined Types 00:17:00 Topic C Table and Functions 00:10:00 Topic D Managing Code Modules 00:08:00 Module: 08 Topic A Introduction Data Tools 00:19:00 Topic B Connected Database Development 00:20:00 Topic C Updating a Connected Database 00:16:00 Module: 09 Topic A Creating New Objects with TSQL 00:12:00 Topic B Comparing Database Schemas 00:10:00 Topic C Offline Database Development 00:13:00 Topic D Database Project Settings 00:18:00 Module: 10 Topic A Using APPLY 00:15:00 Topic B MERGE Statement 00:23:00 Topic C Creating Recursive Queries 00:08:00 Topic D Grouping Sets 00:12:00 Module: 11 Topic A ROLLUP and CUBE Operators 00:12:00 Topic B Creating Pivot Queries 00:14:00 Topic C Executing Dynamic SQL 00:28:00 Module: 12 Topic A Complex Query Execution 00:26:00 Topic B Using Execution Plans 00:16:00 Topic C Execution Plan Operators 00:12:00 Topic D Common Join Operators 00:16:00 Module: 13 Topic A Hierarchy ID Data Type 00:12:00 Topic B Exploring a Hierarchy 00:09:00 Topic C Sparse Columns 00:16:00 Topic D Column Sets 00:12:00 Module: 14 Topic A Filtered Indexes 00:09:00 Topic B FILESTREAM Storage 00:22:00 Topic C Adding Sequences to Queries 00:22:00 Module: 15 Topic A Introduction to Spatial Data 00:13:00 Topic B Spatial Data in SQL Server 00:23:00 Topic C Manipulating Spatial Shapes 00:10:00 Topic D Interactions Between Objects 00:09:00 SQL for Data Analytic - Advanced Level Module: 16 Topic A Partitioning FREE 00:20:00 Topic B Creating Partition Tables 00:30:00 Topic C Querying Partitions 00:14:00 Topic D Managing Partitions 00:17:00 Module: 17 Topic A Complex Querying 00:22:00 Topic B Rankings 00:15:00 Topic C SubQueries 00:21:00 Topic D Common Table Expressions 00:17:00 Module: 18 Topic A Complex Data and Structures 00:26:00 Topic B Efficient Queries 00:36:00 Topic C Complex Queries 00:17:00 Module: 19 Topic A XML Data Type 00:28:00 Topic B XML Schemas 00:17:00 Topic C Querying XML 00:20:00 Topic D Best Practices 00:08:00

Overview This comprehensive course on Typescript Level 4 will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Typescript Level 4 comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. How will I get my certificate? After successfully completing the course you will be able to order your certificate, these are included in the price. Who is This course for? There is no experience or previous qualifications required for enrolment on this Typescript Level 4. It is available to all students, of all academic backgrounds. Requirements Our Typescript Level 4 is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. Career Path Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- Open doors of opportunities Increase your adaptability Keep you relevant Boost confidence And much more!   Course Curriculum 14 sections • 90 lectures • 04:07:00 total length •Module 01: What and why TypeScript: 00:02:00 •Module 02: TypeScript Playground: 00:04:00 •Module 03: Install TypeScript: 00:02:00 •Module 04: Install Visual Studio Code: 00:01:00 •Module 01: Introduction: 00:03:00 •Module 02: First Program Using Visual Studio Code: 00:04:00 •Module 03: Use JS in a HTML: 00:02:00 •Module 04: Strings: 00:02:00 •Module 05: Boolean: 00:01:00 •Module 06: Any Type: 00:01:00 •Module 07: Homogenous Arrays: 00:03:00 •Module 08: Heterogeneous Arrays: 00:01:00 •Module 09: Using alert confirm and prompt: 00:03:00 •Module 10: Comments: 00:02:00 •Module 11: Enum Type: 00:05:00 •Module 01: Arithmetic: 00:03:00 •Module 02: Assignment: 00:04:00 •Module 03: Comparison: 00:04:00 •Module 04: Logical: 00:04:00 •Module 05: Ternary: 00:03:00 •Module 01: Introduction: 00:01:00 •Module 02: IF Else Ladder: 00:06:00 •Module 03: Switch: 00:04:00 •Module 04: Break and Case Flow: 00:03:00 •Module 05: While loop: 00:03:00 •Module 01: Introduction: 00:02:00 •Module 02: Object Literal: 00:03:00 •Module 03: For-In Loop: 00:02:00 •Module 04: Arrays: 00:04:00 •Module 05: De-Structuring Arrays: 00:02:00 •Module 06: De-Structuring Objects: 00:02:00 •Module 01: Introduction: 00:02:00 •Module 02: First Function: 00:03:00 •Module 03: Passing a parameter: 00:01:00 •Module 04: Passing Multiple Parameters: 00:02:00 •Module 05: Optional Parameters: 00:04:00 •Module 06: Default Values: 00:01:00 •Module 07: Function as parameter: 00:02:00 •Module 08: Returning a function: 00:03:00 •Module 09: Anonymous Functions: 00:02:00 •Module 10: Overloading: 00:05:00 •Module 11: REST PARAMS: 00:05:00 •Module 12: Using a Type on REST PARAM: 00:01:00 •Module 01: Introduction: 00:02:00 •Module 02: First arrow function: 00:03:00 •Module 03: Passing Parameters: 00:03:00 •Module 04: Array of Arrow Functions: 00:03:00 •Module 01: let: 00:03:00 •Module 02: const: 00:02:00 •Module 02: const functions: 00:02:00 •Module 04: declare: 00:01:00 •Module 01: Introduction: 00:02:00 •Module 02: Define an Object Interface: 00:03:00 •Module 03: Create and object: 00:03:00 •Module 04: Defining optional properties: 00:01:00 •Module 05: Interfaces are only compile time: 00:01:00 •Module 06: Function Interfaces: 00:04:00 •Module 07: Return Types in Functional interfaces: 00:02:00 •Module 08: Adding methods to Object Interfaces: 00:02:00 •Module 09: Array Interfaces: 00:03:00 •Module 10: String indexed Array Interfaces: 00:03:00 •Module 11: Extending interfaces: 00:06:00 •Module 01: Introduction: 00:01:00 •Module 02: Create a class: 00:03:00 •Module 03: Add a constructor: 00:04:00 •Module 04: Add Function properties: 00:02:00 •Module 05: Power of TypeScript: 00:01:00 •Module 06: Using for-in and instanceof: 00:04:00 •Module 07: Implementing an interface: 00:06:00 •Module 01: Introduction: 00:03:00 •Module 02: Extending a class: 00:05:00 •Module 03: Create Child Objects: 00:07:00 •Module 04: Inheriting Functionality: 00:04:00 •Module 05: Overriding: 00:03:00 •Module 01: Public and readonly: 00:02:00 •Module 02: Encapsulation: 00:01:00 •Module 03: Private properties: 00:04:00 •Module 04: Accessor methods: 00:02:00 •Module 05: Using Static Properties: 00:04:00 •Module 06: More about static: 00:01:00 •Module 07: Static Methods: 00:03:00 •Module 01: String to numeric: 00:04:00 •Module 02: Using the toString method: 00:03:00 •Module 03: Object Casting: 00:02:00 •Module 01: Introduction: 00:01:00 •Module 02: Using Function Modules: 00:04:00 •Module 03: Import Aliasing and Alternate Export Syntax: 00:02:00 •Module 04: Default Exports: 00:02:00 •Module 05: Class Modules: 00:01:00 •Module 06: Aliasing class modules: 00:02:00

This course covers the complete AWS Application Stacks using Cloud Development Kit. Learn to deploy simple-to-complex resources in AWS using CDK and launch several stacks and templates. This course assumes you know how to use the AWS Cloud. It will help you transform your solution architecting skills into CDK Stack.

The Revit MEP course (£525), offers you individual learning (One to One) to improve your skills in Revit, and this course extends to 15 hours.

Duration 4 Days 24 CPD hours This course is intended for The primary audience for this course is system installers, system integrators, system administrators, network administrators, and solutions designers. Overview At the end of this course, you will be able to: Describe the NSO's transactional application framework and mapping model options Describe the Reactive Fastmap design pattern and the NSO Configuration Database (CDB) subscriber in the NSO Transaction model Simplify packages to remove the need for subscriber applications, scale orchestration solutions, and integrate NSO with external systems (east-west integration)Describe the Cisco ESC architecture and integration with NSO, and how the NSO VNF Orchestration (VNFO) Release 2 bundle interacts with ESC for orchestration This course explores how to create advanced services using the NSO application framework and Python scripting with both new and existing Layer 3 Multiprotocol Label Switching (MPLS) VPN services. Students will also learn how to manage and scale these services, and how to use NSO Network Functions Virtualization (NFV) orchestration features and Cisco Elastic Services Controller (ESC) to manage Virtualized Network Functions (VNFs). Cisco NSO Programmability NSO Application Framework NSO Python Scripting NSO Python and Template-Based Services Resources Augmenting Cisco NSO Service Service Lifecycle and Integration Options Overview Greenfield Layer 3 MPLS VPN Service Brownfield Layer 3 MPLS VPN Service Managed Services Managed Services Overview Stacked Service Design Overview Design-Managed Network Services Scaling Service Orchestration Cisco NSO Network Functions Virtualization (NFV) Orchestration ETSI MANO Cisco ESC Cisco NSO Orchestration Additional course details: Nexus Humans Cisco Network Services Orchestrator Advanced Design (NSO300) 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 Cisco Network Services Orchestrator Advanced Design (NSO300) 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.

Duration 2 Days 12 CPD hours This course is intended for Workspace ONE UEM and Workspace ONE Access operators and administrators, account managers, solutions architects, solutions engineers, sales engineers, and consultants Overview By the end of the course, you should be able to meet the following objectives: Explain the general features and functionality that Workspace ONE Access enables Demonstrate how to integrate Workspace ONE UEM with Workspace ONE Access Summarize and implement Workspace ONE productivity services into the digital workspace environment Explain the methods of enabling mobile single sign-on for mobile endpoints managed in the digital workspace Configure Workspace ONE Access to support SAML 2.0 for federated authentication across the workforce In this two-day course, you learn how to apply the fundamental techniques for integrating VMware Workspace ONE© Access? with VMware Workspace ONE© UEM to securely distribute business-critical applications from any device and configure access management controls. Through a combination of hands-on labs, simulations, and interactive lectures, you configure system and productivity integrations for Workspace ONE Access and Workspace ONE UEM. The course provides the principles of identity and access management. You will leave with a foundational understanding of how Workspace ONE uses various authentication methods and protocols to determine user access permissions and enable single sign-on. Course Introduction Introductions and course logistics Course objectives Workspace ONE Access Summarize the benefits of Workspace ONE Access Outline the core features and functions enabled by Workspace ONE Access Navigate the Workspace ONE Access console Explain the functions of directory integration with Workspace ONE Access Explain the various types of authentication protocols enabled by Workspace ONE Access Integrating Workspace ONE UEM and Workspace ONE Access Explain the rationale for integrating Workspace ONE UEM and Workspace ONE Access Outline the process of connecting Workspace ONE UEM and Workspace ONE Access Examine the workflow of integrations Summarize the key features of an integrated solution Productivity Integrations Identify the functions enabled by VMware Unified Access Gateway? Outline the purpose of the VMware AirWatch© Secure Email Gateway? edge service Explain the features enabled by the VMware Workspace ONE© Tunnel? edge service Summarize the capabilities enabled by the Content Gateway edge service SAML 2.0 Authentication Outline authentication methods supported by Workspace ONE Access Summarize the main properties of the SAML protocol Summarize the SAML authentication workflow Explain the application single sign-on authentication workflow with SAML Mobile Single Sign-On Describe the concept of mobile single sign-on Outline mobile single sign-on workflows Intelligence and Automation Summarize the features of Workspace ONE© Intelligence? Outline the benefits of using Workspace ONE Intelligence

Learn all the core fundamentals of modern web design, covering all the commonly used syntax for HTML, CSS, JavaScript, and JavaScript DOM with the help of this beginner-friendly course. Go from a static web page to an interactive one with JavaScript. This course is designed to get you started quickly and easily with creating web pages.

48-Hour Knowledge Knockdown! Prices Reduced Like Never Before! Imagine a world where national security and public safety threats are detected, analysed, and addressed promptly. This is the realm of intelligence analysts, who play a vital role in ensuring our safety. The Intelligence Analysis for National Security and Public Safety course provides comprehensive knowledge to help you succeed in this growing industry. The demand for intelligence analysts in the UK is rising, with the government and private sector investing heavily in national security infrastructure. This Intelligence Analyst Certification Course will equip you with the skills and understanding required to excel in intelligence analysis. Learning Outcomes: Understand the definition and importance of intelligence analysis in national security and public safety. Gain knowledge of the historical development and evolution of intelligence analysis. Comprehend the intelligence cycle and its components for effective analysis. Develop critical thinking and structuring techniques for accurate intelligence analysis. Learn the analysis process, best practices, and methodologies. Examine the role of intelligence in national security and its implications. Explore legal issues and ethical considerations in intelligence analysis. Identify your role, responsibilities, and functions as an intelligence analyst. Why Prefer this Intelligence Analysis for National Security and Public Safety Course? Opportunity to earn a certificate accredited by CPD QS after completing this Intelligence Analysis for National Security and Public Safety course Get a free student ID card! (£10 postal charge will be applicable for international delivery). Innovative and engaging content. Free assessments. 24/7 tutor support Throughout this Intelligence Analysis for National Security and Public Safety course, you will learn the intelligence cycle, critical thinking, structuring techniques, and the legal and ethical considerations involved in intelligence analysis. This Intelligence Analysis for National Security and Public Safety course will pave the way for a rewarding career in intelligence, with ample opportunities for growth and development. Enrol in the Intelligence Analysis for National Security and Public Safety course today, and become part of the front line in safeguarding our nation and communities. Here is the curriculum breakdown of this Intelligence Analysis for National Security and Public Safety course: Module 01: Learn the concept of intelligence analysis Understand its significance in national security Module 02: Explore historical development Understand its evolution over time Module 03: Discover the intelligence cycle components Learn how it enhances analysis Module 04: Develop critical thinking skills Understand structuring for accurate analysis Module 05: Learn methodologies and best practices Enhance your analysis process Module 06: Examine the role of intelligence in security Understand its implications for national security Module 07: Explore legal and ethical issues Learn to navigate them as an analyst Module 08: Identify your role as an intelligence analyst Understand your responsibilities and functions Certification Upon successful completion of the Intelligence Analysis for National Security and Public Safety course, learners can obtain a certificate as proof of their achievement. The following certificate options are available: PDF Certificate: A digital version of the certificate will be emailed to the learner upon request for only £10. Printed Hardcopy Certificate - UK Delivery: For learners within the United Kingdom, a high-quality printed hardcopy of the certificate can be delivered to your postal address for only £29. Printed Hardcopy Certificate - International Delivery: For learners residing outside the UK, a high-quality printed hardcopy of the certificate can be delivered to your international postal address for only £39. CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Individuals aspiring to work as intelligence analysts in national security, law enforcement, or public safety sectors Professionals in related fields want to enhance their understanding of intelligence analysis and its application. Public safety and national security agencies seeking to train their staff in intelligence analysis Students pursuing degrees in security studies, political science, or related fields who want to develop a foundation in intelligence analysis. Researchers or academics focusing on intelligence analysis and its role in national security and public safety. Requirements You will not need any prior background or expertise. All you need to take this Intelligence Analysis for National Security and Public Safety is - A smart device. A secure internet connection. Being over the age of 16. And a strong drive for learning and literacy. Career path Intelligence Analyst - £30-50k/year Counterterrorism Analyst - £35-55k/year Law Enforcement Analyst - £25-45k/year Security Consultant - £40-70k/year Crime Analyst - £25-45k/year

Duration 5 Days 30 CPD hours This course is intended for This course is intended for Database Administrators, Database Developers, BI professionals, and Business reporting users. Overview Upon successful completion of this course, students will be able to run Queries and retrieve results, perform conditional searches, and retrieve data from multiple tables. Before starting this course, make sure you meet at least one of the following prerequisites: Basic knowledge of the Microsoft Windows operating system and its core functionality. Basic working knowledge of Relational Databases. In this course, students will gain a good understanding of the Transact-SQL language. They will be able to create queries, sort, filter the data, execute procedures with T-SQL. Course Outline 1.Introduction to Microsoft SQL Server 2.Introduction to T-SQL Querying 3.Writing SELECT Queries 4.Querying Multiple Tables 5.Sorting and Filtering Data 6.Working with SQL Server Data Types 7.Using DML to Modify Data 8.Using Built-In Functions 9.Grouping and Aggregating Data 10.Using Subqueries 11.Using Table Expressions 12.Using Set Operators 13.Using Windows Ranking, Offset, and Aggregate Functions 14.Pivoting and Grouping Sets 15.Executing Stored Procedures 16.Programming with T-SQL

Duration 3 Days 18 CPD hours This course is intended for This intermediate course is for all computer professionals who will use z/OS UNIX. Overview Discuss the role of z/OS in an open systems environmentIdentify the basic terms used in z/OS UNIXDefine the components of z/OS UNIXExplain major functions provided in z/OS UNIXDiscuss opportunities for applications in a z/OS UNIX environmentIdentify z/OS base elements and optional features that make up z/OS UNIXUse the two interactive interfaces available to access the services This course describes how open standards are implemented in a z/OS system by z/OS UNIX. UNIX System Services are introduced, and the role of z/OS as a server in the open systems environment is discussed. Day 1 Welcome and introduction Unit 1. z/OS UNIX overview Unit 2. Introduction to z/OS UNIX Unit 3. Hierarchical file system Exercises Day 2 Unit 4. z/OS UNIX shell and utilities Unit 5. z/OS UNIX shell commands Unit 6. Working with the shell Unit 7. Functions in z/OS UNIX Exercises Day 3 Unit 8. Working with the z/OS UNIX environment Exercises