Pages

Sunday, 4 March 2012

SQL Commands:


http://study-material-database-programming.blogspot.in/







SQL commands are instructions used to communicate with the database to perform specific task that work with data. SQL commands can be used not only for searching the database but also to perform various other functions like, for example, you can create tables, add data to tables, or modify data, drop the table, set permissions for users. SQL commands are grouped into four major categories depending on their functionality:



Data Definition Language (DDL) - These SQL commands are used for creating, modifying, and dropping the structure of database objects. The commands are CREATE, ALTER, DROP, RENAME, and TRUNCATE.
Data Manipulation Language (DML) - These SQL commands are used for storing, retrieving, modifying, and deleting data. These commands are SELECT, INSERT, UPDATE, and DELETE.



Transaction Control Language (TCL) - These SQL commands are used for managing changes affecting the data. These commands are COMMIT, ROLLBACK, and SAVEPOINT.
Data Control Language (DCL) - These SQL commands are used for providing security to database objects. These commands are GRANT and REVOKE.



Regards,

Ruchika Mandore  [ MCA ] 
Software Engineer
AeroSoft Corp

On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com


On Line Assistence  :
Gtalk                    :   ruchika.aerosoft@gmail.com
Y! Messenger             :   ruchika.aerosoft@yahoo.com
Rediff Bol               :   ruchika.aerosoft@rediffmail.com
MSN                      :   ruchika.aerosoft@hotmail.com

learn online marketing, at http://internationalschoolofinternetmarketing.com Also learn online advertising, learn email marketing, learn search engine marketing, learn affiliatemarketing, learn seo,
 s:  | 

SEARCH JOBS MAKE FRIENDS, HAVE FUN


http://aerosoftseo.com/SEOjobs/ SEO Jobs & Careers - Search Engine Marketing Job Site Jobs In Search advertise Search Engine related Job and Career Vacancies o
 1 attachment: 

32 comments:

  1. You always provide quality based posts, enjoy reading your work. replica watches india

    ReplyDelete
  2. All of your posts are well written. Thank you. post free ads

    ReplyDelete
  3. Wanted to take this opportunity to let you know that I read your blog posts on a regular basis. Your writing style is impressive, keep it up! replica watches india

    ReplyDelete
  4. Thanks for sharing content and such nice information for me. I hope you will share some more content about. sql commands Please keep sharing!

    Best Uttarakhand Resort Ramnagar

    ReplyDelete
  5. This post is so useful and relevant. Surely it will help others a lot. Thanks for this post. Keep blogging. you can make plan withCanada job consultancy in chennai
    Education consultants in chennai
    Holy land tour packages from Chennai

    ReplyDelete
  6. Thankyou for this blog its really interesting and informative, but there is some errors
    Which need to be recorrect by owner. See i also have some good blogs related to
    Technical services, you can check on my website.

    Avast Login
    garmin.com/express
    avg.com/retail
    bullguard support number

    ReplyDelete
  7. great post i'm very impressed by this blog thanks for sharing useful information with us. I'm TravBond Reviews and we are providing honeymoon, holiday tour packages for our client for more information visit our website.
    https://www.travbond.in/

    ReplyDelete
  8. Hi guys firstly I would like to appriciatres you for sharing a such good information and really your contects are excellent and if anyone is looking out for best hotels in manali online then kindly make a visit at manali.

    ReplyDelete
  9. Thanks for providing this informative blog. Read More

    ReplyDelete

  10. Thanks for sharing this article its amazing and i got more knowladge from this article,
    please keep sharing that we could read and get knowladge.

    MagicalIndiaHolidays are offering many offers for Himahcal Tours for more info. please visit our official website
    Best Holiday packages in India, Best holiday packages for family
    Shimla Volvo Tour from Delhi
    Dharamshala & Dalhousie Volvo Package from DelhiManali Mcleodganj Tour Package from Delhi





    ReplyDelete
  11. It is really helpful for readers who are looking for online assignment help.

    foodblog

    ReplyDelete
  12. Wow!!! Really liked the way you wrote the whole post. I'm glad to be here. Keep travelling. I am thinking to visit Bhutan in near future.

    www.99CarRentals.com

    ReplyDelete
  13. Such a great post, thanks for posting this kind of useful information.
    Visit Best Astrologer in RR Nagar

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. That,s very good article, I only belive in programming becouse it gives me real and good help in my blogging career…
    love problem solution in ahmedabad thanks

    ReplyDelete
  16. Thanks for sharing this informative blog..Keep posting.
    For all kind of astrological services contact Best Astrologer in Red Deer.

    ReplyDelete
  17. Your blog is very informative for us.
    Vashikaran Astrologer in KR Puram provides best results with 99% unique solutions.

    ReplyDelete
  18. Thanks for providing this information. It's very helpful.
    For Upvc Windows in Hassan. Contact us.

    ReplyDelete
  19. Good Article ! it's really nice and helpful, thanks for sharing information.
    For best astrology services contact us Vashikaran Astrologer in Bellary

    ReplyDelete
  20. Its very interesting while reading it, thank you for posting such a good article.
    Best Astrologer in Canacona resolves all problems and gives permanent solutions.

    ReplyDelete
  21. Nice Post. Thank you for sharing this Information.
    Visit snacks manufacturing companies in india.

    ReplyDelete
  22. Thanks For Sharing this great post.
    Best Palmist In Bangalore resolves all problems and gives permanent solutions.

    ReplyDelete
  23. Website Designing Company in Janakpuri Website Designing Company in Janakpuri is the best company contact now if you want to create website.

    ReplyDelete