Transforming Everyday Language into Powerful SQL Queries

Focused View

Muhammad Afzal

3:30:18

22 View

1. Introduction

1. Introduction.mp4

03:43

2. Introduction to NLSQL.mp4

05:17

3. How NLSQL Works.mp4

02:30

4. Why NLSQL.mp4

06:04

5. How to connect with NLSQL Team.mp4

01:42

2. Prepare your Database Schema for NLSQL

1. Starting with NLSQL.mp4

02:40

2. Setting up MySQL Sample Database AWS RDS.mp4

04:48

3. Understand the Database.mp4

04:58

4. Setting up View to Avoid complexiteis.mp4

05:01

5. Extracting Table Schema to CSV format Sheets.mp4

06:55

6. Setting up Google Spreadsheet for Each Table.mp4

09:46

7. Formatting Columns in Google Sheets.mp4

02:15

3. Setting Up Joins and Arguments at NLSQL

1. Setting up NLSQL Account.mp4

02:18

2. Setting up Table Configuration at NLSQL Portal.mp4

07:01

3. Setting Up Joins for Tables.mp4

04:22

4. Setting UP KPIs by Configuring Arguments.mp4

05:16

4. Setting Up Application on Azure Portal

1. Setting up NLSQL App on Azure Step by Step AWS.mp4

05:20

2. Overview of NLSQL Resource Group.mp4

02:54

3. Playing with Integrate WebChat.mp4

04:38

4. Setting up NLSQL Channel Chat with Microsoft Teams.mp4

05:51

5. Playing with NLSQL using Microsoft Teams Chatbot

1. Finding Orders Data by Table Column Name.mp4

05:39

2. Finding Sales Data by Table Column Name.mp4

03:47

3. Finding Sale Qty Data by Table Column Name.mp4

06:11

4. Finding All the KPIS in one Prompt.mp4

03:35

5. How to Deal with Same Text accross multiple Tables.mp4

02:15

6. How to Deal with Same Column Name accross multiple tables.mp4

01:23

7. How to Add and Play with Text Based Content as KPI.mp4

05:10

8. Make your life easier by using synonyms.mp4

03:18

6. Setting up TopBottom & Complex Arguments

1. Setting up and playing with Top and Bottom Argument.mp4

07:50

2. Generating the Complex Arugement for Avg Receipt.mp4

07:46

3. Playing with Avg Receipt Complex Argument with Other KPIs.mp4

03:38

4. Updating the older dates to current years for better experience.mp4

04:40

5. Generating the Complex Arugement for Growth By Year.mp4

05:06

6. Generating the Complex Arugement for Growth By Quarter.mp4

04:47

7. Setting up Filters, Dates, and Columns for Map

1. Getting Rid from Dirty Data with the help of Filters.mp4

05:59

2. Configure Date Columns & Playing with data with the help of Date arguments.mp4

10:32

3. Configure Country Column for Map.mp4

02:01

8. Playing with NLSQL Graphs

1. Welcome to Data Visualization.mp4

01:09

2. Visulize Data in Pie Chart.mp4

08:07

3. Visulize Data in Bar Chart.mp4

05:51

4. Visulize Data in Line Chart.mp4

04:31

5. 05-Visulize Data in Scatter Chart.mp4

04:03

6. Visulize Data in Map Chart.mp4

03:53

9. Advance

1. Analytics Page- Keep an eye on your system.mp4

02:54

2. After Depoyment to Production Phase.mp4

02:54

Description

NLSQL and AI: Transforming Everyday Language into Powerful SQL Queries

What You'll 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.

Who is this for?

Data analysts and scientists

Business intelligence professionals

SQL users looking to enhance their skills

Entrepreneurs and business owners seeking streamlined data access

What You Need to Know?

Basic Database Concepts

Basic SQL

Familar with Cloud Platforms such as Azure, AWS

More details

Description
Unlock the power of Natural Language SQL (NLSQL) and revolutionize the way you interact with databases. Welcome to "Mastering NLSQL," an in-depth Udemy course designed to make complex database queries accessible through natural language. Whether you're a beginner or an experienced SQL user, this course equips you with the skills to effortlessly navigate and query databases using intuitive language.
Â
What You'll Learn:
Introduction to NLSQL:
Prepare your database schema for NLSQL
Setting up joins and arguments at NLSQL portal
Setting up an application at the Azure portal
Playing with NLSQL using the Microsoft teams chat bot
Setting up top/bottom and complex arguments
Setting up filters, dates, and map columns
Playing with NLSQL graphs
Advance Settings
Â
Who is this course for?
Data analysts and scientists
Business intelligence professionals
SQL users looking to enhance their skills
Entrepreneurs and business owners seeking streamlined data access
Why Take This Course?
Practical Skills: Acquire hands-on experience with real-world NLSQL applications and projects.
Efficiency: Simplify complex queries and enhance your data analysis workflow.
Career Advancement: Stand out in the competitive field of data analytics by mastering NLSQL.
Flexibility: Access the course anytime, anywhere, and at your own pace.
Enroll now and embark on a journey to master NLSQL, unlocking the full potential of your database querying capabilities.
Who this course is for:
Data analysts and scientists
Business intelligence professionals
SQL users looking to enhance their skills
Entrepreneurs and business owners seeking streamlined data access

User Reviews

Rating

average 0

Total votes0

Focused display

13+ Years of professional experience in Web / IoT(Internet of Things) / Network Application Development using PHP, ASP.NET, C++, Node.js Have my own written PHP OOP framework for small to medium websites/applications. And also developed Multi-Tier DB Architecture Framework for .Net.Extensive experience in Relational Database designing, code architecture , Websites Migrations, Data Import/Export Script, Website Management, Google Apps For Enterprise.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.