Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Oppiskele Challenge: Inserting Bulk Data | Populating a Database
Introduction to SQL
course content

Kurssisisältö

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: Inserting Bulk Data

Instead of inserting books one by one, you can make the process faster by adding multiple records in a single INSERT statement. This is particularly useful when populating a large database.

Tehtävä

Swipe to start coding

Your task is to insert the given data into the table using a single INSERT statement. Insert of manually writing the values, you can copy the data from the snippet below:

  1. ('The Old Man and the Sea', 'Ernest Hemingway', 'Fiction', 1952, '9780684801223', 'Charles Scribner''s Sons', 127, 'English', TRUE)

  2. ('Frankenstein', 'Mary Shelley', 'Horror', 1818, '9780486282114', 'Lackington, Hughes & Co.', 280, 'English', TRUE)

  3. ('Les Misérables', 'Victor Hugo', 'Historical Fiction', 1862, '9780451419439', 'A. Lacroix, Verboeckhoven', 1488, 'English', TRUE)

  4. ('Brave New World', 'Aldous Huxley', 'Dystopian', 1932, '9780060850524', 'Chatto & Windus', 268, 'English', TRUE)

  5. ('The Adventures of Sherlock Holmes', 'Arthur Conan Doyle', 'Mystery', 1892, '9780141034323', 'George Newnes', 307, 'English', TRUE)

Note

Please insert the data in the given order!

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 4. Luku 7
toggle bottom row

book
Challenge: Inserting Bulk Data

Instead of inserting books one by one, you can make the process faster by adding multiple records in a single INSERT statement. This is particularly useful when populating a large database.

Tehtävä

Swipe to start coding

Your task is to insert the given data into the table using a single INSERT statement. Insert of manually writing the values, you can copy the data from the snippet below:

  1. ('The Old Man and the Sea', 'Ernest Hemingway', 'Fiction', 1952, '9780684801223', 'Charles Scribner''s Sons', 127, 'English', TRUE)

  2. ('Frankenstein', 'Mary Shelley', 'Horror', 1818, '9780486282114', 'Lackington, Hughes & Co.', 280, 'English', TRUE)

  3. ('Les Misérables', 'Victor Hugo', 'Historical Fiction', 1862, '9780451419439', 'A. Lacroix, Verboeckhoven', 1488, 'English', TRUE)

  4. ('Brave New World', 'Aldous Huxley', 'Dystopian', 1932, '9780060850524', 'Chatto & Windus', 268, 'English', TRUE)

  5. ('The Adventures of Sherlock Holmes', 'Arthur Conan Doyle', 'Mystery', 1892, '9780141034323', 'George Newnes', 307, 'English', TRUE)

Note

Please insert the data in the given order!

Ratkaisu

Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Oliko kaikki selvää?

Miten voimme parantaa sitä?

Kiitos palautteestasi!

Osio 4. Luku 7
Switch to desktopVaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista
Pahoittelemme, että jotain meni pieleen. Mitä tapahtui?
some-alt