Tudor Ilisoi tudorilisoi

## nw-sql-drills.md

      
        
          
            
              
              1 file
            
          
          
            
              
              0 forks
            
          
          
            
              
              0 comments
            
          
          
            
              
              0 stars
            
          
        
        
          
              
          
          
            
                tudorilisoi
                / nw-sql-drills.md
            
            
              Last active
              October 28, 2019 21:05
                — forked from alfaraday/nw-sql-drills.md
            
          
        
      
        
  
      
    In these drills, you'll practice executing basic CRUD (create, read, update, delete) operations in the psql shell.
Before you get started, download this SQL data dump. Create and populate a new database using the data dump (make sure to update the path with the location where you saved the file):
psql -U dunder_mifflin_admin -d restaurants-app -f ~/Downloads/nyc-restaurants-data-backup.sql
Take a moment to get familiar with this new database. You can use \dt+ to see a list of public tables and  \d <TABLENAME> to see a description of those tables.