Pair Programming with Generative AI Tools E-Learning Training 

Ga op een veelzijdige leerreis die zich verdiept in twee essentiële domeinen: SQL Database Querying en Django Applicatie Ontwikkeling, beide verrijkt door de strategische toepassing van prompt engineering technieken. In de beginfase van deze leerreis verdiept u zich in de fijne kneepjes van SQL, van basisvaardigheden in tabelmanipulatie tot de beheersing van geavanceerde functies. Met behulp van prompt engineering manipuleert u tabellen en gebruikt u AI-tools, zoals ChatGPT en Bard, voor het efficiënt filteren en groeperen van gegevens. Met als hoogtepunt een verkenning van geavanceerde SQL-scenario's, verfijnt prompt engineering de aanpak voor optimale resultaten. Tegelijkertijd ontvouwt de reis zich in de wereld van Django Application Development. Door middel van prompt engineering legt u een robuuste basis door de architectuur van Django te begrijpen, het framework te installeren en door de standaard app te navigeren. U gaat verder met het maken van dynamische Django-apps met HTML/CSS-sjablonen, waarbij u prompt engineering gebruikt voor efficiëntie. Dit omvat datamodellering, migraties en het navigeren door de Django Admin-interface, waarbij prompt engineering naadloos wordt ingezet om database-interactie te verbeteren en CRUD-operaties te stroomlijnen. Deze uitgebreide reis integreert de kracht van prompt engineering in zowel SQL en Django domeinen, waardoor u uitgerust wordt met een gevarieerde set vaardigheden om databases vakkundig te beheren en dynamische webapplicaties te maken. Ontdek, oefen en verbeter uw vaardigheden om een ervaren professional te worden op het gebied van data- en applicatieontwikkeling.

Deze Learning Kit met meer dan 11:23 leeruren is verdeeld in drie sporen:

Cursusinhoud

Track 1: Pair Programming with Generative AI Tools - SQL Databases

In this track of the Pair Programming with Generative AI Tools Skillsoft Aspire journey, the focus is into the intricacies of SQL, progressing from foundational skills in table manipulation to the mastery of advanced features. Incorporating prompt engineering, you'll adeptly manipulate tables and utilize AI tools, such as ChatGPT and Bard, for efficient data filtering and grouping. Culminating in an exploration of advanced SQL scenarios, prompt engineering refines the approach for optimal results.

Courses:

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

Assessment:

• Final Exam: Pair Programming with Generative AI Tools - SQL Databases

Track 2: Pair Programming with Generative Ai Tools - Django

In this track of the Pair Programming with Generative AI Tools Skillsoft Aspire journey, the focus is on Django Application Development. Through prompt engineering, you'll establish a robust foundation by understanding Django's architecture, installing the framework, and navigating its default app. Progressing further, you'll master the creation of dynamic Django apps with HTML/CSS templates, incorporating prompt engineering for efficiency. This encompasses data modeling, migrations, and navigating the Django Admin interface, all seamlessly employing prompt engineering to enhance database interaction and streamline CRUD operations.

Courses:

Prompt Engineering for Django: Learning Django Using Generative AI Help

Course: 1 Hour, 36 Minutes

• Course Overview
• Django for Web Application Development
• Prompt Engineering to Learn Django
• Using Generative AI Assistants
• Using Pair Programming to Create a Django Project
• Running the Django Development Server
• Creating a Django App
• Creating and Configuring Views in a Django App
• Using Templates and Static Files with Generative AI Help
• Dealing with Misdirection from Generative AI Tools
• Course Summary

Prompt Engineering for Django: Creating Django Views & Models

Course: 1 Hour, 59 Minutes

• Course Overview
• Displaying Dynamic Content Using Template Parameters
• Configuring Links Using Named URLs with ChatGPT's Help
• Using Chain of Thought Prompting to Configure Parameterized URLs
• Eliminating Boilerplate Using Template Inheritance
• Configuring an App Theme Using a Bootstrap Template
• Using ChatGPT's Help to Refactor Templates
• Applying Migrations Using Bing Chat
• Creating and Applying Migrations for the Catalog App
• Managing Database Schema Evolution
• Configuring Foreign Key References in Models
• Course Summary

Prompt Engineering for Django: Prompt Engineering to Build a Django App

Course: 1 Hour, 44 Minutes

• Course Overview
• Logging in to the Admin Interface using ChatGPT's Instructions
• Creating Users and Assigning Privileges
• Administering Catalog Models
• Querying and Displaying Products Using Prompt Engineering
• Displaying Products Filtered by Category
• Navigating to the Product Details Page
• Creating an Add Product Page following ChatGPT's Instructions
• Adding and Saving Products in the Catalog
• Updating and Deleting Products
• Course Summary

Assessment:

• Final Exam: Pair Programming with Generative AI Tools - Django