Intro To MySQL With Node.js - Learn To Use MySQL with Node!

Learn MySql Database With Node.js and Javascript The Fast and Easy Way!

3.90 (135 reviews)
Udemy
platform
English
language
Databases
category
instructor
Intro To MySQL With Node.js - Learn To Use MySQL with Node!
4,277
students
2 hours
content
Nov 2023
last update
$39.99
regular price

What you will learn

Understand how to use MySQL Databases With Node js

Understand the basics of what a Database can do.

Install Node, MySQL, Git Bash, Wamp, and MySQL module

You'll Learn How To Create a Database and Table

How to put data in and take data out using Node and Javascript

How to update and delete data from the database

How to explore what's in the database whenever you want

How to create basic reports with the data from your database

Why take this course?

These days everything uses a database, and MySQL is one of the most popular databases out there.  FREE and Open Source, Mysql is a great database for just about all your needs.

Likewise, Node.js is one of the most popular and powerful web development platforms.  Pairing the two together is a powerful combination!

In this course you'll learn the basics of using MySQL with Node.js and Javascript. 

You'll learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.

For this courses I'll assume you already have a basic knowledge of Javascript programming and Node, but you don't need to know anything at all about databases or MySQL to take the course.

You'll learn...

  • What Is A Database

  • How To Install Node

  • How To Install Git Bash Terminal

  • How To Download MySQL

  • How To Install Wamp and PHPMyAdmin

  • How To Install the MySQL Node Module

  • How To Connect to Database in Node

  • How To Explore MySQL With PHPMyAdmin

  • How To Create A Database

  • How To Create A Table

  • How To Insert One Record Into Table

  • How To Insert Many Records Into Table

  • Understanding Data Types

  • How To Select Data From Table

  • How To Format Our Results

  • How To Use The Where Clause

  • How To Use The Like Clause and Wildcards

  • How To Use AND and OR

  • How To Updating Records

  • How To Limit and Order Results

  • How To Delete Records

  • How To Delete (Drop) A Table

  • And More!

I'll walk you through all of this and more, step by step.  If you have any question along the way, I'm here to answer them.

If you've ever wanted to understand databases or use them in your Node programs, this is the course for you.

We'll download everything you need for this course for free, you don't need any special tools!

I'll see you on the inside!

-John Elder



Screenshots

Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Screenshot_01Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Screenshot_02Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Screenshot_03Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Screenshot_04

Reviews

David
January 7, 2024
This is exactly what I needed. There aren't many courses that explain just using Node with MySQL. Other courses explain these 2 along with other full-stack technologies, but I didn't want all of that right now.
Bohdan
October 29, 2023
This is the worst course I have ever taken in my entire life. 1. There is no information here that could help you understand anything, the lecturer just mechanically reproduces the code that he has on the second monitor that he constantly looks at, you can easily find even where he got the code that he sells to you in in the form of a course, google "Node.js mysql" and follow the first link. 2. If you are a Mac user, you will have to figure it out yourself and spend time configuring MAMP (a tool that the lecturer uses on his Windows machine). 3. The lecturer is openly rude to people in the comment section, instead of helping them understand and find a solution (this is not about me). 4. Honestly, just read the documentation. This course is not worth paying for.
Hakan
December 17, 2022
This is a beginner level and the teacher does not show how to render the pages. When i query something, i will also show how to render and publish the results at the rendered page....
Adrian
November 12, 2022
Really simple and straightforward to follow. Avoids the mistakes other courses make where the code is overly complex, which makes it difficult to focus on the important parts of each lesson.
chrissMcKenzie
October 8, 2022
For Context: I followed Maximilian Schwarzmüller's training on MongoDB, he explains everything from beginner to very advanced. He starts with MongoDB CLI (which accompanies us until the end), going through MongoDB Compass (Desktop, a little overflown), then MongoDB Atlas (WebApp), which is an excellent approach and he ends up implementing it as code to make JS&MongoDB (NodeJS Driver). Unfortunately, his code was already half coded, which did not force us to start from scratch, even if the theory, the steps, explanations and modifications of the code were present. He missed that! start it from scratch in JS&MongoDB + Application Deployment (Heroku & AWS). This training deserved like even a 5 star despite the negative points. My Analysis: (Yes I do Analyzes not Opinions!) Lol Coming here I was looking for a training equivalent to Maximilian's MongoDB but with MySQL and which would end in beauty in JS&MySQL + Deployment of the application (Heroku & AWS) but I just came across an "Intro" from the JS&MySQL party (NodeJS Driver, which is like even the part I'm most interested in being Web Developer - Front-End [Junior] wanting to move up to Web Developer - Full Stack [Junior]) In short, John's training is therefore missing the following parts: MySQL CLI, MySQL Workbench (Desktop), phpMyAdmin (WebApp, in depth!..) + Deployment of the application.. For these reasons and its potential for progression, I give you a 4 star. PS: I know, I know, it's an "Intro" but what did you want, it's the complex of the student who wants everything in one, which takes over! Lol. I'm from France and I'm nice, I haven't even mentioned unit tests. Lol2 Raise the quality of this training, you are on the right path! Best wishes..
Imam
September 26, 2022
This is one of the best course I have found after spending tons of hours in youtube to learn the Mysql .Every single video is short and full of information .I am very happy to find this course as I was frustrated about the nodejs and Mysql.Very happy .
Daniel
August 22, 2022
To the point. On point. Good examples. All code works no debugging like most outdated Udemy courses. Will be taking future courses. Thanks much!
Milan
January 9, 2022
Great course to start with Nodejs, just what I was looking for and better because it is so simple and strait forward, spot on.
Avaneesh
November 28, 2021
This instructor is awesome!! I enjoyed the course and this course was like a refreshment for me. Nicely done :)
Keith
February 28, 2021
The lessons are concise. They give a solid enough foundation for students to confidently move on to more advanced concepts.
Wallo
February 8, 2021
I did learn new things in the course, and did get some good exercise in figuring out my errors. So it was worthwhile though not really what I was looking for. Whet I really wanted is information on how to enable normal users (without knowledge of SQl or nodeJS) to add and manage data on a my SQL database through I suppose an interface created with nodeJS. But you did not claim to teach that in this course, I just hoped you pointed in that direction. It does appear that every lecturer has another editor and platform on which the database is run. I understand that, but I do not think it is practical or useful for students to have to install a new platform for each course. So I did not use your advice and work in another way, but eventually sorted the issue. As I have done a bit of SQL where all those lecturers advice on formatting the code e.g. when doing an INSERT INTO. I did get stuck where adding line breaks in the nodeJS script was an issue, but not mentioned. Maybe you can consider adding a note to help others. Thanks Wallo Grant
Florian
February 1, 2021
This course teaches exactly what i need to get my project done. I am able to get data into an out of a database via node.js and javascript.
Semiu
December 20, 2020
This is a good introduction to using Node.js with MySQL. It would have taken a five-star review if it includes (a) handling data entered from HTML form (which is the real-life experience for developers), and (b) handling stored procedures in MySQL with "CALL". Asides from being a way to avoid SQL injection, complex queries cannot be embedded into the node.js without complicating readability.
Bill
March 16, 2020
Look no further than lesson #7 where he gets an error message about the json file while installing the mysql module and has no idea why. A good instructor would have known what it meant right away, an average instructor would have stopped the video right there and figure it out instead of adding it to the lessons. Any time someone is going to follow along with a lesson, there are going to be slight differences. For instance, I already had a local database so I had to create a username and password instead of using the default database settings like in the lesson. Because of that, when I had a question, the answer was start over. Really? A good instructor would be able to look at the error message that I provided and give me a better advice than just start over.
Jacques
March 4, 2020
It's my opinion that this course doesn't have enough content to warrant the same price range as much more robust courses on the site.

Charts

Price

Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Price chart

Rating

Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Ratings chart

Enrollment distribution

Intro To MySQL With Node.js - Learn To Use MySQL with Node! - Distribution chart

Related Topics

2278579
udemy ID
3/18/2019
course created date
11/13/2019
course indexed date
Bot
course submited by