The assignment content consists of six tables: 'Country', 'Genre', 'Publisher', 'Song_at_youtube', 'songs', and 'song_sales'. The content also includes several SQL queries designed to extract specific data from the tables. Some of the queries are used to identify top-rated songs, low-rated songs, and genre distribution. Another query is used to find artists who were born after 1980.