Description
Book Synopsis: 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.
Details
Looking to tell a compelling story with your data? Look no further than Practical SQL: A Beginner's Guide to Storytelling with Data. This fast-paced and approachable guide will teach you SQL, the standard programming language for organizing and exploring data in relational databases. With the help of PostgreSQL and the pgAdmin interface, you'll learn how to find the story hidden within your data. Whether you're a beginner or have never programmed before, this book will equip you with all the necessary tools to create powerful databases and access information quickly and efficiently. Get ready to unlock the true potential of your data with Practical SQL.
Don't let the seemingly complex world of databases and SQL intimidate you. Practical SQL is here to make learning SQL a breeze. With hands-on exercises and real-world examples, this book will guide you through the fundamentals of databases, the SQL language, and making sense of your data. Whether you're analyzing U.S. Census data or data from other government agencies, you'll learn how to aggregate, sort, and filter data to uncover patterns and valuable insights. Plus, you'll even discover how to clean up errors in your data and import/export data using delimited text files. Start your SQL journey today with Practical SQL.
Looking to level up your data analysis skills? Practical SQL is the perfect resource for you. With a focus on storytelling with data, this book will teach you how to create databases, define the right data types, and utilize basic math and advanced statistical functions. Enhance your analysis with queries for geographic information systems (GIS) and automate tasks with advanced queries. Whether you're a beginner or already familiar with SQL, Practical SQL offers an easy-to-follow approach with clear examples. Get ready to unleash the power of SQL with Practical SQL.
Ready to become a master of databases? Practical SQL is your ticket to becoming a data guru. This book takes you through the world of SQL using PostgreSQL as the primary tool, but the SQL syntax applies to many other database applications. With exercises and real-world examples in every chapter, you'll gain practical experience in creating databases, defining data types, and analyzing and visualizing data. Don't miss the opportunity to build powerful databases and access information quickly and efficiently. Take control of your data story with Practical SQL today!
Discover More Best Sellers in Databases & Big Data
Shop Databases & Big Data
$9.99
Databases & Big Data - IPHONE 14 USER GUIDE: An Easy, Step-By-Step Guide On Mastering The Usage Of Your New iPhone 14. Learn The Best Tips & Tricks, And Discover The Most Useful ... Out Of Your Device (Beginners & Seniors)
Data Management at Scale: Modern Data Architecture with Data Mesh and Data Fabric
$39.45
Databases & Big Data - Data Management at Scale: Modern Data Architecture with Data Mesh and Data Fabric
Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Solutions
$20.71
Databases & Big Data - Enterprise Integration Patterns: Designing, Building, and Deploying Messaging Solutions
$31.72
Databases & Big Data - Definitive Guide to DAX, The: Business intelligence for Microsoft Power BI, SQL Server Analysis Services, and Excel (Business Skills)
$19.91
Databases & Big Data - Excel: The most updated bible to master Microsoft Excel from scratch in less than 7 minutes a day | Discover all the features & formulas with step-by-step tutorials (Mastering Technology)
Algorithms For Dummies (For Dummies (Computer/Tech))
$19.29
Databases & Big Data - Algorithms For Dummies (For Dummies (Computer/Tech))
$49.49
Databases & Big Data - Data Engineering with AWS: Learn how to design and build cloud-based data transformation pipelines using AWS
$28.87
Databases & Big Data - Pandas 1.x Cookbook: Practical recipes for scientific computing, time series analysis, and exploratory data analysis using Python, 2nd Edition
