Skip to content
MySQL Course Training cover image

MySQL Course Training
Frontier Education

Free eCertificate | Limited time | SQL Masterclass | Tutor Support | Video Lessons

Summary

Price
£15 inc VAT
Study method
Online, On Demand 
Course format
19 Videos (with subtitles and transcripts)
Duration
2.2 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Reed courses certificate of completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Overview

This MySQL course includes a whole host of practical tips and advice, helping you to develop yourMySQL courseskillsto become the marketeryou can be.

Packed with videos, PDFs and exercises, it'll equip you with what it takes to be a successfulmarketer in today’s business landscape, covering a broad range of topics, from MySQL server basics to database models.

Certificates

Curriculum

This course contains

Format: 19 Videos (with subtitles and transcripts)

Duration: 2h and 14m

Description

With expert guidance and a combination of videos, PDFs, and worksheets, this course will enable you to develop your User Behaviour Analysis, become a Data Analyst and unlock your full potential.

This MySQL Course course covers:

  1. Database Models : what you need to know
  2. ER Model Overview: tailoring your approach to maximise impact
  3. Mastering Make Data-driven Decisions
  4. Find Actionable Customer/business Insights
  5. Measure & Track Marketing Efforts

You’ll also be able to access a number of exclusive bonus resources to help you along your MySQL Course journey, including:

  • Data Types
  • Basics Queries
  • Data Filters Using Operators

Course Curriculum :

Section 1 Introduction

  • Intro

Section 2 Installation

  • Installing Xampp

Section 3 First Steps and Basics

  • Creating and dropping DBs
  • Creating Tables
  • Dropping Tables
  • Inserting into Tables
  • Updating and Deleting
  • Data Types
  • Operators

Section 4 Constraints and Functions

  • Primary Keys
  • Foreign Keys
  • Functions

Section 5 Clauses

  • Select with Where
  • Order By
  • Group By

Section 6 Alters

  • Alters

Section 7 Joins

  • Aliases
  • Inner Join
  • Left and Right Joins

Top reasons to Study Online at Frontier Education

  • Tailor made: Course adapted to market needs and interests
  • Flexible programs: study and work at your own pace on easy-to-use web platforms
  • Online education: progressive teaching methods with video or easy to understand medium
  • Multicultural: connect with classmates from all corners of the globe

Who is this course for?

This MySQL Course is ideal for people looking to progress their career into a Marketer, for those who want to become Data Analyst, as well as looking to further develop their skills and knowledge.

Requirements

  • MySQL Workbench and Community Server for Mac or Windows/PC (we’ll walk you through the free install process)

  • Students are expected to have completed our SQL for Beginners course, and have a solid grasp of SELECT statements, aggregate functions, and table joins

Questions and answers

There are currently no Q&As for this course. Be the first to ask a question.

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

FAQs

Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: Zopa Bank, Level 12, 20 Water Street, Canary Wharf, London E14 5GX. VAT Number 281765280.