Kurssisisältö
Introduction to SQL
Introduction to SQL
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
Challenge: Inserting Data
With the library's books table set up, it's time to start filling it with data! As part of your job, you'll add records for the books already in the library.
Tehtävä
Swipe to start coding
Your task is to insert a row into the books table with the following data:
- Title: Robinson Crusoe
- Author: Daniel Defoe
- Genre: Adventure
- Published Year: 1719
- ISBN: 9780141439822
- Publisher: Penguin Classics
- Pages: 320
- Language: English
- Availability: Yes
Use the general syntax for inserting the row into the table.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaOliko kaikki selvää?
Kiitos palautteestasi!
Osio 4. Luku 4
Challenge: Inserting Data
With the library's books table set up, it's time to start filling it with data! As part of your job, you'll add records for the books already in the library.
Tehtävä
Swipe to start coding
Your task is to insert a row into the books table with the following data:
- Title: Robinson Crusoe
- Author: Daniel Defoe
- Genre: Adventure
- Published Year: 1719
- ISBN: 9780141439822
- Publisher: Penguin Classics
- Pages: 320
- Language: English
- Availability: Yes
Use the general syntax for inserting the row into the table.
Ratkaisu
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoistaOliko kaikki selvää?
Kiitos palautteestasi!
Osio 4. Luku 4
Vaihda työpöytään todellista harjoitusta vartenJatka siitä, missä olet käyttämällä jotakin alla olevista vaihtoehdoista