Course Types
Course Categories
Animal Care
(27 Courses)
Art
(7 Courses)
Business
(46 Courses)
Care
(47 Courses)
Chemistry & Biology
(18 Courses)
Construction & Architecture
(10 Courses)
Cooking & Baking
(8 Courses)
Culture & Tradition
(5 Courses)
Design
(20 Courses)
Environment
(17 Courses)
Fashion & Beauty
(2 Courses)
Finance
(32 Courses)
Health
(204 Courses)
Hospitality
(22 Courses)
HR
(26 Courses)
IT
(45 Courses)
Language
(8 Courses)
Law & Regulations
(12 Courses)
Management
(85 Courses)
Marketing & Sales
(26 Courses)
Office Skill
(20 Courses)
Personal Development
(63 Courses)
Profession
(28 Courses)
Project Management
(10 Courses)
Property & Surveying
(8 Courses)
Safety
(22 Courses)
Science
(14 Courses)
Service
(26 Courses)
Teaching & Academics
(67 Courses)
Travel & Tourism
(2 Courses)
Writing
(8 Courses)Accident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Explore Course Categories
- Explore Course Categories
-
Environment
17 Courses -
Health
204 CoursesHealth View AllAccident & Injuries
Anxiety
Clinical Care
Dementia
Diet
Disability
Food Safety
Health & Safety
Health And Fitness
Healthcare
Hygiene
Medical Administration
Medicine & Treatment
Mental Health
Nursing
Nutrition
Pharmacology
Physical Therapy
Physiology
Physiotherapy
Prevention & Control
Substance Abuse
Therapy
Trauma
-
Language
8 Courses -
Management
85 Courses -
Marketing & Sales
26 Courses -
Personal Development
63 Courses -
Science
14 Courses -
Service
26 Courses
-
Explore Careers Categories
-
All Courses
-
Get Adams Premium (Remove Ads)
-
Adams Blog
-
Resume Builder
-
Adams For Business
-
Download the Adams App
Welcome Back!
What will you learn today? Find out with Adams Academy
Sign Up For Free
Join the World's Largest Free Learning Community
-
Welcome Back!
- Don't have an Adams account? Sign Up
or -
Sign Up For Free
Join the World’s Largest Free Learning Community
- Already have an Adams account? Log In
orThis is the name that will appear on your Certification
-
Forgot password?
Please enter you email address and we will mail you a link to reset your password.
This course includes:
-
5 hours, 46 minutes -
CPD Accreditation
-
88 units
-
Full lifetime access
-
Access on mobile and TV
-
Certificate of completion
Share:
course plublisher
Course CloudKey Concepts Covered by This Free Course
- Introduction to MySQL and its setup.
- Basic concepts of SQL databases, including data manipulation and definition languages.
- Understanding SQL statements and their use in filtering data rows.
- Advanced SQL commands like joins, constraints, and views.
- In-depth exploration of SQL stored procedures and their use.
- Import and export of data and backup and restore of databases.
- Data analytics and using MySQL for data analysis.
Course Overview
Are you interested in data science and analytics? Then, our Learn MySQL from Scratch for Data Science and Analytics course is the perfect starting point. This free course covers all the essential concepts you need to know to become proficient in MySQL database management and data analysis.
In this course, you’ll learn the basics of MySQL databases and SQL statements, including data manipulation, definition languages, and filtering data rows. You’ll also explore advanced concepts like joins, constraints, and views. Our comprehensive course will guide you through the materials and ensure that you have the skills and knowledge to use MySQL for data analysis.
Course Benefits
Our Learn MySQL from Scratch for Data Science and Analytics course provides you with valuable skills that can significantly impact your career prospects in the field of data science and analytics. You will learn how to manage and analyse data using one of the most popular and widely used database management systems, giving you an advantage in the job market.
By the end of the course, you’ll be able to understand how to import and export data, backup and restore databases, and perform data analytics using MySQL. The knowledge and skills you acquire will help you to improve your efficiency and effectiveness in managing and analysing data, making you an asset to any team working in data science and analytics.
Career Path
- Data Analyst: Analyzing data to identify patterns and trends, creating reports, and presenting insights to stakeholders.
- Database Administrator: Responsible for the installation, configuration, and maintenance of database management systems, including MySQL.
- Business Intelligence Analyst: Extracting and analysing data to provide insights for business decision-making.
- Data Scientist: Designing and implementing data-driven models and algorithms to solve complex business problems.
- Data Engineer: Building and maintaining data pipelines and infrastructure to enable data analysis and processing.
Course content
Introduction -
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 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 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 Introduction 00:01:00
-
Insert statement 00:07:00
-
Update statement 00:06:00
-
Delete statement 00:03:00
-
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
-
Create Database user 00:03:00
-
GRANT permissions 00:05:00
-
REVOKE permissions 00:04:00
-
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
-
SELECT WHERE Clause – theory 00:03:00
-
SELECT WHERE Clause – practical 00:06:00
-
Sum() 00:06:00
-
Min()-Max() 00:03:00
-
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 Introduction 00:01:00
-
Group by – theory 00:04:00
-
Data Analytics with Group By 00:04:00
-
HAVING statement 00:03:00
-
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 introduction 00:01:00
-
Check constraint 00:09:00
-
NOT NULL constraint 00:03:00
-
UNIQUE constraint 00:06:00
-
Creating Views 00:03:00
-
Data Analytic Views from multiple tables 00:03:00
-
Section Introduction 00:01:00
-
Timestamp 00:03:00
-
Extract from timestamp 00:03:00
-
Mathematical scalar functions 00:03:00
-
String functions 00:07:00
-
Advanced functions 00:04:00
-
Sub Queries 00:03:00
-
SELECT with calculations 00:05:00
-
Create stored procedure 00:06:00
-
Stored procedure with parameter 00:03:00
-
Drop Procedure 00:01:00
-
Section Introduction 00:01:00
-
Import .csv file 00:04:00
-
Export Data to .csv file 00:02:00
-
Section Introduction 00:01:00
-
Creating Database backup 00:02:00
-
Restoring Database backup 00:02:00
Certify Your Skills
A CPD accredited Adams Diploma/Certificate certifies the skills you’ve learned.
Stand Out From The Crowd
Add your Adams Certification to your resume and stay ahead of the competition.
Advance in Your Career
Share your Adams Certification with potential employers to show off your skills and capabilities.
About Course Publisher
Courses
Unlock your potential with Course Cloud, the UK's leading online provider of career-enhancing skills. With everything from IT and business to healthcare and skilled trades, our diverse range of courses are researched diligently and accredit-rated. Enjoy interactive, self-paced learning through diverse formats that include instructor-led sessions, multimedia lessons and expansive study material. You could be the next to power your career with us. Don't miss out on the opportunity of learning anything at any place with unprecedented flexibility through courseware available on any device. With dedicated tutor support, Course Cloud assures a learning journey that is not just informative but transformative. Join us in taking the first step towards achieving your career aspirations. Request the information today in English (UK) language.
More Free Online Courses by This Publisher
Certificate
Complete Python from Scratch: Start your career in Python 3+
60
Lessons
17
Students
Certificate
Microsoft SQL Server Bootcamp 2022
88
Lessons
9
Students
Certificate
Email Marketing for Beginners
18
Lessons
11
Students
Certificate
Master JavaScript with Data Visualization
76
Lessons
18
Students
Certificate
C++ Programming for Absolute Beginners
77
Lessons
13
Students