{"id":10508,"date":"2019-03-16T12:39:33","date_gmt":"2019-03-16T12:39:33","guid":{"rendered":"https:\/\/dbtut.com\/?p=10508"},"modified":"2019-03-16T12:39:33","modified_gmt":"2019-03-16T12:39:33","slug":"cross-apply-and-outer-apply-operators-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/","title":{"rendered":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)"},"content":{"rendered":"

 <\/p>\n

In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL Server<\/a>” article.<\/p>\n

With the CROSS APPLY and OUTER APPLY operators, we can join a table and a result set returned by a table-valued function.<\/p>\n

Difference Between CROSS APPLY and OUTER APPLY:<\/h3>\n

In the CROSS APPLY<\/strong> operator, only the matching records between the two sources(a table and a table valued function) returns. That is, like INNER JOIN.<\/p>\n

In the OUTER APPLY<\/strong> operator, all records in the table returns as a result even if they do not match the result set of the table valued function. That is, like LEFT OUTER JOIN.<\/p>\n

To better understand the CROSS APPLY and OUTER APPLY operators, let’s first create two sample tables and insert a few records into these tables.<\/p>\n

CREATE TABLE City(\r\n    ID int,\r\n    CityName varchar(100)\r\n)\r\n\r\nCREATE TABLE FamousFood(\r\n    ID int,\r\n    CityID int,\r\n    FoodName varchar(100)\r\n)\r\n\r\nINSERT INTO [dbo].[City]([ID],[CityName])VALUES    (1,'Newyork')\r\nINSERT INTO [dbo].[City]([ID],[CityName])VALUES    (42,'Roma')\r\nINSERT INTO [dbo].[City]([ID],[CityName])VALUES    (3,'Paris')\r\nGO\r\nINSERT INTO [dbo].[FamousFood]([ID],[CityID],[FoodName])VALUES    (1,1,'x')\r\nINSERT INTO [dbo].[FamousFood]([ID],[CityID],[FoodName])VALUES    (2,42,'y')\r\nINSERT INTO [dbo].[FamousFood]([ID],[CityID],[FoodName])VALUES    (3,3,'z')\r\n<\/pre>\n
Now let’s create a table-valued function that reads records from the FamousFood table according to the CityID column. We will use this table valued function in CROSS APPLY and OUTER APPLY examples.<\/p>\n
CREATE FUNCTION Get_Famous_Food_Using_CityID(@CityID int)\r\nRETURNS TABLE\r\nAS\r\nRETURN\r\n( \r\nSELECT * FROM [dbo].[FamousFood]\r\nWHERE CityID = @CityID\r\n)\r\n<\/pre>\n
Get_Famous_Food_Using_CityID table valued fonksiyonunu kullanarak CityID de\u011feri 42 olan kay\u0131tlar\u0131 listeleyelim.<\/p>\n
Let’s list the records with the CityID value “42” using the Get_Famous_Food_Using_CityID table valued function.<\/p>\n
SELECT * FROM Get_Famous_Food_Using_CityID(42)<\/pre>\n
\"\"<\/p>\n
CROSS APPLY and INNER JOIN:<\/h3>\n
First, let’s join these two tables with the inner join method. A result returns as follows.<\/p>\n
SELECT c.ID as CityID,c.CityName, ff.id FamousFoodID, ff.FoodName\r\nFROM [dbo].[City] c\r\nINNER JOIN [dbo].[FamousFood] ff\r\nON c.ID = ff.CityID\r\n<\/pre>\n
\"\"<\/p>\n
Then use the CROSS APPLY operator to join the City table and the Get_Famous_Food_Using_CityID table valued function.<\/p>\n
SELECT c.ID as CityID,c.CityName, ff.id FamousFoodID, ff.FoodName\r\nFROM [dbo].[City] c\r\nCROSS APPLY Get_Famous_Food_Using_CityID(c.ID) ff<\/pre>\n
\"\"<\/p>\n
As you can see, we get the same result as the join of the City and FamousFood tables, by joining the City table and the Get_Famous_Food_Using_CityID table valued function with the CROSS APPLY operator.<\/p>\n
LEFT OUTER JOIN and OUTER APPLY:<\/h3>\n
First, we add a record to City and FamousFood tables that are not related to each other. Thus, we aim to have mismatched records.<\/p>\n
INSERT INTO [dbo].[City]([ID],[CityName])VALUES (5,'Luxemburg') \r\nINSERT INTO [dbo].[FamousFood]([ID],[CityID],[FoodName])VALUES (4,37,'k')<\/pre>\n
And we join the two tables with the FULL OUTER JOIN method as follows.<\/p>\n
SELECT c.ID as CityID,c.CityName, ff.id FamousFoodID, ff.FoodName\r\nFROM [dbo].[City] c\r\nFULL OUTER JOIN [dbo].[FamousFood] ff\r\nON c.ID = ff.CityID\r\n<\/pre>\n
\"\"<\/p>\n
As you can see, when we join the two tables with the FULL OUTER JOIN method, all records in the two tables returned as a result, although the records did not match.<\/p>\n
When we join two tables with the LEFT OUTER JOIN method, as you can see below, all records in the City table return as a result even if they don’t match the records in the FamousFood table. However, records in the FamousFood table that does not match the records in the City table does not return as a result.<\/p>\n
SELECT c.ID as CityID,c.CityName, ff.id FamousFoodID, ff.FoodName\r\nFROM [dbo].[City] c\r\nLEFT OUTER JOIN [dbo].[FamousFood] ff\r\nON c.ID = ff.CityID\r\n<\/pre>\n
\"\"<\/p>\n
We can do the same by using the OUTER APPLY operator as follows.<\/p>\n
SELECT c.ID as CityID,c.CityName, ff.id FamousFoodID, ff.FoodName\r\nFROM [dbo].[City] c\r\nOUTER APPLY Get_Famous_Food_Using_CityID(c.ID) ff\r\n<\/pre>\n
\"\"<\/p>\n\n
\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
  In SQL Server, we can join two tables with JOIN operators. You can read the “Join Types in SQL Server” article. With the CROSS APPLY and OUTER APPLY operators, we can join a table and a result set returned by a table-valued function. Difference Between CROSS APPLY and OUTER APPLY: In the CROSS APPLY …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"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,"footnotes":""},"categories":[3,1596],"tags":[2587,2589,2593,2591,2590,2588,2592],"class_list":["post-10508","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-cross-apply","tag-cross-apply-and-inner-join","tag-difference-between-cross-apply-and-outer-apply","tag-left-join-and-outer-apply","tag-left-outer-join-and-outer-apply","tag-outer-apply","tag-outer-join-and-outer-apply"],"aioseo_notices":[],"yoast_head":"\nCROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-16T12:39:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)\",\"datePublished\":\"2019-03-16T12:39:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\"},\"wordCount\":442,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png\",\"keywords\":[\"CROSS APPLY\",\"CROSS APPLY and INNER JOIN\",\"Difference Between CROSS APPLY and OUTER APPLY\",\"LEFT JOIN and OUTER APPLY:\",\"LEFT OUTER JOIN and OUTER APPLY:\",\"OUTER APPLY\",\"OUTER JOIN and OUTER APPLY:\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\",\"name\":\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png\",\"datePublished\":\"2019-03-16T12:39:33+00:00\",\"description\":\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png\",\"width\":661,\"height\":208},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials","description":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)","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:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials","og_description":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-03-16T12:39:33+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)","datePublished":"2019-03-16T12:39:33+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/"},"wordCount":442,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png","keywords":["CROSS APPLY","CROSS APPLY and INNER JOIN","Difference Between CROSS APPLY and OUTER APPLY","LEFT JOIN and OUTER APPLY:","LEFT OUTER JOIN and OUTER APPLY:","OUTER APPLY","OUTER JOIN and OUTER APPLY:"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/","name":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png","datePublished":"2019-03-16T12:39:33+00:00","description":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/03\/img_5c8cecbed931a.png","width":661,"height":208},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/03\/16\/cross-apply-and-outer-apply-operators-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"CROSS APPLY and OUTER APPLY Operators in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=10508"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/10508\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=10508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=10508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=10508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}