How to Clean Raw Data 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.
To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ► https://goo.gle/3amvXxY
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.
Visit https://goo.gle/2NCbbSc to learn more today.
#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics
Видео How to Clean Raw Data in SQL | Google Data Analytics Certificate канала Google Career Certificates
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.
To access the full program content including readings, practice exercises, job search help, and discussion forums please visit ► https://goo.gle/3amvXxY
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.
Visit https://goo.gle/2NCbbSc to learn more today.
#GrowWithGoogle #GoogleCareerCertificate #DataAnalytics
Видео How to Clean Raw Data in SQL | Google Data Analytics Certificate канала Google Career Certificates
Показать
Комментарии отсутствуют
Информация о видео
11 июня 2021 г. 18:15:05
00:42:44
Другие видео канала
Understanding Clean Data | Google Data Analytics CertificateSQL for Data Analysts and Data Scientists IN 1 HOURCreating Database with SQLiteRunning Basic Statistical Analysis in RReviewing Google Data Analytics Certificate | Should You Take It?Ways to Ensure Data Integrity | Google Data Analytics CertificateHow To Get a Data Analyst Job (with No Experience)Process Data from Dirty to Clean - Part 4 of the Google Data Analytics CertificateTableau Data Analysis Project: Sales Insights : 4 - Data Cleaning & ETL in TableauData Analyst Portfolio Project #1 | Build a Database | Develop SQL | Create a DashboardGoogle vs IBM Data Analyst Certificate - BEST Certificate for Data AnalystsBecome a DATA ANALYST with NO degree?!? The Google Data Analytics Professional CertificateExcel Crash Course - Data Cleaning in Excel - Microsoft Excel TutorialHow I Would Learn to be a Data AnalystData Cleaning Using SQLDay in the Life of a Data Analyst - SurveyMonkey Data TransformationAsk Questions to Make Data-Driven Decisions - Part 2 of 7 of the Google Data Analytics CertificateGoogle Colab - Clean Google Sheets Data, Dealing With Inconsistent DataGoogle Data Analytics Professional Certificate - Full course Part 1 of 7