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.

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.

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 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.

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