Master SQL in less than 3 Hours :
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.
Will go over the definition / full form of SQL and what it means with the help of an example
Definition of MySQL and what are the differences between MySQL and SQL
Explain why and how to install MySQL Server
In this lecture, we will see a problem that will be faced by few after Installing XAMPP and how to solve it.
A Step by Step Instructions on How to Open XAMPP Control Panel After Installation of XAMPP in Mac
This quiz ensures you understood basic definitions clearly.
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
Take this Quiz to test you Knowledge of Basic SQL Queries and clauses.
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
Take this quiz to test you Functions , GROUP BY and HAVING clause knowledge
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.
Take this quiz to make sure you understood the concepts of DELETEs, DROPs and TRUNCATEs
Another List of Sample Queries for you to try and make yourself comfortable with the process of writing Queries.
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.