Extra 10% Off Applied
Fiction
Non-Fiction
Business & Economics
Childrenโs Books
Sort By
Relevance
Extra 5% Off on Shopping above Rs.999
Assured 2-4 Days Express Delivery across India.
Extra 10% Off on Shopping above Rs.1,499
Anthony Debarros
MRP: โน 3,399
โน 3,230
โน 169 Off
(Incl. of all taxes)
Get this at โน 2,907
Extra 10% Off Applied
Ships within 4 - 7 Days
We usually ship orders the next day. This book is specially sourced for you, so it may take few extra days.
Binding
Paperback
Number of Pages
464
Age Group
All
Language
English
Piracy Free
Secure Transactions
Express Delivery
EcoโConscious Packaging
Ships within 3 - 6 Days
We usually ship orders the next day, this book will be specially sourced for you, so it may take few extra days.
Book Summary
This is a beginner-friendly non-fiction guide to SQL, focused on using the language to define, organize, and explore data in relational databases. The central goal is to help you uncover the story hidden in your data by writing clear, effective queries. The intended reader is someone new to programming or data analysis, seeking a practical, approachable path to data mastery and confidence in everyday data tasks.
The content is presented through hands-on projects and runnable examples using PostgreSQL and the pgAdmin interface. Youโll progress from core concepts to more advanced techniques, including spatial data analysis with PostGIS, while applying the ideas to real-world datasets such as US Census demographics, New York City taxi trips, and seismic events. Each chapter includes exercises that reinforce learning and help you build practical, usable skills.
Key concepts and skills covered include creating databases and related tables, aggregating, sorting, and filtering data, using functions for math and statistics, identifying and cleaning data errors, and automating repetitive tasks. The updated edition adds two new chapters: an expanded setup guide to get your system running smoothly, and a focused look at using PostgreSQL with the JSON data interchange format. Learning is structured to feel accessible and enjoyable, with concepts and techniques that transfer across common database systems.
After finishing, readers will handle data more confidently, analyze information quickly, and apply SQL skills to real-world problems. The guide builds curiosity, strengthens problem-solving abilities, and leaves you prepared to tackle data-driven projects with greater independence and clarity.
Product Details
Author
Anthony Debarros
Publisher
Penguin Random House
Number of Pages
464
Language
English
SKU
9781718501065
ISBN
9781718501065
Reading Age
All
Dimensions
17.8x2.5x23.5cm
Binding
Paperback
MRP: โน 3,399
โน 3,230
โน 169 Off