Learn Sql. Cd-Rom Included

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.