Introduction to the Actian Product and Actian SQL (self-paced)

Introduction to the Actian Product and Actian SQL (self-paced)

This course provides a tour of the principal Actian database features along with insight into best practice use of the Actian SQL language.

Cancel Apply

rate limit

Code not recognized.

About this course

At the end of this course you will be able to:

  • Understand the principles and importance of Relational Databases
  • Explore each of the principal Actian database and development tools
  • Understand the principles and importance of industrial-strength SQL
  • Make full use of all the retrieval features of Actian SQL
  • Make full use of all the data-change features of Actian SQL
  • Make full use of all the database-management features of Actian SQL
  • Make full use of Actian Database Procedures, Rules, Events, Integrity features

This course provides you with all the knowledge and skill you need to:

  • use Actian SQL in your batch interfaces, reporting, ad-hoc querying, applications
  • undertake the Actian Application Development and Database Management courses
  • understand and assess the role of Actian in your organization.

Curriculum283 min

  • Course Objective
  • Course Admin
  • Activities
  • Activity Setup Instructions
  • Define the Terminal Type for using Forms-based Utilities in the Course Activities 1 min
  • Relational Concepts and Actian X
  • Relational Concepts and Ingres 6 min
  • Knowledge Builder
  • Check your Knowledge
  • X100 Concepts
  • X100 Concepts 4 min
  • Knowledge Builder
  • Check your Knowledge
  • Character-Based Database Tools
  • ISQL, SQL and Help Statement 5 min
  • Tables, QBF and RBF 4 min
  • Activity - Character-based Database Tools
  • Activity Solution - Character-based Database Tools
  • Knowledge Builder
  • Check your Knowledge
  • Visual Tools
  • Visual Tools 6 min
  • Activity - Visual Tools
  • Activity Solution - Visual Tools
  • Knowledge Builder
  • Check your Knowledge
  • Application Development Tools
  • User Interfaces 5 min
  • Drivers and Access Tools
  • Knowledge Builder
  • Check you Knowledge
  • Controlling Output
  • Simple Queries 6 min
  • SQL Data Types 5 min
  • JSON Data Part 1
  • JSON Data Part 2 10 min
  • Literals NULLs Conversions 4 min
  • Formatting Characters Numeric Data and Dates 3 min
  • CASE Statement 3 min
  • Activity - Controlling Output
  • Activity Solution - Controlling Output
  • Knowledge Builder
  • Check your Knowledge
  • Restricting Rows
  • Restricting rows using the WHERE Clause 3 min
  • Multiple Conditions 5 min
  • Pattern Matching 3 min
  • Activity - Restricting Rows
  • Activity Solution - Restricting Rows
  • Knowledge Builder
  • Check your Knowledge
  • Joining Tables
  • Why Join Tables 4 min
  • Inner Joins 6 min
  • Joining multiple tables and other types of joins 5 min
  • Activity - Joining Tables
  • Activity Solution - Joining Tables
  • Knowledge Builder
  • Check your Knowledge
  • SQL Functions
  • Scalar Functions 3 min
  • Conversion Functions 7 min
  • Aggregate Functions 2 min
  • Aggregate Function Restrictions 4 min
  • Pivot Tables 5 min
  • User Defined Functions 6 min
  • Analytical Functions for Standard Deviation and Variance 4 min
  • Activity - SQL Functions
  • Activity Solution - SQL Functions
  • Knowledge Builder
  • Check your Knowledge
  • Subqueries
  • Subqueries in the WHERE Clause 6 min
  • Subqueries in the FROM clause, Target List, SET and VALUE Clauses and Scalar Subqueries 3 min
  • Activity - Subqueries
  • Activity Solution - Subqueries
  • Knowledge Builder
  • Check your Knowledge
  • Advanced Table Joins
  • Advanced Table Joins 7 min
  • Activity - Advanced Joins
  • Activity Solution - Advanced Joins
  • Knowledge Builder
  • Check your knowledge
  • Views
  • Views 5 min
  • Activity - Views
  • Activity Solution - Views
  • Knowledge Builder
  • Check your Knowledge
  • Database Tables
  • Create Tables 7 min
  • Table Administration 6 min
  • Table Partitioning 5 min
  • External Tables 5 min
  • Activity - Database Tables
  • Activity Solution - Database Tables
  • Knowledge Builder
  • Check your Knowledge
  • Inserts, Updates and Deletes
  • Single Row Inserts & Global Inserts 4 min
  • Creating a Unique ID to Inserts into Identity Columns 3 min
  • Simple UPDATES 5 min
  • Updates using Subqueries and Correlated Updates 4 min
  • DELETE
  • BATCH and BULK Operations
  • Activity - Inserts, Updates and Deletes
  • Activity Solution - Inserts, Updates and Deletes
  • Knowledge Builder
  • Check your Knowledge
  • Integrity Constraints
  • Creating Constraints 5 min
  • Constraint Violations 3 min
  • Referential Constraint Actions 4 min
  • Activity - Integrity Constraints
  • Activity Solution - Integrity Constraints
  • Knowledge Builder
  • Check your Knowledge
  • Copying Data
  • Unformatted Copy 3 min
  • Formatted Copy 5 min
  • NULL Handling 5 min
  • COPY VWLoad 4 min
  • Activity - Copying Data
  • Activity Solution - Copying Data
  • Knowledge Builder
  • Check your Knowledge
  • Transaction Processing
  • Concept of a Transaction and COMMIT 5 min
  • Locking 6 min
  • Transaction Management​ 6 min
  • Snapshot Isolation (X100 only) 3 min
  • Optimistic Concurrency Control (X100 only) 4 min
  • Activity - Transaction Processing
  • Activity Solution - Transaction Processing
  • Knowledge Builder
  • Check your Knowledge
  • Storage Structures and Security
  • Table Structures 4 min
  • Database Security 4 min
  • Column Level Encryption 2 min
  • Application Level Encryption 3 min
  • Column Masking 3 min
  • Configuring AES Encryption Networking 8 min
  • Activity - Storage Structures and Security
  • Activity Solution - Storage Structures and Security
  • Knowledge Builder
  • Check your Knowledge
  • Database Procedures
  • What are Database Procedures and how are they used? 5 min
  • Using Parameters in Database Procedures 5 min
  • Row-Producing and Table Procedures 2 min
  • Handling Errors in Procedures 5 min
  • Activity - Database Procedures
  • Activity Solution - Database Procedures
  • Knowledge Builder
  • Check your Knowledge
  • Database Rules
  • What are Database Rules? 5 min
  • Rule-invoked Database Procedures 4 min
  • Using WHERE Clause in Rules Before Rules and Rule Tracing 2 min
  • Activity - Database Rules
  • Activity Solution - Database Rules
  • Knowledge Builder
  • Check your Knowledge
  • Database Events
  • Database Events 5 min
  • Activity - Database Events
  • Activity Solution - Database Events
  • Knowledge Builder
  • Check your Knowledge
  • SQL Workshops
  • SQL Workshop 1
  • SQL Workshop 1 Solution
  • SQL Workshop 2
  • SQL Workshop 2 Solution
  • Feedback
  • Course Survey

About this course

At the end of this course you will be able to:

  • Understand the principles and importance of Relational Databases
  • Explore each of the principal Actian database and development tools
  • Understand the principles and importance of industrial-strength SQL
  • Make full use of all the retrieval features of Actian SQL
  • Make full use of all the data-change features of Actian SQL
  • Make full use of all the database-management features of Actian SQL
  • Make full use of Actian Database Procedures, Rules, Events, Integrity features

This course provides you with all the knowledge and skill you need to:

  • use Actian SQL in your batch interfaces, reporting, ad-hoc querying, applications
  • undertake the Actian Application Development and Database Management courses
  • understand and assess the role of Actian in your organization.

Curriculum283 min

  • Course Objective
  • Course Admin
  • Activities
  • Activity Setup Instructions
  • Define the Terminal Type for using Forms-based Utilities in the Course Activities 1 min
  • Relational Concepts and Actian X
  • Relational Concepts and Ingres 6 min
  • Knowledge Builder
  • Check your Knowledge
  • X100 Concepts
  • X100 Concepts 4 min
  • Knowledge Builder
  • Check your Knowledge
  • Character-Based Database Tools
  • ISQL, SQL and Help Statement 5 min
  • Tables, QBF and RBF 4 min
  • Activity - Character-based Database Tools
  • Activity Solution - Character-based Database Tools
  • Knowledge Builder
  • Check your Knowledge
  • Visual Tools
  • Visual Tools 6 min
  • Activity - Visual Tools
  • Activity Solution - Visual Tools
  • Knowledge Builder
  • Check your Knowledge
  • Application Development Tools
  • User Interfaces 5 min
  • Drivers and Access Tools
  • Knowledge Builder
  • Check you Knowledge
  • Controlling Output
  • Simple Queries 6 min
  • SQL Data Types 5 min
  • JSON Data Part 1
  • JSON Data Part 2 10 min
  • Literals NULLs Conversions 4 min
  • Formatting Characters Numeric Data and Dates 3 min
  • CASE Statement 3 min
  • Activity - Controlling Output
  • Activity Solution - Controlling Output
  • Knowledge Builder
  • Check your Knowledge
  • Restricting Rows
  • Restricting rows using the WHERE Clause 3 min
  • Multiple Conditions 5 min
  • Pattern Matching 3 min
  • Activity - Restricting Rows
  • Activity Solution - Restricting Rows
  • Knowledge Builder
  • Check your Knowledge
  • Joining Tables
  • Why Join Tables 4 min
  • Inner Joins 6 min
  • Joining multiple tables and other types of joins 5 min
  • Activity - Joining Tables
  • Activity Solution - Joining Tables
  • Knowledge Builder
  • Check your Knowledge
  • SQL Functions
  • Scalar Functions 3 min
  • Conversion Functions 7 min
  • Aggregate Functions 2 min
  • Aggregate Function Restrictions 4 min
  • Pivot Tables 5 min
  • User Defined Functions 6 min
  • Analytical Functions for Standard Deviation and Variance 4 min
  • Activity - SQL Functions
  • Activity Solution - SQL Functions
  • Knowledge Builder
  • Check your Knowledge
  • Subqueries
  • Subqueries in the WHERE Clause 6 min
  • Subqueries in the FROM clause, Target List, SET and VALUE Clauses and Scalar Subqueries 3 min
  • Activity - Subqueries
  • Activity Solution - Subqueries
  • Knowledge Builder
  • Check your Knowledge
  • Advanced Table Joins
  • Advanced Table Joins 7 min
  • Activity - Advanced Joins
  • Activity Solution - Advanced Joins
  • Knowledge Builder
  • Check your knowledge
  • Views
  • Views 5 min
  • Activity - Views
  • Activity Solution - Views
  • Knowledge Builder
  • Check your Knowledge
  • Database Tables
  • Create Tables 7 min
  • Table Administration 6 min
  • Table Partitioning 5 min
  • External Tables 5 min
  • Activity - Database Tables
  • Activity Solution - Database Tables
  • Knowledge Builder
  • Check your Knowledge
  • Inserts, Updates and Deletes
  • Single Row Inserts & Global Inserts 4 min
  • Creating a Unique ID to Inserts into Identity Columns 3 min
  • Simple UPDATES 5 min
  • Updates using Subqueries and Correlated Updates 4 min
  • DELETE
  • BATCH and BULK Operations
  • Activity - Inserts, Updates and Deletes
  • Activity Solution - Inserts, Updates and Deletes
  • Knowledge Builder
  • Check your Knowledge
  • Integrity Constraints
  • Creating Constraints 5 min
  • Constraint Violations 3 min
  • Referential Constraint Actions 4 min
  • Activity - Integrity Constraints
  • Activity Solution - Integrity Constraints
  • Knowledge Builder
  • Check your Knowledge
  • Copying Data
  • Unformatted Copy 3 min
  • Formatted Copy 5 min
  • NULL Handling 5 min
  • COPY VWLoad 4 min
  • Activity - Copying Data
  • Activity Solution - Copying Data
  • Knowledge Builder
  • Check your Knowledge
  • Transaction Processing
  • Concept of a Transaction and COMMIT 5 min
  • Locking 6 min
  • Transaction Management​ 6 min
  • Snapshot Isolation (X100 only) 3 min
  • Optimistic Concurrency Control (X100 only) 4 min
  • Activity - Transaction Processing
  • Activity Solution - Transaction Processing
  • Knowledge Builder
  • Check your Knowledge
  • Storage Structures and Security
  • Table Structures 4 min
  • Database Security 4 min
  • Column Level Encryption 2 min
  • Application Level Encryption 3 min
  • Column Masking 3 min
  • Configuring AES Encryption Networking 8 min
  • Activity - Storage Structures and Security
  • Activity Solution - Storage Structures and Security
  • Knowledge Builder
  • Check your Knowledge
  • Database Procedures
  • What are Database Procedures and how are they used? 5 min
  • Using Parameters in Database Procedures 5 min
  • Row-Producing and Table Procedures 2 min
  • Handling Errors in Procedures 5 min
  • Activity - Database Procedures
  • Activity Solution - Database Procedures
  • Knowledge Builder
  • Check your Knowledge
  • Database Rules
  • What are Database Rules? 5 min
  • Rule-invoked Database Procedures 4 min
  • Using WHERE Clause in Rules Before Rules and Rule Tracing 2 min
  • Activity - Database Rules
  • Activity Solution - Database Rules
  • Knowledge Builder
  • Check your Knowledge
  • Database Events
  • Database Events 5 min
  • Activity - Database Events
  • Activity Solution - Database Events
  • Knowledge Builder
  • Check your Knowledge
  • SQL Workshops
  • SQL Workshop 1
  • SQL Workshop 1 Solution
  • SQL Workshop 2
  • SQL Workshop 2 Solution
  • Feedback
  • Course Survey