|
SQL Design Patterns: Expert Guide To SQL Programming
This indispensable SQL reference book is the first of its kind to leverage the benefits of design patterns to relational database SQL queries; all common SQL structures and design patterns are clearly categorized and described. Emphasizing the theoretical foundation for almost every type of SQL query problem, accompanying figures are included to help
visualize the problem. Because SQL is a declarative language there are many ways to write any SQL query and professional database programmers must understand the correct way to write SQL for complicated database queries, and managers must institute formal SQL coding standards to improve productivity and maintainability. The SQL design patterns in this resource greatly improve the quality and productivity of systems development projects by forming a "best practices" foundation for all relational database queries.
Chapter 1 - Introduction to SQL Counting
Chapter 2 - Integer Generators
Chapter 3 - Introduction to SQL exotic operators
Chapter 4 - Introduction to Constraints
Chapter 5 - Introduction to Trees
Chapter 6 - Introduction to Graphs
|
