Start Building Real Tech Skills.
Learn the skills to transform raw data into organized, actionable systems.
Data Querying
Data querying is the process of asking a database or dataset for specific information. A query allows you to search, filter, and retrieve the data you need from a larger collection of data. Data querying helps people analyze information and answer questions using structured data.
What Are Tech Kit Modules?
Tech Kits are part of the walk-in service provided by Innovate Labs. If you have no prior experience, start with Beginner. If you have some experience, explore Intermediate kits, and move on to Advanced when you’re ready.
Beginner
Build Basic Queries with SQL
Length: 30 Minutes Description: This beginner tech kit introduces students to Structured Query Language (SQL) and the fundamentals of working with databases. Participants will learn how to import data, create database views, and perform basic SQL queries using DB Browser and SQLite. Through guided exercises, students will practice retrieving and modifying structured datasets while developing foundational data analysis skills used across many industries.Intermediate
Analyze Multi-Table Queries with SQL
Length: 45 Minutes Description: This intermediate tech kit expands on SQL fundamentals by integrating database queries with Python-based data analysis and visualization. Participants will retrieve data from SQL databases, process and organize it using Python libraries such as NumPy, and create visualizations using Matplotlib. By combining database querying with programming workflows, students will learn how data pipelines are built for real-world analysis and research applications.Version Control
System created to manage file changes over time allowing many developers to collaborate together effectively. Ability to track changes and revert to previous versions in the past. Allows experimentation with new features without affecting the main version. Git is a version control system. It allows developers to track changes and collaborate with each other on the same code. All changes and updates are tracked and you can go back to different versions without interfering with each other’s work. Once your account is verified, sign in with your new account. GitHub can automatically combine different versions of a project, making team development easier. GitHub is a hosting service for Git repositories.
What Are Tech Kit Modules?
Tech Kits are part of the walk-in service provided by Innovate Labs. If you have no prior experience, start with Beginner. If you have some experience, explore Intermediate kits, and move on to Advanced when you’re ready.
Beginner
Introducing GitHub Browser
Length: 30 Minutes Description: In this tech kit, participants learn how to transform and prepare raw datasets for meaningful analysis. Using Microsoft Power BI, students will import a real marketing dataset and practice essential data cleaning techniques such as renaming fields, filtering rows, removing duplicates, handling missing values, and creating custom calculated columns. These steps prepare the dataset for visualization and help participants understand how analysts convert raw information into structured data that can support business decisions and data-driven insights.Intermediate
GitHub Desktop & Git Command Line
Length: 45 Minutes Description: In this tech kit, participants learn how developers track and manage changes in collaborative coding projects. Using GitHub Desktop, Visual Studio Code, and the Git command line, students will clone a repository, create branches, edit files locally, commit changes, and push updates to a remote GitHub repository. Through both graphical tools and command-line workflows, participants gain hands-on experience with version control systems that are widely used in software development, research, and collaborative technical projects.Advanced Project
What Are Advanced Tech Kit Modules?
The Advanced level combines concepts from both Beginner and Intermediate Tech Kits into a more integrated, hands-on experience. Participants will apply foundational skills alongside more complex tools and workflows to complete a comprehensive project. This level is designed for those who are comfortable with the basics and ready to connect multiple concepts to build more advanced, real-world solutions.
Advanced
Design a Data Pipeline with SQL/GitHub
Length: 60 Minutes Description: Students design integrated systems by combining database design with version-controlled workflows into collaborative solutions.Click Here for Advanced Tech Kit →
Resources
SQLite
Type: Programming Language
Description: SQLite is a lightweight, open source, distribution of SQL.
DB Browser
Type: Application
Description: DB Browser allows users to utilize SQLite and create new databases or connect existing ones.
Python 3.12
Type: Programming Language
Description: Python is an interpreted high-level programming language for general-purpose programming. Version 3.12 is a part of the many new versions that continuously are being put out.
Visual Studio Code
Type: Application
Description: VSCode is a free, open source application that allows users to edit code with the help of built0in programming features.
Git
Type: Software
Description: Git is a version control system that allows developers to track changes and collaborate with each other on the same code. You can think of Git as a developer’s version of Google Docs.
Github Desktop
Type: Application
Description: GitHub is a hosting service for git repositories. It is a great way to collaborate with others, learn new ideas, and show off the work that you have done.