Summary

You have worked your way through a lot in this chapter, so let's recap what you have learned. In the Best practices for SQL client development section, you learned about the importance of creating a development server, including how to duplicate the production database, the importance of creating regular backups during development and how to do so easily and quickly, and how to recover from accidental loss or damage by restoring the full database or just the tables that were lost or damaged.

You also learned how to install modules, connect to the database, and modularize the connection script so that it can be reused in other scripts using Node.js. Finally, you learned how to create a database and add tables using Node.js.

In the next chapter, you will learn how to modify the structure of tables and data within tables. You will also learn how to output the data to the console and the browser by using text and Excel files, including formatting outputs and creating...