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

Buy

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.)

HTML5 and CSS3: Level Up with Today's Web Technologies
HTML5 and CSS3: Level Up with Today's Web Technologies

HTML5 and CSS3 are more than just buzzwords--they're the foundation for today's web applications. This book gets you up to speed on the HTML5 elements and CSS3 features you can use right now in your current projects, with backwards compatible solutions that ensure that you don't leave users of older browsers behind. This new...

Serverless Single Page Apps: Fast, Scalable, and Available
Serverless Single Page Apps: Fast, Scalable, and Available

Don't waste your time building an application server. See how to build low-cost, low-maintenance, highly available, serverless single page web applications that scale into the millions of users at the click of a button. Quickly build reliable, well-tested single page apps that stay up and running 24/7 using Amazon Web Services. Avoid...

Lean from the Trenches: Managing Large-Scale Projects with Kanban
Lean from the Trenches: Managing Large-Scale Projects with Kanban

You know the Agile and Lean development buzzwords, you've read the books. But when systems need a serious overhaul, you need to see how it works in real life, with real situations and people. Lean from the Trenches is all about actual practice. Every key point is illustrated with a photo or diagram, and anecdotes bring you...


Ship it! A Practical Guide to Successful Software Projects
Ship it! A Practical Guide to Successful Software Projects

Ship It! is a collection of tips that show the tools and techniques a successful project team has to use, and how to use them well. You'll get quick, easy-to-follow advice on modern practices: which to use, and when they should be applied. This book avoids current fashion trends and marketing hype; instead, readers find...

Functional Programming in Java: Harnessing the Power Of Java 8 Lambda Expressions
Functional Programming in Java: Harnessing the Power Of Java 8 Lambda Expressions

Intermediate level, for programmers fairly familiar with Java, but new to the functional style of programming and lambda expressions.

Get ready to program in a whole new way. Functional Programming in Java will help you quickly get on top of the new, essential Java 8 language features and the functional style
...

Modular Java: Creating Flexible Applications with OSGi and Spring
Modular Java: Creating Flexible Applications with OSGi and Spring
The secret weapon for attacking complexity in any project is to break it down into smaller, cohesive, and more easily digestible pieces. With Modular Java, you can easily develop applications that are more flexible, testable, maintainable, and comprehensible.

Modular Java is a pragmatic guide to developing modular
...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy