The quick 3 minute SQL quiz a really good tool to test your SQL knowledge. Start trying it today.
The popular ways to prevent deadlock in database while dealing with SQL queries written clearly such that even layman can understand quickly.
Avoid multiple UNION when you want to write better SQL query. Always better to USE case statement this improves performance. Read more.
The power of RDBMS depends on certain rules placed. These rules are called as integrity rules. Those are entity integrity and referential integrity.
You all know RENAME clause in SQL is highly useful to change the name of Table, Index or other objects. Given here why this clause is used and syntax and Rules presented for ORACLE and DB2 databases.
The best example for Java stored procedure in DB2, also given java class path to write stored procedure and explained how to include it in the DB2 stored procedure standard block. Read more.