Long Bui Discovering new things. Data x Platform Ops

Real Learning About SQL

Real Learning About SQL

Diagram of showing the path to learn SQL

Be clear and question what you hear about.

flowchart TB subgraph sqlBank direction TB subgraph basic K1[Data modeling] K2[Data structure] K3[Data Manipulation] end subgraph advance K4[Data Partitioning] K5[Database management] K6[Distributed Database] K7[How data movement is handled] K8[Data Warehouse and Lakehouses] end basic --> advance end A[Learn SQL as Data Discoverer] -->|Finding right method| B(Writing the SQL statements) B --> C{Is that enough ?} C -.Yes.-> D[Trapped] C ==>|No| E[SQL Bank] E --> sqlBank ```

Thoughts that what actually needs to be learned from SQL

  • They say that As Data Worker, we need to learn the SQL
  • They provide the SQL mandatory functionality of SQL scripting
  • But what do you think about this? Is that good enough?

Key Notes

  • NO, it is not just SQL Script
  • You are misleading from the word
  • About SQL: we need to learn:

Basic

  • Data modeling
  • Data structure
  • Data Manipulation

Advanced

  • Data Partitioning
  • Database management
  • Distributed Database
  • How data movement is handled
  • Data Warehouse and Lakehouses

Subscribe to keep you posted the latest updates