Key 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
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
Complete This CPD Accredited Course & Get Your Framed Certificate!
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
Training Express
185 Courses
Training Express is a leading course provider, established by a dedicated team of experts working across the UK. We deliver accredited certification and training to UK businesses looking to improve organisational performance. Our comprehensive courses cover a broad range of sectors and industries, with a focus on promoting high standards of food hygiene, business wellbeing and safety in the workplace.
