장래쌤과 함께하는 쉽고 재미있는 파이썬 이야기
장래쌤
전문 강사에게서 배우는 쉽고 재미있는 파이썬 이야기! 처음 배우는 분들을 위해 차근차근 강의를 진행합니다. 충분히 반복하며 학습할 수 있는 기회를 제공합니다.처음 파이썬을 배우는 분들에게 든든한 디딤돌이 될 것입니다.
입문
Python, 객체지향
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.
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.
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
295
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
changjun157Reviews 3
∙
Average Rating 5.0
- 배대훈
Reviews 2
∙
Average Rating 5.0
- blue_42
Reviews 4
∙
Average Rating 5.0
- yeonhong.min
Reviews 15
∙
Average Rating 4.7
- 유승혁
Reviews 1
∙
Average Rating 5.0
$38.50
jangrae's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[SQL Quest] 실전 문제 풀이로 SQL 역량 강화 하기 (Basic)강의 썸네일](https://cdn.inflearn.com/public/courses/332155/cover/ddae2375-cd09-492e-8290-c7754172ee02/SQL)
![가장 쉽고 깊게 알려주는 MongoDB 완벽 가이드 [ By. 비전공자 & Kakao 개발자 ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/337578/cover/01jwt82r7jn3c9mzybfn00mdnh?f=avif&w=420)
![멀티 모듈 아키텍처로 구현하는 은행 서버 핵심 기능 [ Kotlin & Spring ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/337692/cover/01jx6h8k9xwd55qz59ta1vskrc?f=avif&w=420)
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![[2025] 비전공자도 한 번에 합격하는 SQLD 올인원강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)