The MySQL Workshop - A practical guide to working with data and managing databases with MySQL

Thomas Pettit, Scott Cosentino

Sinossi

Do you want to learn how to create and maintain databases effectively? Are you looking for simple answers to basic MySQL questions as well as straightforward examples that you can use at work? If so, this workshop is the right choice for you.
Designed to build your confidence through hands-on practice, this book uses a simple approach that focuses on the practical, so you can get straight down to business without having to wade through pages and pages of dull, dry theory.
As you work through bite-sized exercises and activities, you'll learn how to use different MySQL tools to create a database and manage the data within it. You'll see how to transfer data between a MySQL database and other sources, and use real-world datasets to gain valuable experience of manipulating and gaining insights from data. As you progress, you'll discover how to protect your database by managing user permissions and performing logical backups and restores.
If you've already tried to teach yourself SQL, but haven't been able to make the leap from understanding simple queries to working on live projects with a real database management system, The MySQL Workshop will get you on the right track.
By the end of this MySQL book, you'll have the knowledge, skills, and confidence to advance your career and tackle your own ambitious projects with MySQL.

Disponibile da: 29/04/2022.

Lunghezza di stampa: 726 pagine.

Scienze e tecnologia

Altri libri che potrebbero interessarti

Powering agri-food value chains...

Irena International Renewable...

This report provides recommendations to accelerate the deployment of geothermal energy in the agri-food sector.

Mostra libro

Assuming the Ecosexual Position...

Jennie Klein, Beth Stephens,...

What's sexy about saving the planet? Funny you should ask. Because that is precisely—or, perhaps, broadly—what Annie Sprinkle and Beth Stephens have spent many years bringing to light in their live art, exhibitions, and films. In 2008, Sprinkle and Stephens married the Earth, which set them on the path to explore the realms of ecosexuality as they became lovers with the Earth and made their mutual pleasure an embodied expression of passion for the environment. Ever since, they have been not just pushing but obliterating the boundaries circumscribing biology and ecology, creating ecosexual art in their performance of an environmentalism that is feminist, queer, sensual, sexual, posthuman, materialist, exuberant, and steeped in humor. 
 
 
 
Assuming the Ecosexual Position tells of childhood moments that pointed to a future of ecosexuality—for Annie, in her family swimming pool in Los Angeles; for Beth, savoring forbidden tomatoes from the vine on her grandparents' Appalachian farm. The book describes how the two came together as lovers and collaborators, how they took a stand against homophobia and xenophobia, and how this union led to the miraculous conception of the Love Art Laboratory, which involved influential performance artists Linda M. Montano, Guillermo Gómez-Peña, and feminist pornographer Madison Young.

Mostra libro

The Evolution of Software...

Sophia Wilson

"The Evolution of Software Development Methodologies: Navigating the Paths of Creation: An Overview of Software Development Methodologies," gives a comprehensive review of the tactics, procedures, and inventions that have pushed forward software development. This book explores the change in the development of software: from very structured and systematic approaches to flexible and dynamic frameworks characteristic of contemporary software development. This research book focuses on five in-depth chapters, discussing the turning points in this evolution. It starts at the origin of programming, when the fundamental concepts of computation and first coding languages emerged.
Then, the birth of structured models is covered with attention to the function of the Waterfall technique, creating methodical, sequential development processes. The discussion then moves on to the transition to Agile practices, where cooperative, iterative techniques transformed teams' approaches toward software projects. Hybrid models such as DevOps are also discussed in meeting some organizational objectives by combining conventional and contemporary methodologies. The new trends include AI-driven techniques and international team collaboration, where there is an extension beyond traditional frameworks.
Blending historical analysis, real-world applications, and futuristic viewpoints, this book caters to students, software professionals, and tech enthusiasts alike. It sheds light on the advantages, disadvantages, and breakthroughs of each methodology, thereby emphasizing how flexibility plays a critical role in a fast-changing technological environment. Whether you want to upgrade your know-how in the software development field or understand the challenges of developing software in today's fast-moving world, this book is priceless as a source of learning on the development of methodologies that power digital innovation.

Mostra libro

Relativity and Cosmology -...

Mark Hedges

Relativity is one of the most profound and influential theories in modern physics, fundamentally altering our understanding of space, time, and gravity. Developed by Albert Einstein in the early 20th century, the theory of relativity consists of two main parts: special relativity and general relativity. Special relativity, formulated in 1905, addresses the behavior of objects moving at constant velocity in the absence of gravitational fields, while general relativity, introduced in 1915, extends the principles of special relativity to include the effects of gravity, describing it as a consequence of the curvature of space-time. Together, these theories provide a unified framework for understanding the large-scale structure of the universe, the motion of celestial bodies, and the nature of gravity itself. 
The foundation of special relativity rests on two key postulates: (1) the laws of physics are the same in all inertial reference frames, and (2) the speed of light in a vacuum is constant for all observers, regardless of their relative motion. These postulates lead to several counterintuitive but experimentally verified consequences, such as time dilation, length contraction, and the relativity of simultaneity. Time dilation implies that a moving clock runs slower relative to a stationary observer, while length contraction means that an object moving at high velocity appears shorter along the direction of motion. The relativity of simultaneity states that two events that are simultaneous in one reference frame may not be simultaneous in another frame moving relative to the first. These effects become significant at velocities approaching the speed of light, where classical mechanics fails to provide accurate predictions.

Mostra libro

Ultimate Django for Web App...

Leonardo Lazzaro

Craft Scalable and Dynamic Web Apps using Django and PythonBook DescriptionThis comprehensive guide is an indispensable resource for developers seeking to elevate their web development skills in Django and Python. The book begins by establishing a strong foundation and understanding of Django's architecture, emphasizing the Model-View-Template (MVT) pattern and a pivotal service layer for creating scalable web applications. The book then progresses to practical aspects, guiding readers through the development of a Task Management App. This hands-on approach reinforces fundamental concepts and showcases Django's flexibility and efficiency in real-world scenarios.The advanced sections of the book will help you tackle complex challenges, covering topics like preventing double-form submissions, implementing offline pessimistic and optimistic locking techniques, mastering API development with Django Ninja, and ensuring application reliability through exhaustive testing with pytest. The book culminates in practical insights for deploying Django applications with Docker and Kubernetes, this guide equips you to tackle real-world challenges effectively.Table of Contents1. Introduction to Django and Python2. Setting Up Your Development Environment3. Getting Started with Django Projects and Apps4. Django Models and PostgreSQL5. Django Views and URL Handling6. Using the Django Template Engine7. Forms in Django8. User Authentication and Authorization in Django9. Django Ninja and APIs10. Testing with pytest11. Deploying Django Applications with Gunicorn and Docker12. Final Thoughts and Future DirectionsIndex

Mostra libro

The Seaweed Revolution - How...

Vincent Doumeizel

Accessible and engaging, topical reading with case studies from around the world. Written by world expert with guaranteed media coverage. First mainstream book looking at seaweed from an environmental standpoint. Will appeal to fans of popular science and those with interest in environmental issues.

Mostra libro