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