From the course: CompTIA Data Systems (DS0-001) Cert Prep

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Code auditing

Code auditing

From the course: CompTIA Data Systems (DS0-001) Cert Prep

Start my 1-month free trial Buy for my team

Code auditing

“

- As you've discovered throughout this course, SQL Code is at the core of the work of data systems professionals. SQL is an incredibly powerful language that can create, retrieve, update, and delete data, as well as alter the structure of the database itself. Users and administrators with access to issue SQL commands have immense power, and with that great power comes great responsibility. Data systems professionals should conduct regular audits of SQL Code to ensure that it's properly designed, appropriately permissioned, and functioning normally. These code audits can uncover security, operational and performance issues. Many databases and other IT systems grant access to users and services through the use of passwords, API keys, and other secrets. Managing these secrets can be tricky as they can be easily stolen if they're not properly secured. For this reason, credentials to sensitive systems should be stored in secure password repositories where they're accessed in real time when…

Contents