Wenn Sie sich für diesen Kurs anmelden, werden Sie auch für diese Spezialisierung angemeldet.
Lernen Sie neue Konzepte von Branchenexperten
Gewinnen Sie ein Grundverständnis bestimmter Themen oder Tools
Erwerben Sie berufsrelevante Kompetenzen durch praktische Projekte
Erwerben Sie ein Berufszertifikat zur Vorlage
In diesem Kurs gibt es 2 Module
Learners will be able to declare and apply variables, differentiate constants and constraints, ensure datatype consistency, manipulate strings effectively, and construct conditional logic in Oracle PLSQL 21c. By completing this course, participants will gain the confidence to analyze business requirements, design structured PLSQL blocks, and apply reusable procedures for real-world programming scenarios.
This course is designed to benefit beginners and intermediate SQL users who want to strengthen their programming skills in Oracle PLSQL. Through hands-on examples, learners will develop problem-solving skills, improve coding accuracy, and optimize data handling techniques that are directly applicable to workplace projects.
What makes this course unique is its step-by-step modular approach, starting from core concepts of variables and constants, then advancing to datatypes and decision-making logic. Each lesson is supported by practice quizzes and graded assessments, ensuring knowledge retention and practical application.
By the end of the course, learners will be able to design, implement, and evaluate Oracle PLSQL solutions with clarity, precision, and industry relevance.
This module introduces the essentials of Oracle PLSQL programming, including variable and constant declarations, constraints, and procedures. Learners will build a solid
Das ist alles enthalten
6 Videos4 Aufgaben
Infos zu Modulinhalt anzeigen
6 Videos•Insgesamt 38 Minuten
Calculate Incentive for Employee•7 Minuten
Variable Declaration•8 Minuten
Constant Declaration•6 Minuten
Adding Constraints in Variable Declaration•5 Minuten
Creating Variables of Same Column Type•6 Minuten
Procedure in Plsql Block•6 Minuten
4 Aufgaben•Insgesamt 60 Minuten
Graded - Foundations of PLSQL Programming•30 Minuten
Getting Started with Variables•10 Minuten
Constants and Constraints•10 Minuten
Smart Variable Usage•10 Minuten
Mastering Conditions and Datatypes
Modul 2•2 Stunden abzuschließen
Moduldetails
This module focuses on working with character datatypes and applying conditional logic in Oracle PLSQL. Learners will gain the ability to manipulate strings effectively and design decision-making structures using IF-ELSE and CASE expressions to control program flow.
Das ist alles enthalten
4 Videos3 Aufgaben
Infos zu Modulinhalt anzeigen
4 Videos•Insgesamt 29 Minuten
Like Operator•7 Minuten
Char and Varchar2 Datatypes•8 Minuten
Using Case When and If Else in PLSQL•8 Minuten
If Then Else end If•6 Minuten
3 Aufgaben•Insgesamt 70 Minuten
Graded - Mastering Conditions and Datatypes•30 Minuten
Working with Strings•10 Minuten
Conditional Logic in Action•30 Minuten
Erwerben Sie ein Karrierezertifikat.
Fügen Sie dieses Zeugnis Ihrem LinkedIn-Profil, Lebenslauf oder CV hinzu. Teilen Sie sie in Social Media und in Ihrer Leistungsbeurteilung.
Dozent
Lehrkraftbewertungen
Lehrkraftbewertungen
Wir haben alle Lernenden um Feedback zu unseren Dozenten gebeten, ausgehend von der Qualität ihres Unterrichtsstils.
Welcome to EDUCBA, a place where knowledge is limitless! We provide a wide selection of instructive and engaging programmes designed to empower students of all ages and experiences. From the convenience of your home, start a revolutionary educational experience with our cutting-edge technologies courses and experienced instructors.
When will I have access to the lectures and assignments?
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
What will I get if I subscribe to this Specialization?
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Is financial aid available?
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.