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=&qu...
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&g...
Read More
9 Program to demonstrate If-Else-If Condition's in VueJS
Program: index.html: <!DOCTYPE html> <html> <body> <div id="ad"> <h1 v-if=&quo...
Read More
8 Program to demonstrate Dynamic CSS in VueJS
Program: index.html: <!DOCTYPE html> <html> <body> <div id="ad"> <div v-bind:c...
Read More
7 Program to demonstrate two ways data binding in VueJS
Program: index.html: <!DOCTYPE html> <html> <body> <div id="ad"> <input type=&...
Read More
Subscribe to:
Posts (Atom)
