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 specialized 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: - Relational Algebra.
2. Non Procedural DML - It describes what data is needed without specifying how to get it. For example: - Relational calculus.
61 comments:
Best material for short study.
please add dbms disadvantages also
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
seo company in chennai
seo company in india
Digital Marketing Coimpany in Chennai
Digital Marketing Company in Chennai
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
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
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
Really Good article.provide a helpful information about Database Concepts.keep updating...
E-mail marketing company in india
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
Weblogic Administration Training
Wow! That's really great information guys.I know lot of new things here. Really great contribution.Thank you ...
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.
Get database language complete information from here Database Language
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
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
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
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
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
Well somehow I got to read lots of articles on your blog. It’s amazing how interesting it is for me to visit you very often.
java training in annanagar | java training in chennai
java training in chennai | java training in electronic city
All the points you described so beautiful. Every time i read your i blog and i am so surprised that how you can write so well.
Data Science course in rajaji nagar | Data Science with Python course in chenni
Data Science course in electronic city | Data Science course in USA
Data science course in pune | Data science course in kalyan nagar
Very informative!! Thanks for sharing with us.
JAVA Training in Chennai
JAVA Course in Chennai
Java training institute in chennai
Best JAVA Training institute in Chennai
Java Training
This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog and useful information. keep doing more.
IELTS Coaching Center in JP Nagar
IELTS Course in JP Nagar
IELTS Training in JP Nagar Bangalore
English Speaking Course in Bangalore JP Nagar
Spoken English in JP Nagar
English Speaking Classes near me
Spoken English Classes in JP Nagar Bangalore
This is my first visit to your blog, keep writing more content.
SEO Training in Chennai
JAVA Training in Chennai
Big Data Training in Chennai
Selenium Training in Chennai
German Classes in chennai
DOT NET Training in Chennai
core Java training in chennai
java training in Porur
very informative
Apponix Technologies
https://www.apponix.com
It is better to engaged ourselves in activities we like. I liked the post. Thanks for sharing.
Microsoft Azure online training
Selenium online training
Java online training
Python online training
uipath online training
This is Very Useful blog, Thank you to Share this.
Data Science Training in Chennai
DevOps Training in Chennai
Hadoop Big Data Training
best java training in chennai
best python training in chennai
best python training institute in omr
python training in omr
selenium training in chennai
selenium training in omr
selenium training in sholinganallur
java training in omr
Good Post..
final year project proposal for information technology
free internship for bca
web designing training in chennai
internship in coimbatore for ece
machine learning internship in chennai
6 months training with stipend in chennai
final year project for it
inplant training in chennai for ece students
industrial training report for electronics and communication
inplant training certificate
It's awesome blog! thanks for this wonderful information with us..really nice to see tis page.
Ai & Artificial Intelligence Course in Chennai
PHP Training in Chennai
Ethical Hacking Course in Chennai Blue Prism Training in Chennai
UiPath Training in Chennai
Thank you for the informative post. It was thoroughly helpful to me. Keep posting more such articles and enlighten us.
Big Data Hadoop Training In Chennai | Big Data Hadoop Training In anna nagar | Big Data Hadoop Training In omr | Big Data Hadoop Training In porur | Big Data Hadoop Training In tambaram | Big Data Hadoop Training In velachery
The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. The angular js programming language is very popular which are most widely used.
Dot Net Training in Chennai | Dot Net Training in anna nagar | Dot Net Training in omr | Dot Net Training in porur | Dot Net Training in tambaram | Dot Net Training in velachery
This article is very nice. I read in your blog.
Python Training in Chennai | Certification | Online Training Course | Python Training in Bangalore | Certification | Online Training Course | Python Training in Hyderabad | Certification | Online Training Course | Python Training in Coimbatore | Certification | Online Training Course | Python Training in Online | Python Certification Training Course
Really very nice article,keep sharing more articles with us.
Thank you..
hadoop admin online training
big data hadoop course
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.
python Training in chennai
python Course in chennai
The blog was absolutely fantastic! Lot of great information which can be helpful in some or the other way. Keep updating the blog, looking forward for more contents.
Top IAS Coaching in Mumbai
Best IAS Coaching in Mumbai
Hello , Nice Article.
Best Facility Management Services in Hyderabad - Amaze PMS
Property Management Services in Hyderabad | Amaze PMS
Best Housekeeping Services in Chennai | Amaze PMS
Best MEP (O & M) Services in Bangalore | Amaze PMS
FM Services for Gated Residential Properties in Hyderabad | Amaze PMS
Post a Comment