15 Database Programming courses delivered Live Online

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.

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.

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 2 Days 12 CPD hours This course is intended for This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education. Overview List and describe the major components of IBM's relational database, DB2 Explain the characteristics of a DB2 table Relate the basic concepts of data modeling Comprehend the processing instructions given to DB2 via simple SQL statements List and describe several ways to build (write) and execute SQL statements List and describe steps needed to imbed SQL statements in an application program Explain some of the functions performed by, and the responsibilities of, database and system administrators Establish a base for more specialized DB2 education This course provides information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms (e.g., z/OS, VM, Linux, UNIX, Windows, etc.) UNDERSTANDING A TABLE * Identify the advantages of a relational database Define a relation Name the language used to talk to a relational database manager (RDBM) List three characteristics assigned to each column Define the tasks performed by DB2 when running an application Defi DATA MODELING AND DATABASE DESIGN * State the purpose of a business model Identify an Entity-Relational Diagram (ERD) model List several DB2 column data types Identify non-standard column and table names Identify the characteristics of a primary key and a foreign key State the purpose of re HOW DOES A USER USE DB2? * List several ways to talk to DB2 List multiple ways to generate an SQL statement List several ways to ADD, REMOVE, or CHANGE table rows List several ways to READ data and produce reports HOW DOES A PROGRAMMER USE DB2? * List the steps needed to create a test environment List the necessary steps to coding SQL in a program Describe the purpose of SQL delimiters Describe the purpose of an SQLCA List the steps involved in preparing a program for execution State the differenc WHAT DOES AN ADMINISTRATOR DO IN DB2? * List some of the tasks performed by a DB2 System Administrator: Identifying the DB2 product, Installing DB2, Creating subsystems/instances, databases and table spaces, Authorizing, and Monitoring List some of the tasks performed by a DB2 Database Administ INFORMATION MANAGEMENT WITH DB2 * List several planning considerations for distributing data List some of the skills required to successfully distribute data Differentiate between remote unit of work, distributed unit of work, and distributed request List some of the security concerns whe

Duration 5 Days 30 CPD hours This course is intended for The target audience for this textbook is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this textbook will be helpful are: ? Business and non-IT professionals ? Application designers and database developers ? Business Intelligence (BI) analysts and consumers ? Database administrators ? Web server administrators Overview The first portion of this textbook considers the logical models upon which a relational database is based and the various configurations and environments in which you may work with the Oracle database. The next segment focuses on the actual SQL syntax for writing database queries. You will begin with the simplest of queries and then proceed onto moderately complex query scenarios. Finally, this textbook covers the DDL, DML and transaction control portions of the SQL language that allow one to create, maintain and manipulate application database objects and application data. This textbook takes a unique approach to SQL training in that it incorporates data modeling theory, relational database theory, graphical depictions of theoretical concepts and numerous examples of actual SQL syntax into one learning vehicle. RELATIONAL DATABASES & DATA MODELS * About Data Models * About the Relational Model * The Electronics Data Model * About the Relational DBMS 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 USING THE DATABASE INTERFACE * About Bind & Substitution Variables * Using SQL Developer * Using SQL*Plus INTRODUCTION TO THE SQL LANGUAGE * About the SQL Language * Characteristics of SQL * Introducing SQL Using Select * SQL Rules THE SELECT STATEMENT * The Select Statement * Distinct/Unique Keyword * Using Alias Names RESTRICTING RESULTS WITH THE WHERE CLAUSE * About Logical Operators * Equality Operator * Boolean Operators * REGEXP_LIKE() * In Operator SORTING DATA WITH THE ORDER BY CLAUSE * About the Order by Clause * Multiple Column Sorts * Specify the Sort Sequence * About Null Values within Sorts * Using Column Aliases PSEUDO COLUMNS, FUNCTIONS & TOP-N QUERIES * Rowid Pseudo Column * ORA_ROWSCN PSEUDO Column * ROWNUM Pseudo Column * About the Built-In Functions * SYSDATE * User & UID * SESSIONTIMEZONE Function * Using the Dual Table * Row Limiting & Top-N Queries * FETCH First x Rows Only Clause * OFFSET x Rows Clause * FETCH?PERCENT Clause * The WITH TIES Option JOINING TABLES * About Joins * Inner Joins * Reflexive Join * Non-Key Join * Outer Join USING THE SET OPERATORS * About the Set Operators * SQL Set Operator Examples * UNION Example * INTERECT Example * MINUS Example * UNION All SUMMARY FUNCTIONS USING SUB-QUERIES * Finding Data with Sub-Queries * Standard Sub-Queries * Correlated Sub-Queries * The EXISTS Operator AGGREGATING DATA WITHIN GROUPS * About Summary Groups * Find Groups within the Tables * Select Data From the Base Tables * Select Groups from the Results USE DDL TO CREATE & MANAGE TABLES * Create Table Statement * Column Data Types * Not Null * Default * Describe * Alter Table Statement * Drop Table Statement * Table DDL Using SQL Developer * Alter User Statement * Alter Session Statement * NLS_Language * NLS_Date USE DML TO MANIPULATE DATA * The Insert Statement * The Delete Statement * The Update Statement * About Transactions * Transaction Rollback * Transaction Commit * Transaction Savepoint * The Set Transaction Statement * Set Transaction Read Only Statement Rules UNDERSTANDING THE DATA MODELS * The Company Data Model * The Electronics Data Model ABOUT THE SQL-99 STANDARD * SQL-92 & SQL-99 * Cross Joins * Natural Joins * Inner Joins * Implicit Inner Join * Outer Joins * Anti Joins * Named Sub-Queries * ENHANCING GROUPS WITH ROLLUP & CUBE * Using Rollup * The Grouping() Function * Using Cube SQL FUNCTIONS: CHARACTER HANDLING * What are the SQL Functions? * String Formatting Functions * UPPER(), LOWER() Example * INITCAP() Example * Character Codes Functions * CHR((), ASCII() Examples * PAD & TRIM Functions * RPAD() Example * RTRIM() Example * TRIM() Example * String Manipulation Functions * DECODE () Example * SUBSTR() Example * INSTR() Example * TRANSLATE() Example * REPLACE() Example * String Comparison Functions * LEAST() Example * Phonetic Search Function * SOUNDEX() Example SQL FUNCTIONS: NUMERIC HANDLING * About the Numeric Data Functions * GREATEST() Example * ABS() Example * ROUND() Example * TRUNC() Example * SIGN() Example * TO_NUMBER() Example & Data ype Conversions * NULL VALUES FUNCTIONS * NVL() & NVL2() Function * NVL() Example (Character) * NVL() Example (Numeric Loss of Data) * NVL() Example (Numeric Output) * NVL2() Example * COALESCE() Function * NULLIF() Function SQL FUNCTIONS: DATE HANDLING * Date Formatting Functions * TO_CHAR() & TO_DATE() Format Patterns * TO_CHAR() Examples * TO_DATE() Examples * EXTRACT() Example * Date Arithmetic Functions * MONTHS_BETWEEN() Example * ADD_MONTHS() Example * LAST_DAY() Example * NEXT_DAY() Example * TRUNC(), ROUND() Dates Example * NEW_ TIME() Example * About V$TIMEZONE_NAMES * CAST() FUNCTION & TIME ZONES DATABASE OBJECTS: ABOUT DATABASE OBJECTS * About Database Objects * About Schemas * Making Object References DATABASE OBJECTS: RELATIONAL VIEWS * About Relations Views * The Create View Statement * Why Use Views? * Accessing Views with DML * Maintaining View Definitions * Alter View * Drop View * DDL Using SQL Developer * DATABASE OBJECTS: INDEXES * About Indexes * Create & Drop Index Statements * Indexes & Performance * Data Dictionary Storage DATABASE OBJECTS: CREATING OTHER OBJECTS * About Sequences * Referencing NEXTVAL * Referencing CURRVAL * Within the DEFAULT Clause * Alter Sequence & Drop Sequence * ALTER SEQUENCE * DROP SEQUENCE * About Identity Columns * CREATE TABLE?GENERATED AS IDENTITY * ALTER TABLE?GENERATED AS IDENTITY * Start With Limit Value * ALTER TABLE...DROP IDENTITY * About Synonyms * CREATE & DROP SYNONYM Statements * CREATE SYNONYM * DROP SYNONYM * Public Vs Private Synonyms * CREATE SCHEMA AUTHORIZATION DATABASE OBJECTS: OBJECT MANAGEMENT USING DDL * The RENAME Statement * TABLESPACE Placement * CREATE TABLE?TABLESPACE * The Comment Statement * The TRUNCATE TABLE Statement DATABASE OBJECTS: SECURITY * About Object Security * Grant Object Privileges * Revoke Object Privileges * Object Privileges & SQL Developer DATA INTEGRITY USING CONSTRAINTS * About Constraints * NOT NULL Constraint * NOT NULL Example * CHECK Constraint * UNIQUE Constraint * PRIMARY KEY Constraint * REFERENCES Constraint * ON DELETE CASCADE Example * ON DELETE SET NULL Example * Constraints on Existing Tables * Constraints & SQL Developer MANAGING CONSTRAINT DEFINITIONS * RENAMING & DROPPING Constraints * ENABLING & DISABLING Constraints * DEFERRED Constraint Enforcement * SET CONSTRAINTS * Handling Constraint Exceptions * Constraints with Views * DATA Dictionary Storage THE DATA DICTIONARY STRUCTURE * More About the Data Dictionary * OBJECT-SPECIFIC Dictionary Views * USER_UPDATABLE_COLUMNS * The Dictionary Structure * METADATA & SQL Developer ADDITIONAL COURSE DETAILS: Nexus Humans Oracle 12c 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 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 is an introductory- level course appropriate for those who are developing applications using relational databases, or who are using SQL to extract and analyze data from databases and need to use the full power of SQL queries. Overview This course combines expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our expert practitioner, attendees will learn to: Maximize the potential of SQL to build powerful, complex and robust SQL queries Query multiple tables with inner joins, outer joins and self joins Construct recursive common table expressions Summarize data using aggregation and grouping Execute analytic functions to calculate ranks Build simple and correlated subqueries Thoroughly test SQL queries to avoid common errors Select the most efficient solution to complex SQL problems A company?s success hinges on responsible, accurate database management. Organizations rely on highly available data to complete all sorts of tasks, from creating marketing reports and invoicing customers to setting financial goals. Data professionals like analysts, developers and architects are tasked with creating, optimizing, managing and analyzing data from databases ? with little room for error. When databases aren?t built or maintained correctly, it?s easy to mishandle or lose valuable data. Our SQL Programming and Database Training Series provides students with the skills they require to develop, analyze and maintain data and in correctly structured, modern and secure databases. SQL is the cornerstone of all relational database operations. In this hands-on course, you learn to exploit the full potential of the SELECT statement to write robust queries using the best query method for your application, test your queries, and avoid common errors and pitfalls. It also teaches alternative solutions to given problems, enabling you to choose the most efficient solution in each situation. INTRODUCTION: QUICK TOOLS REVIEW * Introduction to SQL and its development environments * Using SQL*PLUS * Using SQL Developer USING THE SQL SELECT STATEMENT * Capabilities of the SELECT statement * Arithmetic expressions and NULL values in the SELECT statement * Column aliases * Use of concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword * Use of the DESCRIBE command RESTRICTING AND SORTING DATA * Limiting the Rows * Rules of precedence for operators in an expression * Substitution Variables * Using the DEFINE and VERIFY command SINGLE-ROW FUNCTIONS * Describe the differences between single row and multiple row functions * Manipulate strings with character function in the SELECT and WHERE clauses * Manipulate numbers with the ROUND, TRUNC and MOD functions * Perform arithmetic with date data * Manipulate dates with the date functions CONVERSION FUNCTIONS AND EXPRESSIONS * Describe implicit and explicit data type conversion * Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions * Nest multiple functions * Apply the NVL, NULLIF, and COALESCE functions to data * Decode/Case Statements USING THE GROUP FUNCTIONS AND AGGREGATED DATA * Group Functions * Creating Groups of Data * Having Clause * Cube/Rollup Clause SQL JOINS AND JOIN TYPES * Introduction to JOINS * Types of Joins * Natural join * Self-join * Non equijoins * OUTER join USING SUBQUERIES * Introduction to Subqueries * Single Row Subqueries * Multiple Row Subqueries USING THE SET OPERATORS * Set Operators * UNION and UNION ALL operator * INTERSECT operator * MINUS operator * Matching the SELECT statements USING DATA MANIPULATION LANGUAGE (DML) STATEMENTS * Data Manipulation Language * Database Transactions * Insert * Update * Delete * Merge USING DATA DEFINITION LANGUAGE (DDL) * Data Definition Language * Create * Alter * Drop DATA DICTIONARY VIEWS * Introduction to Data Dictionary * Describe the Data Dictionary Structure * Using the Data Dictionary views * Querying the Data Dictionary Views * Dynamic Performance Views CREATING SEQUENCES, SYNONYMS, INDEXES * Creating sequences * Creating synonyms * Creating indexes * Index Types CREATING VIEWS * Creating Views * Altering Views * Replacing Views MANAGING SCHEMA OBJECTS * Managing constraints * Creating and using temporary tables * Creating and using external tables RETRIEVING DATA USING SUBQUERIES * Retrieving Data by Using a Subquery as Source * Working with Multiple-Column subqueries * Correlated Subqueries * Non-Correlated Subqueries * Using Subqueries to Manipulate Data * Using the Check Option * Subqueries in Updates and Deletes * In-line Views DATA CONTROL LANGUAGE (DCL) * System privileges * Creating a role * Object privileges * Revoking object privileges MANIPULATING DATA * Overview of the Explicit Default Feature * Using multitable INSERTs * Using the MERGE statement * Tracking Changes in Data