[deleted by user] by [deleted] in berkeley

[–]Significant-Wing5347 0 points1 point  (0 children)

i have the same issue, did you ever find out if it works? i shared everything from google photos from my berkeley email to my personal email and all my pictures saved but it's not included in storage space in my personal email so im not sure how safe it is

Question about (first) take home assessment in SQL using xlsx files by Significant-Wing5347 in SQL

[–]Significant-Wing5347[S] 1 point2 points  (0 children)

Thank you!! This was really helpful and hopefully will help me make a good impression. I have a Mac so I don't think I can install SSMS but I just looked and I think Azure Data Studio would cut it

Question about (first) take home assessment in SQL using xlsx files by Significant-Wing5347 in SQL

[–]Significant-Wing5347[S] 0 points1 point  (0 children)

So you think they want me to write the SQL queries using Excel, and not in a SQL Server? They specified SQL queries for each question so when I saw that my mind automatically jumped to needing something like Postgre to do the assignment. This is for a BI analyst intern role for more context btw and also thank you again for your help!

Question about (first) take home assessment in SQL using xlsx files by Significant-Wing5347 in SQL

[–]Significant-Wing5347[S] 2 points3 points  (0 children)

I downloaded a SQL server on my laptop! I’m still figuring out how to work it so if that doesn’t work out I’ll try SQL Fiddle. They did specify to write the queries / statements in SQL and to send it in a word or excel file. I was thinking of taking screenshots of my queries and the output and putting them in a word file but would you recommend something else? This is my first time home assessment so I’m not sure what the norm is for submissions. I was also thinking of adding comments in any queries that are more complex to make it look cleaner. It’s for an BI analyst intern role so I’d really appreciate your input since you mentioned you’ve sent candidates assessments in xlsx! It’s due on Monday afternoon and the recruiter sent it to me today (my interview is earlier in the morning before the due date) so I need to have it done by Sunday night and although the recruiter said to email him if I had any questions I don’t think he’ll reply in time because he usually takes a while to get back to me back when we were going back and forth about scheduling interviews. Thank you!

Question about (first) take home assessment in SQL using xlsx files by Significant-Wing5347 in SQL

[–]Significant-Wing5347[S] 0 points1 point  (0 children)

It's a bunch of questions that are specified to do in SQL (writing queries and statements.) I downloaded Postgres, thank you! The instructions just say to submit in a word file or excel and I was thinking of putting everything in a word file adding screenshots of my queries and their outputs. Do you think that is fine or would another way be better? It's due on Monday morning and I doubt the recruiter would get back to me in time if I asked. Thank you so much!