Data Cleaning in SQL | Google Data Analytics Certificate

Learn about the different data cleaning functions in spreadsheets and SQL, and how SQL can be used to clean large datasets. See how to develop basic search queries for databases and how to apply basic SQL functions for transforming data and cleaning strings. 0:00 Use SQL to Clean Data 0:28 Understanding SQL Capabilities 3:49 SQL vs. Spreadsheets 8:04 Common SQL Queries 14:15 Cleaning String Variables Using SQL 27:03 Advanced Data Cleaning Functions 33:25 Advanced Data Cleaning Functions Pt. 2 This video is part of the Google Data Analytics Certificate which teaches learners how to prepare, process, analyze, share, and act on data. The program, created by Google employees in the field, is designed to provide you with job-ready skills in about 6 months to start or advance your career in data analytics. Take the Certificate HERE: https://career.skills.google/paths/2267/?utm_source=youtube&utm_medium=social&utm_campaign=youtube-description__geo--Global__con--DA__ter--r7GDQt3lZxs Subscribe HERE: https://bit.ly/SubscribeGCC #GrowWithGoogle #GoogleCareerCertificate #DataAnalytics Why earn a Google Career Certificate? ► No experience necessary: Learn job-ready skills, with no college degree required. ► Learn at your own pace: Complete the 100% online courses on your own terms. ► Stand out to employers: Make your resume competitive with a credential from Google. ► A path to in-demand jobs: Connect with top employers who are currently hiring.