215 Programming Fundamentals courses delivered Online

OVERVIEW This comprehensive course on Master JavaScript with Data Visualization will deepen your understanding on this topic. After successful completion of this course you can acquire the required skills in this sector. This Master JavaScript with Data Visualization comes with accredited certification from CPD, which will enhance your CV and make you worthy in the job market. So enrol in this course today to fast track your career ladder. HOW WILL I GET MY CERTIFICATE? You may have to take a quiz or a written test online during or after the course. After successfully completing the course, you will be eligible for the certificate. WHO IS THIS COURSE FOR? There is no experience or previous qualifications required for enrolment on this Master JavaScript with Data Visualization. It is available to all students, of all academic backgrounds. REQUIREMENTS Our Master JavaScript with Data Visualization is fully compatible with PC's, Mac's, Laptop, Tablet and Smartphone devices. This course has been designed to be fully compatible with tablets and smartphones so you can access your course on Wi-Fi, 3G or 4G. There is no time limit for completing this course, it can be studied in your own time at your own pace. CAREER PATH Learning this new skill will help you to advance in your career. It will diversify your job options and help you develop new techniques to keep up with the fast-changing world. This skillset will help you to- * Open doors of opportunities * Increase your adaptability * Keep you relevant * Boost confidence And much more! COURSE CURRICULUM 11 sections • 76 lectures • 06:21:00 total length •Introduction to Getting Started: 00:02:00 •Course Curriculum: 00:05:00 •How to Get Pre-Requisites: 00:02:00 •Getting Started on Windows, Linux or Mac: 00:01:00 •How to ask a Great Questions: 00:02:00 •FAQ's: 00:01:00 •What is JavaScript: 00:09:00 •Choosing Code Editor: 00:03:00 •Installing Code Editor (Sublime Text): 00:04:00 •Installing Code Editor(Visual Studio Code): 00:07:00 •Hello World Program: 00:14:00 •Getting Output: 00:11:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Internal JavaScript: 00:13:00 •External JavaScript: 00:09:00 •Inline JavaScript: 00:04:00 •Async and defer: 00:06:00 •Variables: 00:13:00 •Data Types: 00:10:00 •Numbers: 00:06:00 •Boolean: 00:04:00 •Arrays(): 00:12:00 •Objects: 00:06:00 •Comments: 00:05:00 •Summary: 00:01:00 •Introduction: 00:02:00 •Strings: 00:06:00 •String Formatting: 00:05:00 •String Methods: 00:12:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Arithmetic operators: 00:07:00 •Assignment operators: 00:03:00 •Comparison operators: 00:06:00 •Logical operators: 00:08:00 •Summary: 00:02:00 •Introduction: 00:02:00 •If statement: 00:04:00 •If-else statement: 00:05:00 •If-else-if statement: 00:04:00 •Switch-case statement: 00:09:00 •Summary: 00:01:00 •Introduction: 00:02:00 •While loop: 00:09:00 •Do-while loop: 00:03:00 •For loop: 00:08:00 •Break: 00:02:00 •Continue: 00:03:00 •Coding Exercise: 00:02:00 •Solution for Coding Exercise: 00:02:00 •Summary: 00:02:00 •Introduction: 00:02:00 •Creating a Function: 00:07:00 •Function Call(): 00:07:00 •Function with parameters: 00:05:00 •Function Bind(): 00:06:00 •Summary: 00:01:00 •Introduction: 00:01:00 •How to Use Google chart script: 00:04:00 •Line Graph chart: 00:14:00 •Scatter plots chart: 00:02:00 •Bar chart: 00:04:00 •Pie chart: 00:02:00 •3D Pie chart: 00:02:00 •Summary: 00:01:00 •Introduction: 00:01:00 •Try-catch: 00:05:00 •Try-catch-finally: 00:17:00 •Summary: 00:01:00 •Introduction: 00:01:00 •On Submit Validation: 00:09:00 •Input Numeric Validation: 00:12:00 •Login Form Validation: 00:05:00 •Password Strength Check Validation: 00:04:00 •Summary: 00:01:00

ABOUT COURSE Master the fundamental building block of the web and learn to create beautiful and functional websites with HTML5. In this comprehensive course, you will learn: * The basics of HTML syntax, including elements, attributes, and tags. * How to structure your web pages using HTML5 semantic elements. * How to add images, videos, and other multimedia content to your websites. * How to create interactive web pages using forms and buttons. * How to style your websites using CSS. This course is perfect for beginners with no prior experience in HTML. However, if you have some programming experience, you will be able to learn the material more quickly. You will learn from an experienced web developer who will teach you the concepts and skills you need to succeed. By the end of this course, you will be able to: * Create and structure web pages using HTML5. * Add multimedia content and interactive elements to your websites. * Style your websites using CSS. Build a portfolio of real-world websites Throughout the course, you will work on a variety of hands-on projects to build your skills and create a portfolio of real-world websites. Join a supportive community of learners You will have access to a dedicated student forum where you can ask questions and get help from the instructor and other students. Enroll today and start your journey to becoming a web developer! Bonus: * Get access to the instructor's personal collection of HTML5 resources. Why learn HTML5? HTML5 is the latest version of HTML, and it is the most widely used markup language in the world. It is used to create the structure and content of web pages. HTML5 is a powerful tool that can be used to create a variety of websites, from simple static pages to complex dynamic applications. Here are some of the benefits of learning HTML5: * HTML5 is easy to learn, even for beginners. * HTML5 is a versatile language that can be used to create a variety of websites. * HTML5 is in high demand, and there are many job opportunities for HTML5 developers. * HTML5 is a valuable skill to have, even if you are not planning to become a web developer. So what are you waiting for? Enroll in this course today and start your journey to becoming a web developer! WHAT WILL YOU LEARN? * Become a modern and confident HTML developer, no prior knowledge needed! * Learn to quickly apply CHatGPT AI skills for your website development * Design and build a stunning real-world project for your portfolio from scratch * A web design framework with easy-to-use rules and guidelines to design eye-catching websites * How to make websites work on every possible mobile device (responsive design) * You will learn quickly prompt engineering skills to make real-world websites * Learn to Publish your website on production servers using FTP app COURSE CONTENT GETTING STARTED * INTRODUCTION TO GETTING STARTED * COURSE CURRICULUM * HOW TO GET PRE - REQUISITES * GETTING STARTED ON WINDOWS, LINUX OR MAC * HOW TO ASK GREAT QUESTIONS * FAQ'S HTML SETTING UP LOCAL ENVIRONMENT * INTRODUCTION TO HTML * CHOOSING CODE EDITOR * INSTALLING CODE EDITOR (SUBLIME TEXT) * OVERVIEW OF A WEBPAGE * STRUCTURE OF A FULL HTML WEBPAGE * FIRST HELLO WORLD WEBPAGE * SUMMARY HTML BASIC * INTRODUCTION * HEADING TAGS * PARAGRAPH * FORMATTING TEXT * LIST ITEMS UNORDERED * LIST ITEMS ORDERED * CLASSES * IDS * COMMENTS * SUMMARY HTML INTERMEDIATE * INTRODUCTION * IMAGES * FORMS * FORM ACTIONS * BR TAG * MARQUEE * TEXT AREA * TABLES * LINKS * NAVBAR - MENU * HTML ENTITIES * DIV TAG * GOOGLE MAPS * SUMMARY HTML ADVANCED * INTRODUCTION * HTML5 AUDIO * HTML5 VIDEO * PROGRESS BAR * DRAG AND DROP * CANVAS * IFRAMES * INPUT TYPES * INPUT ATTRIBUTES * YOUTUBE VIDEO LINKING * CREATING RESPONSIVE PAGE * SUMMARY HTML EXPERT * INTRODUCTION * REGISTRATION FORM * LOGIN FORM * ABOUT US FORM * CONTACT US FORM * FOOTER FORM * INTEGRATE ALL TOGETHER * CODING EXERCISE * SOLUTION FOR CODING EXERCISE * SUMMARY PUBLISH YOUR WEBSITE LIVE * INTRODUCTION * INSTALLING FREE FTP SOLUTION (FILEZILLA) * SETTING UP FTP (FILE TRANSFER PROTOCOL) * PUBLISH WEBSITE TO HOSTING SERVER * SUMMARY HTML WEBSITE PROJECT * INTRODUCTION * CHALLENGE - HTML 5 CLOCK FACE WITH NUMBERS * PROJECT OVERVIEW * CONCLUSION ON PROJECT * SUMMARY A course by Sekhar Metla IT Industry Expert RequirementsNo coding or design experience necessary for this courseAny computer works - Windows, Linux or macOSYou don't need to buy any software - we will use the best free code editor in the world

Master the essentials of C++ programming with our beginner-friendly course. Learn from local setup to advanced functions, and embark on your journey in software development.

Introduce kids and beginners to the world of coding with our Python Programming course. From setting up environments to creating projects, unlock the basics of Python in a fun and interactive way.

Unlock the power of AI with our ChatGPT Tutorial for Beginners. Learn to craft prompts, create content, and enhance your skills with AI text generation.

Master Bing AI from scratch! Dive into practical applications—analyze website links, plan vacations, write CVs, and more, with our beginner-friendly tutorial.

Duration 4 Days 24 CPD hours This course is intended for This course is Intended for students with HTML Experience. Overview At the completion of the course, you will be able to: How PHP works. The basic syntax of PHP. Create dynamic interactive pages with PHP. Manipulate files with PHP. Work with arrays in PHP. Validate forms with PHP. Write functions in PHP. Manipulate and manage database data with PHP. Authenticate users with PHP. Manage sessions with PHP. Work with the MDB2 package. Learn advanced form validation with regular expressions. Send email with PHP. In this PHP training course, students will learn to create database-driven websites using PHP and MySQL or the database of their choice. PHP BASICS * How PHP Works The php.ini File Basic PHP Syntax Variables First PHP Script PHP Operators Creating Dynamic Pages Passing Variables via the Query String FLOW CONTROL * Conditional Processing Working with Conditions Loops Working with Loops ARRAYS * Enumerated Arrays Working with Enumerated Arrays Associative Arrays Working with Associative Arrays Two-dimensional Arrays Array Manipulation Functions PHP AND HTML FORMS * HTML Forms Processing Form Input STRING MANIPULATION * Formatting Strings Working with String Manipulation Functions Magic Quotes REUSING CODE AND WRITING FUNCTIONS * Including Files Adding a Header and Footer User Functions Form Processing Form Validation and Presentation Functions MANAGING DATA * Querying a Database Inserting Records AUTHENTICATION WITH PHP AND SQL * A Database-less Login Form Authenticating Users REGULAR EXPRESSIONS * Perl-compatible Regular Expression Functions Regular Expression Syntax Form Validation Functions with Regular Expressions SESSION CONTROL AND COOKIES * Sessions Cookies Authentication with Session Control SENDING EMAIL WITH PHP * mail() PHPMailer Sending a Password by Email FILE SYSTEM MANAGEMENT * Opening a File Reading from a File Writing to a File Writing to a File File Locking Uploading Files via an HTML Form Getting File Information More File Functions Directory Functions Creating a Resume Management Page

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 BLOCKS BEYOND 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

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 BLOCKS BEYOND 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.

Duration 3 Days 18 CPD hours This course is intended for This course is geared for anyone needing to interface with an Oracle database such as end users, business analysts, application developers and database administrators / DBAs. Overview Working within in a hands-on learning environment, guided by our expert team, attendees will develop a practical approach to Oracle Database Technology. Throughout the course participants will explore: Using PL/SQL programming language for database applications and development incorporating PL/SQL modules within the application architecture from the initial design and planning phase The essentials of building executable PL/SQL program units Each of the major segments of a working program and how these interact with each other during program execution Important error or exception handling capabilities of the language. How database-resident program units can be used as part of the overall database application architecture Applying these new skills to the development of PL/SQL packages. Advanced database programming capabilities and benefits How database triggers can be used as part of an advanced database application design Oracle 19c PL/SQL Fundamentals is a three-day, hands-on course that introduces Oracle database programming using the PL/SQL programming language. Throughout the course students will explore the core syntax, structure and features of the language. This course will also lay the foundation for the entire Oracle PL/SQL programming series, allowing one to progress from introductory topics to advanced application design and programming and finally onto writing complex high-performance applications. The course also explores applying the newly learned skills to the development of database applications. Participants will learn how to use database-resident stored program units such as procedures, functions, packages and database triggers. Students will also learn about the latest features in Oracle 19c. 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 and Substitution Variables * Using SQL Developer * Using SQL *Plus CHOOSING A DATABASE PROGRAMMING LANGUAGE * What is Database Programming * PL/SQL Programming * PL/SQL Performance Advantages * Integration with Other Languages PL/SQL LANGUAGE ESSENTIALS * PL/SQL Program Structure * Language Syntax Rules * Embedding SQL * Writing Readable Code * Generating Readable Code * Generating Database Output * SQL * Plus Input of 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 & Braching * 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 * Extend Cursor Techniques * For Update of Clause * Where Current of Clause * Using for ? Loop Cursors INTRODUCTION DATABASE RESIDENT PROGRAMMING UNITS * About Database ? Resident Programs * Physical Storage & Execution * Types of Stored Program Units * Stored Program Unit Advantages * Modular Design Principles CREATING STORED PROCEDURES AND 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 AND 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 PROGRAMMING UNITS * Recompiling Programs * Mass Recompilation Using UTL_RECOMP() * Dropping Procedures & Functions * Drop 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 * About Packages * Creating Packages * Maintaining Packages * Performance Considerations ADVANCED PACKAGE CAPABILITIES * Definer & Invoker Rights * White Lists & Accessible By * Persistent Global Objects * Defining Initilization Logic * Object Orientation Support ADVANCED CURSOR TECHNIQUES * Using Cursor Variables * Using SYS_REFCURSOR * Using Cursor Expressions USING SYSTEM SUPPLIED PACKAGES * DBMS_OUTPUT() * UTL_FILE() * FOPEN() Example DATABASE TRIGGER CONCEPTS * About Database Triggers * DML Event Trigger Sub-Types * Database Trigger Scenario * Trigger Exhaustion Mechanisms * Trigger 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 and 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 * Defining the Scope * Available System Events * System Event Attributes