Beginning SQL server 2000 programming

Robin Dewson

782 pages, parution le 16/10/2003

Ajouter à une liste

Indisponible

Résumé

Microsoft SQL Server 2000 provides enterprise-class database solutions, offering interactive development tools and complete management of your relational database applications.

Beginning SQL Server 2000 Programming develops an example database, at every point providing clear and practical demonstrations of the relevant ideas. Once you have mastered the basics of SQL Server, this book will take you on to more advanced techniques to enable a firm grasp of the most important features quickly and easily, in order to develop your own effective database solutions right away.

SQL Server 2000 Installation
Managing SQL Server
Query Analyzer
Database Analysis and Design
Creating the Sample Database
Defining Tables
Creating Indexes
Building Relationships
Diagramming the Database
Database Backups and Recovery
Maintaining Your Database
Inserting Data
Retrieving Data
Updating Data and Transactions
Deleting Data
Building a View
Stored Procedures
Advanced Stored Procedures
XML and Data Retrieval
Triggers
Appendix A: Further References
Appendix B: System Functions
Appendix C: Function Listing
Appendix D: Access Upsizing
Appendix E: Security
Appendix F: Glossary of Terms
Appendix G: Support and Errata
Index

L'auteur - Robin Dewson

Robin Dewson - Robin Dewson: Robin has been hooked on programming ever since he bought his first computer in 1980, a Sinclair ZX80. His first main application of his own was a Visual FoxPro application that could be used to run a Fantasy League system. It was at this point he met up with a great help in his PC development life, Jon Silver at Step One Technologies, where in return for training, he helped Jon with some other Visual FoxPro applications. From there, realizing that the market place for Visual FoxPro was limited, he decided to learn Visual Basic and SQL Server. Starting out with SQL Server 6.5, he soon moved to SQL Server 7 and Visual Basic 5 and became involved in developing several applications for clients both in the UK and the US. From there he moved to SQL Server 2000 and Visual Basic 6. Robin currently is consulting at Lehman Brothers in London, where he has been for nearly 5 years, using Visual Basic 6 and Sybase on a trading system called Kojak. Robin is also the author of Beginning SQL Server 2000 Programming.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Robin Dewson
Parution	16/10/2003
Nb. de pages	782
Format	18,3 x 23
Couverture	Broché
Poids	1235g
Intérieur	Noir et Blanc
EAN13	9781590592526
ISBN13	978-1-59059-252-6