SQL (Structured Query Language) is the standard language for managing and manipulating data in relational databases. It is an essential tool that allows you to interact with the databases that power modern applications.
We’ve just published a course on the freeCodeCamp Spanish YouTube channel that will guide you step-by-step through the fundamentals of SQL. During the course, you’ll learn the basic concepts you need to get started.
If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.
The course was created by Serge Code. Sergey is a software engineer and content creator who loves to teach and share his knowledge. His work focuses on JavaScript, including React.js, Angular.js, and other frameworks.
Before we look at the course content, let’s look at what SQL is, and why you should learn it.
What is SQL and why should you learn it?
Data is everywhere. Modern platforms and organizations use databases every single day. When you sign into a website with your username and password, you’re using the power of a database.
By mastering SQL, you’ll be able to draw insights from data, a skill that’s highly valued in software engineering, data science, business, and other related fields.
SQL is a specialized language designed to manage data stored in relational databases. With SQL, you can create databases, define their structure, and perform key operations such as creating, inserting, updating, and deleting records.
One of the main features of SQL is that it allows you to retrieve data through queries, so you or your application can find the data you need very quickly.
SQL Course in Spanish
Great now that you know more about SQL, let’s see what you will learn during the course:
Introduction to SQL and Databases.
SQL vs. MySQL, PostgreSQL, and SQL Server.
Hierarchy of relational databases.
DBngin and TablePlus.
Data Definition Language (DDL): create, drop, modify, and describe.
Working with Tables, Attributes, and Constraints
Foreign keys and table relationships.
Data Manipulation Language (DML): INSERT, UPDATE, DELETE, and TRUNCATE.
Data Query Language (DQL): SELECT FROM, WHERE, and ORDER BY.
Aggregation functions (COUNT, SUM, AVG).
Inner joins, left joins, right joins, and 3-table joins.
Subqueries, group by, and be.
Managing SQL with Docker and environment variables.
Best practices and practical examples.
By the end of the course, you’ll be familiar with the fundamentals of SQL and ready to start building and managing your own relational databases.
If you’re ready to start learning SQL, check out the course on the FreeCodeCamp Spanish YouTube channel:
✍️ Course created by Sergey Code.