Learn SQL using MySQL in A Day - Go from 0 to Hero in a day
3.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,053 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL using MySQL in A Day - Go from 0 to Hero in a day to your Wishlist.

Add to Wishlist

Learn SQL using MySQL in A Day - Go from 0 to Hero in a day

Get up to speed on SQL, a skill that employers seek these days. Data and SQL are must have skills for any job.
3.9 (18 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,053 students enrolled
Created by Anil Batra
Last updated 4/2017
English
Current price: $10 Original price: $75 Discount: 87% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Learn fundamentals of Databases and SQL
  • Learn SQL commands required to learn SQL
View Curriculum
Requirements
  • Basic computer skills
Description

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. I used to be a technical guy who turned into a marketer.  In this course I have taken 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.  

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 advanced concepts.

Who is the target audience?
  • 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.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 00:44
+
Installation and Overview of SQL Environment (MySQL)
2 Lectures 04:57

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:22
+
Database Fundamentals
2 Lectures 06:18

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 this quiz you will be tested on what you just learned.

Database Structure Quiz
1 question
+
Writing Queries
8 Lectures 33:58

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
02:39

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
About the Instructor
Anil Batra
3.9 Average rating
27 Reviews
1,096 Students
2 Courses
Speaker, Instructor - Digital Marketing and Analytics Leader

Anil is a seasoned Digital Marketing and Analytics professional with 15 years of experience. He has worked with companies ranging from Fortune 50 to startups and has helped them improve marketing results. His customers include Microsoft, SmartMoney, ESPN, T-Mobile, Hoovers, RealNetworks, Starbucks, and TheStreet. He holds a B. Tech in Electronics and Communication Engineering from India and an MBA from University of Washington, Seattle.

Anil has taught and trained several Marketing and Analytics folks in past nine years of teaching at UBC, University of Washington and Bellevue College, and speaking engagements at various conferences as well as his blog. He teaches Digital Marketing, Digital Analytics, Google Analytics, Tableau and Social Media courses. He also served on the Board of Digital Analytics Association (DAA) and was instrumental in starting the DAA Symposiums.