Intro To MySQL With Node.js | Codemy.com

Intro To MySQL With Node.js


 

Course: 25 Videos
Length: 2 Hours
Price: $49

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!

See you inside!

 

Just $49



 


 

Course Content…

Module 1 Intro To MySQL With Node.js
Unit 1 Course Intro | Video 1
Unit 2 Install Node | Video 2
Unit 3 Install Wamp | Video 3
Unit 4 Install Sublime and Git Bash | Video 4
Unit 5 Start Sublime and Bash | Video 5
Unit 6 NPM Install MySQL | Video 6
Unit 7 Create a Connection | Video 7
Unit 8 Create a Database | Video 8
Unit 9 Create a Table | Video 9
Unit 10 Alter Table | Video 10
Unit 11 Insert Into Table | Video 11
Unit 12 Insert Many Into Table | Video 12
Unit 13 Result Messages | Video 13
Unit 14 Select All | Video 14
Unit 15 Loop Thru Selected | Video 15
Unit 16 Select Specific | Video 16
Unit 17 Select Fields | Video 17
Unit 18 Where Clause | Video 18
Unit 19 And Or | Video 19
Unit 20 Where Variables | Video 20
Unit 21 Order By | Video 21
Unit 22 Delete Record | Video 22
Unit 23 Update Records | Video 23
Unit 24 Limit Records | Video 24
Unit 25 Drop Table | Video 25


 

Just $49