Basic questions re practicing SQL outside DataCamp
Hello! I made a post semi-related to your questions. This is a real take home project an employer gives people who are interviewing.
https://www.reddit.com/r/SQL/s/pzPLtmbO1N
1.) You practice it by thinking about how to leverage SQL to meet the business need. For example, how can you use SQL to show management a certain product is making a profit with individuals of a certain age range? Or the inverse? Can you automate a report with a view or stored procedure? What about year over year earnings?
2.) are you in the US? Honestly, I don’t think interviewers care about a portfolio or personal project outside of just an explanation. You could always visualize it, then just have 3-4 PowerPoints slides showing your process if you want. Again, I have interviewed for a lot of Analyst/Scientist positions and nobody has ever cared about that. In fact, I’ve been a part of interviews where it has ruined their chances because they were adamant on showing their project. It never hurts to have a portfolio built or even a GitHub link for them to view after the interview if they’re interested.
Hope that helps.
More on reddit.comSQL interview disaster
You should spend the time to learn SQL, especially since the language is relatively easy to learn.
More on reddit.comSQL and Coding interview questions - and answers
Do you have the datasets for the SQL Qs? I can work these out in my head, but I think it'd be useful to others to be able to use it to practise.
Seems like just the kind of stuff I do at work
More on reddit.comJust failed my first data science interview due to not knowing pointless names of things in databases and the technical names of sql functions.
Does DataCamp offer SQL Certification?
Yes, our SQL Associate Certification enables you to prove your SQL skills to employers.
Our Data Analyst Certification is also an excellent option to prove your data analysis knowledge with SQL and either Python or R.
Do I need to know programming to learn SQL?
No, you do not need to know programming to learn SQL, but familiarity with basic programming concepts can be beneficial.
What is a SQL database?
A SQL database is a structured collection of data that can be accessed and managed using SQL (Structured Query Language). It uses tables to organize data into rows and columns, allowing for efficient data retrieval, manipulation, and relational database management.