We 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 core concepts that you need to get started.

If you have Spanish-speaking friends, you're welcome to share the Spanish version of this article with them.

The course was created by Sergie Code. Sergie is a software engineer and content creator who loves teaching and sharing his knowledge. His work is focused on JavaScript, including React.js, Angular.js, and other frameworks.

Before we dive into the course content, let's see 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 in to a website with your username and password, you're using the power of databases.

By mastering SQL, you'll be able to extract insights from data, a skill that is highly valued across software engineering, data science, business, and other related areas.

SQL is a specialized language designed for managing 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 SQL's core features is that it allows you to retrieve data through queries, to find the exact data that you or your application need very quickly.

SQL Course in Spanish

Great. Now that you know more about SQL, let's see what you’ll learn during the course:

• Introduction to SQL and Databases.

• SQL vs. MySQL, PostgreSQL, and SQL Server.

• Relational Database Hierarchy.

• DBngin and TablePlus.

• Data Definition Language (DDL): CREATE, DROP, ALTER, 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 JOIN, LEFT JOIN, RIGHT JOIN, and 3-Table Joins.

• Subqueries, GROUP BY, and HAVING.

• 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 you’ll be 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 Sergie Code.

• Youtube: @SergieCode

• Instagram: sergiecode

• LinkedIn: Sergie Code

• GitHub: sergiecode

• Facebook: sergiecodeok

• TikTok: @sergiecode

• Twitter: @sergiecode

• Threads: @sergiecode

We talk about:

• Tips for busy parents who want to learn new skills.

• How AI tools are no substitute for your own critical thinking and problem solving skills.

• How even though it's getting easier every day to learn programming for free, people are so distracted, and for many it feels harder and harder to sit down and do it.

Support for this podcast is provided by a grant from AlgoMonster. AlgoMonster is a platform that teaches data structure and algorithm patterns in a structured sequence, so you can approach technical interview questions more systematically. Their curriculum covers patterns like sliding window, two-pointers, graph search, and dynamic programming, helping you learn each pattern once and apply it to solve many problems. Start a structured interview prep routine at https://algo.monster/freecodecamp

Support also comes from the 10,338 kind folks who donate to our charity each month. Join them and support our mission at https://donate.freecodecamp.org

Get a freeCodeCamp t-shirt for $20 with free shipping anywhere in the US: https://shop.freecodecamp.org

Watch the podcast on the freeCodeCamp.org YouTube channel or listen on your favorite podcast app.

Links from our discussion:

• Article about AI and product management (which includes some blunt takes from Quincy): https://thenewstack.io/for-devs-a-fix-for-ai-complexity-is-hiding-in-plain-sight/

• Andrea's weekly newsletter: https://mainbranch.beehiiv.com/

• Learn How to Learn course by Dr. Barbara Oakley: https://www.classcentral.com/course/learning-how-to-learn-2161

Community news section:

1. freeCodeCamp just published this beginner-friendly back-end development course. You'll learn how to build your own web servers and APIs using Node.js, Express, and MongoDB. freeCodeCamp's website and mobile apps are built using these tools, which make up the popular MERN stack. You'll also get some exposure to database architecture, security principles, testing best practices, and more. (2 hour YouTube course): https://www.freecodecamp.org/news/intro-to-backend-web-development-nodejs-express-mongodb/

2. freeCodeCamp also published a comprehensive Blender and Three.js course where you'll build your own 3D portfolio piece: a render of an adorable home office. If you're interested in 3D rendering and computer graphics, this is the course for you. You'll learn key concepts like Quad Topology, Raycasting, OrbitControls, and more. By the end of the course, your 3D model will be live on the web so you can share it with your friends. (9 hour YouTube course): https://www.freecodecamp.org/news/create-a-cute-room-portfolio-with-threejs-blender-javascript/

3. freeCodeCamp also published a handbook on using Docker with Node.js. You'll learn how to set up Docker and Docker Compose. You'll also learn fundamental concepts like Volumes, Images, and Containers. This is an excellent resource for you to read through and code along with. Bookmark it for future reference. (full length handbook): https://www.freecodecamp.org/news/how-to-use-to-docker-with-nodejs-handbook/

4. Level up your JavaScript implementation skills with this new freeCodeCamp course on Clean Code. You'll learn how to detect “code smells” and refactor your JavaScript accordingly. You'll also learn how to use ESLint and Prettier to automate some of the more error-prone aspects of shipping code. (1 hour watch): https://www.freecodecamp.org/news/level-up-your-javascript-detect-smells-and-write-clean-code/

5. Classic text adventure games Zork I, II, and III are now open source with an MIT license. Microsoft has published their full source code on GitHub: https://github.com/historicalsource/zork1

6. Today's song of the week is 1985 classic "Something About You" by Level 42. I love the slap bass, the vocal harmony, the falsetto, and the huge synth sounds. It's impossible to listen to this song and still be in a bad mood: https://www.youtube.com/watch?v=zpdQQoc-gkk

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will guide you step by step through the fundamentals of Godot. You’ll learn the core concepts that you need to get started.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

Luis Canary created this course. He is the Principal Gameplay Programmer at Pendulo Studios, a Madrid-based video game development company. He has taught courses at universities, schools, and companies and loves to share his passion for game development on his YouTube channel.

Before we dive into the course content, let's see what Godot is, and why you should learn it.

What is Godot?

Godot is an open-source game engine that you can use to build 2D and 3D games.

It has become very popular in the last few years, with robust features that make it a great tool in the game development world, without the heavy resource demands of some other game engines. This makes it a practical choice for creators looking for efficiency and high performance.

Its open-source license is great for independent developers and small teams, as it doesn’t come with any licensing fees. You’ll retain full ownership and control over the games and projects that you create with Godot.

This flexibility makes game development more approachable for everyone.

Godot also has its own user-friendly scripting language and node-based system. Its scripting language, called GDScript, is similar to Python and is easy to learn for beginners. Its intuitive node-based system simplifies the process of creating both 2D and 3D games.

By learning Godot, you’ll be taking your first steps into a career in game development.

💡 Tip: This course is perfect for anyone who wants to start developing video games. It covers core concepts in GDScript.

Godot Course in Spanish

Great. Now that you know more about Godot, let's see what you’ll learn during the course:

• Introduction

• What is Godot?

• Download and install Godot

• Lighting

• Materials and physics

• UI

• Movement

• Player

• First script

• Update project

• Change inputs for a 3D project

• 3D platforms and respawn player

• Collect coins

• 3D camera rotation

• Character model and animations

• Music and sounds

• Export video game .exe

By the end of the course, you’ll be familiar with the fundamentals of Godot and you’ll be ready to start developing video games.

If you’re ready to start learning Godot, check out the course on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Luis Canary.

• YouTube: @LuisCanary

• Instagram: @luiscanary_

• Twitter: @luiscanary

• TikTok: @luiscanary

• Twitch: LuisCanary

• Discord: Invitación

• Facebook: LuisCanaryy

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you the fundamentals of Arduino step by step. You'll learn key programming concepts, like data types, variables, functions, operators, conditionals, and loops, alongside concepts related to electronics, such as digital input and output, time, buttons, temperature and humidity, movement sensors, and more.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

The course was created by Carlos Leon. Carlos is a developer who is passionate about Arduino and who loves sharing his knowledge of programming and electronics with everyone who is interested in learning these technologies.

What is Arduino?

Arduino is an open-source electronics platform that connects the digital and physical worlds. It consists of a microcontroller board and a user-friendly development environment. By connecting various sensors, actuators, and other electronic components to the Arduino board, you can create interactive projects that respond to the real world.

With Arduino, you can build a wide range of projects, from simple circuits to complex robotics systems. You can also practice your problem-solving skills and gain a deeper understanding of programming fundamentals and electronics.

This course is great for anyone who is interested in learning more about Arduino. It’s a stepping stone into the world of robotics, automation, Internet of Things, and wearable technology.

💡 Tip: During the course, you’ll use an Arduino simulator, so you can take the course even if you don’t have an Arduino board available.

Arduino Course

Great! Now that you know more about Arduino, let’s check out some of the topics that you’ll learn during the course:

• Introduction

• Arduino Uno

• Pins

• Electricity concepts

• Calculating resistance

• Breadboard

• Programming fundamentals

• About Wokwi

• Data types

• Variables

• Functions

• Operators

• Conditionals

• Loops

• Serial console

• Hello World with Arduino

• Pin declarations

• Digital input-output

• Analog input-output

• Time

• Buttons

• Libraries

• Sensors

• Temperature and Humidity

• Ultrasonic

• Movement sensor

• Interesting components

• LCD screen

• Servomotors

• And more…

Check out these course screenshots:

💡 Tip: The course is beginner-friendly. It’s great for you if you’re just getting started in the world of programming and electronics. You’ll even write your first “Hello, world!” program in Arduino.

If you’re ready to start learning, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Carlos Leon.

• LinkedIn: Carlos Leon

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you how to implement REST APIs with Node.js, Express, and MongoDB. You'll learn how to design routes, handle HTTP requests, interact with NoSQL databases, and secure your endpoints with JSON Web Token-based authentication.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

The course was created by Leonardo José Castillo Lacruz. Leonardo is a software developer and content creator who loves teaching programming and sharing his knowledge.

APIs and Non-relational Databases

Let's take look at some concepts that you’ll find helpful for the course.

API stands for “Application Programming Interface” in English.

An API is a set of rules and specifications that allow different applications to communicate with each other.

APIs make the process of integrating systems and services much easier.

In the world of web development, you can think of them as a bridge between the front-end and the back-end because they allow data exchange between both parts of the application.

APIs and databases are closely related. An API can interact with a database to retrieve, store, modify, and delete data.

For example, a web application can use an API to get or update user information on a database.

During the course, you’ll work with MongoDB, a non-relational database. This type of database is also referred to as “NoSQL”.

Non-relational databases are a type of database that does not store data in tables with rows and columns. Instead, they have more flexible ways of structuring and storing data.

MongoDB is a non-relational database that stores data in JSON-like documents, which allows developers to represent and store data in a more dynamic and adaptable model. This is ideal for applications that handle large volumes of unstructured or semi-structured data.

To model this data, you'll also learn how to work with a Node.js library called Mongoose, which helps you define the database schema to simplify the interaction between Node.js and MongoDB.

All of these interactions between the web application and the API should have some form of authentication to ensure that only the right users can perform operations on the database through the API.

To implement this, you'll use JSON Web Tokens, a standardized way to securely transmit information in JSON format.

CRUD Course

Great! Now that you know more about these concepts, let's see what you will learn during the course:

• Introduction to MongoDB

• Installing and configuring MongoDB

• MongoDB Atlas

• Connecting to MongoDB Shell

• Structuring an API

• Routes and controllers

• Connecting to MongoDB

• Implementing CRUD

• Introducing Mongoose

• Setting up the data model

• Validating data and testing the API

• Public, private, and authentication routes

• User model

• JSON Web Tokens

• Verifying tokens

• And more...

During the course, you’ll build a RESTful API for a pet adoption system. 🐾

If you’re ready to start working on this project, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Leonardo José Castillo Lacruz.

• YouTube: @LeonardoCastillo79

• LinkedIn: Leonardo José Castillo Lacruz

• Twitter: @ljcl79

• GitHub: @ljcl79

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will guide you step by step through the fundamentals of C# for Unity. You will learn the core concepts that you need to know to start developing games in Unity with C#.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

Luis Canary created this course. He is the Principal Gameplay Programmer at Pendulo Studios, a Madrid-based video game development company. He has taught courses at universities, schools, and companies and loves to share his passion for game development on his YouTube channel.

Before we dive into the course content, let's see what C# is, how it is related to Unity, and why you should learn both of them.

What are C# and Unity?

C# is a versatile programming language known for its simplicity and power. Designed by Microsoft, it's part of the .NET family, a set of tools, libraries, and programming languages that work together to build various applications.

C# is a popular choice for building a wide range of applications, from desktop software and web applications to mobile apps and video games.

This course will focus on the fundamentals of C# for game development with Unity.

Unity is a popular game engine for creating 2D and 3D experiences. It uses C# as its primary scripting language and includes a comprehensive set of tools and features to design, develop, and deploy games across various platforms.

These are the platforms that are currently supported by Unity:

• Desktop

• Mobile

• Web

• Consoles

It also supports Augmented Reality (AR) and Virtual Reality (VR).

By learning C# for Unity development, you will be taking your first steps into a career in game development.

💡 Tip: This course is perfect for anyone who wants to start developing video games. It covers core programming concepts that will remain valid across different versions of C# and Unity.

C# for Unity Course in Spanish

Awesome. Now that you know more about C# and Unity, let's see what you will learn during the course:

• Variables

• Operators

• Conditionals

• Switch Statements

• While Loops

• Do-While Loops

• For Loops

• Arrays

• Lists

• Foreach Loops

• Functions

• Methods

• Modifying components

• Coroutines

• Invoke

• Destroy

• PlayerPrefs

• Classes

• Inheritance

By the end of the course, you will know the fundamentals of C# for Unity and you will be ready to start developing games in this programming language.

If you are ready to start learning C# for Unity, check out the course on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Luis Canary.

• YouTube: @LuisCanary

• Instagram: @luiscanary_

• Twitter: @luiscanary

• TikTok: @luiscanary

• Twitch: LuisCanary

• Discord: Invitación

• Facebook: LuisCanaryy

💡 Tip: Once you've completed this C# for Unity course, we recommend taking a general introduction to Unity course to learn the basics of the user interface and the features of your current version of Unity.

We just published a 2-hour course on the freeCodeCamp.org Spanish YouTube channel that will guide you step by step through building 3 projects with HTML, CSS, and JavaScript. You will practice your skills by building a responsive navigation bar with dropdown menus, a slider, and a landing page with a custom modal.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

Jordan Alexander Cruz Garcia teaches this course. He is a web developer who loves sharing his knowledge and teaching others about the amazing world of CSS.

💡 Tip: Please note that the course focuses on HTML and CSS but also requires basic knowledge of JavaScript for implementing the interactivity.

HTML, CSS, and JavaScript

HTML stands for HyperText Markup Language and CSS stands for Cascading Style Sheets. While HTML provides the structure and content of a website, CSS determines how the content is displayed. It controls the visual aspects of the website, such as fonts, colors, layouts, spacing, and animations.

With CSS, you can easily create different styles and layouts for various screen sizes, making your website look great on desktops, tablets, and mobile devices.

💡 Tip: Websites that adapt to different screen sizes are known as "responsive websites".

We usually write CSS in an external file that we refer to as a "stylesheet". Then, we link this stylesheet to the HTML file, applying all the styles to the corresponding HTML elements based on the CSS selectors and properties.

Separating the content of the website from its presentation is very helpful. It results in a more maintainable project structure and a more efficient rendering process because browsers can render the structure more quickly, while downloading CSS styles in the background.

Basically, CSS is an essential tool for creating the beautiful, visual, and user-friendly websites that we see today.

JavaScript adds interactivity to the website. It turns plain elements into interactive elements to create engaging user experiences.

HTML, CSS, and JavaScript Projects in Spanish

Awesome. Now that you know more about HTML, CSS, and JavaScript, let's check out the projects that you will build during the course.

Project 1: Navigation Bar

You will start by building a navigation bar with dropdown menus. This navigation bar will be responsive, so it will expand or shrink to fit the size of the screen. If the screen is too small, it will automatically transform into a sidebar.

💡 Tip: The main options will always be displayed. When the user clicks on "About" or "Projects", a dropdown menu with additional options will be displayed.

Desktop version

Here you can see the desktop version.

Mobile version

This is the mobile version that you will see in small devices.

💡 Tip: This technique of hiding and toggling the navigation bar is used very frequently to optimize the space for the content as much as possible.

Project 2: Slider

Next, you will build a slider with three positions that will change when the user clicks on the left or right arrows. Each position will have a title, a short paragraph, and a circular image.

💡Tip: Sliders are helpful for sharing user feedback, quotes, and reviews.

Project 3: Landing Page

Finally, you will build a landing page step by step with CSS Grid.

When the user clicks on the "Join us!" button, a custom modal will be displayed. You will implement this modal with HTML, CSS, and JavaScript step by step.

If you are ready to start practicing your HTML, CSS, and JavaScript skills, check out the course on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Jordan Alexander Cruz Garcia (AlexCG).

• YouTube: @AlexCGDesign

• Twitter: @alexcgdesign

• Linkedin: Jordan Alexander Cruz Garcia

• Instagram: @alexcg_design

• GitHub: AlexCGDesign

• Web Development Blog: https://www.alexcgdesign.com/blog

We just published a 5-hour course on the freeCodeCamp.org Spanish YouTube channel that will teach you React step by step. You will start by installing and configuring React with create-react-app and Vite and gradually dive into more advanced topics, including components, JSX, hooks, events, forms, and more.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

Carpi Coder teaches this course. He is a web developer who has learned from many communities, including freeCodeCamp. In 2020, he created his YouTube channel to share his knowledge and now he is sharing his in-depth course with the freeCodeCamp community.

Before we dive into the course content, let's see what React is and why you should learn it...

React for Beginners

React is one of the most popular front-end web development libraries. The results of the Stack Overflow Developer Survey 2023 confirm this.

When developers were asked this question:

Which web frameworks and web technologies have you done extensive development work in over the past year, and which do you want to work in over the next year?

40.58% of them chose React.

React and Node.js were the most common web technologies used by all respondents.

The popularity and worldwide use of React shows how relevant it is and will continue to be in the web development industry.

Key advantages of React include:

• Component-Based Architecture. React applications are built by breaking down complex user interfaces (UIs) into smaller, simpler, and independent components.

• Virtual DOM. React uses a virtual representation of the real DOM of the web application for making updates. With this virtual DOM, it can efficiently update only the parts of the user interface that need to be updated.

• Support for JSX syntax. With JSX, you can define the structure of React components with a syntax that is very similar to HTML combined with JavaScript.

React also has a very large and active community of developers and libraries for many different purposes. It's super helpful for building maintainable and user-friendly web applications.

💡 Tip: The official React logo is an atom. 👇

React Course in Spanish

Awesome. Now that you know more about React, let's see what you will learn during the course:

• How to install React with create-react-app and with Vite.

• JSX

• Components

• Props

• Hooks

• Components lifecycle

• Promises

• Events

• Forms

• And more...

💡 Tip: This course is great for beginners. If you are taking your first steps in React, Carpi Coder will guide you step by step.

You will also learn more advanced techniques, like how to:

• Fetch and display data from an API.

• Integrate your React application with a Firebase database.

• Deploy your React application on Netlify, a cloud platform for deploying and managing web applications and websites.

💡 Tip: During the course, you will create the Firebase database step by step, so you can take the course even if you don't have previous knowledge of Firebase.

If you are ready to start learning React, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Carpi Coder.

• YouTube: @carpicoder

• Instagram: instagram.com/carpicoder

• TikTok: tiktok.com/@carpicoder

• Sitio Web: https://carpicoder.com/

• X: https://x.com/carpicoder

• GitHub: https://github.com/carpicoder

• LinkedIn: linkedin.com/in/matiascoletta

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you the basics of Go step by step. You will start by installing and configuring Go and gradually dive into more advanced topics, including data types, variables, conditionals, loops, functions, the Go standard library, and much more.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

The course was created by Leonardo José Castillo Lacruz. Leonardo is a software developer and content creator who loves teaching programming and sharing his knowledge.

Are you ready? Let's see a quick overview of Go and what you will learn in the course.

Golang for Beginners

In the constantly-evolving world of software development, choosing and learning the right programming language is essential. Go (also known as Golang) has become a powerful and versatile option, rapidly gaining popularity for its combination of simplicity, efficiency, and scalability.

Key advantages of Go include:

• It's easy to learn and understand because of its simple syntax.

• It's very fast because it is compiled ahead of time into native machine code.

• It has powerful tools to handle concurrent tasks.

• It's an open source programming language supported by Google.

• It has use cases in various industries, including cloud and network services, command-line interfaces, web development, and development operations and site reliability engineering.

And more!

Go is a beginner-friendly programming language, so both new and experienced developers can start building amazing applications with its capabilities.

💡 Tip: If you are curious, Go's mascot is this beautiful Gopher that we have below. (Another reason to learn and love Go, right? 😁).

Golang Course in Spanish

Great. Now that you know more about Go, let's see what you will learn during the course:

• Installing and configuring Go

• Data Types

• Variables

• Arrays

• Maps

• Conditionals

• Loops

• Functions

• The Go standard library

• And more...

💡 Tip: The course is great for beginners. If you are taking your first steps with Go, this course is for you.

If you are ready to start learning Go, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Leonardo José Castillo Lacruz.

• YouTube: @LeonardoCastillo79

• LinkedIn: Leonardo José Castillo Lacruz

• Twitter: @ljcl79

• GitHub: @ljcl79

We just published a course on the freeCodeCamp.org Spanish YouTube channel that is designed to teach you how to develop REST APIs step by step. You will also learn how to connect them to databases.

You will develop your API with TypeScript, Node.js, Express, MySQL, and TypeORM and you will test it using Postman, a platform for testing APIs.

You will start from the basics of Node.js and Express and gradually dive into more advanced concepts that will prepare you for connecting your API to a database. By the end of the course, you will be able to create your own APIs with Node.js and Express.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by Leonardo José Castillo. Leonardo is a software developer and content creator who loves teaching programming and sharing his knowledge.

Are you ready? Let's see a quick overview of APIs and what you will learn during the course.

What is an API?

If you ever need to make two applications communicate with each other, APIs are exactly what you are looking for. They are software that you can use to send data between two applications through requests and responses.

💡 Tip: API stands for Application Programming Interface.

The developers of the application that will send the data to the other application will implement an API and document its functionality and endpoints, so other developers can use it and access its resources and data.

💡 Tip: An endpoint is a location in the API that accepts requests and sends back responses.

The developers of the application that will receive data from the API will write code for making these requests, specifying the endpoints and handling the response received from the API appropriately.

Weather API Example

For example, a weather application may access an API to get the current weather data of a location entered by the user.

The developers of the weather app write code to make requests to the weather API, following its guidelines and documentation. The API will then access the data on a database and send it to the client who made the request.

This is the role of APIs. It's a very important role in the world of back-end web development.

You can implement them with many different technologies, including Node.js and Express.

Let's see what they are:

• Node.js is a JavaScript runtime environment that allows you to run JavaScript code outside of the browser.

• Express is a Node.js framework that makes developing servers and APIs much easier.

Learning how to design and implement APIs can open many career opportunities for you.

Career Opportunities

Talking about career opportunities – TypeScript, Node.js, Express, and MySQL, the technologies that you will be practicing in this project, are very popular and in high demand in the programming industry.

To show you how important they are, here we have the results of the Stack Overflow 2023 Developer Survey.

Node.js and Express were the first and fourth most popular web frameworks and technologies:

MySQL was also very high in the rankings. It was the second most popular database:

TypeScript was the fifth most popular language among all respondents:

These results show you how relevant these technologies are are will be for web development in 2024 and beyond.

💡 Tip: During the project, you will also use TypeORM, an Object-Relational Mapping tool that helps you to work with databases in JavaScript, TypeScript, and other programming languages.

APIs Course with Node.js and Express

Great. Now that you know why APIs are so important, let's check out the topics that you will learn about during the course:

• Introduction to Node.js and Express

• Application Architecture

• Dynamic routing

• Controllers

• Database structure

• Connecting the API to a database

• Implementing CRUD operations in TypeScript

• Modeling with TypeORM

• Implementing controllers with TypeORM

And more!

💡 Tip: To build this project, it's recommended to have a basic understanding of TypeScript and web development. If you need to review these topics, we have these courses on the channel:

• Aprende Node.js y Express - Curso desde cero

• Aprende TypeScript - Curso desde cero

If you are ready to start building this API, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Leonardo José Castillo.

• Youtube: @LeonardoCastillo79

• LinkedIn: Leonardo José Castillo Lacruz

• Twitter: @ljcl79

• GitHub: @ljcl79

We just published a course on the freeCodeCamp.org Spanish YouTube channel that is designed to teach you TypeScript step by step.

You will start from the basics and gradually dive into more advanced concepts that will prepare you for building two projects step by step with TypeScript, React.js, and Angular.js. By the end of the course, you will be able to create your own web development projects using TypeScript.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by Sergie Code. Sergie is a software engineer and content creator focused on JavaScript, including React.js, Angular.js, and other frameworks.

Are you ready? Let's see a quick overview of TypeScript and what you will learn during the course.

What is TypeScript?

TypeScript is a superset of JavaScript that adds static types to the programming language. Static typing is very useful for helping you write safe and maintainable code because you can catch errors and potential bugs even before running your code.

TypeScript is widely adopted by the global developer community. It's also a valuable skill that can lead you to many career opportunities.

Career Opportunities

Talking about career opportunities – TypeScript is very popular and it's currently in high demand in the programming industry.

As an example of is relevance and popularity, here we have the results of the most popular technologies of the Stack Overflow 2023 Developer Survey.

When developers where asked the following question:

Which programming, scripting, and markup languages have you done extensive development work in over the past year, and which do you want to work in over the next year? (If you both worked with the language and want to continue to do so, please check both boxes in that row.)

These were the results:

TypeScript was the fifth most popular language among all respondents. Specifically, 38.87% of the respondents selected TypeScript as a language that they have worked with in the past year or plan to work in over the next year.

If we break down the results even further, we can see that 21.18% of the respondents who were learning to code when they took the survey had used or planned to use TypeScript during 2024.

The percentage increased to 43.75% among professional developers:

These results show that TypeScript is growing in popularity.

By learning TypeScript, you will have in-demand skills and a solid foundation for your career as a web developer.

TypeScript Course in Spanish

Great. Now that you know why TypeScript is so important, let's check out the topics that you will learn about during the course:

• Setting up your coding environment

• Installing the necessary tools

• Observer mode

• Data types

• Primitive data types

• Any

• Arrays

• Objects

• Custom types

• Interface

• Classes and OOP

• Encapsulation

• Generics

And more!

During the course, you'll also build two projects. Let's learn more about them now.

Project 1

A To-do List Application with TypeScript and React.js.

Project 2

A list of courses with different tables using TypeScript and Angular.js.

If you are ready to learn TypeScript, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Sergie Code.

• Youtube: @SergieCode

• Instagram: sergiecode

• LinkedIn: Sergie Code

• GitHub: sergiecode

• Facebook: sergiecodeok

• TikTok: @sergiecode

• Twitter: @sergiecode

• Threads: @sergiecode

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you Responsive Web Development by building a website step by step. You will use the core concepts that you need to understand in order to master responsive web development. By the end of the course, you will be able to design and implement responsive websites using HTML and CSS.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by David Choi. David is a Software Developer who loves coding and sharing his knowledge with everyone who wants to dive into the world of programming and computer science.

David will teach you how to create and implement modern and responsive web designs step by step with HTML and CSS (without frameworks or libraries).

If your goal is to design and create modern websites, you definitely need to learn how to make them responsive. Before you start learning responsive web development with David's course, let's have a quick introduction.

What is Responsive Web Development?

A responsive website is a website that adapts its layout and content to fit the size of the screen. It should look and work correctly on desktops, laptops, tablets, smartphones, and other devices.

Responsive web development is the approach used by developers to create these websites that adapt to devices of different sizes. This results in a much better user experience because the user will have access to the content in a layout that has been specifically adapted to their device. Search engines also reward sites that offer a good user experience for all devices.

You can develop responsive websites with HTML and CSS. This is where CSS Flexbox comes to the rescue. You will practice your CSS Flexbox skills during the course. Let's see what it is all about.

What is Flexbox?

Flexbox is a CSS layout model for arranging elements in a single dimension. With Flexbox, you can place elements horizontally or vertically, distribute space evenly to resize the layout based on screen size, and even control the order of the elements.

💡 Tip: If you need to refresh your HTML, CSS, and Flexbox skills, you can take courses on these topics on our Spanish YouTube channel before diving into the project.

• Aprende HTML y CSS - Curso Desde Cero

• Aprende CSS Flexbox - Curso desde Cero

Responsive Website Project in Spanish

During the course, you will:

• Analyze the website design and translate it into HTML.

• Prepare your development environment.

• Install Visual Studio Code.

• Create the structure of the website in HTML.

• Define and assign CSS styles for the mobile version.

• Define and assign CSS styles for the desktop version.

You will combine basic CSS with Flexbox to assign styles that adapt to the current size of the screen.

Here we have some course screenshots to give you an idea of the awesome project that you will be building with David:

If you are ready to start building this project, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by David Choi.

• YouTube: @deivchoi

• GitHub: @choidavid4

We just published a 1-hour course on the freeCodeCamp.org Spanish YouTube channel that will teach you Git from scratch. You will go from the basic concepts like repositories, commits, and branches, to more advanced ones like best practices, cherry picking and .gitignore.

By the end of the course, you will be able to use Git to track changes in a software project.

💡 Tip: The course will also introduce you to the basics of GitHub, a platform where you can host your Git repositories and collaborate with other developers.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by Pedro Plasencia. Pedro is a web developer who loves teaching and sharing his knowledge and experience with his Spanish-speaking community of developers, "Programación en Español".

He will teach you how to work with version control and, specifically, with Git to track the changes made to your project. When you combine Git and GitHub, you can also share your repositories and history of changes with your team members, and work like professional software development teams work around the globe.

Git Course in Spanish**

During the course, you will learn the following aspects of Git:

• Introduction to Git and to Version Control Systems (VCS).
• How to install Git.
• Git in Visual Studio Code.
• Initial Git Setup.
• Creating local Git repositories.
• File states in Git.
• How to start tracking a file of the repository.
• Check the status of a repository.
• Track your changes with commits.
• See the history of commits.
• Create and work with branches.
• Creating tags in the branches.
• See the differences between branches.
• Reset the changes after creating a commit.
• Merge branches to combine changes.
• Conflict resolution when merging branches.
• Introduction to GitHub.
• How to push changes to GitHub.
• How to pull changes from GitHub.
• Remove files or directories from the repository.
• README.md files.
• How to ignore specific files with .gitignore.
• Clone repositories to create local copies.
• Alternatives to GitHub.
• Best Practices.

And more!

Git and GitHub are very powerful tools that you will definitely use in your daily work, regardless of the technology or programming language that you are working with.

Here are some course screenshots. You will be working with Git in the Integrated Terminal of Visual Studio Code.

Course Screenshot - Working with git stash and branches.

Course Screenshot - Checking the differences and solving conflicts.

If you are ready to learn Git, check out the course in Spanish below or on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Pedro Plasencia.

• YouTube: Programación en Español
• Instagram: programacion.es
• Twitter: @program_es
• Website: Programación en Español

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you Tailwind CSS. You will go from the basics to actually building your own real-world projects. By the end of the course, you will be able to design and implement responsive websites with Tailwind CSS.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by David Ruiz. David is a Front-End Web Developer with more than 5 years of experience. He shares projects and courses on Tailwind CSS, HTML, CSS, JavaScript, and React on his YouTube channel.

He will teach you how to create and implement modern and responsive web designs step by step with the pre-defined Tailwind CSS classes.

Before we start diving into Tailwind CSS with David's course, let's have a quick introduction. We'll talk about what Tailwind is and why it's useful to learn if your goal is to design and create modern and responsive websites quickly and efficiently.

What is Tailwind CSS?

Tailwind CSS is a CSS framework with pre-defined classes that you can use for styling HTML elements.

With Tailwind, you can add CSS classes to your HTML elements directly within the HTML file and see how the pre-defined styles are applied immediately.

💡 Tip: Yes! With Tailwind CSS, you write your CSS within the HTML file.

Tailwind CSS (Official Website).

Why Choose Tailwind CSS?

Learning Tailwind CSS can bring many advantages to your web development workflow, including:

• Faster development because you can use pre-defined CSS classes instead of defining the CSS styles yourself.
• Responsive design because these pre-defined CSS classes support variants for different screen sizes. You can develop responsive website directly from your HTML file, without additional media queries.
• Simpler CSS files because you will not be defining all the styles yourself in custom CSS files.
• Consistency because you and your colleagues will be using the same CSS classes with the same naming conventions throughout the project.
• Customization features because you can customize and configure many of these pre-defined CSS classes to fit your needs.

Sounds great, right? 🙂

Styling a Form with Tailwind CSS (Course Screenshot).

By learning Tailwind CSS, you will be acquiring valuable skills for your web development career.

If you are ready to start incorporating Tailwind CSS into your workflow, let's check out the course content.

Tailwind CSS Course in Spanish

During the course, you will learn the following aspects of Tailwind CSS:

• How to install and configure Tailwind CSS
• Colors
• Size
• States
• Pseudo-classes
• Responsive Web Design
• CSS Flexbox with Tailwind CSS
• CSS Grid with Tailwind CSS
• And more!

Plus, you will learn how to toggle dark mode with pre-defined styles from Tailwind CSS and you will build three full real projects:

• A notifications panel
• A dashboard
• A landing page

If you are ready to learn Tailwind CSS, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by David Ruiz.

• YouTube: @CodingTube
• Twitter: @CodingTube
• Página web: https://www.codingtube.dev/
• GitHub: @Davichobits
• LinkedIn: David Israel Ruiz Cabrera

We just published a course on the freeCodeCamp.org Spanish YouTube channel that will teach you Flexbox from the fundamentals. By the end of the course, you will be able to design and implement responsive layouts.

If you have Spanish-speaking friends, you are welcome to share the Spanish version of this article with them.

This course was created by Leosbel Poll Sotomayor. Leosbel is a software engineer with more than 10 years of experience. He started creating more than 20 years ago in Cuba, and is now living in Canada thanks to his programming skills. He created this course for the freeCodeCamp community.

Are you ready? Let's see a quick overview of Flexbox and what you will learn during the course.

What is CSS Flexbox?**

CSS Flexbox stands for CSS Flexible Box Layout. It's a layout model that allows responsive elements to be rearranged within a container based on CSS properties that define how the children should "move" to fit the size of their container.

With Flexbox, you can align, distribute, and space elements using simple properties, so you can avoid complex computations in your CSS.

During the course, you will learn how to use these properties:

• **flex-direction**
• **justify-content**
• **flex-wrap**
• **align-items**
• **align-content**
• **flex-grow**
• **flex-basis**
• **flex-shrink**

And more! You will also learn how to combine them with media queries to create even more powerful responsive layouts.

Flexbox layout. Wrapping elements automatically.

Career Opportunities

If your goal is to have a career in the field of web development, Flexbox will be super helpful for you. These skills are in high demand and widely sought by employers.

Flexbox layout. Classic design with a navigation bar, sidebar, main area, and footer.

Flexbox Course in Spanish**

Awesome. Now that you know why Flexbox is so important, let's check out the topics that you will learn during the course:

• Introduction
• What is Flexbox?
• Importance of Flexbox
• Flexbox Fundamentals
• Tools that you will use during the course
• How to set up your development environment
• Properties related to containers
• Loss of data in CSS
• Properties related to children
• Use case: Navigation Bar
• Use case: Classic Design
• Flexbox vs. Grid

If you are ready to learn Flexbox, check out the course in Spanish on the freeCodeCamp.org Spanish YouTube channel:

✍️ Course created by Leosbel Poll Sotomayor.

• YouTube: LeoDev
• Twitter: @_LeoDev
• LinkedIn: Leosbel Poll Sotomayor