Sumário Itens Encontrados: 60Introduction and Intended AudienceA story about table aliases, a vision about an inferior skill, how to drink wine mixed with water in France!Writing correctly is critical for the quality of our softwareA basic terminologyAll types of software developers!The same styles of development were used for many years in the user interface and in the database!The application developer â the main target of this bookDatabase developers and students in IT universities are especially targeted tooThe two sections of the bookChapter 1 The concept of styleThe style of development is dynamic. We need to recognize it first!The most common styles of programmingThe database development starts with the table designDo we already start the development?Are we ready for SQL?Chapter 2 SQL - the beauty and the beast!How can a query language be so important for a style of development?What is SQL? What is not SQL?What about programming? Is there such a thing like database programming?Programming is a practical activity!Should we write in the database in a certain way?The SQL shop metaphor!An example of bad practice!Chapter 3 The holistic vision against the dataThe concept of data setThe holistic approach versus the atomic approach â an introductionA different model âdoes this model deserve to be promoted indeed?Performance and portability - two advantages for the holistic approach.Visual development versus SQL developmentChapter 4 What to choose: the data set or the data row?Choosing the level of detail: the set versus the row!Performance is poor. Performance completely blocked in any tentative of improvement.Database programming means query, query and query all the time!Letâs go back to the SQL shop! One more time, please!The use of scalar functions âa typical accessory for the atomic approach!Debugging is so simple! The code is much simpler and readable!What is a database developer nowadays?Itâs practice time!Chapter 5 Data transfer paradigm, the first set of examplesThe exercises, the context, the goals, ways to illustrate the two approaches!Holistic versus atomic: incrementally update a targetChapter 6 Others atomic features used in excessThe use of scalar functions â a challenge to the set-based approachA simple query!Chapter 7 Writing SQL versus writing procedurally, other holistic methodsWriting SQL versus writing procedurally, another impediment!An example of update!Writing SQL versus writing procedurally: the power of union in the holistic approach!Embedded SQL versus dynamic SQL â another dilemma!Others holistic solutions: the temporary table, explicit or implicit like with a clauseChapter 8 Row triggers. When should we follow the atomic way? Some final reflections and thoughts!The use of row triggers: another common atomic solution used in excessThe atomic approach should be used, whenever is necessary!Some final reflections and thoughtsThe concept of SQL templateWriting horizontally or vertically: a decision to be taken!The specific software application should be implemented holisticallyThe SQL itself can be better and better!Performance, oh performance! This book is for you!A specific data migration software application can be written in pure SQL more often than you expect!