Jose Ramalho has 17 years of publishing and consulting experience in the computer industry with more than 68 titles published in Portuguese, English, and Spanish. He is the best-selling computer book author in Brazil and a columnist for the Brazilian newspaper Folha de Sao Paulo. Ramalho's titles for Wordware Publishing include Learn Personal Oracle 8.0 with Power Objects 2.0 (1-55622-546-6), Learn Advanced HTML 4.0 with DHTML (1-55622586-5), and the upcoming Learn SQL (1-55622-661-6).
Microsoft Sql Server 7.0. Companion Cd-Rom Included
Par :Formats :
- Nombre de pages559
- PrésentationBroché
- Poids1.015 kg
- Dimensions19,2 cm × 23,6 cm × 3,0 cm
- ISBN1-55622-639-X
- EAN9781556226397
- Date de parution29/06/1999
- ÉditeurWordware
Résumé
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.