inflearn logo

[Practice Makes Perfect] Intermediate SQL for Data Analysis

Inflearn's SQL intermediate course by Datarian, with over 30,000 cumulative students and extensive online/offline teaching experience. Learn intermediate SQL theory and solve 20 practice problems together.

(4.9) 981 reviews

5,604 learners

Level Basic

Course period Unlimited

SQL
SQL
SQL
SQL

News

37 articles

  • datarian님의 프로필 이미지

    The answer to a successful data analyst portfolio lies within the 'job description.'

    Learn the strategies for creating a portfolio that catches the interviewer's eye directly from a 7-year veteran analyst from RIDI!

     

    😎 Seminar on 'How to Create a Data Analysis Portfolio That Catches the Interviewer's Eye'

    • Date & Time: 5/19(Tue) 7:30 PM ~ 9:30 PM

    • Location: ZOOM Online

    👉 Sign up for the seminar

     

    📌 Recommended for these people

    • Job seekers who are curious about how to prepare a portfolio to get a job as a data analyst

    • Career changers who are worried about not having any data analysis projects.

    • Those who are struggling with how to revise their applications after repeatedly failing the document screening stage

    • Anyone who is curious about data analysis portfolios

     

    If you have friends or acquaintances who might need this seminar information, please share the news with them.

     

    26년 4월 세미나 홍보.png.webp26년 4월 세미나 홍보-1.png.webp
    0
  • datarian님의 프로필 이미지

    Hello, Datarian has prepared an appreciation event to celebrate its 5th anniversary.

    At the SQL Data Analysis Camp, where you can learn the most commonly used data analysis frameworks in practice through SQL, you can enroll at a 50% discount if you apply now.

     

    If you've been thinking that you can no longer put off applying data analysis to your work!

    Enroll now and learn directly from data analysts who have worked at Coupang, Ridi, and JobPlanet.

     

    Go to SQL Data Analysis Camp (50% discount, until midnight tonight)

    👉https://dub.sh/WTOM6L5

     

    SQL Data Analysis Camp | After taking this package, you will be transformed like this

     

    Why did our company's sales drop? You can analyze it yourself using SQL.

    You can perform RFM customer segmentation analysis by identifying customers who have made large or frequent purchases in our service.

    You can perform funnel analysis to see how users entered through marketing and what purchase conversions were made.

    You can obtain and check user retention rate data through retention analysis.

     

    SQL 이벤트 카드 - 1 (1).png.webp

     

    0
  • datarian님의 프로필 이미지

    Hello, Datarian has prepared an appreciation event to celebrate its 5th anniversary.

    At the SQL Data Analysis Camp, where you can learn the most commonly used data analysis frameworks in practice through SQL, you can enroll at a 50% discount if you apply now.

     

    If you've felt that you can no longer put off applying data analysis to your work!

    Sign up now and learn directly from data analysts who have worked at Coupang, Ridi, and JobPlanet.

     

    Go to SQL Data Analysis Camp (50% discount, ~4/30)

    👉https://dub.sh/WTOM6L5

     

    SQL Data Analysis Camp | After taking this package, you will be transformed like this

    Why did our company's sales drop? You can analyze it yourself using SQL.

    You can perform RFM customer segmentation analysis by identifying customers who have purchased a lot or frequently from our service.

    You can perform funnel analysis to see how users entered through marketing and what purchase conversions were made.

    You can obtain and check user retention rate data through retention analysis.

     

    SQL 이벤트 카드 - 1.png.webp
    0
  • datarian님의 프로필 이미지

    I need to build a portfolio, but where on earth can I get actual user data?

     

    For those who have heard that you can collect and analyze user data yourself in GA4, but are getting stuck right from the installation stage,

    We have prepared a free hands-on seminar where you can personally go from 'GA4 installation to data verification' in just 2 hours.

     

    Possible to install GA4 without development knowledge

    Configure a data collection environment with just a few clicks

    Check data after connecting to Tistory

     

    📅 4/14 (Tue) 7 PM - 9 PM, ZOOM Online

    👉Register for the seminar

     

    If you have any friends or acquaintances who might need this seminar, please share the news with them :)

     

    25년 7월 세미나 홍보.png.webp25년 7월 세미나 홍보-1.png.webp
    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

$29.70