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
Beginning SQL Server for Developers
Beginning SQL Server for Developers is the perfect book for developers new to SQL Server and planning to create and deploy applications against Microsoft’s market-leading database system for the Windows platform. Now in its fourth edition, the book is enhanced to cover the very latest developments in SQL Server, including the...
Pro T-SQL Programmer's Guide
Pro T–SQL Programmer’s Guide is your guide to making the best use of the powerful, Transact-SQL programming language that is built into Microsoft SQL Server's database engine. This edition is updated to cover the new, in-memory features that are part of SQL Server 2014. Discussing new and existing features, the book...
SQL Server Advanced Data Types: JSON, XML, and Beyond
SQL Server Advanced Data Types attempts to demystify the complex data types that are available to developers in modern versions of SQL Server. Over the last couple of years, I have noticed that many SQL developers have heard of each of the complex data types available in SQL Server but often avoid using them, as they are not sure how these...
XML and JSON Recipes for SQL Server: A Problem-Solution Approach
Welcome and thank you for reading XML and JSON Recipes for SQL Server. In the modern world of information technology, keeping data stored and manipulated reliably and efficiently is one of the first priorities. In the last decade, SQL Server has evolved into a sophisticated Enterprise RDBMS tool, and it is still growing by providing more...