3073 Courses in Glasgow delivered Online

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

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 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 three-day instructor-led course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence. Specifically, this course presents TSQL within the context of data analysis in other words, making meaning from the data rather than transaction-oriented data-tier application development. The course starts with a brief discussion of levels of measurement and quantitative research methodogy, and integrates these concepts into each TSQL topic presented. The goal is to provide a consistent, direct, and purposeful learning path from RDBMS data retrieval through analytical tools such as SQL Server Reporting Services, PowerBI, Excel, R, SAS, and SPSS. Module 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 Module 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 Module 3: Combining Columns from Multiple Tables into a Single Dataset: The JOIN Operators Primary Keys, Foreign Keys, and Joins Understanding Joins, Part 1: CROSSJOIN and the Full Cartesian Product Understanding Joins, Part 2: The INNERJOIN Understanding Joins, Part 3: The OUTERJOINS Understanding Joins, Part 4: Joining more than two tables Understanding Joins, Part 5: Combining INNER and OUTERJOINs Combining JOIN Operations with WHERE and ORDER BY Module 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 Module 5: Subqueries, Derived Tables and Common Table Expressions Non-correlated and correlated subqueries Derived tables Common table expressions Module 6: Encapsulating Data Retrieval Logic Views Table-valued functions Stored procedures Creating objects for read-access users Creating database accounts for analytical client tools Module 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 Additional course details: Nexus Humans 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 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.

Overview Introducing our comprehensive 'Refactor JavaScript Course'. With the digital landscape ever-evolving, coding has grown beyond mere creation. The efficiency, readability, and maintainability of your code are pivotal. This course not only introduces you to the crux of refactoring but also guides you through the art of detecting 'code smells' and mending them. Let's set out on a journey through the various elements and structures of JavaScript, ensuring your knowledge isn't just surface level but robust and future-proof. In the age of cluttered codes and labyrinthine structures, mastering refactoring is akin to acquiring a superpower. By delving into our curriculum, you'll learn to diagnose issues in your code with precision, swiftly making amendments to ensure optimised performance. As you navigate through units addressing everything from the basics to the intricate structures, you'll emerge equipped with the tools to keep your codebase neat, efficient, and above par. Lastly, as we tie up with the conclusion, we don't merely finish. We ensure you're brimming with confidence, adeptness, and a renewed passion for coding. Whether you're a beginner aiming for excellence or someone looking to keep up with modern coding paradigms, this course serves as your gateway to elevated JavaScript expertise. Learning Outcomes: Understand the fundamental principles and significance of refactoring in JavaScript. Identify and rectify common 'code smells' hindering code quality. Implement techniques for refactoring various elements within a JavaScript codebase. Adapt and restructure intricate code layouts for improved clarity and efficiency. Synthesise learning from all units to maintain and enhance existing JavaScript projects. Develop a systematic approach to coding, ensuring reduced errors and increased maintainability. Foster a deeper appreciation and understanding of clean, efficient, and readable JavaScript. Why buy this Refactor Javascript Course? Unlimited access to the course for forever Digital Certificate, Transcript, student ID all included in the price Absolutely no hidden fees Directly receive CPD accredited qualifications after course completion Receive one to one assistance on every weekday from professionals Immediately receive the PDF certificate after passing Receive the original copies of your certificate and transcript on the next working day Easily learn the skills and knowledge from the comfort of your home Certification After studying the course materials of the Refactor Javascript Course there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Who is this course for? This Refactor Javascript Course course is ideal for Individuals keen on refining their JavaScript coding skills. Developers looking to optimise and maintain their existing JavaScript projects. Enthusiasts aiming to elevate their coding standards and best practices. Team leads or managers seeking efficient coding techniques for project oversight. Anyone passionate about producing quality code that stands the test of time. Prerequisites This Refactor Javascript Course does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Refactor Javascript 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. Career path JavaScript Developer: Average Salary Range £30,000 - £55,000 Front-end Developer: Average Salary Range £28,000 - £52,000 Back-end Developer: Average Salary Range £31,000 - £58,000 Full-stack Developer: Average Salary Range £35,000 - £60,000 Software Engineer: Average Salary Range £35,000 - £65,000 Technical Lead: Average Salary Range £50,000 - £80,000. Course Curriculum Refactor Javascript Unit 01: Introduction Module 01: Introduction 00:05:00 Unit 02: Code Smells Module 01: Introduction 00:02:00 Module 02: General Code Smells 00:06:00 Module 03: Kill All the Global Data 00:05:00 Module 04: Long Functions && Long Classes 00:07:00 Module 05: Long Parameters List 00:05:00 Module 06: Side Effect 00:04:00 Module 07: Feature Envy 00:04:00 Module 08: Divergent Change AND Shotgun Surgery 00:06:00 Unit 03: Code Elements Refactoring Module 01: Introduction 00:02:00 Module 02: Be the code minimalist 00:06:00 Module 03: Refactoring variables 00:10:00 Module 04: Refactoring conditionals 00:06:00 Module 05: Refactoring loops 00:11:00 Module 06: Refactoring functions 1 00:11:00 Module 07: Refactoring functions 2 00:06:00 Unit 04: Code Structure Refactoring Module 01: Introduction 00:02:00 Module 02: Error handling 00:13:00 Module 03: Structuring the code 00:07:00 Module 04: Refactoring Tools 00:22:00 Module 05: Eslint Demo 00:17:00 Unit 05: Conclusion Module 01: Conclusion 00:01:00 Assignment Assignment - Refactor Javascript Course 00:00:00

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

Comprehensive Health The vast majority know about current ordinary medication and old home grown cures. Comprehensive medication is the fair compromise between natural medication and regular medication with a contort. It utilizes a more extensive choice of medicines and a completely extraordinary method of approaching relieving or adjusting to infection. Individuals who set aside the effort to find out about all encompassing wellbeing frequently end up feeling more in charge of their wellbeing, finding a feeling of equilibrium in their prosperity, an improved eating routine, better actual wellbeing and the sky is the limit from there. This course expounds with respect to the essentials of comprehensive wellbeing, professionals of all encompassing wellbeing, how all encompassing wellbeing is utilized to treat sickness and that's only the tip of the iceberg. We will start by clarifying the contrasts between all encompassing wellbeing in contrast with natural and regular medication. Then, we audit the regions that comprehensive wellbeing centers around the most, the advantages of all encompassing medication and steps to help kick you off. At long last, we give you tips on utilizing comprehensive medicines at home and when you should search out your overall professional for exhortation. You Will Learn: How all encompassing medication varies from home grown and ordinary medication The various regions that make up comprehensive medical services How comprehensive medication functions The various kinds of comprehensive professionals The advantages of utilizing comprehensive medication Step by step instructions to utilize all encompassing medication in your life Tips on utilizing all encompassing medication adequately for your way of life needs Advantages of Taking This Course: You will find out about the various zones of wellbeing and what they mean for you overall You will find out about another strategy for treating different conditions and infirmities You can improve your psychological, physical, passionate, profound and sexual wellbeing Seeing how comprehensive medication can be utilized rather than traditional clinical practices Assists you with recovering power over your own wellbeing and treatment choices

Overseeing Teams Certification As an administrator or group pioneer, you have an apparently perpetual number of errands that you need to finish. As well as keeping on top of your ventures and spending plan, you additionally need to deal with the individual colleagues. Truth be told, notwithstanding mainstream thinking, figuring out how to work with your colleagues is the main aspect of your responsibilities. An all around run group that functions admirably together is glad busy working and beneficial; angles you can plainly see reflected in your main concern. This course gives you definite data about how to viably deal with a group. We start by discussing the employing and enrolling measure, as having the correct individuals in your group is the most ideal approach to begin fabricating a profitable one. Then, we talk about the distinctive character types you are probably going to seem to be you are assembling your optimal group. Building up a strong workplace is covered straightaway. At last, we survey the significance of undertaking designation and compromise. You Will Learn: The means to take to guarantee that you are recruiting the correct individuals The particular jobs that each colleague plays The difficulties that you may run over while attempting to appoint significant errands Tips on the best way to assign your errands adequately to guarantee the best conceivable efficiency Extra tips on the best way to determine most work environment clashes, paying little mind to character types Advantages of Taking This Course: Seeing more about recruiting by character type and how to assemble the ideal group Figuring out how to persuade varying character types to complete activities Seeing more about making a beneficial, positive and solid working environment culture Figuring out how to appoint by character type and range of abilities, rather than who is close by or is requesting additional work Seeing more about compromise and how to apply those methodologies to your working environment

Description: Microsoft Outlook is helpful software to professionals since it has all the tools and functionality you need for your career. Outlook is created with new and improved features as compared to its previous versions. Through this course, you will learn how to use the new functions and features of Outlook. Learn about professional emails, calendar, contacts, and task management effectively. These features will help you communicate faster and easier to your colleagues, clients or anyone you need to communicate with professionally.In this course you will learn the necessary skills, knowledge and information of Microsoft Outlook. Who is the course for? Professionals or experts who want to learn more about Outlook new features. People who have an interest in knowing Microsoft Outlook new functions and tools. 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 the cost of £39 or in PDF format at the 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 Outlook Intermediate Level course is a useful qualification to possess and would be beneficial for any professions or career industry you are in. Microsoft Outlook Intermediate Level Module One - Getting Started 01:00:00 Module Two - Working with the Outlook Environment 01:00:00 Module Three - Working with Quick Steps 01:00:00 Module Four - Working with Rules 01:00:00 Module Five - Working with Messages 01:00:00 Module Six - Manipulating Message Properties and Options 01:00:00 Module Seven - Formatting Messages 01:00:00 Module Eight - Managing Automatic Content 01:00:00 Module Nine - Working with the Calendar, Appointments, and Meetings 01:00:00 Module Ten - Working with Contacts and Contact Groups 01:00:00 Module Eleven - Working with Tasks 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Outlook Intermediate Level 00:00:00 Mock Exam Mock Exam- Microsoft Outlook Intermediate Level 00:20:00 Final Exam Final Exam- Microsoft Outlook Intermediate Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: Learning more about advanced Microsoft Outlook features will help you become more productive. In the long run, knowing how to utilise this essential tool will help you in your career advancement. In this course, you will be learning about the advanced functions and features of Microsoft Outlook 2007. You will learn how customising Outlook will help you in using it efficiently. Know how adding word element emails to an email can be helpful and how to customise your profile. Understand how advanced E-mail tasks and advanced calendar tasks can function as you will learn how to manage your Outlook files and data well. Who is the course for? Professionals who want to learn about Microsoft functions and features, People who have an interest in knowing advanced Microsoft Outlook features. 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 the cost of £39 or in PDF format at the 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 Outlook 2007 Advanced Workshop Manual is a useful qualification to possess and will be very beneficial and helpful, especially to the following professionals: Business IT Admin Secretary Project Management Microsoft Outlook 2007 Advanced Level Module One - Getting Started 00:30:00 Module Two - Customizing Outlook 01:00:00 Module Three - Adding Word Elements to an E-mail 01:00:00 Module Four - Customizing Your Profile 01:00:00 Module Five - Advanced E-Mail Tasks 01:00:00 Module Six - Advanced Calendar Tasks 01:00:00 Module Seven - Doing More with Tasks 01:00:00 Module Eight - Using Notes 01:00:00 Module Nine - Viewing RSS Feeds 01:00:00 Module Ten - Managing Outlook Data, Part One 01:00:00 Module Eleven - Managing Outlook Data, Part Two 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Outlook 2007 Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Outlook 2007 Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Outlook 2007 Advanced Level 00:20:00 Order Your Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description:  Learning the basics of Microsoft Word 2013 is very helpful to anyone who wants to utilise the program. However, if you want to learn the advanced features of this program, you need to get to use it again. In this course, you will learn the necessary skills, knowledge and information about the advanced functions and features of Microsoft Word 2013. You will know how to make the most of the functions the program can offer. Then you will know all the tools and how to use them. Who is the course for? Professionals who want to learn about the Microsoft Word 2013 People who have an interest in the advanced features of Microsoft Office 2013 Entry Requirement: This course is available to all learners, of all academic backgrounds. However, an education and experience in accounting is an advantage. 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 hard copy 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 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: The Microsoft Word Advanced Level course is a useful qualification to possess and would be beneficial for professions or careers from industries which are: Administrative Assistant PA Secretary Administrator Office Manager. Microsoft Word Advanced Level Module One - Getting Started 00:30:00 Module Two - Working with the Word Window 01:00:00 Module Three - Advanced Editing and Formatting Tasks 01:00:00 Module Four - Working with Illustrations 01:00:00 Module Five - Formatting Pictures 01:00:00 Module Six - Adding SmartArt 01:00:00 Module Seven - Adding Tables 01:00:00 Module Eight - Inserting Special Objects 01:00:00 Module Nine - Working with Document References 01:00:00 Module Ten - Reviewing Your Document 01:00:00 Module Eleven - Using Comments and Tracking 01:00:00 Module Twelve - Wrapping Up 00:30:00 Activities Activities-Microsoft Word Advanced Level 00:00:00 Mock Exam Mock Exam- Microsoft Word Advanced Level 00:20:00 Final Exam Final Exam- Microsoft Word Advanced Level 00:20:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00

Description: This Microsoft Office 2010 Outlook Beginners - Complete Video Course is intended for novice information workers who want to learn beginning level Outlook 2010 skills. It will provide you with an overview of the features and functions of Microsoft Outlook 2010. Here, you will learn the basic functions and features of Outlook 2010. After an introduction to Outlook's windows components and the Help system, you will be able to read and end email messages using several techniques. Then you will learn how to manage email messages and attachments, configure message options, and use search folders, and how to manage contacts and use the People Pane, works with tasks, and create appointments. Finally you will learn to send and respond meeting requests. If you are interested to learn all the basics of Microsoft Outlook 2010, then you should join this immediately Assessment: At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not. 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. Who is this Course for? Microsoft Office 2010 Outlook Beginners - Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it perfect for anyone trying to learn potential professional skills. As there is no experience and qualification required for this course, it is available for all students from any academic background. Requirements Our Microsoft Office 2010 Outlook Beginners - Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation. 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. Getting Started The Program Window FREE 00:12:00 Outlook Today 00:04:00 Getting Help 00:03:00 Email Reading Email Messages 00:05:00 Creating and Sending Email Messages 00:05:00 Working with Messages 00:10:00 Attachments 00:05:00 Email Management Message Options 00:15:00 Junk Email 00:06:00 Search Folders 00:04:00 Printing Messages 00:03:00 Contact Management Working with Contacts 00:12:00 Contact Groups 00:05:00 The People Pane 00:06:00 Tasks Working with Contacts 00:12:00 Managing Tasks 00:13:00 Appointments and Events Creating and Sending Appointments 00:09:00 Modifying Appointments 00:08:00 Events 00:05:00 Calendar Views 00:11:00 Meeting Requests and Responses Meetings 00:13:00 Managing Meetings 00:08:00 Certificate and Transcript Order Your Certificates and Transcripts 00:00:00