Querying SQL Databases: Learning SQL Using Prompt Engineering
Prompt Engineering, SQL
| Intermediate
- 12 videos | 1h 47m 43s
- Includes Assessment
- Earns a Badge
Structured query language (SQL) is a powerful query language designed for managing and manipulating relational databases. Its declarative nature allows users to interact with databases by specifying the desired result, leaving the system to determine the optimal method of execution. Begin this course with an introduction to SQL, including the features of SQL and how and where SQL is used. Then, you will install and operate MySQL, utilizing the assistance of generative artificial intelligence (AI) chatbots ChatGPT and Bard. You will work with the MySQL Workbench and learn to create tables, insert data into tables, and update and delete records in tables. Next, you will find out how to apply constraints on tables, use NOT NULL constraints to prohibit missing values, and use unique constraints, which ensure distinct values in columns. Finally, you will create and work with primary key constraints that are used to uniquely identify records in a table.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this course
Recall foundational concepts of structured query language (sql)
Use generative artificial intelligence (ai) to explore sql
Install mysql on macos and windows
Create a database and table
Insert data into and view tables with chatgpt's assistance -
Update and delete records in tables
Use not null constraints in sql
Use unique constraints and trigger constraint enforcement
Work with primary keys
View and drop constraints
Summarize the key concepts covered in this course
IN THIS COURSE
-
1m 45sIn this video, we will discover the key concepts covered in this course. FREE ACCESS
-
12m 55sAfter completing this video, you will be able to recall foundational concepts of structured query language (SQL). FREE ACCESS
-
3. Using Generative AI Assistants for Prompt Engineering8mIn this video, find out how to use generative artificial intelligence (AI) to explore SQL. FREE ACCESS
-
4. Installing and Setting Up MySQL on macOS and Windows11m 12sLearn how to install MySQL on macOS and Windows. FREE ACCESS
-
5. Creating a Database and Table12m 54sDuring this video, discover how to create a database and table. FREE ACCESS
-
6. Using ChatGPT to Insert Data into Tables10m 47sFind out how to insert data into and view tables with ChatGPT's assistance. FREE ACCESS
-
7. Performing Update and Delete Operations on Tables12m 34sDuring this video, you will learn how to update and delete records in tables. FREE ACCESS
-
8. Adding Not Null Constraints10m 15sDiscover how to use NOT NULL constraints in SQL. FREE ACCESS
-
9. Using Unique Constraints and Constraint Enforcement8m 20sIn this video, find out how to use unique constraints and trigger constraint enforcement. FREE ACCESS
-
10. Working with Primary Keys and Auto Increment7m 7sLearn how to work with primary keys. FREE ACCESS
-
11. Viewing and Dropping Constraints9m 15sIn this video, discover how to view and drop constraints. FREE ACCESS
-
12. Course Summary2m 40sIn 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.
