Single Table SQL

Single Table SQL

• Videos

  • Welcome to PostgreSQL for Everybody
  • History of Relational Databases
  • Bonus Video: Elizabeth Fong and SQL Standards
  • SQL Architecture
  • Working with Tables and PostgreSQL
  • Data Types in PostgreSQL
  • Database Keys and Indexes in PostgreSQL
  • Demonstration: Making our First Tables
  • Demonstration: Musical Track Database (CSV)

• Slides

  • 01-Intro-to-SQL.ppt

• References

  • Using PostgreSQL on PythonAnywhere
  • Demonstration: Using PostgreSQL on PythonAnywhere
  • Sample SQL For Lecture
  • High Contrast / Printable Slides
  • Demonstration: Using DBeaver Client to Run SQL
  • Download DBeaver Client
• Discussions:
  • Single Table SQL (Login Required)
    
• Tools:
  • Quiz: Single Table SQL (Login Required)
    
  • Autograder: Initial Database Setup (Login Required)
    
  • Autograder: Making our first tables (Login Required)
    
  • Autograder: Inserting some data into a table (Login Required)
    
  • Autograder: Serial Fields / Auto Increment (Login Required)
    
  • Autograder: Musical Track Database (Login Required)