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

Prompt Engineering, SQL    |    Intermediate
  • 14 videos | 2h 11m 41s
  • Includes Assessment
  • Earns a Badge
Joins in SQL combine data from multiple tables, linking related information based on common columns. Views offer a virtual representation of data, simplifying complex queries. Triggers execute predefined actions in response to specific events and transactions safeguard against data inconsistencies in the event of failures. Begin this course by creating indexes on SQL tables to enhance query performance. Next, you will explore joining two tables in SQL, use prompt engineering to specify how you want to combine data, and have ChatGPT and Bard generate the queries you need. Then you will create and query simple views and perform normalization so that your data adheres to principles that reduce redundancy and maintain data integrity. You will create triggers for row insertions, updates, and deletes, all with generative artificial intelligence (AI) help. Finally, you will work with transactions, use prompt engineering to state your problem statement, and have generative AI write your queries for you.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this course
    Create indexes to improve performance
    Perform cross joins
    Perform inner joins
    Perform left, right, and full outer joins
    Create and work with views
    Grant access to views
  • Recall key concepts relating to the normalization of data
    Normalize data in structured query language (sql)
    Run queries automatically with triggers
    Create and run advanced triggers
    Commit and rollback transactions
    Use savepoints in transactions
    Summarize the key concepts covered in this course

IN THIS COURSE

  • 2m 21s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 10m 36s
    During this video, you will learn how to create indexes to improve performance. FREE ACCESS
  • Locked
    3.  Performing Cross Join Operations
    9m 50s
    Find out how to perform cross joins. FREE ACCESS
  • Locked
    4.  Performing Inner Join Operations with Generative AI Help
    7m 29s
    In this video, discover how to perform inner joins. FREE ACCESS
  • Locked
    5.  Implementing Left Joins, Right Joins, and Full Outer Joins
    12m 34s
    Learn how to perform left, right, and full outer joins. FREE ACCESS
  • Locked
    6.  Using ChatGPT to Create Views
    9m 50s
    In this video, find out how to create and work with views. FREE ACCESS
  • Locked
    7.  Limiting Access to Data Using Views
    9m 20s
    During this video, discover how to grant access to views. FREE ACCESS
  • Locked
    8.  Normalizing Data with Google Bard
    12m 23s
    After completing this video, you will be able to recall key concepts relating to the normalization of data. FREE ACCESS
  • Locked
    9.  Normalizing Data in SQL
    8m 18s
    Find out how to normalize data in structured query language (SQL). FREE ACCESS
  • Locked
    10.  Prompting ChatGPT to Help Create Triggers
    13m 11s
    Discover how to run queries automatically with triggers. FREE ACCESS
  • Locked
    11.  Creating Advanced Triggers
    10m 6s
    During this video, you will learn how to create and run advanced triggers. FREE ACCESS
  • Locked
    12.  Committing and Rolling Back Transactions
    12m 29s
    In this video, find out how to commit and rollback transactions. FREE ACCESS
  • Locked
    13.  Working with Savepoints
    10m 14s
    Learn how to use savepoints in transactions. FREE ACCESS
  • Locked
    14.  Course Summary
    3m 1s
    In this video, we will summarize the key concepts covered in this course. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.