In this module- we'll learn the basics of SQL.

The purpose of this module isn't to make you an expert in SQL, or even to give you all the necessary tools to build applications with SQL. The goal is to give you a basic understanding of what SQL is, how it works, and why it's important.

It will provide you with a foundation that you can build on as you continue to learn more about SQL and databases, as well as give you the opportunity to learn and get hands-on experience with SQL and queries without having to write an entire application.

The in SQL are just as important as the actual code you'll write in your application. Understanding the concepts behind SQL will help you write better queries, design better databases, and make better decisions about how to store and retrieve data- no matter what tools you're using.

If you already have a strong understanding of SQL, feel free to move directly to the First Lesson in the Prisma Section to learn about Prisma.

What is SQL?

SQL stands for Structured Query Language. It's a special language that we use to talk to databases. Just like how we use different languages to communicate with people from different countries, SQL is the language we use to communicate with databases.

Giving Instructions to Databases

Imagine you have a big library with lots of books. The database is like that library, and the data inside the database is like the books. SQL is like the language you use to tell the librarian what books you want to find, add, or remove from the library. With SQL, you can give the database different instructions, such as:

• Find all the books written by a specific author.
• Add a new book to the library.
• Remove a book from the library.
• Update the information about a book.

Retrieving Information

One of the most common things we use SQL for is to get information from a database. It's like asking the librarian to find a specific book or a group of books based on certain rules. For example, you could say, "Find all the books about dinosaurs that were published in the last 5 years." The database would then look through all its data and give you back the books that match your request.

SQL Commands

SQL has different commands that you use to give instructions to the database. Some of the most basic commands are:

Used to select data from a database.

Used to insert new data into a database.

Used to modify existing data in a database.

Used to delete data from a database.

These commands are like the basic words you need to know to start talking to databases.

In the next lesson, we'll learn a couple different ways to setup local testing with SQL.