{"id":4086,"date":"2026-08-10T09:10:12","date_gmt":"2026-08-10T09:10:12","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/pluralsight-oracle-database-program-with-pl-sql-exam-number-1z0-149-2024-5\/"},"modified":"2026-08-10T09:10:12","modified_gmt":"2026-08-10T09:10:12","slug":"pluralsight-oracle-database-program-with-pl-sql-exam-number-1z0-149-2024-5","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/pluralsight-oracle-database-program-with-pl-sql-exam-number-1z0-149-2024-5\/","title":{"rendered":"Pluralsight \u2013 Oracle Database Program with PL\/SQL Exam Number: 1Z0-149 2024-5"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<div class=\"markdown markdown-main-panel\" style=\"text-align: left\">\n<div class=\"presented-response-container ng-tns-c4213264577-22\">\n<div class=\"response-container-content ng-tns-c4213264577-22\">\n<div class=\"response-content ng-tns-c4213264577-22\">\n<div class=\"markdown markdown-main-panel\">\n<p data-sourcepos=\"5:1-5:300\"><span style=\"vertical-align: inherit\">Course Oracle Database Program with PL\/SQL Exam Number: 1Z0-149. This comprehensive course is designed for people who wish to acquire the skills and knowledge necessary for PL\/SQL programming and pass the 1Z0-149 exam. In this course, key PL\/SQL concepts are taught thoroughly and in depth, and you will be introduced to various types of PL\/SQL programs, including procedures, functions, packages, and triggers. This course is specifically designed to help you prepare for the 1Z0-149 exam. During the course, you will get to know different types of exam questions and learn the tips and techniques necessary to pass the exam.<\/span><\/p>\n<h3 data-sourcepos=\"13:1-13:25\"><span style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul data-sourcepos=\"15:1-29:0\">\n<li data-sourcepos=\"15:1-15:124\"><span style=\"vertical-align: inherit\">PL\/SQL Basics: In this section, you will learn about basic PL\/SQL concepts such as variables, data types, operators, and control structures.<\/span><\/li>\n<li data-sourcepos=\"16:1-16:148\"><span style=\"vertical-align: inherit\">Writing PL\/SQL statements: In this section, you will learn how to write different types of PL\/SQL statements, including DML statements, DDL statements, and PL\/SQL statements.<\/span><\/li>\n<li data-sourcepos=\"17:1-17:144\"><span style=\"vertical-align: inherit\">Working with Composite Data: In this section, you will learn how to work with various types of composite data in PL\/SQL, including records, tables, and arrays.<\/span><\/li>\n<li data-sourcepos=\"18:1-18:160\"><span style=\"vertical-align: inherit\">Using PL\/SQL Subroutines: In this section, you\u2019ll learn how to use PL\/SQL subroutines to organize your code and increase the efficiency of your programs.<\/span><\/li>\n<li data-sourcepos=\"19:1-19:159\"><span style=\"vertical-align: inherit\">Creating Procedures and Using Parameters: In this section, you will learn how to create procedures in PL\/SQL and how to use parameters to pass data to procedures.<\/span><\/li>\n<li data-sourcepos=\"20:1-20:107\"><span style=\"vertical-align: inherit\">Creating Functions: In this section, you will learn how to create functions in PL\/SQL and how to return values \u200b\u200bfrom functions.<\/span><\/li>\n<li data-sourcepos=\"21:1-21:110\"><span style=\"vertical-align: inherit\">Creating Packages: In this section, you will learn how to create packages in PL\/SQL and how to use package objects.<\/span><\/li>\n<li data-sourcepos=\"22:1-22:113\"><span style=\"vertical-align: inherit\">Working with Packages: In this section, you will learn how to work with PL\/SQL packages, including package components and scopes.<\/span><\/li>\n<li data-sourcepos=\"23:1-23:129\"><span style=\"vertical-align: inherit\">Using Dynamic SQL: In this section, you will learn how to use dynamic SQL in PL\/SQL to create more flexible applications.<\/span><\/li>\n<li data-sourcepos=\"24:1-24:116\"><span style=\"vertical-align: inherit\">Design Considerations for PL\/SQL Code: In this section, you will learn how to design clean, efficient, and maintainable PL\/SQL code.<\/span><\/li>\n<li data-sourcepos=\"25:1-25:138\"><span style=\"vertical-align: inherit\">Creating Compound, DDL, and Event Database Triggers: In this section, you will learn how to create different types of database triggers in PL\/SQL.<\/span><\/li>\n<li data-sourcepos=\"26:1-26:134\"><span style=\"vertical-align: inherit\">Using the PL\/SQL Compiler: In this section, you\u2019ll learn how to use the PL\/SQL compiler to debug and optimize your code.<\/span><\/li>\n<li data-sourcepos=\"27:1-27:111\"><span style=\"vertical-align: inherit\">Managing PL\/SQL Code: In this section, you will learn how to manage PL\/SQL code, including versioning and documenting the code.<\/span><\/li>\n<li data-sourcepos=\"28:1-29:0\"><span style=\"vertical-align: inherit\">Dependency Management: In this section, you will learn how to manage dependencies between PL\/SQL objects.<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"7:1-7:21\"><span style=\"vertical-align: inherit\">Who is this course for?<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Database developers who want to improve their PL\/SQL skills<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Database experts who want to learn PL\/SQL programming to automate tasks<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Computer science students who are interested in learning PL\/SQL programming<\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course details<\/span><\/h3>\n<ul style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.pluralsight.com\/paths\/oracle-database-program-with-plsql-exam-number-1z0-149\" target=\"_blank\"><span style=\"vertical-align: inherit\">Pluralsight<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Players: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/esteban-herrera\/\"><span style=\"vertical-align: inherit\">Esteban Herrera<\/span><\/a><span style=\"vertical-align: inherit\"> , <\/span><br \/><span style=\"vertical-align: inherit\"><a href=\"https:\/\/downloadlynet.ir\/tag\/saravanan-dhandapani\/\">Saravanan Dhandapani<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/ed-freitas\/\">Ed Freitas<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/pankaj-jain\/\">Pankaj Jain<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/lucian-lazar\/\">Lucian Lazar<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/elias-fofanov\/\">Elias Fofanov<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/mike-mcquillan\/\">Mike McQuillan<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/alexandru-huiban\/\">Alexandru Huiban<\/a>, <a href=\"https:\/\/downloadlynet.ir\/tag\/agaba-philip\/\">Agaba Philip<\/a><\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Education level: Intermediate<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 19 hours<\/span><\/li>\n<\/ul>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910699 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Oracle-Database-Program-with-PL-SQL-Exam-Number-1Z0-1492.jpg\" alt=\"Oracle Database Program with PL\/SQL Exam Number: 1Z0-149\" width=\"831\" height=\"1366\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910698 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Oracle-Database-Program-with-PL-SQL-Exam-Number-1Z0-149-2.jpg\" alt=\"Oracle Database Program with PL\/SQL Exam Number: 1Z0-149\" width=\"827\" height=\"1072\"><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Images of Oracle Database Program with PL\/SQL Exam Number: 1Z0-149<\/span><\/h3>\n<p style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910700 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Oracle-Database-Program-with-PL-SQL-Exam-Number-1Z0-14921.jpg\" alt=\"Oracle Database Program with PL\/SQL Exam Number: 1Z0-149\" width=\"619\" height=\"170\"><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Sample video of the course<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-130389-1\"><video class=\"wp-video-shortcode\" id=\"video-130389-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_Downloadly.ir.mp4?nocache=1786100300244\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div style=\"text-align: left\">\n<h3><span style=\"vertical-align: inherit\">Installation guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite Player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">English subtitle<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 720p<\/span><\/p>\n<\/div>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Pluralsight_Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_2024-5.part1_Downloadly.ir.rar?nocache=1786100299\"><span style=\"vertical-align: inherit\">Download part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Pluralsight_Oracle_Database_Program_with_PLSQL_Exam_Number_1Z0-149_2024-5.part2_Downloadly.ir.rar?nocache=1786100299\"><span style=\"vertical-align: inherit\">Download part 2 \u2013 944 MB<\/span><\/a><\/p>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 style=\"text-align: left\"><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p style=\"text-align: left\"><span style=\"vertical-align: inherit\">1.9 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Course Oracle Database Program with PL\/SQL Exam Number: 1Z0-149. This comprehensive course is designed for people who wish to acquire the skills and<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[44639,44640,44641,44642,44643,31031,44644,44645,44646,44647,44648,44649,44650,44651],"class_list":["post-4086","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-agaba-philip","dgi_tag-alexandru-huiban","dgi_tag-course-oracle-database-program-with-pl-sql-exam-number-1z0-149","dgi_tag-download-course-oracle-database-program-with-pl-sql-exam-number-1z0-149","dgi_tag-download-oracle-database-program-with-pl-sql-exam-number-1z0-149","dgi_tag-ed-freitas","dgi_tag-elias-fofanov","dgi_tag-esteban-herrera","dgi_tag-free-download-oracle-database-program-with-pl-sql-exam-number-1z0-149","dgi_tag-free-oracle-database-program-with-pl-sql-exam-number-1z0-149","dgi_tag-lucian-lazar","dgi_tag-mike-mcquillan","dgi_tag-pankaj-jain","dgi_tag-saravanan-dhandapani"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4086","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4086\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=4086"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=4086"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=4086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}