Aprendiendo SQL mediante a las principales clasificaciones de las sentencias

Existen diferentes clasificaciones para ordenar las sentencias de SQL, en este artículo, hablaremos sobre las diferentes categorías. Los tipos de sentencias de SQL, se pueden clasificar de varias maneras y en multitud de formas. Aunque las dos clasificaciones más populares son:

  • SQL Commands.
  • CRUD.

SQL Commands

Subdivide las sentencias de SQL en función del uso que se le va a dar. Las diferentes categorías son:

  • DDL (Data Definion Language).
  • DML (Data Manipulation Language).
  • DLC (Data Control Language).
  • TLC (Transaction Control Language).

En la siguiente lista, podemos ver la clasificación de algunas de las sentencias de cada una de las categorías.

CRUD:

Son las sentencias más populares de SQL y aunque no engloba a todas, si a las más usadas. Se suelen utiliza mucho por ejemplo, para todo lo referente a formularios.

Y las sentencias significan:

  • Create (Crear -> Insert).
  • Read (Leer/Consultar -> Select).
  • Update (Actualizar -> Update).
  • Delete (Eliminar -> Delete).

Utilidad de las clasificaciones Sql Commands y CRUD

Ambas clasificaciones nos permiten tener una referencias sobre cuales son los comandos más usados de SQL, y nos permite tener una guia para poder trabajar con ellos. Podemos coger un grupo por ejemplo DDL y trabajar con ellos. Una vez conozcamos las sentencias que pertenecen a DDL: Create, Alter, Drop, Truncate y Rename, podemos empezar a realizar DML realizando querys… Y así con el resto.

83 comentarios

  1. This is a very good tip especially to those fresh to the blogosphere.
    Short but very precise info… Thank you for sharing this one.

    A must read post!

  2. I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored material stylish.
    nonetheless, you command get bought an impatience over that
    you wish be delivering the following. unwell unquestionably come further formerly again since exactly the same nearly very often inside case you shield this hike.

  3. Wow that was unusual. I just wrote an very long comment but after I clicked
    submit my comment didn’t appear. Grrrr…
    well I’m not writing all that over again. Anyhow, just wanted to say
    great blog!

  4. certainly like your web-site but you need to check the spelling on several of your posts.

    A number of them are rife with spelling problems and I find it
    very bothersome to tell the truth then again I’ll surely
    come back again.

  5. Good day! This is my first comment here so I just wanted to give a quick shout
    out and say I genuinely enjoy reading your blog posts.
    Can you recommend any other blogs/websites/forums that
    cover the same subjects? Thanks!

  6. I may need your help. I tried many ways but couldn’t solve it, but after reading your article, I think you have a way to help me. I’m looking forward for your reply. Thanks.

  7. Your style is very unique in comparison to other folks I’ve read stuff from.
    Thanks for posting when you have the opportunity, Guess I’ll just bookmark this site.

  8. At the San Digo district, just 50% of instruction is taught by complete-time faculty.

    My page – 비제이 알바

  9. Fascinating blog! Is your theme custom made or did you download it from somewhere?
    A theme like yours with a few simple tweeks would really make my blog jump out.
    Please let me know where you got your design. With thanks

  10. I am curious to find out what blog system you are
    working with? I’m experiencing some minor security problems
    with my latest site and I’d like to find something more
    secure. Do you have any solutions?

  11. On top rated of that, it has a VIP Loyalty Points
    program through which you can get discounts on future purchases.

    Also visit my web site 동행스피드키노

  12. There is no such thing as an immediate private loan—all individual loans take some time to
    procedure.

    Check out my web page: webpage

  13. With ann economy and society dominated by corporate conglomerates recognized as chaebol,
    South Korean peokple today face increasingly bleak prospects.

    my website – homepage

  14. This post is actually a pleasant one it helps new the web users, who are wishing in favor of blogging.

  15. Plus, they coe with payment protections and forgiveness benefits tat private lenders ddo not give.

    Also visit my blog … 신불자대출

  16. There’s been a lot of talk about Wonder Bread bags given that Joni
    Ernst’s State of the Union response.

    Also visit my webpage 셔츠룸 알바

  17. HKUST mixes softt and really hard skills within itss core courses and electives.

    My web site; 밤알바

  18. I do not know if it’s just me or if everyone else experiencing issues with your blog.
    It appears like some of the written text within your posts are running off the
    screen. Can someone else please comment and let me know if this is happening to them as well?
    This might be a problem with my internet browser because I’ve had this
    happen previously. Appreciate it

  19. OMG! This is amazing. Ireally appreciate it~ May I give out my secrets to a secret only I KNOW and if you want
    to have a checkout You really have to believe mme and have faith and
    I will show how to get connected to girls for free Once again I
    want to show my appreciation and may all the blessing goes to you now!.

  20. When it comes to gambling online, from time to time the rules aand legality of it all can be confusing.

    Also visit my web page :: site

  21. And in common, we ssume that material rewrds aare a fairly
    poor purpose for operating.

    Here is my blog – 란제리알바

  22. Not only do millennials want to select what they do with their time, they
    want the capacity to leave function at perform.

    Here is my homepage; 유흥업소알바

  23. This university gives opportunities to study abroad and prioritizes thee career improvement
    of MBA students.

    Also visit my blog post; 룸싸롱 알바

  24. Ahaa, its good conversation about this piece of writing here
    at this website, I have read all that, so now me also
    commenting at this place.

  25. Now, 56 percent of Americfan girls are functioning for pay,
    the lowest level given that 1986.

    my web-site … 이지알바

  26. So BadCreditLoans’ on the web kid is encrypted and consistently mlnitored
    for any breaches.

    Also visit my blog – 대환대출

  27. RadCred’s application and approval methodology are utterlly simple.

    My blog … 소액대출나라

  28. Every single year, Buckaroo is audited for the purpose of monitorong
    compliance with these standards.

    my web-site – 유콘파워볼

  29. This text is worth everyone’s attention. Where can I find
    out more?

  30. Out of the gate, there have been seven operators, such as some of the industry’s
    most significant giants, like BetMGM, DraftKings, and FanDuel.

    my page :: https://cursos.wonderwomanguatemala.gt/

  31. Pretty nice post. I simply stumbled upon your blog and wanted to mention that I’ve truly enjoyed browsing your weblog posts.
    After all I’ll be subscribing for your rss feed and I hope you write once more soon!

  32. Whats up this is kind of of off topic but I was wanting to know if blogs use WYSIWYG editors or if you have to manually code with HTML. I’m starting a blog soon but have no coding know-how so I wanted to get advice from someone with experience. Any help would be enormously appreciated!

  33. I have observed that intelligent real estate agents almost everywhere are Advertising and marketing. They are knowing that it’s not just placing a sign post in the front area. It’s really concerning building human relationships with these sellers who at some point will become customers. So, after you give your time and efforts to encouraging these vendors go it alone : the «Law of Reciprocity» kicks in. Good blog post.

  34. The subsequent time I learn a blog, I hope that it doesnt disappoint me as a lot as this one. I imply, I do know it was my option to read, but I actually thought youd have one thing interesting to say. All I hear is a bunch of whining about one thing that you possibly can repair in case you werent too busy looking for attention.

  35. Hey there just wanted to give you a quick heads up. The words in your article seem to be running off the screen in Safari. I’m not sure if this is a formatting issue or something to do with web browser compatibility but I figured I’d post to let you know. The design and style look great though! Hope you get the problem resolved soon. Kudos

  36. Excellent website. Plenty of useful info here. I am sending it to several friends ans also sharing in delicious. And naturally, thanks on your sweat!

  37. Thanks for the new stuff you have exposed in your blog post. One thing I’d really like to reply to is that FSBO interactions are built after a while. By introducing yourself to owners the first end of the week their FSBO is definitely announced, prior to the masses commence calling on Monday, you develop a good interconnection. By sending them instruments, educational materials, free reviews, and forms, you become an ally. By subtracting a personal fascination with them and also their problem, you produce a solid connection that, on many occasions, pays off if the owners decide to go with an adviser they know plus trust – preferably you.

  38. Thank you for every other wonderful article. The place else may just anybody get that type of information in such an ideal manner of writing? I have a presentation next week, and I am at the search for such info.

  39. Thanks for the strategies you have discussed here. Also, I believe there are many factors that will keep your car insurance premium decrease. One is, to contemplate buying automobiles that are inside good list of car insurance corporations. Cars that are expensive are usually more at risk of being snatched. Aside from that insurance coverage is also depending on the value of your vehicle, so the more costly it is, then higher your premium you have to pay.

  40. Caroline UdGNcuinhofeSN 5 20 2022 generic version of viagra Effects of thiamine on cardiac function in patients with systolic heart failure systematic review and metaanalysis of randomized, double blind, placebo controlled trials

  41. Hey there! I know this is kind of off topic but I was wondering which blog platform are you using for this site? I’m getting sick and tired of WordPress because I’ve had problems with hackers and I’m looking at alternatives for another platform. I would be awesome if you could point me in the direction of a good platform.

  42. Thanks for your article. It is very unfortunate that over the last decade, the travel industry has had to fight terrorism, SARS, tsunamis, bird flu virus, swine flu, along with the first ever real global recession. Through all this the industry has proven to be solid, resilient and also dynamic, discovering new approaches to deal with hardship. There are constantly fresh complications and opportunities to which the marketplace must once again adapt and behave.

  43. Thanks for the interesting things you have unveiled in your short article. One thing I’d really like to discuss is that FSBO human relationships are built over time. By bringing out yourself to the owners the first saturday and sunday their FSBO is announced, ahead of masses get started calling on Monday, you develop a good connection. By sending them tools, educational supplies, free reports, and forms, you become an ally. If you take a personal affinity for them and also their circumstance, you produce a solid network that, many times, pays off if the owners opt with an agent they know along with trust — preferably you.

  44. hey there and thanks in your information ? I have certainly picked up something new from proper here. I did then again expertise a few technical issues using this site, since I experienced to reload the site many times prior to I could get it to load properly. I have been considering in case your hosting is OK? Now not that I’m complaining, however sluggish loading cases instances will sometimes affect your placement in google and can injury your high quality ranking if ads and ***********|advertising|advertising|advertising and *********** with Adwords. Well I am adding this RSS to my email and can look out for a lot extra of your respective fascinating content. Ensure that you replace this again very soon..

  45. I believe that avoiding ready-made foods would be the first step to be able to lose weight. They will taste excellent, but refined foods have got very little nutritional value, making you try to eat more only to have enough strength to get through the day. If you’re constantly ingesting these foods, transferring to cereals and other complex carbohydrates will make you to have more energy while consuming less. Good blog post.

  46. Undeniably believe that which you said. Your favorite justification appeared to be on the web the easiest thing to be aware of. I say to you, I definitely get annoyed while people consider worries that they plainly don’t know about. You managed to hit the nail upon the top as well as defined out the whole thing without having side-effects , people can take a signal. Will probably be back to get more. Thanks

  47. I have observed that costs for internet degree authorities tend to be a terrific value. For example a full Bachelors Degree in Communication with the University of Phoenix Online consists of Sixty credits with $515/credit or $30,900. Also American Intercontinental University Online offers a Bachelors of Business Administration with a full course element of 180 units and a tuition fee of $30,560. Online studying has made having your diploma much simpler because you might earn your degree through the comfort of your dwelling place and when you finish working. Thanks for all tips I have learned through the website.

  48. I haven?t checked in here for a while since I thought it was getting boring, but the last several posts are good quality so I guess I?ll add you back to my everyday bloglist. You deserve it my friend 🙂

  49. Hi there, I found your web site by the use of Google at the same time as looking for a related matter, your web site got here up, it seems to be great. I’ve bookmarked it in my google bookmarks.

  50. I?ve read a few good stuff here. Definitely worth bookmarking for revisiting. I wonder how much effort you put to create such a great informative site.

  51. This design is wicked! You definitely know how to keep a reader amused. Between your wit and your videos, I was almost moved to start my own blog (well, almost…HaHa!) Excellent job. I really enjoyed what you had to say, and more than that, how you presented it. Too cool!

  52. There are certainly plenty of details like that to take into consideration. That is a great level to convey up. I supply the thoughts above as normal inspiration but clearly there are questions like the one you bring up the place the most important factor will probably be working in sincere good faith. I don?t know if greatest practices have emerged around things like that, but I’m positive that your job is clearly recognized as a fair game. Each girls and boys feel the influence of just a moment?s pleasure, for the rest of their lives.

  53. The information shared is of top quality which has to get appreciated at all levels. Well done…

  54. Unquestionably imagine that which you said. Your favourite reason appeared to be on the internet the easiest factor to keep in mind of. I say to you, I definitely get irked at the same time as other people consider issues that they just don’t realize about. You managed to hit the nail upon the highest as neatly as outlined out the whole thing with no need side-effects , people could take a signal. Will probably be back to get more. Thanks

  55. I truly appreciate this post. I have been looking all over for this! Thank goodness I found it on Bing. You’ve made my day! Thx again

  56. I’ve observed that in the world these days, video games would be the latest popularity with children of all ages. Many times it may be unattainable to drag your children away from the video games. If you want the very best of both worlds, there are many educational games for kids. Thanks for your post.

  57. Thank you, I have recently been seeking for info about this subject for ages and yours is the best I’ve located so far.

  58. Thanks for your post right here. One thing I’d like to say is the fact most professional fields consider the Bachelor Degree as the entry level standard for an online college diploma. Though Associate Degrees are a great way to begin, completing a person’s Bachelors starts up many entrances to various careers, there are numerous on-line Bachelor Course Programs available coming from institutions like The University of Phoenix, Intercontinental University Online and Kaplan. Another issue is that many brick and mortar institutions offer Online variations of their college diplomas but usually for a considerably higher price than the corporations that specialize in online education plans.

  59. Thanks for your useful article. One other problem is that mesothelioma cancer is generally due to the breathing of fibers from asbestos, which is a dangerous material. It can be commonly viewed among workers in the construction industry who may have long experience of asbestos. It’s also caused by living in asbestos covered buildings for some time of time, Your age plays an important role, and some folks are more vulnerable to the risk than others.

  60. I additionally believe that mesothelioma cancer is a exceptional form of many forms of cancer that is typically found in all those previously familiar with asbestos. Cancerous tissues form inside the mesothelium, which is a protective lining which covers the vast majority of body’s internal organs. These cells typically form within the lining in the lungs, mid-section, or the sac which actually encircles one’s heart. Thanks for revealing your ideas.

  61. Superb site you have here but I was wondering if you knew of any forums that cover the same topics talked about in this article? I’d really like to be a part of group where I can get opinions from other experienced people that share the same interest. If you have any suggestions, please let me know. Thanks a lot!

  62. I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Great work!

  63. A great post without any doubt.

  64. I?ve been exploring for a little for any high quality articles or weblog posts on this kind of area . Exploring in Yahoo I ultimately stumbled upon this website. Studying this info So i am satisfied to show that I’ve a very excellent uncanny feeling I found out exactly what I needed. I such a lot indisputably will make certain to don?t put out of your mind this site and give it a glance regularly.

  65. Thanks a ton for your post. I would really like to say that the price of car insurance varies greatly from one plan to another, mainly because there are so many different facets which give rise to the overall cost. By way of example, the make and model of the car will have a significant bearing on the fee. A reliable ancient family vehicle will have a more economical premium over a flashy racecar.

  66. Its such as you read my thoughts! You seem to know a lot approximately this, such as you wrote the e-book in it or something. I feel that you just could do with some percent to power the message house a little bit, but instead of that, this is fantastic blog. A great read. I’ll certainly be back.

  67. You can certainly see your expertise in the work you write. The world hopes for even more passionate writers like you who are not afraid to say how they believe. Always follow your heart.

  68. I have learned new things through the blog post. One other thing I have seen is that typically, FSBO sellers will probably reject people. Remember, they would prefer never to use your solutions. But if anyone maintain a reliable, professional partnership, offering aid and remaining in contact for around four to five weeks, you will usually be capable of win a conversation. From there, a listing follows. Thanks a lot

  69. Thanks for your post. What I want to say is that when looking for a good on the net electronics shop, look for a web page with full information on critical indicators such as the level of privacy statement, safety details, payment options, and also other terms plus policies. Continually take time to investigate the help along with FAQ segments to get a far better idea of how a shop operates, what they can perform for you, and how you can maximize the features.

  70. Nice i really enjoyed reading your blogs. Keep on posting. Thanks

  71. Nice i really enjoyed reading your blogs. Keep on posting. Thanks

  72. Thanks for the post. I have continually noticed that many people are desirous to lose weight as they wish to look slim and also attractive. On the other hand, they do not constantly realize that there are many benefits for losing weight as well. Doctors declare that overweight people come across a variety of conditions that can be instantly attributed to their excess weight. The great news is that people that are overweight as well as suffering from various diseases can help to eliminate the severity of the illnesses by losing weight. You possibly can see a constant but notable improvement with health when even a small amount of weight-loss is achieved.

  73. Have you ever considered writing an ebook or guest authoring on other sites? I have a blog centered on the same topics you discuss and would love to have you share some stories/information. I know my subscribers would value your work. If you are even remotely interested, feel free to shoot me an e-mail.

  74. Attractive component to content. I just stumbled upon your blog and in accession capital to say that I acquire actually enjoyed account your blog posts. Any way I?ll be subscribing on your augment and even I achievement you get right of entry to consistently rapidly.

  75. I would also like to add that in case you do not already have got an insurance policy or else you do not belong to any group insurance, you may well gain from seeking the aid of a health insurance professional. Self-employed or those that have medical conditions normally seek the help of one health insurance brokerage service. Thanks for your writing.

  76. Whoa! This blog looks exactly like my old one! It’s on a totally different subject but it has pretty much the same page layout and design. Excellent choice of colors!

  77. I think this is one of the most important info for me. And i am glad reading your article. But wanna remark on some general things, The website style is perfect, the articles is really great : D. Good job, cheers

  78. You can definitely see your enthusiasm within the work you write. The world hopes for more passionate writers like you who aren’t afraid to mention how they believe. All the time go after your heart.

  79. I have been exploring for a little bit for any high-quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this web site. Reading this information So i am happy to convey that I have an incredibly good uncanny feeling I discovered just what I needed. I most certainly will make sure to do not forget this website and give it a glance regularly.

  80. Hi there! I know this is kinda off topic nevertheless I’d figured I’d ask. Would you be interested in trading links or maybe guest writing a blog article or vice-versa? My blog discusses a lot of the same subjects as yours and I think we could greatly benefit from each other. If you’re interested feel free to shoot me an email. I look forward to hearing from you! Great blog by the way!

  81. One thing I’d like to say is car insurance canceling is a hated experience and if you are doing the proper things as a driver you simply won’t get one. Some individuals do have the notice that they have been officially dumped by their particular insurance company and several have to fight to get extra insurance after having a cancellation. Affordable auto insurance rates usually are hard to get after a cancellation. Knowing the main reasons regarding auto insurance termination can help drivers prevent getting rid of in one of the most essential privileges available. Thanks for the suggestions shared through your blog.

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *

La Ley 34/2002 nos obliga a avisarte de que usamos cookies propias y de terceros con objetivos estadísticos y de sesión y para mostrarte la 'publi' que nos da de comer. Tranquilo, este mensaje solo sale una vez. Más información

Java desde 0 comunica a los usuarios, a través de este aviso, que puede utilizar cookies cuando el usuario navega por las diferentes pantallas y páginas del sitio. Durante el uso de nuestra página Web usted acepta y autoriza expresamente el uso de cookies, de acuerdo con nuestra Política de Privacidad. Este sitio web utiliza las siguientes cookies propias: - Cookies de sesión, para garantizar que los usuarios que escriban comentarios en el blog sean humanos y no aplicaciones automatizadas. De esta forma se combate el spam. Este sitio web utiliza las siguientes cookies de terceros: - Google AdManager y AdSense: Utiliza cookies para mejorar la publicidad. Entre otros fines, suelen utilizarse para segmentarla según el contenido que sea relevante para los usuarios o su ubicación, mejorar los informes de rendimiento de las campañas y evitar mostrar anuncios que los usuarios ya hayan visto. Las cookies no contienen información personal identificable. Consulta cómo utiliza Google la información de sitios web o aplicaciones. y cómo bloquear determinados anuncios. - Google Analytics: Almacena cookies para poder elaborar estadísticas sobre el tráfico y volumen de visitas de esta web. Al utilizar este sitio web está consintiendo el tratamiento de información acerca de usted por Google. Por tanto, el ejercicio de cualquier derecho en este sentido deberá hacerlo comunicando directamente con Google. - Redes sociales: Cada red social utiliza sus propias cookies para que usted pueda pinchar en botones del tipo Me gusta o Compartir.

Cerrar