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

Cursusinhoud

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).
Taak

Swipe to start coding

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.

Oplossing

Switch to desktopSchakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties
Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 4. Hoofdstuk 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).
Taak

Swipe to start coding

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.

Oplossing

Switch to desktopSchakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties
Was alles duidelijk?

Hoe kunnen we het verbeteren?

Bedankt voor je feedback!

Sectie 4. Hoofdstuk 2
Switch to desktopSchakel over naar desktop voor praktijkervaringGa verder vanaf waar je bent met een van de onderstaande opties
Onze excuses dat er iets mis is gegaan. Wat is er gebeurd?
some-alt