Intro To Mysql With Node.Js - Learn To Use Mysql With Node!

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 jаvascript
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 jаvascript. 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 jаvascript 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 jаvascript


Homepage

https://www.udemy.com/course/intro-to-mysql-with-nodejs-and-javascript/