강의

멘토링

로드맵

Programming

/

Database

An easy and fun SQL story with Teacher Jangrae

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

(4.8) 11 reviews

171 learners

  • jangrae
이론 실습 모두
데이터베이스
mysql
SQL
DBMS/RDBMS
MySQL
Oracle
MSSQL

Reviews from Early Learners

What you will learn!

  • Conceptual organization of data

  • How to write basic SQL queries for data analysis

  • How to write SQL queries for multiple table searches

  • Understanding and utilizing over 50 different function features

  • How to write advanced SQL queries for efficient data analysis

Theory + Practice + Quiz all in one!
Everything about SQL, step by step ✅

SQL, easy and fun even for beginners! 📙

Learn the basics of using SQL to query, aggregate, and change data, and discover useful features and various functions for data analysis.

1️⃣ You will learn SQL statement writing skills through systematic learning and practice on various topics such as the following.

  • Find the data you need
    • Writing basic SQL statements to retrieve data (retrieval of rows that meet specified columns and conditions)
    • Understanding NULL values and querying and handling NULL values
    • Understanding automatic type conversion and combining data between columns
    • Sort and query data
    • Processing data according to conditions using CASE statement and IF function
  • Aggregate, manipulate, and sort data to fit your conditions
    • Aggregate by group using GROUP BY statement
    • Manipulating data with INSERT, UPDATE, and DELETE statements
    • Deriving analysis results using various ranking functions
  • Enriching data with relational/virtualization (view) features
    • Retrieving data from multiple tables using joins and subqueries
    • Save the SQL statement you wrote as a view and use it in various ways
  • Deepen data analysis using functions and advanced features
    • Learn over 50 string-related, date-time-related, and number-related functions.
    • Learn advanced features that facilitate practical analysis

2️⃣ We will learn while comparing the differences between the following three DBMS.

MySQL, Microsoft SQL Server (MS-SQL), Oracle


Repeat in 3 steps 👍
Learning SQL step by step

Repeat! Repeat! Repeat! For repeat learning, the whole process is carried out in three steps as follows.

1️⃣ Theory class

You will first learn the overall content through a textbook that systematically organizes only the essential content. You will learn the content you will write later through examples of SQL statements.

2️⃣ Practice Example

By executing actual SQL statements, you can review what you learned in theory classes and understand it more deeply. Learn by comparing the differences between MySQL, MS-SQL, and ORACLE syntax.

3️⃣ Quiz solution

Learning SQL statements is all about repetitive learning. You can review and organize what you have learned by solving additional practice problems in a fun way, like taking a quiz.

🧭 Over 20 years of teaching, practical, and consulting experience

  • We provide easy and fun lectures based on the know-how we have accumulated through many years of training centers and corporate on-site lectures.
  • It provides the best learning opportunity for those who are new to SQL statements.
  • We focus on SQL statements that are required in the field and have been confirmed during consulting for various companies.
  • It is based on MySQL, but it proceeds while comparing the differences with MS SQL and ORACLE.

Who created this course 👨‍🦰

Book

  • Writing of 『SQL Server Development Edition: A Special World Enjoyed with DB』, Ruby Paper
  • Writing of 『SQL Server Operations: A Special World Enjoyed with DB』, Ruby Paper
  • Written by 『SQL Server 2012 Operation and Development with Lee Jang-rae』, IT Forum
  • Author of SQL Server Security Guide for Protecting Personal Information, Microsoft

Teaching and teaching experience

  • Job training for SKT technical new recruits (JT)
  • KT Aible School 1st to 3rd Data Expert Training Course
  • GS EPS Data Analysis Advanced Course
  • SetrackEye Database Administrator Course
  • CJ Daehan Transportation SQL Server Monitoring and Optimization Process
  • SK C&C Data Preprocessing, Analysis Practice, Machine Learning Course
  • Daegu Bank Data Expert Training Course
  • KT Future Talent Development Project Data Preprocessing, Machine Learning Course
  • National Tax Service (Seoul, Daegu) SQL Course for Forensic Investigation
  • SK Networks DA (Data Architect) Training Course
  • SQL Course for Hyosung TNS Developers
  • Hanla Group Python Data Analysis Visualization Course
  • POSCO E&C Data Analysis Visualization Process
  • POSCO ICT Data Analysis Process
  • SK Networks Data Expert Training Course
  • CJ Olive Networks new employee training course, etc.

Q&A🔍

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

Yes, it is possible. We will proceed step by step while systematically learning the theory and practicing so that even those who are new to SQL can easily understand it. Take on the challenge with confidence~

Q. What DBMS is the lecture based on?

Based on ANSI SQL, you will learn SQL statements that can be used in all products such as MySQL, MS SQL, and ORACLE. Since a practical environment is required, we will use MySQL Workbench, which is the easiest to access. We will explain the differences from MS SQL or ORACLE while writing and executing SQL statements in the MySQL environment. In the case of functions, we will explain while comparing the functions used in MySQL, MS-SQL, and ORACLE. Therefore, it does not matter which DBMS you use.

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

First of all, you must prepare your mind to study hard and enjoyably. Since sufficient explanations are given, you can listen without practicing, but if you listen to the lecture while practicing, you must install MySQL including Workbench. Download the practice materials, watch the preparation process video, and restore the learning database to be perfectly prepared for the class.

Recommended for
these people

Who is this course right for?

  • For those who are learning SQL for the first time

  • For those who already know SQL but want to organize their knowledge systematically.

  • For those interested in obtaining the SQLD certification

Hello
This is

297

Learners

20

Reviews

24

Answers

4.9

Rating

3

Courses

  • 현) 디프렌즈 대표

  • 현) 마이크로소프트 공인 강사

  • 전) 마이크로소프트 데이터플랫폼 MVP

  • 전) 씨퀄로 수석 컨설턴트

  • 전) 웹타임교육센터 전임강사

  • 전) 푸르덴셜생명보험 정보시스템 책임

[강의분야]

  • 데이터베이스 개발자, 운영자 과정

  • 데이터베이스 쿼리 튜닝 및 최적화 과정

  • 파이썬, 데이터 전처리, 시각화 과정

  • 파이썬 기반 데이터 분석, 머신러닝 과정

[저서]

  • 디비로 누리는 특별한 세상, SQL Server 개발편

  • 디비로 누리는 특별한 세상, SQL Server 운영편

  • 이장래와 함께하는 SQL Server 운영과 개발 등

Curriculum

All

58 lectures ∙ (9hr 58min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

11 reviews

4.8

11 reviews

  • changjun157님의 프로필 이미지
    changjun157

    Reviews 3

    Average Rating 5.0

    5

    33% enrolled

    It's been about 2 hours now? I've listened to the lecture, and it's easy to listen to because it progresses step by step from the basics. There's no break in the flow while listening to the lecture, and I don't know if the code entry part is fast or if it's done at the speed, but it's done in an instant, so it's easy to continue the flow. There are simple quizzes in between, so you can write SQL yourself and use what you just learned, or there are quizzes that require you to learn later, and thanks to this, you can learn why you need to learn later, which is good.

    • daehoonbae9776님의 프로필 이미지
      daehoonbae9776

      Reviews 2

      Average Rating 5.0

      5

      60% enrolled

      • blue421144님의 프로필 이미지
        blue421144

        Reviews 4

        Average Rating 5.0

        5

        31% enrolled

        • yeonhongmin9780님의 프로필 이미지
          yeonhongmin9780

          Reviews 15

          Average Rating 4.7

          5

          67% enrolled

          The basics are well explained.

          • tmdgurl36987637님의 프로필 이미지
            tmdgurl36987637

            Reviews 1

            Average Rating 5.0

            5

            100% enrolled

            The weighting was appropriate for the level of importance, and the clear examples made it easy to understand. I was able to finish the course in two days. Thank you!

            Limited time deal

            $29.70

            22%

            $38.50

            jangrae's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!