Introduction to Database | Types of Database Architecture | Introduction to SQL | Intellipaat

Introduction to Database | Types of Database Architecture | Introduction to SQL | Intellipaat


Hey guys welcome to this SQL tutorial
course. In this session we’ll start off by understanding what is a database
and then look at the types of database architecture and finally you will
understand what is SQL. So what exactly is a database. Well simply put it’s just
an organized collection of data that are stored in an electronic format,
more specifically a database is an electronic system and that allows us to
easily access manipulate and update the data. Now the modern databases are
managed using something known as a database management system so a database management system or DBMS is basically a system software for creating and
managing databases so the DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data. So now that we’ve understood what
exactly is a database and database management system let’s have a look at
the types of database architecture. So the database architecture could either
be file server or client server. So let’s start with a file server architecture. So
in the file server architecture the files are located on your local system
that is they’re local to you, now suppose you
have an excel file with you and you send a copy to your friend. Now if you make
any changes in your original excel file those changes would not be reflected in
the file with your friend , so in the file server architecture, the server or the
local system acts only as a storage device and only one person at a time can
access it. So this is the basic premise behind file server architecture. Now
let’s look at client-server architecture so we can see that there are three ole db
components or in other words they are just client systems or the user systems.
So we have just shown 3 over here but they can actually be n number of systems
accessing the database at the same time so let’s say you’re logged into the
IRCTC website and want to know the number of trains
running from one place to another place so you’ll send a request from this
system to the network server now this network server sends the same request to
the database server and this is finally forwarded to the database and then the
final result is sent back to the user system so similarly if there are three
users sending the same request the database server will process all the
three requests simultaneously and send back the result to all the three systems.
So that was about the types of database architecture. Now let’s finally
understand what exactly is SQL. So SQL basically stands for structured query
language and it is a standard language for accessing and manipulating databases or in simple terms SQL helps you to communicate with the database. Now the
SQL commands can be divided into four categories data query language, data
definition language, data manipulation language and data control language. So
the data query language comprise of just one command select though it can be
accompanied with many clauses to compose queries against a database and DDL is that power of SQL that allows a user to create and restructure database objects.
So you can see commands like create table, alter table and drop table in
DDL. Now for that we have data manipulation language. It is used to
manipulate the data within tables so the three basic DML commands are insert,
update and delete and finally we have data control commands which allow us to
control access to data within the database. So these DCL commands are normally used to create objects related to user access
and also control the distribution of privileges among users and you can see
commands like grant and revoke in TCL So this brings us to the end of the session. Thank you very much for attending.

Danny Hutson

1 thought on “Introduction to Database | Types of Database Architecture | Introduction to SQL | Intellipaat

  1. Got a question on MS SQL basics? Do write it in the comment and you will get a response immediately by our expert. For MS SQL Server training & certification, call us at US: 1800-216-8930 (Toll Free) or India: +917022374614. You can also write us at [email protected]

Leave a Reply

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