SØG - mellem flere end 8 millioner bøger:
Viser: Learning SQL - Master SQL Fundamentals
Learning SQL
Master SQL Fundamentals
Alan Beaulieu
(2009)
Sprog: Engelsk
om ca. 10 hverdage
Detaljer om varen
- Paperback: 338 sider
- Udgiver: O'Reilly Media, Incorporated (Maj 2009)
- ISBN: 9780596520830
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.
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