2439 Courses in Glasgow delivered On Demand

Embark on a comprehensive journey into the world of MySQL with a focus on its applications in Data Science and Analytics. This course is structured to take you from the fundamentals to advanced topics in MySQL Server. Covering SQL basics, data manipulation and definition, control and analytic functions, and database management, you'll acquire the essential skills for harnessing MySQL's power in data-driven decision-making. Learning Outcomes: Establish a strong foundation in SQL and MySQL. Set up and configure SQL Server for efficient data handling. Master SQL's Data Manipulation, Definition, and Control Language. Create and optimize SQL queries for data analysis. Perform advanced data analytics using SQL. Understand the power of GROUP BY and JOIN statements. Implement data constraints and views for data integrity and security. Develop proficiency in stored procedures, data import/export, and database backup/restore. Why buy this Learn MySQL from Scratch for Data Science and Analytics?  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 Learn MySQL from Scratch for Data Science and Analytics you will be able to take the MCQ test that will assess your knowledge. 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 Learn MySQL from Scratch for Data Science and Analytics course is ideal for Aspiring Data Scientists and Analysts. Database Administrators and Developers. Students and professionals seeking to enter the field of Data Science. Anyone looking to enhance their SQL and MySQL skills for data-related roles. Prerequisites This Learn MySQL from Scratch for Data Science and Analytics 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 Data Analyst: £25,000 - £50,000 per year. Database Administrator: £30,000 - £60,000 per year. SQL Developer: £30,000 - £60,000 per year. Data Scientist: £40,000 - £80,000 per year. Business Intelligence Analyst: £35,000 - £65,000 per year. Course Curriculum Learn MySQL from Scratch for Data Science and Analytics Section 01: Getting Started Introduction 00:02:00 How to get course requirements 00:01:00 Getting started on Windows, Linux or Mac 00:01:00 How to ask great questions 00:01:00 FAQ's 00:01:00 What is Source Code? 00:09:00 Section 02: SQL Server setting up Section Introduction 00:01:00 MySQL Server Installation 00:14:00 Connect MySQL Server Instance 00:06:00 MySQL Workbench overview 00:11:00 Download and Restore Sample Database 00:08:00 Section 03: SQL Database basics Section Introduction 00:01:00 Overview of Databases 00:09:00 Creating Database 00:07:00 SQL Data Types 00:04:00 Column Data Types on Workbench 00:07:00 Creating Table 00:04:00 Overview of Primary and Foreign Key 00:03:00 Primary Key 00:06:00 Foreign Key 00:12:00 Creating Temporary tables 00:12:00 EER - Enhanced Entity Relationship Diagrams 00:04:00 Section 04: SQL DML (Data Manipulation Language) Section Introduction 00:01:00 Insert statement 00:07:00 Update statement 00:06:00 Delete statement 00:03:00 Section 05: SQL DDL (Data Definition Language) Section Introduction 00:01:00 CREATE table statement 00:08:00 DROP statement 00:03:00 ALTER statement 00:05:00 TRUNCATE statement 00:03:00 COMMENT in query 00:02:00 RENAME table 00:03:00 Section 06: SQL DCL (Data Control Language) Create Database user 00:03:00 GRANT permissions 00:06:00 REVOKE permissions 00:04:00 Section 07: SQL Statement Basic Section Introduction 00:01:00 SQL Statement basic 00:03:00 SELECT Statement 00:03:00 SELECT DISTINCT 00:02:00 SELECT with column headings 00:01:00 Column AS statement 00:02:00 DASHBOARD Analytics 00:06:00 Section 08: Filtering Data rows SELECT WHERE Clause - theory 00:03:00 SELECT WHERE Clause - practical 00:06:00 Section 09: Aggregate functions for Data Analysis Sum() 00:06:00 Min()-Max() 00:03:00 Section 10: SQL Data Analyticstatements Order By statement 00:05:00 SELECT TOP 3 records 00:02:00 BETWEEN command 00:06:00 IN operator 00:03:00 Search Data usingLIKE cards 00:05:00 Section 11: SQL Group by statement Section Introduction 00:01:00 Group by - theory 00:04:00 Data Analytics with Group By 00:04:00 HAVING statement 00:03:00 Section 12: JOINS Overview of Joins 00:02:00 What are Joins 00:02:00 Inner join 00:07:00 Left outer join 00:02:00 Right outer join 00:02:00 Union 00:03:00 CERTESIAN Product or Cross Join 00:03:00 Query Exercise 00:01:00 Solution for Query Exercise 00:01:00 Section 13: SQL Constraints Section introduction 00:01:00 Check constraint 00:09:00 NOT NULL constraint 00:03:00 UNIQUE constraint 00:06:00 Section 14: Views Creating Views 00:03:00 Data Analytic Views from multiple tables 00:03:00 Section 15: Advanced SQL Functions Section Introduction 00:01:00 Timestamp 00:03:00 Extract from timestamp 00:03:00 Mathematical scalar functions 00:03:00 String functions3 00:07:00 Advanced functions 00:04:00 Sub Queries 00:03:00 SELECT with calculations 00:05:00 Section 16: SQL Stored procedures Create stored procedure 00:06:00 Stored procedure with parameter 00:03:00 Drop Procedure 00:01:00 Section 17: Import & Export data Section Introduction 00:01:00 Import .csv file 00:04:00 Export Data to .csv file 00:02:00 Section 18: Backup and Restore Database Section Introduction 00:01:00 Creating Database backup 00:02:00 Restoring Database backup 00:02:00

Prologue to Employment Law Certification Business law is an expansive field that tends to all aspects of an individual's functioning life from enrollment to retirement. It means to advance reasonable treatment in the working environment, guaranteeing that laborers are paid decently for safe work did under safe conditions. This course will give you a short outline of how business law functions, who is influenced by work enactment and the results of overstepping the law. It presents work law as a unique field that ought to be a vital factor in molding an organization's approaches and systems. You Will Learn: Who is covered by business law The extent of business law, including information assurance and disciplinary activity How Trade Unions work and how business law identifies with their exercises How work law is upheld in the UK, why it is imperative to stay aware of new improvements in business law and the punishments organizations can hope to get in the event that they don't follow enactment. Advantages of Taking This Course: In the event that you own a business, this course will assist you with understanding the degree of your duties under the law In the event that you are a specialist, this course will widen your insight into your working environment rights In the event that you are an individual from a Trade Union, or are thinking about joining an association, this course will give you an essential outline of their motivation and capacities On the off chance that you have an overall interest in law, this course will acquaint you with quite possibly the main legitimate spaces in the UK.

Learn how to build a login and registration system using PHP, MySQL, and Ajax

Welcome to Trigonometry Basics, your key to unlocking the magic of mathematics! This course is not just about numbers; it's about empowering you with skills that open doors to exciting possibilities. Imagine conquering the world of triangles, circles, and real-world problem-solving like a mathematical superhero! In Trigonometry Basics, you won't just memorise formulas; you'll journey through engaging modules, discovering the secrets of the unit circle, cracking the code of right triangles, and unleashing the power of polar coordinates. This isn't just a course; it's your ticket to mastering math and gaining a superpower that's invaluable in science, engineering, and beyond. Whether you're gearing up for a STEM career, diving into the wonders of mathematics, or simply curious about how trigonometry shapes our world, this course is your guide. It's not just about passing tests; it's about unleashing your inner problem-solving hero! So, are you ready to transform triangles from puzzling to powerful? Let's dive into the world of Trigonometry Basics!   Learning Outcomes Understand the foundational principles of trigonometry. Apply the unit circle approach to solve trigonometric problems. Demonstrate proficiency in solving trigonometry using right triangles. Analyse and solve complex problems using analytic trigonometry. Gain competence in working with polar coordinates. Utilise trigonometric concepts in real-world problem-solving scenarios. Apply acquired knowledge through practical assignments effectively. Develop a strong foundation for advanced mathematical concepts.   Who is this course for Students seeking to strengthen their mathematical fundamentals. Individuals pursuing careers in engineering or physical sciences. Enthusiasts interested in the practical applications of trigonometry. Professionals looking to enhance problem-solving skills. Anyone preparing for further studies in mathematics or related fields.   Why Choose This Course Unlimited access to the course for a lifetime. Opportunity to earn a certificate accredited by the CPD Quality Standards and CIQ after completing this course. Structured lesson planning in line with industry standards. Immerse yourself in innovative and captivating course materials and activities. Assessments designed to evaluate advanced cognitive abilities and skill proficiency. Flexibility to complete the Course at your own pace, on your own schedule. Receive full tutor support throughout the week, from Monday to Friday, to enhance your learning experience. Unlock career resources for CV improvement, interview readiness, and job success.   Career Path Engineering roles (e.g., Mechanical Engineer): £25,000 - £50,000. Data Analyst: £20,000 - £40,000. Computer Programmer: £25,000 - £45,000. Physics Research Assistant: £22,000 - £35,000. Mathematics Teacher: £25,000 - £40,000.   Certification Upon completion of the Trigonometry Basics course, a written assignment test is available, which can be taken during or at the course's conclusion. After successfully passing the test, learners have the opportunity to obtain a downloadable PDF certificate for a fee of £4.99. Alternatively, an original hard copy certificate can be ordered at an additional cost of £8.   Prerequisites No prior qualifications or experience are necessary for enrollment in the Trigonometry Basics course. This program, crafted by industry professionals, is compatible with PCs, Macs, tablets, and smartphones. Accessibility is ensured, allowing learners to engage with the course from any location, provided there is a reliable internet connection. Course Curriculum Course Promo Course Promo 00:02:00 Module 01: Fundamentals Number Tools 00:10:00 Graphing Tools 00:06:00 The Coordinate Plane 00:06:00 Module 02: Trigonometry Unit Circle Approach Introduction 00:01:00 The Unit Circle 00:08:00 Terminal Points 00:31:00 Reference Number 00:22:00 Trigonometric Functions 00:12:00 Evaluating Trigonometric Functions 00:14:00 Graph of Sine & Cosine 00:24:00 Sine & Cosine Graph Transformations 00:17:00 Tangent & Cotangent Graphs 00:20:00 Secant & Cosecant Graphs 00:25:00 Domain and Range of Sin, Cos and Tan 00:22:00 Examples 00:13:00 Domain and Range of Sec, Csc and Cot 00:13:00 Examples 00:16:00 Module 03: Trigonometry: Right Triangle Approach Introduction 00:01:00 Angles 00:16:00 Standard Position 00:08:00 Trigonometric Ratios 00:15:00 Examples 00:13:00 Special Angles 00:24:00 Examples 00:05:00 Reference Angle 00:14:00 Evaluating Trig Functions and Points 00:18:00 Inverse Trigonometric Functions 00:12:00 The Law of Sines 00:13:00 The Law of Cosines 00:10:00 Area of a Triangle 00:08:00 Module 04: Analytic Trigonometry Introduction 00:01:00 Fundamental Identities 00:10:00 Examples 00:18:00 Addition and Subtraction Formulas 00:15:00 Sums of Sines and Cosines 00:07:00 Double Angle Formulas 00:10:00 Half Angle Formulas 00:08:00 Formulas for Lowering Powers 00:05:00 Sum-to-Product Formulas 00:06:00 Product-to-Sum Formulas 00:05:00 Module 05: Polar Coordinates Polar Coordinates 00:19:00 Polar and Rectangular Coordinates 00:11:00 Polar Equations 00:07:00 Graph of Polar Equations 00:18:00 Symmetry 00:17:00 Common Polar Curves 00:12:00 Graphing Complex Numbers 00:06:00 Modulus 00:04:00 Polar Form of Complex Numbers 00:09:00 Multiplication and Division 00:07:00 De Moivre's Theorem 00:05:00 nth Roots of a Complex Number 00:21:00 Resources Resource - Trigonometry Basics 00:00:00 Assignment Assignment - Trigonometry Basics 00:00:00

Excel Spreadsheet Training Course Overview Tired of staring at endless rows and columns in frustration? Would you like to transform your data into insights that impress your boss and streamline your work? Then welcome to Excel Spreadsheet Training: Your Journey from Spreadsheet Novice to Spreadsheet Ninja! At the beginning of the Excel Spreadsheet Training course, you will acquire a thorough understanding of the Excel interface, confidently navigating and leveraging its features for efficient spreadsheet management. Besides, you will learn to enter and manipulate various data types, including text, numbers, time, logical values, and graphics, ensuring accurate and diverse information representation. This course will help you increase your productivity as you master Autofill and Speedfil functionalities, streamlining your workflow and saving valuable time during data entry. Additionally, this Excel Spreadsheet Training course will assist you in developing the skills to save files effectively, ensuring data security and accessibility while maintaining a well-organized digital workspace. Expertise in formulas increases Excel efficiency. In this Excel Spreadsheet Training course, you will gain a solid foundation in Formula Basics, understand the mathematical order behind formulas, and confidently create and manipulate them to suit your analytical needs. Furthermore, you will learn the art of copying relative and absolute formulas, facilitating efficient replication of calculations across your spreadsheet. As you move deeper into the Excel Spreadsheet Training course, you will learn the tricks and techniques to manage the sheets efficiently. When you finish the course, you will be introduced to the functions enabling you to harness Excel's full potential for complex data analysis and decision-making. Without any further delay, enrol in the Excel Spreadsheet Training course to make a fast progression in your career.  Why Choose Teachers Training Some of our website features are: This is a dedicated website for teaching 24/7 tutor support Interactive Content Affordable price Courses accredited by the UK's top awarding bodies 100% online Flexible deadline Entry Requirements No formal entry requirements. You need to have: Passion for learning A good understanding of the English language Be motivated and hard-working Over the age of 16. Certification Successfully completing the MCQ exam of this course qualifies you for a CPD-accredited certificate from The Teachers Training. You will be eligible for both PDF copy and hard copy of the certificate to showcase your achievement however you wish. You can get your digital certificate (PDF) for £4.99 only Hard copy certificates are also available, and you can get one for only £10.99 You can get both PDF and Hard copy certificates for just £12.99! The certificate will add significant weight to your CV and will give you a competitive advantage when applying for jobs. Excel spreadsheet for Beginner Tour of the Excel screen 00:10:00 Entering Data 00:13:00 Autofill Speedfill 00:09:00 Saving the file 00:02:00 Autosum 00:04:00 Formula Basics 00:11:00 Copying formulas - Relative Formulas 00:04:00 Totals and Averages 00:04:00 Formatting the Spreadsheet 00:07:00 Managing the Sheets 00:06:00 Copying formulas - absolute formulas 00:08:00 Linking the Sheets together 00:06:00 Introduction to Functions 00:05:00

Discover Ethereum blockchain development with our comprehensive course. From the fundamentals of Solidity to advanced topics such as NFTs and Truffle, we will gain practical skills through hands-on projects. Whether a beginner or an experienced developer, this course equips us with the tools and knowledge to excel in Ethereum blockchain development.

Overview With the ever-increasing demand for Google Data Studio in personal & professional settings, this online training aims at educating, nurturing, and upskilling individuals to stay ahead of the curve - whatever their level of expertise in Google Data Studio may be. Learning about Google Data Studio or keeping up to date on it can be confusing at times, and maybe even daunting! But that's not the case with this course from Compete High. We understand the different requirements coming with a wide variety of demographics looking to get skilled in Google Data Studio . That's why we've developed this online training in a way that caters to learners with different goals in mind. The course materials are prepared with consultation from the experts of this field and all the information on Google Data Studio is kept up to date on a regular basis so that learners don't get left behind on the current trends/updates. The self-paced online learning methodology by compete high in this Google Data Studio course helps you learn whenever or however you wish, keeping in mind the busy schedule or possible inconveniences that come with physical classes. The easy-to-grasp, bite-sized lessons are proven to be most effective in memorising and learning the lessons by heart. On top of that, you have the opportunity to receive a certificate after successfully completing the course! Instead of searching for hours, enrol right away on this Google Data Studio course from Compete High and accelerate your career in the right path with expert-outlined lessons and a guarantee of success in the long run. Who is this course for? While we refrain from discouraging anyone wanting to do this Google Data Studio course or impose any sort of restrictions on doing this online training, people meeting any of the following criteria will benefit the most from it: Anyone looking for the basics of Google Data Studio , Jobseekers in the relevant domains, Anyone with a ground knowledge/intermediate expertise in Google Data Studio , Anyone looking for a certificate of completion on doing an online training on this topic, Students of Google Data Studio , or anyone with an academic knowledge gap to bridge, Anyone with a general interest/curiosity Career Path This Google Data Studio course smoothens the way up your career ladder with all the relevant information, skills, and online certificate of achievements. After successfully completing the course, you can expect to move one significant step closer to achieving your professional goals - whether it's securing that job you desire, getting the promotion you deserve, or setting up that business of your dreams. Course Curriculum Module 01 Introduction to Google Data Studio Introduction to Google Data Studio 00:00 Module 02 Why Use Google Data Studio Over Others Why Use Google Data Studio Over Others 00:00 Module 03 How to Use Google Data Studio How to Use Google Data Studio 00:00 Module 04 Dashboard In Google Data Studio Dashboard In Google Data Studio 00:00 Module 05 How to Create Report In Google Data Studio How to Create Report In Google Data Studio 00:00 Module 06 Additional Features in Google Data Studio Additional Features in Google Data Studio 00:00 Module 07 Google Data Studio Calculated Formula and Functions Google Data Studio Calculated Formula and Functions 00:00 Module 08 Google Data Studio Data Blending and Sharing Reports Google Data Studio Data Blending and Sharing Reports 00:00 Module 09 Ways to Share Google Data Studio Reports Ways to Share Google Data Studio Reports 00:00

Develop your SQL skills, with useful insights into the MySQL syntax, SQL join statements, and more

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

Special Executive Masters Programme (S.E.M.P) This programme is geared at enhancing professionals' careers. The SEMP is an encapsulated Senior Management Programmes are short certificate modules designed for anyone who would benefit from more in-depth business knowledge delivered in a short and intensive programme What makes us different? We are a world class business school located in the heart of London, Dubai, Islamabad and Lagos. We are one of the fastest growing British business schools with a stylish blended learning model that is both online and on campus. Learn more about the programme Special Executive Master's Programme in Financial Management The MSBM Special Executive Masters Programmes (SEMP) allows you to update your skills, develop new skills, and explore and develop interests in a wide range of topics. These courses can be taken as personal or professional development and may enhance your employability. The SEMP in Financial Management is targeted at finance professionals and other professionals who want to develop a career in finance, and who require a wide-ranging understanding of financial techniques and their application – but do not require a high-level mathematical understanding of finance theories. The SEMP in Financial Management offers specialist studies in the areas of corporate finance, investments, and risk management. It will give online participants a relevant practical knowledge of finance that can be put into use straight away. Careers in finance depend upon a strong understanding of the foundations of finance, investment behaviour, and the dynamic nature of finance, and the SEMP FM will provide a strong preparation for a career in a wide variety of positions within the finance profession. Course Details Mode of Study Using Web-based technology, this program provides self-paced, individualized instruction that can be taken anywhere and anytime an individual has access to a computer and the Internet. This Programme is suitable for successful professionals or specialists in the private, public, or voluntary sectors who have new management responsibilities and need to quickly expand their management knowledge. This Programme serves as a refresher course for those who have had their Masters a long time ago and need quick reminders and professional/ academic updates while it serves as a primer for those very experienced Professionals who never made time out for their masters yet they require the academic and practical relevance of this master’s experience. It is a short executive training that runs online for 3 months. Candidates will run 2 months of active lectures and series of assignments and 1 month for their dissertation. Upon successful completion of the Programme, candidates will be awarded a Continuing Professional Development (CPD) certificate in the specific Programme they have completed. What is a CPD Course? Continuing Professional Development (CPD) is the means by which professionals maintain and enhance their knowledge and skills. The world is constantly moving at a very fast pace so undertaking CPD is essential to support a professional in his/her current role as well as helping them with career progression. CPD is all about upgrading knowledge, skills, and capabilities to remain effective and compliant. A CPD course is an investment that you make in yourself. It’s a way of planning your development that links learning directly to practice. CPD can help you keep your skills and knowledge up to date and prepare you for greater responsibilities. It can boost your confidence, strengthen your professional credibility, and help you become more creative in tackling new challenges. Is the SEMP Financial Management Programme right for me? Understanding non-profit financial reports and improving the ability of an organization to manage solvency issues is key to a sustainable and successful organization. Our online SEMP Financial Management Programme will help Board members, Senior Management, and other team members of your organization understand the ‘money story’, so they can make better decisions about the future of the organization. If you do not have a strong financial background, this three months online course will improve your ability to manage solvency and risk issues and also effectively increase your knowledge of the use of financial information.   Why SEMP Financial Management? SEMP Financial Management helps participants to develop the skills to analyze company financial data accurately and strategically. It focuses on improving executive decision making. This online Programme gives you tools and techniques that provide a comprehensive view of your company, competitors, and potential acquisitions which can help to monitor and forecast performance, measure profitability, assess competitiveness, and analyze restructuring opportunities. Other Benefits include: Financial management plays an involved role in the health of the overall economy, which impacts everyone, regardless of whether or not they have studied finance. Like companies, individuals are faced with investment and financing decisions. Having a firm grasp of finance will help individuals make those decisions. All business functions deal with finance because they need to be able to make the financial argument for the funding of their projects and to manage their budgets. Who should enrol in this online Certificate Program? Advisors working with private equity, including investment bankers, consultants, corporate lawyers or accountants Finance professionals and senior executives who want to understand the implications of private equity for their business, or who want to work in the industry Investors, from pension fund managers to wealth managers seeking to deepen their knowledge of private equity to inform decisions Entrepreneurs or senior executives from large companies seeking private equity funding Private equity professionals wishing to benefit from the latest research and practice Accreditation The content of this course has been independently certified as conforming to universally accepted Continuous Professional Development (CPD) guidelines. Entry Requirements There are no strict entry requirements for this course. Work experience will be added advantage to understanding the content of the course. Workshops This is a self-study programme with unlimited tutor support. You will never be more than a message or phone call away from our tutors. Visa Requirements There are no Visa Requirements for this Course as its an Online Course.