The Complete React Redux Node Express MySQL Developer Course

Explore editor tools and complete hands-on tasks with Visual Studio through multiple-choice exercises throughout the course. The instructor emphasizes using Visual Studio across the entire program.

Install Xampp server and MySQL, choosing the correct version for your system, then start Apache and MySQL and test localhost access.

Learn to set up a React development environment, install create-react-app globally, create your first React project, and run a local dev server on port 3000 while exploring src and public.

Learn how to apply inline styles in React using the style attribute and curly braces, adjust properties like font size, font weight, and margins, and combine bootstrap classes on buttons.

Learn to render classes dynamically in React by building a dynamic class string that changes with state, applying badge or primary classes based on a count condition.

Learn to render a dynamic React list by mapping a state array and giving each item a unique key. Fix common key warnings for list rendering.

Handle events in React by binding click, double-click, and key events, create and reference handlers, pass arguments with arrow functions, and update component state.

Explore composing React components by building a counters component that renders multiple counter components with isolated state, mapping an array of counter objects (id and value) to components via keys.

Learn to handle events from a child component by passing a delete function via props, using an id to remove a counter from the list and update the state.

Learn to protect routes in a React Redux app by building a protected user route that allows access only when logged in or admin, with redirects for unauthorized visits.

Learn to build a bootstrap-styled react form with controlled inputs for name and email, manage state with onChange handlers, and handle submission with preventDefault.

Build a simple restful API with Express, exposing posts, comments, and profile endpoints, then fetch data from the client using fetch or axios, demonstrating get requests and response handling.

Build a simple Redux demo that introduces actions, action creators, reducers, and a store, then dispatch increment and decrement to update a counter and a list with console output.

Create a producer and action folder structure and implement the reduce function. Export constants for increment, decrement, and select, and build action creators to return these actions for the store.

Connect a main React component to a Redux store with React Redux, define increment and decrement actions, map state to props, and wire inputs and buttons to update and display data.

Explore npm, the node package manager, to install third-party packages into node_modules and manage dependencies with a package.json. Create scripts to run tasks, like starting a web server.

Explore node modules, including core modules and packages, and learn how to create your own modules with exports to share variables, functions, and classes across files.

Master basics of a node project: create folders, initialize npm, install dependencies and dev dependencies, build index.js and user.js, export a User class, and require it.

Explore more durable functions, focusing on exports and module usage. Examine the filename and directory functions to determine directory and file names.

Learn to use the Node.js core path module to manipulate file paths, including path.basename, path.dirname, path.extname, and path.join, and practice building a modules folder with files to demonstrate path operations.

Explore the os module by retrieving environment details such as platform, architecture, CPU info, memory, home directory, and system uptime, and log these values to verify the host environment.

Explore the URL module by creating and serializing URLs, inspecting host, hostname, and port, accessing path, and working with search parameters, including dynamically appending and iterating over them.

Explore event emitters in node by building a custom logger that extends event emitter, registering listeners, and emitting events to log messages from code.

Build a basic Node.js http server using the http module and createServer, handle requests and responses, and verify the server running on localhost by testing in the browser.

build a node.js server from scratch, load modules, configure port from environment, serve static files, implement routes like / and /api/users, and handle 404/500 errors with dynamic content types.

Install postman to test api requests, create a new project folder, initialize package.json with npm init, and install express to bootstrap the app.

Create a simple express server by requiring express, initializing app, and listening on port 5000 (or process.env.PORT). Run the server and visit localhost:5000 to see a cannot GET / message.

Explore how to serve static files with express by creating a public folder, adding an index page, and using express.static middleware to render assets.

Create a simple rest api with express to return a user array as json via the get /api/users endpoint. Test the endpoint using postman.

Learn to create a get single user route that fetches a user by id from a dynamic parameter, converts id to number, uses filter, and tests with postman.

Learn how to implement post requests in an express app by building a create-user endpoint at /api/users, parsing json bodies with body-parser, and validating name and email.

Update user data using a put request by validating the user id, updating name and email as needed, and returning the updated user or a status response, demonstrated with Postman.

Learn to implement a delete request in a node express app to remove users, including checking for existence, sending a user deleted response, and returning 400 when not found.

Learn MySQL basics and practice create and delete operations within a simple operation management system, using the command line and Norges, for a streamlined workflow.

Learn to create a MySQL database and set up a user table with id, name, and email, including commands to connect, show databases, use the database, and describe the table.

Learn to select data from the user table using sql, including order by, selecting specific fields like email, and filtering with where and in to retrieve targeted rows.

Update the users table by changing the name column with a where clause, then delete a row, drop the name column, and drop the database to demonstrate SQL data manipulation.

Create a table with an auto-incrementing id, title, and body fields, then test the post route to confirm the database table is created.

Learn to select multiple posts and a single post using dynamic route parameters, handling request and response, and verify results via console output.

Update posts by sending a request, defining the update query, and saving the new title. Test by finding post one and verifying the updated title.

Kick off a full stack stock app by setting up the React front end, installing core packages (React, Redux, react-redux, Express, MySQL), and using a starter template.

Set up and fix routing in a React app by configuring Router, correcting history usage, and defining dynamic routes and components to display search results and user lists.

Explore how to use the GitHub API to search for users and retrieve their repositories using a dynamic username, and examine the returned user data and repository list.

The data component fetches users by username from an API, stores them in state, and renders a searchable user list with avatars and clickable items to view individual profiles.

Develop a specific data component that fetches a user and their last five repositories from an api. Manage state and pass user data as props to a repositories display component.

Implement a redux store with actions and reducers to manage user favorites, persisting to localStorage, and wire it up with react-redux provider and dev tools.

Connects a specific component to the redux store, manages a favorite flag and list via actions, and persists updates to local storage through lifecycle and conditional rendering.

Learn to start a back-end with express, install needed packages, connect to a MySQL database, set up routes and static image hosting, and run the server on a port.

Connect to the my skill database by configuring express, defining the my skill constant, and wiring the router and connect function with error handling, logging, and module exports.

Implement a backend register route to create a new user by accepting name, email, and password, checking for existing email, and inserting the user into the database with proper responses.

Implement a backend login and signup flow by defining user fields, validating credentials against the database, generating a token, and returning a status 200 response.

Create two new components in the logon register folder for login and register, then integrate them on the main page and configure the port and api slice users.

Develop a login component with redux connect, mapStateToProps, and form handling for email and password, and manage sign-in flow, API responses, and token storage.

Develop back-end endpoints to get and update user data, decode the token to extract the user email, query the database for that user, and enforce authorization before returning data.

Learn how to update a user's name and address while handling image uploads on the back end, including configuring disk storage, validating file types, and returning success responses.

Define the back-end delete route to remove a user by id after verifying the password, and test with Postman to confirm a 200 success or 400 error.

Learn to build a user profile component that fetches data with axios, uses token authorization, and displays name, email, and address from a localhost API.

Update a user profile in a React front-end by handling image changes with a file reader, updating state, and saving data via a PUT request.

This lecture demonstrates a front-end delete user flow with a password-confirmation modal using react-bootstrap and react-confirm. It wires the confirm dialog in the profile component and triggers a delete request.

Set up environment variables and a config module to define host, database name, user, and secret for the app. Wire these values into the server connection to prep for deployment.

Deploy a full stack React and Express app to Heroku. Create the app, configure frontend and backend, and set environment variables for ClearDB.