Control Output and Restricting Rows in Actian Vector

Control Output and Restricting Rows in Actian Vector

Within this course beginners guidance is provided for the functionality available to control what is included in a result set generated by an SQL statement against an Actian Vector database

About this course

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

You will have a basic understanding of how you can restrict and/or manipulate data which is returned after executing an SQL statement against an Actian database.

 

Course Style:

This video provides basic information for controlling result set output.

Audience:

This content will benefit those who is responsibility it is to extract data from an Actian database by executing SQL statements.

 

Prerequisites:

The video assumes you have access to an Actian database.

Curriculum10 min

  • Simple Queries 2 min
  • Formatting Character Data 1 min
  • NULL Values in the SQL Expression 2 min
  • Using the WHERE clause 1 min
  • Predicates in SQL 1 min
  • Ambiguous Conditions 1 min
  • Pattern Matching 1 min
  • Feedback
  • Take Course Survey

About this course

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

You will have a basic understanding of how you can restrict and/or manipulate data which is returned after executing an SQL statement against an Actian database.

 

Course Style:

This video provides basic information for controlling result set output.

Audience:

This content will benefit those who is responsibility it is to extract data from an Actian database by executing SQL statements.

 

Prerequisites:

The video assumes you have access to an Actian database.

Curriculum10 min

  • Simple Queries 2 min
  • Formatting Character Data 1 min
  • NULL Values in the SQL Expression 2 min
  • Using the WHERE clause 1 min
  • Predicates in SQL 1 min
  • Ambiguous Conditions 1 min
  • Pattern Matching 1 min
  • Feedback
  • Take Course Survey