Lynn Beighley

Head First SQL (eBook, PDF)

Your Brain on SQL -- A Learner's Guide

• Format: PDF

Produktbeschreibung

Is your data dragging you down? Are your tables all tangled up? Well we've got the tools to teach you just how to wrangle your databases into submission. Using the latest research in neurobiology, cognitive science, and learning theory to craft a multi-sensory SQL learning experience, Head First SQL has a visually rich format designed for the way your brain works, not a text-heavy approach that puts you to sleep.Maybe you've written some simple SQL queries to interact with databases. But now you want more, you want to really dig into those databases and work with your data. Head First SQL will show you the fundamentals of SQL and how to really take advantage of it. We'll take you on a journey through the language, from basic INSERT statements and SELECT queries to hardcore database manipulation with indices, joins, and transactions. We all know "e;Data is Power"e; - but we'll show you how to have "e;Power over your Data"e;. Expect to have fun, expect to learn, and expect to be querying, normalizing, and joining your data like a pro by the time you're finished reading!

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: O'Reilly Media
• Seitenzahl: 607
• Erscheinungstermin: 28. August 2007
• Englisch
• ISBN-13: 9780596800857
• Artikelnr.: 53007080

Autorenporträt

Lynn Beighley is a fiction writer stuck in a technical book writer's body. Upon discovering that technical book writing actually paid real money, she learned to accept and enjoy it. After going back to school to get a Masters in Computer Science, she worked for the acronyms NRL and LANL. Then she discovered Flash, and wrote her first bestseller. A victim of bad timing, she moved to Silicon Valley just before the great crash. She spent several years working for Yahoo! and writing other books and training courses. Finally giving in to her creative writing bent, she moved to the New York area to get an MFA in Creative Writing. Her Head First-style thesis was delivered to a packed room of professors and fellow students. It was extremely well received, and she finished her degree, finished Head First SQL, and can't wait to begin her next book. Lynn loves traveling, cooking, and making up elaborate background stories about complete strangers. She's a little scared of clowns.

Inhaltsangabe

*
* Advance Praise for Head First SQL
* Praise for other Head First books
* Praise for the Head First Approach
* Author of Head First SQL
* How to use this Book: Intro
* Chapter 1: Data and Tables: A place for everything
* Chapter 2: The SELECT Statement: Gifted data retrieval
* Chapter 3: DELETE and UPDATE: A change will do you good
* Chapter 4: Smart Table Design: Why be normal?
* Chapter 5: Alter: Rewriting the Past
* Chapter 6: Advanced Select: Seeing your data with new eyes
* Chapter 7: Multi-Table Database Design: Outgrowing your table
* Chapter 8: Joins and Multi-Table Operations: Can't we all just get
along?
* Chapter 9: Subqueries: Queries within queries
* Chapter 10: Outer Joins, Self-Joins, and Unions: New maneuvers
* Chapter 11: Constraints, Views, and Transactions: Too many cooks
spoil the database
* Chapter 12: Security: Protecting your assets
* Leftovers: The Top Ten Topics (we didn't cover)
* MySQL Installation: Try it out for yourself
* Tools Roundup: All your new SQL tools
*  

Rezensionen

"Lynn Beighley nimmt den Leser in Head First SQL mit auf eine Reise durch die Welt relationaler Datenbanken. In dieser Welt spricht man SQL, und diese Anfragesprache lernt der Leser auf die bekannte lockere Art und Weise der Reihe. [...] Lynn Beighley ist es gelungen, dieses sonst recht theoretisch und trocken vermittelte Thema interessant und locker, aber dennoch anspruchsvoll zu päsentieren. Alle wesentlichen Konzepte relationaler Datenbanken und Aspekte der damit verbundenen Anfragesprache SQL behandelt sie - sogar diejenigen, die sonst "wehtun" (Stichwort: nicht korrelierte Unterabfragen). Die zahlreichen Codebeispiele lassen sich mit SQL einfach und schnell nachvollziehen." -- iX, Juni 2008