Data Types

A user named Elizabeth McKenzie is on a website that asks for her full name: first, middle, and last. However, she does not have a middle name at all.  She enters “Elizabeth” for the first name and “McKenzie” for the last name and clicks submit.  The website then saves her name in a database, and there is nothing to put in the MiddleName column.

Sometimes a value is not known.  It’s not that the value is 0 or an empty string, but just nothing at all. Enter the term used to describe the absence of a value:

NULL

When working with data in a SQL database, each column will have a data type.  There are many types for storing things like numbers, dates, and strings.  Enter the name of the commonly used data type that can store numbers without decimal places within the range from about -2 billion to 2 billion:

INT

Instructions: 

  1. Click the play button to watch the video lesson.
  2. Watch the lesson as many times as needed.
  3. Code along with the instructor using the integrated code editor in the center of your screen.
  4. You can use the Run button beneath the code editor to test your code.
  5. Output from the code that you have written will appear in the panel on the right side of your screen.

If you get stuck or need assistance, you can click the button below to connect with a tutor. 

For additional questions or technical support, email support@veroskills.com