Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Challenge: Create a Table Backup | Updating & Deleting Data
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: Create a Table Backup

After working on inserting most of the books into the new library's database, you realize the importance of safeguarding your progress. To prevent accidental data loss or corruption, it's a good idea to create a backup of the books table.

This backup will serve as a safety net, allowing you to restore the data if anything goes wrong in the future.

Task
test

Swipe to show code editor

Your task is to write a query that duplicates the books table and creates a backup table called books_backup.

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 5. Chapter 8
toggle bottom row

book
Challenge: Create a Table Backup

After working on inserting most of the books into the new library's database, you realize the importance of safeguarding your progress. To prevent accidental data loss or corruption, it's a good idea to create a backup of the books table.

This backup will serve as a safety net, allowing you to restore the data if anything goes wrong in the future.

Task
test

Swipe to show code editor

Your task is to write a query that duplicates the books table and creates a backup table called books_backup.

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 5. Chapter 8
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