☰ Menu

📋 Table of Contents

No
ID
Name
Html
Type of knowledge
1
22
Different between SQL Server/PostgreSQL/MySQL
https://www.datacamp.com/blog/sql-server-postgresql-mysql-whats-the-difference-where-do-i-start
Sharing-data Analyst
Others
2
21
Different between SQL/MySQL/SQL Server
https://www.softwaretestinghelp.com/sql-vs-mysql-vs-sql-server/
Sharing-data Analyst
Others
3
25
Microsoft SQL Server Tutorial
https://learn.microsoft.com/en-us/sql/relational-databases/tutorial-getting-started-with-the-database-engine?view=sql-server-ver15
Sharing-data Analyst
microsoft
4
24
MySQL tutorial
https://dev.mysql.com/doc/mysql-getting-started/en/
Sharing-data Analyst
mysql
5
23
PostgreSQL Tutorial
www.postgresql.org/docs/10/tutorial-install.html
Sharing-data Analyst
postgresql
6
7
Project Based data analytics process
https://pingax.com/Data%20Analyst/understanding-data-analytics-project-life-cycle/
Sharing-data Analyst
Others
7
17
R: function, variables, data type, vectors
https://www.kaggle.com/code/rtatman/getting-started-in-r-first-steps
Sharing-data Analyst
Kaggle
8
29
SQL: CAST
https://www.coursera.org/learn/process-data/lecture/OlLEQ/advanced-data-cleaning-functions-part-1
Sharing-data Analyst
coursera
9
28
SQL: CONCAT/COALESCE
https://www.coursera.org/learn/process-data/lecture/BIh2D/advanced-data-cleaning-functions-part-2
Sharing-data Analyst
coursera
10
35
SQL: INNER/LEFT/RIGHT/OUTER JOIN
https://www.coursera.org/learn/analyze-data/lecture/uLZJH/explore-how-joins-work
Sharing-data Analyst
coursera
11
30
SQL: INSERT INTO/UPDATE
https://www.coursera.org/learn/process-data/lecture/Ktoxq/widely-used-sql-queries
Sharing-data Analyst
coursera
12
27
SQL: LENGTH/SUBSTR/TRIM
https://www.coursera.org/learn/process-data/lecture/xVA4Z/clean-string-variables-using-sql
Sharing-data Analyst
coursera
13
26
SQLite Tutorial
https://www.sqlite.org/quickstart.html
Sharing-data Analyst
sqlite