{"id":4744,"date":"2026-10-07T19:21:26","date_gmt":"2026-10-07T17:21:26","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/"},"modified":"2026-10-07T21:05:28","modified_gmt":"2026-10-07T19:05:28","slug":"oracle-database-sql-fundamentals-1","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/","title":{"rendered":"Oracle Database SQL Fundamentals 1"},"content":{"rendered":"<p>Deze module is bestemd voor beginnende SQL-gebruikers.&#xD; Deze module verschaft de deelnemer kennis en vaardigheden in de omgang met relationele databases door middel van de vraagtaal SQL (Structured Query Language) in combinatie met de Oracle database.&#xD; <\/p>\n<ul>\n<li>Inleiding SQL\n<\/li>\n<li>Structuur van database en tabellen\n<\/li>\n<li>De principes van een vraagtaal\n<\/li>\n<li>Enkelvoudige queries\n<\/li>\n<li>Filteren, Sorteren en groeperen van gegevens\n<\/li>\n<li>SQL Row limiting\n<\/li>\n<li>Conversie Functies, Group functies, Conditionele Expressies\n<\/li>\n<li>Ophalen van data uit meerdere tabellen met ANSI SQL 99 join syntax\n<\/li>\n<li>Subqueries en gecorreleerde queries\n<\/li>\n<li>Set Operators\n<ul>\n<li>Definitie en gebruik van Set Operatoren<\/li>\n<li>Ordenen van resultaat bij Set operations<\/li>\n<\/ul>\n<\/li>\n<li>Data manipulatie: toevoegen, wijzigen en verwijderen van gegevens.\n<\/li>\n<li>Select &#8230; FOR UPDATE.\n<\/li>\n<li>Cre&#xEB;ren en beheren van tabellen\n<\/li>\n<li>Opmaken van rapporten\n<\/li>\n<li>Toepassingen van views\n<\/li>\n<li>Cre&#xEB;ren van en omgaan met Sequences, Indexes en Synonyms\n<\/li>\n<\/ul>\n<p> Op deze module is geen aparte certificering van toepassing <\/p>\n<ul>\n<li>Oracle Database SQL Fundamentals 2<\/li>\n<li>Oracle Database Programmeren met PL\/SQL<\/li>\n<li>Oracle Database Administration<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen.<\/p>\n<p>In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.<\/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-4744","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 1 | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.\" \/>\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-1\/\" \/>\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 1 | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/\" \/>\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:28+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-1\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/\",\"name\":\"Oracle Database SQL Fundamentals 1 | Train IT Now B.V. | Netherlands\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"datePublished\":\"2026-10-07T17:21:26+00:00\",\"dateModified\":\"2026-10-07T19:05:28+00:00\",\"description\":\"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-sql-fundamentals-1\\\/#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-1\\\/#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 1\"}]},{\"@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 1 | Train IT Now B.V. | Netherlands","description":"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.","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-1\/","og_locale":"nl_NL","og_type":"article","og_title":"Oracle Database SQL Fundamentals 1 | Train IT Now B.V. | Netherlands","og_description":"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.","og_url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/","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:28+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-1\/","url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/","name":"Oracle Database SQL Fundamentals 1 | Train IT Now B.V. | Netherlands","isPartOf":{"@id":"https:\/\/trainitnow.com\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","datePublished":"2026-10-07T17:21:26+00:00","dateModified":"2026-10-07T19:05:28+00:00","description":"Beheers SQL in Oracle met deze praktijkgerichte cursus: leer data opvragen, bewerken en analyseren met focus op performance en datamodellen. In deze cursus leert u werken met relationele databases via SQL (Structured Query Language) binnen een Oracle-omgeving. U ontwikkelt praktische vaardigheden in het opvragen, bewerken en structureren van gegevens, en krijgt inzicht in de werking van relationele datamodellen. De training is gericht op het effectief gebruiken van SQL om data te analyseren en te beheren, met aandacht voor performance en nauwkeurigheid.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-sql-fundamentals-1\/#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-1\/#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 1"}]},{"@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\/4744","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=4744"}],"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=4744"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4744"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4744"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4744"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}