# Study Material for the SQL Quiz

https://www.interviewbit.com/sql-cheat-sheet/

https://www.guru99.com/database-normalization.html (We will cover only up to 3NF)



# Serverless Databases

[2023 State of Databases for Serverless & Edge](https://leerob.io/blog/backend)

[Choosing a serverless database for a serverless app](https://gimenete.net/articles/choosing-serverless-database-for-serverless-app)

[Watch Video](https://www.youtube.com/watch?v=giOwMptqexk)

Our standard learning Database will be [Vercel Postgres](https://vercel.com/docs/storage/vercel-postgres)

Vercel Postgres is actually [Neon](https://neon.tech/) which is a Serverless Postgres Database

[Postgres benchmarks between popular ORM libraries](https://github.com/drizzle-team/drizzle-northwind-benchmarks-pg#sample-runs)

We will learn to develop API's using Next.js 13. In order to learn API development we will also cover DBMS Design and Implementation in detail:

1. [What is Neon](https://neon.tech/docs/introduction/about)
2. [Follow Vercel Official Docs](https://vercel.com/docs/storage/vercel-postgres)
3. [Getting Started with Vercel Postgres](https://vercel.com/docs/storage/vercel-postgres/quickstart)
4. [Review Kysely](https://koskimas.github.io/kysely/)
5. [Vercel Postgres + Kysely Next.js Starter](Vercel Postgres + Kysely Next.js Starter)
6. [Introduction to DBMS: Designing and Implementing Databases from Scratch for Absolute Beginners
by Dr. Hariram Chavan, Prof. Sana Shaikh](https://www.amazon.com/Introduction-DBMS-Designing-Implementing-Databases-ebook/dp/B09ZXGWLHW/ref=sr_1_1)
7. [What is Normalization in DBMS (SQL)? 1NF, 2NF, 3NF Example](
https://www.guru99.com/database-normalization.html)
8. [Mastering PostgreSQL 15: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications, 5th Edition 5th ed. Edition](https://www.amazon.com/Mastering-PostgreSQL-techniques-fault-tolerant-applications/dp/1803248343/ref=sr_1_1)
9. [Watch Raw SQL, SQL Query Builder, or ORM?](https://www.youtube.com/watch?v=x1fCJ7sUXCM)



