Explore what SQL/NoSQL prepared statements are and how you can apply them to your projects.
- [Instructor] A prepared statement is basically…the use of a template in your code…with empty values when making queries to the server,…and then as the command is executed,…the empty values are replaced with the data needed…to fulfill the query.…The beauty of most of today's tools for querying databases…is that they already include them,…so if you are using Mongoose for MongoDB,…or Sequelize to query SQL databases,…you've got this area covered already,…so the general guideline here is to use those tools,…like we're doing in our application, and if you're not,…you'll thank me both from a security perspective…or a development perspective,…as they make querying and setting up your server…with the database much easier.…
If you would like more information on the subject,…for Mongo development, go to this webpage,…mongoosejs.com and on this page,…you'll find more information about how to set it up,…what it saves you, and so on, so forth.…And if you prefer developing with SQL,…then use Sequelize, which you can find more information…
- OWASP resources and security threats
- Cross-site scripting and denial of service attacks
- Managing packages in a Node.js app
- Adding two-factor and read-only tokens with npm
- Using prepared statements for SQL/NoSQL
- Encrypting user data and session management
- Adding HTTPS protocol to an application
- Using cookie attributes
- Tools for testing
Skill Level Intermediate
Node.js: Deploying Applicationswith Kirsten Hunter1h 24m Intermediate
Node.js: Debugging and Performance Tuningwith Jon Peck2h 44m Intermediate
1. Security Overview
OWASP top 10 in Node.js2m 22s
2. Best Practices: Packages
3. Best Practices: Data
4. Best Practices: Server Level
5. Tools for Testing
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.