| |
Beginning SQL Server 2000 Programming is designed for novice database programmers, or people familiar with a desktop solution such as Access, who are interested in learning how to develop solutions with Microsoft SQL Server. Microsoft SQL Server 2000 is the latest and most powerful version of a product that provides enterpriseclass 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 straight away. Included with this book is a 120day Enterprise Evaluation edition of Microsoft SQL Server 2000. An end user license agreement is contained in this licensed software. This book covers: Choosing and installing the correct version of SQL Server 2000The important tools used as an interface to SQL Server 2000Basics of relational database designBuilding the sample database for the bookCreating and deleting databases, tables, relationships, and indexes with the interactive tools of SQL Server, and through the TransactSQL language Maintaining, inserting, retrieving, and updating dataManaging transactions to safeguard data modificationsUsing stored procedures to control the flow of execution of SQL statementsUsing XML to retrieve data from SQL Server and publish this data to the InternetCreating triggers to ensure data integrityIncludes 120Day Enterprise Evaluation Edition of Microsoft SQL Server 2000.
|
| |
|