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
Q. Explain the data preprocessing steps in data analysis.
Ans. Data preprocessing transforms the data into a format that is more easily and effectively processed in data mining, machine learning and other data science tasks.
1. Data profiling.
2. Data cleansing.
3. Data reduction.
4. Data transformation.
5. Data enrichment.
6. Data validation.
Q. What Are the Three Stages of Building a Model in Machine Learning?
Ans. The three stages of building a machine learning model are:
Model Building: Choosing a suitable algorithm for the model and train it according to the requirement
Model Testing: Checking the accuracy of the model through the test data
Applying the Model: Making the required changes after testing and use the final model for real-time projects
Q. What are the subsets of SQL?
Ans. The following are the four significant subsets of the SQL:
Data definition language (DDL): It defines the data structure that consists of commands like CREATE, ALTER, DROP, etc.
Data manipulation language (DML): It is used to manipulate existing data in the database. The commands in this category are SELECT, UPDATE, INSERT, etc.
Data control language (DCL): It controls access to the data stored in the database. The commands in this category include GRANT and REVOKE.
Transaction Control Language (TCL): It is used to deal with the transaction operations in the database. The commands in this category are COMMIT, ROLLBACK, SET TRANSACTION, SAVEPOINT, etc.
Q. What is a Parameter in Tableau? Give an Example.
Ans. A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines.
For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter.
Ans. Data preprocessing transforms the data into a format that is more easily and effectively processed in data mining, machine learning and other data science tasks.
1. Data profiling.
2. Data cleansing.
3. Data reduction.
4. Data transformation.
5. Data enrichment.
6. Data validation.
Q. What Are the Three Stages of Building a Model in Machine Learning?
Ans. The three stages of building a machine learning model are:
Model Building: Choosing a suitable algorithm for the model and train it according to the requirement
Model Testing: Checking the accuracy of the model through the test data
Applying the Model: Making the required changes after testing and use the final model for real-time projects
Q. What are the subsets of SQL?
Ans. The following are the four significant subsets of the SQL:
Data definition language (DDL): It defines the data structure that consists of commands like CREATE, ALTER, DROP, etc.
Data manipulation language (DML): It is used to manipulate existing data in the database. The commands in this category are SELECT, UPDATE, INSERT, etc.
Data control language (DCL): It controls access to the data stored in the database. The commands in this category include GRANT and REVOKE.
Transaction Control Language (TCL): It is used to deal with the transaction operations in the database. The commands in this category are COMMIT, ROLLBACK, SET TRANSACTION, SAVEPOINT, etc.
Q. What is a Parameter in Tableau? Give an Example.
Ans. A parameter is a dynamic value that a customer could select, and you can use it to replace constant values in calculations, filters, and reference lines.
For example, when creating a filter to show the top 10 products based on total profit instead of the fixed value, you can update the filter to show the top 10, 20, or 30 products using a parameter.
👍13❤4😍1
The SQL EXISTS operator tests the existence of any value in a subquery i.e. it executes the outer SQL query only if the subquery is not NULL (empty result-set),making it perfect for validating the presence of related data.
The result of EXISTS is a boolean value either True or False
We can also use the NOT operator to inverse the working of the EXISTS clause. The SQL command executes if the subquery returns an empty result-set.
The result of EXISTS is a boolean value either True or False
We can also use the NOT operator to inverse the working of the EXISTS clause. The SQL command executes if the subquery returns an empty result-set.
👍4