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