Basic SQL Queries
Master the four basic operations of SQL (CRUD) to interact with your PostgreSQL tables.
Master the four basic operations of SQL (CRUD) to interact with your PostgreSQL tables.
Learn how to choose between Relational and Non-Relational databases and how to design for scale.
Rapid-fire reference guides for Git, Linux, SQL, and Frontend frameworks.
Learn the basics of data persistence and the difference between SQL and NoSQL databases.
Learn how to speed up your database queries using indexes and understand when to use them.
Learn how to connect different tables using Primary Keys, Foreign Keys, and Joins.
Step-by-step guide to installing PostgreSQL locally and using pgAdmin for database management.