Fail Mark: April 2013

Sunday, 21 April 2013

Meanings of these words

News = North East West South.

Chess = Chariot,Horse, Elephant, Soldiers.

Cold = chronic Obstructive Lung Disease.

Joke = Joy of Kids Entertainment.

Aim = Ambition in Mind.

Date = Day and Time Evolution.

Eat = Energy And Taste.

Tea = Taste And Energy Admitted.

Pen = Power Enriched in Nib.

Smile = Sweet Memories In Lips Expression.

Bye = Be with You Everytime.

SYMBOLS WITH KEYBOARD

Alt + 0153..... ™... trademark symbol
Alt + 0169.... ©.... copyright symbol
Alt + 0174..... ®....registered trademark symbol
Alt + 0176 ...°......degre e symbol
Alt + 0177 ...±....plus-or -minus sign
Alt + 0182 ...¶.....paragr aph mark
Alt + 0190 ...¾....fractio n, three-fourths
Alt + 0215 ....×.....multi plication sign
Alt + 0162...¢....the cent sign
Alt + 0161.....¡..... .upside down exclamation point
Alt + 0191.....¿..... upside down question mark
Alt + 1.......☺....sm iley face
Alt + 2 ......☻.....bla ck smiley face
Alt + 15.....☼.....su n
Alt + 12......♀.....f emale sign
Alt + 11.....♂......m ale sign
Alt + 6.......♠.....s pade
Alt + 5.......♣...... Club
Alt + 3.......♥...... Heart
Alt + 4.......♦...... Diamond
Alt + 13......♪.....e ighth note
Alt + 14......♫...... beamed eighth note
Alt + 8721.... ∑.... N-ary summation (auto sum)
Alt + 251.....√.....s quare root check mark
Alt + 8236.....∞..... infinity
Alt + 24.......↑..... up arrow
Alt + 25......↓...... down arrow
Alt + 26.....→.....ri ght arrow
Alt + 27......←.....l eft arrow
Alt + 18.....↕......u p/down arrow
Alt + 29......↔...lef t right arrow

Keyboard Shorcuts (Microsoft Windows)

Keyboard Shorcuts (Microsoft Windows)
1. CTRL+C (Copy)
2. CTRL+X (Cut)
3. CTRL+V (Paste)
4. CTRL+Z (Undo)
5. DELETE (Delete)
6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin)
7. CTRL while dragging an item (Copy the selected item)
8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item)
9. F2 key (Rename the selected item)
10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word)
11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word)
12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph)
13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph)
14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text)
SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document)
15. CTRL+A (Select all)
16. F3 key (Search for a file or a folder)
17. ALT+ENTER (View the properties for the selected item)
18. ALT+F4 (Close the active item, or quit the active program)
19. ALT+ENTER (Display the properties of the selected object)
20. ALT+SPACEBAR (Open the shortcut menu for the active window)
21. CTRL+F4 (Close the active document in programs that enable you to have multiple documents opensimultaneou sly)
22. ALT+TAB (Switch between the open items)
23. ALT+ESC (Cycle through items in the order that they had been opened)
24. F6 key (Cycle through the screen elements in a window or on the desktop)
25. F4 key (Display the Address bar list in My Computer or Windows Explorer)
26. SHIFT+F10 (Display the shortcut menu for the selected item)
27. ALT+SPACEBAR (Display the System menu for the active window)
28. CTRL+ESC (Display the Start menu)
29. ALT+Underlined letter in a menu name (Display the corresponding menu) Underlined letter in a command name on an open menu (Perform the corresponding command)
30. F10 key (Activate the menu bar in the active program)
31. RIGHT ARROW (Open the next menu to the right, or open a submenu)
32. LEFT ARROW (Open the next menu to the left, or close a submenu)
33. F5 key (Update the active window)
34. BACKSPACE (View the folder onelevel up in My Computer or Windows Explorer)
35. ESC (Cancel the current task)
36. SHIFT when you insert a CD-ROMinto the CD-ROM drive (Prevent the CD-ROM from automatically playing)

Dialog Box - Keyboard Shortcuts
1. CTRL+TAB (Move forward through the tabs)
2. CTRL+SHIFT+TAB (Move backward through the tabs)
3. TAB (Move forward through the options)
4. SHIFT+TAB (Move backward through the options)
5. ALT+Underlined letter (Perform the corresponding command or select the corresponding option)
6. ENTER (Perform the command for the active option or button)
7. SPACEBAR (Select or clear the check box if the active option is a check box)
8. Arrow keys (Select a button if the active option is a group of option buttons)
9. F1 key (Display Help)
10. F4 key (Display the items in the active list)
11. BACKSPACE (Open a folder one level up if a folder is selected in the Save As or Open dialog box)

Microsoft Natural Keyboard Shortcuts
1. Windows Logo (Display or hide the Start menu)
2. Windows Logo+BREAK (Display the System Properties dialog box)
3. Windows Logo+D (Display the desktop)
4. Windows Logo+M (Minimize all of the windows)
5. Windows Logo+SHIFT+M (Restorethe minimized windows)
6. Windows Logo+E (Open My Computer)
7. Windows Logo+F (Search for a file or a folder)
8. CTRL+Windows Logo+F (Search for computers)
9. Windows Logo+F1 (Display Windows Help)
10. Windows Logo+ L (Lock the keyboard)
11. Windows Logo+R (Open the Run dialog box)
12. Windows Logo+U (Open Utility Manager)
13. Accessibility Keyboard Shortcuts
14. Right SHIFT for eight seconds (Switch FilterKeys either on or off)
15. Left ALT+left SHIFT+PRINT SCREEN (Switch High Contrast either on or off)
16. Left ALT+left SHIFT+NUM LOCK (Switch the MouseKeys either on or off)
17. SHIFT five times (Switch the StickyKeys either on or off)
18. NUM LOCK for five seconds (Switch the ToggleKeys either on or off)
19. Windows Logo +U (Open Utility Manager)
20. Windows Explorer Keyboard Shortcuts
21. END (Display the bottom of the active window)
22. HOME (Display the top of the active window)
23. NUM LOCK+Asterisk sign (*) (Display all of the subfolders that are under the selected folder)
24. NUM LOCK+Plus sign (+) (Display the contents of the selected folder)
25. NUM LOCK+Minus sign (-) (Collapse the selected folder)
26. LEFT ARROW (Collapse the current selection if it is expanded, or select the parent folder)
27. RIGHT ARROW (Display the current selection if it is collapsed, or select the first subfolder)

Shortcut Keys for Character Map
After you double-click a character on the grid of characters, you can move through the grid by using the keyboard shortcuts:
1. RIGHT ARROW (Move to the rightor to the beginning of the next line)
2. LEFT ARROW (Move to the left orto the end of the previous line)
3. UP ARROW (Move up one row)
4. DOWN ARROW (Move down one row)
5. PAGE UP (Move up one screen at a time)
6. PAGE DOWN (Move down one screen at a time)
7. HOME (Move to the beginning of the line)
8. END (Move to the end of the line)
9. CTRL+HOME (Move to the first character)
10. CTRL+END (Move to the last character)
11. SPACEBAR (Switch between Enlarged and Normal mode when a character is selected)

Microsoft Management Console (MMC)
Main Window Keyboard Shortcuts
1. CTRL+O (Open a saved console)
2. CTRL+N (Open a new console)
3. CTRL+S (Save the open console)
4. CTRL+M (Add or remove a console item)
5. CTRL+W (Open a new window)
6. F5 key (Update the content of all console windows)
7. ALT+SPACEBAR (Display the MMC window menu)
8. ALT+F4 (Close the console)
9. ALT+A (Display the Action menu)
10. ALT+V (Display the View menu)
11. ALT+F (Display the File menu)
12. ALT+O (Display the Favorites menu)

MMC Console Window Keyboard Shortcuts
1. CTRL+P (Print the current page or active pane)
2. ALT+Minus sign (-) (Display the window menu for the active console window)
3. SHIFT+F10 (Display the Action shortcut menu for the selected item)
4. F1 key (Open the Help topic, if any, for the selected item)
5. F5 key (Update the content of all console windows)
6. CTRL+F10 (Maximize the active console window)
7. CTRL+F5 (Restore the active console window)
8. ALT+ENTER (Display the Properties dialog box, if any, for theselected item)
9. F2 key (Rename the selected item)
10. CTRL+F4 (Close the active console window. When a console has only one console window, this shortcut closes the console)

Remote Desktop Connection Navigation
1. CTRL+ALT+END (Open the Microsoft Windows NT Security dialog box)
2. ALT+PAGE UP (Switch between programs from left to right)
3. ALT+PAGE DOWN (Switch between programs from right to left)
4. ALT+INSERT (Cycle through the programs in most recently used order)
5. ALT+HOME (Display the Start menu)
6. CTRL+ALT+BREAK (Switch the client computer between a window and a full screen)
7. ALT+DELETE (Display the Windows menu)
8. CTRL+ALT+Minus sign (-) (Place a snapshot of the active window in the client on the Terminal server clipboard and provide the same functionality as pressing PRINT SCREEN on a local computer.)
9. CTRL+ALT+Plus sign (+) (Place asnapshot of the entire client window area on the Terminal server clipboardand provide the same functionality aspressing ALT+PRINT SCREEN on a local computer.)

Microsoft Internet Explorer Keyboard Shortcuts
1. CTRL+B (Open the Organize Favorites dialog box)
2. CTRL+E (Open the Search bar)
3. CTRL+F (Start the Find utility)
4. CTRL+H (Open the History bar)
5. CTRL+I (Open the Favorites bar)
6. CTRL+L (Open the Open dialog box)
7. CTRL+N (Start another instance of the browser with the same Web address)
8. CTRL+O (Open the Open dialog box,the same as CTRL+L)
9. CTRL+P (Open the Print dialog box)
10. CTRL+R (Update the current Web )

RELATIONAL DATABASE MANAGEMENT SYSTEM

relational database and management DOWNLOAD HERE

mathematical functions in ppt

mathematical functions DOWNLOAD HERE

Monday, 8 April 2013

VB PROGRAMS

DOWNLOAD HERE VB PROGRAMS

RDBMS PROGRAMS

RDMBS PROGRAMS DOWNLOAD HERE

VIDEO LIBRARY MANAGEMENT IN SQL

SQL>create table customer (cno int,fname varchar(10),sname varchar(10),area varchar(10),phone int);

Table created

SQL>insert table customer values(‘&cno’,’&fname’,’&sname’,’&area’,’&phone’);

Enter value for cno: 1

Enter value for fname: john

Enter value for sname: peter

Enter value for area: cbe

Enter value for phone: 8548547895

1 row created

SQL>select * from customer;

CNO FNAME SNAME AREA PHONE

------ ----------- ----------- -------- -----------

1 john peter cbe 8548547895

2 dean winsister cbe2 1245789987

3 emma Watson cbe4 3455568765

SQL>create table compact (cdno int,title varchar(10),price varchar(10),cname varchar(10));

Table created

SQL>insert table compact values(‘&cdno’,’& title,’& price’,’& cname’);

Enter value for cdno: c1

Enter value for title: algorithm

Enter value for price: 200

Enter value for cname: john

1 row created

SQL>select * from compact;

CDNO TITLE PRICE CNAME

------ ----------- ----------- --------

C1 algorithm 200 john

C2 program 400 sam

C3 hardware 1000 Watson

SQL>create table invoice (invno int,cidno int,issuedate date,returndate date);

Table created

SQL>insert table invoice values(‘&invno’,’&cidno’,’&issuedate’,’&returndate’);

Enter value for invno: 1

Enter value for cidno: 1

Enter value for issuedate: 28/1/10

Enter value for returndate: 28/2/10

1 row created

SQL>select * from invoice;

INVNO CIDNO ISSUEDATE RETURNDATE

----------- ----------- ----------------- --------------------

1 1 28/1/10 28/2/10

2 2 14/3/1/10 14/4/10

3 3 16/4/10 26/5/10

SQL>select area from customer;

AREA

--------

cbe

cbe2

cbe4

SQL>select max(price) as”maximum” from compact;

MAXIMUM

----------------

1000

SQL>select min(price) as”minimum” from compact;

MINIMUM

----------------

200

SQL>select avg(price) as”avg” from compact;

AVG

---------

533.3

SQL>select * from compact where title like ’%algorithm%’;

CDNO TITLE PRICE CNAME

------ ----------- ----------- --------

C1 algorithm 200 john

SQL>select datediff(day,’2010-01-28’,’2010-02-28’) as diffdatebetween from invoice;

DIFFDATEBETWEEN

------------------------------

SQL>delete from invoice where returndate =’28/2/10’;

1 row deleted

SQL>select cname from compact;

CNAME

------------

john

sam

Watson

SQL>select * from customer where phone=’ 8548547895’;

CNO FNAME SNAME AREA PHONE

------ ----------- ----------- -------- -----------

1 john peter cbe 8548547895

DATE FUNCTION IN SQL

SQL>create table t (datecol1 date,datecol2 date,datecol3 date);

Table created

SQL>insert into t values(sysdate+23,sysdate-10,sysdate-24);

SQL>select * from t ;

DATECOL1 DATECOL2 DATECOL3

---------------- ---------------- -----------------

09-mar-13 04-feb-13 21-jan-13

01-jan-12 04-mar-12 23-dec-13

14-feb-11 31-jan-11 16-aug-11

SQL>select max(date col1) from t;

MAX(date col1)

-------------------

14-feb-11

SQL>select min(date col3) from t;

MIN(date col13)

-------------------

21-jan-13

SQL>create table order (oid int,pname varchar(10),odate date datetime NOTNULL DEFAULT GETDATE( ));

Table created

SQL>select GETDATE() from order;

2008-11-11 12:45:34.243

SQL>select DATE PART(yyyy,odate)as order year,DATEPART(mm,odate)as order month from order where oid=1;

ORDER YEAR ORDER MONTH

-------------------- ----------------------

2008 11

SQL>select oid,DATEADD(day,45,orderdate)as order pay date from orders;

OID ORDER PAY DATE

------ --------------------------

1 2008-12-26 13:23:44.647

SQL>DATEDIFF(day,’2008-06-05’,’2008-0806’) as diff date from orders;

DIFFDATE

---------------

SQL>convert(varchar(19),GETDATE())convert(varchar(10) GETDATE(),110) convert(varchar(11) GETDATE(),6));

Nov 04 2011 11:45 pm

11-04-2011

04 Nov 11

SUB QUERIES IN SQL

SQL> create table customer(cid int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address varchar2(20),phno int,email varchar2(20),anualincome varchar2(10),primary key(cid));

Table created.

SQL> insert into customer values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','

&annualincome');

Enter value for cid: 1

Enter value for cname: john

Enter value for age: 58

Enter value for sex: male

Enter value for dob: 5/7/55

Enter value for address: german

Enter value for phno: 8548547895

Enter value for email: john2@gmail.com

Enter value for annualincome: 15000

1 row created.

SQL> select * from customer;

CID CNAME AGE SEX DOB ADDRESS PHNO EMAIL ANUALINCOME

---------- -------------------- ---------- ---------- -------------------- -------------------- ---------- -----------------

1 john 58 male 5/7/55 german 8548547895 john2@gmail.com 15000

2 mac 47 male 1/9/65 japan 8547694858 mac33@gmail.com 14000

3 sam 21 male 1/7/91 greek 7894562158 sam2@yahoo.com 10000

SQL>select * from customer cid in (select cid from customer where annualincome>10000);

CID CNAME AGE SEX DOB ADDRESS PHNO EMAIL ANUALINCOME

---------- -------------------- ---------- ---------- -------------------- -------------------- ---------- -----------------

1 john 58 male 5/7/55 german 8548547895 john2@gmail.com 15000

2 mac 47 male 1/9/65 japan 8547694858 mac33@gmail.com 14000

SQL>select * from customer cid not in (select cid from customer where anualincome>10000);

CID CNAME AGE SEX DOB ADDRESS PHNO EMAIL ANNUALINCOME

---------- -------------------- ---------- ---------- -------------------- -------------------- ---------- -----------------

3 sam 21 male 1/7/91 greek 789456215 sam2@yahoo.com 10000

KEY CONSTRAINS IN SQL

SQL> create table customer(cid int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address varchar2(20),phno int,email varchar2(20),anualincome varchar2(10),primary key(cid));

Table created.

SQL> insert into customer values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','

&annualincome');

Enter value for cid: 1

Enter value for cname: john

Enter value for age: 58

Enter value for sex: male

Enter value for dob: 5/7/55

Enter value for address: german

Enter value for phno: 8548547895

Enter value for email: john2@gmail.com

Enter value for annualincome: 15000

1 row created.

SQL> select * from customer;

CID CNAME AGE SEX DOB ADDRESS PHNO EMAIL ANUALINCOME

---------- -------------------- ---------- ---------- -------------------- -------------------- ---------- -----------------

1 john 58 male 5/7/55 german 8548547895 john2@gmail.com 15000

2 mac 47 male 1/9/65 japan 854769485 mac33@gmail.com 14000

3 sam 21 male 1/7/91 greek 789456215 sam2@yahoo.com 10000

SQL> create table product(cid int,pid int,pname varchar2(20),brandname varchar2(20),price int,quantity int,primary key(cid,pid),foreign key(cid) references customer);

Table created.

SQL> insert into product values('&cid','&pid','&pname','&brandname','&price','&quantity');

Enter value for cid: 1

Enter value for pid: 1

Enter value for pname: x220

Enter value for brandname: sony

Enter value for price: 2500

Enter value for quantity: 5

1 row created.

SQL> select * from product;

CID PID PNAME BRANDNAME PRICE QUANTITY

------ ------ ------------ --------------------- ---------- ------------------

1 1 x220 sony 2500 5

2 2 xpro sony 10000 3

3 3 star 3 samsung 7000 1

SQL> create table person(pid int,pname varchar2(20),address varchar(20),city varchar2(20), unique(pid));

Table created.

SQL> insert into person values('&pid','&pname','&address','&city');

Enter value for pid: 1

Enter value for pname:john

Enter value for address:7^th north street

Enter value for city:coimbatore

1 row created.

SQL> select * from person;

PID PNAME ADDRESS CITY

----- ----------- -------------- -------

1 john 7^th north street coimbatore

2 sam 2^nd korea street cbe

3 winsester 4^th cross street kovai

EXCEPT , EXISTS IN SQL

SQL>create table sailors(sid int,sname varchar2(20),rating int,age int,primary key(sid));

Table created.

SOL> insert into sailors values(‘&sid’,’&sname’,’&rating’,’&age’);

Enter value for sid:1

Enter value for sname:john

Enter value for rating:7

Enter value for age:22

1 row created.

SQL>select * from sailors;

SID SNAME RATING AGE

---- ---------- --------- -----

1 john 7 22

2 dean 8 33

3 sam 5 32

SQL>create table boats(bid int,bname varchar2(20),color varchar2(20),primary key(bid));

Table created.

SOL> insert into boats values(‘&bid’,’&bname’,’&color’,’&age’);

Enter value for bid:102

Enter value for sname:casino

Enter value for color::red

1 row created.

SQL>select * from boats;

BID BNAME COLOR

---- ---------- ---------

102 casino red

102 titanic blue

103 santro green

SQL>create table reserves(sid int,bid int,date varchar2(20),primary key(sid,bid,date) foreign key (sid) references sailors,fpreign key (bid) references boats);

Table created.

SOL> insert into boats reserves(‘&sid’,‘&bid’,’&date’);

Enter value for sid:1

Enter value for bid:102

Enter value for date:9/9/91

1 row created.

SQL>select * from reserves;

SID BID DATE

---- ---------- ---------

1 102 9/9/91

2 102 8/8/81

3 103 6/6/91

SQL>select sname from sailors where exsists(select * from reserves where bid=103 and sid=sid);

SNAME

-----------

Sam

SQL>select sname from sailors where except(select * from reserves where bid=103 and sid=sid);

SNAME

-----------

John

dean

SQL>select sid from sailors left join boats on sailors.bid=boat.bid except select sid from sailors right join boats on sailors.bid=boat.bid;

SID

------

SQL>select sid from sailors except select sid from reserves;

SID

-----

INTERSECT IN SQL

SQL>create table sailors(sid int,sname varchar2(20),rating int,age int,primary key(sid));

Table created.

SOL> insert into sailors values(‘&sid’,’&sname’,’&rating’,’&age’);

Enter value for sid:1

Enter value for sname:john

Enter value for rating:7

Enter value for age:22

1 row created.

SQL>select * from sailors;

SID SNAME RATING AGE

---- ---------- --------- -----

1 john 7 22

2 dean 8 33

3 sam 5 32

SQL>create table boats(bid int,bname varchar2(20),color varchar2(20),primary key(bid));

Table created.

SOL> insert into boats values(‘&bid’,’&bname’,’&color’,’&age’);

Enter value for bid:102

Enter value for sname:casino

Enter value for color::red

1 row created.

SQL>select * from boats;

BID BNAME COLOR

---- ---------- ---------

102 casino red

102 titanic blue

103 santro green

SQL>create table reserves(sid int,bid int,date varchar2(20),primary key(sid,bid,date) foreign key (sid) references sailors,foreign key (bid) references boats);

Table created.

SOL> insert into boats reserves(‘&sid’,‘&bid’,’&date’);

Enter value for sid:1

Enter value for bid:102

Enter value for date:9/9/91

1 row created.

SQL>select * from reserves;

SID BID DATE

---- ---------- ---------

1 102 9/9/91

2 102 8/8/81

3 103 6/6/91

SQL>select s.sid from sailors s,boats b,reserves r where s.ssid=r.sid and b.color=’red’ INTERSECT select s.sid from sailors s,boats b,reserves r where r.bid=b.bid and b.color=’blue’

SID

----

UNION AND UNION ALL IN SQL

SQL> create table customer(cid int,cname varchar2(20),age int,sex varchar2(10),dob varchar2(20),address varchar2(20),phno int,email varchar2(20),annualincome varchar2(10),primary key(cid));

Table created.

SQL> insert into customer values('&cid','&cname','&age','&sex','&dob','&address','&phno','&email','

&annualincome');

Enter value for cid: 1

Enter value for cname: john

Enter value for age: 58

Enter value for sex: male

Enter value for dob: 5/7/55

Enter value for address: german

Enter value for phno: 8548547895

Enter value for email: john2@gmail.com

Enter value for annualincome: 15000

1 row created.

SQL> select * from customer;

CID CNAME AGE SEX DOB ADDRESS PHNO EMAIL ANNUALINCOM

---------- -------------------- ---------- ---------- -------------------- -------------------- ---------- -----------------

1 john 58 male 5/7/55 german 8548547895 john2@gmail.com 15000

2 mac 47 male 1/9/65 japan 854769485 mac33@gmail.com 14000

3 sam 21 male 1/7/91 greek 789456215 sam2@yahoo.com 10000

SQL> create table product(cid int,pid int,pname varchar2(20),brandname varchar2(20),price int,quantity int,primary key(cid,pid),foreign key(cid) references customer);

Table created.

SQL> insert into product values('&cid','&pid','&pname','&brandname','&price','&quantity');

Enter value for cid: 1

Enter value for pid: 1

Enter value for pname: x220

Enter value for brandname: sony

Enter value for price: 2500

Enter value for quantity: 5

1 row created.

SQL> select * from product;

CID PID PNAME BRANDNAME PRICE QUANTITY

------ ------ ------------ --------------------- ---------- ------------------

1 1 x220 sony 2500 5

2 2 xpro sony 10000 3

3 3 star 3 samsung 7000 1

SQL>select cid from customer union select cid from product;

CID

------

SQL>select cid from customer union all select cid from product;

CID

------

Sunday, 21 April 2013

Meanings of these words

SYMBOLS WITH KEYBOARD

Keyboard Shorcuts (Microsoft Windows)

RELATIONAL DATABASE MANAGEMENT SYSTEM

mathematical functions in ppt

Tuesday, 9 April 2013

DATA STRUCTURE AND ALGORITHAM PPT

COMPUTER GRAPHICS IN PPT

WEB SERVICES IN PPT

Monday, 8 April 2013

VB PROGRAMS

RDBMS PROGRAMS

VIDEO LIBRARY MANAGEMENT IN SQL

DATE FUNCTION IN SQL

SUB QUERIES IN SQL

KEY CONSTRAINS IN SQL

EXCEPT , EXISTS IN SQL

INTERSECT IN SQL

UNION AND UNION ALL IN SQL