This is a guide to designing and programming scalable, SQL server databases. The book develops a start to finish process of designing, building and optimizing SQL server 7 databases. It also looks at codes used and the issues of privacy, threats of lawsuits and many other issues.
Reihe
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Höhe: 235 mm
Breite: 188 mm
Gewicht
ISBN-13
978-0-07-212375-3 (9780072123753)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Section 1 Getting started: database design; principles of design; planning the physical design. Section 2 Implementation: implementing the design; building tables. Section 3 Querying the database: data retrieval; joins - combining data from multiple tables; summarizing data and reporting; data modification; subqueries; views. Section 4 Programming for performance: introduction to transactions; locking; data integrity; control of flow languages; indexes; performance and optimization; stored procedures; triggers; distributed data. Section 5 Beyond Transact SQL: T-SQL from other applications; text queries; English query; cursors. Appendices: a recipe for Strawberry Smooches; the Strawberry Smooches entity-relationship diagram.
