What is database and it`s benefits

What is Database?

Database is convenient tool for manage large amount of data.

Benefits of Database

• Redundancy can be reduced.
• Inconsistency can be reduced.
• Data can be shared among single and multiple users by share same database with multiple user
• Standards can be made and can be followed
• Common security mechanism can be set and followed by every user of database.

Types of command are here
Keys in sql server - key Constrains
pattern matching by like
use of distinct
print 1 to 10 by cte
get all child or sub employee with its level
sql indexer
sql server views with example
sql-join
cursor
varchar vs nvarchar
what are difference between temp table and table variable
what is stored procedure
what is function in sql
What are the difference between Stored procedure and function in sql server
how to compare null not null and blank
Use of Sub Query
rank denserank rownumber function in sql server
what is use of nolock?
set identity insert on off