Data Cleansing 101: SQL Server Essentials

Focused View

Amruta Mahajan

35:14

0 View

1-Course Overview

1 -Course Overview.mp4

01:40

2-Understanding Data Quality Essentials

2 -Understanding Data Quality.mp4

05:22

3 -Demo Fundamental Querying for Data Exploration.mp4

03:21

4 -Basic Data Cleaning Techniques Eliminating Duplicate Records.mp4

02:03

5 -Demo Eliminating Duplicate Records.mp4

02:48

6 -Handling Missing Values.mp4

01:02

7 -Demo Handling Missing Values.mp4

02:08

8 -Fixing Inconsistent Data Formats.mp4

02:07

9 -Demo Fixing Inconsistent Data Formats.mp4

02:16

3-Beyond Cleaning Building a Reliable Data Future

10 -Data Integrity and Data Quality Checks.mp4

04:19

11 -Demo Data Integrity and Data Quality Checks.mp4

04:54

12 -Best Practices after the Data Cleaning Process.mp4

03:14

Description

Messy data and inconsistencies often lead to inaccurate conclusions and missed opportunities. This course will teach you to identify and resolve data inconsistencies, master essential cleansing techniques, and implement optimal maintenance practices.

What You'll Learn?

Often, you will come across messy data like duplicate entries, missing values, and inconsistent formats which will lead to inaccurate entries and unreliable analysis.

In this course, Data Cleansing 101: SQL Server Essentials, you’ll gain the ability to cleanse your data in SQL Server database, ensuring clean, reliable data for accurate analysis and confident decision-making.

First, you’ll sharpen your skills to identify and diagnose common data quality issues like duplicates, missing values, and formatting inconsistencies.

Next, you’ll explore powerful SQL queries and functions to remove duplicates, handle missing values, standardize formats, and transform your data into a pristine powerhouse.

Finally, you’ll discover essential best practices for data maintenance, preventing future data quality issues, and maintaining ongoing data integrity.

When you’re finished with this course, you’ll have the skills and knowledge you need to conquer data quality in SQL Server and unlock the full potential of your data for accurate analysis and confident decisions.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft SQL

Amruta Mahajan

Instructor's Courses

Amruta is an experienced Data Analyst with over 12 years of experience in interpreting and analyzing data to drive successful business outcomes. She loves tackling hard problems using data manipulation as her superpower and has worked with market leaders from various fields including Standard & Poors, McDonalds, Mondelez International, General Electric, AMD and Beam Suntory. Amruta is passionate about both teaching and learning and believes “The purpose of life is to discover your gift. The work of life is to develop it. The meaning of life is to give your gift away”. Amruta has an undergrad in Statistics and a Masters in Computer Science. She speaks English, Hindi and Marathi and codes in VBA, Python and R

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.