MOMENTAN AUSVERKAUFT
Über dieses Produkt
Product Identifiers
PublisherO'reilly Media, Incorporated
ISBN-100596520832
ISBN-139780596520830
eBay Product ID (ePID)71650114
Product Key Features
Number of Pages336 Pages
Publication NameLearning Sql : Master Sql Fundamentals
LanguageEnglish
SubjectData Modeling & Design, Programming Languages / Sql, General, Databases / Data Mining, Databases / General
Publication Year2009
TypeTextbook
Subject AreaComputers
AuthorAlan Beaulieu
FormatTrade Paperback
Dimensions
Item Height0.9 in
Item Weight15.4 Oz
Item Length9.2 in
Item Width7 in
Additional Product Features
Edition Number2
Intended AudienceScholarly & Professional
Dewey Edition22
IllustratedYes
Dewey Decimal005.756
Edition DescriptionAnnotated edition
Table Of ContentPreface Chapter 1: A Little Background Chapter 2: Creating and Populating a Database Chapter 3: Query Primer Chapter 4: Filtering Chapter 5: Querying Multiple Tables Chapter 6: Working with Sets Chapter 7: Data Generation, Conversion, and Manipulation Chapter 8: Grouping and Aggregates Chapter 9: Subqueries Chapter 10: Joins Revisited Chapter 11: Conditional Logic Chapter 12: Transactions Chapter 13: Indexes and Constraints Chapter 14: Views Chapter 15: Metadata ER Diagram for Example Database MySQL Extensions to the SQL Language Solutions to Exercises Colophon
SynopsisUpdated 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. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements 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., To get you up to speed with SQL quickly, thisintroductory guide provides hands-on exercises to helpyou learn how to create, manipulate, and retrieveinformation from relational databases. Whether you needto write applications, perform administrative tasks, orgenerate reports, Learning SQL offers a friendly way tomaster all the SQL ......, 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.Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements 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.
LC Classification NumberQA76.73.S67
