Category Archives: Uncategorized

Cursors in SQL Server

First thing first. Usage of Cursors is not encouraged in SQL Server as they are slow. You may go with WHILE loop if you need to iterate through a recordset. Cursor is a database object to retrieve data from a … Continue reading

Posted in Uncategorized | Leave a comment

Understanding Indexes in SQL Server

Indexes in SQL Server are created on columns in tables or views. The index provides a faster way to look up data based on the values in those columns. For example, if you create an index on the primary key … Continue reading

Posted in Uncategorized | Tagged | Leave a comment

Tips to get out most from your online computer training.

Dear Students, Taking online courses can be very convenient for many people. However, online learning¬†requires time management skills, self-discipline, willpower, and strong motivation, as it may be challenging for online learners to successfully complete their online software¬†courses. Below are 10 … Continue reading

Posted in Uncategorized | 2 Comments

Why do you need to learn SQL Server,MSBI,.Net, isJava and C/C++?

SQL Server is a database management system which is used for various data relational purposes. The primary function is to store and retrieve data which is requested by any other software. The application can work on another computer connected via … Continue reading

Posted in Uncategorized | Leave a comment