Database concepts

Introduction to database

Databases 
1.System defined 
2.User Defined

System defined 

• Master database
• Model database-template to create 
• Temp database
• MS DB

User defined 

• User can create 'n' number of databases

Types of authentication 

• Windows Authentication
• SQL Server Authentication

Commanding Languages 

1. Data Definition Language (DDL)

• create 
• alter 
• drop 
• Truncate  

     2.Data Manipulation Language (DML)

• Insert
• Update
• Delete

   3.Data Query Language (DQL)

• Select
• Print

  4.Data Control Language (DCL)

• Grant 
• Deny
• Invoke

  5. Transactional Control Language 

• Commit
• Rollback