| Description |
1 online resource (xxx, 400 pages) : illustrations. |
|
data file rda |
| Series |
Wrox beginning guides |
|
Wrox beginning guides.
|
| Note |
"Wrox programmer to programmer"--Cover. |
| Summary |
Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access, SQL Server, Oracle, and MySQL. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization. Discovering SQL: covers the most important SQL dialects along with the current release of SQL Standard; highlights the differences between particular implementations as well as the power and limitations of SQL; demonstrates how SQL deals with all types of data: structured, unstructured and everything in between; looks at dynamic SQL, procedural extensions and latest developments in the field; shares best practices for optimizing query performance; walks you through the basics of database design and introduces the tools for working with normalized data. |
|
Teaching the SQL skills that businesses demand when hiring programmers If you're a SQL beginner, you don't just want to learn SQL basics, you also want to get some practical SQL skills you can use in the job market. This book gives you both. Covering the basics through intermediate topics with clear explanations, hands-on exercises, and helpful solutions, this book is the perfect introduction to SQL. Topics include both the current SQL:2008 standards, the upcoming SQL:2011 standards, and also how to use SQL against current releases of the most popular commercial SQL databases, such as Oracle. |
| Bibliography |
Includes bibliographical references and index. |
| Contents |
Drowning in data, dying of thirst for knowledge -- Breaking and entering : structured information -- A think you can relate to--designing a relational database -- Overcoming the limitations of SQL -- Grouping and aggregation -- When one is not enough : a query within a query -- You broke it ; you fix it : combining data sets -- What else is there, and why? -- Optimizing performance -- Multiuser environment -- Working with unstructured and semistructured data -- Not by SQL alone -- Installing the library database -- Installing RDBMSs software -- Accessing RDBMSs -- Accessing RDBMSs with the SQuirreL Universal SQL Client. |
| Language |
English. |
| Subject |
SQL (Computer program language)
|
|
Relational databases.
|
|
Database management.
|
|
SQL (Langage de programmation) |
|
Bases de données relationnelles. |
|
Bases de données -- Gestion. |
|
Database management |
|
Relational databases |
|
SQL (Computer program language) |
|
SQL |
|
SQL. |
| Added Author |
Trukhnov, Boris M., editor.
|
| Other Form: |
Print version: Kriegel, Alex. Discovering SQL. Indianapolis, IN : Wiley Pub., ©2011 9781118002674 (OCoLC)671701736 |
| ISBN |
9781118092798 (electronic bk.) |
|
1118092791 (electronic bk.) |
|
9781118092774 (electronic bk.) |
|
1118092775 (electronic bk.) |
|
9781118092781 (electronic bk.) |
|
1118092783 (electronic bk.) |
|
(pbk. ; alk. paper) |
|
(pbk. ; alk. paper) |
|
1283397781 |
|
9781283397780 |
|
9786613397782 |
|
6613397784 |
|
More Resources