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  

69 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

Anonymous 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

Anonymous 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

Anonymous 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

Jeffy said...

seo company in chennai
seo company in india
Digital Marketing Coimpany in Chennai
Digital Marketing Company in Chennai

Shalini said...


Very nice info..!!
seo company in india
digital marketing company in india
seo company in chennai
digital marketing company in chennai

Padhma said...

It's interesting that many of the bloggers your tips helped to clarify a few things for me as well as giving.. very specific nice content. And tell people specific ways to live their lives.Sometimes you just have to yell at people and give them a good shake to get your point across.

Home Spa Services in Mumbai

dhivya priya said...

Finding the time and actual effort to create a superb article like this is great thing. I’ll learn many new stuff right here! Good luck for the next post buddy..
Isoft Innovation
Isoft Innovations Facebook

Evangeline Mitul said...

Excellent and very cool idea and the subject at the top of magnificence and I am happy to this post..Interesting post! Thanks for writing it. What's wrong with this kind of post exactly? It follows your previous guideline for post length as well as clarity..

Best Laser Clinic In Chennai

Best Implant Clinic In Chennai

sathya said...

Here i had read the content you had posted. It is much interesting so please keep update like this. Infact it will be useful for the beginners to develop their knowledge along with . I am expecting much more posts from you

MSBI Training in Chennai

Informatica Training in Chennai

Dataware Housing Training in Chennai

tessa tessa said...

Really nice information here about by choosing with the headlines. We want to make the readers whether it is relevant for their searches or not. They will decide by looking at the headline itself. I agree with your points but i can't understand what's logic behind by including with the number? Why most of the marketers will suggest that one? Is there any important factor within that please convey me.....

SEO Company in India

Karthika Shree said...

Excellent and very cool idea and the subject at the top of magnificence and I am happy to this post..Interesting post! Thanks for writing it.What's wrong with this kind of post exactly? It follows your previous guideline for post length as well as clarity.
Java Training in Chennai

sandhosh said...

Really Good article.provide a helpful information about Database Concepts.keep updating...

E-mail marketing company in india

Karthi Keyan said...

Interesting blog post.This blog shows that you have a great future as a content writer.waiting for more updates...

Digital Marketing Company in India

Digital Marketing Services in India

Digital Marketing Agency in India

Digital Marketing Companies in India

thavapra said...
This comment has been removed by the author.
thavapra said...

Thank you dude, this basics is good enough to clear my technical aptitude tomorrow.. It help to get the overall theories into my mind ...keep blogging.

SEO Company in Chennai

Ancy merina said...

The blog is very interesting and will be much useful for use. Thanks for sharing with your blog. Please keep on updating.
ECommerce Web Development Company in bangalore
Outsource magento ecommerce services india

Anonymous said...

Weblogic Administration Training
Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ...

Kalai chellam said...

Thanks for the informative article. This is one of the best resources I have found in quite some time. Nicely written and great info. I really cannot thank you enough for sharing.

Restaurant in OMR
Apartments in OMR
Villas in OMR
Resorts in OMR

Peter Johnson said...

Awe! What An Blog Very Helpful and interesting Really A great center for acquiring knowledge.Very Helpful Post And Explained Very Clearly About All the things.Very Helpful. Coming To Our Self We Provide Restaurant Equipment Parts .Really Thankfull For the blogger providing such a great information.Thank you. Have a Nice Day.

seo said...

Really It's A Great Pleasure reading your Article,learned a lot of new things,we have to keep on updating it,Primary Care in Chicago.By getting them into one place.Really thanks for posting.Very Thankful for the Informative Post.Really Thanks For Posting.

Lathika Honey said...

Thank you for sharing beneficial information nice post Bala Guntipalli

ViralHarry said...

Get database language complete information from here Database Language

Unknown said...

Very Impressive SQL Tutorial. The content seems to be pretty exhaustive and excellent and will definitely help in learning SQL Tutorial. I'm also a learner taken up SQL Tutorial and I think your content has cleared some concepts of mine. While browsing for SQL Tutorial on YouTube i found this fantastic video on SQL Tutorial. Do check it out if you are interested to know more.:-https://www.youtube.com/watch?v=2OZQXAsCBvk

24Layouts said...

Thanks For Sharing From 24Layouts

john jersy said...

I am really very happy to find this particular site. I just wanted to say thank you for this huge read!! I absolutely enjoying every petite bit of it and I have you bookmarked to test out new substance you post.
Click here:
Microsoft azure training in bangalore
Click here:
Microsoft azure training in pune

sai said...

Awesome! Education is the extreme motivation that open the new doors of data and material. So we always need to study around the things and the new part of educations with that we are not mindful.
Click here:
Microsoft azure training in chennai
Click here:
Microsoft azure training in annanagar
Click here:
Microsoft azure training in velarchery

pooja saravanan said...

This blog is the general information for the feature. You got a good work for these blog.We have a developing our creative content of this mind.Thank you for this blog. This for very interesting and useful.
Blueprism training in Chennai

Blueprism training in Bangalore

Blueprism training in Pune

Blueprism online training

Blueprism training in tambaram

johnsy sai said...

Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging.
Devops training in tambaram
Devops training in velachery
Devops training in annanagar
Devops training in sholinganallur

Lohita Riya said...

Your site is amazing and your blogs are informative and knowledgeable to my websites.This is one of the best tips in my life.I have in quite some time.Nicely written and great info.Thanks to share the more information's.

Seo Experts
Seo Company
Web Designing Company
Digital Marketing
Web Development Company
App Development