This book is intended to teach the basics of using the MySQL relational database management system (RDBMS) to create and manage databases and is ideal for those unfamiliar with both databases in general and MySQL in particular.Topics covered include the basics of relational databases, database architecture, an overview of the MySQL administration tools, database security implementation and detailed tutorials on using SQL to create, manage and retrieve data from MySQL based databases.

A Guide to managing servers and automation About This Book Breeze through Puppet's key features and performance improvements to bring real advantages to your IT infrastructure Discover Puppet best practices to help you avoid common mistakes and pitfalls Examples to help you get to grips with Puppet and succeed with everyday IT automation Who This Book Is For This book targets experienced IT professionals and new Puppet uses, who will learn all they need to know to go from installation to advanced automation. Get a rapid introduction to the essential topics and learn how to build best practices for advanced automation with Puppet. What You Will Learn Understand declarative configuration management Make use of GIT-based deployment workflows Extend Factor with secure elements Create modular and reusable Puppet code Extend your code base with publicly available Puppet modules Separate logic from data by using Hiera Understand and develop Puppet Roles and Profiles In Detail Puppet is a configuration management tool that allows you to automate all your IT configurations, giving you control over what you do to each Puppet Agent in a network, and when and how you do it. In this age of digital delivery and ubiquitous Internet presence, it's becoming increasingly important to implement scaleable and portable solutions, not only in terms of software, but also the system that runs it. This book gets you started quickly with Puppet and its tools in the right way. It highlights improvements in Puppet and provides solutions for upgrading. It starts with a quick introduction to Puppet in order to quickly get your IT automation platform in place. Then you learn about the Puppet Agent and its installation and configuration along with Puppet Server and its scaling options. The book adopts an innovative structure and approach, and Puppet is explained with flexible use cases that empower you to manage complex infrastructures easily. Finally, the book will take readers through Puppet and its companion tools such as Facter, Hiera, and R10k and how to make use of tool chains. Style and approach This book aims to impart all the knowledge required to tap into not only the basics of Puppet, but also its core. The basic ideas and principles of Puppet-based designs are explored and explained. Sophisticated tools are presented to enable you to use Puppet efficiently and productively.

- Kofler's book offers more up-to-date coverage than other books on the market - Provides in-depth coverage of topics normally overlooked, such as the File Scripting Objects, accessing external databases using the ADO library, automating data analysis with pivot tables, and automating diagrams.

* The book supports the new version of Dreamweaver, a huge potential market! * This book is fairly unique within that market - a book purely focused on PHP web development with Dreamweaver that teaches professional techniques, and doesn’t treat readers like idiots (it isn’t aimed at the "dummies" audience.) * Dreamweaver has over 3 million users worldwide.

Find out how to use Docker in your ASP.NET Core MVC applications, and how containers make it easier to develop, deploy and manage those applications in production environments. Packed with examples and practical demonstrations, this book will help you deploy even large-scale, cross-platform web applications from development into production. Best-selling author Adam Freeman takes you on a whirlwind tour of Docker, from creating a consistent development environment for your team to deploying a project and scaling it up in production. By the end of the book, you will have a solid understanding of what Docker does, how it does it and why it is useful when developing and deploying ASP.NET Core MVC applications. What You Will Learn Gain a solid understanding of Docker: what it is, and why you should be using it for your ASP.NET Core MVC applications Use Docker to create a development platform for ASP.NET Core MVC so that applications behave consistently across development and production Use Docker to test, deploy and manage ASP.NET Core MVC containers Use Docker Swarms to scale up applications to cope with large workloads Who This Book Is For ASP.NET Core MVC developers who want to use Docker to containerize and manage their applications

Get step-by-step instruction from installing MySQL; manipulating it; and basic reporting; to advanced reporting; interfacing programs; and backups. --

Dreamweaver CS4 is a massive step forward in terms of integration with the rest of the CS4 suite (Flash, Fireworks, Photoshop, etc.), and also includes whole host of exciting features of its own. The Essential Guide to Dreamweaver CS4 with CSS, Ajax, and PHP concentrates on getting the most out of Dreamweaver CS4, rather than going into every menu item and toolbar icon. The emphasis is on developing websites compliant with the latest web standards, using CSS, JavaScript libraries (with particular emphasis on Spry, Adobe's implementation of Ajax), and PHP. The book covers all aspects of the new user interface, including workspace layouts, iconic panels, the related documents feature, Live View, Code Navigator, and Live Code. It also shows how to use the improved CSS editing features, and JavaScript code introspection. There is also coverage of other new features, such as version control through Subversion integration, and the improved support for Photoshop integration through the use of Smart Objects. Takes you through your development environment set up Covers everything you need to create both standards compliant web sites, and dynamic web applications Teaches real world techniques using a series of step by step tutorials