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!

What you'll 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

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

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 DatabaseHow To Install NodeHow To Install Git Bash TerminalHow To Download MySQLHow To Install Wamp and PHPMyAdminHow To Install the MySQL Node ModuleHow To Connect to Database in NodeHow To Explore MySQL With PHPMyAdminHow To Create A DatabaseHow To Create A TableHow To Insert One Record Into TableHow To Insert Many Records Into TableUnderstanding Data TypesHow To Select Data From TableHow To Format Our ResultsHow To Use The Where ClauseHow To Use The Like Clause and WildcardsHow To Use AND and ORHow To Updating RecordsHow To Limit and Order ResultsHow To Delete RecordsHow 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

Overview

Section 1: Installing All The Tools

Lecture 1 Introduction

Lecture 2 First Things First: How To Get Support Fast!

Lecture 3 Install Node

Lecture 4 Install Wamp

Lecture 5 Install Sublime and Git Bash

Lecture 6 Start Sublime and Bash

Lecture 7 NPM Install MySQL

Section 2: Creating Connections and Databases

Lecture 8 Create a Connection

Lecture 9 Create a Database

Lecture 10 Create a Table

Section 3: Database SQL Commands

Lecture 11 Alter Table

Lecture 12 Insert Into Table

Lecture 13 Insert Many Into Table

Lecture 14 Result Messages

Lecture 15 Select All

Lecture 16 Loop Thru Selected

Lecture 17 Select Specific

Lecture 18 Select Fields

Lecture 19 Where Clause

Lecture 20 And Or

Lecture 21 Where Variables

Lecture 22 Order By

Lecture 23 Delete Record

Lecture 24 Update Records

Lecture 25 Limit Records

Lecture 26 Drop Table

Section 4: Conclusion

Lecture 27 Bonus Lecture

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