{"id":25586720,"date":"2024-06-23T21:24:57","date_gmt":"2024-06-23T15:54:57","guid":{"rendered":"https:\/\/entri.app\/blog\/?p=25586720"},"modified":"2025-01-23T16:52:09","modified_gmt":"2025-01-23T11:22:09","slug":"sql-cheat-sheet","status":"publish","type":"post","link":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/","title":{"rendered":"SQL Cheat Sheet: Basics to Advanced (2025)"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_79_2 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69e78102df4d2\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69e78102df4d2\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#SQL_Cheat_Sheet_Introduction\" >SQL Cheat Sheet: Introduction<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#What_Is_SQL_Cheat_Sheet\" >What Is SQL Cheat Sheet?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#SQL_Cheat_Sheet_Basics_to_Advanced_2025\" >SQL Cheat Sheet: Basics to Advanced (2025)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#SQL_Cheat_Sheet_Conclusion\" >SQL Cheat Sheet: Conclusion<\/a><\/li><\/ul><\/nav><\/div>\n<p>SQL (Structured Query Language) is a query language designed to manage and manipulate relational databases. It lets people interact with databases. SQL enables users to execute various operations, including querying data, updating data, adding and removing entries, establishing and altering database structures, and managing permissions. An SQL cheat sheet is something you might have heard often about. But what is an SQL cheat sheet?<\/p>\n<div class=\"lead-gen-block\"><a href=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/SQL-cheat-sheet-Entri-Elevate.pdf\" data-url=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/SQL-cheat-sheet-Entri-Elevate.pdf\" class=\"lead-pdf-download\" data-id=\"25556852\">\n<p style=\"text-align: center;\"><button class=\"btn btn-default\">SQL CHEAT SHEET &#8211; FREE PDF<\/button><\/p>\n<\/a><\/div>\n<h2><span class=\"ez-toc-section\" id=\"SQL_Cheat_Sheet_Introduction\"><\/span><strong>SQL Cheat Sheet: Introduction<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>SQL, or Structured Query Language, is a language for communicating with databases. It allows you to choose particular data and create intricate reports. SQL is now considered a universal data language. It is utilized in almost every technology that processes data. SQL Cheat Sheet is something very important that one has to learn if they have to efficiently work with SQL. Let us learn more about SQL cheat sheet.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Get the best mentors to learn SQL! Register <\/strong><strong>for Entri Elevate full-stack developer course!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"What_Is_SQL_Cheat_Sheet\"><\/span><strong>What Is SQL Cheat Sheet?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The SQL cheat sheet lists the most frequently used SQL statements for your convenience. Some of the important SQL Cheat Sheet are listed here for your reference. Do you want to learn more SQL cheat sheet commands? Do you want to learn SQL from a reliable source offering valuable certification? Join the Entri Full stack course today! The Entri Elevate full-stack developer course may be a better option for people who prefer to devote serious time and effort to full-stack programming. You may collaborate with industry professionals from top-tier industries, corporations, and organizations. The Entri Elevate Full Stack Web Development Course has been certified by Illinois Tech. Users who finish the program will get distinguished badges from Illinois Tech.<\/p>\n<p style=\"text-align: center;\"><a href=\"https:\/\/entri.app\/course\/full-stack-developer-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Click here to learn more about the Entri Elevate full-stack developer course!<\/strong><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"SQL_Cheat_Sheet_Basics_to_Advanced_2025\"><\/span><strong>SQL Cheat Sheet: Basics to Advanced (2025)<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The SQL cheat sheets that are most prominent in the year 2025 are listed below.<\/p>\n<h3><strong>Data Manipulation Language DML Commands<\/strong><\/h3>\n<p>The SQL instructions that manipulate data in the database are classified as DML, or Data Manipulation Language, and constitute the majority of SQL statements. It is the SQL statement component responsible for controlling data and database access. Essentially, DCL statements are combined with DML statements.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><strong>No. <\/strong><\/td>\n<td width=\"80\"><strong>Command <\/strong><\/td>\n<td width=\"298\"><strong>Syntax <\/strong><\/td>\n<td width=\"203\"><strong>Description <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"36\">1<\/td>\n<td width=\"80\">SELECT<\/td>\n<td width=\"298\">SELECT column1, column2 FROM table_name;<\/td>\n<td width=\"203\">Retrieves data from a database<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">2<\/td>\n<td width=\"80\">INSERT<\/td>\n<td width=\"298\">INSERT INTO table_name<\/p>\n<p>(column1, column2) VALUES<\/p>\n<p>(value1, value2);<\/td>\n<td width=\"203\">Adds new records to a table<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">3<\/td>\n<td width=\"80\">UPDATE<\/td>\n<td width=\"298\">UPDATE table_name SET column1<\/p>\n<p>= value1, column2 = value2<\/p>\n<p>WHERE condition;<\/td>\n<td width=\"203\">Used to modify existing records in a table<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">4<\/td>\n<td width=\"80\">DELETE<\/td>\n<td width=\"298\">DELETE FROM table_name WHERE<\/p>\n<p>condition;<\/td>\n<td width=\"203\">Removes records from a table<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>Data Definition Language DDL Commands<\/strong><\/h3>\n<p>The SQL commands that may be used to specify the database structure are known as DDL or Data Definition Language. It is used to construct and alter the structure of database objects in the database and only works with descriptions of the database schema. Database structures may be created, altered, and deleted using the DDL set of SQL commands, however, data cannot be deleted. General users should utilize applications to access databases. They typically do not use these commands.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><strong>No. <\/strong><\/td>\n<td width=\"86\"><strong>Command <\/strong><\/td>\n<td width=\"310\"><strong>Syntax <\/strong><\/td>\n<td width=\"184\"><strong>Description <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"36\">1<\/td>\n<td width=\"86\">CREATE<\/td>\n<td width=\"310\">CREATE TABLE table_name (column1 datatype1,<\/p>\n<p>column2 datatype2, );<\/td>\n<td width=\"184\">creates a new database and objects,<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">2<\/td>\n<td width=\"86\">ALTER<\/td>\n<td width=\"310\">ALTER TABLE table_name ADD column_name datatype;<\/td>\n<td width=\"184\">adds, deletes, or modifies columns in an existing table<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">3<\/td>\n<td width=\"86\">DROP<\/td>\n<td width=\"310\">DROP TABLE table_name;<\/td>\n<td width=\"184\">used to drop an existing table in a database<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">4<\/td>\n<td width=\"86\">TRUNCATE<\/td>\n<td width=\"310\">TRUNCATE TABLE table_name;<\/td>\n<td width=\"184\">used to delete the data inside a table, but not the table itself<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>Data Control Language DCL Commands<\/strong><\/h3>\n<p>DCL has commands like GRANT and REVOKE that primarily deal with the database system&#8217;s rights, permissions, and other controls.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><strong>No. <\/strong><\/td>\n<td width=\"122\"><strong>Commands <\/strong><\/td>\n<td width=\"236\"><strong>Syntax <\/strong><\/td>\n<td width=\"221\"><strong>Description <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"36\">1<\/td>\n<td width=\"122\">GRANT<\/td>\n<td width=\"236\">GRANT SELECT, INSERT ON<\/p>\n<p>table_name TO user_name;<\/td>\n<td width=\"221\">Used to give specific privileges to users or roles.<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">2<\/td>\n<td width=\"122\">REVOKE<\/td>\n<td width=\"236\">REVOKE SELECT, INSERT ON<\/p>\n<p>table_name FROM<\/p>\n<p>user_name;<\/td>\n<td width=\"221\">Used to take away privileges<\/p>\n<p>previously granted to users or<\/p>\n<p>roles.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>DQL (Data Query Language)<\/strong><\/h3>\n<p>DQL statements are used to run queries on data contained in schema objects. The DQL command&#8217;s goal is to get a schema relation based on the query that is supplied to it. Here is how we may define DQL: It is a part of the SQL statement that enables ordering data that is pulled from the database. The SELECT statement is part of it. With the help of this command, data may be extracted from the database and used for various purposes.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><strong>No.<\/strong><\/td>\n<td width=\"132\"><strong>Commands <\/strong><\/td>\n<td width=\"255\"><strong>Syntax <\/strong><\/td>\n<td width=\"193\"><strong>Description <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"36\">1<\/td>\n<td width=\"132\">SELECT Statement<\/td>\n<td width=\"255\">SELECT column1, column2 FROM table_name;<\/td>\n<td width=\"193\">the primary command used to<\/p>\n<p>retrieve data from a database<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3><strong>TCL (Transaction Control Language)<\/strong><\/h3>\n<p>Transactions combine several tasks into a single unit of execution. Every transaction starts with a particular task and concludes when every work in the group has been properly finished. The transaction fails if any of the tasks are unsuccessful. A transaction may thus only have two possible outcomes: success or failure.<\/p>\n<table>\n<tbody>\n<tr>\n<td width=\"36\"><strong>No. <\/strong><\/td>\n<td width=\"132\"><strong>Commands <\/strong><\/td>\n<td width=\"198\"><strong>Syntax <\/strong><\/td>\n<td width=\"250\"><strong>Description <\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"36\">1<\/td>\n<td width=\"132\">COMMIT<\/td>\n<td width=\"198\">COMMIT;<\/td>\n<td width=\"250\">used to save all the changes made during the current transaction and make them permanent.<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">2<\/td>\n<td width=\"132\">ROLLBACK<\/td>\n<td width=\"198\">ROLLBACK;<\/td>\n<td width=\"250\">used to undo all the changes made during the current transaction and<\/p>\n<p>discard them.<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">3<\/td>\n<td width=\"132\">SAVEPOINT<\/td>\n<td width=\"198\">SAVEPOINT savepoint_name;<\/td>\n<td width=\"250\">used to set a point within a transaction to which you can later roll back.<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">4<\/td>\n<td width=\"132\">ROLLBACK TO<\/p>\n<p>SAVEPOINT<\/td>\n<td width=\"198\">ROLLBACK TO SAVEPOINT<\/p>\n<p>savepoint name;<\/td>\n<td width=\"250\">used to roll back to a specific savepoint within a transaction.<\/td>\n<\/tr>\n<tr>\n<td width=\"36\">5<\/td>\n<td width=\"132\">SET TRANSACTION<\/td>\n<td width=\"198\">SET TRANSACTION [ISOLATION LEVEL { READ<\/p>\n<p>COMMITTED | SERIALIZABL<\/p>\n<p>E }]<\/td>\n<td width=\"250\">used to configure properties for the<\/p>\n<p>current transaction<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><span class=\"ez-toc-section\" id=\"SQL_Cheat_Sheet_Conclusion\"><\/span><strong>SQL Cheat Sheet: Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The majority of websites and apps utilize relational databases in some form or another. This makes SQL incredibly useful since it enables you to build complex but still functioning systems. SQL is an extremely sophisticated and adaptable language for handling and modifying relational databases. This comprehensive cheat sheet covers a wide range of SQL commands and ideas, from database setup to advanced subjects such as stored procedures, triggers, and user-defined functions. This cheat sheet is a great resource for both newcomers learning SQL principles and experienced users wishing to improve their database administration and manipulation skills.<\/p>\n<div class=\"modal\" id=\"modal25556852\"><div class=\"modal-content\"><span class=\"close-button\">&times;<\/span>\n\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f25556852-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"25556852\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/blog\/wp-json\/wp\/v2\/posts\/25586720#wpcf7-f25556852-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"25556852\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.4\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f25556852-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_group_fields\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_hidden_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_visible_groups\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_repeaters\" value=\"[]\" \/><input type=\"hidden\" name=\"_wpcf7cf_steps\" value=\"{}\" \/><input type=\"hidden\" name=\"_wpcf7cf_options\" value=\"{&quot;form_id&quot;:25556852,&quot;conditions&quot;:[],&quot;settings&quot;:{&quot;animation&quot;:&quot;yes&quot;,&quot;animation_intime&quot;:200,&quot;animation_outtime&quot;:200,&quot;conditions_ui&quot;:&quot;normal&quot;,&quot;notice_dismissed&quot;:false,&quot;notice_dismissed_update-cf7-5.9.8&quot;:true,&quot;notice_dismissed_update-cf7-6.1.1&quot;:true}}\" \/>\n<\/fieldset>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"full_name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Name\" value=\"\" type=\"text\" name=\"full_name\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"phone\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone\" value=\"\" type=\"tel\" name=\"phone\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"email_id\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-text wpcf7-validates-as-email\" aria-invalid=\"false\" placeholder=\"Email\" value=\"\" type=\"email\" name=\"email_id\" \/><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"language\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" name=\"language\"><option value=\"\">Language<\/option><option value=\"Malayalam\">Malayalam<\/option><option value=\"Tamil\">Tamil<\/option><option value=\"Telugu\">Telugu<\/option><option value=\"Kannada\">Kannada<\/option><option value=\"Hindi\">Hindi<\/option><\/select><\/span><br \/>\n<span class=\"wpcf7-form-control-wrap\" data-name=\"course\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-field-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course\"><option value=\"\">Upskill in<\/option><option value=\"Coding\">Coding<\/option><option value=\"Robotics &amp; AI Course\">Robotics &amp; AI Course<\/option><option value=\"Structural Design\">Structural Design<\/option><option value=\"Commerce\">Commerce<\/option><option value=\"Stock Market Course\">Stock Market Course<\/option><option value=\"Spoken English\">Spoken English<\/option><option value=\"German Language\">German Language<\/option><option value=\"Montessori Teacher Training\">Montessori Teacher Training<\/option><option value=\"IELTS\">IELTS<\/option><option value=\"OET\">OET<\/option><option value=\"Embedded System Software Engineering\">Embedded System Software Engineering<\/option><option value=\"MEP\">MEP<\/option><option value=\"Quantity Surveying\">Quantity Surveying<\/option><option value=\"Hospital and Healthcare Administration\">Hospital and Healthcare Administration<\/option><option value=\"Yoga TTC\">Yoga TTC<\/option><option value=\"Digital Marketing\">Digital Marketing<\/option><option value=\"AI for Teachers\">AI for Teachers<\/option><option value=\"Arabic\">Arabic<\/option><\/select><\/span>\n<\/p>\n<div data-id=\"group-coding\" data-orig_data_id=\"group-coding\" data-clear_on_hide class=\"\" data-class=\"wpcf7cf_group\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course_name\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-name-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course_name\"><option value=\"\">Select Course<\/option><option value=\"Full Stack Development\">Full Stack Development<\/option><option value=\"Data Science and ML\">Data Science and ML<\/option><option value=\"Software Testing\">Software Testing<\/option><option value=\"Python Programming\">Python Programming<\/option><option value=\"AWS Training\">AWS Training<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<div data-id=\"group-accounting\" data-orig_data_id=\"group-accounting\" data-clear_on_hide class=\"\" data-class=\"wpcf7cf_group\">\n\t<p><span class=\"wpcf7-form-control-wrap\" data-name=\"course_name\"><select class=\"wpcf7-form-control wpcf7-select wpcf7-validates-as-required course-name-select\" aria-required=\"true\" aria-invalid=\"false\" name=\"course_name\"><option value=\"\">Select Course<\/option><option value=\"Business Accounting\">Business Accounting<\/option><option value=\"CMA USA\">CMA USA<\/option><option value=\"Enrolled Agent\">Enrolled Agent<\/option><option value=\"SAP FICO\">SAP FICO<\/option><option value=\"SAP MM\">SAP MM<\/option><option value=\"SAP SD\">SAP SD<\/option><option value=\"ACCA\">ACCA<\/option><option value=\"Tally\">Tally<\/option><option value=\"UAE Accounting\">UAE Accounting<\/option><option value=\"GST\">GST<\/option><\/select><\/span>\n\t<\/p>\n<\/div>\n<p><span class=\"wpcf7-form-control-wrap\" data-name=\"education\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Educational qualification\" value=\"\" type=\"text\" name=\"education\" \/><\/span>\n<\/p>\n<div style=\"display:none\">\n<input class=\"wpcf7-form-control wpcf7-hidden course-name-input\" value=\"\" type=\"hidden\" name=\"course_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-source\" value=\"\" type=\"hidden\" name=\"utm_source\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-medium\" value=\"\" type=\"hidden\" name=\"utm_medium\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-campaign\" value=\"\" type=\"hidden\" name=\"utm_campaign\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-content\" value=\"\" type=\"hidden\" name=\"utm_content\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden utm-term\" value=\"\" type=\"hidden\" name=\"utm_term\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden blog-url\" value=\"\" type=\"hidden\" name=\"blog_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-category-name\" value=\"\" type=\"hidden\" name=\"post_category_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden post-author-name\" value=\"\" type=\"hidden\" name=\"post_author_name\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden file-url\" value=\"\" type=\"hidden\" name=\"file_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden video-url\" value=\"\" type=\"hidden\" name=\"video_url\" \/>\n<input class=\"wpcf7-form-control wpcf7-hidden courseid\" value=\"\" type=\"hidden\" name=\"course_id\" \/>\n<\/div>\n<div class=\"cf7-cf-turnstile\" style=\"margin-top: 0px; margin-bottom: -15px;\"> <div id=\"cf-turnstile-cf7-1371620901\" class=\"cf-turnstile\" data-sitekey=\"0x4AAAAAABVigxtkiZeGTu5L\" data-theme=\"light\" data-language=\"auto\" data-size=\"normal\" data-retry=\"auto\" data-retry-interval=\"1000\" data-action=\"contact-form-7\" data-appearance=\"always\"><\/div> <script>document.addEventListener(\"DOMContentLoaded\", function() { setTimeout(function(){ var e=document.getElementById(\"cf-turnstile-cf7-1371620901\"); e&&!e.innerHTML.trim()&&(turnstile.remove(\"#cf-turnstile-cf7-1371620901\"), turnstile.render(\"#cf-turnstile-cf7-1371620901\", {sitekey:\"0x4AAAAAABVigxtkiZeGTu5L\"})); }, 0); });<\/script> <br class=\"cf-turnstile-br cf-turnstile-br-cf7-1371620901\"> <style>#cf-turnstile-cf7-1371620901 { margin-left: -15px; }<\/style> <script>document.addEventListener(\"DOMContentLoaded\",function(){document.querySelectorAll('.wpcf7-form').forEach(function(e){e.addEventListener('submit',function(){if(document.getElementById('cf-turnstile-cf7-1371620901')){setTimeout(function(){turnstile.reset('#cf-turnstile-cf7-1371620901');},1000)}})})});<\/script> <\/div><br\/><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Submit\" \/>\n<\/p><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>SQL (Structured Query Language) is a query language designed to manage and manipulate relational databases. It lets people interact with databases. SQL enables users to execute various operations, including querying data, updating data, adding and removing entries, establishing and altering database structures, and managing permissions. An SQL cheat sheet is something you might have heard [&hellip;]<\/p>\n","protected":false},"author":90,"featured_media":25600487,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[802,1904,1841,1926],"tags":[],"class_list":["post-25586720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-articles","category-entri-elevate","category-entri-skilling","category-full-stack-web-development"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog<\/title>\n<meta name=\"description\" content=\"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog\" \/>\n<meta property=\"og:description\" content=\"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Entri Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/entri.me\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-23T15:54:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-23T11:22:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"820\" \/>\n\t<meta property=\"og:image:height\" content=\"615\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Sreevidya M\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@entri_app\" \/>\n<meta name=\"twitter:site\" content=\"@entri_app\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sreevidya M\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\"},\"author\":{\"name\":\"Sreevidya M\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8\"},\"headline\":\"SQL Cheat Sheet: Basics to Advanced (2025)\",\"datePublished\":\"2024-06-23T15:54:57+00:00\",\"dateModified\":\"2025-01-23T11:22:09+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\"},\"wordCount\":1035,\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp\",\"articleSection\":[\"Articles\",\"Entri Elevate\",\"Entri Skilling\",\"Full Stack Web Development\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\",\"url\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\",\"name\":\"SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog\",\"isPartOf\":{\"@id\":\"https:\/\/entri.app\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp\",\"datePublished\":\"2024-06-23T15:54:57+00:00\",\"dateModified\":\"2025-01-23T11:22:09+00:00\",\"description\":\"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.\",\"breadcrumb\":{\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp\",\"width\":820,\"height\":615,\"caption\":\"sql-cheat-sheet_1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/entri.app\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Full Stack Web Development\",\"item\":\"https:\/\/entri.app\/blog\/category\/full-stack-web-development\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"SQL Cheat Sheet: Basics to Advanced (2025)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/entri.app\/blog\/#website\",\"url\":\"https:\/\/entri.app\/blog\/\",\"name\":\"Entri Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/entri.app\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/entri.app\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/entri.app\/blog\/#organization\",\"name\":\"Entri App\",\"url\":\"https:\/\/entri.app\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"contentUrl\":\"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png\",\"width\":989,\"height\":446,\"caption\":\"Entri App\"},\"image\":{\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/entri.me\/\",\"https:\/\/x.com\/entri_app\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8\",\"name\":\"Sreevidya M\",\"description\":\"Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.\",\"url\":\"https:\/\/entri.app\/blog\/author\/sreevidya\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog","description":"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.","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:\/\/entri.app\/blog\/sql-cheat-sheet\/","og_locale":"en_US","og_type":"article","og_title":"SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog","og_description":"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.","og_url":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/","og_site_name":"Entri Blog","article_publisher":"https:\/\/www.facebook.com\/entri.me\/","article_published_time":"2024-06-23T15:54:57+00:00","article_modified_time":"2025-01-23T11:22:09+00:00","og_image":[{"width":820,"height":615,"url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp","type":"image\/webp"}],"author":"Sreevidya M","twitter_card":"summary_large_image","twitter_creator":"@entri_app","twitter_site":"@entri_app","twitter_misc":{"Written by":"Sreevidya M","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#article","isPartOf":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/"},"author":{"name":"Sreevidya M","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8"},"headline":"SQL Cheat Sheet: Basics to Advanced (2025)","datePublished":"2024-06-23T15:54:57+00:00","dateModified":"2025-01-23T11:22:09+00:00","mainEntityOfPage":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/"},"wordCount":1035,"publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"image":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp","articleSection":["Articles","Entri Elevate","Entri Skilling","Full Stack Web Development"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/","url":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/","name":"SQL Cheat Sheet: Basics to Advanced (2024) - Entri Blog","isPartOf":{"@id":"https:\/\/entri.app\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage"},"image":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage"},"thumbnailUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp","datePublished":"2024-06-23T15:54:57+00:00","dateModified":"2025-01-23T11:22:09+00:00","description":"An SQL Cheat Sheet lists the most frequently used SQL statements for your convenience. Some SQL Cheat Sheet Commands are DQL, TCL, DCL etc.","breadcrumb":{"@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/entri.app\/blog\/sql-cheat-sheet\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#primaryimage","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2024\/06\/sql-cheat-sheet_1.webp","width":820,"height":615,"caption":"sql-cheat-sheet_1"},{"@type":"BreadcrumbList","@id":"https:\/\/entri.app\/blog\/sql-cheat-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/entri.app\/blog\/"},{"@type":"ListItem","position":2,"name":"Full Stack Web Development","item":"https:\/\/entri.app\/blog\/category\/full-stack-web-development\/"},{"@type":"ListItem","position":3,"name":"SQL Cheat Sheet: Basics to Advanced (2025)"}]},{"@type":"WebSite","@id":"https:\/\/entri.app\/blog\/#website","url":"https:\/\/entri.app\/blog\/","name":"Entri Blog","description":"","publisher":{"@id":"https:\/\/entri.app\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/entri.app\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/entri.app\/blog\/#organization","name":"Entri App","url":"https:\/\/entri.app\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","contentUrl":"https:\/\/entri.app\/blog\/wp-content\/uploads\/2019\/10\/Entri-Logo-1.png","width":989,"height":446,"caption":"Entri App"},"image":{"@id":"https:\/\/entri.app\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/entri.me\/","https:\/\/x.com\/entri_app"]},{"@type":"Person","@id":"https:\/\/entri.app\/blog\/#\/schema\/person\/9f691436793528a81d4769f3fc0c62a8","name":"Sreevidya M","description":"Post-Graduate in English Language and Literature, freelance writer and an SSC aspirant. Provides updates on notifications, syllabuses and dates for government exams.","url":"https:\/\/entri.app\/blog\/author\/sreevidya\/"}]}},"_links":{"self":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25586720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/users\/90"}],"replies":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/comments?post=25586720"}],"version-history":[{"count":5,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25586720\/revisions"}],"predecessor-version":[{"id":25600490,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/posts\/25586720\/revisions\/25600490"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media\/25600487"}],"wp:attachment":[{"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/media?parent=25586720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/categories?post=25586720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/entri.app\/blog\/wp-json\/wp\/v2\/tags?post=25586720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}