{"id":4740,"date":"2026-10-07T19:21:07","date_gmt":"2026-10-07T17:21:07","guid":{"rendered":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/"},"modified":"2026-10-07T20:45:27","modified_gmt":"2026-10-07T18:45:27","slug":"oracle-database-plsql-fundamentals-1","status":"publish","type":"product","link":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/","title":{"rendered":"Oracle Database PL\/SQL Fundamentals 1"},"content":{"rendered":"<p>Deze module is bestemd voor de beheerder en ontwikkelaar van de Oracle database en van applicaties in Oracle Forms en Reports Deze module verschaft de deelnemer kennis en vaardigheden in de procedurele programmeertaal PL\/SQL binnen de ontwikkeltools van Oracle. De cursist is in staat om na de cursus zelfstandig stored procedures en programmablokken te schrijven in PL\/SQL binnen de Oracle-tools. <\/p>\n<ul>\n<li>Eigenschappen en plaats van PL\/SQL\n<\/li>\n<li>PL\/SQL instructies en statements\n<ul>\n<li>Block structuur van PL\/SQL programma&#8217;s<\/li>\n<li>Variabelen, constanten en datatypes in een PL\/SQL programma<\/li>\n<li>Control structures: IF en CASE statements en werken met loops<\/li>\n<li>Schrijven van executable statements<\/li>\n<\/ul>\n<\/li>\n<li>SQL en Database\n<ul>\n<li>Ophalen en manipuleren van data  met PL\/SQL\n<\/li>\n<li>Opslaan en ongedaan maken van transacties<\/li>\n<\/ul>\n<\/li>\n<li>Samengestelde datatypes\n<ul>\n<li>PL\/SQL records<\/li>\n<li>%ROWTYPE attribuut<\/li>\n<li>toevoegen en wijzigen met PL\/SQL records<\/li>\n<li>INDEX BY tabel methodes<\/li>\n<\/ul>\n<\/li>\n<li>Cursors in PL\/SQL\n<ul>\n<li>Theorie van en werken met explicit cursors<\/li>\n<li>For Update en Where Current Of clausules<\/li>\n<\/ul>\n<\/li>\n<li>Stored procedures en functies, en debuggen van subprogramma&#8217;s\n<\/li>\n<li>Foutafhandeling in PL\/SQL applicaties\n<\/li>\n<\/ul>\n<p> Op deze module is geen aparte certificering van toepassing <\/p>\n<ul>\n<li>Oracle Database Develop PL\/SQL Program Units.<\/li>\n<\/ul>\n<p>Samen zijn de trainingen &#8220;Oracle Database PL\/SQL Fundamentals&#8221; en &#8220;Oracle Database Develop PL\/SQL Program Units&#8221; gelijk aan de training &#8220;Oracle Database Programmeren met PL\/SQL&#8221;.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools.<\/p>\n<p>Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.<\/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-4740","product","type-product","status-publish","has-post-thumbnail","product_cat-cb-klassikaal","first","instock","taxable","shipping-taxable","purchasable","product-type-variable"],"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 PL\/SQL Fundamentals 1 | Train IT Now B.V. | Netherlands<\/title>\n<meta name=\"description\" content=\"Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.\" \/>\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-plsql-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 PL\/SQL Fundamentals 1 | Train IT Now B.V. | Netherlands\" \/>\n<meta property=\"og:description\" content=\"Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-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-07T18:45:27+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-plsql-fundamentals-1\\\/\",\"url\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-1\\\/\",\"name\":\"Oracle Database PL\\\/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-plsql-fundamentals-1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/wp-content\\\/uploads\\\/2026\\\/10\\\/2_Oracle_training.jpg\",\"datePublished\":\"2026-10-07T17:21:07+00:00\",\"dateModified\":\"2026-10-07T18:45:27+00:00\",\"description\":\"Leer PL\\\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\\\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\\\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\\\/SQL-programma&rsquo;s te bouwen.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-1\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-fundamentals-1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/trainitnow.com\\\/nl\\\/product\\\/oracle-database-plsql-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-plsql-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 PL\\\/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 PL\/SQL Fundamentals 1 | Train IT Now B.V. | Netherlands","description":"Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.","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-plsql-fundamentals-1\/","og_locale":"nl_NL","og_type":"article","og_title":"Oracle Database PL\/SQL Fundamentals 1 | Train IT Now B.V. | Netherlands","og_description":"Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.","og_url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-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-07T18:45:27+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-plsql-fundamentals-1\/","url":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/","name":"Oracle Database PL\/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-plsql-fundamentals-1\/#primaryimage"},"image":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/#primaryimage"},"thumbnailUrl":"https:\/\/trainitnow.com\/nl\/wp-content\/uploads\/2026\/10\/2_Oracle_training.jpg","datePublished":"2026-10-07T17:21:07+00:00","dateModified":"2026-10-07T18:45:27+00:00","description":"Leer PL\/SQL hands-on en bouw onderhoudbare Oracle-programma&rsquo;s met deze praktijkgerichte cursus voor zelfstandig coderen in Oracle-ontwikkeltools. Deze cursus biedt een praktische introductie tot PL\/SQL, de procedurele programmeertaal van Oracle. Je leert hoe je binnen Oracle-ontwikkeltools zelfstandig programmablokken en stored procedures schrijft. De cursus behandelt de basisprincipes van PL\/SQL, zoals variabelen, controlestructuren, foutafhandeling en het structureren van code. Door middel van hands-on opdrachten ontwikkel je vaardigheden om effici&euml;nte en onderhoudbare PL\/SQL-programma&rsquo;s te bouwen.","breadcrumb":{"@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-fundamentals-1\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/trainitnow.com\/nl\/product\/oracle-database-plsql-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-plsql-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 PL\/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\/4740","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=4740"}],"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=4740"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_brand?post=4740"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_cat?post=4740"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/trainitnow.com\/nl\/wp-json\/wp\/v2\/product_tag?post=4740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}