Get ready to make SQL easy! Updated for the latest version of SQL, the new edition of this perennial bestseller shows programmers and web developers how to use SQL to build relational databases and get valuable information from them. Covering everything you need to know to make working with SQL easier than ever, topics include how to use SQL to structure a DBMS and implement a database design; secure a database; and retrieve information from a database; and much more. SQL is the international standard database language used to create, access, manipulate, maintain, and store information in relational database management systems (DBMS) such as Access, Oracle, SQL Server, and MySQL. SQL adds powerful data manipulation and retrieval capabilities to conventional languages—and this book shows you how to harness the core element of relational databases with ease. - Server platform that gives you choices of development languages, data types, on-premises or cloud, and operating systems - Find great examples on the use of temporal data - Jump right in—without previous knowledge of database programming or SQL As database-driven websites continue to grow in popularity—and complexity—SQL For Dummies is the easy-to-understand, go-to resource you need to use it seamlessly.

Providing in-depth international case studies from a wide range of organizations

Collects practical tips and real-world advice for tackling common Python problems and taking your code to the next level and features interviews with high-profile Python developers who share their tips, tricks, best practices, and real-world advice gleaned from years of experience. Original.

A world-famous security expert explores the social side of security In this thought-provoking volume, the bestselling author of Secrets & Lies and Beyond Fear examines security's essential role in making society possible. Every society has a dishonest minority who breaks rules and doesn't follow group norms. They're not just the selfish; they include people with different morals. Security is how we protect ourselves from this dishonest minority within and what enables us to trust strangers at the local, national, and global scale. This engaging and highly readable book explains why security will always exist, and why we're all better off if it isn't perfect. It covers: - Our evolved security systems and their unique role in facilitating and stabilizing human society. - How our deliberately created security systems support modern, complex societies. - Where security is breaking down, as computer and communication systems replace existing social systems, and as technology gives that dishonest minority more power. - The value of the dishonest minority, and how it serves as a catalyst for social change. Bruce Schneier is a world-famous security technologist, regularly consulted by media, business, and governments. Like Schneier's other highly successful books, Liars and Outliers offers profound insights into the complex issue of security as well as a riveting reading experience.

Touting the benefits of detailed statistical analysis, an economist explains how by sorting through mass quantities of easily stored and sorted information, businesses, governments, and consumers can achieve greater insight into human behavior and use it to predict future trends. Reprint. 37,500 first printing.

Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code. PostGIS in Action is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

Foreword by Steven Pinker Blending the informed analysis of The Signal and the Noise with the instructive iconoclasm of Think Like a Freak, a fascinating, illuminating, and witty look at what the vast amounts of information now instantly available to us reveals about ourselves and our world—provided we ask the right questions. By the end of an average day in the early twenty-first century, human beings searching the internet will amass eight trillion gigabytes of data. This staggering amount of information—unprecedented in history—can tell us a great deal about who we are—the fears, desires, and behaviors that drive us, and the conscious and unconscious decisions we make. From the profound to the mundane, we can gain astonishing knowledge about the human psyche that less than twenty years ago, seemed unfathomable. Everybody Lies offers fascinating, surprising, and sometimes laugh-out-loud insights into everything from economics to ethics to sports to race to sex, gender and more, all drawn from the world of big data. What percentage of white voters didn’t vote for Barack Obama because he’s black? Does where you go to school effect how successful you are in life? Do parents secretly favor boy children over girls? Do violent films affect the crime rate? Can you beat the stock market? How regularly do we lie about our sex lives and who’s more self-conscious about sex, men or women? Investigating these questions and a host of others, Seth Stephens-Davidowitz offers revelations that can help us understand ourselves and our lives better. Drawing on studies and experiments on how we really live and think, he demonstrates in fascinating and often funny ways the extent to which all the world is indeed a lab. With conclusions ranging from strange-but-true to thought-provoking to disturbing, he explores the power of this digital truth serum and its deeper potential—revealing biases deeply embedded within us, information we can use to change our culture, and the questions we’re afraid to ask that might be essential to our health—both emotional and physical. All of us are touched by big data everyday, and its influence is multiplying. Everybody Lies challenges us to think differently about how we see it and the world.

A fully updated edition of this comprehensive bestseller on SQL, the preeminent database language Written to the SQL:2006 ANSI/ISO standard, this one-stop guide to SQL begins with an overview of this industry-standard computer database language, then shows how to retrieve and update data, program with SQL, use stored procedures, and much more. SQL: The Complete Reference, Third Edition has been revised to cover the latest RDBMS software versions including Microsoft SQL Server 2008, Oracle Database 11g, DB2, and MySQL. There are also extensive changes throughout the book including a new chapter on the latest innovations in SQL-based data management, new coverage of Database APIs and OCI, new J2EE developments, new Application Server coverage, SQL security regulations, and much more. .

A former computer hacker who turned his life around reveals how he now works as a computer security expert, protecting corporations from other hackers.

Introduction to Data Mining presents fundamental concepts and algorithms for those learning data mining for the first time. Each major topic is organized into two chapters, beginning with basic concepts that provide necessary background for understanding each data mining technique, followed by more advanced concepts and algorithms.