From the course: Advanced SQL for Application Development
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Database errors
From the course: Advanced SQL for Application Development
Database errors
- [Narrator] An important key to ensuring that our applications are reliable is handling database errors. We're probably all familiar with Murphy's Law that whatever can go wrong will go wrong, and let's just take a look at how many different ways things can go wrong in a database application. First of all, there can be interface errors and that has to do with interfaces to the database. There could be errors within the database itself. It could have errors regarding how we work with the data. There could be operational errors, integrity errors, especially around how we're handling data and working with constraints. There could be some internal error to the RDBMS. There could also be programming errors on our part, and we may try to do things that actually aren't supported by that particular database, so let's take a look at each of these in a little more detail. Now, here are some examples of interface and database…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
(Locked)
Database errors2m 59s
-
(Locked)
Error trapping5m 11s
-
(Locked)
Database not responding, timeouts, and exponential backoff4m 11s
-
(Locked)
Connection pooling and bulk heads3m 53s
-
(Locked)
Monitoring and logging best practices4m 14s
-
(Locked)
Challenge: When your Python application fails30s
-
(Locked)
Solution: When your Python application fails32s
-
(Locked)
-
-