Python

Author: Chris Fehily
Publisher: Peachpit Press
ISBN: 9780201748840
Format: PDF
Download Now
Named after the Monty Python comedy troupe, Python is an interpreted, open-source, object-oriented programming language. It's also free and runs portably on Windows, Mac OS, Unix, and other operating systems. Python can be used for all manner of programming tasks, from CGI scripts to full-fledged applications. It is gaining popularity among programmers in part because it is easier to read (and hence, debug) than most other programming languages, and it's generally simpler to install, learn, and use. Its line structure forces consistent indentation. Its syntax and semantics make it suitable for simple scripts and large programs. Its flexible data structures and dynamic typing allow you to get a lot done in a few lines. To learn it, you'll need is some basic programming experience and a copy of Python: Visual QuickStart Guide. In patented Visual QuickStart Guide fashion, the book doesn't just tell you how to use Python to develop applications, it shows you, breaking Python into easy-to-digest, step-by-step tasks and providing example code. Python: Visual QuickStart Guide emphasizes the core language and libraries, which are the building blocks for programs. Author Chris Fehily starts with the basics - expressions, statements, numbers, strings - then moves on to lists, dictionaries, functions, and modules before wrapping things up with straightforward discussions of exceptions and classes. Some additional topics covered include:- Object-oriented programming- Working in multiple operating systems- Structuring large programs- Comparing Python to C, Perl, and Java- Handling errors gracefully.

SQL

Author: Chris Fehily
Publisher: Peachpit Press
ISBN: 0132089475
Format: PDF, Kindle
Download Now
SQL is a standard interactive and programming language for querying and modifying data and managing databases. This task-based tutorial and reference guide takes the mystery out learning and applying SQL. After going over the relational database model and SQL syntax in the first few chapters, veteran author Chris Fehily immediately launches into the tasks that will get readers comfortable with SQL. In addition to covering all the SQL basics, this thoroughly updated reference contains a wealth of in-depth SQL knowledge and serves as an excellent reference for more experienced users.

PHP for the Web

Author: Larry Ullman
Publisher: Peachpit Press
ISBN: 0134301889
Format: PDF, ePub, Mobi
Download Now
Learn PHP programming the quick and easy way! With PHP for the Web: Visual QuickStart Guide readers can start from the beginning to get a tour of the programming language, or look up specific tasks to learn just what they need to know. This task-based visual reference guide uses step-by-step instructions and plenty of screenshots to teach beginning and intermediate users this popular open-source scripting language. Author Larry Ullman guides readers through the ins and outs of both PHP 5 and PHP 7, and offers more efficient ways to tackle common needs. Both beginning users, who want a thorough introduction to the technology, and more intermediate users, who are looking for a convenient reference, will find what they need here--in straightforward language and through readily accessible examples. Easy visual approach uses demonstrations and real-world examples to guide you through dynamic web development using PHP and show you what to do step by step. Concise steps and explanations let you get up and running in no time. Essential reference guide keeps you coming back again and again. Whether you’re a programming newbie or an experienced veteran learning PHP for the first time, this book will teach you all you need to know, including the latest changes in PHP and more efficient ways to tackle common needs.

Python

Author: Toby Donaldson
Publisher: Peachpit Press
ISBN: 0133435156
Format: PDF, ePub
Download Now
Python is a remarkably powerful dynamic programming language used in a wide variety of situations such as Web, database access, desktop GUIs, game and software development, and network programming. Fans of Python use the phrase "batteries included" to describe the standard library, which covers everything from asynchronous processing to zip files. The language itself is a flexible powerhouse that can handle practically any application domain. This task-based tutorial on Python is for those new to the language and walks you through the fundamentals. You'll learn about arithmetic, strings, and variables; writing programs; flow of control, functions; strings; data structures; input and output; and exception handling. At the end of the book, a special section walks you through a longer, realistic application, tying the concepts of the book together.

PHP and MySQL for Dynamic Web Sites

Author: Larry Ullman
Publisher: Peachpit Press
ISBN: 0134301919
Format: PDF
Download Now
Learn PHP and MySQL programming— the quick and easy way! Easy visual approach uses demonstrations and real-world examples to guide you step by step through advanced techniques for dynamic Web development using PHP and MySQL. • Concise steps and explanations let you get up and running in no time. • Essential reference guide keeps you coming back again and again. • Whether you’re new to programming or an experienced veteran just needing to get up to speed on PHP and MySQL, this book will teach you all you need to know, including the latest changes in the languages, and much more!

MySQL Pocket Reference

Author: George Reese
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596551698
Format: PDF, ePub, Mobi
Download Now
To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly. Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains: How to configure MySQL, such as setting the root password MySQL data types, including numerics, strings, dates, and complex types SQL syntax, commands, data types, operators, and functions Arithmetic, comparison and logical operators Aggregate and general functions Stored procedures and triggers, including procedure definition, procedure calls, procedure management, cursors, and triggers You don't have time to stop and thumb through an exhaustive reference when you're hard at work. This portable and affordable guide is small enough to fit into your pocket, and gives you a convenient reference that you can consult anywhere. When you reach a sticking point and need to get to a solution quickly, the MySQL Pocket Reference is the book you want to have.

SQL

Author: Chris Fehily
Publisher: Peachpit Press
ISBN: 0321553578
Format: PDF, ePub
Download Now
Task-based guide delivers the SQL know-how to employ and maintain any SQL-based database.

SQL Queries for Mere Mortals

Author: John L. Viescas
Publisher: Addison-Wesley Professional
ISBN: 0134858352
Format: PDF
Download Now
The #1 Easy, Common-Sense Guide to SQL Queries—Updated with More Advanced Techniques and Solutions Foreword by Keith W. Hare, Vice Chair, USA SQL Standards Committee SQL Queries for Mere Mortals has earned worldwide praise as the clearest, simplest tutorial on writing effective queries with the latest SQL standards and database applications. Now, author John L. Viescas has updated this hands-on classic with even more advanced and valuable techniques. Step by step, Viescas guides you through creating reliable queries for virtually any current SQL-based database. He demystifies all aspects of SQL query writing, from simple data selection and filtering to joining multiple tables and modifying sets of data. Building on the basics, Viescas shows how to solve challenging real-world problems, including applying multiple complex conditions on one table, performing sophisticated logical evaluations, and using unlinked tables to think “outside the box.” In two brand-new chapters, you learn how to perform complex calculations on groups for sophisticated reporting, and how to partition data into windows for more flexible aggregation. Practice all you want with downloadable sample databases for today’s versions of Microsoft Office Access, Microsoft SQL Server, and the open source MySQL and PostgreSQL databases. Whether you’re a DBA, developer, user, or student, there’s no better way to master SQL. Coverage includes: Getting started: understanding what relational databases are, and ensuring that your database structures are sound SQL basics: using SELECT statements, creating expressions, sorting information with ORDER BY, and filtering data using WHERE Summarizing and grouping data with GROUP BY and HAVING clauses Drawing data from multiple tables: using INNER JOIN, OUTER JOIN, and UNION operators, and working with subqueries Modifying data sets with UPDATE, INSERT, and DELETE statements Advanced queries: complex NOT and AND, conditions, if-then-else using CASE, unlinked tables, driver tables, and more NEW! Using advanced GROUP BY keywords to create subtotals, roll-ups, and more NEW! Applying window functions to answer more sophisticated questions, and gain deeper insight into your data Software-Independent Approach! If you work with database software such as Access, MS SQL Server, Oracle, DB2, MySQL, Ingres, or any other SQL-based program, this book could save you hours of time and aggravation—before you write a single query!

Head First SQL

Author: Lynn Beighley
Publisher: "O'Reilly Media, Inc."
ISBN: 0596526849
Format: PDF
Download Now
Presents an instructional guide to SQL which uses humor and simple images to cover such topics as the structure of relational databases, simple and complex queries, creating multiple tables, and protecting important table data.

Effortless E Commerce with PHP and MySQL

Author: Larry Ullman
Publisher: New Riders
ISBN: 0133519295
Format: PDF, Docs
Download Now
In this comprehensive guide to creating e-commerce website using PHP and MySQL, renowned author Larry Ullman walks you through every step—designing the visual interface, creating the database, presenting content, generating an online catalog, managing the shopping cart, handling the order and the payment process, and fulfilling the order—always with security and best practices emphasized along the way. Even if you’re an experienced web developer, you’re guaranteed to learn something new. The book uses two complete e-commerce site examples, with various features and goals, to present the widest possible range of e-commerce scenarios. This fully updated and expanded second edition includes an additional and new payment processing example, and also reflects the latest changes in PayPal’s options and methodologies. There are new chapters on marketing-related tools to improve the site and sales, on adding functionality via Ajax, and on implementing e-commerce functionality using OOP instead of procedural code. Effortless E-Commerce with PHP and MySQL, Second Edition teaches you how to: Think of the customer first, in order to maximize sales and customer satisfaction Create a safe server environment and database Use secure transactions and prevent common vulnerabilities Incorporate different payment gateways Design scalable sites that are easy to maintain Build administrative interfaces Extend both examples to match the needs of your own sites