What is Database & SQL?


Welcome to this tutorial series on Sql and database But before we learn about database let’s understand. What is data in simple words Data can be facts related to any object in consideration for example your name age height weight [ETC] are some data related to you a picture image file PdF ETC can all be considered Data now. What is a database? We already know what data is but this data could be random [a] database is a systematic collection of data Since the Data in a database is organized it makes Data management easy What is a database management system? DBMS Database management system or DBMs is a collection of programs which enables its users to access a database Manipulate Data and help in the representation of Data It also helps control access to the database by various users let’s discuss a few examples an Online telephone directory would definitely use database management system to store data pertaining to people phone numbers and other contact details Your electricity service provider is obviously using a dBMs to manage billing client related issues to Handle Fault Data Etc Let’s consider the Facebook It needs to store manipulate and present data related to members their friends member activities messages Advertisements, and a lot more we can provide countless numbers of examples for usage of DBMS Database management systems are not a new concept [and] as such had been first implemented in the 1960s Charles [Bachmann’s] integrated Data store, Or IDs is said to be the first DBMS in history with time database technologies evolved a lot while usage Expected functionalities of databases have been increased immensely types of DBMs Let’s see how the DBMs family evolved with time the Following diagram shows the evolution of DBMS categories There are four major types of DBMs. Let’s look into them in detail Hierarchical This type of DBMs employs the parent-child relationship of storing data This type of DBMs is rarely used Nowadays is Structure is like a tree with nodes representing records and branches representing fields The windows registry used in windows Xp is an example of a hierarchical database Configuration settings are stored as tree structures with nodes [Network] DBMs This type of DBMs supports many to many relationships this usually results in complex Database structures RdM server is an example of a database management system that implements the network Model relational DBMs This type of DBMS defines database relationships in forms of tables also known as relations Unlike the Network DBMs our DBMs does not support many to many relationships relational DBMs Usually have predefined data types that they can support This is the most popular DBMs type in the market examples of relational database management systems include mysQl oracle and Microsoft Sql server object-Oriented relational DBMs [this] type supports storage of new Data types the Data to be [stored] is in the form of objects the Objects to be stored in the database have attributes for example Gender or age and methods that define what to do with the data [Postgresql] is an example of object-Oriented relational DBMs So, what is sql? structured query language Sql pronounced as sql or sometimes as sequel is Actually the standard language for dealing with relational databases sql Can be effectively used to insert search update and delete database records That doesn’t mean sql cannot do things Beyond that in Fact it helps in optimizing and maintenance of databases and much more Relational databases like [mysQL], [oracle] Ms. Sql Sybase ETC use sql sql Syntax is used in these databases are almost similar except the fact that some databases use different syntaxes and even proprietary sql syntax is an example of an sqL statement select star from Members where age is Greater than 30? Dbm s stands for database management system We have four major types of DBMs is called Hierarchical Network relational and object-oriented the most widely used DBMs is the relational model the saves Data in table formats It uses sql as the standard query language Sql, is the standard language used to query a database the database approach has many advantages when it comes to storing data Compared to the traditional flat file based systems you

Danny Hutson

Leave a Reply

Your email address will not be published. Required fields are marked *