Practical Sql

Author: Anthony DeBarros
Editor: No Starch Press
ISBN: 1593278276
File Size: 33,30 MB
Format: PDF, ePub, Mobi
Read: 1093
Download

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.
SQL: A Beginner's Guide, Fourth Edition
Language: en
Pages: 544
Authors: Andy Oppel
Categories: Computers
Type: BOOK - Published: 2015-11-06 - Publisher: McGraw Hill Professional

This fully revised, self-paced learning tool lays out all the necessary steps to quickly and easily start writing SQL programs Thoroughly updated to reflect the most recent ANSI/ISO standard, SQL: A Beginner's Guide, Fourth Edition will get you up-and-running with SQL programming right away. Clear tutorials, annotated code, and proven
Practical SQL
Language: en
Pages: 392
Authors: Anthony DeBarros
Categories: Computers
Type: BOOK - Published: 2018-05-01 - Publisher: No Starch Press

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
Databases A Beginner's Guide
Language: en
Pages: 496
Authors: Andy Oppel
Categories: Computers
Type: BOOK - Published: 2009-04-13 - Publisher: McGraw-Hill Education

Essential Database Skills--Made Easy! Learn standard database design and management techniques applicable to any type of database. Featuring clear examples using both Microsoft Access and Oracle, Databases: A Beginner's Guide begins by showing you how to use Structured Query Language (SQL) to create and access database objects. Then, you'll discover
SQL For Beginners
Language: en
Pages: 180
Authors: Berg Craig
Categories: Computers
Type: BOOK - Published: 2019-09-26 - Publisher:

You Are About To Learn How To Use SQL Programming Language Like A Pro Even If You've Never Used It Before! With so many programming languages out there, it is easy to feel overwhelmed on which programming language to learn next. Let me help you make that decision.... Every website,
Learning Language Of SQL
Language: en
Pages: 246
Authors: Phil J Hack
Categories: Computers
Type: BOOK - Published: 2019-11-14 - Publisher:

Learn by doing and STOP wasting more time with a bunch of theory. A Step-by-Step guide is what will get you to the next level. Keep reading and find out more.. Are you ready to start learning the language of SQL in a smarter way with a step by step