MySql stored procedure and stored function

Dear Viewers,

This post demonstrates MySql stored procedure and stored function. Small dataset considered is as below

mysql> select * from student;
+------+---------+-------+----------+
| rno  | name    | class | division |
+------+---------+-------+----------+
|    1 | John    | TE    | A        |
|    2 | Peter   | TE    | A        |
|    1 | David   | TE    | B        |
|    2 | Solomon | TE    | B        |
+------+---------+-------+----------+

Shell script to perform simple file operations

Dear Viewers
Below shell script handles basic file operations. Linux commands used to perform operations are:
1. echo - to print on standard output
2. read - to read user input
3. touch - to create a file
4. mv - to rename a file
5. rm - to remove a file
6. ls - to list the contents of current directory  

Basic MySql commands for beginner

Dear Viewers,

This post is presenting basic MySql commands useful for MySql beginner. For demonstration purpose I have used MySql installed on Ubuntu 12.04.

1. Check mysql service status
pavan@ubuntu:~$ service mysql status
mysql start/running, process 1583

2. Stop mysql service
pavan@ubuntu:~$ sudo service mysql stop
mysql stop/waiting

"Backspacce" key not working in Fedora nautilus

Dear Viewers,

While using Fedora distributions, you might have experienced that "Backspace" key on nautilus do not work. In simple words, nautilus means filesystem hierarchy under "/". So every time to visit or to go back to previously accessed folder, you have to make use of mouse and click on "Back" button available on left top corner. So if you wants to get rid out of this and wish to use shortcut key, then follow the process given below:

1. Open terminal

2. Type in  vi /root/.config/nautilus/accels 

3. Replace the user root by the user name for whom you would like to apply these settings. Important is you have to provide absolute path.

4. Go into "Insert" mode on VI, and copy paste below line as it is

 (gtk_accel_path "<Actions>/ShellActions/Up" "BackSpace") 

5.Press "Esc" then ":" and type "wq"

6. This will save the changes made and will take you back on terminal

7. On terminal type either "nautilus -q" or "killall nautilus"

8. Now open any folder, jump to any directories and cross check whether "Backspace" started working. 

9. You are done.

All The Best.....

Memory Management and Virtual Memory - presentation

Click here to download

Java Programming Concepts - presentation

Click here to download

Linux administration tools and commands

Dear Viewers,

You may use following links where Linux administration tools and utilities have been explained with examples so well.

Link 1:
http://www.tecmint.com/60-commands-of-linux-a-guide-from-newbies-to-system-administrator/

Link 2:
http://www.tldp.org/LDP/abs/html/system.html

Link 3:
http://www.reallylinux.com/docs/admin.shtml

Process and Threads - presentation

Click here to download

Introduction to UNIX OS - presentation

Click here to download

Operating Systems Design - syllabus

Class: TE Computer                                                                                  Subject Code: 310242 

Course Objectives
· To learn the Operating System Booting Process
· To learn advance file system and operating system management
· To learn init() process and other essential boot processes
· To learn use of GRUB2

Course Outcomes
· Ability to use EFI based x64 Operating Systems
· Ability to use x64 based File Systems and Managers