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

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

 Hi, Students! I hope every one gone through our Chapter 1 study material. And to add more value to chapter 1. I come with SQL Introduction and Queries. Have a look it will help us to do our practical section also.   SQL Introduction And Queries

Hello guys, I hope you all learned some important topics from my introduction classes. And I made study materials for beginners and chapter 1. Download and go through it if you have any doubt comment below!! For Beginner Chapter 1