{"id":2323,"date":"2022-10-13T18:54:58","date_gmt":"2022-10-13T18:54:58","guid":{"rendered":"https:\/\/learntube.ai\/blog\/?p=2323"},"modified":"2022-10-13T18:55:01","modified_gmt":"2022-10-13T18:55:01","slug":"what-are-the-most-commonly-used-sql-commands","status":"publish","type":"post","link":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/","title":{"rendered":"What are the Most Commonly Used SQL Commands?"},"content":{"rendered":"\n

The abbreviation SQL<\/a> stands for Structured Query Language. SQL commands tell a database how to perform operations, functions, and queries on data. SQL commands can be used to search the database as well as to create tables, add data to tables, change data, and drop tables. If you’re going to work with SQL, you should know how to use the following fundamental SQL commands. <\/p>\n\n\n\n

SELECT and FROM: <\/strong>A query’s SELECT clause determines which data columns should be displayed in the results. Options can also be used to display data that isn’t contained in a table column.<\/p>\n\n\n\n

CHECK: <\/strong>The CHECK constraint is used to limit the number of possible values for a column.<\/p>\n\n\n\n

When a CHECK constraint is applied to a single column, only certain values are permitted. The CHECK constraint in a table can constrain the values in some columns based on the values in other columns in the row.<\/p>\n\n\n\n

ALTER TABLE:<\/strong> ALTER TABLE changes the structure of a table.<\/p>\n\n\n\n

CREATE TABLE: <\/strong>CREATE TABLE creates a database table precisely what it says on the tin. You can give the table a name and select the columns it should contain.<\/p>\n\n\n\n

WHERE: <\/strong>Use the WHERE clause to limit the number of rows.<\/p>\n\n\n\n

SELECT: <\/strong>SELECT command and the results without a WHERE statement. Then, in a WHERE statement, we’ll use all five qualifiers listed above.<\/p>\n\n\n\n

UPDATE: <\/strong>To update a record in a table, use the UPDATE statement. Use the WHERE condition to specify the records you want to update. At the same time, one or more columns can be updated.<\/p>\n\n\n\n

GROUP BY: <\/strong>GROUP BY allows you to merge rows and aggregate data.<\/p>\n\n\n\n

HAVING: <\/strong>HAVING allows you to filter the data obtained by the GROUP BY clause so that just a subset of the entries is visible to the user.<\/p>\n\n\n\n

AS<\/strong>: you can rename a column or table by using an alias.<\/p>\n\n\n\n

ORDER BY:<\/strong> Sorting the result set by one or more of the SELECT section’s items is possible with ORDER BY. Here’s a SQL statement that sorts the students by FullName in descending order. Although ascending (ASC) is the usual sort order, you can use DESC to sort in the opposite direction (descending).<\/p>\n\n\n\n

COUNT:<\/strong> COUNT counts the number of rows in the result set and displays it as a column.<\/p>\n\n\n\n

DELETE:<\/strong> DELETE is a command that deletes a record from a database table.<\/p>\n\n\n\n

INNER JOIN: <\/strong>Inner Join, selects records from two tables that have values that match.<\/p>\n\n\n\n

LEFT JOIN: <\/strong>The matched rows from the right table, as well as all rows from the left table, are returned via a LEFT JOIN.<\/p>\n\n\n\n

RIGHT JOIN:<\/strong><\/p>\n\n\n\n

A RIGHT JOIN returns all rows from both tables, as well as the matched rows from the left table.<\/p>\n\n\n\n

FULL OUTER JOIN:<\/strong> The Full OUTER JOIN retrieves all rows from both tables that match.<\/p>\n\n\n\n

Final Thoughts: <\/strong>These are the fundamental SQL commands. If you want to learn more about SQL, you can always learn for free on youtube. There are thousands of SQL tutorials on YouTube. Use Career Ninja<\/a>‘s LearnTube<\/a> for hand-holding training on YouTube. LearnTube organizes the results of your YouTube search into a course framework. If you want to learn “SQL tutorials”, search the term on LearnTube and it will show you a bunch of youtube videos like an online course. As a beginner, you’ll click through the videos from the first to the last, as if you were taking an online course tailored specifically for you.<\/p>\n","protected":false},"excerpt":{"rendered":"

The abbreviation SQL stands for Structured Query Language. SQL commands tell a database how to perform operations, functions, and queries on data. SQL commands can be used to search the database as well as to create tables, add data to tables, change data, and drop tables. If you’re going to work with SQL, you should […]<\/p>\n","protected":false},"author":1,"featured_media":2324,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[28,93],"tags":[],"class_list":{"0":"post-2323","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-programming","8":"category-sql"},"yoast_head":"\nWhat are the most commonly used SQL commands?<\/title>\n<meta name=\"description\" content=\"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What are the most commonly used SQL commands?\" \/>\n<meta property=\"og:description\" content=\"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\" \/>\n<meta property=\"og:site_name\" content=\"Learn Tube\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/CareerNinjaIndia\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-13T18:54:58+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-13T18:55:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"2000\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Team LearnTube\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Team LearnTube\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\"},\"author\":{\"name\":\"Team LearnTube\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07\"},\"headline\":\"What are the Most Commonly Used SQL Commands?\",\"datePublished\":\"2022-10-13T18:54:58+00:00\",\"dateModified\":\"2022-10-13T18:55:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\"},\"wordCount\":586,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\"},\"articleSection\":[\"Programming\",\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\",\"url\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\",\"name\":\"What are the most commonly used SQL commands?\",\"isPartOf\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#website\"},\"datePublished\":\"2022-10-13T18:54:58+00:00\",\"dateModified\":\"2022-10-13T18:55:01+00:00\",\"description\":\"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.\",\"breadcrumb\":{\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learntube.ai\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What are the Most Commonly Used SQL Commands?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learntube.ai\/blog\/#website\",\"url\":\"https:\/\/learntube.ai\/blog\/\",\"name\":\"LearnTube\",\"description\":\"10000+ Free Courses with Free Certification and doubt solving -\",\"publisher\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learntube.ai\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learntube.ai\/blog\/#organization\",\"name\":\"LearnTube\",\"url\":\"https:\/\/learntube.ai\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png\",\"contentUrl\":\"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png\",\"width\":3000,\"height\":742,\"caption\":\"LearnTube\"},\"image\":{\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/CareerNinjaIndia\/\",\"https:\/\/www.instagram.com\/careerninjaindia\/\",\"https:\/\/www.linkedin.com\/company\/careerninja\/\",\"https:\/\/www.youtube.com\/c\/CareerNinja\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07\",\"name\":\"Team LearnTube\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/learntube.ai\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g\",\"caption\":\"Team LearnTube\"},\"sameAs\":[\"https:\/\/learntube.ai\/blog\"],\"url\":\"https:\/\/learntube.ai\/blog\/author\/team-learntube\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"What are the most commonly used SQL commands?","description":"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/","og_locale":"en_US","og_type":"article","og_title":"What are the most commonly used SQL commands?","og_description":"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.","og_url":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/","og_site_name":"Learn Tube","article_publisher":"https:\/\/www.facebook.com\/CareerNinjaIndia\/","article_published_time":"2022-10-13T18:54:58+00:00","article_modified_time":"2022-10-13T18:55:01+00:00","og_image":[{"width":2000,"height":2000,"url":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666.jpg","type":"image\/jpeg"}],"author":"Team LearnTube","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Team LearnTube","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#article","isPartOf":{"@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/"},"author":{"name":"Team LearnTube","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07"},"headline":"What are the Most Commonly Used SQL Commands?","datePublished":"2022-10-13T18:54:58+00:00","dateModified":"2022-10-13T18:55:01+00:00","mainEntityOfPage":{"@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/"},"wordCount":586,"commentCount":0,"publisher":{"@id":"https:\/\/learntube.ai\/blog\/#organization"},"articleSection":["Programming","SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/","url":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/","name":"What are the most commonly used SQL commands?","isPartOf":{"@id":"https:\/\/learntube.ai\/blog\/#website"},"datePublished":"2022-10-13T18:54:58+00:00","dateModified":"2022-10-13T18:55:01+00:00","description":"Learn SQL\u2019s most commonly used commands and master this simple and powerful programming language to increase your skill as a developer.","breadcrumb":{"@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learntube.ai\/blog\/programming\/sql\/what-are-the-most-commonly-used-sql-commands\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learntube.ai\/blog\/"},{"@type":"ListItem","position":2,"name":"What are the Most Commonly Used SQL Commands?"}]},{"@type":"WebSite","@id":"https:\/\/learntube.ai\/blog\/#website","url":"https:\/\/learntube.ai\/blog\/","name":"LearnTube","description":"10000+ Free Courses with Free Certification and doubt solving -","publisher":{"@id":"https:\/\/learntube.ai\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learntube.ai\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/learntube.ai\/blog\/#organization","name":"LearnTube","url":"https:\/\/learntube.ai\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png","contentUrl":"https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/04\/1645302407Colourpng.png","width":3000,"height":742,"caption":"LearnTube"},"image":{"@id":"https:\/\/learntube.ai\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/CareerNinjaIndia\/","https:\/\/www.instagram.com\/careerninjaindia\/","https:\/\/www.linkedin.com\/company\/careerninja\/","https:\/\/www.youtube.com\/c\/CareerNinja"]},{"@type":"Person","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/0f4e519a2115e9be9c8083e7a41a4e07","name":"Team LearnTube","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/learntube.ai\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2f280aa676ba5daf1e7407bffa25f05d95bb67811711176adde8cf8440982486?s=96&d=mm&r=g","caption":"Team LearnTube"},"sameAs":["https:\/\/learntube.ai\/blog"],"url":"https:\/\/learntube.ai\/blog\/author\/team-learntube\/"}]}},"uagb_featured_image_src":{"full":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666.jpg",2000,2000,false],"thumbnail":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-150x150.jpg",150,150,true],"medium":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-300x300.jpg",300,300,true],"medium_large":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-768x768.jpg",696,696,true],"large":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-1024x1024.jpg",696,696,true],"1536x1536":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-1536x1536.jpg",1536,1536,true],"2048x2048":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666.jpg",2000,2000,false],"td_218x150":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-218x150.jpg",218,150,true],"td_324x400":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-324x400.jpg",324,400,true],"td_485x360":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-485x360.jpg",485,360,true],"td_696x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-696x696.jpg",696,696,true],"td_1068x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-1068x1068.jpg",1068,1068,true],"td_1920x0":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666-1920x1920.jpg",1920,1920,true],"td_324x235":["https:\/\/learntube.ai\/blog\/wp-content\/uploads\/2022\/10\/21743445_6504666.jpg",235,235,false]},"uagb_author_info":{"display_name":"Team LearnTube","author_link":"https:\/\/learntube.ai\/blog\/author\/team-learntube\/"},"uagb_comment_info":0,"uagb_excerpt":"The abbreviation SQL stands for Structured Query Language. SQL commands tell a database how to perform operations, functions, and queries on data. SQL commands can be used to search the database as well as to create tables, add data to tables, change data, and drop tables. If you’re going to work with SQL, you should…","_links":{"self":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/2323","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/comments?post=2323"}],"version-history":[{"count":1,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/2323\/revisions"}],"predecessor-version":[{"id":2325,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/posts\/2323\/revisions\/2325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/media\/2324"}],"wp:attachment":[{"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/media?parent=2323"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/categories?post=2323"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learntube.ai\/blog\/wp-json\/wp\/v2\/tags?post=2323"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}