Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
SQL Pocket Primer - A Comprehensive Guide to SQL and MySQL for Data Professionals - cover

SQL Pocket Primer - A Comprehensive Guide to SQL and MySQL for Data Professionals

Mercury Learning and Information, Oswald Campesato

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

As part of the best-selling Pocket Primer series, this book is designed for data scientists and machine learning engineers seeking to deepen their SQL knowledge using MySQL as the primary RDBMS. It features Python-based code samples for accessing data from MySQL tables in Pandas data frames and Java-based samples for data access in MySQL, along with handling XML and JSON documents.The book also introduces NoSQL, with an overview of MongoDB, and SQLite, an open-source RDBMS for mobile devices. The final section covers diverse topics like normalization, schemas, database optimization, and performance. This comprehensive approach ensures a well-rounded understanding of SQL and related technologies, enhancing data manipulation and database management skills.Numerous code samples and listings throughout the book support the various topics covered. Companion files with source code and figures are available from the publisher, making this an essential resource for advancing your SQL proficiency and database management expertise.
Available since: 08/12/2024.
Print length: 310 pages.

Other books that might interest you

  • Data Security and Privacy for Beginners - Essential Strategies and Practices for Safeguarding Your Digital Assets - cover

    Data Security and Privacy for...

    Saimon Carrie

    • 0
    • 0
    • 0
    "Data Security and Privacy for Beginners: Essential Strategies and Practices for Safeguarding Your Digital Assets" is a comprehensive guide designed to help individuals navigate the complex landscape of data security and privacy in the digital age. In today's interconnected world, protecting personal and sensitive information has become more critical than ever before. This book provides clear explanations of fundamental concepts, practical tips, and actionable strategies to empower readers to safeguard their data and preserve their privacy online. 
    From understanding the basics of data security and privacy principles to implementing robust security measures, this book covers everything beginners need to know to protect themselves and their digital assets. Readers will learn about encryption techniques, access controls, secure communication protocols, and best practices for securing devices and networks. The book also addresses common threats and risks, such as malware, phishing, and identity theft, and provides guidance on how to mitigate these risks effectively. 
    With "Data Security and Privacy for Beginners," you'll gain the knowledge and skills needed to safeguard your data and protect your privacy in today's digital landscape. 
     
    Show book
  • A Poison Like No Other - How Microplastics Corrupted Our Planet and Our Bodies - cover

    A Poison Like No Other - How...

    Matt Simon

    • 0
    • 0
    • 0
    It's in our food, our clothes, and our homes. It's microplastic and it's everywhere—including our own bodies. Scientists are just beginning to discover how these tiny particles threaten health, but the studies are alarming. 
     
     
      
    In A Poison Like No Other, Matt Simon reveals a whole new dimension to the plastic crisis. Dealing with discarded plastic is bad enough, but when it starts to break down, the real trouble begins. The very thing that makes plastic so useful and ubiquitous—its toughness—means it never really goes away. It just gets smaller and smaller: eventually small enough to enter your lungs or be absorbed by crops or penetrate a fish's muscle tissue before it becomes dinner. 
     
     
      
    Unlike other pollutants, microplastics represent a cocktail of toxicity: plastics contain at least 10,000 different chemicals. Those chemicals are linked to diseases from diabetes to hormone disruption to cancers. 
     
     
     
    A Poison Like No Other is the first book to fully explore this public health threat. As Simon learns from these researchers, there is no easy fix. But we will never curb our plastic addiction until we begin to recognize the invisible particles all around us.
    Show book
  • The Microbiome - What Everyone Needs to Know(r) - cover

    The Microbiome - What Everyone...

    Berenice Langdon

    • 0
    • 0
    • 0
    There are microbiomes—communities of microbes—everywhere we can imagine: in every environment, on every surface, and in every creature, including us. They are an inevitable, if largely invisible, part of life, and understanding how our microbiome works can improve our health.In The Microbiome: What Everyone Needs to Know®, Dr. Berenice Langdon provides a foundational understanding of the microbiome and what it does—and does not—do. Tracing the history of microbiome research, up to the most recent scientific advancements, she dispels common misunderstandings to better acquaint listeners with the form and function of the human body's microbial community. In an accessible style, Dr. Langdon covers the microbiomes of the human body—from the skin to the gut-brain axis, the growing microbiome industry, the creation of the microbiome on newborns, the effects of microbiome changes, and even the possibilities for microbiome evolution into the future.In a fast-moving and oft-overhyped area of research, The Microbiome is a timely and significant contribution to the What Everyone Needs to Know® series.
    Show book
  • How Cyber Security Can Protect Your Business - A guide for all stakeholders - cover

    How Cyber Security Can Protect...

    Christopher Wright

    • 0
    • 0
    • 0
    Summary
    
    - Explains in easy-to-understand terms what executives and senior managers need to know and do about the ever-changing cyber threat landscape.
    - Gives strategic, business-focused guidance and advice relevant to C-suite executives.
    - Provides an effective and efficient framework for managing cyber governance, risk and compliance.
    - Explains what is required to implement an effective cyber security strategy.
    Description
    With high-profile cyber attacks, data breaches and fines for GDPR (General Data Protection Regulation) non-compliance hitting the headlines daily, businesses must protect themselves and their reputations, while reassuring stakeholders they take cyber security seriously.
    Cyber attacks are becoming more sophisticated and prevalent, and the cost of data breaches is soaring. In addition, new regulations and reporting requirements make cyber security a critical business issue.
    Board members and senior management must understand the threat landscape and the strategies they can employ to establish, implement and maintain effective cyber resilience throughout their organisation.
    How Cyber Security Can Protect your Business – A guide for all stakeholders provides an effective and efficient framework for managing cyber governance, risk and compliance, which organisations can adapt to meet their own risk appetite and synchronise with their people, processes and technology. It explains what is meant by governance, risk and compliance, how it applies to cyber security and what is required to implement an effective cyber security strategy.
    The pocket guide:
    
    - Gives readers a greater understanding of cyber governance, risk and compliance;
    - Explains what executives, senior managers and their advisors need to know and do about the ever-changing cyber threat landscape;
    - Provides context as to why stakeholders need to be aware of and in control of their organisation's cyber risk management and cyber incident response;
    - Gives guidance on building an appropriate and efficient governance framework that enables organisations to demonstrate their cyber approach in a non-technical, strategic, business-focused way;
    - Details an overview process to enable risk assessment, assess existing defence mitigations and provide a framework for developing suitable controls; and
    - Includes a checklist to help readers focus on their higher-priority cyber areas.
    Suitable for all managers and executives, this pocket guide will be of interest to non-cyber specialists, including non-executive directors, who may be required to review cyber arrangements. For cyber specialists, it provides an approach for explaining cyber issues in non-jargonistic, business-based language.
    Kick-start your journey to becoming cyber secure – buy this pocket guide today!
    Show book
  • Algorithms to Live By - cover

    Algorithms to Live By

    Brian Christian

    • 0
    • 0
    • 0
    This work provides a concise synthesis of the key insights and analysis from Algorithms to Live By. It is an independent summary, not the original book, and has no affiliation with or endorsement from the original publication. Created for readers who want a clear, thought-provoking overview, it distills the central themes and ideas while preserving the depth and relevance of the work. 
    An exploration of how classic algorithms from computer science can help navigate everyday decisions, from when to stop searching and commit to how to schedule tasks, organize clutter and balance exploration with exploitation. It turns concepts like optimal stopping, caching, overfitting and game theory into practical mental models for managing time, choices and uncertainty.
    Show book
  • Sand Stories - Surprising Truths about the Global Sand Crisis and the Quest for Sustainable Solutions - cover

    Sand Stories - Surprising Truths...

    Kiran Pereira

    • 0
    • 0
    • 0
    Sand is the hidden foundation of our society. In Sand Stories, Kiran Pereira maps out why it is the most consumed commodity on the planet after water. The book examines the impacts of our seemingly insatiable demand for sand on people, wildlife and our ecosystems. 
    The concern is that sand is a non-renewable resource in human timescales and not every kind of sand is useful to industry. The good news is that there are solutions to this alarming global problem, including those that foster a circular economy. 
    Show book