SQL data cleaning methods you should know for Data Science:
1. Identifying Missing Data
2. Removing Duplicate Records
3. Handling Missing Data
4. Standardizing Data
5. Correcting Data Entry Errors
1. Identifying Missing Data
2. Removing Duplicate Records
3. Handling Missing Data
4. Standardizing Data
5. Correcting Data Entry Errors
👍5❤2
SQL Roadmap 👇👇
https://www.linkedin.com/posts/sql-analysts_sql-activity-7235150234706690048-ydnI
Like for more ❤️
https://www.linkedin.com/posts/sql-analysts_sql-activity-7235150234706690048-ydnI
Like for more ❤️
What's the full form of NoSQL?
Anonymous Quiz
17%
Next Structured Query Language
68%
No Structure Query Language
4%
Non Stop Query Language
11%
Not Only SQL
🤔27👍7❤4🎉3
SQL Programming Resources
What's the full form of NoSQL?
To be honest, I also wasn't aware of this fullform until today 😂
🤣29👍9
5 Key SQL Aggregate Functions for data analyst
🍞SUM(): Adds up all the values in a numeric column.
🍞AVG(): Calculates the average of a numeric column.
🍞COUNT(): Counts the total number of rows or non-NULL values in a column.
🍞MAX(): Returns the highest value in a column.
🍞MIN(): Returns the lowest value in a column.
🍞SUM(): Adds up all the values in a numeric column.
🍞AVG(): Calculates the average of a numeric column.
🍞COUNT(): Counts the total number of rows or non-NULL values in a column.
🍞MAX(): Returns the highest value in a column.
🍞MIN(): Returns the lowest value in a column.
❤9👍7👏1