Overview What You Will Learn Curriculum Instructor

Course Overview

NLSQL is a powerful natural language-to-SQL solution that allows you to query databases without writing complex SQL statements. By integrating with platforms like Microsoft Teams and Azure, it transforms how you interact with data, making analytics accessible to both technical and non-technical users. This course guides you through setting up, configuring, and fully utilizing NLSQL, enabling you to streamline business intelligence tasks and turn plain language queries into actionable insights. 

This course begins with an introduction to NLSQL, its working principles, and its advantages. You will learn how to prepare your database schema, configure joins and arguments, and deploy NLSQL on Azure. The training covers integrating NLSQL with Microsoft Teams for chatbot-based data queries and setting up advanced arguments for complex KPIs. You will also explore data cleaning with filters, date configurations, mapping columns, and creating visualizations like pie, bar, line, scatter, and map charts. The course concludes with analytics monitoring and deployment best practices for production environments. 

You will finish with the ability to configure, integrate, and utilize NLSQL for powerful, language-driven data analytics. 

What You Will Learn

  • Gain a comprehensive understanding of NLSQL, from its fundamentals to advanced concepts.
  • Empowering you to seamlessly convert everyday language into powerful SQL queries.
  • Learn to set up databases for NLSQL, optimizing data in Google Sheets, and establishing a foundation for smooth and intuitive interactions with your data.
  • Explore the synergy between NLSQL and Artificial Intelligence (AI), enhancing your ability to intelligently query databases for insightful data analysis.

Program Curriculum

  • Introduction to NLSQL
  • How NLSQL Works?
  • Why NLSQL?
  • How to Connect with NLSQL Team?
  • Chapter 1 Quiz

  • Starting with NLSQL
  • Setting up MySQL Sample Database AWS RDS
  • Understand the Database
  • Setting up View to Avoid Complexities
  • Extracting Table Schema to CSV Format Sheets
  • Setting up Google Spreadsheet for Each Table
  • Formatting Columns in Google Sheets
  • Chapter 2 Quiz

  • Setting Up NLSQL Account
  • Setting Up Table Configuration at NLSQL Portal
  • Setting Up Joins for Tables
  • Setting Up KPIs by Configuring Arguments
  • Chapter 3 Quiz

  • Setting up NLSQL App on Azure Step by Step AWS
  • Overview of NLSQL Resource Group
  • Playing with Integrate WebChat
  • Setting up NLSQL Channel Chat with Microsoft Teams
  • Chapter 4 Quiz

  • Finding Orders Data by Table Column Name
  • Finding Sales Data by Table Column Name
  • Finding Sale Qty Data by Table Column Name
  • Finding All the KPIs in One Prompt
  • How to Deal with Same Text Across Multiple Tables?
  • How to Deal with Same Column Name Across Multiple Tables?
  • How to Add and Play with Text-based Content as KPI?
  • Make Your Life Easier by Using Synonyms
  • Chapter 5 Quiz

  • Setting up and Playing with Top and Bottom Argument
  • Generating the Complex Argument for Avg Receipt
  • Playing with Avg Receipt Complex Argument with Other KPIs
  • Updating the Older Dates to Current Years for Better Experience
  • Generating the Complex Argument for Growth by Year
  • Generating the Complex Argument for Growth by Quarter
  • Chapter 6 Quiz

  • Getting Rid from Dirty Data with the Help of Filters
  • Configure Date Columns & Playing with Data with the Help of Date Arguments
  • Configure Country Column for Map
  • Chapter 7 Quiz

  • Welcome to Data Visualization
  • Visualize Data in Pie Chart
  • Visualize Data in Bar Chart
  • Visualize Data in Line Chart
  • Visualize Data in Scatter Chart
  • Visualize Data in Map Chart
  • Chapter 8 Quiz

  • Analytics Page - Keep an Eye on Your System
  • After Deployment to Production Phase
  • Chapter 9 Quiz
Load more modules

Instructor

Muhammad Afzal

Muhammad Afzal is a freelance developer who was passionate about Web, Cloud &IoT. He has been working on tech projects for more than 13 years. He has worked for international clients & firms and has been involved in a wide variety of projects and technologies, including Smart Agriculture, Warehouse monitoring, Environmental monitoring solutions, and many others. For several years, he has been focusing on the IoT ecosystem. He is currently working as a Freelance IoT consultant to clients around the world. He also produces education content for Udemy, YouTube regarding IoT, Cloud, and Web. He also writes for Different IoT Tech companies regarding their products and services. Beside all of that he is voluntarily organizing IoT Workshops for local community. His main objective nowadays is to help others to understand and implement IoT solutions.

Join over 1 Million professionals from the most renowned Companies in the world!

certificate

Empower Your Learning with Our Flexible Plans

Invest in your future with our flexible subscription plans. Whether you're just starting out or looking to enhance your expertise, there's a plan tailored to meet your needs. Gain access to in-demand skills and courses for your continuous learning needs.

Monthly Plans
Annual Plans
Save 20% with our annual plans!

Pro

Ideal for continuous learning, offering video-based learning with 840+ courses and diverse Learning Paths to enhance your skills.

$ 69.00
Billed monthly or $599.00 billed annually
Get Started Now
Start your 7-day trial for $1

What is included

  • 840+ Premium Short Courses
  • 70+ Structured Learning Paths
  • Validation of Completion with all courses and learning paths
  • New Courses added every month
Early Access Offer

Pro +

Experience immersive learning with Practice Labs and CTF Challenges for comprehensive skill-building.

$ 79.00
Billed monthly or $699.00 billed annually
Get Started Now
Start your 7-day trial for $1

Everything in Pro and

  • 1400+ Practice Lab exercises with guided instructions
  • 150+ CTF Challenges with detailed walkthroughs
  • New Practice Labs and Challenges added every month

Related Courses

  • Hacking WEP/WPA/WPA2 Wi-Fi Networks Using Kali Linux 2.

    Hacking WEP/WPA/WPA2 Wi-Fi Networks Using Kali Linux 2

    Short Course

    Hacking WEP/WPA/WPA2 Wi-Fi Networks Using Kali Linux 2

    Vulnerability Assessment and Pentesting

    The comprehensive course to secure & crack WEP/WPA/WPA2 k...

    $69.99

    Intermediate

    5 hr 12 m

  • Bootstrap 4 Quick Website Bootstrap Components Course.

    Bootstrap 4 Quick Website Bootstrap Components Course

    Short Course

    Bootstrap 4 Quick Website Bootstrap Components Course

    Software Development

    Explore the basics of Bootstrap and learn to create a website...

    $49.99

    Beginner

    1 hr 30 m

  • CCNA - Understanding Routers and Switches.

    CCNA - Understanding Routers and Switches

    Short Course

    CCNA - Understanding Routers and Switches

    Security Architecture and Operations

    A comprehensive guide to understanding the in-depth functioni...

    $49.99

    Intermediate

    2 hr 0 m

  • The Complete Full-Stack JavaScript Course.

    The Complete Full-Stack JavaScript Course

    Short Course

    The Complete Full-Stack JavaScript Course

    Software Development

    Learn full-stack web development using JavaScript (ReactJS, N...

    $79.99

    Beginner

    24 hr 17 m

  • React.JS for Ecommerce: Building a Store with React.JS

    React.JS for Ecommerce: Building a Store with React.JS

    Short Course

    React.JS for Ecommerce: Building a Store with React.JS

    DevSecOps

    From React.js Fundamentals to Crafting an Online Storefront

    $49.99

    Advanced

    3 hr 30 m

  • CISSP Certification Domains 5, 6, 7, and 8 Video Training.

    CISSP Certification Domains 5, 6, 7, and 8 Video Training

    Short Course

    CISSP Certification Domains 5, 6, 7, and 8 Video Training

    Cybersecurity

    This course is ideal for individuals who desire to pass the I...

    $69.99

    Intermediate

    6 hr 30 m

  • Helm 3 - Package Manager for Kubernetes.

    Helm 3 - Package Manager for Kubernetes

    Short Course

    Helm 3 - Package Manager for Kubernetes

    Software Development

    A must tool for every DevOps engineer

    $49.99

    Intermediate

    1 hr 27 m

  • Learn Ethical Hacking by Hacking Real Websites Legally.

    Learn Ethical Hacking by Hacking Real Websites Legally

    Short Course

    Learn Ethical Hacking by Hacking Real Websites Legally

    Vulnerability Assessment and Pentesting

    Fun way to learn ethical hacking by playing online hacking ga...

    $69.99

    Beginner

    4 hr 18 m

1 50
View all