An Ihren Kindle oder ein anderes Gerät senden

 
 
 

Kostenlos testen

Jetzt kostenlos reinlesen

An Ihren Kindle oder ein anderes Gerät senden

Der Artikel ist in folgender Variante leider nicht verfügbar
Keine Abbildung vorhanden für
Farbe:
Keine Abbildung vorhanden

 

Head First SQL: Your Brain on SQL -- A Learner's Guide [Kindle Edition]

Lynn Beighley
4.3 von 5 Sternen  Alle Rezensionen anzeigen (3 Kundenrezensionen)

Kindle-Preis: EUR 19,46 Inkl. MwSt. und kostenloser drahtloser Lieferung über Amazon Whispernet

Kostenlose Kindle-Leseanwendung Jeder kann Kindle Bücher lesen  selbst ohne ein Kindle-Gerät  mit der KOSTENFREIEN Kindle App für Smartphones, Tablets und Computer.

Geben Sie Ihre E-Mail-Adresse oder Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Weitere Ausgaben

Amazon-Preis Neu ab Gebraucht ab
Kindle Edition EUR 19,46  
Taschenbuch EUR 31,95  


Produktbeschreibungen

Pressestimmen

"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

Kurzbeschreibung

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 "Data is Power" - but we'll show you how to have "Power over your Data". 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!


Produktinformation

  • Format: Kindle Edition
  • Dateigröße: 22644 KB
  • Seitenzahl der Print-Ausgabe: 610 Seiten
  • Gleichzeitige Verwendung von Geräten: Keine Einschränkung
  • Verlag: O'Reilly Media; Auflage: 1 (15. August 2007)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B009VQ7NIQ
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Word Wise: Nicht aktiviert
  • Durchschnittliche Kundenbewertung: 4.3 von 5 Sternen  Alle Rezensionen anzeigen (3 Kundenrezensionen)
  • Amazon Bestseller-Rang: #233.571 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?

Mehr über den Autor

Lynn Beighley ist eine Romanautorin, die in den Körper einer Fachbuchautorin eingesperrt ist. Langsam beginnt sie, das zu akzeptieren und zu genießen. Eine Rolle könnte dabei spielen, dass sie festgestellt hat, dass man vom Schreiben von Fachbüchern leben kann. Nachdem sie sich wieder auf die Schulbank begeben hatte, um einen Abschluss in Informatik zu machen, arbeitete sie für die Akronyme NRL und LANL. Dann entdeckte sie Flash und schrieb ihren ersten Bestseller.

Ins Silicon Valley zog sie kurz vor dem großen Crash. Schlechtes Timing ... Einige Jahre arbeitete sie für Yahoo!, schrieb weitere Bücher und gab Kurse. Dann gab sie ihrer literarischen Neigung nach und zog in den Raum New York, um einen MFA in Creative Writing zu erwerben. Ihre Von Kopf bis Fuß-artige Abschlussarbeit wurde einem Raum voller Professoren und Kommilitonen vorgestellt und sehr gut aufgenommen. Sie machte ihren Abschluss, beendete SQL von Kopf bis Fuß und kann es kaum erwarten, endlich mit ihrem nächsten Buch zu beginnen.

Lynn reist und kocht gern und amüsiert sich damit, sich komplizierte Geschichten zu den Menschen auszudenken, die ihr auf der Straße begegnen. Vor Clowns fürchtet sie sich.

Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?


Kundenrezensionen

4 Sterne
0
2 Sterne
0
1 Sterne
0
4.3 von 5 Sternen
4.3 von 5 Sternen
Die hilfreichsten Kundenrezensionen
5 von 5 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Ausgezeichnetes Le(h)r(n)buch 23. Dezember 2007
Format:Taschenbuch|Verifizierter Kauf
Eigentlich genügt dieses Buch Anfängern, um SQL zu lernen - ich habe das erste Kapitel im vergangenen Semester mit Gewinn in einem Pool-Kursus (Pflichtkurs) für Betriebliche Informationssysteme eingesetzt, und die meisten der Aufgaben brachten die Studenten deutlich weiter als das, was ich bisher immer gesagt, aber nicht eingeübt hatte. Die sehr kleinschrittige Vorgehensweise ist prima! Weiter ging es in meinem Kurs dann mit Alan Beaulieu's Buch Learning SQL (ebenfalls O'Reilly) - im Unterschied zum letzten Jahr gelang es den Studenten nun ohne größere Schwierigkeiten, sich dem SELECT-Befehl, Filterbedingungen und auch der Behandlung verlinkter Tabellen zu widmen.

Ich bleibe ein treuer Kunde der "Head First" Reihe, und hoffe, dass sich dieser interessante, abwechslungsreiche Lehrstil auch in unsere Bildungsstätten mehr Eingang findet!
War diese Rezension für Sie hilfreich?
1 von 2 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Ein Lehrbuch, das Spass macht! 24. März 2008
Von Fabius
Format:Taschenbuch|Verifizierter Kauf
Mit diesem Buch macht das Lernen einfach Spass! Es ist ein weiterer, würdiger Vertreter der Head First-Reihe. Abwechslungsreich, kleinschrittig, mit vielen Wiederholungen, die aber nicht langweilig werden, wird man an das Thema SQL herangeführt und prägt es sich anhaltend ein.

Ich habe den Stil dieser Reihe lieben gelernt. Dabei war ich bei meinem ersten Kontakt (Java von Kopf bis Fuss) recht skeptisch: das mir wirr erscheinende Outfit des Buches, die unkonventionellen Beispiele,... Aber wer sich auf diesen Stil einlässt, darf Neues lernen und sich dabei vergnügen.
War diese Rezension für Sie hilfreich?
0 von 1 Kunden fanden die folgende Rezension hilfreich
Von Stefan
Format:Taschenbuch|Verifizierter Kauf
Das Buch ist ein guter Einstieg und setzt dazu keine weiteren Vorkenntnisse voraus. Am Anfang geht das Buch meines Erachtens zu langsam vor. Es erklaert lang und breit den Unterschied von "und" und "oder" und einfachen logischen Operationen. Danach geht es dann etwas zuegiger voran. Bei den spaeteren Beispielen fehlen mir Beispieldatenbanken zum Import, anhand derer man die Operationen nachvollziehen kann und weitere Operationen mit Open Source Software, wie z.B. MySQL.
Was nicht im Buch enthalten ist (und auch nicht zu SQL im engeren Sinn gehoert) sind Indexing und Trigger.
Fazit: Nicht so gut wie die "anderen" Head firsts (Design Patterns, Java). Eher zu lang fuer den Inhalt, ueber SQL hinausgehende Themen, die man aber immer in Verbindung mit SQL braucht, fehlen. Daher "nur" drei Sterne.
War diese Rezension für Sie hilfreich?
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
Amazon.com: 4.2 von 5 Sternen  91 Rezensionen
161 von 166 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Head First SQL in the Classroom 24. Dezember 2007
Von Ryan - Veröffentlicht auf Amazon.com
Format:Taschenbuch
Before I talk about Head First SQL, let me tell you about other database books I have used in the classroom. I teach an enterprise databases sequence (DBs I and II) at a tribal college in Montana. On the course evaluations for this sequence, students have a common complaint: "Liked the class. Hated the book.", "The book was painful to read.", "Please get a different book!"

Each year my colleagues and I are on the watch for a better, more engaging database book. We have tried three books over the past five years, but the difference between those books is like the difference between shades of grey. In the classroom, most of my time is spent mediating the daunting abstractness of those books or breaking down huge lumps of difficult technical material written in plodding and pedantic prose. This year a spot of color showed up: Head First SQL!

I discovered Head First SQL too late to use it as the primary text for my Fall quarter DBs class, but I liked it so much, I added it as an optional textbook for the quarter and told my students it would be the main textbook for the Winter quarter. I did so because the energy of the class was waning rapidly, and the book I had originally chosen was not helping. I needed to add some excitement to homework and lectures. Within two days of using Head First SQL, the classroom became a far more engaging environment.

I compiled this list for anyone interested in learning databases and SQL, especially anyone who teaches it.

Eleven Things I like about Head First SQL:

1. The book starts where my students start. The first questions my students have are questions of relevance: Why do I want to know this? What have I done before that's like this? What will this material add to my career and my life? Head First SQL starts by ushering the student through those questions: What is a database? Who cares about databases? What will a database do for me?

2. My students are able to read SQL, think SQL, and write SQL after the first chapter. Head First SQL starts students on the command-line, the same command-line professional database administrators use during 80-95% of their workday. My students start out with good command-line habits like using a DESCRIBE statement to view database structure and columns before writing a SELECT statement that references those columns.

3. The book invites my students to make mistakes and anticipates the most common mistakes I see students make. On quizzes, students who've dug into the book don't make those mistakes again.

4. The book's sequence of topics fits the way I teach and the way my students learn: queries come before design and theory. Head First SQL does not set out to be a comprehensive database design book, but it does an excellent job of immersing the learner in the critical thinking that goes into database design and table design strategy. I applaud Lynn Beighley and the Head First Team. They have laid an excellent foundation for the learner to smoothly transition into abstract database design concepts such as normalization, primary and foreign keys, entity-relationship diagrams (ERDs), and E.F. Codd's 12 principles of relational design.

5. Students don't read the book. They work the book. They play the book. They do the book.

6. Like Socrates, Head First SQL pushes my class and I to ask deeper questions about data, information, table design, normalization. Three different times during fall quarter, we had substantive arguments about which data types to use for certain columns. To hear my students using critical thinking and applying it to table design strategy is rewarding.

7. Like a guide, an outfitter, a trusted companion, HF SQL walks beside the student. The books I have used before talk down to students, talk over their heads, or just plain pontificate.

8. Theater in a database classroom? Yes. My students and I act out things like "Confessions of a NULL" -- fun, mysterious, memorable -- a great way to turn an abstract concept into a concrete and palpable one.

9. At conferences, committee meetings, training seminars, my colleagues and I talk about student engagement and the new "three Rs": rigor, relationships, and relevance. Using Head First SQL in my classroom changed my class noticeably, and I attribute that change to Head First's focus on those three Rs. My students started showing up early for class, spent more time in the lab outside of class, and performed far better on quizzes.

10. My quizzes and tests consist of sample tables and data. The open-ended questions on those tests ask students to write SQL to solve problems--a daunting task but the best way to assess whether students really "get" the concepts. In the past, students scores have ranged from 10% to 87%. A score of 92% was rare. A score of 95% almost unattainable. With Head First SQL, that range increased to between 70% and 98%. If that's not proof of Head First SQL's effectiveness, I don't know what is.

11. You will laugh your [body part here] off! And be warned: no matter what body part you substitute into the brackets, you will laugh several other body parts off as well.

I highly recommend this book to anyone teaching or learning SQL, relational database design, or MySQL.
44 von 45 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Perfect for getting started or reviewing forgotten/fuzzy concepts... 25. November 2007
Von Thomas Duff - Veröffentlicht auf Amazon.com
Format:Taschenbuch
I haven't met a Head First/Head Rush title I didn't like, and this one is no exception... Head First SQL: Your Brain on SQL -- A Learner's Guide by Lynn Beighley. It's perfect for someone diving into the world of relational databases for the first time, as well as those who don't do it often enough to feel comfortable with things like normalized forms and outer joins. And along the way, you'll have plenty of fun picking up the skills you lack/need to reinforce.

Contents:
Intro; Data and Tables - A Place for Everything; The SELECT Statement - Gifted Data Retrieval; DELETE and UPDATE - A Change Will Do You Good; Smart Table Design - Why Be Normal?; ALTER - Rewriting the Past; Advanced SELECT - Seeing Your Data With New Eyes; Multi-table Database Design - Outgrowing Your Table; Joins and Multi-table Operations - Can't We All Just Get Along?; Subqueries - Queries Within Queries; Outer Joins, Self Joins, and Unions - New Maneuvers; Constraints, Views, and Transactions - Too Many Cooks Spoil The Database; Security - Protecting Your Assets; The Top Ten Topics (We Didn't Cover); Try It Out For Yourself; All Your New SQL Tools

As with all Head First titles, Head First SQL sets out to engage all your senses during the learning process. Unusual diagrams, questions, exercises, and off-beat pictures are just some of the ways that the author works to grab your attention and force you down the path of learning (whether it feels like you're going down that path or not). The mixture of these techniques means that your mind doesn't really have a chance to drift off and start thinking about what you're going to have for dinner. It's this style that makes the Head First series the first one I'll recommend to people setting out to learn a new skill.

For those who are wondering, Head First SQL uses the free MySQL package for all the examples and exercises. It's not necessary to have some expensive relational database system already installed on your PC. So even if your SQL learning efforts are self-funded, the total outlay will pretty much be the cost of the book, and that's it. And given that SQL is a standard query language, much of what you learn will also transfer over to any other relational database system you end up using down the road, like Oracle or DB2.

Since I've done some SQL in the past, I found most of the value for myself located in the later chapters. Working with subqueries and more complex joins aren't things I do on a regular basis, so it's easy for me to forget the concepts. But a quick flip here, and it all starts coming back, much clearer than before.

There's a reason I rarely loan out my Head First titles... they often don't come back. This will be added to that lock-and-key section of my bookshelf that requires DNA samples before they leave the premises. :)
70 von 75 Kunden fanden die folgende Rezension hilfreich
3.0 von 5 Sternen Could have used a few more months in development... 13. November 2007
Von John Salerno - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
My first Head First book was Head First HTML with CSS & XHTML, and it was absolutely wonderful. Given that, I had very high hopes for Head First SQL as well, but I'm sad to say this book is very disappointing.

I have two main complaints: the explanations in the book, and the typos. First off, I already studied a little SQL on my own a few months ago, mainly using websites and online tutorials. It's a fairly easy language to learn so I got pretty deep into it. I think it is for that reason only that I am able to follow along so well in Head First SQL. What I mean is, it seems to me that very little explanation is actually going on in the book. I understand the Head First method of teaching, but that doesn't have to preclude *any* kind of explanation at all.

For the most part, the chapters in this book describe a bunch of different situations (Greg and his list of contacts, clowns traveling around town, donuts at different shops, etc.) and through these examples we are given a bunch of SQL queries. The problem is that only once or twice does the author actually stop to say "Ok, here is the structure of the SQL query we will use"...instead, she just throws a bunch of queries at us and I feel like I would be very lost if I hadn't already studied SQL a little bit previously.

Instead of saying something like "You type the SELECT keyword, followed by your table name, followed by....." she just gives us the statement fully written. The problem I see with this is that it doesn't teach us how to construct our own. Our only real option is to pattern our own queries based on this single example she gives, rather than to know how to compose our queries from the ground up. (Sort of the whole teach a man to fish metaphor.)

And as I mentioned, there are a ton of different examples she uses (contacts, clowns, donuts, movies, girl scouts, etc. etc.) that there is no consistency between the examples. Very early on we are encouraged to enter a bunch of data into our own SQL database on our computer, and you figure, Ok, we'll use this throughout the book to run tests on it. Nope, you'll hardly see this table again for a long time, so don't bother. What I liked about the HTML book was that the authors carried a project all the way through the book. Head First SQL does not have that consistency.

Finally, the typos in this book are atrocious. There are a lot of little typos in grammar, which are annoying and unprofessional, but forgivable because we all know well enough what was meant (e.g. "then then you type"...well, we all know that one of those "then"s isn't meant to be there). But what is worse and less forgivable are all the technical typos that actually make the examples and crossword puzzles wrong and non-workable. This is ridiculous.

There is a "thank you" in the beginning of the book that says without a certain editor's help, the book would have come out in 2008. After reading most of this book already, I truly believe it still wasn't ready to come and could have used a lot more proofreading. If I spot these errors just by my casual reading, then why can't the author and editors, whose job it is?

Something tells me that this book was rushed to be released in 2007, and it shows in the quality.
34 von 36 Kunden fanden die folgende Rezension hilfreich
5.0 von 5 Sternen Any book on SQL whose style and content makes it possible for me to read and reread it in the last 24 hours deserves 5 Stars. 7. September 2007
Von Charles Harvey - Veröffentlicht auf Amazon.com
Format:Taschenbuch
As a beginning/intermediate Ruby/Rails programmer I have been waiting for this book to fill in that big SQL hole in my knowledge base.

Even though Rails abstracts much of the underlying SQL code through its ORM, Head First SQL answers many questions I had about SQL in an entertaining way.

Before this book my SQL knowledge could be summed up in two lines.
mysqladmin -uroot create abc_development
and
localhost/phpmyadmin

During a 24 hour marathon session with lots of Red Bull and Coffee the book has switched on the big SQL light in my head now.

For this Ruby/Rails programmer chapter 7 on Multi-Table Database Design, and chapter 12 on Security was worth the price of admission alone.

The Author's implementation of the Head First style is entertaining enough to actually make Head First SQL an enjoyable thing to study rather than sitting on my shelf with the other 3 SQL books that I was hoping to learn through osmosis as they can be a bit dry.

Any book on SQL whose style and content makes it possible for me to read and reread in the last 24 hours deserves 5 Stars.
32 von 36 Kunden fanden die folgende Rezension hilfreich
4.0 von 5 Sternen title should be Head First MySql, not Head First SQL 29. November 2007
Von Robert D. Glover Jr. - Veröffentlicht auf Amazon.com
Format:Taschenbuch|Verifizierter Kauf
Probably the publisher changed the name after the book was written but before publication in order to reach a wider audience.

Still, I'm glad I bought "HeadFirst SQL" because it has allowed me to better understand outer joins, inner joins, natural joins, intersect, union, sub-selects, views, etc.

The book does not explain any of the differences between MySql and other databases such as Oracle, when it comes to generating keys for "inserts", using "create" statements, the syntax of the "alter" statement, the ability to use a "check" constraint, granting and revoking security, etc. Only MySql version 5 syntax is taught, and it is taught in very great detail.

As a developer who uses Oracle 10g, I found the first half of this book was barely worth skimming. Much of it is specific to MySql and would generate syntax errors if applied to an Oracle database. The 2nd half of the book however is worth reading carefully and even re-reading; it's fun to read and imparts a great deal of valuable information about the things I mentioned in the first paragraph.

In summary, the book is worth the money for people who already know a little SQL but want to understand much better how to write DML (data manipulation language). It is not helpful for non-MySql programmers who want to learn DDL (Data Definition Language)..

Post Script-- The single biggest improvement I would suggest for not only this book but all "Head First..." books is to add page numbers where related information can be found. It is very frustrating, for example, to try to do the quiz on page 463 on writing a specific SQL query-- the book does not show on page 463 what page to flip back to in order to see the actual table definitions-- it could be thirty, forty pages back or it could be a hundred pages back, there is no way of knowing.
Waren diese Rezensionen hilfreich?   Wir wollen von Ihnen hören.
Kundenrezensionen suchen
Nur in den Rezensionen zu diesem Produkt suchen

Kunden diskutieren

Das Forum zu diesem Produkt
Diskussion Antworten Jüngster Beitrag
Noch keine Diskussionen

Fragen stellen, Meinungen austauschen, Einblicke gewinnen
Neue Diskussion starten
Thema:
Erster Beitrag:
Eingabe des Log-ins
 

Kundendiskussionen durchsuchen
Alle Amazon-Diskussionen durchsuchen
   


Ähnliche Artikel finden