Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

The Hidden Costs of Poor Database Access

GOTO Conferences via YouTube

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the hidden costs of poor database access in this 40-minute conference talk from GOTO Copenhagen 2019. Delve into common anti-patterns in database access, learn about alternative data models, and compare major database architectures. Discover how to optimize current projects and make informed decisions for future ones. Cover topics such as performance vs. productivity, database bottlenecks, SELECT * usage, prepared statements, blocking vs. non-blocking calls, joins, hierarchical data, and SQL++ compatibility. Gain insights on querying complex data structures and understand the implications of SQL:2016's JSON support. Walk away with key takeaways to improve database access and overall application performance.

Syllabus

Intro
Performance vs productivity
Databases are the bottleneck of most apps
SELECT *
Prepared statements
Blocking vs non-blocking calls
Joins
I want to be productive!
Wait, why do we have to choose?
Hierarchical data
But how do I query that?
SQL++ is backwards compatible
But SQL:2016 introduced JSON support
Key takeaways
Outro

Taught by

GOTO Conferences

Reviews

Start your review of The Hidden Costs of Poor Database Access

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.