Learn SQL and MySQL in 3 Hours

Understand what is SQL , Start writing Simple and Complex SQL Queries using MySQL. Very useful for Data Analysis.
4.5 (103 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,493 students enrolled
Instructed by Umang Shah Development / Databases
$19
$30
37% off
Take This Course
  • Lectures 45
  • Length 2 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2016 English

Course Description

Master SQL in less than 3 Hours :

  • Do You Want to Become a professional Software / Web Application Developer and increase your income Exponentially ?
  • Are you a Marketing Professional Who wants to use SQL for making Better Marketing Decisions ?
  • Are you a University Student Working Towards a Computer Science or Information Technology Degree ?

Then look no further as you have come to the right place. I have been working with SQL for more than 7 Years now and am currently working as an Application developer. This in-depth course on SQL taught by me covers everything from the very basic definitions to very complex concepts of RELATIONAL DATABASES , FOREIGN KEYS and JOINS so that by the time this course ends, You will have an excellent understanding of all the important concepts of SQL to get things rolling for you.

SQL can be used in almost all fields in today's technology driven world whether you are into your own business or into marketing or into development of Web / Mobile applications. You can use SQL to Analyze tons and tons of data within milliseconds and use the results of analysis to make better fact and data based decision thereby increasing the chances of arriving at a correct decision.

I can assure you that you will enjoy this course and hope that you would make the most of the knowledge you would have gained by the end of this course. Thanks and hope to see you in Lectures.

What are the requirements?

  • No Technical background required as everything will be covered from scratch

What am I going to get from this course?

  • Create SQL/MySQL based applications for companies of all shapes and sizes
  • Understand all concepts of SQL and databases
  • Analyze tons of data in few seconds
  • Make better fact based decisions
  • Spot trends and patterns easily in pile of data

What is the target audience?

  • Marketing professional who wants to make better fact based decisions
  • University students working towards computer science or IT degree
  • Analytic Users
  • Someone who loves learning everything about technology
  • Anyone who wants to know how major IT companies stores all your data

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
02:46

Understand what will be covering throughout the course

SQL Powerpoint Presentation ( For your reference )
Article
02:55

Will go over the definition / full form of SQL and what it means with the help of an example

02:09

Definition of MySQL and what are the differences between MySQL and SQL

02:33

Explain why and how to install MySQL Server

03:35

In this lecture, we will see a problem that will be faced by few after Installing XAMPP and how to solve it.

Article

A Step by Step Instructions on How to Open XAMPP Control Panel After Installation of XAMPP in Mac

02:24

Understand What is DB i.e. Database and Table

05:50

Understand how to create DB and table in MySQL server

4 questions

This quiz ensures you understood basic definitions clearly.

Section 2: Inserts , Selects and Updates
03:43

Learn How to Start Adding Data into Tables

01:36

Learn How to See existing data in Table with the help of SELECT

01:44

Explain the use of LIMIT clause with the help of an Example

02:27

Understand When and Where the 'WHERE' clause is useful

02:14

Understand How and When to use UPDATE Clause

04:23

Here you will understand how you can change TABLE structure using ALTER

03:55

Understand when and how to use AND as well as OR Clause

03:21

Understand how to get things in sorted form with the help of ORDER BY Clause

02:18

Understand how IN is a specialized form of OR clause

04:04

Understand How LIKE can be used to find patterns in a pile of data

01:19

See how to select few specific fields or columns of a table

01:45

Understand how DISTINCT can be used for finding UNIQUE values of a column in a table.

02:54

In this lecture, we will understand how you can give an alias to a field , a table or a query

6 questions

Take this Quiz to test you Knowledge of Basic SQL Queries and clauses.

Test - INSERTS , SELECTS and UPDATES
2 pages
Section 3: MySQL Datatypes and Constraints
03:46

Understand what are Datatypes and then take a look at different types of Datatypes.

02:51

First we will understand what are constraints and we will then look at different type of constraints.

Section Quiz
3 questions
Section 4: JOINS and UNIONS
Creating base for Future Lectures
04:44
08:40

Here in this lecture we will understand a very important concept of Relational Databases and Also take a look at a possible problem that might occur if necessary precautions are not taken with relational databases.

07:36

Here we will understand how a possible problem with relational databases can be avoided with the use of FOREIGN KEY Constaint

00:47

Understand what is a Join and then take a look at different type of JOINS

07:41

Understand what is a Left Join and When to Use it

02:00

Understand what is a Right Join and also how is the result of Right Join different than that of Left Join

01:34

Understand the concept of INNER JOIN

02:22

Understand what is UNION and how is it different from JOIN ?

01:58

In this lecture we will understand what is Subquery

Section Quiz
2 questions
Section 5: GROUPS and MySQL Functions
04:41

Let's take a look at some of the important MySQL Functions.

02:06

Lets take a look at GROUP BY Clause and then we can look at how we can use several MySQL Functions along with GROUP BY Clause.

01:35

First we will understand the concept of HAVING and then look at a practical example of how to use HAVING

2 questions

Take this quiz to test you Functions , GROUP BY and HAVING clause knowledge

Section 6: VIEWS
02:31

Here we will first understand what are VIEWS and what are its uses. We will then see how we can create them in MySQL Server.

01:53

Here we will Understand How to change a VIEW and also see how we can DROP a view.

Test - CREATE , ALTER and DROP VIEWs
1 page
Section 7: DELETEs , DROPs and TRUNCATEs
01:15

Here in this lecture we will see how you can delete data rows from a table

01:03

In this lecture we will first take a look at TRUNCATE table which will remove all data from table while keeping the table structure intact. The second will be DROP table which will delete data along with structure of the table and the last one is DROP Database which will remove all tables inside database along with the database itself.

2 questions

Take this quiz to make sure you understood the concepts of DELETEs, DROPs and TRUNCATEs

25+ Sample Queries
4 pages
Importing Tables and Data to your local PhpMyAdmin
Article
Article

Another List of Sample Queries for you to try and make yourself comfortable with the process of writing Queries.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Umang Shah, Software / Web Application developer and now a teacher

My Name is Umang Shah. I have a Master of Science Degree from one of the Most Reputed Universities in the United States and have been working as a Software / Web Application Developer for Several Years now. I am here to share the practical knowledge which i have gained over those years in the easiest way possible to you guys. Hope to make a difference by helping you guys advance your careers and life by teaching various courses here at Udemy. Thank you.

Ready to start learning?
Take This Course