Querying SQL Databases: Learning SQL Using Prompt Engineering

Prompt Engineering, SQL    |    Intermediate
  • 12 videos | 1h 47m 43s
  • Includes Assessment
  • Earns a Badge
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
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 45s
    In this video, we will discover the key concepts covered in this course. FREE ACCESS
  • 12m 55s
    After completing this video, you will be able to recall foundational concepts of structured query language (SQL). FREE ACCESS
  • Locked
    3.  Using Generative AI Assistants for Prompt Engineering
    8m
    In this video, find out how to use generative artificial intelligence (AI) to explore SQL. FREE ACCESS
  • Locked
    4.  Installing and Setting Up MySQL on macOS and Windows
    11m 12s
    Learn how to install MySQL on macOS and Windows. FREE ACCESS
  • Locked
    5.  Creating a Database and Table
    12m 54s
    During this video, discover how to create a database and table. FREE ACCESS
  • Locked
    6.  Using ChatGPT to Insert Data into Tables
    10m 47s
    Find out how to insert data into and view tables with ChatGPT's assistance. FREE ACCESS
  • Locked
    7.  Performing Update and Delete Operations on Tables
    12m 34s
    During this video, you will learn how to update and delete records in tables. FREE ACCESS
  • Locked
    8.  Adding Not Null Constraints
    10m 15s
    Discover how to use NOT NULL constraints in SQL. FREE ACCESS
  • Locked
    9.  Using Unique Constraints and Constraint Enforcement
    8m 20s
    In this video, find out how to use unique constraints and trigger constraint enforcement. FREE ACCESS
  • Locked
    10.  Working with Primary Keys and Auto Increment
    7m 7s
    Learn how to work with primary keys. FREE ACCESS
  • Locked
    11.  Viewing and Dropping Constraints
    9m 15s
    In this video, discover how to view and drop constraints. FREE ACCESS
  • Locked
    12.  Course Summary
    2m 40s
    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.

YOU MIGHT ALSO LIKE

Book Leveling Up with SQL: Advanced Techniques for Transforming Data into Insights
Course CompTIA Data+: Database Concepts
Rating 4.6 of 23 users Rating 4.6 of 23 users (23)
Book Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Rating 4.6 of 255 users Rating 4.6 of 255 users (255)
Course Generative AI and Its Impact to Everyday Business
Rating 4.6 of 893 users Rating 4.6 of 893 users (893)
Course Exploring Prompt Engineering Techniques
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)