Learn SQL and MySQL in 3 Hours

Learn How to Start Adding Data into Tables

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

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

Understand When and Where the 'WHERE' clause is useful

Understand How and When to use UPDATE Clause

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

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

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

Understand how IN is a specialized form of OR clause

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

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

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

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

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

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

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.

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

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

Understand what is a Left Join and When to Use it

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

Understand the concept of INNER JOIN

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

In this lecture we will understand what is Subquery

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

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.

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

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.

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

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

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.

25+ Sample Queries to try and test the knowledge you have gained throughout the course. There are 2 separate PDFs attached. One contains all questions and other the answers. Please come up with your own answers before referring to answers provided.

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