MySQL Cookbook
MySQL Cookbook

Author: Paul DuBois

Publisher: "O'Reilly Media, Inc."

Published: 2014-07-28

Total Pages: 1101

ISBN-13: 144937414X

DOWNLOAD EBOOK

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 Cookbook
MySQL Cookbook

Author: Sveta Smirnova

Publisher: "O'Reilly Media, Inc."

Published: 2022-08-02

Total Pages: 1121

ISBN-13: 1492093114

DOWNLOAD EBOOK

For MySQL, the price of popularity comes with a flood of questions from users on how to solve specific data-related issues. That's where this cookbook comes in. 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 resolve MySQL problems from scratch. In this updated fourth edition, authors Sveta Smirnova and Alkin Tezuysal provide more than 200 recipes that cover powerful features in both MySQL 5.7 and 8.0. Beginners as well as professional database and web developers will dive into topics such as MySQL Shell, MySQL replication, and working with JSON. You'll learn how to: Connect to a server, issue queries, and retrieve results Retrieve data from the MySQL Server Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Assess the characteristics of a dataset Write stored functions and procedures Use stored routines, triggers, and scheduled events Perform basic MySQL administration tasks Understand MySQL monitoring fundamentals

Puppet Cookbook - Third Edition
Puppet Cookbook - Third Edition

Author: Thomas Uphill

Publisher: Packt Publishing Ltd

Published: 2015-02-20

Total Pages: 336

ISBN-13: 1784393738

DOWNLOAD EBOOK

This book is for anyone who builds and administers servers, especially in a web operations context. It requires some experience of Linux systems administration, including familiarity with the command line, file system, and text editing. No programming experience is required.

MySQL Cookbook
MySQL Cookbook

Author: Elias Negrin

Publisher: BPB Publications

Published: 2024-08-21

Total Pages: 511

ISBN-13: 935551929X

DOWNLOAD EBOOK

DESCRIPTION MySQL Cookbook – MySQL is a popular open-source database, and SQL is the top language for querying, creating, and managing data in databases. Developers and administrators widely use it for general and specific applications. MySQL powers business IT applications like CRM and ERP, APIs, web and e-commerce platforms, database management, data analytics, and increasingly, big data and data science projects. It starts with MySQL Workbench for beginners and moves to MySQL Shell for advanced scripting. Learn data redundancy, disaster recovery, and server connections in various languages. Core functions like SELECT, JOINs, INSERT, UPDATE, and DELETE are explained. Explore string, date, and time functions, sorting, stored procedures, triggers, and data manipulation. Finally, it covers user management, backups, performance, and security best practices. By the end of this book, you will be adept at interacting with MySQL databases, crafting efficient queries, and confidently managing your data for optimal performance and security. KEY FEATURES ● Gain confidence and skills to solve data problems with hands-on MySQL exercises. ● Learn practical MySQL skills by solving common database issues. ● Connect to servers, issue queries, retrieve data, and manage MySQL tasks. WHAT YOU WILL LEARN ● Connect to a server, issue queries, and retrieve results from MySQL Server. ● Store, retrieve, and manipulate strings and work with dates and times. ● Sort query results and generate aggregations. ● Use stored routines, triggers, and scheduled events. ● Perform basic MySQL administration tasks and monitoring fundamentals. WHO THIS BOOK IS FOR Whether you are a developer, an administrator, a faculty member teaching databases, or a student aiming to enhance your skills, this book provides valuable insights and hands-on knowledge to tackle database-related questions and problems effectively. TABLE OF CONTENTS 1. Using the MySQL Client Program 2. Using MySQL Shell 3. Using MySQL Replication 4. Writing MySQL-based Programs 5. Querying Data from Tables: Tables Management 6. Working with Strings 7. Working with Dates and Times 8. Sorting Query Results 9. Using Stored Routines, Triggers, and Scheduled Events 10. Importing and Exporting Data 11. Validating and Reformatting Data 12. Generating and Using Sequences 13. Working with JSON 14. Server Administration 15. Monitoring the Database Server and Security

The Definitive Guide to MySQL
The Definitive Guide to MySQL

Author: Michael Kofler

Publisher: Apress

Published: 2008-01-01

Total Pages: 802

ISBN-13: 1430206691

DOWNLOAD EBOOK

This second edition of Michael Kofler's acclaimed MySQL book has updated and expanded to cover MySQL 4.0, the most recent production release of the popular open source database, which boasts more than 4 million users worldwide. Like the first edition, this revision, which has been renamed to reflect the breadth and depth of Kofler's coverage of the topic, provides a thorough introduction to the installation, configuration, implementation, and administration of MySQL. In addition, Kofler demonstrates how you can use MySQL in conjunction with various other technologies to create database-driven websites, and he gives practical advice on database design. Kofler also covers what's coming up next in MySQL 4.1.

MySQL Stored Procedure Programming
MySQL Stored Procedure Programming

Author: Guy Harrison

Publisher: "O'Reilly Media, Inc."

Published: 2006-03-28

Total Pages: 636

ISBN-13: 0596100892

DOWNLOAD EBOOK

Providing an introduction to stored procedures programming and functions, this text covers the fundamentals of data types, operators, and using SQL in stored procedures.

The Needs for a Ubiquitous Collaborative Communication System Among the Cancer Community (UUM Press)
The Needs for a Ubiquitous Collaborative Communication System Among the Cancer Community (UUM Press)

Author: Ariffin Abdul Mutalib

Publisher: UUM Press

Published: 2015-01-01

Total Pages: 81

ISBN-13: 9670876133

DOWNLOAD EBOOK

Supporting the needs and preferences of the cancer community in their learning communication is necessary. As they communicate very frequently among each other. Caregivers communicate with medical practitioners, patients communicate with each other on their progress, and a lot more. Currently they communicate through telephone calls, which incur a lot of expenditure. This book describes a study that proves the necessity of an online collaborative communication system among the cancer community. Readers will find the content of this book useful in terms of the facts about the cancer community, methods in carrying out this kind of study, and elaborate discussions on the necessity of the online collaborative communication system, which is specially designed for the cancer community and is called the CCS.

Raspberry Pi 3 Cookbook for Python Programmers
Raspberry Pi 3 Cookbook for Python Programmers

Author: Dr. Steven Lawrence Fernandes

Publisher: Packt Publishing Ltd

Published: 2018-04-30

Total Pages: 542

ISBN-13: 1788626982

DOWNLOAD EBOOK

A recipe-based guide to programming your Raspberry Pi 3 using Python Key Features Leverage the power of Raspberry Pi 3 using Python programming Create 3D games, build neural network modules, and interface with your own circuits Packed with clear, step-by-step recipes to walk you through the capabilities of Raspberry Pi Book Description Raspberry Pi 3 Cookbook for Python Programmers – Third Edition begins by guiding you through setting up Raspberry Pi 3, performing tasks using Python 3.6, and introducing the first steps to interface with electronics. As you work through each chapter, you will build your skills and apply them as you progress. You will learn how to build text classifiers, predict sentiments in words, develop applications using the popular Tkinter library, and create games by controlling graphics on your screen. You will harness the power of a built in graphics processor using Pi3D to generate your own high-quality 3D graphics and environments. You will understand how to connect Raspberry Pi’s hardware pins directly to control electronics, from switching on LEDs and responding to push buttons to driving motors and servos. Get to grips with monitoring sensors to gather real-life data, using it to control other devices, and viewing the results over the internet. You will apply what you have learned by creating your own Pi-Rover or Pi-Hexipod robots. You will also learn about sentiment analysis, face recognition techniques, and building neural network modules for optical character recognition. Finally, you will learn to build movie recommendations system on Raspberry Pi 3. What you will learn Learn to set up and run Raspberry Pi 3 Build text classifiers and perform automation using Python Predict sentiments in words and create games and graphics Detect edges and contours in images Build human face detection and recognition system Use Python to drive hardware Sense and display real-world data Build a neural network module for optical character recognition Build movie recommendations system Who this book is for This book is for anyone who wants to master the skills of Python programming using Raspberry Pi 3. Prior knowledge of Python will be an added advantage.

Python GUI Programming Cookbook
Python GUI Programming Cookbook

Author: Burkhard Meier

Publisher: Packt Publishing Ltd

Published: 2019-10-11

Total Pages: 476

ISBN-13: 1838828818

DOWNLOAD EBOOK

Over 90 recipes to help you develop widgets, forms, layouts, charts, and much more using the latest features of Python 3 Key FeaturesUse object-oriented programming to develop impressive GUIs in PythonCreate interesting charts to visually represent data using MatplotlibDevelop GUIs with the latest versions of tkinter, PyQt5, and wxPython frameworksBook Description Python is a multi-domain, interpreted programming language that is easy to learn and implement. With its wide support for frameworks to develop GUIs, you can build interactive and beautiful GUI-based applications easily using Python. This third edition of Python GUI Programming Cookbook follows a task-based approach to help you create effective GUIs with the smallest amount of code. Every recipe in this book builds upon the last to create an entire, real-life GUI application. These recipes also help you solve problems that you might encounter while developing GUIs. This book mainly focuses on using Python’s built-in tkinter GUI framework. You'll learn how to create GUIs in Python using simple programming styles and object-oriented programming (OOP). As you add more widgets and expand your GUI, you will learn how to connect to networks, databases, and graphical libraries that greatly enhance the functionality of your GUI. You’ll also learn how to use threading to ensure that your GUI doesn't become unresponsive. Toward the end, you’ll learn about the versatile PyQt GUI framework, which comes along with its own visual editor that allows you to design GUIs using drag and drop features. By the end of the book, you’ll be an expert in designing Python GUIs and be able to develop a variety of GUI applications with ease. What you will learnCreate amazing GUIs with Python's built-in tkinter moduleCustomize GUIs using layout managers to arrange GUI widgetsAdvance from the typical waterfall coding style to an OOP style using PythonDevelop beautiful charts using the free Matplotlib Python moduleUse threading in a networked environment to make GUIs responsiveDiscover ways to connect GUIs to a MySQL databaseUnderstand how unit tests can be created and internationalize GUIDelve into the world of GUI creation using PyQt5Who this book is for If you’re a programmer or developer looking to enhance your Python skills by writing powerful GUI applications, this book is for you. Familiarity with the Python programming language is necessary to get the most out of the book.

Solr Cookbook - Third Edition
Solr Cookbook - Third Edition

Author: Rafał Kuć

Publisher: Packt Publishing Ltd

Published: 2015-01-23

Total Pages: 356

ISBN-13: 1783553162

DOWNLOAD EBOOK

This book is for intermediate Solr Developers who are willing to learn and implement Pro-level practices, techniques, and solutions. This edition will specifically appeal to developers who wish to quickly get to grips with the changes and new features of Apache Solr 5.