SQL Syntax tips for a beginner
Hello,
I am new to Domo but want to learn how to use Domo with SQL. I am advanced in R and I understand the logical needs. I was hoping someone had some SQL syntax tips or resources for learning the SQL language to implement in Domo.
Thanks!
Best Answer
-
Hi @user065584
Ones that I like that tend to be more interactive like:
https://www.w3schools.com/sql/default.asp
https://mystery.knightlab.com/ - More gamified learning
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Answers
-
Hi @user065584
Ones that I like that tend to be more interactive like:
https://www.w3schools.com/sql/default.asp
https://mystery.knightlab.com/ - More gamified learning
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
@user065584 , i have an answer you didn't ask for ... don't learn MySQL to become more effective in Domo.
Spend time in MagicETL. I get it, hard pill to swallow for a person who does scripting.
MagicETL will be faster than anything you write in MySQL. And the performance of Magic will continue to improve whereas MySQL will not (Magic 2.0 virtually obliterates the need for SQL processing except in the context of complex joins.)
If you want to get better at data pipelines, I strongly recommend Ralph Kimball's Data Warehouse Toolkit. It's all concepts and no code, but critical in building a framework on how to structure your data in Domo.
I would be warry of learning syntax because you can literally google MySQL documentation in seconds ... it's not really a high value piece of learning to absorb. Instead, knowing and recognizing dimensional modeling design patterns (Kimball) will give you much more mileage for effort, IMHO.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"5
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 747 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive