I'm a full time Magento developer and site manager and have been for the last year and a half. I have built multiple modules that safely extend the store and are coded "the Magento way".
I want to invest in becoming a certified developer but am concerned that my limited knowledge of MySQL structure may be my demise. I understand foreign keys and their purpose but have spent practically zero time developing tables that implement them. The same applies for other, somewhat advanced, MySQL functionality.
Are there any resources that I can crawl through to gauge my working knowledge in order to gain an understanding of where I stand? How should I move forward from here in working towards my certification?
I'm not sure if you know, but we do have both a Moderator's Kit for studying: https://magento.com/training/catalog/moderators-kit as well as a Magento Moderated Study Group: https://magento.com/training/catalog/0075-magento-u
Let me know if you have any questions on either - happy to help.
To be clear, since you posted this under M2, all of our current certifications are for M1 with the exception of the M2 Trained Partner badge that is a team effort available only to partners.