In this repo, all about Structured Query Language(SQL) which is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database.
Topics that covered are:
- Create, Use and Drop Database
1.1. Create a Database
1.2 Use a Database
1.3 Drop a Database - Constraints in SQL Database
2.1 Not Null Constraints
2.2 Default Constraints
2.3 Unique Constraints
2.4 Primary Key Constraints - Create a Stored Recored in Table
3.1 Create a Table
3.2 Stored Record in Table - Select and Distinct Statement
4.1 Select a Single Column from Table
4.2 Select a Multiple Column from Table
4.3 Select Entire Columns from Table
4.4 Select Distinct - Where Clause
5.1 Simple Conditions
5.2 And Conditions
5.3 OR Conditions
5.4 Not Conditions
5.5 Like Conditions
5.6 Between Condition - Function
6.1 Min()
6.2 Max()
6.3 Count()
6.4 Sum()
6.5 Avg()
6.6 String LTRIM()
6.7 String Lower()
6.8 String Upper()
6.9 Reverse()
6.10 String Substring() - Order By
7.1 Ascending Order
7.2 Descending Order - Top Clause
- Group By
- Having Clause
- Update Statement
- Delete Statement
- Truncate Statement
- Join Statement
14.1 Inner Join
14.2 Left Join
14.3 Right Join
14.4 Full Join
14.5 Update using Join - Union and Intersection Operator
15.1 Union Operator
15.2 Union All Operator
15.3 Except Operator
15.4 Intersect Operator - Create View and Drop View
16.1 Create View
16.2 Drop View - Alter Table
17.1 Add Column
17.2 Drop Column - Merge Statement
- Table Valued Function
- Temporary Table
- Case Statement
- IIF() Function
- Stored Procedure