GST Billing Software
header image

RAD Framework for Developing Web Apps in .Net

Erachana Line

Sl. No

Contents

1.

Introduction

1.1

Database definition

1.2

Database Types

1.3

Tables, Columns, Rows

1.4

Naming Conventions

2.

SQL

2.1

What is SQL?

2.2

What is Query?

2.3

What is Constrains?

2.4

Properties of Constraints

2.5

Types of Constraints

2.5.1

NOT NULL

2.5.2

Unique

2.5.3

Primary Key

2.5.4

Foreign Key

2.5.5

Check

2.5.6

Default

2.5.7

Auto increment

2.5.8

Referential Integrity

2.6

SQL Clauses

3.

SQL Datatypes

4.

DDL

4.1

Create

4.1.1

Create Database

4.1.2

Create Table

4.1.3

Create Table with Constraints

4.2

Use

4.3

Alter

4.3.1

Add, Drop, Modify

4.3.2

Add, Drop, Modify with Constraints

4.4

Drop

4.5

Truncate

4.6

Assignment

5.

DML

5.1

Select

5.1.1

Select All

5.1.2

Select by using where

5.1.3

Select by Left Join

5.1.4

Select by using Right Join

5.1.5

Select by using Inner Join

5.1.6

Select by using Full Join

5.1.7

Select by using Aggregate Functions

5.2

Insert

5.2.1

Insert with Column

5.2.2

Insert Without Column

5.3

Update

5.3.1

Update All

5.3.2

Update by using Where clause

5.4

Delete

5.4.1

Delete All

5.4.2

Delete by using Where clause

5.5

Assignment

6.

Conditional SQL

6.1

IF NULL

6.2

IS NULL

6.3

COALESE

6.4

CASE WHEN

6.5

Union, Intersection, Cross Product

7.

DCL

7.1

Grant

7.2

Revoke

8.

TCL

8.1

Commit

8.2

Rollback

9.

SQL Queries

10.

Assignment

11.

Question Paper