MySQL Administrator's Bible


Book Description

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.




Fedora 10 and Red Hat Enterprise Linux Bible


Book Description

As a market-leading, free, open-source Linux operating system (OS), Fedora 10 is implemented in Red Hat Enterprise Linux and serves as an excellent OS for those who want more frequent updates. Bestselling author Christopher Negus offers an ideal companion resource for both new and advanced Linux users. He presents clear, thorough instructions so you can learn how to make Linux installation simple and painless, take advantage of the desktop interface, and use the Linux shell, file system, and text editor. He also describes key system administration skills, including setting up users, automating system tasks, backing up and restoring files, and understanding the latest security issues and threats. Included is both a DVD distribution of Fedora Linux 10 and a bootable Fedora LiveCD. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




MySQL Bible


Book Description

Organization: The book is divided into five parts: Getting Starated with MySQL and Relational Databases; Understanding SQL Through MySQL; MySQL Administration; MySQL Developer Guide; and Advanced and Specialized MySQL Topics. Comprehensive coverage: This Bible covers both beginning-level and advanced topics. Topics covered include: introduction to relational database management; installing and configuring MySQL on the Linux, Windows 2000, and Mac OS X operating systems; MySQL security; debugging and repairing MySQL databases and servers; MySQL performance tuning; and developing MySQL applications with Perl and PHP. Coverage of NuSphere MySQL: Due to the growing popularity of the NuSphere MySQL package, this book covers its enhancements and how to install and develop with NuSphere MySQL. Running database application: This book builds an e-commerce sample database application throughout to demonstrate concepts and topics. ABOUT THE CD-ROM: What's on the CD-ROM: The CD-ROM includes the latest version of MySQL (either Version 4.0 or 4.1); sample database application and code in the book; and PHP and Perl.




Information Technology


Book Description

Information Technology: An Introduction for Today’s Digital World introduces undergraduate students to a wide variety of concepts they will encounter throughout their IT studies and careers. The book covers computer organization and hardware, Windows and Linux operating systems, system administration duties, scripting, computer networks, regular expressions, binary numbers, the Bash shell in Linux, DOS, managing processes and services, and computer security. It also gives students insight on IT-related careers, such as network and web administration, computer forensics, web development, and software engineering. Suitable for any introductory IT course, this classroom-tested text presents many of the topics recommended by the ACM Special Interest Group on IT Education (SIGITE). It offers a far more detailed examination of the computer than current computer literacy texts, focusing on concepts essential to all IT professionals—from operating systems and hardware to information security and computer ethics. The book highlights Windows/DOS and Linux with numerous examples of issuing commands and controlling the operating systems. It also provides details on hardware, programming, and computer networks. Ancillary Resources The book includes laboratory exercises and some of the figures from the text online. PowerPoint lecture slides, answers to exercises, and a test bank are also available for instructors.




Mac Security Bible


Book Description

Your essential, no-holds-barred guide to Mac security threats and solutions Myth number one: Macs are safer than PCs. Not really, says author Joe Kissell, named one of MacTech's "25 Most Influential People" in the Mac community for 2008. In this timely guide, he not only takes you beyond the myths, he also delves into the nitty-gritty of each potential threat, helping you weigh the pros and cons of the solutions you might choose. Learn to measure risk versus inconvenience, make informed decisions, and protect your Mac computers, your privacy, and your data with this essential guide. Explains the security threats to Macs, including data in transit from your e-mail or network, and malware such as viruses, worms, and Trojan horses; these threats, formerly the exclusive worry of PC users, now increasingly threaten Macs Explores physical security and hardware barriers, software settings, third-party solutions, and more Shows Mac OS X users how to develop and enforce security policies Covers security for Windows running on a Mac with Boot Camp, virtualization software such as Parallels Desktop or VMware Fusion, and more Learn the full range of options you need to consider to make your Mac safe. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.




MySQL Cookbook


Book Description

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




MySQL Administrator's Guide


Book Description

If you are not already one of the 4 million plus users of the MySQL database, you will want to become one after reading this book. MySQL Administrator's Guide is the official guide to installing, administering and working with MySQL 5.0 and MySQL databases. Starting with the basics, you will learn to store, manage and retrieve data in a MySQL database and to eventually manipulate the code behind MySQL 5.0 to customize your database. With the clear examples and tips provided in this comprehensive learning guide, you can become a MySQL expert in no time.




Linux Command Line and Shell Scripting Bible


Book Description

Talk directly to your system for a faster workflow with automation capability Linux Command Line and Shell Scripting Bible is your essential Linux guide. With detailed instruction and abundant examples, this book teaches you how to bypass the graphical interface and communicate directly with your computer, saving time and expanding capability. This third edition incorporates thirty pages of new functional examples that are fully updated to align with the latest Linux features. Beginning with command line fundamentals, the book moves into shell scripting and shows you the practical application of commands in automating frequently performed functions. This guide includes useful tutorials, and a desk reference value of numerous examples. The Linux command line allows you to type specific shell commands directly into the system to manipulate files and query system resources. Command line statements can be combined into short programs called shell scripts, a practice increasing in popularity due to its usefulness in automation. This book is a complete guide providing detailed instruction and expert advice working within this aspect of Linux. Write simple script utilities to automate tasks Understand the shell, and create shell scripts Produce database, e-mail, and web scripts Study scripting examples ranging from basic to advanced Whether used as a tutorial or as a quick reference, this book contains information that every Linux user should know. Why not learn to use the system to its utmost capability? Linux is a robust system with tremendous potential, and Linux Command Line and Shell Scripting Bible opens the door to new possibilities.




Web Coding Bible (HTML, CSS, Javascript, PHP, SQL, XML, SVG, Canvas, WebGL, Java Applet, ActionScript, jQuery, WordPress, SEO and many more)


Book Description

This fixed-layout eBook teaches all essential web technologies from A to Z. Skillfully written, extremely succinct, with a lot of tables, diagrams, examples and screen output, it touches the latest experimental technology in action. Covering some hardly documented 'tricks' beyond the basics, this book guarantees to transform an Internet newcomer to an accomplished web developer. For every web developer, it is a handy must-have. As we know, various web technologies are interconnected and it is impossible to fully master one technology without knowing another. Traditionally, a serious web developer needs to rely on several books or sources when coding a website. This book represents an all-in-one solution. It presents to you a holistic view of all essential web technologies. It means spending less money and time in learning more. The topics include HTML, CSS, JavaScript, PHP, AJAX, SQL, XML, XPath, XSD, XQuery, XSLT, SVG, Canvas, WebGL, Java Applet, Flash ActionScript, Red5, Firebase, WebRTC, htaccess, mod rewrite, jQuery, cURL, WordPress, SEO etc. (This eBook should be read using a fixed-layout-compatible (epub3) reader such as the Gitden Reader in Android.)




Adobe Dreamweaver CS6 Bible


Book Description

Thoroughly covers the latest version of the leading website development software Web designers rely on Dreamweaver to create functional, attractive websites quickly and efficiently. The newest version adds some important functionality for tablet and smart phone screens, HTML5 enhancements, CSS3 updates, and native mobile application development for iOS, Android, and other platforms. This comprehensive guide covers them all and much more, making it the complete course in Dreamweaver for new users as well as a vital guide to help experienced designers delve deeper into more advanced topics. Covers all the updates in the newest version of Dreamweaver, including multi-screen, responsive web design for desktop, tablets, and phones; plug-in free video and audio playback; new web font support; and native mobile application development for Apple iOS, Google Android, Palm, Symbian, BlackBerry, and other platforms Features all the basic information for new users as well as detailed coverage of more advanced topics Shows how to set preferences, access the code directly, build pages using style sheets, work with text and images, set up tables, create interactive forms, and use frames and framesets Explores JavaScript frameworks, powering Ajax pages with jQuery, making data dynamic, using content management systems like WordPress, inserting Flash elements, using video and audio, integrating with XML and XSLT, animating with CSS3, and much more Dreamweaver CS6 Bible is the A-to-Z Dreamweaver reference for all web developers.