Course Content

Next.js 14

1. Introduction

Welcome Project Overview Course Prerequisites How the Course Works

2. Basic Concepts

Project Set Up Project File-Folder Strcture Styling Approaches Adding the Global CSS File Tailwind Styling CSS Modules Conditionally Applying Styles Custom Google Fonts Challenge: Adding Custom Google Font Images

3. Pages and Layouts

How Routing Works Challenge: Creating Page Creating a Common Layout Navigation Optimization Creating Active Links

4. Deployment and Database

Accounts Set Up Project Deployment Project Database Data Population

5. Working with Data

How to Fetch Data Working with the Dashboard Page Practice and Challenge: Retrieving Data Dynamic vs Static Rendering Loaders Specific Parts Loaders Challenge: Skeleton Loader Grouping Components for Loaders

6. Advanced Features

Invoices Page Search Functionality Pagination Server Actions Creating Item Updating Item Deleting Item Challenge: Form Validation

7. Authentication

Understanding Authentication Login Route NextAuth.js Authentication Configuration & Route Protection Password Hashing & Credentials Sign-in Functionality Connecting UI & Functionality Logout Functionality What's Next?

Next.js 14

Data Population

Let's add some initial data to the database.

Look for the file named seed.js in the scripts folder of the project. This script contains instructions for creating and seeding tables for invoices, sellers, users, and income.

Don't worry if you don't fully understand the code details. In essence, the script uses SQL to create the tables and populates them with data from the placeholder-data.js file.

To proceed, add the following line to your scripts in the package.json file:

package.json

{
  "private": true,
  "scripts": {
    "build": "next build",
    "dev": "next dev",
    "prettier": "prettier --write --ignore-unknown .",
    "prettier:check": "prettier --check --ignore-unknown .",
    "seed": "node -r dotenv/config ./scripts/seed.js",
    "start": "next start"
  },
  // ...
}

To proceed, we need to access the terminal and execute the following command: npm run seed.

We should see the following messages in the terminal, indicating that the data was successfully populated.

content

Spend some time inspecting the data we populated. Follow the instructions below to find the data storage.

Database Testing

Navigate to the "Query" tab to execute the SQL request. Let's attempt to run the following query.

We should get the following result:

In Practice

Everything was clear?

Section 4. Chapter 4

Course Content

Next.js 14

1. Introduction

Welcome Project Overview Course Prerequisites How the Course Works

2. Basic Concepts

Project Set Up Project File-Folder Strcture Styling Approaches Adding the Global CSS File Tailwind Styling CSS Modules Conditionally Applying Styles Custom Google Fonts Challenge: Adding Custom Google Font Images

3. Pages and Layouts

How Routing Works Challenge: Creating Page Creating a Common Layout Navigation Optimization Creating Active Links

4. Deployment and Database

Accounts Set Up Project Deployment Project Database Data Population

5. Working with Data

How to Fetch Data Working with the Dashboard Page Practice and Challenge: Retrieving Data Dynamic vs Static Rendering Loaders Specific Parts Loaders Challenge: Skeleton Loader Grouping Components for Loaders

6. Advanced Features

Invoices Page Search Functionality Pagination Server Actions Creating Item Updating Item Deleting Item Challenge: Form Validation

7. Authentication

Understanding Authentication Login Route NextAuth.js Authentication Configuration & Route Protection Password Hashing & Credentials Sign-in Functionality Connecting UI & Functionality Logout Functionality What's Next?

Next.js 14

Data Population

Let's add some initial data to the database.

Look for the file named seed.js in the scripts folder of the project. This script contains instructions for creating and seeding tables for invoices, sellers, users, and income.

Don't worry if you don't fully understand the code details. In essence, the script uses SQL to create the tables and populates them with data from the placeholder-data.js file.

To proceed, add the following line to your scripts in the package.json file:

package.json

{
  "private": true,
  "scripts": {
    "build": "next build",
    "dev": "next dev",
    "prettier": "prettier --write --ignore-unknown .",
    "prettier:check": "prettier --check --ignore-unknown .",
    "seed": "node -r dotenv/config ./scripts/seed.js",
    "start": "next start"
  },
  // ...
}

To proceed, we need to access the terminal and execute the following command: npm run seed.

We should see the following messages in the terminal, indicating that the data was successfully populated.

content

Spend some time inspecting the data we populated. Follow the instructions below to find the data storage.

Database Testing

Navigate to the "Query" tab to execute the SQL request. Let's attempt to run the following query.

We should get the following result:

In Practice

Everything was clear?

Section 4. Chapter 4

some-alt