Nonfiction
Book
0 Holds on 1 Copy
Availability
Details
PUBLISHED
©2011
DESCRIPTION
xiv, 282 pages ; 23 cm
ISBN/ISSN
LANGUAGE
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