Introduction to database

MAR

1

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

Simple Queries 

create table employee

(empid int primary key, empname varchar(100),empaddrs varchar(100))

Insert into employee(empid,empname,empaddrs)values 

(101,'ram','bangalore'),(102,'siv','hyderbad'),(103,'avi','bangalore'),(104,'sam','chennai')

select * from employee

Result:

empid empname empaddrs

101 ram bangalore

102 siv hyderbad

103 avi bangalore

104 sam chennai

alter table employee add salary money

update employee set salary= 10000 where empid=101

update employee set salary= 20000 where empid=102

update employee set salary= 30000 where empid=103

update employee set salary= 20000 where empid=104

select * from employee

Result:

empid empname empaddrs salary

101 ram bangalore 10000.00

102 siv hyderbad 20000.00

103 avi bangalore 30000.00

104 sam chennai 20000.00