_toc.yml

# Table of contents
# Learn more at https://jupyterbook.org/customize/toc.html

format: jb-book
root: index
parts:
- caption: JupyterBook authors
  chapters:
  - file: contributors/contributors
- caption: Introduction to exploratory data analysis with SQL and Jupyter
  chapters:
  - file: exploratory-data-analysis-with-sql/absenteeism-dataset
- caption: Introduction to SQL
  chapters:
  - file: intro-to-sql/connecting-to-databases
  - file: intro-to-sql/making-your-first-query
  - file: intro-to-sql/aggregate-functions-in-sql
  - file: intro-to-sql/joining-data-in-sql
  - file: intro-to-sql/combining-data-from-multiple-tables
- caption: Interactive Queries and Parameterization
  chapters:
  - file: interactive-queries-and-parameterization/introduction-to-ipywidgets
  - file: interactive-queries-and-parameterization/parameterize-sql-queries
  - file: interactive-queries-and-parameterization/make-your-queries-interactive
- caption: Advanced Querying Techniques
  chapters:
  - file: advanced-querying-techniques/subqueries
  - file: advanced-querying-techniques/advanced-joins
  - file: advanced-querying-techniques/advanced-aggregations
  - file: advanced-querying-techniques/ctes
- caption: Visualizing Your SQL Queries
  chapters:
  - file: visualizing-your-sql-queries/types-of-visualizations
  - file: visualizing-your-sql-queries/plotting-with-seaborn
  - file: visualizing-your-sql-queries/plotting-with-plotly
  - file: visualizing-your-sql-queries/plotting-with-ggplot
- caption: Packaging Your SQL Project
  chapters:
  - file: packaging-your-sql-project/introduction-to-the-dataset-and-problem
  - file: packaging-your-sql-project/intro-to-python-scripting-and-pipelines
  - file: packaging-your-sql-project/intro-to-etl-pipelines-with-python-and-sql
  - file: packaging-your-sql-project/containerizing-etl-with-docker
  - file: packaging-your-sql-project/etl-eda-pipeline-with-ploomber
- caption: Introduction to Dashboards and Apps
  chapters:
  - file: intro-to-dashboards-and-apps/connecting-etl-to-dashboard-with-voila
- caption: Mini projects - Movie recommendation system
  chapters:
  - file: mini-projects/recommendation-system/introduction
  - file: mini-projects/recommendation-system/intro-to-rec-systems
  - file: mini-projects/recommendation-system/setting-up-poetry
  - file: mini-projects/recommendation-system/setting-up-etl
  - file: mini-projects/recommendation-system/eda-with-jupyter
  - file: mini-projects/recommendation-system/setting-up-a-recommendation-system
  - file: mini-projects/recommendation-system/setting-up-fastapi
  - file: mini-projects/recommendation-system/adding-tests
  - file: mini-projects/recommendation-system/packaging-with-docker
- caption: Deploying Your SQL Applications
  chapters:
  - file: deploying-your-sql-applications/cloud-based-options
  - file: deploying-your-sql-applications/automate-ci-cd-with-github-actions
  - file: deploying-your-sql-applications/sample-aws-deployment-workflow