Course Highlights
Gain the skills and credentials to kickstart a successful career and learn from the experts with this step-by-step training course. This Learn MySQL from Scratch for Data Science and Analytics course has been specially designed to help learners gain a good command of Learn MySQL from Scratch for Data Science and Analytics , providing them with a solid foundation of knowledge to become a qualified professional.
Through this Learn MySQL from Scratch for Data Science and Analytics course, you will gain both practical and theoretical understanding of Learn MySQL from Scratch for Data Science and Analytics that will increase your employability in this field, help you stand out from the competition and boost your earning potential in no time.
Not only that, but this training includes up-to-date knowledge and techniques that will ensure you have the most in-demand skills to rise to the top of the industry. This qualification is fully accredited, broken down into several manageable modules, ideal for aspiring professionals.
Learning outcome
- Familiar yourself with the recent development and updates of the relevant industry
- Know how to use your theoretical knowledge to adapt in any working environment
- Get help from our expert tutors anytime you need
- Access to course contents that are designed and prepared by industry professionals
- Study at your convenient time and from wherever you want
Course media
Why should I take this course?
- Affordable premium-quality E-learning content, you can learn at your own pace.
- You will receive a completion certificate upon completing the course.
- Internationally recognized Accredited Qualification will boost up your resume.
- You will learn the researched and proven approach adopted by successful people to transform their careers.
- You will be able to incorporate various techniques successfully and understand your customers better.
Requirements
- No formal qualifications required, anyone from any academic background can take this course.
- Access to a computer or digital device with internet connectivity.
Course Curriculum
-
Introduction
00:03:00 -
How to get course requirements
00:03:00
-
Getting started on Windows, Linux or Docker
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
-
REVOKE permissions
00:04:00
-
GRANT permissions
00:05: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
-
Duration:5 hours, 49 minutes
-
Access:1 Year
-
Units:88
Want to get everything for £149
Take Lifetime Pack
