Skip to Main Content
Data Analytics & Visualization All-in-One For Dummies
book

Data Analytics & Visualization All-in-One For Dummies

by Jack A. Hyman, Luca Massaron, Paul McFedries, John Paul Mueller, Lillian Pierson, Jonathan Reichental, Joseph Schmuller, Alan R. Simon, Allen G. Taylor
April 2024
Beginner content levelBeginner
832 pages
20h 32m
English
For Dummies
Content preview from Data Analytics & Visualization All-in-One For Dummies

Chapter 3

Values, Variables, Functions, and Expressions

IN THIS CHAPTER

Bullet Discovering valid values for table columns

Bullet Summarizing data with set functions

Bullet Dissecting data with value functions

Bullet Converting data types

This chapter describes the tools that ISO/IEC standard SQL provides to operate on data. In addition to specifying the value of a data item, you can slice and dice an item in a variety of ways. Instead of just retrieving raw data as it exists in the database, you can preprocess it to deliver just the information you want, in the form that you want it.

Entering Data Values

After you’ve created a database table, the next step is to enter data into it. SQL supports a number of different data types. Within any specific data type, the data can take any of several forms. The five different forms that can appear in table rows are

  • Row values
  • Column references
  • Literal values
  • Variables
  • Special variables

Each form is discussed in turn throughout this section.

Row values have multiple parts

A row value includes the values of all the data in all the columns in a row in a table. It ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Data Science For Dummies

Data Science For Dummies

Lillian Pierson
Data Science For Dummies, 2nd Edition

Data Science For Dummies, 2nd Edition

Lillian Pierson, Jake Porway

Publisher Resources

ISBN: 9781394244096Purchase Link