We've ranked the best mysql books using expert recommendations, sales data, and millions of reader ratings. At Shortform, we know books. Our book guides are the best in the world. Learn why.
Cover unavailable
1
Learning PHP, MySQL & JavaScript: With jQuery, CSS & HTML5 (Learning PHP, MYSQL, Javascript, CSS & HTML5)
Robin Nixon
5.0
Build interactive, data-driven websites with the potent combination of open source technologies and web standards, even if you have only basic HTML knowledge. In this update to this popular hands-on guide, you’ll tackle dynamic web programming with the latest versions of today’s core technologies: PHP, MySQL, JavaScript, CSS, HTML5, and key jQuery libraries.
Web designers will learn how to use these technologies together and pick up valuable web programming practices along the way—including how to optimize websites for mobile devices. At the end of the book, you’ll put everything together to build a fully functional social networking site suitable for both desktop and mobile browsers.
Explore MySQL, from database structure to complex queries Use the MySQLi extension, PHP’s improved MySQL interface Create dynamic PHP web pages that tailor themselves to the user Manage cookies and sessions and maintain a high level of security Enhance the JavaScript language with jQuery and jQuery mobile libraries Use Ajax calls for background browser-server communication Style your web pages by acquiring CSS2 and CSS3 skills Implement HTML5 features, including geolocation, audio, video, and the canvas element Reformat your websites into mobile web apps
…
Cover unavailable
2
Designing Data-Intensive Applications
Martin Kleppmann
4.8
Many forces affect software today: larger datasets, geographical disparities, complex company structures, and the growing need to be fast and nimble in the face of change.
Proven approaches such as service-oriented and event-driven architectures are joined by newer techniques such as microservices, reactive architectures, DevOps, and stream processing. Many of these patterns are successful by themselves, but as this practical ebook demonstrates, they provide a more holistic and compelling approach when applied together.
Author Ben Stopford explains how service-based architectures and stream processing tools such as Apache Kafka® can help you build business-critical systems.
* Learn why streaming beats request-response based architectures in complex, contemporary use cases * Understand why replayable logs such as Kafka provide a backbone for both service communication and shared datasets * Explore how event collaboration and event sourcing patterns increase safety and recoverability with functional, event-driven approaches * Apply patterns including Event Sourcing and CQRS, and how to build multi-team systems with microservices and SOA using patterns such as “inside out databases” and “event streams as a source of truth” * Build service ecosystems that blend event-driven and request-driven interfaces using a replayable log and Kafka's Streams API * Scale beyond individual teams into larger, department- and company-sized architectures, using event streams as a source of truth
…
Cover unavailable
3
Murach's MySQL
Joel Murach
4.8
Cover unavailable
4
High Performance MySQL: Optimization, Backups, Replication & Load Balancing
Baron Schwartz
4.8
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In "High Performance MySQL" you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics include: A review of configuration and setup optionsStorage engines and table typesBenchmarkingIndexesQuery OptimizationApplication DesignServer PerformanceReplicationLoad-balancingBackup and RecoverySecurity
…
Cover unavailable
5
PHP and MySQL Web Development
Luke Welling, Laura Thomson
4.7
PHP and MySQL Web Development, Fifth EditionThe definitive guide to building database-driven Web applications with PHP and MySQL PHP and MySQL are popular open-source technologies that are ideal for quickly developing database-driven Web applications. PHP is a powerful scripting language designed to enable developers to create highly featured Web applications quickly, and MySQL is a fast, reliable database that integrates well with PHP and is suited for dynamic Internet-based applications. PHP and MySQL Web Development shows how to use these tools together to produce effective, interactive Web applications. It clearly describes the basics of the PHP language, explains how to set up and work with a MySQL database, and then shows how to use PHP to interact with the database and the server. This practical, hands-on book consistently focuses on real-world applications, even in the introductory chapters. The authors cover important aspects of security and authentication as they relate to building a real-world website and show you how to implement these aspects in PHP and MySQL. They also introduce you to the integration of front-end and back-end technologies by using JavaScript in your application development. The final part of this book describes how to approach real-world projects and takes the reader through the design, planning, and building of several projects, including: User authentication and personalization Web-based email Social media integration Shopping cart The fifth edition of PHP and MySQL Web Development has been thoroughly updated, revised, and expanded to cover developments in PHP through versions 5.6 and 7, as well as features introduced in recent stable releases of MySQL. Free Access to Web Edition Purchase of this book in any format, electronic or print, includes free access to the corresponding Web Edition, which provides several special features: The complete text of the book online Exercises and interactive quizzes to test your understanding of the material Bonus chapters not included in the print or e-book editions Updates and corrections as they become available The Web Edition can be viewed on all types of computers and mobile devices with any modern web browser that supports HTML5. Contents at a Glance Part I: Using PHP 1 PHP Crash Course 2 Storing and Retrieving Data 3 Using Arrays 4 String Manipulation and Regular Expressions 5 Reusing Code and Writing Functions 6 Object-Oriented PHP 7 Error and Exception Handling Part II: Using MySQL 8 Designing Your Web Database 9 Creating Your Web Database 10 Working with Your MySQL Database 11 Accessing Your MySQL Database from the Web with PHP 12 Advanced MySQL Administration 13 Advanced MySQL Programming Part III: Web Application Security 14 Web Application Security Risks 15 Building a Secure Web Application 16 Implementing Authentication Methods with PHP Part IV: Advanced PHP Techniques 17 Interacting with the File System and the Server 18 Using Network and Protocol Functions 19 Managing the Date and Time 20 Internationalization and Localization 21 Generating Images 22 Using Session Control in PHP 23 Integrating JavaScript and PHP 24 Other Useful Features Part V: Building Practical PHP and MySQL Projects 25 Using PHP and MySQL for Large Projects 26 Debugging and Logging 27 Building User Authentication and Personalization 28 (Web Edition) Building a Web-Based Email Client with Laravel Part I 29 (Web Edition) Building a Web-Based Email Client with Laravel Part II 30 (Web Edition) Social Media Integration Sharing and Authentication 31 (Web Edition) Building a Shopping Cart Part VI: Appendix A Installing Apache, PHP, and MySQL
…
Recommended by Scott Johnson.
Scott Johnson
I spent a ton of years doing mostly product management as opposed to software engineering (what I do now). Although I had written code and managed engineers, I wasn't really a hands on software engineer. In the wake of the dot com crisis, when everyone was unemployed, when an unexpected software engineering gig landed on me, the book PHP and MySQL Web Development by Luke Welling and Laura Thompson literally taught me database backed web development. Oddly enough, two years later, I ended up marrying one of the book's editors. If I hadn't read that book, I wouldn't have ended up speaking at the PHP conference where I met my wife and I would not be married to her (or have my kids). That one book took me down the Open Source path and while I've changed languages (Ruby / Rails), it literally changed every single aspect of my life. [source]
Cover unavailable
6
MySQL Cookbook
Paul DuBois
4.7
Along with MySQL's popularity has come a flood of questions about solving specific problems, and that's where this Cookbook is essential. Designed as a handy resource when you need quick solutions or techniques, the book offers dozens of short, focused pieces of code and hundreds of worked-out examples for programmers of all levels who don't have the time (or expertise) to solve MySQL problems from scratch.
The new edition covers MySQL 5.0 and its powerful new features, as well as the older but still widespread MySQL 4.1. One major emphasis of this book is how to use SQL to formulate queries for particular kinds of questions, using the mysql client program included in MySQL distributions. The other major emphasis is how to write programs that interact with the MySQL server through an API. You'll find plenty of examples using several language APIs in multiple scenarios and situations, including the use of Ruby to retrieve and format data. There are also many new examples for using Perl, PHP, Python, and Java as well.
Other recipes in the book teach you to:
Access data from multiple tables at the same time Use SQL to select, sort, and summarize rows Find matches or mismatches between rows in two tables Determine intervals between dates or times, including age calculations Store images into MySQL and retrieve them for display in web pages Get LOAD DATA to read your data files properly or find which values in the file are invalid Use strict mode to prevent entry of bad data into your database Copy a table or a database to another server Generate sequence numbers to use as unique row identifiers Create database events that execute according to a schedule And a lot more MySQL Cookbook doesn't attempt to develop full-fledged, complex applications. Instead, it's intended to assist you in developing applications yourself by helping you get past problems that have you stumped.
…
Cover unavailable
7
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Walter Shields
4.7
SQL Made Easy- The Ultimate Step by Step Guide To Success Do you want to learn SQL programming without the complicated explanations? Do you want to understand how to manage databases without all the confusion? Well than, this is your go to guide to help you master SQL programming in no time! This book breaks down the fundamentals elements that are essential to make you proficient in SQL programming and database management By the end of this book you will be confident enough to take on any problems that encompass SQL SQL software can be complex, but a powerful tool if used with the right understanding In this book you will discover how SQL is simple, flexible, portable and most of all well integrated to various database applications The demand for SQL professionals is HUGE and the opportunities are endless! Learn how to easily master it and land yourself high grade paying jobs or free-lance work Entry level positions in the US can easily earn $90,000+ USD salary - That's almost six figures! The demand for these desirable skill sets are high, so become familiar with SQL ASAP What Sets This book apart from the rest? Why choose this book? This is most comprehensive and detailed book out for beginners to use. Not only are readers given step by step guide instructions, but, this book also contains detailed and high quality diagrams that enhance a reader's experience and understanding of the material. Visual aids are essential in the learning process, and this book in specific has ample diagrams for readers to follow. Normal SQL books on the market easily retail for $100s+, but, this book gives you such immense value and is far superior than any book out there for beginners. Why not start off at an affordable price? Don't miss out on this opportunity! What You'll Learn SQL and its uses Data definition language statementsDetailed keywords, statements, commands and functions, and how to put them to use in specific or altered waysData query language statementsHow to use each formula in real life situationsTransactional control commandsTerminology, syntax and expressionsUnderstanding Cursors, Triggers and Errors And, much, much more! The amount of value you receive is immense and the return on investment is exponential. Make the greatest investment in yourself by starting yourself off the right way today. From the examples, images, and step by step guide instructions you can have the assurance that you will be on the right path to mastery and long term success in SQL programming and database management. What are you waiting for? Take advantage this opportunity while you still can. Grab your copy now! Note* For the best visual experience of diagrams it is highly recommended you purchases the paperback version.
…
Cover unavailable
8
High Performance MySQL: Optimization, Backups, and Replication
Baron Schwartz, Peter Zaitsev, et al.
4.6
Cover unavailable
9
Head First PHP & MySQL
Lynn Beighley
4.6
If you're ready to create web pages more complex than those you can build with HTML and CSS, Head First PHP & MySQL is the ultimate learning guide to building dynamic, database-driven websites using PHP and MySQL. Packed with real-world examples, this book teaches you all the essentials of server-side programming, from the fundamentals of PHP and MySQL coding to advanced topics such as form validation, session IDs, cookies, database queries and joins, file I/O operations, content management, and more.
Head First PHP & MySQL offers the same visually rich format that's turned every title in the Head First series into a bestseller, with plenty of exercises, quizzes, puzzles, and other interactive features to help you retain what you've learned.
Use PHP to transform static HTML pages into dynamic web sites Create and populate your own MySQL database tables, and work with data stored in files Perform sophisticated MySQL queries with joins, and refine your results with LIMIT and ORDER BY Use cookies and sessions to track visitors' login information and personalize the site for users Protect your data from SQL injection attacks Use regular expressions to validate information on forms Dynamically display text based on session info and create images on the fly Pull syndicated data from other sites using PHP and XML Throughout the book, you'll build sophisticated examples -- including a mailing list, a job board, and an online dating site -- to help you learn how to harness the power of PHP and MySQL in a variety of contexts. If you're ready to build a truly dynamic website, Head First PHP & MySQL is the ideal way to get going.
…
Cover unavailable
10
MySQL Stored Procedure Programming: Building High-Performance Web Applications in MySQL
Guy Harrison, Steven Feuerstein
4.6
The implementation of stored procedures in MySQL 5.0 a huge milestone -- one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work -- and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without.
In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use.
MySQL's new procedural language has a straightforward syntax, making it easy to write simple programs. But it's not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise.
In MySQL Stored Procedure Programming, they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections:
MySQL stored programming fundamentals -- tutorial, basic statements, SQL in stored programs, and error handling Building MySQL stored programs -- transaction handling, built-in functions, stored functions, and triggers MySQL stored programs in applications -- using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET) Optimizing MySQL stored programs -- security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices A companion web site contains many thousands of lines of code, that you can put to use immediately.
Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of Oracle PL/SQL Programming, the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.
…
Cover unavailable
11
MySQL
Paul DuBois
4.5
A guide for end users and administrators alike. MySQL helps users make the most of MySQL, a client-server SQL database management system. -- Devoted exclusively to helping users make the most of the MySQL database system -- Provides the best single source of understandable, practical information for learning how to use MySQL productively -- Closely tied to the MySQL developers, Paul DuBois is a MySQL expert, and has authored and revised a significant portion of the online MySQL documentationMySQL will teach the reader how to use the tools provided by the MySQL distribution itself, covering installation, setup, daily use, security, optimization, maintenance, and troubleshooting. It will also discuss important third-party tools, such as the Perl DBI and Apache/PHP interfaces that provide access to MySQL. These are used by a significant number of people who employ MySQL particularly for tying MySQL to Web sites. In a facetious sense, you could say the goal is to explain how to use MySQL so clearly that traffic on the MySQL, DBI, and PHP mailing lists is reduced significantly. It's pretty clear from tracking the questions asked on those lists that a general-purpose guide to MySQL (other than the reference manual) is needed.
…
Cover unavailable
12
Learning MySQL
Seyed M.M. (Saied) Tahaghoghi and Hugh Williams
4.5
Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as:
Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season?
MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and Learning MySQL provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.
After covering the basics, the book travels far into MySQL's subtleties, including complex queries and joins, how to interact with the database over the Web using PHP or Perl, and important house-keeping such as backups and security.
Topic include:
Installation on Linux, Windows, and Mac OS X Basic and advanced querying using SQL User management and security Backups and recovery Tuning for improved efficiency Developing command-line and web database applications using the PHP and Perl programming languages
The authors, Saied Tahaghoghi and Hugh E. Williams, have careers in academia and business, and share a keen interest in research into search technologies.
Whether you've never touched a database or have already completed some MySQL projects, you'll find insights in Learning MySQL that will last a career.
…
Cover unavailable
13
Learn SQL (using MySQL) in One Day and Learn It Well: SQL for Beginners with Hands-on Project
LCF Publishing
4.5
New Book by Best-Selling Author Jamie Chan. Learn SQL Fast with a unique Hands-On Project. Book 5 of the Learn Coding Fast Series.
Learn SQL (using MySQL) Fast and Learn It Well. Master SQL Programming with a unique Hands-On Project The information era is upon us and the ability to organize and make sense of data has become an invaluable skill.
Have you been hearing about data, databases and SQL and wondering what it's all about? Or perhaps you have just gotten a new job and need to learn SQL fast.
This book is for you. You no longer have to feel lost and overwhelmed by all the fragmented tutorials online, nor do you have to waste your time and money learning SQL from lengthy books and expensive online courses.
What this book offers... Learn SQL Fast
Concepts in this book are presented in a "to-the-point" and concise style to cater to the busy individual. With this book, you can learn SQL in just one day and start coding immediately.
SQL for Beginners
Complex topics are broken down into simple steps with clear and carefully chosen examples to ensure that you can easily master SQL even if you have never coded before. In addition, the output for all examples are provided immediately so you do not have to wait till you have access to your computer to test the examples.
Complete process with well thought out flow
The complete process from database creation, table creation, data input, manipulation and retrieval etc is covered. The flow of the book is carefully planned to ensure that you can easily follow along.
How is this book different... The best way to learn SQL is by doing. This book provides examples for all concepts taught so that you can try out the different SQL commands yourself.
In addition, you'll be guided through a complete project at the end of the book that requires the application of all the concepts taught previously. Working through the project will not only give you an immense sense of achievement, it'll also help you retain the knowledge and master the language.
Ready to embark on your SQL learning journey? This book is for you. Click the BUY button and download it now.
What you'll learn: - What is a database and DBMS? - What is SQL? - What software do you need to code SQL programs? - How to create databases and tables in SQL? - What are the common data types in SQL? - How to input data into the database - How to select data from SQL tables - How to use aggregate functions - How to write JOIN and UNION statements - What is a SQL view? - How to write SQL triggers - How to write stored procedures and functions - How to make decisions with IF and CASE statements - How to control the flow of program with WHILE, REPEAT and LOOP statements - What are cursors and how to use them? .. and more...
Finally, you'll be guided through a hands-on project that requires the application of all the topics covered.
Click the BUY button and download the book now to start learning SQL. Learn it fast and learn it well.
…
Cover unavailable
14
Sams Teach Yourself SQL in 10 Minutes
Ben Forta
4.5
Sams Teach Yourself SQL in 10 Minutes, Fourth Edition"New full-color code examples help you see how SQL statements are structured" Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know-starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply-in 22 short, quick lessons that will each take only 10 minutes or less to complete. With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language. "10 minutes is all you need to learn how to..." Use the major SQL statementsConstruct complex SQL statements using multiple clauses and operatorsRetrieve, sort, and format database contentsPinpoint the data you need using a variety of filtering techniquesUse aggregate functions to summarize dataJoin two or more related tablesInsert, update, and delete dataCreate and alter database tablesWork with views, stored procedures, and moreTable of Contents 1 Understanding SQL 2 Retrieving Data 3 Sorting Retrieved Data 4 Filtering Data 5 Advanced Data Filtering 6 Using Wildcard Filtering 7 Creating Calculated Fields 8 Using Data Manipulation Functions 9 Summarizing Data 10 Grouping Data 11 Working with Subqueries 12 Joining Tables 13 Creating Advanced Joins 14 Combining Queries 15 Inserting Data 16 Updating and Deleting Data 17 Creating and Manipulating Tables 18 Using Views 19 Working with Stored Procedures 20 Managing Transaction Processing 21 Using Cursors 22 Understanding Advanced SQL Features Appendix A: Sample Table Scripts Appendix B: Working in Popular Applications Appendix C: SQL Statement Syntax Appendix D: Using SQL Datatypes Appendix E: SQL Reserved Words
…
Cover unavailable
15
Murach's PHP and MySQL
Joel Murach, Ray Harris, et al.
4.5
Cover unavailable
16
High Performance MySQL: Optimization, Backups, Replication, and More
Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy D. Zawodny, Arjen Lentz, Derek J. Balling
4.5
Cover unavailable
17
Mastering Regular Expressions
Jeffrey E. F. Friedl
4.5
Regular expressions are an extremely powerful tool for manipulating text and data. They are now standard features in a wide range of languages and popular tools, including Perl, Python, Ruby, Java, VB.NET and C# (and any language using the .NET Framework), PHP, and MySQL.
If you don't use regular expressions yet, you will discover in this book a whole new world of mastery over your data. If you already use them, you'll appreciate this book's unprecedented detail and breadth of coverage. If you think you know all you need to know about regularexpressions, this book is a stunning eye-opener.
As this book shows, a command of regular expressions is an invaluable skill. Regular expressions allow you to code complex and subtle text processing that you never imagined could be automated. Regular expressions can save you time and aggravation. They can be used to craft elegant solutions to a wide range of problems. Once you've mastered regular expressions, they'll become an invaluable part of your toolkit. You will wonder how you ever got by without them.
Yet despite their wide availability, flexibility, and unparalleled power, regular expressions are frequently underutilized. Yet what is power in the hands of an expert can be fraught with peril for the unwary. Mastering Regular Expressions will help you navigate the minefield to becoming an expert and help you optimize your use of regular expressions.
Mastering Regular Expressions, Third Edition, now includes a full chapter devoted to PHP and its powerful and expressive suite of regular expression functions, in addition to enhanced PHP coverage in the central "core" chapters. Furthermore, this edition has been updated throughout to reflect advances in other languages, including expanded in-depth coverage of Sun's java.util.regex package, which has emerged as the standard Java regex implementation.Topics include:
A comparison of features among different versions of many languages and tools How the regular expression engine works Optimization (major savings available here!) Matching just what you want, but not what you don't want Sections and chapters on individual languages Written in the lucid, entertaining tone that makes a complex, dry topic become crystal-clear to programmers, and sprinkled with solutions to complex real-world problems, Mastering Regular Expressions, Third Edition offers a wealth information that you can put to immediateuse.
Reviews of this new edition and the second edition:
"There isn't a better (or more useful) book available on regular expressions."
--Zak Greant, Managing Director, eZ Systems
"A real tour-de-force of a book which not only covers the mechanics of regexes in extraordinary detail but also talks about efficiency and the use of regexes in Perl, Java, and .NET...If you use regular expressions as part of your professional work (even if you already have a good book on whatever language you're programming in) I would strongly recommend this book to you."
--Dr. Chris Brown, Linux Format
"The author does an outstanding job leading the reader from regexnovice to master. The book is extremely easy to read and chock full ofuseful and relevant examples...Regular expressions are valuable toolsthat every developer should have in their toolbox. Mastering RegularExpressions is the definitive guide to the subject, and an outstandingresource that belongs on every programmer's bookshelf. Ten out of TenHorseshoes."
--Jason Menard, Java Ranch
…
Cover unavailable
18
Php, Mysql, & JavaScript All-In-One for Dummies
Blum
4.5
Explore the engine that drives the internet
It takes a powerful suite of technologies to drive the most-visited websites in the world. PHP, mySQL, JavaScript, and other web-building languages serve as the foundation for application development and programming projects at all levels of the web.
Dig into this all-in-one book to get a grasp on these in-demand skills, and figure out how to apply them to become a professional web builder. You'll get valuable information from seven handy books covering the pieces of web programming, HTML5 & CSS3, JavaScript, PHP, MySQL, creating object-oriented programs, and using PHP frameworks.
Helps you grasp the technologies that power web applications Covers PHP version 7.2 Includes coverage of the latest updates in web development Perfect for developers to use to solve problems This book is ideal for the inexperienced programmer interested in adding these skills to their toolbox. New coders who've made it through an online course or boot camp will also find great value in how this book builds on what you already know.
…
Cover unavailable
19
MySQL Crash Course
Ben Forta
4.5
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.
…
Cover unavailable
20
SQL Cookbook
Anthony Molinaro
4.5
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 columns FROM table WHERE conditions. 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, we all 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.
…
Cover unavailable
21
Web Scraping with Python: Collecting More Data from the Modern Web
Ryan Mitchell
4.4
Cover unavailable
22
The PHP Workshop: A New, Interactive Approach to Learning PHP
Alexandru Busuioc, David Carr, et al.
4.4
Cover unavailable
23
Learning SQL
Alan Beaulieu
4.4
Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.
Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:
Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.
…
Cover unavailable
24
PHP and MySQL for Dynamic Web Sites: Visual Quickpro Guide
Larry Ullman
4.4
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!
…
Cover unavailable
25
Pro MySQL
Michael Kruckenberg, Jay Pipes, et al.
4.4
Pro MySQL is the first book that exclusively covers intermediate and advanced features of MySQL, the world's most popular open source database server. Whether you are a seasoned MySQL user looking to take your skills to the next level, or youre a database expert searching for a fast-paced introduction to MySQL's advanced features, this book is for you.
The first part of this book discusses topics related to design and development. Topics include transaction processing and indexing theory, benchmarking and profiling, and advanced coverage of storage engines and data types. The authors also delve deep into the MySQL source code and system architecture at a level you won't find anywhere else. Essential advanced SQL is also covered, with discussion of subqueries, derived tables, and joins. These concepts are demonstrated in a range of situation-specific examplesfrom dealing with hierarchical data to performing geographic information system (GIS) examples with just MySQL. This section also covers MySQL 5's new enterprise features like stored procedures, triggers, and views.
The latter part of this book devotes itself to administration topics. Topics include MySQL installation and upgrading, user administration, database backups, replication, and clustering. You'll also learn about the new data dictionary features available in MySQL 5.
…
Cover unavailable
26
PHP 6 and MySQL 5 for Dynamic Web Sites: Visual Quickpro Guide
Larry Ullman
4.4
With step-by-step instructions, complete scripts, and expert tips to guide readers, this work gets right down to business - after grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), it goes on to cover security, sessions and cookies, and using additional Web tools.
Cover unavailable
27
Java: The Complete Reference
Herbert Schild
4.4
The Definitive Java Programming Guide
In "Java: The Complete Reference, Eighth Edition," bestselling programming author Herb Schildt shows you everything you need to develop, compile, debug, and run Java programs. Updated for Java Platform, Standard Edition 7 (Java SE 7), this comprehensive volume covers the entire Java language, including its syntax, keywords, and fundamental programming principles. You'll also find information on key elements of the Java API library. JavaBeans, servlets, applets, and Swing are examined and real-world examples demonstrate Java in action. In addition, new Java SE 7 features such as try-with-resources, strings in switch, type inference with the diamond operator, NIO.2, and the Fork/Join Framework are discussed in detail.
Coverage includes: Data types and operatorsControl statementsClasses and objectsConstructors and methodsMethod overloading and overridingInterfaces and packagesInheritanceException handlingGenericsAutoboxingEnumerationsAnnotationsThe try-with-resources statementVarargsMultithreadingThe I/O classesNetworkingThe Collections FrameworkApplets and servletsJavaBeansAWT and SwingThe Concurrent APIMuch, much more
…
Cover unavailable
28
SQL Pocket Guide
Jonathan Gennick
4.4
If you're a programmer or database administrator who uses SQL in your day-to-day work, this popular pocket guide is the ideal on-the-job reference. You'll find many examples that address the language's complexity, along with key aspects of SQL used in IBM DB2 Release 9.7, MySQL 5.1, Oracle Database 11g Release 2, PostgreSQL 9.0, and Microsoft SQL Server 2008 Release 2.
SQL Pocket Guide describes how these database systems implement SQL syntax for querying, managing transactions, and making changes to data. It also shows how the systems use SQL functions, regular expression syntax, and type conversion functions and formats.
All example SQL statements in this book execute against a set of tables, with data that you can quickly download. The third edition covers important database changes, including:
Oracle's support of the recursive WITH syntax, and addition of PIVOT and UNPIVOT operators Functions new to Oracle, such as LISTAGG, NTH_VALUE, and more PostgreSQL’s support of recursive WITH and some window functions DB2 syntax and datatypes, some compatible with Oracle MySQL features such as the TIMESTAMP type and the TO_SECONDS function
…
Cover unavailable
29
SQL Antipatterns
Bill Karwin
4.4
Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he's sharing his collection of antipatterns--the most common errors he's identified in those thousands of requests for help.
Most developers aren't SQL experts, and most of the SQL that gets used is inefficient, hard to maintain, and sometimes just plain wrong. This book shows you all the common mistakes, and then leads you through the best fixes. What's more, it shows you what's behind these fixes, so you'll learn a lot about relational databases along the way.
Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development.
The chances are good that your application's database layer already contains problems such as Index Shotgun, Keyless Entry, Fear of the Unknown, and Spaghetti Query. This book will help you and your team find them. Even better, it will also show you how to fix them, and how to avoid these and other problems in the future.
SQL Antipatterns gives you a rare glimpse into an SQL expert's playbook. Now you can stamp out these common database errors once and for all.
Whatever platform or programming language you use, whether you're a junior programmer or a Ph.D., SQL Antipatterns will show you how to design and build databases, how to write better database queries, and how to integrate SQL programming with your application like an expert. You'll also learn the best and most current technology for full-text search, how to design code that is resistant to SQL injection attacks, and other techniques for success.
…
Cover unavailable
30
Web Database Applications with PHP and MySQL
Hugh E. Williams, David Lane
4.4
There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.
Web Database Applications with PHP and MySQL, Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates to give your dynamic web pages a standard look.
But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.
Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.
Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introduces PHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.
This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:
Installation and configuration of Apache, MySQL, and PHP on Unix®, Windows®, and Mac OS® X systems Introductions to PHP, SQL, and MySQL administration Session management, including the use of a custom database for improved efficiency User input validation, security, and authentication The PEAR repository, plus details on the use of PEAR DB and Template classes Production of PDF reports
…
Cover unavailable
31
MySQL Pocket Reference: SQL Functions and Utilities
George Reese
4.3
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.
…
Cover unavailable
32
Jump Start MySQL: Master the Database That Powers the Web
Timothy Boronczyk
4.3
Get a Jump Start on working with MySQL today!
MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers.
In just one weekend with this hands-on tutorial, you'll learn how to:
Get started with MySQL Store, modify, and retrieve data Work with multiple tables Connect to your database through code Program the database Back up your data
…
Cover unavailable
33
SQL in a Nutshell: A Desktop Quick Reference
Kevin Kline, Daniel Kline, Brand Hunt
4.3
SQL in a Nutshell applies the eminently useful "Nutshell" format to Structured Query Language (SQL), the elegant--but complex--descriptive language that is used to create and manipulate large stores of data. For SQL programmers, analysts, and database administrators, the new second edition of SQL in a Nutshell is the essential date language reference for the world's top SQL database products. SQL in a Nutshell is a lean, focused, and thoroughly comprehensive reference for those who live in a deadline-driven world.
This invaluable desktop quick reference drills down and documents every SQL command and how to use it in both commercial (Oracle, DB2, and Microsoft SQL Server) and open source implementations (PostgreSQL, and MySQL). It describes every command and reference and includes the command syntax (by vendor, if the syntax differs across implementations), a clear description, and practical examples that illustrate important concepts and uses. And it also explains how the leading commercial and open sources database product implement SQL. This wealth of information is packed into a succinct, comprehensive, and extraordinarily easy-to-use format that covers the SQL syntax of no less than 4 different databases.
When you need fast, accurate, detailed, and up-to-date SQL information, SQL in a Nutshell, Second Edition will be the quick reference you'll reach for every time. SQL in a Nutshell is small enough to keep by your keyboard, and concise (as well as clearly organized) enough that you can look up the syntax you need quickly without having to wade through a lot of useless fluff. You won't want to work on a project involving SQL without it.
…
Cover unavailable
34
Creating a Website: The Missing Manual
Matthew MacDonald
4.3
You can easily create a professional-looking website with nothing more than an ordinary computer and some raw ambition. Want to build a blog, sell products, create forums, or promote an event? No problem! This friendly, jargon-free book gives you the techniques, tools, and advice you need to build a site and get it up on the Web.
The important stuff you need to know:
Master the basics. Learn HTML5, the language of the Web.
Design good-looking pages. Use styles to build polished layouts.
Get it online. Find a reliable web host and pick a good web address.
Use time-saving tools. Learn free tools for creating web pages and tracking your visitors.
Attract visitors. Make sure people can find your site through popular search engines like Google.
Build a community. Encourage repeat visits with social media.
Bring in the cash. Host Google ads, sell Amazon's wares, or push your own products that people can buy via PayPal.
Add pizzazz. Include audio, video, interactive menus, and a pinch of JavaScript.
…
Cover unavailable
35
MySQL: Learn MySQL the Quick and Easy Way (Visual QuickStart Guide)
Larry Ullman
4.3
Even if you've never used MySQL before, this Visual QuickStart Guide will have you up and running with the world's most popular open source database application in no time. In this completely updated edition of our best-selling guide to MySQL, leading technology author Larry Ullman uses his trademark crystal-clear instructions and friendly prose to introduce you to everything that's new in MySQL. Filled with step-by-step, task-based instructions and loads of visual aids, this book explains how to interact with MySQL using SQL, the language common to all databases. The interface examples show how to use MySQL's own tools and how to use three popular programming languages (PHP, Perl, and Java). The book covers MySQL versions 3 and 4, as well as everything new in the eagerly anticipated version 5. Along the way, you'll find extensive coverage of MySQL installation, administration, database design, as well as its use with various programming languages, database programming techniques, utilities, advanced MySQL and SQL, and more!
- Takes an easy, visual approach to teaching MySQL, using pictures to guide you through the software and show you what to do. - Works like a reference book--you look up what you need and then get straight to work. - No long-winded passages--concise, straightforward commentary explains what you need to know. - Affordably priced, because buying a computer book shouldn't be an investment in itself. - Companion Web site at www.DMCInsights.com/mysql2 contains complete source code for examples in the book, online resources, extra scripts and tutorials, updates, a reader forum, and more.
…
Cover unavailable
36
Top 50 MySQL Interview Questions & Answers
Knowledge Powerhouse
4.3
Cover unavailable
37
Head First SQL
Lynn Beighley
4.3
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!
…
Cover unavailable
38
MySQL 5.0 Certification Study Guide: The authoritative study guide to prepare for and pass the MySQL Certified Developer and MySQL Certified DBA exams
Paul DuBois, Stefan Hinz, Carsten Pedersen
4.3
Cover unavailable
39
SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL
John L. Viescas
4.3
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!
…
Cover unavailable
40
Web Design - Start Here: A No-Nonsense, Jargon Free Guide to the Fundamentals of Web Design
Stefan Mischook
4.3
This friendly, comprehensive guide will teach you everything you need to know to create and maintain stylish, effective websites that please clients, customers, viewers, and you.
Cover unavailable
41
SQL All-In-One For Dummies, 3rd Edition
Taylor
4.3
The latest on SQL databases
SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who manage them will find clear, concise explanations of the SQL language and its many powerful applications.
With the ballooning amount of data out there, more and more businesses, large and small, are moving from spreadsheets to SQL databases like Access, Microsoft SQL Server, Oracle databases, MySQL, and PostgreSQL. This compendium of information covers designing, developing, and maintaining these databases.
Cope with any issue that arises in SQL database creation and management Get current on the newest SQL updates and capabilities Reference information on querying SQL-based databases in the SQL language Understand relational databases and their importance to today's organizations SQL All-In-One For Dummies is a timely update to the popular reference for readers who want detailed information about SQL databases and queries.
…
Cover unavailable
42
PHP and MySQL for Dynamic Web Sites
Larry Ullman
4.3
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 beginning to intermediate 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 features and techniques with PHP and MySQL. Also new to this edition are chapters introducing jQuery and object-oriented programming techniques.
…
Cover unavailable
43
Web Coding & Development All-In-One for Dummies
Paul McFedries
4.3
Speak the languages that power the web
With more high-paying web development jobs opening every day, people with coding and web/app building skills are having no problems finding employment. If you're a would-be developer looking to gain the know-how to build the interfaces, databases, and other features that run modern websites, web apps, and mobile apps, look no further. Web Coding & Development All-in-One For Dummies is your go-to interpreter for speaking the languages that handle those tasks.
Get started with a refresher on the rules of coding before diving into the languages that build interfaces, add interactivity to the web, or store and deliver data to sites. When you're ready, jump into guidance on how to put it all together to build a site or create an app.
Get the lowdown on coding basics Review HTML and CSS Make sense of JavaScript, jQuery, PHP, and MySQL Create code for web and mobile apps There's a whole world of opportunity out there for developers--and this fast-track boot camp is here to help you acquire the skills you need to take your career to new heights!
Database skills are among the most in-demand IT skills today. Now you can gain a solid foundation in database design and implementation with the practical, easy-to-understand approach in the market-leading DATABASE SYSTEMS: DESIGN, IMPLEMENTATION, AND MANAGEMENT, 13E. Diagrams, illustrations, and tables clarify in-depth coverage of database design. You learn the key to successful database implementation as you study how to properly design databases to fit within the larger strategic data environment. Clear, straightforward writing supports an outstanding balance of theory and practice with hands-on skills today's employers want. Revised SQL coverage offers more SQL examples and simpler explanations that focus on the areas most important for a database career. More coverage of Big Data Analytics and NoSQL, including related Hadoop technologies, now provides a stronger hands-on approach.
…
Cover unavailable
45
Php, MySQL & JavaScript All in One, Sams Teach Yourself
Julie C. Meloni
4.3
In just a short time, you can learn how to use PHP, MySQL, and JavaScript together to create dynamic, interactive websites and applications using three leading web development technologies. No previous programming experience is required. Using a straightforward, step-by-step approach, each lesson in this book builds on the previous ones, enabling you to learn the essentials of full-stack web application development - from HTML, CSS, and JavaScript on the front end, to PHP scripting and MySQL databases on the server. Regardless of whether you run Linux, Windows, or MacOS, the book includes complete instructions to install all the software you need to set up a stable environment for learning, testing, and production. Step-by-step instructions carefully walk you through the most common web application development tasks. Practical, hands-on examples show you how to apply what you learn. Quizzes and exercises help you test your knowledge and stretch your skills. Learn how to: - Build web pages with HTML5 and CSS - Use JavaScript to build dynamic, interactive web pages - Get PHP, MySQL, and JavaScript to work together to create modern, standards-compliant web applications - Enhance interactivity with AJAX - Leverage JavaScript libraries such as jQuery - Work with cookies and user sessions - Get user input with web-based forms - Use basic SQL commands - Interact with the MySQL database using PHP - Write maintainable code and get started with version control - Decide when frameworks such as Bootstrap, Foundation, React, Angular, and Laravel can be useful - Create a web-based discussion forum or calendar - Add a storefront and shopping cart to your site Contents at a GlancePART I Web Application Basics 1 Understanding How the Web Works 2 Structuring HTML and Using Cascading Style Sheets 3 Understanding the CSS Box Model and Positioning 4 Introducing JavaScript 5 Introducing PHP PART II Getting Started with Dynamic Web Sites 6 Understanding Dynamic Web Sites and HTML5 Applications 7 JavaScript Fundamentals: Variables, Strings, and Arrays 8 JavaScript Fundamentals: Functions, Objects, and Flow Control 9 Understanding JavaScript Event Handling 10 The Basics of Using jQuery PART III Taking Your Web Applications to the Next Level 11 AJAX: Getting Started with Remote Scripting 12 PHP Fundamentals: Variables, Strings, and Arrays 13 PHP Fundamentals: Functions, Objects, and Flow Control 14 Working with Cookies and User Sessions 15 Working with Web-Based Forms PART IV Integrating a Database into Your Applications 16 Understanding the Database Design Process 17 Learning Basic SQL Commands 18 Interacting with MySQL Using PHP PART V Getting Started with Application Development 19 Creating a Simple Discussion Forum 20 Creating an Online Storefront 21 Creating a Simple Calendar 22 Managing Web Applications PART VI Appendixes A Installation QuickStart with XAMPP B Installing and Configuring MySQL C Installing and Configuring Apache D Installing and Configuring PHP
…
Cover unavailable
46
MySQL & Perl for the Web
Paul DuBois
4.3
MySQL and Perl for the Web provides a much-needed handbook for database and Web developers seeking an extensive and detailed guide for using the combination of MySQL and Perl to build dynamic and interactive database-backed Web sites. It shows how to use Perl's DBI database access module, pairing it with with the CGI.pm module that allows Web pages and forms to be generated and processed easily. These tools provide developers with a solid foundation for creating applications that incorporate database content to create dynamic, up-to-date Web sites.
The book employs a practical learn-by-doing approach that demonstrates development techniques by building complete applications, not just fragmentary pieces. It shows what to do at each step of the way during the process of building live, working examples. Applications are fully explained so you can understand how they work and apply the techniques they illustrate to your own projects.
…
Cover unavailable
47
MySQL Administrator's Bible
Sheeri K. Cabral and Keith Murphy
4.3
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management--including MySQL's unique approach to basic database features and functions--as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
…
Cover unavailable
48
PHP & MySQL For Dummies
Janet Valade
4.3
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
…
Cover unavailable
49
Database in Depth: Relational Theory for Practitioners
C.J. Date
4.3
This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.
Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view that's not influenced by any vendor or product. Featuring an extensive set of exercises, it will help you:
understand why and how the relational model is still directly relevant to modern database technology (and will remain so for the foreseeable future) see why and how the SQL standard is seriously deficient use the best current theoretical knowledge in the design of their databases and database applications make informed decisions in their daily database professional activities
Database in Depth will appeal not only to database developers and designers, but also to a diverse field of professionals and academics, including database administrators (DBAs), information modelers, database consultants, and more. Virtually everyone who deals with relational databases should have at least a passing understanding of the fundamentals of working with relational models. Author C.J. Date has been involved with the relational model from its earliest days. An exceptionally clear-thinking writer, Date lays out principle and theory in a manner that is easily understood. Few others can speak as authoritatively the topic of relational databases as Date can.
…
Cover unavailable
50
MySQL: The Complete Reference
Vikram Vaswani
4.3
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
Get comprehensive coverage of all the powerful new features of MySQL, one of the fastest--and free--relational databases in use today
Written in conjunction with the MySQL development team, this expert resource covers transactional integrity, disaster recovery, scalability, support for mobile users, Web-based and client/server programming, and much more.
…
Cover unavailable
51
Beginning PHP5, Apache, and MySQL Web Development
Elizabeth Naramore, Jason Gerner, Yann Le Scouarnec, Jeremy Stolz, Michael K. Glass
4.3
This update to a Wrox bestseller dives in and guides the reader through the entire process of creating dynamic, data-driven sites using the open source "AMP" model: Apache Web server, the MySQL database system, and the PHP scripting language. The team of expert authors covers PHP scripting, database management, security, integration, and e-commerce functions and comes complete with a useful syntax reference. Showcases three fully functional Web site examples, with implementations for both Windows and Linux, that readers can incorporate into their own projects Updates include a new chapter on PHP5 features and functions, a new example Web site application, and updates to PHP5 throughout the text
…
Cover unavailable
52
PHP Solutions: Dynamic Web Design Made Easy
David Powers
4.3
Dynamic Web Design Made Easy--that's a pretty bold claim. How easy is easy? It's not like an instant cake mix: just add water and stir. Dynamic web design is--well-- dynamic. Every website is different, so it's impossible to grab a script, paste it into a web page, and expect it to work. Building dynamic sites involves diving into the code and adju- ing it to your own requirements. If that thought makes you break out in a cold sweat, just relax for a moment. PHP is not difficult, and I've written this book very much with the n- programmer in mind. I've done so because I don't come from a computing background myself. In fact, I went to school in the days before pocket calculators were invented, never mind personal computers. As a result, I don't assume that you drank in knowledge of arrays, loops, and conditional statements with your mother's milk. Everything is explained in plain, straightforward l- guage, and I've highlighted points where things may go wrong, with advice on how to solve the problem. At the same time, if you're working with computers and websites, you're bound to have a certain level of technical knowledge and skill. So I don't talk down to you either.
…
Cover unavailable
53
A Guide to SQL
Philip J. Pratt
4.3
A GUIDE TO SQL, Ninth Edition, provides an effective introduction to SQL programming using straightforward instruction, extensive hands-on exercises, and a strong foundation in real-world business applications. The Ninth Edition builds on the longstanding success of this proven text by presenting basic SQL commands in the context of a running case, in which a business uses SQL to manage orders, items, customers, and sales reps. The authors emphasize that fundamental principles and practices apply regardless of the database environment chosen, and they include examples from the latest versions of Oracle and Microsoft Access, and SQL Server throughout the text.
…
Cover unavailable
54
WordPress: The Missing Manual (Missing Manuals)
Matthew MacDonald
4.3
WordPress lets you build everything from a simple blog to a full-blown, dynamic website, but the program's rich feature set can be difficult to master. This jargon-free book walks you through the process of creating your WordPress site, whether you're a beginner launching a blog, a webmaster building a corporate site, or an experienced WordPress user looking for tips, tricks, and additional detail. You'll find lots advice and instructions to guide you everything from creating your first page to ongoing management of your site.
…
Cover unavailable
55
PHP & MySQL: Server-Side Web Development
Jon Duckett
4.3
Learn PHP, the programming language used to build sites like Facebook, Wikipedia and WordPress, then discover how these sites store information in a database (MySQL) and use the database to create the web pages.
This full-color book is packed with inspiring code examples, infographics and photography that not only teach you the PHP language and how to work with databases, but also show you how to build new applications from scratch. It demonstrates practical techniques that you will recognize from popular sites where visitors can:
Register as a member and log in Create articles, posts and profiles that are saved in a database Upload their own images and files Automatically receive email notifications Like and comment on posts. To show you how to apply the skills you learn, you will build a complete content management system, enhanced with features that are commonly seen on social networks.
Written by best-selling HTML & CSS and JavaScript & jQuery author Jon Duckett, this book uses a unique visual approach, with step-by-step instructions, practical code examples and pro tips that will teach you how to build modern database-driven websites using PHP.
…
Cover unavailable
56
MySQL Administrator's Guide and Language Reference
MySQL AB
4.3
Written by the creators of MySQL and edited by one of the most highly respected MySQL authors, the "MySQL Administrator's Guide " "and Language Reference" is the official guide to installing MySQL, to setting up and administering MySQL databases, and to storing and retrieving data in these databases. This new edition combines into one book the "MySQL Language Reference" (on CD) with the practical information of the "MySQL Administrator's Guide" book.
…
Cover unavailable
57
Effective MySQL: Optimizing SQL Statements: Practical Knowledge for Performance Improvement
Ronald Bradford
4.3
The Essential Guide to SQL Statement Optimization Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.
Identify the essential analysis commands for gathering and diagnosing issues Learn how different index theories are applied and represented in MySQL Plan and execute informed SQL optimizations Create MySQL indexes to improve query performance Master the MySQL query execution plan Identify key configuration variables that impact SQL execution and performance Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results Improve index utilization with covering indexes and partial indexes Learn hidden performance tips for improving index efficiency and simplifying SQL statements
…
Cover unavailable
58
Learn MySQL in Plain English: A Beginner's Guide to MySQL
Trevor Page
4.3
Cover unavailable
59
Oracle Database 12c the Complete Reference
Bob Bryla
4.3
An all-new edition of this bestselling Oracle Press book, fully revised and updated for the latest database release, Oracle Database 12"c." "Oracle Database 12c: The Complete Reference" provides thorough coverage of all the changes--major and minor--that have taken place in the four years since the last database release. This Oracle Press guide begins by establishing critical database concepts and covers database architecture, cloud computing, analytic functions, implementing SQL profiles, using SQL plan management, and Java programming in the Oracle environment. You will also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions with cross-referencing of topics. Includes chapters on cloud integration and other cutting-edge features Revised throughout and expanded with new chapters covering topics such as export and import, analytic functions, Object PL/SQL, new tuning features in Oracle Database 12"c," new security measures, and more Popular alphabetic reference is a quick, one-stop shop for major Oracle commands, keywords, features, and functions--with cross-referencing of topics Electronic content includes searchable eBook and all code examples from the book
…
Cover unavailable
60
Beginning PHP and MySQL 5: From Novice to Professional
W Jason Gilmore
4.3
Written for the budding web developer searching for a powerful, low-cost solution for building flexible, dynamic web sites. Essentially three books in one: provides thorough introductions to the PHP language and the MySQL database, and shows you how these two technologies can be effectively integrated to build powerful websites. Provides over 500 code examples, including real-world tasks such as creating an auto-login feature, sending HTML-formatted e-mail, testing password guessability, and uploading files via a web interface. Updated for MySQL 5, includes new chapters introducing triggers, stored procedures, and views.
…
Cover unavailable
61
Php, Mysql, JavaScript & Html5 All-In-One for Dummies
Steve Suehring, Janet Valade
4.2
Get the basics on four key web programming tools in one great book! PHP, JavaScript, and HTML5 are essential programming languages for creating dynamic websites that work with the MySQL database. PHP and MySQL provide a robust, easy-to-learn, open-source solution for creating superb e-commerce sites and content management. JavaScript and HTML5 add support for the most current multimedia effects. This one-stop guide gives you what you need to know about all four! Seven self-contained minibooks cover web technologies, HTML5 and CSS3, PHP programming, MySQL databases, JavaScript, PHP with templates, and web applications.
Addresses how PHP, MySQL, JavaScript, and HTML5 are vital tools for creating dynamic, database-driven websites and are especially important for e-commerce sites Serves as essential reading for web designers who are new to these technologies, offering a crash course covering all of these powerful technologies in this handy volume of seven self-contained minibooks Covers how to program in PHP and how to create and administer a MySQL database as well as how to manipulate MySQL data via a web interface Shows how to create a secure website and how to code popular e-business applications such as login programs and shopping carts With seven books in one, PHP, MySQL, JavaScript & HTML5 All-in-One For Dummies will turn your website into the center of attention in no time at all.
…
Cover unavailable
62
SQL: A Beginner's Guide, Fourth Edition
Andy Oppel
4.2
Cover unavailable
63
Backup & Recovery: Inexpensive Backup Solutions for Open Systems
W. Curtis Preston
4.2
Packed with practical, freely available backup and recovery solutions for Unix, Linux, Windows, and Mac OS X systems -- as well as various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revised and expanded with over 75% new material.
Backup & Recovery starts with a complete overview of backup philosophy and design, including the basic backup utilities of tar, dump, cpio, ntbackup, ditto, and rsync. It then explains several open source backup products that automate backups using those utilities, including AMANDA, Bacula, BackupPC, rdiff-backup, and rsnapshot. Backup & Recovery then explains how to perform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris, VMWare, & Windows systems using freely-available utilities. The book also provides overviews of the current state of the commercial backup software and hardware market, including overviews of CDP, Data De-duplication, D2D2T, and VTL technology. Finally, it covers how to automate the backups of DB2, Exchange, MySQL, Oracle, PostgreSQL, SQL-Server, and Sybase databases - without purchasing a commercial backup product to do so. For environments of all sizes and budgets, this unique book shows you how to ensure data protection without resorting to expensive commercial solutions. You will soon learn to:
Automate the backup of popular databases without a commercial utility Perform bare metal recovery of any popular open systems platform, including your PC or laptop Utilize valuable but often unknown open source backup products Understand the state of commercial backup software, including explanations of CDP and data de-duplication software Access the current state of backup hardware, including Virtual Tape Libraries (VTLs)
…
Cover unavailable
64
Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database
Eric Vanier
4.2
Cover unavailable
65
MySQL Troubleshooting: What To Do When Queries Don't Work
Sveta Smirnova
4.2
Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with MySQL.
Written by a principal technical support engineer at Oracle, MySQL Troubleshootingprovides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence.
Understand the source of a problem, even when the solution is simple Handle problems that occur when applications run in multiple threads Debug and fix problems caused by configuration options Discover how operating system tuning can affect your server Use troubleshooting techniques specific to replication issues Get a reference to additional troubleshooting techniques and tools, including third-party solutions Learn best practices for safe and effective troubleshooting—and for preventing problems
…
Cover unavailable
66
MySQL Management and Administration with Navicat
Gökhan Ozar
4.2
Standard Mini. This book is written for MySQL Users, Developers, and admins who want to discover just how easy Navicat makes even normally arduous tasks.
Cover unavailable
67
MySQL Database Design and Tuning
Robert D Schneider
4.2
The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to:
Deploy the right MySQL product for your performance needs. Set up a performance management and monitoring environment using tools from MySQL. Implement the right indexing strategy Apply good performance strategy when developing software to work with the MySQL database. Configure dozens of variable to correctly tune the MySQL engine. If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.
…
Cover unavailable
68
SQL QuickStart Guide: The Simplified Beginner's Guide to SQL
ClydeBank Technology
4.2
The Ultimate Beginner's Guide To Learning SQL - From Retrieving Data To Creating Databases! *PRINTING ISSUE HAS BEEN CORRECTED*
Structured Query Language or SQL (pronounced sequel by many) is the most widely used programming language used in database management and is the standard language for Relational Database Management Systems (RDBMS). SQL programming allows users to return, analyze, create, manage and delete data within a database - all within a few commands.
With more industries and organizations looking to the power of data, the need for an efficient, scalable solution for data management is required. More often than not, organizations implement a Relational Database Management System in one form or another. These systems create long-term data "warehouses" that can be easily accessed to return and analyze results, such as, "Show me all of the clients from Canada that have purchased more than $20,000 in the last 3 years." This "query," which would have taken an extensive amount of hands-on research to complete prior to the use of database, can now be determined in seconds by executing a simple SELECT SQL statement on a database.
SQL can seem daunting to those with little to zero programming knowledge and can even pose a challenge to those that have experience with other languages. Most resources jump right into the technical jargon and are not suited for someone to really grasp how SQL Actually Works. That's why we created this book. Our goal here is simple: show you exactly everything you need to know to utilize SQL in whatever capacity you may need in simple, easy to follow concepts. Our book provides Multiple Step-by-Step Examples of how to master these SQL concepts to ensure you know what you're doing and why you're doing it every step of the way.
This book will allow you to successfully go from knowing absolutely nothing about SQL to being able to quickly retrieve and analyze data from multiple tables. Step-by-step we will Walk You Through the Fundamentals of Understanding How a Relational Database is Structured to how to execute Complex SELECT Statements to return large datasets from your database.
Here Is A Preview Of What You'll Learn... What are Relational Databases and How are They Structured! Why Knowing SQL Is Important To Almost Any Database! The Fundamentals of SQL Programming Syntax! How To Retrieve Any Type of Data You May Need Within Your Database! The Important Differences in SQL Syntax Across Database Programs! The Top Mistakes to AVOID That Those New To SQL Make! Our Personal Guarantee We are so confident that methods outlined in this book will help you learn SQL that we're willing to let you try the book risk-free. If you are not fully satisfied with the product, simply let us know and we will provide a 100% full refund. That's right, a 100% Money-Back Guarantee! What reason do you have to not give this book a try?
Scroll Up & Click The "Add To Cart" Icon On The Right Side Right Now! ClydeBank Media LLC All Rights Reserved
…
Cover unavailable
69
MySQL Reference Manual
Michael Widenius, David Axmark, et al.
4.2
MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0.
Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL. In addition, you can turn a page and find such unexpected riches as:
A thorough comparison of MySQL with SQL standards and other databases A discussion of privileges and suggested uses of privileges to enhance security Directions for replicating a database and for running several MySQL servers on a single system Directions for initializing a database from a flat file Guidelines for estimating the performance of different queries A far-reaching discussion of optimization, with reference to the implementation of MySQL Investigations of the differences between data types and the pros and cons of each type of number, string, or timestamp An extended inquiry into the effects of using delayed inserts A candid explanation of why various errors occur and how to recover from them Tips for weighted, full-text searches Detailed descriptions of the features, strengths, and weaknesses of available table formats A guide to adding new functions to MySQL No serious MySQL user should be without this book.
…
Cover unavailable
70
The Language of SQL
Larry Rockoff
4.2
The Language of SQL, Second Edition Many SQL texts attempt to serve as an encyclopedic reference on SQL syntax -- an approach that is often counterproductive, because that information is readily available in online references published by the major database vendors. For SQL beginners, it's more important for a book to focus on general concepts and to offer clear explanations and examples of what various SQL statements can accomplish. This is that book. A number of features make The Language of SQL unique among introductory SQL books. First, you will not be required to download software or sit with a computer as you read the text. The intent of this book is to provide examples of SQL usage that can be understood simply by reading. Second, topics are organized in an intuitive and logical sequence. SQL keywords are introduced one at a time, allowing you to grow your understanding as you encounter new terms and concepts. Finally, this book covers the syntax of three widely used databases: Microsoft SQL Server, MySQL, and Oracle. Special "Database Differences" sidebars clearly show you any differences in syntax among these three databases, and instructions are included on how to obtain and install free versions of the databases. This is the only book you need to gain a quick working knowledge of SQL and relational databases. Learn How To... Use SQL to retrieve data from relational databases Apply functions and calculations to data Group and summarize data in a variety of useful ways Use complex logic to retrieve only the data you need Update data and create new tables Design relational databases so that data retrieval is easy and intuitive Use spreadsheets to transform your data into meaningful displays Retrieve data from multiple tables via joins, subqueries, views, and set logic Create, modify, and execute stored procedures Install Microsoft SQL Server, MySQL, or Oracle Contents at a Glance 1 Relational Databases and SQL 2 Basic Data Retrieval 3 Calculated Fields and Aliases 4 Using Functions 5 Sorting Data 6 Selection Criteria 7 Boolean Logic 8 Conditional Logic 9 Summarizing Data 10 Subtotals and Crosstabs 11 Inner Joins 12 Outer Joins 13 Self Joins and Views 14 Subqueries 15 Set Logic 16 Stored Procedures and Parameters 17 Modifying Data 18 Maintaining Tables 19 Principles of Database Design 20 Strategies for Displaying Data A Getting Started with Microsoft SQL Server B Getting Started with MySQL C Getting Started with Oracle
…
Cover unavailable
71
Build Your Own Database Driven Website Using PHP & MySQL
Kevin Yank
4.2
Build Your Own Database-Driven Website Using PHP & MySQL is a practical guide for first-time users of PHP & MySQL that teaches readers by creating a fully working Content Management System, Shopping Cart and other real-world applications. There has been a marked increase in the adoption of PHP, most notably in the beginning to intermediate levels. PHP now boasts over 30% of the server side scripting market (Source: php.weblogs.com).
The previous edition sold over 17,000 copies exclusively through Sitepoint.com alone. With the release of PHP 5, SitePoint have updated this bestseller to reflect best practice web development using PHP 5 and MySQL 4.
The 3rd Edition includes more code examples and also a new bonus chapter on structured PHP Programming which introduces techniques for organizing real world PHP applications to avoid code duplication and ensure code is manageable and maintainable. The chapter introduces features like include files, user-defined function libraries and constants, which are combined to produce a fully functional access control system suitable for use on any PHP Website.
…
Cover unavailable
72
SQL for MySQL Developers: A Comprehensive Tutorial and Reference: A Comprehensive Tutorial and Reference
Rick F. van der Lans
4.2
This book describes MYSQL's SQL dialect. It teaches how and why to use certain features of the language. Not only the classic features of SQL are described, but also the more advanced features. Every aspect of the language is discussed thoroughly and critically. The following aspects of SQL, among other things, are covered: Querying and updating data (joins, functions, and subqueries), creating tables, specifying primary and foreign keys and other constraints, using indexes, data security, developing stored procedures and triggers. Application development with PHP and Python, transactions, optimization of statements, is also discussed. Many users of MySQL have only very limited knowledge of SQL and would be significantly more productive if they had a better understanding of SQL. Others know SQL, but are unfamiliar with the idiosyncracies of MySQL's SQL implementation. In either case, this is the book for them. The exercises are a key benefit for readers familiar with other SQL variants. The structure, style and approach of this book is based on van der Lans best-selling Introduction to SQL (published by Addison-Wesley since 1987). This book is still being used at many universities, and is now in a fourth edition. And that structure and approach have therefore been tested over and over again.
…
Cover unavailable
73
OCA Oracle Database 12c Installation and Administration Exam Guide (Exam 1Z0-062) (Oracle Press)
John Watson
4.2
A Complete Study System for OCA Exam 1Z0-062
Prepare for the Oracle Certified Associate Oracle Database 12c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including:
Installing and upgrading Oracle Database software Managing the database instance Configuring the Oracle network environment Managing database storage structures Administering user security Managing undo data and data concurrency Implementing Oracle Database auditing Performing database maintenance Managing performance and tuning SQL Managing resources using Oracle Database Resource Manager Automating tasks Moving data Performing backup and recovery Installing Oracle Grid Infrastructure for a standalone server
Electronic content includes:
185+ practice exam questions with detailed answers and explanations Test engine that provides custom exams by chapter or by domain PDF copy of the book
…
Cover unavailable
74
PHP, MySQL and Apache (Sams Teach Yourself)
Julie C. Meloni
4.2
A new edition of this title is available, ISBN-10: 067232976X ISBN-13: 9780672329760
You own your own business. You have also created a website for your business that details the products or services that you offer, but it doesn't allow potential customers to purchase anything online. Don't risk losing business-learn to create a dynamic online environment using only three programs. PHP, MySQL and Apache are three popular open-source tools that can work together to help you create a dynamic website, such as an online shopping experience. Sams Teach Yourself PHP, MySQL and Apache All in One is a complete reference manual for all three development tools. You will learn how to install, configure and set up the PHP scripting language, use the MySQL database system, and work with the Apache Web server. Then you'll take it a step further and discover how they work together to create a dynamic website. Use the book and the included CD to create a simple website, as well as a mailing list, online address book, shopping cart and storefront. Updated to reflect the most recent developments in PHP and MySQL, including the final stable release of MySQL 5.0, you will open your website to limitless possibilities with Sams Teach Yourself PHP, MySQL and Apache All in One.
…
Cover unavailable
75
Learning PHP 5
David Sklar
4.2
PHP has gained a following among non-technical web designers who need to add interactive aspects to their sites. Offering a gentle learning curve, PHP is an accessible yet powerful language for creating dynamic web pages. As its popularity has grown, PHP's basic feature set has become increasingly more sophisticated. Now PHP 5 boasts advanced features--such as new object-oriented capabilities and support for XML and Web Services--that will please even the most experienced web professionals while still remaining user-friendly enough for those with a lower tolerance for technical jargon.
If you've wanted to try your hand at PHP but haven't known where to start, then Learning PHP 5 is the book you need. If you've wanted to try your hand at PHP but haven't known where to start, then Learning PHP 5 is the book you need. With attention to both PHP 4 and the new PHP version 5, it provides everything from a explanation of how PHP works with your web server and web browser to the ins and outs of working with databases and HTML forms. Written by the co-author of the popular PHP Cookbook, this book is for intelligent (but not necessarily highly-technical) readers. Learning PHP 5 guides you through every aspect of the language you'll need to master for professional web programming results. This book provides a hands-on learning experience complete with exercises to make sure the lessons stick.
Learning PHP 5 covers the following topics, and more:
How PHP works with your web browser and web server PHP language basics, including data, variables, logic and looping Working with arrays and functions Making web forms Working with databases like MySQL Remembering users with sessions Parsing and generating XML Debugging Written by David Sklar, coauthor of the PHP Cookbook and an instructor in PHP, this book offers the ideal classroom learning experience whether you're in a classroom or on your own. From learning how to install PHP to designing database-backed web applications, Learning PHP 5 will guide you through every aspect of the language you'll need to master to achieve professional web programming results.
…
Cover unavailable
76
A Guide to MySQL
Philip J. Pratt and Mary Z. Last
4.2
The MySQL database has become the world's most popular open source database because of its consistent fast performance, high reliability, and ease of use. That's why best-selling authors Phil Pratt and Mary Last are pleased to introduce their latest database textbook - A Guide to MySQL. This straightforward text utilizes three case databases - Premiere Products, Henry Books, and Alexamara Marina Group - to teach the concepts and techniques of using MySQL. Your students will gain the skills to build professional quality MySQL databases, thanks to this real-world approach. Additional hands-on exercises at the end of each chapter offer students the opportunity to problem-solve based on what they've previously learned.
…
Cover unavailable
77
MySQL in a Nutshell
Russell J. T. Dyer
4.2
MySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With "MySQL in a Nutshell" by your keyboard, you can drill down into the full depth of MySQL's capabilities quickly and easily.
"MySQL in a Nutshell" is the indispensable desktop reference to all MySQL functions. Programming language APIs for PHP, Perl, and C are covered, as well as all the popular MySQL utilities.
This invaluable resource clearly documents the details that experienced users need to take full advantage of this powerful database management system. Better yet, this wealth of information is packed into the concise, comprehensive, and extraordinarily easy-to-use format for which the in a Nutshell guides are renowned.
In addition to providing a thorough reference to MySQL statements and functions, the administrative utilities, and the most popular APIs, "MySQL in a Nutshell" includes several tutorial chapters to help newcomers get started. Moreover, each chapter covering an API begins with a brief tutorial so that, regardless of your level of experience in any given area, you will be able to understand and master unfamiliar territory.
"MySQL in a Nutshell" distills all the vital MySQL details you need on a daily basis into one convenient, well-organized book. It will save you hundreds of hours of tedious research or trial and error and put the facts you need to truly tap MySQL's capabilities at your fingertips.
…
Cover unavailable
78
MySQL Language Reference
MySQL AB
4.1
With more than 4 million active installations, MySQL is the world's most popular open-source database.
Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases.
The "MySQL Language Reference" is the only official guide to the MySQL language and programming APIs.
Written by the creators of MySQL, and edited by the highly respected MySQL authors, the "MySQL Language Reference" is designed for database administrators and programmers who need a reliable, detailed reference to every part of the MySQL language and all the available APIs.
…
Cover unavailable
79
A Practical Guide to Fedora and Red Hat Enterprise Linux
Mark G. Sobell
4.1
I have found this book to be a very useful classroom text, as well as a great Linux resource. It teaches Linux using a ground-up approach that gives students the chance to progress with their skills and grow into the Linux world. I have often pointed to this book when asked to recommend a solid Linux reference." "-- Eric Hartwell, Chair, School of Information Technology, ITT Technical Institute"Master All the Techniques You Need to Succeed with Fedora(TM) or Red Hat(R) Enterprise Linux(R) The #1 Fedora and RHEL resource--a tutorial AND on-the-job reference Master Linux administration and security using the command line, GUI tools, Python, systemd, and firewalld Set up key Internet servers, step by step, including Samba, Apache, MariaDB/MySQL, sendmail, OpenSSH, DNS, LDAP, and more Brand-new chapter on Virtual Machines and Cloud Computing! In this comprehensive guide, one of the world's leading Linux experts brings together all the knowledge and real-world insights you need to master and succeed with today's versions of Fedora or Red Hat Enterprise Linux. Best-selling author Mark Sobell explains Linux clearly and effectively, focusing on skills you'll actually need as a user, programmer, or administrator. Sobell assumes no prior Linux knowledge. He starts at the beginning and walks you through every topic and task that matters, using easy-to-understand examples. Step by step, you'll learn how to install and configure Linux from the accompanying DVD, navigate its graphical user interface, provide file/printer sharing, configure network servers, secure Linux desktops and networks, work with the command line, administer Linux efficiently, and automate administration using Python and bash. Mark Sobell has taught hundreds of thousands of Linux and UNIX professionals. He knows every Linux nook and cranny--and he never forgets what it's like to be new to Linux. Whatever you want to do with Linux--now or in the future--you'll find it in this book. Compared with other Linux books, "A Practical Guide to Fedora(TM)and Red Hat(R)Enterprise Linux (R), Seventh Edition, " delivers Complete, up-to-the-minute coverage of Fedora 19 and RHEL 7 (beta) New programming chapters that cover Python and MariaDB/MySQL, plus a new tutorial on using GnuPG to encrypt communications Information on state-of-the-art security: SELinux, ACLs, firewalld (firewall-config and firewall-cmd), iptables (system-config-firewall), GnuPG, and OpenSSH New chapter on VMs (virtual machines) and cloud computing, including VMware, QEMU/KVM, virt-manager, virsh, GNOME Boxes, and AWS (Amazon Web Services) Expanded command-line coverage, including a new chapter that details 32 important utilities Practical information on Internet server configuration, including Apache, sendmail, NFSv4, DNS/BIND, the new LDAP Dynamic Server, and IPv6 Complete "meat-and-potatoes" information on system/network administration, now including GRUB 2, the XFS filesystem, the new Anaconda Installer, the systemd init daemon, firewalld, and NetworkManager Detailed instructions on keeping Linux systems up to date, finding software packages, and working with repositories using yum and rpm Full coverage of the LPI Linux Essentials exam objectives plus extensive coverage of the CompTIA Linux+ exam objectives; Appendix E provides a map from objectives to pages in the book New coverage of find, sort, xz (compression), free, xargs, and the nano editor And much more, including a 500+ term glossary and comprehensive indexes "Includes DVD! Get the full version of the Fedora 19 release!
…
Cover unavailable
80
Learning Python, Java, JavaScript, C, C++, C#, CSS, HTML, jQuery, MySQL, SQL, LINUX, Perl, PHP or XML: Quick web links to FREE 300+ textbooks, 100+ cheat sheets, 100+ video tutorials and More!
Dr. Web Links
4.1
Cover unavailable
81
MySQL Admin Cookbook
Daniel Schneller, Udo Schwedt
4.1
This book uses the approach of a cookbook, presenting solutions to problems in the form of recipes. Each recipe provides the reader with easy step-by-step descriptions of the actions necessary to accomplish a specific task. Example values and code samples are used throughout the recipes, which makes adaptation for individual needs easy Administrators of all skill-levels will find step-by-step instructions for practical approaches to MySQL configuration, maintenance, and optimization topics. Each recipe uses a concrete example for easy understanding. This book is for ambitious MySQL users as well as professional data center database administrators. Beginners as well as experienced administrators will profit from this cookbook and get fresh ideas to improve their MySQL environments. Detailed background information will enable them to widen their MySQL horizon. It does not cover SQL basics, how to install MySQL servers, or how to design a relational database schema. Readers are expected to have a basic understanding of the SQL language and database concepts in general.
…
Cover unavailable
82
Learn SQL by Examples: Examples of SQL Queries and Stored Procedures for MySQL and Oracle
Sergey Skudaev
4.1
Any developer coding in any computer language must know SQL (Structured Query Language). SQL is used to manipulate data in a relational database. In my tutorial I provide more than a hundred examples of SQL queries for MySQL, Oracle and MS Access databases. The book includes CREATE TABLE statements and INSERT statements with the same data as I am using in the book. You will be able to recreate all required tables on your PC to practice SQL with my tutorial. Or you may use my web page. This book includes homework with 40 questions and answers.
…
Cover unavailable
83
Managing & Using MySQL: Open Source SQL Databases for Managing Information & Web Sites
Tim King, George Reese, Randy Yarger, Hugh E. Williams, Randy Jay Yarger
4.1
MySQL is a popular and robust open source database product that supports key subsets of SQL on both Linux and Unix systems. MySQL is free for nonprofit use and costs a small amount for commercial use. Unlike commercial databases, MySQL is affordable and easy to use. This book includes introductions to SQL and to relational database theory. If you plan to use MySQL to build web sites or other Linux or Unix applications, this book teaches you to do that, and it will remain useful as a reference once you understand the basics. Ample tutorial material and examples are included throughout.
This book has all you need to take full advantage of this powerful database management system. It takes you through the whole process from installation and configuration to programming interfaces and database administration. This second edition has a greatly enhanced administration chapter that includes information on administrative tools, server configuration, server startup and shutdown, log file management, database backup and restore, and database administration and repair. In addition, a new chapter on security describes data, server, and client-server security, while a chapter on extending MySQL provides an overview of MySQL internals and describes the use of MySQL user-defined functions.
If you know C/C++, Java, Perl, PHP, or Python, you can write programs to interact with your MySQL database. In addition, you can embed queries and updates directly in an HTML file so that a web page becomes its own interface to the database. Managing and Using MySQL includes chapters on the programming language interfaces, and it also includes a complete reference section with specific function calls for each language.
Also included in the reference section are references to the SQL language, and details of the MySQL system variables, programs, and utilities. New to the second edition is a reference to the internal MySQL tables, which will be of particular interest to those who want to work extensively with MySQL security.
…
Cover unavailable
84
MySQL and JSON: A Practical Programming Guide
David Stokes
4.1
Cover unavailable
85
OCA Oracle Database 12c SQL Fundamentals I Exam Guide (Exam 1Z0-061) (Oracle Press)
Roopesh Ramklass
4.1
Cover unavailable
86
Pro Python System Administration
Rytis Sileika
4.1
As time goes on, system administrators are presented with increasingly complicated challenges. In the early days, a team of engineers might have had to look after one or two systems. These days, one engineer can administer hundreds or thousands of systems.
System administrators are gradually replacing their tools with more advanced and flexible ones. One of the choices is Python. Structurally, Python is a modern, high-level language with a very clean syntax. Python comes with many built-in libraries that can make automation tasks easier. It also has extensive set of third-party libraries and a very active development community. This flexibility makes Python a good choice for a wide variety of tasks, from prototyping science applications to system maintenance and administration jobs.
This book explains and shows how to apply Python scripting in practice. Unlike the majority of the Python books, it will show you how to approach and resolve real-world issues that most system administrators will come across in their careers. In this book, you will find several projects in the categories of network administration, web server administration, and monitoring and database management. In each project, we will define the problem, design the solution, and go through the more interesting implementation steps. Each project is accompanied with the source code of a fully working prototype, which you'll be able to use immediately or adapt to your requirements and environment.
…
Cover unavailable
87
Learning Node.js: A Hands-On Guide to Building Web Applications in JavaScript
Marc Wandschneider
4.1
Learning Node.jsA Hands-On Guide to Building Web Applications in JavaScript
Node.js makes it far easier to create fast, compact, and reliable web/network applications and web servers, and is rapidly becoming indispensable to modern web developers. Learning Node.js brings together the knowledge and JavaScript code you need to build master the Node.js platform and build server-side applications with extraordinary speed and scalability. You ll start by installing and running Node.js, understanding the extensions it uses, and quickly writing your first app. Next, building on the basics, you ll write more capable application servers and extend them with today s most powerful Node.js tools and modules. Finally, you ll discover today s best practices for testing, running Node.js code on production servers, and writing command-line utilities. Throughout the book, author Marc Wandschneider teaches by walking you line-by-line through carefully crafted examples, demonstrating proven techniques for creating highly efficient applications and servers. Build Node.js solutions that leverage your current JavaScript skills Master Node.js nonblocking IO and async programming Handle more requests and increase your application s flexibility Use and write your own modules Perform common JSON/web server tasks Use browsers to generate pages on the fly via Ajax calls and template libraries Simplify development with the express framework Create database back-ends using popular NoSQL and relational databases Deploy and run Node.js apps on Unix/OS X or Windows servers Take advantage of multiprocessor hardware Support virtual hosts and SSL/HTTPS security Test Node.js programs that mix synchronous, async, and RESTful server API functionality "
…
Cover unavailable
88
MySQL: MySQL Tutorials for Beginners Basic to Advanced MySQL Languages
Dennis Hutten
4.1
Cover unavailable
89
Learning PHP & MySQL
Michele E. Davis
4.1
PHP and MySQL are quickly becoming the de facto standard for rapid development of dynamic, database-driven web sites. This book is perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books. With concepts explained in plain English, the new edition starts with the basics of the PHP language, and explains how to work with MySQL, the popular open source database. You then learn how to put the two together to generate dynamic content.
If you come from a web design or graphics design background and know your way around HTML, Learning PHP & MySQL is the book you've been looking for. The content includes:
PHP basics such as strings and arrays, and pattern matching A detailed discussion of the variances in different PHP versions MySQL data fundamentals like tables and statements Information on SQL data access for language A new chapter on XHTML Error handling, security, HTTP authentication, and more Learning PHP & MySQL explains everything from fundamental concepts to the nuts and bolts of performing specific tasks. As part of O'Reilly's bestselling Learning series, the book is an easy-to-use resource designed specifically for beginners. It's a launching pad for future learning, providing you with a solid foundation for more advanced development.
…
Cover unavailable
90
MySQL and mSQL
Tim King, George Reese, Randy Yarger
4.1
MySQL and mSQL are popular and robust database products that support key subsets of SQL on both Linux and Unix systems. Both products are free for nonprofit use and cost a small amount for commercial use.
Even a small organization or web site has uses for a database. Perhaps you keep track of all your customers and find that your information is outgrowing the crude, flat-file format you started with. Or you want to ask your web site's visitors for their interests and preferences and put up a fresh web page that tallies the results.
Unlike commercial databases, MySQL and mSQL are affordable and easy to use. If you know basic C, Java, Perl, or Python, you can quickly write a program to interact with your database. In addition, you can embed queries and updates right in an HTML file so that a web page becomes its own interface to the database.
This book is all you need to make use of MySQL or mSQL. It takes you through the whole process from installation and configuration to programming interfaces and basic administration. Includes reference chapters and ample tutorial material.
Topics include:
Introductions to simple database design and SQL Building, installation, and configuration Basic programming APIs for C, C++, Java (JDBC), Perl, and Python CGI programming with databases in C and Perl Web interfaces: PHP, W3-mSQL, Lite, and mSQLPerl
…
Cover unavailable
91
WordPress Web Design for Dummies
Lisa Sabin-Wilson
4.0
Learn how WordPress can help you create a unique, customized Web site Once only a platform for bloggers, WordPress is gaining popularity as a tool for creating individualized Web sites. WordPress expert Lisa Sabin-Wilson makes it easy for anyone with a basic knowledge of the WordPress software to create a custom site using complimentary technologies including CSS, HTML, and PHP. This easy-to-follow, full-color guide helps you identify the tools and technologies you need to create the site you envision, build a user-friendly navigation system, select colors and layouts, work with existing WordPress themes, and even develop your own theme to personalize your site.
WordPress offers a versatile tool for building customized Web sites; this full-color book walks you through the process, explains the complimentary technologies involved, and shows you how to select colors, fonts, and themes Case studies illustrate the process and the effects that can be achieved Shows how to incorporate WordPress templates, graphic design principles, HTML, CSS, and PHP to build a truly one-of-a-kind Web site If you know how to use WordPress software to create a blog, WordPress Web Design For Dummies will enable you to quickly and easily construct a unique Web site for your business, organization, or personal use.
…
Cover unavailable
92
Understanding MySQL Internals
Sasha Pachev
4.0
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev -- a former member of the MySQL Development Team -- provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more.
The core of Understanding MySQL Internals begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover:
Core server classes, structures, and API The communication protocol between the client and the server Configuration variables, the controls of the server; includes a tutorial on how to add your own Thread-based request handling -- understanding threads and how they are used in MySQL An overview of MySQL storage engines The storage engine interface for integrating third-party storage engines The table lock manager The parser and optimizer for improving MySQL's performance Integrating a transactional storage engine into MySQL The internals of replication
Understanding MySQL Internals provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.
…
Cover unavailable
93
Developing a Java Web Application in a Day: Step by step explanations with Eclipse, Tomcat and MySQL - A complete Java Project with Source Code (Java Web Programming Book 2)
Luciano Manelli
4.0
Cover unavailable
94
PHP & MySQL in easy steps: Covers MySQL 8.0
Mike McGrath
4.0
PHP & MySQL in Easy Steps
Cover unavailable
95
The MySQL Workshop: A New, Interactive Approach to Learning MySQL
Thomas Pettit and Daniël van Eeden
4.0
Cover unavailable
96
The Definitive Guide to MySQL 5
Michael Kofler
4.0
MySQL 5 is slated to be the most significant release in the products history. The Definitive Guide to MySQL 5, Third Edition is the newest revision of Michael Koflers popular book. This is the first book to offer in-depth instruction about the new features of the world's most popular open source database server. Updated to reflect changes in MySQL version 5, this book will expose you to MySQL's impressive array of new features: views, stored procedures, triggers, and spatial data types.
Whether you're a novice or intermediate user, you will benefit from extensive coverage of core MySQL features like user administration, basic and advanced querying, and security. You will also be introduced to several standard and third-party tools, like MySQL Administrator, Query Browser, and the popular PHPMyAdmin tool.
…
Cover unavailable
97
Oracle Database 12c Pl/SQL Programming
Michael McLaughlin
4.0
Master Oracle Database 12c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide.
Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries
…
Cover unavailable
98
SQL: Beginner's Guide to Learn SQL for Database and Data Analysis (with MySQL) Quickly with a Hands-On Project
1
