Pair Programming with Generative AI Tools
Beschrijving
Pair Programming with Generative AI Tools.
Embark on a multifaceted learning journey that delves into two essential domains: SQL Database Querying and Django Application Development, both enriched by the strategic application of prompt engineering techniques. In the initial phase of this learning journey, you will delve 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 approa…
Veelgestelde vragen
Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.
Pair Programming with Generative AI Tools.
Embark on a multifaceted learning journey that delves into two essential domains: SQL Database Querying and Django Application Development, both enriched by the strategic application of prompt engineering techniques. In the initial phase of this learning journey, you will delve 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. Concurrently, the journey unfolds into the world of 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. This comprehensive journey integrates the power of prompt engineering into both SQL and Django realms, equipping you with a diverse skill set to proficiently manage databases and craft dynamic web applications. Explore, practice, and advance your capabilities to emerge as a skilled professional in the realms of data and application development.
This Learning Kit with more than 11 hours of learning is divided into three tracks:
Course content
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
Specificaties
Taal: Engels
Kwalificaties van de Instructeur:
Gecertificeerd
Cursusformaat en Lengte: Lesvideo's met
ondertiteling, interactieve elementen en opdrachten en testen
Lesduur: 11:23 uur
Assesments: De assessment test uw kennis en
toepassingsvaardigheden van de onderwerpen uit het leertraject.
Deze is 365 dagen beschikbaar na activering.
Online Virtuele labs: Ontvang 12 maanden toegang
tot virtuele labs die overeenkomen met de traditionele
cursusconfiguratie. Actief voor 365 dagen na activering,
beschikbaarheid varieert per Training.
Online mentor: U heeft 24/7 toegang tot een online
mentor voor al uw specifieke technische vragen over het
studieonderwerp. De online mentor is 365 dagen beschikbaar na
activering, afhankelijk van de gekozen Learning Kit.
Voortgangsbewaking: Ja
Toegang tot Materiaal: 365 dagen
Technische Vereisten: Computer of mobiel apparaat,
Stabiele internetverbindingen Webbrowserzoals Chrome, Firefox,
Safari of Edge.
Support of Ondersteuning: Helpdesk en online
kennisbank 24/7
Certificering: Certificaat van deelname in PDF
formaat
Prijs en Kosten: Cursusprijs zonder extra
kosten
Annuleringsbeleid en Geld-Terug-Garantie: Wij
beoordelen dit per situatie
Award Winning E-learning: Ja
Tip! Zorg voor een rustige leeromgeving, tijd en
motivatie, audioapparatuur zoals een koptelefoon of luidsprekers
voor audio, accountinformatie zoals inloggegevens voor toegang tot
het e-learning platform.
Verrijk Uw Carrière met OEM's ICT Trainingen
Waarom kiezen voor
OEM?
Ervaring: Meer dan 20 jaar
expertise in ICT-trainingen.
Uitgebreide Selectie: Meer dan 1000 cursussen van
200 topmerken.
Hoge Tevredenheid: Beoordeeld met een 9.0 op
Springest.
Kwaliteitsgarantie: Gecertificeerde docenten en
award-winning E-learning.
Partnerschappen: Microsoft Partner, EC-Council
Partner, Certiport en Pearson VUE.
Blijf op de hoogte van nieuwe ervaringen
Deel je ervaring
Heb je ervaring met deze cursus? Deel je ervaring en help anderen kiezen. Als dank voor de moeite doneert Springest € 1,- aan Stichting Edukans.Er zijn nog geen veelgestelde vragen over dit product. Als je een vraag hebt, neem dan contact op met onze klantenservice.