Saturday, November 21, 2020

Tuesday, November 17, 2020

SQL

 1. BASIC SQL STEP BY STEP -  CLICK HERE

2. UGC CBCS ASSIGNMENT FOR GENERAL STUDENT - CLICK HERE

3. UGC CBCS ASSIGNMENT FOR HONOURS  STUDENT - 

4. self join in sql - CLICK HERE

5. DATE command in SQL - CLICK HERE

6. wbsu 2016 dbms practical question - CLCIK HERE

7. CHECK CONSTRAINTS - CLICK HERE


JDBC code - create table, insert record, update record, delete record, drop table

 1.  jdbc1.CREATE TABLE using sql - CLICK HERE

2.  jdbc2. DISPLAY TABLE USING JDBC - CLICK HERE

3.  jdbc3. INSERT RECORD IN TABLE USING JDBC -    CLICK HERE

4. jdbc4. UPDATE RECORD IN TABLE USING JDBC -  CLICK HERE

5. jdbc5. CREATE TABLE USING JDBC - CLICK HERE

6. jdbc6. DROP TABLE USING JDBC-    CLICK HERE

7. jdbc7. DELETE DATA FROM TABLE USING JDBC - CLICK HERE

8. jdbc8. ALL ARE IN A SINGLE PROGRAM CREATE TABLE,INSERTION,DELETION, DROP TABLE USING JDBC - CLICK HERE



jdbc8. ALL ARE IN A SINGLE PROGRAM CREATE TABLE,INSERTION,DELETION, DROP TABLE USING JDBC

 jdbc8. ALL ARE IN A SINGLE PROGRAM CREATE TABLE,INSERTION,DELETION, DROP TABLE USING JDBC




jdbc7. DELETE DATA FROM TABLE USING JDBC

 

jdbc7. DELETE DATA FROM TABLE USING JDBC



jdbc6. DROP TABLE USING JDBC

 jdbc6. DROP TABLE USING JDBC



jdbc5. CREATE TABLE USING JDBC

jdbc5. CREATE TABLE USING JDBC



 

jdbc4. UPDATE RECORD IN TABLE USING JDBC

 jdbc4. UPDATE RECORD IN TABLE USING JDBC