Learn SQL and MySQL in 3 Hours
4.1 (153 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,652 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn SQL and MySQL in 3 Hours to your Wishlist.

Add to Wishlist

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.1 (153 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,652 students enrolled
Created by Umang Shah
Last updated 6/2016
English
Current price: $10 Original price: $20 Discount: 50% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 4 Articles
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • No Technical background required as everything will be covered from scratch
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.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
45 Lectures
02:05:20
+
Introduction
9 Lectures 22:52

Understand what will be covering throughout the course

Preview 02:46

SQL Powerpoint Presentation ( For your reference )
00:01

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

Preview 02:55

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

Preview 02:09

Explain why and how to install MySQL Server

Preview 02:33

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

Preview 03:35

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

Further Installation instructions for Mac
00:38

Understand What is DB i.e. Database and Table

Preview 02:24

Understand how to create DB and table in MySQL server

Preview 05:50

This quiz ensures you understood basic definitions clearly.

Section Quiz
4 questions
+
Inserts , Selects and Updates
14 Lectures 35:43

Learn How to Start Adding Data into Tables

Preview 03:43

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

Preview 01:36

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

Preview 01:44

Understand When and Where the 'WHERE' clause is useful

conditions with WHERE clause
02:27

Understand How and When to use UPDATE Clause

modify Data with Update
02:14

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

Table structure change with ALTER
04:23

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

AND as well as OR Clause
03:55

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

Sort result using ORDER BY Clause
03:21

Understand how IN is a specialized form of OR clause

IN Clause
02:18

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

Find Patterns in Data with LIKE Clause
04:04

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

Selecting specific Fields / Columns
01:19

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

DISTINCT
01:45

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

ALIAS
02:54

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

Section Quiz
6 questions

Test - INSERTS , SELECTS and UPDATES
2 pages
+
MySQL Datatypes and Constraints
2 Lectures 06:37

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

Datatypes
03:46

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

Constraints
02:51

Section Quiz
3 questions
+
JOINS and UNIONS
9 Lectures 37:22
Creating base for Future Lectures
04:44

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.

Relational Databases ?
08:40

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

What is a FOREIGN KEY Constraint ?
07:36

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

What are JOINS ?
00:47

Understand what is a Left Join and When to Use it

LEFT JOIN
07:41

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

RIGHT JOIN
02:00

Understand the concept of INNER JOIN

INNER JOIN
01:34

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

UNION
02:22

In this lecture we will understand what is Subquery

Subquery .... Query inside another Query
01:58

Section Quiz
2 questions
+
GROUPS and MySQL Functions
3 Lectures 08:22

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

MySQL Functions
04:41

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.

GROUP BY Clause
02:06

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

HAVING Clause
01:35

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

Section Quiz
2 questions
+
VIEWS
3 Lectures 04:24

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.

What are VIEWS and how to Create Them ?
02:31

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

ALTER and DROP VIEWS
01:53

Test - CREATE , ALTER and DROP VIEWs
1 page
+
DELETEs , DROPs and TRUNCATEs
5 Lectures 03:03

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

DELETE data from tables
01:15

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.

TRUNCATE Tables , DROP Tables and Database
01:03

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

Section Quiz
2 questions

25+ Sample Queries
4 pages

Importing Tables and Data to your local PhpMyAdmin
00:39

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

30+ Sample Queries
00:05
About the Instructor
Umang Shah
4.2 Average rating
562 Reviews
6,674 Students
2 Courses
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.