{"id":4745,"date":"2026-10-07T19:21:33","date_gmt":"2026-10-07T17:21:33","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/"},"modified":"2026-10-07T21:05:38","modified_gmt":"2026-10-07T19:05:38","slug":"oracle-database-sql-fundamentals-2","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/","title":{"rendered":"Oracle Database SQL Fundamentals 2"},"content":{"rendered":"<p>Deze module is bestemd voor applicatie ontwikkelaars, database beheerders en andere gebruikers die al beschikken over SQL basiskennis. Deze module verschaft de deelnemer kennis en vaardigheden in de geavanceerde mogelijkheden van Oracle SQL in combinatie met de Oracle database. De focus ligt op geavanceerde query&#8217;s, de data dictionary, controle van gebruikerstoegang en globalisatie. <\/p>\n<ul>\n<li>\nData Dictionary<\/p>\n<ul>\n<li> Data Dictionary hi&#xEB;rarchie<\/li>\n<li>Beheer objecten met queries op de Data Dictionary\n<\/li>\n<li>Commentaar in Data Dictionary<\/li>\n<\/ul>\n<\/li>\n<li>Toegangsbeveiliging op object en system level\n<ul>\n<li>Gebruikersrechten<\/li>\n<li>Rollen voor groepen<\/li>\n<li>Privileges voor views en beveiliging door views<\/li>\n<\/ul>\n<\/li>\n<li>Beheren van Schema Objecten.\n<ul>\n<li>Constraints<\/li>\n<li>create (function-based) indexes<\/li>\n<li>drop columns en set column UNUSED<\/li>\n<li>werken met Flashback<\/li>\n<li>Clusters\n<ul>\n<li>Cluster maken<\/li>\n<li>Clusters en Clustertabellen verwijderen<\/li>\n<\/ul>\n<\/li>\n<li>Temporary Tables<\/li>\n<li>creatie en gebruik van external tables<\/li>\n<\/ul>\n<\/li>\n<li>Manipulatie van Large Data Sets.\n<ul>\n<li>data manipulatie met subqueries<\/li>\n<li>multi-table inserts (unconditional, pivoting en conditional)<\/li>\n<li>merge rows in a table<\/li>\n<li>opsporen van data mutaties in de tijd.\n<ul>\n<li>Flashback Query, Flashback Version en DBMS_FLASHBACK package<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Werken met data in verschillende tijdzones.<\/li>\n<li>Retrieve Data met subqueries.\n<ul>\n<li>multi-column subqueries<\/li>\n<li> meerdere subqueries in een query<\/li>\n<li>werken met gecorreleerde subqueries<\/li>\n<li>scalar subqueries<\/li>\n<li>WITH clausule<\/li>\n<li>Analytical SQL<\/li>\n<\/ul>\n<\/li>\n<li>Regular Expression Support.\n<ul>\n<li>Meta Characters<\/li>\n<li>Regular Expression functions<\/li>\n<li>Basic Searches<\/li>\n<li>pattern checking en replacement<\/li>\n<li>regular expressions en check constraints<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p> Op deze module is geen aparte certificering van toepassing <\/p>\n<ul>\n<li>Oracle Database programmeren met PL\/SQL<\/li>\n<li>Oracle Database Administration<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen.<\/p>\n<p>Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.<\/p>\n","protected":false},"featured_media":4746,"comment_status":"open","ping_status":"closed","template":"","meta":{"_acf_changed":false},"product_brand":[],"product_cat":[506],"product_tag":[],"class_list":["post-4745","product","type-product","status-publish","has-post-thumbnail","product_cat-cb-klassikaal","first","instock","taxable","shipping-taxable","purchasable","product-type-simple"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/\" \/>\n<meta property=\"article:modified_time\" content=\"2026-10-07T19:05:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1672\" \/>\n\t<meta property=\"og:image:height\" content=\"941\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/\",\"name\":\"Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"datePublished\":\"2026-10-07T17:21:33+00:00\",\"dateModified\":\"2026-10-07T19:05:38+00:00\",\"description\":\"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/#primaryimage\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"width\":1672,\"height\":941},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-2\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Products\",\"item\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/shop\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Oracle Database SQL Fundamentals 2\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"name\":\"Train IT Now | Netherlands\",\"description\":\"Opleidingen op gebied van IT\",\"publisher\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\"},\"alternateName\":\"Train IT Now B.V.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#organization\",\"name\":\"Train IT Now B.V.\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"contentUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/08\\\/Trainitnow-VERT-POS.png\",\"width\":846,\"height\":564,\"caption\":\"Train IT Now B.V.\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/p\\\/Train-it-Now-61573405935953\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/106495503\",\"https:\\\/\\\/www.instagram.com\\\/trainitnow\\\/\",\"https:\\\/\\\/nl.linkedin.com\\\/company\\\/train-it-now\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands","description":"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.","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:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands","og_description":"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.","og_url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/","og_site_name":"Train IT Now B.V. | Netherlands","article_publisher":"https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","article_modified_time":"2026-10-07T19:05:38+00:00","og_image":[{"width":1672,"height":941,"url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/","url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/","name":"Oracle Database SQL Fundamentals 2 | Train IT Now B.V. | Netherlands","isPartOf":{"@id":"https:\/\/trainitnow.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","datePublished":"2026-10-07T17:21:33+00:00","dateModified":"2026-10-07T19:05:38+00:00","description":"Verdiep je Oracle SQL skills met deze cursus: leer complexe query&rsquo;s bouwen, beheer gebruikersrechten en maak je database klaar voor internationale toepassingen. Deze cursus biedt verdieping in de geavanceerde mogelijkheden van Oracle SQL binnen een Oracle-databaseomgeving. U leert complexe query&rsquo;s opstellen, werken met de data dictionary en gebruikersrechten beheren. Daarnaast komt globalisatie aan bod: het aanpassen van databases voor meertalige en internationale toepassingen.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/#primaryimage","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","width":1672,"height":941},{"@type":"BreadcrumbList","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trainitnow.com\/nl\/"},{"@type":"ListItem","position":2,"name":"Products","item":"https:\/\/trainitnow.com\/nl\/shop\/"},{"@type":"ListItem","position":3,"name":"Oracle Database SQL Fundamentals 2"}]},{"@type":"WebSite","@id":"https:\/\/trainitnow.com\/nl\/#website","url":"https:\/\/trainitnow.com\/nl\/","name":"Train IT Now | Netherlands","description":"Opleidingen op gebied van IT","publisher":{"@id":"https:\/\/trainitnow.com\/nl\/#organization"},"alternateName":"Train IT Now B.V.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trainitnow.com\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/trainitnow.com\/nl\/#organization","name":"Train IT Now B.V.","url":"https:\/\/trainitnow.com\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","contentUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/08\/Trainitnow-VERT-POS.png","width":846,"height":564,"caption":"Train IT Now B.V."},"image":{"@id":"https:\/\/trainitnow.com\/nl\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/p\/Train-it-Now-61573405935953\/","https:\/\/www.linkedin.com\/company\/106495503","https:\/\/www.instagram.com\/trainitnow\/","https:\/\/nl.linkedin.com\/company\/train-it-now"]}]}},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product\/4745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/comments?post=4745"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media\/4746"}],"wp:attachment":[{"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/media?parent=4745"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4745"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4745"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}