- Mali
- Jewish American
- Prince of Persia
- Tropical
- Beethoven
- Law
- Giotto
- Tiernan, Cate
- Science Fiction & Fantasy
- Pediatrics
- General
- Cognitive Psychology
- Sanskrit
- Human Geography
- Topology
- Zoology
- Brahms
- Leighton, Frederic
- Serbo-Croatian
- Blanchot, Maurice
- Judy Moody
- Read and Wonder
- Constitutions
- Crane, Hart
- ( O )
- Resumes
- Networking
- Hydrology
- Oral & Maxillofacial
- Cardiovascular
- Some of our other sites:
- Books
- Clothing, Shoes and Accessories
- Baby Clothes and Accessories
- Cosmetics, Beauty Products and Fragrances
- Cellphones, Call Plans and Accessories
- Video Games
- DVDs
- Electronics, Gadgets and Computers
- Health and Personal Care
- Home and Garden
- Home DIY
- Jewelry
- Magazines and Newspapers
- Music Downloads
- Musical Instruments
- Office Equipment and Supplies
- Software and Games
- Sporting Goods
- Toys and Games
- Watches
- UK Books
- UK Video Games
- UK Home and Garden
- UK Electronics, Gadgets and Computers
- UK Baby Clothes and Accessories
- UK Software and Games
- UK Sporting Goods
- UK Toys and Games
Books : Computers & Internet : Databases : Specific Databases : MySQL & mSQL
-
Sams Teach Yourself SQL in 10 Minutes has established itself as the gold standard for introductory SQL books, offering a fast-paced accessible tutorial to the major themes and techniques involved in applying the SQL language. Forta¿s examples are clear and his writing style is crisp and concise. As with earlier editions, this revision includes coverage of current versions of all major commercial SQL platforms. New this time around is coverage of MySQL, and PostgreSQL. All examples have been tested against each SQL platform, with incompatibilities or platform distinctives called out and explained.
-
It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject.
-
-
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: Emphasis throughout on both performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views A detailed discussion on how to build very large, highly scalable systems with MySQL New options for backups and replication Optimization of advanced querying features, such as full-text searches Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
-
With over 3 million users worldwide, Adobe's Dreamweaver is the most popular web development software in the world, and it just took another step forward with CS3, the new version released in 2007. Having come a long way from its humble beginnings as a simple web design tool, CS3 allows you to rapidly put together standards compliant web sites and dynamic web sites with server-side languages and Ajax, and much more. To complement this great new application, David Powers has written the ultimate guide to itThe Essential Guide to Dreamweaver CS3 teaches you everything you need to know about the application, from setting up your development environment environment to publishing your sites and applications on the web, and everything in between.- Takes you through your development environment set up
- Covers everything you need to create both standards compliant web sutes, and dynamic web applications
- Teaches several real world techniques using a series of step by step tutorials
What youll learn
- How to set up your ideal development environment, using Mac OSX/Windows, Apache (and IIS on Windows,) Apache, MySQL, and phpMyAdmin
- Creating standards compliant web sites using CS3's XHTML and CSS features
- Creating dynamic web applications using CS3's PHP and Spry Ajax server behaviors
- Building several real world web site functions, such as form validation, random quote generator, search function, user management/login pages, dynamic Ajax gallery, and much more.
- Creating an interface design in Fireworks CS3 and importing it into Dreamweaver CS3.
- How use Dreamweaver CS3's XML functionality, to consume RSS feeds, and create Spry data sets
- Using includes, templates and master detail pages.
- How to publish your site after you've created it
Summary of Contents
- Chapter 1: Dreamweaver CS3Your Creative Partner
- Chapter 2: Building Dynamic Sites with Ajax and PHP
- Chapter 3: Getting the Work Environment Ready
- Chapter 4: Setting Up a PHP Site
- Chapter 5: Adding a Touch of Style
- Chapter 6: Creating a CSS Site Straight Out of the Box
- Chapter 7: Building Site Navigation with the Spry Menu Bar
- Chapter 8: Sprucing Up Content with Spry Widgets
- Chapter 9: Building Online Forms and Validating Input
- Chapter 10: Introducing the Basics of PHP
- Chapter 11: Using PHP to Process a Form
- Chapter 12: Working with PHP Includes and Templates
- Chapter 13: Setting Up MySQL and phpMyAdmin
- Chapter 14: Storing Records in a Database
- Chapter 15: Controlling Access to Your Site
- Chapter 16: Working with Multiple Tables
- Chapter 17: Searching Records and Handling Dates
- Chapter 18: Using XSLT to Display Live News Feeds and XML
- Chapter 19: Using Spry to Display XML
- Chapter 20: Getting the Best of Both Worlds with PHP and Spry
-
-
Beginning PHP and MySQL: From Novice to Professional, Third Edition offers a comprehensive introduction to two of the most prominent open source technologies on the planet: the PHP scripting language and the MySQL database server. Updated to introduce the features found in MySQLs most significant release to date, readers learn how to take advantage of the latest features of both technologies to build powerful, manageable, and stable web applications.
Essentially three books in one, readers not only profit from extensive introductions to the core features of each technology, but also learn how to effectively integrate the two in order to build robust data-driven applications. Packed with practical examples and insight into the real-world challenges faced by developers based on author W. Jason Gilmore's 7 years of expertise working with these technologies, readers will repeatedly return to this book as both a valuable instructional tool and reference guide.
What youll learn
- The PHP language
- How to back your web site with MySQL
- Templating so that you can apply a consistent design across all pages on your site
- How to authenticate your web site users
- How to use cookies to maintain information (such as items in a shopping cart) while a user is browsing your site
Who is this book for?
This book is written for developers seeking to take advantage of the PHP language and MySQL database to create powerful web applications.
About the Apress Beginning Series
The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from "novice to professional." Youll start your journey by seeing what you need to knowbut without needless theory and filler. Youll build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you thereit is your trusted guide through unfamiliar territory!
-
-
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!
-
You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level.Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is "so" much more you can do with the language. In the "SQL Cookbook," experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about:
Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out
Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function
Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set
"Bucketization," and why you should never use that term in Brooklyn.
How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques
The technique of "walking a string," which allows you to use SQL to parse through the characters, words, or delimited elements of a string
Written in O'Reilly's popular Problem/Solution/Discussion style, the "SQL Cookbook" is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, weall have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The "SQL Cookbook" moves quickly from problem to solution, saving you time each step of the way.
-
-
-
Sams Teach Yourself PHP, MySQL® and Apache All in One
Fourth Edition
Julie C. Meloni
Starter Kit
CD-ROM includes a complete starter kit for Windows®, Linux®, and Mac® OS X
In just a short time, you can learn how to use PHP, MySQL, and Apache together to create dynamic, interactive websites and applications using the three leading open-source web development technologies.
Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of PHP scripting, MySQL databases, and the Apache web server from the ground up.
Regardless of whether you run Linux, Windows, or Mac OS X, the enclosed CD includes a complete starter kit that lets you install all the software you need to set up a stable environment for learning, testing, and production.
Learn how to…
- Install, configure, and set up the PHP scripting language, the MySQL database system, and the Apache Web server
- Get these technologies to work together to create a dynamic, database-backed website
- Interact with MySQL using PHP
- Work with forms and files
- Create a web-based discussion forum or mailing list
- Add a storefront and shopping cart to your site
- Optimize your MySQL databases
- Fine-tune the Apache server’s performance
- Restrict access to your applications
- Set up a secure web server
Julie C. Meloni is the technical director for i2i Interactive, a multimedia company located in Los Altos, California. She has been developing web-based applications since the early days of the web, and is the author of several books and articles on web-based programming languages and database topics, including Sams Teach Yourself MySQL in 24 Hours.
CD-ROM Includes
- A complete PHP, MySQL, and Apache starter kit for Windows®, Linux®, or Mac® OS X.
Category: Web Development
Covers: PHP 5.2, MySQL 5, Apache 2.2
User Level: Beginning
-
...an instructive and expert demonstration of how to use PHP, MySQL, the Zend Framework, Smarty, Ajax, and other powerful technologies for creating robust Web sites.
— Michael J. Ross, Web developer/Slashdot contributor
Want to assert yourself as a cutting–edge PHP web developer? Take a practical approach, learning by example from author Quentin Zervaas, and discover how to bring together the many technologies needed to create a successful, modern web application.
In Practical Web 2.0 Applications with PHP, PHP, MySQL, CSS, XHTML, and JavaScript/Ajax development techniques are brought together to show you how to create the hottest PHP web applications, from planning and design up to final implementation, without going over unnecessary basics that will hold you back. This book includes must–have application features such as search functionality, maps, blogs, dynamic image galleries, and personalized user areas. The Zend Framework is used extensively to build the application, allowing you to focus on developing the application rather than on reinventing the wheel.
Topics covered include application planning and design; setting up the application framework; using CSS for easier styling; adding dynamic effects the easy way using JavaScript libraries such as Prototype and script.aculo.us; and implementing several must–have web application features such as user login, blogs, dynamic image galleries, search functionality, mapping with Google Maps, and much more. Zervaas covers everything in a practical, tutorial style so you can start working on your own projects as quickly as possible.
- Create cutting–edge PHP/MySQL web applications.
- Implement must–have functionality such as blogs, maps, search functionality, and dynamic image galleries.
- Master styling with CSS and dynamic effects using Ajax/JavaScript libraries.
What you’ll learn
- How to set up the perfect PHP/MySQL application development environment
- How to implement basic user management functionality
- How to use many of the components from the Zend Framework
- How to effectively make use of the Prototype and script.aculo.us JavaScript libraries, including many examples of developing custom JavaScript classes
- How to create standards–compliant and accessible HTML code and effectively style it using CSS
- How to create a basic blog system and enhance it with Ajax
- How to add personalized user areas to your web application
- How to create a dynamic image gallery
- How to add search functionality to your application
- How to use the Google Maps API to add maps to your application
- How to implement popular Web 2.0 features, such as microformats, tags, and web feeds
Who is this book for?
This book is for any PHP developer who wants to stay ahead of the curve, with practical, high–level web application development techniques.
About the Apress Practical Series
The Practical series from Apress is your best choice for getting the job done, period. From professional to expert, this series lets you apply project–motivated templates (or frameworks) step by step in a very direct, practical, and efficient manner toward current real–world projects that may be sitting on your desk. So whatever your career goal, Apress can be your trusted guide to take you where you want to go on your IT career empowerment path.
Related Titles from Apress
- Beginning PHP and MySQL: From Novice to Professional, Third Edition
- PHP 5 Objects, Patterns, and Practice
- Beginning PHP and MySQL E-Commerce: From Novice to Professional, Second Edition
-
-
SQL is the language of databases. It's used to create and maintain database objects, place data into those objects, query the data, modify the data, and, finally, delete data that is no longer needed. Databases lie at the heart of many, if not most business applications. Chances are very good that if you're involved with software development, you're using SQL to some degree. And if you're using SQL, you should own a good reference or two.Now available in an updated second edition, our very popular "SQL Pocket Guide" is a major help to programmers, database administrators, and everyone who uses SQL in their day-to-day work. The "SQL Pocket Guide" is a concise reference to frequently used SQL statements and commonly used SQL functions. Not just an endless collection of syntax diagrams, this portable guide addresses the language's complexity head on and leads by example. The information in this edition has been updated to reflect the latest versions of the most commonly used SQL variants including:
Oracle Database 10g, Release 2 (including
the free Oracle Database 10g Express Edition (XE))
Microsoft SQL Server 2005
MySQL 5
IBM DB2 8.2
PostreSQL 8.1 database
-
MySQL is one of the most popular database management systems available, powering everything from Internet powerhouses to individual corporate databases to simple end-user applications, and everything in between. And this book will teach you all you need to know to be immediately productive with MySQL. By working through 30 highly focused hands-on lessons, your MySQL Crash Course will be both easier and more effective than you'd have thought possible. Learn how to:
- Retrieve and sort data
- Filter data using comparisons, regular expressions, full text search, and much more
- Join relational data
- Create and alter tables
- Insert, update, and delete data
- Leverage the power of stored procedures and triggers
- Use views and Cursors
- Manage transactional processing
- Create user accounts and manage security via access control
Ben Forta is Macromedia's Senior Technical Evangelist, and has almost 20 years of experience in the computer industry in product development, support, training, and product marketing. Ben is the author of the best-selling Sams Teach Yourself SQL in 10 Minutes (now in its third edition, and translated into over a dozen languages), ColdFusion Web Application Construction Kit, and Advanced ColdFusion Development (both published by Que Publishing), Sams Teach Yourself Regular Expressions in 10 Minutes, as well as books on SQL, Flash, JSP, HomeSite, WAP, Windows 2000, and other subjects.
-
-
In this book you'll learn how to:- Create dynamic websites with design and usability in mind, as well as functionality
- Understand how PHP scripts work, giving you confidence to adapt them to your own needs
- Bring online forms to life, check required fields, and ensure user input is safe to process
- Upload files and automatically create thumbnails from larger images
- Manage website content with a searchable database
- Chapter 1: What Is PHPAnd Why Should I Care?
- Chapter 2: Getting Ready to Work with PHP
- Chapter 3: How to Write PHP Scripts
- Chapter 4: Lightening Your Workload with Includes
- Chapter 5: Bringing Forms to Life
- Chapter 6: Uploading Files
- Chapter 7: Using PHP to Manage Files
- Chapter 8: Generating Thumbnail Images
- Chapter 9: Pages That Remember: Simple Login and Multipage Forms
- Chapter 10: Setting Up MySQL and phpMyAdmin
- Chapter 11: Getting Started with a Database
- Chapter 12: Creating a Dynamic Online Gallery
- Chapter 13: Managing Content
- Chapter 14: Solutions to Common PHP/MySQL Problems
- Chapter 15: Keeping Intruders at Bay
-
This is the official guide to passing the two MySQL certification tests for MySQL 5, the long-awaited major revision of MySQL. The number of MySQL certification exams taken has doubled in the last six months.
Certcities.com lists the MySQL certification as one of the top 10 certifications to grow in 2005. MySQL professionals need a way to distinguish themselves from the vast majority of database administrators and developers. With more than 4 million active installations, MySQL is the world's most popular open-source database. Known for its speed, reliability and case of use, MySQL has become a low-cost alternative to expensive database systems such as Oracle, IBM and Microsoft. MySQL AB has aggressively improved the feature set of MySQL with MySQL 5, making it more suitable for enterprise-level applications and uses. The MySQL certification tests, available at over 3,000 PearsonVUE testing centers, is a key component of this enterprise growth strategy, establishing a base level of skills for database users, administrators and programmers.
The MySQL Core Certification is aimed at the database user who wants proof of his or her abilities in such fundamental areas as SQL, data entry and maintenance, and data extraction. The MySQL Professional Certification test is designed for the advanced user who wants to prove his or her knowledge in such areas as database management, installation, security, disaster prevention and optimization. Both tests are thoroughly covered in the MySQL 5.0 Certification Study Guide. Written by Paul DuBois, the leading author of books on MySQL topics, and reviewed for technical accuracy by MySQL AB, this book is the fastest, most reliable way for MySQL users, developers, and administrators to prepare for either of the MySQL tests.
-
Build an online catalog and a members-only site
Everything you need to know to create a dynamic PHP and MySQL Web site!
Been thinking of creating a high-quality interactive Web site? This book is just what you need to get started! Here's the fun and easy way(r) to develop a Web application in PHP 4, 5, or 6 and MySQL 5, test your software, enable your Web pages to display, change, and move database information, and much more.
Discover how to
* Plan and implement a Web database application
* Design and build a MySQL 5 database
* Build dynamic HTML forms
* Create scripts that store, retrieve, and update database information
* Display database information in a Web page