Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge: Creating a new Books Table | Populating a Database
Introduction to SQL
course content

Course Content

Introduction to SQL

Introduction to SQL

1. Getting Started
What is SQL?Setting Up SQL and SSMSGetting Familiar with SSMSStructure of an SQL Database SystemThe SELECT StatementChallenge: First Day as a LibrarianChallenge: Find all Book TitlesChallenge: Find Book Titles and AuthorsThe DISTINCT KeywordChallenge: Find all Genres
2. Filtering Data
The WHERE ClauseChallenge: Help a Reader Find Their Favorite GenreChallenge: Fetching Older BooksConditional Expressions: Comparison OperatorsChallenge: Avoid the Damaged BooksChallenge: Highlight New ArrivalsChallenge: Budget-Friendly BooksConditional Expressions: The AND OperatorChallenge: Find Specific Books for a ReaderChallenge: Defining RangesChallenge: Multiple ConditionsConditional Expressions: The OR OperatorChallenge: Matching Multiple OptionsChallenge: Excluding A RangeConditional Expressions: The NOT OperatorChallenge: Negating a Range
3. Sorting Data
Basic SortingChallenge: Sorting the Library CatalogueSorting by Multiple ColumnsChallenge: Further Sorting the CatalogueSorting after Filtering DataChallenge: Find the Cheapest BooksChallenge: Help a Customer Find a BookThe LIMIT KeywordChallenge: Select Books for the Collector's SectionChallenge: Affordable Books
4. Populating a Database
Creating a TableChallenge: Creating a new Books TableInserting Rows into a TableChallenge: Inserting DataChallenge: Inserting More DataInserting Multiple RowsChallenge: Inserting Bulk DataPrimary KeysThe SERIAL KeywordChallenge: Changing the Books StructureSpecifying Default ValuesChallenge: Further Improving the Books Table
5. Updating & Deleting Data
Updating Rows in a TableChallenge: Correct Book's DataChallenge: Updating Page CountsChallenge: Mark Archived Books As UnavailableDeleting RowsChallenge: Deleting Outdated RecordsDuplicating TablesChallenge: Create a Table BackupChallenge: Generate a Summarized Books TableDeleting Tables

book
Challenge: Creating a new Books Table

Congratulations on Your New Job!

You've moved on from your old library to take up a position at a much larger and older library. Unlike your previous job, this library has no digital system — everything is still on paper. Your first responsibility is to modernize their system by creating a database for the library.

First Task: Create a Books Table

As your first task, you are required to create a table to store data about all the available books. Consider which columns to include in the table to ensure the books are easily browsable and manageable.

After some brainstorming, you decide the table should include the following columns:

  • title - The title of the book (VARCHAR, max-length 255);
  • author - The author of the book (VARCHAR, max-length 255);
  • genre - The genre/category of the book (VARCHAR, max-length 100);
  • published_year - The year the book was published (INTEGER);
  • isbn - The International Standard Book Number (VARCHAR, max-length 20);
  • publisher - The publisher of the book (VARCHAR, max-length 255);
  • pages - The number of pages in the book (INTEGER);
  • language - The language of the book (VARCHAR, max-length 50);
  • is_available - Whether the book is available for lending (BOOLEAN).
Task
test

Swipe to show code editor

Your task is to write a query for creating a table called books_table, having the above mentioned columns.

Note

You need to specify exactly the books_table name, it's specified by the task description.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 2
toggle bottom row

book
Challenge: Creating a new Books Table

Congratulations on Your New Job!

You've moved on from your old library to take up a position at a much larger and older library. Unlike your previous job, this library has no digital system — everything is still on paper. Your first responsibility is to modernize their system by creating a database for the library.

First Task: Create a Books Table

As your first task, you are required to create a table to store data about all the available books. Consider which columns to include in the table to ensure the books are easily browsable and manageable.

After some brainstorming, you decide the table should include the following columns:

  • title - The title of the book (VARCHAR, max-length 255);
  • author - The author of the book (VARCHAR, max-length 255);
  • genre - The genre/category of the book (VARCHAR, max-length 100);
  • published_year - The year the book was published (INTEGER);
  • isbn - The International Standard Book Number (VARCHAR, max-length 20);
  • publisher - The publisher of the book (VARCHAR, max-length 255);
  • pages - The number of pages in the book (INTEGER);
  • language - The language of the book (VARCHAR, max-length 50);
  • is_available - Whether the book is available for lending (BOOLEAN).
Task
test

Swipe to show code editor

Your task is to write a query for creating a table called books_table, having the above mentioned columns.

Note

You need to specify exactly the books_table name, it's specified by the task description.

Solution

Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
Everything was clear?

How can we improve it?

Thanks for your feedback!

Section 4. Chapter 2
Switch to desktopSwitch to desktop for real-world practiceContinue from where you are using one of the options below
We're sorry to hear that something went wrong. What happened?
some-alt