{"id":32,"date":"2022-01-30T09:34:53","date_gmt":"2022-01-30T09:34:53","guid":{"rendered":"https:\/\/technagrik.com\/sqlhelper\/?p=32"},"modified":"2022-01-30T10:13:14","modified_gmt":"2022-01-30T10:13:14","slug":"overview-sql-tutorial","status":"publish","type":"post","link":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/","title":{"rendered":"1. SQL Tutorial – First Step"},"content":{"rendered":"\n

Tutorial will help you in understanding basics of SQL. In later stage some of the advance SQL concepts will be covered. First let us understand some basics of SQL.<\/p>\n\n\n\n

What is SQL?<\/strong><\/p>\n\n\n\n

SQL stands for Structured Query Language. <\/p>\n\n\n\n

Where is it used?<\/strong><\/p>\n\n\n\n

It is used to query structured data in databases. <\/p>\n\n\n\n

What is database?<\/strong><\/p>\n\n\n\n

Database is an organised collection of data stored and accessed electronically.<\/p>\n\n\n\n

What are the most popular databases?<\/strong><\/p>\n\n\n\n

Most popular database include Oracle,Microsoft SQL Server, MySQL, PostgreSQL, SQLite, MongoDB, Redis, and many more.<\/p>\n\n\n\n

Do they all run SQL?<\/strong><\/p>\n\n\n\n

Most of the relational database use SQL. Some of the database which do not use SQL are MongoDB, CouchDB, DB2, and few more.<\/p>\n\n\n\n

Now that we have covered some basics, we would now start with details of how we are going to proceed.<\/p>\n\n\n\n

  1. Overview<\/li>
  2. Setup<\/li>
  3. Basic SQL<\/li>
  4. Advance SQL<\/li>
  5. Oracle SQL<\/li><\/ol>\n\n\n\n

    Are your ready to start?<\/p>\n\n\n\n

    \n
    2. Setup <\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Tutorial will help you in understanding basics of SQL. In later stage some of the advance SQL concepts will be covered. First let us understand some basics of SQL. What is SQL? SQL stands for Structured Query Language. Where is it used? It is used to query structured data in databases. What is database? Database […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,4],"tags":[],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-sql-general","category-sql-tutorial"],"yoast_head":"\n1. SQL Tutorial - First Step - SQL Helper<\/title>\n<meta name=\"description\" content=\"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"1. SQL Tutorial - First Step - SQL Helper\" \/>\n<meta property=\"og:description\" content=\"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL Helper\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/SQL-Helper-by-TechNagrik-104058832194412\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-30T09:34:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-01-30T10:13:14+00:00\" \/>\n<meta name=\"author\" content=\"TechNagrik\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechNagrik\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/\"},\"author\":{\"name\":\"TechNagrik\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/#\\\/schema\\\/person\\\/579b7c960820cea5e62f20ff864bc556\"},\"headline\":\"1. SQL Tutorial – First Step\",\"datePublished\":\"2022-01-30T09:34:53+00:00\",\"dateModified\":\"2022-01-30T10:13:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/\"},\"wordCount\":154,\"commentCount\":0,\"articleSection\":[\"SQL General\",\"SQL Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/\",\"url\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/\",\"name\":\"1. SQL Tutorial - First Step - SQL Helper\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/#website\"},\"datePublished\":\"2022-01-30T09:34:53+00:00\",\"dateModified\":\"2022-01-30T10:13:14+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/#\\\/schema\\\/person\\\/579b7c960820cea5e62f20ff864bc556\"},\"description\":\"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/2022\\\/01\\\/30\\\/overview-sql-tutorial\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"1. SQL Tutorial – First Step\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/#website\",\"url\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/\",\"name\":\"SQL Helper\",\"description\":\"By Tech Nagrik\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/#\\\/schema\\\/person\\\/579b7c960820cea5e62f20ff864bc556\",\"name\":\"TechNagrik\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g\",\"caption\":\"TechNagrik\"},\"sameAs\":[\"https:\\\/\\\/technagrik.com\\\/\",\"https:\\\/\\\/www.facebook.com\\\/SQL-Helper-by-TechNagrik-104058832194412\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCuf38QfExTzxsvRKCVbswkw\"],\"url\":\"https:\\\/\\\/technagrik.com\\\/sqlhelper\\\/author\\\/technagreek\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"1. SQL Tutorial - First Step - SQL Helper","description":"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.","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:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"1. SQL Tutorial - First Step - SQL Helper","og_description":"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.","og_url":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/","og_site_name":"SQL Helper","article_author":"https:\/\/www.facebook.com\/SQL-Helper-by-TechNagrik-104058832194412","article_published_time":"2022-01-30T09:34:53+00:00","article_modified_time":"2022-01-30T10:13:14+00:00","author":"TechNagrik","twitter_card":"summary_large_image","twitter_misc":{"Written by":"TechNagrik","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/#article","isPartOf":{"@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/"},"author":{"name":"TechNagrik","@id":"https:\/\/technagrik.com\/sqlhelper\/#\/schema\/person\/579b7c960820cea5e62f20ff864bc556"},"headline":"1. SQL Tutorial – First Step","datePublished":"2022-01-30T09:34:53+00:00","dateModified":"2022-01-30T10:13:14+00:00","mainEntityOfPage":{"@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/"},"wordCount":154,"commentCount":0,"articleSection":["SQL General","SQL Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/","url":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/","name":"1. SQL Tutorial - First Step - SQL Helper","isPartOf":{"@id":"https:\/\/technagrik.com\/sqlhelper\/#website"},"datePublished":"2022-01-30T09:34:53+00:00","dateModified":"2022-01-30T10:13:14+00:00","author":{"@id":"https:\/\/technagrik.com\/sqlhelper\/#\/schema\/person\/579b7c960820cea5e62f20ff864bc556"},"description":"SQL Tutorial - First Step. Contents includes various information about how expertise gained over the years are going to help in learning SQL the easiest way.","breadcrumb":{"@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/technagrik.com\/sqlhelper\/2022\/01\/30\/overview-sql-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/technagrik.com\/sqlhelper\/"},{"@type":"ListItem","position":2,"name":"1. SQL Tutorial – First Step"}]},{"@type":"WebSite","@id":"https:\/\/technagrik.com\/sqlhelper\/#website","url":"https:\/\/technagrik.com\/sqlhelper\/","name":"SQL Helper","description":"By Tech Nagrik","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/technagrik.com\/sqlhelper\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/technagrik.com\/sqlhelper\/#\/schema\/person\/579b7c960820cea5e62f20ff864bc556","name":"TechNagrik","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6fb325d9847628fb10fa9c68f28e4b2fdf4615fd46adbd5c102e6a8f5c5926cc?s=96&d=mm&r=g","caption":"TechNagrik"},"sameAs":["https:\/\/technagrik.com\/","https:\/\/www.facebook.com\/SQL-Helper-by-TechNagrik-104058832194412","https:\/\/www.youtube.com\/channel\/UCuf38QfExTzxsvRKCVbswkw"],"url":"https:\/\/technagrik.com\/sqlhelper\/author\/technagreek\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/posts\/32","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/comments?post=32"}],"version-history":[{"count":5,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":48,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/posts\/32\/revisions\/48"}],"wp:attachment":[{"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/technagrik.com\/sqlhelper\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}