sungyup's.

Back to Study
PostgreSQL
class

PostgreSQL

Udemy PostgreSQL 강의 정리

Stephen Grider
34 posts

SQL Basics

1.1
Intro
1.2
Filtering Records
1.3
Working with Tables
1.4
Joins
1.5
Aggregation and Grouping
1.6
Sorting
1.7
Unions and Set
1.8
Subquery
1.9
Distinct
1.10
Utility Operators

PostgreSQL

2.1
Postgres Admin
2.2
Complex Datatypes
2.3
Database-Side Validation and Constraints

Database Structure Design Patterns

3.1
SQL Design Tool
3.2
"Like" System
3.3
"Mention" System
3.4
"Hashtag" System
3.5
Implementing Database Design Patterns
3.6
Writing Complex Queries

Postgres Deep Dive

4.1
Understanding the Internals of PostgreSQL
4.2
A Look at Indexes for Performance
4.3
Behind the Scenes of Indexes
4.4
Basic Query Tuning
4.5
Advanced Query Tuning

CTE & Views

5.1
Common Table Expressions
5.2
Simple Queries With Views
5.3
Optimizing Queries with Materialized Views
5.4
Handling Transactions

Managing Database Design with Schema Migrations

6.1
Schema Migrations
6.2
Schema vs Data Migrations
6.3
Accessing PostgreSQL FROM API's
6.4
Data Access Pattern-Repositories
6.5
Security Around PostgreSQL

Testing

7.1
Fast Parallel Testing