Database Languages

Thursday, August 14, 2008 by Ankit Goyal

Database Languages

A DBMS is a software package that carries out many different tasks including the provision of facilities to enable the user to access and modify information in the database. The database is an intermediate link between the physical database, computer and the operating system and the users. To provide the various facilities to different types of users, a DBMS normally provides one or more spe­cialized programming languages called database languages.

Database languages come in different forms. They are: -

1. Data Description Language (DDL)

2. Data Manipulation Language (DML)

Data Description Language (DDL)

As the name suggests, this language is used to define the various types of data in the database and their relationship with each other.

The basic functions performed by DDL are: -

• Create tables, files, databases and data dictionaries.

• Specify the storage structure of each table on disk.

• Integrity constraints on various tables.

• Security and authorization information of each table.

• Specify the structure of each table.

• Overall design of the Database.

Data Manipulation Language (DML)

A language that enables users to access or manipulate data (retrieve, insert, update, delete) as organized by a certain Data Model is called the Data Manipulation Language (DML). It can be of two types: -

1. Procedural DML - It describes what data is needed and how to get it. For example: - Rela­tional Algebra.

2. Non Procedural DML - It describes what data is needed without specifying how to get it. For example: - Relational calculus.

Filed under , having  

43 comments:

Pradeep said...

Best material for short study.

siree said...

please add dbms disadvantages also

Training Coimbatore said...

great post

Thanks for the wonderful share.Very Nice article.
Oracle Training in Coimbatore | Hadoop Training in Coimbatore |
Java Training in Coimbatore | Dot Net Training in Coimbatore
Web Designing Training in Coimbatore | Informatica Training in Coimbatore

Sathya G said...



the blog is very interesting and will be much useful for us. thank you for sharing the blog with us. please keep on updating.
Informatica Training in Chennai Adyar

Aashi siva said...

It's like you read my mind! You seem to know a lot about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a little bit, but instead of that, this is fantastic blog. A great read. I will definitely be back.

Online Training in Chennai

Aashi siva said...

I do believe all of the concepts you’ve introduced in your post. They’re very convincing and will definitely work. Nonetheless, the posts are too short for novices. May you please extend them a bit from subsequent time? Thank you for the post.

Online Training in Chennai

Giri Mani 2 said...

Great... Excellent sharing.. This is very helpful for beginers. Read that provide me more enthusiastic. This helps me get a more knowledge about this topic. Thanks for this.
Email Marketing Chennai Adyar

Shalini said...

Nice to see your blog post.. I really enjoyed by reading your blog post. Thanks a lot for sharing this with us.. Keep on sharing like this informative post.

SMO Services Chennai


Shalini said...

You have provide great deal. Your writing style of this post was great to view in particular section. Thanks for sharing your exclusive article.

Regards,
Email Marketing Chennai

Abiya Carol said...

It's interesting that many of the bloggers to helped clarify a few things for me as well as giving.Most of ideas can be nice content.The people to give them a good shake to get your point and across the command .

Branding Services in Chennai

Sathya G said...


this is really a very great blog. the information present in this blog will be very useful for us. thank you for sharing with us.
SEO Company In Chennai

Sathya G said...

the blog is very interesting and will be much useful for us. thank you for sharing the blog with us. please keep on updating.
Software Testing Training

Sathya G said...


the blog is very interesting and will be much useful for us. thank you for sharing the blog with us. please keep on updating
Software Testing Training in Chennai

Keerthi said...

It’s really amazing that we can record what our visitors do on our site. Thanks for sharing this awesome guide. I’m happy that I came across with your site this article is on point,thanks again and have a great day. Keep update more information..

Online Training in Chennai

Keerthi said...

A nice article here, i think that people who have grown up with the idea of using computers are showing more responsibility towards writing posts that are thoughtful, do not have grammar mistakes and pertinent to the post..

Online Training in Chennai

Giri Mani 2 said...

Great... Excellent sharing.. This is very helpful for beginers. Read that provide me more enthusiastic. This helps me get a more knowledge about this topic. Thanks for this.
Salesforce Training in Chennai

Giri Mani said...

This blog giving the details of technology. This gives the details about working with the business processes and change the way. Here explains think different and work different then provide the better output. Thanks for this blog.
Salesforce Training in Chennai

Geethapriya said...

Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners
Dotnet Training in Chennai

Geethapriya said...

Great information shared in this blog. Helps in gaining concepts about new information and concepts.Awsome information provided.Very useful for the beginners.
Dotnet Training in Chennai

Rekhila said...

This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
Digital Marketing company in Chennai

Maani kamili said...


I do trust all of the concepts you’ve presented on your post. They’re really convincing and will definitely work. Still, the posts are too brief for newbies. May you please extend them a little from subsequent time?Also, I’ve shared your website in my social networks.
Digital marketing course

Maani kamili said...


Someone essentially lend a hand to make severely posts I would state. That is the very first time I frequented your website page and thus far? I surprised with the analysis you made to create this particular submit incredible. Fantastic job!
Digital marketing course in Chennai

Rekhila said...

There are lots of information about latest technology and how to get trained in them, like this have spread around the web, but this is a unique one according to me. The strategy you have updated here will make me to get trained in future technologies. By the way you are running a great blog. Thanks for sharing this.
Hadoop training in Chennai

Rekhila said...

Great blog..You have clearly explained about the concept..Step by step explanation is too good to understand..Its very useful for me to understand..Keep on sharing..
Best Hadoop training institute in Chennai

Rekhila said...

Awesome..You have clearly explained ...Its very useful for me to know about new things..Keep on blogging..
Hadoop training

rek Pk said...

Your content is awesome . You have done a great job and its very useful for me . I appreciate your effort and I hope that you will get more positive comments from the web users.
Best SEO training in Chennai

Rekhila said...

This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.
Digital marketing company in Chennai
Digital marketing services in Chennai

arulnath d said...

I’m sincerely suggesting your blog to all my friends… I’ve changed myself in many thing after reading your blog… Thanks and keep going.

SEO Training in Chennai

rek Pk said...

Your content is awesome . You have done a great job and its very useful for me . I appreciate your effort and I hope that you will get more positive comments from the web users.
Best SEO training institue in Chennai

Maha Ravi said...

this is really too useful and have more ideas from yours. keep sharing many techniques. eagerly waiting for your new blog and useful information. keep doing more.
Sharepoint Training in Chennai

Maha Ravi said...


I will bookmark your blog and take the feeds additionally? I’m satisfied to find so many helpful information here within the put up, we want work out extra strategies in this regard, thanks for sharing.
Sharepoint Training in Chennai

Girija Manikandan said...

This blog having the details of Processes running. The way of runing is explained clearly. The content quality is really great. The full document is entirely amazing. Thank you very much for this blog.
Web Designing Training in Chennai

karthireva said...


wow great,nowadays this type of blog id more important and informative technology,it was more impressive to read ,which helps to design more in effective ways

Dot Net training

Karthi Swetha said...

The given information was very excellent & Great tips, and awesome way to get exert tips from everyone,not only i like that post all peoples like that post,because of all given information was wonderful and it's very helpful for me.


Best Dot Net Training Institutes in Chennai

kalai said...



These information really worth saying, i think you are master of the content and thank you so much sharing that valuable information.

Dot Net training in chennai

Akshayhaasini said...


wow great,nowadays this type of blog id more important and informative technology,it was more impressive to read ,which helps to design more in effective ways


Java training in chennai

Geetha said...

very useful information provided in this blog. concepts were explained in a detailed manner. Keep giving these types of informations
SEO training in Chennai

Geetha said...

very useful information provided in this blog. concepts were explained in a detailed manner. Keep giving these types of informations
SEO training in Chennai

Suseela Susiee said...


All are saying the same thing repeatedly, but in your blog I had a chance to get some useful and unique information, I love your writing style very much, I would like to suggest your blog in my dude circle, so keep on updates.



Manual testing training in Chennai

Selenium training in Chennai

Software testing training in Chennai

Swethapriya said...


Thank you for taking the time to provide us excellent & valuable information. We strive to provide our candidates with excellent care.


Car Spa at Doorstep in Mumbai


Shalini said...


Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India

Jeffy said...

Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information. I would like to suggest your blog in my dude circle. please keep on updates. hope it might be much useful for us. keep on updating...
seo company in chennai
Digital Marketing company in chennai

Shalini said...

Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
Digital Marketing Company in India