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 21sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
10m 36sDuring this video, you will learn how to create indexes to improve performance. FREE ACCESS
-
3. Performing Cross Join Operations9m 50sFind out how to perform cross joins. FREE ACCESS
-
4. Performing Inner Join Operations with Generative AI Help7m 29sIn this video, discover how to perform inner joins. FREE ACCESS
-
5. Implementing Left Joins, Right Joins, and Full Outer Joins12m 34sLearn how to perform left, right, and full outer joins. FREE ACCESS
-
6. Using ChatGPT to Create Views9m 50sIn this video, find out how to create and work with views. FREE ACCESS
-
7. Limiting Access to Data Using Views9m 20sDuring this video, discover how to grant access to views. FREE ACCESS
-
8. Normalizing Data with Google Bard12m 23sAfter completing this video, you will be able to recall key concepts relating to the normalization of data. FREE ACCESS
-
9. Normalizing Data in SQL8m 18sFind out how to normalize data in structured query language (SQL). FREE ACCESS
-
10. Prompting ChatGPT to Help Create Triggers13m 11sDiscover how to run queries automatically with triggers. FREE ACCESS
-
11. Creating Advanced Triggers10m 6sDuring this video, you will learn how to create and run advanced triggers. FREE ACCESS
-
12. Committing and Rolling Back Transactions12m 29sIn this video, find out how to commit and rollback transactions. FREE ACCESS
-
13. Working with Savepoints10m 14sLearn how to use savepoints in transactions. FREE ACCESS
-
14. Course Summary3m 1sIn 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.
