AI Automation – Chat with Databases without SQL [No-Code]

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Introduction to NLSQL

Lecture 3: How NLSQL Works

Lecture 4: Why NLSQL?

Lecture 5: How to connect with NLSQL Team?

Chapter 2: Prepare your Database Schema for NLSQL

Lecture 1: Starting with NLSQL

Lecture 2: Setting up MySQL Sample Database AWS RDS

Lecture 3: Understand the Database

Lecture 4: Setting up View to Avoid complexiteis

Lecture 5: Extracting Table Schema to CSV format Sheets

Lecture 6: Setting up Google Spreadsheet for Each Table

Lecture 7: Formatting Columns in Google Sheets

Chapter 3: Setting Up Joins and Arguments at NLSQL

Lecture 1: Setting up NLSQL Account

Lecture 2: Setting up Table Configuration at NLSQL Portal

Lecture 3: Setting Up Joins for Tables

Lecture 4: Setting UP KPIs by Configuring Arguments

Chapter 4: Setting Up Application on Azure Portal

Lecture 1: Setting up NLSQL App on Azure Step by Step AWS

Lecture 2: Overview of NLSQL Resource Group

Lecture 3: Playing with Integrate WebChat

Lecture 4: Setting up NLSQL Channel Chat with Microsoft Teams

Chapter 5: Playing with NLSQL using Microsoft Teams Chatbot

Lecture 1: Finding Orders Data by Table Column Name

Lecture 2: Finding Sales Data by Table Column Name

Lecture 3: Finding Sale Qty Data by Table Column Name

Lecture 4: Finding All the KPIS in one Prompt

Lecture 5: How to Deal with Same Text accross multiple Tables?

Lecture 6: How to Deal with Same Column Name accross multiple tables

Lecture 7: How to Add and Play with Text Based Content as KPI

Lecture 8: Make your life easier by using synonyms

Chapter 6: Setting up Top/Bottom & Complex Arguments

Lecture 1: Setting up and playing with Top and Bottom Argument

Lecture 2: Generating the Complex Arugement for Avg Receipt

Lecture 3: Playing with Avg Receipt Complex Argument with Other KPIs

Lecture 4: Updating the older dates to current years for better experience

Lecture 5: Generating the Complex Arugement for Growth By Year

Lecture 6: Generating the Complex Arugement for Growth By Quarter

Chapter 7: Setting up Filters, Dates, and Columns for Map

Lecture 1: Getting Rid from Dirty Data with the help of Filters

Lecture 2: Configure Date Columns & Playing with data with the help of Date arguments

Lecture 3: Configure Country Column for Map

Chapter 8: Playing with NLSQL Graphs

Lecture 1: Welcome to Data Visualization

Lecture 2: Visulize Data in Pie Chart

Lecture 3: Visulize Data in Bar Chart

Lecture 4: Visulize Data in Line Chart

Lecture 5: 05-Visulize Data in Scatter Chart

Lecture 6: Visulize Data in Map Chart

Chapter 9: Advance

Lecture 1: Analytics Page- Keep an eye on your system

Lecture 2: After Depoyment to Production Phase