- Database
- 287 (Registered)
-
Working on any language is a plus point but how to store data in the database, how to fetch the data from the database, these are the question every new programmer ask. Most people think that SQL is the complex thing to learn but believe me, it’s very easy, it’s just like the English language. In this series, we are going to cover each and every fundamental concept related to SQL.
We start from zero what is the database, how to store data in the database, we will also discuss about the NO-SQL database like MongoDB, you will learn how to fetch the record, we will also discuss about the relational database and also how to fetch the data from two tables using joins.
We will discuss different types of joins and how to use the theme. You will learn a lot of things in this series. At the end of this series, I will give you an overview of the MongoDB so you can easily take the next step.
Course Content
-
Introduction
-
Detailed
- Creating database and table
- Select statement in SQL
- Select distinct statement in SQL
- Where Clause in SQL
- SQL And, OR, not operators
- Order by keyword in SQL
- Insert statement in SQL
- NULL values in SQL
- Update statement in SQL
- Delete statement in SQL
- IN operator in SQL
- SQL Alias
- Between operator in SQL
- Min,Max,Sum,Count,Avg in SQL
- Like in SQL
- Introduction to join and creating the second tables
- Inner Join in SQL
- Left join in SQL
- Group by in SQL
- Having clause in SQL
- Introduction to subquery in SQL
- Creating the Databases in SQL
- Creating the tables in SQL
- SQL constraints in SQL
- Alter Columns in SQL
- Conclusion