-
Course Objective
- Course Admin
-
Activities
-
Activity Setup Instructions
- X100 Concepts
-
X100 Concepts 4 min
-
Knowledge Builder
-
Check your Knowledge
- Command Line Interface Tools
-
Install and Connect the Actian CLI Tools (Windows) 7 min
-
Install and Connect Actian CLI Tools (Linux) 7 min
-
Activity - Command Line Interface Tools
-
Activity Solution - Command Line Interface Tools
-
Knowledge Builder
-
Check your Knowledge
- Controlling Output
-
Simple Queries 6 min
-
SQL Data Types 5 min
-
JSON Data Part 1 4 min
-
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 4 min
-
BATCH and BULK Operations 4 min
-
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
-
Snapshot Isolation 3 min
-
Optimistic Concurrency Control 4 min
-
Activity - Transaction Processing
-
Activity Solution - Transaction Processing
-
Knowledge Builder
-
Check your Knowledge
- Database Security
-
Database Security 4 min
-
DBMS Level Encryption 3 min
-
Application Level Encryption 3 min
-
Column Level Encryption 2 min
-
Column Masking 3 min
-
Configuring AES Encryption Networking 8 min
-
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 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
Introduction to 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.
At the end of this course you will be able to:
- Understand the basic Actian database concepts
- 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, 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 Database Management courses
- understand and assess the role of Actian in your organization.