From the course: Complete Guide to Analytics Engineering

Unlock this course with a free trial

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

Database best practices

Database best practices

From the course: Complete Guide to Analytics Engineering

Start my 1-month free trial Buy for my team

Database best practices

“

- [Narrator] When working in your organization's database, you're likely to find a lot of different work styles and organization processes. At some point in your career, you're likely to run into some weird or improper stuff. In this chapter, we're going to discuss some best practices for working in databases that will not only make your work smoother and more organized, but it will also protect you from some potential dangers. When working with databases, you're likely to run into some data that is critical to the organization. This could be account balances, revenue line items, patient medical records, inventory data, employee information, et cetera. Losing this data could lose your company money or time. As such, it's a good practice to protect your mission-critical data. One way to protect this data is to limit who can alter it. In the database, you can create roles and assign users to those specific roles. It's a good idea to start by giving someone read-only access when they…

Contents