Friday, April 30, 2010

Delete and Truncate

Delete and Truncate are both commands in SQL to remove data from a table. But why do we have two commands? Are there any differences? YES! There are differences although the result is same. Both of them delete the data.

Monday, April 19, 2010

Inheritance

As we have already discussed in the previous post, OOPS characterizes objects by their class. So, if you only know the name of the class, you can name some of the characteristics of an object, such as even if you don't know what a BMW is, if someone tells you that it belongs to the class car, you would know the basic characteristics.

Sunday, April 18, 2010

Normalization and De-Normalization

Database normalization is a data design and organization process applied to data structures based on rules that help building relational databases.  Normalization is done to achieve the following goals:
  • eliminating redundant data (for example, storing the same data in more than one table)
  • ensuring data dependencies make sense (only storing related data in a table).

Saturday, April 17, 2010

Classes in OOP

A class is a blueprint or prototype from which objects are created. This section defines a class that models the state and behavior of a real-world object. It intentionally focuses on the basics, showing how even a simple class can cleanly model state and behavior.

Friday, April 16, 2010

SQL Server: Varchar v/s NVarchar

VARCHAR and NVARCHAR are two datatypes that are used in SQL Server very frequently and interchangeably. We would see what is the difference if any between these two:

Monday, April 12, 2010

OOPS-Building blocks-2

Continuing from the last post, we will look at what it means with
  • abstraction
  • polymorphism
  • encapsulation
  • event

Sunday, April 11, 2010

OOPS-Building blocks

Here are the basic blocks:
  • Class
  • Objects
  • Methods
  • Inheritance
  • Polymorphism
  • Abstraction
  • Event
  • Encapsulation

Object Oriented Programming (OOPS)

OOPS is the Computer programming concept that breaks the problem into smaller objects similar to real life. Traditionally, computer programming used to emphasize on solving the problems with functions and procedures. For every task there would exist a function. This was good but was confusing with complex products and softwares. Moreover, the data used to suffer because of this approach.

Why geekiatrics?

I'm starting this blog to freshen up  my programming concepts. It's been more than 4 years that I finished my education and have since been working with an MNC. Somehow, I felt the need to go back to the basics and study again to be able to hold fort in the field.

and hence this blog was born. Over the next few months, I'll keep posting my learnings on this platform. Hope this would also help others.

Looking forward to the contribution from readers as well.