Welcome to the Opteryx Labs! These hands-on labs are designed to guide you from the fundamentals of SQL querying to mastering complex data operations with Opteryx. Whether you’re a data science enthusiast, a software developer, or a seasoned data analyst, these labs will enhance your data manipulation skills and expand your understanding of data querying.
The Opteryx Labs series offers a structured approach to learning how to effectively use Opteryx for executing SQL queries across various data scenarios. Each lab builds on the last, increasing in complexity and introducing more advanced techniques.
-
Lab 101.01 - Simple Query & Display: Dive into the world of Opteryx with a straightforward SQL query. This introductory lab will teach you how to execute a simple SQL query and visually display the results, setting a solid foundation for more complex operations.
-
Lab 101.02 - Query a Local File: Expand your skills by querying data directly from local files. This lab will guide you through setting up and executing an SQL query against a Parquet file, enhancing your ability to handle file-based data sources.
-
Lab 101.03 - Draw a Simple Chart: Learn to combine SQL querying with data visualization. In this lab, you will use results from Opteryx queries to create a basic chart using Matplotlib, illustrating the power of integrating SQL results with Python's data visualization capabilities.
To get the most out of these labs, ensure you have a Python environment set up with Opteryx installed. Each lab includes detailed instructions on prerequisites, setup, and step-by-step guidance through each exercise. The labs are designed to be followed in sequence, but feel free to jump ahead if you feel confident in your current skills.
- Python 3.9 or later
- Opteryx installed in your environment (instructions provided in lab 101.01)
- Basic knowledge of SQL and Python
Each lab is presented as a Jupyter Notebook. To get started:
- Open in Binder: Click on the "Launch Binder" badge to open the pre-loaded Jupteryx Labs instance in your web browser.
- Navigate to the Labs: Each lab in the "Opteryx 101" folder has a short description, labs will open in a Notebook.
- Run Cells: Follow the instructions in each lab to run the Notebook cells and complete the exercises.
We welcome contributions to the Opteryx Labs! If you have suggestions for improvements or new lab ideas, please feel free to submit a pull request or open an issue via GitHub. Your input is invaluable in keeping the labs up-to-date and relevant.
All content in the Opteryx Labs repository is provided under the Apache 2.0 License - see the LICENSE file for details.
Explore the labs at your own pace, challenge yourself with the exercises, and don’t hesitate to reach out if you have any questions. Happy querying!