Learn back-end development with Node.js, covering HTTP servers, databases, JWT, WebSockets, and more. Consolidate your skills in a capstone project by building a RESTful API for a practical use case.

nodegui.tar.gz

Without_start_script

With_start_script

cookingProcess

writeFileExample

fileProcessor

fileTask

dynamicServer

directoryManager

axios

expressjs

axios_http

dotenv

lodash

nodemon

postgres

postgres-api

postgres-exercise

bcrypt

complete_authentication

websocket-server

math-jest

async-jest

npm-intro-exercise

babel

process_env

process_dotenv

process_lifecycle

Without_start_script-debug

babel-copy

This Node.js course offers a structured path to mastering back-end development. It begins with introducing Node.js and JavaScript in the server-side context, covering modules and foundational concepts. You’ll explore asynchronous programming with callbacks, Promises, async/await, and the event loop, followed by event-driven programming with the EventEmitter class. Practical skills include file system operations, working with buffers, and using streams for efficient data handling.

The course will then guide you through building HTTP servers, implementing routing, handling GET/POST requests, and integrating PostgreSQL for database-driven APIs. Additional topics include JWT-based authentication, WebSockets for real-time features like chat systems and live dashboards, and testing with Jest.

In the capstone project, you’ll build a RESTful API that stores arbitrary JSON data and enables filtering and retrieval in JSON, HTML, or CSV formats, enhancing your skills in building scalable back-end solutions.

Learn Node.js

It makes the database slower to connect to during runtime.


It prevents the application from connecting to the database during deployment.


It disables the use of environment variables for runtime configuration.

It exposes sensitive information to anyone with access to the codebase.


Why is it considered insecure to hardcode database credentials in the configuration file?

Why is it considered insecure to hardcode database credentials in the configuration file?

Using string interpolation for SQL queries.


Validating user input and using parameterized queries.


Executing raw SQL queries directly in the application.


Granting database users full access permissions.


Which strategy prevents SQL injection attacks?


Which strategy prevents SQL injection attacks?

In RESTful APIs, which principle ensures each request is independent and contains all the necessary information to process it?


In RESTful APIs, which principle ensures each request is independent and contains all the necessary information to process it?

When designing a RESTful API endpoint to update a task’s status, which combination of HTTP method and URL is most appropriate?

When designing a RESTful API endpoint to update a task’s status, which combination of HTTP method and URL is most appropriate?

Yes, it can be used because it fetches data securely with parameterized queries.

No, it cannot be used because it doesn't return the fetched data for further processing.


Yes, it can be used because `console.log` outputs the data for client use.

No, it cannot be used because the database connection is not secured with SSL.


Consider the following code snippet:

```javascript
import pkg from 'pg';
const { Client } = pkg;

const client = new Client({
  user: 'postgres',
  host: 'localhost',
  database: 'companydb',
  password: 'password123',
  port: 5432,
});

const fetchEmployees = async () => {
  const query = 'SELECT id, name FROM employees WHERE department = $1';
  const values = ['Engineering'];

  try {
    await client.connect();
    const result = await client.query(query, values);
    console.log('Employee Records:', result.rows);
  } catch (err) {
    console.error('Database error:', err);
  } finally {
    await client.end();
  }
};
```

Can this code be directly used in a RESTful API endpoint to handle a client request? Why or why not?


Consider the following code snippet:
<pre><code class="language-javascript">import pkg from 'pg';
const { Client } = pkg;

const client = new Client({
 user: 'postgres',
 host: 'localhost',
 database: 'companydb',
 password: 'password123',
 port: 5432,
});

const fetchEmployees = async () =&gt; {
 const query = 'SELECT id, name FROM employees WHERE department = $1';
 const values = ['Engineering'];

 try {
 await client.connect();
 const result = await client.query(query, values);
 console.log('Employee Records:', result.rows);
 } catch (err) {
 console.error('Database error:', err);
 } finally {
 await client.end();
 }
};
</code></pre>
Can this code be directly used in a RESTful API endpoint to handle a client request? Why or why not?

Test your understanding of working with databases in Node.js with this comprehensive quiz.

Getting Started with Node.js

Global Objects and Modules

Asynchronous Programming

Event-Driven Programming

Core Node.js Modules

Building a Basic Web Server

npm and Package Management

Working with Databases

Advanced Topics

Wrap Up

Appendix

Building a RESTful API with Node.js and PostgreSQL

Quiz: Working with Databases