Latest article tagged on "Database Design"

Indexes in SQL Server

Indexes are used in relational databases to quickly retrieve the data .It is similar to indexes at the front of the books whose purpose is to find a topic quickly.


In this article, I want to explain about SQL Keys such as PRIMARY KEY, FOREIGN KEY, COMPOSITE KEY, and UNIQUE KEY AND ALTERNATE KEY.

By Anupam Mishra posted   one year ago

Working With BLOB(Binary Large Objects)

A BLOB is a build-in data type supported by the database implementing SQL 99 alias SQL3 Standards. A BLOB is used to store large binary data ,such as bit images,audios,and multimedia clips as the column value in a database table.

By Anupam Mishra posted   one year ago

Using Cursor in CallableStatement

A cursor defines the runtime execution environment for query when the result of the query execution can be captured.

By Anupam Mishra posted   one year ago

Callable Statement in Java

In Java, CallableStatement is used to call the stored procedures and functions by using an object of the CallableStatement Interface.

By Anupam Mishra posted   one year ago

Don't want to miss updates? Please click the below button!

Follow MindStick