SQL Commands<\/strong><\/h2>\n

\n
• SQL commands are instruction which is used to communicate with the database.<\/li>\n
• It is also used to perform specific tasks, functions, and queries of data<\/li>\n
• It can also perform various tasks like creating a table, updating a table, deleting a table etc.<\/li>\n<\/ul>\n

  <\/p>\n

  Types of SQL Commands<\/strong><\/h2>\n

  There are 5 types of SQL Commands<\/p>\n

  DDL (Data Definition Language)<\/h3>\n

  \n
  • Changing the structure of table like creating table, altering a table, and deleting a table can be done using this DDL<\/li>\n
  • Commands in ddl are autocommitted which means it permanently save all changes in the database.<\/li>\n
  • Some of the command in DDL are: create, alter,drop, truncate.<\/li>\n<\/ul>\n

    DML – Data Manipulation Language<\/h3>\n

    \n
    • These commands are used for modifing the database. Responsible for all form of changes in the database.<\/li>\n
    • Commands in dml are not autocommitted which means it cannot permanently save all changes in the database. They can roll back.<\/li>\n
    • Some of the commands under DML are:<\/li>\n
    • Insert, Update, Delete.<\/li>\n<\/ul>\n

      DCL – Data Control Language<\/h3>\n

      \n
      • These command are used to grant and revoke authorities from user.<\/li>\n
      • Some of the commands under DCL are:<\/li>\n
      • Grant<\/li>\n
      • Revoke<\/li>\n<\/ul>\n

        TCL – Transaction Control Language<\/h3>\n

        \n
        • These commands can only be used with DML commands like Insert, delete, update etc.<\/li>\n
        • These operations are auto committed that is why they cannot be used while creating tables or dropping them.<\/li>\n
        • Some of the commands under TCL are:\n
          \n
          • Commit<\/li>\n
          • Roll Back<\/li>\n
          • Save Point<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

            DQL – Data Query Language<\/h3>\n

            \n
            • These commands are used to fetch the data from a database.<\/li>\n
            • Select is the only command used in this language.<\/li>\n<\/ul>\n

              \n","protected":false},"excerpt":{"rendered":"

              SQL Commands SQL commands are instruction which is used to communicate with the database. It is also used to perform specific tasks, functions, and queries of data It can also perform various tasks like creating a table, updating a table, deleting a table etc. Types of SQL Commands There are 5 types of SQL Commands […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"passster_activate_protection":false,"passster_protect_child_pages":"","passster_protection_type":"password","passster_password":"","passster_activate_overwrite_defaults":"","passster_headline":"","passster_instruction":"","passster_placeholder":"","passster_button":"","passster_id":"","passster_activate_misc_settings":"","passster_redirect_url":"","passster_hide":"no","passster_area_shortcode":"","gtb_hide_title":false,"gtb_wrap_title":false,"gtb_class_title":"","gtb_remove_headerfooter":false,"footnotes":""},"categories":[7157],"tags":[19001,18992,18995,18999,19000,18990,18997,18993,18996,18998,18994,18991],"class_list":["post-5034","post","type-post","status-publish","format-standard","hentry","category-dbms","tag-basic-structure-of-sql-queries","tag-dbms-sql-introduction","tag-how-to-perform-a-query-in-database","tag-sql-queries-in-dbms-with-examples","tag-types-of-queries-in-dbms","tag-what-is-a-database-query","tag-what-is-a-dbms-query","tag-what-is-a-query","tag-what-is-a-query-and-subquery-in-dbms","tag-what-is-a-query-in-a-database","tag-what-is-query-in-sql","tag-what-is-structured-query-language"],"yoast_head":"\n