SQL with MySQL Database for Beginners - Zero to Hero
4.6 (132 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,455 students enrolled

SQL with MySQL Database for Beginners - Zero to Hero

Step by Step SQL with MySQL Database for Beginners, Non-Techs, newbs - Quick way to learn SQL using MySQL Database
4.6 (132 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,455 students enrolled
Created by Anil Batra
Last updated 11/2018
English
English [Auto-generated]
Current price: $109.99 Original price: $199.99 Discount: 45% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 2 articles
  • 1 downloadable resource
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 3,500+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Expand all 22 lectures 01:21:39
+ Installation and Overview of SQL Environment (MySQL)
2 lectures 04:56

First step of learn SQL is to get familiar with the interface on where you will be writing SQL. This lecture teaches you exactly that.

Preview 03:35

First step of learn SQL is to get familiar with the interface on where you will be writing SQL. This lecture teaches you exactly that.

Preview 01:21
+ Database Fundamentals
3 lectures 08:39

Before you can write SQL it is critical to understand what all is in the database. This lecture will help you with it.

Preview 03:09

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.

Sakila Sample Database in MySQL
02:21

In this quiz you will be tested on what you just learned.

Database Structure Quiz
1 question
+ Writing SQL Queries in MySQL
9 lectures 35:05

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.

Your First SQL statement in MySQL
02:39
Inserting a new record
01:07

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.

Limiting the result set with WHERE clause
05:33

This lecture will show you how to sort the result set to give you the order that you need.

Sorting your result set
04:01

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.

Using Numeric and Date Values to narrow down your result set
03:25

Marketing database are full of erroneous data. This lecture will teach you how to fix the data issues when you find them.

Updating exiting records
03:23
Deleting records
03:41

Counting and summing are two common functions that Marketers need to do to identify their targets. Learn the syntax in this lecture.

Aggregating the data
04:32

You will learn how to join multiple tables and use of table alias.

Getting data from multiple tables
06:44

Let;s practice what you have learned.

Practice your skills
6 questions
+ Data manipulation outside the database
2 lectures 05:22

Learn how to export the data from database into Excel for further manipulation

Exporting Data from MySQL to Excel
02:04

Learn how to connect the data to data visualization tools such as Tableau to create graphs and charts in Tableau.

Connecting Data Visualization tools such as Tableau to mySQL
03:18
+ Beyond Data Manipulation
5 lectures 27:11

Generally this is done by a DBA but it is good to know in case you have to create a new table.

Creating a new table
11:11

Learn following advanced table manipulation commends

  1. Get a list of columns and column information of a table
  2. Change the name of a table
  3. Delete all the data from a table
  4. Delete a table


Some advanced table commands.
08:53

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 from a CSV file into MySQL
02:58

Learn how to export Microsoft Excel data to mySQL.

How to import data in Excel to mySQL
04:04
Bonus Lecture
00:05
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