inflearn logo
inflearn logo

Easy to understand, SQL secret recipe for everyone

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

(4.9) 수강평 9개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

SQL
SQL
Big Data
Big Data
Data Engineering
Data Engineering
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
Big Data
Big Data
Data Engineering
Data Engineering
DBMS/RDBMS
DBMS/RDBMS

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.9

5.0

이진우

63% 수강 후 작성

good

5.0

변성욱

100% 수강 후 작성

Thank you for explaining it in an easy to understand way. It is very helpful.

5.0

전준석

100% 수강 후 작성

I listened to the lecture well. It was a useful time. It was good to try to split and assemble it. It would have been good if there were classes that could interpret slightly more difficult and longer queries, but it's a shame, but I listened well.

강의상세_배울수있는것_타이틀

  • SQL Coding Principles

  • How to write good SQL

  • How to interpret SQL well

  • How to Validate SQL Well

  • And some SQL code editing tips

SQL that no one told me about,
The secret recipe for writing, interpreting, and verifying well!

📣 The author of [Everyone's SQL] and [Everyone's R Data Analysis] will teach you.

"Everyone's SQL Secret Recipe: Easy, Essential SQL" is a lecture by an instructor with over a decade of SQL experience. This course teaches beginners the most useful and helpful tips for effectively utilizing SQL. We'll call these "SQL Recipes." Experience these SQL Recipes, which even your seniors haven't shared yet.

"Why learn something you won't use?"
The 'Easy to Understand the Essentials' series is a lecture series that focuses on the most useful things, excluding as much as possible things that are not necessary for practical use.

Lecture Planning 📖

  • ✔️ This course is for beginners who only know the most basic grammar of SQL .
  • ✔️ An instructor with over a decade of SQL experience will teach you the secrets to mastering SQL .
  • ✔️ We teach you how to write, interpret, and validate good SQL.
  • ✔️ We teach you how to use SQL that is useful for both developers and data analysts .

SQL was created for the purpose of manipulating and displaying data. Therefore, its handling methods must differ from those of other programming languages. Just as each dish has its own unique cooking method, SQL has its own unique code-writing tips. Try out these SQL recipes to create your own delicious SQL dishes.


Recommended for these people! 📌

I especially recommend this to those who have no choice but to study SQL and data analysis on their own.

SQL beginner

SQL utilization
Those who are at a loss

SQL beginner

As an intermediate
Those who want to level up

students/examinees

SQL related
Those preparing for certification

beginner developer

SQL coding
Those who want to do well

The secret to mastering SQL that even your seniors won't tell you !

  • Describes the characteristics of SQL.
  • We will teach you how to write SQL queries by taking advantage of the characteristics of SQL.
  • We will teach you how to interpret SQL queries by leveraging the characteristics of SQL.
  • We will show you how to validate SQL queries by leveraging the characteristics of SQL.
  • Explained in simple language for beginners.

Only in this lecture
Check out the features ✨

The author of the best-selling SQL introductory book, 'Everyone's SQL', covers special SQL usage topics not covered in the book.

  • Based on the instructor's experience, we have compiled only the key secrets to mastering SQL .
  • We provide a textbook with 15 secret recipes (how to use) in 3 chapters to effectively utilize SQL.
  • You don't need to prepare anything. You'll practice in an online practice environment .
  • Since it is aimed at beginners, it is explained in a beginner's language.

How to conduct a lecture

  • We explain the theory using core recipe textbooks and practice with Oracle LIVE SQL .
  • As each lecture builds on the previous one , your knowledge continues to expand .
  • We start with the most basic recipes and move on to advanced ones .
  • The 15 secret recipes are separate, yet interconnected to broaden your thinking.
  • SQL beginners can take the next step to become intermediate SQL users with these secret recipes.

# 15 SQL Core Recipes: We teach you the key secrets to effectively using SQL!

It provides 15 secret recipes in 3 chapters on writing, interpreting, and validating SQL.

# LIVE SQL : Fast and convenient online practice environment!

All practical examples are stored online and can be completed online without any installation required.


As an intermediate SQL user
We help you improve your skills. 📜

  • We will teach you the basic principles of the SQL language.
  • We provide secret recipes for mastering SQL.
  • We provide a foundation for beginners and advanced learners to level up from beginner to intermediate.


What you'll learn 📚

It consists of three chapters: Writing, Interpreting, and Verifying SQL. Each chapter contains a corresponding SQL recipe. First, you'll learn the theory through the textbook, then practice with LIVE SQL.

Chapter 0. Pre-lecture

We'll explain the unique characteristics of SQL, which distinguish it from other programming languages. We'll cover core SQL patterns, which form the foundation of this course. We'll also cover how to use LIVE SQL and the structure of a practical database.

Chapter 1. Writing SQL

This course will teach you how to write effective SQL by leveraging the unique characteristics of the SQL language. It will delve into SQL patterns and modularization. You'll learn how to write SQL using patterns and modules.

Chapter 2. Interpreting SQL

This chapter will teach you how to easily interpret SQL using the characteristics of SQL described in "Writing SQL." Chapter 1 explains the principles of writing and the subsequent interpretation.

Chapter 3. Validating SQL

This book covers the questions beginners often have. We'll teach you how to verify SQL logic, which is just as important as writing SQL itself.

Other SQL coating tips

We also cover some useful tips to keep in mind when coding SQL.


Frequently Asked Questions
Check it out 💬

Q. Is this a course that non-majors can also take?

Designed with non-experts in mind, it's explained in simple, beginner-friendly language.

Q. Is there anything I need to prepare before attending the lecture?

You just need to know SELECT ~ FROM and what group functions are.
However, it is structured so that you can get a feel for SQL even if you don't know anything about it.

Q. What level of content is covered in the class?

Assuming you know the most basic grammar, I will teach you within the beginner level of SQL.


Who created this course
Introducing the knowledge sharer ✒️

Data Chef

I'm a lecturer who has dedicated my career to IT and data analysis. Based on IT technology, I've worked on a variety of projects across diverse fields, from CRM to big data and web analytics. I've accumulated extensive data and experience working for large corporations and specialized companies, and I'm distilling this experience into books and lectures.

History

  • Author of 'Everyone's SQL', 'Everyone's R Data Analysis', and 'Everyone's Google Analytics 4'
  • Working in data analysis/construction at large corporations and specialized companies

Main history

  • L Electronics expands GA4 application
  • Company A, Google Analytics implementation and analysis
  • A cosmetics, CRM operations, data analysis
  • I Hotel, Digital Marketing/CRM Manager
  • K-Card, H-Card, and Text Mining Analysis Projects
  • N Shopping, HR Operation System Development Project
  • A Phone, D Computer, E Lux, and H Mart Business Collaboration
  • D Electronics, CRM system operation, call center operation, program development

Curious about Data Chef's past lectures?

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • Anyone who wants to write, interpret, and verify SQL well

  • People who know basic SQL grammar but have difficulty using it

  • For those who are moving from the beginner level to the beginner level

선수 지식, 필요할까요?

  • You only need to know the most basic SELECT FROM syntax.

강의소개.지공자소개

923

수강생

73

수강평

23

답변

4.7

강의 평점

3

강의_other

커리큘럼

전체

27개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

9개

4.9

9개의 수강평

  • aberkios8300님의 프로필 이미지
    aberkios8300

    수강평 1

    평균 평점 5.0

    5

    100% 수강 후 작성

    Thank you for explaining it in an easy to understand way. It is very helpful.

    • yuna43068470님의 프로필 이미지
      yuna43068470

      수강평 1

      평균 평점 4.0

      4

      100% 수강 후 작성

      It was good for people with basic knowledge to listen to it as a reminder.

      • somal4568님의 프로필 이미지
        somal4568

        수강평 6

        평균 평점 5.0

        5

        33% 수강 후 작성

        • jjy40762200님의 프로필 이미지
          jjy40762200

          수강평 1

          평균 평점 5.0

          5

          100% 수강 후 작성

          I listened to the lecture well. It was a useful time. It was good to try to split and assemble it. It would have been good if there were classes that could interpret slightly more difficult and longer queries, but it's a shame, but I listened well.

          • jinwoolee3060님의 프로필 이미지
            jinwoolee3060

            수강평 1

            평균 평점 5.0

            5

            63% 수강 후 작성

            good

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            강의상세.할인문구

            $4,176.00

            29%

            $37.40