Companies Home Search Profile

Learning SQL: Generate, Manipulate, and Retrieve Data

Learning SQL: Generate, Manipulate, and Retrieve Data

Download pdf

Learning SQL: Generate, Manipulate, and Retrieve Data

Learning SQL: Generate, Manipulate, and Retrieve Data

Category

Data Mining

SQL

Author

Alan Beaulieu

Publication

OReilly Media

0 View

As data floods into your company, you need to put it to work right awayand 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. Youll 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, youll 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 SQLs built-in functions and use conditional logic in data statements

'

Download pdf

ISBN-10

1492057614

ISBN-13

978-1492057611

Publisher

OReilly Media

Price

28.49

File Type

PDF

Page No.

377

Alan Beaulieu

Discover more of the author’s books, see similar authors, read author blogs and more ...

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 25 years. He is the author of Learning SQL and Mastering Oracle SQL (OReilly), and has written an online course on SQL for the University of California. He currently runs his own consulting company that specializes in database design and development in the fields of Financial Services and Telecommunications. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

Similar Books

Machine Learning for Text

Machine Learning for Text

Charu C. Aggarwal

Machine Learning

Pandas 1.x Cookbook: Practical recipes for scientific computing, time series analysis, and exploratory data analysis using Python, 2nd Edition

Pandas 1.x Cookbook: Practical recipes for scientific computing, time series analysis, and exploratory data analysis using Python, 2nd Edition

Ted Petrou

PostgreSQL 13 Cookbook: Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions

PostgreSQL 13 Cookbook: Over 120 recipes to build high-performance and fault-tolerant PostgreSQL database solutions

Avinash Vallarapu

The Kaggle Book: Data analysis and machine learning for competitive data science

The Kaggle Book: Data analysis and machine learning for competitive data science

Luca Massaron

Machine Learning

Hands-On Data Preprocessing in Python: Learn how to effectively prepare data for successful data analytics

Hands-On Data Preprocessing in Python: Learn how to effectively prepare data for successful data analytics

Roy Jafari

Cleaning Data for Effective Data Science: Doing the other 80% of the work with Python, R, and command-line tools

Cleaning Data for Effective Data Science: Doing the other 80% of the work with Python, R, and command-line tools

David Mertz

Hands-On Data Analysis with Pandas: A Python data science handbook for data collection, wrangling, analysis, and visualization, 2nd Edition

Hands-On Data Analysis with Pandas: A Python data science handbook for data collection, wrangling, analysis, and visualization, 2nd Edition

Stefanie Molin

Data Mining Approaches for Big Data and Sentiment Analysis in Social Media (Advances in Data Mining and Database Management)

Data Mining Approaches for Big Data and Sentiment Analysis in Social Media (Advances in Data Mining and Database Management)

Brij B Gupta

Hands-On Deep Learning with Apache Spark: Build and deploy distributed deep learning applications on Apache Spark

Hands-On Deep Learning with Apache Spark: Build and deploy distributed deep learning applications on Apache Spark

Guglielmo Iozzia

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

Scott Cosentino

Software Development

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Ahmad Osama

Microsoft Azure

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Hans-Jürgen Schönig

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Anthony DeBarros

SQL Pocket Primer

SQL Pocket Primer

Oswald Campesato

Apache Pulsar in Action

Apache Pulsar in Action

David Kjerrumgaard

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

Jörg Brandeis

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Gilit Saporta

MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators

Alkin Tezuysal

Other Authors' Books

Other Publishing Books

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Vlad Khononov

Software Architecture

CockroachDB: The Definitive Guide: Distributed Data at Scale

CockroachDB: The Definitive Guide: Distributed Data at Scale

Guy Harrison

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Dmitri Korotkevitch

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Akash Tandon

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Joyce Avila

Cloud Computing

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Wes McKinney

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Bonny P McClain

Efficient Go: Data-Driven Performance Optimization

Efficient Go: Data-Driven Performance Optimization

Bartlomiej Plotka

Software Development

Foundations of Scalable Systems: Designing Distributed Architectures

Foundations of Scalable Systems: Designing Distributed Architectures

Ian Gorton

Software Development

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Luke Kysow

Reliable Machine Learning: Applying SRE Principles to ML in Production

Reliable Machine Learning: Applying SRE Principles to ML in Production

Todd Underwood

Machine Learning

Operating OpenShift: An SRE Approach to Managing Infrastructure

Operating OpenShift: An SRE Approach to Managing Infrastructure

Manuel Dewald

Software Development

User Reviews

Log in first to post a comment

Rating

0

0

0

0

0

average 0

Total votes0