270 MySQL courses in Leeds delivered On Demand

Master the art of self-hosting WordPress on Linux with our comprehensive video course, designed to empower technical professionals to fully control their web presence.

Understand how Docker works and learn its core features with this hands-on course. This is 90% practice without any useless demos! Learn how to create different containers such as Node.js, Python, WordPress, MongoDB, MySQL, Redis, Elasticsearch, and much more.

Welcome to this beginner's level course on Microsoft SQL Servers. Understand the concepts of SQL and learn to create a new database and table to perform various operations on it, with live running queries as examples. Work on hands-on exercises and understand database concepts in a real-world scenario.

A complete course on Sqoop, Flume, and Hive: Ideal for achieving CCA175 and Hortonworks Spark Certification

Business and Data Analysis with SQL is a comprehensive training in the theoretical and practical study of Data analysis and SQ language. This module is open to the people who want to elevate their business growth. Secure your position as an asset to the organization by learning SQL. Make your professional skill more productive by learning data analysis and SQL communication. The course exposes to you the details on computational and data investigational methods. It also highlights the basics of extracting data from the database storage. On completion of this online course, you will have an extensive understanding of how the database works and ways to function them properly, and thus be able to make critical decisions like a professional. What you'll learn At the end of this course, you will have the ability to run your own data projects, work with databases and manage large datasets and provide meaningful business intelligence reports to your team. Requirements Be familiar with reports and data-based projects. Who this course is for: This course is aimed at business professionals who work with data of all sizes. You will learn the fundamentals of business intelligence and basic data warehouse development. Introduction Business and Data Analysis with SQL FREE 00:06:00 Database and Datawarehouse Design Introduction to Databases- A History 00:04:00 SQL Statement Categories 00:02:00 Capture data requirements 00:09:00 Physical Vs Logical Data Representations 00:03:00 Normalise data 00:07:00 Fact Tables 00:04:00 Aggregate data 00:07:00 Entity Relationship Diagrams (ERD's) 00:07:00 Extract, Transform and Load (ETL) 00:13:00 Structured Query Language (SQL) - Fundamentals MySQL Server Setup 00:05:00 MySQL Server Start and stop Service 00:02:00 Connect to database 00:07:00 Comments in SQL 00:05:00 Select data from a table 00:16:00 Table Indexes 00:08:00 Table and Column Aliases 00:05:00 Inner Join Tables 00:02:00 Left and Right Outer Table Joins 00:04:00 Union (all) Results 00:04:00 Project Management Project Management (Agile Methodology) 00:11:00 Kanban boards 00:09:00 Prioritise Requirements using MoSCoW 00:04:00 Sales Project Sales Project - Introduction 00:05:00 Create and Drop Database 00:05:00 Query Workflow 00:09:00 Sales Project - Part 1 - Data Capture 00:15:00 Sales Project - Part 2 - Data Analysis 00:08:00 Sales Project - Part 3 - Data Summary 00:12:00 Sales Project - Part 4 - Send to production 00:09:00 MySQL Query Explain Plan 00:07:00 Common Table Expressions (WITH) 00:14:00 Data Control Language (DCL) User Administration 00:13:00 MySQL Programs MySQL Set Windows Environment Variable 00:05:00 MySQL Command Line 00:17:00 Visualising Data Export results to Excel 00:06:00 Setup MySQL ODBC (Open Database Connector) 00:11:00 Creating a report in Microsoft Excel 00:21:00 Course Certification

Have you ever wondered how data speaks its complex language? Are you curious to unlock the code and understand its intricate dialects? Welcome to our course - Data Analysis for Data Analyst - a comprehensive theoretical exploration of data and its manifold intricacies. In this Data Analysis for Data Analyst course bundle, we will journey together through a diverse range of theories and concepts, from the fundamentals of data analysis to business data interpretations, MySQL database management, GDPR UK regulations, and Excel data analysis. All without touching a single tool! This expedition will empower you to comprehend data's multifaceted universe and the essential role it plays in various sectors. With us, data is not just numbers or facts but a powerful storyteller, a strategic guide, and a rulemaker. We offer you the keys to understanding this universal language, revealing how it shapes businesses, influences decisions, and regulates processes. Join us on this enlightening path as we explore the vast, intricate world of data. Are you ready to become fluent in the language of data? The seven CPD Accredited courses are: Course 01: Basic Data Analysis Course 02: Business Data Analysis Course 03: Learn MySQL from Scratch for Data Science and Analytics Course 04: Diploma in Data Analytics with Tableau Course 05: GDPR UK Training Course 06: Google Data Studio: Data Analytics Course 07: Excel Data Analysis Learning Outcomes Grasp the foundations of data analysis Understand the application of data in a business context Gain deep knowledge about MySQL for data analysis Acquire a working knowledge of GDPR in the UK Enhance your data interpretation skills through Excel Embrace a holistic understanding of the data landscape. Diploma in Data Analysis Fundamentals: Learn to unravel the layers of data and extract meaningful insights. Business Data Analysis: Decode the relationship between data and business strategies. Learn MySQL from Scratch for Data Science and Analytics: Delve deep into the database management system MySQL, its structure, and usage in data analytics. GDPR UK Training: Understand data protection regulations in the UK context. Excel Data Analysis: Uncover how Excel is more than just a spreadsheet application for data analysis. Theoretical Approach: Our course provides a theoretical exploration of data analytics, allowing you to understand data beyond its application. Comprehensive Bundle: This well-rounded course offers a unified approach to understanding data in diverse fields. So, are you ready to unlock the language of data? Embark on this journey today! CPD 50 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Aspiring data analysts keen on understanding data theories. Professionals looking to delve deeper into data analysis. Business enthusiasts wanting to understand the influence of data on decision making. IT professionals seeking knowledge about data protection in the UK. Career path Data Analyst - £30K to £45K/year Business Analyst - £35K to £55K/year Data Science Specialist - £50K to £70K/year GDPR Compliance Officer - £35K to £55K/year Excel Analyst - £28K to £42K/year Database Administrator (MySQL focus) - £40K to £60K/year. Certificates Certificate Of Completion Digital certificate - Included Certificate Of Completion Hard copy certificate - Included You will get a complimentary Hard Copy Certificate.

This course will enable you to master Docker fundamentals that are required for Spring Boot developers. You'll learn the essential concepts needed to create Dockerfiles for your projects using Docker, Docker Compose, Volumes and various Docker commands. You will launch multiple Docker containers for your microservices that will communicate with each other.

In a world driven by the digital realm, web design and development stand as pillars of modern communication and business. As the UK sees a burgeoning demand for professionals in this domain, with potential earnings ranging up to £50,000 annually, there couldn't be a better time to invest in honing your skills. Our "Web Design, Web Development with HTML, CSS & Bootstrap - CPD Certified" bundle unveils a comprehensive approach, delving into crucial tools like Affinity Designer, Adobe XD, Bootstrap, PHP, MySQL, GitHub, and Heroku.The bundle provides a comprehensive understanding of web design and development, offering a range of modern tools and techniques used by professionals. Whether you are a beginner looking to start from scratch or an intermediate learner hoping to upgrade your skills, this bundle has got you covered. Enrol now and start your journey towards a fulfilling career in web design and web development! This Web Design, Web Development with HTML, CSS & Bootstrap - CPD Certified Bundle Contains 6 of Our Premium Courses for One Discounted Price: Course 01: Web Design in Affinity Designer Course 02: Web Design with Adobe XD Course 03: Creative Web Design with HTML5, CSS3 and Bootstrap Course 04: Bootstrap 4 Responsive Web Development Course 05: Modern PHP Web Development w/ MySQL, GitHub & Heroku Course 06: Learn Web Development from Scratch Learning Outcomes: By the end of this Web Design, Web Development with HTML, CSS & Bootstrap bundle course, learners will be able to: Master designing aesthetically pleasing web interfaces. Learn to create user-friendly designs with Adobe XD. Gain insights into HTML5, CSS3 and Bootstrap web design. Understand responsive web development using Bootstrap 4. Learn modern PHP web development strategies with MySQL. Get acquainted with using GitHub and Heroku for web development. Start from the basics and excel in comprehensive web development. The Web Design and Web Development Bundle opens up a world of digital creativity, offering a robust understanding of six essential web design and development platforms. Each course provides a deep dive into a unique aspect of web development, presenting you with a broad range of skills and knowledge. Through this bundle, you'll gain proficiency in Affinity Designer and Adobe XD, two powerful tools for creating intuitive and visually appealing web interfaces. Delve into the world of HTML5, CSS3, and Bootstrap, the cornerstones of responsive web design. Modern PHP Web Development with MySQL, GitHub & Heroku will introduce you to backend development, allowing you to create robust and dynamic websites. Whether you're starting your web development journey or looking to refine your skills, this bundle is your comprehensive guide to the world of web design and development. CPD 60 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Web Design, Web Development with HTML, CSS & Bootstrap bundle is ideal for: Aspiring Web Designers Budding Web Developers Future Backend Developers Enthusiastic Digital Creatives Requirements You will not need any prior background or expertise to enrol in this bundle! Career path Web Designer Front-end Developer Back-end Developer Full-stack Developer UI/UX Designer Web Development Project Manager Certificates Digital certificate Digital certificate - Included Hard copy certificate Hard copy certificate - £29 If you are an international student, you will be required to pay an additional fee of 10 GBP for international delivery, and 4.99 GBP for delivery within the UK, for each certificate

Delve into the fascinating realm of web application development with our comprehensive course, 'Web Applications for Specialisation on Development.' Tailored for aspiring web developers, this program offers an extensive curriculum covering everything from CSS intricacies to advanced PHP and MySQL techniques. Picture yourself mastering the art of web design and backend programming, a skillset highly sought after in today's digital landscape. The course sets off with a thorough introduction to CSS, paving the way for more advanced topics. As you progress, you'll journey through various levels of CSS expertise, from basic to expert, equipping you with the skills to create visually stunning and responsive websites. Transitioning into the backend, the course introduces PHP, a cornerstone in web application development. Learn to manipulate strings, utilise operators, and make decisive programming decisions. PHP's control flow statements, functions, and object-oriented programming are also covered in detail, offering you a robust understanding of server-side scripting. The latter part of the course focuses on MySQL, essential for database management and operations. By the end of this course, you'll have a comprehensive understanding of both front-end styling and backend functionality, preparing you for a thriving career in web development. Learning Outcomes Master CSS from basic to expert level for front-end web design. Gain a thorough understanding of PHP for effective server-side scripting. Learn MySQL for database creation, querying, and management. Develop skills in PHP and MySQL for building dynamic web applications. Acquire expertise in error handling, data validation, and security in web development. Why choose this Web Applications for Specialisation on Development 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. Who is this Web Applications for Specialisation on Development course for? Aspiring web developers seeking comprehensive knowledge in CSS, PHP, and MySQL. IT professionals aiming to specialise in web application development. Computer science students wanting practical skills in web technologies. Front-end developers looking to expand their backend development skills. Anyone interested in building a career in web design and development. Career path Web Developer - £24,000 to £40,000 Front-End Developer - £26,000 to £42,000 Back-End Developer - £28,000 to £45,000 Full Stack Developer - £30,000 to £50,000 Database Administrator - £27,000 to £43,000 PHP Developer - £25,000 to £41,000 Prerequisites This Web Applications for Specialisation on Development does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Web Applications for Specialisation on Development 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. Certification After studying the course materials, there will be a written assignment test which you can take at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £4.99 Original Hard Copy certificates need to be ordered at an additional cost of £8.

***Want to Unlock the Secrets of Data? Become a Database Mastermind!*** The world runs on data, and Database Administrators (DBAs) are the heroes behind the scenes ensuring its smooth operation. Database administrators in the UK are in high demand, with an average salary of £41,501 per year. The job market is expected to grow by 9% in the next few years, so now is a great time to start a career as a database administrator. As a database administrator, you will be responsible for the design, implementation, and maintenance of databases. You will also be responsible for ensuring the security and integrity of the data. If you are interested in a challenging and rewarding career in technology, then database administration is a great option for you. Our Database Administrator course starts with the basics of Database Administrator and gradually progresses towards advanced topics. Therefore, each lesson of this Database Administrator course is intuitive and easy to understand. Learning Outcomes By the end of this Database Administrator course, you'll be able to: Install and configure MySQL Server and MySQL Workbench. Create, manage, and manipulate databases and tables using SQL. Insert, update, and delete data efficiently. Design and implement database relationships to ensure data integrity. Utilize aggregate functions to summarize and analyze data. Reverse engineer existing databases and forward engineer data models. Why would you choose the Database Administrator course from Compliance Central: Lifetime access to Database Administrator course materials Full tutor support is available from Monday to Friday with the Database Administrator course Learn Database Administrator skills at your own pace from the comfort of your home Gain a complete understanding of Database Administrator course Accessible, informative Database Administrator learning modules designed by experts Get 24/7 help or advice from our email and live chat teams with the Database Administrator Study Database Administrator in your own time through your computer, tablet or mobile device A 100% learning satisfaction guarantee with your Database Administrator Course Database Administrator Curriculum Breakdown of the Database Administrator Course Unit 01: Introduction Gain foundational knowledge of MySQL Server and databases, including installation and initial setup. Module 01: Introduction to MySQL Server and Databases Module 02: Download and Install MySQL Server and MySQL Workbench Unit 02: Manipulating Tables and Data - CRUD Operations Learn to manage databases through creating, reading, updating, and deleting (CRUD) data in SQL and MySQL Workbench. Module 01: Connect and Create a Database Module 02: Drop or Remove Database Module 03: Create an SQL Database Table Module 04: Insert Data into the Table with SQL Script Module 05: Insert Data into the Table with Workbench Module 06: Select Data from the Table with SQL Script Module 07: Select Data with Filters Module 08: Update Data in the Table Module 09: Delete Data from the Table Module 10: Reverse Engineer Database into Model Module 11: Forward Engineer Data Model into Database Unit 03: Relationships and Foreign Keys Understand and implement relationships, foreign keys, and normalization in databases, enhancing data integrity and querying capabilities.ys Module 01: What are Relationships, Foreign Keys and Normalization? Module 02: Create Relationships with Data Modeling Module 03: Create Relationships with Workbench Table Design Tool Module 04: Insert Records in Related Tables Module 05: Run Queries on Related Tables (Inner Joins) Module 06: Left, Right and Cross-Joins Unit 04: Aggregate Functions Explore aggregate functions to perform calculations on data sets, including grouping, averaging, counting, and summing data. Module 01: Grouping Data using SQL GROUP BY Clause Module 02: SQL AVG Aggregate Function Module 03: SQL COUNT Aggregate Function Module 04: SQL MIN & MAX Aggregate Functions Module 05: SQL SUM Aggregate Function Module 06: Splitting Groups using HAVING Clause CPD 10 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This Database Administrator course is ideal for: Individuals with an interest in data management and database systems. IT professionals seeking to expand their skillset and transition into a Database Administrator role. Business analysts who want to gain a deeper understanding of data structures and manipulation techniques. Anyone passionate about building and maintaining robust and efficient databases. Those looking to enhance their career prospects in the ever-growing field of data. Requirements To enrol in this Database Administrator course, all you need is a basic understanding of the English Language and an internet connection. Career path A successful career as a Database Administrator can open doors to exciting opportunities. Here are some potential career paths to consider: Database Administrator Database Analyst Database Architect Data Warehouse Specialist Business Intelligence Analyst Data Scientist (with further specialization) Database Security Specialist Certificates CPD Accredited PDF Certificate Digital certificate - Included CPD Accredited PDF Certificate CPD Accredited Hard Copy Certificate Hard copy certificate - £10.79 CPD Accredited Hard Copy Certificate Delivery Charge: Inside the UK: Free Outside of the UK: £9.99 each