Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Practical SQL: A Beginner's Guide to Storytelling with Data


Practical SQL is an approachable and fast-paced guide to SQL (Structured Query Language), the standard programming language for defining, organizing, and exploring data in relational databases. The book focuses on using SQL to find the story your data tells, with the popular open-source database PostgreSQL and the pgAdmin interface as its primary tools.

You’ll first cover the fundamentals of databases and the SQL language, then build skills by analyzing data from the U.S. Census and other federal and state government agencies. With exercises and real-world examples in each chapter, this book will teach even those who have never programmed before all the tools necessary to build powerful databases and access information quickly and efficiently.

You’ll learn how to:
-Create databases and related tables using your own data
-Define the right data types for your information
-Aggregate, sort, and filter data to find patterns
-Use basic math and advanced statistical functions
-Identify errors in data and clean them up
-Import and export data using delimited text files
-Write queries for geographic information systems (GIS)
-Create advanced queries and automate tasks

Learning SQL doesn’t have to be dry and complicated. Practical SQL delivers clear examples with an easy-to-follow approach to teach you the tools you need to build and manage your own databases.

This book uses PostgreSQL, but the SQL syntax is applicable to many database applications, including Microsoft SQL Server and MySQL.

(HTML tags aren't allowed.)

Microsoft® SQL Server® 2008 Analysis Services Step by Step
Microsoft® SQL Server® 2008 Analysis Services Step by Step

Teach yourself to use SQL Server 2008 Analysis Services for business intelligence?one step at a time. You'll start by building your understanding of the business intelligence platform enabled by SQL Server and the Microsoft Office System, highlighting the role of Analysis Services. Then, you’ll create a simple...

Introduction to Topology and Geometry
Introduction to Topology and Geometry

An easily accessible introduction to over threecenturies of innovations in geometry

Praise for the First Edition

...a welcome alternative to compartmentalizedtreatments bound to the old thinking. This clearly written,well-illustrated book supplies sufficient background to beself-contained. CHOICE

This fully...

CentOS Bible
CentOS Bible
Authoritative guide to a rapidly growing Linux distribution

This is one of the first, if not the first comprehensive guide to the CentOS Linux operating system. Linux guru Tim Bornocyzyk, thoroughly covers the topic whether you're a Linux novice or a regular who now wants to master this increasingly popular...

Computer Networking: A Top-Down Approach Featuring the Internet
Computer Networking: A Top-Down Approach Featuring the Internet
The most up-to-date introduction to the field of computer networking, this book's top-down approach starts at the application layer and works down the protocol stack. It also uses the Internet as the main example of networks. This all creates a book relevant to those interested in networking today. By starting at the application-layer and...
The Human Foot: A Companion to Clinical Studies
The Human Foot: A Companion to Clinical Studies
The appendages at the end of our forelimbs tend to attract the evolutionary and clinical limelight, but our feet are as important as our hands for our survival and success as a species. We tend to take them for granted, yet the many millions of modern humans who run either competitively or for recreation, or who play sports such...
Automotive Painting Technology: A Monozukuri-Hitozukuri Perspective
Automotive Painting Technology: A Monozukuri-Hitozukuri Perspective

This book offers unique and valuable contributions to the field. It offers breadth and inclusiveness. Most existing works on automotive painting cover only a single aspect of this complex topic, such as the chemistry of paint or paint booth technology. Monozukuri and Hitozukuri are Japanese terms that can be translated as “making...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy