Advanced SQL for Application Development | Lynda


Advanced SQL for Application Development | Lynda
English | Size: 243.42 MB
Genre: eLearning

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.
Topics include:
Creating tables and loading data
Parameterizing SELECT statements
Indexing tables
Object relational mapping
Partitioning
Error trapping
Monitoring and logging
Automated schema migration

nitroflare.com/view/7F47C035AF83883/LD.Advanced.SQL.for.Application.Development.1.6.part1.rar
nitroflare.com/view/AD54630C31DDB92/LD.Advanced.SQL.for.Application.Development.1.6.part2.rar

rapidgator.net/file/e6c168c6f17a1b99814eae5a3d8dc942/LD.Advanced.SQL.for.Application.Development.1.6.part1.rar.html
rapidgator.net/file/95d589bb7092fb8849fcf3a99ef23715/LD.Advanced.SQL.for.Application.Development.1.6.part2.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.