Javascript and mySQL 8.x Crash Course

Spin up mySQL 8.x instance in seconds and work with it from Node JS Javascript with the promised based mysql2 library
Rating: 3.9 out of 5 (20 ratings)
5,115 students
Javascript and mySQL 8.x Crash Course
Rating: 3.9 out of 5 (20 ratings)
5,116 students
How to create mySQL 8.x Instance
Create Databases in mySQL
Connect to mySQL from Javascript Node JS
Query mySQL Tables from Javascript
Perform DML operations from Javascript (Insert/Update/Delete)
Execute Transactions on mySQL from Javascript

Requirements

  • Installed Visual Studio Code
  • Installed Node JS
  • Installed Docker
Description

MySQL is a popular open-source relational database management system. As part of the LAMP stack, mySQL became a critical part of the web platform. In this course I want to show how we can build Javascript applications to work MySQL database. Here is what we will do:

  • Introduction - Lecture 1

  • Spin up mysql 8.x instance with docker - Lecture 2

  • Create Database, Tables, and insert rows - Lecture 3

  • Connect to mySQL from Javascript(mysql2) - Lecture 4

  • Executing SELECT queries from Javascript - Lecture 5

  • Executing DML (insert/update/delete) from Javascript on mySQL - Lecture 6

  • Transactions - Lecture 7


Who this course is for:
  • Intermediate Javascript Developers to work with databases
Curriculum
1 section • 8 lectures • 40m total length
  • Introduction
  • Spin up mysql 8.x instance with docker
  • Create Database, Tables, and insert rows in mySQL CLI
  • Connect to mySQL from Javascript with mysql2 library
  • Execute SELECT queries from Javascript
  • Executing DML (insert/update/delete) from Javascript on mySQL
  • Transactions
  • myISAM

Instructor
Software Engineer, Author
Hussein Nasser
  • 4.3 Instructor Rating
  • 907 Reviews
  • 37,200 Students
  • 7 Courses

My name is Hussein and I’m a software engineer. Ever since my uncle gave me my first programming book in 1998 (Learn programming with Visual Basic 2) I discovered that software is my passion. I started my blog, and YouTube channel as an outlet to talk about software.



Using software to solve interesting problems is one of the fascinating things I really enjoy. Feel free to contact me on my social media channels to tell your software story, ask questions or share interesting problems. I would love to hear it!



I also specialize in the field of geographic information systems (or GIS). I helped many organizations in different countries implement the GIS technology and wrote custom apps to fit their use cases and streamline their workflows since 2005. I wrote five books on Esri ArcGIS technology, recorded over two hundred YouTube videos and software tutorials being watched until this day and started a software engineer podcast in 2018. I've been an engineer at Esri building cool GIS technologies since 2015.