PostgreSQL Tutorial

PostgreSQL Download for installation.

How to Install PostgreSQL in Linux - PostgreSQL Installation

How to Create Database in PostgreSQL - PostgreSQL Create Database 

How to Create User in PostgreSQL - PostgreSQL Create User

How to Rename Table in PostgreSQL - PostgreSQL Rename Table

Listing Database in PostgreSQL - PostgreSQL List Database / PostgreSQL Show Database

READ MORE ...

Recreate temp tablespace in Oracle

SQL> create temporary tablespace temp1 tempfile '/scratch/u01/app/oracle/oradata/tmp01/temp01.dbf' size 10G;

SQL> alter database default temporary tablespace temp1;

SQL> drop tablespace temp INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.





https://orahow.com/drop-and-recreate-temp-tablespace-in-oracle/

READ MORE ...

How to Check Airtel 4g LTE Dongle Data Usage

Airtel 4G - Fourth Generation Technology provides upto 5 times faster speeds than 3G making it suitable for all type of high speed applications and services. It is also touted to be the fastest wireless internet service. The latest after 2G and 3G which gives you a faster and rich internet experience. With 4G hi-speeds, you can notice a visible difference while downloading files, doing video-chat, playing multiplayer games or while viewing HD videos online.

How to Check Airtel 4g LTE Data Usage

To check airtel data usage click on the link below:

Airtel Data Usage

Artel 4G can be used at home or your office for :

•  Wireless internet access.
• Access rich content and multimedia applications eg: Movies, HD videos, e-learning, HD content and more.
•  multiple downloads of heavy files, high definition multimedia content at the same time will be possible.
• Higher uplink and downlink speeds.
• Seamless online streaming – ZERO buffering.
•  High definition online gaming Access business applications that require higher speeds and last mile connectivity.
•  Face-2-face video chat seamlessly.

airtel 4G LTE FAQs

http://www.airtel.in/forme/wireless-internet/4g_lte/4g_lte_faqs/4g_faqs

READ MORE ...

Windows: How to Hide/Unhide Hard Disk Partition using Command Prompt

People generally use drive locker to lock or unlock hard drive partition on their systems to protect data from unauthorized access. Use of software for this task is quite tricky when you forget password because in general life it is difficult to manage passwords from your laptop to ATM. 

So to get rid of this problem we can suggest you to use this method using which you can hide or unhide hard disk partition your windows laptops without use of any software.

So let's start diskpart prompt to do our task. For this open Command Prompt, it will be much better when you open "CMD" as an administrator.

Now, on cmd prompt type "Diskpart". After few seconds you will be prompted to "Diskpart" prompt.


Type "List Vol" so that you can see all the volumes or drives attached to your PCs as shown in the above figure. Using this command you can find the particular drive information like it's volume number, letters associated with it, labels (if any), file system type, size, status and info.

Now select the dive letter which you want to remove as:

DISKPART>  list vol
DISKPART> select vol 4

Finally remove the letter associated with this drive.

DISKPART> remve letter E 

When you press enter you will get a message : Diskpart successfully removed the drive letter or mount point. After completion of this step your selected drive will be no longer visible to you and no doubt others.

To gain access to this partition again you need to follow the same steps but in place of remove letter you need to enter assign letter. So lets look into this method:

To bring back or unhide partition , select volume which you want to unhide and assign letter to the selected volume. In some cases when you release a particular letter windows automatically assign it to others,  so first check whether the letter which you are going to assign is not in use, otherwise you can assign any other letter.

DISKPART>  list vol

DISKPART>  select vol 4
DISKPART> assign letter E 

After the completion of this step you can see the particular volume. For more tech stuff stay connected on G+, Facebook, Twitter.

READ MORE ...

Lyrics: Gulabi Aankhein Jo Teri Dekhi Md.Rafi

Gulabi Aankhein Jo Teri Dekhi (Md.Rafi)
Movie/Album: The Train (1970)
Music By: R. D. Burman
Lyrics By: Anand Bakshi
Performed By: Mohammed Rafi

Gulaabi Aankhen Jo Teri Dekhi
Sharaabi Yeh Dil Ho Gaya
Sambhaalo Mujhko O Mere Yaaron
Sambhalna Mushkil Ho Gaya

Dil Mein Mere Khwaab Tere
Bas Tere Jaise Ho Deewaar Pe
Tujhpe Fida Main Kyoon Hua
Aata Hai Gussa Mujhe Pyaar Pe
Main Lut Gaya Maanke Dil Ka Kaha
Main Kahin Tha Na Raha

Kya Kahoon Main Dilruba
Pura Yeh Jaadu Teri Aankhon Ka
Yeh Mera Kaatil Ho Gaya
Gulaabi Aankhen Jo Teri Dekhi
Sharaabi Yeh Dil Ho Gaya

Maine Sada Chaaha Yehi
Daaman Bacha Loon Haseenon Se Main
Teri Kasam Khwaabon Mein Bhi
Bachta Fida Naazneenon Se Main
Tauba Magar Mil Gayi Tujhse Nazar
Mil Gaya Dard-E-Jigar

Sun Zara O Bekhabar
Zara Sa Haske Jo Dekha Tune
Main Tera Bismil Ho Gaya
Gulaabi Aankhen Jo Teri Dekhi
Sharaabi Yeh Dil Ho Gaya
Sambhaalo Mujhko O Mere Yaaron
Sambhalna Mushkil Ho Gaya

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

गुलाबी आँखें, जो तेरी देखी, शराबी ये दिल हो गया
सम्भालो मुझको, ओ मेरे यारों, सम्भलना मुश्किल हो गया

दिल में मेरे, ख़्वाब तेरे, तस्वीरें जैसे हों दीवार पे
तुझपे फ़िदा, मैं क्यूँ हुआ, आता है गुस्सा मुझे प्यार पे
मैं लुट गया, मान के दिल का कहा
मैं कहीं का ना रहा, क्या कहूँ मैं दिलरुबा
बुरा ये जादू तेरी आँखों का, ये मेरा क़ातिल हो गया
गुलाबी आँखें जो तेरी देखी...

मैंने सदा, चाहा यही, दामन बचा लूं हसीनों से मैं
तेरी क़सम, ख़्वाबों में भी, बचता फिरा नाज़नीनों से मैं
तौबा मगर, मिल गई तुझसे नज़र
मिल गया दर्द-ए-जिगर, सुन ज़रा ओ बेख़बर
ज़रा सा हँस के, जो देखा तूने, मैं तेरा बिस्मिल हो गया
गुलाबी आँखें जो तेरी देखी......

READ MORE ...

COMPUTER NETWORKS - VTU CSE/ISE CN LAB MANUAL

NETWORKS LABORATORY: CN LAB PROGRAMS FOR VTU CSE/ISE STUDENTS
Subject Code : 06CSL77
IA Marks : 25
No. of Practical Hrs./ Week : 03
Exam Hours : 03
Total No. of Practical Hrs. : 42
Exam Marks : 50

Note: Student is required to solve one problem from PART-A and one
problem from PART-B. The questions are allotted based on lots. Both
questions carry equal marks.

DOWNLOAD

SSIT CN LAB

PART - A

SIMULATION EXERCISES

The following experiments shall be conducted using either NS / OPNET or
any other suitable simulator.
1. Simulate a three nodes point – to – point network with duplex links
between them. Set the queue size and vary the bandwidth and find the
number of packets dropped.

2. Simulate a four node point-to-point network with the links connected as
follows:
n0 – n2, n1 – n2 and n2 – n3. Apply TCP agent between n0-n3 and UDP
between n1-n3. Apply relevant applications over TCP and UDP agents
changing the parameter and determine the number of packets sent by
TCP / UDP.

3. Simulate the different types of Internet traffic such as FTP and TELNET
over a network and analyze the throughput.

4. Simulate the transmission of ping messages over a network topology
consisting of 6 nodes and find the number of packets dropped due to
congestion.

5. Simulate an Ethernet LAN using n nodes (6-10), change error rate and
data rate and compare throughput.


6. Simulate an Ethernet LAN using n nodes and set multiple traffic nodes
and determine collision across different nodes.

7. Simulate an Ethernet LAN using n nodes and set multiple traffic nodes
and plot congestion window for different source / destination.

8. Simulate simple ESS and with transmitting nodes in wire-less LAN by
simulation and determine the performance with respect to transmission
of packets.

PART - B

Implement the following in C/C++:
1. Write a program for error detecting code using CRC-CCITT (16- bits).

2. Write a program for frame sorting technique used in buffers.

3. Write a program for distance vector algorithm to find suitable path for
transmission.

4. Using TCP/IP sockets, write a client – server program to make the client
send the file name and to make the server send back the contents of the
requested file if present.

5. Implement the above program using as message queues or FIFOs as IPC
channels.

6. Write a program for simple RSA algorithm to encrypt and decrypt the
data.

7. Write a program for Hamming code generation for error detection and
correction.

8. Write a program for congestion control using leaky bucket algorithm.

READ MORE ...

VTU: COMPUTER GRAPHICS LAB PROGRAMS FOR 6th SEM

COMPUTER GRAPHICS AND VISUALIZATION LABORATORY - VTU

Subject Code : 06CSL67 IA Marks : 25
No. of Practical Hrs./ Week : 03 Exam Hours : 03
Total No. of Practical Hrs. : 42 Exam Marks : 50

DOWNLOAD

PART - A

IMPLEMENT THE FOLLOWING PROGRAMS IN C / C++

1. Program to recursively subdivide a tetrahedron to from 3D Sierpinski
gasket. The number of recursive steps is to be specified by the user.

2. Program to implement Liang-Barsky line clipping algorithm.

3. Program to draw a color cube and spin it using OpenGL transformation
matrices.

4. Program to create a house like figure and rotate it about a given fixed
point using OpenGL functions.

5. Program to implement the Cohen-Sutherland line-clipping algorithm.
Make provision to specify the input line, window for clipping and view
port for displaying the clipped image.

6. Program to create a cylinder and a parallelepiped by extruding a circle
and quadrilateral respectively. Allow the user to specify the circle and
the quadrilateral.

7 Program, using OpenGL functions, to draw a simple shaded scene
consisting of a tea pot on a table. Define suitably the position and
properties of the light source along with the properties of the properties
of the surfaces of the solid object used in the scene.

8. Program to draw a color cube and allow the user to move the camera
suitably to experiment with perspective viewing. Use OpenGL functions.

9. Program to fill any given polygon using scan-line area filling algorithm.
(Use appropriate data structures.)

10. Program to display a set of values { fij } as a rectangular mesh.

PART - B
Develop a suitable Graphics package to implement the skills learnt in the
theory and the exercises indicated in Part A. Use the OpenGL.

READ MORE ...