Explore a description of CRUD and why it matters to JDBC.
- [Instructor] The final thing that…I really want to talk about before we jump into…actually writing a lot of code here…is the concept of CRUD when dealing with databases.…Now, CRUD is an acronym for the four main functions…that you do to data in a database:…create, read, update, delete.…Now this is all part of the data manipulation language,…or DML.…Most SQL statements, at least most of them…that a developer will operate with on a regular basis,…are extensions of these four main functions.…
Now, I have a few thoughts here…about how to get really good at writing SQL,…especially when you're dealing with CRUD operations.…First and foremost is to learn SQL itself.…A developer needs to understand how SQL works,…how it operates, and how to optimize it.…I do also believe that it's important,…at least at the base level,…for developers to learn a little bit about data theory,…and more important than that is to learn relational algebra.…
Learning this allows you to understand…how complex joint patterns can actually…cause data anomalies with what is returned.…
AuthorFrank P Moley III
- Deciphering JDBC terminology
- Using containerized PostgreSQL
- Creating, reading, updating, and deleting data
- The Repository pattern
- Using stored procedures
- Ordering and limiting results
- Transactions in JDBC
- Handling exceptions
Skill Level Intermediate
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Programming Foundations: Databaseswith Simon Allardice3h 11m Appropriate for all
Java Essential Training: Objects and APIswith David Gassner2h 46m Intermediate
What you need to know5m 10s
1. Introducing Java Data Access
2. Data Access Basics
3. Advanced Data Access
Next steps3m 26s
- 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.