PostgreSQL SQL 30일 학습
== What is SQL And Relational Database == == What is PostreSQL AKA Postrgres == == PostgreSQL Installation (Mac OS) == == PostgreSQL Installation (Windows) == == GUI Clients vs Terminal/CMD Clients == == Setup PSQL (MAC OS) == == Setup PSQL (Windows) == == How to Create Database == == How to Connect to Databases == == A Very Dangerous Command == == How To Create Tables == == Creating Tables Without Constraints == == Creating Tables with Constraints == == Insert Into == == Insert Into Example == == Generate 1000 Rows with Mockaroo == == Select From == == Order By == == Distinct == == Where Clause and AND == == Comparison Operators == == Limit, Offset & Fetch == == IN == == Between == == Like And iLike == == Group By == == Group By Having == == Adding New Table And Data Using Mockaroo == == Calculating Min, Max & Average == == Sum == == Basics of Arithmetic Operators == == Arithmetic Operators (ROUND) == == Alias == == Coalesce == == NULLIF == == Timestamps And Dates Course == == Adding And Subtracting With Dates == == Extracting Fields From Timestamp == == Age Function == == What Are Primary Keys == == Understanding Primary Keys == == Adding Primary Key == == Unique Constraints == == Check Constraints == == How to Delete Records == == How to Update Records == == On Conflict Do Nothing == == Upsert == == What Is A Relationship/Foreign Keys == == Adding Relationship Between Tables == == Updating Foreign Keys Columns == == Inner Joins == == Left Joins == == Deleting Records With Foreign Keys == == Exporting Query Results to CSV == == Serial & Sequences == == Extensions == == Understanding UUID Data Type == == UUID As Primary Keys == == Conclusion ==