강의

멘토링

로드맵

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) 9 reviews

434 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,768

Learners

434

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

9 reviews

4.9

9 reviews

  • fpdk13248842님의 프로필 이미지
    fpdk13248842

    Reviews 7

    Average Rating 5.0

    5

    63% enrolled

    • pbj0812
      Instructor

      Thank you!

  • shyoon991님의 프로필 이미지
    shyoon991

    Reviews 66

    Average Rating 5.0

    5

    100% enrolled

  • jjhgwx님의 프로필 이미지
    jjhgwx

    Reviews 594

    Average Rating 4.9

    5

    38% enrolled

    Thank you so much for the great lecture!

    • pbj0812
      Instructor

      Thank you for the good review!

  • tett77님의 프로필 이미지
    tett77

    Reviews 18

    Average Rating 5.0

    5

    100% enrolled

    ⭐ A lecture recommended for those with basic SQL knowledge!!! A lecture that will help you level up your SQL skills to intermediate and advanced levels. ⭐ Also recommended for those who have forgotten intermediate and advanced SQL grammar and need a review. ⭐ Above all, the biggest advantage is that it's free!!! ⭐ You can learn important intermediate and advanced SQL techniques in less than an hour. ⭐ You can learn the essentials of Windows functions, ROLLUP functions, and other functions that are difficult to study on your own through the lecture. ⭐ A really recommended lecture!! Please listen to it:)

    • pbj0812
      Instructor

      ⭐Are you one of my friends???⭐Thank you for the great review⭐⭐⭐⭐⭐

    • If it was an acquaintance, I would have asked a lot of questions, but it's a pity.

    • pbj0812
      Instructor

      It's already been 4 months... Feel free to ask even if you're not an acquaintance!!!

  • yong111han2518님의 프로필 이미지
    yong111han2518

    Reviews 8

    Average Rating 4.8

    4

    100% enrolled

    Thank you for the education

Free

pbj0812's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!