GenAI Powered SQL for Business Analysts

GenAI Powered SQL for Business Analysts

• Lesson 01: Unleashing SQL Magic A Dynamic Introduction to Database Mastery

  • 1.01 Introduction to Database

  • 1.02 DBMS, RDBM, and SQL

  • 1.03 Entity relationship model

  • 1.04 Relationship Degree

  • 1.05 Types of Relationship

  • 1.06 Cardinalities

• Lesson 02: Working with Database and Tables

  • 2.01 Introduction to Database in MySQL​

  • 2.02 Tables in MySQL

  • 2.03 DDL

  • 2.04 SQL Data Manipulation

  • 2.05 SQL Query Implementation

  • 2.06 Grouping and Ordering Table Data

  • 2.07 Comments in SQL

• Lesson 03: Working with Operators, Constraints, and Data Types​

  • 3.01 SQL Data Types​

  • 3.02 MySQL Operators​

  • 3.03 Indexing in MySQL​

  • 3.04 MySQL Constraints​

  • 3.05 Unique and Check Constraint

• Lesson 04: SQL Functions and AI-Assisted Query Optimization

  • 4.01 Introduction to SQL Functions

  • 4.02 String Functions

  • 4.03 Date and Time Functions

  • 4.04 Aggregate Functions

  • 4.05 Window Functions

  • 4.06 AI-Assisted Query Optimization

• Lesson 05: Joins, Set Operators, and Subqueries​

  • 5.01 Introduction to Alias​

  • 5.02 Introduction to Joins​

  • 5.03 Set Operators in SQL​

  • 5.04 Subquery in SQL​

• Lesson 06: SQL Analytics, Modularization, and AI-Based Performance Tuning

  • 6.01 Introduction to Window Functions

  • 6.02 Aggregate Window Functions

  • 6.03 Ranking Window Functions

  • 6.04 SQL Views

  • 6.05 SQL Common Table Expressions (CTEs)

  • 6.06 AI-Driven SQL Performance Tuning and Monitoring