2447 Courses in Glasgow delivered On Demand

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

Description: Microsoft Office is a group of different applications with different specific main functions that offer flexible and powerful tasks management. These applications can help you to organise, manage, and present information. Since the products of Microsoft Office are considered as the gold standard for businesses across the globe, knowing the functions of applications is a benefit for you. Through this course, you will learn all the essential skills, knowledge, and information about Microsoft Office 2007. You will know how to make use of all the programs and features of Microsoft Office. Who is the course for? New staff or workers who want to learn about the Microsoft Office 2007 Programs People who have an interest in all the features of the Microsoft Office 2007 Applications 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 you have successfully passed the test, you will be able to obtain an Accredited Certificate of Achievement. You can however also obtain a Course Completion Certificate following the course completion without sitting for the test. Certificates can be obtained either in hardcopy at a cost of £39 or in PDF format at a cost of £24. PDF certificate's turnaround time is 24 hours and for the hardcopy certificate, it is 3-9 working days. 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 recognised 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: The Microsoft Office 2007 Essentials course is a useful qualification to possess and would be beneficial for any type of professions or career from any type of industry you are in, such as: Administrative Assistant Businessman Executive Assistant Office Administrator Office Manager Personal Assistant Secretary Senior Manager Staff. Microsoft Word 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Word 01:00:00 Module Three - Working with Documents 01:00:00 Module Four - Your First Document 01:00:00 Module Five - Basic Editing Tasks 01:00:00 Module Six - Basic Formatting Tasks 01:00:00 Module Seven - Advanced Formatting Tasks 01:00:00 Module Eight - Formatting Paragraphs 01:00:00 Module Nine - Working with Styles 01:00:00 Module Ten - Formatting the Page 01:00:00 Module Eleven - Adding the Finishing Touches 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Word 2007 for Beginners 00:00:00 Microsoft Excel 2007 for Beginners Module One - Getting Started 01:00:00 Module Two - Opening and Closing Excel 01:00:00 Module Three - Your First Worksheet 01:00:00 Module Four - Working with Excel Files 01:00:00 Module Five - Viewing Excel Data 01:00:00 Module Six - Printing Excel Data 01:00:00 Module Seven - Building Formulas 01:00:00 Module Eight - Using Excel Functions 01:00:00 Module Nine - Using Time Saving Tools 01:00:00 Module Ten - Formatting your Data 01:00:00 Module Eleven - More Formatting 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Excel 2007 for Beginners 00:00:00 Microsoft PowerPoint 2007 For Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing PowerPoint 01:00:00 Module Three - Working with Presentations 01:00:00 Module Four - Your First Presentation 01:00:00 Module Five - Formatting Text 01:00:00 Module Six - Formatting Paragraphs 01:00:00 Module Seven - Working with Text 01:00:00 Module Eight - Advanced Formatting Tasks 01:00:00 Module Nine - Customizing Slide Elements 01:00:00 Module Ten - Setting up Your Slide Show 01:00:00 Module Eleven - Showtime! 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft PowerPoint 2007 for Beginners 00:00:00 Microsoft Access 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening Access 01:00:00 Module Three - Using the Access Interface 01:00:00 Module Four - Working with Database Objects 01:00:00 Module Five - Creating Tables 01:00:00 Module Six - Working with Tables 01:00:00 Module Seven - Creating Forms 01:00:00 Module Eight - Working with Forms 01:00:00 Module Nine - Creating Reports 01:00:00 Module Ten - Creating Queries 01:00:00 Module Eleven - Managing Your Database 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activites- Microsoft Access 2007 for Beginners 00:00:00 Microsoft Outlook 2007 for Beginners Module One - Getting Started 00:30:00 Module Two - Opening and Closing Outlook 01:00:00 Module Three - Working with E-mail 01:00:00 Module Four - Creating a New E-mail 01:00:00 Module Five - Managing E-mail 01:00:00 Module Six - Managing Junk Mail 01:00:00 Module Seven - Outlook's Organization Tools 01:00:00 Module Eight - Searching for Items 01:00:00 Module Nine - An Introduction to the Calendar 01:00:00 Module Ten - An Introduction to Tasks 01:00:00 Module Eleven - An Introduction to Contacts 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities-Microsoft Outlook 2007 for Beginners 00:00:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00: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.

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

Want to learn about NSX? Whether you are an absolute beginner or a CCIE, this is the course for you! Prep for VCP6-NV

In this course, you will learn the fundamentals of data visualization in Python using the well-known Matplotlib and Seaborn data science libraries and perform exploratory data analysis (EDA) by visualizing a data set using a variety of charts.

This course will take you from the basics of Rust to understanding how to use all its features effectively for writing clear and effective code. With the help of engaging exercises and explanations, you'll learn the basic syntaxes, iterators, generics, borrow checker, code documentation, pointer lifetimes, and much more.

***24 Hour Limited Time Flash Sale*** QLS Endorsed Import/Export and Port Management Admission Gifts FREE PDF & Hard Copy Certificate| PDF Transcripts| FREE Student ID| Assessment| Lifetime Access| Enrolment Letter Unlock the world of Import/Export and Port Management with this QLS-endorsed training bundle. Embark on a learning journey across two cornerstone courses - Import/Export and Port Management. Alongside these, complement your theoretical understanding with five CPD QS accredited courses. Expand your expertise in Logistic Management, Supply Chain Management, Airport Management, the role of a Transport Manager, and grasp the ins and outs of Warehouse Management. This all-encompassing course bundle gives you a rigorous understanding of the import/export industry, as well as the management of ports and other logistical hubs. You'll receive hardcopy certificates upon the completion of the QLS-endorsed courses, highlighting your accomplishment. Delve deeper with the CPD QS accredited courses, and broaden your knowledge base. Be it understanding supply chains, mastering logistics, or knowing the vital role a Transport Manager plays, this bundle has it covered. Discover the complexities of Import/Export and Port Management, and gear yourself up with in-depth theoretical knowledge to navigate this fast-paced industry. This bundle comprises the following courses: QLS Endorsed Courses: Course 01: Diploma in Import/Export Processing at QLS Level 4 Course 02: Diploma in Port Management at QLS Level 5 CPD QS Accredited Courses: Course 03: Logistic Management Course 04: Supply Chain Management Course 05: Airport Management Course 06: Transport Manager Course 07: Warehouse Management Diploma Learning Outcomes: By the end of this Import/Export and Port Management bundle course, learners will be able to: Gain an understanding of the principles and processes involved in Import/Export. Acquire knowledge about the functioning and management of ports. Learn the intricacies of Logistics Management and its application. Understand the principles of Supply Chain Management. Learn the workings and responsibilities of a Transport Manager. Gain knowledge about the operations and management of airports. Understand the functions and organisation of a warehouse. Enhance overall knowledge about the transport and logistics industry. The Import/Export and Port Management - Endorsed Training bundle is a comprehensive package offering a profound understanding of key areas within the transport and logistics industry. The two QLS-endorsed courses impart a strong theoretical understanding of the import/export sector, alongside the management and operation of ports. These subjects are central to the world of trade, transport and global commerce. The five CPD QS accredited courses supplement this knowledge by addressing other pivotal elements of the industry such as logistics, supply chains, airport operations, transport management, and warehouse management. This comprehensive training bundle aims to provide a thorough theoretical understanding of these areas, expanding your knowledge and boosting your potential within the transport and logistics sector. CPD 300 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Import/Export and Port Management bundle is perfect for: Individuals interested in gaining knowledge about the import/export sector and port management. Aspiring professionals looking to delve into transport and logistics management. Those seeking to learn about different facets of the transport and logistics industry such as airport and warehouse management. Anyone wishing to gain a theoretical understanding to complement further professional training in this field. Career path Import/Export Specialist: Median Salary - £28,000 per year. Port Manager: Median Salary - £40,000 per year. Logistic Manager: Median Salary - £35,000 per year. Supply Chain Manager: Median Salary - £42,000 per year. Transport Manager: Median Salary - £31,000 per year. Warehouse Manager: Median Salary - £27,000 per year. Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - Included

This course will show you how you can use Bash shell scripting to automate repetitive tasks. With the help of exciting projects, you will cover the basic and advanced concepts and commands of shell scripting and learn how to write error-free shell scripts in Ubuntu.