Prompt Engineering for Querying SQL Databases E-Learning

Enhance your database querying skills with our Prompt Engineering for Querying SQL Databases Training. Learn to craft efficient prompts and master SQL techniques to retrieve, analyze, and manipulate data. This training covers essential SQL commands, complex queries, and optimization strategies. Book now to boost your data handling expertise!

What is generative AI?

Generative artificial intelligence (generative AI) is a type of AI that can create new content and ideas, including conversations, stories, images, videos, and music. AI technologies attempt to mimic human intelligence in nontraditional computing tasks like image recognition, natural language processing (NLP), and translation. Generative AI is the next step in artificial intelligence. You can train it to learn human language, programming languages, art, chemistry, biology, or any complex subject matter. It reuses training data to solve new problems. For example, it can learn English vocabulary and create a poem from the words it processes. Your organization can use generative AI for various purposes, like chatbots, media creation, and product development and design.

Course content

Querying SQL Databases: Learning SQL Using Prompt Engineering

Course: 1 Hour, 48 Minutes

• Course Overview
• Prompt Engineering for Querying SQL Databases
• Using Generative AI Assistants for Prompt Engineering
• Installing and Setting Up MySQL on macOS and Windows
• Creating a Database and Table
• Using ChatGPT to Insert Data into Tables
• Performing Update and Delete Operations on Tables
• Adding Not Null Constraints
• Using Unique Constraints and Constraint Enforcement
• Working with Primary Keys and Auto Increment
• Viewing and Dropping Constraints
• Course Summary

Querying SQL Databases: Using Generative AI Tools to Filter & Group Data

Course: 2 Hours, 4 Minutes

• Course Overview
• Uploading Data from a CSV File to MySQL
• Using ChatGPT to Filter Rows Using the WHERE Clause
• Using Different Conditional Clauses for Filtering
• Using the LIKE and IN Keywords for Filtering
• Using Prompt Engineering for Subquery Operations
• Configuring Foreign Key Constraints
• Setting up ON DELETE CASCADE with ChatGPT's Help
• Using Bard to Perform Numeric Aggregations on Data
• Executing String Functions and Math Operations
• Computing Aggregations on Grouped Data
• Using the HAVING Clause to Filter Grouped Results
• Writing Complex Grouping and Aggregation Queries Using Bard
• Course Summary

Querying SQL Databases: Prompt Engineering to Work with Advanced SQL Operations

Course: 2 Hours, 12 Minutes

• Course Overview
• Creating Indexes with Bing Chat's Help
• Performing Cross Join Operations
• Performing Inner Join Operations with Generative AI Help
• Implementing Left Joins, Right Joins, and Full Outer Joins1
• Using ChatGPT to Create Views
• Limiting Access to Data Using Views
• Normalizing Data with Google Bard
• Normalizing Data in SQL
• Prompting ChatGPT to Help Create Triggers
• Creating Advanced Triggers
• Committing and Rolling Back Transactions
• Working with Savepoints
• Course Summary