Conference Schedule - PGConf.EU 2012

Back

A day of SQL with Celko

Date: Oct. 23, 2012
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

EnterpriseDB 2ndQuadrant

Gold Sponsors

VMware Servoy Cybertec

Silver Sponsors

Heroku GoodData Dalibo pgPower


Related Conferences

Postgres Open 2012