Senior Data Analyst's SQL Coding Test Know-how Revealed [Monthly Datalian Seminar Replay | December 2023]

Monthly Datalian Seminar

In December, we'll cover SQL coding tests !

December's Datalian Seminar is 🔍

I recommend this to those who are having these concerns ✅

• Data analyst job seekers who need to take a SQL coding test this month

• If you're unsure how to prepare for the SQL coding test to become a data analyst,

• For those who are not majoring in SQL and are wondering where to start preparing for the SQL coding test

• If you have never taken a SQL coding test before and are curious about the test environment or process,

• Anyone who wants to hear about the SQL coding test experience and know-how of a senior data analyst

Lecture Introduction ⏰

# Almost everything about SQL coding tests: from study methods to practical know-how.

✔ Speaker Yoon Seon-mi

• Datarian Data Analyst

• Former data analyst at Coupang, Hyperconnect, and Kakao

• I've already been working at the company for eight years. Ironically, working with Datalian members on various projects like marketing and service planning has given me even more faith in the power of data than when I was solely a data analyst. I'm passionate about communicating data analysis in a way that's accessible to everyone.

Expected Questions Q&A 💬

Live participation review
If you're curious 👏

What was the most impressive thing you learned during the seminar?

• I failed the certification exam this year and am preparing to retake it in January next year. Even as I was preparing, I kept wondering, "Do I really need this certification?" The advice to "consider whether you're viewing the certification as a talisman to mask your shortcomings" really resonated with me.

• What impressed me about the SQL coding test was that it wasn't about getting a high score, but rather a logical examination that examined the entire process of how you approach a problem. That's why I felt it was important to show my skills and dedication during the test.

• I was able to see how the test was conducted, and even if I couldn't write the query perfectly, I had to leave a record of the process...! This part may seem obvious, but I think I realized it again.

• I remember the great tip that you should prepare for the coding test in parallel with the theory, rather than trying to prepare perfectly!

• I was impressed by the fact that you have to approach the coding test with confidence!

• I was impressed by the content recommending a learning method where you know the theory, solve problems, and then move on to see if you understand it well, the attitude of leaving queries even if you can't solve the answer, and the tip of using flexibility to communicate the intention of the question with the interviewer if possible.

• The most striking thing was the advice to approach coding tests with confidence. The Coupang story was especially funny 😊😊

• I appreciated the reminder that even if you get stuck during a coding test, you should still leave a trace of your work. I hadn't thought about preparing for the test, but the tips on what to prepare in advance were incredibly helpful.

• Even though I knew the grammar, I had a hard time writing code. It was helpful to learn how to think by watching other people's solutions.

  
  

• The coding test reviews and how to deal with problems that you can't solve were impressive!

  
  

• Coding tests are trending!

  
  

  
  

A word to Datarian!

• Ever since I attended SQL Camp, I've felt that Datalian's content and lectures are truly valuable because they are taught by people with practical experience. I'm definitely planning to attend the next seminar. Thank you :)

• I was very satisfied with both the content and the way it was presented! I knew nothing about SQL, but thanks to this course, I learned a lot.

• I liked the positive comments that the camp had about the comfortable atmosphere and the fact that anyone attending the camp could prepare well for the coding test based on various case studies.

• The seminar content... It was perfect, lasting about two hours, with nothing to throw away. It was so informative that I was so grateful to myself for signing up for the seminar the whole time. And the way the seminar was conducted! This was my first time experiencing a webinar, and I felt like there were fewer unexpected issues during the online seminar, and it was conducted more neatly and systematically! The speakers were so eloquent, and their sense of humor was also fantastic!

• The content was fantastic! The experiential component was also excellent, and it was smoother and more systematic than any other seminar I've attended! Thank you.

  
  

• I knew I had to take a coding test, but I was frustrated because I only had a vague understanding of it, not a clear one. I was so happy to have been able to get a handle on it after attending today's seminar.

• Thank you for always organizing informative lectures! This was my first time attending, but I'll definitely be attending more in the future!

  
  

• This was my first time studying, so I was a bit lost, but thanks to Datarian, I learned a lot of things, including theory, practice, and practical experience, so I'm looking forward to my future studies!

• Thank you. I hope to see more seminars on a variety of topics like this one in the future!

• I'd like to once again express my gratitude to the Datalian members who prepared this high-quality seminar!!! The seminar content was incredibly informative!