inflearn logo
inflearn logo

[A Hundred Words are Not as Good as Seeing Once] SQL Practical Guide for Data Analysis (Free Mini Course)

Datalian's SQL practical lecture with over 10,000 cumulative students and rich online/offline lecture experience. How is SQL used in practice? Let's become a data analyst who solves problems using real data from Microsoft's Yammer service.

(4.8) 85 reviews

8,622 learners

Level Intermediate

Course period 12 months

SQL
SQL
SQL
SQL

News

43 articles

  • datarian님의 프로필 이미지

    The Data Next Level Challenge (Data Level Challenge), a challenge for reading and recording recommended books related to data analysis, has returned for its 5th cohort.

    This recommended book is the 12th Brunch Award 🏆 winner "UX Emerged After Data Struggles."

    챌린지 9.png.webp

    This book is a secret manual that generously shares the know-how of working in a data-driven way from a 17-year veteran product designer—insights that can only be provided by someone who has directly experienced hands-on work in the field.

    Less than 50 days left in 2025! If you want to spend it meaningfully and productively, join us with Devel Challenge 🥰

    📚 DevChall 5th Cohort Recommended Books

    ∙ 『UX Emerged After Data Struggles』 _ Written by Lee Mi-jin (Ranran)

    We recommend this challenge for these people
    ∙ Those curious about why designers, planners, and marketers need to understand data

    ∙ Those who want to know specific methods for working in a data-driven way
    ∙ Those who want to spend the remaining 2025 meaningfully

    📌 How to Apply for the Challenge (Free, Application Deadline 11/23)
    https://dub.sh/5Qy11p6

    If you have colleagues or friends around you who want to start studying data analysis, please share the news about this challenge.

    0
  • datarian님의 프로필 이미지

    Have you ever felt like you're studying data diligently on your own, but still relying on 'intuition' when it comes to actual work? You read books, take courses, and try things out in practice, but often it's hard to grasp what exactly it means to "work based on data."

    Datarian has prepared a seminar to resolve that frustration.
    In the November seminar, 17-year veteran product designer Lee Mi-jin (Ranran) will share 'How to work data-driven without data analysts' based on her direct experience at 7 small startups.

    If you're curious about the vivid real-world cases and know-how that couldn't be fully covered in the Brunch Book award-winning work "UX Emerged at the End of Data Struggles", don't miss Datarian's November seminar "Data-Driven Design Without Data Analysts".

    "Data-Driven Design Without a Data Analyst" Seminar

    • Date: November 4th (Tuesday) 7:00 PM - 9:00 PM

    • Location: Zoom Online Seminar

    • Speaker: Lee Mi-jin (Ranran) — Author of 『UX Emerged After Data Struggles』, 17-year Product Designer

    Register for Seminar

    We recommend this seminar for these people

    • Designers, planners, and marketers who want to work based on data

    • Small startup practitioners without analysts

    • All practitioners who want to persuade with data, not intuition

    If you have team members, colleagues, or acquaintances who might need this seminar content, please be sure to share this link with them.

    0
  • datarian님의 프로필 이미지

    I'd like to share information about the free GA4 Hands-On Seminar that will be held next Tuesday evening.

    I've prepared this for those who have resolved to learn GA4 this year but haven't started yet.

    GA4 핸즈온-4.png.webp

    In just 2 hours at the seminar, you can install GA4 on your blog and check real-time data yourself.

    GA4 can be installed without development knowledge

    Hands-on, hands-on training with simple setup in just a few clicks

    Install GA4 on your Tistory blog and check real-time data

    You can ask practitioners directly about your GA4-related questions in the Q&A session.

    📅 Seminar Information

    • Event Date: 7/15 (Tue) 7:00 PM - 9:00 PM

    • Location: Zoom Online

    • Cost: Free

    👉 Apply for participation

    If you have a teammate or acquaintance who might need a seminar, please share the news with them :)

    0
  • datarian님의 프로필 이미지

    🥲 Job hunting is so daunting. I wish I could just look at my seniors’ portfolios once.”

    " 🙌 ​You can directly see the portfolios of successful seniors who found employment at Datarian's January seminar!"

    From a portfolio that passed the entrance exam as a new 'marketer at a large corporation' without any relevant experience, to a portfolio that changed jobs from 'agency marketer' to 'in-house data analyst', we will reveal all the job-hunting secrets of our seniors who succeeded in finding a job despite the cold wave!

    ▼ Apply for the “Data Analysis Portfolio that Leads Straight to an Interview” Seminar
    (1/14 (Tue) 7:00 PM - 9:00 PM, ZOOM Online)

    https://bit.ly/4gZQHLk


    • [Lecture] Revealing a portfolio that changed jobs from marketer to data analyst (feat. Department of Korean Language and Literature)
      _ Catch Table Data Analyst, Jiho Yoon

    • [Lecture] How to Create a Data Analysis Project That Will Become a Weapon for Your Marketing Job


      _ Jaerim Lee, Marketer, Card Finance Team, Card Company


    25년 1월 세미나 소개 2p.png25년 1월 세미나 소개 1p.png

    If you have friends, acquaintances, or colleagues around you who are struggling to prepare for employment, please share the seminar news with them.

    Share January Seminar News https://bit.ly/4gZQHLk

    0
  • datarian님의 프로필 이미지

    Edited

    Hello planners and marketers,
    Has anyone seen the outdoor advertisement for Speak that covered Gangnam Station earlier this year?

    It is not easy for a startup with a limited budget to plan and confirm outdoor advertising.

    I would like to share a blog post written by 'Jung Du-hyeon', a Speak Branding Marketer, about the difficult process of planning, confirming, and executing outdoor advertising.

    I think there are many people who are worried about the promotional plans for the year-end and New Year holidays.
    I recommend that you read Duhyun's blog post and use it as a reference to learn how to persuade your CEO and team members.

     

    The story of covering Gangnam Station with outdoor advertising - Internal persuasion
    https://bit.ly/4gUDIvj

     

    Internal Persuasive for Brand Campaigns
    https://bit.ly/4eZ3yN1

     

    If you attend the Datalian seminar held next Tuesday, you will also hear internal persuasion tips from IT startup practitioners, so if there are people around you who are interested, please share the seminar news with them 😀

     

    Watch the seminar 'Effectively Persuading My Plan Based on Data' on Tuesday, October 15th
    https://bit.ly/4eMWVgC

     

    24년 8월 세미나 소개 1page.png

     

    0
  • datarian님의 프로필 이미지

    Data analysts can be divided into ‘in-house data analysts’ and ‘consulting data analysts’ depending on the type of company they work for.

    Next Tuesday (7/9) at 7 PM, there will be a seminar where you can learn about the differences between the two types of data analysts , with senior data analysts who have built their careers as consulting data analysts and in-house data analysts .

    If you have a colleague or friend who is an aspiring data analyst or junior analyst who is worried about their first company or career, please share the seminar information 🙂

    👉 Check out the seminar: https://bit.ly/3GmaJzu

     

    Datalian July Seminar “Data Analysts, Which Company Should You Go To?”

    📅 7/9 (Tue), 7pm ZOOM Online

     

    [Part 1 Lecture] This is what data analysts at consulting firms do _ Kim Seon-young, Executive Director of Market Fit Lab Solutions Division

    [Part 2 Panel Talk] What is the difference between an in-house data analyst and a consulting data analyst?

     

    👉 Apply: https://bit.ly/3GmaJzu

     

    image

     

    0
  • datarian님의 프로필 이미지

    Edited

    Hello, this is Datarian Bomin.

    Since October of last year, Datalian has been running a challenge where students read books related to data analysis and write about them. This time in particular, we are openly recruiting challengers so that we can do this with more people who want to upgrade their data analysis skills 🙌 Anyone can participate in the challenge!

     

    #DataNextLevelChallenge #DevelChallenge 1-minute summary

    • Read recommended books from data analysts in the field and complete the mission of verifying your identity on SNS and Datalian Slack once a week.

    • Anyone interested in data analysis can apply. If you have friends or colleagues interested in data analysis, please share the news of the challenge opening.

    • It will be a 3-week challenge + retrospective meeting.

    • There is no entry fee! Please prepare your own challenge book.

     

    April Challenge Book: The Red Lie, Statistics

    image

    The April Challenge Book is an introductory book on statistics that explains statistical errors that can easily be made in real life in an easy and fun way.

    I think I need to have basic statistical knowledge to effectively utilize data in my work .. I recommend this challenge to those who are wondering if there is an introductory book that is easy to read rather than a stiff and boring major book!
    For more detailed information about the challenge and how to apply, please check the link below :)

    👉 https://bit.ly/3IHTQQJ

     

    Are you curious about what kind of camp the data analysis camp that includes challenges after the end of the semester is?

    Get insights and tips from data analysts from Jobplanet, Coupang, and Ridibooks.

    Check out the 'SQL Data Analysis Camp' (~until 3/15, 30% early bird discount)
    https://bit.ly/3RiEl79

    Check out the 'GA4 Data Analysis Camp' (until 3/15, 30% early bird discount)
    https://bit.ly/3VcOJ2E

    0
  • datarian님의 프로필 이미지

    Are you guys actually using 'funnel analysis', the basics of growth hacking, in your practice?

    They say that you can significantly grow your product just by making good use of funnel analysis.

     

    At the Datalian March seminar, we will be discussing various strategies for growing products through funnel analysis with Seunghwan Seo, the 10-year Product Owner of Alamy, a morning wellness app with 2.5 million DAU.

     

    If you are curious about the secret to Alamy’s steady growth over the past 10 years, be sure to sign up for the March seminar.

    If you have a friend or colleague around you who needs this seminar, please share the news about it :)

     

    📅 Sign up for the Zoom seminar on Tuesday, March 12 at 7 PM

     https://bit.ly/3T6nfsC

     

    1⃣ [Lecture] “Finding Clues to Grow Your Product Using Funnel Analysis”

    2⃣ [Panel Talk] “How do other companies conduct funnel analysis?”

     

    image

    image

    0

Access is restricted to non-public courses.