Which of the following is not an aggregate function in SQL?
Anonymous Quiz
21%
COUNT
7%
SUM
9%
AVG
64%
TOTAL
🔥16👍4👏4😁4🥰1
Which of the following is not part of DDL (Data Definition Language) in SQL?
Anonymous Quiz
13%
CREATE
18%
ALTER
22%
DROP
47%
SELECT
👍13❤5🔥2
Which of the following is part of DML(Data Manipulation Language) in SQL?
Anonymous Quiz
23%
SELECT
18%
CREATE
25%
Group by
34%
INSERT
👍10🥰9❤2🎉2👏1
Learning and Practicing SQL: Resources and Platforms
1. https://sqlbolt.com/
2. https://sqlzoo.net/
3. https://www.codecademy.com/learn/learn-sql
4. https://www.w3schools.com/sql/
5. https://www.hackerrank.com/domains/sql
6. https://www.windowfunctions.com/
7. https://selectstarsql.com/
8. https://quip.com/2gwZArKuWk7W
9. https://leetcode.com/problemset/database/
10. https://thedatamonk.com
1. https://sqlbolt.com/
2. https://sqlzoo.net/
3. https://www.codecademy.com/learn/learn-sql
4. https://www.w3schools.com/sql/
5. https://www.hackerrank.com/domains/sql
6. https://www.windowfunctions.com/
7. https://selectstarsql.com/
8. https://quip.com/2gwZArKuWk7W
9. https://leetcode.com/problemset/database/
10. https://thedatamonk.com
👍50❤9👏8
Do you want to know about roadmap/required skills to become data analyst?
Anonymous Poll
91%
Yes
9%
No
👍23❤5🔥4👏2
Ok guys I am planning to share complete roadmap for data analyst with Free Resources from tomorrow
Share our channel with your friends and keep supporting ❤️❤️
👇👇
https://t.iss.one/sqlspecialist
Share our channel with your friends and keep supporting ❤️❤️
👇👇
https://t.iss.one/sqlspecialist
❤71👍38👏19
Which of the following skill/skills you already know?
Anonymous Poll
70%
Basic Excel
24%
Statistics
9%
R
41%
Python
50%
SQL
26%
Advanced Excel
21%
Numpy & Pandas
26%
Power BI
17%
Tableau
12%
None of the above
👍85🔥11👏7👎5🤩3❤2
Resources for Advanced Excel:
Datacamp course:
https://learn.datacamp.com/skill-tracks/spreadsheet-fundamentals?version=1
Chandoo’s youtube channel:
https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Free Excel Book
https://t.iss.one/learndataanalysis
Data Visualization in Excel
https://bit.ly/3JDEs6A
Datacamp course:
https://learn.datacamp.com/skill-tracks/spreadsheet-fundamentals?version=1
Chandoo’s youtube channel:
https://www.youtube.com/channel/UC8uU_wruBMHeeRma49dtZKA
Free Excel Book
https://t.iss.one/learndataanalysis
Data Visualization in Excel
https://bit.ly/3JDEs6A
❤20👍15🥰1👏1
Free Resources to learn BI tools:
Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9
Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ
Tableau Book
https://t.iss.one/sqlspecialist/51
Power BI Book
https://t.iss.one/sqlspecialist/85
Abhishek Agarwal: https://www.youtube.com/playlist?list=PL6_D9USWkG1C4raCOTlTf_oq4XnNNNtm9
Bharti consultancy: https://www.youtube.com/playlist?list=PLyD1XCIRA3gQmN73dHwQWr4R08ABZFMtZ
Tableau Book
https://t.iss.one/sqlspecialist/51
Power BI Book
https://t.iss.one/sqlspecialist/85
👍24❤3👏2
Don't focus on learning too many things from multiple resources at a time. That's why i am sharing only limited resources
Quality>Quantity
Quality>Quantity
❤71👍28👏6🥰2
Free Resources for Python
Codebasics python tutorials (first 16) —
https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0
Practice Python course
https://dabeaz-course.github.io/practical-python/Notes/Contents.html
Codebasics python HINDI tutorials —
https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO
Useful Python resources for beginners
https://t.iss.one/programming_guide/8
Python 3 Book for beginners
https://t.iss.one/pythondevelopersindia/272?single
Codebasics python tutorials (first 16) —
https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0
Practice Python course
https://dabeaz-course.github.io/practical-python/Notes/Contents.html
Codebasics python HINDI tutorials —
https://www.youtube.com/playlist?list=PLPbgcxheSpE1DJKfdko58_AIZRIT0TjpO
Useful Python resources for beginners
https://t.iss.one/programming_guide/8
Python 3 Book for beginners
https://t.iss.one/pythondevelopersindia/272?single
👍22❤9👏2🔥1
Now that you have gained all the right skills, you need to showcase your skills and stand out from others to land a job. Projects and Portfolios will do that for you, so invest an ample amount of time in preparing these. You can find enough and more datasets in Kaggle for doing projects. Do a bit research and start working on it. Once its done, prepare an insightful resume and start applying for jobs and internships.
❤46👍21🔥6
Data Analyst Resume Template-
https://www.dayjob.com/downloads/CV_examples/data_analyst_CV_template.pdf
Kaggle exploratory data analysis
* Notebooks:
https://www.kaggle.com/notebooks
* Datasets:
https://www.kaggle.com/datasets
Project ideas:
Alex the Analyst Portfolio Project Series:
https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&t=0s
https://www.dayjob.com/downloads/CV_examples/data_analyst_CV_template.pdf
Kaggle exploratory data analysis
* Notebooks:
https://www.kaggle.com/notebooks
* Datasets:
https://www.kaggle.com/datasets
Project ideas:
Alex the Analyst Portfolio Project Series:
https://www.youtube.com/watch?v=qfyynHBFOsM&list=PLUaB-1hjhk8H48Pj32z4GZgGWyylqv85f&t=0s
👍29❤13🔥5👏2😁1😢1
Which situation is perfect to use bar chart?
Anonymous Quiz
19%
Viewing trends in data over time.
56%
Comparing data across categories.
17%
Showing hierarchical data as a proportion of a whole.
9%
Showing duration over time.
👍8❤2
Full form of KPIs in analytics domain?
Anonymous Quiz
9%
Key Problem Indexes
75%
Key Performance Indicators
7%
Key Problem Indicators
9%
Key Processing Indexes
👍20😁9
Which of the following statement is true about KPIs and metrics?
Anonymous Quiz
68%
Every KPI is a metric, but not every metric is a KPI.
32%
Every metric is a KPI, but not every KPI is a metric.
👍14🤔9😁8
Which chart type is perfect for showing Project timeline?
Anonymous Quiz
24%
Bar chart
39%
Gantt chart
17%
Scatter plot
20%
Histogram
👍29
When should you use histogram?
Anonymous Quiz
75%
Understanding the distribution of your data.
25%
Showing duration over time
👍18
👏12❤1👍1
👍11🥰1
👍15👏4🔥2