51 Database Programming courses

Duration 2 Days 12 CPD hours This course is intended for This course is designed for people who need output from a database. In some cases, database programs have limited reporting tools, or tools that are not accessible. Learners may or may not have programming or SQL experience. Overview In this course, you will connect to a database to extract data and present it as a report. You will: Identify the elements of the Crystal Reports interface. Create and modify a basic report. Use formulas to calculate and filter data. Build a parameterized report. Group report data. Enhance a report. Create a report using data from an Excel workbook. Distribute data. In this course, students will create a basic report by connecting to a database and modifying the report's presentation. 1 - EXPLORING THE CRYSTAL REPORTS INTERFACE * Topic A: Explore Crystal Reports * Topic B: Use Crystal Reports Help * Topic C: Customize Report Settings 2 - WORKING WITH REPORTS * Topic A: Create a Report * Topic B: Modify a Report * Topic C: Display Specific Report Data * Topic D: Work with Report Sections 3 - USING FORMULAS IN REPORTS * Topic A: Create a Formula * Topic B: Edit a Formula * Topic C: Filter Data by Using a Formula * Topic D: Work with Advanced Formulas and Functions * Topic E: Handle Null Values 4 - BUILDING PARAMETERIZED REPORTS * Topic A: Create a Parameter Field * Topic B: Use a Range Parameter in a Report * Topic C: Create a Prompt 5 - GROUPING REPORT DATA * Topic A: Group Report Data * Topic B: Modify a Group Report * Topic C: Group by Using Parameters * Topic D: Create a Parameterized Top N Report 6 - ENHANCING A REPORT * Topic A: Format a Report * Topic B: Insert Objects in a Report * Topic C: Suppress Report Sections * Topic D: Use Report Templates 7 - CREATING A REPORT FROM EXCEL DATA * Topic A: Create a Report Based on Excel Data * Topic B: Modify a Report Generated from Excel Data * Topic C: Update Data in a Report Based on Excel Data 8 - DISTRIBUTING DATA * Topic A: Export Data * Topic B: Create Mailing Labels 9 - APPENDIX * Appendix A: Setting Up and Configuring Data Sources * Appendix B: Using Report Processing Techniques * Appendix C: Using Functions in Formulas

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.

COMPLETE VB.NET TRAINING COURSE DESCRIPTION A hands on introduction to programming in Visual BASIC .Net. WHAT WILL YOU LEARN * Build Visual BASIC applications. * Build simple components * Debug Visual BASIC programs. * Examine existing code and determine its function. COMPLETE VB.NET TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to program in Visual BASIC. Anyone wishing to build Windows based applications. * Prerequisites: None although experience in another high level language would be useful. * Duration 5 days COMPLETE VB.NET TRAINING COURSE CONTENTS * Writing your first program Visual Studio, forms designer, running VB programs, the UI, properties, writing the code. * Toolbox Controls Basic use, input controls, ActiveX controls. * Menus and Dialog Boxes Menus, Dialog Box controls, event procedures. * Visual Basic .NET variables and operators Variables, I/O, data types, constants, operators, Math Methods, precedence. * Decision Structures and Loops and Timers Event-Driven programming, If…Then, Select Case, For…Next Loops, Timer Control. * Debugging Visual Basic .NET Programs Break Mode, watch & command windows. * Structured Error Handling Try...Catch, Finally, Err Object, retry periods. * Modules and Procedures Standard modules, public variables, procedures. * Arrays and Collections to Manage Data Fixed-Size & dynamic Arrays, ReDim Preserve, object collections, Controls Collection. * Text Files and String Processing Text Box object, Text String methods, sorting. * Automating Office Applications Application objects, automation in VB, the Object Browser, the Process Component. * Deploying Visual Basic .NET Applications Planning a deployment, ways to deploy an application, deployment projects, options. * Managing Windows Forms Forms, positioning, manipulation, adding controls, organizing controls, Startup Object. * Adding Graphics and Animation Effects System.Drawing namespace, coordinates, SystemPaint Event, animation, transparency. * Inheriting Forms and Creating Base Classes Inheriting forms, inheritance picker, base classes and inheritance, classes in projects. * Working with Printers PrintDocument class, Text Box object, Print Preview and Page Setup Dialog Boxes. * Database programming with ADO.NET Databases, ADO.NET, Data Adapters, Datasets, Bound & Navigation Controls. Displaying database records, formatting DataGrid cells, updating the database. * Displaying HTML Documents Using IE IE Object, Internet Controls, IE Events. * Web Forms for Interactive Web Applications ASP.NET, Web Forms vs. Windows Forms, HTML controls, web applications, event procedures for web forms controls.

In this comprehensive course, you will learn everything you need to know about SQL and Microsoft SQL Server, from the basic to advanced topics. With easy-to-follow lessons and hands-on exercises, you will gain the skills and confidence to work with databases like a pro. Perfect for beginners and anyone looking to expand their data management skills.

COMPLETE PYTHON TRAINING COURSE DESCRIPTION Python is an agile, robust, expressive, fully objectoriented, extensible, and scalable programming language. It combines the power of compiled languages with the simplicity and rapid development of scripting languages. This course covers Python from the very basics of 'hello world!' through to object oriented programming and advanced topics such as multi threading. Hands on follows all the major sections in order to reinforce the theory. WHAT WILL YOU LEARN * Read Python programs. * Write Python programs. * Debug Python programs. * Use Python's objects and memory model as well as its OOP features. COMPLETE PYTHON PROGRAMMING TRAINING COURSE DETAILS * Who will benefit: Anyone wishing to learn Python. * Prerequisites: None. * Duration 5 days COMPLETE PYTHON PROGRAMMING TRAINING COURSE CONTENTS * Welcome to Python: What is Python? Origins, features. Downloading and installing Python, Python manuals, comparing Python, other implementations. * Getting started: Program output, the print statement, "hello world!", Program input, raw_input(), comments, operators, variables and assignment, numbers, strings, lists and tuples, dictionaries, indentation, if statement, while Loop, for loop. range(), list comprehensions. Files, open() and file() built-in functions. Errors and exceptions. Functions, Classes, Modules, useful functions. * Python basics: Statements and syntax, variable assignment, identifiers, basic style guidelines, memory management, First Python programs, Related modules/developer tools. * Python Objects: Other built-in types, Internal Types, Standard type operators, Standard type built-in functions, Categorizing standard types, Unsupported types. * Numbers: Integers, Double precision floating point numbers, Complex numbers, Operators, Built-in and factory functions, Other numeric types. * Sequences: strings, lists, and tuples: Sequences, Strings, Strings and operators, String-only operators, Built-in functions, String built-in methods, Special features of strings, Unicode, Summary of string highlights, Lists, Operators, Built-in functions, List type built-in methods, Special features of lists, Tuples, Tuple operators and built-in functions, Tuples special features, Copying Python objects and shallow and deep copies. * Mapping and set types: Mapping Type: dictionaries and operators, Mapping type built-in and factory functions, Mapping type built-in methods, Dictionary keys, Set types, Set type operators, Built-in functions, Set type built-in methods. * Conditionals and loops: If, else and elif statements, Conditional expressions, while, for, break, continue and pass statements, else statement . . . take two, Iterators and iter(), List comprehensions, Generator expressions. * Files and input/output: File objects, File built-in functions [open() and file()], File built-in methods and attributes, Standard files, Command-line arguments, File system, File execution, Persistent storage modules. * Errors and exceptions: What are exceptions? Detecting and handling exceptions, Context management, Exceptions as strings, Raising exceptions, Assertions, Standard exceptions, Creating Exceptions, Why exceptions, Exceptions and the sys module. * Functions: Calling, creating and passing functions, formal arguments, variable-length arguments, functional programming, Variable scope, recursion, generators. * Modules: Modules and files, Namespaces, Importing modules, Module import features, Module built-in functions, Packages, Other features of modules. * Object-Oriented Programming (OOP): Classes, Class attributes, Instances, Instance attributes, Binding and method invocation, Static methods and class methods, Composition, Sub-classing and derivation, Inheritance, Built-in functions for classes, and other objects, Customizing classes with special methods, Privacy, Delegation, Advanced features of new-style classes (Python 2.2+), Related modules and documentation. * Execution environment: Callable and code Objects, Executable object statements and built-in functions, Executing other programs. 'Restricted' and 'Terminating' execution, operating system interface. * Regular expressions: Special symbols and characters, REs and Python, Regular expressions example. * Network programming: Sockets: communication endpoints, Network programming in Python, SocketServer module, Twisted framework introduction. * Internet client programming: What are internet clients? Transferring files, Network news, E-mail. * Multithreaded Programming: Threads and processes Python, threads, and the global interpreter lock, The thread and threading Modules. * GUI programming: Tkinter and Python programming, Tkinter Examples, Brief tour of other GUIs. * Web programming: Web surfing with Python: creating simple web clients, Advanced Web clients, CGI: helping web servers process client data, Building CGI applications, Using Unicode with CGI, Advanced CGI, Web (HTTP) Servers. * Database programming: Python database application programmer's interface (DB-API), ORMs. * Miscellaneous Extending Python by writing extensions, Web Services, programming MS Office with Win32 COM, Python and Java programming with Jython.

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

Duration 4.375 Days 26.25 CPD hours This course is intended for The target audience for this course is all Oracle professionals. Among the specific groups for whom this course will be helpful are: Application designers and database developers Database administrators Web server administrators Overview This eTextbook begins with an explanation of the intent and usage of the PL/SQL programming language for database applications. Important reasons why one should incorporate PL/SQL modules within the application architecture right from the initial design and planning phase are presented. Next one learns how to begin building executable PL/SQL program units. One learns about each of the major segments of a working program and how these interact with each other during program execution, including the important error or exception handling capabilities of the language. The final section goes beyond the basics and begins to explore advanced topics that will be useful later in the Sideris Oracle PL/SQL developer textbook series. One learns techniques and features that allow modular and reusable programs to be developed, increasing productivity and maintainability of database applications. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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. his eTextbook introduces one to Oracle database programming using the PL/SQL programming language. One will learn the syntax, structure and features of the language. This textbook will also lay the foundation for the entire Sideris 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.

MySQL: Learn how to use MySQL and PHP to build reports and work with databases for web applications

Learn to use SQLite databases with Python through a hands-on approach