2436 Programming courses

Java OOP Course Duration: 1 Day Who would find this course useful? This is useful if you have some coding skills already. This course is fast paced, not quite basics level. It specifically concentrates on Object Oriented Programming Principles (OOP) in Java. Download: Download Java JDK and Eclipse IDE. For classroom courses: Bring your own device. Java OOP Course description Session 1: General Concepts Revision: Scanner, Input from stdin, Print to stdout. Descision, While and For Loops Arrays Session 2: Packages, Methods, Encapsulation Using packages Creating and calling methods, parameters, method overloading Data protection through encapsulation Session 3: Classes, object construction Inheritance, method overload and override Polymorphism or runtime binding Session 4: Constructors, parameterised constructors Create abstract classes and methods Create and use an interface Session 5: Use the access modifiers protected and the default (package-friendly) Create static variables, methods, and initialisers Create final classes, methods, and variables Session 6: Nested Classes, Local Classes, Anonymous Classes, and Lambda Expressions, Enum Types Nested and inner classes; A stack class. What is included PCWorkshops Course Certificate on completion Java Course Notes Java Code Examples Practical Java Course exercises, Java Course Revision work After the course: 1-Hour personalised online revision session Book the Java OOP Course Powered by Eventbrite About us Our experienced trainers are award winners. More about us FAQ's Client Comments

“Master SQL programming and database management with MySQL. Learn to create, manage, and analyze data with SQL’s powerful tools in this comprehensive online course.”

Duration 5 Days 30 CPD hours This course is intended for Application DevelopersWeb AdministratorDeveloperProject ManagerSystem AdministratorTechnical AdministratorTechnical ConsultantTeam Leader Overview Write Java code that uses variables, arrays, conditional and loop constructsManipulate primitive numeric data and string data using Java operatorsCreate Java classes and use object referencesAccess the fields and methods of an objectManipulate text data using the methods of the String and StringBuilder classesUse casting without losing precision or causing errorsDeclare, override, and invoke methodsAccess and create static fields and methodsUse classes from the java.time and java.time.format packages to format and print the local date and timeEncapsulate a class using access modifiers and overloaded constructorsDefine and implement a simple class hierarchyDemonstrate polymorphism by implementing a Java InterfaceUse a Predicate Lambda expression as the argument to a methodHandle a checked exception in a Java application This Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you'll begin to build a baseline of knowledge to propel your career in development. This Java SE 8 Fundamentals training introduces you to object-oriented programming using the Java language. Through hands-on exercises, you'll begin to build a baseline of knowledge to propel your career in development. Additional course details: Nexus Humans Java SE 8 Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Java SE 8 Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.

SAFe® for Teams: Virtual In-House Training Build the skills needed to become a high-performing team member of an Agile Release Train (ART) and learn how to collaborate effectively with other teams by becoming a SAFe® 5 Practitioner (SP). During this course, you will gain an in-depth understanding of the ART, how it delivers value, and what you can do to effectively perform the role using Scrum, Kanban, and Extreme Programming (XP). You will also learn how to write stories and break down features, plan and execute iterations, and plan Program Increments. Finally, you'll learn about the continuous delivery pipeline and DevOps culture, how to effectively integrate with other teams in the program, and what it takes to continuously improve the train. What you will Learn To perform the role of a SAFe® Practitioner, you should be able to: Apply SAFe® to scale Lean and Agile development in their enterprise Know their team and its role on the Agile Release Train Know all other teams on the train, their roles, and the dependencies between the teams Plan Iterations Execute Iterations and demonstrate value Plan Program Increments Integrate and work with other teams on the train Introducing the Scaled Agile Framework® (SAFe®) Building an Agile Team Planning the Iteration Executing the Iteration Executing the Program Increment Practicing SAFe®

The demand for coding essential skills is skyrocketing. The average salary for a web developer in the United Kingdom is £65,824 per year. And that number is only going to go up as more and more businesses move their operations online. If you want to get ahead in the tech industry, you need to learn how to code. This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML course will teach you the crucial skills you need to become a web developer. You'll learn HTML, JavaScript, C#, and ASP.NET. You'll also learn how to build interactive web applications and use JavaScript to add dynamic functionality to your pages. In this Coding Essentials course, we start with an introduction to HTML, where you'll learn the basics, intermediate to advanced level topics, and explore advanced HTML techniques. Next, we dive into JavaScript, a powerful scripting language used for web development. From the fundamentals to conditional statements, control flow, functions, and error handling, you'll gain a solid understanding of JavaScript and its role in creating dynamic web pages. But that's not all! We also dive into the world of C#, a versatile and widely-used programming language. Starting with the basics, you'll progress through operators, statements, control flow, and debugging techniques. You'll also master object-oriented programming (OOPs) concepts, such as class encapsulation, inheritance, polymorphism, abstract classes, and interfaces. Our comprehensive curriculum concludes with exploring error-handling techniques in C#, ensuring you can create robust and reliable applications. Join us on this exciting coding adventure, where our experienced and expert instructors will guide you every step of the way. Don't miss this opportunity to unlock a world of possibilities and take your coding skills to new heights. Enrol in our Coding Essentials course today and unleash your coding potential! Learning Outcomes: Upon completion of the Coding Essentials course, you should be able to: Master the fundamentals of HTML for creating web pages. Gain intermediate and advanced HTML skills for enhanced web development. Understand the core concepts and syntax of JavaScript. Learn to use JavaScript to create dynamic and interactive web content. Develop proficiency in JavaScript operators and conditional statements. Explore control flow statements and error handling in JavaScript. Acquire a solid foundation in C# programming language. Learn C# operators, statements, and control flow techniques. Understand object-oriented programming (OOPs) concepts in C#. Apply C# error handling techniques for creating robust applications. Who is this course for? This Coding Essentials course is perfect for: Beginners who want to learn coding essentials from scratch. Individuals interested in web development and programming languages. Professionals seeking to enhance their coding skills and expand career opportunities. Students or graduates looking to add valuable coding skills to their resumes. Anyone with a passion for coding and a desire to create innovative applications. Career Path  Our Coding Essentials course will help you to pursue a range of career paths, such as: Web Developer: £25,000 - £50,000 per year. Software Engineer: £30,000 - £60,000 per year. Full Stack Developer: £35,000 - £70,000 per year. Front-end Developer: £25,000 - £55,000 per year. Back-end Developer: £30,000 - £60,000 per year. C# Developer: £35,000 - £70,000 per year. JavaScript Developer: £30,000 - £60,000 per year. Certification After studying the course materials of the Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML there will be a written assignment test which you can take either during or at the end of the course. After successfully passing the test you will be able to claim the pdf certificate for £5.99. Original Hard Copy certificates need to be ordered at an additional cost of £9.60. Prerequisites This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML does not require you to have any prior qualifications or experience. You can just enrol and start learning.This Coding Essentials - Javascript, ASP. Net, C# - Bonus HTML was made by professionals and it is compatible with all PC's, Mac's, tablets and smartphones. You will be able to access the course from anywhere at any time as long as you have a good enough internet connection. Course Curriculum Introduction Introduction 00:03:00 How to Get Course requirements 00:02:00 Getting Started on Windows, Linux or Mac 00:02:00 How to ask Great Questions 00:01:00 FAQ's 00:01:00 HTML Introduction HTML 00:05:00 Choosing Code Editor 00:06:00 Installing Code Editor (Sublime Text) 00:04:00 Overview of a Webpage 00:05:00 Structure of a Full HTML Webpage 00:07:00 First Hello World! Webpage 00:09:00 HTML Basic Heading tag 00:09:00 Paragraph 00:08:00 Formatting Text 00:12:00 List Items Unordered 00:05:00 List Items Ordered 00:04:00 Classes 00:09:00 IDs 00:06:00 Comments 00:04:00 HTML Intermediate Images 00:12:00 Forms 00:05:00 Marquee 00:06:00 Text area 00:06:00 Tables 00:06:00 Links 00:07:00 Navbar - Menu 00:04:00 HTML Entities 00:05:00 Div tag 00:06:00 Google Maps 00:07:00 HTML Advanced HTML Audio 00:07:00 HTML Video 00:05:00 Canvas 00:06:00 Iframes 00:05:00 Input Types 00:04:00 Input Attributes 00:06:00 Registration Form 00:04:00 Contact Us Form 00:10:00 Coding Exercise 00:01:00 Solution for Coding Exercise 00:02:00 JavaScript Introduction What is JavaScript 00:09:00 Hello World Program 00:14:00 Getting Output 00:11:00 Internal JavaScript 00:13:00 External JavaScript 00:09:00 Inline JavaScript 00:04:00 Async and defer 00:06:00 JavaScript Basics Variables 00:13:00 Data Types 00:10:00 Numbers 00:06:00 Strings 00:06:00 String Formatting 00:05:00 JavaScript Operators Arithmetic operators 00:07:00 Assignment operators 00:03:00 Comparison operators 00:06:00 Logical operators 00:08:00 JavaScript Conditional Statements If-else statement 00:05:00 If-else-if statement 00:04:00 JavaScript Control Flow Statements While loop 00:09:00 Do-while loop 00:03:00 For loop 00:08:00 Solution for Coding Exercise 00:02:00 JavaScript Functions Creating a Function 00:07:00 Function Call() 00:07:00 Function with parameters 00:05:00 JavaScript Error Handling Try-catch 00:05:00 Try-catch-finally 00:17:00 JavaScript Client-Side Validations On Submit Validation 00:09:00 Input Numeric Validation 00:12:00 C# Introduction Introduction to CSharp 00:07:00 CSharp vs NET 00:04:00 What is CLR 00:05:00 Architecture of NET Application 00:09:00 Getting Visual Studio 00:07:00 First CSharp Hello World Application 00:16:00 First CSharp Core Hello World Program 00:18:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 C# Basic Variables 00:24:00 CSharp Identifiers 00:08:00 Data Types 00:08:00 Type Casting 00:14:00 User Inputs 00:10:00 Comments 00:03:00 C# Operators Arithmetic Operators 00:09:00 Assignment Operators 00:03:00 Comparison Operators 00:03:00 Logical Operators 00:03:00 Strings 00:10:00 String Properties 00:08:00 Booleans 00:06:00 Assessment Test 00:01:00 Solution for Assessment Test 00:01:00 C# Statements If else Conditions and Statements 00:12:00 Switch-Case Statements 00:09:00 C# Control Flow statements While Loop Statement 00:07:00 Do-While Statement 00:03:00 For Loop Statement 00:07:00 Foreach Statement 00:06:00 Break and Continue 00:03:00 C# Built-in coding Arrays 00:13:00 Loop Through Arrays 00:10:00 Lists 00:07:00 SystemIO Namespace 00:03:00 Datetime 00:10:00 TimeSpan 00:06:00 C# Debugging techniques Debugging Tools in Visual Studio 00:13:00 Call Stack Window 00:04:00 Locals and Autos 00:04:00 C# Object-oriented programming [OOPs] Introduction to Class 00:03:00 Create a Class 00:15:00 Object Initializers 00:16:00 Parameters 00:12:00 Access Modifiers(theory) 00:13:00 C# Methods Introduction to methods 00:06:00 Create a method 00:16:00 Method with parameters 00:09:00 Method default and multiple parameters 00:09:00 Method return keyword 00:07:00 Method Over loading 00:08:00 Assessment Test 00:01:00 Solution for Assessment Test 00:02:00 C# Class Encapsulation Introduction to OOPs 00:04:00 Classes and Objects 00:11:00 Class Members 00:10:00 Class Constructors 00:14:00 Access Modifiers 00:11:00 Properties Get Set 00:06:00 Encapsulation 00:03:00 C# Inheritance and Polymorphism Intro Inheritance and Polymorphism 00:03:00 Inheritance 00:12:00 Polymorphism 00:13:00 Assessment Test 00:02:00 Solution for Assessment Test 00:03:00 C# Abstract and Interfaces Introduction 00:02:00 Abstraction 00:07:00 Interfaces 00:07:00 Enums 00:05:00 C# Error Handling Techniques Try Catch 00:10:00 Custom message on Errors 00:05:00 Finally 00:06:00 Throw keyword 00:09:00 Coding Exercise 00:02:00

In this course, you will learn full-stack web development with React JS for the frontend and Python Django for the backend. You will learn and explore various databases such as Microsoft SQL Server, MySQL, MongoDB, PostgreSQL, and SQLite.

Level 5 QLS Endorsed Diploma | 150 CPD Points | +Gifts: QLS Certificate + PDF Certificate | 24/7 Learner Support

24 Hour Flash Deal **25-in-1 BIM - Building Information Modeling Systems Engineering Mega Bundle** BIM - Building Information Modeling Systems Engineering Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the BIM - Building Information Modeling Systems Engineering package online with Studyhub through our online learning platform. The BIM - Building Information Modeling Systems Engineering bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This BIM - Building Information Modeling Systems Engineering course provides complete 360-degree training on BIM - Building Information Modeling Systems Engineering. You'll get not one, not two, not three, but twenty-five BIM - Building Information Modeling Systems Engineering courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these BIM - Building Information Modeling Systems Engineering courses are yours for as long as you want them once you enrol in this course This BIM - Building Information Modeling Systems Engineering Bundle consists the following career oriented courses: Course 01: Building Information Modelling Course 02: Autodesk Revit Complete Training Course 03: Revit Architecture Interior Design Course Course 04: Advanced Revit Architecture Design Course Course 05: Learn AutoCAD Programming using VB.NET Course 06: AutoCAD Programming using VB.NET with Windows Forms Course 07: AutoCAD Programming Using C#.NET Course 08: AutoCAD VBA Programming Course 09: CAD Course Course 10: Landscape Architecture Online Diploma Course Course 11: Innovations in Roofing Technologies Course 12: Architectural Studies Course 13: Architectural & Interior Design: Modern and International Design Course 14: Basics of Revit Architecture Exterior Design Course 15: WELL Building Standard Course 16: Building Surveying Course 17: Construction Industry Scheme (CIS) Course 18: LEED V4 - Building Design and Construction Course 19: Read Construction & Structural Drawing Like Expert Course 20: Construction Management Course 21: Land Surveying Course 22: Site Management Safety Training Scheme (SMSTS) Course 23: Estimation with RSMeans: Construction Estimation Course 24: Lone Worker Safety & Protection Course 25: Time Management The BIM - Building Information Modeling Systems Engineering course has been prepared by focusing largely on BIM - Building Information Modeling Systems Engineering career readiness. It has been designed by our BIM - Building Information Modeling Systems Engineering specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The BIM - Building Information Modeling Systems Engineering Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This BIM - Building Information Modeling Systems Engineering bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This BIM - Building Information Modeling Systems Engineering Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into BIM - Building Information Modeling Systems Engineering Elementary modules, allowing our students to grasp each lesson quickly. The BIM - Building Information Modeling Systems Engineering course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive BIM - Building Information Modeling Systems Engineering bundle, you really hit the jackpot. Here's what you get: Step by step BIM - Building Information Modeling Systems Engineering lessons One to one assistance from BIM - Building Information Modeling Systems Engineeringprofessionals if you need it Innovative exams to test your knowledge after the BIM - Building Information Modeling Systems Engineeringcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five BIM - Building Information Modeling Systems Engineering courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your BIM - Building Information Modeling Systems Engineering certificate and transcript on the next working day Easily learn the BIM - Building Information Modeling Systems Engineering skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This BIM - Building Information Modeling Systems Engineering training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in BIM - Building Information Modeling Systems Engineering Requirements To participate in this BIM - Building Information Modeling Systems Engineering course, all you need is - A smart device A secure internet connection And a keen interest in BIM - Building Information Modeling Systems Engineering Career path You will be able to kickstart your BIM - Building Information Modeling Systems Engineering career because this course includes various courses as a bonus. This Building Information Modeling Systems Engineering is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore BIM - Building Information Modeling Systems Engineering career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

24 Hour Flash Deal **25-in-1 ASP.Net MVC and Entity Framework Mega Bundle** ASP.Net MVC and Entity Framework Enrolment Gifts **FREE PDF Certificate**FREE PDF Transcript ** FREE Exam** FREE Student ID ** Lifetime Access **FREE Enrolment Letter ** Take the initial steps toward a successful long-term career by studying the ASP.Net MVC and Entity Framework package online with Studyhub through our online learning platform. The ASP.Net MVC and Entity Framework bundle can help you improve your CV, wow potential employers, and differentiate yourself from the mass. This ASP.Net MVC and Entity Framework course provides complete 360-degree training on ASP.Net MVC and Entity Framework. You'll get not one, not two, not three, but twenty-five ASP.Net MVC and Entity Framework courses included in this course. Plus Studyhub's signature Forever Access is given as always, meaning these ASP.Net MVC and Entity Framework courses are yours for as long as you want them once you enrol in this course This ASP.Net MVC and Entity Framework Bundle consists the following career oriented courses: Course 01: ASP.Net MVC and Entity Framework Course 02: Building a TodoMVC Application in Vue, React and Angular Course 03: Code Your Own Drawing Application in Android Studio Course 04: Penetration Testing with OWASP ZAP: Mastery course Course 05: Complete Web Development Course 06: Start Your Career as Web Developer Course 07: PHP Web Development with MySQL Course 08: Learn Spring & Angular Material with a Full Web Application Course 09: Node JS: API Development with Swagger Interface Description Language Course 10: Mobile and Web Development with Ionic & Angular JS Course 11: Web Applications for Specialisation on Development Course 12: Secure Programming of Web Applications Course 13: Web Application Penetration Testing Course 14: Web Design with Adobe XD Course 15: Responsive Web Design Course 16: JavaScript Functions Course 17: jQuery Masterclass Course: JavaScript and AJAX Coding Bible Course 18: C Programming Language Course 19: C++ Programming Course 20: Basics of WordPress Course 21: Flutter & Dart Development Course Course 22: Build Progressive Web Apps with Angular Course 23: Learn How To Create a Web App for iPad Course 24: Diploma in Front-End Web Development Course 25: Bash Scripting, Linux and Shell Programming The ASP.Net MVC and Entity Framework course has been prepared by focusing largely on ASP.Net MVC and Entity Framework career readiness. It has been designed by our ASP.Net MVC and Entity Framework specialists in a manner that you will be likely to find yourself head and shoulders above the others. For better learning, one to one assistance will also be provided if it's required by any learners. The ASP.Net MVC and Entity Framework Bundle is one of the most prestigious training offered at StudyHub and is highly valued by employers for good reason. This ASP.Net MVC and Entity Framework bundle course has been created with twenty-five premium courses to provide our learners with the best learning experience possible to increase their understanding of their chosen field. This ASP.Net MVC and Entity Framework Course, like every one of Study Hub's courses, is meticulously developed and well researched. Every one of the topics is divided into ASP.Net MVC and Entity Framework Elementary modules, allowing our students to grasp each lesson quickly. The ASP.Net MVC and Entity Framework course is self-paced and can be taken from the comfort of your home, office, or on the go! With our Student ID card you will get discounts on things like music, food, travel and clothes etc. In this exclusive ASP.Net MVC and Entity Framework bundle, you really hit the jackpot. Here's what you get: Step by step ASP.Net MVC and Entity Framework lessons One to one assistance from ASP.Net MVC and Entity Frameworkprofessionals if you need it Innovative exams to test your knowledge after the ASP.Net MVC and Entity Frameworkcourse 24/7 customer support should you encounter any hiccups Top-class learning portal Unlimited lifetime access to all twenty-five ASP.Net MVC and Entity Framework courses Digital Certificate, Transcript and student ID are all included in the price PDF certificate immediately after passing Original copies of your ASP.Net MVC and Entity Framework certificate and transcript on the next working day Easily learn the ASP.Net MVC and Entity Framework skills and knowledge you want from the comfort of your home CPD 250 CPD hours / points Accredited by CPD Quality Standards Who is this course for? This ASP.Net MVC and Entity Framework training is suitable for - Students Recent graduates Job Seekers Individuals who are already employed in the relevant sectors and wish to enhance their knowledge and expertise in ASP.Net MVC and Entity Framework Requirements To participate in this ASP.Net MVC and Entity Framework course, all you need is - A smart device A secure internet connection And a keen interest in ASP.Net MVC and Entity Framework Career path You will be able to kickstart your ASP.Net MVC and Entity Framework career because this course includes various courses as a bonus. This ASP.Net MVC and Entity Framework is an excellent opportunity for you to learn multiple skills from the convenience of your own home and explore ASP.Net MVC and Entity Framework career opportunities. Certificates CPD Accredited Certificate Digital certificate - Included CPD Accredited e-Certificate - Free CPD Accredited Hardcopy Certificate - Free Enrolment Letter - Free Student ID Card - Free

Duration 5 Days 30 CPD hours This course is intended for This course is intended for individuals who are Application designers and database developers, database administrators and web server administrators. Overview Upon successful completion of this course, students will be able to work with Oracle database programming using the PL/SQL programming language. They will learn the syntax, structure and features of the language. In this course, students will learn the foundation for the programming series and the use of database-resident stored program units for Oracle 12c. Selection & Setup of the Database Interface Considering Available Tools Selecting the Appropriate Tool Oracle Net Database Connections Oracle PAAS Database Connections Setup SQL Developer Setup SQL*Plus Setup Jdeveloper About Bind & Substitution Variables Using SQL Developer Using SQL*Plus Choosing a Database Programming Language What is Database Programming? PL?SQL Performance Advantages Integration wth Other Languages PL/SQL Language Fundamentals PL/SQL Program Structure LANGUAGE SYNTAX RULES EMBEDDING SQL WRITING READABLE CODE GENERATING DATABASE OUTPUT SQL*PLUS INPUT OF A PROGRAM BLOCK Declare Section About the Declare Section DECLARE PRIMITIVE TYPES DECLARATION OPTIONS NOT NULL CONSTANT DATA DICTIONARY INTEGRATION %TYPE DECLARE SIMPLE USER---DEFINED TYPES TYPE... TABLE TYPE... RECORD EXTENDED USER---DEFINED TYPES Begin Section About the Begin Section Manipulating Program Data Logic Control & Branching GOTO LOOP IF-THEN-ELSE CASE Exception Section ABOUT THE EXCEPTION SECTION ISOLATING THE SPECIFIC EXCEPTION PRAGMA EXCEPTION_INIT SQLCODE &SQLERRM Example SQL%ROWCOUNT &SELECT...INTO Beyond the Basics: Explicit Cursors ABOUT EXPLICIT CURSORS EXTENDED CURSOR TECHNIQUES FOR UPDATE OF Clause WHERE CURRENT OF Clause Using FOR?LOOP Cursors Beyond the Basics: Nested BlocksBeyond the Basics: Declared Subprograms USING DECLARED SUBPROGRAMS DECLARED PROCEDURE DECLARED FUNCTION Introducing Databse-Resident Program Units ABOUT DATABASE---RESIDENT PROGRAMS PHYSICAL STORAGE & EXECUTION TYPES OF STORED PROGRAM UNITS STORED PROGRAM UNIT ADVANTAGES MODULAR DESIGN PRINCIPLES Creating Stored Procedures & Functions STORED PROCEDURES & FUNCTIONS CREATE PROCEDURE / CREATE FUNCTION CREATING PROCEDURES & FUNCTIONS RAISE_SALARY() Procedure SALARY_VALID() Function THE PARAMETER SPECIFICATION DEFAULT Clause SYSTEM & OBJECT PRIVILEGES USING THE DEVELOPMENT TOOLS Executing Stored Procedures & Functions CALLING PROCEDURES & FUNCTIONS UNIT TESTING WITH EXECUTE ANONYMOUS BLOCK UNIT TESTING SPECIFYING A PARAMETER NOTATION SQL WORKSHEET UNIT TESTING CALLING FUNCTIONS FROM SQL Maintaining Stored Program Units RECOMPILING PROGRAMS Mass Recompilation Using UTL_RECOMP() DROPPING PROCEDURES & FUNCTIONS DROP PROCEDURE / FUNCTION DATA DICTIONARY METADATA Using USER_OBJECTS Using USER_SOURCE Using USER_ERRORS Using USER_OBJECT_SIZE Using USER_DEPENDENCIES Managing Dependencies DEPENDENCY INTERNALS TRACKING DEPENDENCIES THE DEPENDENCY TRACKING UTILITY SQL DEVELOPER DEPENDENCY INFO DEPENDENCY STRATEGY CHECKLISTS Creating & Maintaining Packages ABOUT PACKAGES CREATING PACKAGES MAINTAINING PACKAGES PERFORMANCE CONSIDERATIONS Advanced Package Capabilities DEFINER & INVOKER RIGHTS WHITE LITS & ACCESSIBLE BY PERSISTENT GLOBAL OBJECTS DEFINING INITIALIZATION LOGIC OBJECT ORIENTATION SUPPORT Advanced Cursor Techniques USING CUSROS VARIABLES USING SYS_REFCURSOR USING CURSOR EXPRESSIONS Using System-Supplied Package DBMS_OUTPUT() UTL_FILE() FOPEN() EXAMPLE Database Trigger Concepts ABOUT DATABASE TRIGGERS DML EVENT TRIGGER SUB---TYPES DATABASE TRIGGER SCENARIO TRIGGER EXECUTION MECHANISMS TRIGGERS WITHIN SQL WORKSHEET Creating Database Triggers STATEMENT-LEVEL TRIGGERS Using RAISE_APPLICATION_ERROR() ROW---LEVEL TRIGGERS EXAMPLES OF TRIGGERS EMPLOYEE_SALARY_CHECK Example EMPLOYEE_JOURNAL Example BUDGET_EVENT Example INSTEAD OF TRIGGERS TRIGGERS WITHIN AN APPLICATION Maintaining Database Triggers CALL SYNTAX TRIGGER MAINTENANCE TASKS SHOW ERRORS TRIGGER DROP TRIGGER ALTER TRIGGER MULTIPLE TRIGGERS FOR A TABLE HANDLING MUTATING TABLE ISSUES Implementing System Event Triggers WHAT ARE SYSTEM EVENT TRIGGERS? DEFININGTHE SCOPE AVAILABLE SYSTEM EVENTS SYSTEM EVENT ATTRIBUTES Additional course details: Nexus Humans Oracle 12c PL/SQL Fundamentals training program is a workshop that presents an invigorating mix of sessions, lessons, and masterclasses meticulously crafted to propel your learning expedition forward. This immersive bootcamp-style experience boasts interactive lectures, hands-on labs, and collaborative hackathons, all strategically designed to fortify fundamental concepts. Guided by seasoned coaches, each session offers priceless insights and practical skills crucial for honing your expertise. Whether you're stepping into the realm of professional skills or a seasoned professional, this comprehensive course ensures you're equipped with the knowledge and prowess necessary for success. While we feel this is the best course for the Oracle 12c PL/SQL Fundamentals course and one of our Top 10 we encourage you to read the course outline to make sure it is the right content for you. Additionally, private sessions, closed classes or dedicated events are available both live online and at our training centres in Dublin and London, as well as at your offices anywhere in the UK, Ireland or across EMEA.