Showing posts with label intermediate. Show all posts
Showing posts with label intermediate. Show all posts

Head First SQL: Your Brain on SQL -- A Learner's Guide Review

Head First SQL: Your Brain on SQL -- A Learner's Guide
Average Reviews:

(More customer reviews)
Are you looking to buy Head First SQL: Your Brain on SQL -- A Learner's Guide? Here is the right place to find the great deals. we can offer discounts of up to 90% on Head First SQL: Your Brain on SQL -- A Learner's Guide. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Head First SQL: Your Brain on SQL -- A Learner's Guide ReviewBefore 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.
Head First SQL: Your Brain on SQL -- A Learner's Guide Overview
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!


Want to learn more information about Head First SQL: Your Brain on SQL -- A Learner's Guide?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Learning Python: Powerful Object-Oriented Programming Review

Learning Python: Powerful Object-Oriented Programming
Average Reviews:

(More customer reviews)
Are you looking to buy Learning Python: Powerful Object-Oriented Programming? Here is the right place to find the great deals. we can offer discounts of up to 90% on Learning Python: Powerful Object-Oriented Programming. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Learning Python: Powerful Object-Oriented Programming ReviewThis book will teach you Python if you have a lot of patience and are willing to wade through many pages of text to get information. The author wastes a lot of ink stating things like "I'll introduce you to topic XYZ, but you will have to wait until a later chapter to go into detail." Or introducing a topic and then declaring it is outside the books (1216 page) scope. Here's an example from page 85:
"Text pattern matching is an advanced tool outside this book's scope, but readers with backgrounds in other scripting languages may be interested to know that to do pattern matching in Python, we import a module called re."
Pattern matching is a critical feature of any scripting language. I was surprised to see such an important topic thrown away.
The book is divided into sections. I've put page counts and a summary description of the content to further describe the glacial pace of the book:
Part 1: Getting Stared: Pages 1- 72
72 pages to tell you how to run a Python program.
Part 2: Types and Operations 73-258
186 pages to introduce Python types (strings, numbers, sequences, etc)
Page 3: Statements and Syntax - 259-392
If statements are not introduced until Part3.
At this point I gave up and started reading the online tutorial.Learning Python: Powerful Object-Oriented Programming Overview
Google and YouTube use Python because it's highly adaptable, easy to maintain, and allows for rapid development. If you want to write high-quality, efficient code that's easily integrated with other languages and tools, this hands-on book will help you be productive with Python quickly -- whether you're new to programming or just new to Python. It's an easy-to-follow self-paced tutorial, based on author and Python expert Mark Lutz's popular training course. Each chapter contains a stand-alone lesson on a key component of the language, and includes a unique Test Your Knowledge section with practical exercises and quizzes, so you can practice new skills and test your understanding as you go. You'll find lots of annotated examples and illustrations to help you get started with Python 3.0.

Learn about Python's major built-in object types, such as numbers, lists, and dictionaries
Create and process objects using Python statements, and learn Python's general syntax model
Structure and reuse code using functions, Python's basic procedural tool
Learn about Python modules: packages of statements, functions, and other tools, organized into larger components
Discover Python's object-oriented programming tool for structuring code
Learn about the exception-handling model, and development tools for writing larger programs
Explore advanced Python tools including decorators, descriptors, metaclasses, and Unicode processing


Want to learn more information about Learning Python: Powerful Object-Oriented Programming?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...

Object-Oriented PHP: Concepts, Techniques, and Code Review

Object-Oriented PHP: Concepts, Techniques, and Code
Average Reviews:

(More customer reviews)
Are you looking to buy Object-Oriented PHP: Concepts, Techniques, and Code? Here is the right place to find the great deals. we can offer discounts of up to 90% on Object-Oriented PHP: Concepts, Techniques, and Code. Check out the link below:

>> Click Here to See Compare Prices and Get the Best Offers

Object-Oriented PHP: Concepts, Techniques, and Code ReviewObject-Oriented PHP is really a technical brief that seems to fall short of its own ambitions. It covers PHP 5, most notably the radical switch from prior versions to a full OOP model. Lavin summarizes the reasons for the changes and reviews basic concepts of OOP. He then develops some classes for an application that draws images from a database and displays thumbnail images. In some places the PHP 4 equivalent code is provided for study. Notes on MySQL and PHP Data Objects (PDO) are also included.
It is a terse and sometimes bumpy ride. The book's conversational tone is appropriate for fellow geeks, but I found it more distracting than reassuring. There are some summary apologies, for example, that make the chapters seem like they were transcribed from tape. Rather than go back and match the introductory objectives to the text, a summary or two admits things didn't quite work out as planned. Ok, let's say there was no time to fix it. How does calling attention to it help?
Because the book is so short, the author glosses many concepts, frequently referring to web sites for technical details and tutorials. Once or twice he refers to a well-known author (e.g., Bruce Eckel) to support a complex point. Again while this is appropriate for a peer audience, it also needlessly puts the book out of reach for some readers.
It seems to me the book once had a too-ambitious outline. The back cover states you'll learn to "Incorporate AJAX into your OO PHP code." The coverage on this topic is trivial: an eight-line paragraph that names a website from which to retrieve example code, followed by indicators in subsequent to show where the AJAX reference is. The reader would be right to feel misled.
This book should be useful to the author's PHP peers, but those same readers should understand OOP well beforehand. I doubt a skeptical or demanding reader will like this book. Beginners will almost certainly get lost early and often.Object-Oriented PHP: Concepts, Techniques, and Code Overview
Object-Oriented PHP shows developers how to take advantage of the new object-oriented features of PHP. Working within the context of concrete examples, the book begins with code compatible with PHP 4 and 5, and then focuses on object-orientation in PHP 5. The author's practical approach uses numerous code examples, which will help developers get up to speed with object oriented PHP quickly, and show them how to apply what they learn to everyday situations. All code samples are available for download on the book's companion site.


Want to learn more information about Object-Oriented PHP: Concepts, Techniques, and Code?

>> Click Here to See All Customer Reviews & Ratings Now
Read More...