Detailed Course Outline
Module 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 utilities