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.
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.
3 Courses | 6h 3m 53s
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.
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.
In structured query language (SQL), filtering and grouping are fundamental operations that enable precise control and analysis of data. Begin this course by filtering your data using SQL queries. You will learn how to use the WHERE clause with comparison and logical operators to create predicates and how to use the LIKE and IN keywords for filtering. Then you will discover how to read data from a CSV file into a MySQL table using the MySQL workbench. Next, you will work with subqueries to help execute queries using data from multiple tables and you will explore foreign-key constraints to maintain referential integrity. You will examine grouping and aggregation of your data, including simple numeric aggregations like COUNT, SUM, and AVG. Finally, you will perform basic string manipulation and math operations on table columns, divide your data by categorical columns and perform aggregations for each category, and filter the results of grouped and aggregated tables.
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.
Django is a high-level, open-source web framework for building robust and scalable web applications using the Python programming language. Django comes equipped with a rich set of built-in features, including an object-relational mapping (ORM) system for database interactions, a powerful templating engine, and a secure authentication system. You will start this course by diving into Django and learning the model-template-view (MTV) architecture that Django uses. Next, you will install Django and create a basic app, seeking the help of generative AI tools such as ChatGPT and Google Bard to set up a Django project and explore its basic functionality. Then, you will create your own app within the project, focusing on the uses for and responsibilities of the automatically generated files. Finally, you will build a simple web app using Django, starting with a basic view that renders HTML templates that you can access at a URL path. You will learn to include static assets, such as stylesheets and images, and you will deal with misdirection from generative AI tools.
HTML templates and database access play integral roles in modern web development, providing tools to enhance website structure, presentation, and responsiveness. HTML templates serve as the backbone for web pages, defining the document structure and content while database integration serves to make your app serve dynamic, personalized content. Begin this course by adding life to your Django apps with dynamic content. Real apps invariably rely on user input, so you will learn to weave data from Python functions into your HTML templates using template parameters. Then you will use dynamic named URLs to add links between your app's pages. You will use generative AI tools and template inheritance to reduce boilerplate HTML code. Next, you will style and theme your application using Bootstrap templates. Finally, you will dive into data models with Django, using Django's built-in SQLite database and object-relational mapper. You will create a class representing a table and evolve your database schema using migrations.
In Django, data models are the essential building blocks for defining the structure and behavior of a web application's database. Utilizing an object-relational mapping (ORM) system, Django abstracts the database schema into Python classes, allowing developers to interact with the database using high-level, Pythonic syntax. Begin this course by logging into the Django Admin interface, your control center for modifying models, adding users, and performing other administrative actions. You will create a superuser and add a regular user. Next, you will use HTML templates and the associated Python code to dynamically pull data from the models based on user input. Then you will focus on deletion and deactivation of resources. Finally, you will add and modify data. You will create forms in your HTML templates and configure your code to modify resources based on the input. By the end of this journey, you will be well-versed in Django, with skills ranging from creating a user interface using HTML templates to managing data stored in backend databases.