Inhaltsangabe
SQL (structured query language) is rapidly emerging as a database language standard, and a practical guide to its use is a must for database programmers. Learn Microsoft SQL Server 7.0 begins with the SQL basics and thoroughly highlights the fundamentals, including database creation, query techniques, and data warehousing. An appendix provides a reference guide to the syntax of the Transact-SQL language. The companion CD-ROM contains the 120-day Evaluation Edition of Microsoft SQL Server 7.0, along with the database used in the chapter exercises. * Create databases, tables, indexes, views, stored procedures, triggers, and database diagrams. * Run queries directly in the database with the Query Analyzer. * Duplicate and distribute data through merge and transactional replications. * Create data warehouses using the OLAP Manager, and learn about the features of this tool. * Transform data using Data Transformation Services. * Learn proper backup and restoration procedures. * Use the reference guide to learn Transact-SQL syntax. * Practice the concepts in the book using the Evaluation Edition of Microsoft SQL Server 7.0 included on the companion CD-ROM.
Reseña del editor
The guide to structured query language (SQL) for database programmers introduces the software's main resources as well as database creation, query techniques, and data warehousing. A 240- page appendix serves as a reference guide to the syntax of the Transact-SQL language. The CD-ROM contains an evaluation edition of SQL Server 7.0, along with the database used in the chapter exercises. Annotation c. Book News, Inc., Portland, OR (booknews.com)
„Über diesen Titel“ kann sich auf eine andere Ausgabe dieses Titels beziehen.