Test theme
Introduction to the Actian X product and Actian X SQL (self-paced)

Introduction to the Actian X product and Actian X SQL (self-paced)

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

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 X database and development tools
  • Understand the principles and importance of industrial-strength SQL
  • Make full use of all the retrieval features of Actian X SQL
  • Make full use of all the data-change features of Actian X SQL
  • Make full use of all the database-management features of Actian X SQL
  • Make full use of Actian X Database Procedures, Rules, Events, Integrity features

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

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

Curriculum9 hr 47 min

  • Course Detail
  • Preview
    Introduction to Actian X 0 hr 12 min
  • Relational Concepts and Actian X
  • Actian X and Information and Users 0 hr 27 min
  • Actian X and Relational 0 hr 25 min
  • Character-Based Database Tools
  • Part 1 0 hr 34 min
  • Part 2 0 hr 27 min
  • Database Tools
  • Actian Director 0 hr 20 min
  • Administration and Command Line tools 0 hr 27 min
  • Application Development 0 hr 25 min
  • Controlling Output
  • Part 1 0 hr 30 min
  • Part 2 0 hr 17 min
  • SQL Functionality
  • Restricting Rows 0 hr 29 min
  • Simple Joins 0 hr 25 min
  • Set Functions 0 hr 18 min
  • Sub Queries 0 hr 23 min
  • Advanced Joins 0 hr 13 min
  • Views 0 hr 23 min
  • Database Tables 0 hr 28 min
  • Inserts, Updates and Deletes - Part 1 0 hr 14 min
  • Inserts, Updates and Deletes - Part 2 0 hr 16 min
  • Integrity Constraints 0 hr 15 min
  • Copying Data 0 hr 27 min
  • Transaction Processing 0 hr 24 min
  • Database Performance and Security 0 hr 14 min
  • Database Procedures - Part 1 0 hr 21 min
  • Database Procedures - Part 2 0 hr 16 min
  • Database Rules 0 hr 21 min
  • Database Events 0 hr 4 min
  • Course Summary
  • Take Course Survey
  • Course Activity Content

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 X database and development tools
  • Understand the principles and importance of industrial-strength SQL
  • Make full use of all the retrieval features of Actian X SQL
  • Make full use of all the data-change features of Actian X SQL
  • Make full use of all the database-management features of Actian X SQL
  • Make full use of Actian X Database Procedures, Rules, Events, Integrity features

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

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

Curriculum9 hr 47 min

  • Course Detail
  • Preview
    Introduction to Actian X 0 hr 12 min
  • Relational Concepts and Actian X
  • Actian X and Information and Users 0 hr 27 min
  • Actian X and Relational 0 hr 25 min
  • Character-Based Database Tools
  • Part 1 0 hr 34 min
  • Part 2 0 hr 27 min
  • Database Tools
  • Actian Director 0 hr 20 min
  • Administration and Command Line tools 0 hr 27 min
  • Application Development 0 hr 25 min
  • Controlling Output
  • Part 1 0 hr 30 min
  • Part 2 0 hr 17 min
  • SQL Functionality
  • Restricting Rows 0 hr 29 min
  • Simple Joins 0 hr 25 min
  • Set Functions 0 hr 18 min
  • Sub Queries 0 hr 23 min
  • Advanced Joins 0 hr 13 min
  • Views 0 hr 23 min
  • Database Tables 0 hr 28 min
  • Inserts, Updates and Deletes - Part 1 0 hr 14 min
  • Inserts, Updates and Deletes - Part 2 0 hr 16 min
  • Integrity Constraints 0 hr 15 min
  • Copying Data 0 hr 27 min
  • Transaction Processing 0 hr 24 min
  • Database Performance and Security 0 hr 14 min
  • Database Procedures - Part 1 0 hr 21 min
  • Database Procedures - Part 2 0 hr 16 min
  • Database Rules 0 hr 21 min
  • Database Events 0 hr 4 min
  • Course Summary
  • Take Course Survey
  • Course Activity Content