The complete idiot's guide to SQL
(2011)

Nonfiction

Book

Call Numbers:
005.7565/SQL/HOLZNER,S

0 Holds on 1 Copy

Availability

Locations Call Number Status
Adult Nonfiction 005.7565/SQL/HOLZNER,S Due: 4/25/2024

Details

PUBLISHED
New York : Alpha Books, [2011]
©2011
DESCRIPTION

xiv, 282 pages ; 23 cm

ISBN/ISSN
9781615641093 (pbk.), 1615641092 (pbk.)
LANGUAGE
English
NOTES

"Provides the syntax for all of the DBMSes including MySQL, Oracle, Microsoft SQL Server, and PostgreSQL" -- Cover

Mastering the SQL basics. Getting into SQL ; Storing data in tables ; Retrieving your data -- Crunching your data. Sorting your data ; Filtering your data ; Getting more filtering power ; Updating your data ; SQL's built-in functions -- In-depth data handling. Joining tables ; Aggregating and grouping data ; Views, unions, and variables -- Power techniques. Stored procedures and cursors ; Using transactions ; Understanding constraints and triggers ; Advanced SQL topics ; Creating and administering user accounts in SQL

This helpful guide give you practical information you can apply to your specific relational database management system

Includes index

Additional Titles