Learn MySQL from Scratch for Data Science and Analytics

One Education

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).

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.

This Learn MySQL from Scratch for Data Science and Analytics course is open to all, with no formal entry requirements.

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.