|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/intro-to-mysql-with-nodejs-and-javascript/
课程评论:没有评论
课程名称:使用Node.js入门MySQL - 学习如何在Node中使用MySQL! 课程概述:当今所有事物都使用数据库,其中MySQL是最受欢迎的数据库之一。MySQL是免费的开源数据库,非常适合几乎所有需求。而Node.js则是一个强大且流行的网页开发平台,两者结合形成了强大的组合!在本课程中,您将学习如何在Node.js和JavaScript中使用MySQL的基础知识,包括如何创建数据库和表、添加数据、排序数据、生成报告、提取特定数据等。课程假设您已经具备基本的JavaScript编程和Node知识,但不需要任何关于数据库或MySQL的背景知识。 您将学习: - 什么是数据库 - 如何安装Node - 如何安装Git Bash终端 - 如何下载MySQL - 如何安装Wamp和PHPMyAdmin - 如何安装MySQL Node模块 - 如何在Node中连接到数据库 - 如何使用PHPMyAdmin探索MySQL - 如何创建数据库 - 如何创建表 - 如何向表中插入一条记录 - 如何向表中插入多条记录 - 数据类型的理解 - 如何从表中选择数据 - 如何格式化结果 - 如何使用WHERE子句 - 如何使用LIKE子句和通配符 - 如何使用AND和OR - 如何更新记录 - 如何限制和排序结果 - 如何删除记录 - 如何删除(删除)表等。 我将逐步引导您完成以上内容。如果您在学习过程中有任何问题,我会为您解答。如果您曾想理解数据库或在Node程序中使用数据库,那么本课程就是为您准备的。我们将免费下载所需的所有内容,您不需要任何特殊工具!期待在课程中见到您!- John Elder
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 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