Learn Sql. Cd-Rom Included - Couverture souple

Ramalho, José-A

Couverture souple

ISBN 10 : 1556226616 ISBN 13 : 9781556226618

Editeur : Wordware Publishing Inc., 1999

Synopsis

SQL (structured query language) has become the default database language. As its popularity and usage has grown, the leading database companies have expanded their support for SQL. Learn SQL offers a guide to three of the most popular variations of SQL Microsoft's Transact-SQL, Oracle's PL/SQL, and Centura's SQLBase. Database expert José A. Ramalho begins this comprehensive overview of SQL with 15 chapters highlighting the fundamentals of the language. These chapters include the creation of database objects such as tables, indexes, and views, how to use expressions and operators, maintaining and joining tables, and creating queries and subqueries. A reference section contains guides to the syntax of Transact-SQL, Oracle PL/SQL, and SQLBase, along with summaries of the functions, commands, and data types of the SQL language. The companion CD-ROM contains a 60-day trial version of SQLBase from Centura Software Corporation, an evaluation copy of Advantage Database Server 5.5 from Extended Systems; and an example database used in the chapter exercises. With this book: > Create tables, indexes, and views, and learn how to maintain tables. > Explore the SELECT command in detail and expand the command's use with expressions, operators and subqueries. > Create queries and organize your results with the ORDER BY and GROUP BY clauses. > Grant privileges and roles to users to improve database security. > Use the reference guides to learn Transact-SQL, PL/SQL, and SQLBase syntax.

A propos du livre

À propos de l'auteur

About the author: José A. Ramalho has 17 years of publishing and consulting experience in the computer industry with 72 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 Learn Microsoft SQL Server (1-55622-639-X).

Détails de l'édition

• Éditeur: Wordware Publishing Inc.
• Date d'édition: 1999
• Langue: anglais
• ISBN 10: 1556226616
• ISBN 13: 9781556226618
• Reliure: Broché
• Nombre de pages: 681
• Coordonnées du fabricant: non disponible
• Personne responsable: WordUnited GmbH; distribution@wordunited.com; ; Theodorstrasse 105; DUSSELDORF; 40472; Allemagne