Description

The Learn MySQL from Scratch for Data Science and Analytics is all you need to advance your career in the relevant fields.

Enrol now to discover everything you need to know about The Learn MySQL from Scratch for Data Science and Analytics and the skills to improve your talents in this field and be confident in your knowledge bucket with One Education as your right hand!

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.

Course Images

Learn MySQL from Scratch for Data Science and Analytics Course

By One Education

Booking options

Highlights

Description

About The Provider

Tags

Reviews