{"id":7516,"date":"2019-04-02T08:59:48","date_gmt":"2019-04-02T08:59:48","guid":{"rendered":"https:\/\/ittutorial.org\/?p=7516"},"modified":"2019-07-24T13:21:31","modified_gmt":"2019-07-24T13:21:31","slug":"oracle-sql-tutorials-chapter-1-1","status":"publish","type":"post","link":"https:\/\/ittutorial.org\/oracle-sql-tutorials-chapter-1-1\/","title":{"rendered":"Oracle SQL Tutorials &#8211; Chapter 1 (Part 1 of 3)"},"content":{"rendered":"<p style=\"text-align: left\"><strong>CHAPTER 1 &#8211; INTRODUCTION TO SQL<\/strong><\/p>\n<ul>\n<li>Explaining the capabilities of the SELECT statement<\/li>\n<li>Writing simple SELECT statements<\/li>\n<li>Select columns and aliases<\/li>\n<li>Arithmetic operators<\/li>\n<li>NULL value<\/li>\n<li>Union operator<\/li>\n<li>Usage of DISTINCT command<\/li>\n<\/ul>\n<p><strong>What is SQL ( Structured Query Language)<\/strong><\/p>\n<ul>\n<li>It is a language that being used to manage and querying the data in relational (RDBMS) databases.<\/li>\n<li>It is not a programming language like C, C++ , Java. It is a sub-language that being used on databases like Oracle, SQL Server, Sybase, MySQL, DB2.<\/li>\n<li>SQL is a language that allows the applications and users to acces the database and make changes.<\/li>\n<\/ul>\n<p><strong>Classification of the SQL Commands<\/strong><\/p>\n<ul>\n<li>SQL commands are classify under four parts as DDL, DML, DCL and TCL.<\/li>\n<li>DDL : Data Definiton Language<\/li>\n<li>DML : Data Manipulation Language<\/li>\n<li>DCL : Data Control Language<\/li>\n<li>TCL : Transaction Control Language<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" width=\"689\" height=\"371\" class=\"wp-image-7517\" src=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/dml-ddl-dcl-ile-ilgili-garsel-sonucu.jpeg\" alt=\"dml ddl dcl ile ilgili g\u00c3\u00b6rsel sonucu\" srcset=\"https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/dml-ddl-dcl-ile-ilgili-garsel-sonucu.jpeg 689w, https:\/\/ittutorial.org\/wp-content\/uploads\/2019\/04\/dml-ddl-dcl-ile-ilgili-garsel-sonucu-300x162.jpeg 300w\" sizes=\"auto, (max-width: 689px) 100vw, 689px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Usage Areas of SQL <\/strong><\/p>\n<ul>\n<li>Modeling and managing the data &amp; data models.<\/li>\n<li>Selecting, adding, deleting and updating the data.<\/li>\n<li>Creating, changing and deleting the database objects.<\/li>\n<li>Controlling the access to the database and objects.<\/li>\n<li>Providing the consistency and integrity of the database.<\/li>\n<\/ul>\n<p><strong>The Rules of Writing SQL<\/strong><\/p>\n<ul>\n<li>SQL statements are not case-sensitive.<\/li>\n<li>SQL statements are formes in one or more lines.<\/li>\n<li>Keywords can not be shortened or divided into lines ( SELECT, FROM, DISCTINCT etc.).<\/li>\n<li>Keywords are usually placed in different lines.<\/li>\n<li>Keywords are usually writing in upper-case.<\/li>\n<li>Date and character data are alligned in left as default.<\/li>\n<li>Numerical data are alligned in right as default.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>You can continue to read from this link ;<\/p>\n<p>https:\/\/ittutorial.org\/2019\/04\/02\/oracle-sql-tutorials-chapter-1-2\/<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>CHAPTER 1 &#8211; INTRODUCTION TO SQL Explaining the capabilities of the SELECT statement Writing simple SELECT statements Select columns and aliases Arithmetic operators NULL value Union operator Usage of DISTINCT command What is SQL ( Structured Query Language) It is a language that being used to manage and querying the data in relational (RDBMS) databases. &hellip;<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1994,3019],"tags":[3006,3004,3005,3009,3011,3010,1340,3001,3013,3014,1572,3003,3017,3015,3016,3018,3000,3012,3007,3002,3008],"class_list":["post-7516","post","type-post","status-publish","format-standard","","category-oracle","category-oracle-sql","tag-dcl","tag-ddl","tag-dml","tag-how-to-write-sql","tag-learn-oracle-sql","tag-learn-sql","tag-oracle-sql","tag-oracle-sql-tutorial","tag-oracle-sql-tutorials","tag-rules-of-sql","tag-sql","tag-sql-commands","tag-sql-komutlari","tag-sql-nedir","tag-sql-ogren","tag-sql-ogrenme","tag-sql-tutorial","tag-sql-tutorials","tag-tcl","tag-what-is-sql","tag-writing-sql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7516","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/comments?post=7516"}],"version-history":[{"count":7,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7516\/revisions"}],"predecessor-version":[{"id":10735,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/posts\/7516\/revisions\/10735"}],"wp:attachment":[{"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/media?parent=7516"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/categories?post=7516"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ittutorial.org\/wp-json\/wp\/v2\/tags?post=7516"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}