Last updated 11/2021 MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz Language: English | Size: 2.38 GB | Duration: 2h 9m Learn MySql Database With Node.js and jаvascript 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 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