Actian Data Platform for Data Scientists: Building Machine Learning Models

About this course

Course Outcome:

You will have been provided with insight for the native SQL functions available within the Platform Warehouse along with information for how to achieve feature encoding and how to create datasets for training and testing your Machine Learning Models using SQL.

Course Style:

The course is provided in a step-by-step fashion, introducing you to the available native SQL functions and demonstrating how to perform feature encoding and data subset creation.

Audience:

For Data Scientists and Data Architects, and similar personas within your organisation responsible for business intelligence, analytics and data visualisation.

Prerequisites:

No prior knowledge of Actian Data Platform is required
Some knowledge of the data science workflow is assumed
Actian Data Platform login credentials and access to the Warehouse data are assumed to be available to you.

Supplementary Resources:

Product Documentation:	https://docs.actian.com/
Actian Community:	https://communities.actian.com/
Software Download:	https://esd.actian.com/

Curriculum43 min

Course Objective 1 min
Course Admin
Prerequisites and Supporting Content 1 min
Adding Platform Data Integration IPs to the Warehouse trusted list of IPs 3 min
Install the Platform ODBC Data Driver for Windows 7 min
Install the Platform ODBC Data Driver for Linux 4 min
Install the Platform Data Driver for Apple MAC 5 min
Jupyter Notebook: Feature Encoding and Dataset Split Iris Dataset 1 min
Inbuilt SQL Functions
Analytical Functions and Standard Deviation and Variance 4 min
Pivot Tables 5 min
Feature Encoding and Normalization
Add Encoded Columns 2 min
Feature Encoding and Normalization using SQL 5 min
Splitting the dataset for Training and Testing the Machine Learning Model
Splitting the dataset for Training and Testing the Machine Learning Model 4 min
Feedback
Take Course Survey 1 min

About this course