How we did it:
For any feedback, any questions, any notes or just for chat - feel free to follow us on social networks
Expert advice for smarties is offered from the #1 SQL guru. Trees and hierarchies are topics that all SQL users need to know, and this is the first developer's guide that addresses these concepts that are universally difficult for programmers to master. The book is Web-enhanced with downloadable SQL code, ready to use.
Adam Freeman, Steven Sanderson
The ASP.NET MVC 3 Framework is the latest evolution of Microsoft’s ASP.NET web platform. It provides a high-productivity programming model that promotes cleaner code architecture, test-driven development, and powerful extensibility, combined with all the benefits of ASP.NET 4. In this third edition, the core model-view-controller (MVC) architectural concepts are not simply explained or discussed in isolation, but are demonstrated in action. You’ll work through an extended tutorial to create a working e-commerce web application that combines ASP.NET MVC with the latest C# language features and unit-testing best practices. By gaining this invaluable, practical experience, you’ll discover MVC’s strengths and weaknesses for yourself—and put your best-learned theory into practice. The book's authors Steve Sanderson and Adam Freeman have both watched the growth of ASP.NET MVC since its first release. Steve is a well-known blogger on the MVC Framework and a member of the Microsoft Web Platform and Tools team. Adam started designing and building web applications 15 years ago and has been responsible for some of the world's largest and most ambitious projects. You can be sure you are in safe hands. What you’ll learn Gain a solid architectural understanding of ASP.NET MVC 3, including basic MVC Explore the entire ASP.NET MVC Framework See how MVC and test-driven development work in action Capitalize on your existing knowledge quickly and easily through comparison of features in classic ASP.NET to those in ASP.NET MVC Learn about the latest security and deployment issues, including those related to IIS 7 Who this book is for This book is for web developers with a basic knowledge of ASP.NET and C# who want (or need) to start using the new ASP.NET MVC 3 Framework. Table of ContentsPart 1 1. The Big Idea 2. Getting Ready 3. Your First MVC Application 4. The MVC Pattern 5. Essential Language Features 6. Essential Tools for MVC 7. SportsStore I – A Real Application 8. SportsStore II – Navigation & Cart 9. SportsStore III - Administration Part 2 10. Overview of MVC projects 11. URLs, Routing & Areas 12. Controllers & Actions 13. Filters 14. Controller Extensibility 15. Views 16. Model Templates 17. Model Binding 18. Model Validation 19. Unobtrusive Ajax 20. jQuery Part 3. 21. Security 22. Authentication & Authorization 23. Deployment
Michael James Hernandez
“This book takes the somewhat daunting process of database design and breaks it into completely manageable and understandable components. Mike’s approach whilst simple is completely professional, and I can recommend this book to any novice database designer.” –Sandra Barker, Lecturer, University of South Australia, Australia “Databases are a critical infrastructure technology for information systems and today’s business. Mike Hernandez has written a literate explanation of database technology–a topic that is intricate and often obscure. If you design databases yourself, this book will educate you about pitfalls and show you what to do. If you purchase products that use a database, the book explains the technology so that you can understand what the vendor is doing and assess their products better.” –Michael Blaha, consultant and trainer, author of A Manager’s Guide to Database Technology “If you told me that Mike Hernandez could improve on the first edition of Database Design for Mere Mortals I wouldn’t have believed you, but he did! The second edition is packed with more real-world examples, detailed explanations, and even includes database-design tools on the CD-ROM! This is a must-read for anyone who is even remotely interested in relational database design, from the individual who is called upon occasionally to create a useful tool at work, to the seasoned professional who wants to brush up on the fundamentals. Simply put, if you want to do it right, read this book!” –Matt Greer, Process Control Development, The Dow Chemical Company “Mike’s approach to database design is totally common-sense based, yet he’s adhered to all the rules of good relational database design. I use Mike’s books in my starter database-design class, and I recommend his books to anyone who’s interested in learning how to design databases or how to write SQL queries.” –Michelle Poolet, President, MVDS, Inc. “Slapping together sophisticated applications with poorly designed data will hurt you just as much now as when Mike wrote his first edition, perhaps even more. Whether you’re just getting started developing with data or are a seasoned pro; whether you've read Mike’s previous book or this is your first; whether you're happier letting someone else design your data or you love doing it yourself–this is the book for you. Mike’s ability to explain these concepts in a way that’s not only clear, but fun, continues to amaze me.” –From the Foreword by Ken Getz, MCW Technologies, coauthor ASP.NET Developer's JumpStart “The first edition of Mike Hernandez’s book Database Design for Mere Mortals was one of the few books that survived the cut when I moved my office to smaller quarters. The second edition expands and improves on the original in so many ways. It is not only a good, clear read, but contains a remarkable quantity of clear, concise thinking on a very complex subject. It’s a must for anyone interested in the subject of database design.” –Malcolm C. Rubel, Performance Dynamics Associates “Mike’s excellent guide to relational database design deserves a second edition. His book is an essential tool for fledgling Microsoft Access and other desktop database developers, as well as for client/server pros. I recommend it highly to all my readers.” –Roger Jennings, author of Special Edition Using Access 2002 “There are no silver bullets! Database technology has advanced dramatically, the newest crop of database servers perform operations faster than anyone could have imagined six years ago, but none of these technological advances will help fix a bad database design, or capture data that you forgot to include! Database Design for Mere Mortals™, Second Edition, helps you design your database right in the first place!” –Matt Nunn, Product Manager, SQL Server, Microsoft Corporation “When my brother started his professional career as a developer, I gave him Mike’s book to help him understand database concepts and make real-world application of database technology. When I need a refresher on the finer points of database design, this is the book I pick up. I do not think that there is a better testimony to the value of a book than that it gets used. For this reason I have wholeheartedly recommended to my peers and students that they utilize this book in their day-to-day development tasks.” –Chris Kunicki, Senior Consultant, OfficeZealot.com “Mike has always had an incredible knack for taking the most complex topics, breaking them down, and explaining them so that anyone can ‘get it.’ He has honed and polished his first very, very good edition and made it even better. If you're just starting out building database applications, this book is a must-read cover to cover. Expert designers will find Mike’s approach fresh and enlightening and a source of great material for training others.” –John Viescas, President, Viescas Consulting, Inc., author of Running Microsoft Access 2000 and coauthor of SQL Queries for Mere Mortals “Whether you need to learn about relational database design in general, design a relational database, understand relational database terminology, or learn best practices for implementing a relational database, Database Design for Mere Mortals™, Second Edition, is an indispensable book that you’ll refer to often. With his many years of real-world experience designing relational databases, Michael shows you how to analyze and improve existing databases, implement keys, define table relationships and business rules, and create data views, resulting in data integrity, uniform access to data, and reduced data-entry errors.” –Paul Cornell, Site Editor, MSDN Office Developer Center Sound database design can save hours of development time and ensure functionality and reliability. Database Design for Mere Mortals™, Second Edition, is a straightforward, platform-independent tutorial on the basic principles of relational database design. It provides a commonsense design methodology for developing databases that work. Database design expert Michael J. Hernandez has expanded his best-selling first edition, maintaining its hands-on approach and accessibility while updating its coverage and including even more examples and illustrations. This edition features a CD-ROM that includes diagrams of sample databases, as well as design guidelines, documentation forms, and examples of the database design process. This book will give you the knowledge and tools you need to create efficient and effective relational databases.
Rida Al Barazi, Cloves Carneiro Jr., Cloves Carneiro
Beginning Rails 3 is the practical starting point for anyone wanting to learn how to build dynamic web applications using the Rails framework for Ruby. You'll learn how all of the components of Rails fit together and how you can leverage them to create sophisticated web applications with less code and more joy. This book is particularly well suited to those with little or no experience with web application development, or who have some experience but are new to Rails. Beginning Rails 3 assumes basic familiarity with web terms and technologies, but doesn't require you to be an expert. Rather than delving into the arcane details of Rails, the focus is on the aspects of the framework that will become your pick, shovel, and axe. Part history lesson, part introduction to object-oriented programming, and part dissertation on open source software, this title doesn't just explain how to do something in Rails, it explains why. Learn to create Rails web applications from scratch Includes a gentle introduction to the Ruby programming language Completely updated to include the features of Rails 3 What you’ll learn Rails 3 includes the combined power of Rails and Merb. Beginning Rails 3 will get you started in learning this technology and creating dynamic web applications in next to no time. Install Rails on a Mac, Windows, or Linux system Understand the Model-View-Controller architecture Learn the value of databases and how to set up MySQL in Rails Get instant feedback on your work by testing in the Rails Console Add Ajax and visual effects to create rich user interfaces Use and create your own Rails plug-ins Who this book is for Web developers who want to harness the power of Rails 3 to quickly build dynamic rich Internet applications. Anyone who hasn't used Rails before will be able to learn the basics from this book. Table of Contents Introducing the Rails Framework Getting Started Getting Something Running Working with a Database: Active Record Advanced Active Record: Enhancing Your Models Action Pack: Working with the View and the Controller Advanced Action Pack Improving Interaction with Ajax Sending and Receiving E-Mail Testing Your Application Internationalization Extending Rails with Plug-ins Deploying Your Rails Applications Ruby, a Programmer’s Best Friend Databases 101 The Rails Community Git
Build a Django content management system, blog, and social networking site with James Bennett as he introduces version 1.1 of the popular Django framework. You’ll work through the development of each project, implementing and running the applications while learning new features along the way. Web frameworks are playing a major role in the creation of today’s most compelling web applications, because they automate many of the tedious tasks, allowing developers to instead focus on providing users with creative and powerful features. Python developers have been particularly fortunate in this area, having been able to take advantage of Django, a very popular open-source web framework whose stated goal is to "make it easier to build better web applications more quickly with less code." Practical Django Projects introduces this popular framework by way of a series of real–world projects. Readers follow along with the development of each project, implementing and running each application while learning new features along the way. This edition is updated for Django 1.1 and includes an all-new chapter covering practical development tools and techniques you'll be able to apply to your own development workflow. What you’ll learn Capitalize upon the well–defined and stable framework architecture of Django 1.1 to build web applications faster than ever before Learn by doing by working through the creation of three real–world projects, including a content management system, blog, and social networking site Build user–friendly web sites with well–structured URLs, session tracking, and syndication options Let Django handle tedious tasks such as database interaction while you focus on building compelling applications Who this book is for Web developers seeking to use the powerful Django framework to build powerful web sites. Table of Contents Welcome to Django Your First Django Site: A Simple CMS Customizing the Simple CMS A Django-Powered Weblog Expanding the Weblog Templates for the Weblog Finishing the Weblog A Social Code-Sharing Site Form Processing in the Code-Sharing Application Finishing the Code-Sharing Applications Practical Development Techniques Writing Reusable Django Applications
Adrian Holovaty, Jacob Kaplan-Moss
This latest edition of The Definitive Guide to Django is updated for Django 1.1, and, with the forward–compatibility guarantee that Django now provides, should serve as the ultimate tutorial and reference for this popular framework for years to come. Django, the Python–based equivalent to Ruby’s Rails web development framework, is one of the hottest topics in web development today. Lead developer Jacob Kaplan–Moss and Django creator Adrian Holovaty show you how they use this framework to create award–winning web sites by guiding you through the creation of a web application reminiscent of ChicagoCrime.org. The Definitive Guide to Django is broken into three parts, with the first introducing Django fundamentals such as installation and configuration, and creating the components that together power a Django–driven web site. The second part delves into the more sophisticated features of Django, including outputting non–HTML content such as RSS feeds and PDFs, caching, and user management. The appendixes serve as a detailed reference to Django’s many configuration options and commands. What you’ll learn The first half of this book explains in depth how to build web applications using Django including the basics of dynamic web pages, the Django templating system interacting with databases, and web forms. The second half of this book discusses higher-level concepts such as caching, security, and how to deploy Django. The appendixes form a reference for the commands and configurations available in Django. Who this book is for Anyone who wants to use the powerful Django framework to build dynamic web sites quickly and easily. Table of Contents Introduction to Django Getting Started Views and URLconfs Templates Models The Django Admin Site Forms Advanced Views and URLconfs Advanced Templates Advanced Models Generic Views Deploying Django Generating Non-HTML Content Sessions, Users, and Registration Caching django.contrib Middleware Integrating with Legacy Databases and Applications Internationalization Security
Beginning Django E-Commerce guides you through producing an e-commerce site using Django, the most popular Python web development framework. Topics covered include how to make a shopping cart, a checkout, and a payment processor; how to make the most of Ajax; and search engine optimization best practices. Throughout the book, you'll take each topic and apply it to build a single example site, and all the while you'll learn the theory behind what you're architecting. Build a fully functional e-commerce site. Learn to architect your site properly to survive in an increasingly competitive online landscape with good search engine optimization techniques. Become versed in the Django web framework and learn how you can put it to use to drastically reduce the amount of work you need to do to get a site up and running quickly. What you’ll learn Understand Django best practices for architecting a web site that will eventually be put into production. Leverage Django templates to maintain a consistent look and feel across your site. Learn search engine optimization best practices with search engine–friendly URLs, metatags, and an auto-generated Google site map. Follow best practices for security so the bad guys don't get control of your site or compromise your data. Learn about developing and deploying your Python code on the Google App Engine. Construct an enterprise-level shopping cart application that can actually receive payments from Authorize.net and PayPal. Who this book is for This book is for programmers looking to learn how to quickly and effectively leverage the Django web framework to build lightweight, powerful web sites. While the book is aimed at developers interested in creating e-commerce sites, the topics covered apply to any other site you might build with Django. You'll learn how to optimize your site for search engines, secure your pages to thwart hackers, and deploy your site into production–all with Django. Along the way, you'll build a fully functional e-commerce module that will have you up and selling stuff on the web in no time! Table of Contents Best Laid Plans Creating a Django Site Models for Sale The Shopping Cart Site Checkout & Orders Creating User Accounts Product Images Implementing Product Search Intelligent Cross-Selling Adding in Ajax Search Engine Optimization Web Security Overview Improving Performance Django Testing Deployment Django on Google App Engine
Spells out an approach to usability testing that anyone can easily apply to his or her own website, application or other product, in a book that explains how to test any design, keep one's focus on finding the most important problems and fix the problems one finds using the author's "the least you can do" approach. Original.
David Chappell, J. Harvey Trimble, Jr.
Learn SQL basics quickly with this visual tutorial featuring over 125 graphics SQL (Structured Query Language) is the tool used to access nearly all databases, which means that most software professionals should understand at least the basics. This hands-on tutorial offers an accessible introduction to SQL using over 125 graphics to illustrate the lessons. The book's unique visual approach makes it much easier for the reader to learn SQL. This Second Edition has been updated with new graphics and covers such subjects as the SELECT statement, joins, subqueries, views, granting and revoking privileges, and creating and destroying tables.
Daniel Greenfeld, Audrey Roy
Update! The third edition, Two Scoops of Django: Best Practices For Django 1.8 is available! Revised and expanded to 532 pages, it's a whole new book full of new material. Please consider it before purchasing this edition! http://www.amazon.com/Two-Scoops-Django-Best-Practices/dp/0981467342 Two Scoops of Django: Best Practices For Django 1.5 is chock-full of material that will help you with your Django projects. We'll introduce you to various tips, tricks, patterns, code snippets, and techniques that we've picked up over the years. We have put thousands of hours into writing and revising its 300+ pages of concise, example-packed text. What is everyone saying about Two Scoops of Django? "A single read-through of Two Scoops of Django gave me so many lightbulbs and tips; I had to go back for a second helping." -- Lynn Root, Red Hat engineer and PyLadies ambassador. Ha ha, I learned something in the first chapter. Awesome. -- Zed Shaw, Author of Learn Python the Hard Way. Two Scoops should provide some food for thought and usable recommendations for anybody using Django regularly. -- Malcolm Tredinnick, Django Core Contributor Make sure you have your favorite project next to you while reading. You'll be doing some rewriting. -- Bryan Veloso, GitHubber, PyCon PH Keynote Speaker If I could time travel, the first thing I'd do would be give my younger self a copy of this book, and make him read it. -- Randall Degges, Passionate Python Hacker You know those lessons you learn when projects blow up in your face? This book contains several projects worth of such lessons. -- Lennart Regebro, author of "Porting to Python 3" This book should prove to be an amazing resource for any new-to-Django developer that picks it up. -- Kenneth Love, Creator of "Getting Started with Django" No matter what your skill level is, Two Scoops has solid tips for everyone. -- Jeff Triplett, Developer at Revsys This is the book I wished had existed and I could have read when I started learning Django. -- Barry Morrison, Linux systems engineer and Django developer Two Scoops of Django is by far the best Django book I've read. -- Ben Beecher on Twitter Are there any negatives? Well yes. Only one: I wish I've read it earlier! -- Branko Vukelic Table of Contents Chapter 1: Coding Conventions Chapter 2: The Optimal Django Environment Setup Chapter 3: How To Lay Out Django Projects Chapter 4: Fundamentals of Django App Design Chapter 5: Settings and Requirements Files Chapter 6: Database/Model Best Practices Chapter 7: Function-and Class-Based Views Chapter 8: Best Practices for Class Based Views Chapter 9: Common Patterns for Forms Chapter 10: More Things To Know About Forms Chapter 11: Building REST APIs in Django Chapter 12: Templates: Best Practices Chapter 13: Template Tags and Filters Chapter 14: Tradeoffs of Replacing Core Components Chapter 15: Working With the Django Admin Chapter 16: Dealing with the User Model Chapter 17: Django's Secret Sauce: Third-Party Packages Chapter 18: Testing Chapter of Doom! Chapter 19: Documentation: Be Obsessed Chapter 20: Finding and Reducing Bottlenecks Chapter 21: Security Best Practices Chapter 22: Logging: Tips and Tools Chapter 23: Signals: Use Cases and Avoidance Techniques Chapter 24: What About Those Random Utilities? Chapter 25: Deploying Django Projects Chapter 26: How To Release Your Own Django Packages Chapter 27: Closing Thoughts Appendix A: Packages Mentioned In This Book Appendix B: Troubleshooting
Remarkable puzzlers, graded in difficulty, illustrate elementary and advanced aspects of probability. These problems were selected for originality, general interest, or because they demonstrate valuable techniques. Also includes detailed solutions.