Share Your Knowledge

Write SQL statement for DDL language. Write SQL statement to implement all DMl& TCL Wite SQL statement for key constraints. write SQL statement to join two or more tables. write SQL statement to create,update and drop views write SQL statements for implementing nested queries write SQL statements for implementing set operations.

Here I made study material for unit 3 & 4 study along with your class notes for more information if you have any doubt put it in comments Chapter 3          Chapter 4

Hi Guys; Here I attached study material for joins and views. Have a look and practice it with different tables. Click here to download

Hi guys, Here I uploaded remaining topics of Chapter 2 Have a look, if you have any doubt post your commands!! chapter 2

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 ; · ...