Introduction to SQL

Зміст курсу

Introduction to SQL

Introduction to SQL

1. Getting Started

What is SQL?Setting Up SQL and SSMS Getting Familiar with SSMS Structure of an SQL Database System The SELECT Statement Challenge: First Day as a Librarian Challenge: Find all Book Titles Challenge: Find Book Titles and Authors The DISTINCT Keyword Challenge: Find all Genres

2. Filtering Data

The WHERE Clause Challenge: Help a Reader Find Their Favorite Genre Challenge: Fetching Older Books Conditional Expressions: Comparison Operators Challenge: Avoid the Damaged Books Challenge: Highlight New Arrivals Challenge: Budget-Friendly Books Conditional Expressions: The AND Operator Challenge: Find Specific Books for a Reader Challenge: Defining Ranges Challenge: Multiple Conditions Conditional Expressions: The OR Operator Challenge: Matching Multiple Options Challenge: Excluding A Range Conditional Expressions: The NOT Operator Challenge: Negating a Range

3. Sorting Data

Basic Sorting Challenge: Sorting the Library Catalogue Sorting by Multiple Columns Challenge: Further Sorting the Catalogue Sorting after Filtering Data Challenge: Find the Cheapest Books Challenge: Help a Customer Find a Book The LIMIT Keyword Challenge: Select Books for the Collector's Section Challenge: Affordable Books

4. Populating a Database

Creating a Table Challenge: Creating a new Books Table Inserting Rows into a Table Challenge: Inserting Data Challenge: Inserting More Data Inserting Multiple Rows Challenge: Inserting Bulk Data Primary Keys The SERIAL Keyword Challenge: Changing the Books Structure Specifying Default Values Challenge: Further Improving the Books Table

5. Updating & Deleting Data

Updating Rows in a Table Challenge: Correct Book's Data Challenge: Updating Page Counts Challenge: Mark Archived Books As Unavailable Deleting Rows Challenge: Deleting Outdated Records Duplicating Tables Challenge: Create a Table Backup Challenge: Generate a Summarized Books Table Deleting Tables

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

Завдання

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.

Рішення

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 4. Розділ 2

toggle bottom row

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

Завдання

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.

Рішення

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 4. Розділ 2

Перейдіть на комп'ютер для реальної практикиПродовжуйте з того місця, де ви зупинились, використовуючи один з наведених нижче варіантів

some-alt