- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Learning SQLby Alan Beaulieu
Synopses & Reviews
Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
Book News Annotation:
This is an introduction to SQL, the database computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. Chapters cover creating and populating a database; queries; filtering; querying multiple tables; working with sets; data generation, conversion, and manipulation; grouping and aggregates; subqueries; table joins; conditional logic; transactions; indexes and constraints; views; and metadata. Examples and exercises use MySQL, which is freely available, although they also run on Oracle Database and SQL Server. Annotation ©2009 Book News, Inc., Portland, OR (booknews.com)
SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. This introductory guide is designed for developers new to the program.
About the Author
Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters and can be reached at firstname.lastname@example.org.
Table of Contents
PrefaceChapter 1: A Little BackgroundChapter 2: Creating and Populating a DatabaseChapter 3: Query PrimerChapter 4: FilteringChapter 5: Querying Multiple TablesChapter 6: Working with SetsChapter 7: Data Generation, Conversion, and ManipulationChapter 8: Grouping and AggregatesChapter 9: SubqueriesChapter 10: Joins RevisitedChapter 11: Conditional LogicChapter 12: TransactionsChapter 13: Indexes and ConstraintsChapter 14: ViewsChapter 15: MetadataER Diagram for Example DatabaseMySQL Extensions to the SQL LanguageSolutions to ExercisesColophon
What Our Readers Are Saying
Other books you might like
Computers and Internet » Computers Reference » General