Day 4 of 60 Days - Learn Sql Server

This is the Day 4 recording of SQL Server.
In this you will learn basics of

1.Tables ,columns ,Rows ,Pages (8k) ,Extents (8k *8)
DataTypes , Table Creation (Basic Level) ,DDL , DML ,DQL, DCL Statements
INSERT / Store Data into SQL Server Tables
a.Single Row
b.Multiple Rows Inserts with NULL Values

1.Tables
3.Rows
4.Pages
5.Extents
6.DataTypes .

7.DDL , DML ,DQL, DCL Statements
7.Table Creation (Basic Level) - Columns and Data Types
8.INSERT / Store Data into SQL Server Tables
a.Single Row
b.Multiple Rows Inserts with NULL Values
DDL (Data defination Language) :
1.CReate
CReate table [Employee] (EmpId int,deptId int,Name varchar(100))
2.Drop
drop table [Employee]
3.Truncate
truncate table [Employee]
4.ALter
alter table [Employee]
add cid int



DML (Data Manupulation L)
1.Insert
insert into [Employee] (EmpId,deptId,Name)
select 1,2,'Shrikant'
union
select 2,2,'Prashnt'


2.Update
update a set deptId=2

from [Employee] a
where EmpId=1
3.Delete
delete a from [Employee] a
where EmpId=1

DQL (Data Query) :
1.Select
select * from [Employee]

DCL (Data Control)
1.Grant
2.Revoke
3.Deny