Welcome to the Mini Bootcamp 2024. This session introduces data and finance through two subjects: SQL and prompt engineering—skills for working with data and AI. This recap covers a 2024 event; its schedule, course access and platform details may have changed.
Sound Check and Introductions
Before starting, the host checks the audio and video and asks viewers to confirm in the chat that they can see and hear clearly. The session is intended to be informal and interactive.
Mini Bootcamp 2024 Overview
The bootcamp is described as an opportunity to learn skills for modern work, especially data and AI. Each session is expected to last about 1.5 to 2 hours and cover topics intended for practical use.
Checking Audio and Video
The host checks the sound and picture again to make sure viewers can follow the session.
Last Year’s Bootcamp
The speaker says the previous year’s bootcamp attracted many participants and received positive feedback, and says the team aims to offer a strong learning experience this year.
Course Length and Topics
The program is planned for 3 days. Day 1 introduces SQL and prompt engineering; Day 3 is expected to cover economics and data.
SQL: A Language for Working With Databases
SQL, or Structured Query Language, is used to manage and retrieve information from databases. The session presents it as a foundational skill for data work.
Prompt Engineering: Writing Instructions for AI
Prompt engineering means designing instructions, or prompts, to help an AI system perform a requested task.
Accessing the Online School
The slides and supporting materials are said to be available through the online school, where participants can download them and find additional exercises.
Watching the YouTube Live Stream
Participants can watch on YouTube Live and join the discussion with other viewers.
Watching the Facebook Live Stream
Facebook Live is listed as another place to watch the session.
Watching the Recording Later
A recording is expected to be available in the online school for people who miss the live session.
Day 3: Economics and Data
Day 3 is presented as a session about economics and data, intended to explain how the two areas relate.
Core Topics: SQL and Prompt Engineering
The session introduces SQL and prompt engineering with an emphasis on practical applications.
Download the Slides and Resources
Slides and additional resources can be downloaded from the online school.
Recordings and Schedule
The recording and the full course schedule are said to be uploaded to the online school.
SQL Basics and Use Cases
The session introduces SQL basics and examples of how it can be used to work with databases.
Using AI Effectively
The session discusses ways to use AI as a learning and work aid.
The Fast SQL Course
This section introduces examples of using SQL quickly and effectively.
Writing Prompts With the RICE Framework
The session presents the RICE framework as a way to structure prompts.
Action Verbs and “Teach Me”
The session discusses using action verbs and the instruction “Teach me” to make a request clearer to an AI tool.
Essential SQL: 8 Core Topics
The session says it will cover 8 core SQL topics, which are listed below.
SELECT: Choose Columns
SELECT chooses which columns to return from a table.
WHERE: Filter Rows
WHERE filters rows according to specified conditions.
ORDER BY: Sort Results
ORDER BY sorts results in a chosen order.
LIMIT: Restrict Results
LIMIT caps the number of rows returned.
Aggregate Functions: Summarize Data
Aggregate functions summarize data. The examples named in the session are SUM, AVG and COUNT.
GROUP BY: Group Rows
GROUP BY groups rows so the results can be analyzed by category.
JOIN: Connect Tables
JOIN combines related data from multiple tables.
Introductions and Experience
This section introduces the speaker and his work background.
Meet the Speaker: Toy
Hello, I’m Toy from the Data Rockie page.
Toy’s Work Experience
I work as a data analyst and have run the Data Rockie page for 8 years.
Learning Independently
I believe in self-directed learning and am happy to share what I have learned.
Using AI Effectively
This section returns to ways AI can support learning and work.
AI as a Learning Assistant
Use AI as an assistant for learning and work, rather than treating it as a substitute for understanding the material.
The Right Way to Use Generative AI
The session discusses using generative AI appropriately.
“Teach Me”: Use AI to Learn
The “Teach me” prompt asks an AI tool to explain a subject or guide a learning process.
Sam Altman and the Benefits of AI
The session mentions Sam Altman and discusses potential benefits of AI.
AI for Education
This section considers ways AI can be applied in education.
Using Gemini
The session demonstrates using Gemini.
Prompt Engineering: Designing Instructions
Prompt engineering involves structuring instructions so an AI system can respond to the task you have in mind.
RICE Framework: “Roll,” Instruction, Context and Example
The framework is presented as “Roll, Instruction, Context, Example.” The first word appears as “Roll”; check the original bootcamp materials for the intended term.
Instruction: Use an Action Verb
The session recommends using an action verb in the instruction portion of a prompt.
Essential SQL
This section revisits the 8 core SQL topics.
SELECT: Choose Columns
SELECT specifies the columns you want to retrieve.
WHERE: Filter Rows
WHERE filters the rows in a query.
ORDER BY: Sort Results
ORDER BY sorts the query results.
LIMIT: Restrict Results
LIMIT limits the number of results returned.
Aggregate Functions: Summarize Data
Aggregate functions calculate summaries of data.
GROUP BY: Group Rows
GROUP BY groups rows for analysis.
JOIN: Connect Tables
JOIN connects data across tables.
Writing a Prompt
This section walks through examples of writing prompts.
Use Gemini to Create an SQL Study Plan
The session demonstrates asking Gemini to create a plan for learning SQL.
Example: Writing an SQL Query
This section introduces an example SQL query.
Using Google Sheets to Work With SQL
The session demonstrates a workflow that uses Google Sheets alongside SQL.
Name a Range
Named ranges can make spreadsheet data easier to reference.
Use SELECT
The example uses the SELECT statement.
Use WHERE
The example uses WHERE to filter rows.
Use Columns A, B and C in Google Sheets
The example refers to spreadsheet columns A, B and C.
Use the QUERY Function
The session demonstrates the Google Sheets QUERY function.
Prompt Writing: Specify the Row
The prompt should specify which row or rows the task concerns.
Prompt Writing: State the Instruction
The instruction should say what the AI is being asked to do.
Prompt Writing: Provide Context
Context gives the AI relevant background for the task.
Prompt Writing: Include an Example
An example can show the format or kind of answer you want.
Use Standard SQL
The session refers to using standard SQL in the example.
Use Gemini to Write a Query
The speaker demonstrates using Gemini to draft a query.
Use Backticks
This section covers backticks in the query example.
Summary
- Use AI as a learning aid; understand the SQL and review the output instead of relying on a generated answer without checking it.
- SQL is a language for working with databases.
- Prompt engineering means writing clear instructions for an AI tool.
- AI can be used as a learning assistant.
- The session discusses potential uses of AI in education.
- The session calls for thoughtful use of generative AI.
- The session introduces the RICE prompt framework.
- Action verbs can make instructions clearer.
- The session demonstrates Gemini.
- The 8 essential SQL topics include the following:
- SELECT chooses columns.
- WHERE filters rows.
- ORDER BY sorts results.
- LIMIT restricts the number of results.
- Aggregate functions summarize data.
- GROUP BY groups rows.
- JOIN connects tables.
💬 Get free financial guidance from a specialist. Add us on LINE.
Or scan the QR code to connect.
