Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Data Science

/

Data Analysis

SELECT ALL FROM SQL2

This is a [Data Analysis, Programming Language] lecture prepared for SQL data analysis beginners. This is a SQL SELECT basic grammar lecture that starts without installing SQL.

(4.9) 8 reviews

427 learners

  • pbj0812
실습 중심
sql
SQL
MySQL
Thumbnail

Reviews from Early Learners

What you will learn!

  • SQL

  • MySQL

  • Data Extraction

  • data analysis

Extract actual data with SQL Select!

Lecture Topics 📖

  • This lecture is a follow-up lecture to SELECT ALL FROM SQL .
  • This lecture is designed to help you extract the data you want using SQL's SELECT syntax.
  • I created this so that students can follow along using simple data that I created myself.

I recommend this to these people 🙆‍♀️

For those who don't know what skills they need to know to become a data analyst

For those who want to see the data they want to see better through SQL

For those who think SELECT, FROM, WHERE, GROUP BY are everything in SQL


Lecture Features ✨

  • This lecture is structured so that you can practice anywhere with internet access by using https://sqltest.net/ .
  • The data and queries used in the lecture are saved in a notepad, so there are no difficulties due to the lecture environment.
  • You should know the basic SQL SELECT statement. If you don't know it, I recommend you take the previous lecture, SELECT ALL FROM SQL.


What you'll learn 📚

  • In each section, you will learn how to control data using the SQL SELECT statement.
  • By comparing the query statement created using the prior knowledge you had before taking each lecture with the content you learn in the lecture, you can compare the differences with the corresponding function.

Expected Questions Q&A 💬

Q. Where is this technology most commonly used?

If you are in an environment where analytics using queries is possible, this is a necessary skill.

Q. Are there any issues with the computer specifications?

It is possible as long as you have internet access and notepad (txt file) available.


Things to note before taking the class 📢

Practice environment

  • A PC with Internet access
  • PC that opens txt files

Learning Materials

  • 7 txt files

Player Knowledge and Notes

  • Prior knowledge of SQL's SELECT statement (SELECT, WHERE, GROUP BY) is required.
  • The volume may be a little low.

Introducing the knowledge sharer ✒️

Hello, I am Park Beom-jin. I have uploaded a total of 7 lectures on Inflearn since 2018, and you have listened to my lectures for over 7,000 minutes. I hope you find them easy and fun.

Resume / Portfolio / Personal Video


Recommended for
these people

Who is this course right for?

  • If you know the basics of SQL but want to know a little more...

  • If you dream of becoming a data librarian

  • I heard that you have to learn SQL to work with data, but if you don't know where to start

Need to know before starting?

  • SQL Basics

Hello
This is

9,698

Learners

428

Reviews

15

Answers

4.8

Rating

8

Courses

- 현) KREAM 데이터 분석가

- 전) ABLY 데이터 분석가

- 전) wadiz 데이터 분석가

- 전) XIILab 인공지능개발팀 선임연구원

- 전) 아라종합기술 수치모델링1팀 사원

- 인하대학교 해양과학과 (학/석)

Curriculum

All

8 lectures ∙ (45min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

8 reviews

4.9

8 reviews

  • 김재환님의 프로필 이미지
    김재환

    Reviews 7

    Average Rating 5.0

    5

    63% enrolled

    • 박범진
      Instructor

      감사합니다!

  • soono991님의 프로필 이미지
    soono991

    Reviews 66

    Average Rating 5.0

    5

    100% enrolled

  • Jang Jaehoon님의 프로필 이미지
    Jang Jaehoon

    Reviews 492

    Average Rating 4.8

    5

    38% enrolled

    좋은 강의 정말 감사합니다!

    • 박범진
      Instructor

      좋은 수강평 감사합니다!

  • 망고맛있어님의 프로필 이미지
    망고맛있어

    Reviews 18

    Average Rating 5.0

    5

    100% enrolled

    ⭐sql 기초 지식이 있는 분들에게 추천하는 강의 !!! 중급 및 고급으로 sql 실력을 레벨업하실 수 있는 강의 입니다. ⭐sql 중, 고급 문법을 까먹으신 분들, 복습이 필요하신 분들에게도 추천합니다. ⭐ 무엇보다 무료라는 것이 큰 장점!!! ⭐ 1시간이 안되는 시간을 통해 중요한 중급, 고급 sql 기술을 익힐 수 있습니다. ⭐ 혼자 공부하기 어려운 윈도우 함수, ROLLUP함수 등을 강의를 통해 핵심만 쏙쏙 배울 수 있습니다. ⭐ 진짜 추천 강의!! 제발 들어주세요:)

    • 박범진
      Instructor

      ⭐혹시 제 지인 아니시죠???⭐대박 후기 감사합니다⭐⭐⭐⭐⭐

    • 지인이면 이것저것 여쭈어 볼 텐데 아쉽네요

    • 박범진
      Instructor

      벌써 4개월이 지났군요.. 지인 아니라도 물어보셔도 됩니다!!!

  • 한지용님의 프로필 이미지
    한지용

    Reviews 8

    Average Rating 4.8

    4

    100% enrolled

    교육 감사합니다

Free

pbj0812's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!