![]() ![]() because real world you have to do shit like that a lot.The goal of /r/SQL is to provide a place for interesting and informative SQL content and discussions. If u really want to be a pro a discrete class or just a specific set theory class might help like another mentioned.Įdit: an addition, i would prefer to hire something who can talk to me about struggling through some data wrangling project because they were intermediate in sql, than someone who is advanced but didnt push their boundaries with projects etc. they were hard and I would sit there for hours troubleshooting cause i didn’t know anything- but thats how you learn in the tech industry (at least imo). When I shifted to DE I followed tutorials for architecting and deploying databases, tutorials for setting up projects using hadoop,spark,scalla, airflow, deploying on AWS. When I went into SDE i was googling tutorials on spinning up websites as a project, creating micro-service architectures, etc. These days the quality of info is very high. If you can’t on your own, there are lots of udemy courses and youtube tutorials that are very good at explaining. Now if you don’t have a job that means you need to do projects. Compsci is very much learn as you go, theres so much knowledge out there you can’t study everything. You might not be able to solo it but you can follow steps. That being said, just like SDE you need practical experience. If u want a job below senior you dont even need to be an expert. instead of “what would be the total monthly sales for each customer” ask “between which months of 2021 did we see the most MoM negative or positive change in sales by customer” then you can follow up by including and excluding trailing months (e.g. And try really hard to ask yourself some complex questions. You can ask the business questions, and then using the ERDs write hypothetical SQL to answer them. Some data connector companies, like fivetran, also have data ERDs online that show what data tables are provided when using their connectors. You can similarly do the same thing with any data set on kaggle or UCI etc, come up with real live business questions that you can use data to answer. That way, you get a sample of data and real life problems. I’ve worked at a few places that have given pretty relevant and wonderful data challenges. I’d recommend maybe doing some practice interviews for jobs you don’t really care much about. Honestly it shouldn’t be that bad, and if you are at a company that treats data as a first class citizen, hell even a third class citizen, you probably will not have to deal with the degree of stupid data decisions I’ve had to deal with. I learned the most when I had shitty DBs, where you had to cross join unnest to get particular values, use window functions to remove duplicates but only after making sure that you got the right record that had exactly one record of type a before it and x records of type b after it, oh and work with engineers who designed the tables that didn’t know why there would be duplicates in the first place. How do you use a query plan to produce efficient queries?.Explain the frame and window portions of window functions.What are the different methods to control values in DB's? When to use one instead of another?.Walk me through fill factor and fragmentation.What are the different DB objects, why use one instead of the other?.Differences between indexes on tables and views?.What's the purpose behind schema binding?.What's happening here? How do you resolve it? You've been given a FK violation error when attempting to insert a value.Your SQL isn't going to be expert level if you aren't being held to any requirements from a technical, performance and/or any other perspective. Think you kind of can't without experience in a strict system. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |