U4181SHPHPHP-U4181S1.0<h5>At the conclusion of this course you should be able to:</h5> <ul> <li>Understand relational database concepts and terminology</li></ul><h5>At the end of this course students will learn: </h5><ul> <li>Relational database concepts and terminology</li><li>HPE NonStop SQL/MP components</li><li>HPE NonStop SQL/MP database structures</li><li>HPE NonStop SQL/MP conversational interface</li><li>HPE NonStop SQL/MP queries</li><li>HPE NonStop SQL/MP database object creation and management</li></ul><ul> <li>U4147S: Concepts and Facilities for HPE NonStop Systems</li></ul><ul> <li>Anyone working with or interested in the HPE NonStop SQL/MP product</li><li>Anyone responsible for managing or designing a database or developing embedded SQL programs</li></ul><h5>Module 1 - Relational Database Definitions </h5><ul> <li>Flat-file systems and relational database management systems (RDMBS)</li><li>Components of a relational table</li><li>Relational database structure</li><li>Primary and foreign keys in a relational table</li><li>Different types of relationships</li><li>How relationships are formed in a relational database</li></ul><h5>Module 2 - SQL/MP Physical Architecture </h5><ul> <li>Characteristics and functions of NonStop SQL/MP objects</li><li>Function and important aspects of each of the objects</li></ul><p> Module 3 - NonStop SQL/MP Process Architecture </p> <ul> <li>Characteristics and functions of NonStop SQL/MP processes</li><li>Function and important aspects of each of the processes</li><li>Overall data flow</li></ul><h5>Module 4 - NonStop SQL/MP - The SQL Language </h5><ul> <li>Standard types of SQL statements and their functions</li></ul><h5>Module 5 - NonStop SQL/MP Conversational Interface </h5><ul> <li>Setting up an SQLCI session</li><li>Standard SQLCI commands</li><li>Ad hoc query processing</li><li>SQLCI Report Writer</li></ul><h5>Module 6 - Generating Queries for Single Tables</h5> <ul> <li>Core syntax, structure, and function of an SQL query</li></ul><h5>Module 7 - Generating Queries Against Multiple Tables </h5><ul> <li>Concept of a &ldquo;join&rdquo;</li><li>Simple join examples</li><li>How joining works and how to work through a join</li></ul><h5>Module 8 - SQL Subqueries </h5><ul> <li>Concept of a subquery</li><li>Two types of subqueries</li><li>Syntax of subqueries</li></ul><h5>Module 9 - Creating a NonStop SQL/MP Database </h5><ul> <li>Catalog</li><li>Table</li><li>Partition</li><li>Index</li><li>Constraint</li><li>View</li><li>Comment</li><li>Collation</li></ul><h5>Module 10 - Creating Rows and Loading a NonStop SQL/ MP Database </h5><ul> <li>Referential integrity</li><li>How to use the INSERT statement</li><li>SQL utilities, CONVERT, COPY, and LOA</li></ul><h5>Module 11 - Modifying Database Data </h5><ul> <li>Business transactions and Transaction Control Language (TCL) SQL commands</li><li>SQL UPDATE and DELETE commands</li><li>Locking mechanisms</li></ul><h5>Module 12 - NonStop SQL Management Functions </h5><ul> <li>Introduction to managing an SQL/MP database</li><li>Syntax to alter or drop a NonStop SQL/MP object</li><li>Impact and considerations to alter or drop SQL objects in the database</li><li>Security issues related to adding, altering, or dropping an SQL object from the database</li><li>Object dependencies &bull; SQLCI and NonStop kernel utilities</li></ul>At the conclusion of this course you should be able to: - Understand relational database concepts and terminology At the end of this course students will learn: - Relational database concepts and terminology - HPE NonStop SQL/MP components - HPE NonStop SQL/MP database structures - HPE NonStop SQL/MP conversational interface - HPE NonStop SQL/MP queries - HPE NonStop SQL/MP database object creation and management- U4147S: Concepts and Facilities for HPE NonStop Systems- Anyone working with or interested in the HPE NonStop SQL/MP product - Anyone responsible for managing or designing a database or developing embedded SQL programsModule 1 - Relational Database Definitions - Flat-file systems and relational database management systems (RDMBS) - Components of a relational table - Relational database structure - Primary and foreign keys in a relational table - Different types of relationships - How relationships are formed in a relational database Module 2 - SQL/MP Physical Architecture - Characteristics and functions of NonStop SQL/MP objects - Function and important aspects of each of the objects Module 3 - NonStop SQL/MP Process Architecture - Characteristics and functions of NonStop SQL/MP processes - Function and important aspects of each of the processes - Overall data flow Module 4 - NonStop SQL/MP - The SQL Language - Standard types of SQL statements and their functions Module 5 - NonStop SQL/MP Conversational Interface - Setting up an SQLCI session - Standard SQLCI commands - Ad hoc query processing - SQLCI Report Writer Module 6 - Generating Queries for Single Tables - Core syntax, structure, and function of an SQL query Module 7 - Generating Queries Against Multiple Tables - Concept of a “join” - Simple join examples - How joining works and how to work through a join Module 8 - SQL Subqueries - Concept of a subquery - Two types of subqueries - Syntax of subqueries Module 9 - Creating a NonStop SQL/MP Database - Catalog - Table - Partition - Index - Constraint - View - Comment - Collation Module 10 - Creating Rows and Loading a NonStop SQL/ MP Database - Referential integrity - How to use the INSERT statement - SQL utilities, CONVERT, COPY, and LOA Module 11 - Modifying Database Data - Business transactions and Transaction Control Language (TCL) SQL commands - SQL UPDATE and DELETE commands - Locking mechanisms Module 12 - NonStop SQL Management Functions - Introduction to managing an SQL/MP database - Syntax to alter or drop a NonStop SQL/MP object - Impact and considerations to alter or drop SQL objects in the database - Security issues related to adding, altering, or dropping an SQL object from the database - Object dependencies • SQLCI and NonStop kernel utilities4 Tage3000.003600.003000.00