Businesses are gathering data today at exponential rates and yet few people know how to access it meaningfully. If you’re a business or IT professional, this short hands-on guide teaches you how to pull and transform data with SQL in significant ways. You will quickly master the fundamentals of SQL and learn how to create your own databases.
Author Thomas Nield provides exercises throughout the book to help you practice your newfound SQL skills at home, without having to use a database server environment. Not only will you learn how to use key SQL statements to find and manipulate your data, but you’ll also discover how to efficiently design and manage databases to meet your needs.
You’ll also learn how to:
Explore relational databases, including lightweight and centralized models
Use SQLite and SQLiteStudio to create lightweight databases in minutes
Query and transform data in meaningful ways by using SELECT, WHERE, GROUP BY, and ORDER BY
Join tables to get a more complete view of your business data
Build your own tables and centralized databases by using normalized design principles
Manage data by learning how to INSERT, DELETE, and UPDATE records
MacBook For Dummies (Computer/Tech) Got a new MacBook, MacBook Air, or MacBook Pro? Want the scoop on Mac laptop basics, using Mac OS X Leopard, networking a laptop, or connecting your laptop to wireless devices? There’s no better place to find what you need than MacBook For Dummies, 2nd Edition!
With your Mac laptop, you can take your movies, music,...
Foundations of Cryptography: Volume 1, Basic Tools (Vol 1)
Cryptography is concerned with the conceptualization, definition and construction of computing systems that address security concerns. This book presents a rigorous and systematic treatment of the foundational issues: defining cryptographic tasks and solving new cryptographic problems using existing tools. It focuses on the basic mathematical...
Advanced Topics in Java: Core Concepts in Data Structures
Java is one of the most widely used programming languages today. It was first released by Sun Microsystems in 1995. Over the years, its popularity has grown to the point where it plays an important role in most of our lives. From laptops to data centers, game consoles to scientific supercomputers, cell phones to the Internet, Java is...
Medical Response to Terrorism: Preparedness and Clinical Practice
Even two decades ago, few would have imagined that terrorism would be planned and carried out on such an enormous scale as it is today. Terrorist attacks rely on horror and surprise, invoking different times, places, victims, and methods. Their purpose is to cause widespread confusion, fear, injury, and death. They disrupt security,...
Microsoft ADO.NET (Core Reference)
Microsoft ADO.NET represents a major step forward for Microsoft data access technologies. It gives developers an unprecedented level of control over how their code interacts with their data—a welcome advance for developers who have been frustrated by the lack of control offered by previous "black box"...