- This repository contains all books, cheat sheets, general learning materials, coding files and snippets. As well as, link to Hackerrank profile when solving challanges.
The repository would contain all the source code files, including:
- SQL Scripts
Either in a form of screenshots or files e.g. Jupyter, or SQL extracts.
PDF files, such as research papers, books, or project documentation
-
E - Books & Cheet sheets
-
Practical SQL: A Beginner's Guide to Storytelling with Data
Link:
https://github.com/anthonydb/practical-sql
- SQL Cheat Sheets
A range of cheat sheets that describe common features, keywords, and functions within SQL.
PDF Guides
3 Examples of Database Normalisation
Database Modelling Tools Spreadsheet
Database Normalisation Checklist A range of database design guides for different domains: an ERD, table and column definitions, and SQL scripts.
AirBNB eCommerce website Train booking system Hotel booking system Online course system eCommerce Products (and the SQL scripts are here) Movie theatre booking (and the SQL scripts are here) Oracle Certified Associate Practice Questions (1Z0-071)
Data Analysis Project Guides
- A PDF to help you prepare the data, with a list of questions, and Select queries to answer those questions.
Population Analysis (from this YouTube video) Car Sales Analysis (from this YouTube video) Olist eCommerce PDF of Posts
And many more
Mainly but not limited to the following:
-
PGAdmin & PSQL
-
SQL Server & TSQL
-
MySQL Workbench & Server (Previously)
-
SQLite
-
DBeaver
- Universal Database Tool:
Link:
- Projects:
Celestial Bodies Database
World Cup Database
Salon Appointment Scheduler
Periodic Table Database
Number Guessing Game
- Hackerrank problem challanges
Profile Link:
- Awesome SQLite with learning resources:
https://github.com/planetopendata/awesome-sqlite
- Awsome datasets collections:
Football: https://github.com/openfootball/awesome-football
Geo-spacial datasets: https://github.com/planetopendata/awesome-world
- Ready-to-Use (Instant) Database Schemas
football.db (github: openfootball/schema.sql) - teams, competitions, seasons, matches, goals, rounds, groups, etc.
beer.db (github: openbeer/schema.sql) - beer, brand, brewery, etc.
Chinook Database (codeplex: chinookdatabase), (chinook.sqlite Download) - online music store (artists, albums, genres, playlists, media tracks, customers, invoices, employees) with sample data; inspired by the
"classic" Microsoft Northwind database Northwind.db (github: jpwhite3/northwind-SQLite3, Swift pkg: NorthwindSQLite.swift) - food store (customers, products, orders, employees, suppliers, ...) with sample data; port of the "classic" Microsoft Northwind database
SQLite Web Service (JSON API) Publishers / Containers
- Turn your Database into Ready-to-Use (Instant) Online Web Services (JSON APIs) w/ Query Language (QL)
Datasette (github: simonw/datasette) by Simon Willison - an instant JSON API for your SQLite databases
SQLPage (github: lovasoa/sqlpage) - build dynamic websites entirely in SQL on top of SQLite databases
employees.db: https://github.com/fracpete/employees-db-sqlite
-
This repository contains sample databases for the Build Your Own SQLite challenge.
-
General Sample databases:
sample.db:
This is a tiny database used in stages 1-6. It contains two tables: apples and oranges.
superheroes.db:
This is a small version of the test database used in stage 6. It contains one table: superheroes. It is ~1MB in size.
companies.db:
This is a small version of the test database used in stage 7. It contains one table: companies, and one index: idx_companies_country It is ~7MB in size.
An app sample databases.
-
Panamapapers DB and other OFFSHORE LEAKS DATABASES by ICIJ:
ICIJ GitHub repo:
A zip archive with all CSV files:
Link:
https://offshoreleaks.icij.org/pages/database
Offshore Leaks (2013) Panama Papers (2016) Bahamas Leaks (2016) Paradise Papers (2017) Pandora Papers (2021)
ERDs
Link to the shape of the data:
https://offshoreleaks-data.icij.org/offshoreleaks/neo4j/guide/datashape.html
1 x PNG file
-
Northwind DB - Trading and inventory management
-
Chinook DB - Digital media store
-
car_company_database-master
-
sakila-sqlite3-main DB - Online DVD rental
-
Employees Database:
Link:
https://github.com/fracpete/employees-db-sqlite
- SportsDB Sample Database:
Link:
https://github.com/yugabyte/yugabyte-db/wiki/SportsDB-Sample-Database
- Airlines Sample Database:
Link:
https://github.com/prameshstha/airline-database
- AdventureWorks for PostgreSQL:
Link:
https://github.com/lorint/AdventureWorks-for-Postgres
- Employees for PSQL:
Link:
https://github.com/vrajmohan/pgsql-sample-data/tree/master/employee
- Massive IMDb database:
Link:
https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/2QYZBT
- PostgreSQL list of sample databases:
Link:
https://wiki.postgresql.org/wiki/Sample_Databases
- Postgres sample data for learning:
Link:
https://neon.tech/docs/import/import-sample-data
- PSQL Airlines Sample Database:
Link:
https://postgrespro.com/docs/postgrespro/12/demodb-bookings
- PgFoundry project
Link:
https://www.postgresql.org/ftp/projects/pgFoundry/
- OpensourceShakespeare
Link:
https://github.com/catherinedevlin/opensourceshakespeare
- MusicBrainz Database
Link:
https://musicbrainz.org/doc/MusicBrainz_Database/Download
- Microsoft SQL samples:
Link:
https://learn.microsoft.com/en-us/sql/samples/sql-samples-where-are?view=sql-server-ver16
- Banking Sample Database:
Link:
https://github.com/panaitescu-paul/Bank-Database-SQL-2020
For MYSQL: https://github.com/haggarw3/sql-bank-data
- School database model:
Link:
https://github.com/OrnellaFanais/SQL-DB
- TravelAgencyProjectDB:
Link:
https://github.com/Ladydiana/TravelAgencyProjectDB
- MovieLens data and database:
Link:
https://github.com/ankane/movielens.sql
https://github.com/ivelten/MovieLens
copy of https://www.postgresql.org/ftp/projects/pgFoundry/dbsamples/
- A collection of sample databases for PostgreSQL.
Adventureworks - OLTP database for a fictitious, multinational manufacturing company called Adventure Works Cycles
Chinook - digital media store
French Towns - all French towns and regions
ISO-3166 - All countries and subcountries in the world
Pagila - Movie rental database with actors, ratings, payments, etc.
Role Based Access Control - authentication solution
USDA - food database
Northwind DB for PSQL - Trading and inventory management: https://github.com/pthom/northwind_psql?tab=readme-ov-file
World - Cities, Countries, and what language they speak
DVD Rental DB
Other Resources
http://www.databaseanswers.org/data_models/
https://github.com/morenoh149/postgresDBSamples
All Previous Databases can be exported to SQL server, MySQL and vice versa
https://app.codecrafters.io/courses/sqlite/overview
- Migrating from SQLite to PostgreSQL:
https://stackoverflow.com/questions/4581727/how-to-convert-sqlite-sql-dump-file-to-postgresql
- Exporting SQLite to SQL Server:
https://stackoverflow.com/questions/163079/exporting-from-sqlite-to-sql-server
- Migrating PSQL to SQL Server:
- Migrating SQLite to MySQL:
https://stackoverflow.com/questions/18671/quick-easy-way-to-migrate-sqlite3-to-mysql
https://hevodata.com/learn/sqlite-to-mysql/
- Migrating PSQL to MySQL:
https://stackoverflow.com/questions/5909223/migrate-database-from-postgres-to-mysql
- Migrating SQL Server to MySQL:
https://stackoverflow.com/questions/3917081/how-to-export-sql-server-database-to-mysql
https://www.vinchin.com/webinar.html
README.md: A markdown file providing an overview of the project, setup instructions, and usage guidelines
Additional markdown files explaining specific aspects of the project
License file
Notes for professionals books also included, just pick our poison:
- SQL
- PosgreSQL
- MySQL
- MongoDB
- Microsoft SQL