Description:


Description

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!

Who this course is for:

   Anyone who wants to use the MySQL Database with Node js and Javascript

Requirements

   A Basic Understanding Of Javasctipt Programming Would Be Helpful
   A Basic Understanding Of Node js would be useful
   You don’t need any special tools, we’ll download everything we need for free. You just need a Windows, Mac, or Linux computer

Last updated 3/2019