From the course: SQL for Data Analysis
Join today to access over 24,400 courses taught by industry experts.
Finding missing values - SQL Tutorial
From the course: SQL for Data Analysis
Finding missing values
- [Instructor] Next, we'll take a look at how we can identify missing data in our database. Missing data can have major implications for your development project, affecting your customer's experience and your organization's reputation. Let's look at some ways to identify data that may be missing. I'm going to go to the chapter two directory finding missing values, and first we're going to take a look at the salesperson's table. The database team has added a new column called Status. Here's a script we can run to add that new column to the salesperson table. Let's click on Run on Active Connection again, that adds the column to our table. Now, when we run select status from salesperson, we see that all the values for status are listed as null. Null represents an empty value. The value could be null upon creation of the record or it can be assigned a null value from the program. Of course, that depends on if our column…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
