Share Your Knowledge

Hi guys, Here I attached study material of Chapter 1 & Chapter 2, Have a look don't skip any topic  Click here to download   Chapter 1  Chapter 2

Dear students, As we know our unit one is covered and revised two times. Here I also attached few study materials ppt, teaching flow     click here to download  

·         To CREATE DATABASE statement is used to create a new SQL database. CREATE DATABASE databasename ; ·         To Drop Database DROP DATABASE databasename ; ·         To Create Table CREATE TABLE Persons (PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255)); ·                To Drop table DROP TABLE table_name ; ·                 To Alter table ALTER TABLE table_name ADD column_name datatype ; ·         To Add Constrains ALTER TABLE Persons ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName); ·         To Drop Constrains ALTER TABLE Persons DROP CONSTRAINT PK_Person ; · ...

Hay there... here i uploaded study material for unit 1 click here to download >>>> follow this ppts to get a clear idea about our class