
Learning SQL: Generate, Manipulate, and Retrieve Data
Paperback
Publisher Price: $65.99
ISBN13: 9781492057611
Publisher: Oreilly Media
Published: Apr 21 2020
Pages: 377
Weight: 1.30
Height: 0.70 Width: 7.00 Depth: 9.20
Language: English
As data floods into your company, you need to put it to work right away--and SQL is the best tool for the job. With the latest edition of this introductory guide, author Alan Beaulieu helps developers get up to speed with SQL fundamentals for writing database applications, performing administrative tasks, and generating reports. You'll find new chapters on SQL and big data, analytic functions, and working with very large databases.
Each chapter presents a self-contained lesson on a key SQL concept or technique using numerous illustrations and annotated examples. Exercises let you practice the skills you learn. Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly discover how to put the power and flexibility of this language to work.
- Move quickly through SQL basics and several advanced features
- Use SQL data statements to generate, manipulate, and retrieve data
- Create database objects, such as tables, indexes, and constraints with SQL schema statements
- Learn how datasets interact with queries; understand the importance of subqueries
- Convert and manipulate data with SQL's built-in functions and use conditional logic in data statements
Also in
Databases
Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable Systems
Kleppmann, Martin
Paperback
Fundamentals of Data Engineering: Plan and Build Robust Data Systems
Housley, Matt
Reis, Joe
Paperback
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Hardcover
Practical Statistics for Data Scientists: 50+ Essential Concepts Using R and Python
Gedeck, Peter
Bruce, Peter
Bruce, Andrew
Paperback
The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling
Kimball, Ralph
Ross, Margy
Paperback
Fusion Strategy: How Real-Time Data and AI Will Power the Industrial Future
Venkatraman, Venkat
Govindarajan, Vijay
Hardcover
SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL
Shields, Walter
Paperback
The Definitive Guide to Dax: Business Intelligence for Microsoft Power Bi, SQL Server Analysis Services, and Excel
Russo, Marco
Ferrari, Alberto
Paperback
Trustworthy Online Controlled Experiments: A Practical Guide to A/B Testing
Xu, Ya
Kohavi, Ron
Tang, Diane
Paperback
Introduction to Statistics: An Intuitive Guide for Analyzing Data and Unlocking Discoveries
Frost, Jim
Paperback
Product Operations: How successful companies build better products at scale
Perri, Melissa
Tilles, Denise
Paperback
The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Second Edition
Tibshirani, Robert
Hastie, Trevor
Friedman, Jerome
Hardcover
Data Analytics & Visualization All-In-One for Dummies
Massaron, Luca
Hyman, Jack A.
McFedries, Paul
Paperback
SQL Cookbook: Query Solutions and Techniques for All SQL Users
Graaf, Robert de
Molinaro, Anthony
Paperback
Hands-On Salesforce Data Cloud: Implementing and Managing a Real-Time Customer Data Platform
Avila, Joyce Kay
Paperback
Statistical Tableau: How to Use Statistical Models and Decision Science in Tableau
Lang, Ethan
Paperback
Becoming a Data Head: How to Think, Speak, and Understand Data Science, Statistics, and Machine Learning
Gutman, Alex J.
Goldmeier, Jordan
Paperback
Apache Iceberg: The Definitive Guide: Data Lakehouse Functionality, Performance, and Scalability on the Data Lake
Hughes, Jason
Merced, Alex
Shiran, Tomer
Paperback
Designing Data Governance from the Ground Up: Six Steps to Build a Data-Driven Culture
Maffeo, Lauren
Paperback
SQL for Data Analysis: Advanced Techniques for Transforming Data Into Insights
Tanimura, Cathy
Paperback
Mathletics: How Gamblers, Managers, and Fans Use Mathematics in Sports, Second Edition
Winston, Wayne L.
Nestler, Scott
Pelechrinis, Konstantinos
Paperback
Numerical Python: Scientific Computing and Data Science Applications with Numpy, Scipy and Matplotlib
Johansson, Robert
Paperback
Analytics the Right Way: A Business Leader's Guide to Putting Data to Productive Use
Wilson, Tim
Sutherland, Joe
Paperback
R in Action, Third Edition: Data Analysis and Graphics with R and Tidyverse
Kabacoff, Robert I.
Paperback
Databricks Certified Data Engineer Associate Study Guide: In-Depth Guidance and Practice
Alhussein, Derar
Paperback
Non-Invasive Data Governance: The Path of Least Resistance and Greatest Success
Seiner, Robert
Paperback
Data Modeling with Microsoft Power BI: Self-Service and Enterprise Data Warehouse with Power BI
Ehrenmueller-Jensen, Markus
Paperback
Agile Data Warehouse Design: Collaborative Dimensional Modeling, from Whiteboard to Star Schema
Corr, Lawrence
Stagnitto, Jim
Paperback
Football Analytics with Python & R: Learning Data Science Through the Lens of Sports
Erickson, Richard a.
Eager, Eric A.
Paperback
High Performance PostgreSQL for Rails: Reliable, Scalable, Maintainable Database Applications
Atkinson, Andrew
Paperback
Exam Ref Dp-600 Implementing Analytics Solutions Using Microsoft Fabric
Winter, Johnny
Resl, Stěpán
Maslyuk, Daniil
Paperback
Blockchain: The Comprehensive Guide to Blockchain Development, Ethereum, Solidity, and Smart Contracts
Schütz, Andreas
Fertig, Tobias
Paperback
Data and Reality: A Timeless Perspective on Perceiving and Managing Information in Our Imprecise World, 3rd Edition
Kent, William
Paperback
PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices
Ciolli, Gianni
Mejías, Boriss
Angelakos, Jimmy
Paperback
Turning Data into Wisdom: How We Can Collaborate with Data to Change Ourselves, Our Organizations, and Even the World
Hanegan, Kevin
Paperback
Collect, Combine, and Transform Data Using Power Query in Power Bi and Excel
Maslyuk, Daniil
Raviv, Gil
Paperback
Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us about Who We Really Are
Stephens-Davidowitz, Seth
Paperback
SQL Server 2022 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Fritchey, Grant
Paperback
Winning with Data Science: A Handbook for Business Leaders
Swaminathan, Akshay
Friedman, Howard Steven
Hardcover
Alteryx Designer: The Definitive Guide: Simplify and Automate Your Analytics
Burkhow, Joshua
Paperback
Databricks Data Intelligence Platform: Unlocking the Genai Revolution
Gupta, Nikhil
Yip, Jason
Paperback
Excel 2021: Everything you need to know about Excel to go from Beginner to Expert
Wright, Nora E.
Paperback
Observability Engineering: Achieving Production Excellence
Miranda, George
Majors, Charity
Fong-Jones, Liz
Paperback
Streaming Databases: Unifying Batch and Stream Processing
Dulay, Hubert
Debusmann, Ralph Matthias
Paperback
Data Governance: The Definitive Guide: People, Processes, and Tools to Operationalize Data Trustworthiness
Lakshmanan, Valliappa
Eryurek, Evren
Gilad, Uri
Paperback
Aerospike: Up and Running: Developing on a Modern Operational Database for Globally Distributed Apps
Autin, Albert
Srinivasan, V.
Faulkes, Tim
Paperback
Apache Airflow Best Practices: A practical guide to orchestrating data workflow with Apache Airflow
Intorf, Dylan
Doorn, Kendrick Van
Storey, Dylan
Paperback
Data Strategy: How to Profit from a World of Big Data, Analytics and Artificial Intelligence
Marr, Bernard
Paperback
Practical Time Series Analysis: Prediction with Statistics and Machine Learning
Nielsen, Aileen
Paperback
Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud
Aravindan, Arunjith
Ayyalusamy, Jeyaram
Paperback
Analytics Engineering with SQL and Dbt: Building Meaningful Data Models at Scale
Russa, Helder
Machado, Rui Pedro
Paperback
Implementing Data Mesh: Design, Build, and Implement Data Contracts, Data Products, and Data Mesh
Perrin, Jean-Georges
Broda, Eric
Paperback
Value-Driven Data: Identifying, Communicating and Delivering Effective Business Solutions with Data
Odaro, Edosa
Paperback
Cockroachdb: The Definitive Guide: Distributed Data at Scale
Darnell, Ben
Harrison, Guy
Seldess, Jesse
Paperback
High Performance Spark: Best Practices for Scaling and Optimizing Apache Spark
Warren, Rachel
Karau, Holden
Paperback
Kafka: The Definitive Guide: Real-Time Data and Stream Processing at Scale
Sivaram, Rajini
Shapira, Gwen
Palino, Todd
Paperback
The Data Storyteller's Handbook: How to create business impact using data storytelling
Greenbrook, Kat
Paperback
Data Engineering Design Patterns: Recipes for Solving the Most Common Data Engineering Problems
Konieczny, Bartosz
Paperback
Learn Microsoft Fabric: A practical guide to performing data analytics in the era of artificial intelligence
Schacht, Bradley
Ali, Arshad
Paperback
Build a Robo-Advisor with Python (from Scratch): Automate Your Financial and Investment Decisions
Michalka, Alex
Reider, Rob
Paperback
Optimizing DAX: Improving DAX performance in Microsoft Power BI and Analysis Services
Russo, Marco
Ferrari, Alberto
Paperback
Big Data in Der Mobilität: Akteure, Geschäftsmodelle Und Nutzenpotenziale Für Die Welt Von Morgen
Gatzert, Nadine
Knorre, Susanne
Müller-Peters, Horst
Paperback
Blueprints for Text Analytics Using Python: Machine Learning-Based Solutions for Common Real World (Nlp) Applications
Winkler, Christian
Albrecht, Jens
Ramachandran, Sidharth
Paperback
Data Engineering Best Practices: Architect robust and cost-effective data solutions in the cloud era
Larochelle, David
Schiller, Richard J.
Paperback
Data Governance Handbook: A practical approach to building trust in data
Batchelder, Wendy S.
Paperback
Object-Role Modeling Fundamentals: A Practical Guide to Data Modeling with ORM
Halpin, Terry
Paperback
Business 101 for the Data Professional: What You Need to Know to Succeed in Business
Morrow, Jordan
Paperback
Delta Lake: The Definitive Guide: Modern Data Lakehouse Architectures with Data Lakes
Wentling, Tristen
Haines, Scott
Lee, Denny
Paperback
Mongodb: The Definitive Guide: Powerful and Scalable Data Storage
Brazil, Eoin
Chodorow, Kristina
Bradshaw, Shannon
Paperback
Product Analytics: Applied Data Science Techniques for Actionable Consumer Insights
Rodrigues, Joanne
Paperback
SQL for Data Scientists: A Beginner's Guide for Building Datasets for Analysis
Teate, Renee M. P.
Paperback
Text as Data: A New Framework for Machine Learning and the Social Sciences
Stewart, Brandon M.
Grimmer, Justin
Roberts, Margaret E.
Paperback
Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud
Avila, Joyce Kay
Paperback
Azure Data Factory by Example: Practical Implementation for Data Engineers
Swinbank, Richard
Paperback
PostgreSQL Query Optimization: The Ultimate Guide to Building Efficient Queries
Database Expert
Dombrovskaya, Henrietta
Bailliekova, Anna
Paperback
Data Analytics with Hadoop: An Introduction for Data Scientists
Kim, Jenny
Bengfort, Benjamin
Paperback
Practical Lakehouse Architecture: Designing and Implementing Modern Data Platforms at Scale
Thalpati, Gaurav Ashok
Paperback
High Performance Python: Practical Performant Programming for Humans
Ozsvald, Ian
Gorelick, Micha
Paperback
Text Data Management and Analysis: A Practical Introduction to Information Retrieval and Text Mining
Zhai, Chengxiang
Massung, Sean
Paperback
Predictive Analytics for the Modern Enterprise: A Practitioner's Guide to Designing and Implementing Solutions
Ali, Nooruddin Abbas
Paperback
Learn PostgreSQL - Second Edition: Use, manage and build secure and scalable databases with PostgreSQL 16
Pirozzi, Enrico
Ferrari, Luca
Paperback
Database Management for Business Leaders: Building and Using Data Solutions That Work for You
Ruddell, Larry
Paperback
Aprende SQL en un fin de semana: El curso definitivo para crear y consultar bases de datos
Padial Solier, Antonio
Paperback
Practical Natural Language Processing: A Comprehensive Guide to Building Real-World Nlp Systems
Vajjala, Sowmya
Gupta, Anuj
Majumder, Bodhisattwa
Paperback
SAP S/4hana Financial Accounting Certification Guide: Application Associate Exam
Pougkas, Stefanos
Paperback
The Decision Maker's Handbook to Data Science: AI and Data Science for Non-Technical Executives, Managers, and Founders
Kampakis, Stylianos
Paperback
The Enterprise Data Catalog: Improve Data Discovery, Ensure Data Governance, and Enable Innovation
Olesen-Bagneux, Ole
Paperback
Applied Unsupervised Learning with Python
Johnston, Benjamin
Jones, Aaron
Kruger, Christopher
Paperback
Practical Serverless Applications with AWS: Harnessing the Power of Serverless Cloud Applications
Prakash, Apoorva
Basha, Shaik Inthiyaz
Paperback
Data Mining Techniques: For Marketing, Sales, and Customer Relationship Management
Berry, Michael J. a.
Linoff, Gordon S.
Paperback
Pandas Cookbook - Third Edition: Practical recipes for scientific computing, time series, and exploratory data analysis using Python
Harrison, Matthew
Ayd, William
Paperback
Data-Driven Talent Management: Using Analytics to Improve Employee Experience
Saling, Kristin
Paperback
Data Quality Fundamentals: A Practitioner's Guide to Building Trustworthy Data Pipelines
Vorwerck, Molly
Moses, Barr
Gavish, Lior
Paperback
Data and Analytics Strategy for Business: Unlock Data Assets and Increase Innovation with a Results-Driven Data Strategy
Asplen-Taylor, Simon
Paperback
Azure SQL Revealed: The Next-Generation Cloud Database with AI and Microsoft Fabric
Ward, Bob
Paperback
MICROSOFT EXCEL & ACCESS For Beginners and Pros. 2024: A Complete Guide to Master Excel and Access 365 for All Users
Sherer, Charles
Paperback
Principles of Data Science: Mathematical techniques and theory to succeed in data-driven industries
Ozdemir, Sinan
Paperback
Cracking the Data Engineering Interview: Land your dream job with the help of resume-building tips, over 100 mock questions, and a unique portfolio
Bryan, Kedeisha
Ransome, Taamir
Paperback
Essential Data Analytics, Data Science, and AI: A Practical Guide for a Data-Driven World
Attobrah, Maxine
Paperback
Mastering Python for Bioinformatics: How to Write Flexible, Documented, Tested Python Code for Research Computing
Youens-Clark, Ken
Paperback