- Taschenbuch: 607 Seiten
- Verlag: O'Reilly and Associates; Auflage: 1 (September 2007)
- Sprache: Englisch
- ISBN-10: 0596526849
- ISBN-13: 978-0596526849
- Größe und/oder Gewicht: 20,3 x 3,1 x 23,5 cm
- Durchschnittliche Kundenbewertung: 3 Kundenrezensionen
- Amazon Bestseller-Rang: Nr. 106.341 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
Andere Verkäufer auf Amazon
+ GRATIS Lieferung innerhalb Deutschlands
+ EUR 3,00 Versandkosten
Head First SQL: Your Brain on SQL -- A Learner's Guide (Englisch) Taschenbuch – September 2007
|Neu ab||Gebraucht ab|
Wird oft zusammen gekauft
Kunden, die diesen Artikel gekauft haben, kauften auch
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
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. 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!
Über den Autor und weitere Mitwirkende
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.
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
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.
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!
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.
Die hilfreichsten Kundenrezensionen auf Amazon.com
My biggest complaint is in this book there is a part that they have in the questions area that states you cannot add a forgotten column, this simply isn't true, and they do get to this later on in the book, but don't even hint towards the fact that this is possible. The way they word it makes it seem like that isn't even a possibility.
SQL is not very big as languages go, but there's more than meets the eye to this language. Most importantly, Lynn Beighley takes the time to go through some key table-building concepts such as 'atomic data' and 'normal tables.' Further, she goes into great detail about creating and using relational data bases from setting up FOREIGN keys to using JOINs in data queries. She spends plenty of time with the CREATE statement in different contexts. Most SQL books, act as though you use tools like Visual Studio or MyPHPAdmin for creating tables, and so they do not 'waste time' with the CREATE statement for different types of tables. There's a problem in not visiting and revisiting CREATE when dealing with relational database management systems (RDBMS)--you don't understand the data and data types and hooks quite as well. Also, using CREATE, you can go from one tool to another without having to learn the protocol for each tool in the same or different language context.
Her material on queries and sub-queries is in depth and the examples are sensible for the materials. While it's important to have some fun with the database examples in the HF series, it's also important to have examples that make sense, and hers do both. Likewise, her materials on ALTER are complete and helpful. Through all of these, she provides several SELECT examples and the many clauses (statements) that can be used with SELECT. Her chapter on security is quite good as well for an introduction to SQL capabilities in that area.
I found only a couple of things I'd like to see changed. First, after some introductory INSERT examples, she seems to drop them as relevant further on in the book. Further INSERT examples would be quite helpful in the chapters on ALTER and with multiple tables. The multiple CREATE examples are golden, and if she'd do that with INSERT, it'd be most helpful. Second, at the very end of the book, she includes a 2-minute example of using PHP with MySQL. Yikes; she uses mysql instead of mysqli. Since at least 2004 when PHP 4.1.3 came out, the recommended PHP statement for MySQL work has been mysqli; not mysql -- the 'i' makes a big difference. Among other things, you can use a single statement to handle the connect information--url, username, password AND database name. Further, new terms like SERIAL are available in mysqli. Those two items would knock it down from a 5-star to a 4.5 star review, but I'd round up on this book any day.
My evaluation is 4 stars and not 5 just because the scripts for creation of SQL tables we can download don't cover all the content of the book. In many chapters I had to create the tables and populate them on my own to simulate the tables presented and to test what was explained. I think it would be more productive if it was possible to download scripts to create and populate tables according to the contents of each chapter.