인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
Data Science

/

Data Analysis

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

246 students

SQL
Thumbnail

This course is prepared for Basic Learners.

What you will learn!

  • 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.

'Easy SQL Secret Recipe for Everyone' is a lecture in which an instructor with over a decade of SQL experience teaches beginners the most useful and useful tips for effectively utilizing SQL. Let's call these SQL recipes. Experience the SQL recipes that even your seniors haven't taught you.

"Why learn something you won't use?"
The 'Easy to Understand Only the Essentials' series is a lecture that aims to teach you the most useful things in an easy-to-understand manner, excluding things that are not necessary for practical use as much as possible.

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 will teach you how to use SQL that is useful for both developers and data analysts .

SQL is a language that was created for the purpose of manipulating and outputting data. Therefore, the method of handling it should be different from other programming languages. Just as each dish has a different cooking method, SQL has its own unique code creation tips. Create your own delicious SQL dish through SQL recipes .


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
A person who is at a loss

SQL beginner

As an intermediate
For those who want to level up

Student/Test taker

SQL related
People preparing for certification

Beginner Developer

SQL coding
Those who want to do well

The secret to handling SQL well that even seniors don'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 taking advantage of 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 for this lecture
Check out the features ✨

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

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

How to conduct a lecture

  • We explain the theory using the core recipe textbook and proceed with practice using Oracle LIVE SQL .
  • As each lecture builds on the next, your knowledge continues to expand .
  • Start with the most basic recipes and work your way up to advanced ones .
  • The 15 secret recipes are separate, yet connected to each other to broaden your thinking.
  • SQL beginners can take the next step to become intermediate SQL users with our secret recipe.

# 15 SQL Core Recipes: We teach you the core secrets to making good use of SQL!

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
I'll help you improve your skills. 📜

  • We will teach you the basic principles of the SQL language.
  • Provides a secret recipe 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, and you will learn SQL recipes for each chapter. First, you will learn the theory through the textbook, and then practice through LIVE SQL.

Chapter 0. Pre-lecture

We will tell you about the features of SQL language that are different from other programming languages. We will cover the core SQL patterns that are the basis of this lecture. We will also cover how to handle LIVE SQL and the structure of a practice database.

Chapter 1. Writing SQL

We will teach you how to write good SQL by utilizing the characteristics of the SQL language. We will cover SQL patterns and modularization in depth. We will write SQL using patterns and modules.

Chapter 2. Interpreting SQL

We will teach you how to easily interpret SQL using the characteristics of SQL explained in Writing. Chapter 1. Explains the principles of writing and subsequent interpretation.

Chapter 3. Validating SQL

This covers the things beginners are curious about. We will teach you how to verify SQL logic, which is just as important as writing SQL.

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 lecture that non-majors can also take?

Made with non-specialists in mind. Explained in easy-to-understand beginner language.

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

You just need to know SELECT ~ FROM and what a group function is.
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?

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


Created this course
Introducing the knowledge sharer. ✒️

Data Chef

I am a lecturer who has walked only one path in the field of IT and data analysis. Based on IT technology, I have carried out various projects in various fields ranging from CRM, big data, and web analysis. I am organizing the data I have experienced and the rich experience I have had while working at large corporations and specialized companies into books and lectures.

History

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

Main history

  • L Electronics, GA4 application expansion
  • Company A, Google Analytics implementation and analysis
  • A Cosmetics, CRM Operations, Data Analysis
  • I am currently working as a hotel, digital marketing/CRM manager.
  • K Card, H Card, Text Mining Analysis Project
  • N Shopping, HR Operation System Construction Project
  • A Phone, D Computer, E Lux, H Mart Business Collaboration
  • D Electronics, CRM system operation, call center operation, program development

Are you curious about Data Chef's past lectures?

Recommended for
these people!

Who is this course right for?

  • 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

Need to know before starting?

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

Hello
This is

788

Students

52

Reviews

22

Answers

4.8

Rating

2

Courses

Curriculum

All

27 lectures ∙ (4hr 5min)

Lecture resources

are provided.

Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!