title
Node.js MySQL Tutorial | Building CRUD App with Node.js Express and MySQL | Edureka

description
** Node.js Certification Training: https://www.edureka.co/nodejs-certification-training ** This Edureka video on 'Node.js MySQL Tutorial' will help you in learning how to connect to a MySQL database from your Node.js application with practical demonstration. In this session following topics have been covered: [0:33] What Is MySQL [1:13] Advantages Of MySQL [3:42] MySQL Installation [4:47] Building Crud Api With Node.Js And MySQL ------------------------------------- Do subscribe to our channel and hit the bell icon to never miss an update from us in the future: https://goo.gl/6ohpTV SlideShare: https://www.slideshare.net/EdurekaIN Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka #edureka #edurekanodejs #nodejsmysql #nodejsmysqltutorial #nodejscertification #nodejstraining #nodejsonlinetraining ----------------------------------------------------------------- How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 3. At the end of the training, you will be working on a real-time project for which we will provide you a Grade and a Verifiable Certificate! -------------------------------------------------------------------- About The Course Node.js Training is a platform that enables the participants to build high performance, event-driven, real-time and scalable networking applications just by using JavaScript. Edureka's Node.js training will train you to build networking and web-based applications that are far more superior and efficient than applications built in other languages. ---------------------------------------------------------------------- Who should go for this course? This course is designed for professionals who aspire to be application developers and gain expertise in building real-time, highly-scalable applications in Node.js. The following professionals can go for this course : 1. Web Developers 2. Project Managers 3. Software Architects 4. Testing Professionals ----------------------------------------------------------------------- Why learn Node.js? Node.js uses JavaScript - a language known to millions of developers worldwide - thus giving it a much lower learning curve even for complete beginners. Using Node.js you can build simple Command Line programs or complex enterprise level web applications with equal ease. Node.js is an event-driven, server-side, asynchronous development platform with lightning speed execution. Node.js helps you to code the most complex functionalities in just a few lines of code. ----------------------------------------------------------------------- Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. Please write back to us at sales@edureka.in or call us at IND: 9606058406 / US: 18338555775 (toll-free) for more information.

detail
{'title': 'Node.js MySQL Tutorial | Building CRUD App with Node.js Express and MySQL | Edureka', 'heatmap': [{'end': 821.262, 'start': 804.599, 'weight': 0.73}, {'end': 905.767, 'start': 888.088, 'weight': 0.812}, {'end': 1007.237, 'start': 986.664, 'weight': 0.72}, {'end': 1069.063, 'start': 1038.619, 'weight': 0.966}], 'summary': 'This tutorial covers mysql integration with node.js, emphasizing its open-source nature, low cost, secure data protection, ease of management, high performance, high availability, and scalability. it includes setting up a node.js application, creating database and routes in mysql, and api verification using postman.', 'chapters': [{'end': 188.139, 'segs': [{'end': 76.734, 'src': 'embed', 'start': 49.967, 'weight': 0, 'content': [{'end': 54.868, 'text': "and it provides a lot of different storage engines which have different uses and it's been backed up by Oracle.", 'start': 49.967, 'duration': 4.901}, {'end': 57.189, 'text': "So it's open source, but it's been backed up by Oracle.", 'start': 54.928, 'duration': 2.261}, {'end': 60.25, 'text': 'So you can use it without any commercial license.', 'start': 57.749, 'duration': 2.501}, {'end': 63.911, 'text': 'And if you want a premium services or support from Oracle,', 'start': 60.55, 'duration': 3.361}, {'end': 71.073, 'text': 'you can sell by the premium support license for that and in which Oracle will provide you support for any kind of issue or a security patch or anything.', 'start': 63.911, 'duration': 7.162}, {'end': 76.734, 'text': 'So what are the advantages of my sequel to the node shares? So first is scalability and flexibility.', 'start': 71.633, 'duration': 5.101}], 'summary': 'Mysql is open source, backed by oracle, offers premium support, and provides scalability and flexibility.', 'duration': 26.767, 'max_score': 49.967, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod1849967.jpg'}, {'end': 104.789, 'src': 'embed', 'start': 80.236, 'weight': 3, 'content': [{'end': 86.179, 'text': 'So it can be installed on a very low-end machine like on a Raspberry Pi or it can be installed on a large scale server same way.', 'start': 80.236, 'duration': 5.943}, {'end': 92.963, 'text': 'You can use my sequel to create embedded server on a small device like a Raspberry Pi or on a new server, like on a AWS server,', 'start': 86.239, 'duration': 6.724}, {'end': 95.824, 'text': 'or even a server which you can deploy on your data warehouse.', 'start': 92.963, 'duration': 2.861}, {'end': 97.505, 'text': "So it's very scalable.", 'start': 96.485, 'duration': 1.02}, {'end': 102.808, 'text': 'You can choose different variations of hardware for my sequel and it will run on any of them.', 'start': 97.525, 'duration': 5.283}, {'end': 104.789, 'text': 'Next thing is low cost of ownership.', 'start': 103.368, 'duration': 1.421}], 'summary': 'Mysql is scalable, running on low-end devices like raspberry pi and large servers. it offers low cost of ownership.', 'duration': 24.553, 'max_score': 80.236, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod1880236.jpg'}, {'end': 151.686, 'src': 'embed', 'start': 119.525, 'weight': 1, 'content': [{'end': 120.986, 'text': 'Next one is secure data protection.', 'start': 119.525, 'duration': 1.461}, {'end': 124.388, 'text': 'So MySQL has been getting developed more than 10 years.', 'start': 121.626, 'duration': 2.762}, {'end': 132.633, 'text': 'So it has a good security implementation and it has powerful mechanisms to handle out different user accesses and ownerships on the database.', 'start': 124.908, 'duration': 7.725}, {'end': 136.939, 'text': "So it's very secure and it's been following the industry standards for security.", 'start': 133.177, 'duration': 3.762}, {'end': 138.92, 'text': 'Next point is ease of management.', 'start': 137.479, 'duration': 1.441}, {'end': 143.322, 'text': 'It is very easy to download and start your first development with mysql.', 'start': 139.46, 'duration': 3.862}, {'end': 145.003, 'text': "So it's very easy to maintain also.", 'start': 143.702, 'duration': 1.301}, {'end': 150.385, 'text': 'So it provides you different tools like mysql workbench, which can be used for maintaining your database or going through the database,', 'start': 145.123, 'duration': 5.262}, {'end': 151.686, 'text': 'records and everything,', 'start': 150.385, 'duration': 1.301}], 'summary': 'Mysql offers secure data protection and easy management with over 10 years of development, following industry security standards, and providing user-friendly tools like mysql workbench.', 'duration': 32.161, 'max_score': 119.525, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18119525.jpg'}, {'end': 194.462, 'src': 'embed', 'start': 169.253, 'weight': 2, 'content': [{'end': 176.135, 'text': 'so you can have multiple indexes in your system or single index in your system and also do caching of your records in your memory only,', 'start': 169.253, 'duration': 6.882}, {'end': 180.197, 'text': 'instead of like going through the records again and cache them inside your memory only.', 'start': 176.135, 'duration': 4.062}, {'end': 182.797, 'text': 'so in that way it provides a very good performance.', 'start': 180.197, 'duration': 2.6}, {'end': 188.139, 'text': "when you're working with my sequel, it can be used for applications which have a high demand on performance.", 'start': 182.797, 'duration': 5.342}, {'end': 194.462, 'text': 'So mysql can be also used as a server which is highly available or can be also used as a cluster database.', 'start': 188.719, 'duration': 5.743}], 'summary': 'Mysql can provide high performance for applications with high demand, offering multiple indexes and caching for improved performance, and can also be used as a highly available server or cluster database.', 'duration': 25.209, 'max_score': 169.253, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18169253.jpg'}], 'start': 11.499, 'title': 'Mysql integration with node.js', 'summary': 'Covers the integration of mysql with node.js, emphasizing its open-source nature, low cost, secure data protection, ease of management, and high performance.', 'chapters': [{'end': 188.139, 'start': 11.499, 'title': 'Node.js and mysql integration', 'summary': 'Covers the integration of mysql with node.js, discussing the features, advantages, and scalability of mysql, highlighting its open-source nature, low cost, secure data protection, ease of management, and high performance.', 'duration': 176.64, 'highlights': ['MySQL is open source, providing low cost of ownership with no startup cost for licensing, enabling easy application development and the option for paid support from Oracle. Open source nature, low cost of ownership, option for paid support from Oracle', 'MySQL offers secure data protection with over 10 years of development, strong security implementation, and adherence to industry standards for security. Secure data protection, strong security implementation, adherence to industry standards', 'MySQL provides high performance through caching data in memory, indexing, and optimizing data retrieval, making it suitable for applications with high demand on performance. High performance, caching data in memory, indexing, optimizing data retrieval', 'MySQL is very scalable, allowing installation on a variety of hardware, from low-end machines like Raspberry Pi to large-scale servers and cloud platforms like AWS. Scalability, installation on a variety of hardware, compatibility with cloud platforms', 'MySQL is easy to manage, with tools like MySQL Workbench for database maintenance, automated event scheduling, and cleanup operations, facilitating convenient development and maintenance. Ease of management, tools like MySQL Workbench, automated event scheduling, convenient development and maintenance']}], 'duration': 176.64, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod1811499.jpg', 'highlights': ['Open source nature, low cost of ownership, option for paid support from Oracle', 'Secure data protection, strong security implementation, adherence to industry standards', 'High performance, caching data in memory, indexing, optimizing data retrieval', 'Scalability, installation on a variety of hardware, compatibility with cloud platforms', 'Ease of management, tools like MySQL Workbench, automated event scheduling, convenient development and maintenance']}, {'end': 511.441, 'segs': [{'end': 225.654, 'src': 'embed', 'start': 188.719, 'weight': 0, 'content': [{'end': 194.462, 'text': 'So mysql can be also used as a server which is highly available or can be also used as a cluster database.', 'start': 188.719, 'duration': 5.743}, {'end': 199.744, 'text': 'So in which you can create master and slave servers and deploy on your cloud or in your data warehouse.', 'start': 194.802, 'duration': 4.942}, {'end': 205.887, 'text': 'So in that way, you can create different applications of the same database and keep a copy of them,', 'start': 200.324, 'duration': 5.563}, {'end': 210.849, 'text': 'so that if the demand is high or if there is any downtime of any server or any machine,', 'start': 205.887, 'duration': 4.962}, {'end': 214.811, 'text': 'you can easily switch to another slave or you can use a cluster for managing those things.', 'start': 210.849, 'duration': 3.962}, {'end': 218.609, 'text': "So it's very scalable in those parameters of high availability.", 'start': 215.447, 'duration': 3.162}, {'end': 221.011, 'text': "So we'll move with the next topic.", 'start': 219.77, 'duration': 1.241}, {'end': 223.173, 'text': 'MySQL installation.', 'start': 222.172, 'duration': 1.001}, {'end': 225.654, 'text': "So we'll see how we can install MySQL on our system.", 'start': 223.253, 'duration': 2.401}], 'summary': 'Mysql can be used for highly available servers or as a cluster database, allowing for scalability and easy management of server downtime.', 'duration': 36.935, 'max_score': 188.719, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18188719.jpg'}, {'end': 371.688, 'src': 'embed', 'start': 348.171, 'weight': 3, 'content': [{'end': 355.241, 'text': 'From here you can start the mysql server or stop the mysql server, and you can also configure different directories for mysql,', 'start': 348.171, 'duration': 7.07}, {'end': 358.546, 'text': 'like the error directory or the data directory for mysql server.', 'start': 355.241, 'duration': 3.305}, {'end': 362.143, 'text': 'So the next thing is which we want to download is the mysql workbench.', 'start': 359.281, 'duration': 2.862}, {'end': 369.126, 'text': 'So workbench is a tool in which you can connect to your database and get information from the database and do operations on it.', 'start': 362.723, 'duration': 6.403}, {'end': 371.688, 'text': 'So in this case, I will just go scroll down.', 'start': 369.566, 'duration': 2.122}], 'summary': 'Transcript discusses starting/stopping mysql server, configuring directories, and downloading mysql workbench for database management.', 'duration': 23.517, 'max_score': 348.171, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18348171.jpg'}, {'end': 477.124, 'src': 'embed', 'start': 452.301, 'weight': 5, 'content': [{'end': 459.322, 'text': "Now, we need to start with the node.js application part where we're going to create a connection between the node.js application and MySQL.", 'start': 452.301, 'duration': 7.021}, {'end': 462.163, 'text': 'So for that first we have to create a node.js application.', 'start': 459.763, 'duration': 2.4}, {'end': 464.244, 'text': "So we'll open my terminal.", 'start': 462.523, 'duration': 1.721}, {'end': 468.425, 'text': "So now in my terminal, I'm going to start with a node.js application.", 'start': 464.844, 'duration': 3.581}, {'end': 475.382, 'text': 'So create mkdir directory, node mysql example.', 'start': 468.805, 'duration': 6.577}, {'end': 477.124, 'text': "now we'll navigate to this folder.", 'start': 475.382, 'duration': 1.742}], 'summary': 'Creating a connection between a node.js application and mysql by setting up a node.js application and navigating to the created directory.', 'duration': 24.823, 'max_score': 452.301, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18452301.jpg'}], 'start': 188.719, 'title': 'Mysql high availability and scalability', 'summary': 'Discusses using mysql for high availability and scalability, creating master and slave servers, ensuring scalability and high availability, managing server downtime and demand spikes.', 'chapters': [{'end': 225.654, 'start': 188.719, 'title': 'Mysql high availability and scalability', 'summary': 'Discusses using mysql as a highly available server or cluster database, enabling the creation of master and slave servers for different applications, ensuring scalability and high availability in managing server downtime and demand spikes.', 'duration': 36.935, 'highlights': ['MySQL can be used as a highly available server or a cluster database, allowing the creation of master and slave servers for different applications, ensuring scalability and high availability.', 'This setup enables easy switching to another slave or using a cluster for managing server downtime or high demand.', "MySQL's high availability and scalability make it a valuable choice for cloud deployment or data warehouse usage."]}, {'end': 511.441, 'start': 226.215, 'title': 'Installing mysql on mac and using mysql workbench', 'summary': 'Covers the process of downloading and installing mysql server and mysql workbench on a mac machine, including steps for configuring the server, connecting to the database using mysql workbench, and setting up a node.js application for mysql.', 'duration': 285.226, 'highlights': ['The chapter covers the process of downloading and installing MySQL server and MySQL Workbench on a Mac machine Covers the process of downloading and installing MySQL server and MySQL Workbench on a Mac machine, including steps for configuring the server and connecting to the database using MySQL Workbench.', 'Steps for configuring the server and connecting to the database using MySQL Workbench Describes the steps for configuring the server and connecting to the database using MySQL Workbench, including setting up connections and running queries.', 'Setting up a node.js application for MySQL Describes the process of setting up a node.js application for MySQL, including initializing the application and creating directories.']}], 'duration': 322.722, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18188719.jpg', 'highlights': ['MySQL can be used as a highly available server or a cluster database, ensuring scalability and high availability.', 'The setup enables easy switching to another slave or using a cluster for managing server downtime or high demand.', "MySQL's high availability and scalability make it a valuable choice for cloud deployment or data warehouse usage.", 'The chapter covers the process of downloading and installing MySQL server and MySQL Workbench on a Mac machine.', 'Describes the steps for configuring the server and connecting to the database using MySQL Workbench.', 'Describes the process of setting up a node.js application for MySQL, including initializing the application and creating directories.']}, {'end': 768.746, 'segs': [{'end': 575.622, 'src': 'embed', 'start': 530.095, 'weight': 0, 'content': [{'end': 533.497, 'text': 'The next step is open this node application and we will studio code.', 'start': 530.095, 'duration': 3.402}, {'end': 535.579, 'text': "So I'm going to use Visual Studio code for development.", 'start': 533.517, 'duration': 2.062}, {'end': 538.255, 'text': "but you're free to use any editor which you like.", 'start': 536.135, 'duration': 2.12}, {'end': 543.636, 'text': 'So the folder is loaded and it has the same package or decent file, which we just created.', 'start': 538.775, 'duration': 4.861}, {'end': 550.137, 'text': 'Now we have to install all the packages which we need or just go back to a terminal and install all the packages.', 'start': 544.136, 'duration': 6.001}, {'end': 555.278, 'text': 'So we need to install and p.m. Install packages which are dependencies for this project.', 'start': 551.038, 'duration': 4.24}, {'end': 558.919, 'text': "So we'll install Express Express handlebars.", 'start': 555.298, 'duration': 3.621}, {'end': 565.32, 'text': 'My sequel so these packages the three of them are dependencies for this project.', 'start': 560.819, 'duration': 4.501}, {'end': 569.379, 'text': 'We also need body parser to parse the body information.', 'start': 566.198, 'duration': 3.181}, {'end': 570.64, 'text': "So we'll just install that too.", 'start': 569.419, 'duration': 1.221}, {'end': 575.622, 'text': 'We also need nodemon which we are going to install as a dev dependency.', 'start': 572.381, 'duration': 3.241}], 'summary': 'Setting up a node application in visual studio code, installing packages including express, express handlebars, mysql, body parser, and nodemon.', 'duration': 45.527, 'max_score': 530.095, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18530095.jpg'}, {'end': 703.155, 'src': 'embed', 'start': 602.39, 'weight': 1, 'content': [{'end': 605.872, 'text': 'So nodemon is installed on my system now can start developing our application.', 'start': 602.39, 'duration': 3.482}, {'end': 608.193, 'text': 'So we have the package edition file.', 'start': 606.752, 'duration': 1.441}, {'end': 615.357, 'text': 'So now we will create our server file in web project folder to define our starting files for node.js.', 'start': 609.313, 'duration': 6.044}, {'end': 626.954, 'text': 'So for that I will just create a server.js file and this we have dependency on mysql require MySQL like this and express.', 'start': 615.817, 'duration': 11.137}, {'end': 636.119, 'text': 'Const body parser.', 'start': 634.598, 'duration': 1.521}, {'end': 642.742, 'text': 'Require body parser.', 'start': 641.101, 'duration': 1.641}, {'end': 652.948, 'text': 'So now we will create a express application by saying app is equal to express.', 'start': 648.826, 'duration': 4.122}, {'end': 659.182, 'text': 'and then we define app.use for body parcel.', 'start': 655.18, 'duration': 4.002}, {'end': 666.086, 'text': 'So this configures the node.js application.', 'start': 663.444, 'duration': 2.642}, {'end': 672.609, 'text': "Now, I'll just at the end, I will start this application by saying app.listen the port number.", 'start': 666.966, 'duration': 5.643}, {'end': 675.131, 'text': "So we'll just listen to port 3000.", 'start': 672.629, 'duration': 2.502}, {'end': 677.232, 'text': 'Now you have to configure how the database works.', 'start': 675.131, 'duration': 2.101}, {'end': 680.156, 'text': 'This is a node Express application.', 'start': 678.635, 'duration': 1.521}, {'end': 683.459, 'text': 'Now you have to define the configuration for the mysql database.', 'start': 680.176, 'duration': 3.283}, {'end': 691.085, 'text': 'So just write mysql connection is equal to mysql dot create connection and define the connection object over here.', 'start': 683.739, 'duration': 7.346}, {'end': 697.21, 'text': "So first we need the host that's localhost because I'm just pointing to the local machine.", 'start': 691.866, 'duration': 5.344}, {'end': 698.231, 'text': "So it's going to be localhost.", 'start': 697.25, 'duration': 0.981}, {'end': 703.155, 'text': 'Otherwise, you can provide the IP for the database the user for the database server.', 'start': 698.271, 'duration': 4.884}], 'summary': 'Developing a node.js application using express and mysql, configuring server and database settings, and listening on port 3000.', 'duration': 100.765, 'max_score': 602.39, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18602390.jpg'}, {'end': 768.746, 'src': 'embed', 'start': 735.808, 'weight': 5, 'content': [{'end': 740.371, 'text': 'so it provides us error if the connection object is not connected.', 'start': 735.808, 'duration': 4.563}, {'end': 749.857, 'text': 'so we can just try error handling like this.', 'start': 740.371, 'duration': 9.486}, {'end': 756.002, 'text': "so if the connection is successful, it will just print connected, otherwise it's going to print connection field.", 'start': 749.857, 'duration': 6.145}, {'end': 758.903, 'text': "so now i'll go back to my terminal and clear the screen.", 'start': 756.002, 'duration': 2.901}, {'end': 761.585, 'text': 'you can see the files over here.', 'start': 758.903, 'duration': 2.682}, {'end': 765.588, 'text': "so now i'll just run nodemon, server.js.", 'start': 761.585, 'duration': 4.003}, {'end': 768.746, 'text': 'So it says connection failed.', 'start': 767.264, 'duration': 1.482}], 'summary': "Error handling implemented for connection status, resulting in a 'connection failed' message.", 'duration': 32.938, 'max_score': 735.808, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18735808.jpg'}], 'start': 511.461, 'title': 'Node.js application development', 'summary': 'Covers setting up a node.js application in visual studio code, installing dependencies like express, express handlebars, mysql, and body parser, as well as dev dependency nodemon. it outlines the process of setting up a node.js express server, creating a server file, configuring dependencies, and starting the application on port 3000. additionally, it covers setting up a mysql database connection in node.js, including defining host, user, password, and configuring multiple statements, and demonstrates error handling and connection status feedback.', 'chapters': [{'end': 597.087, 'start': 511.461, 'title': 'Node.js application development', 'summary': 'Covers setting up a node.js application in visual studio code, installing dependencies including express, express handlebars, mysql, and body parser, as well as dev dependency nodemon.', 'duration': 85.626, 'highlights': ['Setting up a Node.js application in Visual Studio code The next step is open this node application in Visual Studio code, which is used for development.', 'Installing dependencies including Express, Express handlebars, MySQL, and body parser Dependencies like Express, Express handlebars, and MySQL are installed for the project.', 'Installing dev dependency nodemon Nodemon is installed as a dev dependency for the project.']}, {'end': 680.156, 'start': 602.39, 'title': 'Setting up node.js express server', 'summary': 'Outlines the process of setting up a node.js express server, creating a server file, configuring dependencies, and starting the application on port 3000.', 'duration': 77.766, 'highlights': ['The chapter outlines the process of setting up a Node.js Express server, creating a server file, configuring dependencies, and starting the application on port 3000.', 'Dependencies on mysql and express are required for the server setup.', 'The application is started on port 3000.']}, {'end': 768.746, 'start': 680.176, 'title': 'Configuring mysql connection in node.js', 'summary': 'Covers setting up a mysql database connection in node.js, including defining host, user, password, and configuring multiple statements, and demonstrates error handling and connection status feedback.', 'duration': 88.57, 'highlights': ['Defining the configuration for the mysql database, including host, user, password, and multiple statements configuration.', 'Demonstrating error handling for the connection status, with feedback on successful connection or failure.', 'Running nodemon server.js resulting in a connection failure.']}], 'duration': 257.285, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18511461.jpg', 'highlights': ['Setting up a Node.js application in Visual Studio code The next step is open this node application in Visual Studio code, which is used for development.', 'Dependencies on mysql and express are required for the server setup.', 'Defining the configuration for the mysql database, including host, user, password, and multiple statements configuration.', 'The chapter outlines the process of setting up a Node.js Express server, creating a server file, configuring dependencies, and starting the application on port 3000.', 'Installing dependencies including Express, Express handlebars, MySQL, and body parser Dependencies like Express, Express handlebars, and MySQL are installed for the project.', 'Demonstrating error handling for the connection status, with feedback on successful connection or failure.', 'Installing dev dependency nodemon Nodemon is installed as a dev dependency for the project.', 'The application is started on port 3000.', 'Running nodemon server.js resulting in a connection failure.']}, {'end': 1049.007, 'segs': [{'end': 905.767, 'src': 'heatmap', 'start': 804.599, 'weight': 0, 'content': [{'end': 810.544, 'text': 'So you can configure the character set and the collation for the database and it just confirms you the query.', 'start': 804.599, 'duration': 5.945}, {'end': 812.426, 'text': 'So now we have a database created over here.', 'start': 810.905, 'duration': 1.521}, {'end': 816.2, 'text': "We'll just go back to my code and save it again.", 'start': 812.759, 'duration': 3.441}, {'end': 821.262, 'text': 'So now you can see so what I did is I just went back to my server.js and saved it again.', 'start': 816.64, 'duration': 4.622}, {'end': 825.024, 'text': 'So which triggered the nodemon to reload the node.js server.', 'start': 821.702, 'duration': 3.322}, {'end': 828.705, 'text': "So now because I have the database ready, it's able to connect to the MySQL.", 'start': 825.544, 'duration': 3.161}, {'end': 830.986, 'text': 'Otherwise it was giving an error that the connection was failing.', 'start': 828.725, 'duration': 2.261}, {'end': 834.907, 'text': 'So the database creation has to be done before you start with the coding part.', 'start': 831.426, 'duration': 3.481}, {'end': 838.869, 'text': 'The next step is defining all the routes for our application.', 'start': 835.688, 'duration': 3.181}, {'end': 846.422, 'text': 'so the first thing is we are going to create different routes for this application, which are going to be in different files.', 'start': 839.657, 'duration': 6.765}, {'end': 848.864, 'text': 'so first i will create a routes folder.', 'start': 846.422, 'duration': 2.442}, {'end': 852.607, 'text': 'in this folder i will create people.js.', 'start': 848.864, 'duration': 3.743}, {'end': 866.658, 'text': 'this will have the route for all people and in this file i will import express, require express and define the router.', 'start': 852.607, 'duration': 14.051}, {'end': 878.524, 'text': "so i'll just define so this is a router object for the express application on which we are going to create all the routes.", 'start': 866.658, 'duration': 11.866}, {'end': 888.088, 'text': "so i'll just define get and the handler for that.", 'start': 878.524, 'duration': 9.564}, {'end': 894.37, 'text': "let's define request and response.", 'start': 888.088, 'duration': 6.282}, {'end': 896.811, 'text': "now we have to use this router, so i'll just export.", 'start': 894.37, 'duration': 2.441}, {'end': 905.767, 'text': 'this module, not exports, is equal to router And in my server file I have to import this in my application.', 'start': 896.811, 'duration': 8.956}], 'summary': 'Configured database, saved code, connected to mysql, created routes for application.', 'duration': 107.814, 'max_score': 804.599, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18804599.jpg'}, {'end': 981.342, 'src': 'embed', 'start': 938.157, 'weight': 5, 'content': [{'end': 946.803, 'text': 'so all the routes which are coming for slash people will go to the people routes file and in that we can handle the request which we need to respond back.', 'start': 938.157, 'duration': 8.646}, {'end': 951.447, 'text': "so now in my evil file, i'll just go back to the route which i have which is get.", 'start': 946.803, 'duration': 4.644}, {'end': 955.544, 'text': "So we're here, we can make a database connection and do the query part.", 'start': 952.182, 'duration': 3.362}, {'end': 959.087, 'text': 'So for creating the connection first, I will do one cleanup.', 'start': 956.105, 'duration': 2.982}, {'end': 964.27, 'text': 'So I will create a new file which will be named as connection.js,', 'start': 959.347, 'duration': 4.923}, {'end': 968.333, 'text': 'and I will move the connection details from this app.js to a particular file over there.', 'start': 964.27, 'duration': 4.063}, {'end': 976.298, 'text': 'So just take this and put it over here and now I can export my sequel connection from here module dot exports.', 'start': 968.633, 'duration': 7.665}, {'end': 978.841, 'text': 'to mysql connection.', 'start': 977.68, 'duration': 1.161}, {'end': 981.342, 'text': "so i'm exporting mysql connection from here.", 'start': 978.841, 'duration': 2.501}], 'summary': 'Create a new file connection.js to handle database queries and export mysql connection.', 'duration': 43.185, 'max_score': 938.157, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18938157.jpg'}, {'end': 1007.237, 'src': 'heatmap', 'start': 986.664, 'weight': 0.72, 'content': [{'end': 997.209, 'text': 'const. mysql connection is equal to require connection.', 'start': 986.664, 'duration': 10.545}, {'end': 999.531, 'text': 'now i can run the connection methods over here.', 'start': 997.209, 'duration': 2.322}, {'end': 1004.353, 'text': 'so i will just copy this line and move to my people.js.', 'start': 999.531, 'duration': 4.822}, {'end': 1007.237, 'text': 'so actually we need to make a connection over here.', 'start': 1005.456, 'duration': 1.781}], 'summary': 'Setting up mysql connection for people.js.', 'duration': 20.573, 'max_score': 986.664, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18986664.jpg'}], 'start': 769.927, 'title': 'Creating database and routes in mysql', 'summary': 'Covers the process of creating a database in mysql using mysql workbench, successful connection to the database, creating routes for an application, defining routes in different files, and handling database queries.', 'chapters': [{'end': 834.907, 'start': 769.927, 'title': 'Creating database in mysql', 'summary': 'Discusses the process of creating a database in mysql using mysql workbench, ensuring successful connection to the database and the importance of creating the database before starting the coding part.', 'duration': 64.98, 'highlights': ['Creating a database named Edureka using MySQL Workbench, ensuring successful connection to the MySQL server.', 'Saving the server.js file triggers nodemon to reload the node.js server, allowing successful connection to the MySQL database.', 'The importance of creating the database before starting the coding part to avoid connection errors.']}, {'end': 1049.007, 'start': 835.688, 'title': 'Creating routes and database connection', 'summary': 'Covers creating routes for an application, including defining routes in different files, importing express and defining a router, and moving connection details to a separate file to export the mysql connection, with a focus on creating a route for people and handling database queries.', 'duration': 213.319, 'highlights': ['Defining routes in different files and creating a routes folder The speaker creates different routes for the application in separate files within a routes folder.', 'Importing express and defining a router The process involves importing express and defining a router object for creating all the routes.', 'Moving connection details to a separate file and exporting the MySQL connection The connection details are moved from the main application file to a separate file named connection.js to export the MySQL connection.', 'Creating a route for people and handling database queries A route for people is created, where database queries, such as a select query for retrieving all records, are handled.']}], 'duration': 279.08, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod18769927.jpg', 'highlights': ['Creating a database named Edureka using MySQL Workbench, ensuring successful connection to the MySQL server.', 'The importance of creating the database before starting the coding part to avoid connection errors.', 'Saving the server.js file triggers nodemon to reload the node.js server, allowing successful connection to the MySQL database.', 'Defining routes in different files and creating a routes folder The speaker creates different routes for the application in separate files within a routes folder.', 'Importing express and defining a router The process involves importing express and defining a router object for creating all the routes.', 'Moving connection details to a separate file and exporting the MySQL connection The connection details are moved from the main application file to a separate file named connection.js to export the MySQL connection.', 'Creating a route for people and handling database queries A route for people is created, where database queries, such as a select query for retrieving all records, are handled.']}, {'end': 1245.076, 'segs': [{'end': 1200.517, 'src': 'embed', 'start': 1049.007, 'weight': 0, 'content': [{'end': 1053.149, 'text': 'now we need to go back to our terminal and run this code.', 'start': 1049.007, 'duration': 4.142}, {'end': 1054.13, 'text': 'so it says MySQL.', 'start': 1053.149, 'duration': 0.981}, {'end': 1054.87, 'text': "it's not defined.", 'start': 1054.13, 'duration': 0.74}, {'end': 1056.591, 'text': "so that's the issue.", 'start': 1054.87, 'duration': 1.721}, {'end': 1059.213, 'text': "because I haven't copied the MySQL import over here.", 'start': 1056.591, 'duration': 2.622}, {'end': 1062.915, 'text': 'so I have to cut this import from here and add it to my connection file.', 'start': 1059.213, 'duration': 3.702}, {'end': 1064.902, 'text': 'Now you can see it made a connection.', 'start': 1063.462, 'duration': 1.44}, {'end': 1069.063, 'text': 'Now the next step is go to Chrome and hit that URL.', 'start': 1065.822, 'duration': 3.241}, {'end': 1072.624, 'text': 'The URL was localhost 3000 slash people.', 'start': 1069.803, 'duration': 2.821}, {'end': 1077.344, 'text': "So I'll just hit this and go back to terminal and see if it gives any errors or something.", 'start': 1072.644, 'duration': 4.7}, {'end': 1081.325, 'text': 'So we got an error that there is no such table available on the database.', 'start': 1077.984, 'duration': 3.341}, {'end': 1084.065, 'text': 'Now what I have to do is I have to create this table.', 'start': 1081.785, 'duration': 2.28}, {'end': 1086.366, 'text': "So I'll go back to my MySQL workbench.", 'start': 1084.486, 'duration': 1.88}, {'end': 1091.247, 'text': "So I'm in MySQL workbench and I will create this table on this particular database.", 'start': 1086.946, 'duration': 4.301}, {'end': 1093.207, 'text': "So I'll name it as people.", 'start': 1091.847, 'duration': 1.36}, {'end': 1096.467, 'text': 'and define the columns for it.', 'start': 1095.206, 'duration': 1.261}, {'end': 1106.573, 'text': 'Name, you can define different parameters for people like age, define name, where care, 200.', 'start': 1097.467, 'duration': 9.106}, {'end': 1111.556, 'text': 'It prints you the query like do you want to execute this query? Yes, I want to and execute that query.', 'start': 1106.573, 'duration': 4.983}, {'end': 1113.817, 'text': 'So now the table will be created as people.', 'start': 1111.756, 'duration': 2.061}, {'end': 1120.261, 'text': 'I will go back to localhost and run localhost 3000 slash people.', 'start': 1114.598, 'duration': 5.663}, {'end': 1122.983, 'text': 'You can see it prints out a blank area over here.', 'start': 1120.702, 'duration': 2.281}, {'end': 1126.919, 'text': "because the table is created although it doesn't have any records in it.", 'start': 1123.598, 'duration': 3.321}, {'end': 1129.299, 'text': 'So now add records to this baby.', 'start': 1126.939, 'duration': 2.36}, {'end': 1139.901, 'text': "So I'm using the editor inside for quench for adding records.", 'start': 1136.28, 'duration': 3.621}, {'end': 1150.303, 'text': 'So just click on what record and say probing and is going to so I did the value for first record and for the second record.', 'start': 1140.641, 'duration': 9.662}, {'end': 1151.785, 'text': 'Apply the changes.', 'start': 1151.104, 'duration': 0.681}, {'end': 1155.068, 'text': 'So once you apply the changes, it will give you the queries that will be executed.', 'start': 1151.945, 'duration': 3.123}, {'end': 1161.654, 'text': 'So it says insert queries for adding records by the queries and confirm that the queries have been triggered successfully.', 'start': 1155.088, 'duration': 6.566}, {'end': 1164.317, 'text': "I'll go back to your browser and do it refresh.", 'start': 1161.674, 'duration': 2.643}, {'end': 1166.799, 'text': "So you'll see that the record started coming up.", 'start': 1164.337, 'duration': 2.462}, {'end': 1169.762, 'text': 'So these were the two records which I added into the database.', 'start': 1167.099, 'duration': 2.663}, {'end': 1176.148, 'text': "So now we have a successful database connection and it's able to retrieve records from the database.", 'start': 1170.262, 'duration': 5.886}, {'end': 1180.628, 'text': "So we can use different tools like postman to verify our api's.", 'start': 1176.806, 'duration': 3.822}, {'end': 1189.952, 'text': 'so I can just open postman and send the request to this URL, which is localhost 3000 slash people, send request and get request to it.', 'start': 1180.628, 'duration': 9.324}, {'end': 1193.654, 'text': 'And you can see it prints out a JSON response over here.', 'start': 1190.872, 'duration': 2.782}, {'end': 1200.517, 'text': "Why do I get a JSON response? So this my sequel package actually converts whatever the record you're getting from the database.", 'start': 1193.674, 'duration': 6.843}], 'summary': 'Created mysql database, added records, and verified api with postman.', 'duration': 151.51, 'max_score': 1049.007, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod181049007.jpg'}, {'end': 1245.076, 'src': 'embed', 'start': 1219.07, 'weight': 2, 'content': [{'end': 1225.432, 'text': "So this was example of running a MySQL server with node.js and we'll cover the more advanced parts in the next session.", 'start': 1219.07, 'duration': 6.362}, {'end': 1226.993, 'text': 'Thank you guys for joining in.', 'start': 1226.153, 'duration': 0.84}, {'end': 1230.066, 'text': 'I hope you have enjoyed listening to this video.', 'start': 1227.944, 'duration': 2.122}, {'end': 1238.031, 'text': 'Please be kind enough to like it and you can comment any of your doubts and queries and we will reply them at the earliest.', 'start': 1230.426, 'duration': 7.605}, {'end': 1243.895, 'text': 'Do look out for more videos in our playlist and subscribe to Edureka channel to learn more.', 'start': 1238.391, 'duration': 5.504}, {'end': 1245.076, 'text': 'Happy learning!.', 'start': 1244.435, 'duration': 0.641}], 'summary': 'Demo of running mysql server with node.js. advanced topics in next session. like, comment, subscribe for more videos.', 'duration': 26.006, 'max_score': 1219.07, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod181219070.jpg'}], 'start': 1049.007, 'title': 'Mysql setup and api verification', 'summary': "Covers setting up a mysql connection, creating a 'people' table, adding records to the database, and verifying the api with postman to retrieve json responses. it also includes running a mysql server with node.js and encourages engagement for future content.", 'chapters': [{'end': 1122.983, 'start': 1049.007, 'title': 'Setting up mysql connection and creating a table', 'summary': "Details setting up a mysql connection, including resolving errors and creating a table named 'people' with columns like name and age, followed by accessing the localhost url to view the table.", 'duration': 73.976, 'highlights': ["Creating a table named 'people' on the database by defining columns like name and age, and executing the query to create the table.", "Resolving the error of 'no such table available on the database' by creating the required table 'people' in MySQL workbench.", "Setting up the MySQL connection and resolving the issue of 'MySQL not defined' by moving the MySQL import to the connection file."]}, {'end': 1218.23, 'start': 1123.598, 'title': 'Adding records to database and verifying api with postman', 'summary': 'Covers the process of adding records to a database using an editor, applying changes, and verifying the api with postman, demonstrating the retrieval of json responses from the mysql server.', 'duration': 94.632, 'highlights': ['The process of adding records to a database using an editor and applying changes is described. Demonstrates the process of adding records to a database and applying changes to trigger insert queries.', 'The successful retrieval of records from the database is highlighted. Emphasizes the successful database connection and retrieval of records from the database.', 'The demonstration of verifying API with Postman and the retrieval of JSON responses from the MySQL server is explained. Shows the process of verifying API with Postman and the conversion of database records into JSON responses using the MySQL package.']}, {'end': 1245.076, 'start': 1219.07, 'title': 'Running mysql server with node.js', 'summary': 'Covered running a mysql server with node.js, with more advanced parts to be covered in the next session. it emphasized the importance of liking, commenting, subscribing, and looking out for more videos in the playlist.', 'duration': 26.006, 'highlights': ['The chapter covered running a MySQL server with node.js The example demonstrated the process of running a MySQL server with node.js.', 'More advanced parts to be covered in the next session The session mentioned that the next session will cover more advanced parts of running MySQL server with node.js.', 'Emphasized the importance of liking, commenting, subscribing, and looking out for more videos in the playlist The video emphasized the importance of viewer engagement by asking them to like, comment, subscribe, and look out for more videos in the playlist.']}], 'duration': 196.069, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/xn9ef5pod18/pics/xn9ef5pod181049007.jpg', 'highlights': ["Creating a table named 'people' on the database by defining columns like name and age, and executing the query to create the table.", 'The process of adding records to a database using an editor and applying changes is described. Demonstrates the process of adding records to a database and applying changes to trigger insert queries.', 'The chapter covered running a MySQL server with node.js The example demonstrated the process of running a MySQL server with node.js.', 'The successful retrieval of records from the database is highlighted. Emphasizes the successful database connection and retrieval of records from the database.', 'The demonstration of verifying API with Postman and the retrieval of JSON responses from the MySQL server is explained. Shows the process of verifying API with Postman and the conversion of database records into JSON responses using the MySQL package.', 'More advanced parts to be covered in the next session The session mentioned that the next session will cover more advanced parts of running MySQL server with node.js.', 'Emphasized the importance of liking, commenting, subscribing, and looking out for more videos in the playlist The video emphasized the importance of viewer engagement by asking them to like, comment, subscribe, and look out for more videos in the playlist.', "Resolving the error of 'no such table available on the database' by creating the required table 'people' in MySQL workbench.", "Setting up the MySQL connection and resolving the issue of 'MySQL not defined' by moving the MySQL import to the connection file."]}], 'highlights': ['High performance, caching data in memory, indexing, optimizing data retrieval', 'Secure data protection, strong security implementation, adherence to industry standards', 'Scalability, installation on a variety of hardware, compatibility with cloud platforms', 'Open source nature, low cost of ownership, option for paid support from Oracle', 'Ease of management, tools like MySQL Workbench, automated event scheduling, convenient development and maintenance', 'MySQL can be used as a highly available server or a cluster database, ensuring scalability and high availability.', 'The setup enables easy switching to another slave or using a cluster for managing server downtime or high demand.', "MySQL's high availability and scalability make it a valuable choice for cloud deployment or data warehouse usage.", 'The chapter covers the process of downloading and installing MySQL server and MySQL Workbench on a Mac machine.', 'Defining the configuration for the mysql database, including host, user, password, and multiple statements configuration.', 'The chapter outlines the process of setting up a Node.js Express server, creating a server file, configuring dependencies, and starting the application on port 3000.', 'Creating a database named Edureka using MySQL Workbench, ensuring successful connection to the MySQL server.', 'The importance of creating the database before starting the coding part to avoid connection errors.', "Creating a table named 'people' on the database by defining columns like name and age, and executing the query to create the table.", 'The process of adding records to a database using an editor and applying changes is described. Demonstrates the process of adding records to a database and applying changes to trigger insert queries.', 'The chapter covered running a MySQL server with node.js The example demonstrated the process of running a MySQL server with node.js.', 'The successful retrieval of records from the database is highlighted. Emphasizes the successful database connection and retrieval of records from the database.', 'The demonstration of verifying API with Postman and the retrieval of JSON responses from the MySQL server is explained. Shows the process of verifying API with Postman and the conversion of database records into JSON responses using the MySQL package.']}