Thursday, December 10, 2009

Microsoft Windows SHORTCUT KEYS


Shortcut keys help provide an easier and usually quicker method of navigating and using computer software programs.

Command Prompt



ANSI.SYS Defines functions that change display graphics, control cursor movement, and reassign keys.
APPEND Causes MS-DOS to look in other directories when editing a file or running a command.
ARP Displays, adds, and removes arp information from network devices.
ASSIGN Assign a drive letter to an alternate letter.
ASSOC View the file associations.
AT Schedule a time to execute commands or programs.
ATMADM Lists connections and addresses seen by Windows ATM call manager.
ATTRIB Display and change file attributes.
BATCH Recovery console command that executes a series of commands in a file.
BOOTCFG Recovery console command that allows a user to view, modify, and rebuild the boot.ini
BREAK Enable / disable CTRL + C feature.
CACLS View and modify file ACL's.
CALL Calls a batch file from another batch file.
CD Changes directories.
CHCP Supplement the International keyboard and character set information.
CHDIR Changes directories.
CHKDSK Check the hard disk drive running FAT for errors.
CHKNTFS Check the hard disk drive running NTFS for errors.
CHOICE Specify a listing of multiple options within a batch file.
CLS Clears the screen.
CMD Opens the command interpreter.
COLOR Easily change the foreground and background color of the MS-DOS window.
COMP Compares files.
COMPACT Compresses and uncompress files.
CONTROL Open control panel icons from the MS-DOS prompt.
CONVERT Convert FAT to NTFS.
COPY Copy one or more files to an alternate location.
CTTY Change the computers input/output devices.
DATE View or change the systems date.
DEBUG Debug utility to create assembly programs to modify hardware settings.
DEFRAG Re-arrange the hard disk drive to help with loading programs.
DEL Deletes one or more files.
DELETE Recovery console command that deletes a file.
DELTREE Deletes one or more files and/or directories.
DIR List the contents of one or more directory.
DISABLE Recovery console command that disables Windows system services or drivers.
DISKCOMP Compare a disk with another disk.
DISKCOPY Copy the contents of one disk and place them on another disk.
DOSKEY Command to view and execute commands that have been run in the past.
DOSSHELL A GUI to help with early MS-DOS users.
DRIVPARM Enables overwrite of original device drivers.
ECHO Displays messages and enables and disables echo.
EDIT View and edit files.
EDLIN View and edit files.
EMM386 Load extended Memory Manager.
ENABLE Recovery console command to enable a disable service or driver.
ENDLOCAL Stops the localization of the environment changes enabled by the setlocal command.
ERASE Erase files from computer.
EXIT Exit from the command interpreter.
EXPAND Expand a M*cros*ft Windows file back to it's original format.
EXTRACT Extract files from the M*cros*ft Windows cabinets.
FASTHELP Displays a listing of MS-DOS commands and information about them.
FC Compare files.
FDISK Utility used to create partitions on the hard disk drive.
FIND Search for text within a file.
FINDSTR Searches for a string of text within a file.
FIXBOOT Writes a new boot sector.
FIXMBR Writes a new boot record to a disk drive.
FOR Boolean used in batch files.
FORMAT Command to erase and prepare a disk drive.
FTP Command to connect and operate on a FTP server.
FTYPE Displays or modifies file types used in file extension associations.
GOTO Moves a batch file to a specific label or location.
GRAFTABL Show extended characters in graphics mode.
HELP Display a listing of commands and brief explanation.
IF Allows for batch files to perform conditional processing.
IFSHLP.SYS 32-bit file manager.
IPCONFIG Network command to view network adapter settings and assigned values.
KEYB Change layout of keyboard.
LABEL Change the label of a disk drive.
LH Load a device driver in to high memory.
LISTSVC Recovery console command that displays the services and drivers.
LOADFIX Load a program above the first 64k.
LOADHIGH Load a device driver in to high memory.
LOCK Lock the hard disk drive.
LOGON Recovery console command to list installations and enable administrator login.
MAP Displays the device name of a drive.
MD Command to create a new directory.
MEM Display memory on system.
MKDIR Command to create a new directory.
MODE Modify the port or display settings.
MORE Display one page at a time.
MOVE Move one or more files from one directory to another directory.
MSAV Early M*cros*ft Virus scanner.
MSD Diagnostics utility.
MSCDEX Utility used to load and provide access to the CD-ROM.
NBTSTAT Displays protocol statistics and current TCP/IP connections using NBT
NET Update, fix, or view the network or network settings
NETSH Configure dynamic and static network information from MS-DOS.
NETSTAT Display the TCP/IP network protocol statistics and information.
NLSFUNC Load country specific information.
NSLOOKUP Look up an IP address of a domain or host on a network.
PATH View and modify the computers path location.
PATHPING View and locate locations of network latency.
PAUSE Command used in batch files to stop the processing of a command.
PING Test / send information to another network computer or network device.
POPD Changes to the directory or network path stored by the pushd command.
POWER Conserve power with computer portables.
PRINT Prints data to a printer port.
PROMPT View and change the MS-DOS prompt.
PUSHD Stores a directory or network path in memory so it can be returned to at any time.
QBASIC Open the QBasic.
RD Removes an empty directory.
REN Renames a file or directory.
RENAME Renames a file or directory.
RMDIR Removes an empty directory.
ROUTE View and configure windows network route tables.
RUNAS Enables a user to execute a program on another computer.
SCANDISK Run the scandisk utility.
SCANREG Scan registry and recover registry from errors.
SET Change one variable or string to another.
SETLOCAL Enables local environments to be changed without affecting anything else.
SETVER Change MS-DOS version to trick older MS-DOS programs.
SHARE Installs support for file sharing and locking capabilities.
SHIFT Changes the position of replaceable parameters in a batch program.
SHUTDOWN Shutdown the computer from the MS-DOS prompt.
SMARTDRV Create a disk cache in conventional memory or extended memory.
SORT Sorts the input and displays the output to the screen.
START Start a separate window in Windows from the MS-DOS prompt.
SUBST Substitute a folder on your computer for another drive letter.
SWITCHES Remove add functions from MS-DOS.
SYS Transfer system files to disk drive.
TELNET Telnet to another computer / device from the prompt.
TIME View or modify the system time.
TITLE Change the title of their MS-DOS window.
TRACERT Visually view a network packets route across a network.
TREE View a visual tree of the hard disk drive.
TYPE Display the contents of a file.
UNDELETE Undelete a file that has been deleted.
UNFORMAT Unformat a hard disk drive.
UNLOCK Unlock a disk drive.
VER Display the version information.
VERIFY Enables or disables the feature to determine if files have been written properly.
VOL Displays the volume information about the designated drive.
XCOPY Copy multiple files, directories, and/or drives from one location to another.
TRUENAME When placed before a file, will display the whole directory in which it exists
TASKKILL It allows you to kill those unneeded or locked up applications
read more "Microsoft Windows SHORTCUT KEYS"

Run Commands To Access The Control Panel

Add/Remove Programs control appwiz.cpl
Date/Time Properties control timedate.cpl
Display Properties control desk.cpl
FindFast control findfast.cpl
Fonts Folder control fonts
Internet Properties control inetcpl.cpl
Keyboard Properties control main.cpl keyboard
Mouse Properties control main.cpl
Multimedia Properties control mmsys.cpl
Network Properties control netcpl.cpl
Password Properties control password.cpl
Printers Folder control printers
Sound Properties control mmsys.cpl sounds
System Properties control sysdm.cpl

read more "Run Commands To Access The Control Panel"

Run Commands

compmgmt.msc - Computer management
devmgmt.msc - Device manager
diskmgmt.msc - Disk management
dfrg.msc - Disk defrag
eventvwr.msc - Event viewer
fsmgmt.msc - Shared folders
gpedit.msc - Group policies
lusrmgr.msc - Local users and groups
perfmon.msc - Performance monitor
rsop.msc - Resultant set of policies
secpol.msc - Local security settings
services.msc - Various Services
msconfig - System Configuration Utility
regedit - Registry Editor
msinfo32 _ System Information
sysedit _ System Edit
win.ini _ windows loading information(also system.ini)
winver _ Shows current version of windows
mailto: _ Opens default email client
command _ Opens command prompt
read more "Run Commands"

Windows XP Shortcuts

ALT+- (ALT+hyphen) Displays the Multiple Document Interface (MDI) child window's System menu
ALT+ENTER View properties for the selected item
ALT+ESC Cycle through items in the order they were opened
ALT+F4 Close the active item, or quit the active program
ALT+SPACEBAR Display the System menu for the active window
ALT+TAB Switch between open items
ALT+Underlined letter Display the corresponding menu
BACKSPACE View the folder one level up in My Computer or Windows Explorer
CTRL+A Select all
CTRL+B Bold
CTRL+C Copy
CTRL+I Italics
CTRL+O Open an item
CTRL+U Underline
CTRL+V Paste
CTRL+X Cut
CTRL+Z Undo
CTRL+F4 Close the active document
CTRL while dragging Copy selected item
CTRL+SHIFT while dragging Create shortcut to selected iteM
CTRL+RIGHT ARROW Move the insertion point to the beginning of the next word
CTRL+LEFT ARROW Move the insertion point to the beginning of the previous word
CTRL+DOWN ARROW Move the insertion point to the beginning of the next paragraph
CTRL+UP ARROW Move the insertion point to the beginning of the previous paragraph
SHIFT+DELETE Delete selected item permanently without placing the item in the Recycle Bin
ESC Cancel the current task
F1 Displays Help
F2 Rename selected item
F3 Search for a file or folder
F4 Display the Address bar list in My Computer or Windows Explorer
F5 Refresh the active window
F6 Cycle through screen elements in a window or on the desktop
F10 Activate the menu bar in the active program
SHIFT+F10 Display the shortcut menu for the selected item
CTRL+ESC Display the Start menu
SHIFT+CTRL+ESC Launches Task Manager
SHIFT when you insert a CD Prevent the CD from automatically playing
WIN Display or hide the Start menu
WIN+BREAK Display the System Properties dialog box
WIN+D Minimizes all Windows and shows the Desktop
WIN+E Open Windows Explorer
WIN+F Search for a file or folder
WIN+F+CTRL Search for computers
WIN+L Locks the desktop
WIN+M Minimize or restore all windows
WIN+R Open the Run dialog box
WIN+TAB Switch between open items
read more "Windows XP Shortcuts"

Windows Explorer Shortcuts

ALT+SPACEBAR - Display the current window’s system menu
SHIFT+F10 - Display the item's context menu
CTRL+ESC - Display the Start menu
ALT+TAB - Switch to the window you last used
ALT+F4 - Close the current window or quit
CTRL+A - Select all items
CTRL+X - Cut selected item(s)
CTRL+C - Copy selected item(s)
CTRL+V - Paste item(s)
CTRL+Z - Undo last action
CTRL+(+) - Automatically resize the columns in the right hand pane
TAB - Move forward through options
ALT+RIGHT ARROW - Move forward to a previous view
ALT+LEFT ARROW - Move backward to a previous view
SHIFT+DELETE - Delete an item immediately
BACKSPACE - View the folder one level up
ALT+ENTER - View an item’s properties
F10 - Activate the menu bar in programs
F6 - Switch between left and right panes
F5 - Refresh window contents
F3 - Display Find application
F2 - Rename selected item
read more "Windows Explorer Shortcuts"

Internet Explorer Shortcuts


CTRL+A - Select all items on the current page
CTRL+D - Add the current page to your Favorites
CTRL+E - Open the Search bar
CTRL+F - Find on this page
CTRL+H - Open the History bar
CTRL+I - Open the Favorites bar
CTRL+N - Open a new window
CTRL+O - Go to a new location
CTRL+P - Print the current page or active frame
CTRL+S - Save the current page
CTRL+W - Close current browser window
CTRL+ENTER - Adds the http://www. (url) .com
SHIFT+CLICK - Open link in new window
BACKSPACE - Go to the previous page
ALT+HOME - Go to your Home page
HOME - Move to the beginning of a document
TAB - Move forward through items on a page
END - Move to the end of a document
ESC - Stop downloading a page
F11 - Toggle full-screen view
F5 - Refresh the current page
F4 - Display list of typed addresses
F6 - Change Address bar and page focus
ALT+RIGHT ARROW - Go to the next page
SHIFT+CTRL+TAB - Move back between frames
SHIFT+F10 - Display a shortcut menu for a link
SHIFT+TAB - Move back through the items on a page
CTRL+TAB - Move forward between frames
CTRL+C - Copy selected items to the clipboard
CTRL+V - Insert contents of the clipboard
ENTER - Activate a selected link
HOME - Move to the beginning of a document
END - Move to the end of a document
F1 - Display Internet Explorer Help
read more "Internet Explorer Shortcuts"

Accessibility Shortcuts



Tap SHIFT 5 times - Toggles StickyKeys on and off.
Press down and hold the right SHIFT key for 8 seconds - Toggles FilterKeys on and off.
Press down and hold the NUM LOCK key for 5 seconds - Toggles ToggleKeys on and off.
Left ALT+left SHIFT+NUM LOCK - Toggles MouseKeys on and off.
Left ALT+left SHIFT+PRINT SCREEN - Toggles High Contrast on and off.
read more "Accessibility Shortcuts"

Microsoft Office Keyboard Shortcut Keys


All Caps - CTRL+SHIFT+A
Annotation - ALT+CTRL+M
Auto Format - ALT+CTRL+K
Auto Text - F3 or ALT+CTRL+V
Bold - CTRL+B or CTRL+SHIFT+B
Bookmark - CTRL+SHIFT+F5
Copy - CTRL+C or CTRL+INSERT
Copy Format - CTRL+SHIFT+C
Copy Text - SHIFT+F2
Create Auto Text - ALT+F3
Date Field - ALT+SHIFT+D
Delete Back Word - CTRL+BACKSPACE
Delete Word - CTRL+DELETE
Dictionary - ALT+SHIFT+F7
Do Field Click - ALT+SHIFT+F9
Doc Maximize - CTRL+F10
Doc Move - CTRL+F7
Doc Restore - CTRL+F5
Doc Size - CTRL+F8
Grow Font - CTRL+SHIFT+.
Grow Font One Point - CTRL+]Hanging Indent - CTRL+T
Header Footer Link - ALT+SHIFT+R
Help - F1
Hidden - CTRL+SHIFT+H
Hyperlink - CTRL+K
Indent - CTRL+M
Italic - CTRL+I or CTRL+SHIFT+I
Justify Para - CTRL+J
Left Para - CTRL+L
Line Up Extend - SHIFT+UP
List Num Field - ALT+CTRL+L
Outline - ALT+CTRL+O
Outline Collapse - ALT+SHIFT+- or ALT+SHIFT+NUM -
Outline Demote - ALT+SHIFT+RIGHT
Outline Expand - ALT+SHIFT+=
Outline Expand - ALT+SHIFT+NUM +
Outline Move Down - ALT+SHIFT+DOWN
Outline Move Up - ALT+SHIFT+UP
Outline Promote - ALT+SHIFT+LEFT
Outline Show First Line - ALT+SHIFT+L
Lock Fields - CTRL+3 or CTRL+F11
Web Go Back - ALT+LEFT
Web Go Forward - ALT+RIGHT
Word Left - CTRL+LEFT
Word Left Extend - CTRL+SHIFT+LEFT
Word Right - CTRL+RIGHT
read more "Microsoft Office Keyboard Shortcut Keys"

Excel Time saving Shortcuts



Move to next cell in row - Tab
Move to previous cell in row - Shift + Tab
Up one screen - Page Up
Down one screen - Page Down
Move to next worksheet - Ctrl + Page Down
Move to previous worksheet - Ctrl + Page Up
Go to first cell in data region - Ctrl + Home
Go to last cell in data region - Ctrl + End
Bold toggle for selection - Ctrl + B
Italic toggle for selection - Ctrl + I
Underline toggle for selection - Ctrl + U
Strikethrough for selection - Ctrl + 5
Change the font - Ctrl + Shift + F
Change the font size - Ctrl + Shift + P
Apply outline borders - Ctrl + Shift + 7
Remove all borders - Ctrl + Shift + Underline
Wrap text in same cell - Alt + Enter
Format cells - Ctrl + 1
Select font - Ctrl + Shift + F
Select point size - Ctrl + Shift + P
Format as currency - Ctrl + Shift + 4
Format as general - Ctrl + Shift + # (hash sign)
Format as percentage - Ctrl + Shift + 5
Format as number - Ctrl + Shift + 1
Autosum a range of cells - Alt + Equals Sign
Insert the date - Ctrl +; (semi-colon)
Insert the time - Ctrl + Shift +; (semi-colon)
Insert columns/rows - Ctrl + Shift + + (plus sign)
Insert a new worksheet - Shift + F11
Read Monitor Cell One - Alt + Shift + 1
Read Monitor Cell Two - Alt + Shift + 2
Read Monitor Cell Three - Alt + Shift + 3
Read Monitor Cell Four - Alt + Shift + 4
List Visible Cells With Data - Ctrl + Shift + D
Lists Data In Current Column - Ctrl + Shift + C
List Data In Current Row - Ctrl + Shift + R
Select Hyperlink - Ctrl + Shift + H
Move To Worksheet Listbox - Ctrl + Shift + S
Move To Monitor Cell - Ctrl + Shift + M
Select Worksheet Objects - Ctrl + Shift + O
List Cells At Page Breaks - Ctrl + Shift + B
Options Listbox - Insert + V
read more "Excel Time saving Shortcuts"

Easy move through Powerpoint


Quote:
Apply subscript formatting - CTRL+EQUAL SIGN (=)
Apply superscript formatting - CTRL+PLUS SIGN (+)
Bold - CTRL+B
Capitalize - SHIFT+F3
Copy - CTRL+C
Delete a word - CTRL+BACKSPACE
Demote a paragraph - ALT+SHIFT+RIGHT ARROW
Find - CTRL+F
Insert a hyperlink - CTRL+K
Insert a new slide - CTRL+M
Italicize - CTRL+I
Make a duplicate of the current slide - CTRL+D
Open - CTRL+O
Open the Font dialog box - CTRL+T
Paste - CTRL+V
Print - CTRL+P
Promote a paragraph - ALT+SHIFT+LEFT ARROW
Repeat your last action - F4 or CTRL+Y
Save - CTRL+S
Select all - CTRL+A
Start a slide show - F5
Switch to the next pane (clockwise) - F6
Switch to the previous pane - SHIFT+F6
Undo - CTRL+Z
View guides - CTRL+G
read more "Easy move through Powerpoint"

Window XP Hidden Applications Shortcuts

To run any of these apps go to Start > Run and type the executable name:


1) Character Map = charmap.exe (very useful for finding unusual characters)


2) Disk Cleanup = cleanmgr.exe


3) Clipboard Viewer = clipbrd.exe (views contents of Windows clipboard)


4) Dr Watson = drwtsn32.exe (Troubleshooting tool)

5) DirectX diagnosis = dxdiag.exe (Diagnose & test DirectX, video & sound cards)


6) Private character editor = eudcedit.exe (allows creation or modification of characters)


7) IExpress Wizard = iexpress.exe (Create self-extracting / self-installing package)


8) Microsoft Synchronization Manager = mobsync.exe (appears to allow synchronization of files on the network for when working offline. Apparently undocumented).


9) Windows Media Player 5.1 = mplay32.exe (Retro version of Media Player, very basic).


10) ODBC Data Source Administrator = odbcad32.exe (something to do with databases)


11) Object Packager = packager.exe (to do with packaging objects for insertion in files, appears to have comprehensive help files).


12) System Monitor = perfmon.exe (very useful, highly configurable tool, tells you everything you ever wanted to know about any aspect of PC performance, for uber-geeks only )


13) Program Manager = progman.exe (Legacy Windows 3.x desktop shell).


14) Remote Access phone book = rasphone.exe (documentation is virtually non-existant).


15) Registry Editor = regedt32.exe [also regedit.exe] (for hacking the Windows Registry).


16) Network shared folder wizard = shrpubw.exe (creates shared folders on network).


17) File siganture verification tool = sigverif.exe


18) Volume Control = sndvol32.exe (I've included this for those people that lose it from the System Notification area).


19) System Configuration Editor = sysedit.exe (modify System.ini & Win.ini just like in Win98! ).


20) Syskey = syskey.exe (Secures XP Account database - use with care, it's virtually undocumented but it appears to encrypt all passwords, I'm not sure of the full implications).


21) Microsoft Telnet Client = telnet.exe


22) Driver Verifier Manager = verifier.exe (seems to be a utility for monitoring the actions of drivers, might be useful for people having driver problems. Undocumented).


23) Windows for Workgroups Chat = winchat.exe (appears to be an old NT utility to allow chat sessions over a LAN, help files available).
read more "Window XP Hidden Applications Shortcuts"

Database Programming With JAVA




Contents:

Part I: The JDBC API

Chapter 1. Java in the Enterprise

The Enterprise
Java as a Tool for Enterprise Development
The Database
Database Programming with Java

Chapter 2. Relational Databases and SQL

What Is a Relational Database?
Databases and Database Engines
An Introduction to SQL
A Note on SQL Versions

Chapter 3. Introduction to JDBC

What Is JDBC?
Connecting to the Database
Connection Troubles
Basic Database Access
SQL Datatypes and Java Datatypes
Scrollable Result Sets
The JDBC Support Classes
A Database Servlet

Chapter 4. Advanced JDBC

Prepared SQL
What Kind of Statement to Use?
Batch Processing
Updatable Result Sets
Advanced Datatypes
Meta-Data


Chapter 5. The JDBC Optional Package
Data Sources
Connection Pooling
Rowsets
Distributed Transactions

Part II: Applied JDBC


Chapter 6. Other Enterprise APIs

Java Naming and Directory Interface
Remote Method Invocation
Object Serialization
Enterprise JavaBeans.

Chapter 7. Distributed Application Architecture.

Architecture.
Design Patterns
The Banking Application

Chapter 8. Distributed Component Models

Kinds of Distributed Components
Security
Transactions
Lookups and Searches
Entity Relationships

Chapter 9. Persistence

Database Transactions
Mementos and Delegates
JDBC Persistence
Searches
Chapter 10. The User Interface
Swing at a Glance.
Models for Database Applications
Distributed Listeners
Worker Threads

Part III: Reference .


Chapter 11. JDBC Reference

Reference

Chapter 12. The JDBC Optional Package Reference

If you have not yet read a book on Java, then this book should not be the first one you pick up. I
assume that readers have a basic understanding of the Java programming language. Specifically,
you should feel comfortable with the basic syntax of Java and central concepts such as classes,
interfaces, and packages.we also expect that you know some basic database concepts. You do not need the same solid foundation with database concepts that he assume for Java. Instead, you should have some minimal exposure to relational databases; you should know what tables, columns, and rows are andunderstand basic SQL syntax.

For download:


 
read more "Database Programming With JAVA"

DBMS by Raghu Ramakrishnan 2nd edition



Database management systems have become ubiquitous as a fundamental tool for managinginformation, and a course on the principles and practice of database systems isnow an integral part of computer science curricula. This book covers the fundamentalsof modern database management systems, in particular relational database systems.It is intended as a text for an introductory database course for undergraduates, andwe have attempted to present the material in a clear, simple style.

New in the Second Edition
Based on extensive user surveys and feedback, we have re ned the book's organization.
The major change is the early introduction of the ER model, together with a discussion
of conceptual database design. As in the rst edition, we introduce SQL-92's data
de nition features together with the relational model (in Chapter 3), and whenever
appropriate, relational model concepts (e.g., de nition of a relation, updates, views, ER
to relational mapping) are illustrated and discussed in the context of SQL. Of course,
we maintain a careful separation between the concepts and their SQL realization. The
material on data storage, le organization, and indexes has been moved back, and the material on relational queries has been moved forward. Nonetheless, the two parts(storage and organization vs. queries) can still be taught in either order based on theinstructor's preferences.In order to facilitate brief coverage in a rst course, the second edition contains overviewchapters on transaction processing and query optimization. Most chapters have beenrevised extensively, and additional explanations and gures have been added in manyplaces. For example, the chapters on query languages now contain a uniform numberingof all queries to facilitate comparisons of the same query (in algebra, calculus, andSQL), and the results of several queries are shown in gures. JDBC and ODBCcoverage has been added to the SQL query chapter and SQL:1999 features are discussedboth in this chapter and the chapter on object-relational databases. A discussion ofRAID has been added to Chapter 7. We have added a new database design case study,illustrating the entire design cycle, as an appendix.

for free download:

 
read more "DBMS by Raghu Ramakrishnan 2nd edition"

Oracle/SQL Tutorial

Contents
1. SQL – Structured Query Language
1.1. Tables
1.2. Queries (Part I)
1.3. Data Definition in SQL
1.4. Data Modifications in SQL
1.5. Queries (Part II)
1.6. Views
2. SQL*Plus (Minimal User Guide, Editor Commands, Help System)
3. Oracle Data Dictionary
4. Application Programming
4.1. PL/SQL
4.1.1 Introduction
4.1.2 Structure of PL/SQL Blocks
4.1.3 Declarations
4.1.4 Language Elements
4.1.5 Exception Handling
4.1.6 Procedures and Functions
4.1.7 Packages
4.1.8 Programming in PL/SQL
4.2. Embedded SQL and Pro*C
5. Integrity Constraints and Triggers
5.1. Integrity Constraints
5.1.1 Check Constraints
5.1.2 Foreign Key Constraints
5.1.3 More About Column- and Table Constraints
5.2. Triggers
5.2.1 Overview
5.2.2 Structure of Triggers
5.2.3 Example Triggers
5.2.4 Programming Triggers
6. System Architecture
6.1. Storage Management and Processes
6.2. Logical Database Structures
6.3. Physical Database Structures
6.4. Steps in Processing an SQL Statement
6.5. Creating Database Objects

This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the
Oracle Relational Database Management System.

For Download:


 


For sql server cheat sheet:



read more "Oracle/SQL Tutorial"

Data Base System Concepts By Korth



"Database System Concepts," , is intended for a first course in databases at the junior or senior undergraduate, or first-year graduate, level. In addition to basic material for a first course, the text contains advanced material that can be used for course supplements, or as introductory material for an advanced course.

The authors assume only a familiarity with basic data structures, computer organization, and a high-level programming language such as Java, C, or Pascal. Concepts are presented as intuitive descriptions, and many are based on the running example of a bank enterprise. Important theoretical results are covered, but formal proofs are omitted. In place of proofs, figures and examples are used to suggest why a result is true.

For Download:-



read more "Data Base System Concepts By Korth"

DBMS Lab Manual

This Material helps you to prepare well for DBMS Lab External Exam....All the Commands in SQL,PL/SQL and all Concepts in DBMS are explained in a lucid way with examples such that even a lay person could understand well.

Get a free download of DBMS Lab Manual


read more "DBMS Lab Manual"

Oracle 10g Concepts


Oracle Concepts 10g and Database Architecture:This book provides a brief overview of Architecture of Oracle database. It also gives an introduction to the concept of instance. The document discusses the structures that are used to define the physical and logical representations if Oracle Database. Get a free download of Oracle 10g Concepts

 
read more "Oracle 10g Concepts"

Oracle SQL Programming -O Reilly


For the past ten years, O'Reilly's Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle's powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone--from novices to experienced developers, and from Oracle Forms developers to database administrators--make the most of PL/SQL.
The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.
The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Get a free download of Oracle SQL Programming -O Reilly




read more "Oracle SQL Programming -O Reilly"

Nokia Cell Themes


hii friends...here are some amusing Nokia cell phone themes.

Download for free from WWW.VSMB.TK





read more "Nokia Cell Themes"

Download Nokia NSeries Pack 2009inc 1000 softwares


Nokia NSeries Pack 2009inc 1000 softwares

Apps-Themes-Games l Symbian OS 6>8>9 l Nokia N70-N80-N90 l 92 MB l RAR

Program-Tema-Oyun l Symbian OS 6>8>9 l Nokia N70-N80-N90 l 92 MB l RAR

Description:
Active Desk 1.51
Aglie Messenger 3.30 Nokia 6600, 7610, 6620
Aglie Messenger 3.30 Nokia 7650, 3650, 36xx, N-GAGE
Album OpenBit
Answering Machine 1.20
Audioa Aalyzer 1.0
Avant Go 5.2.41
BlackBaller 1.0
BlackList 1.02
Cabir Fix
Call Cheater 1.01
Call Control 1.0
Call Control 1.0 6600
Camcoder 3.75
Camcoder Pro 7.4
CameraFX 1.3.1
Cell Track
Contacts Manager 1.04
Crystal Player 1.2
DevMan 2.02
Doris Browser 1.1.9
Extended File Manager 1.71
FExplorer 1.11
Fileman 1.01
Finanz 1.01
Flash Player 1.1
FlashGet 0.7
Foto Fun Pack
Full Screen Caller 3.00
GSM Position Locator 1.82
HipCam 1.02
irRemote Control 1.00
Key Locker 1.0
MadMixer 1.0
Mate Finder 2.4.8
Message Saver 1.14
MobiClip
MP3 Go 2.02
MP3 Gravity 1.2
Mp3Player 1.10
mUltiMedia Player 0.90
myList 3.50
Opera 8.0
PDF Plus 1.36
Photo Editor 1.01
Photo Fusion 2.25
Photo Grapher 2.42
Photo Plus 1.0
PhotoSMS 1.64
Power Dictaphone 1.00
PowerLock 1.0
PowerNotes 1.01
PV Player 3.04
Quick Office 2.0
Quick Word 1.08
Quran 0.941b
Real player Advanced
Resco Viewer 4.01
Ringtone Studio 1.41
Screen Saver 1.71
sDoubler 1.10
SeleQ 1.65i
SimWorks AntiVirus 1.22
Smart Answer 2.02
Smart Dialer 1.1
Smart Launcher 1.06
SmartMovie 2.44
SMS Machine 1.01
Splash Photo 4.1.2
Spy Call 1.1 For 6600
Switcher 1.5
Ulead Phote Express
Ultra MP3 1.32
Vics Player
Video Studio MStyle 1.0
World Clock Pro 1.10
WorldMate 1.0
XP Icon Changer
Zipman 2.31









read more "Download Nokia NSeries Pack 2009inc 1000 softwares"

Download Nokia N80 Themes



       




read more "Download Nokia N80 Themes"

Batch Commands



hi.......
Are you interested in batch programming then you have here an excellent material on dos commands.These include commands from the basics.Every command is well explained with syntax and a real time example.Then why are you waiting still? Just click on the below two tutorials and start inventing.

Tutorial1

Tutorial2

Tutorial3

read more "Batch Commands"

Batch Programming

Tutorial of  BATCH PROGRAMMING



read more "Batch Programming"

Flag counter

free counters