SQL Server 2000 Design and TSQL Programming

Michelle Poolet, Michael Reilly (Autoren)

Buch | Softcover

608 Seiten

2000
Osborne/McGraw-Hill (Verlag)
978-0-07-212375-3 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

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.

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.

Erscheint lt. Verlag	30.11.2000
Reihe/Serie	Database Professional's Library
Zusatzinfo	10 line illustrations
Verlagsort	New York
Sprache	englisch
Maße	188 x 235 mm
Gewicht	1210 g
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Mathematik / Informatik ► Informatik ► Software Entwicklung
	Mathematik / Informatik ► Informatik ► Theorie / Studium
ISBN-10	0-07-212375-3 / 0072123753
ISBN-13	978-0-07-212375-3 / 9780072123753
Zustand	Neuware