996 Courses in Leeds delivered Online

Data speaks volumes—if you know how to listen. This course offers a clever route into the world of MySQL, showing you how structured data can turn into smart decisions. Whether you're sifting through figures, building dashboards, or deciphering patterns, understanding SQL isn’t just helpful—it’s essential. You’ll be guided through the foundations of MySQL with clarity and precision, making sense of tables, queries, joins, and more—all without the fluff or confusion. Designed with the analytical mind in focus, this course shines a light on how MySQL powers insights behind the scenes in data science and analytics. It's tailored for learners who prefer clarity over jargon and structure over noise. If you're curious about how databases work and how data fuels smart outcomes, this course is your ideal stepping stone—organised, engaging and purposefully built for those who appreciate logic and clean learning paths. Expert Support Dedicated tutor support and 24/7 customer support are available to all students with this premium quality course. Key Benefits Learning materials of the Design course contain engaging voiceover and visual elements for your comfort. Get 24/7 access to all content for a full year. Each of our students gets full tutor support on weekdays (Monday to Friday) Course Curriculum: Section 01: Getting Started Introduction How to get course requirements Getting started on Windows, Linux or Mac How to ask great questions FAQ's What is Source Code? Section 02: SQL Server setting up Section Introduction MySQL Server Installation Connect MySQL Server Instance MySQL Workbench overview Download and Restore Sample Database Section 03: SQL Database basics Section Introduction Overview of Databases Creating Database SQL Data Types Column Data Types on Workbench Creating Table Overview of Primary and Foreign Key Primary Key Foreign Key Creating Temporary tables EER - Enhanced Entity Relationship Diagrams Section 04: SQL DML (Data Manipulation Language) Section Introduction Insert statement Update statement Delete statement Section 05: SQL DDL (Data Definition Language) Section Introduction CREATE table statement DROP statement ALTER statement TRUNCATE statement COMMENT in query RENAME table Section 06: SQL DCL (Data Control Language) Create Database user GRANT permissions REVOKE permissions Section 07: SQL Statement Basic Section Introduction SQL Statement basic SELECT Statement SELECT DISTINCT SELECT with column headings Column AS statement DASHBOARD Analytics Section 08: Filtering Data rows SELECT WHERE Clause - theory SELECT WHERE Clause - practical Section 09: Aggregate functions for Data Analysis Sum() Min()-Max() Section 10: SQL Data Analyticstatements Order By statement SELECT TOP 3 records BETWEEN command IN operator Search Data usingLIKE cards Section 11: SQL Group by statement Section Introduction Group by - theory Data Analytics with Group By HAVING statement Section 12: JOINS Overview of Joins What are Joins Inner join Left outer join Right outer join Union CERTESIAN Product or Cross Join Query Exercise Solution for Query Exercise Section 13: SQL Constraints Section introduction Check constraint NOT NULL constraint UNIQUE constraint Section 14: Views Creating Views Data Analytic Viewsfrom multiple tables Section 15: Advanced SQL Functions Section Introduction Timestamp Extract from timestamp Mathematical scalar functions String functions Advanced functions Sub Queries SELECT with calculations Section 16: SQL Stored procedures Create stored procedure Stored procedure with parameter Drop Procedure Section 17: Import & Export data Section Introduction Import .csv file Export Data to .csv file Section 18: Backup and Restore Database Section Introduction Creating Database backup Restoring Database backup Exam & Retakes: It is to inform our learners that the initial exam for this online course is provided at no additional cost. In the event of needing a retake, a nominal fee of £9.99 will be applicable. Certification Upon successful completion of the assessment procedure, learners can obtain their certification by placing an order and remitting a fee of £9 for PDF Certificate and £15 for the Hardcopy Certificate within the UK ( An additional £10 postal charge will be applicable for international delivery). Who is this course for? This Learn MySQL from Scratch for Data Science and Analytics course is designed to enhance your expertise and boost your CV. Learn key skills and gain a certificate of achievement to prove your newly-acquired knowledge. Requirements This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements. Career path Upon successful completion of The Learn MySQL from Scratch for Data Science and Analytics Course, learners will be equipped with many indispensable skills and have the opportunity to grab.

A comprehensive package for beginners to learn how to automate social media applications such as WhatsApp, YouTube, and Facebook from scratch using Python. The course will help you understand the impact of social media automation in real-world applications and provide a unique hands-on experience in developing different real-time exciting projects.

Discover the power of data science and machine learning with Python! Learn essential techniques, algorithms, and tools to analyze data, build predictive models, and unlock insights. Dive into hands-on projects, from data manipulation to advanced machine learning applications. Elevate your skills and unleash the potential of Python for data-driven decision-making.

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.

All about containers, Docker, and Kubernetes for Python engineers.

Data scraping is used to get the data available on different websites and APIs. This also involves automating the web flows to extract the data from different web pages. Data Scraping and Data Mining with Python is a well-designed course for beginners to develop a solid groundwork for the skills necessary.

The underlying patterns in your data hold vital insights; unearth them with cutting-edge clustering and classification techniques in R

Whether you work in machine learning or finance or are pursuing a career in web development or data science, Python is one of the most important skills you can learn. Python's simple syntax suits desktop, web, and business applications. Python's design philosophy emphasizes readability and usability. The average python developer salary in the United Kingdom is £55,000 per year or £28.21 per hour. Entry-level positions start at £42,500 per year, while most experienced workers make up to £77,500 per year. So enrol in this Python Coding Specialist (PCS) bundle and become a specialist. Along with this Python course, you will get 10 premium courses, an original hardcopy, 11 PDF Certificates (Main Course + Additional Courses) Student ID card as gifts. This Python Coding Specialist (PCS) Bundle Consists of the following Premium courses: Course 01: Python Programming for Everybody Course 02: Data Science with Python Course 03: Machine Learning with Python Course 04: Learn to Use Python for Spatial Analysis in ArcGIS Course 05: Higher Order Functions in Python - Level 03 Course 06: Introduction to Data Analysis Course 07: Data Structures Complete Course Course 08: Basic Google Data Studio Course 09: Business Intelligence and Data Mining Masterclass Course 10: Cyber Security Incident Handling and Incident Response Course 11: Decision Making and Critical Thinking Enrol now in Python Coding Specialist (PCS) to advance your career, and use the premium study materials from Apex Learning. Python Coding Specialist (PCS) The bundle incorporates basic to advanced level skills to shed some light on your way and boost your career. Hence, you can strengthen your Python Coding Specialist (PCS) expertise and essential knowledge, which will assist you in reaching your goal. Moreover, you can learn from any place in your own time without travelling for classes. Course Curriculum : Module 01 A Installing Python Documentation Command Line Variables Simple Python Syntax Keywords Import Module Module 02 Additional Topics If Elif Else Iterable For Loops Execute Exceptions Module 03 Module 04 Module 05 Certificate: PDF Certificate: Free (Previously it was £6*11 = £66) Hard Copy Certificate: Free (For The Title Course: Previously it was £10) CPD 110 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Python Coding Specialist (PCS) Anyone from any background can enrol in this Python Coding Specialist (PCS) bundle. Requirements Python Coding Specialist (PCS) This Python Coding Specialist (PCS) course has been designed to be fully compatible with tablets and smartphones. Career path Python Coding Specialist (PCS) Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Digital certificate - Included Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Python Programming for Everybody) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost.

The goal of this course is to use Python machine learning to create algorithms that you can use in the real world. You'll start with the basics of machine learning. You'll learn how to create, train, and optimize models and use these models in real-world applications.

Get Hard Copy + PDF Certificates + Transcript + Student ID Card worth £160 as a Gift - Enrol Now Whether you work in machine learning or finance or are pursuing a career in web development or data science, Python is one of the most important skills you can learn. Python's simple syntax is especially suited for desktop, web, and business applications. Python's design philosophy emphasizes readability and usability. Python was developed upon the premise that there should be only one way (and preferably one obvious way) to do things, a philosophy that has resulted in a strict level of code standardization. The core programming language is quite small and the standard library is also large. In fact, Python's large library is one of its greatest benefits, providing a variety of different tools for programmers suited for many different tasks. This Python Bundle Consists of the following Premium courses: Course 01: Python Programming for Everybody Course 02: Data Science with Python Course 03: Machine Learning with Python Course 04: Learn to Use Python for Spatial Analysis in ArcGIS Course 05: Higher Order Functions in Python - Level 03 Course 06: Introduction to Data Analysis Course 07: Data Structures Complete Course Course 08: Basic Google Data Studio Course 09: Computer Science: Graph Theory Algorithms Course 10: Cloud Computing / CompTIA Cloud+ (CV0-002) Course 11: Business Intelligence and Data Mining Masterclass Course 12: Cyber Security Incident Handling and Incident Response Course 13: Decision Making and Critical Thinking Decision Making and Critical Thinking Course 14: Time Management Benefits you'll get from choosing Apex Learning: Pay once and get lifetime access to 14 CPD courses Free e-Learning App for engaging reading materials & helpful assistance Certificates, student ID for the Courses included in a one-time fee Free up your time - don't waste time and money travelling for classes Accessible, informative modules of Courses designed by expert instructors Learn about Courses at your ease - anytime, from anywhere Study the Courses from your computer, tablet or mobile device CPD accredited Courses - improve the chance of gaining professional skills Curriculum : Course 01: Python Programming for Everybody This Python's curriculum has been designed by experts with years of experience behind them. The Python course is extremely dynamic and well-paced to help you understand with ease. You'll discover how to master the skill while exploring relevant and essential topics. Module 01 A Installing Python Documentation Command Line And much more... Module 02 Additional Topics If Elif Else Iterable For And much more... Module 03 Number Types More Number Types Strings More Strings And much more... Module 04 Comprehensions Definitions Functions Default Arguments And much more... Module 05 Function Objects Lambda Generators Closures And much more... How will I get my Certificate? After successfully completing the course you will be able to order your CPD Accredited Certificates (PDF + Hard Copy) as proof of your achievement. PDF Certificate: Free (For The Title Course) Hard Copy Certificate: Free (For The Title Course) CPD 140 CPD hours / points Accredited by CPD Quality Standards Who is this course for? Anyone from any background can enrol in this bundle. Requirements Our course is fully compatible with PCs, Macs, laptops, tablets and Smartphone devices. Career path Having this expertise will increase the value of your CV and open you up to multiple job sectors. Certificates Certificate of completion Hard copy certificate - Included You will get the Hard Copy certificate for the title course (Python Programming for Everybody) absolutely Free! Other Hard Copy certificates are available for £10 each. Please Note: The delivery charge inside the UK is £3.99, and the international students must pay a £9.99 shipping cost. Certificate of completion Digital certificate - Included You will get the PDF Certificate for the title course (Python Programming for Everybody) absolutely Free!