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 ==