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!
I want to read the book!
All characters reduced
Learn SQL using MySQL in One Day and Learn It Well - SQL for beginners with Hands-on Project - cover

Learn SQL using MySQL in One Day and Learn It Well - SQL for beginners with Hands-on Project

Jamie Chan

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

Learn SQL (using MySQL) in One Day and Learn It Well is the ultimate guide for beginners aiming to grasp the complexities of SQL through hands-on learning. Starting with an introduction to the essence of databases, this book methodically advances through defining and manipulating tables, mastering data insertion, updates, deletions, and executing sophisticated data selection techniques across its comprehensive chapters. It further explores the creation and utility of views, the implementation of triggers to automate database responses, and the intricacies of variables, stored routines, control flow tools, and cursors, culminating in a capstone project that brings all concepts together.
Culminating in a project , this book offers a unique opportunity to apply all the learned concepts in a practical, real-world scenario, reinforcing the skills and knowledge acquired throughout the chapters. The appendices provide additional resources including table definitions for practical exercises modeled on real-world scenarios.
Embark on a learning journey that transitions you from novice to proficient in managing and querying databases with MySQL, empowering you with the skills to tackle real-world data challenges.
Available since: 04/26/2024.
Print length: 127 pages.

Other books that might interest you

  • Analytics the Right Way - A Business Leader's Guide to Putting Data to Productive Use - cover

    Analytics the Right Way - A...

    Tim Wilson, Dr. Joe Sutherland

    • 0
    • 0
    • 0 
    Organizations have more data at their fingertips than ever, and their ability to put that data to productive use should be a key source of sustainable competitive advantage. Yet, business leaders looking to tap into a steady and manageable stream of "actionable insights" often, instead, get blasted with a deluge of dashboards, chart-filled slide decks, and opaque machine learning jargon that leaves them asking, "So what?" 
 
 
 
Analytics the Right Way is a guide for these leaders. It provides a clear and practical approach to putting analytics to productive use with a three-part framework that brings together the realities of the modern business environment with the deep truths underpinning statistics, computer science, machine learning, and artificial intelligence. The result: a pragmatic and actionable guide for delivering clarity, order, and business impact to an organization's use of data and analytics. 
 
 
 
The book uses real-world examples from the authors' direct experiences—working inside organizations, as external consultants, and as educators—to empower the listener to put foundational analytical and statistical concepts to effective use in a business context.
    Show book
  • The Wild Side Volume 2 - cover

    The Wild Side Volume 2

    Scott Shalaway

    • 0
    • 0
    • 0 
    The Wildside Volume 2 highlights seventy five of the best of Scott Shalaway's syndicated nature columns. Let Scott introduce you to the natural history of creatures you see and enjoy every day--birds, bats, butterflies, and many other animals and plants. Compare personal perspectives on nature. Tag along as he describes his outdoor adventures, from the wilds of West Virginia to the Galapagos Islands. And learn how to attract more wildlife to your backyard with food, nest boxes, and wildflowers. 
Scott Shalaway (1952-2025) earned his PhD in wildlife ecology at Michigan State. After working first at the Michigan Department of Natural Resources and then as a zoology professor at Oklahoma State University, he moved to West Virginia to fulfill his dream of becoming a freelance nature writer. Scott’s life “on the wild side” encompassed 33 years writing more than 2,000 columns, seven books, and several hundred magazine articles--many of which won writing awards. For 22 of those years, he also hosted live weekly radio shows in Pittsburgh and Wheeling, West Virginia. Scott led 13 birding tours to Mexico and 11 more to Ecuador, the Galapagos, Maine, the Everglades, southern Arizona, Hawk Mountain and Cape May. 
This audiobook is brought to life by Scott's eldest daughter, author and voice actor Nora Shalaway Carpenter.
    Show book
  • Important Astronauts Cosmonauts and Other Spaceflight Personalities - cover

    Important Astronauts Cosmonauts...

    Martin K. Ettington

    • 0
    • 0
    • 0 
    This book is the eighth volume of “The Living in Space Series”. Each volume focuses on one particular technology of living in space. 
This book covers the Astronauts, Cosmonauts, and other individuals who were responsible for some of the biggest space adventures to date. 
When I was a kid growing up in the 1960s my friends and I were always listening to the latest news about the Mercury Seven and their latest adventures flying into space. 
As of 2020 less than 600 persons have gone into space. These people have pioneered many different types of space activities and are responsible for many legends. 
In 1985 while working for Hewlett Packard I got myself transferred to work at the Johnson Space Center in Houston, Texas for a couple of years. It was incredible for me because I got to see the manned space flight center up close, walk inside of Space mockups, and meet many astronauts. In fact it was David Wolf—who later became an astronaut who took me up for rides in his Pitt Special Acrobatic plane (where I got really sick) which convinced me to get my own pilots license. I even applied for the astronaut corps but didn’t make it. 
I also knew Julie Resnick who was killed in the Challenger explosion. It was very impressive attending the Challenger public funeral where President Reagan spoke. 
As a lifelong space buff, I’m very happy to write this book series and introduce the key players here. In this book we will profile those persons who have been the star players in man’s exploration of space, and who have made major space contributions over the years.
    Show book
  • Israel and the Cyber Threat - How the Startup Nation Became a Global Cyber Power - cover

    Israel and the Cyber Threat -...

    Gabi Siboni, Charles D....

    • 0
    • 0
    • 0 
    In Israel and the Cyber Threat, Charles D. ("Chuck") Freilich, Matthew S. Cohen, and Gabi Siboni provide a detailed and comprehensive study of Israel's cyber strategy, tracing it from its origins to the present. They analyze Israel's highly advanced civil and military cyber capabilities and organizational structures to offer insights into what other countries can learn from Israel's experience. To achieve this, they explore how and why Israel has been able to build a remarkable cyber ecosystem and turn itself, despite its small size, into a global cyber power. The book further examines the major cyber threats facing Israel, including the most in-depth look at Iranian cyber policies and attacks; Israel's defensive and offensive capabilities and the primary attacks it has conducted; capacity building; international cooperation; and the impact of Israel's strategic culture on its cyber prowess. By placing Israel's actions in the realm of international relations theory, the book sheds light on many of the major questions in the field regarding cyber policies. 
 
 
 
The most authoritative work to date on Israeli cyber strategy, this book provides a comprehensive look at the major actions Israel has taken in cyberspace. It also places them in the broader context of global cyber developments to help listeners understand state behavior in cyberspace.
    Show book
  • Cycles - The Science of Periods Why They Matter and How to Nourish Each Phase - cover

    Cycles - The Science of Periods...

    FNP Amy J. Hammer

    • 0
    • 0
    • 0 
    There is no one-size-fits-all guide to your cycle. But registered nurse Amy Hammer arms you with a strong foundation in physiology and hormonal health, explores historical and sociocultural aspects of women's health, and reimagines the phases of the menstrual cycle as aligning with the four seasons to provide a detailed guide for living well. 
 
 
 
Also included are nutritive recipes, supportive movement practices, and self-care rituals and recipes to guide you through each phase of the menstrual cycle and of life. 
 
 
 
Become in tune with your internal rhythm, reclaim the meaning of self-care, and cultivate optimal health for every season of life. This comprehensive, body-literate guide includes: 
 
 
 
● 40 nutrient-dense, menstrual-phase specific recipes that support hormonal, emotional, cognitive, gut, and overall health. 
 
 
 
● The science behind menstrual cycles and how hormonal fluctuation impacts your brain, breasts, skin, and weight. 
 
 
 
● How to track your cycle using fertility awareness methods, allowing you to naturally and effectively avoid or pursue pregnancy. 
 
 
 
● Supportive full-body movement, self-care, and nutrition tips that optimize physiological and hormonal health.
    Show book
  • The Power of Machine Learning - The Next Frontier: Making Data-Driven Decisions - cover

    The Power of Machine Learning -...

    Tristan Vale

    • 0
    • 0
    • 0 
    Step into the transformative world of machine learning, where data shapes decisions and drives innovations. From businesses to healthcare, from finance to entertainment, uncover how machine learning is redefining the very fabric of our modern society. 
"The Power of Machine Learning: The Next Frontier- Making Data-Driven Decisions" explores the history, importance, and challenges of data-driven decisions in various sectors, focusing on the balance between data power and societal interests. 
Equip yourself with the knowledge to navigate the digital landscape confidently. Whether you're a professional aiming to integrate machine learning into your domain, a student eager to delve into this revolutionary field, or simply a curious mind, this book offers comprehensive insights that cater to all. 
Dive into the future of decision-making. Go on a journey to discover the limitless potential of machine learning in shaping tomorrow's world. Your exploration into the next frontier awaits.
    Show book