23 hours (approximately)
Grade Achieved: 84.39%
By the end of this course, you will be able to do the following: – Learn how to check for data integrity. – Discover data cleaning techniques using spreadsheets. – Develop basic SQL queries for use on databases. – Apply basic SQL functions for cleaning and transforming data. – Gain an understanding of how to verify the results of cleaning data. – Explore the elements and importance of data cleaning reports.
WHAT YOU WILL LEARN
-
Define data integrity with reference to types of integrity and risk to data integrity
-
Apply basic SQL functions for use in cleaning string variables in a database
-
Develop basic SQL queries for use on databases
-
Describe the process involved in verifying the results of cleaning data
