What you'll learn

Grasp fundamentals of Databases, MySQL
Comfortably navigate MYSQL Workbench
Manipulate data in MySQL using SQL
Master common SQL commands in MySQL Database
Import Data from Excel, CSV files into MySQL
Export data from MySQL into Excel or CSV Files
Use MySQL database with Tableau

Course content

6 sections • 22 lectures • 1h 21m total length

Introduction0:44

How databases are structured3:09
Understanding a schema in MySQL3:09
Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.
Sakila Sample Database in MySQL2:03
In some environments such as Mac, you might not get Skila database by default. This lecture shows you how to add it so that you can follow along.
Database Structure Quiz

Your First SQL statement in MySQL2:39
SELECT is the statement that you will end up using majority of the time. Learn how to write a SELECT statement to find the data that you are looking for.
Inserting a new record1:07
Limiting the result set with WHERE clause5:33
Learn how to use WHERE clause to narrow down your data. Learn the usage of AND and OR operators to narrow down your result set.
Sorting your result set4:01
This lecture will show you how to sort the result set to give you the order that you need.
Using Numeric and Date Values to narrow down your result set3:25
You will learn how to use numeric and date values to narrow down your result set along with string values to get exactly the result set that you need. You will learn about =, >,<, >=, <= and between clauses.
Updating exiting records3:23
Marketing database are full of erroneous data. This lecture will teach you how to fix the data issues when you find them.
Deleting records3:41
Aggregating the data4:32
Counting and summing are two common functions that Marketers need to do to identify their targets. Learn the syntax in this lecture.
Getting data from multiple tables6:44
You will learn how to join multiple tables and use of table alias.
Practice your skills

Creating a new table11:11
Generally this is done by a DBA but it is good to know in case you have to create a new table.
Some advanced table commands.8:53
Learn following advanced table manipulation commends

Get a list of columns and column information of a table
Change the name of a table
Delete all the data from a table
Delete a table
How to import data from a CSV file into MySQL2:58
Many times the data is available in a csv file (comma separated values file) that needs to be imported in the database to combine it with other data or further manipulation. This lecture will show you how ti import that data into the database.
How to import data in Excel to mySQL4:04
Learn how to export Microsoft Excel data to mySQL.
Bonus Lecture0:18

Requirements

Basic computer skills

Description

Cut the unnecessary jargon and learn SQL with MySQL in a simple and easy way.

Data is a critical part of any job these days. Having SQL skills will help you accomplish many of the data task that your job requires. Whether you are trying to add new skills to enhance your career or looking for a new job, this course will help you add a critical skill that many jobs and employers seek today. SQL skills help you succeed in a large number of careers that range from technical to business.

This course will teach you everything you need to start using SQL and practicing SQL with MySQL.

You don't need hours of lectures to learn SQL and MySQL, that's exactly how I approached this course. I synthesized the information so that it is quick and easy to understand.

In this course I have simplified the process without getting into all the complex technical speak out so that anybody can learn SQL. This course is designed to make each step very easy to understand. I used the same methods that I use to teach business analysts and marketing analysts in my own group.

The course should not take full day, you can learn during your work day and practice as you go.

This course uses MySQL but most of the commands can also be applied to SQL Server.

Note: This is a beginner level course. If you have prior knowledge of SQL than this course might serve as refresher but won't teach you many advanced concepts.

Why you should learn from me?

I have been in Digital Marketing and Analytics for over 15 years. I have trained people from diverse backgrounds and have converted them into high performing Digital Marketers and Analysts. I understand both the technology and marketing side of business. I have dealt with many analytics technologies way before Google Tag manager existed and know the inner working of Digital Analytics.

In addition, I have developed various course and taught students from all over the world. I am online instructor for University of British Columbia (Canada), University of Washington (USA), Bellevue College (USA) and Digital Analytics Association.

Who this course is for:

This course is for anybody who deals with data in their job and has no SQL background, this course will help them gain a valuable skills required to do their job.
New graduates who are trying to get a job. Data is an essential part of every job these days. This course will add a valuable skill to the resume.
Anybody who wants to learn the fundamentals of SQL.
Anybody who wants to learn MySQL workbench
Anybody who wants to learn the fundamentals of MySQL

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 1min

Installation and Overview of SQL Environment (MySQL)2 lectures • 5min

Database Fundamentals3 lectures • 8min

Writing SQL Queries in MySQL9 lectures • 35min

Data manipulation outside the database2 lectures • 5min

Beyond Data Manipulation5 lectures • 27min

Requirements

Description

Who this course is for: