Schedule - PGConf.EU 2012

A day of SQL with Celko

Date: 2012-10-23
Time: 09:00–17:00
Room: Vltava
Level: Intermediate

Morning: Data & DDL

1. Data
   1. Scales & Measurements
   2. Encoding Schemes
   3. Data Types
2. Data Modeling
   1. What A Schema Is And Is Not
   2. What A Table Is And Is Not
   3. What A Row Is And Is Not
   4. What A Column Is And Is Not
3. Common design problems
   1. Misplaced Attributes
   2. Attribute splitting
   3. EAV
   4. Missing constraints
   5. Lack of DRI

LUNCH

Afternoon: Queries & SQL Idioms

1. How SELECT Works
2. Fancy Queries
   1. Joins
   2. Set Operations
   3. Grouping vs Equality
   4. Window Clauses & Aggregates
3. SQL Features Nobody Knows About
   1. INSERT DEFAULT VALUES
   2. Views that use WITH CHECK OPTION
4. Idioms
   1. Nested Sets Model
   2. Lookup Tables
   3. Calendar Tables
   4. Series Table
5. Report Period Table

Speaker

Joe Celko

Platinum Sponsors

Gold Sponsors

Silver Sponsors

---

Related Conferences