Real Life SQL and .NET

Welcome to the world of SQL and the huge,growing database technologies of today's business all over the SQLworld. By reading this article, we have begun accepting the knowledgethat will soon be required for survival in today's world of relationaldatabase and data management. Alas, for the reason that it is firstnecessary to provide a background of SQL and cover some preliminaryconcepts that we need to know, the majority of this article is text inparagraph format.

The highlights of this article include:
-An introduction to and brief history of SQL
-An overview of some basic terms and concepts
-An introduction to database management systems

After we have enough information ANSI SQL, we will focus on T-SQL, Jet SQL, and Oracle SQL.

SQL Classification and History

Every business has data, which requires someorganized method, or mechanism, for maintaining the data. Thismechanism is referred to as a database management system (DBMS).Database management systems have been around for years, many of whichstarted out as flat-file systems on a mainframe. With today'stechnologies, the accepted use of database management systems has begunto flow in other directions, driven by the demands of growing business,increased volumes of corporate data, and of course Internettechnologies.

Today two important technologies are veryfavorites. First one is Relational Database and second one is ObjectDatabase technology. Object Database's capability to allocate and storeobjects is the most obvious difference between a Relational Databaseand Object Database. Objects are fussy instances or occurrences of aclass. We can straight accumulate an object without first convertingthe object's member variables into columns in a relational table whenusing an object database A more accurate model of the real world isprovided by the object database approach. We can keep away from theartificial concept of mapping class member variables to databasecolumns by directly storing objects in the database. An objectidentifier identifies every object stored in an object database. Objectidentifier is equivalent to a primary identifier in the relationalworld. There are some advantages against each other but whatever if weuse one of them this technologies, we will need to use SQL.

What is SQL really?

Structured Query Language is the standardlanguage used to communicate with a relational database or objectdatabase. The prototype was originally developed by IBM using Dr. E.F.Codd's theory as a model. In 1979, not long after IBM's prototype, thefirst SQL product, ORACLE, was released by Relational Software, Inc.(now Oracle Corporation). SQL is pronounced either of two ways as theletters S-Q-L (esquel), or "sequel"; both pronounced are acceptable.SQL is the language that we use to express our needs to the database.We may request specific information from within a database in the formof a query, using SQL.The American National Standards Institute (ANSI) is an organizationthat approves certain standards in many different industries. SQL hasbeen deemed the standard language is relational database communication,originally approved in 1986 based on IBM's implementation. The currentstandard is referred to as SQL/92, much revised since 1986.

Download the rest of the article [here]