Introduction to SQL

Challenge: First Day as a Librarian

Welcome to Your First Day as a Librarian!

It's your first day as a librarian, and you're eager to get familiar with the entire library catalog. To get a complete overview of the collection, you want to see every detail available for each book in the library's database, including the title, author, publication year, and genre. This full view will help you understand what kinds of books are available at a glance.

Tarea

Swipe to start coding

Write a SQL query to retrieve all columns from the Books table so you can get a complete overview of each book in the library.

_{Once you've completed this task, click the button below the code to check your solution.}

Solución

¿Todo estuvo claro?

¡Gracias por tus comentarios!

Sección 1. Capítulo 6

Query Result

Introduction to SQL

1. Getting Started

This section will introduce you to coding in SQL. It will start with some basic information related to SQL and SQL Databases in general, eventually moving towards writing basic SQL queries. The section also includes some fun exercises where you will get to practice the SQL syntax.

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

We will get an introduction to filtering data from our selections. This will give us control over what kind of data we fetch from the database. This section will cover the syntax for filtering data and various operators which can help us write robust conditions for conditional selection of 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

This section focuses on concepts related to sorting the tables based on the column values. Sorting can be useful in extracting the minimum or maximum values from a column or for making it easier to find relevant information quickly. We will also look at a keyword which can help us limit the number of rows that are fetched by our SELECT statements, making our queries more concise.

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

You will learn about useful queries and keywords that can help us in populating a database with some data. This will include queries for creating tables, and for inserting rows into those tables. We will also cover two additional keywords that can help us in making our tables more intractable and robust.

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

We will look at how to modify or delete data in an SQL database. This will include queries for updating or deleting rows in a table and making a copy of a table or deleting it.

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