nhannn87dn/learn-postgresql

Learn-PostgreSQL

Note: cập nhật lại staff có gender

Why PostgreSQL ?

• PostgreSQL is an advanced relational database system.
• PostgreSQL supports both relational (SQL) and non-relational (JSON) queries.
• PostgreSQL is free and open-source.
• PostgreSQL is a back-end database for dynamic websites and web applications.
• PostgreSQL supports the most important programming languages: Python, Java, C/C++, C#, Node.js, Go, Ruby, Perl, Tcl

Outline

PostgreSQL

1. Database Design Concept
2. Normalization and Intro PostgreSQL
3. Databases, Data Type and Table
4. Modifying Data: Insert, Update, Delete
5. Querying Data: Select, Group by, Grouping sets, Cube, and Rollup
6. Advanced Queries and Joins: Sub Query, Join, Union
7. Transactions, Conditional Expressions & Operators
8. PL/pgSQL: Variables & constants, Control structure, Function, Exception handling, Stored procedures
9. Views and Triggers
10. Indexes and PostgreSQL Administration

References

• https://www.postgresql.org/docs/current/index.html
• https://www.w3schools.com/postgresql/index.php
• https://www.tutorialspoint.com/postgresql/
• https://www.tutorialsteacher.com/postgresql
• https://github.com/dwyl/learn-postgresql
• https://render.com/docs/databases
• https://www.w3schools.com/postgresql/postgresql_create_demodatabase.php
• https://www.w3resource.com/PostgreSQL/tutorial.php

Best Guides

• https://www.postgresqltutorial.com
• https://launchschool.com/books/sql_first_edition/read/multi_tables#designingtables