SQL Techniques

Intermediate PostgreSQL techniques.

• Videos

  • Tools and Techniques
  • Altering Table Schema
  • Dates
  • DISTINCT / GROUP BY
  • Sub-Queries
  • Concurrency
  • Stored Procedures
  • Reading and Parsing Files
  • Demonstration: Creating and Loading a Database
  • Demonstration: SELECT DISTINCT
  • Demonstration: GROUP BY
  • Demonstration: Sub Query
  • Demonstration: Transactions
  • Demonstration: Stored Procedures
  • Demonstration: Loading and Normalizing CSV Data

• Slides

  • 03-Techniques.pptx

• References

  • Sample SQL For Lecture
  • Sample SQL For CSV Loading
  • Sample CSV Data
  • High Contrast / Printable Slides
• Discussions:
  • SQL Techniques (Login Required)
    
• Tools:
  • Quiz: SQL Techniques (Login Required)
    
  • Autograder: Musical Tracks Many-to-One (Login Required)
    
  • Autograder: Unesco Heritage Sites Many-to-One (Login Required)
    
  • Autograder: Musical Track Database plus Artists (Login Required)