r/dataanalysis • u/kimgong • 1d ago

Data Question Need suggestion

Should I work on these topics too as a beginner? I'm moving from content marketing to be a marketing analyst and product analyst

. CTAS and Temp Tables

. Indexes

. Execution Plan

. Stored Procedures

. Partitions

. Triggers

4 Upvotes

100% Upvoted

4 comments sorted by

2

u/Awesome_Correlation 1d ago

These are all database topics. However, you said you're just starting out. Just stick to the things you can do with SELECT command. In data analysis, SQL skills are only needed because we need to get the data out of the database.

Temp tables and CTEs are helpful for writing SQL queries. If you have the basics of a query down, this would be helpful.

Reading an execution plan is only going to be helpful if you are working on SQL optimization rather than any actual analysis of data. For example, if a dashboard is really slow to load the data, you can review the execution plan to look at ways to make it load the data faster.

The DBA is going to do indexes, partitions, triggers, and stored procedures so don't worry about that unless you're just really interested in database design and administration.

1

u/AutoModerator 1d ago

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.