This repo contains notes on SQL and PostgreSQL
-
Updated
Oct 6, 2022 - PLpgSQL
This repo contains notes on SQL and PostgreSQL
Personal comprehensive reference guide for Postgres, Knex, and SQL
This module covers techniques to optimize query execution, such as creating indexes, and query planning, that improve performance. It will also introduce tools and techniques for terminating inefficient queries that are consuming our database resources.
Practical SQL tasks for learning core database queries
This project demonstrates how to analyze a restaurant database. Data was organized into a MySQL 8.0 database using MySQL Workbench/Navicat, then migrated to Google CloudMySQL. Looker Studio is used to visualize insights.The project showcases an end-to-end workflow: database design, SQL querying, and interactive reporting
This repository features a PostgreSQL database designed to efficiently manage data related to solar panel systems.
Relational database project for managing sports competitions and teams, designed with conceptual and logical modeling, SQL queries, views, and triggers.
Building strong foundations in PostgreSQL.
☕️🎵 A Music-Centric social network database development
Add a description, image, and links to the sql-queries topic page so that developers can more easily learn about it.
To associate your repository with the sql-queries topic, visit your repo's landing page and select "manage topics."