16 Program for Foreign Key in PostgreSQL

Program: create table customers(CID int primary key, name text, contact int); create table orders(OID int primary key, item text, pric...
Read More

15 Program for Default Constraint in PostgreSQL

Program: create table cars(id int, mileage int default 0); insert into cars (id) values(1); select * from cars; insert into cars...
Read More

14 Program for Serial Constraint in PostgreSQL

Program: create table books( ID serial primary key, name text); insert into books (name) values('Book1'); insert into books...
Read More

13 Program for Primary Key Constraint in PostgreSQL

Program: create table people( ID int primary key, name text, number int); insert into people values(1, 'Atharva', 54955); i...
Read More

12 Program for Unique Constraint in PostgreSQL

Program: create table food(name  text unique,price int); insert into food values('Apple',5); insert into food values('M...
Read More

11 Program for Not Null Constrain in PostgreSQL

Program: create table people(name text, age int not null); insert into people values('Jim', 40); insert into people values(...
Read More

10 Program to demonstrate Math Function in PostgreSQL

Program: select avg(age) from students; select count(name) from students; select min(age) from students; select max(age) from st...
Read More

9 Program to Update Data in PostgreSQL

Program: select * from students; UPDATE students SET number='3333' Where name='Kim'; Output:
Read More

8 Program to demonstrate Operators in PostgreSQL

Program: select * from students where name='Atharva' and age='18'; select * from students where name='Atharva'...
Read More

7 Program for Where and Where NOT Clause in PostgreSQL

Program: select * from students; select * from students where name='Atharva'; select * from students where name='Atharv...
Read More

6 Program to show Where Clause in PostgreSQL

Program: select * from students; select * from students where name='Atharva'; select * from students where age>18; Ou...
Read More

5 Program to show Select Distinct Clause in PostgreSQL

Program: select * from students; select name from students; select distinct(name) from students; Output:
Read More

4 Program for Select Clause in PostgreSQL

Program: INSERT INTO students values('John', 19, 97999),('Kim', 20,9898),('Atharva',200,989122); select * from...
Read More

3 Program to Insert Data in Table of PostgreSQL

Program: INSERT INTO students values('Atharva', 18, 99999); select * from students; Output:
Read More

2 Program to create and describe table in PostgreSQL

Program: create table students(name text,age int,number int);  -- To create table \d students -- To describe table Output:
Read More

1 Program to create and delete PostgreSQL Database

Program:  create database demo2; -- Creating Database \l -- To View All Database \c demo1 -- To use Demo1 Database drop databas...
Read More

18 Program to Pass Complex Data to Templates using Embedded-JS and ExpressJS

Program: app.js: var express = require('express'); var app = express(); app.set('view engine', 'ejs'); a...
Read More

17 Program to demonstrate Template Engine using Embedded-JS and ExpressJS

Program: app.js: var express = require('express'); var app = express(); app.set('view engine', 'ejs'); a...
Read More

16 Program to handle Dynamic Route Params in ExpressJS

Program: var express = require('express'); const { response } = require('express'); const { request } = require('ht...
Read More

15 Intro to ExpressJS

Program: var express = require('express'); var app = express(); app.get('/home',function(request,response){     re...
Read More

14 Program to Manual Routing in NodeJS

Program: var http = require('http'); var fs = require('fs'); var server = http.createServer(function (request, respon...
Read More

13 Program for Sending JSON Data in NodeJS

Program: var http = require('http'); var fs = require('fs'); var server = http.createServer(function(request,response...
Read More

12 Program to Serving HTML Pages in NodeJS

Program: index.html: <!DOCTYPE html> <html>     <body>         <h1> Coding Atharva </h1>     </bod...
Read More

11 Program to demonstrate Writable Stream in NodeJS

Program: var http = require('http'); var fs = require('fs'); var readStream = fs.createReadStream(__dirname+'/dem...
Read More

10 Program to demonstrate Readable Stream in NodeJS

Program: var http = require('http'); var fs = require('fs'); var readStream = fs.createReadStream(__dirname+'/dem...
Read More

9 Program to Create Own Server in NodeJS

Program: var http = require('http'); var server = http.createServer( function(request,response){     response.writeHead(200,{...
Read More

8 Program to Create and Delete Directory in NodeJS

Program: var fs = require('fs'); fs.mkdirSync('demo'); console.log('Demo Directory Create'); fs.rmdirSyn...
Read More

7 Program to Delete/Un-link File in NodeJS

Program: var fs = require('fs'); fs.unlink('demo.txt',function(){     console.log("File Deleted"); }); ...
Read More

6 Program to read and write file in NodeJS

Synchronous: First it will read the file then execute the next statement. Program: var fs = require('fs'); var r = fs.readF...
Read More

5 Program to demonstrate Event Emitter in NodeJS

Program: var events = require('events'); var emitter = new events.EventEmitter(); emitter.on('publishVideo', functi...
Read More

4 Program to use Multiple Modules in NodeJS

Program: math.js: var calculate_square = function(number){     console.log(number*number); }; var calculate_cube = function(n){  ...
Read More

3 Program to use Modules in NodeJS

Program: square.js: var calculate_square = function(number){     console.log(number*number); } module.exports = calculate_square; ...
Read More

2 Program to demonstrate Function Expression in NodeJS

Program: var displayMessage = function () {     console.log(" This is a DisplayMessage Function"); } var calculateSquare =...
Read More

1 Program to Print Hello World in NodeJS

Program: setTimeout(function(){     console.log("Hello World!"); },5000) Output:
Read More

16 Program to demonstrate Registering Components and Props in VueJS

Program: App.vue: <template>   <div id="app">     <heading></heading>     <h1> Hello There! ...
Read More

15 Program to demonstrate Styling Components in Vue CLI

Program: App.vue: <template>   <div id="app">     <h1>  Hello There! </h1>     <students>...
Read More

14 Program to demonstrate Nesting Components using VUE CLI

Steps: 1) $npm install -g vue-cli 2) $vue init webpack-simple my-project 3) $cd my-project 4) $npm install 5) $npm run dev ...
Read More

13 Program to demonstrate Referencing in VueJS

Program: index.html: <!DOCTYPE html> <html> <body>     <div id="ad">         <input type=...
Read More

12 Program to demonstrate Components in VueJS

Program: index.html: <!DOCTYPE html> <html> <body>     <div id="ad">         <mycomponent...
Read More

11 Program to demonstrate Multiple Instances in VueJS

Program: index.html: <!DOCTYPE html> <html> <body> <div id="ad"> {{ value }} ...
Read More

10 Program to demonstrate For Loop in VueJS

Program: index.html: <!DOCTYPE html> <html> <body>     <div id="ad">         <h1> <b...
Read More