{"id":13,"date":"2011-06-27T07:38:18","date_gmt":"2011-06-27T07:38:18","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/27\/what-is-sql\/"},"modified":"2011-06-27T07:38:18","modified_gmt":"2011-06-27T07:38:18","slug":"what-is-sql","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/27\/what-is-sql\/","title":{"rendered":"WHAT IS SQL"},"content":{"rendered":"<p>SQL:<\/p>\n<p>Abbrivation: Structured Query Language, an international standard for database manipulation.<\/p>\n<p>SQL is\u00a0a computer\u00a0language designed to manipulate data in RDBMS(Relational database management system).<\/p>\n<p>SQL is an ANSI Standard,it is devoloped by IBM.<\/p>\n<p>SQL is divided into three basic parts:<\/p>\n<ul>\n<li>DDL<\/li>\n<li>DML<\/li>\n<li>DCL<\/li>\n<\/ul>\n<p>DDL: Data Definition Language. Read more about <a href=\"http:\/\/sqlserverlearner.com\/2011\/ddl-data-definition-language\">DDL here<\/a><\/p>\n<p>DML: Data manipulation language. Read more about <a href=\"http:\/\/sqlserverlearner.com\/2011\/dml-data-manipulation-language-sql-server\">DML here<\/a><\/p>\n<p>DCL: Data Control Language. Read more about <a href=\"http:\/\/sqlserverlearner.com\/2011\/ddl-data-definition-language-sql-server\">DCL here<\/a><\/p>\n<p>SQL Database contains objects like Tables, Procedures, Views, Functions, Triggers\u00a0etc..<\/p>\n<p>Read more about SQL Server Objects here.<\/p>\n<p>Tables contain columns which hold data of a single type. So each table constitutes of multiple columns of different datatype.<\/p>\n<p>Read more about SQL Server Datatypes here.<\/p>\n<p>Following are the few TASKS that can be done using SQL:<\/p>\n<ul>\n<li>Create, Modify, Delete Databases<\/li>\n<li>Create , Modify, Delete Database Objects such as<br \/>\nTables,Procedures,Views,Functions etc..<\/li>\n<li>Grant, Revoke Permissions on Database Objects<\/li>\n<li>Insert,Delete,Update records in Tables.<\/li>\n<li>Create,Modify, Drop\u00a0 Indexes,Triggers Etc.<\/li>\n<li>Fetch data from the database Tables,views etc.<\/li>\n<li>Execute Procedures , Functions Etc.<\/li>\n<\/ul>\n<p>Simple SQL Query:<\/p>\n<p><code><br \/>\nSELECT * FROM EMPLOYEE<br \/>\n<\/code><\/p>\n<p>The above query when executed gives all the records in the table Employee.<\/p>\n<p>Further Reading: <a href=\"http:\/\/en.wikipedia.org\/wiki\/SQL\">wiki<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL: Abbrivation: Structured Query Language, an international standard for database manipulation. SQL is\u00a0a computer\u00a0language designed to manipulate data in RDBMS(Relational database management system). SQL is an ANSI Standard,it is devoloped by IBM. SQL is divided into three basic parts: DDL DML DCL DDL: Data Definition Language. Read more about DDL here DML: Data manipulation language.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[42,43,44,45,46,47],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/13"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=13"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/13\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}