Murach s MySQL

Author: Joel Murach
Publisher: Mike Murach & Associates Incorporated
ISBN: 1890774820
Release Date: 2015-03
Genre: Computers

This how-to guide to MySQL is perfect for beginning programmers or experienced developers. It shows how to code all the essential SQL statements for working with a MySQL database. It shows how to design a database, including how to use MySQL Workbench to create an EER model. It shows how to take advantage of relatively new MySQL features such as foreign keys, transactions, stored procedures, stored functions, and triggers. And it presents a starting set of skills for a database administrator (DBA). A must-have for anyone who works with MySQL.

Murach s PHP and MySQL

Author: Joel Murach
Publisher: Mike Murach & Associates
ISBN: 1890774790
Release Date: 2014-12-01
Genre: Computers

PHP and MySQL are two of today's most popular, open-source tools for server-side programming. That means there's a continuing demand for web developers who know how to use PHP and MySQL at the professional level. And with this book, you can become one of them! In fact, in just the first 6 chapters, you will create a database-driven website that implements the MVC pattern, the way the best professionals do. Then, the rest of the book lets you build on that base to develop a full set of professional skills.

Murach s Android Programming 2nd Edition

Author: Joel Murach
Publisher: Mike Murach & Associates
ISBN: 1890774936
Release Date: 2015-12
Genre:

This book teaches anyone with a basic understanding of Java how to develop Android apps at a professional level, using Android Studio. To start, it shows how to use Android Studio to code, test, and debug a Tip Calculator app for a smartphone or tablet. Then, it expands upon this app to show must-have Android skills such as working with layouts, widgets, events, themes, styles, menus, preferences, and fragments. Next, this book presents two more apps that illustrate Android skills you'll use every day, such as working with threads, files, adapters, intents, services, notifications, broadcast receivers, SQLite databases, content providers, and app widgets. Finally, this book presents an app that uses the Google Maps API and shows you how to submit your finished apps to the Google Play store. The real-world apps let you see how the skills you're learning work together, and they illustrate how and when you'd use each skill.

MySQL Cookbook

Author: Paul DuBois
Publisher: "O'Reilly Media, Inc."
ISBN: 9781449374150
Release Date: 2014-07-28
Genre: Computers

MySQL’s popularity has brought a flood of questions about how to solve specific problems, and that’s where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don’t have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you’ll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration

Expert MySQL

Author: Charles Bell
Publisher: Apress
ISBN: 9781430246602
Release Date: 2013-02-03
Genre: Computers

Expert MySQL is the leading reference for learning, understanding, and extending the MySQL server. It unlocks the full promise of open source by showing how to modify the code, create your own storage engine, build your own authentication plugins, and even add your own functions and commands to the SQL language. No other book provides the level of detail or the extensive examples of the inner workings of MySQL that have taken engineers years to master. Expert MySQL is a must have book for all systems integrators, engineers, and software developers working with the MySQL server code. Expert MySQL is also a wealth of information on key aspects of MySQL internals. You’ll learn about internal query representation, how the optimizer creates execution plans, and how to exert control over those plans for optimal performance in your environment. You'll even learn to build your own query optimizer, giving insight that can help you understand and resolve tough performance problems. High-availability and replication are also covered, making Expert MySQL a must-have book for anyone doing high-end work involving MySQL. Shows how to customize MySQL and its storage and authentication engines Provides in-depth knowledge of internals for use in query tuning and performance troubleshooting Covers high-end features such as high-availability and replication

Murach s Java Programming

Author: Joel Murach
Publisher: Mike Murach and Associates, Incorporated
ISBN: 1943872074
Release Date: 2017-06-22
Genre: Computers

This is the 5th edition of Murach's classic Java book that's trained thousands of developers in the last 15 years. Now fully updated to Java 9, this book helps any programmer learn Java faster and better than ever before: [[It's the one Java book that presents object-oriented features like inheritance, interfaces, and polymorphism in a way that's both understandable and useful in the real world. [[It offers new coverage of JavaFX, the date/time API, lambdas, and working with SQLite databases. [[It uses a self-paced approach that works whether you're a beginner or have years of programming experience. [[It's full of practical coding examples that enhance training and that provide starting code for new applications. [[It lets you practice what you've just learned at the end of every chapter, to solidify your skills. [[And it's all done in the distinctive Murach style that has been training professional programmers for more than 43 years.

MySQL in a Nutshell

Author: Russell J.T. Dyer
Publisher: "O'Reilly Media, Inc."
ISBN: 1449379370
Release Date: 2008-04-15
Genre: Computers

When you need to find the right SQL keyword or MySQL client command-line option right away, turn to this convenient reference, known for the same speed and flexibility as the system it covers so thoroughly. MySQL is packed with so many capabilities that the odds of remembering a particular function or statement at the right moment are pretty slim. With MySQL in a Nutshell, you get the details you need, day in and day out, in one concise and extremely well organized book. The new edition contains all the commands and programming information for version 5.1, including new features and language interfaces. It's ideal for anyone using MySQL, from novices who need to get up to speed to advanced users who want a handy reference. Like all O'Reilly Nutshell references, it's easy to use and highly authoritative, written by the editor of the MySQL Knowledge Base at MySQL AB, the creator and owner of MySQL. Inside, you'll find: A thorough reference to MySQL statements, functions, and administrative utilities Several tutorial chapters to help newcomers get started Programming language APIs for PHP, Perl, and C Brief tutorials at the beginning of each API chapter to help anyone, regardless of experience level, understand and master unfamiliar territory New chapters on replication, triggers, and stored procedures Plenty of new examples of how MySQL is used in practice Useful tips to help you get through the most difficult subjects Whether you employ MySQL in a mission-critical, heavy-use environment or for applications that are more modest, this book puts a wealth of easy-to-find information at your fingertips, saving you hundreds of hours of trial and error and tedious online searching. If you're ready to take advantage of everything MySQL has to offer, MySQL in a Nutshell has precisely what it takes.

Learning MySQL

Author: Seyed Tahaghoghi
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596008642
Release Date: 2007-11-28
Genre: Computers

Presents instructions on using MySQL, covering such topics as installation, querying, user management, security, and backups and recovery.

MySQL

Author: Matthew Stucky
Publisher: Sams Publishing
ISBN: 073571049X
Release Date: 2001
Genre: Computers

In MySQL, Paul DuBois provides you with a comprehensive guide to one of the most popular relational database systems. Paul has contributed to the online documentation for MySQL, and is an active member of the MySQL community. The principal MySQL developer, Monty Widenius, and a network of his fellow developers reviewed the manuscript, providing Paul with the kind of insight no one else could supply. Instead of merely giving you a general overview of MySQL, Paul teaches you how to make the most of its capabilities. Through two sample database applications that run throughout the book, he gives you solutions to problems you're sure to face. He helps you integrate MySQL efficiently with third-party tools, such as PHP and Perl, enabling you to generate dynamic Web pages through database queries. He teaches you to write programs that access MySQL databases, and also provides a comprehensive set of references to column types, operators, functions, SQL syntax, MySQL programming, C API, Perl DBI, and PHP API. MySQL simply gives you the kind of information you won't find anywhere else.

PHP Programming with MySQL The Web Technologies Series

Author: Don Gosselin
Publisher: Cengage Learning
ISBN: 9780538745840
Release Date: 2010-01-06
Genre: Computers

This book covers the basics of PHP and MySQL along with introductions to advanced topics including object-oriented programming and how to build Web sites that incorporate authentication and security. After you complete this course, you will be able to use PHP and MySQL to build professional quality, database-driven Web sites. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Murach s JavaScript

Author: Mary Delamater
Publisher: Mike Murach & Associates
ISBN: 1890774855
Release Date: 2015-10-01
Genre: Computers

Today, JavaScript is used in 89.9% of all websites, including the most heavily-trafficked sites like Google, Facebook, YouTube, and Amazon. That is why every web developer should know how to use JavaScript. The problem is that JavaScript is surprisingly difficult to learn, not only for programming novices but also for experienced programmers. But now, Murachs JavaScript makes it easier than ever to become an accomplished JavaScript programmer. To make that possible, section 1 of this book presents a six-chapter course in JavaScript that gets you off to a great start. This section works for programming novices as well as experienced programmers because it lets you set your own pace. When you finish this section, you will be able to write, test and debug JavaScript applications of your own. Then, section 2 builds on that base by presenting the additional skills that every JavaScript programmer must have. That includes working with arrays and web storage, creating and using your own object types in object-oriented applications, using regular expressions for data validation, and much more. For many developers, sections 1 and 2 will be all that they need to know. But for those who want to move on to the expert level, section 3 presents the skills that will get you there. That includes skills like how to bulletproof your applications by using closures, namespaces, and modules; how to make your functions more useful by using callbacks; and how to use JSON to transmit and store data. Then, the last chapter in this section introduces you to jQuery and shows you how it can make your JavaScript code even better.

Murach s Java Servlets and JSP

Author: Joel Murach
Publisher: Mike Murach & Associates Incorporated
ISBN: 1890774782
Release Date: 2014-06-01
Genre: Computers

Provides information on using servlets and JavaServer Pages to create Web applications that use the MVC pattern.

MySQL PHP Database Applications

Author: Jay Greenspan
Publisher: Wiley
ISBN: 0764535374
Release Date: 2001-01-29
Genre: Computers

More businesses and ambitious individuals are trying to bring applications to the Web but they are bewildered with the array of components and concepts needed to create a data-driven site. The cost, stability and ease of development using the Open Source PHP 4 scripting language and a MySQL database makes this combination the best choice for small and mid-size Web-based applications. PHP4/MySQL Database Applications demonstrates web-application development by presenting seven real, ready-to-use examples starting with a simple guess book and ending with a fully-functional e-commerce site with a shopping cart. Inexperienced users will learn the essentials of working with PHP4 and MySQL so they can start building and customizing database applications for the web right away!

Effortless E Commerce with PHP and MySQL

Author: Larry Ullman
Publisher: New Riders
ISBN: 9780133519297
Release Date: 2013-11-12
Genre: Computers

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