Database Quick Reference-SQL,Oracle,MS-Access..

• Oracle Datatypes

• Complete Oracle Tutorial

• Oracle Stored Procedures(Full)

• Oracle Stored Procedures(Quick Ref)

• PL/SQL Material

• Normal Forms at a glance

• Date functions (To_Date)

• Multiple update conditions in single query(Using CASE and WHEN)

• Update columns by joining multiple tables,update multiple columns

• Rank, DenseRank (Finding second maximum salary....)

• Joins Reference

• How to export data from Oracle/How to dump Oracle data(Tables/Users)

• Materialized View (PPT)

• SQL Performance Tuning and Profiling (PPT)

Microsoft Office

• Excel macro material

• Excel Keyboard Shortcuts

• ExcelVBA for beginers

• Word Keyboard Shortcuts

• Popup a calendar when I click on a cell

PHP

• PHP Quick Reference