Advanced SQL for Application Development
Heads up! This course may be archived and/or unavailable.
Many applications require a relational database. But poorly designed data architecture and poorly written SQL can result in subpar performance, unreliable services, and difficulty scaling. This course includes hands-on examples and lessons that show how to build scalable and resilient databases to support any application. Learn how to write optimized SQL for transaction processing, use indexes to reduce read latency, partition data to improve scalability, and use established design patterns. Instructor Dan Sullivan also explores object relational mapping and shows how to respond to database errors such as query timeouts and refused connections. After completing this course, you will be able to design robust database applications that can scale to meet increasingly demanding workloads.
Contents:
- Introduction
- 1. Advanced Querying with Select
- 2. Indexing Tables
- 3. Object-Relational Mapping (ORM)
- 4. Designing for Scalability
- 5. Designing for Reliability
- 6. Designing for Maintainability
- Conclusion
Get a Reminder
| Rating | Not enough ratings |
|---|---|
| Length | 2h 7m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Dan Sullivan |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science |
| Tags | SQL Database Development Application Development |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
IT Applications Trainer $44k
Applications Analyst/Web Applications Specialist $57k
Applications Analyst 1 2 3 $58k
Advanced Applications $72k
Many different sales & marketing positions $80k
Many various sales positions Manager $81k
Many Positions $82k
Web Applications $95k
Applications Engineeer $101k
Applications Integration $106k
Applications Admin $137k
Enterprise Applications $149k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
| Rating | Not enough ratings |
|---|---|
| Length | 2h 7m |
| Starts | On Demand (Start anytime) |
| Cost | $29/month (Access to entire library- free trial available) |
| From | LinkedIn Learning |
| Instructor | Dan Sullivan |
| Download Videos | Only via the LinkedIn Learning mobile app |
| Language | English |
| Subjects | Data Science |
| Tags | SQL Database Development Application Development |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course
