PAC | Introduction To MySQL With Node.js. Learn To Use MySQL With Node (2019 EN)

Company: Packt Publishing
Author: John Elder
Full Title: Introduction To MySQL With Node.js. Learn To Use MySQL With Node
Year: 2019
Language: English
Genre: Educational: Databases
Skill Level: -
Price: €183.99
-
Files: MP4 (+ Code Files)
Time: 01:57:50
Video: AVC, 1918 x 1080 (1.776) at 30.000 fps 400 kbps
Audio: AAC at 148 Kbps, 2 channels, 48.0 KHz



Master MySQL databases with Node.js and JavaScript—the fast and easy way!.

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 course, we 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. If you've ever wanted to understand databases or use them in your Node programs, this is the course for you.


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 the MySQL module
✓ 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 a database
✓ How to explore what's in a database whenever you want
✓ How to create basic reports with the data from your database

Features:
✓ Learn how to use MySQL databases with Node js
✓ Learn how to create databases and tables, add data, sort data, create reports, pull specific data, and more.


Lessons:
1. Installing All the Tools
01. Introduction
02. Install Node
03. Install Wamp
04. Install Sublime and Git Bash
05. Start Sublime and Bash
06. NPM Install MySQL
2. Creating Connections and Databases
07. Create a Connection
08. Create a Database
09. Create a Table
3. Database SQL Commands
10. Alter Table
11. Insert into Table
12. Insert Many into Table
13. Result Messages
14. Select All
15. Loop Thru Selected
16. Select Specific
17. Select Fields
18. Where Clause
19. And Or
20. Where Variables
21. Order By
22. Delete Record
23. Update Records
24. Limit Records
25. Drop Table

Our members see more. Join us!
-------------
Our members see more. Join us!