From the course: Advanced SQL: Logical Query Processing, Part 1
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Presentation ordering in multitier architecture - SQL Tutorial
From the course: Advanced SQL: Logical Query Processing, Part 1
Presentation ordering in multitier architecture
- [Instructor] The final processing phases of the query deal with presentation ordering and the ability to limit the size of the result set. Before we dive into the specifics of order processing, I would like to spend a few minutes on why I believe that in most cases it doesn't make sense to perform ordering in the database at all. In a multi-tier application the responsibilities of the entire application stack are physically and logically separated, with each tier having well defined responsibilities and boundaries. Communication between tiers are performed over well defined APIs. The data tier consists of the persistence mechanisms and the data access layer. The application tier processes data to and from the presentation tier, perform logic transformations, and enforces business roles. The presentation tier is what the users see and interact with. This separation of duties is critical for avoiding evil dependencies…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.