Data Analytics
Data Analyst Roadmap 👆👆 More quality content coming soon 😄❤️
What to cover next?
Anonymous Poll
46%
SQL
38%
Python
29%
Statistics
44%
Power BI
25%
Tableau
7%
Qlik
13%
R
17%
ML/AI
30%
Excel
👍89👏10🔥9😢4🥰2❤1👎1😁1
Which of the following SQL statement is used to fetch only those Company and Country columns from Customers table where County is 'USA'?
Anonymous Quiz
21%
SELECT Company FROM Customers WHERE Country = 'USA'
63%
SELECT Company, Country FROM Customers WHERE Country = 'USA'
8%
SELECT Country FROM Customers WHERE Country = 'USA'
8%
FETCH Company, Country FROM Customers WHERE Country = 'USA'
🔥28👍25❤7👏7😁7
Data Analytics
What to cover next?
Nice to see amazing response for SQL, Power BI, Statistics, Python & Excel :)
👍47❤8👏2
Forwarded from SQL Programming Resources
Road map to learn SQL
https://xn--r1a.website/sqlanalyst/3
https://xn--r1a.website/sqlanalyst/3
👍33❤13
Which of the following is not a window function in SQL?
Anonymous Quiz
7%
RANK()
24%
ROW_NUMBER
59%
RANKIFY()
10%
DENSE_RANK()
😁27👍16
Which of the following is a SQL constraint?
Anonymous Quiz
8%
NOTIFY
27%
SELECT
9%
WRONG
56%
NOT NULL
👍17❤4👏3👌1
Which of the following is DML command in SQL?
Anonymous Quiz
66%
INSERT
22%
CREATE
7%
NOTIFY
6%
NULL
👍17🥰2
Which of the following function is used to return length of the string?
Anonymous Quiz
78%
LEN()
3%
LEFT()
1%
RIGHT()
17%
STRINGLENGTH()
👍11👏2😁1
Useful websites to practice and enhance your Data Analytics skills
👇👇
1. SQL
https://mode.com/sql-tutorial/introduction-to-sql
https://xn--r1a.website/sqlspecialist/232?single
2. Python
https://www.learnpython.org/
https://bit.ly/3T7y4ta
https://www.geeksforgeeks.org/python-programming-language/learn-python-tutorial
3. R
https://www.datacamp.com/courses/free-introduction-to-r
4. Data Structures
https://leetcode.com/study-plan/data-structure/
https://www.udacity.com/course/data-structures-and-algorithms-in-python--ud513
5. Data Visualization
https://www.freecodecamp.org/learn/data-visualization/
https://www.tableau.com/learn/training/20223
https://www.workout-wednesday.com/power-bi-challenges/
6. Excel
https://excel-practice-online.com/
https://www.w3schools.com/EXCEL/index.php
Join @free4unow_backup for more free courses
ENJOY LEARNING 👍👍
👇👇
1. SQL
https://mode.com/sql-tutorial/introduction-to-sql
https://xn--r1a.website/sqlspecialist/232?single
2. Python
https://www.learnpython.org/
https://bit.ly/3T7y4ta
https://www.geeksforgeeks.org/python-programming-language/learn-python-tutorial
3. R
https://www.datacamp.com/courses/free-introduction-to-r
4. Data Structures
https://leetcode.com/study-plan/data-structure/
https://www.udacity.com/course/data-structures-and-algorithms-in-python--ud513
5. Data Visualization
https://www.freecodecamp.org/learn/data-visualization/
https://www.tableau.com/learn/training/20223
https://www.workout-wednesday.com/power-bi-challenges/
6. Excel
https://excel-practice-online.com/
https://www.w3schools.com/EXCEL/index.php
Join @free4unow_backup for more free courses
ENJOY LEARNING 👍👍
👍46❤13👏5🥰2🎉2🔥1
Data Analytics
Nice to see amazing response for SQL, Power BI, Statistics, Python & Excel :)
Data Analysis with Excel
👇👇
https://xn--r1a.website/excel_analyst/2
Power BI DAX Functions
👇👇
https://xn--r1a.website/PowerBI_analyst/2
All about SQL
👇👇
https://xn--r1a.website/sqlanalyst/29
Python for data analysis
👇👇
https://xn--r1a.website/pythonanalyst/26
Statistics Book and other useful resources
👇👇
https://xn--r1a.website/DataAnalystInterview/34
Join channel as per your interest :)
👇👇
https://xn--r1a.website/excel_analyst/2
Power BI DAX Functions
👇👇
https://xn--r1a.website/PowerBI_analyst/2
All about SQL
👇👇
https://xn--r1a.website/sqlanalyst/29
Python for data analysis
👇👇
https://xn--r1a.website/pythonanalyst/26
Statistics Book and other useful resources
👇👇
https://xn--r1a.website/DataAnalystInterview/34
Join channel as per your interest :)
👍52❤15👏7🔥2🥰2😁1
Do you also need data analysis projects and more free courses to be shared in this channel?
Anonymous Poll
98%
Yes
2%
Not needed as of now
👍33👏5
Which of the following function is used to capitalize first letter in SQL?
Anonymous Quiz
53%
UPPER()
29%
INITCAP()
1%
LOWER()
17%
FIRSTLETTERCAPITAL()
👍32❤1🔥1