It takes time to become a Database Expert or an expert Database Administrator. This all comes with lot of experience in various database d...
Read More
SQL - Injection
If you take user input through a webpage and insert it into a SQL database, there's a chance that you have left yourself wide open for...
Read More
SQL - Handling Duplicates
There may be a situation when you have multiple duplicate records in a table. While fetching such records, it makes more sense to fetch on...
Read More
SQL - Using Sequences
A sequence is a set of integers 1, 2, 3, ... that are generated in order on demand. Sequences are frequently used in databases because man...
Read More
SQL - Sub Queries
A Subquery or Inner query or Nested query is a query within another SQL query and embedded within the WHERE clause. A subquery is used t...
Read More
Subscribe to:
Posts
(
Atom
)